/trunk/rucrm/modules/Faq/ListView.php
PHP | 270 lines | 201 code | 43 blank | 26 comment | 46 complexity | a598264f4e22bf5fdcae3767bd3c6e3e MD5 | raw file
Possible License(s): LGPL-2.1, MPL-2.0-no-copyleft-exception, GPL-2.0, LGPL-3.0
- <?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 $theme;
- $theme_path="themes/".$theme."/";
- $image_path=$theme_path."images/";
- global $mod_strings;
- require_once('modules/Faq/Faq.php');
- require_once('Smarty_setup.php');
- require_once('include/utils/utils.php');
- require_once('include/ListView/ListView.php');
- require_once('modules/Faq/Faq.php');
- require_once('modules/CustomView/CustomView.php');
- require_once('include/database/Postgres8.php');
- global $app_strings,$theme;
- $current_module_strings = return_module_language($current_language, 'Faq');
- global $currentModule, $adb;
- require_once($theme_path.'layout_utils.php');
- if(isset($_REQUEST['category']) && $_REQUEST['category'] !='')
- {
- $category = vtlib_purify($_REQUEST['category']);
- }
- else
- {
- $category = getParentTabFromModule($currentModule);
- }
- $focus = new Faq();
- // Initialize sort by fields
- $focus->initSortbyField('Faq');
- // END
- $smarty = new vtigerCRM_Smarty;
- $other_text = Array();
- if(!$_SESSION['lvs'][$currentModule])
- {
- unset($_SESSION['lvs']);
- $modObj = new ListViewSession();
- $modObj->sorder = $sorder;
- $modObj->sortby = $order_by;
- $_SESSION['lvs'][$currentModule] = get_object_vars($modObj);
- }
- if($_REQUEST['errormsg'] != '')
- {
- $errormsg = vtlib_purify($_REQUEST['errormsg']);
- $smarty->assign("ERROR","The User does not have permission to delete ".$errormsg." ".$currentModule);
- }else
- {
- $smarty->assign("ERROR","");
- }
- $url_string = '';
- //<<<<cutomview>>>>>>>
- $oCustomView = new CustomView("Faq");
- $viewid = $oCustomView->getViewId($currentModule);
- $customviewcombo_html = $oCustomView->getCustomViewCombo($viewid);
- $viewnamedesc = $oCustomView->getCustomViewByCvid($viewid);
- //Added to handle approving or denying status-public by the admin in CustomView
- $statusdetails = $oCustomView->isPermittedChangeStatus($viewnamedesc['status']);
- $smarty->assign("CUSTOMVIEW_PERMISSION",$statusdetails);
- //To check if a user is able to edit/delete a customview
- $edit_permit = $oCustomView->isPermittedCustomView($viewid,'EditView',$currentModule);
- $delete_permit = $oCustomView->isPermittedCustomView($viewid,'Delete',$currentModule);
- $smarty->assign("CV_EDIT_PERMIT",$edit_permit);
- $smarty->assign("CV_DELETE_PERMIT",$delete_permit);
- //<<<<<customview>>>>>
- if(ListViewSession::hasViewChanged($currentModule,$viewid)) {
- $_SESSION['FAQ_ORDER_BY'] = '';
- }
- //<<<<<<<<<<<<<<<<<<< sorting - stored in session >>>>>>>>>>>>>>>>>>>>
- if($_REQUEST['order_by'] != '')
- $order_by = $adb->sql_escape_string($_REQUEST['order_by']);
- else
- $order_by = (($_SESSION['FAQ_ORDER_BY'] != '')?($_SESSION['FAQ_ORDER_BY']):($focus->default_order_by));
- if($_REQUEST['sorder'] != '')
- $sorder = $adb->sql_escape_string($_REQUEST['sorder']);
- else
- $sorder = (($_SESSION['FAQ_SORT_ORDER'] != '')?($_SESSION['FAQ_SORT_ORDER']):($focus->default_sort_order));
- $_SESSION['FAQ_ORDER_BY'] = $order_by;
- $_SESSION['FAQ_SORT_ORDER'] = $sorder;
- //<<<<<<<<<<<<<<<<<<< sorting - stored in session >>>>>>>>>>>>>>>>>>>>
- if($viewid != 0)
- {
- $CActionDtls = $oCustomView->getCustomActionDetails($viewid);
- }
- elseif($viewid ==0)
- {
- echo "<table border='0' cellpadding='5' cellspacing='0' width='100%' height='450px'><tr><td align='center'>";
- echo "<div style='border: 3px solid rgb(153, 153, 153); background-color: rgb(255, 255, 255); width: 55%; position: relative; z-index: 10000000;'>
- <table border='0' cellpadding='5' cellspacing='0' width='98%'>
- <tbody><tr>
- <td rowspan='2' width='11%'><img src='". vtiger_imageurl('denied.gif', $theme)."' ></td>
- <td style='border-bottom: 1px solid rgb(204, 204, 204);' nowrap='nowrap' width='70%'><span clas
- s='genHeaderSmall'>$app_strings[LBL_PERMISSION]</span></td>
- </tr>
- <tr>
- <td class='small' align='right' nowrap='nowrap'>
- <a href='javascript:window.history.back();'>$app_strings[LBL_GO_BACK]</a><br>
- </td>
- </tr>
- </tbody></table>
- </div>";
- echo "</td></tr></table>";
- exit;
- }
- if(isPermitted('Faq','Delete','') == 'yes')
- $other_text ['del'] = $app_strings[LBL_MASS_DELETE];
- //Retreive the list from Database
- //Retreive the list from Database
- //<<<<<<<<<customview>>>>>>>>>
- global $current_user;
- $queryGenerator = new QueryGenerator($currentModule, $current_user);
- if ($viewid != "0") {
- $queryGenerator->initForCustomViewById($viewid);
- } else {
- $queryGenerator->initForDefaultCustomView();
- }
- if(isset($_REQUEST['query']) && $_REQUEST['query'] == 'true')
- {
- $queryGenerator->addUserSearchConditions($_REQUEST);
- $ustring = getSearchURL($_REQUEST);
- // we have a query
- $url_string .="&query=true".$ustring;
- $smarty->assign("SEARCH_URL",$url_string);
- }
- $list_query = $queryGenerator->getQuery();
- $view_script = "<script language='javascript'>
- function set_selected()
- {
- len=document.massdelete.viewname.length;
- for(i=0;i<len;i++)
- {
- if(document.massdelete.viewname[i].value == '$viewid')
- document.massdelete.viewname[i].selected = true;
- }
- }
- set_selected();
- </script>";
- if(isset($order_by) && $order_by != '')
- {
- $tablename = getTableNameForField('Faq',$order_by);
- $tablename = (($tablename != '')?($tablename."."):'');
- if( $adb->dbType == "pgsql")
- $list_query .= ' GROUP BY '.$tablename.$order_by;
-
- $list_query .= ' ORDER BY '.$tablename.$order_by.' '.$sorder;
- }
- //Constructing the list view
- $smarty->assign("MOD", $mod_strings);
- $smarty->assign("APP", $app_strings);
- $smarty->assign("THEME", $theme);
- $smarty->assign("IMAGE_PATH",$image_path);
- $smarty->assign("MODULE",$currentModule);
- $smarty->assign("BUTTONS",$other_text);
- $smarty->assign("CATEGORY",$category);
- $smarty->assign("SINGLE_MOD",'Document');
- if($viewnamedesc['viewname'] == 'All')
- {
- $smarty->assign("ALL", 'All');
- }
- //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);
- if($viewid !='')
- $url_string .= "&viewname=".$viewid;
- //Retreive the List View Table Header
- $controller = new ListViewController($adb, $current_user, $queryGenerator);
- $listview_header = $controller->getListViewHeader($focus,$currentModule,$url_string,$sorder,
- $order_by);
- $smarty->assign("LISTHEADER", $listview_header);
- $listview_header_search = $controller->getBasicSearchFieldInfoList();
- $smarty->assign("SEARCHLISTHEADER",$listview_header_search);
- $listview_entries = $controller->getListViewEntries($focus,$currentModule,$list_result,
- $navigation_array);
- $smarty->assign("LISTHEADER", $listview_header);
- $smarty->assign("LISTENTITY", $listview_entries);
- $smarty->assign("SELECT_SCRIPT", $view_script);
- //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),";"));
- $navigationOutput = getTableHeaderSimpleNavigation($navigation_array, $url_string,"Faq","index",$viewid);
- $alphabetical = AlphabeticalSearch($currentModule,'index','question','true','basic',"","","","",$viewid);
- $fieldnames = $controller->getAdvancedSearchOptionString();
- $criteria = getcriteria_options();
- $smarty->assign("CRITERIA", $criteria);
- $smarty->assign("FIELDNAMES", $fieldnames);
- $smarty->assign("ALPHABETICAL", $alphabetical);
- $smarty->assign("NAVIGATION", $navigationOutput);
- $smarty->assign("CUSTOMVIEW_OPTION",$customviewcombo_html);
- $smarty->assign("VIEWID", $viewid);
- $smarty->assign("SINGLE_MOD" ,'Faq');
- if(isPermitted('Faq','EditView','') == 'yes') {
- $other_text['mass_edit'] = $app_strings[LBL_MASS_EDIT];
- }
- $smarty->assign("BUTTONS",$other_text);
- $check_button = Button_Check($module);
- $smarty->assign("CHECK", $check_button);
- 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(isset($_REQUEST['ajax']) && $_REQUEST['ajax'] != '')
- $smarty->display("ListViewEntries.tpl");
- else
- $smarty->display("ListView.tpl");
- ?>