155 lines
5.7 KiB
PHP
155 lines
5.7 KiB
PHP
<?php
|
|
/*+**********************************************************************************
|
|
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
|
|
* ("License"); You may not use this file except in compliance with the License
|
|
* The Original Code is: vtiger CRM Open Source
|
|
* The Initial Developer of the Original Code is vtiger.
|
|
* Portions created by vtiger are Copyright (C) vtiger.
|
|
* All Rights Reserved.
|
|
************************************************************************************/
|
|
global $app_strings, $mod_strings, $current_language, $currentModule, $theme;
|
|
global $list_max_entries_per_page;
|
|
|
|
require_once('Smarty_setup.php');
|
|
require_once('include/ListView/ListView.php');
|
|
require_once('modules/CustomView/CustomView.php');
|
|
require_once('include/DatabaseUtil.php');
|
|
require_once("modules/$currentModule/$currentModule.php");
|
|
|
|
$category = getParentTab();
|
|
$url_string = '';
|
|
|
|
$tool_buttons = Button_Check($currentModule);
|
|
$list_buttons = Array();
|
|
|
|
if(isPermitted($currentModule,'Delete','') == 'yes') $list_buttons['del'] = $app_strings[LBL_MASS_DELETE];
|
|
if(isPermitted($currentModule,'EditView','') == 'yes') {
|
|
$list_buttons['mass_edit'] = $app_strings[LBL_MASS_EDIT];
|
|
// Mass Edit could be used to change the owner as well!
|
|
//$list_buttons['c_owner'] = $app_strings[LBL_CHANGE_OWNER];
|
|
}
|
|
|
|
$focus = new $currentModule();
|
|
$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', true);
|
|
|
|
$smarty->assign('MOD', $mod_strings);
|
|
$smarty->assign('APP', $app_strings);
|
|
$smarty->assign('MODULE', $currentModule);
|
|
$smarty->assign('SINGLE_MOD', $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());
|
|
|
|
// Enabling Module Search
|
|
$url_string = '';
|
|
if($_REQUEST['query'] == 'true') {
|
|
list($where, $ustring) = split('#@@#', getWhereCondition($currentModule));
|
|
$url_string .= "&query=true$ustring";
|
|
$smarty->assign('SEARCH_URL', $url_string);
|
|
}
|
|
|
|
// Custom View
|
|
$customView = new CustomView($currentModule);
|
|
$viewid = $customView->getViewId($currentModule);
|
|
$customview_html = $customView->getCustomViewCombo($viewid);
|
|
$viewinfo = $customView->getCustomViewByCvid($viewid);
|
|
|
|
$smarty->assign("VIEWID", $viewid);
|
|
|
|
if($viewinfo['viewname'] == 'All') $smarty->assign('ALL', 'All');
|
|
|
|
if($viewid != '0') {
|
|
$listquery = getListQuery($currentModule);
|
|
$list_query= $customView->getModifiedCvListQuery($viewid, $listquery, $currentModule);
|
|
} else {
|
|
$list_query= getListQuery($currentModule);
|
|
}
|
|
|
|
if($where != '') {
|
|
$list_query = "$list_query AND $where";
|
|
}
|
|
|
|
// Sorting
|
|
if($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;
|
|
}
|
|
}
|
|
|
|
$countQuery = $adb->query( mkCountQuery($list_query) );
|
|
$recordCount= $adb->query_result($countQuery,0,'count');
|
|
|
|
// Set paging start value.
|
|
$start = 1;
|
|
if(isset($_REQUEST['start'])) { $start = $_REQUEST['start']; }
|
|
else { $start = $_SESSION['lvs'][$currentModule]['start']; }
|
|
// Total records is less than a page now.
|
|
if($recordCount <= $list_max_entries_per_page) $start = 1;
|
|
|
|
// Save in session
|
|
if(empty($start)) $start = 1; // Reset to proper state
|
|
$_SESSION['lvs'][$currentModule]['start'] = $start;
|
|
|
|
$navigation_array = getNavigationValues($start, $recordCount, $list_max_entries_per_page);
|
|
|
|
$start_rec = $navigation_array['start'];
|
|
$end_rec = $navigation_array['end_val'];
|
|
$_SESSION['nav_start']=$start_rec;
|
|
$_SESSION['nav_end']=$end_rec;
|
|
|
|
if ($start_rec ==0) $limit_start_rec = 0;
|
|
else $limit_start_rec = $start_rec -1;
|
|
|
|
$list_result = $adb->query( $list_query . " LIMIT $limit_start_rec, $list_max_entries_per_page" );
|
|
|
|
$record_string= $app_strings['LBL_SHOWING']." $start_rec - $end_rec " . $app_strings['LBL_LIST_OF'] ." ".$recordCount;
|
|
|
|
$smarty->assign('RECORD_COUNTS', $record_string);
|
|
$smarty->assign("CUSTOMVIEW_OPTION",$customview_html);
|
|
|
|
// Navigation
|
|
$start = $_SESSION['lvs'][$currentModule]['start'];
|
|
$navigation_array = getNavigationValues($start, $recordCount, $list_max_entries_per_page);
|
|
$navigationOutput = getTableHeaderNavigation($navigation_array, $url_string, $currentModule, 'index', $viewid);
|
|
$smarty->assign("NAVIGATION", $navigationOutput);
|
|
|
|
$listview_header = getListViewHeader($focus,$currentModule,$url_string,$sorder,$order_by,'',$customView);
|
|
$listview_entries = getListViewEntries($focus,$currentModule,$list_result,$navigation_array,'','','EditView','Delete',$customView);
|
|
$listview_header_search = getSearchListHeaderValues($focus,$currentModule,$url_string,$sorder,$order_by,'',$customView);
|
|
|
|
$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 = getAdvSearchfields($currentModule);
|
|
$criteria = getcriteria_options();
|
|
$smarty->assign("ALPHABETICAL", $alphabetical);
|
|
$smarty->assign("FIELDNAMES", $fieldnames);
|
|
$smarty->assign("CRITERIA", $criteria);
|
|
|
|
if(isset($_REQUEST['ajax']) && $_REQUEST['ajax'] != '')
|
|
$smarty->display("ListViewEntries.tpl");
|
|
else
|
|
$smarty->display('ListView.tpl');
|
|
|
|
?>
|