initSortbyField($currentModule); $list_buttons=$focus->getListButtons($app_strings,$mod_strings); if(ListViewSession::hasViewChanged($currentModule,$viewid)) { $_SESSION[$currentModule."_Order_By"] = ''; } $sorder = $focus->getSortOrder(); $order_by = $focus->getOrderBy(); $_SESSION[$currentModule."_Order_By"] = $order_by; $_SESSION[$currentModule."_Sort_Order"]=$sorder; $smarty = new vtigerCRM_Smarty(); // Identify this module as custom module. $smarty->assign('CUSTOM_MODULE', $focus->IsCustomModule); $smarty->assign('MAX_RECORDS', $list_max_entries_per_page); $smarty->assign('MOD', $mod_strings); $smarty->assign('APP', $app_strings); $smarty->assign('MODULE', $currentModule); $smarty->assign('SINGLE_MOD', getTranslatedString('SINGLE_'.$currentModule)); $smarty->assign('CATEGORY', $category); $smarty->assign('BUTTONS', $list_buttons); $smarty->assign('CHECK', $tool_buttons); $smarty->assign('THEME', $theme); $smarty->assign('IMAGE_PATH', "themes/$theme/images/"); $smarty->assign('CHANGE_OWNER', getUserslist()); $smarty->assign('CHANGE_GROUP_OWNER', getGroupslist()); // Custom View $customView = new CustomView($currentModule); $viewid = $customView->getViewId($currentModule); $customview_html = $customView->getCustomViewCombo($viewid); $viewinfo = $customView->getCustomViewByCvid($viewid); // Feature available from 5.1 if(method_exists($customView, 'isPermittedChangeStatus')) { // Approving or Denying status-public by the admin in CustomView $statusdetails = $customView->isPermittedChangeStatus($viewinfo['status']); // To check if a user is able to edit/delete a CustomView $edit_permit = $customView->isPermittedCustomView($viewid,'EditView',$currentModule); $delete_permit = $customView->isPermittedCustomView($viewid,'Delete',$currentModule); $smarty->assign("CUSTOMVIEW_PERMISSION",$statusdetails); $smarty->assign("CV_EDIT_PERMIT",$edit_permit); $smarty->assign("CV_DELETE_PERMIT",$delete_permit); } // END $smarty->assign("VIEWID", $viewid); if($viewinfo['viewname'] == 'All') $smarty->assign('ALL', 'All'); if($viewid ==0) { echo "

"; echo "

	$app_strings[LBL_PERMISSION]
	$app_strings[LBL_GO_BACK]

"; echo "

