getCustomViewCombo(); if(isset($_REQUEST['viewname']) == false || $_REQUEST['viewname']=='') { if($oCustomView->setdefaultviewid != "") { $viewid = $oCustomView->setdefaultviewid; }else { $viewid = "0"; } } $theme_path="themes/".$theme."/"; $image_path=$theme_path."images/"; //Retreive the list from Database //<<<<<<<<>>>>>>>> $date_var = date('Y-m-d'); $currentModule = 'Invoice'; $viewId = getCvIdOfAll($currentModule); $queryGenerator = new QueryGenerator($currentModule, $current_user); $queryGenerator->initForCustomViewById($viewId); $meta = $queryGenerator->getMeta($currentModule); $accessibleFieldNameList = array_keys($meta->getModuleFields()); $customViewFields = $queryGenerator->getCustomViewFields(); $fields = $queryGenerator->getFields(); $newFields = array_diff($fields, $customViewFields); $widgetFieldsList = array('subject','salesorder_id','account_id','contact_id','invoicestatus', 'total'); $widgetFieldsList = array_intersect($accessibleFieldNameList, $widgetFieldsList); $widgetSelectedFields = array_chunk(array_intersect($customViewFields, $widgetFieldsList), 2); //select the first chunk of two fields $widgetSelectedFields = $widgetSelectedFields[0]; if(count($widgetSelectedFields) < 2) { $widgetSelectedFields = array_chunk(array_merge($widgetSelectedFields, $accessibleFieldNameList), 2); //select the first chunk of two fields $widgetSelectedFields = $widgetSelectedFields[0]; } $newFields = array_merge($newFields, $widgetSelectedFields); $queryGenerator->setFields($newFields); $_REQUEST = getTopInvoiceSearch($_REQUEST); $queryGenerator->addUserSearchConditions($_REQUEST); $search_qry = '&query=true'.getSearchURL($_REQUEST); $query = $queryGenerator->getQuery(); //<<<<<<<>>>>>>>> $query .= " LIMIT " . $adb->sql_escape_string($maxval); if($calCnt == 'calculateCnt') { $list_result_rows = $adb->query(mkCountQuery($query)); return $adb->query_result($list_result_rows, 0, 'count'); } $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 = vtlib_purify($_REQUEST['start']); } else { $start = 1; } //Retreive the Navigation array $navigation_array = getNavigationValues($start, $noofrows, $list_max_entries_per_page); 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; } } $focus = new Invoice(); $title=array('myTopInvoices.gif',$current_module_strings['LBL_MY_TOP_INVOICE'],'home_mytopinv'); //Retreive the List View Table Header $controller = new ListViewController($adb, $current_user, $queryGenerator); $controller->setHeaderSorting(false); $header = $controller->getListViewHeader($focus,$currentModule,$url_string,$sorder, $order_by, true); $entries = $controller->getListViewEntries($focus,$currentModule,$list_result, $navigation_array, true); $values=Array('ModuleName'=>'Invoice','Title'=>$title,'Header'=>$header,'Entries'=>$entries,'search_qry'=>$search_qry); if ( ($noofrows == 0 ) || ($noofrows>0) ) return $values; } function getTopInvoiceSearch($output) { global $current_user; $output['query'] = 'true'; $output['searchtype'] = 'advance'; $advft_criteria_groups = array('1' => array('groupcondition' => null)); $advft_criteria = array( array ( 'groupid' => 1, 'columnname' => 'vtiger_invoice:invoicestatus:invoicestatus:Invoice_Status:V', 'comparator' => 'n', 'value' => 'Paid', 'columncondition' => 'and' ), array ( 'groupid' => 1, 'columnname' => 'vtiger_crmentity:smownerid:assigned_user_id:Invoice_Assigned_To:V', 'comparator' => 'e', 'value' => getFullNameFromArray('Users', $current_user->column_fields), 'columncondition' => null ) ); $output['advft_criteria'] = Zend_Json::encode($advft_criteria); $output['advft_criteria_groups'] = Zend_Json::encode($advft_criteria_groups); return $output; } ?>