|
Server : Apache System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64 User : rainic ( 1014) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/akaindir/public_html/crm/modules/Mobile/api/ws/ |
Upload File : |
<?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.
************************************************************************************/
class Mobile_WS_FetchModuleFilters extends Mobile_WS_Controller {
function process(Mobile_API_Request $request) {
$module = $request->get('module');
$current_user = $this->getActiveUser();
$allFilters = CustomView_Record_Model::getAllByGroup($module);
unset($allFilters['Public']);
$result = array();
if($allFilters) {
foreach($allFilters as $group => $filters) {
$result[$group] = array();
foreach($filters as $filter) {
$result[$group][] = array('id'=>$filter->get('cvid'), 'name'=>$filter->get('viewname'), 'default'=>$filter->isDefault());
}
}
}
$response = new Mobile_API_Response();
$response->setResult(array('filters'=>$result, 'moduleLabel' => vtranslate($module, $module)));
return $response;
}
protected function getModuleFilters($moduleName, $user) {
$filters = array();
global $adb;
$sql = "SELECT vtiger_customview.*, vtiger_users.user_name FROM vtiger_customview
INNER JOIN vtiger_users ON vtiger_customview.userid = vtiger_users.id WHERE vtiger_customview.entitytype=?";
$parameters = array($moduleName);
if(!is_admin($user)) {
require('user_privileges/user_privileges_'.$user->id.'.php');
$sql .= " AND (vtiger_customview.status=0 or vtiger_customview.userid = ? or vtiger_customview.status = 3 or vtiger_customview.userid IN
(SELECT vtiger_user2role.userid FROM vtiger_user2role INNER JOIN vtiger_users on vtiger_users.id=vtiger_user2role.userid
INNER JOIN vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid WHERE vtiger_role.parentrole LIKE '".$current_user_parent_role_seq."::%'))";
array_push($parameters, $current_user->id);
}
$result = $adb->pquery($sql, $parameters);
if($result && $adb->num_rows($result)) {
while($resultrow = $adb->fetch_array($result)) {
$filters[] = $this->prepareFilterDetailUsingResultRow($resultrow);
}
}
return $filters;
}
protected function prepareFilterDetailUsingResultRow($resultrow) {
$filter = array();
$filter['cvid'] = $resultrow['cvid'];
$filter['viewname'] = decode_html($resultrow['viewname']);
$filter['setdefault'] = $resultrow['setdefault'];
$filter['setmetrics'] = $resultrow['setmetrics'];
$filter['moduleName'] = decode_html($resultrow['entitytype']);
$filter['status'] = decode_html($resultrow['status']);
$filter['userName'] = decode_html($resultrow['user_name']);
return $filter;
}
}