"; exit; } global $current_user; $queryGenerator = new QueryGenerator($currentModule, $current_user); if ($viewid != "0") { $queryGenerator->initForCustomViewById($viewid); } else { $queryGenerator->initForDefaultCustomView(); } // Enabling Module Search $url_string = ''; if($_REQUEST['query'] == 'true') { $queryGenerator->addUserSearchConditions($_REQUEST); $ustring = getSearchURL($_REQUEST); $url_string .= "&query=true$ustring"; $smarty->assign('SEARCH_URL', $url_string); } $list_query = $queryGenerator->getQuery(); $where = $queryGenerator->getConditionalWhere(); if(isset($where) && $where != '') { $_SESSION['export_where'] = $where; } else { unset($_SESSION['export_where']); } // Sorting if(!empty($order_by)) { if($order_by == 'smownerid') $list_query .= ' ORDER BY user_name '.$sorder; else { $tablename = getTableNameForField($currentModule, $order_by); $tablename = ($tablename != '')? ($tablename . '.') : ''; $list_query .= ' ORDER BY ' . $tablename . $order_by . ' ' . $sorder; } } //Postgres 8 fixes if( $adb->dbType == "pgsql") $list_query = fixPostgresQuery( $list_query, $log, 0); if(PerformancePrefs::getBoolean('LISTVIEW_COMPUTE_PAGE_COUNT', false) === true) { $count_result = $adb->query( mkCountQuery( $list_query)); $noofrows = $adb->query_result($count_result,0,"count"); }else { $noofrows = null; } $queryMode = (isset($_REQUEST['query']) && $_REQUEST['query'] == 'true'); $start = ListViewSession::getRequestCurrentPage($currentModule, $list_query, $viewid, $queryMode); $navigation_array = VT_getSimpleNavigationValues($start,$list_max_entries_per_page,$noofrows); $limit_start_rec = ($start-1) * $list_max_entries_per_page; if( $adb->dbType == "pgsql") $list_result = $adb->pquery($list_query. " OFFSET $limit_start_rec LIMIT $list_max_entries_per_page", array()); else $list_result = $adb->pquery($list_query. " LIMIT $limit_start_rec, $list_max_entries_per_page", array()); $recordListRangeMsg = getRecordRangeMessage($list_result, $limit_start_rec,$noofrows); $smarty->assign('recordListRange',$recordListRangeMsg); $smarty->assign("CUSTOMVIEW_OPTION",$customview_html); // Navigation $navigationOutput = getTableHeaderSimpleNavigation($navigation_array, $url_string, $currentModule, 'index', $viewid); $smarty->assign("NAVIGATION", $navigationOutput); $controller = new ListViewController($adb, $current_user, $queryGenerator); if(isset($skipAction)==false){ $skipAction==false; } $listview_header = $controller->getListViewHeader($focus,$currentModule,$url_string,$sorder,$order_by,$skipAction); $listview_entries = $controller->getListViewEntries($focus,$currentModule,$list_result,$navigation_array,$skipAction); $listview_header_search = $controller->getBasicSearchFieldInfoList(); $smarty->assign('LISTHEADER', $listview_header); $smarty->assign('LISTENTITY', $listview_entries); $smarty->assign('SEARCHLISTHEADER',$listview_header_search); // Module Search $alphabetical = AlphabeticalSearch($currentModule,'index',$focus->def_basicsearch_col,'true','basic','','','','',$viewid); $fieldnames = $controller->getAdvancedSearchOptionString(); $criteria = getcriteria_options(); $smarty->assign("ALPHABETICAL", $alphabetical); $smarty->assign("FIELDNAMES", $fieldnames); $smarty->assign("CRITERIA", $criteria); $smarty->assign("AVALABLE_FIELDS", getMergeFields($currentModule,"available_fields")); $smarty->assign("FIELDS_TO_MERGE", getMergeFields($currentModule,"fileds_to_merge")); //Added to select Multiple records in multiple pages $smarty->assign("SELECTEDIDS", vtlib_purify($_REQUEST['selobjs'])); $smarty->assign("ALLSELECTEDIDS", vtlib_purify($_REQUEST['allselobjs'])); $smarty->assign("CURRENT_PAGE_BOXES", implode(array_keys($listview_entries),";")); ListViewSession::setSessionQuery($currentModule,$list_query,$viewid); // Gather the custom link information to display include_once('vtlib/Vtiger/Link.php'); $customlink_params = Array('MODULE'=>$currentModule, 'ACTION'=>vtlib_purify($_REQUEST['action']), 'CATEGORY'=> $category); $smarty->assign('CUSTOM_LINKS', Vtiger_Link::getAllByType(getTabid($currentModule), Array('LISTVIEWBASIC','LISTVIEW'), $customlink_params)); // END if(isPermitted($currentModule, "Merge") == 'yes' && file_exists("modules/$currentModule/Merge.php")) { $wordTemplates = array(); $wordTemplateResult = fetchWordTemplateList($currentModule); $tempCount = $adb->num_rows($wordTemplateResult); $tempVal = $adb->fetch_array($wordTemplateResult); for ($templateCount = 0; $templateCount < $tempCount; $templateCount++) { $wordTemplates[$tempVal["templateid"]] = $tempVal["filename"]; $tempVal = $adb->fetch_array($wordTemplateResult); } $smarty->assign('WORDTEMPLATES', $wordTemplates); } $smarty->assign('IS_ADMIN', is_admin($current_user)); if(isset($_REQUEST['ajax']) && $_REQUEST['ajax'] != '') $smarty->display("ListViewEntries.tpl"); else $smarty->display('ListView.tpl'); ?>