public function process(Vtiger_Request $request) { $db = PearDatabase::getInstance(); $qualifiedModuleName = $request->getModule(false); $moduleName = $request->getModule(); $baseModule = $request->get('base_module'); $tpl_id = $request->get('tpl_id'); if ($request->get('s') == '' || $request->get('s') == 'true') { $summary = $request->get('summary'); $conditionAll = $request->getRaw('condition_all_json'); $conditionOption = $request->getRaw('condition_option_json'); if ($tpl_id != '') { $insertBaseRecord = "UPDATE vtiger_dataaccess SET module_name = ?, summary = ? WHERE dataaccessid = ?"; $db->pquery($insertBaseRecord, array($baseModule, $summary, $tpl_id), true); Settings_DataAccess_Module_Model::updateConditions($conditionAll, $tpl_id); Settings_DataAccess_Module_Model::updateConditions($conditionOption, $tpl_id, FALSE); } else { $insertBaseRecord = "INSERT INTO vtiger_dataaccess (module_name,summary) VALUES(?,?)"; $db->pquery($insertBaseRecord, array($baseModule, $summary), true); $tpl_id = $db->getLastInsertID(); Settings_DataAccess_Module_Model::addConditions($conditionAll, $tpl_id); Settings_DataAccess_Module_Model::addConditions($conditionOption, $tpl_id, FALSE); } } $DataAccess = Settings_DataAccess_Module_Model::getDataAccessInfo($tpl_id, false); $viewer = $this->getViewer($request); $viewer->assign('STEP', 3); $viewer->assign('TPL_ID', $tpl_id); $viewer->assign('MODULE_NAME', $moduleName); $viewer->assign('REQUEST', $request); $viewer->assign('BASE_MODULE', $baseModule); $viewer->assign('ACTIONS_SELECTED', $DataAccess['basic_info']['data']); $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName); echo $viewer->view('Step3.tpl', $qualifiedModuleName, true); }
public static function getSupportedModules() { if (empty(self::$supportedModules)) { self::$supportedModules = self::getEntityModulesList(); } return self::$supportedModules; }
public function process(Vtiger_Request $request) { $qualifiedModuleName = $request->getModule(false); $moduleName = $request->getModule(); $baseModule = $request->get('base_module'); $idTpl = $request->get('tpl_id'); $viewer = $this->getViewer($request); if ($idTpl && $baseModule != 'All') { $docInfo = Settings_DataAccess_Module_Model::getDataAccessInfo($idTpl); $viewer->assign('BASE_INFO', $docInfo['basic_info']); for ($i = 0; $i < count($docInfo['required_conditions']); $i++) { $fieldModel = Vtiger_Field_Model::getInstance($docInfo['required_conditions'][$i]['fieldname'], Vtiger_Module_Model::getInstance($baseModule)); $docInfo['required_conditions'][$i]['info'] = $fieldModel->getFieldInfo(); } $viewer->assign('REQUIRED_CONDITIONS', $docInfo['required_conditions']); for ($i = 0; $i < count($docInfo['optional_conditions']); $i++) { $fieldModel = Vtiger_Field_Model::getInstance($docInfo['optional_conditions'][$i]['fieldname'], Vtiger_Module_Model::getInstance($baseModule)); $docInfo['optional_conditions'][$i]['info'] = $fieldModel->getFieldInfo(); } $viewer->assign('OPTIONAL_CONDITIONS', $docInfo['optional_conditions']); $viewer->assign('TPL_ID', $idTpl); } $viewer->assign('STEP', 2); $viewer->assign('MODULE_NAME', $moduleName); $viewer->assign('REQUEST', $request); $viewer->assign('SUMMARY', $request->get('summary')); $viewer->assign('BASE_MODULE', $baseModule); $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName); $viewer->assign('FIELD_LIST', Settings_DataAccess_Module_Model::getListBaseModuleField($baseModule)); $viewer->assign('CONDITION_BY_TYPE', Settings_DataAccess_Module_Model::getConditionByType()); echo $viewer->view('Step2.tpl', $qualifiedModuleName, true); }
public function process(Vtiger_Request $request) { $tpl_id = $request->get('tpl_id'); $base_module = $request->get('base_module'); Settings_DataAccess_Module_Model::saveActionConfig($tpl_id, $request->get('actions_list'), array()); header("Location: index.php?module=DataAccess&parent=Settings&view=Step3&tpl_id={$tpl_id}&base_module={$base_module}&s=false"); }
public function process(Vtiger_Request $request) { $id = $request->get('id'); $aid = $request->get('a'); $baseModule = $request->get('m'); Settings_DataAccess_Module_Model::deleteAction($id, $aid); header("Location: index.php?module=DataAccess&parent=Settings&view=Step3&tpl_id={$id}&base_module={$baseModule}&s=false"); }
public function process(Vtiger_Request $request) { $param = $request->get('param'); $Resp = Settings_DataAccess_Module_Model::executeAjaxHandlers($param['module'], $param); $response = new Vtiger_Response(); $response->setResult(array('success' => $Resp['success'], 'data' => $Resp['data'])); $response->emit(); }
public function process(Vtiger_Request $request) { $qualifiedModuleName = $request->getModule(false); $moduleName = $request->getModule(); $baseModule = $request->get('base_module'); $viewer = $this->getViewer($request); $viewer->assign('MODULE_NAME', $moduleName); $viewer->assign('DOC_TPL_LIST', Settings_DataAccess_Module_Model::getDataAccessList($baseModule)); $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName); $viewer->assign('DOCUMENT_LIST', $qualifiedModuleName); echo $viewer->view('ListDoc.tpl', $qualifiedModuleName, true); }
public function process(Vtiger_Request $request) { $qualifiedModuleName = $request->getModule(false); $moduleName = $request->getModule(); $viewer = $this->getViewer($request); $viewer->assign('MODULE_NAME', $moduleName); $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName); $viewer->assign('DOC_TPL_LIST', Settings_DataAccess_Module_Model::getDataAccessList()); $viewer->assign('SUPPORTED_MODULE_MODELS', Settings_DataAccess_Module_Model::getEntityModulesList()); $viewer->assign('SETTINGS_MODULE_NAME', $qualifiedModuleName); $viewer->assign('DOCUMENT_LIST', $qualifiedModuleName); echo $viewer->view('Index.tpl', $qualifiedModuleName, true); }
public function process(Vtiger_Request $request) { $baseModule = $request->get('base_module'); $summary = $request->get('summary'); $conditionAll = $request->getRaw('condition_all_json'); $conditionOption = $request->getRaw('condition_option_json'); $db = PearDatabase::getInstance(); $insertBaseRecord = "INSERT INTO vtiger_dataaccess VALUES(?, ?, ?)"; $db->pquery($insertBaseRecord, array(NULL, $baseModule, $summary), true); $recordId = $db->getLastInsertID(); Settings_DataAccess_Module_Model::addConditions($conditionAll, $recordId); Settings_DataAccess_Module_Model::addConditions($conditionOption, $recordId, FALSE); header("Location: index.php?module=DataAccess&parent=Settings&view=Index"); }
public function process(Vtiger_Request $request) { $baseModule = $request->get('base_module'); $summary = $request->get('summary'); $tplId = $request->get('tpl_id'); $conditionAll = $request->getRaw('condition_all_json'); $conditionOption = $request->getRaw('condition_option_json'); $db = PearDatabase::getInstance(); $insertBaseRecord = "UPDATE vtiger_dataaccess SET module_name = ?, summary = ? WHERE dataaccessid = ?"; $db->pquery($insertBaseRecord, array($baseModule, $summary, $tplId), true); Settings_DataAccess_Module_Model::updateConditions($conditionAll, $tplId); Settings_DataAccess_Module_Model::updateConditions($conditionOption, $tplId, FALSE); header("Location: index.php?module=DataAccess&parent=Settings&view=Index"); }
public function process(Vtiger_Request $request) { $qualifiedModuleName = $request->getModule(false); $moduleName = $request->getModule(); $baseModule = $request->get('base_module'); $num = $request->get('num'); if ("" == $num) { $num = 0; } $viewer = $this->getViewer($request); $viewer->assign('NUM', ++$num); $viewer->assign('BASE_MODULE', $baseModule); $viewer->assign('FIELD_LIST', Settings_DataAccess_Module_Model::getListBaseModuleField($baseModule)); $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName); echo $viewer->view('Condition.tpl', $qualifiedModuleName, true); }
public function process(Vtiger_Request $request) { $qualifiedModuleName = $request->getModule(false); $moduleName = $request->getModule(); $baseModule = $request->get('base_module'); $id = $request->get('id'); $viewer = $this->getViewer($request); $viewer->assign('MODULE_NAME', $moduleName); $viewer->assign('STEP', 3); $viewer->assign('BASE_MODULE', $baseModule); $viewer->assign('TPL_ID', $id); $viewer->assign('ACTIONS_LIST', Settings_DataAccess_Module_Model::listAccesDataDirector($baseModule)); $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName); $viewer->assign('DOCUMENT_LIST', $qualifiedModuleName); echo $viewer->view('AddAction.tpl', $qualifiedModuleName, true); }
public function process(Vtiger_Request $request) { $qualifiedModuleName = $request->getModule(false); $moduleName = $request->getModule(); $idTpl = $request->get('tpl_id'); $viewer = $this->getViewer($request); if ($idTpl) { $docInfo = Settings_DataAccess_Module_Model::getDataAccessInfo($idTpl); $viewer->assign('BASE_INFO', $docInfo['basic_info']); $viewer->assign('TPL_ID', $idTpl); } $viewer->assign('STEP', 1); $viewer->assign('MODULE_NAME', $moduleName); $viewer->assign('MODULE_LIST', Settings_DataAccess_Module_Model::getSupportedModules()); $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName); echo $viewer->view('Step1.tpl', $qualifiedModuleName, true); }
public function process(Vtiger_Request $request) { $qualifiedModuleName = $request->getModule(false); $moduleName = $request->getModule(); $baseModule = $request->get('m'); $tpl_id = $request->get('did'); $aid = $request->get('aid'); $action = $request->get('an'); $actionsName = explode(Settings_DataAccess_Module_Model::$separator, $action); $Config = Settings_DataAccess_Module_Model::showConfigDataAccess($tpl_id, $action, $baseModule); $DataAccess = Settings_DataAccess_Module_Model::getDataAccessInfo($tpl_id, false); $viewer = $this->getViewer($request); $viewer->assign('MODULE_NAME', $moduleName); $viewer->assign('BASE_MODULE', $baseModule); $viewer->assign('ACTIONMOD', $actionsName[0]); $viewer->assign('ACTION', $actionsName[1]); $viewer->assign('ACTIONNAME', $action); $viewer->assign('AID', $aid); $viewer->assign('TPL_ID', $tpl_id); $viewer->assign('CONFIG', $Config); $viewer->assign('SAVED_DATA', $DataAccess['basic_info']['data'][$aid]); $viewer->assign('QUALIFIED_MODULE', $qualifiedModuleName); echo $viewer->view('ActionConfig.tpl', $qualifiedModuleName, true); }
/** * Function to get the list view entries * @param Vtiger_Paging_Model $pagingModel * @return <Array> - Associative array of record id mapped to Vtiger_Record_Model instance. */ public function getListViewEntries($pagingModel) { $db = PearDatabase::getInstance(); $moduleName = $this->getModule()->get('name'); $moduleFocus = CRMEntity::getInstance($moduleName); $moduleModel = Vtiger_Module_Model::getInstance($moduleName); $queryGenerator = $this->get('query_generator'); $listViewContoller = $this->get('listview_controller'); $orderBy = $this->getForSql('orderby'); $sortOrder = $this->getForSql('sortorder'); if(!empty($orderBy)){ $columnFieldMapping = $moduleModel->getColumnFieldMapping(); $orderByFieldName = $columnFieldMapping[$orderBy]; $orderByFieldModel = $moduleModel->getField($orderByFieldName); if($orderByFieldModel && $orderByFieldModel->getFieldDataType() == Vtiger_Field_Model::REFERENCE_TYPE){ //IF it is reference add it in the where fields so that from clause will be having join of the table $queryGenerator = $this->get('query_generator'); $queryGenerator->addWhereField($orderByFieldName); } } if (!empty($orderBy) && $orderBy === 'smownerid') { $fieldModel = Vtiger_Field_Model::getInstance('assigned_user_id', $moduleModel); if ($fieldModel->getFieldDataType() == 'owner') { $orderBy = 'COALESCE(' . getSqlForNameInDisplayFormat(['first_name' => 'vtiger_users.first_name', 'last_name' => 'vtiger_users.last_name'], 'Users') . ',vtiger_groups.groupname)'; } } $listQuery = $this->getQuery(); $listQuery = preg_replace("/vtiger_crmentity.deleted\s*=\s*0/i", 'vtiger_crmentity.deleted = 1', $listQuery); $startIndex = $pagingModel->getStartIndex(); $pageLimit = $pagingModel->getPageLimit(); if(!empty($orderBy)) { if($orderByFieldModel && $orderByFieldModel->isReferenceField()){ $referenceModules = $orderByFieldModel->getReferenceList(); $referenceNameFieldOrderBy = array(); foreach($referenceModules as $referenceModuleName) { $referenceModuleModel = Vtiger_Module_Model::getInstance($referenceModuleName); $referenceNameFields = $referenceModuleModel->getNameFields(); $columnList = array(); foreach($referenceNameFields as $nameField) { $fieldModel = $referenceModuleModel->getField($nameField); $columnList[] = $fieldModel->get('table').'.'.$fieldModel->get('column'); } if(count($columnList) > 1) { $referenceNameFieldOrderBy[] = getSqlForNameInDisplayFormat(array('first_name'=>$columnList[0],'last_name'=>$columnList[1]),'Users').' '.$sortOrder; } else { $referenceNameFieldOrderBy[] = implode('', $columnList).' '.$sortOrder ; } } $listQuery .= ' ORDER BY '. implode(',',$referenceNameFieldOrderBy); }else{ $listQuery .= ' ORDER BY '. $orderBy . ' ' .$sortOrder; } } $listQuery .= " LIMIT $startIndex,".($pageLimit+1); $listResult = $db->pquery($listQuery, array()); $listViewRecordModels = array(); $listViewEntries = $listViewContoller->getListViewRecords($moduleFocus,$moduleName, $listResult); $pagingModel->calculatePageRange($listViewEntries); if($db->num_rows($listResult) > $pageLimit){ array_pop($listViewEntries); $pagingModel->set('nextPageExists', true); }else{ $pagingModel->set('nextPageExists', false); } $index = 0; foreach($listViewEntries as $recordId => $record) { $rawData = $db->query_result_rowdata($listResult, $index++); $record['id'] = $recordId; $listViewRecordModels[$recordId] = $moduleModel->getRecordFromArray($record, $rawData); $listViewRecordModels[$recordId]->lockEditView = Users_Privileges_Model::checkLockEdit($moduleName, $recordId); $listViewRecordModels[$recordId]->isPermittedToEditView = Users_Privileges_Model::isPermitted($moduleName, 'EditView', $recordId); $listViewRecordModels[$recordId]->colorList = Settings_DataAccess_Module_Model::executeColorListHandlers( $moduleName, $recordId, $listViewRecordModels[$recordId] ); } return $listViewRecordModels; }
function CheckPermissionsToEditView($moduleName, $record) { $log = vglobal('log'); $log->info("Entering Into fn CheckPermissionsToEditView({$moduleName}, {$record})"); $currentUserModel = Users_Record_Model::getCurrentUserModel(); $currentUserId = $currentUserModel->getId(); $recordPermission = true; if ($record == '' || $currentUserModel->isAdminUser()) { return true; } $recordModel = Vtiger_Record_Model::getInstanceById($record, $moduleName); $PermissionsHandlers = Settings_DataAccess_Module_Model::executePermissionsHandlers($moduleName, $record, $recordModel); $log->info("Exiting fn CheckPermissionsToEditView()"); return $PermissionsHandlers['success']; }
/** * Overrided to add HTML content for callstatus irrespective of the filters */ public function getListViewEntries($pagingModel) { $db = PearDatabase::getInstance(); $moduleName = $this->getModule()->get('name'); $moduleFocus = CRMEntity::getInstance($moduleName); $moduleModel = Vtiger_Module_Model::getInstance($moduleName); //Add the direction field to the query irrespective of filter $queryGenerator = $this->get('query_generator'); $fields = $queryGenerator->getFields(); array_push($fields, 'direction'); $queryGenerator->setFields($fields); $this->set('query_generator', $queryGenerator); //END $listViewContoller = $this->get('listview_controller'); $searchKey = $this->get('search_key'); $searchValue = $this->get('search_value'); $operator = $this->get('operator'); if (!empty($searchKey)) { $queryGenerator->addUserSearchConditions(array('search_field' => $searchKey, 'search_text' => $searchValue, 'operator' => $operator)); } $orderBy = $this->getForSql('orderby'); $sortOrder = $this->getForSql('sortorder'); //List view will be displayed on recently created/modified records if (empty($orderBy) && empty($sortOrder) && $moduleName != "Users") { $orderBy = 'modifiedtime'; $sortOrder = 'DESC'; } if (!empty($orderBy)) { $columnFieldMapping = $moduleModel->getColumnFieldMapping(); $orderByFieldName = $columnFieldMapping[$orderBy]; $orderByFieldModel = $moduleModel->getField($orderByFieldName); if ($orderByFieldModel->getFieldDataType() == Vtiger_Field_Model::REFERENCE_TYPE) { //IF it is reference add it in the where fields so that from clause will be having join of the table $queryGenerator = $this->get('query_generator'); $queryGenerator->addWhereField($orderByFieldName); //$queryGenerator->whereFields[] = $orderByFieldName; } } $listQuery = $this->getQuery(); $sourceModule = $this->get('src_module'); if (!empty($sourceModule)) { if (method_exists($moduleModel, 'getQueryByModuleField')) { $overrideQuery = $moduleModel->getQueryByModuleField($sourceModule, $this->get('src_field'), $this->get('src_record'), $listQuery); if (!empty($overrideQuery)) { $listQuery = $overrideQuery; } } } $startIndex = $pagingModel->getStartIndex(); $pageLimit = $pagingModel->getPageLimit(); if (!empty($orderBy)) { if ($orderByFieldModel->isReferenceField()) { $referenceModules = $orderByFieldModel->getReferenceList(); $referenceNameFieldOrderBy = array(); foreach ($referenceModules as $referenceModuleName) { $referenceModuleModel = Vtiger_Module_Model::getInstance($referenceModuleName); $referenceNameFields = $referenceModuleModel->getNameFields(); $columnList = array(); foreach ($referenceNameFields as $nameField) { $fieldModel = $referenceModuleModel->getField($nameField); $columnList[] = $fieldModel->get('table') . $orderByFieldModel->getName() . '.' . $fieldModel->get('column'); } if (count($columnList) > 1) { $referenceNameFieldOrderBy[] = getSqlForNameInDisplayFormat(array('first_name' => $columnList[0], 'last_name' => $columnList[1]), 'Users') . ' ' . $sortOrder; } else { $referenceNameFieldOrderBy[] = implode('', $columnList) . ' ' . $sortOrder; } } $listQuery .= ' ORDER BY ' . implode(',', $referenceNameFieldOrderBy); } else { $listQuery .= ' ORDER BY ' . $orderBy . ' ' . $sortOrder; } } $viewid = ListViewSession::getCurrentView($moduleName); ListViewSession::setSessionQuery($moduleName, $listQuery, $viewid); $listQuery .= " LIMIT {$startIndex}," . ($pageLimit + 1); $listResult = $db->pquery($listQuery, array()); $listViewRecordModels = array(); $listViewEntries = $listViewContoller->getListViewRecords($moduleFocus, $moduleName, $listResult); $pagingModel->calculatePageRange($listViewEntries); if ($db->num_rows($listResult) > $pageLimit) { array_pop($listViewEntries); $pagingModel->set('nextPageExists', true); } else { $pagingModel->set('nextPageExists', false); } //Adding the HTML content based on the callstatus and direction to the records foreach ($listViewEntries as $recordId => $record) { //To Replace RecordingUrl by Icon $recordingUrl = explode('>', $listViewEntries[$recordId]['recordingurl']); $url = explode('<', $recordingUrl[1]); if ($url[0] != '' && $listViewEntries[$recordId]['callstatus'] == 'completed') { $listViewEntries[$recordId]['recordingurl'] = $recordingUrl[0] . '>' . '<i class="icon-volume-up"></i>' . '</a>'; } else { $listViewEntries[$recordId]['recordingurl'] = ''; } if ($listViewEntries[$recordId]['direction'] == 'outbound') { if ($listViewEntries[$recordId]['callstatus'] == 'ringing' || $listViewEntries[$recordId]['callstatus'] == 'in-progress') { $listViewEntries[$recordId]['callstatus'] = '<span class="label label-info"><i class="icon-arrow-up icon-white"> </i> ' . $listViewEntries[$recordId]["callstatus"] . '</span>'; } else { if ($listViewEntries[$recordId]['callstatus'] == 'completed') { $listViewEntries[$recordId]['callstatus'] = '<span class="label label-success"><i class="icon-arrow-up icon-white"> </i> ' . $listViewEntries[$recordId]["callstatus"] . '</span>'; } else { if ($listViewEntries[$recordId]['callstatus'] == 'no-answer') { $listViewEntries[$recordId]['callstatus'] = '<span class="label label-important"><i class="icon-arrow-up icon-white"> </i> ' . $listViewEntries[$recordId]["callstatus"] . '</span>'; } else { $listViewEntries[$recordId]['callstatus'] = '<span class="label label-warning"><i class="icon-arrow-up icon-white"> </i> ' . $listViewEntries[$recordId]["callstatus"] . '</span>'; } } } } else { if ($listViewEntries[$recordId]['direction'] == 'inbound') { if ($listViewEntries[$recordId]['callstatus'] == 'ringing' || $listViewEntries[$recordId]['callstatus'] == 'in-progress') { $listViewEntries[$recordId]['callstatus'] = '<span class="label label-info"><i class="icon-arrow-down icon-white"> </i> ' . $listViewEntries[$recordId]["callstatus"] . '</span>'; } else { if ($listViewEntries[$recordId]['callstatus'] == 'completed') { $listViewEntries[$recordId]['callstatus'] = '<span class="label label-success"><i class="icon-arrow-down icon-white"> </i> ' . $listViewEntries[$recordId]["callstatus"] . '</span>'; } else { if ($listViewEntries[$recordId]['callstatus'] == 'no-answer') { $listViewEntries[$recordId]['callstatus'] = '<span class="label label-important"><i class="icon-arrow-down icon-white"> </i> ' . $listViewEntries[$recordId]["callstatus"] . '</span>'; } else { $listViewEntries[$recordId]['callstatus'] = '<span class="label label-warning"><i class="icon-arrow-down icon-white"> </i> ' . $listViewEntries[$recordId]["callstatus"] . '</span>'; } } } } } } //END $index = 0; foreach ($listViewEntries as $recordId => $record) { $rawData = $db->query_result_rowdata($listResult, $index++); $record['id'] = $recordId; $listViewRecordModels[$recordId] = $moduleModel->getRecordFromArray($record, $rawData); $listViewRecordModels[$recordId]->lockEditView = Users_Privileges_Model::checkLockEdit($moduleName, $recordId); $listViewRecordModels[$recordId]->isPermittedToEditView = Users_Privileges_Model::isPermitted($moduleName, 'EditView', $recordId); $listViewRecordModels[$recordId]->colorList = Settings_DataAccess_Module_Model::executeColorListHandlers($moduleName, $recordId, $listViewRecordModels[$recordId]); } return $listViewRecordModels; }
function preProcess(Vtiger_Request $request, $display = true) { parent::preProcess($request, false); $recordId = $request->get('record'); $moduleName = $request->getModule(); if (!$this->record) { $this->record = Vtiger_DetailView_Model::getInstance($moduleName, $recordId); } $recordModel = $this->record->getRecord(); $recordStrucure = Vtiger_RecordStructure_Model::getInstanceFromRecordModel($recordModel, Vtiger_RecordStructure_Model::RECORD_STRUCTURE_MODE_DETAIL); $summaryInfo = array(); // Take first block information as summary information $stucturedValues = $recordStrucure->getStructure(); foreach ($stucturedValues as $blockLabel => $fieldList) { $summaryInfo[$blockLabel] = $fieldList; break; } $detailViewLinkParams = array('MODULE' => $moduleName, 'RECORD' => $recordId); $detailViewLinks = $this->record->getDetailViewLinks($detailViewLinkParams); $this->record->getWidgets($detailViewLinkParams); $navigationInfo = ListViewSession::getListViewNavigation($recordId); $viewer = $this->getViewer($request); $viewer->assign('RECORD', $recordModel); $viewer->assign('NAVIGATION', $navigationInfo); $viewer->assign('COLORLISTHANDLERS', Settings_DataAccess_Module_Model::executeColorListHandlers($moduleName, $recordId, false)); //Intially make the prev and next records as null $prevRecordId = null; $nextRecordId = null; $found = false; if ($navigationInfo) { foreach ($navigationInfo as $page => $pageInfo) { foreach ($pageInfo as $index => $record) { //If record found then next record in the interation //will be next record if ($found) { $nextRecordId = $record; break; } if ($record == $recordId) { $found = true; } //If record not found then we are assiging previousRecordId //assuming next record will get matched if (!$found) { $prevRecordId = $record; } } //if record is found and next record is not calculated we need to perform iteration if ($found && !empty($nextRecordId)) { break; } } } $moduleModel = Vtiger_Module_Model::getInstance($moduleName); if (!empty($prevRecordId)) { $viewer->assign('PREVIOUS_RECORD_URL', $moduleModel->getDetailViewUrl($prevRecordId)); } if (!empty($nextRecordId)) { $viewer->assign('NEXT_RECORD_URL', $moduleModel->getDetailViewUrl($nextRecordId)); } $viewer->assign('MODULE_MODEL', $this->record->getModule()); $viewer->assign('DETAILVIEW_LINKS', $detailViewLinks); $viewer->assign('DETAILVIEW_WIDGETS', $this->record->widgets); $viewer->assign('IS_EDITABLE', $this->record->getRecord()->isEditable($moduleName)); $viewer->assign('IS_DELETABLE', $this->record->getRecord()->isDeletable($moduleName)); $linkParams = array('MODULE' => $moduleName, 'ACTION' => $request->get('view')); $linkModels = $this->record->getSideBarLinks($linkParams); $viewer->assign('QUICK_LINKS', $linkModels); $viewer->assign('MODULE_NAME', $moduleName); $currentUserModel = Users_Record_Model::getCurrentUserModel(); $viewer->assign('DEFAULT_RECORD_VIEW', $currentUserModel->get('default_record_view')); $picklistDependencyDatasource = Vtiger_DependencyPicklist::getPicklistDependencyDatasource($moduleName); $viewer->assign('PICKLIST_DEPENDENCY_DATASOURCE', Zend_Json::encode($picklistDependencyDatasource)); if ($display) { $this->preProcessDisplay($request); } }
/** * Function to get the list view entries * @param Vtiger_Paging_Model $pagingModel * @return <Array> - Associative array of record id mapped to Vtiger_Record_Model instance. */ public function getListViewEntries($pagingModel, $searchResult = false) { $db = PearDatabase::getInstance(); $moduleName = $this->getModule()->get('name'); $moduleFocus = CRMEntity::getInstance($moduleName); $moduleModel = Vtiger_Module_Model::getInstance($moduleName); $currentUser = Users_Record_Model::getCurrentUserModel(); $queryGenerator = $this->get('query_generator'); $listViewContoller = $this->get('listview_controller'); $listViewFields = array('visibility', 'assigned_user_id', 'activitystatus'); $queryGenerator->setFields(array_unique(array_merge($queryGenerator->getFields(), $listViewFields))); $searchParams = $this->get('search_params'); if (empty($searchParams)) { $searchParams = array(); } $glue = ""; if (count($queryGenerator->getWhereFields()) > 0 && count($searchParams) > 0) { $glue = QueryGenerator::$AND; } $queryGenerator->parseAdvFilterList($searchParams, $glue); $searchKey = $this->get('search_key'); $searchValue = $this->get('search_value'); $operator = $this->get('operator'); if (!empty($searchKey)) { $queryGenerator->addUserSearchConditions(array('search_field' => $searchKey, 'search_text' => $searchValue, 'operator' => $operator)); } $orderBy = $this->getForSql('orderby'); $sortOrder = $this->getForSql('sortorder'); //List view will be displayed on recently created/modified records if (empty($orderBy) && empty($sortOrder) && $moduleName != "Users") { $orderBy = 'modifiedtime'; $sortOrder = 'DESC'; } if (!empty($orderBy)) { $columnFieldMapping = $moduleModel->getColumnFieldMapping(); $orderByFieldName = $columnFieldMapping[$orderBy]; $orderByFieldModel = $moduleModel->getField($orderByFieldName); if ($orderByFieldModel && $orderByFieldModel->isReferenceField()) { //IF it is reference add it in the where fields so that from clause will be having join of the table $queryGenerator = $this->get('query_generator'); $queryGenerator->setConditionField($orderByFieldName); //$queryGenerator->whereFields[] = $orderByFieldName; } } if (!empty($orderBy) && $orderBy === 'smownerid') { $fieldModel = Vtiger_Field_Model::getInstance('assigned_user_id', $moduleModel); if ($fieldModel->getFieldDataType() == 'owner') { $orderBy = 'COALESCE(' . getSqlForNameInDisplayFormat(['first_name' => 'vtiger_users.first_name', 'last_name' => 'vtiger_users.last_name'], 'Users', '') . ', vtiger_groups.groupname)'; } } //To combine date and time fields for sorting if ($orderBy == 'date_start') { $orderBy = "str_to_date(concat(date_start,time_start),'%Y-%m-%d %H:%i:%s')"; } else { if ($orderBy == 'due_date') { $orderBy = "str_to_date(concat(due_date,time_end),'%Y-%m-%d %H:%i:%s')"; } } $listQuery = $this->getQuery(); if ($searchResult && $searchResult != '' && is_array($searchResult)) { $listQuery .= " AND vtiger_crmentity.crmid IN (" . implode(', ', $searchResult) . ") "; } unset($searchResult); $sourceModule = $this->get('src_module'); if (!empty($sourceModule)) { if (method_exists($moduleModel, 'getQueryByModuleField')) { $overrideQuery = $moduleModel->getQueryByModuleField($sourceModule, $this->get('src_field'), $this->get('src_record'), $listQuery); if (!empty($overrideQuery)) { $listQuery = $overrideQuery; } } } $startIndex = $pagingModel->getStartIndex(); $pageLimit = $pagingModel->getPageLimit(); if (!empty($orderBy)) { if ($orderByFieldModel && $orderByFieldModel->isReferenceField()) { $referenceModules = $orderByFieldModel->getReferenceList(); $referenceNameFieldOrderBy = array(); foreach ($referenceModules as $referenceModuleName) { $referenceModuleModel = Vtiger_Module_Model::getInstance($referenceModuleName); $referenceNameFields = $referenceModuleModel->getNameFields(); $columnList = array(); foreach ($referenceNameFields as $nameField) { $fieldModel = $referenceModuleModel->getField($nameField); $columnList[] = $fieldModel->get('table') . $orderByFieldModel->getName() . '.' . $fieldModel->get('column'); } if (count($columnList) > 1) { $referenceNameFieldOrderBy[] = getSqlForNameInDisplayFormat(array('first_name' => $columnList[0], 'last_name' => $columnList[1]), 'Users') . ' ' . $sortOrder; } else { $referenceNameFieldOrderBy[] = implode('', $columnList) . ' ' . $sortOrder; } } $listQuery .= ' ORDER BY ' . implode(', ', $referenceNameFieldOrderBy); } else { $listQuery .= ' ORDER BY ' . $orderBy . ' ' . $sortOrder; } } $viewid = ListViewSession::getCurrentView($moduleName); if (empty($viewid)) { $viewid = $pagingModel->get('viewid'); } $_SESSION['lvs'][$moduleName][$viewid]['start'] = $pagingModel->get('page'); ListViewSession::setSessionQuery($moduleName, $listQuery, $viewid); $listQueryWithNoLimit = $listQuery; $listQuery .= " LIMIT {$startIndex}," . ($pageLimit + 1); $listResult = $db->pquery($listQuery, array()); $listViewRecordModels = array(); $listViewEntries = $listViewContoller->getListViewRecords($moduleFocus, $moduleName, $listResult); $pagingModel->calculatePageRange($listViewEntries); if ($db->num_rows($listResult) > $pageLimit) { array_pop($listViewEntries); $pagingModel->set('nextPageExists', true); } else { $pagingModel->set('nextPageExists', false); } $groupsIds = Vtiger_Util_Helper::getGroupsIdsForUsers($currentUser->getId()); $index = 0; foreach ($listViewEntries as $recordId => $record) { $rawData = $db->query_result_rowdata($listResult, $index++); $visibleFields = array('activitytype', 'date_start', 'due_date', 'assigned_user_id', 'visibility', 'smownerid'); $ownerId = $rawData['smownerid']; $visibility = true; if (in_array($ownerId, $groupsIds)) { $visibility = false; } else { if ($ownerId == $currentUser->getId()) { $visibility = false; } } if (!$currentUser->isAdminUser() && $rawData['activitytype'] != 'Task' && $rawData['visibility'] == 'Private' && $ownerId && $visibility) { foreach ($record as $data => $value) { if (in_array($data, $visibleFields) != -1) { unset($rawData[$data]); unset($record[$data]); } } $record['subject'] = vtranslate('Busy', 'Events') . '*'; } if ($record['activitytype'] == 'Task') { unset($record['visibility']); unset($rawData['visibility']); } $record['id'] = $recordId; $listViewRecordModels[$recordId] = $moduleModel->getRecordFromArray($record, $rawData); $listViewRecordModels[$recordId]->lockEditView = Users_Privileges_Model::checkLockEdit($moduleName, $recordId); $listViewRecordModels[$recordId]->isPermittedToEditView = Users_Privileges_Model::isPermitted($moduleName, 'EditView ', $recordId); $listViewRecordModels[$recordId]->colorList = Settings_DataAccess_Module_Model::executeColorListHandlers($moduleName, $recordId, $listViewRecordModels[$recordId]); } return $listViewRecordModels; }
/** * Function to get the list view entries * @param Vtiger_Paging_Model $pagingModel * @return <Array> - Associative array of record id mapped to Vtiger_Record_Model instance. */ public function getListViewEntries($pagingModel) { $db = PearDatabase::getInstance(); $moduleName = $this->getModule()->get('name'); $moduleFocus = CRMEntity::getInstance($moduleName); $moduleModel = Vtiger_Module_Model::getInstance($moduleName); $queryGenerator = $this->get('query_generator'); $listViewContoller = $this->get('listview_controller'); $searchParams = $this->get('search_params'); if (empty($searchParams)) { $searchParams = array(); } $glue = ""; if (count($queryGenerator->getWhereFields()) > 0 && (count($searchParams)) > 0) { $glue = QueryGenerator::$AND; } $queryGenerator->parseAdvFilterList($searchParams, $glue); $searchKey = $this->get('search_key'); $searchValue = $this->get('search_value'); $operator = $this->get('operator'); if (!empty($searchKey)) { $queryGenerator->addUserSearchConditions(array('search_field' => $searchKey, 'search_text' => $searchValue, 'operator' => $operator)); } $orderBy = $this->getForSql('orderby'); $sortOrder = $this->getForSql('sortorder'); //List view will be displayed on recently created/modified records if (empty($orderBy) && empty($sortOrder) && $moduleName != "Users") { $orderBy = 'modifiedtime'; $sortOrder = 'DESC'; } if (!empty($orderBy)) { $columnFieldMapping = $moduleModel->getColumnFieldMapping(); $orderByFieldName = $columnFieldMapping[$orderBy]; $orderByFieldModel = $moduleModel->getField($orderByFieldName); if ($orderByFieldModel && ($orderByFieldModel->isReferenceField() || $orderByFieldModel->getFieldDataType() == Vtiger_Field_Model::CURRENCY_LIST)) { //IF it is reference add it in the where fields so that from clause will be having join of the table $queryGenerator = $this->get('query_generator'); $queryGenerator->addWhereField($orderByFieldName); //$queryGenerator->whereFields[] = $orderByFieldName; } } if (!empty($orderBy) && $orderBy === 'smownerid') { $fieldModel = Vtiger_Field_Model::getInstance('assigned_user_id', $moduleModel); if ($fieldModel->getFieldDataType() == 'owner') { $orderBy = 'COALESCE(' . getSqlForNameInDisplayFormat(['first_name' => 'vtiger_users.first_name', 'last_name' => 'vtiger_users.last_name'], 'Users') . ',vtiger_groups.groupname)'; } } $listQuery = $this->getQuery(); $sourceModule = $this->get('src_module'); $sourceField = $this->get('src_field'); if (!empty($sourceModule)) { if (method_exists($moduleModel, 'getQueryByModuleField')) { $overrideQuery = $moduleModel->getQueryByModuleField($sourceModule, $this->get('src_field'), $this->get('src_record'), $listQuery, $this->get('currency_id')); if (!empty($overrideQuery)) { $listQuery = $overrideQuery; } } } $startIndex = $pagingModel->getStartIndex(); $pageLimit = $pagingModel->getPageLimit(); if (!empty($orderBy)) { if ($orderByFieldModel && $orderByFieldModel->isReferenceField()) { $referenceModules = $orderByFieldModel->getReferenceList(); $referenceNameFieldOrderBy = array(); foreach ($referenceModules as $referenceModuleName) { $referenceModuleModel = Vtiger_Module_Model::getInstance($referenceModuleName); $referenceNameFields = $referenceModuleModel->getNameFields(); $columnList = array(); foreach ($referenceNameFields as $nameField) { $fieldModel = $referenceModuleModel->getField($nameField); $columnList[] = $fieldModel->get('table') . $orderByFieldModel->getName() . '.' . $fieldModel->get('column'); } if (count($columnList) > 1) { $referenceNameFieldOrderBy[] = getSqlForNameInDisplayFormat(array('first_name' => $columnList[0], 'last_name' => $columnList[1]), 'Users') . ' ' . $sortOrder; } else { $referenceNameFieldOrderBy[] = implode('', $columnList) . ' ' . $sortOrder; } } $listQuery .= ' ORDER BY ' . implode(',', $referenceNameFieldOrderBy); } else if ($orderByFieldModel && $orderByFieldModel->getFieldDataType() == Vtiger_Field_Model::CURRENCY_LIST) { $listQuery .= ' ORDER BY ' . $orderByFieldModel->getUITypeModel()->getCurrenyListReferenceFieldName() . ' ' . $sortOrder; } else { $listQuery .= ' ORDER BY ' . $orderBy . ' ' . $sortOrder; } } $viewid = ListViewSession::getCurrentView($moduleName); if (empty($viewid)) { $viewid = $pagingModel->get('viewid'); } $_SESSION['lvs'][$moduleName][$viewid]['start'] = $pagingModel->get('page'); ListViewSession::setSessionQuery($moduleName, $listQuery, $viewid); //For Pricebooks popup in Products and Services Related list if ($sourceField !== 'productsRelatedList') { $listQuery .= " LIMIT $startIndex," . ($pageLimit + 1); } $listResult = $db->pquery($listQuery, array()); $listViewRecordModels = array(); $listViewEntries = $listViewContoller->getListViewRecords($moduleFocus, $moduleName, $listResult); $pagingModel->calculatePageRange($listViewEntries); //To check if next page if ($db->num_rows($listResult) > $pageLimit && $sourceField !== 'productsRelatedList') { array_pop($listViewEntries); $pagingModel->set('nextPageExists', true); } else { $pagingModel->set('nextPageExists', false); } $index = 0; foreach ($listViewEntries as $recordId => $record) { $rawData = $db->query_result_rowdata($listResult, $index++); $record['id'] = $recordId; // Pass through the src_record state to dependent model if ($this->has('src_record')) { $rawData['src_record'] = $this->get('src_record'); } $listViewRecordModels[$recordId] = $moduleModel->getRecordFromArray($record, $rawData); $listViewRecordModels[$recordId]->lockEditView = Users_Privileges_Model::checkLockEdit($moduleName, $recordId); $listViewRecordModels[$recordId]->isPermittedToEditView = Users_Privileges_Model::isPermitted($moduleName, 'EditView', $recordId); $listViewRecordModels[$recordId]->colorList = Settings_DataAccess_Module_Model::executeColorListHandlers($moduleName, $recordId, $listViewRecordModels[$recordId]); } return $listViewRecordModels; }
/** * Function to get the list view entries * @param Vtiger_Paging_Model $pagingModel * @return <Array> - Associative array of record id mapped to Vtiger_Record_Model instance. */ public function getListViewEntries($pagingModel) { $db = PearDatabase::getInstance(); $moduleName = $this->getModule()->get('name'); $moduleFocus = CRMEntity::getInstance($moduleName); $moduleModel = Vtiger_Module_Model::getInstance($moduleName); $queryGenerator = $this->get('query_generator'); $listViewContoller = $this->get('listview_controller'); $searchParams = $this->get('search_params'); if (empty($searchParams)) { $searchParams = array(); } $glue = ""; if (count($queryGenerator->getWhereFields()) > 0 && count($searchParams) > 0) { $glue = QueryGenerator::$AND; } $queryGenerator->parseAdvFilterList($searchParams, $glue); $searchKey = $this->get('search_key'); $searchValue = $this->get('search_value'); $operator = $this->get('operator'); if (!empty($searchKey)) { $queryGenerator->addUserSearchConditions(array('search_field' => $searchKey, 'search_text' => $searchValue, 'operator' => $operator)); } $orderBy = $this->getForSql('orderby'); $sortOrder = $this->getForSql('sortorder'); //List view will be displayed on recently created/modified records if (empty($orderBy) && empty($sortOrder) && $moduleName != "Users") { $orderBy = 'modifiedtime'; $sortOrder = 'DESC'; } if (!empty($orderBy)) { $columnFieldMapping = $moduleModel->getColumnFieldMapping(); $orderByFieldName = $columnFieldMapping[$orderBy]; $orderByFieldModel = $moduleModel->getField($orderByFieldName); if ($orderByFieldModel && $orderByFieldModel->getFieldDataType() == Vtiger_Field_Model::REFERENCE_TYPE) { //IF it is reference add it in the where fields so that from clause will be having join of the table $queryGenerator = $this->get('query_generator'); $queryGenerator->addWhereField($orderByFieldName); } } if (!empty($orderBy) && $orderBy === 'smownerid') { $fieldModel = Vtiger_Field_Model::getInstance('assigned_user_id', $moduleModel); if ($fieldModel->getFieldDataType() == 'owner') { $orderBy = 'COALESCE(CONCAT(vtiger_users.first_name,vtiger_users.last_name),vtiger_groups.groupname)'; } } $listQuery = $this->getQuery(); $request = new Vtiger_Request($_REQUEST, $_REQUEST); $potential_id = $this->get('potential_id'); if (Settings_SalesProcesses_Module_Model::checkRelatedToPotentialsLimit() && Settings_SalesProcesses_Module_Model::isLimitForModule($request->get('module'))) { if (empty($potential_id)) { $potential_id = $this->get('potentialid'); if ($potential_id == '') { $potential_id = -1; } } $newListQuery = ''; $explodedListQuery = explode('INNER JOIN', $listQuery); foreach ($explodedListQuery as $key => $value) { $newListQuery .= 'INNER JOIN' . $value; if ($key == 0 && $moduleName == 'Products') { $newListQuery .= ' INNER JOIN vtiger_seproductsrel AS seproductsrel ON vtiger_products.productid = seproductsrel.productid '; } elseif ($key == 0 && $moduleName == 'Services') { $newListQuery .= ' INNER JOIN vtiger_crmentityrel ON (vtiger_crmentityrel.relcrmid = vtiger_service.serviceid OR vtiger_crmentityrel.crmid = vtiger_service.serviceid) '; } } $newListQuery = trim($newListQuery, 'INNER JOIN'); if ($moduleName == 'Products') { $newListQuery .= " AND seproductsrel.crmid = '{$potential_id}' "; } elseif ($moduleName == 'Services') { $newListQuery .= " AND ( (vtiger_crmentityrel.crmid = '{$potential_id}' AND module = 'Potentials') OR (vtiger_crmentityrel.relcrmid = '{$potential_id}' AND relmodule = 'Potentials')) "; } $listQuery = $newListQuery; } if ($this->get('subProductsPopup')) { $listQuery = $this->addSubProductsQuery($listQuery); } $sourceModule = $this->get('src_module'); $sourceField = $this->get('src_field'); if (!empty($sourceModule)) { if (method_exists($moduleModel, 'getQueryByModuleField')) { $overrideQuery = $moduleModel->getQueryByModuleField($sourceModule, $sourceField, $this->get('src_record'), $listQuery); if (!empty($overrideQuery)) { $listQuery = $overrideQuery; } } } $startIndex = $pagingModel->getStartIndex(); $pageLimit = $pagingModel->getPageLimit(); if (!empty($orderBy)) { if ($orderByFieldModel && $orderByFieldModel->getFieldDataType() == Vtiger_Field_Model::REFERENCE_TYPE) { $referenceModules = $orderByFieldModel->getReferenceList(); $referenceNameFieldOrderBy = array(); foreach ($referenceModules as $referenceModuleName) { $referenceModuleModel = Vtiger_Module_Model::getInstance($referenceModuleName); $referenceNameFields = $referenceModuleModel->getNameFields(); $columnList = array(); foreach ($referenceNameFields as $nameField) { $fieldModel = $referenceModuleModel->getField($nameField); $columnList[] = $fieldModel->get('table') . $orderByFieldModel->getName() . '.' . $fieldModel->get('column'); } if (count($columnList) > 1) { $referenceNameFieldOrderBy[] = getSqlForNameInDisplayFormat(array('first_name' => $columnList[0], 'last_name' => $columnList[1]), 'Users') . ' ' . $sortOrder; } else { $referenceNameFieldOrderBy[] = implode('', $columnList) . ' ' . $sortOrder; } } $listQuery .= ' ORDER BY ' . implode(',', $referenceNameFieldOrderBy); } else { $listQuery .= ' ORDER BY ' . $orderBy . ' ' . $sortOrder; } } $viewid = ListViewSession::getCurrentView($moduleName); if (empty($viewid)) { $viewid = $pagingModel->get('viewid'); } $_SESSION['lvs'][$moduleName][$viewid]['start'] = $pagingModel->get('page'); ListViewSession::setSessionQuery($moduleName, $listQuery, $viewid); //For Products popup in Price Book Related list if ($sourceModule !== 'PriceBooks' && $sourceField !== 'priceBookRelatedList') { $listQuery .= " LIMIT {$startIndex}," . ($pageLimit + 1); } $listResult = $db->pquery($listQuery, array()); $listViewRecordModels = array(); $listViewEntries = $listViewContoller->getListViewRecords($moduleFocus, $moduleName, $listResult); $pagingModel->calculatePageRange($listViewEntries); if ($db->num_rows($listResult) > $pageLimit && $sourceModule !== 'PriceBooks' && $sourceField !== 'priceBookRelatedList') { array_pop($listViewEntries); $pagingModel->set('nextPageExists', true); } else { $pagingModel->set('nextPageExists', false); } $index = 0; foreach ($listViewEntries as $recordId => $record) { $rawData = $db->query_result_rowdata($listResult, $index++); $record['id'] = $recordId; $listViewRecordModels[$recordId] = $moduleModel->getRecordFromArray($record, $rawData); $listViewRecordModels[$recordId]->lockEditView = Users_Privileges_Model::checkLockEdit($moduleName, $recordId); $listViewRecordModels[$recordId]->isPermittedToEditView = Users_Privileges_Model::isPermitted($moduleName, 'EditView', $recordId); $listViewRecordModels[$recordId]->colorList = Settings_DataAccess_Module_Model::executeColorListHandlers($moduleName, $recordId, $listViewRecordModels[$recordId]); } return $listViewRecordModels; }