|
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/Picklist/models/ |
Upload File : |
<?php
/*+**********************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.1
* ("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 Settings_Picklist_Field_Model extends Vtiger_Field_Model {
public function isEditable() {
$nonEditablePickListValues = array( 'campaignrelstatus', 'duration_minutes','email_flag','hdnTaxType',
'payment_duration','recurringtype','recurring_frequency','visibility', 'paymentterms', 'modeofpayment', 'paymentgateway');
if(in_array($this->getName(), $nonEditablePickListValues)) return false;
return true;
}
/**
* Function which will give the picklistvalues for given roleids
* @param type $roleIdList -- array of role ids
* @param type $groupMode -- Intersection/Conjuction , intersection will give only picklist values that exist for all roles
* @return type -- array
*/
public function getPicklistValues($roleIdList, $groupMode='INTERSECTION') {
if(!$this->isRoleBased()) {
return parent::getPicklistValues();
}
$intersectionMode = false;
if($groupMode == 'INTERSECTION') {
$intersectionMode = true;
}
if(Vtiger_Cache::get('PicklistRoleBasedValues',$this->getName().implode('_', $roleIdList))){
return Vtiger_Cache::get('PicklistRoleBasedValues',$this->getName().implode('_', $roleIdList));
}
$db = PearDatabase::getInstance();
$fieldName = $this->getName();
$tableName = 'vtiger_'.$fieldName;
$idColName = $fieldName.'id';
$query = 'SELECT '.$fieldName;
if($intersectionMode) {
$query .= ',count(roleid) as rolecount ';
}
$query .= ' FROM vtiger_role2picklist INNER JOIN '.$tableName.' ON vtiger_role2picklist.picklistvalueid = '.$tableName.'.picklist_valueid'.
' WHERE roleid IN ('.generateQuestionMarks($roleIdList).') order by sortorderid';
if($intersectionMode) {
$query .= ' GROUP BY picklistvalueid';
}
$result = $db->pquery($query, $roleIdList);
$pickListValues = array();
$num_rows = $db->num_rows($result);
for($i=0; $i<$num_rows; $i++) {
$rowData = $db->query_result_rowdata($result, $i);
if($intersectionMode) {
//not equal if specify that the picklistvalue is not present for all the roles
if($rowData['rolecount'] != count($roleIdList)){
continue;
}
}
//Need to decode the picklist values twice which are saved from old ui
$pickListValues[$rowData[$fieldName]] = decode_html(decode_html($rowData[$fieldName]));
}
Vtiger_Cache::set('PicklistRoleBasedValues', $fieldName.implode('_', $roleIdList), $pickListValues);
return $pickListValues;
}
/**
* Function to get instance
* @param <String> $value - fieldname or fieldid
* @param <type> $module - optional - module instance
* @return <Vtiger_Field_Model>
*/
public static function getInstance($value, $module = false) {
$fieldObject = parent::getInstance($value, $module);
if($fieldObject) {
return self::getInstanceFromFieldObject($fieldObject);
}
return false;
}
/**
* Static Function to get the instance fo Vtiger Field Model from a given Vtiger_Field object
* @param Vtiger_Field $fieldObj - vtlib field object
* @return Vtiger_Field_Model instance
*/
public static function getInstanceFromFieldObject(Vtiger_Field $fieldObj) {
$objectProperties = get_object_vars($fieldObj);
$fieldModel = new self();
foreach($objectProperties as $properName=>$propertyValue) {
$fieldModel->$properName = $propertyValue;
}
return $fieldModel;
}
/**
* Function which will give the editable picklist values for a field
* @param type $fieldName -- string
* @return type -- array of values
*/
public static function getEditablePicklistValues($fieldName){
$cache = Vtiger_Cache::getInstance();
$EditablePicklistValues = $cache->get('EditablePicklistValues', $fieldName);
if($EditablePicklistValues) {
return $EditablePicklistValues;
}
$db = PearDatabase::getInstance();
$primaryKey = Vtiger_Util_Helper::getPickListId($fieldName);
$query="SELECT $primaryKey ,$fieldName FROM vtiger_$fieldName WHERE presence=1";
$values = array();
$result = $db->pquery($query, array());
$num_rows = $db->num_rows($result);
for($i=0; $i<$num_rows; $i++) {
//Need to decode the picklist values twice which are saved from old ui
$values[$db->query_result($result,$i,$primaryKey)] = decode_html(decode_html($db->query_result($result,$i,$fieldName)));
}
$cache->set('EditablePicklistValues', $fieldName, $values);
return $values;
}
/**
* Function which will give the non editable picklist values for a field
* @param type $fieldName -- string
* @return type -- array of values
*/
public static function getNonEditablePicklistValues($fieldName){
$cache = Vtiger_Cache::getInstance();
$NonEditablePicklistValues = $cache->get('NonEditablePicklistValues', $fieldName);
if($NonEditablePicklistValues) {
return $NonEditablePicklistValues;
}
$db = PearDatabase::getInstance();
$columnIndex = Vtiger_Util_Helper::getPickListId($fieldName);
$query = "select $columnIndex, $fieldName from vtiger_$fieldName where presence=0";
$values = array();
$result = $db->pquery($query, array());
$num_rows = $db->num_rows($result);
for($i=0; $i<$num_rows; $i++) {
//Need to decode the picklist values twice which are saved from old ui
$values[$db->query_result($result,$i,$columnIndex)] = decode_html(decode_html($db->query_result($result,$i,$fieldName)));
}
$cache->set('NonEditablePicklistValues', $fieldName, $values);
return $values;
}
}