|
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/Documents/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.
*************************************************************************************/
class Documents_ListView_Model extends Vtiger_ListView_Model {
/**
* Function to get the list of listview links for the module
* @param <Array> $linkParams
* @return <Array> - Associate array of Link Type to List of Vtiger_Link_Model instances
*/
public function getListViewLinks($linkParams) {
$currentUserModel = Users_Record_Model::getCurrentUserModel();
$moduleModel = $this->getModule();
$linkTypes = array('LISTVIEWBASIC', 'LISTVIEW', 'LISTVIEWSETTING');
$links = Vtiger_Link_Model::getAllByType($moduleModel->getId(), $linkTypes, $linkParams);
$createPermission = Users_Privileges_Model::isPermitted($moduleModel->getName(), 'CreateView');
if($createPermission) {
$vtigerDocumentTypes = array(
array(
'type' => 'I',
'label' => 'LBL_INTERNAL_DOCUMENT_TYPE',
'url' => 'index.php?module=Documents&view=EditAjax&type=I'
),
array(
'type' => 'E',
'label' => 'LBL_EXTERNAL_DOCUMENT_TYPE',
'url' => 'index.php?module=Documents&view=EditAjax&type=E'
),
array(
'type' => 'W',
'label' => 'LBL_WEBDOCUMENT_TYPE',
'url' => 'index.php?module=Documents&view=EditAjax&type=W'
)
);
$basicLinks = array(
array(
'linktype' => 'LISTVIEWBASIC',
'linklabel' => 'Vtiger',
'linkurl' => $moduleModel->getCreateRecordUrl(),
'linkicon' => 'Vtiger.png',
'linkdropdowns' => $vtigerDocumentTypes,
'linkclass' => 'addDocumentToVtiger',
),
array(
'linktype' => 'LISTVIEWBASIC',
'linklabel' => 'LBL_ADD_FOLDER',
'linkurl' => 'javascript:Documents_List_Js.triggerAddFolder("'.$moduleModel->getAddFolderUrl().'")',
'linkicon' => ''
)
);
foreach($basicLinks as $basicLink) {
$links['LISTVIEWBASIC'][] = Vtiger_Link_Model::getInstanceFromValues($basicLink);
}
}
$exportPermission = Users_Privileges_Model::isPermitted($moduleModel->getName(), 'Export');
if($exportPermission) {
$advancedLink = array(
'linktype' => 'LISTVIEW',
'linklabel' => 'LBL_EXPORT',
'linkurl' => 'javascript:Vtiger_List_Js.triggerExportAction("'.$moduleModel->getExportUrl().'")',
'linkicon' => ''
);
$links['LISTVIEW'][] = Vtiger_Link_Model::getInstanceFromValues($advancedLink);
}
if($currentUserModel->isAdminUser()) {
$settingsLinks = $this->getSettingLinks();
foreach($settingsLinks as $settingsLink) {
$links['LISTVIEWSETTING'][] = Vtiger_Link_Model::getInstanceFromValues($settingsLink);
}
}
return $links;
}
/**
* Function to get the list of Mass actions for the module
* @param <Array> $linkParams
* @return <Array> - Associative array of Link type to List of Vtiger_Link_Model instances for Mass Actions
*/
public function getListViewMassActions($linkParams) {
$currentUserModel = Users_Privileges_Model::getCurrentUserPrivilegesModel();
$moduleModel = $this->getModule();
$linkTypes = array('LISTVIEWMASSACTION');
$links = Vtiger_Link_Model::getAllByType($moduleModel->getId(), $linkTypes, $linkParams);
//Opensource fix to make documents module mass editable
if($currentUserModel->hasModuleActionPermission($moduleModel->getId(), 'EditView')) {
$massActionLink = array(
'linktype' => 'LISTVIEWMASSACTION',
'linklabel' => 'LBL_EDIT',
'linkurl' => 'javascript:Vtiger_List_Js.triggerMassEdit("index.php?module='.$moduleModel->get('name').'&view=MassActionAjax&mode=showMassEditForm");',
'linkicon' => ''
);
$links['LISTVIEWMASSACTION'][] = Vtiger_Link_Model::getInstanceFromValues($massActionLink);
}
if ($currentUserModel->hasModuleActionPermission($moduleModel->getId(), 'Delete')) {
$massActionLink = array(
'linktype' => 'LISTVIEWMASSACTION',
'linklabel' => 'LBL_DELETE',
'linkurl' => 'javascript:Vtiger_List_Js.massDeleteRecords("index.php?module=' . $moduleModel->getName() . '&action=MassDelete");',
'linkicon' => ''
);
$links['LISTVIEWMASSACTION'][] = Vtiger_Link_Model::getInstanceFromValues($massActionLink);
}
$massActionLink = array(
'linktype' => 'LISTVIEWMASSACTION',
'linklabel' => 'LBL_MOVE',
'linkurl' => 'javascript:Documents_List_Js.massMove("index.php?module=' . $moduleModel->getName() . '&view=MoveDocuments");',
'linkicon' => ''
);
$links['LISTVIEWMASSACTION'][] = Vtiger_Link_Model::getInstanceFromValues($massActionLink);
return $links;
}
/**
* 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');
$folderKey = $this->get('folder_id');
$folderValue = $this->get('folder_value');
if(!empty($folderValue)) {
// added to check if there are filter conditions already there then we need to add a glue between them
$glue = "";
if(count($queryGenerator->getWhereFields()) > 0) {
$glue = QueryGenerator::$AND;
}
$queryGenerator->addCondition($folderKey,$folderValue,'e',$glue);
}
$searchParams = $this->get('search_params');
if(empty($searchParams)) {
$searchParams = array();
}
$glue = "";
if(count($queryGenerator->getWhereFields()) > 0 && (count($searchParams)) == 1 && count($searchParams[0]) > 0) { // searchParams do exist but first array is empty, so added a check
$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->get('orderby');
$sortOrder = $this->get('sortorder');
if(!empty($orderBy)){
$queryGenerator = $this->get('query_generator');
$fieldModels = $queryGenerator->getModuleFields();
$orderByFieldModel = $fieldModels[$orderBy];
if($orderByFieldModel && ($orderByFieldModel->getFieldDataType() == Vtiger_Field_Model::REFERENCE_TYPE ||
$orderByFieldModel->getFieldDataType() == Vtiger_Field_Model::OWNER_TYPE)){
$queryGenerator->addWhereField($orderBy);
}
}
//Document source required in list view for managing delete
$listViewFields = $queryGenerator->getFields();
if(!in_array('document_source', $listViewFields)){
$listViewFields[] = 'document_source';
}
$queryGenerator->setFields($listViewFields);
$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;
}
}
//allow source module to modify the query
$sourceModuleModel = Vtiger_Module_Model::getInstance($sourceModule);
if(method_exists($sourceModuleModel, 'getQueryByModuleField')) {
$sourceOverrideQuery = $sourceModuleModel->getQueryByModuleField($moduleModel->getName(),$this->get('src_field'),$this->get('src_record'),$listQuery);
if(!empty($sourceOverrideQuery)) {
$listQuery = $sourceOverrideQuery;
}
}
}
$startIndex = $pagingModel->getStartIndex();
$pageLimit = $pagingModel->getPageLimit();
if(!empty($orderBy) && $orderByFieldModel) {
$listQuery .= ' ORDER BY '.$queryGenerator->getOrderByColumn($orderBy).' '.$sortOrder;
} else if(empty($orderBy) && empty($sortOrder)){
//List view will be displayed on recently created/modified records
$listQuery .= ' ORDER BY vtiger_crmentity.modifiedtime DESC';
}
$viewid = ListViewSession::getCurrentView($moduleName);
if(empty($viewid)){
$viewid = $pagingModel->get('viewid');
}
$_SESSION['lvs'][$moduleName][$viewid]['start'] = $pagingModel->get('page');
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);
}
$index = 0;
foreach($listViewEntries as $recordId => $record) {
$rawData = $db->query_result_rowdata($listResult, $index++);
$record['id'] = $recordId;
$listViewRecordModels[$recordId] = $moduleModel->getRecordFromArray($record, $rawData);
}
return $listViewRecordModels;
}
}