/**
* Function to get the display value in detail view
* @param <Integer> crmid of record
* @return <String>
*/
public function getEditViewDisplayValue($value)
{
if ($value) {
$userName = getOwnerName($value);
return $userName;
}
}
/**
* Function to get the Display Value, for the current field type with given DB Insert Value
* @param <Object> $value
* @return <Object>
*/
public function getDisplayValue($values, $record = false, $recordInstance = false, $rawText = false)
{
$db = PearDatabase::getInstance();
$currentUser = Users_Record_Model::getCurrentUserModel();
$displayValue = '';
if ($recordInstance !== false) {
$moduleName = $recordInstance->getModuleName();
} elseif ($record !== false) {
$recordMetaData = Vtiger_Functions::getCRMRecordMetadata($record);
$moduleName = $recordMetaData['setype'];
}
$shownersTable = self::getShownerTable($moduleName);
$result = $db->pquery('SELECT DISTINCT userid FROM ' . $shownersTable . ' WHERE crmid = ?', [$record]);
while (($shownerid = $db->getSingleValue($result)) !== false) {
if (Vtiger_Owner_UIType::getOwnerType($shownerid) === 'User') {
if ($currentUser->isAdminUser() && !$rawText) {
$displayValue .= '<a href="index.php?module=User&view=Detail&record=' . $shownerid . '">' . rtrim(getOwnerName($shownerid)) . '</a>,';
} else {
$displayValue .= rtrim(getOwnerName($shownerid)) . ',';
}
} else {
if ($currentUser->isAdminUser() && !$rawText) {
$displayValue .= '<a href="index.php?module=Groups&parent=Settings&view=Detail&record=' . $shownerid . '">' . rtrim(getOwnerName($shownerid)) . '</a>,';
} else {
$displayValue .= rtrim(getOwnerName($shownerid)) . ',';
}
}
}
return rtrim($displayValue, ',');
}
function CustomerCommentFromPortal($entityData)
{
$adb = PearDatabase::getInstance();
$data = $entityData->getData();
$customerWSId = $data['customer'];
$relatedToWSId = $data['related_to'];
$relatedToId = explode('x', $relatedToWSId);
$moduleName = getSalesEntityType($relatedToId[1]);
if ($moduleName == 'HelpDesk' && !empty($customerWSId)) {
$ownerIdInfo = getRecordOwnerId($relatedToId[1]);
if (!empty($ownerIdInfo['Users'])) {
$ownerId = $ownerIdInfo['Users'];
$ownerName = getOwnerName($ownerId);
$toEmail = getUserEmailId('id', $ownerId);
}
if (!empty($ownerIdInfo['Groups'])) {
$ownerId = $ownerIdInfo['Groups'];
$groupInfo = getGroupName($ownerId);
$ownerName = $groupInfo[0];
$toEmail = implode(',', getDefaultAssigneeEmailIds($ownerId));
}
$subject = getTranslatedString('LBL_RESPONDTO_TICKETID', $moduleName) . "##" . $relatedToId[1] . "## " . getTranslatedString('LBL_CUSTOMER_PORTAL', $moduleName);
$contents = getTranslatedString('Dear', $moduleName) . " " . $ownerName . "," . "<br><br>" . getTranslatedString('LBL_CUSTOMER_COMMENTS', $moduleName) . "<br><br>\n\t\t\t\t\t<b>" . $data['commentcontent'] . "</b><br><br>" . getTranslatedString('LBL_RESPOND', $moduleName) . "<br><br>" . getTranslatedString('LBL_REGARDS', $moduleName) . "<br>" . getTranslatedString('LBL_SUPPORT_ADMIN', $moduleName);
$customerId = explode('x', $customerWSId);
$result = $adb->pquery("SELECT email FROM vtiger_contactdetails WHERE contactid=?", array($customerId[0]));
$fromEmail = $adb->query_result($result, 0, 'email');
send_mail('HelpDesk', $toEmail, '', $fromEmail, $subject, $contents);
}
}
/**
* Function to get the Display Value, for the current field type with given DB Insert Value
* @param <Object> $value
* @return <Object>
*/
public function getDisplayValue($values)
{
if ($values == '')
return;
foreach (Vtiger_Functions::getArrayFromValue($values) as $value) {
if (Vtiger_Owner_UIType::getOwnerType($value) === 'User') {
$userModel = Users_Record_Model::getCleanInstance('Users');
$userModel->set('id', $value);
$detailViewUrl = $userModel->getDetailViewUrl();
$currentUser = Users_Record_Model::getCurrentUserModel();
if ($currentUser->isAdminUser()) {
$displayvalue[] = '<a href=' . $detailViewUrl . '>' . rtrim(getOwnerName($value)) . '</a>';
} else {
$displayvalue[] = rtrim(getOwnerName($value));
}
} else {
$currentUser = Users_Record_Model::getCurrentUserModel();
if ($currentUser->isAdminUser()) {
$recordModel = new Settings_Groups_Record_Model();
$recordModel->set('groupid', $value);
$detailViewUrl = $recordModel->getDetailViewUrl();
$displayvalue[] = '<a href=' . $detailViewUrl . '>' . rtrim(getOwnerName($value)) . '</a>';
} else {
$displayvalue[] = rtrim(getOwnerName($value));
}
}
}
$displayvalue = implode(', ', $displayvalue);
return $displayvalue;
}
/**
* Function to get the Display Value, for the current field type with given DB Insert Value
* @param <Object> $value
* @return <Object>
*/
public function getDisplayValue($values)
{
if ($values == NULL && !is_array($values))
return;
foreach ($values as $value) {
if (self::getOwnerType($value) === 'User') {
$userModel = Users_Record_Model::getCleanInstance('Users');
$userModel->set('id', $value);
$detailViewUrl = $userModel->getDetailViewUrl();
$currentUser = Users_Record_Model::getCurrentUserModel();
if (!$currentUser->isAdminUser()) {
return getOwnerName($value);
}
} else {
$currentUser = Users_Record_Model::getCurrentUserModel();
if (!$currentUser->isAdminUser()) {
return getOwnerName($value);
}
$recordModel = new Settings_Groups_Record_Model();
$recordModel->set('groupid', $value);
$detailViewUrl = $recordModel->getDetailViewUrl();
}
$displayvalue[] = "<a href=" . $detailViewUrl . ">" . getOwnerName($value) . "</a> ";
}
$displayvalue = implode(',', $displayvalue);
return $displayvalue;
}
function author()
{
$authorid = $this->data['smcreatorid'];
if (!isset(self::$ownerNamesCache[$authorid])) {
self::$ownerNamesCache[$authorid] = getOwnerName($authorid);
}
return self::$ownerNamesCache[$authorid];
}
/**
* Function to get the display value in detail view
* @param <Integer> crmid of record
* @return <String>
*/
public function getEditViewDisplayValue($value)
{
global $log;
$log->debug("Entering ./uitypes/UserReference.php::getEditViewDisplayValue");
if ($value) {
$userName = getOwnerName($value);
return $userName;
}
}
/**
* This function sends a mail to the handler whenever the product reaches the reorder level.
* Param $product_id - product id
* Param $upd_qty - updated product quantity in no's
* Param $prod_name - product name
* Param $qtyinstk - quantity in stock
* Param $qty - quantity
* Param $module - module name
* return type void
*/
function sendPrdStckMail($product_id, $upd_qty, $prod_name, $qtyinstk, $qty, $module)
{
global $log;
$log->debug("Entering sendPrdStckMail(" . $product_id . "," . $upd_qty . "," . $prod_name . "," . $qtyinstk . "," . $qty . "," . $module . ") method ...");
global $current_user;
global $adb;
$reorderlevel = getPrdReOrderLevel($product_id);
$log->debug("Inside sendPrdStckMail function, module=" . $module);
$log->debug("Prd reorder level " . $reorderlevel);
if ($upd_qty < $reorderlevel) {
//send mail to the handler
$handler = getRecordOwnerId($product_id);
foreach ($handler as $type => $id) {
$handler = $id;
}
$handler_name = getOwnerName($handler);
if (vtws_isRecordOwnerUser($handler)) {
$to_address = getUserEmail($handler);
} else {
$to_address = implode(',', getDefaultAssigneeEmailIds($handler));
}
//Get the email details from database;
if ($module == 'SalesOrder') {
$notification_table = 'SalesOrderNotification';
$quan_name = '{SOQUANTITY}';
}
if ($module == 'Quotes') {
$notification_table = 'QuoteNotification';
$quan_name = '{QUOTEQUANTITY}';
}
if ($module == 'Invoice') {
$notification_table = 'InvoiceNotification';
}
$query = "select * from vtiger_inventorynotification where notificationname=?";
$result = $adb->pquery($query, array($notification_table));
$subject = $adb->query_result($result, 0, 'notificationsubject');
$body = $adb->query_result($result, 0, 'notificationbody');
$status = $adb->query_result($result, 0, 'status');
if ($status == 0 || $status == '') {
return false;
}
$subject = str_replace('{PRODUCTNAME}', $prod_name, $subject);
$body = str_replace('{HANDLER}', $handler_name, $body);
$body = str_replace('{PRODUCTNAME}', $prod_name, $body);
if ($module == 'Invoice') {
$body = str_replace('{CURRENTSTOCK}', $upd_qty, $body);
$body = str_replace('{REORDERLEVELVALUE}', $reorderlevel, $body);
} else {
$body = str_replace('{CURRENTSTOCK}', $qtyinstk, $body);
$body = str_replace($quan_name, $qty, $body);
}
$body = str_replace('{CURRENTUSER}', $current_user->user_name, $body);
$mail_status = send_mail($module, $to_address, $current_user->user_name, $current_user->email1, decode_html($subject), nl2br(to_html($body)));
}
$log->debug("Exiting sendPrdStckMail method ...");
}
/**
* Function to get the Display Value, for the current field type with given DB Insert Value
* @param <Object> $value
* @return <Object>
*/
public function getDisplayValue($value)
{
if (self::getOwnerType($value) === 'User') {
$userModel = Users_Record_Model::getCleanInstance('Users');
$userModel->set('id', $value);
$detailViewUrl = $userModel->getDetailViewUrl();
} else {
$currentUser = Users_Record_Model::getCurrentUserModel();
if (!$currentUser->isAdminUser()) {
return getOwnerName($value);
}
$recordModel = new Settings_Groups_Record_Model();
$recordModel->set('groupid', $value);
$detailViewUrl = $recordModel->getDetailViewUrl();
}
return "<a href=" . $detailViewUrl . ">" . getOwnerName($value) . "</a>";
}
/**
* Function to get the Display Value, for the current field type with given DB Insert Value
* @param <Object> $value
* @return <Object>
*/
public function getDisplayValue($values)
{
if ($values == NULL) {
return;
}
foreach (Vtiger_Functions::getArrayFromValue($values) as $value) {
$userModel = Users_Record_Model::getCleanInstance('Users');
$userModel->set('id', $value);
$detailViewUrl = $userModel->getDetailViewUrl();
$currentUser = Users_Record_Model::getCurrentUserModel();
if (!$currentUser->isAdminUser()) {
return getOwnerName($value);
}
$displayvalue[] = "<a href=" . $detailViewUrl . ">" . getOwnerName($value) . "</a> ";
}
$displayvalue = implode(',', $displayvalue);
return $displayvalue;
}
function HelpDesk_notifyOnPortalTicketComment($entityData)
{
$adb = PearDatabase::getInstance();
$moduleName = $entityData->getModuleName();
$wsId = $entityData->getId();
$parts = explode('x', $wsId);
$entityId = $parts[1];
$ownerIdInfo = getRecordOwnerId($entityId);
if (!empty($ownerIdInfo['Users'])) {
$ownerId = $ownerIdInfo['Users'];
$ownerName = getOwnerName($ownerId);
$to_email = getUserEmailId('id', $ownerId);
}
if (!empty($ownerIdInfo['Groups'])) {
$ownerId = $ownerIdInfo['Groups'];
$groupInfo = getGroupName($ownerId);
$ownerName = $groupInfo[0];
$to_email = implode(',', getDefaultAssigneeEmailIds($ownerId));
}
$wsParentId = $entityData->get('contact_id');
$parentIdParts = explode('x', $wsParentId);
$parentId = $parentIdParts[1];
$entityDelta = new VTEntityDelta();
$oldComments = $entityDelta->getOldValue($entityData->getModuleName(), $entityId, 'comments');
$newComments = $entityDelta->getCurrentValue($entityData->getModuleName(), $entityId, 'comments');
$commentDiff = str_replace($oldComments, '', $newComments);
$latestComment = strip_tags($commentDiff);
//send mail to the assigned to user when customer add comment
// SalesPlatform.ru begin
$subject = getTranslatedString('LBL_RESPONDTO_TICKETID', $moduleName) . " " . $entityData->get('ticket_no') . " " . getTranslatedString('LBL_CUSTOMER_PORTAL', $moduleName);
//$subject = getTranslatedString('LBL_RESPONDTO_TICKETID', $moduleName)."##". $entityId."##". getTranslatedString('LBL_CUSTOMER_PORTAL', $moduleName);
// SalesPlatform.ru end
$contents = getTranslatedString('Dear', $moduleName) . " " . $ownerName . "," . "<br><br>" . getTranslatedString('LBL_CUSTOMER_COMMENTS', $moduleName) . "<br><br>\n\t\t\t\t\t\t<b>" . $latestComment . "</b><br><br>" . getTranslatedString('LBL_RESPOND', $moduleName) . "<br><br>" . getTranslatedString('LBL_REGARDS', $moduleName) . "<br>" . getTranslatedString('LBL_SUPPORT_ADMIN', $moduleName);
//get the contact email id who creates the ticket from portal and use this email as from email id in email
$result = $adb->pquery("SELECT lastname, firstname, email FROM vtiger_contactdetails WHERE contactid=?", array($parentId));
$customername = $adb->query_result($result, 0, 'firstname') . ' ' . $adb->query_result($result, 0, 'lastname');
$customername = decode_html($customername);
//Fix to display the original UTF-8 characters in sendername instead of ascii characters
$from_email = $adb->query_result($result, 0, 'email');
send_mail('HelpDesk', $to_email, '', $from_email, $subject, $contents);
}
function content_56970bf26f937($_smarty_tpl)
{
?>
<div class="relatedContainer"><input type="hidden" name="currentPageNum" value="<?php
echo $_smarty_tpl->tpl_vars['PAGING']->value->getCurrentPage();
?>
" /><?php
$_smarty_tpl->tpl_vars["RELATED_MODULE_NAME"] = new Smarty_variable($_smarty_tpl->tpl_vars['RELATED_MODULE']->value->get('name'), null, 0);
?>
<input type="hidden" name="relatedModuleName" class="relatedModuleName" value="<?php
echo $_smarty_tpl->tpl_vars['RELATED_MODULE_NAME']->value;
?>
" /><input type="hidden" value="<?php
echo $_smarty_tpl->tpl_vars['ORDER_BY']->value;
?>
" id="orderBy"><input type="hidden" value="<?php
echo $_smarty_tpl->tpl_vars['SORT_ORDER']->value;
?>
" id="sortOrder"><input type="hidden" value="<?php
echo $_smarty_tpl->tpl_vars['RELATED_ENTIRES_COUNT']->value;
?>
" id="noOfEntries"><input type='hidden' value="<?php
echo $_smarty_tpl->tpl_vars['PAGING']->value->getPageLimit();
?>
" id='pageLimit'><input type='hidden' value="<?php
echo $_smarty_tpl->tpl_vars['TOTAL_ENTRIES']->value;
?>
" id='totalCount'><div class="relatedHeader "><div class="btn-toolbar row-fluid"><div class="span6"><?php
$_smarty_tpl->tpl_vars['RELATED_LINK'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['RELATED_LINK']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['RELATED_LIST_LINKS']->value['LISTVIEWBASIC'];
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
foreach ($_from as $_smarty_tpl->tpl_vars['RELATED_LINK']->key => $_smarty_tpl->tpl_vars['RELATED_LINK']->value) {
$_smarty_tpl->tpl_vars['RELATED_LINK']->_loop = true;
if ($_smarty_tpl->tpl_vars['RELATED_LINK']->value != null) {
?>
<div class="btn-group"><?php
ob_start();
echo $_smarty_tpl->tpl_vars['RELATED_LINK']->value->get('_selectRelation');
$_tmp1 = ob_get_clean();
$_smarty_tpl->tpl_vars['IS_SELECT_BUTTON'] = new Smarty_variable($_tmp1, null, 0);
?>
<button type="button" class="btn [addButton<?php
if ($_smarty_tpl->tpl_vars['IS_SELECT_BUTTON']->value == true) {
?>
selectRelation <?php
}
?>
"<?php
if ($_smarty_tpl->tpl_vars['IS_SELECT_BUTTON']->value == true) {
?>
data-moduleName=<?php
echo $_smarty_tpl->tpl_vars['RELATED_LINK']->value->get('_module')->get('name');
?>
<?php
}
if ($_smarty_tpl->tpl_vars['RELATED_LINK']->value->isPageLoadLink()) {
if ($_smarty_tpl->tpl_vars['RELATION_FIELD']->value) {
?>
data-name="<?php
echo $_smarty_tpl->tpl_vars['RELATION_FIELD']->value->getName();
?>
" <?php
}
}
if ($_smarty_tpl->tpl_vars['IS_SELECT_BUTTON']->value != true) {
?>
name="composeEmail"<?php
}
?>
><?php
if ($_smarty_tpl->tpl_vars['IS_SELECT_BUTTON']->value == false) {
?>
<i class="icon-plus icon-white"></i><?php
}
?>
<strong><?php
echo $_smarty_tpl->tpl_vars['RELATED_LINK']->value->getLabel();
?>
</strong></button></div><?php
}
}
?>
</div><div class="span6"><div class="pull-right"><span class="pageNumbers"><span class="pageNumbersText"><?php
if (!empty($_smarty_tpl->tpl_vars['RELATED_RECORDS']->value)) {
echo $_smarty_tpl->tpl_vars['PAGING']->value->getRecordStartRange();
echo vtranslate('LBL_to', $_smarty_tpl->tpl_vars['RELATED_MODULE_NAME']->value);
echo $_smarty_tpl->tpl_vars['PAGING']->value->getRecordEndRange();
} else {
?>
<span> </span><?php
}
?>
</span><span class="icon-refresh pull-right totalNumberOfRecords cursorPointer<?php
if (empty($_smarty_tpl->tpl_vars['RELATED_RECORDS']->value)) {
?>
hide<?php
}
?>
"></span></span><span class="btn-group"><button class="btn" id="relatedListPreviousPageButton" <?php
if (!$_smarty_tpl->tpl_vars['PAGING']->value->isPrevPageExists()) {
?>
disabled <?php
}
?>
type="button"><span class="icon-chevron-left"></span></button><button class="btn dropdown-toggle" type="button" id="relatedListPageJump" data-toggle="dropdown" <?php
if ($_smarty_tpl->tpl_vars['PAGE_COUNT']->value == 1) {
?>
disabled <?php
}
?>
><i class="vtGlyph vticon-pageJump" title="<?php
echo vtranslate('LBL_LISTVIEW_PAGE_JUMP', $_smarty_tpl->tpl_vars['moduleName']->value);
?>
"></i></button><ul class="listViewBasicAction dropdown-menu" id="relatedListPageJumpDropDown"><li><span class="row-fluid"><span class="span3"><span class="pull-right"><?php
echo vtranslate('LBL_PAGE', $_smarty_tpl->tpl_vars['moduleName']->value);
?>
</span></span><span class="span4"><input type="text" id="pageToJump" class="listViewPagingInput" value="<?php
echo $_smarty_tpl->tpl_vars['PAGING']->value->getCurrentPage();
?>
"/></span><span class="span2 textAlignCenter"><?php
echo vtranslate('LBL_OF', $_smarty_tpl->tpl_vars['moduleName']->value);
?>
</span><span class="span3" id="totalPageCount"><?php
echo $_smarty_tpl->tpl_vars['PAGE_COUNT']->value;
?>
</span></span></li></ul><button class="btn" id="relatedListNextPageButton" <?php
if (!$_smarty_tpl->tpl_vars['PAGING']->value->isNextPageExists() || $_smarty_tpl->tpl_vars['PAGE_COUNT']->value == 1) {
?>
disabled <?php
}
?>
type="button"><span class="icon-chevron-right"></span></button></span></div></div></div></div><div class="contents-topscroll"><div class="topscroll-div"> </div></div><div class="relatedContents contents-bottomscroll"><div class="bottomscroll-div"><?php
$_smarty_tpl->tpl_vars['WIDTHTYPE'] = new Smarty_variable($_smarty_tpl->tpl_vars['USER_MODEL']->value->get('rowheight'), null, 0);
?>
<table class="table table-bordered listViewEntriesTable"><thead><tr class="listViewHeaders"><?php
$_smarty_tpl->tpl_vars['HEADER_FIELD'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['HEADER_FIELD']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['RELATED_HEADERS']->value;
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
$_smarty_tpl->tpl_vars['HEADER_FIELD']->total = $_smarty_tpl->_count($_from);
$_smarty_tpl->tpl_vars['HEADER_FIELD']->iteration = 0;
foreach ($_from as $_smarty_tpl->tpl_vars['HEADER_FIELD']->key => $_smarty_tpl->tpl_vars['HEADER_FIELD']->value) {
$_smarty_tpl->tpl_vars['HEADER_FIELD']->_loop = true;
$_smarty_tpl->tpl_vars['HEADER_FIELD']->iteration++;
$_smarty_tpl->tpl_vars['HEADER_FIELD']->last = $_smarty_tpl->tpl_vars['HEADER_FIELD']->iteration === $_smarty_tpl->tpl_vars['HEADER_FIELD']->total;
if ($_smarty_tpl->tpl_vars['HEADER_FIELD']->value != null) {
?>
<th class="<?php
echo $_smarty_tpl->tpl_vars['WIDTHTYPE']->value;
?>
"><?php
if ($_smarty_tpl->tpl_vars['HEADER_FIELD']->value->get('column') == 'access_count' || $_smarty_tpl->tpl_vars['HEADER_FIELD']->value->get('column') == 'idlists') {
?>
<a href="javascript:void(0);" class="noSorting"><?php
echo vtranslate($_smarty_tpl->tpl_vars['HEADER_FIELD']->value->get('label'), $_smarty_tpl->tpl_vars['RELATED_MODULE_NAME']->value);
?>
</a><?php
} else {
?>
<a href="javascript:void(0);" class="relatedListHeaderValues" data-nextsortorderval="<?php
if ($_smarty_tpl->tpl_vars['COLUMN_NAME']->value == $_smarty_tpl->tpl_vars['HEADER_FIELD']->value->get('column')) {
echo $_smarty_tpl->tpl_vars['NEXT_SORT_ORDER']->value;
} else {
?>
ASC<?php
}
?>
" data-fieldname="<?php
echo $_smarty_tpl->tpl_vars['HEADER_FIELD']->value->get('column');
?>
"><?php
echo vtranslate(html_entity_decode($_smarty_tpl->tpl_vars['HEADER_FIELD']->value->get('label')), $_smarty_tpl->tpl_vars['RELATED_MODULE_NAME']->value);
?>
<?php
if ($_smarty_tpl->tpl_vars['COLUMN_NAME']->value == $_smarty_tpl->tpl_vars['HEADER_FIELD']->value->get('column')) {
?>
<img class="<?php
echo $_smarty_tpl->tpl_vars['SORT_IMAGE']->value;
?>
"><?php
}
?>
</a><?php
}
?>
</th><?php
}
}
?>
</tr></thead><?php
$_smarty_tpl->tpl_vars['RELATED_RECORD'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['RELATED_RECORD']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['RELATED_RECORDS']->value;
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
foreach ($_from as $_smarty_tpl->tpl_vars['RELATED_RECORD']->key => $_smarty_tpl->tpl_vars['RELATED_RECORD']->value) {
$_smarty_tpl->tpl_vars['RELATED_RECORD']->_loop = true;
if ($_smarty_tpl->tpl_vars['RELATED_RECORD']->value != null) {
?>
<tr class="listViewEntries" data-id='<?php
echo $_smarty_tpl->tpl_vars['RELATED_RECORD']->value->getId();
?>
' name="emailsRelatedRecord"><?php
$_smarty_tpl->tpl_vars['HEADER_FIELD'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['HEADER_FIELD']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['RELATED_HEADERS']->value;
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
$_smarty_tpl->tpl_vars['HEADER_FIELD']->total = $_smarty_tpl->_count($_from);
$_smarty_tpl->tpl_vars['HEADER_FIELD']->iteration = 0;
foreach ($_from as $_smarty_tpl->tpl_vars['HEADER_FIELD']->key => $_smarty_tpl->tpl_vars['HEADER_FIELD']->value) {
$_smarty_tpl->tpl_vars['HEADER_FIELD']->_loop = true;
$_smarty_tpl->tpl_vars['HEADER_FIELD']->iteration++;
$_smarty_tpl->tpl_vars['HEADER_FIELD']->last = $_smarty_tpl->tpl_vars['HEADER_FIELD']->iteration === $_smarty_tpl->tpl_vars['HEADER_FIELD']->total;
if ($_smarty_tpl->tpl_vars['HEADER_FIELD']->value != null) {
$_smarty_tpl->tpl_vars['RELATED_HEADERNAME'] = new Smarty_variable($_smarty_tpl->tpl_vars['HEADER_FIELD']->value->get('name'), null, 0);
?>
<td class="<?php
echo $_smarty_tpl->tpl_vars['WIDTHTYPE']->value;
?>
"><?php
if ($_smarty_tpl->tpl_vars['HEADER_FIELD']->value->isNameField() == true || $_smarty_tpl->tpl_vars['HEADER_FIELD']->value->get('uitype') == '4') {
?>
<a><?php
echo $_smarty_tpl->tpl_vars['RELATED_RECORD']->value->getDisplayValue($_smarty_tpl->tpl_vars['RELATED_HEADERNAME']->value);
?>
</a><?php
} elseif ($_smarty_tpl->tpl_vars['RELATED_HEADERNAME']->value == 'access_count') {
echo $_smarty_tpl->tpl_vars['RELATED_RECORD']->value->getAccessCountValue($_smarty_tpl->tpl_vars['PARENT_RECORD']->value->getId());
} elseif ($_smarty_tpl->tpl_vars['RELATED_HEADERNAME']->value == 'date_start') {
if ($_smarty_tpl->tpl_vars['EMAIL_FLAG']->value != 'SAVED') {
echo $_smarty_tpl->tpl_vars['RELATED_RECORD']->value->getDisplayValue($_smarty_tpl->tpl_vars['RELATED_HEADERNAME']->value);
} elseif ($_smarty_tpl->tpl_vars['RELATED_RECORD']->value->isFromMailManager()) {
?>
<span class="label label-warning"><?php
echo vtranslate('LBL_ATTACHED', $_smarty_tpl->tpl_vars['RELATED_MODULE_NAME']->value);
?>
</span><?php
}
} elseif ($_smarty_tpl->tpl_vars['RELATED_HEADERNAME']->value == 'time_start') {
if ($_smarty_tpl->tpl_vars['EMAIL_FLAG']->value != 'SAVED') {
echo $_smarty_tpl->tpl_vars['RELATED_RECORD']->value->getDisplayValue($_smarty_tpl->tpl_vars['RELATED_HEADERNAME']->value);
} elseif ($_smarty_tpl->tpl_vars['RELATED_RECORD']->value->isFromMailManager()) {
?>
<span class="label label-warning"><?php
echo vtranslate('LBL_ATTACHED', $_smarty_tpl->tpl_vars['RELATED_MODULE_NAME']->value);
?>
</span><?php
}
} elseif ($_smarty_tpl->tpl_vars['RELATED_HEADERNAME']->value == 'parent_id') {
$_smarty_tpl->tpl_vars['REFERENCE_RECORD'] = new Smarty_variable($_smarty_tpl->tpl_vars['RELATED_RECORD']->value->get($_smarty_tpl->tpl_vars['RELATED_HEADERNAME']->value), null, 0);
$_smarty_tpl->tpl_vars['RECORD_MODULE_MODEL'] = new Smarty_variable($_smarty_tpl->tpl_vars['RELATED_RECORD']->value->getModule(), null, 0);
$_smarty_tpl->tpl_vars['RECORD_FIELD_MODEL'] = new Smarty_variable($_smarty_tpl->tpl_vars['RECORD_MODULE_MODEL']->value->getField($_smarty_tpl->tpl_vars['RELATED_HEADERNAME']->value), null, 0);
$_smarty_tpl->tpl_vars['UI_TYPE_MODEL'] = new Smarty_variable(Vtiger_Base_UIType::getInstanceFromField($_smarty_tpl->tpl_vars['RECORD_FIELD_MODEL']->value), null, 0);
$_smarty_tpl->tpl_vars['REFERENCE_MODULE_MODEL'] = new Smarty_variable($_smarty_tpl->tpl_vars['UI_TYPE_MODEL']->value->getReferenceModule($_smarty_tpl->tpl_vars['REFERENCE_RECORD']->value), null, 0);
$_smarty_tpl->tpl_vars['REFERENCE_MODULE_NAME'] = new Smarty_variable($_smarty_tpl->tpl_vars['REFERENCE_MODULE_MODEL']->value->get('name'), null, 0);
$_smarty_tpl->tpl_vars['REFERENCE_RECORD_ENTIYNAME_LIST'] = new Smarty_variable(getEntityName($_smarty_tpl->tpl_vars['REFERENCE_MODULE_NAME']->value, $_smarty_tpl->tpl_vars['REFERENCE_RECORD']->value), null, 0);
?>
<a href="index.php?module=<?php
echo $_smarty_tpl->tpl_vars['REFERENCE_MODULE_NAME']->value;
?>
&view=<?php
echo $_smarty_tpl->tpl_vars['REFERENCE_MODULE_MODEL']->value->getDetailViewName();
?>
&record=<?php
echo $_smarty_tpl->tpl_vars['REFERENCE_RECORD']->value;
?>
"title="<?php
echo vtranslate($_smarty_tpl->tpl_vars['REFERENCE_MODULE_NAME']->value, $_smarty_tpl->tpl_vars['REFERENCE_MODULE_NAME']->value);
?>
"onclick="if(event.stopPropagation){event.stopPropagation();}else{event.cancelBubble=true;}"><?php
echo $_smarty_tpl->tpl_vars['REFERENCE_RECORD_ENTIYNAME_LIST']->value[$_smarty_tpl->tpl_vars['REFERENCE_RECORD']->value];
?>
</a><?php
} elseif ($_smarty_tpl->tpl_vars['HEADER_FIELD']->value->getFieldDataType() == 'owner') {
echo getOwnerName($_smarty_tpl->tpl_vars['RELATED_RECORD']->value->get($_smarty_tpl->tpl_vars['RELATED_HEADERNAME']->value));
} else {
echo $_smarty_tpl->tpl_vars['RELATED_RECORD']->value->getDisplayValue($_smarty_tpl->tpl_vars['RELATED_HEADERNAME']->value);
}
if ($_smarty_tpl->tpl_vars['HEADER_FIELD']->last) {
?>
<div class="pull-right actions"><span class="actionImages"><a name="emailsDetailView"><i title="<?php
echo vtranslate('LBL_SHOW_COMPLETE_DETAILS', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
" class="icon-th-list alignMiddle"></i></a> <?php
if (!$_smarty_tpl->tpl_vars['RELATED_RECORD']->value->isSentMail()) {
?>
<a name="emailsEditView"><i title="<?php
echo vtranslate('LBL_EDIT', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
" class="icon-pencil alignMiddle"></i></a><?php
}
if ($_smarty_tpl->tpl_vars['IS_DELETABLE']->value) {
?>
<a class="relationDelete"><i title="<?php
echo vtranslate('LBL_DELETE', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
" class="icon-trash alignMiddle"></i></a><?php
}
?>
</span></div><?php
}
?>
</td><?php
}
}
?>
</tr><?php
}
}
?>
</table></div></div></div>
<?php
}
/**
* Compute the full inventory on devices in the data centers and return the data
* center summary statistics
*
* @param PHPExcel_Worksheet $worksheet
* @param array $DProps properties defined for the Excel document
* @return (array|array|array|boolean)[]
* statistics array, device inventory, cabinet inventory
*/
function computeSheetBodyDCInventory($DProps)
{
global $person;
global $sessID;
$dc = new DataCenter();
$cab = new Cabinet();
$device = new Device();
$invData = array();
$invCab = array();
$sheetColumns = $DProps['DC Inventory']['Columns'];
$cabinetColumns = $DProps['Rack Inventory']['Columns'];
$devTemplates = DeviceTemplate::getTemplateListIndexedbyID();
$deptList = Department::GetDepartmentListIndexedbyID();
$contactList = $person->GetUserList('indexed');
$limitedUser = false;
$dcList = $dc->GetDCList();
$Stats = array();
// A little code to update the counter
$percentDone = 0;
$sectionMaxPercent = 40;
$incrementalPercent = 1 / sizeof($dcList) * $sectionMaxPercent;
foreach ($dcList as $dc) {
$dcContainerList = $dc->getContainerList();
$dcStats = array();
$cab->DataCenterID = $dc->DataCenterID;
$dcStats['Fl_Spc'] = $dc->SquareFootage;
$dcStats['DesignPower'] = $dc->MaxkW;
$dcStats['Watts'] = 0;
$dcStats['Rk_Num'] = 0;
$dcStats['Rk_UtT'] = 0;
$dcStats['Rk_UtU'] = 0;
$dcStats['Rk_UtE'] = 0;
$dcStats['Rk_Res'] = 0;
$cabList = $cab->ListCabinetsByDC();
if (count($cabList) == 0) {
// empty data center room
$devSpec = makeEmptySpec($sheetColumns, $dcContainerList);
$devSpec['DC Name'] = $dc->Name;
$invData[] = $devSpec;
} else {
foreach ($cabList as $cab) {
if (!$person->ReadAccess and $cab->AssignedTo == 0 or $cab->AssignedTo > 0 and !$person->canRead($cab->AssignedTo)) {
// User is not allowed to see anything in here
$limitedUser = true;
continue;
}
$zoneName = getZoneName($cab);
$rowName = getRowName($cab);
addRackStat($invCab, $cab, $cabinetColumns, $dc, $dcContainerList);
$cab_height = $cab->CabinetHeight;
if (mb_strtoupper($cab->Model) == 'RESERVED') {
$dcStats['Rk_Res']++;
} else {
$dcStats['Rk_Num']++;
}
$dcStats['Rk_UtT'] += $cab_height;
$device->Cabinet = $cab->CabinetID;
$device_list = $device->ViewDevicesByCabinet();
// empty cabinet
if (count($device_list) == 0 && $cab->CabinetHeight > 0) {
$dcStats['Rk_UtE'] += $cab_height;
$devSpec = makeEmptySpec($sheetColumns, $dcContainerList);
$devSpec['Zone'] = $zoneName;
$devSpec['Row'] = $rowName;
$devSpec['DC Name'] = $dc->Name;
$devSpec['Cabinet'] = $cab->Location;
$devSpec['Position'] = 1;
$devSpec['Height'] = $cab->CabinetHeight;
$devSpec['Device'] = '__EMPTY';
$invData[] = $devSpec;
} else {
usort($device_list, 'cmpDevPos');
$low_idx = 1;
foreach ($device_list as $dev) {
if ($low_idx < $dev->Position) {
// range of empty slots
if ($dev->Position <= $cab_height) {
$height = $dev->Position - $low_idx;
} else {
$height = $cab_height - $low_idx + 1;
}
if ($height > 0) {
$dcStats['Rk_UtE'] += $height;
$devSpec = makeEmptySpec($sheetColumns, $dcContainerList);
${$devSpec}['Zone'] = $zoneName;
$devSpec['Row'] = $rowName;
$devSpec['DC Name'] = $dc->Name;
$devSpec['Cabinet'] = $cab->Location;
$devSpec['Position'] = $low_idx;
$devSpec['Height'] = $height;
$devSpec['Device'] = '__EMPTY';
$invData[] = $devSpec;
}
$low_idx = $dev->Position;
}
// device in cabinet
$reserved = $dev->Reservation ? 'reserved' : null;
list($manufacturer, $model) = getDeviceTemplateName($devTemplates, $dev);
$devSpec = makeEmptySpec($sheetColumns, $dcContainerList);
$devSpec['DevID'] = $dev->DeviceID;
$devSpec['Zone'] = $zoneName;
$devSpec['Row'] = $rowName;
$devSpec['DC Name'] = $dc->Name;
$devSpec['Cabinet'] = $cab->Location;
$devSpec['Position'] = $dev->Position;
$devSpec['Half Depth'] = getDeviceDepthPos($dev);
$devSpec['Height'] = $dev->Height;
$devSpec['Device'] = $dev->Label;
$devSpec['Parent Device'] = null;
$devSpec['Manufacturer'] = $manufacturer;
$devSpec['Model'] = $model;
$devSpec['Device Type'] = $dev->DeviceType;
$devSpec['Asset Number'] = $dev->AssetTag;
$devSpec['Serial No.'] = $dev->SerialNo;
$devSpec['Install Date'] = $dev->InstallDate;
$devSpec['Warranty End'] = $dev->WarrantyExpire;
$devSpec['Owner'] = getOwnerName($dev, $deptList);
$devSpec['Power (W)'] = $dev->NominalWatts;
$devSpec['Reservation'] = $reserved;
$devSpec['Contact'] = getContactName($contactList, $dev->PrimaryContact);
$devSpec['Tags'] = getTagsString($dev);
$devSpec['Notes'] = html_entity_decode(strip_tags($dev->Notes), ENT_COMPAT, 'UTF-8');
$invData[] = $devSpec;
$dcStats['Watts'] += $dev->NominalWatts;
// devices can be installed at the same position and
// could be of different height; count only the free
// rack units which are not covered by any device
if ($low_idx == $dev->Position) {
$low_idx += $dev->Height;
$dcStats['Rk_UtU'] += $dev->Height;
} else {
$rest_height = $dev->Position + $dev->Height - $low_idx;
$rest_height = $rest_height > 0 ? $rest_height : 0;
$low_idx += $rest_height;
$dcStats['Rk_UtU'] += $rest_height;
}
if ($dev->DeviceType == 'Chassis') {
list($watts, $invData) = computeDeviceChildren($sheetColumns, $invData, $dev, $dc->Name, $cab, $devTemplates, $deptList, $contactList, $dcContainerList);
$dcStats['Watts'] += $watts;
}
}
if ($low_idx <= $cab->CabinetHeight) {
// empty range at the top of the cabinet, $low_idx is
// the potentially free location
$height = $cab->CabinetHeight - $low_idx + 1;
$dcStats['Rk_UtE'] += $height;
$devSpec = makeEmptySpec($sheetColumns, $dcContainerList);
$devSpec['Zone'] = $zoneName;
$devSpec['Row'] = $rowName;
$devSpec['DC Name'] = $dc->Name;
$devSpec['Cabinet'] = $cab->Location;
$devSpec['Position'] = $low_idx;
$devSpec['Height'] = $height;
$devSpec['Device'] = '__EMPTY';
$invData[] = $devSpec;
}
}
}
}
assignStatsVal($Stats, $dc, $dcStats);
$percentDone += $incrementalPercent;
JobQueue::updatePercentage($sessID, $percentDone);
}
return array($Stats, $invData, $invCab, $limitedUser);
}
function content_5698d11f3c1a7($_smarty_tpl)
{
?>
<div class="SendEmailFormStep2" name="emailPreview"><input type="hidden" name="parentRecord" value="<?php
echo $_smarty_tpl->tpl_vars['PARENT_RECORD']->value;
?>
"/><input type="hidden" name="recordId" value="<?php
echo $_smarty_tpl->tpl_vars['RECORD_ID']->value;
?>
"/><br><div class="well well-large zeroPaddingAndMargin"><div class="modal-header blockHeader emailPreviewHeader" style="height:30px"><h3 class='span4'><?php
echo vtranslate('SINGLE_Emails', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
<?php
echo vtranslate('LBL_INFO', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
</h3><div class='pull-right'><span class="btn-toolbar"><span class="btn-group"><button type="button" name="previewForward" class="btn" data-mode="emailForward"><strong><?php
echo vtranslate('LBL_FORWARD', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
</strong></button></span><?php
if (!$_smarty_tpl->tpl_vars['RECORD']->value->isSentMail()) {
?>
<span class="btn-group"><button type="button" name="previewEdit" class="btn" data-mode="emailEdit"><strong><?php
echo vtranslate('LBL_EDIT', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
</strong></button></span><?php
}
?>
<span class="btn-group"><button type="button" name="previewPrint" class="btn" data-mode="previewPrint"><strong><?php
echo vtranslate('LBL_PRINT', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
</strong></button></span></span></div></div><form class="form-horizontal emailPreview" method="POST"><div class="row-fluid padding-bottom1per"><span class="span12 row-fluid"><span class="span2"><span class="pull-right muted"><?php
echo vtranslate('LBL_FROM', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
</span></span><span class="span9"><span class="row-fluid"><?php
echo $_smarty_tpl->tpl_vars['FROM']->value;
?>
</span></span></span></div><div class="row-fluid padding-bottom1per"><span class="span12 row-fluid"><span class="span2"><span class="pull-right muted"><?php
echo vtranslate('LBL_TO', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
</span></span><span class="span9"><?php
if (empty($_smarty_tpl->tpl_vars['TO']->value)) {
$_smarty_tpl->tpl_vars['TO'] = new Smarty_variable(array(), null, 0);
}
$_smarty_tpl->tpl_vars['TO_EMAILS'] = new Smarty_variable(implode(",", $_smarty_tpl->tpl_vars['TO']->value), null, 0);
?>
<span class="row-fluid"><?php
echo $_smarty_tpl->tpl_vars['TO_EMAILS']->value;
?>
</span></span></span></div><?php
if (!empty($_smarty_tpl->tpl_vars['CC']->value)) {
?>
<div class="row-fluid padding-bottom1per"><span class="span12 row-fluid"><span class="span2"><span class="pull-right muted"><?php
echo vtranslate('LBL_CC', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
</span></span><span class="span9"><span class="row-fluid"><?php
echo $_smarty_tpl->tpl_vars['CC']->value;
?>
</span></span></span></div><?php
}
if (!empty($_smarty_tpl->tpl_vars['BCC']->value)) {
?>
<div class="row-fluid padding-bottom1per"><span class="span12 row-fluid"><span class="span2"><span class="pull-right muted"><?php
echo vtranslate('LBL_BCC', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
</span></span><span class="span9"><span class="row-fluid"><?php
echo $_smarty_tpl->tpl_vars['BCC']->value;
?>
</span></span></span></div><?php
}
?>
<div class="row-fluid padding-bottom1per"><span class="span12 row-fluid"><span class="span2"><span class="pull-right muted"><?php
echo vtranslate('LBL_SUBJECT', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
</span></span><span class="span9"><span class="row-fluid"><?php
echo $_smarty_tpl->tpl_vars['RECORD']->value->get('subject');
?>
</span></span></span></div><div class="row-fluid padding-bottom1per"><span class="span12 row-fluid"><span class="span2"><span class="pull-right muted"><?php
echo vtranslate('LBL_ATTACHMENT', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
</span></span><span class="span9"><span class="row-fluid"><?php
$_smarty_tpl->tpl_vars['ATTACHMENT_DETAILS'] = new Smarty_Variable();
$_smarty_tpl->tpl_vars['ATTACHMENT_DETAILS']->_loop = false;
$_from = $_smarty_tpl->tpl_vars['RECORD']->value->getAttachmentDetails();
if (!is_array($_from) && !is_object($_from)) {
settype($_from, 'array');
}
foreach ($_from as $_smarty_tpl->tpl_vars['ATTACHMENT_DETAILS']->key => $_smarty_tpl->tpl_vars['ATTACHMENT_DETAILS']->value) {
$_smarty_tpl->tpl_vars['ATTACHMENT_DETAILS']->_loop = true;
?>
<a <?php
if (array_key_exists('docid', $_smarty_tpl->tpl_vars['ATTACHMENT_DETAILS']->value)) {
?>
href="index.php?module=Documents&action=DownloadFile&record=<?php
echo $_smarty_tpl->tpl_vars['ATTACHMENT_DETAILS']->value['docid'];
?>
&fileid=<?php
echo $_smarty_tpl->tpl_vars['ATTACHMENT_DETAILS']->value['fileid'];
?>
"<?php
} else {
?>
href="index.php?module=Emails&action=DownloadFile&attachment_id=<?php
echo $_smarty_tpl->tpl_vars['ATTACHMENT_DETAILS']->value['fileid'];
?>
"<?php
}
?>
><?php
echo $_smarty_tpl->tpl_vars['ATTACHMENT_DETAILS']->value['attachment'];
?>
</a> <?php
}
?>
</span></span></span></div><div class="row-fluid padding-bottom1per"><span class="span12 row-fluid"><span class="span2"><span class="pull-right muted"><?php
echo vtranslate('LBL_DESCRIPTION', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
</span></span><span class="span9"><span class="row-fluid"><?php
echo decode_html($_smarty_tpl->tpl_vars['RECORD']->value->get('description'));
?>
</span></span></span></div><div class="row-fluid"><span class="span1"> </span><span class="span10 margin0px"><hr/></span></div><div class="row-fluid"><span class="span4"> </span><span class="span4 textAlignCenter"><span class="muted"><?php
if ($_smarty_tpl->tpl_vars['RECORD']->value->get('email_flag') == "SAVED") {
?>
<small><em><?php
echo vtranslate('LBL_DRAFTED_ON', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
</em></small><span><small><em> <?php
echo Vtiger_Util_Helper::formatDateTimeIntoDayString($_smarty_tpl->tpl_vars['RECORD']->value->get('createdtime'));
?>
</em></small></span><?php
} elseif ($_smarty_tpl->tpl_vars['RECORD']->value->get('email_flag') == "MailManager") {
?>
<small><em><?php
echo vtranslate('LBL_MAIL_DATE', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
: </em></small><?php
$_smarty_tpl->tpl_vars["MAIL_DATE"] = new Smarty_variable($_smarty_tpl->tpl_vars['RECORD']->value->get('date_start') . ' ' . $_smarty_tpl->tpl_vars['RECORD']->value->get('time_start'), null, 0);
?>
<span><small><em> <?php
echo Vtiger_Util_Helper::formatDateTimeIntoDayString($_smarty_tpl->tpl_vars['MAIL_DATE']->value);
?>
</em></small></span><?php
} else {
?>
<small><em><?php
echo vtranslate('LBL_SENT_ON', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
</em></small><?php
$_smarty_tpl->tpl_vars["SEND_TIME"] = new Smarty_variable($_smarty_tpl->tpl_vars['RECORD']->value->get('date_start') . ' ' . $_smarty_tpl->tpl_vars['RECORD']->value->get('time_start'), null, 0);
?>
<span><small><em> <?php
echo Vtiger_Util_Helper::formatDateTimeIntoDayString($_smarty_tpl->tpl_vars['SEND_TIME']->value);
?>
</em></small></span><?php
}
?>
</span></span></div><div class="row-fluid"><span class="span3"> </span><span class="span5 textAlignCenter"><span><strong> <?php
echo vtranslate('LBL_OWNER', $_smarty_tpl->tpl_vars['MODULE']->value);
?>
: <?php
echo getOwnerName($_smarty_tpl->tpl_vars['RECORD']->value->get('assigned_user_id'));
?>
</strong></span></span></div></form></div></div><?php
echo $_smarty_tpl->getSubTemplate(vtemplate_path('JSResources.tpl'), $_smarty_tpl->cache_id, $_smarty_tpl->compile_id, null, null, array(), 0);
}
public function getTreeEntries()
{
$db = PearDatabase::getInstance();
$recordId = $this->getParentRecordModel()->getId();
$relModuleId = $this->getRelatedModuleModel()->getId();
$relModuleName = $this->getRelatedModuleModel()->getName();
$treeViewModel = $this->getTreeViewModel();
$relationModel = $this->getRelationModel();
$fields = $treeViewModel->getTreeField();
$template = $treeViewModel->getTemplate();
$result = $db->pquery('SELECT tr.*,rel.crmid,rel.rel_created_time,rel.rel_created_user,rel.rel_comment FROM vtiger_trees_templates_data tr ' . 'INNER JOIN u_yf_crmentity_rel_tree rel ON rel.tree = tr.tree ' . 'WHERE tr.templateid = ? AND rel.crmid = ? AND rel.relmodule = ?', [$template, $recordId, $relModuleId]);
$trees = [];
while ($row = $db->getRow($result)) {
$treeID = $row['tree'];
$pieces = explode('::', $row['parenttrre']);
end($pieces);
$parent = prev($pieces);
$parentName = '';
if ($row['depth'] > 0) {
$result2 = $db->pquery('SELECT name FROM vtiger_trees_templates_data WHERE templateid = ? AND tree = ?', [$template, $parent]);
$parentName = $db->getSingleValue($result2);
$parentName = '(' . vtranslate($parentName, $relModuleName) . ') ';
}
$tree = ['id' => $treeID, 'name' => $parentName . vtranslate($row['name'], $relModuleName), 'parent' => $parent == 0 ? '#' : $parent];
if ($relationModel->showCreatorDetail()) {
$tree['relCreatedUser'] = getOwnerName($row['rel_created_user']);
$tree['relCreatedTime'] = Vtiger_Datetime_UIType::getDisplayDateTimeValue($row['rel_created_time']);
}
if ($relationModel->showComment()) {
if (strlen($row['rel_comment']) > AppConfig::relation('COMMENT_MAX_LENGTH')) {
$tree['relCommentFull'] = $row['rel_comment'];
}
$tree['relComment'] = Vtiger_Functions::textLength($row['rel_comment'], AppConfig::relation('COMMENT_MAX_LENGTH'));
}
if (!empty($row['icon'])) {
$tree['icon'] = $row['icon'];
}
$trees[] = $tree;
}
return $trees;
}
function get_project_tickets($id, $module, $customerid, $sessionid)
{
require_once 'modules/HelpDesk/HelpDesk.php';
require_once 'include/utils/UserInfoUtil.php';
$adb = PearDatabase::getInstance();
$log = vglobal('log');
$log->debug("Entering customer portal function get_project_tickets ..");
$check = checkModuleActive($module);
if ($check == false) {
return array("#MODULE INACTIVE#");
}
if (!validateSession($customerid, $sessionid)) {
return null;
}
$user = new Users();
$userid = getPortalUserid();
$current_user = $user->retrieveCurrentUserInfoFromFile($userid);
$focus = new HelpDesk();
$focus->filterInactiveFields('HelpDesk');
$TicketsfieldVisibilityByColumn = array();
$fields_list = array();
foreach ($focus->list_fields as $fieldlabel => $values) {
foreach ($values as $table => $fieldname) {
$fields_list[$fieldlabel] = $fieldname;
$TicketsfieldVisibilityByColumn[$fieldname] = getColumnVisibilityPermission($current_user->id, $fieldname, 'HelpDesk');
}
}
$query = "SELECT vtiger_troubletickets.*, vtiger_crmentity.smownerid FROM vtiger_troubletickets\n\t\tINNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_troubletickets.ticketid\n\t\tINNER JOIN vtiger_crmentityrel ON (vtiger_crmentityrel.relcrmid = vtiger_crmentity.crmid OR vtiger_crmentityrel.crmid = vtiger_crmentity.crmid)\n\t\tWHERE vtiger_crmentity.deleted = 0 AND (vtiger_crmentityrel.crmid = ? OR vtiger_crmentityrel.relcrmid = ?)";
$params = array($id, $id);
$res = $adb->pquery($query, $params);
$noofdata = $adb->num_rows($res);
for ($j = 0; $j < $noofdata; $j++) {
$i = 0;
foreach ($fields_list as $fieldlabel => $fieldname) {
$fieldper = $TicketsfieldVisibilityByColumn[$fieldname];
//in troubletickets the list_fields has columns so we call this API
if ($fieldper == '1') {
continue;
}
$output[0][$module]['head'][0][$i]['fielddata'] = Vtiger_Language_Handler::getTranslatedString($fieldlabel, 'HelpDesk', vglobal('default_language'));
$fieldvalue = $adb->query_result($res, $j, $fieldname);
$ticketid = $adb->query_result($res, $j, 'ticketid');
if ($fieldname == 'title') {
$fieldvalue = '<a href="index.php?module=HelpDesk&action=index&fun=detail&ticketid=' . $ticketid . '">' . $fieldvalue . '</a>';
}
if ($fieldname == 'parent_id' || $fieldname == 'contact_id') {
$crmid = $fieldvalue;
$entitymodule = getSalesEntityType($crmid);
if ($crmid != '' && $entitymodule != '') {
$fieldvalues = getEntityName($entitymodule, array($crmid));
if ($entitymodule == 'Contacts') {
$fieldvalue = '<a href="index.php?module=Contacts&action=index&id=' . $crmid . '">' . $fieldvalues[$crmid] . '</a>';
} elseif ($entitymodule == 'Accounts') {
$fieldvalue = '<a href="index.php?module=Accounts&action=index&id=' . $crmid . '">' . $fieldvalues[$crmid] . '</a>';
}
} else {
$fieldvalue = '';
}
}
if ($fieldname == 'smownerid') {
$fieldvalue = getOwnerName($fieldvalue);
}
if ($fieldlabel == 'Status') {
$fieldvalue = Vtiger_Language_Handler::getTranslatedString($fieldvalue, 'HelpDesk', vglobal('default_language'));
}
$output[1][$module]['data'][$j][$i]['fielddata'] = $fieldvalue;
$i++;
}
}
$log->debug("Exiting customerportal function get_project_tickets ..");
return $output;
}
function getValue($field_result, $list_result, $fieldname, $focus, $module, $entity_id, $list_result_count, $mode, $popuptype, $returnset = '', $viewid = '')
{
global $log, $listview_max_textlength, $app_strings, $current_language, $currentModule;
$log->debug("Entering getValue(" . $field_result . "," . $list_result . "," . $fieldname . "," . get_class($focus) . "," . $module . "," . $entity_id . "," . $list_result_count . "," . $mode . "," . $popuptype . "," . $returnset . "," . $viewid . ") method ...");
global $adb, $current_user, $default_charset;
require 'user_privileges/user_privileges_' . $current_user->id . '.php';
$tabname = getParentTab();
$tabid = getTabid($module);
$current_module_strings = return_module_language($current_language, $module);
$uicolarr = $field_result[$fieldname];
foreach ($uicolarr as $key => $value) {
$uitype = $key;
$colname = $value;
}
//added for getting event status in Custom view - Jaguar
if ($module == 'Calendar' && ($colname == "status" || $colname == "eventstatus")) {
$colname = "activitystatus";
}
//Ends
$field_val = $adb->query_result($list_result, $list_result_count, $colname);
if (stristr(html_entity_decode($field_val), "<a href") === false && $uitype != 8) {
$temp_val = textlength_check($field_val);
} elseif ($uitype != 8) {
$temp_val = html_entity_decode($field_val, ENT_QUOTES);
} else {
$temp_val = $field_val;
}
// vtlib customization: New uitype to handle relation between modules
if ($uitype == '10') {
$parent_id = $field_val;
if (!empty($parent_id)) {
$parent_module = getSalesEntityType($parent_id);
$valueTitle = $parent_module;
if ($app_strings[$valueTitle]) {
$valueTitle = $app_strings[$valueTitle];
}
$displayValueArray = getEntityName($parent_module, $parent_id);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $value) {
$displayValue = $value;
}
}
$value = "<a href='index.php?module={$parent_module}&action=DetailView&record={$parent_id}' title='{$valueTitle}'>{$displayValue}</a>";
} else {
$value = '';
}
} else {
if ($uitype == 53) {
$value = textlength_check($adb->query_result($list_result, $list_result_count, 'user_name'));
// When Assigned To field is used in Popup window
if ($value == '') {
$user_id = $adb->query_result($list_result, $list_result_count, 'smownerid');
if ($user_id != null && $user_id != '') {
$value = getOwnerName($user_id);
}
}
} elseif ($uitype == 52) {
$value = getUserName($adb->query_result($list_result, $list_result_count, $colname));
} elseif ($uitype == 51) {
$parentid = $adb->query_result($list_result, $list_result_count, "parentid");
if ($module == 'Accounts') {
$entity_name = textlength_check(getAccountName($parentid));
} elseif ($module == 'Products') {
$entity_name = textlength_check(getProductName($parentid));
}
$value = '<a href="index.php?module=' . $module . '&action=DetailView&record=' . $parentid . '&parenttab=' . $tabname . '" style="' . $P_FONT_COLOR . '">' . $entity_name . '</a>';
} elseif ($uitype == 77) {
$value = getUserName($adb->query_result($list_result, $list_result_count, 'inventorymanager'));
} elseif ($uitype == 5 || $uitype == 6 || $uitype == 23 || $uitype == 70) {
if ($temp_val != '' && $temp_val != '0000-00-00') {
$value = getDisplayDate($temp_val);
} elseif ($temp_val == '0000-00-00') {
$value = '';
} else {
$value = $temp_val;
}
} elseif ($uitype == 15 || $uitype == 55 && $fieldname == "salutationtype") {
$temp_val = decode_html($adb->query_result($list_result, $list_result_count, $colname));
if ($is_admin == false && $profileGlobalPermission[1] == 1 && $profileGlobalPermission[2] == 1 && $temp_val != '') {
$temp_acttype = $adb->query_result($list_result, $list_result_count, 'activitytype');
if ($temp_acttype != 'Task' && $fieldname == "taskstatus") {
$temptable = "eventstatus";
} else {
$temptable = $fieldname;
}
$roleid = $current_user->roleid;
$roleids = array();
$subrole = getRoleSubordinates($roleid);
if (count($subrole) > 0) {
$roleids = $subrole;
}
array_push($roleids, $roleid);
//here we are checking wheather the table contains the sortorder column .If sortorder is present in the main picklist table, then the role2picklist will be applicable for this table...
$sql = "select * from vtiger_{$temptable} where {$temptable}=?";
$res = $adb->pquery($sql, array(decode_html($temp_val)));
$picklistvalueid = $adb->query_result($res, 0, 'picklist_valueid');
if ($picklistvalueid != null) {
$pick_query = "select * from vtiger_role2picklist where picklistvalueid={$picklistvalueid} and roleid in (" . generateQuestionMarks($roleids) . ")";
$res_val = $adb->pquery($pick_query, array($roleids));
$num_val = $adb->num_rows($res_val);
}
if ($num_val > 0 || $temp_acttype == 'Task' && $fieldname == 'activitytype') {
$temp_val = $temp_val;
} else {
$temp_val = "<font color='red'>" . $app_strings['LBL_NOT_ACCESSIBLE'] . "</font>";
}
}
$value = $current_module_strings[$temp_val] != '' ? $current_module_strings[$temp_val] : ($app_strings[$temp_val] != '' ? $app_strings[$temp_val] : $temp_val);
if ($value != "<font color='red'>" . $app_strings['LBL_NOT_ACCESSIBLE'] . "</font>") {
$value = textlength_check($value);
}
} elseif ($uitype == 16) {
$value = getTranslatedString($temp_val, $currentModule);
} elseif ($uitype == 71 || $uitype == 72) {
if ($temp_val != '') {
if ($fieldname == 'unit_price') {
$currency_id = getProductBaseCurrency($entity_id, $module);
$cursym_convrate = getCurrencySymbolandCRate($currency_id);
$value = "<font style='color:grey;'>" . $cursym_convrate['symbol'] . "</font> " . $temp_val;
} else {
$rate = $user_info['conv_rate'];
//changes made to remove vtiger_currency symbol infront of each vtiger_potential amount
if ($temp_val != 0) {
$value = convertFromDollar($temp_val, $rate);
} else {
$value = $temp_val;
}
}
} else {
$value = '';
}
} elseif ($uitype == 17) {
$value = '<a href="http://' . $field_val . '" target="_blank">' . $temp_val . '</a>';
} elseif ($uitype == 13 || $uitype == 104 && ($_REQUEST['action'] != 'Popup' && $_REQUEST['file'] != 'Popup')) {
if ($_SESSION['internal_mailer'] == 1) {
//check added for email link in user detailview
if ($module == 'Calendar') {
if (getActivityType($entity_id) == 'Task') {
$tabid = 9;
} else {
$tabid = 16;
}
} else {
$tabid = getTabid($module);
}
$fieldid = getFieldid($tabid, $fieldname);
if (empty($popuptype)) {
$value = '<a href="javascript:InternalMailer(' . $entity_id . ',' . $fieldid . ',\'' . $fieldname . '\',\'' . $module . '\',\'record_id\');">' . $temp_val . '</a>';
} else {
$value = $temp_val;
}
} else {
$value = '<a href="mailto:' . $field_val . '">' . $temp_val . '</a>';
}
} elseif ($uitype == 56) {
if ($temp_val == 1) {
$value = $app_strings['yes'];
} elseif ($temp_val == 0) {
$value = $app_strings['no'];
} else {
$value = '';
}
} elseif ($uitype == 57) {
if ($temp_val != '') {
$sql = "SELECT * FROM vtiger_contactdetails WHERE contactid=?";
$result = $adb->pquery($sql, array($temp_val));
$value = '';
if ($adb->num_rows($result)) {
$name = getFullNameFromQResult($result, 0, "Contacts");
$value = '<a href=index.php?module=Contacts&action=DetailView&record=' . $temp_val . '>' . $name . '</a>';
}
} else {
$value = '';
}
} elseif ($uitype == 58) {
if ($temp_val != '') {
$sql = "SELECT * FROM vtiger_campaign WHERE campaignid=?";
$result = $adb->pquery($sql, array($temp_val));
$campaignname = $adb->query_result($result, 0, "campaignname");
$value = '<a href=index.php?module=Campaigns&action=DetailView&record=' . $temp_val . '>' . $campaignname . '</a>';
} else {
$value = '';
}
} elseif ($uitype == 59) {
if ($temp_val != '') {
$value = getProductName($temp_val);
} else {
$value = '';
}
} elseif ($uitype == 61) {
$attachmentid = $adb->query_result($adb->pquery("SELECT * FROM vtiger_seattachmentsrel WHERE crmid = ?", array($entity_id)), 0, 'attachmentsid');
$value = '<a href = "index.php?module=uploads&action=downloadfile&return_module=' . $module . '&fileid=' . $attachmentid . '&filename=' . $temp_val . '">' . $temp_val . '</a>';
} elseif ($uitype == 62) {
$parentid = $adb->query_result($list_result, $list_result_count, "parent_id");
$parenttype = $adb->query_result($list_result, $list_result_count, "parent_type");
if ($parenttype == "Leads") {
$tablename = "vtiger_leaddetails";
$fieldname = "lastname";
$idname = "leadid";
}
if ($parenttype == "Accounts") {
$tablename = "vtiger_account";
$fieldname = "accountname";
$idname = "accountid";
}
if ($parenttype == "Products") {
$tablename = "vtiger_products";
$fieldname = "productname";
$idname = "productid";
}
if ($parenttype == "HelpDesk") {
$tablename = "vtiger_troubletickets";
$fieldname = "title";
$idname = "ticketid";
}
if ($parenttype == "Invoice") {
$tablename = "vtiger_invoice";
$fieldname = "subject";
$idname = "invoiceid";
}
if ($parentid != '') {
$sql = "SELECT * FROM {$tablename} WHERE {$idname} = ?";
$fieldvalue = $adb->query_result($adb->pquery($sql, array($parentid)), 0, $fieldname);
$value = '<a href=index.php?module=' . $parenttype . '&action=DetailView&record=' . $parentid . '&parenttab=' . urlencode($tabname) . '>' . $fieldvalue . '</a>';
} else {
$value = '';
}
} elseif ($uitype == 66) {
$parentid = $adb->query_result($list_result, $list_result_count, "parent_id");
$parenttype = $adb->query_result($list_result, $list_result_count, "parent_type");
if ($parenttype == "Leads") {
$tablename = "vtiger_leaddetails";
$fieldname = "lastname";
$idname = "leadid";
}
if ($parenttype == "Accounts") {
$tablename = "vtiger_account";
$fieldname = "accountname";
$idname = "accountid";
}
if ($parenttype == "HelpDesk") {
$tablename = "vtiger_troubletickets";
$fieldname = "title";
$idname = "ticketid";
}
if ($parentid != '') {
$sql = "SELECT * FROM {$tablename} WHERE {$idname} = ?";
$fieldvalue = $adb->query_result($adb->pquery($sql, array($parentid)), 0, $fieldname);
$value = '<a href=index.php?module=' . $parenttype . '&action=DetailView&record=' . $parentid . '&parenttab=' . urlencode($tabname) . '>' . $fieldvalue . '</a>';
} else {
$value = '';
}
} elseif ($uitype == 67) {
$parentid = $adb->query_result($list_result, $list_result_count, "parent_id");
$parenttype = $adb->query_result($list_result, $list_result_count, "parent_type");
if ($parenttype == "Leads") {
$tablename = "vtiger_leaddetails";
$fieldname = "lastname";
$idname = "leadid";
}
if ($parenttype == "Contacts") {
$tablename = "vtiger_contactdetails";
$fieldname = "contactname";
$idname = "contactid";
}
if ($parentid != '') {
$sql = "SELECT * FROM {$tablename} WHERE {$idname} = ?";
$fieldvalue = $adb->query_result($adb->pquery($sql, array($parentid)), 0, $fieldname);
$value = '<a href=index.php?module=' . $parenttype . '&action=DetailView&record=' . $parentid . '&parenttab=' . urlencode($tabname) . '>' . $fieldvalue . '</a>';
} else {
$value = '';
}
} elseif ($uitype == 68) {
$parentid = $adb->query_result($list_result, $list_result_count, "parent_id");
$parenttype = $adb->query_result($list_result, $list_result_count, "parent_type");
if ($parenttype == '' && $parentid != '') {
$parenttype = getSalesEntityType($parentid);
}
if ($parenttype == "Contacts") {
$tablename = "vtiger_contactdetails";
$fieldname = "contactname";
$idname = "contactid";
}
if ($parenttype == "Accounts") {
$tablename = "vtiger_account";
$fieldname = "accountname";
$idname = "accountid";
}
if ($parentid != '') {
$sql = "SELECT * FROM {$tablename} WHERE {$idname} = ?";
$fieldvalue = $adb->query_result($adb->pquery($sql, array($parentid)), 0, $fieldname);
$value = '<a href=index.php?module=' . $parenttype . '&action=DetailView&record=' . $parentid . '&parenttab=' . urlencode($tabname) . '>' . $fieldvalue . '</a>';
} else {
$value = '';
}
} elseif ($uitype == 78) {
if ($temp_val != '') {
$quote_name = getQuoteName($temp_val);
$value = '<a href=index.php?module=Quotes&action=DetailView&record=' . $temp_val . '&parenttab=' . urlencode($tabname) . '>' . textlength_check($quote_name) . '</a>';
} else {
$value = '';
}
} elseif ($uitype == 79) {
if ($temp_val != '') {
$purchaseorder_name = getPoName($temp_val);
$value = '<a href=index.php?module=PurchaseOrder&action=DetailView&record=' . $temp_val . '&parenttab=' . urlencode($tabname) . '>' . textlength_check($purchaseorder_name) . '</a>';
} else {
$value = '';
}
} elseif ($uitype == 80) {
if ($temp_val != '') {
$salesorder_name = getSoName($temp_val);
$value = "<a href=index.php?module=SalesOrder&action=DetailView&record={$temp_val}&parenttab=" . urlencode($tabname) . ">" . textlength_check($salesorder_name) . '</a>';
} else {
$value = '';
}
} elseif ($uitype == 75 || $uitype == 81) {
if ($temp_val != '') {
$vendor_name = getVendorName($temp_val);
$value = '<a href=index.php?module=Vendors&action=DetailView&record=' . $temp_val . '&parenttab=' . urlencode($tabname) . '>' . textlength_check($vendor_name) . '</a>';
} else {
$value = '';
}
} elseif ($uitype == 98) {
$value = '<a href="index.php?action=RoleDetailView&module=Settings&parenttab=Settings&roleid=' . $temp_val . '">' . textlength_check(getRoleName($temp_val)) . '</a>';
} elseif ($uitype == 33) {
$value = $temp_val != "" ? str_ireplace(' |##| ', ', ', $temp_val) : "";
if (!$is_admin && $value != '') {
$value = $field_val != "" ? str_ireplace(' |##| ', ', ', $field_val) : "";
if ($value != '') {
$value_arr = explode(',', trim($value));
$roleid = $current_user->roleid;
$subrole = getRoleSubordinates($roleid);
if (count($subrole) > 0) {
$roleids = $subrole;
array_push($roleids, $roleid);
} else {
$roleids = $roleid;
}
if (count($roleids) > 0) {
$pick_query = "select distinct {$fieldname} from vtiger_{$fieldname} inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_{$fieldname}.picklist_valueid where roleid in (" . generateQuestionMarks($roleids) . ") and picklistid in (select picklistid from vtiger_{$fieldname}) order by {$fieldname} asc";
$params = array($roleids);
} else {
$pick_query = "select distinct {$fieldname} from vtiger_{$fieldname} inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_{$fieldname}.picklist_valueid where picklistid in (select picklistid from vtiger_{$fieldname}) order by {$fieldname} asc";
$params = array();
}
$pickListResult = $adb->pquery($pick_query, $params);
$picklistval = array();
for ($i = 0; $i < $adb->num_rows($pickListResult); $i++) {
$picklistarr[] = $adb->query_result($pickListResult, $i, $fieldname);
}
$value_temp = array();
$string_temp = '';
$str_c = 0;
foreach ($value_arr as $ind => $val) {
$notaccess = '<font color="red">' . $app_strings['LBL_NOT_ACCESSIBLE'] . "</font>";
if (!$listview_max_textlength || !(strlen(preg_replace("/(<\\/?)(\\w+)([^>]*>)/i", "", $string_temp)) > $listview_max_textlength)) {
$value_temp1 = in_array(trim($val), $picklistarr) ? $val : $notaccess;
if ($str_c != 0) {
$string_temp .= ' , ';
}
$string_temp .= $value_temp1;
$str_c++;
} else {
$string_temp .= '...';
}
}
$value = $string_temp;
}
}
} elseif ($uitype == 85) {
$value = $temp_val != "" ? "<a href='skype:{$temp_val}?call'>{$temp_val}</a>" : "";
} elseif ($uitype == 116) {
$value = $temp_val != "" ? getCurrencyName($temp_val) : "";
} elseif ($uitype == 117) {
// NOTE: Without symbol the value could be used for filtering/lookup hence avoiding the translation
$value = $temp_val != "" ? getCurrencyName($temp_val, false) : "";
} elseif ($uitype == 26) {
$sql = "select foldername from vtiger_attachmentsfolder where folderid = ?";
$res = $adb->pquery($sql, array($temp_val));
$foldername = $adb->query_result($res, 0, 'foldername');
$value = $foldername;
} elseif ($uitype == 11) {
// Fix added for Trac Id: 6139
if (vtlib_isModuleActive('PBXManager')) {
$value = "<a href='javascript:;' onclick='startCall("{$temp_val}", "{$entity_id}")'>" . $temp_val . "</a>";
} else {
$value = $temp_val;
}
} elseif ($uitype == 25) {
$contactid = $_REQUEST['record'];
$emailid = $adb->query_result($list_result, $list_result_count, "activityid");
$result = $adb->pquery("SELECT access_count FROM vtiger_email_track WHERE crmid=? AND mailid=?", array($contactid, $emailid));
$value = $adb->query_result($result, 0, "access_count");
if (!$value) {
$value = 0;
}
} elseif ($uitype == 8) {
if (!empty($temp_val)) {
$temp_val = html_entity_decode($temp_val, ENT_QUOTES, $default_charset);
$json = new Zend_Json();
$value = vt_suppressHTMLTags(implode(',', $json->decode($temp_val)));
}
} else {
if ($fieldname == $focus->list_link_field) {
if ($mode == "search") {
if ($popuptype == "specific" || $popuptype == "toDospecific") {
// Added for get the first name of contact in Popup window
if ($colname == "lastname" && $module == 'Contacts') {
$temp_val = getFullNameFromQResult($list_result, $list_result_count, "Contacts");
}
$slashes_temp_val = popup_from_html($temp_val);
$slashes_temp_val = htmlspecialchars($slashes_temp_val, ENT_QUOTES, $default_charset);
//Added to avoid the error when select SO from Invoice through AjaxEdit
if ($module == 'SalesOrder') {
$value = '<a href="javascript:window.close();" onclick=\'set_return_specific("' . $entity_id . '", "' . nl2br(decode_html($slashes_temp_val)) . '","' . $_REQUEST['form'] . '");\'>' . $temp_val . '</a>';
} elseif ($module == 'Contacts') {
require_once 'modules/Contacts/Contacts.php';
$cntct_focus = new Contacts();
$cntct_focus->retrieve_entity_info($entity_id, "Contacts");
$slashes_temp_val = popup_from_html($temp_val);
//ADDED TO CHECK THE FIELD PERMISSIONS FOR
$xyz = array('mailingstreet', 'mailingcity', 'mailingzip', 'mailingpobox', 'mailingcountry', 'mailingstate', 'otherstreet', 'othercity', 'otherzip', 'otherpobox', 'othercountry', 'otherstate');
for ($i = 0; $i < 12; $i++) {
if (getFieldVisibilityPermission($module, $current_user->id, $xyz[$i]) == '0') {
$cntct_focus->column_fields[$xyz[$i]] = $cntct_focus->column_fields[$xyz[$i]];
} else {
$cntct_focus->column_fields[$xyz[$i]] = '';
}
}
// For ToDo creation the underlying form is not named as EditView
$form = !empty($_REQUEST['form']) ? $_REQUEST['form'] : '';
if (!empty($form)) {
$form = htmlspecialchars($form, ENT_QUOTES, $default_charset);
}
$value = '<a href="javascript:window.close();" onclick=\'set_return_contact_address("' . $entity_id . '", "' . nl2br(decode_html($slashes_temp_val)) . '", "' . popup_decode_html($cntct_focus->column_fields['mailingstreet']) . '", "' . popup_decode_html($cntct_focus->column_fields['otherstreet']) . '", "' . popup_decode_html($cntct_focus->column_fields['mailingcity']) . '", "' . popup_decode_html($cntct_focus->column_fields['othercity']) . '", "' . popup_decode_html($cntct_focus->column_fields['mailingstate']) . '", "' . popup_decode_html($cntct_focus->column_fields['otherstate']) . '", "' . popup_decode_html($cntct_focus->column_fields['mailingzip']) . '", "' . popup_decode_html($cntct_focus->column_fields['otherzip']) . '", "' . popup_decode_html($cntct_focus->column_fields['mailingcountry']) . '", "' . popup_decode_html($cntct_focus->column_fields['othercountry']) . '","' . popup_decode_html($cntct_focus->column_fields['mailingpobox']) . '", "' . popup_decode_html($cntct_focus->column_fields['otherpobox']) . '","' . $form . '");\'>' . $temp_val . '</a>';
} else {
if ($popuptype == 'toDospecific') {
$value = '<a href="javascript:window.close();" onclick=\'set_return_toDospecific("' . $entity_id . '", "' . nl2br(decode_html($slashes_temp_val)) . '");\'>' . $temp_val . '</a>';
} else {
$value = '<a href="javascript:window.close();" onclick=\'set_return_specific("' . $entity_id . '", "' . nl2br(decode_html($slashes_temp_val)) . '");\'>' . $temp_val . '</a>';
}
}
} elseif ($popuptype == "detailview") {
if ($colname == "lastname" && ($module == 'Contacts' || $module == 'Leads')) {
$temp_val = getFullNameFromQResult($list_result, $list_result_count, $module);
}
$slashes_temp_val = popup_from_html($temp_val);
$slashes_temp_val = htmlspecialchars($slashes_temp_val, ENT_QUOTES, $default_charset);
$focus->record_id = $_REQUEST['recordid'];
if ($_REQUEST['return_module'] == "Calendar") {
$value = '<a href="javascript:window.close();" id="calendarCont' . $entity_id . '" LANGUAGE=javascript onclick=\'add_data_to_relatedlist_incal("' . $entity_id . '","' . decode_html($slashes_temp_val) . '");\'>' . $temp_val . '</a>';
} else {
$value = '<a href="javascript:window.close();" onclick=\'add_data_to_relatedlist("' . $entity_id . '","' . $focus->record_id . '","' . $module . '");\'>' . $temp_val . '</a>';
}
} elseif ($popuptype == "formname_specific") {
$slashes_temp_val = popup_from_html($temp_val);
$slashes_temp_val = htmlspecialchars($slashes_temp_val, ENT_QUOTES, $default_charset);
$value = '<a href="javascript:window.close();" onclick=\'set_return_formname_specific("' . $_REQUEST['form'] . '", "' . $entity_id . '", "' . nl2br(decode_html($slashes_temp_val)) . '");\'>' . $temp_val . '</a>';
} elseif ($popuptype == "inventory_prod") {
$row_id = $_REQUEST['curr_row'];
//To get all the tax types and values and pass it to product details
$tax_str = '';
$tax_details = getAllTaxes();
for ($tax_count = 0; $tax_count < count($tax_details); $tax_count++) {
$tax_str .= $tax_details[$tax_count]['taxname'] . '=' . $tax_details[$tax_count]['percentage'] . ',';
}
$tax_str = trim($tax_str, ',');
$rate = $user_info['conv_rate'];
if (getFieldVisibilityPermission('Products', $current_user->id, 'unit_price') == '0') {
$unitprice = $adb->query_result($list_result, $list_result_count, 'unit_price');
if ($_REQUEST['currencyid'] != null) {
$prod_prices = getPricesForProducts($_REQUEST['currencyid'], array($entity_id));
$unitprice = $prod_prices[$entity_id];
}
} else {
$unit_price = '';
}
$sub_products = '';
$sub_prod = '';
$sub_prod_query = $adb->pquery("SELECT vtiger_products.productid,vtiger_products.productname,vtiger_products.qtyinstock,vtiger_crmentity.description from vtiger_products INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_products.productid INNER JOIN vtiger_seproductsrel on vtiger_seproductsrel.crmid=vtiger_products.productid WHERE vtiger_seproductsrel.productid=? and vtiger_seproductsrel.setype='Products'", array($entity_id));
for ($i = 0; $i < $adb->num_rows($sub_prod_query); $i++) {
//$sub_prod=array();
$id = $adb->query_result($sub_prod_query, $i, "productid");
$str_sep = '';
if ($i > 0) {
$str_sep = ":";
}
$sub_products .= $str_sep . $id;
$sub_prod .= $str_sep . " - " . $adb->query_result($sub_prod_query, $i, "productname");
}
$sub_det = $sub_products . "::" . str_replace(":", "<br>", $sub_prod);
$qty_stock = $adb->query_result($list_result, $list_result_count, 'qtyinstock');
//fix for T6943
$slashes_temp_val = popup_from_html($field_val);
$slashes_temp_val = htmlspecialchars($slashes_temp_val, ENT_QUOTES, $default_charset);
$description = popup_from_html($adb->query_result($list_result, $list_result_count, 'description'));
$slashes_temp_desc = decode_html(htmlspecialchars($description, ENT_QUOTES, $default_charset));
$slashes_desc = str_replace(array("\r", "\n"), array('\\r', '\\n'), $slashes_temp_desc);
$tmp_arr = array("entityid" => $entity_id, "prodname" => "" . stripslashes(decode_html(nl2br($slashes_temp_val))) . "", "unitprice" => "{$unitprice}", "qtyinstk" => "{$qty_stock}", "taxstring" => "{$tax_str}", "rowid" => "{$row_id}", "desc" => "{$slashes_desc}", "subprod_ids" => "{$sub_det}");
require_once 'include/Zend/Json.php';
$prod_arr = Zend_Json::encode($tmp_arr);
$value = '<a href="javascript:window.close();" id=\'popup_product_' . $entity_id . '\' onclick=\'set_return_inventory("' . $entity_id . '", "' . decode_html(nl2br($slashes_temp_val)) . '", "' . $unitprice . '", "' . $qty_stock . '","' . $tax_str . '","' . $row_id . '","' . $slashes_desc . '","' . $sub_det . '");\' vt_prod_arr=\'' . $prod_arr . '\' >' . $temp_val . '</a>';
} elseif ($popuptype == "inventory_prod_po") {
$row_id = $_REQUEST['curr_row'];
//To get all the tax types and values and pass it to product details
$tax_str = '';
$tax_details = getAllTaxes();
for ($tax_count = 0; $tax_count < count($tax_details); $tax_count++) {
$tax_str .= $tax_details[$tax_count]['taxname'] . '=' . $tax_details[$tax_count]['percentage'] . ',';
}
$tax_str = trim($tax_str, ',');
$rate = $user_info['conv_rate'];
if (getFieldVisibilityPermission($module, $current_user->id, 'unit_price') == '0') {
$unitprice = $adb->query_result($list_result, $list_result_count, 'unit_price');
if ($_REQUEST['currencyid'] != null) {
$prod_prices = getPricesForProducts($_REQUEST['currencyid'], array($entity_id), $module);
$unitprice = $prod_prices[$entity_id];
}
} else {
$unit_price = '';
}
$sub_products = '';
$sub_prod = '';
$sub_prod_query = $adb->pquery("SELECT vtiger_products.productid,vtiger_products.productname,vtiger_products.qtyinstock,vtiger_crmentity.description from vtiger_products INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_products.productid INNER JOIN vtiger_seproductsrel on vtiger_seproductsrel.crmid=vtiger_products.productid WHERE vtiger_seproductsrel.productid=? and vtiger_seproductsrel.setype='Products'", array($entity_id));
for ($i = 0; $i < $adb->num_rows($sub_prod_query); $i++) {
//$sub_prod=array();
$id = $adb->query_result($sub_prod_query, $i, "productid");
$str_sep = '';
if ($i > 0) {
$str_sep = ":";
}
$sub_products .= $str_sep . $id;
$sub_prod .= $str_sep . " - {$id}." . $adb->query_result($sub_prod_query, $i, "productname");
}
$sub_det = $sub_products . "::" . str_replace(":", "<br>", $sub_prod);
$slashes_temp_val = popup_from_html($field_val);
$slashes_temp_val = htmlspecialchars($slashes_temp_val, ENT_QUOTES, $default_charset);
$description = popup_from_html($adb->query_result($list_result, $list_result_count, 'description'));
$slashes_temp_desc = decode_html(htmlspecialchars($description, ENT_QUOTES, $default_charset));
$slashes_desc = str_replace(array("\r", "\n"), array('\\r', '\\n'), $slashes_temp_desc);
$tmp_arr = array("entityid" => $entity_id, "prodname" => "" . stripslashes(decode_html(nl2br($slashes_temp_val))) . "", "unitprice" => "{$unitprice}", "qtyinstk" => "{$qty_stock}", "taxstring" => "{$tax_str}", "rowid" => "{$row_id}", "desc" => "{$slashes_desc}", "subprod_ids" => "{$sub_det}");
require_once 'include/Zend/Json.php';
$prod_arr = Zend_Json::encode($tmp_arr);
$value = '<a href="javascript:window.close();" id=\'popup_product_' . $entity_id . '\' onclick=\'set_return_inventory_po("' . $entity_id . '", "' . decode_html(nl2br($slashes_temp_val)) . '", "' . $unitprice . '", "' . $tax_str . '","' . $row_id . '","' . $slashes_desc . '","' . $sub_det . '"); \' vt_prod_arr=\'' . $prod_arr . '\' >' . $temp_val . '</a>';
} elseif ($popuptype == "inventory_service") {
$row_id = $_REQUEST['curr_row'];
//To get all the tax types and values and pass it to product details
$tax_str = '';
$tax_details = getAllTaxes();
for ($tax_count = 0; $tax_count < count($tax_details); $tax_count++) {
$tax_str .= $tax_details[$tax_count]['taxname'] . '=' . $tax_details[$tax_count]['percentage'] . ',';
}
$tax_str = trim($tax_str, ',');
$rate = $user_info['conv_rate'];
if (getFieldVisibilityPermission('Services', $current_user->id, 'unit_price') == '0') {
$unitprice = $adb->query_result($list_result, $list_result_count, 'unit_price');
if ($_REQUEST['currencyid'] != null) {
$prod_prices = getPricesForProducts($_REQUEST['currencyid'], array($entity_id), $module);
$unitprice = $prod_prices[$entity_id];
}
} else {
$unit_price = '';
}
$slashes_temp_val = popup_from_html($field_val);
$slashes_temp_val = htmlspecialchars($slashes_temp_val, ENT_QUOTES, $default_charset);
$description = popup_from_html($adb->query_result($list_result, $list_result_count, 'description'));
$slashes_temp_desc = decode_html(htmlspecialchars($description, ENT_QUOTES, $default_charset));
$slashes_desc = str_replace(array("\r", "\n"), array('\\r', '\\n'), $slashes_temp_desc);
$tmp_arr = array("entityid" => $entity_id, "prodname" => "" . stripslashes(decode_html(nl2br($slashes_temp_val))) . "", "unitprice" => "{$unitprice}", "taxstring" => "{$tax_str}", "rowid" => "{$row_id}", "desc" => "{$slashes_desc}");
require_once 'include/Zend/Json.php';
$prod_arr = Zend_Json::encode($tmp_arr);
$value = '<a href="javascript:window.close();" id=\'popup_product_' . $entity_id . '\' onclick=\'set_return_inventory("' . $entity_id . '", "' . decode_html(nl2br($slashes_temp_val)) . '", "' . $unitprice . '", "' . $tax_str . '","' . $row_id . '","' . $slashes_desc . '");\' vt_prod_arr=\'' . $prod_arr . '\' >' . $temp_val . '</a>';
} elseif ($popuptype == "inventory_pb") {
$prod_id = $_REQUEST['productid'];
$flname = $_REQUEST['fldname'];
$listprice = getListPrice($prod_id, $entity_id);
$temp_val = popup_from_html($temp_val);
$value = '<a href="javascript:window.close();" onclick=\'set_return_inventory_pb("' . $listprice . '", "' . $flname . '"); \'>' . $temp_val . '</a>';
} elseif ($popuptype == "specific_account_address") {
require_once 'modules/Accounts/Accounts.php';
$acct_focus = new Accounts();
$acct_focus->retrieve_entity_info($entity_id, "Accounts");
$slashes_temp_val = popup_from_html($temp_val);
$slashes_temp_val = htmlspecialchars($slashes_temp_val, ENT_QUOTES, $default_charset);
$xyz = array('bill_street', 'bill_city', 'bill_code', 'bill_pobox', 'bill_country', 'bill_state', 'ship_street', 'ship_city', 'ship_code', 'ship_pobox', 'ship_country', 'ship_state');
for ($i = 0; $i < 12; $i++) {
if (getFieldVisibilityPermission($module, $current_user->id, $xyz[$i]) == '0') {
$acct_focus->column_fields[$xyz[$i]] = $acct_focus->column_fields[$xyz[$i]];
} else {
$acct_focus->column_fields[$xyz[$i]] = '';
}
}
$bill_street = str_replace(array("\r", "\n"), array('\\r', '\\n'), popup_decode_html($acct_focus->column_fields['bill_street']));
$ship_street = str_replace(array("\r", "\n"), array('\\r', '\\n'), popup_decode_html($acct_focus->column_fields['ship_street']));
$value = '<a href="javascript:window.close();" onclick=\'set_return_address("' . $entity_id . '", "' . nl2br(decode_html($slashes_temp_val)) . '", "' . $bill_street . '", "' . $ship_street . '", "' . popup_decode_html($acct_focus->column_fields['bill_city']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_city']) . '", "' . popup_decode_html($acct_focus->column_fields['bill_state']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_state']) . '", "' . popup_decode_html($acct_focus->column_fields['bill_code']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_code']) . '", "' . popup_decode_html($acct_focus->column_fields['bill_country']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_country']) . '","' . popup_decode_html($acct_focus->column_fields['bill_pobox']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_pobox']) . '");\'>' . $temp_val . '</a>';
} elseif ($popuptype == "specific_contact_account_address") {
require_once 'modules/Accounts/Accounts.php';
$acct_focus = new Accounts();
$acct_focus->retrieve_entity_info($entity_id, "Accounts");
$slashes_temp_val = popup_from_html($temp_val);
$slashes_temp_val = htmlspecialchars($slashes_temp_val, ENT_QUOTES, $default_charset);
$bill_street = str_replace(array("\r", "\n"), array('\\r', '\\n'), popup_decode_html($acct_focus->column_fields['bill_street']));
$ship_street = str_replace(array("\r", "\n"), array('\\r', '\\n'), popup_decode_html($acct_focus->column_fields['ship_street']));
$value = '<a href="javascript:window.close();" onclick=\'set_return_contact_address("' . $entity_id . '", "' . nl2br(decode_html($slashes_temp_val)) . '", "' . $bill_street . '", "' . $ship_street . '", "' . popup_decode_html($acct_focus->column_fields['bill_city']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_city']) . '", "' . popup_decode_html($acct_focus->column_fields['bill_state']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_state']) . '", "' . popup_decode_html($acct_focus->column_fields['bill_code']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_code']) . '", "' . popup_decode_html($acct_focus->column_fields['bill_country']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_country']) . '","' . popup_decode_html($acct_focus->column_fields['bill_pobox']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_pobox']) . '");\'>' . $temp_val . '</a>';
} elseif ($popuptype == "specific_potential_account_address") {
$slashes_temp_val = popup_from_html($temp_val);
$slashes_temp_val = htmlspecialchars($slashes_temp_val, ENT_QUOTES, $default_charset);
// For B2C support, Potential was enabled to be linked to Contacts also.
// Hence we need case handling for it.
$relatedid = $adb->query_result($list_result, $list_result_count, "related_to");
$relatedentity = getSalesEntityType($relatedid);
if ($relatedentity == 'Accounts') {
require_once 'modules/Accounts/Accounts.php';
$acct_focus = new Accounts();
$acct_focus->retrieve_entity_info($relatedid, "Accounts");
$account_name = getAccountName($relatedid);
$slashes_account_name = popup_from_html($account_name);
$slashes_account_name = htmlspecialchars($slashes_account_name, ENT_QUOTES, $default_charset);
$xyz = array('bill_street', 'bill_city', 'bill_code', 'bill_pobox', 'bill_country', 'bill_state', 'ship_street', 'ship_city', 'ship_code', 'ship_pobox', 'ship_country', 'ship_state');
for ($i = 0; $i < 12; $i++) {
if (getFieldVisibilityPermission('Accounts', $current_user->id, $xyz[$i]) == '0') {
$acct_focus->column_fields[$xyz[$i]] = $acct_focus->column_fields[$xyz[$i]];
} else {
$acct_focus->column_fields[$xyz[$i]] = '';
}
}
$bill_street = str_replace(array("\r", "\n"), array('\\r', '\\n'), popup_decode_html($acct_focus->column_fields['bill_street']));
$ship_street = str_replace(array("\r", "\n"), array('\\r', '\\n'), popup_decode_html($acct_focus->column_fields['ship_street']));
$value = '<a href="javascript:window.close();" onclick=\'set_return_address("' . $entity_id . '", "' . nl2br(decode_html($slashes_temp_val)) . '", "' . $relatedid . '", "' . nl2br(decode_html($slashes_account_name)) . '", "' . $bill_street . '", "' . $ship_street . '", "' . popup_decode_html($acct_focus->column_fields['bill_city']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_city']) . '", "' . popup_decode_html($acct_focus->column_fields['bill_state']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_state']) . '", "' . popup_decode_html($acct_focus->column_fields['bill_code']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_code']) . '", "' . popup_decode_html($acct_focus->column_fields['bill_country']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_country']) . '","' . popup_decode_html($acct_focus->column_fields['bill_pobox']) . '", "' . popup_decode_html($acct_focus->column_fields['ship_pobox']) . '");\'>' . $temp_val . '</a>';
} else {
if ($relatedentity == 'Contacts') {
require_once 'modules/Contacts/Contacts.php';
$contact_name = getContactName($relatedid);
$slashes_contact_name = popup_from_html($contact_name);
$slashes_contact_name = htmlspecialchars($slashes_contact_name, ENT_QUOTES, $default_charset);
$value = '<a href="javascript:window.close();" onclick=\'set_return_contact("' . $entity_id . '", "' . nl2br(decode_html($slashes_temp_val)) . '", "' . $relatedid . '", "' . nl2br(decode_html($slashes_contact_name)) . '");\'>' . $temp_val . '</a>';
} else {
$value = $temp_val;
}
}
} elseif ($popuptype == "set_return_emails") {
if ($module == 'Accounts') {
$name = $adb->query_result($list_result, $list_result_count, 'accountname');
$accid = $adb->query_result($list_result, $list_result_count, 'accountid');
if (CheckFieldPermission('email1', $module) == "true") {
$emailaddress = $adb->query_result($list_result, $list_result_count, "email1");
$email_check = 1;
} else {
$email_check = 0;
}
if ($emailaddress == '') {
if (CheckFieldPermission('email2', $module) == 'true') {
$emailaddress2 = $adb->query_result($list_result, $list_result_count, "email2");
$email_check = 2;
} else {
if ($email_check == 1) {
$email_check = 4;
} else {
$email_check = 3;
}
}
}
$querystr = "SELECT fieldid,fieldlabel,columnname FROM vtiger_field WHERE tabid=? and uitype=13 and vtiger_field.presence in (0,2)";
$queryres = $adb->pquery($querystr, array(getTabid($module)));
//Change this index 0 - to get the vtiger_fieldid based on email1 or email2
$fieldid = $adb->query_result($queryres, 0, 'fieldid');
$slashes_name = popup_from_html($name);
$slashes_name = htmlspecialchars($slashes_name, ENT_QUOTES, $default_charset);
$value = '<a href="javascript:window.close();" onclick=\'return set_return_emails(' . $entity_id . ',' . $fieldid . ',"' . decode_html($slashes_name) . '","' . $emailaddress . '","' . $emailaddress2 . '","' . $email_check . '"); \'>' . textlength_check($name) . '</a>';
} elseif ($module == 'Vendors') {
$name = $adb->query_result($list_result, $list_result_count, 'vendorname');
$venid = $adb->query_result($list_result, $list_result_count, 'vendorid');
if (CheckFieldPermission('email', $module) == "true") {
$emailaddress = $adb->query_result($list_result, $list_result_count, "email");
$email_check = 1;
} else {
$email_check = 0;
}
$querystr = "SELECT fieldid,fieldlabel,columnname FROM vtiger_field WHERE tabid=? and uitype=13 and vtiger_field.presence in (0,2)";
$queryres = $adb->pquery($querystr, array(getTabid($module)));
//Change this index 0 - to get the vtiger_fieldid based on email1 or email2
$fieldid = $adb->query_result($queryres, 0, 'fieldid');
$slashes_name = popup_from_html($name);
$slashes_name = htmlspecialchars($slashes_name, ENT_QUOTES, $default_charset);
$value = '<a href="javascript:window.close();" onclick=\'return set_return_emails(' . $entity_id . ',' . $fieldid . ',"' . decode_html($slashes_name) . '","' . $emailaddress . '","' . $emailaddress2 . '","' . $email_check . '"); \'>' . textlength_check($name) . '</a>';
} elseif ($module == 'Contacts' || $module == 'Leads') {
$name = getFullNameFromQResult($list_result, $list_result_count, $module);
if (CheckFieldPermission('email', $module) == "true") {
$emailaddress = $adb->query_result($list_result, $list_result_count, "email");
$email_check = 1;
} else {
$email_check = 0;
}
if ($emailaddress == '') {
if (CheckFieldPermission('yahooid', $module) == 'true') {
$emailaddress2 = $adb->query_result($list_result, $list_result_count, "yahooid");
$email_check = 2;
} else {
if ($email_check == 1) {
$email_check = 4;
} else {
$email_check = 3;
}
}
}
$querystr = "SELECT fieldid,fieldlabel,columnname FROM vtiger_field WHERE tabid=? and uitype=13 and vtiger_field.presence in (0,2)";
$queryres = $adb->pquery($querystr, array(getTabid($module)));
//Change this index 0 - to get the vtiger_fieldid based on email or yahooid
$fieldid = $adb->query_result($queryres, 0, 'fieldid');
$slashes_name = popup_from_html($name);
$slashes_name = htmlspecialchars($slashes_name, ENT_QUOTES, $default_charset);
$value = '<a href="javascript:window.close();" onclick=\'return set_return_emails(' . $entity_id . ',' . $fieldid . ',"' . decode_html($slashes_name) . '","' . $emailaddress . '","' . $emailaddress2 . '","' . $email_check . '"); \'>' . $name . '</a>';
} else {
$firstname = $adb->query_result($list_result, $list_result_count, "first_name");
$lastname = $adb->query_result($list_result, $list_result_count, "last_name");
$name = $lastname . ' ' . $firstname;
$emailaddress = $adb->query_result($list_result, $list_result_count, "email1");
$slashes_name = popup_from_html($name);
$slashes_name = htmlspecialchars($slashes_name, ENT_QUOTES, $default_charset);
$email_check = 1;
$value = '<a href="javascript:window.close();" onclick=\'return set_return_emails(' . $entity_id . ',-1,"' . decode_html($slashes_name) . '","' . $emailaddress . '","' . $emailaddress2 . '","' . $email_check . '"); \'>' . textlength_check($name) . '</a>';
}
} elseif ($popuptype == "specific_vendor_address") {
require_once 'modules/Vendors/Vendors.php';
$acct_focus = new Vendors();
$acct_focus->retrieve_entity_info($entity_id, "Vendors");
$slashes_temp_val = popup_from_html($temp_val);
$slashes_temp_val = htmlspecialchars($slashes_temp_val, ENT_QUOTES, $default_charset);
$xyz = array('street', 'city', 'postalcode', 'pobox', 'country', 'state');
for ($i = 0; $i < 6; $i++) {
if (getFieldVisibilityPermission($module, $current_user->id, $xyz[$i]) == '0') {
$acct_focus->column_fields[$xyz[$i]] = $acct_focus->column_fields[$xyz[$i]];
} else {
$acct_focus->column_fields[$xyz[$i]] = '';
}
}
$bill_street = str_replace(array("\r", "\n"), array('\\r', '\\n'), popup_decode_html($acct_focus->column_fields['street']));
$value = '<a href="javascript:window.close();" onclick=\'set_return_address("' . $entity_id . '", "' . nl2br(decode_html($slashes_temp_val)) . '", "' . $bill_street . '", "' . popup_decode_html($acct_focus->column_fields['city']) . '", "' . popup_decode_html($acct_focus->column_fields['state']) . '", "' . popup_decode_html($acct_focus->column_fields['postalcode']) . '", "' . popup_decode_html($acct_focus->column_fields['country']) . '","' . popup_decode_html($acct_focus->column_fields['pobox']) . '");\'>' . $temp_val . '</a>';
} elseif ($popuptype == "specific_campaign") {
$slashes_temp_val = popup_from_html($temp_val);
$slashes_temp_val = htmlspecialchars($slashes_temp_val, ENT_QUOTES, $default_charset);
$value = '<a href="javascript:window.close();" onclick=\'set_return_specific_campaign("' . $entity_id . '", "' . nl2br(decode_html($slashes_temp_val)) . '");\'>' . $temp_val . '</a>';
} else {
if ($colname == "lastname") {
$temp_val = getFullNameFromQResult($list_result, $list_result_count, $module);
}
$slashes_temp_val = popup_from_html($temp_val);
$slashes_temp_val = htmlspecialchars($slashes_temp_val, ENT_QUOTES, $default_charset);
$log->debug("Exiting getValue method ...");
if ($_REQUEST['maintab'] == 'Calendar') {
$value = '<a href="javascript:window.close();" onclick=\'set_return_todo("' . $entity_id . '", "' . nl2br(decode_html($slashes_temp_val)) . '");\'>' . $temp_val . '</a>';
} else {
$value = '<a href="javascript:window.close();" onclick=\'set_return("' . $entity_id . '", "' . nl2br(decode_html($slashes_temp_val)) . '");\'>' . $temp_val . '</a>';
}
}
} else {
if ($module == "Leads" && $colname == "lastname" || $module == "Contacts" && $colname == "lastname") {
$value = '<a href="index.php?action=DetailView&module=' . $module . '&record=' . $entity_id . '&parenttab=' . $tabname . '">' . $temp_val . '</a>';
} elseif ($module == "Calendar") {
$actvity_type = $adb->query_result($list_result, $list_result_count, 'activitytype');
$actvity_type = $actvity_type != '' ? $actvity_type : $adb->query_result($list_result, $list_result_count, 'type');
if ($actvity_type == "Task") {
$value = '<a href="index.php?action=DetailView&module=' . $module . '&record=' . $entity_id . '&activity_mode=Task&parenttab=' . $tabname . '">' . $temp_val . '</a>';
} else {
$value = '<a href="index.php?action=DetailView&module=' . $module . '&record=' . $entity_id . '&activity_mode=Events&parenttab=' . $tabname . '">' . $temp_val . '</a>';
}
} elseif ($module == "Vendors") {
$value = '<a href="index.php?action=DetailView&module=Vendors&record=' . $entity_id . '&parenttab=' . $tabname . '">' . $temp_val . '</a>';
} elseif ($module == "PriceBooks") {
$value = '<a href="index.php?action=DetailView&module=PriceBooks&record=' . $entity_id . '&parenttab=' . $tabname . '">' . $temp_val . '</a>';
} elseif ($module == "SalesOrder") {
$value = '<a href="index.php?action=DetailView&module=SalesOrder&record=' . $entity_id . '&parenttab=' . $tabname . '">' . $temp_val . '</a>';
} elseif ($module == 'Emails') {
$value = $temp_val;
} else {
$value = '<a href="index.php?action=DetailView&module=' . $module . '&record=' . $entity_id . '&parenttab=' . $tabname . '">' . $temp_val . '</a>';
}
}
} elseif ($fieldname == 'expectedroi' || $fieldname == 'actualroi' || $fieldname == 'actualcost' || $fieldname == 'budgetcost' || $fieldname == 'expectedrevenue') {
$rate = $user_info['conv_rate'];
$value = convertFromDollar($temp_val, $rate);
} elseif (($module == 'Invoice' || $module == 'Quotes' || $module == 'PurchaseOrder' || $module == 'SalesOrder') && ($fieldname == 'hdnGrandTotal' || $fieldname == 'hdnSubTotal' || $fieldname == 'txtAdjustment' || $fieldname == 'hdnDiscountAmount' || $fieldname == 'hdnS_H_Amount')) {
$currency_info = getInventoryCurrencyInfo($module, $entity_id);
$currency_id = $currency_info['currency_id'];
$currency_symbol = $currency_info['currency_symbol'];
$value = $currency_symbol . $temp_val;
} else {
$value = $temp_val;
}
}
}
// Mike Crowe Mod --------------------------------------------------------Make right justified and vtiger_currency value
if (in_array($uitype, array(71, 72, 7, 9, 90))) {
$value = '<span align="right">' . $value . '</div>';
}
$log->debug("Exiting getValue method ...");
return $value;
}
/** Function to get the update ticket history for the specified ticketid
* @param $id -- $ticketid:: Type Integer
*/
function constructUpdateLog($focus, $mode, $assigned_group_name, $assigntype)
{
global $adb;
global $current_user;
if ($mode != 'edit') {
$updatelog = "Ticket created. Assigned to ";
if (!empty($assigned_group_name) && $assigntype == 'T') {
$updatelog .= " group " . (is_array($assigned_group_name) ? $assigned_group_name[0] : $assigned_group_name);
} elseif ($focus->column_fields['assigned_user_id'] != '') {
$updatelog .= " user " . getUserFullName($focus->column_fields['assigned_user_id']);
} else {
$updatelog .= " user " . getUserFullName($current_user->id);
}
$fldvalue = date("l dS F Y h:i:s A") . ' by ' . $current_user->user_name;
$updatelog .= " -- " . $fldvalue . "--//--";
} else {
$ticketid = $focus->id;
//First retrieve the existing information
$tktresult = $adb->pquery("select * from vtiger_troubletickets where ticketid=?", array($ticketid));
$crmresult = $adb->pquery("select * from vtiger_crmentity where crmid=?", array($ticketid));
$updatelog = decode_html($adb->query_result($tktresult, 0, "update_log"));
$old_owner_id = $adb->query_result($crmresult, 0, "smownerid");
$old_status = $adb->query_result($tktresult, 0, "status");
$old_priority = $adb->query_result($tktresult, 0, "priority");
$old_severity = $adb->query_result($tktresult, 0, "severity");
$old_category = $adb->query_result($tktresult, 0, "category");
//Assigned to change log
if ($focus->column_fields['assigned_user_id'] != $old_owner_id) {
$owner_name = getOwnerName($focus->column_fields['assigned_user_id']);
if ($assigntype == 'T') {
$updatelog .= ' Transferred to group ' . $owner_name . '\\.';
} else {
$updatelog .= ' Transferred to user ' . decode_html($owner_name) . '\\.';
}
// Need to decode UTF characters which are migrated from versions < 5.0.4.
}
//Status change log
if ($old_status != $focus->column_fields['ticketstatus'] && $focus->column_fields['ticketstatus'] != '') {
$updatelog .= ' Status Changed to ' . $focus->column_fields['ticketstatus'] . '\\.';
}
//Priority change log
if ($old_priority != $focus->column_fields['ticketpriorities'] && $focus->column_fields['ticketpriorities'] != '') {
$updatelog .= ' Priority Changed to ' . $focus->column_fields['ticketpriorities'] . '\\.';
}
//Severity change log
if ($old_severity != $focus->column_fields['ticketseverities'] && $focus->column_fields['ticketseverities'] != '') {
$updatelog .= ' Severity Changed to ' . $focus->column_fields['ticketseverities'] . '\\.';
}
//Category change log
if ($old_category != $focus->column_fields['ticketcategories'] && $focus->column_fields['ticketcategories'] != '') {
$updatelog .= ' Category Changed to ' . $focus->column_fields['ticketcategories'] . '\\.';
}
$updatelog .= ' -- ' . date("l dS F Y h:i:s A") . ' by ' . $current_user->user_name . '--//--';
}
return $updatelog;
}
function module_Chart($user_id, $date_start = "2000-01-01", $end_date = "2017-01-01", $query, $graph_for, $title, $added_qry = "", $module = "", $graph_type)
{
global $adb, $current_user, $mod_strings, $default_charset;
global $days, $date_array, $period_type;
if ($added_qry != "") {
$query .= $added_qry;
}
$result = $adb->query($query);
$no_of_rows = $adb->num_rows($result);
$mod_count_array = array();
$search_str_array = array();
$mod_name_array = array();
$count_by_date[] = array();
$mod_tot_cnt_array = array();
$mod_name_val = "";
$mod_cnt_crtd_date = "";
$target_val = "";
$bar_target_val = "";
$test_target_val = "";
if ($no_of_rows != 0) {
while ($row = $adb->fetch_array($result)) {
if ($graph_for == 'sostatus' || $graph_for == 'leadsource' || $graph_for == 'leadstatus' || $graph_for == 'industry' || $graph_for == 'productcategory' || $graph_for == 'postatus' || $graph_for == 'invoicestatus' || $graph_for == 'ticketstatus' || $graph_for == 'priority' || $graph_for == 'category' || $graph_for == 'quotestage' || $graph_for == 'salesstage') {
$mod_name = getTranslatedString($row[$graph_for]);
$search_str = $row[$graph_for];
} else {
$mod_name = $row[$graph_for];
$search_str = $row[$graph_for];
}
if ($mod_name == "") {
$mod_name = $mod_strings["Un Assigned"];
$search_str = " ";
}
$crtd_time = $row['createdtime'];
$crtd_time_array = explode(" ", $crtd_time);
$crtd_date = $crtd_time_array[0];
if (!isset($mod_tot_cnt_array[$crtd_date])) {
$mod_tot_cnt_array[$crtd_date] = 0;
}
$mod_tot_cnt_array[$crtd_date] += 1;
if (in_array($mod_name, $mod_name_array) == false) {
$uniqueid[$mod_name] = '0';
array_push($mod_name_array, $mod_name);
// getting all the unique Names into the array
if ($graph_for == "productname") {
if ($row['qtyinstock'] == '') {
$mod_count_array[$mod_name] = 1;
} else {
$mod_count_array[$mod_name] = $row['qtyinstock'];
}
}
} else {
if ($graph_for == "productname") {
$uniqueid[$mod_name] = $uniqueid[$mod_name] + 1;
$mod_name = $mod_name . '[' . $uniqueid[$mod_name] . ']';
array_push($mod_name_array, $mod_name);
// getting all the unique Names into the array
if ($row['qtyinstock'] == '') {
$mod_count_array[$mod_name] = 1;
} else {
$mod_count_array[$mod_name] = $row['qtyinstock'];
}
}
}
if (in_array($search_str, $search_str_array) == false) {
array_push($search_str_array, $search_str);
}
//Counting the number of values for a type of graph
if ($graph_for == "productname") {
if ($row['qtyinstock'] == '') {
$mod_count_array[$mod_name] = 1;
} else {
$mod_count_array[$mod_name] = $row['qtyinstock'];
}
} else {
if (!isset($mod_count_array[$mod_name])) {
$mod_count_array[$mod_name] = 0;
}
$mod_count_array[$mod_name]++;
}
//Counting the number of values for a type of graph for a particular date
if (!isset($count_by_date[$mod_name][$crtd_date])) {
$count_by_date[$mod_name][$crtd_date] = 0;
}
$count_by_date[$mod_name][$crtd_date] += 1;
}
$mod_by_mod_cnt = count($mod_name_array);
if ($mod_by_mod_cnt != 0) {
$url_string = "";
$mod_cnt_table = "<table border=0 cellspacing=1 cellpadding=3><tr>\r\n\t\t\t\t<th> Status </th>";
//Assigning the Header values to the vtiger_table and giving the dates as graphformat
for ($i = 0; $i < $days; $i++) {
$tdate = $date_array[$i];
$values = Graph_n_table_format($period_type, $tdate);
$graph_format = $values[0];
$table_format = $values[1];
$mod_cnt_table .= "<th>{$table_format}</th>";
}
$mod_cnt_table .= "<th>Total</th></tr>";
//For all type of the array
for ($i = 0; $i < count($mod_name_array); $i++) {
$search_str = $search_str_array[$i];
$mod_name = $mod_name_array[$i];
$id_name = "";
if ($mod_name == "Un Assigned") {
$mod_name = $mod_strings["Un Assigned"];
$search_str = " ";
}
if ($graph_for == "accountid") {
$name_val_table = get_account_name($mod_name);
} else {
$name_val_table = $mod_name;
}
$mod_cnt_table .= "<tr><td>{$name_val_table}</td>";
$mod_cnt_crtd_date = "";
//For all the days
for ($j = 0; $j < $days; $j++) {
$tdate = $date_array[$j];
if (!isset($count_by_date[$mod_name][$tdate])) {
$count_by_date[$mod_name][$tdate] = "0";
}
$cnt_by_date = $count_by_date[$mod_name][$tdate];
$mod_cnt_table .= "<td>{$cnt_by_date} </td>";
if ($i == 0) {
$values = Graph_n_table_format($period_type, $tdate);
$graph_format = $values[0];
$table_format = $values[1];
//passing the created dates to graph
if ($mod_graph_date != "") {
$mod_graph_date = "{$mod_graph_date},{$graph_format}";
} else {
$mod_graph_date = "{$graph_format}";
}
}
//passing the name count by date to graph
if ($mod_cnt_crtd_date != "") {
$mod_cnt_crtd_date .= ",{$cnt_by_date}";
} else {
$mod_cnt_crtd_date = "{$cnt_by_date}";
}
}
$mod_count_val = $mod_count_array[$mod_name];
$tot_mod_cnt = array_sum($count_by_date[$mod_name]);
$mod_cnt_table .= "<td align=center>{$tot_mod_cnt}</td></tr>";
if ($graph_for == "accountid") {
$name_val = get_account_name($mod_name);
if ($name_val != "") {
$mod_name = $name_val;
$search_str = $name_val;
}
}
if ($graph_for == "smownerid") {
$name_val = getOwnerName($mod_name);
if ($name_val != "") {
$mod_name = $name_val;
$search_str = $name_val;
}
}
if ($graph_for == "product_id" || $graph_for == "productid") {
$query = "SELECT productname FROM vtiger_products WHERE productid=?";
$result = $adb->pquery($query, array($mod_name));
$name_val = $adb->query_result($result, 0, "productname");
if ($name_val != "") {
$mod_name = $name_val;
$search_str = $name_val;
}
}
if ($graph_for == "purchaseorderid") {
$query = "SELECT subject FROM vtiger_purchaseorder WHERE purchaseorderid=?";
$result = $adb->pquery($query, array($mod_name));
$name_val = $adb->query_result($result, 0, "subject");
$id_name = $mod_name;
if ($name_val != "") {
$mod_name = $name_val;
$search_str = $name_val;
}
}
if ($graph_for == "quoteid") {
$query = "SELECT subject FROM vtiger_quotes WHERE quoteid=?";
$result = $adb->pquery($query, array($mod_name));
$name_val = $adb->query_result($result, 0, "subject");
$id_name = $mod_name;
if ($name_val != "") {
$mod_name = $name_val;
$search_str = $name_val;
}
}
if ($graph_for == "invoiceid") {
$query = "SELECT subject FROM vtiger_invoice WHERE invoiceid=?";
$result = $adb->pquery($query, array($mod_name));
$name_val = $adb->query_result($result, 0, "subject");
$id_name = $mod_name;
if ($name_val != "") {
$mod_name = $name_val;
$search_str = $name_val;
}
}
if ($graph_for == "campaignid") {
//this will return the list of the names of the campaign``:w for the y-axis
$query = "SELECT campaignname FROM vtiger_campaign WHERE campaignid=?";
$result = $adb->pquery($query, array($mod_name));
$name_val = $adb->query_result($result, 0, "campaignname");
$id_name = $mod_name;
if ($name_val != "") {
$mod_name = $name_val;
$search_str = $name_val;
}
}
if ($graph_for == "parent_id" || $graph_for == "related_to") {
$seType = getSalesEntityType($mod_name);
if ($seType == 'Contacts') {
$query = "SELECT lastname, firstname FROM vtiger_contactdetails\r\n\t\t\t\t\t\t\tWHERE contactid=?";
$result = $adb->pquery($query, array($mod_name));
$name_val = $adb->query_result($result, 0, "lastname");
if ($name_val != "") {
if (getFieldVisibilityPermission('Contacts', $current_user->id, 'firstname') == '0') {
$first_name = $adb->query_result($result, 0, "firstname");
if ($first_name != '') {
$name_val .= " " . $first_name;
}
}
}
} else {
$query = "SELECT accountname FROM vtiger_account WHERE accountid=?";
$result = $adb->pquery($query, array($mod_name));
$name_val = $adb->query_result($result, 0, "accountname");
}
$mod_name = $name_val;
$search_str = $name_val;
}
//Passing name to graph
$mod_name = str_replace(":", ":", $mod_name);
if ($mod_name_val != "") {
$mod_name_val .= "::{$mod_name}";
} else {
$mod_name_val = "{$mod_name}";
}
//Passing count to graph
if ($mod_cnt_val != "") {
$mod_cnt_val .= "::{$mod_count_val}";
} else {
$mod_cnt_val = "{$mod_count_val}";
}
if ($module != "") {
//Check for Ticket Priority
if ($graph_type == "ticketsbypriority") {
$graph_for = "ticketpriorities";
}
//added to get valid url in dashbord for tickets by team
if ($graph_for == "smownerid") {
$searchField = "assigned_user_id";
} elseif ($graph_for == 'category') {
$searchField = 'ticketcategories';
} elseif ($graph_for == 'priority') {
$searchField = 'ticketpriorities';
} elseif ($graph_for == "accountid") {
$searchField = "account_id";
} else {
$searchField = $graph_for;
}
$cvid = getCvIdOfAll($module);
if ($module == "Home") {
$cvid = getCvIdOfAll($mod_name);
$link_val = "index.php?module=" . $mod_name . "&action=ListView&from_homepagedb=true&type=dbrd&query=true&owner=" . $current_user->user_name . "&viewname=" . $cvid;
} else {
if ($module == "Contacts" || $module == "Products" && ($graph_for == "quoteid" || $graph_for == "invoiceid" || $graph_for == "purchaseorderid")) {
$link_val = "index.php?module=" . $module . "&action=ListView&from_dashboard=true&type=dbrd&query=true&" . $searchField . "=" . $id_name . "&viewname=" . $cvid;
} else {
$esc_search_str = urlencode($search_str);
//$esc_search_str = htmlentities($search_str, ENT_QUOTES, $default_charset);
$link_val = "index.php?module=" . $module . "&action=index&from_dashboard=true&search_text=" . $esc_search_str . "&search_field=" . $searchField . "&searchtype=BasicSearch&query=true&type=entchar&operator=e&viewname=" . $cvid;
}
}
//Adding the links to the graph
$link_val = str_replace(':', ':', $link_val);
if ($i == 0) {
$bar_target_val .= $link_val;
} else {
$bar_target_val .= "::" . $link_val;
}
}
//The data as per given date
if ($i == 0) {
$urlstring .= $mod_cnt_crtd_date;
} else {
$urlstring .= "K" . $mod_cnt_crtd_date;
}
if ($i == 0) {
$test_target_val .= $link_val;
} else {
$test_target_val .= "K" . $link_val;
}
}
$mod_cnt_table .= "</tr><tr><td class=\"{$class}\">Total</td>";
//For all Days getting the vtiger_table
for ($k = 0; $k < $days; $k++) {
$tdate = $date_array[$k];
if (!isset($mod_tot_cnt_array[$tdate])) {
$mod_tot_cnt_array[$tdate] = "0";
}
$tot = $mod_tot_cnt_array[$tdate];
if ($period_type != "yday") {
$mod_cnt_table .= "<td>{$tot}</td>";
}
}
if ($graph_for == "productname") {
$cnt_total = array_sum($mod_count_array);
} else {
$cnt_total = array_sum($mod_tot_cnt_array);
}
$mod_cnt_table .= "<td align=\"center\" class=\"{$class}\">{$cnt_total}</td></tr></table>";
$mod_cnt_table .= "</table>";
$title_of_graph = "{$title} : {$cnt_total}";
$bar_target_val = urlencode($bar_target_val);
$test_target_val = urlencode($test_target_val);
$Prod_mod_val = array($mod_name_val, $mod_cnt_val, $title_of_graph, $bar_target_val, $mod_graph_date, $urlstring, $mod_cnt_table, $test_target_val);
return $Prod_mod_val;
} else {
$data = 0;
}
} else {
$data = 0;
return "<h3> The data is not available with the specified time period</h3>";
}
return $data;
}
/**
* this function processes the given result and returns the value :: for now we are getting the values for the
* reference, owner fields, booleans and currency fields; other processing might be added later if required
* @param array $result - the webservices result object
* @param array $descObj - the webservices describe object
* @return array $result - the processes webservices result object
*/
function vttooltip_processResult($result, $descObj)
{
global $current_user;
foreach ($descObj['fields'] as $field) {
$name = $field['name'];
$value = $result[0][$name];
if ($field['type']['name'] == 'reference') {
$name = $field['name'];
if (!empty($value)) {
$result[0][$name] = vtws_getName($value, $current_user);
} else {
$result[0][$name] = '';
}
} elseif ($field['type']['name'] == 'owner') {
list($info, $id) = explode("x", $value);
$result[0][$name] = getOwnerName($id);
} elseif ($field['type']['name'] == 'boolean') {
if ($result[0][$name] == 1) {
$result[0][$name] = "on";
} else {
$result[0][$name] = "off";
}
} elseif ($field['type']['name'] == 'picklist') {
$temp = '';
foreach ($field['type']['picklistValues'] as $value) {
if (strcmp($value['value'], $result[0][$name]) == 0) {
$temp = $value['value'];
}
}
$result[0][$name] = $temp;
} elseif ($field['type']['name'] == 'date') {
$result[0][$name] = DateTimeField::convertToUserFormat($value);
} elseif ($field['type']['name'] == 'datetime') {
$date = new DateTimeField($value);
$result[0][$name] = $date->getDisplayDateTimeValue();
} elseif ($field['type']['name'] == 'time') {
$date = new DateTimeField($value);
$result[0][$name] = $date->getDisplayTime();
} elseif ($field['type']['name'] == 'currency') {
$currencyField = new CurrencyField($value);
$result[0][$name] = $currencyField->getDisplayValueWithSymbol();
}
}
return $result;
}
/** Function to return the duplicate records data as a formatted array */
function getDuplicateRecordsArr($module)
{
global $adb, $app_strings, $list_max_entries_per_page, $theme;
$field_values_array = getFieldValues($module);
$field_values = $field_values_array['fieldnames_list'];
$fld_arr = $field_values_array['fieldnames_array'];
$col_arr = $field_values_array['columnnames_array'];
$fld_labl_arr = $field_values_array['fieldlabels_array'];
$ui_type = $field_values_array['fieldname_uitype'];
$dup_query = getDuplicateQuery($module, $field_values, $ui_type);
// added for page navigation
$dup_count_query = substr($dup_query, stripos($dup_query, 'FROM'), strlen($dup_query));
$dup_count_query = "SELECT count(*) as count " . $dup_count_query;
$count_res = $adb->query($dup_count_query);
$no_of_rows = $adb->query_result($count_res, 0, "count");
if ($no_of_rows <= $list_max_entries_per_page) {
$_SESSION['dup_nav_start' . $module] = 1;
} else {
if (isset($_REQUEST["start"]) && $_REQUEST["start"] != "" && $_SESSION['dup_nav_start' . $module] != $_REQUEST["start"]) {
$_SESSION['dup_nav_start' . $module] = ListViewSession::getRequestStartPage();
}
}
$start = $_SESSION['dup_nav_start' . $module] != "" ? $_SESSION['dup_nav_start' . $module] : 1;
$navigation_array = getNavigationValues($start, $no_of_rows, $list_max_entries_per_page);
$start_rec = $navigation_array['start'];
$end_rec = $navigation_array['end_val'];
$navigationOutput = getTableHeaderNavigation($navigation_array, "", $module, "FindDuplicate", "");
if ($start_rec == 0) {
$limit_start_rec = 0;
} else {
$limit_start_rec = $start_rec - 1;
}
$dup_query .= " LIMIT {$limit_start_rec}, {$list_max_entries_per_page}";
//ends
$nresult = $adb->query($dup_query);
$no_rows = $adb->num_rows($nresult);
require_once 'modules/Vtiger/layout_utils.php';
if ($no_rows == 0) {
if ($_REQUEST['action'] == 'FindDuplicateRecords') {
//echo "<br><br><center>".$app_strings['LBL_NO_DUPLICATE']." <a href='javascript:window.history.back()'>".$app_strings['LBL_GO_BACK'].".</a></center>";
//die;
echo "<link rel='stylesheet' type='text/css' href='themes/{$theme}/style.css'>";
echo "<table border='0' cellpadding='5' cellspacing='0' width='100%' height='450px'><tr><td align='center'>";
echo "<div style='border: 3px solid rgb(153, 153, 153); background-color: rgb(255, 255, 255); width: 55%; position: relative; z-index: 10000000;'>\n\n\t\t\t\t<table border='0' cellpadding='5' cellspacing='0' width='98%'>\n\t\t\t\t<tbody><tr>\n\t\t\t\t<td rowspan='2' width='11%'><img src='" . vtiger_imageurl('empty.jpg', $theme) . "' ></td>\n\t\t\t\t<td style='border-bottom: 1px solid rgb(204, 204, 204);' nowrap='nowrap' width='70%'><span class='genHeaderSmall'>{$app_strings['LBL_NO_DUPLICATE']}</span></td>\n\t\t\t\t</tr>\n\t\t\t\t<tr>\n\t\t\t\t<td class='small' align='right' nowrap='nowrap'>\n\t\t\t\t<a href='javascript:window.history.back();'>{$app_strings['LBL_GO_BACK']}</a><br> </td>\n\t\t\t\t</tr>\n\t\t\t\t</tbody></table>\n\t\t\t\t</div>";
echo "</td></tr></table>";
exit;
} else {
echo "<br><br><table align='center' class='reportCreateBottom big' width='95%'><tr><td align='center'>" . $app_strings['LBL_NO_DUPLICATE'] . "</td></tr></table>";
die;
}
}
$rec_cnt = 0;
$temp = array();
$sl_arr = array();
$grp = "group0";
$gcnt = 0;
$ii = 0;
//ii'th record in group
while ($rec_cnt < $no_rows) {
$result = $adb->fetchByAssoc($nresult);
//echo '<pre>';print_r($result);echo '</pre>';
if ($rec_cnt != 0) {
$sl_arr = array_slice($result, 2);
array_walk($temp, 'lower_array');
array_walk($sl_arr, 'lower_array');
$arr_diff = array_diff($temp, $sl_arr);
if (count($arr_diff) > 0) {
$gcnt++;
$temp = $sl_arr;
$ii = 0;
}
$grp = "group" . $gcnt;
}
$fld_values[$grp][$ii]['recordid'] = $result['recordid'];
for ($k = 0; $k < count($col_arr); $k++) {
if ($rec_cnt == 0) {
$temp[$fld_labl_arr[$k]] = $result[$col_arr[$k]];
}
if ($ui_type[$fld_arr[$k]] == 56) {
if ($result[$col_arr[$k]] == 0) {
$result[$col_arr[$k]] = $app_strings['no'];
} else {
$result[$col_arr[$k]] = $app_strings['yes'];
}
}
if ($ui_type[$fld_arr[$k]] == 75 || $ui_type[$fld_arr[$k]] == 81) {
$vendor_id = $result[$col_arr[$k]];
if ($vendor_id != '') {
$vendor_name = getVendorName($vendor_id);
}
$result[$col_arr[$k]] = $vendor_name;
}
if ($ui_type[$fld_arr[$k]] == 57) {
$contact_id = $result[$col_arr[$k]];
if ($contact_id != '') {
$parent_module = 'Contacts';
$displayValueArray = getEntityName($parent_module, $contact_id);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $field_value) {
$contactname = $field_value;
}
}
}
$result[$col_arr[$k]] = $contactname;
}
if ($ui_type[$fld_arr[$k]] == 15 || $ui_type[$fld_arr[$k]] == 16) {
$result[$col_arr[$k]] = getTranslatedString($result[$col_arr[$k]], $module);
}
if ($ui_type[$fld_arr[$k]] == 33) {
$fieldvalue = explode(' |##| ', $result[$col_arr[$k]]);
$result[$col_arr[$k]] = array();
foreach ($fieldvalue as $picklistValue) {
$result[$col_arr[$k]][] = getTranslatedString($picklistValue, $module);
}
$result[$col_arr[$k]] = implode(', ', $result[$col_arr[$k]]);
}
if ($ui_type[$fld_arr[$k]] == 68) {
$parent_id = $result[$col_arr[$k]];
if ($parent_id != '') {
$parentname = getParentName($parent_id);
}
$result[$col_arr[$k]] = $parentname;
}
if ($ui_type[$fld_arr[$k]] == 53 || $ui_type[$fld_arr[$k]] == 52) {
if ($result[$col_arr[$k]] != '') {
$owner = getOwnerName($result[$col_arr[$k]]);
}
$result[$col_arr[$k]] = $owner;
}
if ($ui_type[$fld_arr[$k]] == 50 or $ui_type[$fld_arr[$k]] == 51) {
if ($module != 'Products') {
$entity_name = getAccountName($result[$col_arr[$k]]);
} else {
$entity_name = getProductName($result[$col_arr[$k]]);
}
if ($entity_name != '') {
$result[$col_arr[$k]] = $entity_name;
} else {
$result[$col_arr[$k]] = '';
}
}
if ($ui_type[$fld_arr[$k]] == 58) {
$campaign_name = getCampaignName($result[$col_arr[$k]]);
if ($campaign_name != '') {
$result[$col_arr[$k]] = $campaign_name;
} else {
$result[$col_arr[$k]] = '';
}
}
if ($ui_type[$fld_arr[$k]] == 59) {
$product_name = getProductName($result[$col_arr[$k]]);
if ($product_name != '') {
$result[$col_arr[$k]] = $product_name;
} else {
$result[$col_arr[$k]] = '';
}
}
/*uitype 10 handling*/
if ($ui_type[$fld_arr[$k]] == 10) {
$result[$col_arr[$k]] = getRecordInfoFromID($result[$col_arr[$k]]);
}
if ($ui_type[$fld_arr[$k]] == 5 || $ui_type[$fld_arr[$k]] == 6 || $ui_type[$fld_arr[$k]] == 23) {
if (${$result}[$col_arr[$k]] != '' && ${$result}[$col_arr[$k]] != '0000-00-00') {
$date = new DateTimeField(${$result}[$col_arr[$k]]);
$value = $date->getDisplayDate();
if (strpos(${$result}[$col_arr[$k]], ' ') > -1) {
$value .= ' ' . $date->getDisplayTime();
}
} elseif (${$result}[$col_arr[$k]] == '0000-00-00') {
$value = '';
} else {
$value = ${$result}[$col_arr[$k]];
}
$result[$col_arr[$k]] = $value;
}
if ($ui_type[$fld_arr[$k]] == 71) {
$result[$col_arr[$k]] = CurrencyField::convertToUserFormat($result[$col_arr[$k]]);
}
if ($ui_type[$fld_arr[$k]] == 72) {
$result[$col_arr[$k]] = CurrencyField::convertToUserFormat($result[$col_arr[$k]], null, true);
}
$fld_values[$grp][$ii][$fld_labl_arr[$k]] = $result[$col_arr[$k]];
}
$fld_values[$grp][$ii]['Entity Type'] = $result['deleted'];
$ii++;
$rec_cnt++;
}
$gro = "group";
for ($i = 0; $i < $no_rows; $i++) {
$ii = 0;
$dis_group[] = $fld_values[$gro . $i][$ii];
$count_group[$i] = count($fld_values[$gro . $i]);
$ii++;
$new_group[] = $dis_group[$i];
}
$fld_nam = $new_group[0];
$ret_arr[0] = $fld_values;
$ret_arr[1] = $fld_nam;
$ret_arr[2] = $ui_type;
$ret_arr["navigation"] = $navigationOutput;
return $ret_arr;
}
/** This function returns the vtiger_field details for a given vtiger_fieldname.
* Param $uitype - UI type of the vtiger_field
* Param $fieldname - Form vtiger_field name
* Param $fieldlabel - Form vtiger_field label name
* Param $maxlength - maximum length of the vtiger_field
* Param $col_fields - array contains the vtiger_fieldname and values
* Param $generatedtype - Field generated type (default is 1)
* Param $module_name - module name
* Return type is an array
*/
function getOutputHtml($uitype, $fieldname, $fieldlabel, $maxlength, $col_fields, $generatedtype, $module_name, $mode = '', $typeofdata = null)
{
global $log, $app_strings, $adb, $default_charset, $theme, $mod_strings, $current_user;
$log->debug("Entering getOutputHtml(" . $uitype . "," . $fieldname . "," . $fieldlabel . "," . $maxlength . "," . print_r($col_fields, true) . "," . $generatedtype . "," . $module_name . ") method ...");
require 'user_privileges/sharing_privileges_' . $current_user->id . '.php';
require 'user_privileges/user_privileges_' . $current_user->id . '.php';
$theme_path = "themes/" . $theme . "/";
$image_path = $theme_path . "images/";
$fieldlabel = from_html($fieldlabel);
$fieldvalue = array();
$final_arr = array();
$value = $col_fields[$fieldname];
$custfld = '';
$ui_type[] = $uitype;
$editview_fldname[] = $fieldname;
// vtlib customization: Related type field
if ($uitype == '10') {
global $adb;
$fldmod_result = $adb->pquery('SELECT relmodule, status FROM vtiger_fieldmodulerel WHERE fieldid=
(SELECT fieldid FROM vtiger_field, vtiger_tab WHERE vtiger_field.tabid=vtiger_tab.tabid AND fieldname=? AND name=? and vtiger_field.presence in (0,2)) order by sequence', array($fieldname, $module_name));
$entityTypes = array();
$parent_id = $value;
for ($index = 0; $index < $adb->num_rows($fldmod_result); ++$index) {
$entityTypes[] = $adb->query_result($fldmod_result, $index, 'relmodule');
}
if (!empty($value)) {
if ($adb->num_rows($fldmod_result) == 1) {
$valueType = $adb->query_result($fldmod_result, 0, 0);
} else {
$valueType = getSalesEntityType($value);
}
$displayValueArray = getEntityName($valueType, $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $value) {
$displayValue = $value;
}
}
} else {
$displayValue = '';
$valueType = '';
$value = '';
}
$editview_label[] = array('options' => $entityTypes, 'selected' => $valueType, 'displaylabel' => getTranslatedString($fieldlabel, $module_name));
$fieldvalue[] = array('displayvalue' => $displayValue, 'entityid' => $parent_id);
} else {
if ($uitype == 5 || $uitype == 6 || $uitype == 23) {
$log->info("uitype is " . $uitype);
if ($value == '') {
//modified to fix the issue in trac(http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/1469)
if ($fieldname != 'birthday' && $generatedtype != 2 && getTabid($module_name) != 14) {
$disp_value = getNewDisplayDate();
}
if (($module_name == 'Events' || $module_name == 'Calendar') && $uitype == 6) {
$curr_time = date('H:i', strtotime('+5 minutes'));
}
if (($module_name == 'Events' || $module_name == 'Calendar') && $uitype == 23) {
$curr_time = date('H:i', strtotime('+10 minutes'));
}
//Added to display the Contact - Support End Date as one year future instead of
//today's date -- 30-11-2005
if ($fieldname == 'support_end_date' && $_REQUEST['module'] == 'Contacts') {
$addyear = strtotime("+1 year");
$disp_value = DateTimeField::convertToUserFormat(date('Y-m-d', $addyear));
} elseif ($fieldname == 'validtill' && $_REQUEST['module'] == 'Quotes') {
$disp_value = '';
}
} else {
if ($uitype == 6) {
if ($col_fields['time_start'] != '' && ($module_name == 'Events' || $module_name == 'Calendar')) {
$curr_time = $col_fields['time_start'];
$value = $value . ' ' . $curr_time;
} else {
$curr_time = date('H:i', strtotime('+5 minutes'));
}
}
if (($module_name == 'Events' || $module_name == 'Calendar') && $uitype == 23) {
if ($col_fields['time_end'] != '') {
$curr_time = $col_fields['time_end'];
$value = $value . ' ' . $curr_time;
} else {
$curr_time = date('H:i', strtotime('+10 minutes'));
}
}
$disp_value = getValidDisplayDate($value);
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$date_format = parse_calendardate($app_strings['NTC_DATE_FORMAT']);
if (!empty($curr_time)) {
if (($module_name == 'Events' || $module_name == 'Calendar') && ($uitype == 23 || $uitype == 6)) {
$curr_time = DateTimeField::convertToUserTimeZone($curr_time);
$curr_time = $curr_time->format('H:i');
}
} else {
$curr_time = '';
}
if (empty($disp_value)) {
$disp_value = '';
}
$fieldvalue[] = array($disp_value => $curr_time);
if ($uitype == 5 || $uitype == 23) {
if ($module_name == 'Events' && $uitype == 23) {
$fieldvalue[] = array($date_format => $current_user->date_format . ' ' . $app_strings['YEAR_MONTH_DATE']);
} else {
$fieldvalue[] = array($date_format => $current_user->date_format);
}
} else {
$fieldvalue[] = array($date_format => $current_user->date_format . ' ' . $app_strings['YEAR_MONTH_DATE']);
}
} elseif ($uitype == 16) {
require_once 'modules/PickList/PickListUtils.php';
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldname = $adb->sql_escape_string($fieldname);
$pick_query = "select {$fieldname} from vtiger_{$fieldname} order by sortorderid";
$params = array();
$pickListResult = $adb->pquery($pick_query, $params);
$noofpickrows = $adb->num_rows($pickListResult);
$options = array();
$pickcount = 0;
$found = false;
for ($j = 0; $j < $noofpickrows; $j++) {
$value = decode_html($value);
$pickListValue = decode_html($adb->query_result($pickListResult, $j, strtolower($fieldname)));
if ($value == trim($pickListValue)) {
$chk_val = "selected";
$pickcount++;
$found = true;
} else {
$chk_val = '';
}
$pickListValue = to_html($pickListValue);
if (isset($_REQUEST['file']) && $_REQUEST['file'] == 'QuickCreate') {
$options[] = array(htmlentities(getTranslatedString($pickListValue), ENT_QUOTES, $default_charset), $pickListValue, $chk_val);
} else {
$options[] = array(getTranslatedString($pickListValue), $pickListValue, $chk_val);
}
}
$fieldvalue[] = $options;
} elseif ($uitype == 1613) {
require_once 'modules/PickList/PickListUtils.php';
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldname = $adb->sql_escape_string($fieldname);
$pickListResult = getAllowedPicklistModules();
$options = array();
$options[] = "";
$pickcount = 0;
$found = false;
foreach ($pickListResult as $pKey => $pValue) {
$value = decode_html($value);
$pickListValue = decode_html($pValue);
if ($value == trim($pickListValue)) {
$chk_val = "selected";
$pickcount++;
$found = true;
} else {
$chk_val = '';
}
$pickListValue = to_html($pickListValue);
if (isset($_REQUEST['file']) && $_REQUEST['file'] == 'QuickCreate') {
$options[] = array(htmlentities(getTranslatedString($pickListValue, $pickListValue), ENT_QUOTES, $default_charset), $pickListValue, $chk_val);
} else {
$options[] = array(getTranslatedString($pickListValue, $pickListValue), $pickListValue, $chk_val);
}
}
uasort($options, function ($a, $b) {
return strtolower($a[0]) < strtolower($b[0]) ? -1 : 1;
});
$fieldvalue[] = $options;
} elseif ($uitype == 15 || $uitype == 33) {
require_once 'modules/PickList/PickListUtils.php';
$roleid = $current_user->roleid;
$picklistValues = getAssignedPicklistValues($fieldname, $roleid, $adb);
$valueArr = explode("|##|", $value);
foreach ($valueArr as $key => $value) {
$valueArr[$key] = trim(html_entity_decode($value, ENT_QUOTES, $default_charset));
}
$pickcount = 0;
if (!empty($picklistValues)) {
foreach ($picklistValues as $order => $pickListValue) {
if (in_array(trim($pickListValue), $valueArr)) {
$chk_val = "selected";
$pickcount++;
} else {
$chk_val = '';
}
if (isset($_REQUEST['file']) && $_REQUEST['file'] == 'QuickCreate') {
$options[] = array(htmlentities(getTranslatedString($pickListValue), ENT_QUOTES, $default_charset), $pickListValue, $chk_val);
} else {
$options[] = array(getTranslatedString($pickListValue), $pickListValue, $chk_val);
}
}
if ($pickcount == 0 && !empty($value)) {
$options[] = array($app_strings['LBL_NOT_ACCESSIBLE'], $value, 'selected');
}
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $options;
} elseif ($uitype == 3313) {
require_once 'modules/PickList/PickListUtils.php';
$picklistValues = getAllowedPicklistModules();
$valueArr = explode("|##|", $value);
foreach ($valueArr as $key => $value) {
$valueArr[$key] = trim(html_entity_decode($value, ENT_QUOTES, $default_charset));
}
$pickcount = 0;
if (!empty($picklistValues)) {
foreach ($picklistValues as $order => $pickListValue) {
if (in_array(trim($pickListValue), $valueArr)) {
$chk_val = "selected";
$pickcount++;
} else {
$chk_val = '';
}
if (isset($_REQUEST['file']) && $_REQUEST['file'] == 'QuickCreate') {
$options[] = array(htmlentities(getTranslatedString($pickListValue, $pickListValue), ENT_QUOTES, $default_charset), $pickListValue, $chk_val);
} else {
$options[] = array(getTranslatedString($pickListValue, $pickListValue), $pickListValue, $chk_val);
}
}
if ($pickcount == 0 && !empty($value)) {
$options[] = array($app_strings['LBL_NOT_ACCESSIBLE'], $value, 'selected');
}
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
uasort($options, function ($a, $b) {
return strtolower($a[0]) < strtolower($b[0]) ? -1 : 1;
});
$fieldvalue[] = $options;
} elseif ($uitype == 1024) {
$options = array();
$arr_evo = explode(' |##| ', $value);
$roleid = $current_user->roleid;
$subrole = getRoleSubordinates($roleid);
$uservalues = array_merge($subrole, array($roleid));
for ($i = 0; $i < sizeof($uservalues); $i++) {
$currentValId = $uservalues[$i];
$currentValName = getRoleName($currentValId);
if (in_array(trim($currentValId), $arr_evo)) {
$chk_val = 'selected';
} else {
$chk_val = '';
}
$options[] = array($currentValName, $currentValId, $chk_val);
}
$fieldvalue[] = $options;
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
} elseif ($uitype == 17) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $value;
} elseif ($uitype == 85) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $value;
} elseif ($uitype == 14) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $value;
} elseif ($uitype == 19 || $uitype == 20) {
if (isset($_REQUEST['body'])) {
$value = $_REQUEST['body'];
}
if ($fieldname == 'terms_conditions') {
//Assign the value from focus->column_fields (if we create Invoice from SO the SO's terms and conditions will be loaded to Invoice's terms and conditions, etc.,)
$value = $col_fields['terms_conditions'];
//if the value is empty then only we should get the default Terms and Conditions
if ($value == '' && $mode != 'edit') {
$value = getTermsandConditions();
}
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $value;
} elseif ($uitype == 21 || $uitype == 24) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $value;
} elseif ($uitype == 22) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $value;
} elseif ($uitype == 52 || $uitype == 77) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
global $current_user;
if ($value != '') {
$assigned_user_id = $value;
} else {
$assigned_user_id = $current_user->id;
}
if ($uitype == 52) {
$combo_lbl_name = 'assigned_user_id';
} elseif ($uitype == 77) {
$combo_lbl_name = 'assigned_user_id1';
}
//Control will come here only for Products - Handler and Quotes - Inventory Manager
if ($is_admin == false && $profileGlobalPermission[2] == 1 && ($defaultOrgSharingPermission[getTabid($module_name)] == 3 or $defaultOrgSharingPermission[getTabid($module_name)] == 0)) {
$users_combo = get_select_options_array(get_user_array(FALSE, "Active", $assigned_user_id, 'private'), $assigned_user_id);
} else {
$users_combo = get_select_options_array(get_user_array(FALSE, "Active", $assigned_user_id), $assigned_user_id);
}
$fieldvalue[] = $users_combo;
} elseif ($uitype == 53) {
global $noof_group_rows;
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
//Security Checks
if ($fieldname == 'assigned_user_id' && $is_admin == false && $profileGlobalPermission[2] == 1 && ($defaultOrgSharingPermission[getTabid($module_name)] == 3 or $defaultOrgSharingPermission[getTabid($module_name)] == 0)) {
$result = get_current_user_access_groups($module_name);
} else {
$result = get_group_options();
}
if ($result) {
$nameArray = $adb->fetch_array($result);
}
$assigned_user_id = empty($value) ? $current_user->id : $value;
if ($fieldname == 'assigned_user_id' && $is_admin == false && $profileGlobalPermission[2] == 1 && ($defaultOrgSharingPermission[getTabid($module_name)] == 3 or $defaultOrgSharingPermission[getTabid($module_name)] == 0)) {
$users_combo = get_select_options_array(get_user_array(FALSE, "Active", $assigned_user_id, 'private'), $assigned_user_id);
} else {
$users_combo = get_select_options_array(get_user_array(FALSE, "Active", $assigned_user_id), $assigned_user_id);
}
if ($noof_group_rows != 0) {
if ($fieldname == 'assigned_user_id' && $is_admin == false && $profileGlobalPermission[2] == 1 && ($defaultOrgSharingPermission[getTabid($module_name)] == 3 or $defaultOrgSharingPermission[getTabid($module_name)] == 0)) {
$groups_combo = get_select_options_array(get_group_array(FALSE, "Active", $assigned_user_id, 'private'), $assigned_user_id);
} else {
$groups_combo = get_select_options_array(get_group_array(FALSE, "Active", $assigned_user_id), $assigned_user_id);
}
}
$fieldvalue[] = $users_combo;
$fieldvalue[] = $groups_combo;
} elseif ($uitype == 51 || $uitype == 50 || $uitype == 73) {
if (!isset($_REQUEST['convertmode']) || $_REQUEST['convertmode'] != 'update_quote_val' && $_REQUEST['convertmode'] != 'update_so_val') {
if (isset($_REQUEST['account_id']) && $_REQUEST['account_id'] != '') {
$value = vtlib_purify($_REQUEST['account_id']);
}
}
if ($value != '') {
$account_name = getAccountName($value);
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $account_name;
$fieldvalue[] = $value;
} elseif ($uitype == 54) {
$options = array();
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$pick_query = "select * from vtiger_groups";
$pickListResult = $adb->pquery($pick_query, array());
$noofpickrows = $adb->num_rows($pickListResult);
for ($j = 0; $j < $noofpickrows; $j++) {
$pickListValue = $adb->query_result($pickListResult, $j, "name");
if ($value == $pickListValue) {
$chk_val = "selected";
} else {
$chk_val = '';
}
$options[] = array($pickListValue => $chk_val);
}
$fieldvalue[] = $options;
} elseif ($uitype == 55 || $uitype == 255) {
require_once 'modules/PickList/PickListUtils.php';
if ($uitype == 255) {
$fieldpermission = getFieldVisibilityPermission($module_name, $current_user->id, 'firstname', 'readwrite');
}
if ($uitype == 255 && $fieldpermission == '0') {
$fieldvalue[] = '';
} else {
$fieldpermission = getFieldVisibilityPermission($module_name, $current_user->id, 'salutationtype', 'readwrite');
if ($fieldpermission == '0') {
$roleid = $current_user->roleid;
$picklistValues = getAssignedPicklistValues('salutationtype', $roleid, $adb);
$pickcount = 0;
$salt_value = $col_fields["salutationtype"];
foreach ($picklistValues as $order => $pickListValue) {
if ($salt_value == trim($pickListValue)) {
$chk_val = "selected";
$pickcount++;
} else {
$chk_val = '';
}
if (isset($_REQUEST['file']) && $_REQUEST['file'] == 'QuickCreate') {
$options[] = array(htmlentities(getTranslatedString($pickListValue), ENT_QUOTES, $default_charset), $pickListValue, $chk_val);
} else {
$options[] = array(getTranslatedString($pickListValue), $pickListValue, $chk_val);
}
}
if ($pickcount == 0 && $salt_value != '') {
$options[] = array($app_strings['LBL_NOT_ACCESSIBLE'], $salt_value, 'selected');
}
$fieldvalue[] = $options;
} else {
$fieldvalue[] = '';
}
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $value;
} elseif ($uitype == 59) {
if ($_REQUEST['module'] == 'HelpDesk') {
if (isset($_REQUEST['product_id']) & $_REQUEST['product_id'] != '') {
$value = $_REQUEST['product_id'];
}
} elseif (isset($_REQUEST['parent_id']) & $_REQUEST['parent_id'] != '') {
$value = vtlib_purify($_REQUEST['parent_id']);
}
if ($value != '') {
$product_name = getProductName($value);
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $product_name;
$fieldvalue[] = $value;
} elseif ($uitype == 63) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
if ($value == '') {
$value = 1;
}
$options = array();
$pick_query = "select * from vtiger_duration_minutes order by sortorderid";
$pickListResult = $adb->pquery($pick_query, array());
$noofpickrows = $adb->num_rows($pickListResult);
$salt_value = $col_fields["duration_minutes"];
for ($j = 0; $j < $noofpickrows; $j++) {
$pickListValue = $adb->query_result($pickListResult, $j, "duration_minutes");
if ($salt_value == $pickListValue) {
$chk_val = "selected";
} else {
$chk_val = '';
}
$options[$pickListValue] = $chk_val;
}
$fieldvalue[] = $value;
$fieldvalue[] = $options;
} elseif ($uitype == 64) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$date_format = parse_calendardate($app_strings['NTC_DATE_FORMAT']);
$fieldvalue[] = $value;
} elseif ($uitype == 156) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $value;
$fieldvalue[] = $is_admin;
} elseif ($uitype == 56) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $value;
} elseif ($uitype == 57) {
if ($value != '') {
$displayValueArray = getEntityName('Contacts', $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $field_value) {
$contact_name = $field_value;
}
}
} elseif (isset($_REQUEST['contact_id']) && $_REQUEST['contact_id'] != '') {
if ($_REQUEST['module'] == 'Contacts' && ($fieldname = 'contact_id')) {
$contact_name = '';
} else {
$value = $_REQUEST['contact_id'];
$displayValueArray = getEntityName('Contacts', $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $field_value) {
$contact_name = $field_value;
}
} else {
$contact_name = '';
}
}
}
//Checking for contacts duplicate
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $contact_name;
$fieldvalue[] = $value;
} elseif ($uitype == 58) {
if ($value != '') {
$campaign_name = getCampaignName($value);
} elseif (isset($_REQUEST['campaignid']) && $_REQUEST['campaignid'] != '') {
if ($_REQUEST['module'] == 'Campaigns' && ($fieldname = 'campaignid')) {
$campaign_name = '';
} else {
$value = $_REQUEST['campaignid'];
$campaign_name = getCampaignName($value);
}
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $campaign_name;
$fieldvalue[] = $value;
} elseif ($uitype == 61) {
if ($value != '') {
$assigned_user_id = $value;
} else {
$assigned_user_id = $current_user->id;
}
if ($module_name == 'Emails' && $col_fields['record_id'] != '') {
$attach_result = $adb->pquery("select * from vtiger_seattachmentsrel where crmid = ?", array($col_fields['record_id']));
//to fix the issue in mail attachment on forwarding mails
if (isset($_REQUEST['forward']) && $_REQUEST['forward'] != '') {
global $att_id_list;
}
for ($ii = 0; $ii < $adb->num_rows($attach_result); $ii++) {
$attachmentid = $adb->query_result($attach_result, $ii, 'attachmentsid');
if ($attachmentid != '') {
$attachquery = "select * from vtiger_attachments where attachmentsid=?";
$attachmentsname = $adb->query_result($adb->pquery($attachquery, array($attachmentid)), 0, 'name');
if ($attachmentsname != '') {
$fieldvalue[$attachmentid] = '[ ' . $attachmentsname . ' ]';
}
if (isset($_REQUEST['forward']) && $_REQUEST['forward'] != '') {
$att_id_list .= $attachmentid . ';';
}
}
}
} else {
if ($col_fields['record_id'] != '') {
$attachmentid = $adb->query_result($adb->pquery("select * from vtiger_seattachmentsrel where crmid = ?", array($col_fields['record_id'])), 0, 'attachmentsid');
if ($col_fields[$fieldname] == '' && $attachmentid != '') {
$attachquery = "select * from vtiger_attachments where attachmentsid=?";
$value = $adb->query_result($adb->pquery($attachquery, array($attachmentid)), 0, 'name');
}
}
if ($value != '') {
$filename = ' [ ' . $value . ' ]';
}
if ($filename != '') {
$fieldvalue[] = $filename;
}
if ($value != '') {
$fieldvalue[] = $value;
}
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
} elseif ($uitype == 28) {
if ($col_fields['record_id'] != '') {
$attachmentid = $adb->query_result($adb->pquery("select * from vtiger_seattachmentsrel where crmid = ?", array($col_fields['record_id'])), 0, 'attachmentsid');
if ($col_fields[$fieldname] == '' && $attachmentid != '') {
$attachquery = "select * from vtiger_attachments where attachmentsid=?";
$value = $adb->query_result($adb->pquery($attachquery, array($attachmentid)), 0, 'name');
}
}
if ($value != '' && $module_name != 'Documents') {
$filename = ' [ ' . $value . ' ]';
} elseif ($value != '' && $module_name == 'Documents') {
$filename = $value;
}
if ($filename != '') {
$fieldvalue[] = $filename;
}
if ($value != '') {
$fieldvalue[] = $value;
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
} elseif ($uitype == 69) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
if ($col_fields['record_id'] != "") {
if ($module_name == 'Products') {
$query = 'select vtiger_attachments.path, vtiger_attachments.attachmentsid, vtiger_attachments.name ,vtiger_crmentity.setype from vtiger_products left join vtiger_seattachmentsrel on vtiger_seattachmentsrel.crmid=vtiger_products.productid inner join vtiger_attachments on vtiger_attachments.attachmentsid=vtiger_seattachmentsrel.attachmentsid inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_attachments.attachmentsid where vtiger_crmentity.setype="Products Image" and productid=?';
$params = array($col_fields['record_id']);
} else {
if ($module_name == 'Contacts') {
$imageattachment = 'Image';
} else {
$imageattachment = 'Attachment';
}
$query = "select vtiger_attachments.*,vtiger_crmentity.setype\n\t\t\t\t from vtiger_attachments\n\t\t\t\t inner join vtiger_seattachmentsrel on vtiger_seattachmentsrel.attachmentsid = vtiger_attachments.attachmentsid\n\t\t\t\t inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_attachments.attachmentsid\n\t\t\t\t where vtiger_crmentity.setype='{$module_name} {$imageattachment}'\n\t\t\t\t and vtiger_attachments.name = ?\n\t\t\t\t and vtiger_seattachmentsrel.crmid=?";
$params = array($col_fields[$fieldname], $col_fields['record_id']);
}
$result_image = $adb->pquery($query, $params);
for ($image_iter = 0; $image_iter < $adb->num_rows($result_image); $image_iter++) {
$image_id_array[] = $adb->query_result($result_image, $image_iter, 'attachmentsid');
//decode_html - added to handle UTF-8 characters in file names
//urlencode - added to handle special characters like #, %, etc.,
$image_array[] = urlencode(decode_html($adb->query_result($result_image, $image_iter, 'name')));
$image_orgname_array[] = decode_html($adb->query_result($result_image, $image_iter, 'name'));
$image_path_array[] = $adb->query_result($result_image, $image_iter, 'path');
}
if (is_array($image_array)) {
for ($img_itr = 0; $img_itr < count($image_array); $img_itr++) {
$fieldvalue[] = array('name' => $image_array[$img_itr], 'path' => $image_path_array[$img_itr] . $image_id_array[$img_itr] . "_", "orgname" => $image_orgname_array[$img_itr]);
}
} else {
$fieldvalue[] = '';
}
} else {
$fieldvalue[] = '';
}
} elseif ($uitype == 62) {
if (isset($_REQUEST['parent_id']) && $_REQUEST['parent_id'] != '') {
$value = vtlib_purify($_REQUEST['parent_id']);
}
if ($value != '') {
$parent_module = getSalesEntityType($value);
}
if (isset($_REQUEST['account_id']) && $_REQUEST['account_id'] != '') {
$parent_module = "Accounts";
$value = $_REQUEST['account_id'];
}
if ($parent_module != 'Contacts') {
if ($parent_module == "Leads") {
$displayValueArray = getEntityName($parent_module, $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $field_value) {
$parent_name = $field_value;
}
}
$lead_selected = "selected";
} elseif ($parent_module == "Accounts") {
$sql = "select * from vtiger_account where accountid=?";
$result = $adb->pquery($sql, array($value));
$parent_name = $adb->query_result($result, 0, "accountname");
$account_selected = "selected";
} elseif ($parent_module == "Potentials") {
$sql = "select * from vtiger_potential where potentialid=?";
$result = $adb->pquery($sql, array($value));
$parent_name = $adb->query_result($result, 0, "potentialname");
$potential_selected = "selected";
} elseif ($parent_module == "Products") {
$sql = "select * from vtiger_products where productid=?";
$result = $adb->pquery($sql, array($value));
$parent_name = $adb->query_result($result, 0, "productname");
$product_selected = "selected";
} elseif ($parent_module == "PurchaseOrder") {
$sql = "select * from vtiger_purchaseorder where purchaseorderid=?";
$result = $adb->pquery($sql, array($value));
$parent_name = $adb->query_result($result, 0, "subject");
$porder_selected = "selected";
} elseif ($parent_module == "SalesOrder") {
$sql = "select * from vtiger_salesorder where salesorderid=?";
$result = $adb->pquery($sql, array($value));
$parent_name = $adb->query_result($result, 0, "subject");
$sorder_selected = "selected";
} elseif ($parent_module == "Invoice") {
$sql = "select * from vtiger_invoice where invoiceid=?";
$result = $adb->pquery($sql, array($value));
$parent_name = $adb->query_result($result, 0, "subject");
$invoice_selected = "selected";
} elseif ($parent_module == "Quotes") {
$sql = "select * from vtiger_quotes where quoteid=?";
$result = $adb->pquery($sql, array($value));
$parent_name = $adb->query_result($result, 0, "subject");
$quote_selected = "selected";
} elseif ($parent_module == "HelpDesk") {
$sql = "select * from vtiger_troubletickets where ticketid=?";
$result = $adb->pquery($sql, array($value));
$parent_name = $adb->query_result($result, 0, "title");
$ticket_selected = "selected";
}
}
$editview_label[] = array($app_strings['COMBO_LEADS'], $app_strings['COMBO_ACCOUNTS'], $app_strings['COMBO_POTENTIALS'], $app_strings['COMBO_PRODUCTS'], $app_strings['COMBO_INVOICES'], $app_strings['COMBO_PORDER'], $app_strings['COMBO_SORDER'], $app_strings['COMBO_QUOTES'], $app_strings['COMBO_HELPDESK']);
$editview_label[] = array($lead_selected, $account_selected, $potential_selected, $product_selected, $invoice_selected, $porder_selected, $sorder_selected, $quote_selected, $ticket_selected);
$editview_label[] = array("Leads&action=Popup", "Accounts&action=Popup", "Potentials&action=Popup", "Products&action=Popup", "Invoice&action=Popup", "PurchaseOrder&action=Popup", "SalesOrder&action=Popup", "Quotes&action=Popup", "HelpDesk&action=Popup");
$fieldvalue[] = $parent_name;
$fieldvalue[] = $value;
} elseif ($uitype == 66) {
if (!empty($_REQUEST['parent_id'])) {
$value = vtlib_purify($_REQUEST['parent_id']);
}
if (!empty($value)) {
$parent_module = getSalesEntityType($value);
if ($parent_module != "Contacts") {
$entity_names = getEntityName($parent_module, $value);
$parent_name = $entity_names[$value];
$fieldvalue[] = $parent_name;
$fieldvalue[] = $value;
}
}
// Check for vtiger_activity type if task orders to be added in select option
$act_mode = $_REQUEST['activity_mode'];
$parentModulesList = array('Leads' => $app_strings['COMBO_LEADS'], 'Accounts' => $app_strings['COMBO_ACCOUNTS'], 'Potentials' => $app_strings['COMBO_POTENTIALS'], 'HelpDesk' => $app_strings['COMBO_HELPDESK'], 'Campaigns' => $app_strings['COMBO_CAMPAIGNS'], 'Vendors' => $app_strings['COMBO_VENDORS']);
if ($act_mode == "Task") {
$parentModulesList['Quotes'] = $app_strings['COMBO_QUOTES'];
$parentModulesList['PurchaseOrder'] = $app_strings['COMBO_PORDER'];
$parentModulesList['SalesOrder'] = $app_strings['COMBO_SORDER'];
$parentModulesList['Invoice'] = $app_strings['COMBO_INVOICES'];
}
$parentModuleNames = array_keys($parentModulesList);
$parentModuleLabels = array_values($parentModulesList);
$editview_label[0] = $parentModuleLabels;
$editview_label[1] = array_fill(0, count($parentModulesList), '');
$selectedModuleIndex = array_search($parent_module, $parentModuleNames);
if ($selectedModuleIndex > -1) {
$editview_label[1][$selectedModuleIndex] = 'selected';
}
$parentModulePopupUrl = array();
foreach ($parentModuleNames as $parentModule) {
$parentModulePopupUrl[] = $parentModule . '&action=Popup';
}
$editview_label[2] = $parentModulePopupUrl;
} elseif ($uitype == 357) {
$pmodule = $_REQUEST['pmodule'];
if (empty($pmodule)) {
$pmodule = $_REQUEST['par_module'];
}
if ($pmodule == 'Contacts') {
$contact_selected = 'selected';
} elseif ($pmodule == 'Accounts') {
$account_selected = 'selected';
} elseif ($pmodule == 'Leads') {
$lead_selected = 'selected';
} elseif ($pmodule == 'Vendors') {
$vendor_selected = 'selected';
} elseif ($pmodule == 'Users') {
$user_selected = 'selected';
} elseif ($pmodule == 'Project') {
$project_selected = 'selected';
} elseif ($pmodule == 'ProjectTask') {
$projecttask_selected = 'selected';
} elseif ($pmodule == 'Potentials') {
$potentials_selected = 'selected';
} elseif ($pmodule == 'HelpDesk') {
$helpdesk_selected = 'selected';
}
if (isset($_REQUEST['emailids']) && $_REQUEST['emailids'] != '') {
$parent_id = $_REQUEST['emailids'];
$parent_name = '';
$myids = explode("|", $parent_id);
for ($i = 0; $i < count($myids) - 1; $i++) {
$realid = explode("@", $myids[$i]);
$entityid = $realid[0];
$nemail = count($realid);
if ($pmodule == 'Accounts') {
require_once 'modules/Accounts/Accounts.php';
$myfocus = new Accounts();
$myfocus->retrieve_entity_info($entityid, "Accounts");
$fullname = br2nl($myfocus->column_fields['accountname']);
$account_selected = 'selected';
} elseif ($pmodule == 'Contacts') {
require_once 'modules/Contacts/Contacts.php';
$myfocus = new Contacts();
$myfocus->retrieve_entity_info($entityid, "Contacts");
$fname = br2nl($myfocus->column_fields['firstname']);
$lname = br2nl($myfocus->column_fields['lastname']);
$fullname = $lname . ' ' . $fname;
$contact_selected = 'selected';
} elseif ($pmodule == 'Leads') {
require_once 'modules/Leads/Leads.php';
$myfocus = new Leads();
$myfocus->retrieve_entity_info($entityid, "Leads");
$fname = br2nl($myfocus->column_fields['firstname']);
$lname = br2nl($myfocus->column_fields['lastname']);
$fullname = $lname . ' ' . $fname;
$lead_selected = 'selected';
} elseif ($pmodule == 'Project') {
require_once 'modules/Project/Project.php';
$myfocus = new Project();
$myfocus->retrieve_entity_info($entityid, "Project");
$fname = br2nl($myfocus->column_fields['projectname']);
$lname = br2nl($myfocus->column_fields['projectid']);
$fullname = $fname;
$project_selected = 'selected';
} elseif ($pmodule == 'ProjectTask') {
require_once 'modules/ProjectTask/ProjectTask.php';
$myfocus = new ProjectTask();
$myfocus->retrieve_entity_info($entityid, "ProjectTask");
$fname = br2nl($myfocus->column_fields['projecttaskname']);
$lname = br2nl($myfocus->column_fields['projecttaskid']);
$fullname = $fname;
$projecttask_selected = 'selected';
} elseif ($pmodule == 'Potentials') {
require_once 'modules/Potentials/Potentials.php';
$myfocus = new Potentials();
$myfocus->retrieve_entity_info($entityid, "Potentials");
$fname = br2nl($myfocus->column_fields['potentialname']);
$lname = br2nl($myfocus->column_fields['potentialid']);
$fullname = $fname;
$potentials_selected = 'selected';
} elseif ($pmodule == 'HelpDesk') {
require_once 'modules/HelpDesk/HelpDesk.php';
$myfocus = new HelpDesk();
$myfocus->retrieve_entity_info($entityid, "HelpDesk");
$fname = br2nl($myfocus->column_fields['title']);
$lname = br2nl($myfocus->column_fields['ticketid']);
$fullname = $fname;
$helpdesk_selected = 'selected';
}
for ($j = 1; $j < $nemail; $j++) {
$querystr = 'select columnname from vtiger_field where fieldid=? and vtiger_field.presence in (0,2)';
$result = $adb->pquery($querystr, array($realid[$j]));
$temp = $adb->query_result($result, 0, 'columnname');
$temp1 = br2nl($myfocus->column_fields[$temp]);
//Modified to display the entities in red which don't have email id
if (!empty($temp_parent_name) && strlen($temp_parent_name) > 150) {
$parent_name .= '<br>';
$temp_parent_name = '';
}
if ($temp1 != '') {
$parent_name .= $fullname . '<' . $temp1 . '>; ';
$temp_parent_name .= $fullname . '<' . $temp1 . '>; ';
} else {
$parent_name .= "<b style='color:red'>" . $fullname . '<' . $temp1 . '>; ' . "</b>";
$temp_parent_name .= "<b style='color:red'>" . $fullname . '<' . $temp1 . '>; ' . "</b>";
}
}
}
} else {
if ($_REQUEST['record'] != '' && $_REQUEST['record'] != NULL) {
$parent_name = '';
$parent_id = '';
$myemailid = $_REQUEST['record'];
$mysql = "select crmid from vtiger_seactivityrel where activityid=?";
$myresult = $adb->pquery($mysql, array($myemailid));
$mycount = $adb->num_rows($myresult);
if ($mycount > 0) {
for ($i = 0; $i < $mycount; $i++) {
$mycrmid = $adb->query_result($myresult, $i, 'crmid');
$parent_module = getSalesEntityType($mycrmid);
if ($parent_module == "Leads") {
$sql = "select firstname,lastname,email from vtiger_leaddetails where leadid=?";
$result = $adb->pquery($sql, array($mycrmid));
$full_name = getFullNameFromQResult($result, 0, "Leads");
$myemail = $adb->query_result($result, 0, "email");
$parent_id .= $mycrmid . '@0|';
//make it such that the email adress sent is remebered and only that one is retrived
$parent_name .= $full_name . '<' . $myemail . '>; ';
$lead_selected = 'selected';
} elseif ($parent_module == "Contacts") {
$sql = "select * from vtiger_contactdetails where contactid=?";
$result = $adb->pquery($sql, array($mycrmid));
$full_name = getFullNameFromQResult($result, 0, "Contacts");
$myemail = $adb->query_result($result, 0, "email");
$parent_id .= $mycrmid . '@0|';
//make it such that the email adress sent is remebered and only that one is retrived
$parent_name .= $full_name . '<' . $myemail . '>; ';
$contact_selected = 'selected';
} elseif ($parent_module == "Accounts") {
$sql = "select * from vtiger_account where accountid=?";
$result = $adb->pquery($sql, array($mycrmid));
$account_name = $adb->query_result($result, 0, "accountname");
$myemail = $adb->query_result($result, 0, "email1");
$parent_id .= $mycrmid . '@0|';
//make it such that the email adress sent is remebered and only that one is retrived
$parent_name .= $account_name . '<' . $myemail . '>; ';
$account_selected = 'selected';
} elseif ($parent_module == "Users") {
$sql = "select user_name,email1 from vtiger_users where id=?";
$result = $adb->pquery($sql, array($mycrmid));
$account_name = $adb->query_result($result, 0, "user_name");
$myemail = $adb->query_result($result, 0, "email1");
$parent_id .= $mycrmid . '@0|';
//make it such that the email adress sent is remebered and only that one is retrived
$parent_name .= $account_name . '<' . $myemail . '>; ';
$user_selected = 'selected';
} elseif ($parent_module == "Vendors") {
$sql = "select * from vtiger_vendor where vendorid=?";
$result = $adb->pquery($sql, array($mycrmid));
$vendor_name = $adb->query_result($result, 0, "vendorname");
$myemail = $adb->query_result($result, 0, "email");
$parent_id .= $mycrmid . '@0|';
//make it such that the email adress sent is remebered and only that one is retrived
$parent_name .= $vendor_name . '<' . $myemail . '>; ';
$vendor_selected = 'selected';
}
}
}
}
$custfld .= '<td width="20%" class="dataLabel">' . $app_strings['To'] . ' </td>';
$custfld .= '<td width="90%" colspan="3"><input name="parent_id" type="hidden" value="' . $parent_id . '"><textarea readonly name="parent_name" cols="70" rows="2">' . $parent_name . '</textarea> <select name="parent_type" >';
$custfld .= '<OPTION value="Contacts" selected>' . $app_strings['COMBO_CONTACTS'] . '</OPTION>';
$custfld .= '<OPTION value="Accounts" >' . $app_strings['COMBO_ACCOUNTS'] . '</OPTION>';
$custfld .= '<OPTION value="Leads" >' . $app_strings['COMBO_LEADS'] . '</OPTION>';
$custfld .= '<OPTION value="Vendors" >' . $app_strings['COMBO_VENDORS'] . '</OPTION></select><img src="' . vtiger_imageurl('select.gif', $theme) . '" alt="Select" title="Select" LANGUAGE=javascript onclick=\'$log->debug("Exiting getOutputHtml method ..."); return window.open("index.php?module="+ document.EditView.parent_type.value +"&action=Popup&popuptype=set_$log->debug("Exiting getOutputHtml method ..."); return_emails&form=EmailEditView&form_submit=false","test","width=600,height=400,resizable=1,scrollbars=1,top=150,left=200");\' align="absmiddle" style=\'cursor:hand;cursor:pointer\'> <input type="image" src="' . vtiger_imageurl('clear_field.gif', $theme) . '" alt="Clear" title="Clear" LANGUAGE=javascript onClick="this.form.parent_id.value=\'\';this.form.parent_name.value=\'\';$log->debug("Exiting getOutputHtml method ..."); return false;" align="absmiddle" style=\'cursor:hand;cursor:pointer\'></td>';
$editview_label[] = array('Contacts' => $contact_selected, 'Accounts' => $account_selected, 'Vendors' => $vendor_selected, 'Leads' => $lead_selected, 'Users' => $user_selected);
$fieldvalue[] = $parent_name;
$fieldvalue[] = $parent_id;
}
} elseif ($uitype == 68) {
if (empty($value) && isset($_REQUEST['parent_id']) && $_REQUEST['parent_id'] != '') {
$value = vtlib_purify($_REQUEST['parent_id']);
}
if ($value != '') {
$parent_module = getSalesEntityType($value);
if ($parent_module == "Contacts") {
$displayValueArray = getEntityName($parent_module, $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $field_value) {
$parent_name = $field_value;
}
}
$contact_selected = "selected";
} elseif ($parent_module == "Accounts") {
$sql = "select * from vtiger_account where accountid=?";
$result = $adb->pquery($sql, array($value));
$parent_name = $adb->query_result($result, 0, "accountname");
$account_selected = "selected";
} else {
$parent_name = "";
$value = "";
}
}
$editview_label[0] = array();
$editview_label[1] = array();
$editview_label[2] = array();
if (vtlib_isModuleActive('Accounts')) {
array_push($editview_label[0], $app_strings['COMBO_ACCOUNTS']);
array_push($editview_label[1], $account_selected);
array_push($editview_label[2], "Accounts");
}
if (vtlib_isModuleActive('Contacts')) {
array_push($editview_label[0], $app_strings['COMBO_CONTACTS']);
array_push($editview_label[1], $contact_selected);
array_push($editview_label[2], "Contacts");
}
$fieldvalue[] = $parent_name;
$fieldvalue[] = $value;
} elseif ($uitype == 9 || $uitype == 7) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fldrs = $adb->pquery('select typeofdata from vtiger_field
where vtiger_field.fieldname=? and vtiger_field.tabid=?', array($fieldname, getTabid($module_name)));
$typeofdata = $adb->query_result($fldrs, 0, 0);
$typeinfo = explode('~', $typeofdata);
if ($typeinfo[0] == 'I') {
$fieldvalue[] = $value;
} else {
$currencyField = new CurrencyField($value);
$decimals = CurrencyField::getDecimalsFromTypeOfData($typeofdata);
$currencyField->initialize($current_user);
$currencyField->setNumberofDecimals(min($decimals, $currencyField->getCurrencyDecimalPlaces()));
$fieldvalue[] = $currencyField->getDisplayValue(null, false, true);
}
} elseif ($uitype == 71 || $uitype == 72) {
$currencyField = new CurrencyField($value);
// Some of the currency fields like Unit Price, Total, Sub-total etc of Inventory modules, do not need currency conversion
if ($col_fields['record_id'] != '' && $uitype == 72) {
if ($fieldname == 'unit_price') {
$rate_symbol = getCurrencySymbolandCRate(getProductBaseCurrency($col_fields['record_id'], $module_name));
$currencySymbol = $rate_symbol['symbol'];
} else {
$currency_info = getInventoryCurrencyInfo($module, $col_fields['record_id']);
$currencySymbol = $currency_info['currency_symbol'];
}
$fieldvalue[] = $currencyField->getDisplayValue(null, true);
} else {
$decimals = CurrencyField::getDecimalsFromTypeOfData($typeofdata);
$currencyField->initialize($current_user);
$currencyField->setNumberofDecimals(min($decimals, $currencyField->getCurrencyDecimalPlaces()));
$fieldvalue[] = $currencyField->getDisplayValue(null, false, true);
$currencySymbol = $currencyField->getCurrencySymbol();
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name) . ': (' . $currencySymbol . ')';
} elseif ($uitype == 75 || $uitype == 81) {
if ($value != '') {
$vendor_name = getVendorName($value);
} elseif (isset($_REQUEST['vendor_id']) && $_REQUEST['vendor_id'] != '') {
$value = $_REQUEST['vendor_id'];
$vendor_name = getVendorName($value);
}
$pop_type = 'specific';
if ($uitype == 81) {
$pop_type = 'specific_vendor_address';
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $vendor_name;
$fieldvalue[] = $value;
} elseif ($uitype == 76) {
if ($value != '') {
$potential_name = getPotentialName($value);
} elseif (isset($_REQUEST['potential_id']) && $_REQUEST['potential_id'] != '') {
$value = $_REQUEST['potental_id'];
$potential_name = getPotentialName($value);
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $potential_name;
$fieldvalue[] = $value;
} elseif ($uitype == 78) {
if ($value != '') {
$quote_name = getQuoteName($value);
} elseif (isset($_REQUEST['quote_id']) && $_REQUEST['quote_id'] != '') {
$value = $_REQUEST['quote_id'];
$potential_name = getQuoteName($value);
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $quote_name;
$fieldvalue[] = $value;
} elseif ($uitype == 79) {
if ($value != '') {
$purchaseorder_name = getPoName($value);
} elseif (isset($_REQUEST['purchaseorder_id']) && $_REQUEST['purchaseorder_id'] != '') {
$value = $_REQUEST['purchaseorder_id'];
$purchaseorder_name = getPoName($value);
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $purchaseorder_name;
$fieldvalue[] = $value;
} elseif ($uitype == 80) {
if ($value != '') {
$salesorder_name = getSoName($value);
} elseif (isset($_REQUEST['salesorder_id']) && $_REQUEST['salesorder_id'] != '') {
$value = $_REQUEST['salesorder_id'];
$salesorder_name = getSoName($value);
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $salesorder_name;
$fieldvalue[] = $value;
} elseif ($uitype == 30) {
$rem_days = 0;
$rem_hrs = 0;
$rem_min = 0;
if ($value != '') {
$SET_REM = 'CHECKED';
} else {
$SET_REM = '';
}
$rem_days = floor($col_fields[$fieldname] / (24 * 60));
$rem_hrs = floor(($col_fields[$fieldname] - $rem_days * 24 * 60) / 60);
$rem_min = ($col_fields[$fieldname] - $rem_days * 24 * 60) % 60;
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$day_options = getReminderSelectOption(0, 31, 'remdays', $rem_days);
$hr_options = getReminderSelectOption(0, 23, 'remhrs', $rem_hrs);
$min_options = getReminderSelectOption(10, 59, 'remmin', $rem_min);
$fieldvalue[] = array(array(0, 32, 'remdays', getTranslatedString('LBL_DAYS', 'Calendar'), $rem_days), array(0, 24, 'remhrs', getTranslatedString('LBL_HOURS', 'Calendar'), $rem_hrs), array(10, 60, 'remmin', getTranslatedString('LBL_MINUTES', 'Calendar') . ' ' . getTranslatedString('LBL_BEFORE_EVENT', 'Calendar'), $rem_min));
$fieldvalue[] = array($SET_REM, getTranslatedString('LBL_YES'), getTranslatedString('LBL_NO'));
$SET_REM = '';
} elseif ($uitype == 115) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$pick_query = "select * from vtiger_" . $adb->sql_escape_string($fieldname);
$pickListResult = $adb->pquery($pick_query, array());
$noofpickrows = $adb->num_rows($pickListResult);
//Mikecrowe fix to correctly default for custom pick lists
$options = array();
$found = false;
for ($j = 0; $j < $noofpickrows; $j++) {
$pickListValue = $adb->query_result($pickListResult, $j, strtolower($fieldname));
if ($value == $pickListValue) {
$chk_val = "selected";
$found = true;
} else {
$chk_val = '';
}
$options[] = array(getTranslatedString($pickListValue), $pickListValue, $chk_val);
}
$fieldvalue[] = $options;
$fieldvalue[] = $is_admin;
} elseif ($uitype == 116 || $uitype == 117) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$pick_query = "select * from vtiger_currency_info where currency_status = 'Active' and deleted=0";
$pickListResult = $adb->pquery($pick_query, array());
$noofpickrows = $adb->num_rows($pickListResult);
//Mikecrowe fix to correctly default for custom pick lists
$options = array();
$found = false;
for ($j = 0; $j < $noofpickrows; $j++) {
$pickListValue = $adb->query_result($pickListResult, $j, 'currency_name');
$currency_id = $adb->query_result($pickListResult, $j, 'id');
if ($value == $currency_id) {
$chk_val = "selected";
$found = true;
} else {
$chk_val = '';
}
$options[$currency_id] = array($pickListValue => $chk_val);
}
$fieldvalue[] = $options;
$fieldvalue[] = $is_admin;
} elseif ($uitype == 98) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $value;
$fieldvalue[] = getRoleName($value);
$fieldvalue[] = $is_admin;
} elseif ($uitype == 105) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
if (isset($col_fields['record_id']) && $col_fields['record_id'] != '') {
$query = "select vtiger_attachments.path, vtiger_attachments.name from vtiger_contactdetails left join vtiger_seattachmentsrel on vtiger_seattachmentsrel.crmid=vtiger_contactdetails.contactid inner join vtiger_attachments on vtiger_attachments.attachmentsid=vtiger_seattachmentsrel.attachmentsid where vtiger_contactdetails.imagename=vtiger_attachments.name and contactid=?";
$result_image = $adb->pquery($query, array($col_fields['record_id']));
for ($image_iter = 0; $image_iter < $adb->num_rows($result_image); $image_iter++) {
$image_array[] = $adb->query_result($result_image, $image_iter, 'name');
$image_path_array[] = $adb->query_result($result_image, $image_iter, 'path');
}
}
if (is_array($image_array)) {
for ($img_itr = 0; $img_itr < count($image_array); $img_itr++) {
$fieldvalue[] = array('name' => $image_array[$img_itr], 'path' => $image_path_array[$img_itr]);
}
} else {
$fieldvalue[] = '';
}
} elseif ($uitype == 101) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = getOwnerName($value);
$fieldvalue[] = $value;
} elseif ($uitype == 26) {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$folderid = $col_fields['folderid'];
$foldername_query = 'select foldername from vtiger_attachmentsfolder where folderid = ?';
$res = $adb->pquery($foldername_query, array($folderid));
$foldername = $adb->query_result($res, 0, 'foldername');
if ($foldername != '' && $folderid != '') {
$fldr_name[$folderid] = $foldername;
}
$sql = "select foldername,folderid from vtiger_attachmentsfolder order by foldername";
$res = $adb->pquery($sql, array());
for ($i = 0; $i < $adb->num_rows($res); $i++) {
$fid = $adb->query_result($res, $i, "folderid");
$fldr_name[$fid] = $adb->query_result($res, $i, "foldername");
}
$fieldvalue[] = $fldr_name;
} elseif ($uitype == 27) {
if ($value == 'E') {
$external_selected = "selected";
$filename = $col_fields['filename'];
} else {
$internal_selected = "selected";
$filename = $col_fields['filename'];
}
$editview_label[] = array(getTranslatedString('Internal'), getTranslatedString('External'));
$editview_label[] = array($internal_selected, $external_selected);
$editview_label[] = array("I", "E");
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$fieldvalue[] = $value;
$fieldvalue[] = $filename;
} elseif ($uitype == '31') {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$options = array();
$themeList = get_themes();
foreach ($themeList as $theme) {
if ($value == $theme) {
$selected = 'selected';
} else {
$selected = '';
}
$options[] = array(getTranslatedString($theme), $theme, $selected);
}
$fieldvalue[] = $options;
} elseif ($uitype == '32') {
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
$options = array();
$languageList = Vtiger_Language::getAll();
foreach ($languageList as $prefix => $label) {
if ($value == $prefix) {
$selected = 'selected';
} else {
$selected = '';
}
$options[] = array(getTranslatedString($label), $prefix, $selected);
}
$fieldvalue[] = $options;
} else {
//Added condition to set the subject if click Reply All from web mail
if ($_REQUEST['module'] == 'Emails' && $_REQUEST['mg_subject'] != '') {
$value = $_REQUEST['mg_subject'];
}
$editview_label[] = getTranslatedString($fieldlabel, $module_name);
if ($fieldname == 'fileversion') {
if (empty($value)) {
$value = '';
} else {
$fieldvalue[] = $value;
}
} else {
$fieldvalue[] = $value;
}
}
}
// Mike Crowe Mod --------------------------------------------------------force numerics right justified.
if (!preg_match("/id=/i", $custfld)) {
$custfld = preg_replace("/<input/iS", "<input id='{$fieldname}' ", $custfld);
}
if (in_array($uitype, array(71, 72, 7, 9, 90))) {
$custfld = preg_replace("/<input/iS", "<input align=right ", $custfld);
}
$final_arr[] = $ui_type;
$final_arr[] = $editview_label;
$final_arr[] = $editview_fldname;
$final_arr[] = $fieldvalue;
$type_of_data = explode('~', $typeofdata);
$final_arr[] = $type_of_data[1];
$log->debug('Exiting getOutputHtml method ...');
return $final_arr;
}
public static function getUpdateLogEditMessage($ticketid, $column_fields)
{
global $adb, $log, $current_user;
//First retrieve the existing information
$tktresult = $adb->pquery("select * from vtiger_troubletickets where ticketid=?", array($ticketid));
$crmresult = $adb->pquery("select * from vtiger_crmentity where crmid=?", array($ticketid));
$updatelog = decode_html($adb->query_result($tktresult, 0, "update_log"));
$old_owner_id = $adb->query_result($crmresult, 0, "smownerid");
$old_status = $adb->query_result($tktresult, 0, "status");
$old_priority = $adb->query_result($tktresult, 0, "priority");
$old_severity = $adb->query_result($tktresult, 0, "severity");
$old_category = $adb->query_result($tktresult, 0, "category");
//Assigned to change log
if ($column_fields['assigned_user_id'] != $old_owner_id) {
$owner_name = getOwnerName($column_fields['assigned_user_id']);
if ($assigntype == 'T') {
$updatelog .= ' Transferred to group ' . $owner_name . '\\.';
} else {
$updatelog .= ' Transferred to user ' . decode_html($owner_name) . '\\.';
}
// Need to decode UTF characters which are migrated from versions < 5.0.4.
}
//Status change log
if ($old_status != $column_fields['ticketstatus'] && $column_fields['ticketstatus'] != '') {
$updatelog .= ' Status Changed to ' . $column_fields['ticketstatus'] . '\\.';
}
//Priority change log
if ($old_priority != $column_fields['ticketpriorities'] && $column_fields['ticketpriorities'] != '') {
$updatelog .= ' Priority Changed to ' . $column_fields['ticketpriorities'] . '\\.';
}
//Severity change log
if ($old_severity != $column_fields['ticketseverities'] && $column_fields['ticketseverities'] != '') {
$updatelog .= ' Severity Changed to ' . $column_fields['ticketseverities'] . '\\.';
}
//Category change log
if ($old_category != $column_fields['ticketcategories'] && $column_fields['ticketcategories'] != '') {
$updatelog .= ' Category Changed to ' . $column_fields['ticketcategories'] . '\\.';
}
$updatelog .= ' -- ' . date("l dS F Y h:i:s A") . ' by ' . $current_user->user_name . '--//--';
return $updatelog;
}
/**
* This function is used to get the days in between the current time and the modified time of an entity .
* Takes the input parameter as $id - crmid it will calculate the number of days in between the
* the current time and the modified time from the vtiger_crmentity vtiger_table and return the result as a string.
* The return format is updated <No of Days> day ago <(date when updated)>
*/
function updateInfo($id)
{
global $log;
$log->debug("Entering updateInfo(" . $id . ") method ...");
global $adb;
global $app_strings;
$query = 'SELECT modifiedtime, modifiedby FROM vtiger_crmentity WHERE crmid = ?';
$result = $adb->pquery($query, array($id));
$modifiedtime = $adb->query_result($result, 0, 'modifiedtime');
$modifiedby_id = $adb->query_result($result, 0, 'modifiedby');
$modifiedby = $app_strings['LBL_BY'] . getOwnerName($modifiedby_id);
$date = new DateTimeField($modifiedtime);
$modifiedtime = DateTimeField::convertToDBFormat($date->getDisplayDate());
$current_time = date('Y-m-d H:i:s');
$values = explode(' ', $modifiedtime);
$date_info = explode('-', $values[0]);
$time_info = explode(':', $values[1]);
$date = $date_info[2] . ' ' . $app_strings[date("M", mktime(0, 0, 0, $date_info[1], $date_info[2], $date_info[0]))] . ' ' . $date_info[0];
$time_modified = strtotime($modifiedtime);
$time_now = strtotime($current_time);
$days_diff = (int) (($time_now - $time_modified) / (60 * 60 * 24));
if ($days_diff == 0) {
$update_info = $app_strings['LBL_UPDATED_TODAY'] . " (" . $date . ")" . ' ' . $modifiedby;
} elseif ($days_diff == 1) {
$update_info = $app_strings['LBL_UPDATED'] . " " . $days_diff . " " . $app_strings['LBL_DAY_AGO'] . " (" . $date . ")" . ' ' . $modifiedby;
} else {
$update_info = $app_strings['LBL_UPDATED'] . " " . $days_diff . " " . $app_strings['LBL_DAYS_AGO'] . " (" . $date . ")" . ' ' . $modifiedby;
}
$log->debug("Exiting updateInfo method ...");
return $update_info;
}
/**
* this function processes the given result and returns the value :: for now we are getting the values for the
* reference, owner fields, booleans and currency fields; other processing might be added later if required
* @param array $result - the webservices result object
* @param array $descObj - the webservices describe object
* @return array $result - the processes webservices result object
*/
function vttooltip_processResult($result, $descObj)
{
global $current_user;
foreach ($descObj['fields'] as $field) {
if ($field['type']['name'] == 'reference') {
$name = $field['name'];
$value = $result[0][$name];
if (!empty($value)) {
$result[0][$name] = vtws_getName($value, $current_user);
} else {
$result[0][$name] = '';
}
} elseif ($field['type']['name'] == 'owner') {
$name = $field['name'];
$value = $result[0][$name];
list($info, $id) = explode("x", $value);
$result[0][$name] = getOwnerName($id);
} elseif ($field['type']['name'] == 'boolean') {
$name = $field['name'];
if ($result[0][$name] == 1) {
$result[0][$name] = "on";
} else {
$result[0][$name] = "off";
}
} elseif ($field['type']['name'] == 'picklist') {
$name = $field['name'];
$temp = '';
foreach ($field['type']['picklistValues'] as $value) {
if (strcmp($value['value'], $result[0][$name]) == 0) {
$temp = $value['value'];
}
}
$result[0][$name] = $temp;
}
}
return $result;
}
/**
* Transform the value while exporting
*/
function transform_export_value($key, $value)
{
if ($key == 'owner') {
return getOwnerName($value);
}
return parent::transform_export_value($key, $value);
}
function get_details($id, $module, $customerid, $sessionid)
{
global $adb, $log, $current_language, $default_language, $current_user;
require_once 'include/utils/utils.php';
require_once 'include/utils/UserInfoUtil.php';
require_once 'modules/Users/Users.php';
$log->debug("Entering customer portal function get_details ..");
$user = new Users();
$userid = getPortalUserid();
$current_user = $user->retrieveCurrentUserInfoFromFile($userid);
$current_language = $default_language;
$isPermitted = check_permission($customerid, $module, $id);
if ($isPermitted == false) {
return array("#NOT AUTHORIZED#");
}
if (!validateSession($customerid, $sessionid)) {
return null;
}
if ($module == 'Quotes') {
$query = "SELECT\n\t\t\tvtiger_quotes.*,vtiger_crmentity.*,vtiger_quotesbillads.*,vtiger_quotesshipads.*, \n\t\t\tvtiger_quotescf.* FROM vtiger_quotes \n\t\t\tINNER JOIN vtiger_crmentity " . "ON vtiger_crmentity.crmid = vtiger_quotes.quoteid \n\t\t\tINNER JOIN vtiger_quotesbillads\n\t\t\t\tON vtiger_quotes.quoteid = vtiger_quotesbillads.quotebilladdressid\n\t\t\tINNER JOIN vtiger_quotesshipads\n\t\t\t\tON vtiger_quotes.quoteid = vtiger_quotesshipads.quoteshipaddressid\n\t\t\tLEFT JOIN vtiger_quotescf\n\t\t\t\tON vtiger_quotes.quoteid = vtiger_quotescf.quoteid \n\t\t\tWHERE vtiger_quotes.quoteid=(" . generateQuestionMarks($id) . ") AND vtiger_crmentity.deleted = 0";
} else {
if ($module == 'Documents') {
$query = "SELECT\n\t\t\tvtiger_notes.*,vtiger_crmentity.*,vtiger_attachmentsfolder.foldername \n\t\t\tFROM vtiger_notes\n\t\t\tINNER JOIN vtiger_crmentity on vtiger_crmentity.crmid = vtiger_notes.notesid \n\t\t\tLEFT JOIN vtiger_attachmentsfolder \n\t\t\t\tON vtiger_notes.folderid = vtiger_attachmentsfolder.folderid\n\t\t\twhere vtiger_notes.notesid=(" . generateQuestionMarks($id) . ") AND vtiger_crmentity.deleted=0";
} else {
if ($module == 'HelpDesk') {
$query = "SELECT\n\t\t\tvtiger_troubletickets.*,vtiger_crmentity.smownerid,vtiger_crmentity.createdtime,vtiger_crmentity.modifiedtime, \n\t\t\tvtiger_ticketcf.*,vtiger_crmentity.description FROM vtiger_troubletickets\n\t\t\tINNER JOIN vtiger_crmentity on vtiger_crmentity.crmid = vtiger_troubletickets.ticketid \n\t\t\tINNER JOIN vtiger_ticketcf\n\t\t\t\tON vtiger_ticketcf.ticketid = vtiger_troubletickets.ticketid\n\t\t\tWHERE (vtiger_troubletickets.ticketid=(" . generateQuestionMarks($id) . ") AND vtiger_crmentity.deleted = 0)";
} else {
if ($module == 'Services') {
$query = "SELECT vtiger_service.*,vtiger_crmentity.*,vtiger_servicecf.* FROM vtiger_service\n\t\t\tINNER JOIN vtiger_crmentity \n\t\t\t\tON vtiger_crmentity.crmid = vtiger_service.serviceid AND vtiger_crmentity.deleted = 0\n\t\t\tLEFT JOIN vtiger_servicecf \n\t\t\t\tON vtiger_service.serviceid = vtiger_servicecf.serviceid \t\n\t\t\tWHERE vtiger_service.serviceid= (" . generateQuestionMarks($id) . ")";
} else {
if ($module == 'Contacts') {
$query = "SELECT vtiger_contactdetails.*,vtiger_contactaddress.*,vtiger_contactsubdetails.*,vtiger_contactscf.*" . " ,vtiger_crmentity.*,vtiger_customerdetails.* \n\t\t \tFROM vtiger_contactdetails \n\t\t\tINNER JOIN vtiger_crmentity\n\t\t\t\tON vtiger_crmentity.crmid = vtiger_contactdetails.contactid \n\t\t\tINNER JOIN vtiger_contactaddress\n\t\t\t\tON vtiger_contactaddress.contactaddressid = vtiger_contactdetails.contactid\n\t\t\tINNER JOIN vtiger_contactsubdetails\n\t\t\t\tON vtiger_contactsubdetails.contactsubscriptionid = vtiger_contactdetails.contactid\n\t\t\tINNER JOIN vtiger_contactscf\n\t\t\t\tON vtiger_contactscf.contactid = vtiger_contactdetails.contactid\n\t\t\tLEFT JOIN vtiger_customerdetails\n\t\t\t\tON vtiger_customerdetails.customerid = vtiger_contactdetails.contactid \n\t\t\tWHERE vtiger_contactdetails.contactid = (" . generateQuestionMarks($id) . ") AND vtiger_crmentity.deleted = 0";
} else {
if ($module == 'Accounts') {
$query = "SELECT vtiger_account.*,vtiger_accountbillads.*,vtiger_accountshipads.*,vtiger_accountscf.*,\n\t\t\tvtiger_crmentity.* FROM vtiger_account\n\t\t\tINNER JOIN vtiger_crmentity\n\t\t\t\tON vtiger_crmentity.crmid = vtiger_account.accountid\n\t\t\tINNER JOIN vtiger_accountbillads\n\t\t\t\tON vtiger_account.accountid = vtiger_accountbillads.accountaddressid\n\t\t\tINNER JOIN vtiger_accountshipads\n\t\t\t\tON vtiger_account.accountid = vtiger_accountshipads.accountaddressid\n\t\t\tINNER JOIN vtiger_accountscf\n\t\t\t\tON vtiger_account.accountid = vtiger_accountscf.accountid" . " WHERE vtiger_account.accountid = (" . generateQuestionMarks($id) . ") AND vtiger_crmentity.deleted = 0";
} else {
if ($module == 'Products') {
$query = "SELECT vtiger_products.*,vtiger_productcf.*,vtiger_crmentity.* " . "FROM vtiger_products " . "INNER JOIN vtiger_crmentity " . "ON vtiger_crmentity.crmid = vtiger_products.productid " . "LEFT JOIN vtiger_productcf " . "ON vtiger_productcf.productid = vtiger_products.productid " . "LEFT JOIN vtiger_vendor \n\t\t\tON vtiger_vendor.vendorid = vtiger_products.vendor_id \n\t\tLEFT JOIN vtiger_users \n\t\t\tON vtiger_users.id = vtiger_products.handler " . "WHERE vtiger_products.productid = (" . generateQuestionMarks($id) . ") AND vtiger_crmentity.deleted = 0";
}
}
}
}
}
}
}
$params = array($id);
$fieldquery = "SELECT fieldname,columnname,fieldlabel,blocklabel,uitype FROM vtiger_field \n\tINNER JOIN vtiger_blocks on vtiger_blocks.blockid=vtiger_field.block WHERE vtiger_field.tabid = ? AND displaytype in (1,2,4) \n\tORDER BY vtiger_field.block,vtiger_field.sequence";
$fieldres = $adb->pquery($fieldquery, array(getTabid($module)));
$nooffields = $adb->num_rows($fieldres);
$res = $adb->pquery($query, $params);
// Dummy instance to make sure column fields are initialized for futher processing
$focus = CRMEntity::getInstance($module);
for ($i = 0; $i < $nooffields; $i++) {
$columnname = $adb->query_result($fieldres, $i, 'columnname');
$fieldname = $adb->query_result($fieldres, $i, 'fieldname');
$fieldid = $adb->query_result($fieldres, $i, 'fieldid');
$blockid = $adb->query_result($fieldres, $i, 'block');
$uitype = $adb->query_result($fieldres, $i, 'uitype');
$blocklabel = $adb->query_result($fieldres, $i, 'blocklabel');
$blockname = getTranslatedString($blocklabel, $module);
if ($blocklabel == 'LBL_COMMENTS' || $blocklabel == 'LBL_IMAGE_INFORMATION') {
// the comments block of tickets is hardcoded in customer portal,get_ticket_comments is used for it
continue;
}
if ($uitype == 83) {
//for taxclass in products and services
continue;
}
$fieldper = getFieldVisibilityPermission($module, $current_user->id, $fieldname);
if ($fieldper == '1') {
continue;
}
$fieldlabel = getTranslatedString($adb->query_result($fieldres, $i, 'fieldlabel'));
$fieldvalue = $adb->query_result($res, 0, $columnname);
$output[0][$module][$i]['fieldlabel'] = $fieldlabel;
$output[0][$module][$i]['blockname'] = $blockname;
if ($columnname == 'parent_id' || $columnname == 'contactid' || $columnname == 'accountid' || $columnname == 'potentialid' || $fieldname == 'account_id' || $fieldname == 'contact_id') {
$crmid = $fieldvalue;
$modulename = getSalesEntityType($crmid);
if ($crmid != '' && $modulename != '') {
$fieldvalues = getEntityName($modulename, array($crmid));
if ($modulename == 'Contacts') {
$fieldvalue = '<a href="index.php?module=Contacts&action=index&id=' . $crmid . '">' . $fieldvalues[$crmid] . '</a>';
} elseif ($modulename == 'Accounts') {
$fieldvalue = '<a href="index.php?module=Accounts&action=index&id=' . $crmid . '">' . $fieldvalues[$crmid] . '</a>';
} else {
$fieldvalue = $fieldvalues[$crmid];
}
} else {
$fieldvalue = '';
}
}
if ($module == 'Quotes') {
if ($fieldname == 'subject' && $fieldvalue != '') {
$fieldid = $adb->query_result($res, 0, 'quoteid');
$fieldvalue = '<a href="index.php?downloadfile=true&module=Quotes&action=index&id=' . $fieldid . '">' . $fieldvalue . '</a>';
}
if ($fieldname == 'total') {
$sym = getCurrencySymbol($res, 0, 'currency_id');
$fieldvalue = $sym . $fieldvalue;
}
}
if ($module == 'Documents') {
$fieldid = $adb->query_result($res, 0, 'notesid');
$filename = $fieldvalue;
$folderid = $adb->query_result($res, 0, 'folderid');
$filestatus = $adb->query_result($res, 0, 'filestatus');
$filetype = $adb->query_result($res, 0, 'filelocationtype');
if ($fieldname == 'filename') {
if ($filestatus == 1) {
if ($filetype == 'I') {
$fieldvalue = '<a href="index.php?downloadfile=true&folderid=' . $folderid . '&filename=' . $filename . '&module=Documents&action=index&id=' . $fieldid . '" >' . $fieldvalue . '</a>';
} elseif ($filetype == 'E') {
$fieldvalue = '<a target="_blank" href="' . $filename . '" onclick = "updateCount(' . $fieldid . ');">' . $filename . '</a>';
}
}
}
if ($fieldname == 'folderid') {
$fieldvalue = $adb->query_result($res, 0, 'foldername');
}
if ($fieldname == 'filesize') {
if ($filetype == 'I') {
$fieldvalue = $fieldvalue . ' B';
} elseif ($filetype == 'E') {
$fieldvalue = '--';
}
}
if ($fieldname == 'filelocationtype') {
if ($fieldvalue == 'I') {
$fieldvalue = getTranslatedString('LBL_INTERNAL', $module);
} elseif ($fieldvalue == 'E') {
$fieldvalue = getTranslatedString('LBL_EXTERNAL', $module);
} else {
$fieldvalue = '---';
}
}
}
if ($columnname == 'product_id') {
$fieldvalues = getEntityName('Products', array($fieldvalue));
$fieldvalue = '<a href="index.php?module=Products&action=index&productid=' . $fieldvalue . '">' . $fieldvalues[$fieldvalue] . '</a>';
}
if ($module == 'Products') {
if ($fieldname == 'vendor_id') {
$fieldvalue = get_vendor_name($fieldvalue);
}
}
if ($fieldname == 'assigned_user_id' || $fieldname == 'assigned_user_id1') {
$fieldvalue = getOwnerName($fieldvalue);
}
if ($uitype == 56) {
if ($fieldvalue == 1) {
$fieldvalue = 'Yes';
} else {
$fieldvalue = 'No';
}
}
if ($module == 'HelpDesk' && $fieldname == 'ticketstatus') {
$parentid = $adb->query_result($res, 0, 'parent_id');
$status = $adb->query_result($res, 0, 'status');
if ($customerid != $parentid) {
//allow only the owner to delete the ticket
$fieldvalue = '';
} else {
$fieldvalue = $status;
}
}
if ($fieldname == 'unit_price') {
$sym = getCurrencySymbol($res, 0, 'currency_id');
$fieldvalue = $sym . $fieldvalue;
}
$output[0][$module][$i]['fieldvalue'] = $fieldvalue;
}
if ($module == 'HelpDesk') {
$ticketid = $adb->query_result($res, 0, 'ticketid');
$sc_info = getRelatedServiceContracts($ticketid);
if (!empty($sc_info)) {
$modulename = 'ServiceContracts';
$blocklable = getTranslatedString('LBL_SERVICE_CONTRACT_INFORMATION', $modulename);
$j = $i;
for ($k = 0; $k < count($sc_info); $k++) {
foreach ($sc_info[$k] as $label => $value) {
$output[0][$module][$j]['fieldlabel'] = getTranslatedString($label, $modulename);
$output[0][$module][$j]['fieldvalue'] = $value;
$output[0][$module][$j]['blockname'] = $blocklable;
$j++;
}
}
}
}
$log->debug("Existing customer portal function get_details ..");
return $output;
}
/** This function returns the detail view form vtiger_field and and its properties in array format.
* Param $uitype - UI type of the vtiger_field
* Param $fieldname - Form vtiger_field name
* Param $fieldlabel - Form vtiger_field label name
* Param $col_fields - array contains the vtiger_fieldname and values
* Param $generatedtype - Field generated type (default is 1)
* Param $tabid - vtiger_tab id to which the Field belongs to (default is "")
* Return type is an array
*/
function getDetailViewOutputHtml($uitype, $fieldname, $fieldlabel, $col_fields, $generatedtype, $tabid = '', $module = '')
{
global $log;
$log->debug("Entering getDetailViewOutputHtml(" . $uitype . "," . $fieldname . "," . $fieldlabel . "," . $col_fields . "," . $generatedtype . "," . $tabid . ") method ...");
global $adb;
global $mod_strings;
global $app_strings;
global $current_user;
global $theme;
$theme_path = "themes/" . $theme . "/";
$image_path = $theme_path . "images/";
$fieldlabel = from_html($fieldlabel);
$custfld = '';
$value = '';
$arr_data = array();
$label_fld = array();
$data_fld = array();
require 'user_privileges/user_privileges_' . $current_user->id . '.php';
require 'user_privileges/sharing_privileges_' . $current_user->id . '.php';
// vtlib customization: New uitype to handle relation between modules
if ($uitype == '10') {
$fieldlabel = getTranslatedString($fieldlabel, $module);
$parent_id = $col_fields[$fieldname];
if (!empty($parent_id)) {
$parent_module = getSalesEntityType($parent_id);
$valueTitle = getTranslatedString($parent_module, $parent_module);
$displayValueArray = getEntityName($parent_module, $parent_id);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $value) {
$displayValue = $value;
}
}
// vtlib customization: For listview javascript triggers
$modMetaInfo = getEntityFieldNames($parent_module);
$modEName = is_array($modMetaInfo['fieldname']) ? $modMetaInfo['fieldname'][0] : $modMetaInfo['fieldname'];
$vtlib_metainfo = "<span type='vtlib_metainfo' vtrecordid='{$parent_id}' vtfieldname=" . "'{$modEName}' vtmodule='{$parent_module}' style='display:none;'></span>";
// END
$label_fld = array($fieldlabel, "<a href='index.php?module={$parent_module}&action=DetailView&record={$parent_id}' title='{$valueTitle}'>{$displayValue}</a>{$vtlib_metainfo}");
} else {
$moduleSpecificMessage = 'MODULE_NOT_SELECTED';
if ($mod_strings[$moduleSpecificMessage] != "") {
$moduleSpecificMessage = $mod_strings[$moduleSpecificMessage];
}
$label_fld = array($fieldlabel, '');
}
} else {
if ($uitype == 99) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $col_fields[$fieldname];
if ($fieldname == 'confirm_password') {
return null;
}
} elseif ($uitype == 116 || $uitype == 117) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = getCurrencyName($col_fields[$fieldname]);
$pick_query = "select * from vtiger_currency_info where currency_status = 'Active' and deleted=0";
$pickListResult = $adb->pquery($pick_query, array());
$noofpickrows = $adb->num_rows($pickListResult);
//Mikecrowe fix to correctly default for custom pick lists
$options = array();
$found = false;
for ($j = 0; $j < $noofpickrows; $j++) {
$pickListValue = $adb->query_result($pickListResult, $j, 'currency_name');
$currency_id = $adb->query_result($pickListResult, $j, 'id');
if ($col_fields[$fieldname] == $currency_id) {
$chk_val = "selected";
$found = true;
} else {
$chk_val = '';
}
$options[$currency_id] = array($pickListValue => $chk_val);
}
$label_fld["options"] = $options;
} elseif ($uitype == 13 || $uitype == 104) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $col_fields[$fieldname];
} elseif ($uitype == 16) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = getTranslatedString($col_fields[$fieldname], $module);
$fieldname = $adb->sql_escape_string($fieldname);
$pick_query = "select {$fieldname} from vtiger_{$fieldname} order by sortorderid";
$params = array();
$pickListResult = $adb->pquery($pick_query, $params);
$noofpickrows = $adb->num_rows($pickListResult);
$options = array();
$count = 0;
$found = false;
for ($j = 0; $j < $noofpickrows; $j++) {
$pickListValue = decode_html($adb->query_result($pickListResult, $j, strtolower($fieldname)));
$col_fields[$fieldname] = decode_html($col_fields[$fieldname]);
if ($col_fields[$fieldname] == $pickListValue) {
$chk_val = "selected";
$count++;
$found = true;
} else {
$chk_val = '';
}
$pickListValue = to_html($pickListValue);
$options[] = array(getTranslatedString($pickListValue), $pickListValue, $chk_val);
}
$label_fld["options"] = $options;
} elseif ($uitype == 15) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $col_fields[$fieldname];
$roleid = $current_user->roleid;
$valueArr = explode("|##|", $col_fields[$fieldname]);
$picklistValues = getAssignedPicklistValues($fieldname, $roleid, $adb);
//Mikecrowe fix to correctly default for custom pick lists
$options = array();
$count = 0;
$found = false;
if (!empty($picklistValues)) {
foreach ($picklistValues as $order => $pickListValue) {
if (in_array(trim($pickListValue), array_map("trim", $valueArr))) {
$chk_val = "selected";
$pickcount++;
} else {
$chk_val = '';
}
if (isset($_REQUEST['file']) && $_REQUEST['file'] == 'QuickCreate') {
$options[] = array(htmlentities(getTranslatedString($pickListValue), ENT_QUOTES, $default_charset), $pickListValue, $chk_val);
} else {
$options[] = array(getTranslatedString($pickListValue), $pickListValue, $chk_val);
}
}
if ($pickcount == 0 && !empty($value)) {
$options[] = array($app_strings['LBL_NOT_ACCESSIBLE'], $value, 'selected');
}
}
$label_fld["options"] = $options;
} elseif ($uitype == 115) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = getTranslatedString($col_fields[$fieldname]);
$pick_query = "select * from vtiger_" . $adb->sql_escape_string($fieldname);
$pickListResult = $adb->pquery($pick_query, array());
$noofpickrows = $adb->num_rows($pickListResult);
$options = array();
$found = false;
for ($j = 0; $j < $noofpickrows; $j++) {
$pickListValue = $adb->query_result($pickListResult, $j, strtolower($fieldname));
if ($col_fields[$fieldname] == $pickListValue) {
$chk_val = "selected";
$found = true;
} else {
$chk_val = '';
}
$options[] = array($pickListValue => $chk_val);
}
$label_fld["options"] = $options;
} elseif ($uitype == 33) {
//uitype 33 added for multiselector picklist - Jeri
$roleid = $current_user->roleid;
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = str_ireplace(' |##| ', ', ', $col_fields[$fieldname]);
$picklistValues = getAssignedPicklistValues($fieldname, $roleid, $adb);
$options = array();
$selected_entries = array();
$selected_entries = explode(' |##| ', $col_fields[$fieldname]);
if (!empty($picklistValues)) {
foreach ($picklistValues as $order => $pickListValue) {
foreach ($selected_entries as $selected_entries_value) {
if (trim($selected_entries_value) == trim(htmlentities($pickListValue, ENT_QUOTES, $default_charset))) {
$chk_val = 'selected';
$pickcount++;
break;
} else {
$chk_val = '';
}
}
if (isset($_REQUEST['file']) && $_REQUEST['file'] == 'QuickCreate') {
$options[] = array(htmlentities(getTranslatedString($pickListValue), ENT_QUOTES, $default_charset), $pickListValue, $chk_val);
} else {
$options[] = array(getTranslatedString($pickListValue), $pickListValue, $chk_val);
}
}
if ($pickcount == 0 && !empty($value)) {
$not_access_lbl = "<font color='red'>" . $app_strings['LBL_NOT_ACCESSIBLE'] . "</font>";
$options[] = array($not_access_lbl, trim($selected_entries_value), 'selected');
}
}
$label_fld["options"] = $options;
} elseif ($uitype == 17) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$matchPattern = "^[\\w]+:\\/\\/^";
$value = $col_fields[$fieldname];
preg_match($matchPattern, $value, $matches);
if (!empty($matches[0])) {
$fieldValue = str_replace($matches, "", $value);
$label_fld[] = $value;
} else {
if ($value != null) {
$label_fld[] = 'http://' . $value;
} else {
$label_fld[] = '';
}
}
} elseif ($uitype == 19) {
if ($fieldname == 'notecontent' or $module == 'Timecontrol') {
$col_fields[$fieldname] = decode_html($col_fields[$fieldname]);
} else {
$col_fields[$fieldname] = str_replace("<br />", "<br>", $col_fields[$fieldname]);
}
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $col_fields[$fieldname];
} elseif ($uitype == 20 || $uitype == 21 || $uitype == 22 || $uitype == 24) {
// Armando LC<scher 11.08.2005 -> B'descriptionSpan -> Desc: removed $uitype == 19 and made an aditional elseif above
if ($uitype == 20) {
//Fix the issue #4680
$col_fields[$fieldname] = $col_fields[$fieldname];
} else {
$col_fields[$fieldname] = nl2br($col_fields[$fieldname]);
}
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $col_fields[$fieldname];
} elseif ($uitype == 51 || $uitype == 50 || $uitype == 73) {
$account_id = $col_fields[$fieldname];
if ($account_id != '') {
$account_name = getAccountName($account_id);
}
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $account_name;
$label_fld["secid"] = $account_id;
$label_fld["link"] = "index.php?module=Accounts&action=DetailView&record=" . $account_id;
//Account Name View
} elseif ($uitype == 52 || $uitype == 77 || $uitype == 101) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$user_id = $col_fields[$fieldname];
$user_name = getOwnerName($user_id);
if ($user_id != '') {
$assigned_user_id = $user_id;
} else {
$assigned_user_id = $current_user->id;
}
if (is_admin($current_user)) {
$label_fld[] = '<a href="index.php?module=Users&action=DetailView&record=' . $user_id . '">' . $user_name . '</a>';
} else {
$label_fld[] = $user_name;
}
if ($is_admin == false && $profileGlobalPermission[2] == 1 && ($defaultOrgSharingPermission[getTabid($module)] == 3 or $defaultOrgSharingPermission[getTabid($module)] == 0)) {
$users_combo = get_select_options_array(get_user_array(FALSE, "Active", $assigned_user_id, 'private'), $assigned_user_id);
} else {
$users_combo = get_select_options_array(get_user_array(FALSE, "Active", $user_id), $assigned_user_id);
}
$label_fld["options"] = $users_combo;
} elseif ($uitype == 11) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $col_fields[$fieldname];
} elseif ($uitype == 53) {
global $noof_group_rows, $adb;
$owner_id = $col_fields[$fieldname];
$user = '******';
$result = $adb->pquery("SELECT count(*) as count from vtiger_users where id = ?", array($owner_id));
if ($adb->query_result($result, 0, 'count') > 0) {
$user = '******';
}
$owner_name = getOwnerName($owner_id);
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $owner_name;
if (is_admin($current_user)) {
$label_fld["secid"][] = $owner_id;
if ($user == 'no') {
$label_fld["link"][] = "index.php?module=Settings&action=GroupDetailView&groupId=" . $owner_id;
} else {
$label_fld["link"][] = "index.php?module=Users&action=DetailView&record=" . $owner_id;
}
//$label_fld["secid"][] = $groupid;
//$label_fld["link"][] = "index.php?module=Settings&action=GroupDetailView&groupId=".$groupid;
}
//Security Checks
if ($fieldname == 'assigned_user_id' && $is_admin == false && $profileGlobalPermission[2] == 1 && ($defaultOrgSharingPermission[getTabid($module_name)] == 3 or $defaultOrgSharingPermission[getTabid($module_name)] == 0)) {
$result = get_current_user_access_groups($module_name);
} else {
$result = get_group_options();
}
if ($result) {
$nameArray = $adb->fetch_array($result);
}
global $current_user;
//$value = $user_id;
if ($owner_id != '') {
if ($user == 'yes') {
$label_fld["options"][] = 'User';
$assigned_user_id = $owner_id;
$user_checked = "checked";
$team_checked = '';
$user_style = 'display:block';
$team_style = 'display:none';
} else {
//$record = $col_fields["record_id"];
//$module = $col_fields["record_module"];
$label_fld["options"][] = 'Group';
$assigned_group_id = $owner_id;
$user_checked = '';
$team_checked = 'checked';
$user_style = 'display:none';
$team_style = 'display:block';
}
} else {
$label_fld["options"][] = 'User';
$assigned_user_id = $current_user->id;
$user_checked = "checked";
$team_checked = '';
$user_style = 'display:block';
$team_style = 'display:none';
}
if ($fieldname == 'assigned_user_id' && $is_admin == false && $profileGlobalPermission[2] == 1 && ($defaultOrgSharingPermission[getTabid($module)] == 3 or $defaultOrgSharingPermission[getTabid($module)] == 0)) {
$users_combo = get_select_options_array(get_user_array(FALSE, "Active", $current_user->id, 'private'), $assigned_user_id);
} else {
$users_combo = get_select_options_array(get_user_array(FALSE, "Active", $current_user->id), $assigned_user_id);
}
if ($noof_group_rows != 0) {
if ($fieldname == 'assigned_user_id' && $is_admin == false && $profileGlobalPermission[2] == 1 && ($defaultOrgSharingPermission[getTabid($module)] == 3 or $defaultOrgSharingPermission[getTabid($module)] == 0)) {
$groups_combo = get_select_options_array(get_group_array(FALSE, "Active", $current_user->id, 'private'), $current_user->id);
} else {
$groups_combo = get_select_options_array(get_group_array(FALSE, "Active", $current_user->id), $current_user->id);
}
}
$label_fld["options"][] = $users_combo;
$label_fld["options"][] = $groups_combo;
} elseif ($uitype == 55 || $uitype == 255) {
if ($tabid == 4) {
$query = "select vtiger_contactdetails.imagename from vtiger_contactdetails where contactid=?";
$result = $adb->pquery($query, array($col_fields['record_id']));
$imagename = $adb->query_result($result, 0, 'imagename');
if ($imagename != '') {
$imgpath = "test/contact/" . $imagename;
$label_fld[] = getTranslatedString($fieldlabel, $module);
} else {
$label_fld[] = getTranslatedString($fieldlabel, $module);
}
} else {
$label_fld[] = getTranslatedString($fieldlabel, $module);
}
$value = $col_fields[$fieldname];
if ($uitype == 255) {
global $currentModule;
$fieldpermission = getFieldVisibilityPermission($currentModule, $current_user->id, 'firstname');
}
if ($uitype == 255 && $fieldpermission == 0 && $fieldpermission != '') {
$fieldvalue[] = '';
} else {
$roleid = $current_user->roleid;
$subrole = getRoleSubordinates($roleid);
if (count($subrole) > 0) {
$roleids = implode("','", $subrole);
$roleids = $roleids . "','" . $roleid;
} else {
$roleids = $roleid;
}
if ($is_admin == true || $profileGlobalPermission[1] == 0 || $profileGlobalPermission[2] == 0) {
$pick_query = "select salutationtype from vtiger_salutationtype order by salutationtype";
$params = array();
} else {
$pick_query = "select * from vtiger_salutationtype left join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid=vtiger_salutationtype.picklist_valueid where picklistid in (select picklistid from vtiger_picklist where name='salutationtype') and roleid=? order by salutationtype";
$params = array($current_user->roleid);
}
$pickListResult = $adb->pquery($pick_query, $params);
$noofpickrows = $adb->num_rows($pickListResult);
$sal_value = $col_fields["salutationtype"];
$salcount = 0;
for ($j = 0; $j < $noofpickrows; $j++) {
$pickListValue = $adb->query_result($pickListResult, $j, "salutationtype");
if ($sal_value == $pickListValue) {
$chk_val = "selected";
$salcount++;
} else {
$chk_val = '';
}
}
if ($salcount == 0 && $sal_value != '') {
$notacc = $app_strings['LBL_NOT_ACCESSIBLE'];
}
$sal_value = $col_fields["salutationtype"];
if ($sal_value == '--None--') {
$sal_value = '';
}
$label_fld["salut"] = getTranslatedString($sal_value);
$label_fld["notaccess"] = $notacc;
}
$label_fld[] = $value;
} elseif ($uitype == 56) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$value = $col_fields[$fieldname];
if ($value == 1) {
//Since "yes" is not been translated it is given as app strings here..
$displayValue = $app_strings['yes'];
} else {
$displayValue = $app_strings['no'];
}
$label_fld[] = $displayValue;
} elseif ($uitype == 156) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$value = $col_fields[$fieldname];
if ($value == 'on') {
//Since "yes" is not been translated it is given as app strings here..
$displayValue = $app_strings['yes'];
} else {
$displayValue = $app_strings['no'];
}
$label_fld[] = $displayValue;
} elseif ($uitype == 57) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$contact_id = $col_fields[$fieldname];
if ($contact_id != '') {
$displayValueArray = getEntityName('Contacts', $contact_id);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $field_value) {
$contact_name = $field_value;
}
} else {
$contact_name = '';
}
}
$label_fld[] = $contact_name;
$label_fld["secid"] = $contact_id;
$label_fld["link"] = "index.php?module=Contacts&action=DetailView&record=" . $contact_id;
} elseif ($uitype == 58) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$campaign_id = $col_fields[$fieldname];
if ($campaign_id != '') {
$campaign_name = getCampaignName($campaign_id);
}
$label_fld[] = $campaign_name;
$label_fld["secid"] = $campaign_id;
$label_fld["link"] = "index.php?module=Campaigns&action=DetailView&record=" . $campaign_id;
} elseif ($uitype == 59) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$product_id = $col_fields[$fieldname];
if ($product_id != '') {
$product_name = getProductName($product_id);
}
//Account Name View
$label_fld[] = $product_name;
$label_fld["secid"] = $product_id;
$label_fld["link"] = "index.php?module=Products&action=DetailView&record=" . $product_id;
} elseif ($uitype == 61) {
global $adb;
$label_fld[] = getTranslatedString($fieldlabel, $module);
if ($tabid == 10) {
$attach_result = $adb->pquery("select * from vtiger_seattachmentsrel where crmid = ?", array($col_fields['record_id']));
for ($ii = 0; $ii < $adb->num_rows($attach_result); $ii++) {
$attachmentid = $adb->query_result($attach_result, $ii, 'attachmentsid');
if ($attachmentid != '') {
$attachquery = "select * from vtiger_attachments where attachmentsid=?";
$attachmentsname = $adb->query_result($adb->pquery($attachquery, array($attachmentid)), 0, 'name');
if ($attachmentsname != '') {
$custfldval = '<a href = "index.php?module=uploads&action=downloadfile&return_module=' . $col_fields['record_module'] . '&fileid=' . $attachmentid . '&entityid=' . $col_fields['record_id'] . '">' . $attachmentsname . '</a>';
} else {
$custfldval = '';
}
}
$label_fld['options'][] = $custfldval;
}
} else {
$attachmentid = $adb->query_result($adb->pquery("select * from vtiger_seattachmentsrel where crmid = ?", array($col_fields['record_id'])), 0, 'attachmentsid');
if ($col_fields[$fieldname] == '' && $attachmentid != '') {
$attachquery = "select * from vtiger_attachments where attachmentsid=?";
$col_fields[$fieldname] = $adb->query_result($adb->pquery($attachquery, array($attachmentid)), 0, 'name');
}
//This is added to strip the crmid and _ from the file name and show the original filename
//$org_filename = ltrim($col_fields[$fieldname],$col_fields['record_id'].'_');
/* Above line is not required as the filename in the database is stored as it is and doesn't have crmid attached to it.
This was the cause for the issue reported in ticket #4645 */
$org_filename = $col_fields[$fieldname];
// For Backward Compatibility version < 5.0.4
$filename_pos = strpos($org_filename, $col_fields['record_id'] . '_');
if ($filename_pos === 0) {
$start_idx = $filename_pos + strlen($col_fields['record_id'] . '_');
$org_filename = substr($org_filename, $start_idx);
}
if ($org_filename != '') {
if ($col_fields['filelocationtype'] == 'E') {
if ($col_fields['filestatus'] == 1) {
//&& strlen($col_fields['filename']) > 7 ){
$custfldval = '<a target="_blank" href =' . $col_fields['filename'] . ' onclick=\'javascript:dldCntIncrease(' . $col_fields['record_id'] . ');\'>' . $col_fields[$fieldname] . '</a>';
} else {
$custfldval = $col_fields[$fieldname];
}
} elseif ($col_fields['filelocationtype'] == 'I') {
if ($col_fields['filestatus'] == 1) {
$custfldval = '<a href = "index.php?module=uploads&action=downloadfile&return_module=' . $col_fields['record_module'] . '&fileid=' . $attachmentid . '&entityid=' . $col_fields['record_id'] . '" onclick=\'javascript:dldCntIncrease(' . $col_fields['record_id'] . ');\'>' . $col_fields[$fieldname] . '</a>';
} else {
$custfldval = $col_fields[$fieldname];
}
} else {
$custfldval = '';
}
}
$label_fld[] = $custfldval;
}
} elseif ($uitype == 28) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$attachmentid = $adb->query_result($adb->pquery("select * from vtiger_seattachmentsrel where crmid = ?", array($col_fields['record_id'])), 0, 'attachmentsid');
if ($col_fields[$fieldname] == '' && $attachmentid != '') {
$attachquery = "select * from vtiger_attachments where attachmentsid=?";
$col_fields[$fieldname] = $adb->query_result($adb->pquery($attachquery, array($attachmentid)), 0, 'name');
}
$org_filename = $col_fields[$fieldname];
// For Backward Compatibility version < 5.0.4
$filename_pos = strpos($org_filename, $col_fields['record_id'] . '_');
if ($filename_pos === 0) {
$start_idx = $filename_pos + strlen($col_fields['record_id'] . '_');
$org_filename = substr($org_filename, $start_idx);
}
if ($org_filename != '') {
if ($col_fields['filelocationtype'] == 'E') {
if ($col_fields['filestatus'] == 1) {
//&& strlen($col_fields['filename']) > 7 ){
$custfldval = '<a target="_blank" href =' . $col_fields['filename'] . ' onclick=\'javascript:dldCntIncrease(' . $col_fields['record_id'] . ');\'>' . $col_fields[$fieldname] . '</a>';
} else {
$custfldval = $col_fields[$fieldname];
}
} elseif ($col_fields['filelocationtype'] == 'I') {
if ($col_fields['filestatus'] == 1) {
$custfldval = '<a href = "index.php?module=uploads&action=downloadfile&return_module=' . $col_fields['record_module'] . '&fileid=' . $attachmentid . '&entityid=' . $col_fields['record_id'] . '" onclick=\'javascript:dldCntIncrease(' . $col_fields['record_id'] . ');\'>' . $col_fields[$fieldname] . '</a>';
} else {
$custfldval = $col_fields[$fieldname];
}
} else {
$custfldval = '';
}
}
$label_fld[] = $custfldval;
} elseif ($uitype == 69) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
if ($tabid == 14) {
$images = array();
$query = 'select productname, vtiger_attachments.path, vtiger_attachments.attachmentsid, vtiger_attachments.name,vtiger_crmentity.setype from vtiger_products left join vtiger_seattachmentsrel on vtiger_seattachmentsrel.crmid=vtiger_products.productid inner join vtiger_attachments on vtiger_attachments.attachmentsid=vtiger_seattachmentsrel.attachmentsid inner join vtiger_crmentity on vtiger_crmentity.crmid = vtiger_attachments.attachmentsid where vtiger_crmentity.setype="Products Image" and productid=?';
$result_image = $adb->pquery($query, array($col_fields['record_id']));
for ($image_iter = 0; $image_iter < $adb->num_rows($result_image); $image_iter++) {
$image_id_array[] = $adb->query_result($result_image, $image_iter, 'attachmentsid');
//decode_html - added to handle UTF-8 characters in file names
//urlencode - added to handle special characters like #, %, etc.,
$image_array[] = urlencode(decode_html($adb->query_result($result_image, $image_iter, 'name')));
$image_orgname_array[] = decode_html($adb->query_result($result_image, $image_iter, 'name'));
$imagepath_array[] = $adb->query_result($result_image, $image_iter, 'path');
}
if (count($image_array) > 1) {
if (count($image_array) < 4) {
$sides = count($image_array) * 2;
} else {
$sides = 8;
}
$image_lists = '<div id="Carousel" style="position:relative;vertical-align: middle;">
<img src="modules/Products/placeholder.gif" width="571" height="117" style="position:relative;">
</div><script>var Car_NoOfSides=' . $sides . '; Car_Image_Sources=new Array(';
for ($image_iter = 0; $image_iter < count($image_array); $image_iter++) {
$images[] = '"' . $imagepath_array[$image_iter] . $image_id_array[$image_iter] . "_" . $image_array[$image_iter] . '","' . $imagepath_array[$image_iter] . $image_id_array[$image_iter] . "_" . $image_array[$image_iter] . '"';
}
$image_lists .= implode(',', $images) . ');</script><script language="JavaScript" type="text/javascript" src="modules/Products/Productsslide.js"></script><script language="JavaScript" type="text/javascript">Carousel();</script>';
$label_fld[] = $image_lists;
} elseif (count($image_array) == 1) {
list($pro_image_width, $pro_image_height) = getimagesize($imagepath_array[0] . $image_id_array[0] . "_" . $image_orgname_array[0]);
if ($pro_image_width > 450 || $pro_image_height > 300) {
$label_fld[] = '<img src="' . $imagepath_array[0] . $image_id_array[0] . "_" . $image_array[0] . '" border="0" width="450" height="300">';
} else {
$label_fld[] = '<img src="' . $imagepath_array[0] . $image_id_array[0] . "_" . $image_array[0] . '" border="0" width="' . $pro_image_width . '" height="' . $pro_image_height . '">';
}
} else {
$label_fld[] = '';
}
} else {
if ($module == 'Contacts') {
$imageattachment = 'Image';
} else {
$imageattachment = 'Attachment';
}
//$imgpath = getModuleFileStoragePath('Contacts').$col_fields[$fieldname];
$sql = "select vtiger_attachments.*,vtiger_crmentity.setype\n\t\t\t from vtiger_attachments\n\t\t\t inner join vtiger_seattachmentsrel on vtiger_seattachmentsrel.attachmentsid = vtiger_attachments.attachmentsid\n\t\t\t inner join vtiger_crmentity on vtiger_crmentity.crmid = vtiger_attachments.attachmentsid\n\t\t\t where vtiger_crmentity.setype='{$module} {$imageattachment}'\n\t\t\t and vtiger_attachments.name = ?\n\t\t\t and vtiger_seattachmentsrel.crmid=?";
$image_res = $adb->pquery($sql, array($col_fields[$fieldname], $col_fields['record_id']));
$image_id = $adb->query_result($image_res, 0, 'attachmentsid');
$image_path = $adb->query_result($image_res, 0, 'path');
//decode_html - added to handle UTF-8 characters in file names
//urlencode - added to handle special characters like #, %, etc.,
$image_name = urlencode(decode_html($adb->query_result($image_res, 0, 'name')));
$imgpath = $image_path . $image_id . "_" . $image_name;
if ($image_name != '') {
$ftype = $adb->query_result($image_res, 0, 'type');
$isimage = stripos($ftype, 'image') !== false;
if ($isimage) {
$imgtxt = getTranslatedString('SINGLE_' . $module, $module) . ' ' . getTranslatedString('Image');
$label_fld[] = '<img src="' . $imgpath . '" alt="' . $imgtxt . '" title= "' . $imgtxt . '" style="max-width: 500px;">';
} else {
$imgtxt = getTranslatedString('SINGLE_' . $module, $module) . ' ' . getTranslatedString('SINGLE_Documents');
$label_fld[] = '<a href="' . $imgpath . '" alt="' . $imgtxt . '" title= "' . $imgtxt . '">' . $image_name . '</a>';
}
} else {
$label_fld[] = '';
}
}
} elseif ($uitype == 62) {
$value = $col_fields[$fieldname];
if ($value != '') {
$parent_module = getSalesEntityType($value);
if ($parent_module == "Leads") {
$label_fld[] = $app_strings['LBL_LEAD_NAME'];
$displayValueArray = getEntityName($parent_module, $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $field_value) {
$lead_name = $field_value;
}
}
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $lead_name . '</a>';
} elseif ($parent_module == "Accounts") {
$label_fld[] = $app_strings['LBL_ACCOUNT_NAME'];
$sql = "select * from vtiger_account where accountid=?";
$result = $adb->pquery($sql, array($value));
$account_name = $adb->query_result($result, 0, "accountname");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $account_name . '</a>';
} elseif ($parent_module == "Potentials") {
$label_fld[] = $app_strings['LBL_POTENTIAL_NAME'];
$sql = "select * from vtiger_potential where potentialid=?";
$result = $adb->pquery($sql, array($value));
$potentialname = $adb->query_result($result, 0, "potentialname");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $potentialname . '</a>';
} elseif ($parent_module == "Products") {
$label_fld[] = $app_strings['LBL_PRODUCT_NAME'];
$sql = "select * from vtiger_products where productid=?";
$result = $adb->pquery($sql, array($value));
$productname = $adb->query_result($result, 0, "productname");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $productname . '</a>';
} elseif ($parent_module == "PurchaseOrder") {
$label_fld[] = $app_strings['LBL_PORDER_NAME'];
$sql = "select * from vtiger_purchaseorder where purchaseorderid=?";
$result = $adb->pquery($sql, array($value));
$pordername = $adb->query_result($result, 0, "subject");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $pordername . '</a>';
} elseif ($parent_module == "SalesOrder") {
$label_fld[] = $app_strings['LBL_SORDER_NAME'];
$sql = "select * from vtiger_salesorder where salesorderid=?";
$result = $adb->pquery($sql, array($value));
$sordername = $adb->query_result($result, 0, "subject");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $sordername . '</a>';
} elseif ($parent_module == "Invoice") {
$label_fld[] = $app_strings['LBL_INVOICE_NAME'];
$sql = "select * from vtiger_invoice where invoiceid=?";
$result = $adb->pquery($sql, array($value));
$invoicename = $adb->query_result($result, 0, "subject");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $invoicename . '</a>';
} elseif ($parent_module == "Quotes") {
$label_fld[] = $app_strings['LBL_QUOTES_NAME'];
$sql = "select * from vtiger_quotes where quoteid=?";
$result = $adb->pquery($sql, array($value));
$quotename = $adb->query_result($result, 0, "subject");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $quotename . '</a>';
} elseif ($parent_module == "HelpDesk") {
$label_fld[] = $app_strings['LBL_HELPDESK_NAME'];
$sql = "select * from vtiger_troubletickets where ticketid=?";
$result = $adb->pquery($sql, array($value));
$title = $adb->query_result($result, 0, "title");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $title . '</a>';
}
} else {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $value;
}
} elseif ($uitype == 105) {
//Added for user image
$label_fld[] = getTranslatedString($fieldlabel, $module);
//$imgpath = getModuleFileStoragePath('Contacts').$col_fields[$fieldname];
$sql = "select vtiger_attachments.* from vtiger_attachments left join vtiger_salesmanattachmentsrel on vtiger_salesmanattachmentsrel.attachmentsid = vtiger_attachments.attachmentsid where vtiger_salesmanattachmentsrel.smid=?";
$image_res = $adb->pquery($sql, array($col_fields['record_id']));
$image_id = $adb->query_result($image_res, 0, 'attachmentsid');
$image_path = $adb->query_result($image_res, 0, 'path');
$image_name = $adb->query_result($image_res, 0, 'name');
$imgpath = $image_path . $image_id . "_" . $image_name;
if ($image_name != '') {
//Added the following check for the image to retain its in original size.
list($pro_image_width, $pro_image_height) = getimagesize(decode_html($imgpath));
$label_fld[] = '<a href="' . $imgpath . '" target="_blank"><img src="' . $imgpath . '" width="' . $pro_image_width . '" height="' . $pro_image_height . '" alt="' . $col_fields['user_name'] . '" title="' . $col_fields['user_name'] . '" border="0"></a>';
} else {
$label_fld[] = '';
}
} elseif ($uitype == 66) {
$value = $col_fields[$fieldname];
if ($value != '') {
$parent_module = getSalesEntityType($value);
if ($parent_module == "Leads") {
$label_fld[] = $app_strings['LBL_LEAD_NAME'];
$displayValueArray = getEntityName($parent_module, $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $field_value) {
$lead_name = $field_value;
}
}
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $lead_name . '</a>';
} elseif ($parent_module == "Accounts") {
$label_fld[] = $app_strings['LBL_ACCOUNT_NAME'];
$sql = "select * from vtiger_account where accountid=?";
$result = $adb->pquery($sql, array($value));
$account_name = $adb->query_result($result, 0, "accountname");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $account_name . '</a>';
} elseif ($parent_module == "Potentials") {
$label_fld[] = $app_strings['LBL_POTENTIAL_NAME'];
$sql = "select * from vtiger_potential where potentialid=?";
$result = $adb->pquery($sql, array($value));
$potentialname = $adb->query_result($result, 0, "potentialname");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $potentialname . '</a>';
} elseif ($parent_module == "Quotes") {
$label_fld[] = $app_strings['LBL_QUOTE_NAME'];
$sql = "select * from vtiger_quotes where quoteid=?";
$result = $adb->pquery($sql, array($value));
$quotename = $adb->query_result($result, 0, "subject");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $quotename . '</a>';
} elseif ($parent_module == "PurchaseOrder") {
$label_fld[] = $app_strings['LBL_PORDER_NAME'];
$sql = "select * from vtiger_purchaseorder where purchaseorderid=?";
$result = $adb->pquery($sql, array($value));
$pordername = $adb->query_result($result, 0, "subject");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $pordername . '</a>';
} elseif ($parent_module == "SalesOrder") {
$label_fld[] = $app_strings['LBL_SORDER_NAME'];
$sql = "select * from vtiger_salesorder where salesorderid=?";
$result = $adb->pquery($sql, array($value));
$sordername = $adb->query_result($result, 0, "subject");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $sordername . '</a>';
} elseif ($parent_module == "Invoice") {
$label_fld[] = $app_strings['LBL_INVOICE_NAME'];
$sql = "select * from vtiger_invoice where invoiceid=?";
$result = $adb->pquery($sql, array($value));
$invoicename = $adb->query_result($result, 0, "subject");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $invoicename . '</a>';
} elseif ($parent_module == "Campaigns") {
$label_fld[] = $app_strings['LBL_CAMPAIGN_NAME'];
$sql = "select * from vtiger_campaign where campaignid=?";
$result = $adb->pquery($sql, array($value));
$campaignname = $adb->query_result($result, 0, "campaignname");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $campaignname . '</a>';
} elseif ($parent_module == "HelpDesk") {
$label_fld[] = $app_strings['LBL_HELPDESK_NAME'];
$sql = "select * from vtiger_troubletickets where ticketid=?";
$result = $adb->pquery($sql, array($value));
$tickettitle = $adb->query_result($result, 0, "title");
if (strlen($tickettitle) > 25) {
$tickettitle = substr($tickettitle, 0, 25) . '...';
}
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $tickettitle . '</a>';
} elseif ($parent_module == "Vendors") {
//MSL
$label_fld[] = $app_strings['LBL_VENDOR_NAME'];
$sql = "select vendorname from vtiger_vendor where vendorid=?";
$result = $adb->pquery($sql, array($value));
$vendor_name = $adb->query_result($result, 0, "vendorname");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $vendor_name . '</a>';
}
//MSL -------------------------------------------
} else {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $value;
}
} elseif ($uitype == 67) {
$value = $col_fields[$fieldname];
if ($value != '') {
$parent_module = getSalesEntityType($value);
if ($parent_module == "Leads") {
$label_fld[] = $app_strings['LBL_LEAD_NAME'];
$displayValueArray = getEntityName($parent_module, $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $field_value) {
$lead_name = $field_value;
}
}
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $lead_name . '</a>';
} elseif ($parent_module == "Contacts") {
$label_fld[] = $app_strings['LBL_CONTACT_NAME'];
$displayValueArray = getEntityName($parent_module, $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $field_value) {
$contact_name = $field_value;
}
} else {
$contact_name = '';
}
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $contact_name . '</a>';
}
} else {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $value;
}
} elseif ($uitype == 357) {
$value = $col_fields[$fieldname];
if ($value != '') {
$parent_name = '';
$parent_id = '';
$myemailid = $_REQUEST['record'];
$mysql = "select crmid from vtiger_seactivityrel where activityid=?";
$myresult = $adb->pquery($mysql, array($myemailid));
$mycount = $adb->num_rows($myresult);
if ($mycount > 1) {
$label_fld[] = $app_strings['LBL_RELATED_TO'];
$label_fld[] = $app_strings['LBL_MULTIPLE'];
} else {
$parent_module = getSalesEntityType($value);
if ($parent_module == "Leads") {
$label_fld[] = $app_strings['LBL_LEAD_NAME'];
$displayValueArray = getEntityName($parent_module, $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $field_value) {
$lead_name = $field_value;
}
}
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $lead_name . '</a>';
} elseif ($parent_module == "Contacts") {
$label_fld[] = $app_strings['LBL_CONTACT_NAME'];
$displayValueArray = getEntityName($parent_module, $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $field_value) {
$contact_name = $field_value;
}
} else {
$contact_name = '';
}
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $contact_name . '</a>';
} elseif ($parent_module == "Accounts") {
$label_fld[] = $app_strings['LBL_ACCOUNT_NAME'];
$sql = "select * from vtiger_account where accountid=?";
$result = $adb->pquery($sql, array($value));
$accountname = $adb->query_result($result, 0, "accountname");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $accountname . '</a>';
}
}
} else {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $value;
}
} elseif ($uitype == 68) {
$value = $col_fields[$fieldname];
if ($value != '') {
$parent_module = getSalesEntityType($value);
if ($parent_module == "Contacts") {
$label_fld[] = $app_strings['LBL_CONTACT_NAME'];
$displayValueArray = getEntityName($parent_module, $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $key => $field_value) {
$contact_name = $field_value;
}
} else {
$contact_name = '';
}
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $contact_name . '</a>';
} elseif ($parent_module == "Accounts") {
$label_fld[] = $app_strings['LBL_ACCOUNT_NAME'];
$sql = "select * from vtiger_account where accountid=?";
$result = $adb->pquery($sql, array($value));
$account_name = $adb->query_result($result, 0, "accountname");
$label_fld[] = '<a href="index.php?module=' . $parent_module . '&action=DetailView&record=' . $value . '">' . $account_name . '</a>';
} else {
$value = '';
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $value;
}
} else {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $value;
}
} elseif ($uitype == 63) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $col_fields[$fieldname] . 'h ' . $col_fields['duration_minutes'] . 'm';
} elseif ($uitype == 6) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
if ($col_fields[$fieldname] == '0') {
$col_fields[$fieldname] = '';
}
if ($col_fields['time_start'] != '') {
$start_time = $col_fields['time_start'];
}
$dateValue = $col_fields[$fieldname];
if ($col_fields[$fieldname] == '0000-00-00' || empty($dateValue)) {
$displayValue = '';
} else {
if (empty($start_time) && strpos($col_fields[$fieldname], ' ') == false) {
$displayValue = DateTimeField::convertToUserFormat($col_fields[$fieldname]);
} else {
if (!empty($start_time)) {
$date = new DateTimeField($col_fields[$fieldname] . ' ' . $start_time);
} else {
$date = new DateTimeField($col_fields[$fieldname]);
}
$displayValue = $date->getDisplayDateTimeValue();
}
}
$label_fld[] = $displayValue;
} elseif ($uitype == 5 || $uitype == 23 || $uitype == 70) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$dateValue = $col_fields[$fieldname];
if ($col_fields['time_end'] != '' && ($tabid == 9 || $tabid == 16) && $uitype == 23) {
$end_time = $col_fields['time_end'];
}
if ($dateValue == '0000-00-00' || empty($dateValue)) {
$displayValue = '';
} else {
if (empty($end_time) && strpos($dateValue, ' ') == false) {
$displayValue = DateTimeField::convertToUserFormat($col_fields[$fieldname]);
} else {
if (!empty($end_time)) {
$date = new DateTimeField($col_fields[$fieldname] . ' ' . $end_time);
} else {
$date = new DateTimeField($col_fields[$fieldname]);
}
$displayValue = $date->getDisplayDateTimeValue();
}
}
$label_fld[] = $displayValue;
} elseif ($uitype == 71 || $uitype == 72) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$currencyField = new CurrencyField($col_fields[$fieldname]);
if ($uitype == 72) {
// Some of the currency fields like Unit Price, Total, Sub-total etc of Inventory modules, do not need currency conversion
if ($fieldname == 'unit_price') {
$rate_symbol = getCurrencySymbolandCRate(getProductBaseCurrency($col_fields['record_id'], $module));
$label_fld[] = $currencyField->getDisplayValue(null, true);
$label_fld["cursymb"] = $rate_symbol['symbol'];
} else {
$currency_info = getInventoryCurrencyInfo($module, $col_fields['record_id']);
$label_fld[] = $currencyField->getDisplayValue(null, true);
$label_fld["cursymb"] = $currency_info['currency_symbol'];
}
} else {
$label_fld[] = $currencyField->getDisplayValue();
$label_fld["cursymb"] = $currencyField->getCurrencySymbol();
}
} elseif ($uitype == 75 || $uitype == 81) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$vendor_id = $col_fields[$fieldname];
if ($vendor_id != '') {
$vendor_name = getVendorName($vendor_id);
}
$label_fld[] = $vendor_name;
$label_fld["secid"] = $vendor_id;
$label_fld["link"] = "index.php?module=Vendors&action=DetailView&record=" . $vendor_id;
} elseif ($uitype == 76) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$potential_id = $col_fields[$fieldname];
if ($potential_id != '') {
$potential_name = getPotentialName($potential_id);
}
$label_fld[] = $potential_name;
$label_fld["secid"] = $potential_id;
$label_fld["link"] = "index.php?module=Potentials&action=DetailView&record=" . $potential_id;
} elseif ($uitype == 78) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$quote_id = $col_fields[$fieldname];
if ($quote_id != '') {
$quote_name = getQuoteName($quote_id);
}
$label_fld[] = $quote_name;
$label_fld["secid"] = $quote_id;
$label_fld["link"] = "index.php?module=Quotes&action=DetailView&record=" . $quote_id;
} elseif ($uitype == 79) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$purchaseorder_id = $col_fields[$fieldname];
if ($purchaseorder_id != '') {
$purchaseorder_name = getPoName($purchaseorder_id);
}
$label_fld[] = $purchaseorder_name;
$label_fld["secid"] = $purchaseorder_id;
$label_fld["link"] = "index.php?module=PurchaseOrder&action=DetailView&record=" . $purchaseorder_id;
} elseif ($uitype == 80) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$salesorder_id = $col_fields[$fieldname];
if ($salesorder_id != '') {
$salesorder_name = getSoName($salesorder_id);
}
$label_fld[] = $salesorder_name;
$label_fld["secid"] = $salesorder_id;
$label_fld["link"] = "index.php?module=SalesOrder&action=DetailView&record=" . $salesorder_id;
} elseif ($uitype == 30) {
$rem_days = 0;
$rem_hrs = 0;
$rem_min = 0;
$reminder_str = "";
$rem_days = floor($col_fields[$fieldname] / (24 * 60));
$rem_hrs = floor(($col_fields[$fieldname] - $rem_days * 24 * 60) / 60);
$rem_min = ($col_fields[$fieldname] - $rem_days * 24 * 60) % 60;
$label_fld[] = getTranslatedString($fieldlabel, $module);
if ($col_fields[$fieldname]) {
$reminder_str = $rem_days . ' ' . $mod_strings['LBL_DAYS'] . ' ' . $rem_hrs . ' ' . $mod_strings['LBL_HOURS'] . ' ' . $rem_min . ' ' . $mod_strings['LBL_MINUTES'] . ' ' . $mod_strings['LBL_BEFORE_EVENT'];
}
$label_fld[] = ' ' . $reminder_str;
} elseif ($uitype == 98) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
if (is_admin($current_user)) {
$label_fld[] = '<a href="index.php?module=Settings&action=RoleDetailView&roleid=' . $col_fields[$fieldname] . '">' . getRoleName($col_fields[$fieldname]) . '</a>';
} else {
$label_fld[] = getRoleName($col_fields[$fieldname]);
}
} elseif ($uitype == 85) {
//Added for Skype by Minnie
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $col_fields[$fieldname];
} elseif ($uitype == 26) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$query = "select foldername from vtiger_attachmentsfolder where folderid = ?";
$result = $adb->pquery($query, array($col_fields[$fieldname]));
$folder_name = $adb->query_result($result, 0, "foldername");
$label_fld[] = $folder_name;
} elseif ($uitype == 27) {
if ($col_fields[$fieldname] == 'I') {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $mod_strings['LBL_INTERNAL'];
} else {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $mod_strings['LBL_EXTERNAL'];
}
} elseif ($uitype == 31) {
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = $col_fields[$fieldname];
$options = array();
$themeList = get_themes();
foreach ($themeList as $theme) {
if ($current_user->theme == $theme) {
$selected = 'selected';
} else {
$selected = '';
}
$options[] = array(getTranslatedString($theme), $theme, $selected);
}
$label_fld["options"] = $options;
} elseif ($uitype == 32) {
$options = array();
$languageList = Vtiger_Language::getAll();
$label_fld[] = getTranslatedString($fieldlabel, $module);
$label_fld[] = isset($languageList[$col_fields[$fieldname]]) ? $languageList[$col_fields[$fieldname]] : $col_fields[$fieldname];
foreach ($languageList as $prefix => $label) {
if ($current_user->language == $prefix) {
$selected = 'selected';
} else {
$selected = '';
}
$options[] = array(getTranslatedString($label), $prefix, $selected);
}
$label_fld["options"] = $options;
} else {
$label_fld[] = getTranslatedString($fieldlabel, $module);
if ($col_fields[$fieldname] == '0' && $fieldname != 'filedownloadcount' && $fieldname != 'filestatus' && $fieldname != 'filesize') {
$col_fields[$fieldname] = '';
}
//code for Documents module :start
if ($tabid == 8) {
$downloadtype = $col_fields['filelocationtype'];
if ($fieldname == 'filename') {
if ($downloadtype == 'I') {
//$file_value = $mod_strings['LBL_INTERNAL'];
$fld_value = $col_fields['filename'];
$ext_pos = strrpos($fld_value, ".");
$ext = substr($fld_value, $ext_pos + 1);
$ext = strtolower($ext);
if ($ext == 'bin' || $ext == 'exe' || $ext == 'rpm') {
$fileicon = "<img src='" . vtiger_imageurl('fExeBin.gif', $theme) . "' hspace='3' align='absmiddle' border='0'>";
} elseif ($ext == 'jpg' || $ext == 'gif' || $ext == 'bmp') {
$fileicon = "<img src='" . vtiger_imageurl('fbImageFile.gif', $theme) . "' hspace='3' align='absmiddle' border='0'>";
} elseif ($ext == 'txt' || $ext == 'doc' || $ext == 'xls') {
$fileicon = "<img src='" . vtiger_imageurl('fbTextFile.gif', $theme) . "' hspace='3' align='absmiddle' border='0'>";
} elseif ($ext == 'zip' || $ext == 'gz' || $ext == 'rar') {
$fileicon = "<img src='" . vtiger_imageurl('fbZipFile.gif', $theme) . "' hspace='3' align='absmiddle'\tborder='0'>";
} else {
$fileicon = "<img src='" . vtiger_imageurl('fbUnknownFile.gif', $theme) . "' hspace='3' align='absmiddle' border='0'>";
}
} else {
$fld_value = $col_fields['filename'];
$fileicon = "<img src='" . vtiger_imageurl('fbLink.gif', $theme) . "' alt='" . $mod_strings['LBL_EXTERNAL_LNK'] . "' title='" . $mod_strings['LBL_EXTERNAL_LNK'] . "' hspace='3' align='absmiddle' border='0'>";
}
$label_fld[] = $fileicon . $fld_value;
}
if ($fieldname == 'filesize') {
if ($col_fields['filelocationtype'] == 'I') {
$filesize = $col_fields[$fieldname];
if ($filesize < 1024) {
$label_fld[] = $filesize . ' B';
} elseif ($filesize > 1024 && $filesize < 1048576) {
$label_fld[] = round($filesize / 1024, 2) . ' KB';
} else {
if ($filesize > 1048576) {
$label_fld[] = round($filesize / (1024 * 1024), 2) . ' MB';
}
}
} else {
$label_fld[] = ' --';
}
}
if ($fieldname == 'filetype' && $col_fields['filelocationtype'] == 'E') {
$label_fld[] = ' --';
}
/* if($fieldname == 'filestatus')
{
$filestatus = $col_fields[$fieldname];
if($filestatus == 0)
$label_fld[]=$mod_strings['LBL_ACTIVE'];
else
$label_fld[]=$mod_strings['LBL_INACTIVE'];
} */
}
//code for Documents module :end
$label_fld[] = $col_fields[$fieldname];
}
}
$label_fld[] = $uitype;
//sets whether the currenct user is admin or not
if (is_admin($current_user)) {
$label_fld["isadmin"] = 1;
} else {
$label_fld["isadmin"] = 0;
}
$log->debug("Exiting getDetailViewOutputHtml method ...");
return $label_fld;
}
