|
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/public_html/crm/modules/Vtiger/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.
*************************************************************************************/
include_once 'vtlib/Vtiger/Field.php';
/**
* Vtiger Field Model Class
*/
class Vtiger_Field_Model extends Vtiger_Field {
var $webserviceField = false;
const REFERENCE_TYPE = 'reference';
const OWNER_TYPE = 'owner';
const OWNERGROUP_TYPE = 'group';
const CURRENCY_LIST = 'currencyList';
const QUICKCREATE_MANDATORY = 0;
const QUICKCREATE_NOT_ENABLED = 1;
const QUICKCREATE_ENABLED = 2;
const QUICKCREATE_NOT_PERMITTED = 3;
/**
* Function to get the value of a given property
* @param <String> $propertyName
* @return <Object>
* @throws Exception
*/
public function get($propertyName) {
if(property_exists($this,$propertyName)) {
return $this->$propertyName;
}
return null;
}
/**
* Function which sets value for given name
* @param <String> $name - name for which value need to be assinged
* @param <type> $value - values that need to be assigned
* @return Vtiger_Field_Model
*/
public function set($name, $value) {
$this->$name = $value;
return $this;
}
/**
* Function to get the Field Id
* @return <Number>
*/
public function getId() {
return $this->id;
}
public function getName() {
return $this->name;
}
public function getFieldName() {
return $this->name;
}
/**
* Function to retrieve full data
* @return <array>
*/
public function getData(){
return get_object_vars($this);
}
public function getModule() {
if(!$this->module) {
$moduleObj = $this->block->module;
if(empty($moduleObj)) {
return false;
}
$this->module = Vtiger_Module_Model::getInstanceFromModuleObject($moduleObj);
}
return $this->module;
}
public function setModule($moduleInstance) {
$this->module = $moduleInstance;
}
/**
* Function to retieve display value for a value
* @param <String> $value - value which need to be converted to display value
* @return <String> - converted display value
*/
public function getDisplayValue($value, $record=false, $recordInstance = false) {
if(!$this->uitype_instance) {
$this->uitype_instance = Vtiger_Base_UIType::getInstanceFromField($this);
}
$uiTypeInstance = $this->uitype_instance;
return $uiTypeInstance->getDisplayValue($value, $record, $recordInstance);
}
/**
* Function to retrieve display type of a field
* @return <String> - display type of the field
*/
public function getDisplayType() {
return $this->get('displaytype');
}
/**
* Function to get the Webservice Field Object for the current Field Object
* @return WebserviceField instance
*/
public function getWebserviceFieldObject() {
if($this->webserviceField == false) {
$db = PearDatabase::getInstance();
$row = array();
$row['uitype'] = $this->get('uitype');
$row['block'] = $this->get('block');
$row['tablename'] = $this->get('table');
$row['columnname'] = $this->get('column');
$row['fieldname'] = $this->get('name');
$row['fieldlabel'] = $this->get('label');
$row['displaytype'] = $this->get('displaytype');
$row['masseditable'] = $this->get('masseditable');
$row['typeofdata'] = $this->get('typeofdata');
$row['presence'] = $this->get('presence');
$row['tabid'] = $this->getModuleId();
$row['fieldid'] = $this->get('id');
$row['readonly'] = !$this->getProfileReadWritePermission();
$row['defaultvalue'] = $this->get('defaultvalue');
$this->webserviceField = WebserviceField::fromArray($db, $row);
}
return $this->webserviceField;
}
/**
* Function to get the Webservice Field data type
* @return <String> Data type of the field
*/
public function getFieldDataType() {
if(!$this->fieldDataType) {
$uiType = $this->get('uitype');
if($uiType == '69') {
$fieldDataType = 'image';
} else if($uiType == '26') {
$fieldDataType = 'documentsFolder';
} else if($uiType == '27') {
$fieldDataType = 'fileLocationType';
} else if($uiType == '9') {
$fieldDataType = 'percentage';
} else if($uiType == '28') {
$fieldDataType = 'documentsFileUpload';
} else if($uiType == '83') {
$fieldDataType = 'productTax';
} else if($uiType == '117') {
$fieldDataType = 'currencyList';
} else if($uiType == '55' && stripos($this->getName(), 'salutationtype') !== false) {
$fieldDataType = 'picklist';
} else if($uiType == '55' && stripos($this->getName(), 'firstname') !== false) {
$fieldDataType = 'salutation';
} else if($uiType == '55' && stripos($this->getName(), 'roundrobin_userid') !== false) {
$fieldDataType = 'multiowner';
} else {
$webserviceField = $this->getWebserviceFieldObject();
$fieldDataType = $webserviceField->getFieldDataType();
}
$this->fieldDataType = $fieldDataType;
}
return $this->fieldDataType;
}
/**
* Function to get list of modules the field refernced to
* @return <Array> - list of modules for which field is refered to
*/
public function getReferenceList($hideDisabledModules = true, $presenceZero = true) {
$webserviceField = $this->getWebserviceFieldObject();
$referenceList = $webserviceField->getReferenceList($hideDisabledModules);
if($presenceZero && is_array($referenceList) && count($referenceList) > 0) {
foreach($referenceList as $key => $referenceModule) {
$moduleModel = Vtiger_Module_Model::getInstance($referenceModule);
if($moduleModel && $moduleModel->get('presence') != 0) {
unset($referenceList[$key]);
}
}
}
return $referenceList;
}
/**
* Function to check if the field is named field of the module
* @return <Boolean> - True/False
*/
public function isNameField() {
$nameFieldObject = Vtiger_Cache::get('EntityField',$this->getModuleName());
if(!$nameFieldObject){
$moduleModel = $this->getModule();
if(!empty($moduleModel)) {
$moduleEntityNameFields = $moduleModel->getNameFields();
}else{
$moduleEntityNameFields = array();
}
}else{
$moduleEntityNameFields = explode(',', $nameFieldObject->fieldname);
}
if(in_array($this->get('name'), $moduleEntityNameFields)) {
return true;
}
return false;
}
/**
* Function to check whether the current field is read-only
* @return <Boolean> - true/false
*/
public function isReadOnly() {
if($this->block) {
if($this->block->label == "LBL_ITEM_DETAILS"){
return false;
}
}
$webserviceField = $this->getWebserviceFieldObject();
return $webserviceField->isReadOnly();
}
/**
* Function to get the UI Type model for the uitype of the current field
* @return Vtiger_Base_UIType or UI Type specific model instance
*/
public function getUITypeModel() {
return Vtiger_Base_UIType::getInstanceFromField($this);
}
public function isRoleBased() {
if($this->get('uitype') == '15' || $this->get('uitype') == '33' || ($this->get('uitype') == '55' && $this->getFieldName() == 'salutationtype')) {
return true;
}
return false;
}
/**
* Function to get all the available picklist values for the current field
* @return <Array> List of picklist values if the field is of type picklist or multipicklist, null otherwise.
*/
public function getPicklistValues() {
$fieldDataType = $this->getFieldDataType();
$fieldName = $this->getName();
$permission = true;
// for reference fields the field name will be in the format of (referencefieldname;(module)fieldname)
preg_match('/(\w+) ; \((\w+)\) (\w+)/', $fieldName, $matches);
if(count($matches) > 0) {
list($full, $referenceParentField, $referenceModule, $referenceFieldName) = $matches;
$fieldName = $referenceFieldName;
}
if($fieldName == 'hdnTaxType' || ($fieldName == 'region_id' && $this->get('displaytype') == 5)) return null;
if($fieldDataType == 'picklist' || $fieldDataType == 'multipicklist') {
$fieldPickListValues = array();
$currentUser = Users_Record_Model::getCurrentUserModel();
if($this->isRoleBased()) {
$userModel = Users_Record_Model::getCurrentUserModel();
$picklistValues = Vtiger_Util_Helper::getRoleBasedPicklistValues($fieldName, $userModel->get('roleid'));
}else{
$picklistValues = Vtiger_Util_Helper::getPickListValues($fieldName);
}
foreach($picklistValues as $value) {
$fieldPickListValues[$value] = vtranslate($value,$this->getModuleName());
}
return $fieldPickListValues;
}
return null;
}
/**
* Function to check if the current field is mandatory or not
* @return <Boolean> - true/false
*/
public function isMandatory() {
list($type,$mandatory)= explode('~',$this->get('typeofdata'));
return $mandatory=='M' ? true:false;
}
/**
* Function to get the field type
* @return <String> type of the field
*/
public function getFieldType(){
$webserviceField = $this->getWebserviceFieldObject();
return $webserviceField->getFieldType();
}
/**
* Function to check if the field is shown in detail view
* @return <Boolean> - true/false
*/
public function isViewEnabled() {
$permision = $this->getPermissions();
if ($this->getDisplayType() == '4' || in_array($this->get('presence'), array(1, 3))) {
return false;
}
return $permision;
}
/**
* Function to check if the field is shown in detail view
* @return <Boolean> - true/false
*/
public function isViewable() {
if(!$this->isViewEnabled()) {
return false;
}
return true;
}
/**
* Function to check if the field is shown in detail view
* @return <Boolean> - true/false
*/
public function isViewableInDetailView() {
if(!$this->isViewable() || $this->getDisplayType() == '3' || $this->getDisplayType() == '5' || $this->getDisplayType() == '6') {
return false;
}
return true;
}
public function isViewableInFilterView() {
if(!$this->isViewable()){
return false;
}
if($this->getDisplayType() == '6' && $this->getName() =='tags') {
return false;
}
return true;
}
public function isEditEnabled() {
$displayType = (int)$this->get('displaytype');
$restrictedFields = array('isconvertedfrompotential','isconvertedfromlead');
$editEnabledDisplayTypes = array(1,3,5);
if(!$this->isViewEnabled() ||
!in_array($displayType, $editEnabledDisplayTypes) ||
strcasecmp($this->getFieldDataType(),"autogenerated") ===0 ||
strcasecmp($this->getFieldDataType(),"id") === 0 || in_array($this->getName(), $restrictedFields)) {
return false;
}
return true;
}
public function isQuickCreateEnabled() {
$moduleModel = $this->getModule();
$quickCreate = $this->get('quickcreate');
if(($quickCreate == self::QUICKCREATE_MANDATORY || $quickCreate == self::QUICKCREATE_ENABLED
|| $this->isMandatory()) && $this->get('uitype') != 69) {
//isQuickCreateSupported will not be there for settings
if(method_exists($moduleModel,'isQuickCreateSupported') && $moduleModel->isQuickCreateSupported()) {
return true;
}
}
return false;
}
/**
* Function to check whether summary field or not
* @return <Boolean> true/false
*/
public function isSummaryField() {
return ($this->get('summaryfield')) ? true : false;
}
/**
* Function to check whether the current field is editable
* @return <Boolean> - true/false
*/
public function isEditable() {
if(!$this->isEditEnabled()
|| !$this->isViewable()
|| !in_array(((int)$this->get('displaytype')), array(1,5))
|| $this->isReadOnly() == true
|| $this->get('uitype') == 4) {
return false;
}
return true;
}
/**
* Function to check whether field is ajax editable'
* @return <Boolean>
*/
public function isAjaxEditable() {
$ajaxRestrictedFields = array('4', '72', '61');
if(!$this->isEditable() || in_array($this->get('uitype'), $ajaxRestrictedFields)) {
return false;
}
return true;
}
/**
* 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);
$className = Vtiger_Loader::getComponentClassName('Model', 'Field', $fieldObj->getModuleName());
$fieldModel = new $className();
foreach($objectProperties as $properName=>$propertyValue) {
$fieldModel->$properName = $propertyValue;
}
return $fieldModel;
}
/**
* Function to get the custom view column name transformation of the field for a date field used in date filters
* @return <String> - tablename:columnname:fieldname:module_fieldlabel
*/
public function getCVDateFilterColumnName() {
$moduleName = $this->getModuleName();
$tableName = $this->get('table');
$columnName = $this->get('column');
$fieldName = $this->get('name');
$fieldLabel = $this->get('label');
$escapedFieldLabel = str_replace(' ', '_', $fieldLabel);
$moduleFieldLabel = $moduleName.'_'.$escapedFieldLabel;
return $tableName.':'.$columnName.':'.$fieldName.':'.$moduleFieldLabel;
}
/**
* Function to get the custom view column name transformation of the field
* @return <String> - tablename:columnname:fieldname:module_fieldlabel:fieldtype
*/
public function getCustomViewColumnName() {
$moduleName = $this->getModuleName();
$tableName = $this->get('table');
$columnName = $this->get('column');
$fieldName = $this->get('name');
$fieldLabel = $this->get('label');
$typeOfData = $this->get('typeofdata');
$fieldTypeOfData = explode('~', $typeOfData);
$fieldType = $fieldTypeOfData[0];
//Special condition need for reference field as they should be treated as string field
if($this->getFieldDataType() == 'reference') {
$fieldType = 'V';
} else {
$fieldType = ChangeTypeOfData_Filter($tableName, $columnName, $fieldType);
}
$escapedFieldLabel = str_replace(' ', '_', $fieldLabel);
$moduleFieldLabel = $moduleName.'_'.$escapedFieldLabel;
// for reference field we store field name in the format (parentReferenceFieldName ; (referenceModule) referenceFieldName)
$referenceFieldName = $this->get('reference_fieldname');
if(!empty($referenceFieldName)) $fieldName = $referenceFieldName;
return $tableName.':'.$columnName.':'.$fieldName.':'.$moduleFieldLabel.':'.$fieldType;
}
/**
* Function to get the Report column name transformation of the field
* @return <String> - tablename:columnname:module_fieldlabel:fieldname:fieldtype
*/
public function getReportFilterColumnName() {
$moduleName = $this->getModuleName();
$tableName = $this->get('table');
$columnName = $this->get('column');
$fieldName = $this->get('name');
$fieldLabel = $this->get('label');
$typeOfData = $this->get('typeofdata');
$fieldTypeOfData = explode('~', $typeOfData);
$fieldType = $fieldTypeOfData[0];
if($this->getFieldDataType() == 'reference') {
$fieldType = 'V';
} else {
$fieldType = ChangeTypeOfData_Filter($tableName, $columnName, $fieldType);
}
$escapedFieldLabel = str_replace(' ', '_', $fieldLabel);
if($moduleName == 'Events') $moduleName = 'Calendar';
$moduleFieldLabel = $moduleName.'_'.$escapedFieldLabel;
if($tableName == 'vtiger_crmentity' && $columnName !='smownerid'){
$tableName = 'vtiger_crmentity'.$moduleName;
} elseif($columnName == 'smownerid') {
$tableName = 'vtiger_users'.$moduleName;
$columnName ='user_name';
}
return $tableName.':'.$columnName.':'.$moduleFieldLabel.':'.$fieldName.':'.$fieldType;
}
/**
* This is set from Workflow Record Structure, since workflow expects the field name
* in a different format in its filter. Eg: for module field its fieldname and for reference
* fields its reference_field_name : (reference_module_name) field - salesorder_id: (SalesOrder) subject
* @return <String>
*/
function getWorkFlowFilterColumnName() {
return $this->get('workflow_columnname');
}
/**
* Function to get the field details
* @return <Array> - array of field values
*/
public function getFieldInfo() {
$currentUser = Users_Record_Model::getCurrentUserModel();
$fieldDataType = $this->getFieldDataType();
$this->fieldInfo['mandatory'] = $this->isMandatory();
$this->fieldInfo['presence'] = $this->isActiveField();
$this->fieldInfo['quickcreate'] = $this->isQuickCreateEnabled();
$this->fieldInfo['masseditable'] = $this->isMassEditable();
$this->fieldInfo['defaultvalue'] = $this->hasDefaultValue();
$this->fieldInfo['column'] = $this->get('column');
$this->fieldInfo['type'] = $fieldDataType;
$this->fieldInfo['name'] = $this->get('name');
$this->fieldInfo['label'] = vtranslate($this->get('label'), $this->getModuleName());
if($fieldDataType == 'picklist' || $fieldDataType == 'multipicklist' || $fieldDataType == 'multiowner') {
$pickListValues = $this->getPicklistValues();
if(!empty($pickListValues)) {
$this->fieldInfo['picklistvalues'] = $pickListValues;
} else {
$this->fieldInfo['picklistvalues'] = array();
}
$this->fieldInfo['picklistColors'] = array();
$picklistColors = $this->getPicklistColors();
if ($picklistColors) {
$this->fieldInfo['picklistColors'] = $picklistColors;
}
}
if($fieldDataType === 'currencyList'){
$currencyList = $this->getCurrencyList();
$this->fieldInfo['currencyList'] = $currencyList;
}
if($this->getFieldDataType() == 'date' || $this->getFieldDataType() == 'datetime'){
$currentUser = Users_Record_Model::getCurrentUserModel();
$this->fieldInfo['date-format'] = $currentUser->get('date_format');
}
if($this->getFieldDataType() == 'time') {
$currentUser = Users_Record_Model::getCurrentUserModel();
$this->fieldInfo['time-format'] = $currentUser->get('hour_format');
}
if($this->getFieldDataType() == 'currency') {
$currentUser = Users_Record_Model::getCurrentUserModel();
$this->fieldInfo['currency_symbol'] = $currentUser->get('currency_symbol');
$this->fieldInfo['decimal_separator'] = $currentUser->get('currency_decimal_separator');
$this->fieldInfo['group_separator'] = $currentUser->get('currency_grouping_separator');
}
if($this->getFieldDataType() == 'owner') {
$userList = $currentUser->getAccessibleUsers();
$groupList = $currentUser->getAccessibleGroups();
$pickListValues = array();
$pickListValues[vtranslate('LBL_USERS', $this->getModuleName())] = $userList;
$pickListValues[vtranslate('LBL_GROUPS', $this->getModuleName())] = $groupList;
$this->fieldInfo['picklistvalues'] = $pickListValues;
}
if($this->getFieldDataType() == 'ownergroup') {
$groupList = $currentUser->getAccessibleGroups();
$pickListValues = array();
$this->fieldInfo['picklistvalues'] = $groupList;
}
if($this->getFieldDataType() == 'reference') {
$this->fieldInfo['referencemodules'] = $this->getReferenceList();
}
$this->fieldInfo['validator'] = $this->getValidator();
return $this->fieldInfo;
}
function setFieldInfo($fieldInfo) {
$this->fieldInfo = $fieldInfo;
}
/**
* Function to get the date values for the given type of Standard filter
* @param <String> $type
* @return <Array> - 2 date values representing the range for the given type of Standard filter
*/
protected static function getDateForStdFilterBytype($type, $userPeferredDayOfTheWeek = false) {
$date = DateTimeField::convertToUserTimeZone(date('Y-m-d H:i:s'));
$d = $date->format('d');
$m = $date->format('m');
$y = $date->format('Y');
$today = date("Y-m-d", mktime(0, 0, 0, $m, $d, $y));
$todayName = date('l', strtotime($today));
$tomorrow = date("Y-m-d", mktime(0, 0, 0, $m, $d + 1, $y));
$yesterday = date("Y-m-d", mktime(0, 0, 0, $m, $d - 1, $y));
$currentmonth0 = date("Y-m-d", mktime(0, 0, 0, $m, "01", $y));
$currentmonth1 = $date->format("Y-m-t");
$lastmonth0 = date("Y-m-d", mktime(0, 0, 0, $m - 1, "01", $y));
$lastmonth1 = date("Y-m-t", strtotime($lastmonth0));
$nextmonth0 = date("Y-m-d", mktime(0, 0, 0, $m + 1, "01", $y));
$nextmonth1 = date("Y-m-t", strtotime($nextmonth0));
// (Last Week) If Today is "Sunday" then "-2 week Sunday" will give before last week Sunday date
if(!$userPeferredDayOfTheWeek){
$userPeferredDayOfTheWeek = 'Sunday';
}
if($todayName == $userPeferredDayOfTheWeek)
$lastweek0 = date("Y-m-d",strtotime("-1 week $userPeferredDayOfTheWeek"));
else
$lastweek0 = date("Y-m-d", strtotime("-2 week $userPeferredDayOfTheWeek"));
$prvDay = date('l', strtotime(date('Y-m-d', strtotime('-1 day', strtotime($lastweek0)))));
$lastweek1 = date("Y-m-d", strtotime("-1 week $prvDay"));
// (This Week) If Today is "Sunday" then "-1 week Sunday" will give last week Sunday date
if($todayName == $userPeferredDayOfTheWeek)
$thisweek0 = date("Y-m-d",strtotime("-0 week $userPeferredDayOfTheWeek"));
else
$thisweek0 = date("Y-m-d", strtotime("-1 week $userPeferredDayOfTheWeek"));
$prvDay = date('l', strtotime(date('Y-m-d', strtotime('-1 day', strtotime($thisweek0)))));
$thisweek1 = date("Y-m-d", strtotime("this $prvDay"));
// (Next Week) If Today is "Sunday" then "this Sunday" will give Today's date
if($todayName == $userPeferredDayOfTheWeek)
$nextweek0 = date("Y-m-d",strtotime("+1 week $userPeferredDayOfTheWeek"));
else
$nextweek0 = date("Y-m-d", strtotime("this $userPeferredDayOfTheWeek"));
$prvDay = date('l', strtotime(date('Y-m-d', strtotime('-1 day', strtotime($nextweek0)))));
$nextweek1 = date("Y-m-d", strtotime("+1 week $prvDay"));
$next7days = date("Y-m-d", mktime(0, 0, 0, $m, $d + 6, $y));
$next30days = date("Y-m-d", mktime(0, 0, 0, $m, $d + 29, $y));
$next60days = date("Y-m-d", mktime(0, 0, 0, $m, $d + 59, $y));
$next90days = date("Y-m-d", mktime(0, 0, 0, $m, $d + 89, $y));
$next120days = date("Y-m-d", mktime(0, 0, 0, $m, $d + 119, $y));
$last7days = date("Y-m-d", mktime(0, 0, 0, $m, $d - 6, $y));
$last14days = date("Y-m-d", mktime(0, 0, 0, $m, $d - 13, $y));
$last30days = date("Y-m-d", mktime(0, 0, 0, $m, $d - 29, $y));
$last60days = date("Y-m-d", mktime(0, 0, 0, $m, $d - 59, $y));
$last90days = date("Y-m-d", mktime(0, 0, 0, $m, $d - 89, $y));
$last120days = date("Y-m-d", mktime(0, 0, 0, $m, $d - 119, $y));
$currentFY0 = date("Y-m-d", mktime(0, 0, 0, "01", "01", $y));
$currentFY1 = date("Y-m-t", mktime(0, 0, 0, "12", $d, $y));
$lastFY0 = date("Y-m-d", mktime(0, 0, 0, "01", "01", $y - 1));
$lastFY1 = date("Y-m-t", mktime(0, 0, 0, "12", $d, $y - 1));
$nextFY0 = date("Y-m-d", mktime(0, 0, 0, "01", "01", $y + 1));
$nextFY1 = date("Y-m-t", mktime(0, 0, 0, "12", $d, $y + 1));
if ($m <= 3) {
$cFq = date("Y-m-d", mktime(0, 0, 0, "01", "01", $y));
$cFq1 = date("Y-m-d", mktime(0, 0, 0, "03", "31", $y));
$nFq = date("Y-m-d", mktime(0, 0, 0, "04", "01", $y));
$nFq1 = date("Y-m-d", mktime(0, 0, 0, "06", "30", $y));
$pFq = date("Y-m-d", mktime(0, 0, 0, "10", "01", $y - 1));
$pFq1 = date("Y-m-d", mktime(0, 0, 0, "12", "31", $y - 1));
} else if ($m > 3 and $m <= 6) {
$cFq = date("Y-m-d", mktime(0, 0, 0, "04", "01", $y));
$cFq1 = date("Y-m-d", mktime(0, 0, 0, "06", "30", $y));
$nFq = date("Y-m-d", mktime(0, 0, 0, "07", "01", $y));
$nFq1 = date("Y-m-d", mktime(0, 0, 0, "09", "30", $y));
$pFq = date("Y-m-d", mktime(0, 0, 0, "01", "01", $y));
$pFq1 = date("Y-m-d", mktime(0, 0, 0, "03", "31", $y));
} else if ($m > 6 and $m <= 9) {
$cFq = date("Y-m-d", mktime(0, 0, 0, "07", "01", $y));
$cFq1 = date("Y-m-d", mktime(0, 0, 0, "09", "30", $y));
$nFq = date("Y-m-d", mktime(0, 0, 0, "10", "01", $y));
$nFq1 = date("Y-m-d", mktime(0, 0, 0, "12", "31", $y));
$pFq = date("Y-m-d", mktime(0, 0, 0, "04", "01", $y));
$pFq1 = date("Y-m-d", mktime(0, 0, 0, "06", "30", $y));
} else {
$cFq = date("Y-m-d", mktime(0, 0, 0, "10", "01", $y));
$cFq1 = date("Y-m-d", mktime(0, 0, 0, "12", "31", $y));
$nFq = date("Y-m-d", mktime(0, 0, 0, "01", "01", $y + 1));
$nFq1 = date("Y-m-d", mktime(0, 0, 0, "03", "31", $y + 1));
$pFq = date("Y-m-d", mktime(0, 0, 0, "07", "01", $y));
$pFq1 = date("Y-m-d", mktime(0, 0, 0, "09", "30", $y));
}
$dateValues = array();
if ($type == "today") {
$dateValues[0] = $today;
$dateValues[1] = $today;
} elseif ($type == "yesterday") {
$dateValues[0] = $yesterday;
$dateValues[1] = $yesterday;
} elseif ($type == "tomorrow") {
$dateValues[0] = $tomorrow;
$dateValues[1] = $tomorrow;
} elseif ($type == "thisweek") {
$dateValues[0] = $thisweek0;
$dateValues[1] = $thisweek1;
} elseif ($type == "lastweek") {
$dateValues[0] = $lastweek0;
$dateValues[1] = $lastweek1;
} elseif ($type == "nextweek") {
$dateValues[0] = $nextweek0;
$dateValues[1] = $nextweek1;
} elseif ($type == "thismonth") {
$dateValues[0] = $currentmonth0;
$dateValues[1] = $currentmonth1;
} elseif ($type == "lastmonth") {
$dateValues[0] = $lastmonth0;
$dateValues[1] = $lastmonth1;
} elseif ($type == "nextmonth") {
$dateValues[0] = $nextmonth0;
$dateValues[1] = $nextmonth1;
} elseif ($type == "next7days") {
$dateValues[0] = $today;
$dateValues[1] = $next7days;
} elseif ($type == "next30days") {
$dateValues[0] = $today;
$dateValues[1] = $next30days;
} elseif ($type == "next60days") {
$dateValues[0] = $today;
$dateValues[1] = $next60days;
} elseif ($type == "next90days") {
$dateValues[0] = $today;
$dateValues[1] = $next90days;
} elseif ($type == "next120days") {
$dateValues[0] = $today;
$dateValues[1] = $next120days;
} elseif ($type == "last7days") {
$dateValues[0] = $last7days;
$dateValues[1] = $today;
} elseif ($type == "last14days") {
$dateValues[0] = $last14days;
$dateValues[1] = $today;
} elseif ($type == "last30days") {
$dateValues[0] = $last30days;
$dateValues[1] = $today;
} elseif ($type == "last60days") {
$dateValues[0] = $last60days;
$dateValues[1] = $today;
} else if ($type == "last90days") {
$dateValues[0] = $last90days;
$dateValues[1] = $today;
} elseif ($type == "last120days") {
$dateValues[0] = $last120days;
$dateValues[1] = $today;
} elseif ($type == "thisfy") {
$dateValues[0] = $currentFY0;
$dateValues[1] = $currentFY1;
} elseif ($type == "prevfy") {
$dateValues[0] = $lastFY0;
$dateValues[1] = $lastFY1;
} elseif ($type == "nextfy") {
$dateValues[0] = $nextFY0;
$dateValues[1] = $nextFY1;
} elseif ($type == "nextfq") {
$dateValues[0] = $nFq;
$dateValues[1] = $nFq1;
} elseif ($type == "prevfq") {
$dateValues[0] = $pFq;
$dateValues[1] = $pFq1;
} elseif ($type == "thisfq") {
$dateValues[0] = $cFq;
$dateValues[1] = $cFq1;
} else {
$dateValues[0] = "";
$dateValues[1] = "";
}
return $dateValues;
}
/**
* Function to get all the date filter type informations
* @return <Array>
*/
public static function getDateFilterTypes() {
$dateFilters = Array('lessthandaysago' => array('label' => 'LBL_LESS_THAN_DAYS_AGO'),
'morethandaysago' => array('label' => 'LBL_MORE_THAN_DAYS_AGO'),
'inlessthan' => array('label' => 'LBL_IN_LESS_THAN'),
'inmorethan' => array('label' => 'LBL_IN_MORE_THAN'),
'daysago' => array('label' => 'LBL_DAYS_AGO'),
'dayslater' => array('label' => 'LBL_DAYS_LATER'),
'custom' => array('label' => 'LBL_CUSTOM'),
'prevfy' => array('label' => 'LBL_PREVIOUS_FY'),
'thisfy' => array('label' => 'LBL_CURRENT_FY'),
'nextfy' => array('label' => 'LBL_NEXT_FY'),
'prevfq' => array('label' => 'LBL_PREVIOUS_FQ'),
'thisfq' => array('label' => 'LBL_CURRENT_FQ'),
'nextfq' => array('label' => 'LBL_NEXT_FQ'),
'yesterday' => array('label' => 'LBL_YESTERDAY'),
'today' => array('label' => 'LBL_TODAY'),
'tomorrow' => array('label' => 'LBL_TOMORROW'),
'lastweek' => array('label' => 'LBL_LAST_WEEK'),
'thisweek' => array('label' => 'LBL_CURRENT_WEEK'),
'nextweek' => array('label' => 'LBL_NEXT_WEEK'),
'lastmonth' => array('label' => 'LBL_LAST_MONTH'),
'thismonth' => array('label' => 'LBL_CURRENT_MONTH'),
'nextmonth' => array('label' => 'LBL_NEXT_MONTH'),
'last7days' => array('label' => 'LBL_LAST_7_DAYS'),
'last14days' => array('label' => 'LBL_LAST_14_DAYS'),
'last30days' => array('label' => 'LBL_LAST_30_DAYS'),
'last60days' => array('label' => 'LBL_LAST_60_DAYS'),
'last90days' => array('label' => 'LBL_LAST_90_DAYS'),
'last120days' => array('label' => 'LBL_LAST_120_DAYS'),
'next30days' => array('label' => 'LBL_NEXT_30_DAYS'),
'next60days' => array('label' => 'LBL_NEXT_60_DAYS'),
'next90days' => array('label' => 'LBL_NEXT_90_DAYS'),
'next120days' => array('label' => 'LBL_NEXT_120_DAYS')
);
$currentUserModel = Users_Record_Model::getCurrentUserModel();
$userPeferredDayOfTheWeek = $currentUserModel->get('dayoftheweek');
foreach($dateFilters as $filterType => $filterDetails) {
$dateValues = self::getDateForStdFilterBytype($filterType,$userPeferredDayOfTheWeek);
$dateFilters[$filterType]['startdate'] = $dateValues[0];
$dateFilters[$filterType]['enddate'] = $dateValues[1];
}
return $dateFilters;
}
/**
* Function to get all the supported advanced filter operations
* @return <Array>
*/
public static function getAdvancedFilterOptions() {
return array(
'e' => 'LBL_EQUALS',
'n' => 'LBL_NOT_EQUAL_TO',
's' => 'LBL_STARTS_WITH',
'ew' => 'LBL_ENDS_WITH',
'c' => 'LBL_CONTAINS',
'k' => 'LBL_DOES_NOT_CONTAIN',
'l' => 'LBL_LESS_THAN',
'g' => 'LBL_GREATER_THAN',
'm' => 'LBL_LESS_THAN_OR_EQUAL',
'h' => 'LBL_GREATER_OR_EQUAL',
'b' => 'LBL_BEFORE',
'a' => 'LBL_AFTER',
'bw' => 'LBL_BETWEEN',
'y' => 'LBL_IS_EMPTY',
'ny'=> 'LBL_IS_NOT_EMPTY',
'lessthanhoursbefore' => 'LBL_LESS_THAN_HOURS_BEFORE',
'lessthanhourslater' => 'LBL_LESS_THAN_HOURS_LATER',
'morethanhoursbefore' => 'LBL_MORE_THAN_HOURS_BEFORE',
'morethanhourslater' => 'LBL_MORE_THAN_HOURS_LATER',
);
}
/**
* Function to get the advanced filter option names by Field type
* @return <Array>
*/
public static function getAdvancedFilterOpsByFieldType() {
return array(
'V' => array('e','n','s','ew','c','k','y','ny'),
'N' => array('e','n','l','g','m','h', 'y','ny'),
'T' => array('e','n','l','g','m','h','bw','b','a','y','ny'),
'I' => array('e','n','l','g','m','h','y','ny'),
'C' => array('e','n','y','ny'),
'D' => array('e','n','bw','b','a','y','ny'),
'DT' => array('e','n','bw','b','a','y','ny','lessthanhoursbefore','lessthanhourslater','morethanhoursbefore','morethanhourslater'),
'NN' => array('e','n','l','g','m','h','y','ny'),
'E' => array('e','n','s','ew','c','k','y','ny')
);
}
/**
* Function to retrieve field model for specific block and module
* @param <Vtiger_Module_Model> $blockModel - block instance
* @return <array> List of field model
*/
public static function getAllForModule($moduleModel){
$fieldModelList = Vtiger_Cache::get('ModuleFields',$moduleModel->id);
if(!$fieldModelList){
$fieldObjects = parent::getAllForModule($moduleModel);
$fieldModelList = array();
//if module dont have any fields
if(!is_array($fieldObjects)){
$fieldObjects = array();
}
foreach($fieldObjects as $fieldObject){
$fieldModelObject= self::getInstanceFromFieldObject($fieldObject);
$fieldModelList[$fieldModelObject->get('block')->id][] = $fieldModelObject;
Vtiger_Cache::set('field-'.$moduleModel->getId(),$fieldModelObject->getId(),$fieldModelObject);
Vtiger_Cache::set('field-'.$moduleModel->getId(),$fieldModelObject->getName(),$fieldModelObject);
}
Vtiger_Cache::set('ModuleFields',$moduleModel->id,$fieldModelList);
}
return $fieldModelList;
}
/**
* 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 = null;
if($module){
$fieldObject = Vtiger_Cache::get('field-'.$module->getId(), $value);
}
if(!$fieldObject){
$fieldObject = parent::getInstance($value, $module);
if($module){
Vtiger_Cache::set('field-'.$module->getId(),$value,$fieldObject);
}
}
if($fieldObject) {
return self::getInstanceFromFieldObject($fieldObject);
}
return false;
}
/**
* Added function that returns the folders in a Document
* @return <Array>
*/
function getDocumentFolders() {
$db = PearDatabase::getInstance();
$result = $db->pquery('SELECT * FROM vtiger_attachmentsfolder', array());
$rows = $db->num_rows($result);
$folders = array();
for($i=0; $i<$rows; $i++){
$folderId = $db->query_result($result, $i, 'folderid');
$folderName = $db->query_result($result, $i, 'foldername');
$folders[$folderId] = $folderName;
}
return $folders;
}
/**
* Function checks if the current Field is Read/Write
* @return <Boolean>
*/
function getProfileReadWritePermission() {
return $this->getPermissions('readwrite');
}
/**
* Function returns Client Side Validators name
* @return <Array> [name=>Name of the Validator, params=>Extra Parameters]
*/
/**TODO: field validator need to be handled in specific module getValidator api **/
function getValidator() {
$validator = array();
$fieldName = $this->getName();
switch($fieldName) {
case 'birthday' : $funcName = array('name'=>'lessThanToday');
break;
case 'support_end_date' : $funcName = array('name' => 'greaterThanDependentField', 'params' => array('support_start_date'));
break;
case 'support_start_date' : $funcName = array('name' => 'lessThanDependentField', 'params' => array('support_end_date'));
break;
case 'targetenddate' :
case 'actualenddate' :
case 'enddate' : $funcName = array('name' => 'greaterThanDependentField', 'params' => array('startdate'));
break;
case 'start_date' :
case 'startdate' : if($this->getModule()->get('name') == 'Project') {
$params = array('targetenddate');
} else if ($this->getModule()->get('name') == 'Products' || $this->getModule()->get('name') == 'Services') {
$params = array('expiry_date');
} else if ($this->getModule()->get('name') == 'ServiceContracts') {
$params = array('due_date');
} else {
//for project task
$params = array('enddate');
}
$funcName = array('name' => 'lessThanDependentField', 'params' => $params);
break;
case 'expiry_date' :
case 'due_date' : $funcName = array('name' => 'greaterThanDependentField', 'params' => array('start_date'));
break;
case 'sales_end_date' : $funcName = array('name' => 'greaterThanDependentField', 'params' => array('sales_start_date'));
break;
case 'sales_start_date' : $funcName = array('name' => 'lessThanDependentField', 'params' => array('sales_end_date'));
break;
case 'hours' :
case 'days' : $funcName = array('name'=>'PositiveNumber');
break;
case 'employees' : $funcName = array('name'=>'WholeNumber');
break;
case 'related_to' : $funcName = array('name'=>'ReferenceField');
break;
//SalesOrder field sepecial validators
case 'end_period' : $funcName1 = array('name' => 'greaterThanDependentField', 'params' => array('start_period'));
array_push($validator, $funcName1);
$funcName = array('name' => 'lessThanDependentField', 'params' => array('duedate'));
break;
case 'start_period' : $funcName = array('name' => 'lessThanDependentField', 'params' => array('end_period'));
break;
}
if ($funcName) {
array_push($validator, $funcName);
}
return $validator;
}
/**
* Function to retrieve display value in edit view
* @param <String> $value - value which need to be converted to display value
* @return <String> - converted display value
*/
public function getEditViewDisplayValue($value) {
if(!$this->uitype_instance) {
$this->uitype_instance = Vtiger_Base_UIType::getInstanceFromField($this);
}
$uiTypeInstance = $this->uitype_instance;
return $uiTypeInstance->getEditViewDisplayValue($value);
}
/**
* Function to retieve types of file locations in Documents Edit
* @return <array> - List of file location types
*/
public function getFileLocationType() {
return array('I'=> vtranslate('LBL_INTERNAL','Documents'), 'E'=> vtranslate('LBL_EXTERNAL','Documents'));
}
/**
* Function returns list of Currencies available in the system
* @return <Array>
*/
public function getCurrencyList() {
$db = PearDatabase::getInstance();
// Not a good approach to get all the fields if not required(May leads to Performance issue)
$result = $db->pquery('SELECT id, currency_name FROM vtiger_currency_info WHERE currency_status = ? AND deleted=0', array('Active'));
for($i=0; $i<$db->num_rows($result); $i++) {
$currencyId = $db->query_result($result, $i, 'id');
$currencyName = $db->query_result($result, $i, 'currency_name');
$currencies[$currencyId] = $currencyName;
}
return $currencies;
}
/**
* Function to get Display value for RelatedList
* @param <String> $value
* @return <String>
*/
public function getRelatedListDisplayValue($value) {
if(!$this->uitype_instance) {
$this->uitype_instance = Vtiger_Base_UIType::getInstanceFromField($this);
}
$uiTypeInstance = $this->uitype_instance;
return $uiTypeInstance->getRelatedListDisplayValue($value);
}
/**
* Function to get Default Field Value
* @return <String> defaultvalue
*/
public function getDefaultFieldValue(){
return $this->defaultvalue;
}
/**
* Function whcih will get the databse insert value format from user format
* @param type $value in user format
* @return type
*/
public function getDBInsertValue($value) {
if(!$this->uitype_instance) {
$this->uitype_instance = Vtiger_Base_UIType::getInstanceFromField($this);
}
$uiTypeInstance = $this->uitype_instance;
return $uiTypeInstance->getDBInsertValue($value);
}
/**
* Function to get visibilty permissions of a Field
* @param <String> $accessmode
* @return <Boolean>
*/
public function getPermissions($accessmode = 'readonly') {
$user = Users_Record_Model::getCurrentUserModel();
$privileges = $user->getPrivileges();
if ($privileges->hasGlobalReadPermission()) {
return true;
} else {
$modulePermission = Vtiger_Cache::get('modulePermission-'.$accessmode, $this->getModuleId());
if (!$modulePermission) {
$modulePermission = self::preFetchModuleFieldPermission($this->getModuleId(), $accessmode);
}
if (array_key_exists($this->getId(), $modulePermission)) {
return true;
} else {
return false;
}
}
}
/**
* Function to Preinitialize the module Field Permissions
* @param <Integer> $tabid
* @param <String> $accessmode
* @return <Array>
*/
public static function preFetchModuleFieldPermission($tabid,$accessmode = 'readonly'){
$adb = PearDatabase::getInstance();
$user = Users_Record_Model::getCurrentUserModel();
$privileges = $user->getPrivileges();
$profilelist = $privileges->get('profiles');
if (count($profilelist) > 0) {
if ($accessmode == 'readonly') {
$query = "SELECT vtiger_profile2field.visible,vtiger_field.fieldid FROM vtiger_field INNER JOIN vtiger_profile2field ON vtiger_profile2field.fieldid=vtiger_field.fieldid INNER JOIN vtiger_def_org_field ON vtiger_def_org_field.fieldid=vtiger_field.fieldid WHERE vtiger_field.tabid=? AND vtiger_profile2field.visible=0 AND vtiger_def_org_field.visible=0 AND vtiger_profile2field.profileid in (" . generateQuestionMarks($profilelist) . ") AND vtiger_field.presence in (0,2) GROUP BY vtiger_field.fieldid";
} else {
$query = "SELECT vtiger_profile2field.visible,vtiger_field.fieldid FROM vtiger_field INNER JOIN vtiger_profile2field ON vtiger_profile2field.fieldid=vtiger_field.fieldid INNER JOIN vtiger_def_org_field ON vtiger_def_org_field.fieldid=vtiger_field.fieldid WHERE vtiger_field.tabid=? AND vtiger_profile2field.visible=0 AND vtiger_profile2field.readonly=0 AND vtiger_def_org_field.visible=0 AND vtiger_profile2field.profileid in (" . generateQuestionMarks($profilelist) . ") AND vtiger_field.presence in (0,2) GROUP BY vtiger_field.fieldid";
}
$params = array($tabid, $profilelist);
} else {
if ($accessmode == 'readonly') {
$query = "SELECT vtiger_profile2field.visible,vtiger_field.fieldid FROM vtiger_field INNER JOIN vtiger_profile2field ON vtiger_profile2field.fieldid=vtiger_field.fieldid INNER JOIN vtiger_def_org_field ON vtiger_def_org_field.fieldid=vtiger_field.fieldid WHERE vtiger_field.tabid=? AND vtiger_profile2field.visible=0 AND vtiger_def_org_field.visible=0 AND vtiger_field.presence in (0,2) GROUP BY vtiger_field.fieldid";
} else {
$query = "SELECT vtiger_profile2field.visible,vtiger_field.fieldid FROM vtiger_field INNER JOIN vtiger_profile2field ON vtiger_profile2field.fieldid=vtiger_field.fieldid INNER JOIN vtiger_def_org_field ON vtiger_def_org_field.fieldid=vtiger_field.fieldid WHERE vtiger_field.tabid=? AND vtiger_profile2field.visible=0 AND vtiger_profile2field.readonly=0 AND vtiger_def_org_field.visible=0 AND vtiger_field.presence in (0,2) GROUP BY vtiger_field.fieldid";
}
$params = array($tabid);
}
$result = $adb->pquery($query, $params);
$modulePermission = array();
$noOfFields = $adb->num_rows($result);
for ($i = 0; $i < $noOfFields; ++$i) {
$row = $adb->query_result_rowdata($result, $i);
$modulePermission[$row['fieldid']] = $row['visible'];
}
Vtiger_Cache::set('modulePermission-'.$accessmode,$tabid,$modulePermission);
return $modulePermission;
}
public function __update() {
$db = PearDatabase::getInstance();
$query = 'UPDATE vtiger_field SET typeofdata=?,presence=?,quickcreate=?,masseditable=?,defaultvalue=?,summaryfield=?,headerfield=?';
$params = array($this->get('typeofdata'), $this->get('presence'), $this->get('quickcreate'),
$this->get('masseditable'), $this->get('defaultvalue'), $this->get('summaryfield'), $this->get('headerfield'));
if ($this->get('uitype')) {
$query .= ', uitype=?';
$params[] = $this->get('uitype');
}
if ($this->get('label')) {
$query .= ', fieldlabel=?';
$params[] = decode_html($this->get('label'));
}
$query .= ' WHERE fieldid=?';
$params[] = $this->get('id');
$db->pquery($query,$params);
}
public function updateTypeofDataFromMandatory($mandatoryValue='O') {
$mandatoryValue = strtoupper($mandatoryValue);
$supportedMandatoryLiterals = array('O','M');
if(!in_array($mandatoryValue, $supportedMandatoryLiterals)) {
return;
}
$typeOfData = $this->get('typeofdata');
$components = explode('~', $typeOfData);
$components[1] = $mandatoryValue;
$this->set('typeofdata', implode('~', $components));
return $this;
}
public function isCustomField() {
return ($this->get('generatedtype') == 2) ? true : false;
}
public function hasDefaultValue() {
return trim($this->defaultvalue) == '' ? false : true;
}
public function isActiveField() {
$presence = $this->get('presence');
return in_array($presence, array(0,2));
}
public function isMassEditable() {
return $this->masseditable == 1 ? true : false;
}
/**
* Function which will check if empty piclist option should be given
*/
public function isEmptyPicklistOptionAllowed() {
return true;
}
public function isReferenceField() {
return ($this->getFieldDataType() == self::REFERENCE_TYPE) ? true : false;
}
public function isOwnerField() {
return ($this->getFieldDataType() == self::OWNER_TYPE) ? true : false;
}
public static function getInstanceFromFieldId($fieldId, $moduleTabId) {
$db = PearDatabase::getInstance();
if(is_string($fieldId)) {
$fieldId = array($fieldId);
}
$query = 'SELECT * FROM vtiger_field WHERE fieldid IN ('.generateQuestionMarks($fieldId).') AND tabid=?';
$result = $db->pquery($query, array($fieldId,$moduleTabId));
$fieldModelList = array();
$num_rows = $db->num_rows($result);
for($i=0; $i<$num_rows; $i++) {
$row = $db->query_result_rowdata($result, $i);
$fieldModel = new self();
$fieldModel->initialize($row);
$fieldModelList[] = $fieldModel;
}
return $fieldModelList;
}
public function hasCustomLock() {
return false;
}
/**
* Function to get the auto fill reference field for this field
* @return <array> $autoFill - with module name and field name
*/
public function getAutoFillValue() {
$moduleModel = $this->getModule();
$referenceList = $this->getReferenceList();
foreach ($referenceList as $referenceModuleName) {
$autoFillData = $moduleModel->getAutoFillModuleAndField($referenceModuleName);
if($autoFillData) {
foreach($autoFillData as $data) {
// To get the parent autofill reference field name of reference field
$referenceModuleModel = Vtiger_Module_Model::getInstance($referenceModuleName);
$parentAutoFillData = $referenceModuleModel->getAutoFillModuleAndField($referenceModuleName);
foreach($parentAutoFillData as $parentData) {
if($parentData['module'] == $data['module']){
$data['parentfieldname'] = $parentData['fieldname'];
break;
}
}
$newautoFillData[] = $data;
}
return $newautoFillData;
}
}
return false;
}
public function isOneToOneRelationField() {
$fieldDataType = $this->getFieldDataType();
$relatedTo = $this->get('related_field_id');
if($fieldDataType == self::REFERENCE_TYPE && !empty($relatedTo)) {
return true;
}
return false;
}
public function getOneToOneRelationField(){
if(!$this->isOneToOneRelationField()) return false;
return Vtiger_Field_Model::getInstance($this->get('related_field_id'));
}
/**
* Determins whether the current field is reposnible for any relation ship
* @return boolean
*/
public function isRelationShipReponsibleField() {
$relationModelFromRelationField = $this->getRelationShipForThisField();
if($relationModelFromRelationField) return true;
else return false;
}
/**
* return the relation model if the current field is responsible for any relation ship
* @return Vtiger_Relation_Model / false;
*/
public function getRelationShipForThisField() {
return Vtiger_Relation_Model::getInstanceFromRelationFied($this->getId());
}
/**
* Function to check whether header field or not
* @return <Boolean> true/false
*/
public function isHeaderField() {
return ($this->get('headerfield')) ? true : false;
}
public function getPicklistColors() {
$picklistColors = array();
$fieldDataType = $this->getFieldDataType();
if (in_array($fieldDataType, array('picklist', 'multipicklist'))) {
$fieldName = $this->getName();
preg_match('/(\w+) ; \((\w+)\) (\w+)/', $fieldName, $matches);
if (count($matches) > 0) {
list($full, $referenceParentField, $referenceModule, $referenceFieldName) = $matches;
$fieldName = $referenceFieldName;
}
if (!in_array($fieldName, array('hdnTaxType', 'region_id')) && !in_array($this->getModuleName(), array('Users'))) {
$db = PearDatabase::getInstance();
$picklistValues = $this->getPicklistValues();
$tableName = "vtiger_$fieldName";
if (Vtiger_Utils::CheckTable($tableName)) {
if (is_array($picklistValues) && count($picklistValues)) {
$result = $db->pquery("SELECT $fieldName, color FROM $tableName WHERE $fieldName IN (".generateQuestionMarks($picklistValues).")", array_keys($picklistValues));
while ($row = $db->fetch_row($result)) {
$picklistColors[$row[$fieldName]] = $row['color'];
}
}
}
}
}
return $picklistColors;
}
public function isUniqueField() {
return $this->isunique;
}
}