$_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 Change/Delete " . $errormsg . " " . $currentModule); } else { $smarty->assign("ERROR", ""); } //<<<<<<<<<<<<<<<<<<< sorting - stored in session >>>>>>>>>>>>>>>>>>>> $sorder = $focus->getSortOrder(); $order_by = $focus->getOrderBy(); $_SESSION['SALESORDER_ORDER_BY'] = $order_by; $_SESSION['SALESORDER_SORT_ORDER'] = $sorder; //<<<<<<<<<<<<<<<<<<< sorting - stored in session >>>>>>>>>>>>>>>>>>>> if (isset($_REQUEST['query']) && $_REQUEST['query'] != '' && $_REQUEST['query'] == 'true') { list($where, $ustring) = split("#@@#", getWhereCondition($currentModule)); // we have a query $url_string .= "&query=true" . $ustring; $log->info("Here is the where clause for the list view: {$where}"); $smarty->assign("SEARCH_URL", $url_string); } //<<<<cutomview>>>>>>> $oCustomView = new CustomView("SalesOrder"); $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);
} $where_relquery = getRelCheckquery($currentModule, $return_module, $recordid); //if((!isset($is_disable_approve) || (isset($is_disable_approve) && !$is_disable_approve)) && (isset($module_enable_approve) && $module_enable_approve)) { // $where_relquery .= ' AND ec_crmentity.approved=1 '; //} if (empty($query)) { $query = $focus->getListQuery($where_relquery, true); //viewscope = all_to_me } //customview begin if ($viewid != "0") { $query = $oCustomView->getModifiedCvListQuery($viewid, $query, $currentModule, true); } //customview end if (isset($_REQUEST['query']) && $_REQUEST['query'] == 'true') { list($where, $ustring) = explode("#@@#", getWhereCondition($currentModule)); $url_string .= "&query=true" . $ustring; } if (isset($where) && $where != '') { $query .= ' and ' . $where; } $upperModule = strtoupper($currentModule); if (isset($_REQUEST['order_by']) && $_REQUEST['order_by'] != '') { $order_by = $_REQUEST['order_by']; } else { $order_by = $_SESSION[$upperModule . '_ORDER_BY'] != '' ? $_SESSION[$upperModule . '_ORDER_BY'] : "modifiedtime"; } if (isset($_REQUEST['sorder']) && $_REQUEST['sorder'] != '') { $sorder = $_REQUEST['sorder']; } else { $sorder = $_SESSION[$upperModule . '_SORT_ORDER'] != '' ? $_SESSION[$upperModule . '_SORT_ORDER'] : 'DESC';
echo "<div style='border: 3px solid rgb(153, 153, 153); background-color: rgb(255, 255, 255); width: 55%; position: relative; z-index: 10000000;'>\n\t\t<table border='0' cellpadding='5' cellspacing='0' width='98%'>\n\t\t<tbody><tr>\n\t\t<td rowspan='2' width='11%'><img src='" . vtiger_imageurl('close.gif', $theme) . "'></td>\n\t\t<td style='border-bottom: 1px solid rgb(204, 204, 204);' nowrap='nowrap' width='70%'>\n\t\t\t<span class='genHeaderSmall'>" . $app_strings['LBL_PERMISSION'] . "</span></td>\n\t\t</tr>\n\t\t<tr>\n\t\t<td class='small' align='right' nowrap='nowrap'>\n\t\t<a href='javascript:window.history.back();'>" . $app_strings['LBL_GO_BACK'] . "</a><br>\n\t\t</td>\n\t\t</tr>\n\t\t</tbody></table>\n\t\t</div>\n\t\t</td></tr></table>"; exit; } $changeOwner = getAssignedTo(16); $userList = $changeOwner[0]; $groupList = $changeOwner[1]; $smarty->assign("CHANGE_USER", $userList); $smarty->assign("CHANGE_GROUP", $groupList); $smarty->assign("CHANGE_OWNER", getUserslist()); $smarty->assign("CHANGE_GROUP_OWNER", getGroupslist()); $smarty->assign('MAX_RECORDS', $list_max_entries_per_page); $where = ""; $url_string = ''; // assigning http url string if (isset($_REQUEST['query']) && $_REQUEST['query'] == 'true') { list($where, $ustring) = explode("#@@#", getWhereCondition('Calendar')); // we have a query $url_string .= "&query=true" . $ustring; $log->info("Here is the where clause for the list view: {$where}"); $smarty->assign("SEARCH_URL", $url_string); } if ($viewnamedesc['viewname'] == 'All') { $smarty->assign("ALL", 'All'); } if (isPermitted("Calendar", "Delete", $_REQUEST['record']) == 'yes') { $other_text['del'] = $app_strings[LBL_MASS_DELETE]; } if (isPermitted('Calendar', 'EditView', '') == 'yes') { $other_text['c_owner'] = $app_strings[LBL_CHANGE_OWNER]; } global $task_title;
function getSelectAllQuery($input, $module) { global $adb, $current_user; $viewid = vtlib_purify($input['viewname']); if ($module == "Calendar") { $listquery = getListQuery($module); $oCustomView = new CustomView($module); $query = $oCustomView->getModifiedCvListQuery($viewid, $listquery, $module); $where = ''; if ($input['query'] == 'true') { list($where, $ustring) = split("#@@#", getWhereCondition($module, $input)); if (isset($where) && $where != '') { $query .= " AND " . $where; } } } else { $queryGenerator = new QueryGenerator($module, $current_user); $queryGenerator->initForCustomViewById($viewid); if ($input['query'] == 'true') { $queryGenerator->addUserSearchConditions($input); } $queryGenerator->setFields(array('id')); $query = $queryGenerator->getQuery(); if ($module == 'Documents') { $folderid = vtlib_purify($input['folderidstring']); $folderid = str_replace(';', ',', $folderid); $query .= " AND vtiger_notes.folderid in (" . $folderid . ")"; } } $result = $adb->pquery($query, array()); return $result; }
echo "</td></tr></table>"; exit; } $changeOwner = getAssignedTo(16); $userList = $changeOwner[0]; $groupList = $changeOwner[1]; $smarty->assign("CHANGE_USER", $userList); $smarty->assign("CHANGE_GROUP", $groupList); $smarty->assign("CHANGE_OWNER", getUserslist()); $smarty->assign("CHANGE_GROUP_OWNER", getGroupslist()); $smarty->assign('MAX_RECORDS', $list_max_entries_per_page); $where = ""; $url_string = ''; // assigning http url string if (isset($_REQUEST['query']) && $_REQUEST['query'] == 'true') { list($where, $ustring) = split("#@@#", getWhereCondition('Calendar')); // we have a query $url_string .= "&query=true" . $ustring; $log->info("Here is the where clause for the list view: {$where}"); $smarty->assign("SEARCH_URL", $url_string); } if ($viewnamedesc['viewname'] == 'All') { $smarty->assign("ALL", 'All'); } if (isPermitted("Calendar", "Delete", $_REQUEST['record']) == 'yes') { $other_text['del'] = $app_strings[LBL_MASS_DELETE]; } if (isPermitted('Calendar', 'EditView', '') == 'yes') { $other_text['c_owner'] = $app_strings[LBL_CHANGE_OWNER]; } global $task_title;