688 lines
28 KiB
PHP
688 lines
28 KiB
PHP
|
<?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 Vtiger_RelationListView_Model extends Vtiger_Base_Model {
|
||
|
|
|
||
|
|
protected $relationModel = false;
|
||
|
|
protected $parentRecordModel = false;
|
||
|
|
protected $relatedModuleModel = false;
|
||
|
|
|
||
|
|
public function setRelationModel($relation){
|
||
|
|
$this->relationModel = $relation;
|
||
|
|
return $this;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getRelationModel() {
|
||
|
|
return $this->relationModel;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function setParentRecordModel($parentRecord){
|
||
|
|
$this->parentRecordModel = $parentRecord;
|
||
|
|
return $this;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getParentRecordModel(){
|
||
|
|
return $this->parentRecordModel;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function setRelatedModuleModel($relatedModuleModel){
|
||
|
|
$this->relatedModuleModel = $relatedModuleModel;
|
||
|
|
return $this;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getRelatedModuleModel(){
|
||
|
|
return $this->relatedModuleModel;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getCreateViewUrl(){
|
||
|
|
$relationModel = $this->getRelationModel();
|
||
|
|
$relatedModel = $relationModel->getRelationModuleModel();
|
||
|
|
$parentRecordModule = $this->getParentRecordModel();
|
||
|
|
$parentModule = $parentRecordModule->getModule();
|
||
|
|
|
||
|
|
$createViewUrl = $relatedModel->getCreateRecordUrl().'&returnmode=showRelatedList&returntab_label='.$this->tab_label.
|
||
|
|
'&returnrecord='.$parentRecordModule->getId().'&returnmodule='.$parentModule->getName().
|
||
|
|
'&returnview=Detail&returnrelatedModuleName='.$this->getRelatedModuleModel()->getName().
|
||
|
|
'&returnrelationId='.$relationModel->getId();
|
||
|
|
|
||
|
|
if(in_array($relatedModel->getName(), getInventoryModules())){
|
||
|
|
$createViewUrl.='&relationOperation=true';
|
||
|
|
}
|
||
|
|
//To keep the reference fieldname and record value in the url if it is direct relation
|
||
|
|
if($relationModel->isDirectRelation()) {
|
||
|
|
$relationField = $relationModel->getRelationField();
|
||
|
|
$createViewUrl .='&'.$relationField->getName().'='.$parentRecordModule->getId();
|
||
|
|
}
|
||
|
|
|
||
|
|
//if parent module has auto fill data it should be automatically filled
|
||
|
|
$autoFillData = $parentModule->getAutoFillModuleAndField($parentModule->getName());
|
||
|
|
$relatedAutoFillData = $relatedModel->getAutoFillModuleAndField($parentModule->getName());
|
||
|
|
|
||
|
|
if($autoFillData) {
|
||
|
|
//There can be more than one auto-filled field.
|
||
|
|
foreach ($autoFillData as $autoFilledField){
|
||
|
|
$parentAutoFillField = $autoFilledField['fieldname'];
|
||
|
|
$parentAutoFillModule = $autoFilledField['module'];
|
||
|
|
if($parentRecordModule->get($parentAutoFillField)) {
|
||
|
|
if($relatedAutoFillData){
|
||
|
|
foreach ($relatedAutoFillData as $relatedAutoFilledField){
|
||
|
|
$relatedAutoFillFieldName = $relatedAutoFilledField['fieldname'];
|
||
|
|
$relatedAutoFillModuleName = $relatedAutoFilledField['module'];
|
||
|
|
if($parentAutoFillModule === $relatedAutoFillModuleName) {
|
||
|
|
$createViewUrl .= '&'.$relatedAutoFillFieldName.'='.$parentRecordModule->get($parentAutoFillField);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
return $createViewUrl;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getCreateEventRecordUrl(){
|
||
|
|
$relationModel = $this->getRelationModel();
|
||
|
|
$relatedModel = $relationModel->getRelationModuleModel();
|
||
|
|
$parentRecordModule = $this->getParentRecordModel();
|
||
|
|
$parentModule = $parentRecordModule->getModule();
|
||
|
|
|
||
|
|
//SalesPlatform.ru begin
|
||
|
|
//$createViewUrl = $relatedModel->getCreateEventRecordUrl().'&returnmode=showRelatedList&returntab_label='.$relationModel->get('label').
|
||
|
|
$createViewUrl = $relatedModel->getCreateEventRecordUrl().'&returnmode=showRelatedList&returntab_label='. $relationModel->get('label') . '&parent_id=' . $this->parentRecordModel->getId() .
|
||
|
|
//SalesPlatform.ru end
|
||
|
|
'&returnrecord='.$parentRecordModule->getId().'&returnmodule='.$parentModule->get('name').
|
||
|
|
'&returnview=Detail&returnrelatedModuleName=Calendar'.
|
||
|
|
'&returnrelationId='.$relationModel->getId();
|
||
|
|
//To keep the reference fieldname and record value in the url if it is direct relation
|
||
|
|
if($relationModel->isDirectRelation()) {
|
||
|
|
$relationField = $relationModel->getRelationField();
|
||
|
|
$createViewUrl .='&'.$relationField->getName().'='.$parentRecordModule->getId();
|
||
|
|
}
|
||
|
|
return $createViewUrl;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getCreateTaskRecordUrl(){
|
||
|
|
$relationModel = $this->getRelationModel();
|
||
|
|
$relatedModel = $relationModel->getRelationModuleModel();
|
||
|
|
$parentRecordModule = $this->getParentRecordModel();
|
||
|
|
$parentModule = $parentRecordModule->getModule();
|
||
|
|
|
||
|
|
//SalesPlatform.ru begin
|
||
|
|
//$createViewUrl = $relatedModel->getCreateTaskRecordUrl().'&returnmode=showRelatedList&returntab_label='.$relationModel->get('label').
|
||
|
|
$createViewUrl = $relatedModel->getCreateTaskRecordUrl().'&returnmode=showRelatedList&returntab_label='.$relationModel->get('label') . '&parent_id=' . $this->parentRecordModel->getId() .
|
||
|
|
//SalesPlatform.ru end
|
||
|
|
'&returnrecord='.$parentRecordModule->getId().'&returnmodule='.$parentModule->get('name').
|
||
|
|
'&returnview=Detail&returnrelatedModuleName=Calendar'.
|
||
|
|
'&returnrelationId='.$relationModel->getId();
|
||
|
|
|
||
|
|
//To keep the reference fieldname and record value in the url if it is direct relation
|
||
|
|
if($relationModel->isDirectRelation()) {
|
||
|
|
$relationField = $relationModel->getRelationField();
|
||
|
|
$createViewUrl .='&'.$relationField->getName().'='.$parentRecordModule->getId();
|
||
|
|
}
|
||
|
|
return $createViewUrl;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getLinks(){
|
||
|
|
$relationModel = $this->getRelationModel();
|
||
|
|
$actions = $relationModel->getActions();
|
||
|
|
|
||
|
|
$selectLinks = $this->getSelectRelationLinks();
|
||
|
|
foreach($selectLinks as $selectLinkModel) {
|
||
|
|
$selectLinkModel->set('_selectRelation',true)->set('_module',$relationModel->getRelationModuleModel());
|
||
|
|
}
|
||
|
|
$addLinks = $this->getAddRelationLinks();
|
||
|
|
|
||
|
|
$links = array_merge($selectLinks, $addLinks);
|
||
|
|
$relatedLink = array();
|
||
|
|
$relatedLink['LISTVIEWBASIC'] = $links;
|
||
|
|
return $relatedLink;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getSelectRelationLinks() {
|
||
|
|
$relationModel = $this->getRelationModel();
|
||
|
|
$selectLinkModel = array();
|
||
|
|
|
||
|
|
if(!$relationModel->isSelectActionSupported()) {
|
||
|
|
return $selectLinkModel;
|
||
|
|
}
|
||
|
|
|
||
|
|
$relatedModel = $relationModel->getRelationModuleModel();
|
||
|
|
|
||
|
|
$selectLinkList = array(
|
||
|
|
array(
|
||
|
|
'linktype' => 'LISTVIEWBASIC',
|
||
|
|
'linklabel' => vtranslate('LBL_SELECT')." ".vtranslate('SINGLE_'.$relatedModel->getName(), $relatedModel->getName()),
|
||
|
|
'linkurl' => '',
|
||
|
|
'linkicon' => '',
|
||
|
|
'linkmodule' => $relatedModel->getName(),
|
||
|
|
)
|
||
|
|
);
|
||
|
|
|
||
|
|
|
||
|
|
foreach($selectLinkList as $selectLink) {
|
||
|
|
$selectLinkModel[] = Vtiger_Link_Model::getInstanceFromValues($selectLink);
|
||
|
|
}
|
||
|
|
return $selectLinkModel;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getAddRelationLinks() {
|
||
|
|
$relationModel = $this->getRelationModel();
|
||
|
|
$addLinkModel = array();
|
||
|
|
$addLinkList = array();
|
||
|
|
if(!$relationModel->isAddActionSupported()) {
|
||
|
|
return $addLinkModel;
|
||
|
|
}
|
||
|
|
$relatedModel = $relationModel->getRelationModuleModel();
|
||
|
|
|
||
|
|
if($relatedModel->get('label') == 'Calendar'){
|
||
|
|
if($relatedModel->isPermitted('CreateView')) {
|
||
|
|
$addLinkList[] = array(
|
||
|
|
'linktype' => 'LISTVIEWBASIC',
|
||
|
|
'linklabel' => vtranslate('LBL_ADD_EVENT'),
|
||
|
|
'linkurl' => $this->getCreateEventRecordUrl(),
|
||
|
|
'linkicon' => '',
|
||
|
|
'_linklabel' => '_add_event'// used in relatedlist.tpl to identify module to open quickcreate popup
|
||
|
|
);
|
||
|
|
$addLinkList[] = array(
|
||
|
|
'linktype' => 'LISTVIEWBASIC',
|
||
|
|
'linklabel' => vtranslate('LBL_ADD_TASK'),
|
||
|
|
'linkurl' => $this->getCreateTaskRecordUrl(),
|
||
|
|
'linkicon' => '',
|
||
|
|
'_linklabel' => '_add_task'
|
||
|
|
);
|
||
|
|
}
|
||
|
|
} else if ($relatedModel->get('label') == 'Documents') {
|
||
|
|
$parentRecordModule = $this->getParentRecordModel();
|
||
|
|
$parentModule = $parentRecordModule->getModule();
|
||
|
|
$relationParameters = '&sourceModule='.$parentModule->get('name').'&sourceRecord='.$parentRecordModule->getId().'&relationOperation=true';
|
||
|
|
|
||
|
|
if($relationModel->isDirectRelation()) {
|
||
|
|
$relationField = $relationModel->getRelationField();
|
||
|
|
$relationParameters .='&'.$relationField->getName().'='.$parentRecordModule->getId();
|
||
|
|
}
|
||
|
|
$vtigerDocumentTypes = array(
|
||
|
|
array(
|
||
|
|
'type' => 'I',
|
||
|
|
'label' => 'LBL_INTERNAL_DOCUMENT_TYPE',
|
||
|
|
'url' => 'index.php?module=Documents&view=EditAjax&type=I'.$relationParameters
|
||
|
|
),
|
||
|
|
array(
|
||
|
|
'type' => 'E',
|
||
|
|
'label' => 'LBL_EXTERNAL_DOCUMENT_TYPE',
|
||
|
|
'url' => 'index.php?module=Documents&view=EditAjax&type=E'.$relationParameters
|
||
|
|
),
|
||
|
|
array(
|
||
|
|
'type' => 'W',
|
||
|
|
'label' => 'LBL_WEBDOCUMENT_TYPE',
|
||
|
|
'url' => 'index.php?module=Documents&view=EditAjax&type=W'.$relationParameters
|
||
|
|
)
|
||
|
|
);
|
||
|
|
$addLinkList[] = array(
|
||
|
|
'linktype' => 'LISTVIEWBASIC',
|
||
|
|
'linklabel' => 'Vtiger',
|
||
|
|
'linkurl' => $this->getCreateViewUrl(),
|
||
|
|
'linkicon' => 'Vtiger.png',
|
||
|
|
'linkdropdowns' => $vtigerDocumentTypes,
|
||
|
|
'linkclass' => 'addDocumentToVtiger',
|
||
|
|
);
|
||
|
|
}else{
|
||
|
|
if (Users_Privileges_Model::isPermitted($relatedModel->getName(), 'CreateView')) {
|
||
|
|
$addLinkList = array(
|
||
|
|
array(
|
||
|
|
'linktype' => 'LISTVIEWBASIC',
|
||
|
|
// NOTE: $relatedModel->get('label') assuming it to be a module name - we need singular label for Add action.
|
||
|
|
'linklabel' => vtranslate('LBL_ADD')." ".vtranslate('SINGLE_'.$relatedModel->getName(), $relatedModel->getName()),
|
||
|
|
'linkurl' => $this->getCreateViewUrl(),
|
||
|
|
'linkicon' => '',
|
||
|
|
)
|
||
|
|
);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
foreach($addLinkList as $addLink) {
|
||
|
|
$addLinkModel[] = Vtiger_Link_Model::getInstanceFromValues($addLink);
|
||
|
|
}
|
||
|
|
return $addLinkModel;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getEntries($pagingModel) {
|
||
|
|
$db = PearDatabase::getInstance();
|
||
|
|
$parentModule = $this->getParentRecordModel()->getModule();
|
||
|
|
$relationModule = $this->getRelationModel()->getRelationModuleModel();
|
||
|
|
$relationModuleName = $relationModule->get('name');
|
||
|
|
$relatedColumnFields = $relationModule->getConfigureRelatedListFields();
|
||
|
|
if(count($relatedColumnFields) <= 0){
|
||
|
|
$relatedColumnFields = $relationModule->getRelatedListFields();
|
||
|
|
}
|
||
|
|
|
||
|
|
if($relationModuleName == 'Calendar') {
|
||
|
|
//Adding visibility in the related list, showing records based on the visibility
|
||
|
|
$relatedColumnFields['visibility'] = 'visibility';
|
||
|
|
}
|
||
|
|
|
||
|
|
if($relationModuleName == 'PriceBooks') {
|
||
|
|
//Adding fields in the related list
|
||
|
|
$relatedColumnFields['unit_price'] = 'unit_price';
|
||
|
|
$relatedColumnFields['listprice'] = 'listprice';
|
||
|
|
$relatedColumnFields['currency_id'] = 'currency_id';
|
||
|
|
}
|
||
|
|
|
||
|
|
$query = $this->getRelationQuery();
|
||
|
|
|
||
|
|
if ($this->get('whereCondition') && is_array($this->get('whereCondition'))) {
|
||
|
|
$currentUser = Users_Record_Model::getCurrentUserModel();
|
||
|
|
$queryGenerator = new QueryGenerator($relationModuleName, $currentUser);
|
||
|
|
$queryGenerator->setFields(array_values($relatedColumnFields));
|
||
|
|
$whereCondition = $this->get('whereCondition');
|
||
|
|
foreach ($whereCondition as $fieldName => $fieldValue) {
|
||
|
|
if (is_array($fieldValue)) {
|
||
|
|
$comparator = $fieldValue[1];
|
||
|
|
$searchValue = $fieldValue[2];
|
||
|
|
$type = $fieldValue[3];
|
||
|
|
if ($type == 'time') {
|
||
|
|
$searchValue = Vtiger_Time_UIType::getTimeValueWithSeconds($searchValue);
|
||
|
|
}
|
||
|
|
$queryGenerator->addCondition($fieldName, $searchValue, $comparator, "AND");
|
||
|
|
}
|
||
|
|
}
|
||
|
|
$whereQuerySplit = split("WHERE", $queryGenerator->getWhereClause());
|
||
|
|
$query.=" AND " . $whereQuerySplit[1];
|
||
|
|
}
|
||
|
|
|
||
|
|
$startIndex = $pagingModel->getStartIndex();
|
||
|
|
$pageLimit = $pagingModel->getPageLimit();
|
||
|
|
|
||
|
|
$orderBy = $this->getForSql('orderby');
|
||
|
|
$sortOrder = $this->getForSql('sortorder');
|
||
|
|
|
||
|
|
if($orderBy) {
|
||
|
|
|
||
|
|
$orderByFieldModuleModel = $relationModule->getFieldByColumn($orderBy);
|
||
|
|
if($orderByFieldModuleModel && $orderByFieldModuleModel->isReferenceField()) {
|
||
|
|
//If reference field then we need to perform a join with crmentity with the related to field
|
||
|
|
$queryComponents = $split = preg_split('/ where /i', $query);
|
||
|
|
$selectAndFromClause = $queryComponents[0];
|
||
|
|
$whereCondition = $queryComponents[1];
|
||
|
|
$qualifiedOrderBy = 'vtiger_crmentity'.$orderByFieldModuleModel->get('column');
|
||
|
|
$selectAndFromClause .= ' LEFT JOIN vtiger_crmentity AS '.$qualifiedOrderBy.' ON '.
|
||
|
|
$orderByFieldModuleModel->get('table').'.'.$orderByFieldModuleModel->get('column').' = '.
|
||
|
|
$qualifiedOrderBy.'.crmid ';
|
||
|
|
$query = $selectAndFromClause.' WHERE '.$whereCondition;
|
||
|
|
$query .= ' ORDER BY '.$qualifiedOrderBy.'.label '.$sortOrder;
|
||
|
|
} elseif($orderByFieldModuleModel && $orderByFieldModuleModel->isOwnerField()) {
|
||
|
|
$query .= ' ORDER BY COALESCE(CONCAT(vtiger_users.first_name,vtiger_users.last_name),vtiger_groups.groupname) '.$sortOrder;
|
||
|
|
} else{
|
||
|
|
// Qualify the the column name with table to remove ambugity
|
||
|
|
$qualifiedOrderBy = $orderBy;
|
||
|
|
$orderByField = $relationModule->getFieldByColumn($orderBy);
|
||
|
|
if ($orderByField) {
|
||
|
|
$qualifiedOrderBy = $relationModule->getOrderBySql($qualifiedOrderBy);
|
||
|
|
}
|
||
|
|
if($qualifiedOrderBy == 'vtiger_activity.date_start' && ($relationModuleName == 'Calendar' || $relationModuleName == 'Emails')) {
|
||
|
|
$qualifiedOrderBy = "str_to_date(concat(vtiger_activity.date_start,vtiger_activity.time_start),'%Y-%m-%d %H:%i:%s')";
|
||
|
|
}
|
||
|
|
$query = "$query ORDER BY $qualifiedOrderBy $sortOrder";
|
||
|
|
}
|
||
|
|
} else if($relationModuleName == 'HelpDesk' && empty($orderBy) && empty($sortOrder) && $moduleName != "Users") {
|
||
|
|
$query .= ' ORDER BY vtiger_crmentity.modifiedtime DESC';
|
||
|
|
}
|
||
|
|
|
||
|
|
$limitQuery = $query .' LIMIT '.$startIndex.','.$pageLimit;
|
||
|
|
$result = $db->pquery($limitQuery, array());
|
||
|
|
$relatedRecordList = array();
|
||
|
|
$currentUser = Users_Record_Model::getCurrentUserModel();
|
||
|
|
$groupsIds = Vtiger_Util_Helper::getGroupsIdsForUsers($currentUser->getId());
|
||
|
|
$recordsToUnset = array();
|
||
|
|
for($i=0; $i< $db->num_rows($result); $i++ ) {
|
||
|
|
$row = $db->fetch_row($result,$i);
|
||
|
|
$newRow = array();
|
||
|
|
foreach($row as $col=>$val){
|
||
|
|
if(array_key_exists($col,$relatedColumnFields)){
|
||
|
|
$newRow[$relatedColumnFields[$col]] = $val;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
//To show the value of "Assigned to"
|
||
|
|
$ownerId = $row['smownerid'];
|
||
|
|
$newRow['assigned_user_id'] = $row['smownerid'];
|
||
|
|
if($relationModuleName == 'Calendar') {
|
||
|
|
$visibleFields = array('activitytype','date_start','time_start','due_date','time_end','assigned_user_id','visibility','smownerid','parent_id');
|
||
|
|
$visibility = true;
|
||
|
|
if(in_array($ownerId, $groupsIds)) {
|
||
|
|
$visibility = false;
|
||
|
|
} else if($ownerId == $currentUser->getId()){
|
||
|
|
$visibility = false;
|
||
|
|
}
|
||
|
|
if(!$currentUser->isAdminUser() && $newRow['activitytype'] != 'Task' && $newRow['visibility'] == 'Private' && $ownerId && $visibility) {
|
||
|
|
foreach($newRow as $data => $value) {
|
||
|
|
if(in_array($data, $visibleFields) != -1) {
|
||
|
|
unset($newRow[$data]);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
$newRow['subject'] = vtranslate('Busy','Events').'*';
|
||
|
|
}
|
||
|
|
if($newRow['activitytype'] == 'Task') {
|
||
|
|
unset($newRow['visibility']);
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
//SalesPlatform.ru begin
|
||
|
|
if ($relationModuleName == 'PBXManager') {
|
||
|
|
$recordingUrl = $row['recordingurl'];
|
||
|
|
if (!empty($recordingUrl) && $row['callstatus'] == 'completed') {
|
||
|
|
$row['recordingurl'] = '<audio preload="metadata" src="index.php?module=PBXManager&action=ListenRecord&record='.$row['crmid'].'" controls>
|
||
|
|
<a href="index.php?module=PBXManager&action=ListenRecord&record='.$row['crmid'].'" ><i class="icon-volume-up"></i></a>
|
||
|
|
</audio>';
|
||
|
|
$newRow['recordingurl'] = $row['recordingurl'];
|
||
|
|
} else {
|
||
|
|
$newRow['recordingurl'] = '';
|
||
|
|
$row['recordingurl'] = '';
|
||
|
|
}
|
||
|
|
|
||
|
|
/* Handle call status */
|
||
|
|
$callStatus = $row['callstatus'];
|
||
|
|
if(!empty($callStatus)) {
|
||
|
|
$direction = $row['direction'];
|
||
|
|
$row['callstatus'] = $this->getCallStatusDisplay($direction, $callStatus, $relationModuleName);
|
||
|
|
$newRow['callstatus'] = $row['callstatus'];
|
||
|
|
}
|
||
|
|
}
|
||
|
|
//SalesPlatofrm.ru end
|
||
|
|
|
||
|
|
$record = Vtiger_Record_Model::getCleanInstance($relationModule->get('name'));
|
||
|
|
$record->setData($newRow)->setModuleFromInstance($relationModule)->setRawData($row);
|
||
|
|
$record->setId($row['crmid']);
|
||
|
|
$relatedRecordList[$row['crmid']] = $record;
|
||
|
|
if($relationModuleName == 'Calendar' && !$currentUser->isAdminUser() && $newRow['activitytype'] == 'Task' && isToDoPermittedBySharing($row['crmid']) == 'no') {
|
||
|
|
$recordsToUnset[] = $row['crmid'];
|
||
|
|
}
|
||
|
|
}
|
||
|
|
$pagingModel->calculatePageRange($relatedRecordList);
|
||
|
|
|
||
|
|
$nextLimitQuery = $query. ' LIMIT '.($startIndex+$pageLimit).' , 1';
|
||
|
|
$nextPageLimitResult = $db->pquery($nextLimitQuery, array());
|
||
|
|
if($db->num_rows($nextPageLimitResult) > 0){
|
||
|
|
$pagingModel->set('nextPageExists', true);
|
||
|
|
}else{
|
||
|
|
$pagingModel->set('nextPageExists', false);
|
||
|
|
}
|
||
|
|
//setting related list view count before unsetting permission denied records - to make sure paging should not fail
|
||
|
|
$pagingModel->set('_relatedlistcount', count($relatedRecordList));
|
||
|
|
foreach($recordsToUnset as $record) {
|
||
|
|
unset($relatedRecordList[$record]);
|
||
|
|
}
|
||
|
|
|
||
|
|
return $relatedRecordList;
|
||
|
|
}
|
||
|
|
|
||
|
|
//SalesPlatform.ru begin
|
||
|
|
private function getCallStatusDisplay($direction, $callStatus, $moduleName) {
|
||
|
|
$status = $callStatus;
|
||
|
|
if ($direction == 'outbound') {
|
||
|
|
if ($callStatus == 'ringing' || $callStatus == 'in-progress') {
|
||
|
|
$status = '<span class="label label-info"><i class="fa fa-arrow-up">
|
||
|
|
</i> ' . vtranslate($callStatus, $moduleName) . '</span>';
|
||
|
|
} else if ($callStatus == 'completed') {
|
||
|
|
$status = '<span class="label label-success"><i class="fa fa-arrow-up">
|
||
|
|
</i> ' . vtranslate($callStatus, $moduleName) . '</span>';
|
||
|
|
} else if ($callStatus == 'no-answer') {
|
||
|
|
$status = '<span class="label label-danger"><i class="fa fa-arrow-up">
|
||
|
|
</i> ' . vtranslate($callStatus, $moduleName) . '</span>';
|
||
|
|
} else {
|
||
|
|
$status = '<span class="label label-warning"><i class="fa fa-arrow-up">
|
||
|
|
</i> ' . vtranslate($callStatus, $moduleName) . '</span>';
|
||
|
|
}
|
||
|
|
} else if ($direction == 'inbound') {
|
||
|
|
if ($callStatus == 'ringing' || $callStatus == 'in-progress') {
|
||
|
|
$status = '<span class="label label-info"><i class="fa fa-arrow-down">
|
||
|
|
</i> ' . vtranslate($callStatus, $moduleName) . '</span>';
|
||
|
|
} else if ($callStatus == 'completed') {
|
||
|
|
$status = '<span class="label label-success"><i class="fa fa-arrow-down">
|
||
|
|
</i> ' . vtranslate($callStatus, $moduleName) . '</span>';
|
||
|
|
} else if ($callStatus == 'no-answer') {
|
||
|
|
$status = '<span class="label label-danger"><i class="fa fa-arrow-down">
|
||
|
|
</i> ' . vtranslate($callStatus, $moduleName) . '</span>';
|
||
|
|
} else {
|
||
|
|
$status = '<span class="label label-warning"><i class="fa fa-arrow-down">
|
||
|
|
</i> ' . vtranslate($callStatus, $moduleName) . '</span>';
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
return $status;
|
||
|
|
}
|
||
|
|
//SalesPlatform.ru end
|
||
|
|
|
||
|
|
public function getHeaders() {
|
||
|
|
$relationModel = $this->getRelationModel();
|
||
|
|
$relatedModuleModel = $relationModel->getRelationModuleModel();
|
||
|
|
|
||
|
|
$summaryFieldsList = $relatedModuleModel->getHeaderAndSummaryViewFieldsList();
|
||
|
|
|
||
|
|
$headerFields = array();
|
||
|
|
if(count($summaryFieldsList) > 0) {
|
||
|
|
foreach($summaryFieldsList as $fieldName => $fieldModel) {
|
||
|
|
$headerFields[$fieldName] = $fieldModel;
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
$headerFieldNames = $relatedModuleModel->getRelatedListFields();
|
||
|
|
foreach($headerFieldNames as $fieldName) {
|
||
|
|
$headerFields[$fieldName] = $relatedModuleModel->getField($fieldName);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$nameFields = $relatedModuleModel->getNameFields();
|
||
|
|
foreach($nameFields as $fieldName){
|
||
|
|
if(!$headerFields[$fieldName]) {
|
||
|
|
$headerFields[$fieldName] = $relatedModuleModel->getField($fieldName);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
return $headerFields;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Function to get Relation query
|
||
|
|
* @return <String>
|
||
|
|
*/
|
||
|
|
public function getRelationQuery() {
|
||
|
|
$relationModel = $this->getRelationModel();
|
||
|
|
|
||
|
|
if(!empty($relationModel) && $relationModel->get('name') != NULL){
|
||
|
|
$recordModel = $this->getParentRecordModel();
|
||
|
|
$query = $relationModel->getQuery($recordModel);
|
||
|
|
return $query;
|
||
|
|
}
|
||
|
|
$relatedModuleModel = $this->getRelatedModuleModel();
|
||
|
|
$relatedModuleName = $relatedModuleModel->getName();
|
||
|
|
|
||
|
|
$relatedModuleBaseTable = $relatedModuleModel->basetable;
|
||
|
|
$relatedModuleEntityIdField = $relatedModuleModel->basetableid;
|
||
|
|
|
||
|
|
$parentModuleModel = $relationModel->getParentModuleModel();
|
||
|
|
$parentModuleBaseTable = $parentModuleModel->basetable;
|
||
|
|
$parentModuleEntityIdField = $parentModuleModel->basetableid;
|
||
|
|
$parentRecordId = $this->getParentRecordModel()->getId();
|
||
|
|
$parentModuleDirectRelatedField = $parentModuleModel->get('directRelatedFieldName');
|
||
|
|
|
||
|
|
$relatedModuleFields = array_keys($this->getHeaders());
|
||
|
|
$currentUserModel = Users_Record_Model::getCurrentUserModel();
|
||
|
|
$queryGenerator = new QueryGenerator($relatedModuleName, $currentUserModel);
|
||
|
|
$queryGenerator->setFields($relatedModuleFields);
|
||
|
|
|
||
|
|
$query = $queryGenerator->getQuery();
|
||
|
|
|
||
|
|
$queryComponents = preg_split('/ FROM /i', $query);
|
||
|
|
$query = $queryComponents[0].' ,vtiger_crmentity.crmid FROM '.$queryComponents[1];
|
||
|
|
|
||
|
|
$whereSplitQueryComponents = preg_split('/ WHERE /i', $query);
|
||
|
|
$joinQuery = ' INNER JOIN '.$parentModuleBaseTable.' ON '.$parentModuleBaseTable.'.'.$parentModuleDirectRelatedField." = ".$relatedModuleBaseTable.'.'.$relatedModuleEntityIdField;
|
||
|
|
|
||
|
|
$query = "$whereSplitQueryComponents[0] $joinQuery WHERE $parentModuleBaseTable.$parentModuleEntityIdField = $parentRecordId AND $whereSplitQueryComponents[1]";
|
||
|
|
|
||
|
|
return $query;
|
||
|
|
}
|
||
|
|
|
||
|
|
public static function getInstance($parentRecordModel, $relationModuleName, $label=false) {
|
||
|
|
$parentModuleName = $parentRecordModel->getModule()->get('name');
|
||
|
|
$className = Vtiger_Loader::getComponentClassName('Model', 'RelationListView', $parentModuleName);
|
||
|
|
$instance = new $className();
|
||
|
|
|
||
|
|
$parentModuleModel = $parentRecordModel->getModule();
|
||
|
|
$relatedModuleModel = Vtiger_Module_Model::getInstance($relationModuleName);
|
||
|
|
$instance->setRelatedModuleModel($relatedModuleModel);
|
||
|
|
|
||
|
|
$relationModel = Vtiger_Relation_Model::getInstance($parentModuleModel, $relatedModuleModel, $label);
|
||
|
|
$instance->setParentRecordModel($parentRecordModel);
|
||
|
|
|
||
|
|
if(!$relationModel){
|
||
|
|
$relatedModuleName = $relatedModuleModel->getName();
|
||
|
|
$parentModuleModel = $instance->getParentRecordModel()->getModule();
|
||
|
|
$referenceFieldOfParentModule = $parentModuleModel->getFieldsByType('reference');
|
||
|
|
foreach ($referenceFieldOfParentModule as $fieldName=>$fieldModel) {
|
||
|
|
$refredModulesOfReferenceField = $fieldModel->getReferenceList();
|
||
|
|
if(in_array($relatedModuleName, $refredModulesOfReferenceField)){
|
||
|
|
$relationModelClassName = Vtiger_Loader::getComponentClassName('Model', 'Relation', $parentModuleModel->getName());
|
||
|
|
$relationModel = new $relationModelClassName();
|
||
|
|
$relationModel->setParentModuleModel($parentModuleModel)->setRelationModuleModel($relatedModuleModel);
|
||
|
|
$parentModuleModel->set('directRelatedFieldName',$fieldModel->get('column'));
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
if(!$relationModel){
|
||
|
|
$relationModel = false;
|
||
|
|
}
|
||
|
|
$instance->setRelationModel($relationModel);
|
||
|
|
return $instance;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Function to get Total number of record in this relation
|
||
|
|
* @return <Integer>
|
||
|
|
*/
|
||
|
|
public function getRelatedEntriesCount() {
|
||
|
|
$db = PearDatabase::getInstance();
|
||
|
|
$currentUser = Users_Record_Model::getCurrentUserModel();
|
||
|
|
$realtedModuleModel = $this->getRelatedModuleModel();
|
||
|
|
$relatedModuleName = $realtedModuleModel->getName();
|
||
|
|
$relationQuery = $this->getRelationQuery();
|
||
|
|
$relationQuery = preg_replace("/[ \t\n\r]+/", " ", $relationQuery);
|
||
|
|
$position = stripos($relationQuery,' from ');
|
||
|
|
if ($position) {
|
||
|
|
$split = preg_split('/ FROM /i', $relationQuery);
|
||
|
|
$splitCount = count($split);
|
||
|
|
if($relatedModuleName == 'Calendar') {
|
||
|
|
$relationQuery = 'SELECT DISTINCT vtiger_crmentity.crmid, vtiger_activity.activitytype ';
|
||
|
|
} else {
|
||
|
|
$relationQuery = 'SELECT COUNT(DISTINCT vtiger_crmentity.crmid) AS count';
|
||
|
|
}
|
||
|
|
for ($i=1; $i<$splitCount; $i++) {
|
||
|
|
$relationQuery = $relationQuery. ' FROM ' .$split[$i];
|
||
|
|
}
|
||
|
|
}
|
||
|
|
if(strpos($relationQuery,' GROUP BY ') !== false){
|
||
|
|
$parts = explode(' GROUP BY ',$relationQuery);
|
||
|
|
$relationQuery = $parts[0];
|
||
|
|
}
|
||
|
|
$result = $db->pquery($relationQuery, array());
|
||
|
|
if ($result) {
|
||
|
|
if($relatedModuleName == 'Calendar') {
|
||
|
|
$count = 0;
|
||
|
|
for($i=0;$i<$db->num_rows($result);$i++) {
|
||
|
|
$id = $db->query_result($result, $i, 'crmid');
|
||
|
|
$activityType = $db->query_result($result, $i, 'activitytype');
|
||
|
|
if(!$currentUser->isAdminUser() && $activityType == 'Task' && isToDoPermittedBySharing($id) == 'no') {
|
||
|
|
continue;
|
||
|
|
} else {
|
||
|
|
$count++;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
return $count;
|
||
|
|
} else {
|
||
|
|
return $db->query_result($result, 0, 'count');
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
return 0;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Function to update relation query
|
||
|
|
* @param <String> $relationQuery
|
||
|
|
* @return <String> $updatedQuery
|
||
|
|
*/
|
||
|
|
public function updateQueryWithWhereCondition($relationQuery) {
|
||
|
|
$condition = '';
|
||
|
|
|
||
|
|
$whereCondition = $this->get("whereCondition");
|
||
|
|
$count = count($whereCondition);
|
||
|
|
if ($count > 1) {
|
||
|
|
$appendAndCondition = true;
|
||
|
|
}
|
||
|
|
|
||
|
|
$i = 1;
|
||
|
|
foreach ($whereCondition as $fieldName => $fieldValue) {
|
||
|
|
if(is_array($fieldValue)){
|
||
|
|
$fieldColumn = $fieldValue[0];
|
||
|
|
$comparator = $fieldValue[1];
|
||
|
|
$value = $fieldValue[2];
|
||
|
|
if($comparator == "c"){
|
||
|
|
$condition .= "$fieldColumn like '%$value%' ";
|
||
|
|
}else{
|
||
|
|
$condition .= "$fieldColumn = '$value' ";
|
||
|
|
}
|
||
|
|
}else {
|
||
|
|
$condition .= " $fieldName = '$fieldValue' ";
|
||
|
|
}
|
||
|
|
if ($appendAndCondition && ($i++ != $count)) {
|
||
|
|
$condition .= " AND ";
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$pos = stripos($relationQuery, 'where');
|
||
|
|
if ($pos) {
|
||
|
|
$split = preg_split('/where/i', $relationQuery);
|
||
|
|
$updatedQuery = $split[0].' WHERE '.$split[1].' AND '.$condition;
|
||
|
|
} else {
|
||
|
|
$updatedQuery = $relationQuery.' WHERE '.$condition;
|
||
|
|
}
|
||
|
|
return $updatedQuery;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getCurrencySymbol($recordId, $fieldModel) {
|
||
|
|
$db = PearDatabase::getInstance();
|
||
|
|
$moduleName = $fieldModel->getModuleName();
|
||
|
|
$fieldName = $fieldModel->get('name');
|
||
|
|
$tableName = $fieldModel->get('table');
|
||
|
|
$columnName = $fieldModel->get('column');
|
||
|
|
|
||
|
|
if(($fieldName == 'unit_price') && ($moduleName == 'Products' || $moduleName == 'Services')) {
|
||
|
|
$query = "SELECT currency_symbol FROM vtiger_currency_info WHERE id = (";
|
||
|
|
if($moduleName == 'Products')
|
||
|
|
$query .= "SELECT currency_id FROM vtiger_products WHERE productid = ?)";
|
||
|
|
else if($moduleName == 'Services')
|
||
|
|
$query .= "SELECT currency_id FROM vtiger_service WHERE serviceid = ?)";
|
||
|
|
|
||
|
|
$result = $db->pquery($query, array($recordId));
|
||
|
|
return $db->query_result($result, 0, 'currency_symbol');
|
||
|
|
} else if(($tableName == 'vtiger_invoice' || $tableName == 'vtiger_quotes' || $tableName == 'vtiger_purchaseorder' || $tableName == 'vtiger_salesorder') &&
|
||
|
|
($columnName == 'total' || $columnName == 'subtotal' || $columnName == 'discount_amount' || $columnName == 's_h_amount' || $columnName == 'paid' ||
|
||
|
|
$columnName == 'balance' || $columnName == 'received' || $columnName == 'listprice' || $columnName == 'adjustment' || $columnName == 'pre_tax_total')) {
|
||
|
|
$focus = CRMEntity::getInstance($moduleName);
|
||
|
|
$query = "SELECT currency_symbol FROM vtiger_currency_info WHERE id = ( SELECT currency_id FROM ".$tableName." WHERE ".$focus->table_index." = ? )";
|
||
|
|
$result = $db->pquery($query, array($recordId));
|
||
|
|
return $db->query_result($result, 0, 'currency_symbol');
|
||
|
|
} else {
|
||
|
|
$fieldInfo = $fieldModel->getFieldInfo();
|
||
|
|
return $fieldInfo['currency_symbol'];
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|