| Server IP : 138.197.176.125 / Your IP : 216.73.217.55 Web Server : Apache/2.4.41 (Ubuntu) System : Linux SuiteCRM-8 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64 User : root ( 0) PHP Version : 8.3.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/crm_easylife/modules/Assets/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 Assets_Module_Model extends Vtiger_Module_Model {
public function getQueryByModuleField($sourceModule, $field, $record, $listQuery) {
if ($sourceModule == 'HelpDesk') {
$condition = " vtiger_assets.assetsid NOT IN (SELECT relcrmid FROM vtiger_crmentityrel WHERE crmid = ? UNION SELECT crmid FROM vtiger_crmentityrel WHERE relcrmid = ?) ";
$db = PearDatabase::getInstance();
$condition = $db->convert2Sql($condition, array($record, $record));
$pos = stripos($listQuery, 'where');
if ($pos) {
$split = preg_split('/where/i', $listQuery);
$overRideQuery = $split[0].' WHERE '.$split[1].' AND '.$condition;
} else {
$overRideQuery = $listQuery.' WHERE '.$condition;
}
return $overRideQuery;
}
}
/**
* Function to check whether the module is summary view supported
* @return <Boolean> - true/false
*/
public function isSummaryViewSupported() {
return false;
}
/*
* Function to get supported utility actions for a module
*/
public function getUtilityActionsNames() {
return array('Import', 'Export', 'DuplicatesHandling');
}
}