|
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/www/crm/modules/Settings/Workflows/models/ |
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.
*************************************************************************************/
/*
* Settings List View Model Class
*/
class Settings_Workflows_ListView_Model extends Settings_Vtiger_ListView_Model {
/**
* 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) {
$listview_max_textlength = vglobal('listview_max_textlength');
$db = PearDatabase::getInstance();
$module = $this->getModule();
$moduleName = $module->getName();
$parentModuleName = $module->getParentName();
$qualifiedModuleName = $moduleName;
if(!empty($parentModuleName)) {
$qualifiedModuleName = $parentModuleName.':'.$qualifiedModuleName;
}
$recordModelClass = Vtiger_Loader::getComponentClassName('Model', 'Record', $qualifiedModuleName);
$search_value = $this->get('search_value');
$listFields = $module->listFields;
$listQuery = "SELECT ";
foreach ($listFields as $fieldName => $fieldLabel) {
$listQuery .= "$fieldName, ";
}
$listQuery .= "status, ";
$listQuery .= $module->baseIndex . " FROM ". $module->baseTable.
' INNER JOIN vtiger_tab ON vtiger_tab.name='. $module->baseTable.'.module_name';
$params = array();
$sourceModule = $this->get('sourceModule');
if(!empty($sourceModule)) {
$listQuery .= ' WHERE vtiger_tab.presence IN (0,2) AND module_name = ?';
$params[] = $sourceModule;
} else {
$listQuery .= ' WHERE vtiger_tab.presence IN (0,2)';
}
if(!empty($search_value)) {
$listQuery .= ' AND workflowname like "%'.$search_value.'%"';
}
$startIndex = $pagingModel->getStartIndex();
$pageLimit = $pagingModel->getPageLimit();
$orderBy = $this->getForSql('orderby');
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)';
}
}
if(!empty($orderBy)) {
$listQuery .= ' ORDER BY '. $orderBy . ' ' .$this->getForSql('sortorder');
}
$nextListQuery = $listQuery.' LIMIT '.($startIndex+$pageLimit).',1';
$listQuery .= " LIMIT $startIndex,".($pageLimit+1);
$listResult = $db->pquery($listQuery, $params);
$noOfRecords = $db->num_rows($listResult);
$listViewRecordModels = array();
for($i=0; $i<$noOfRecords; ++$i) {
$row = $db->query_result_rowdata($listResult, $i);
$record = new $recordModelClass();
$module_name = $row['module_name'];
$row['raw_module_name'] = $module_name;
//To handle translation of calendar to To Do
if($module_name == 'Calendar'){
$module_name = vtranslate('LBL_TASK', $module_name);
}else{
$module_name = vtranslate($module_name, $module_name);
}
$row['module_name'] = $module_name;
$row['v7_execution_condition'] = $record->getV7executionConditionAsLabel($row['execution_condition'], $module_name);
$row['execution_condition'] = vtranslate($record->executionConditionAsLabel($row['execution_condition']), 'Settings:Workflows');
if(mb_strlen(decode_html($row['summary']), 'UTF-8') > $listview_max_textlength) {
$row['summary'] = mb_substr(decode_html($row['summary']), 0, $listview_max_textlength, 'UTF-8')."...";
}
$test = decode_html($row['test']);
$row['raw_test'] = $test;
if(!empty($test) && $test != ''){
$wfCond = json_decode($test,true);
$conditionList = array();
if(is_array($wfCond)) {
for ($k=0; $k<(count($wfCond)); ++$k){
$conditionList[] = $wfCond[$k]['fieldname'].' '.$wfCond[$k]['operation'].' '.$wfCond[$k]['value'];
}
}
$row['test'] = $conditionList;
}
$record->setData($row);
$listViewRecordModels[$record->getId()] = $record;
}
$pagingModel->calculatePageRange($listViewRecordModels);
if($db->num_rows($listResult) > $pageLimit){
array_pop($listViewRecordModels);
$pagingModel->set('nextPageExists', true);
}else{
$pagingModel->set('nextPageExists', false);
}
$nextPageResult = $db->pquery($nextListQuery, $params);
$nextPageNumRows = $db->num_rows($nextPageResult);
if($nextPageNumRows <= 0) {
$pagingModel->set('nextPageExists', false);
}
return $listViewRecordModels;
}
/* * *
* Function which will get the list view count
* @return - number of records
*/
public function getListViewCount() {
$db = PearDatabase::getInstance();
$module = $this->getModule();
$listQuery = 'SELECT count(*) AS count FROM ' . $module->baseTable . '
INNER JOIN vtiger_tab ON vtiger_tab.name = '. $module->baseTable .'.module_name
AND vtiger_tab.presence IN (0,2)';
$sourceModule = $this->get('sourceModule');
if($sourceModule) {
$listQuery .= " WHERE module_name = '$sourceModule'";
}
$search_value = $this->get('search_value');
if(!empty($search_value)) {
$listQuery .= ' AND workflowname like "%'.$search_value.'%"';
}
$listResult = $db->pquery($listQuery, array());
return $db->query_result($listResult, 0, 'count');
}
}