id.".php"); $smarty = new vtigerCRM_Smarty; // Data from the below modules will not be allowed to restore $skip_modules = array('Webmails'); $skip_tab_ids = array(); for($i=0; $i 0) { $sql .= ' AND tabid NOT IN ('. generateQuestionMarks($skip_tab_ids) .')'; } $sql .= ' ORDER BY name'; $result =$adb->pquery($sql, array($skip_tab_ids)); $noofrows = $adb->num_rows($result); $module_name =Array(); $module_data =Array(); if($noofrows > 0) { for($x=0,$y=0; $x<$noofrows;$x++) { $tabid = $adb->query_result($result,$x,'tabid'); if($is_admin || $profileGlobalPermission[2]==0 || $profileGlobalPermission[1]==0 || $profileTabsPermission[$tabid]==0) { $mod_name = $adb->query_result($result,$x,"name"); $module_name[$y] = $mod_name; $y++; } } } if(isset($_REQUEST['selected_module']) && $_REQUEST['selected_module'] != '') { $select_module = vtlib_purify($_REQUEST['selected_module']); if (!in_array($select_module, $module_name)) { show_error_msg(); } } else { if (count($module_name) > 0) { $select_module = $module_name[0]; } else { show_error_msg('no_permitted_modules'); } } $focus = CRMEntity::getInstance($select_module); if(count($module_name) > 0) { $cur_mod_view = new CustomView($select_module); $viewid = $cur_mod_view->getViewIdByName('All', $select_module); global $current_user; $queryGenerator = new QueryGenerator($select_module, $current_user); $queryGenerator->initForCustomViewById($viewid); // 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(); $list_query = preg_replace("/vtiger_crmentity.deleted\s*=\s*0/i", 'vtiger_crmentity.deleted = 1', $list_query); //Search criteria added to the list Query if(isset($where) && $where != '') { $list_query .= ' AND '.$where; } $count_result = $adb->query( mkCountQuery($list_query)); $noofrows = $adb->query_result($count_result,0,"count"); $smarty->assign("NUMOFROWS", $noofrows); $controller = new ListViewController($adb, $current_user, $queryGenerator); $rb_listview_header = $controller->getListViewHeader($focus,$select_module,$url_string,$sorder, $order_by, true); $listview_header_search = $controller->getBasicSearchFieldInfoList(); $smarty->assign("SEARCHLISTHEADER", $listview_header_search); if(isset($_REQUEST['start']) && $_REQUEST['start'] != '') $start = vtlib_purify($_REQUEST['start']); else $start = 1; $navigation_array = getNavigationValues($start, $noofrows, $list_max_entries_per_page); // Setting the record count string //modified by rdhital $start_rec = $navigation_array['start']; $end_rec = $navigation_array['end_val']; //By Raju Ends //limiting the query if ($start_rec ==0) $limit_start_rec = 0; else $limit_start_rec = $start_rec -1; if( $adb->dbType == "pgsql") $list_result = $adb->query($list_query. " OFFSET ".$limit_start_rec." LIMIT ".$list_max_entries_per_page); else $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] ." ".$noofrows; $navigationOutput = getTableHeaderNavigation($navigation_array, $url_string,"Recyclebin","index",""); $lvEntries = $controller->getListViewEntries($focus,$select_module,$list_result, $navigation_array, true); } $smarty->assign("NAVIGATION", $navigationOutput); $smarty->assign("RECORD_COUNTS", $record_string); $smarty->assign('MAX_RECORDS', $list_max_entries_per_page); //to get the field name that mentions the module $query = "SELECT fieldname,tablename FROM vtiger_entityname WHERE modulename =?"; $queryResult = $adb->pquery($query, array($select_module)); $moduleColumnName = $adb->query_result($queryResult,0,'fieldname'); $moduleTableName = $adb->query_result($queryResult,0,'tablename'); if(strpos($moduleColumnName,',')) { $field_array = explode(',',$moduleColumnName); $moduleColumnName = $field_array[0]; } $query = "SELECT fieldname FROM vtiger_field WHERE tablename=? and columnname=?"; $moduleFieldName = $adb->query_result($adb->pquery($query, array($moduleTableName,$moduleColumnName)),0,'fieldname'); $indexField = $moduleFieldName; $alphabetical = AlphabeticalSearch($currentModule,'index',$indexField,'true','basic',"","","","",$viewid); $category = getParentTab();; $check_button = Button_Check($_REQUEST['module']); $check_button['EditView'] = 'no'; $smarty->assign("CHECK", $check_button); $smarty->assign("ALPHABETICAL", $alphabetical); $smarty->assign("NUMBER_MODULES",$noofrows); $smarty->assign("MODULE_NAME",$module_name); $smarty->assign("SELECTED_MODULE",$select_module); $smarty->assign("MODULE_DATA",$rb_listview_header); $smarty->assign("MOD", $mod_strings); $smarty->assign("MODULE",$currentModule); $smarty->assign("CATEGORY",$category); $smarty->assign("THEME",$theme); $smarty->assign("IMAGE_PATH",$image_path); $smarty->assign("APP", $app_strings); $smarty->assign("CMOD", return_module_language($current_language,$select_module)); $smarty->assign("lvEntries", $lvEntries); $smarty->assign("ALLSELECTEDIDS", vtlib_purify($_REQUEST['allselobjs'])); $smarty->assign("CURRENT_PAGE_BOXES", implode(array_keys($lvEntries),";")); $smarty->assign("IS_ADMIN", $is_admin); if($_REQUEST['mode'] != 'ajax') { $smarty->display(vtlib_getModuleTemplate($currentModule,'RecycleBin.tpl')); } else { $smarty->display(vtlib_getModuleTemplate($currentModule,'RecycleBinContents.tpl')); } function show_error_msg($error_type='permission_denied') { global $theme; if ($error_type == 'permission_denied') { echo ""; echo "
"; echo "
" . getTranslatedString('LBL_PERMISSION') . "
" . getTranslatedString('LBL_GO_BACK') . "
"; echo "
"; die(); } else if ($error_type == 'no_permitted_modules') { echo ""; echo "
"; echo "
" . getTranslatedString('LBL_NO_PERMITTED_MODULES') . "
"; echo "
"; die(); } } ?>