template = $templateString;
}
function render($entityCache, $entityId){
$this->cache = $entityCache;
$this->parent = $this->cache->forId($entityId);
return $this->parseTemplate();
}
private function matchHandler($match){
preg_match('/\((\w+) : \(([_\w]+)\) (\w+)\)/', $match[1], $matches);
if ($match[1] == 'logo') {
return $this->getMetaValue($match[1]);
}
// If parent is empty then we can't do any thing here
if(!empty($this->parent)){
if(count($matches)==0){
$fieldname = $match[1];
//To handle comments for this module
if (in_array($fieldname, array('lastComment', 'last5Comments', 'allComments'))) {
return $this->getComments($this->parent->getModuleName(), $fieldname, $this->parent->getId());
}
$data = $this->parent->getData();
if(isset($data[$fieldname]) || $fieldname === '_DATE_FORMAT_') {
if($this->useValue($data, $fieldname)){
$result = $this->transformToUserFormat($this->parent->getModuleName(), $fieldname, $data[$fieldname]);
} else {
$result ='';
}
} else {
$result ='$'.$fieldname;
}
}else{
list($full, $referenceField, $referenceModule, $fieldname) = $matches;
if($referenceModule === '__VtigerMeta__' || $fieldname === 'dbLabel') {
$result = $this->getMetaValue($fieldname);
}else{
$referenceId = $this->parent->get($referenceField);
if($referenceId==null){
$result="";
}else{
//To handle comments for this reference module
if (in_array($fieldname, array('lastComment', 'last5Comments', 'allComments'))) {
return $this->getComments($referenceModule, $fieldname, $referenceId);
}
if ($referenceField === 'contact_id') {
$referenceIdsList = explode(',', $referenceId);
$parts = array();
foreach ($referenceIdsList as $referenceId) {
$entity = $this->cache->forId($referenceId);
$data = $entity->getData();
if($this->useValue($data, $fieldname)) {
$parts[] = $this->transformToUserFormat($referenceModule, $fieldname, $data[$fieldname]);
}
}
return implode(',', $parts);
}
$entity = $this->cache->forId($referenceId);
if($referenceModule==="Users" && $entity->getModuleName()=="Groups"){
list($groupEntityId, $groupId) = vtws_getIdComponents($referenceId);
require_once('include/utils/GetGroupUsers.php');
$ggu = new GetGroupUsers();
$ggu->getAllUsersInGroup($groupId);
$users = $ggu->group_users;
$parts = Array();
foreach($users as $userId){
$refId = vtws_getWebserviceEntityId("Users", $userId);
$entity = $this->cache->forId($refId);
$data = $entity->getData();
if($this->useValue($data, $fieldname)){
$parts[] = $this->transformToUserFormat($referenceModule, $fieldname, $data[$fieldname]);
}
}
$result = implode(", ", $parts);
} elseif($entity->getModuleName()===$referenceModule){
$data = $entity->getData();
if($this->useValue($data, $fieldname)){
$handler = vtws_getModuleHandlerFromName($referenceModule, $this->cache->user);
$meta = $handler->getMeta();
$referenceFieldList = $meta->getReferenceFieldDetails();
if(array_key_exists($fieldname,$referenceFieldList)) {
$webserviceId = $data[$fieldname];
$idComponents = vtws_getIdComponents($webserviceId);
if($fieldname == 'currency_id' && $referenceModule == 'Users') {
$result = decode_html(getCurrencyName($idComponents[1]));
} else {
$result = decode_html(Vtiger_Util_Helper::getLabel($idComponents[1]));
}
}else{
$result = $this->transformToUserFormat($referenceModule, $fieldname, $data[$fieldname]);
}
}else{
$result = '';
}
}else{
$result = '';
}
}
}
}
}
return $result;
}
protected function useValue($data, $fieldname) {
return true;
}
function parseTemplate(){
return preg_replace_callback('/\\$(\w+|\((\w+) : \(([_\w]+)\) (\w+)\))/', array($this,"matchHandler"), $this->template);
}
function getMetaValue($fieldname){
require_once 'config.inc.php';
global $site_URL, $PORTAL_URL, $current_user, $HELPDESK_SUPPORT_NAME, $HELPDESK_SUPPORT_EMAIL_ID;
switch($fieldname){
case 'date' : $referenceId = $this->parent->get('assigned_user_id');
if ($referenceId) {
$entity = $this->cache->forId($referenceId);
list($entityId, $ownerId) = vtws_getIdComponents($referenceId);
if($entity->getModuleName() === 'Groups') {
list($moduleId, $recordId) = vtws_getIdComponents($this->parent->getId());
$ownerId = Vtiger_Util_Helper::getCreator($recordId);
}
}
$ownerObject = new Users();
$ownerObject->retrieveCurrentUserInfoFromFile($ownerId);
$date = new DateTimeField(null);
return $date->getDisplayDate($ownerObject);
case 'time' : return Vtiger_Util_Helper::convertTimeIntoUsersDisplayFormat(date('h:i:s'));
case 'dbtimezone' : return DateTimeField::getDBTimeZone();
case 'usertimezone' : $referenceId = $this->parent->get('assigned_user_id');
if ($referenceId) {
$entity = $this->cache->forId($referenceId);
list($entityId, $ownerId) = vtws_getIdComponents($referenceId);
if($entity->getModuleName() === 'Groups') {
list($moduleId, $recordId) = vtws_getIdComponents($this->parent->getId());
$ownerId = Vtiger_Util_Helper::getCreator($recordId);
}
}
if ($ownerId) {
$ownerFocus = CRMEntity::getInstance('Users');
$ownerFocus->retrieve_entity_info($ownerId, 'Users');
return getTranslatedString($ownerFocus->column_fields['time_zone'], 'Users');
}
return '';
case 'crmdetailviewurl' : $wsId = $this->parent->getId();
$parts = explode('x', $wsId);
$recordId = $parts[1];
$moduleName = $this->parent->getModuleName();
return "$site_URL/index.php?module=$moduleName&view=Detail&record=$recordId";
case 'portaldetailviewurl' : $wsId = $this->parent->getId();
$parts = explode('x', $wsId);
$recordId = $parts[1];
$moduleName = $this->parent->getModuleName();
$recorIdName='id';
if($moduleName == 'HelpDesk') $recorIdName = 'ticketid';
if($moduleName == 'Faq') $recorIdName = 'faqid';
if($moduleName == 'Products') $recorIdName = 'productid';
return $PORTAL_URL.'/index.php?module='.$moduleName.'&action=index&'.$recorIdName.'='.$recordId.'&status=true';
case 'portalpdfurl' : $wsId = $this->parent->getId();
$parts = explode('x', $wsId);
$recordId = $parts[1];
$moduleName = $this->parent->getModuleName();
$recorIdName='id';
return $PORTAL_URL.'/index.php?module='.$moduleName.'&action=index&'.$recorIdName.'='.$recordId.'&downloadfile=true';
case 'siteurl' : return $site_URL;
case 'portalurl' : return $PORTAL_URL;
case 'logo' : return '
';
case 'recordId' : list($moduleId, $recordId) = vtws_getIdComponents($this->parent->getId());
return $recordId;
case 'supportName' : return $HELPDESK_SUPPORT_NAME;
case 'supportEmailId' : return $HELPDESK_SUPPORT_EMAIL_ID;
default: '';
}
}
/**
* Function to transform the field values into user format
* @param $moduleName
* @param $fieldName
* @param $fieldValue
* @return $fieldValue
*/
public function transformToUserFormat($moduleName, $fieldName, $fieldValue) {
global $adb, $log, $current_user;
//getting owner info
$referenceId = $this->parent->get('assigned_user_id');
if ($referenceId) {
$entity = $this->cache->forId($referenceId);
list($entityId, $ownerId) = vtws_getIdComponents($referenceId);
if($entity->getModuleName() === 'Groups') {
list($moduleId, $recordId) = vtws_getIdComponents($this->parent->getId());
$ownerId = Vtiger_Util_Helper::getCreator($recordId);
}
}
if(!empty($ownerId)) {
$ownerObject = new Users();
$ownerObject->retrieveCurrentUserInfoFromFile($ownerId);
}
if ($ownerObject && $fieldName === '_DATE_FORMAT_') {
return $ownerObject->column_fields['date_format'];
}
//getting field instance info
$entityObject = VtigerWebserviceObject::fromName($adb, $moduleName);
$handlerPath = $entityObject->getHandlerPath();
$handlerClass = $entityObject->getHandlerClass();
require_once $handlerPath;
$entityHandler = new $handlerClass($entityObject, $current_user, $adb, $log);
$entityMeta = $entityHandler->getMeta();
$entityFields = $entityMeta->getModuleFields();
$fieldInstance = $entityFields[$fieldName];
switch($fieldInstance->getFieldDataType()) {
case 'date' : if (($moduleName === 'Events' && in_array($fieldName, array('date_start', 'due_date'))) ||
($moduleName === 'Calendar' && $fieldName === 'date_start')) {
if ($fieldName === 'date_start') {
$dateTime = $this->parent->get('date_start') .' '. $this->parent->get('time_start');
} else {
$dateTime = $this->parent->get('due_date') .' '. $this->parent->get('time_end');
}
$fieldValue = Vtiger_Util_Helper::convertDateTimeIntoUsersDisplayFormat($dateTime, $ownerObject);
} else {
$dateFieldObj = new DateTimeField($fieldValue);
$fieldValue = $dateFieldObj->getDisplayDate($ownerObject);
}
break;
case 'datetime' : $fieldValue = Vtiger_Util_Helper::convertDateTimeIntoUsersDisplayFormat($fieldValue, $ownerObject);
break;
case 'currency' : if ($fieldInstance->getUIType() === '72') {
$fieldValue = CurrencyField::convertToUserFormat($fieldValue, $ownerObject, true);
} else if($fieldInstance->getUIType() == '71') {
$fieldValue = CurrencyField::convertToUserFormat($fieldValue, $ownerObject);
}
break;
case 'time' : $fieldValue = Vtiger_Util_Helper::convertTimeIntoUsersDisplayFormat($fieldValue, $ownerObject);
break;
case 'picklist' : require_once 'includes/runtime/LanguageHandler.php';
require_once 'includes/runtime/Globals.php';
$fieldValue = vtranslate($fieldValue,$moduleName,$ownerObject->column_fields['language']);
break;
case 'multipicklist' : require_once 'includes/runtime/LanguageHandler.php';
require_once 'includes/runtime/Globals.php';
$fieldValueParts = explode(';',$fieldValue);
foreach($fieldValueParts as $index=>$fieldValue) {
$fieldValueParts[$index] = vtranslate($fieldValue,$moduleName,$ownerObject->column_fields['language']);
}
$fieldValue = implode(';', $fieldValueParts);
break;
case 'boolean' : require_once 'includes/runtime/LanguageHandler.php';
require_once 'includes/runtime/Globals.php';
if($fieldValue == 1){
$fieldValue = vtranslate('LBL_YES',$moduleName);
}else {
$fieldValue = vtranslate('LBL_NO',$moduleName);
}
break;
case 'reference' : if($fieldName == 'currency_id') {
$currencyId = explode('x', $fieldValue);
$currencyId = $currencyId[1];
$fieldValue = decode_html(getCurrencyName($currencyId));
}else{
if($fieldValue != 0 && $fieldValue != null){
$id = explode('x', $fieldValue);
$webServiceObject = VtigerWebserviceObject::fromId($adb,$id[0]);
if($webServiceObject){
$Value = getEntityName($webServiceObject->getEntityName(), $id);
$fieldValue = $Value[$id[1]];
}
}
}
break;
case 'double' : if ($moduleName === 'HelpDesk' && in_array($fieldName, array('days', 'hours'))) {
$fieldValue = decimalFormat($fieldValue);
} else {
$fieldValue;
}
break;
default : $fieldValue;
}
return nl2br($fieldValue);
}
/**
* Function to fieldvalues of Comments
* @param $moduleName
* @param $fieldName
* @param $fieldValue
* @return $comments
*/
public function getComments($moduleName, $fieldName, $fieldValue) {
global $adb, $log, $current_user;
$sql = 'SELECT commentcontent FROM vtiger_modcomments WHERE related_to = ? ORDER BY modcommentsid DESC';
switch ($fieldName) {
case 'lastComment' : $sql .= ' LIMIT 1'; break;
case 'last5Comments' : $sql .= ' LIMIT 5'; break;
default : $sql; break;
}
list($entityId, $recordId) = vtws_getIdComponents($fieldValue);
$result = $adb->pquery($sql, array($recordId));
$numOfRows = $adb->num_rows($result);
$commentsList = '';
for ($i=0; $i<$numOfRows; $i++) {
$comment = $adb->query_result($result, $i, 'commentcontent');
if ($comment != '') {
$commentsList .= '
' . nl2br($comment);
}
}
return $commentsList;
}
}
?>