'quotestage_dom'); $comboFieldArray = getComboArray($comboFieldNames); $popuptype = ''; $popuptype = $_REQUEST["popuptype"]; echo get_module_title("Quotes", "Quotes" , true); echo "
"; // focus_list is the means of passing data to a ListView. global $focus_list; if (!isset($where)) $where = ""; if (isset($_REQUEST['order_by'])) $order_by = $_REQUEST['order_by']; $url_string = ''; $sorder = 'ASC'; if(isset($_REQUEST['sorder']) && $_REQUEST['sorder'] != '') $sorder = $_REQUEST['sorder']; if($popuptype!='') $url_string .= "&popuptype=".$popuptype; $seedAccount = new Quote(); if(isset($_REQUEST['query']) && $_REQUEST['query'] == 'true') { // we have a query $url_string .="&query=true"; if (isset($_REQUEST['subject'])) $subject = $_REQUEST['subject']; if (isset($_REQUEST['potentialname'])) $potentialname = $_REQUEST['potentialname']; if (isset($_REQUEST['quotestage'])) $quotestage = $_REQUEST['quotestage']; if (isset($_REQUEST['accountname'])) $accountname = $_REQUEST['accountname']; $where_clauses = Array(); //Added for Custom Field Search $sql="select * from field where tablename='quotescf' order by fieldlabel"; $result=$adb->query($sql); for($i=0;$i<$adb->num_rows($result);$i++) { $column[$i]=$adb->query_result($result,$i,'columnname'); $fieldlabel[$i]=$adb->query_result($result,$i,'fieldlabel'); $uitype[$i]=$adb->query_result($result,$i,'uitype'); if (isset($_REQUEST[$column[$i]])) $customfield[$i] = $_REQUEST[$column[$i]]; if(isset($customfield[$i]) && $customfield[$i] != '') { if($uitype[$i] == 56) $str=" quotescf.".$column[$i]." = 1"; else $str=" quotescf.".$column[$i]." like '$customfield[$i]%'"; array_push($where_clauses, $str); $url_string .="&".$column[$i]."=".$customfield[$i]; } } //upto this added for Custom Field if(isset($subject) && $subject != "") { array_push($where_clauses, "quotes.subject like ".PearDatabase::quote($subject."%")); $url_string .= "&subject=".$subject; } if(isset($accountname) && $accountname != "") { array_push($where_clauses, "account.accountname like ".PearDatabase::quote("%".$accountname."%")); $url_string .= "&accountname=".$accountname; } if(isset($quotestage) && $quotestage != "") { array_push($where_clauses, "quotes.quotestage like ".PearDatabase::quote("%".$quotestage."%")); $url_string .= ""estage=".$quotestage; } $where = ""; foreach($where_clauses as $clause) { if($where != "") $where .= " and "; $where .= $clause; } if (!empty($assigned_user_id)) { if (!empty($where)) { $where .= " AND "; } $where .= "crmentity.smownerid IN("; foreach ($assigned_user_id as $key => $val) { $where .= PearDatabase::quote($val); $where .= ($key == count($assigned_user_id) - 1) ? ")" : ", "; } } $log->info("Here is the where clause for the list view: $where"); } if (!isset($_REQUEST['search_form']) || $_REQUEST['search_form'] != 'false') { // Stick the form header out there. $search_form=new XTemplate ('modules/Quotes/PopupSearchForm.html'); $search_form->assign("MOD", $current_module_strings); $search_form->assign("APP", $app_strings); $search_form->assign("POPUPTYPE",$popuptype); if ($order_by !='') $search_form->assign("ORDER_BY", $order_by); if ($sorder !='') $search_form->assign("SORDER", $sorder); $search_form->assign("VIEWID",$viewid); $search_form->assign("JAVASCRIPT", get_clear_form_js()); if($order_by != '') { $ordby = "&order_by=".$order_by; } else { $ordby =''; } $search_form->assign("BASIC_LINK", "index.php?module=Quotes".$ordby."&action=index".$url_string."&sorder=".$sorder."&viewname=".$viewid); $search_form->assign("ADVANCE_LINK", "index.php?module=Quotes&action=index".$ordby."&advanced=true".$url_string."&sorder=".$sorder."&viewname=".$viewid); $search_form->assign("JAVASCRIPT", get_clear_form_js()); if (isset($subject)) $search_form->assign("SUBJECT", $subject); if (isset($accountname)) $search_form->assign("ACCOUNTNAME", $accountname); if (isset($quotestage)) $search_form->assign("QUOTESTAGE", get_select_options($comboFieldArray['quotestage_dom'], $quotestage, $advsearch)); else $search_form->assign("QUOTESTAGE", get_select_options($comboFieldArray['quotestage_dom'], '', $advsearch)); echo get_form_header($current_module_strings['LBL_SEARCH_FORM_TITLE'], '', false); if (isset($_REQUEST['advanced']) && $_REQUEST['advanced'] == 'true') { $url_string .="&advanced=true"; $search_form->assign("ALPHABETICAL",AlphabeticalSearch('Quotes','Popup','subject','true','advanced',$popuptype,"","","",$viewid)); //Added for Custom Field Search $sql="select * from field where tablename='quotescf' order by fieldlabel"; $result=$adb->query($sql); for($i=0;$i<$adb->num_rows($result);$i++) { $column[$i]=$adb->query_result($result,$i,'columnname'); $fieldlabel[$i]=$adb->query_result($result,$i,'fieldlabel'); if (isset($_REQUEST[$column[$i]])) $customfield[$i] = $_REQUEST[$column[$i]]; } require_once('include/CustomFieldUtil.php'); $custfld = CustomFieldSearch($customfield, "quotescf", "quotescf", "quoteid", $app_strings,$theme,$column,$fieldlabel); $search_form->assign("CUSTOMFIELD", $custfld); //upto this added for Custom Field $search_form->parse("advanced"); $search_form->out("advanced"); } else { $search_form->assign("ALPHABETICAL",AlphabeticalSearch('Quotes','Popup','subject','true','basic',$popuptype,"","","",$viewid)); $search_form->parse("main"); $search_form->out("main"); } echo get_form_footer(); echo "\n
\n"; } $focus = new Quote(); echo get_form_header($current_module_strings['LBL_LIST_FORM_TITLE'],'', false); $xtpl=new XTemplate ('modules/Quotes/Popup.html'); global $theme; $theme_path="themes/".$theme."/"; $image_path=$theme_path."images/"; $xtpl->assign("MOD", $mod_strings); $xtpl->assign("APP", $app_strings); $xtpl->assign("IMAGE_PATH",$image_path); $xtpl->assign("THEME_PATH",$theme_path); //Retreive the list from Database $query = getListQuery("Quotes"); if(isset($where) && $where != '') { $query .= ' and '.$where; } if(isset($order_by) && $order_by != '') { $query .= ' ORDER BY '.$order_by.' '.$sorder; } $list_result = $adb->query($query); //Retreiving the no of rows $noofrows = $adb->num_rows($list_result); //Retreiving the start value from request if(isset($_REQUEST['start']) && $_REQUEST['start'] != '') { $start = $_REQUEST['start']; } else { $start = 1; } //Retreive the Navigation array $navigation_array = getNavigationValues($start, $noofrows, $list_max_entries_per_page); // Setting the record count string if ($navigation_array['start'] == 1) { if($noofrows != 0) $start_rec = $navigation_array['start']; else $start_rec = 0; if($noofrows > $list_max_entries_per_page) { $end_rec = $navigation_array['start'] + $list_max_entries_per_page - 1; } else { $end_rec = $noofrows; } } else { if($navigation_array['next'] > $list_max_entries_per_page) { $start_rec = $navigation_array['next'] - $list_max_entries_per_page; $end_rec = $navigation_array['next'] - 1; } else { $start_rec = $navigation_array['prev'] + $list_max_entries_per_page; $end_rec = $noofrows; } } $record_string= $app_strings[LBL_SHOWING]." " .$start_rec." - ".$end_rec." " .$app_strings[LBL_LIST_OF] ." ".$noofrows; //Retreive the List View Table Header $focus->list_mode="search"; $focus->popup_type=$popuptype; $listview_header = getSearchListViewHeader($focus,"Quotes",$url_string,$sorder,$order_by); $xtpl->assign("LISTHEADER", $listview_header); $listview_entries = getSearchListViewEntries($focus,"Quotes",$list_result,$navigation_array); $xtpl->assign("LISTENTITY", $listview_entries); if($order_by !='') $url_string .="&order_by=".$order_by; if($sorder !='') $url_string .="&sorder=".$sorder; $navigationOutput = getTableHeaderNavigation($navigation_array, $url_string,"Quotes","Popup"); $xtpl->assign("NAVIGATION", $navigationOutput); $xtpl->assign("RECORD_COUNTS", $record_string); $xtpl->parse("main"); $xtpl->out("main"); ?>