Forked from
vtiger / vtigercrm
1785 commits behind the upstream repository.
-
Uma authored0df6975c
Functions.php 51.18 KiB
<?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.
************************************************************************************/
/**
* TODO need to organize into classes based on functional grouping.
*/
class Vtiger_Functions {
const LINK_TO_ANCHOR_TEXT_SYMBOL = '#';
static function userIsAdministrator($user) {
return (isset($user->is_admin) && $user->is_admin == 'on');
}
/**
* this function returns JS date format of current user
*
* return string
*/
public static function currentUserJSDateFormat()
{
$datePopupFormat = '';
$currentUser = Users_Record_Model::getCurrentUserModel();
switch ($currentUser->get('date_format')) {
case 'dd.mm.yyyy':
$datePopupFormat = '%d.%m.%Y';
break;
case 'mm.dd.yyyy':
$datePopupFormat = '%m.%d.%Y';
break;
case 'yyyy.mm.dd':
$datePopupFormat = '%Y.%m.%d';
break;
case 'dd/mm/yyyy':
$datePopupFormat = '%d/%m/%Y';
break;
case 'mm/dd/yyyy':
$datePopupFormat = '%m/%d/%Y';
break;
case 'yyyy/mm/dd':
$datePopupFormat = '%Y/%m/%d';
break;
case 'dd-mm-yyyy':
$datePopupFormat = '%d-%m-%Y';
break;
case 'mm-dd-yyyy':
$datePopupFormat = '%m-%d-%Y';
break;
case 'yyyy-mm-dd':
$datePopupFormat = '%Y-%m-%d';
break;
}
return $datePopupFormat;
}
/**
* This function returns the date in user specified format.
* limitation is that mm-dd-yyyy and dd-mm-yyyy will be considered same by this API.
* As in the date value is on mm-dd-yyyy and user date format is dd-mm-yyyy then the mm-dd-yyyy
* value will be return as the API will be considered as considered as in same format. * this due to the fact that this API tries to consider the where given date is in user date
* format. we need a better gauge for this case.
* @global Users $current_user
* @param Date $cur_date_val the date which should a changed to user date format.
* @return Date
*/
static function currentUserDisplayDate($value) {
global $current_user;
$dat_fmt = $current_user->date_format;
if ($dat_fmt == '') {
$dat_fmt = 'dd-mm-yyyy';
}
$date = new DateTimeField($value);
return $date->getDisplayDate();
}
static function currentUserDisplayDateNew() {
global $log, $current_user;
$date = new DateTimeField(null);
return $date->getDisplayDate($current_user);
}
// i18n
static function getTranslatedString($str, $module='', $language='') {
return Vtiger_Language_Handler::getTranslatedString($str, $module, $language);
}
// CURRENCY
protected static $userIdCurrencyIdCache = array();
static function userCurrencyId($userid) {
global $adb;
if (!isset(self::$userIdCurrencyIdCache[$userid])) {
$result = $adb->pquery('SELECT id,currency_id FROM vtiger_users', array());
while ($row = $adb->fetch_array($result)) {
self::$userIdCurrencyIdCache[$row['id']] =
$row['currency_id'];
}
}
return self::$userIdCurrencyIdCache[$userid];
}
protected static $currencyInfoCache = array();
protected static function getCurrencyInfo($currencyid) {
global $adb;
if (!isset(self::$currencyInfoCache[$currencyid])) {
$result = $adb->pquery('SELECT * FROM vtiger_currency_info', array());
while ($row = $adb->fetch_array($result)) {
self::$currencyInfoCache[$row['id']] = $row;
}
}
return self::$currencyInfoCache[$currencyid];
}
static function getCurrencyName($currencyid, $show_symbol = true) {
$currencyInfo = self::getCurrencyInfo($currencyid);
if ($show_symbol) {
return sprintf("%s : %s", Vtiger_Deprecated::getTranslatedCurrencyString($currencyInfo['currency_name']), $currencyInfo['currency_symbol']);
}
return $currencyInfo['currency_name'];
}
static function getCurrencySymbolandRate($currencyid) {
$currencyInfo = self::getCurrencyInfo($currencyid);
$currencyRateSymbol = array(
'rate' => $currencyInfo['conversion_rate'],
'symbol'=>$currencyInfo['currency_symbol']
);
return $currencyRateSymbol; }
// MODULE
protected static $moduleIdNameCache = array();
protected static $moduleNameIdCache = array();
protected static $moduleIdDataCache = array();
protected static function getBasicModuleInfo($mixed) {
$id = $name = NULL;
if (is_numeric($mixed)) $id = $mixed;
else $name = $mixed;
$reload = false;
if ($name) {
if (!isset(self::$moduleNameIdCache[$name])) {$reload = true;}
} else if ($id) {
if (!isset(self::$moduleIdNameCache[$id])) {$reload = true;}
}
if ($reload) {
global $adb;
$result = $adb->pquery('SELECT tabid, name, ownedby FROM vtiger_tab', array());
while ($row = $adb->fetch_array($result)) {
self::$moduleIdNameCache[$row['tabid']] = $row;
self::$moduleNameIdCache[$row['name']] = $row;
}
}
return $id ? self::$moduleIdNameCache[$id] : self::$moduleNameIdCache[$name];
}
static function getModuleData($mixed) {
$id = $name = NULL;
if (is_numeric($mixed)) $id = $mixed;
else $name = (string)$mixed;
$reload = false;
if ($name && !isset(self::$moduleNameIdCache[$name])) {$reload = true;}
else if ($id && !isset(self::$moduleIdNameCache[$id])) {$reload = true;}
else {
if (!$id) $id = self::$moduleNameIdCache[$name]['tabid'];
if (!isset(self::$moduleIdDataCache[$id])) { $reload = true; }
}
if ($reload) {
global $adb;
$result = $adb->pquery('SELECT * FROM vtiger_tab', array());
while ($row = $adb->fetch_array($result)) {
self::$moduleIdNameCache[$row['tabid']] = $row;
self::$moduleNameIdCache[$row['name']] = $row;
self::$moduleIdDataCache[$row['tabid']] = $row;
}
if ($name && isset(self::$moduleNameIdCache[$name])) {
$id = self::$moduleNameIdCache[$name]['tabid'];
}
}
return $id ? self::$moduleIdDataCache[$id] : NULL;
}
static function getModuleId($name) {
$moduleInfo = self::getBasicModuleInfo($name);
return $moduleInfo ? $moduleInfo['tabid'] : NULL;
}
static function getModuleName($id) {
$moduleInfo = self::getBasicModuleInfo($id);
return $moduleInfo ? $moduleInfo['name'] : NULL;
}
static function getModuleOwner($name) {
$moduleInfo = self::getBasicModuleInfo($name);
return $moduleInfo ? $moduleInfo['ownedby'] : NULL;
}
protected static $moduleEntityCache = array();
static function getEntityModuleInfo($mixed) {
$name = NULL;
if (is_numeric($mixed)) $name = self::getModuleName ($mixed);
else $name = $mixed;
if ($name && !isset(self::$moduleEntityCache[$name])) {
global $adb;
$result = $adb->pquery('SELECT fieldname,modulename,tablename,entityidfield,entityidcolumn from vtiger_entityname', array());
while ($row = $adb->fetch_array($result)) {
self::$moduleEntityCache[$row['modulename']] = $row;
}
}
return isset(self::$moduleEntityCache[$name])?
self::$moduleEntityCache[$name] : NULL;
}
static function getEntityModuleSQLColumnString($mixed) {
$data = array();
$info = self::getEntityModuleInfo($mixed);
if ($info) {
$data['tablename'] = $info['tablename'];
$fieldnames = $info['fieldname'];
if (strpos(',', $fieldnames) !== false) {
$fieldnames = sprintf("concat(%s)", implode(",' ',", explode(',', $fieldnames)));
}
$data['fieldname'] = $fieldnames;
}
return $data;
}
static function getEntityModuleInfoFieldsFormatted($mixed) {
$info = self::getEntityModuleInfo($mixed);
$fieldnames = $info ? $info['fieldname'] : NULL;
if ($fieldnames && stripos($fieldnames, ',') !== false) {
$fieldnames = explode(',', $fieldnames);
}
$info['fieldname'] = $fieldnames;
return $info;
}
// MODULE RECORD
protected static $crmRecordIdMetadataCache = array();
protected static function getCRMRecordMetadata($mixedid) {
global $adb;
$multimode = is_array($mixedid);
$ids = $multimode ? $mixedid : array($mixedid);
$missing = array();
foreach ($ids as $id) {
if ($id && !isset(self::$crmRecordIdMetadataCache[$id])) {
$missing[] = $id;
}
}
if ($missing) {
$sql = sprintf("SELECT crmid, setype, label FROM vtiger_crmentity WHERE %s", implode(' OR ', array_fill(0, count($missing), 'crmid=?')));
$result = $adb->pquery($sql, $missing);
while ($row = $adb->fetch_array($result)) {
self::$crmRecordIdMetadataCache[$row['crmid']] = $row;
}
}
$result = array();
foreach ($ids as $id) { if (isset(self::$crmRecordIdMetadataCache[$id])) {
$result[$id] = self::$crmRecordIdMetadataCache[$id];
} else {
$result[$id] = NULL;
}
}
return $multimode? $result : array_shift($result);
}
static function getCRMRecordType($id) {
$metadata = self::getCRMRecordMetadata($id);
return $metadata ? $metadata['setype'] : NULL;
}
static function getCRMRecordLabel($id, $default='') {
$metadata = self::getCRMRecordMetadata($id);
return $metadata ? $metadata['label'] : $default;
}
static function getUserRecordLabel($id, $default='') {
$labels = self::getCRMRecordLabels('Users', $id);
return isset($labels[$id])? $labels[$id] : $default;
}
static function getGroupRecordLabel($id, $default='') {
$labels = self::getCRMRecordLabels('Groups', $id);
return isset($labels[$id])? $labels[$id] : $default;
}
static function getCRMRecordLabels($module, $ids) {
if (!is_array($ids)) $ids = array($ids);
if ($module == 'Users' || $module == 'Groups') {
// TODO Cache separately?
return self::computeCRMRecordLabels($module, $ids);
} else {
$metadatas = self::getCRMRecordMetadata($ids);
$result = array();
foreach ($metadatas as $data) {
$result[$data['crmid']] = $data['label'];
}
return $result;
}
}
static function updateCRMRecordLabel($module, $id) {
global $adb;
$labelInfo = self::computeCRMRecordLabels($module, $id);
if ($labelInfo) {
$label = decode_html($labelInfo[$id]);
$adb->pquery('UPDATE vtiger_crmentity SET label=? WHERE crmid=?', array($label, $id));
self::$crmRecordIdMetadataCache[$id] = array(
'setype' => $module,
'crmid' => $id,
'label' => $labelInfo[$id]
);
}
}
static function getOwnerRecordLabel($id) {
$result = self::getOwnerRecordLabels($id);
return $result ? array_shift($result) : NULL;
}
static function getOwnerRecordLabels($ids) {
if (!is_array($ids)) $ids = array($ids);
$nameList = array();
if ($ids) { $nameList = self::getCRMRecordLabels('Users', $ids);
$groups = array();
$diffIds = array_diff($ids, array_keys($nameList));
if ($diffIds) {
$groups = self::getCRMRecordLabels('Groups', array_values($diffIds));
}
if ($groups) {
foreach ($groups as $id => $label) {
$nameList[$id] = $label;
}
}
}
return $nameList;
}
static function computeCRMRecordLabels($module, $ids) {
global $adb;
if (!is_array($ids)) $ids = array($ids);
if ($module == 'Events') {
$module = 'Calendar';
}
if ($module) {
$entityDisplay = array();
if ($ids) {
if ($module == 'Groups') {
$metainfo = array('tablename' => 'vtiger_groups','entityidfield' => 'groupid','fieldname' => 'groupname');
} else if ($module == 'DocumentFolders') {
$metainfo = array('tablename' => 'vtiger_attachmentsfolder','entityidfield' => 'folderid','fieldname' => 'foldername');
} else {
$metainfo = self::getEntityModuleInfo($module);
}
$table = $metainfo['tablename'];
$idcolumn = $metainfo['entityidfield'];
$columns = explode(',', $metainfo['fieldname']);
// NOTE: Ignore field-permission check for non-admin (to compute record label).
$columnString = count($columns) < 2? $columns[0] :
sprintf("concat(%s)", implode(",' ',", $columns));
$sql = sprintf('SELECT '. implode(',',$columns).', %s AS id FROM %s WHERE %s IN (%s)',
$idcolumn, $table, $idcolumn, generateQuestionMarks($ids));
$result = $adb->pquery($sql, $ids);
if($result) {
while ($row = $adb->fetch_array($result)) {
$labelValues = array();
foreach($columns as $columnName) {
$labelValues[] = $row[$columnName];
}
$entityDisplay[$row['id']] = implode(' ',$labelValues);
}
}
}
return $entityDisplay;
}
}
protected static $groupIdNameCache = array();
static function getGroupName($id) {
global $adb; if (!self::$groupIdNameCache[$id]) {
$result = $adb->pquery('SELECT groupid, groupname FROM vtiger_groups');
while ($row = $adb->fetch_array($result)) {
self::$groupIdNameCache[$row['groupid']] = $row['groupname'];
}
}
$result = array();
if (isset(self::$groupIdNameCache[$id])) {
$result[] = decode_html(self::$groupIdNameCache[$id]);
$result[] = $id;
}
return $result;
}
protected static $userIdNameCache = array();
static function getUserName($id) {
global $adb;
if (!self::$userIdNameCache[$id]) {
$result = $adb->pquery('SELECT id, user_name FROM vtiger_users');
while ($row = $adb->fetch_array($result)) {
self::$userIdNameCache[$row['id']] = $row['user_name'];
}
}
return (isset(self::$userIdNameCache[$id])) ? self::$userIdNameCache[$id] : NULL;
}
static function getModuleFieldInfos($mixed) {
global $adb;
$moduleFieldInfo = array();
$moduleInfo = self::getBasicModuleInfo($mixed);
$module = $moduleInfo['name'];
if(Vtiger_Cache::get('ModuleFieldInfo',$module)){
return Vtiger_Cache::get('ModuleFieldInfo',$module);
}
if ($module) {
$result = $adb->pquery('SELECT * FROM vtiger_field WHERE tabid=?', array(self::getModuleId($module)));
while ($row = $adb->fetch_array($result)) {
$moduleFieldInfo[$module][$row['fieldname']] = $row;
}
Vtiger_Cache::set('ModuleFieldInfo',$module,$moduleFieldInfo[$module]);
}
return $moduleFieldInfo[$module] ? $moduleFieldInfo[$module] : NULL;
}
static function getModuleFieldInfoWithId($fieldid) {
global $adb;
$result = $adb->pquery('SELECT * FROM vtiger_field WHERE fieldid=?', array($fieldid));
return ($adb->num_rows($result))? $adb->fetch_array($result) : NULL;
}
static function getModuleFieldInfo($moduleid, $mixed) {
$field = NULL;
if (empty($moduleid) && is_numeric($mixed)) {
$field = self::getModuleFieldInfoWithId($mixed);
} else {
$fieldsInfo = self::getModuleFieldInfos($moduleid);
if ($fieldsInfo) {
if (is_numeric($mixed)) {
foreach ($fieldsInfo as $name => $row) {
if ($row['fieldid'] == $mixed) {
$field = $row;
break;
}
}
} else { $field = isset($fieldsInfo[$mixed]) ? $fieldsInfo[$mixed] : NULL;
}
}
}
return $field;
}
static function getModuleFieldId($moduleid, $mixed, $onlyactive=true) {
$field = self::getModuleFieldInfo($moduleid, $mixed, $onlyactive);
if ($field) {
if ($onlyactive && ($field['presence'] != '0' && $field['presence'] != '2')) {
$field = NULL;
}
}
return $field ? $field['fieldid'] : false;
}
// Utility
static function formatDecimal($value){
$fld_value = $value;
if(strpos($value, '.')) {
$fld_value = rtrim($value, '0');
}
$value = rtrim($fld_value, '.');
return $value;
}
static function fromHTML($string, $encode=true) {
if (is_string($string)) {
if (preg_match('/(script).*(\/script)/i', $string)) {
$string = preg_replace(array('/</', '/>/', '/"/'), array('<', '>', '"'), $string);
}
}
return $string;
}
static function fromHTML_FCK($string) {
if (is_string($string)) {
if (preg_match('/(script).*(\/script)/i', $string)) {
$string = str_replace('script', '', $string);
}
}
return $string;
}
static function fromHTML_Popup($string, $encode = true) {
$popup_toHtml = array(
'"' => '"',
"'" => ''',
);
//if($encode && is_string($string))$string = html_entity_decode($string, ENT_QUOTES);
if ($encode && is_string($string)) {
$string = addslashes(str_replace(array_values($popup_toHtml), array_keys($popup_toHtml), $string));
}
return $string;
}
static function br2nl($str) {
$str = preg_replace("/(\r\n)/", "\\r\\n", $str);
$str = preg_replace("/'/", " ", $str);
$str = preg_replace("/\"/", " ", $str);
return $str;
}
static function suppressHTMLTags($string) {
return preg_replace(array('/</', '/>/', '/"/'), array('<', '>', '"'), $string);
}
static function getInventoryTermsAndCondition($moduleName) {
global $adb;
$sql = 'SELECT tandc FROM vtiger_inventory_tandc WHERE type = ?';
$result = $adb->pquery($sql, array($moduleName));
$tandc = $adb->query_result($result, 0, 'tandc');
return $tandc;
}
/**
* Function to get group permissions given to config.inc.php file
* @return type
*/
static function getGroupPermissionsFromConfigFile(){
$rootDirectory = vglobal('root_directory');
return exec("ls -l $rootDirectory/config.inc.php | awk 'BEGIN {OFS=\":\"}{print $3,$4}'");
}
static function initStorageFileDirectory() {
$filepath = 'storage/';
$year = date('Y');
$month = date('F');
$day = date('j');
$week = '';
$permissions = self::getGroupPermissionsFromConfigFile();
if (!is_dir($filepath . $year)) {
//create new folder
mkdir($filepath . $year);
$yearPath = $filepath.$year;
exec("chown -R $permissions $yearPath");
}
if (!is_dir($filepath . $year . "/" . $month)) {
//create new folder
$monthFilePath = "$year/$month";
$monthPath = $filepath.$monthFilePath;
mkdir($filepath . $monthFilePath);
exec("chown -R $permissions $monthPath");
}
if ($day > 0 && $day <= 7)
$week = 'week1';
elseif ($day > 7 && $day <= 14)
$week = 'week2';
elseif ($day > 14 && $day <= 21)
$week = 'week3';
elseif ($day > 21 && $day <= 28)
$week = 'week4';
else
$week = 'week5';
if (!is_dir($filepath . $year . "/" . $month . "/" . $week)) {
//create new folder
$weekFilePath = "$year/$month/$week";
$weekPath = $filepath . $weekFilePath;
mkdir($filepath . $weekFilePath );
exec("chown -R $permissions $weekPath");
}
$filepath = $filepath . $year . "/" . $month . "/" . $week . "/";
return $filepath;
}
static function validateImageMetadata($data, $short=true) {
if (is_array($data)) {
foreach ($data as $key => $value) {
$ok = self::validateImageMetadata($value);
if (!$ok) return false;
} } else {
if (stripos($data, $short ? "<?" : "<?php") !== false) { // suspicious dynamic content
return false;
}
}
return true;
}
static function validateImage($file_details) {
global $app_strings;
$allowedImageFormats = array('jpeg', 'png', 'jpg', 'pjpeg', 'x-png', 'gif', 'bmp');
$mimeTypesList = array_merge($allowedImageFormats, array('x-ms-bmp'));//bmp another format
$file_type_details = explode("/", $file_details['type']);
$filetype = $file_type_details['1'];
if ($filetype) {
$filetype = strtolower($filetype);
}
$saveimage = 'true';
if (!in_array($filetype, $allowedImageFormats)) {
$saveimage = 'false';
}
//mime type check
$mimeType = self::mime_content_type($file_details['tmp_name']);
$mimeTypeContents = explode('/', $mimeType);
if (!$file_details['size'] || strtolower($mimeTypeContents[0]) !== 'image' || !in_array($mimeTypeContents[1], $mimeTypesList)) {
$saveimage = 'false';
}
//metadata check
$shortTagSupported = ini_get('short_open_tag') ? true : false;
if ($saveimage == 'true') {
$exifdata = exif_read_data($file_details['tmp_name']);
if ($exifdata && !self::validateImageMetadata($exifdata, $shortTagSupported)) {
$saveimage = 'false';
}
}
// Check for php code injection
if ($saveimage == 'true') {
$imageContents = file_get_contents($file_details['tmp_name']);
if (stripos($imageContents, $shortTagSupported ? "<?" : "<?php") !== false) { // suspicious dynamic content.
$saveimage = 'false';
}
}
return $saveimage;
}
static function getMergedDescription($description, $id, $parent_type, $removeTags = false) {
global $current_user;
$token_data_pair = explode('$', $description);
$emailTemplate = new EmailTemplate($parent_type, $description, $id, $current_user);
$emailTemplate->removeTags = $removeTags;
$description = $emailTemplate->getProcessedDescription();
$tokenDataPair = explode('$', $description);
$fields = Array();
for ($i = 1; $i < count($token_data_pair); $i++) {
$module = explode('-', $tokenDataPair[$i]);
$fields[$module[0]][] = $module[1];
}
if (is_array($fields['custom']) && count($fields['custom']) > 0) {
$description = self::getMergedDescriptionCustomVars($fields, $description,$id,$parent_type);
}
if(is_array($fields['companydetails']) && count($fields['companydetails']) > 0){
$description = self::getMergedDescriptionCompanyDetails($fields,$description);
}
//for merging record id merge tags(eg: $helpdesk-id$) with record values if(is_array($fields) && !empty($fields)) {
foreach ($fields as $moduleName => $fields) {
if(in_array('id',$fields)) {
if(strtolower($parent_type) === $moduleName) {
$needle = "$$moduleName-id$";
$description = str_replace($needle,$id,$description);
}
}
}
}
return $description;
}
/**
* Function replaces all company merge tags will respective value.
* @param type $fields
* @param type $description
* @return type
*/
static function getMergedDescriptionCompanyDetails($fields, $description){
$companyModuleModel = Settings_Vtiger_CompanyDetails_Model::getInstance();
foreach($fields['companydetails'] as $columnname){
$token_data = '$companydetails-' . $columnname . '$';
$token_value = $companyModuleModel->get($columnname);
if(empty($token_value)){
$token_value = '';
}
$description = str_replace($token_data, $token_value, $description);
}
return $description;
}
static function getMergedDescriptionCustomVars($fields, $description, $recordId = '', $module = '') {
global $site_URL, $PORTAL_URL;
foreach ($fields['custom'] as $columnname) {
$token_data = '$custom-' . $columnname . '$';
$token_value = '';
switch ($columnname) {
case 'currentdate' : $token_value = date("F j, Y");
break;
case 'currenttime' : $token_value = date("G:i:s T");
break;
case 'siteurl' : $token_value = $site_URL;
break;
case 'portalurl' : $token_value = $PORTAL_URL;
break;
case 'crmdetailviewurl' : if($module !== 'Users') {
$token_value = $site_URL."/index.php?module=$module&view=Detail&record=$recordId";
} else {
$token_value = $token_data;
}
break;
}
if ($columnname !== 'viewinbrowser') {
$description = str_replace($token_data, $token_value, $description);
}
}
return $description;
}
static function getSingleFieldValue($tablename, $fieldname, $idname, $id) {
global $adb;
$fieldname = Vtiger_Util_Helper::validateStringForSql($fieldname);
$idname = Vtiger_Util_Helper::validateStringForSql($idname);
$fieldval = $adb->query_result($adb->pquery("select $fieldname from $tablename where $idname = ?", array($id)), 0, $fieldname);
return $fieldval;
}
static function getRecurringObjValue() {
$recurring_data = array(); if (isset($_REQUEST['recurringtype']) && $_REQUEST['recurringtype'] != null && $_REQUEST['recurringtype'] != '--None--') {
if (!empty($_REQUEST['date_start'])) {
$startDate = $_REQUEST['date_start'];
}
if (!empty($_REQUEST['calendar_repeat_limit_date'])) {
$endDate = $_REQUEST['calendar_repeat_limit_date'];
$recurring_data['recurringenddate'] = $endDate;
} elseif (isset($_REQUEST['due_date']) && $_REQUEST['due_date'] != null) {
$endDate = $_REQUEST['due_date'];
}
if (!empty($_REQUEST['time_start'])) {
$startTime = $_REQUEST['time_start'];
}
if (!empty($_REQUEST['time_end'])) {
$endTime = $_REQUEST['time_end'];
}
$recurring_data['startdate'] = $startDate;
$recurring_data['starttime'] = $startTime;
$recurring_data['enddate'] = $endDate;
$recurring_data['endtime'] = $endTime;
$recurring_data['type'] = $_REQUEST['recurringtype'];
if ($_REQUEST['recurringtype'] == 'Weekly') {
if (isset($_REQUEST['sun_flag']) && $_REQUEST['sun_flag'] != null)
$recurring_data['sun_flag'] = true;
if (isset($_REQUEST['mon_flag']) && $_REQUEST['mon_flag'] != null)
$recurring_data['mon_flag'] = true;
if (isset($_REQUEST['tue_flag']) && $_REQUEST['tue_flag'] != null)
$recurring_data['tue_flag'] = true;
if (isset($_REQUEST['wed_flag']) && $_REQUEST['wed_flag'] != null)
$recurring_data['wed_flag'] = true;
if (isset($_REQUEST['thu_flag']) && $_REQUEST['thu_flag'] != null)
$recurring_data['thu_flag'] = true;
if (isset($_REQUEST['fri_flag']) && $_REQUEST['fri_flag'] != null)
$recurring_data['fri_flag'] = true;
if (isset($_REQUEST['sat_flag']) && $_REQUEST['sat_flag'] != null)
$recurring_data['sat_flag'] = true;
}
elseif ($_REQUEST['recurringtype'] == 'Monthly') {
if (isset($_REQUEST['repeatMonth']) && $_REQUEST['repeatMonth'] != null)
$recurring_data['repeatmonth_type'] = $_REQUEST['repeatMonth'];
if ($recurring_data['repeatmonth_type'] == 'date') {
if (isset($_REQUEST['repeatMonth_date']) && $_REQUEST['repeatMonth_date'] != null)
$recurring_data['repeatmonth_date'] = $_REQUEST['repeatMonth_date'];
else
$recurring_data['repeatmonth_date'] = 1;
}
elseif ($recurring_data['repeatmonth_type'] == 'day') {
$recurring_data['repeatmonth_daytype'] = $_REQUEST['repeatMonth_daytype'];
switch ($_REQUEST['repeatMonth_day']) {
case 0 :
$recurring_data['sun_flag'] = true;
break;
case 1 :
$recurring_data['mon_flag'] = true;
break;
case 2 :
$recurring_data['tue_flag'] = true;
break;
case 3 :
$recurring_data['wed_flag'] = true;
break;
case 4 :
$recurring_data['thu_flag'] = true;
break;
case 5 :
$recurring_data['fri_flag'] = true;
break;
case 6 : $recurring_data['sat_flag'] = true;
break;
}
}
}
if (isset($_REQUEST['repeat_frequency']) && $_REQUEST['repeat_frequency'] != null)
$recurring_data['repeat_frequency'] = $_REQUEST['repeat_frequency'];
$recurObj = RecurringType::fromUserRequest($recurring_data);
return $recurObj;
}
}
static function getTicketComments($ticketid) {
global $adb;
$moduleName = getSalesEntityType($ticketid);
$commentlist = '';
$sql = "SELECT commentcontent FROM vtiger_modcomments WHERE related_to = ?";
$result = $adb->pquery($sql, array($ticketid));
for ($i = 0; $i < $adb->num_rows($result); $i++) {
$comment = $adb->query_result($result, $i, 'commentcontent');
if ($comment != '') {
$commentlist .= '<br><br>' . $comment;
}
}
if ($commentlist != '')
$commentlist = '<br><br>' . getTranslatedString("The comments are", $moduleName) . ' : ' . $commentlist;
return $commentlist;
}
static function generateRandomPassword() {
$salt = "abcdefghijklmnopqrstuvwxyz0123456789";
srand((double) microtime() * 1000000);
$i = 0;
while ($i <= 7) {
$num = rand() % 33;
$tmp = substr($salt, $num, 1);
$pass = $pass . $tmp;
$i++;
}
return $pass;
}
static function getTagCloudView($id = "") {
global $adb;
if ($id == '') {
$tag_cloud_status = 1;
} else {
$query = "select visible from vtiger_homestuff where userid=? and stufftype='Tag Cloud'";
$res = $adb->pquery($query, array($id));
$tag_cloud_status = $adb->query_result($res, 0, 'visible');
}
if ($tag_cloud_status == 0) {
$tag_cloud_view = 'true';
} else {
$tag_cloud_view = 'false';
}
return $tag_cloud_view;
}
static function transformFieldTypeOfData($table_name, $column_name, $type_of_data) {
$field = $table_name . ":" . $column_name;
//Add the field details in this array if you want to change the advance filter field details
static $new_field_details = Array(
//Contacts Related Fields
"vtiger_contactdetails:accountid" => "V",
"vtiger_contactsubdetails:birthday" => "D",
"vtiger_contactdetails:email" => "V", "vtiger_contactdetails:secondaryemail" => "V",
//Potential Related Fields
"vtiger_potential:campaignid" => "V",
//Account Related Fields
"vtiger_account:parentid" => "V",
"vtiger_account:email1" => "V",
"vtiger_account:email2" => "V",
//Lead Related Fields
"vtiger_leaddetails:email" => "V",
"vtiger_leaddetails:secondaryemail" => "V",
//Documents Related Fields
"vtiger_senotesrel:crmid" => "V",
//Calendar Related Fields
"vtiger_seactivityrel:crmid" => "V",
"vtiger_seactivityrel:contactid" => "V",
"vtiger_recurringevents:recurringtype" => "V",
//HelpDesk Related Fields
"vtiger_troubletickets:parent_id" => "V",
"vtiger_troubletickets:product_id" => "V",
//Product Related Fields
"vtiger_products:discontinued" => "C",
"vtiger_products:vendor_id" => "V",
"vtiger_products:parentid" => "V",
//Faq Related Fields
"vtiger_faq:product_id" => "V",
//Vendor Related Fields
"vtiger_vendor:email" => "V",
//Quotes Related Fields
"vtiger_quotes:potentialid" => "V",
"vtiger_quotes:inventorymanager" => "V",
"vtiger_quotes:accountid" => "V",
//Purchase Order Related Fields
"vtiger_purchaseorder:vendorid" => "V",
"vtiger_purchaseorder:contactid" => "V",
//SalesOrder Related Fields
"vtiger_salesorder:potentialid" => "V",
"vtiger_salesorder:quoteid" => "V",
"vtiger_salesorder:contactid" => "V",
"vtiger_salesorder:accountid" => "V",
//Invoice Related Fields
"vtiger_invoice:salesorderid" => "V",
"vtiger_invoice:contactid" => "V",
"vtiger_invoice:accountid" => "V",
//Campaign Related Fields
"vtiger_campaign:product_id" => "V",
//Related List Entries(For Report Module)
"vtiger_activityproductrel:activityid" => "V",
"vtiger_activityproductrel:productid" => "V",
"vtiger_campaigncontrel:campaignid" => "V",
"vtiger_campaigncontrel:contactid" => "V",
"vtiger_campaignleadrel:campaignid" => "V",
"vtiger_campaignleadrel:leadid" => "V",
"vtiger_cntactivityrel:contactid" => "V",
"vtiger_cntactivityrel:activityid" => "V",
"vtiger_contpotentialrel:contactid" => "V",
"vtiger_contpotentialrel:potentialid" => "V",
"vtiger_pricebookproductrel:pricebookid" => "V",
"vtiger_pricebookproductrel:productid" => "V",
"vtiger_seactivityrel:crmid" => "V",
"vtiger_seactivityrel:activityid" => "V",
"vtiger_senotesrel:crmid" => "V",
"vtiger_senotesrel:notesid" => "V",
"vtiger_seproductsrel:crmid" => "V",
"vtiger_seproductsrel:productid" => "V",
"vtiger_seticketsrel:crmid" => "V",
"vtiger_seticketsrel:ticketid" => "V",
"vtiger_vendorcontactrel:vendorid" => "V",
"vtiger_vendorcontactrel:contactid" => "V",
"vtiger_pricebook:currency_id" => "V",
);
//If the Fields details does not match with the array, then we return the same typeofdata
if (isset($new_field_details[$field])) {
$type_of_data = $new_field_details[$field];
}
return $type_of_data;
}
static function getPickListValuesFromTableForRole($tablename, $roleid) {
global $adb;
$tablename = Vtiger_Util_Helper::validateStringForSql($tablename);
$query = "select $tablename from vtiger_$tablename inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_$tablename.picklist_valueid where roleid=? and picklistid in (select picklistid from vtiger_picklist) order by sortorderid";
$result = $adb->pquery($query, array($roleid));
$fldVal = Array();
while ($row = $adb->fetch_array($result)) {
$fldVal [] = $row[$tablename];
}
return $fldVal;
}
static function getActivityType($id) {
global $adb;
$query = "select activitytype from vtiger_activity where activityid=?";
$res = $adb->pquery($query, array($id));
$activity_type = $adb->query_result($res, 0, "activitytype");
return $activity_type;
}
static function getInvoiceStatus($id) {
global $adb;
$result = $adb->pquery("SELECT invoicestatus FROM vtiger_invoice where invoiceid=?", array($id));
$invoiceStatus = $adb->query_result($result,0,'invoicestatus');
return $invoiceStatus;
}
static function mkCountQuery($query) {
// Remove all the \n, \r and white spaces to keep the space between the words consistent.
// This is required for proper pattern matching for words like ' FROM ', 'ORDER BY', 'GROUP BY' as they depend on the spaces between the words.
$query = preg_replace("/[\n\r\s]+/"," ",$query);
//Strip of the current SELECT fields and replace them by "select count(*) as count"
// Space across FROM has to be retained here so that we do not have a clash with string "from" found in select clause
$query = "SELECT count(*) AS count ".substr($query, stripos($query,' FROM '),strlen($query));
//Strip of any "GROUP BY" clause
if(stripos($query,'GROUP BY') > 0)
$query = substr($query, 0, stripos($query,'GROUP BY'));
//Strip of any "ORDER BY" clause
if(stripos($query,'ORDER BY') > 0)
$query = substr($query, 0, stripos($query,'ORDER BY'));
return $query;
}
/** Function to get unitprice for a given product id
* @param $productid -- product id :: Type integer
* @returns $up -- up :: Type string
*/
static function getUnitPrice($productid, $module='Products') {
$adb = PearDatabase::getInstance();
if($module == 'Services') {
$query = "select unit_price from vtiger_service where serviceid=?";
} else {
$query = "select unit_price from vtiger_products where productid=?";
}
$result = $adb->pquery($query, array($productid));
$unitpice = $adb->query_result($result,0,'unit_price');
return $unitpice;
}
/**
* Function to fetch the list of vtiger_groups from group vtiger_table
* Takes no value as input
* returns the query result set object
*/
static function get_group_options() {
global $adb, $noof_group_rows;
$sql = "select groupname,groupid from vtiger_groups";
$result = $adb->pquery($sql, array());
$noof_group_rows = $adb->num_rows($result);
return $result;
}
/**
* Function to determine mime type of file.
* Compatible with mime_magic or fileinfo php extension.
*/
static function mime_content_type($filename) {
$type = null;
if (function_exists('mime_content_type')) {
$type = mime_content_type($filename);
} else if (function_exists('finfo_open')) {
$finfo = finfo_open(FILEINFO_MIME_TYPE);
$type = finfo_file($finfo, $filename);
finfo_close($finfo);
} else {
throw new Exception('mime_magic or fileinfo extension required.');
}
return $type;
}
/**
* Check the file MIME Type
* @param $targetFile Filepath to validate
* @param $claimedMime Array of bad file extenstions
*/
static function verifyClaimedMIME($targetFile,$claimedMime) {
$fileMimeContentType= self::mime_content_type($targetFile);
if (in_array(strtolower($fileMimeContentType), $claimedMime)) {
return false;
}
return true;
}
/*
* Function to generate encrypted password.
*/
static function generateEncryptedPassword($password, $mode='') {
if ($mode == '') {
$mode = (version_compare(PHP_VERSION, '5.5.0') >= 0)? 'PHASH' : 'CRYPT';
}
if ($mode == 'PHASH') return password_hash($password, PASSWORD_DEFAULT);
if ($mode == 'MD5') return md5($password);
if ($mode == 'CRYPT') {
$salt = null;
if (function_exists('password_hash')) { // php 5.5+
$salt = password_hash($password, PASSWORD_DEFAULT);
} else {
$salt = '$2y$11$'.str_replace("+",".",substr(base64_encode(openssl_random_pseudo_bytes(17)),0,22));
}
return crypt($password, $salt);
}
throw new Exception('Invalid encryption mode: '.$mode);
}
/*
* Function to compare encrypted password.
*/
static function compareEncryptedPassword($plainText, $encryptedPassword, $mode='CRYPT') {
$reEncryptedPassword = null;
switch ($mode) {
case 'PHASH': return password_verify($plainText, $encryptedPassword);
case 'CRYPT': $reEncryptedPassword = crypt($plainText, $encryptedPassword); break;
case 'MD5' : $reEncryptedPassword = md5($plainText); break;
default : $reEncryptedPassword = $plainText; break;
}
return ($reEncryptedPassword == $encryptedPassword);
}
/**
* Function to get modules which has line items
* @returns array of modules
*/
static function getLineItemFieldModules() {
return array('Invoice', 'Quotes', 'PurchaseOrder', 'SalesOrder', 'Products', 'Services');
}
/**
* Function to encode an array to json with all the options
* @param <Array> $array
* @return <sting> Json String
*/
static function jsonEncode($array) {
return json_encode($array, JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_QUOT | JSON_HEX_AMP | JSON_UNESCAPED_UNICODE);
}
/**
* Function to get the special date conditions
* @return <array> array of special date conditions
*/
static function getSpecialDateConditions() {
return array('lessthandaysago', 'morethandaysago', 'inlessthan', 'inmorethan', 'daysago', 'dayslater');
}
/**
* Function to get the special time conditions
* @return <array> array of special time conditions
*/
static function getSpecialTimeConditions() {
return array('lessthanhoursbefore', 'lessthanhourslater', 'morethanhoursbefore', 'morethanhourslater');
}
/**
* Function to get the special date and time conditions
* @return <array> array of special date and time conditions
*/
static function getSpecialDateTimeCondtions() {
return array_merge(self::getSpecialDateConditions(), self::getSpecialTimeConditions());
}
/**
* Function to get track email image contents
* @param $recordId Email record Id
* @param $parentId Parent record Id of Email record
* @return string returns track image contents
*/
static function getTrackImageContent($recordId, $parentId) {
$siteURL = vglobal('site_URL');
$applicationKey = vglobal('application_unique_key');
$trackURL = "$siteURL/modules/Emails/actions/TrackAccess.php?record=$recordId&parentId=$parentId&applicationKey=$applicationKey";
$imageDetails = "<img src='$trackURL' alt='' width='1' height='1'>";
return $imageDetails;
}
/** * Function to get the list of urls from html content
* @param <string> $content
* @return <array> $urls
*/
public static function getUrlsFromHtml($content) {
$doc = new DOMDocument();
$urls = array();
//handling utf8 characters present in the template source
$formattedContent = mb_convert_encoding($content, 'HTML-ENTITIES', "UTF-8");
if(empty($formattedContent)) return $urls;
$doc->loadHTML($formattedContent);
$tags = $doc->getElementsByTagName('a');
foreach ($tags as $tag) {
$hrefTag = $tag->getAttribute('href');
//If href start with mailto:,tel:,# then skip those URLS from tracking
if (strpos($hrefTag, 'mailto:') !== 0 && strpos($hrefTag, 'tel:') !== 0 && $hrefTag[0] !== self::LINK_TO_ANCHOR_TEXT_SYMBOL) {
$urls[$hrefTag][] = $tag->nodeValue;
}
}
return $urls;
}
static function redirectUrl($targetUrl) {
$regExp = "~^(?:f|ht)tps?://~i"; // This regular expression is to detect if targetUrl which was stored in database contains
//http:// or https:// then it will redirect as normal if not for target http:// will prepend and then redirect
if (!preg_match($regExp, $targetUrl)) {
return header("Location:http://" . $targetUrl);
}
return header("Location:" . $targetUrl);
}
/**
* Function to check if a string is a valid date value or not
* @param string $value string to check if that is a date value or not
* @return boolean Returns true if $value is date else returns false
*/
static function isDateValue($value) {
$valueParts = explode('-', $value);
if (count($valueParts) == 3 && (strlen($valueParts[0]) == 4 || strlen($valueParts[1]) == 4 || strlen($valueParts[2]) == 4)) {
$time = strtotime($value);
if ($time && $time > 0) {
return true;
} else {
return false;
}
} else {
return false;
}
}
/**
* Function to get name and email value from a string of format <b>Your Name<youremail@company.com></b>
* @param String $string Name and email value in required format.
* @return Array Returns array of name and email in format <b><br>Array(<br>	name => Your Name,<br>	email => youemail@company.com<br>)</b>
* @return Boolean Returns FALSE if given string doesn't match required format.
*/
static function extractNameEmail($string) {
$pattern = '/([(\w+) ]+)(<)([\\w-+]+(?:\\.[\\w-+]+)*@(?:[\\w-]+\\.)+[a-zA-Z]{2,7})(>)/is';
if (preg_match($pattern, $string, $matches)) {
return array('name' => $matches[1], 'email' => $matches[3]);
}
return false;
}
/**
* Function to get value for all mandatory relation field of a module (except Users).
* @param String $module Module for which mandatory relation field is needed * @param String $mode (Optional) Label or Id for relation fields. Default label
* @return Array Returns array of all mandatory relation field values
*/
public static function getMandatoryReferenceFields($module, $mode = 'label') {
$mandatoryReferenceFields = array();
$userId = Users::getActiveAdminId();
$db = PearDatabase::getInstance();
$moduleInstance = Vtiger_Module_Model::getInstance($module);
$referenceFields = $moduleInstance->getFieldsByType(array('reference', 'multireference'));
foreach ($referenceFields as $field => $fieldModel) {
$uiType = $fieldModel->get('uitype');
$referenceModules = $fieldModel->getReferenceList();
if (!is_array($referenceModules)) {
$referenceModules = array($referenceModules);
}
$referenceModule = $referenceModules[0];
if ($fieldModel->isMandatory() && !empty($referenceModule) && !in_array($uiType, array(50, 51, 52))) {
$recordName = '?????';
$result = $db->pquery("SELECT crmid, label FROM vtiger_crmentity WHERE label LIKE ? AND deleted = ? AND setype = ?", array("%$recordName%", 0, $referenceModule));
if ($db->num_rows($result) < 1) {
$moduleModel = Vtiger_Module_Model::getInstance($referenceModule);
$recordModel = Vtiger_Record_Model::getCleanInstance($referenceModule);
$fieldInstances = Vtiger_Field_Model::getAllForModule($moduleModel);
foreach ($fieldInstances as $blockInstance) {
foreach ($blockInstance as $fieldInstance) {
$fieldName = $fieldInstance->getName();
$defaultValue = $fieldInstance->getDefaultFieldValue();
$dataType = $fieldInstance->getFieldDataType();
if ($defaultValue) {
$recordModel->set($fieldName, decode_html($defaultValue));
}
if ($fieldInstance->isMandatory() && !$defaultValue && !in_array($dataType, array('reference', 'multireference'))) {
$randomValue = Vtiger_Util_Helper::getDefaultMandatoryValue($fieldInstance->getFieldDataType());
if ($dataType == 'picklist' || $dataType == 'multipicklist') {
$picklistValues = $fieldInstance->getPicklistValues();
$randomValue = reset($picklistValues);
}
$recordModel->set($fieldName, $randomValue);
}
$referenceRelationFields = Vtiger_Functions::getMandatoryReferenceFields($referenceModule, 'id');
foreach ($referenceRelationFields as $relationFieldName => $relationValue) {
$recordModel->set($relationFieldName, $relationValue);
}
}
}
$recordModel->set('mode', '');
$recordModel->set('assigned_user_id', $userId);
$recordModel->save();
if ($mode == 'label') {
$recordName = Vtiger_Util_Helper::getRecordName($recordModel->getId());
} else {
$recordName = $recordModel->getId();
}
} else {
if ($mode == 'label') {
$recordName = $db->query_result($result, 0, 'label');
} else {
$recordName = $db->query_result($result, 0, 'crmid');
}
}
$mandatoryReferenceFields[$field] = $recordName;
}
}
return $mandatoryReferenceFields;
}
static function setEventsContactIdToRequest($recordId) {
$db = PearDatabase::getInstance();
$contactIds = array();
$result = $db->pquery("SELECT contactid FROM vtiger_cntactivityrel WHERE activityid = ?", array($recordId));
$count = $db->num_rows($result);
for ($i = 0; $i < $count; $i++) {
$contactIds[] = $db->query_result($result, $i, 'contactid');
}
$_REQUEST['contactidlist'] = implode(';', $contactIds);
}
static function getNonQuickCreateSupportedModules() {
$nonQuickCreateModules = array();
$modules = Vtiger_Module_Model::getAll(array(0, 2));
foreach ($modules as $module) {
if (!$module->isQuickCreateSupported()) {
$nonQuickCreateModules[] = $module->getName();
}
}
return $nonQuickCreateModules;
}
static function getPrivateCommentModules() {
return array('HelpDesk', 'Faq');
}
/**
* Function which will return user field table for a module
* @param type $moduleName -- module for which table name need to be retrieved
* @return type -- table name
*/
public static function getUserSpecificTableName($moduleName) {
return 'vtiger_crmentity_user_field';
}
/**
* Function which will determine whether the table contains user specific field
* @param type $tableName -- name of the table
* @param type $moduleName -- moduleName
* @return boolean
*/
public static function isUserSpecificFieldTable($tableName, $moduleName) {
$moduleName = strtolower($moduleName);
return (self::getUserSpecificTableName($moduleName) == $tableName) ? true : false;
}
public static function isUserExist($userId) {
$adb = PearDatabase::getInstance();
$query = "SELECT 1 FROM vtiger_users WHERE id=? AND deleted=? AND status = ?";
$result = $adb->pquery($query, array($userId, 0, 'Active'));
if ($adb->num_rows($result) > 0) {
return true;
} else {
return false;
}
}
/**
* Function to decode JWT web token
* @param <string> $id_token
* @return <array>
*/
static function jwtDecode($id_token) {
$token_parts = explode(".", $id_token);
// First, in case it is url-encoded, fix the characters to be
// valid base64
$encoded_token = str_replace('-', '+', $token_parts[1]);
$encoded_token = str_replace('_', '/', $encoded_token);
// Next, add padding if it is needed. switch (strlen($encoded_token) % 4) {
case 0: break;// No pad characters needed.
case 2: $encoded_token = $encoded_token . "=="; break;
case 3: $encoded_token = $encoded_token . "="; break;
default:return null;// Invalid base64 string!
}
$json_string = base64_decode($encoded_token);
$jwt = json_decode($json_string, true);
return $jwt;
}
/**
* Function to mask input text.
*/
static function toProtectedText($text) {
if (empty($text)) return $text;
require_once 'include/utils/encryption.php';
$encryption = new Encryption();
return '$ve$'.$encryption->encrypt($text);
}
/*
* Function to determine if text is masked.
*/
static function isProtectedText($text) {
return !empty($text) && (strpos($text, '$ve$') === 0);
}
/*
* Function to unmask the text.
*/
static function fromProtectedText($text) {
if (static::isProtectedText($text)) {
require_once 'include/utils/encryption.php';
$encryption = new Encryption();
return $encryption->decrypt(substr($text, 4));
}
return $text;
}
/*
* Function to convert file size in bytes to user displayable format
*/
static function convertFileSizeToUserFormat($sizeInBytes) {
$fileSizeUnits = array('KB', 'MB', 'GB', 'TB', 'PB', 'EB', 'ZB', 'YB');
$i = -1;
do {
$sizeInBytes = $sizeInBytes / 1024;
$i++;
} while ($sizeInBytes > 1024);
return round($sizeInBytes, 2) . $fileSizeUnits[$i];
}
/**
* Function to check if a module($sourceModule) is related to Documents module.
* @param <string> $sourceModule - Source module
* @return <boolean> Returns TRUE if $sourceModule is related to Documents module and
* Documents module is active else returns FALSE.
*/
static function isDocumentsRelated($sourceModule) {
$isRelated = false;
$moduleName = 'Documents';
if (vtlib_isModuleActive($moduleName)) {
$moduleModel = Vtiger_Module_Model::getInstance($moduleName);
$sourceModuleModel = Vtiger_Module_Model::getInstance($sourceModule);
if ($moduleModel && $sourceModuleModel) {
$relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, $moduleModel);
} if ($relationModel) {
$isRelated = true;
}
}
return $isRelated;
}
/**
* Function to Escapes special characters in a string for use in an SQL statement
* @param type $value
* @return type
*/
static function realEscapeString($value){
$db = PearDatabase::getInstance();
$value = $db->sql_escape_string($value);
return $value;
}
/**
* Request parameters and it's type.
* @var type
*/
protected static $type = array(
'record' => 'id',
'src_record' => 'id',
'parent_id' => 'id',
'_mfrom' => 'email',
'_mto' => 'email',
'sequencesList' => 'idlist',
'search_value' => 'keyword',
);
/**
* Function to validate request parameters.
* @param type $request
* @throws Exception - Bad Request
*/
public static function validateRequestParameters($request) {
foreach (self::$type as $param => $type) {
if ( isset($request[$param])&& $request[$param] && !self::validateRequestParameter($type, $request[$param])) {
http_response_code(400);
throw new Exception('Bad Request');
}
}
}
/**
* Function to validate request parameter by it's type.
* @param <String> type - Type of paramter.
* @param <String> $value - Which needs to be validated.
* @return <Boolean>
*/
public static function validateRequestParameter($type, $value) {
$ok = true;
switch ($type) {
case 'id' : $ok = (preg_match('/[^0-9xH]/', $value)) ? false : $ok;
break;
case 'email' : $ok = (!filter_var($value, FILTER_VALIDATE_EMAIL)) ? false : $ok;
break;
case 'idlist' : $ok = (preg_match('/[a-zA-Z]/', $value)) ? false : $ok;
break;
case 'keyword':
$blackList = array('UNION', '--', 'SELECT ', 'SELECT*', '%', 'NULL', 'HEX');
foreach ($blackList as $keyword) {
if (stripos($value, $keyword) !== false) {
$ok = false;
break;
}
}
break; }
return $ok;
}
/**
* Function to get file public url to access outside of CRM (from emails)
* @param <Integer> $fileId
* @param <String> $fileName
* @return <String> $sourceUrl
*/
public static function getFilePublicURL($imageId, $imageName) {
$publicUrl = '';
$fileId = $imageId;
$fileName = $imageName;
if ($fileId) {
$publicUrl = "public.php?fid=$fileId&key=".$fileName;
}
return $publicUrl;
}
/**
* Function to get the attachmentsid to given crmid
* @param type $crmid
* @param type $webaservice entity id
* @return <Array>
*/
static function getAttachmentIds($crmid, $WsEntityId) {
$adb = PearDatabase::getInstance();
$attachmentIds = false;
if(!empty($crmid)) {
$query = "SELECT attachmentsid FROM vtiger_seattachmentsrel WHERE crmid = ?";
$result = $adb->pquery($query, array($crmid));
$noofrows = $adb->num_rows($result);
if ($noofrows > 1) {
for ($i = 0; $i < $noofrows; $i++) {
$attachmentIds[] = vtws_getId($WsEntityId,$adb->query_result($result, $i, 'attachmentsid'));
}
} else if($noofrows > 0){
$attachmentIds[] = vtws_getId($WsEntityId, $adb->query_result($result, 0, 'attachmentsid'));
}
}
return $attachmentIds;
}
}