retrieve_entity_info($_REQUEST['record'],"HelpDesk"); $focus->name=$focus->column_fields['ticket_title']; } if(isset($_REQUEST['isDuplicate']) && $_REQUEST['isDuplicate'] == 'true') { $focus->id = ""; } //Added code for Error display in sending mail to assigned to user when ticket is created or updated. if($_REQUEST['message'] != '' && $_REQUEST['message'] != 1 && $focus->column_fields['assigned_user_id'] != 0) { $error_message = '

Mail could not be sent to "Assigned To" user. '; if(@strstr($_REQUEST['message'],'Language string failed to load: connect_host')) $error_message .= 'Please check the mail server.'; elseif(@strstr($_REQUEST['message'],'Language string failed to load: recipients_failed')) $error_message .= 'Please check the "Assigned to" email id.'; $error_message .= '

'; echo $error_message; } global $app_strings; global $app_list_strings; global $mod_strings; global $current_user; global $theme; $theme_path="themes/".$theme."/"; $image_path=$theme_path."images/"; require_once($theme_path.'layout_utils.php'); $xtpl=new XTemplate ('modules/HelpDesk/DetailView.html'); $xtpl->assign("MOD", $mod_strings); $xtpl->assign("APP", $app_strings); if (isset($focus->name)) $xtpl->assign("NAME", $focus->name); else $xtpl->assign("NAME", ""); $xtpl->assign("TICKETID", $_REQUEST['record']); $block_1 = getDetailBlockInformation("HelpDesk",1,$focus->column_fields); $xtpl->assign("BLOCK1", $block_1); $block_2 = getDetailBlockInformation("HelpDesk",2,$focus->column_fields); $xtpl->assign("BLOCK2", $block_2); $block_3 = getDetailBlockInformation("HelpDesk",3,$focus->column_fields); $xtpl->assign("BLOCK3", $block_3); $block_1_header = getBlockTableHeader("LBL_TICKET_INFORMATION"); $block_3_header = getBlockTableHeader("LBL_DESCRIPTION_INFORMATION"); $xtpl->assign("BLOCK1_HEADER", $block_1_header); $xtpl->assign("BLOCK3_HEADER", $block_3_header); $block_4 = getDetailBlockInformation("HelpDesk",4,$focus->column_fields); $block_4_header = getBlockTableHeader("LBL_TICKET_RESOLUTION"); $xtpl->assign("BLOCK4", $block_4); $xtpl->assign("BLOCK4_HEADER", $block_4_header); $block_6 = getCommentInformation($_REQUEST['record']); if($block_6 != '') { $block_6_header = getBlockTableHeader("LBL_COMMENTS"); $xtpl->assign("BLOCK6", $block_6); $xtpl->assign("BLOCK6_HEADER", $block_6_header); } $block_5 = getDetailBlockInformation("HelpDesk",5,$focus->column_fields); if(trim($block_5) != '') { $cust_fld = ''; $cust_fld .= '
'; $block_5_header = getBlockTableHeader("LBL_CUSTOM_INFORMATION"); $cust_fld .= $block_5_header; $cust_fld .= ''; $cust_fld .= $block_5; $cust_fld .= '
'; $cust_fld .= '
'; $cust_fld .= '
'; } $xtpl->assign("CUSTOMFIELD", $cust_fld); $permissionData = $_SESSION['action_permission_set']; if(isPermitted("HelpDesk",1,$_REQUEST['record']) == 'yes') { $xtpl->assign("EDITBUTTON",""); $xtpl->assign("DUPLICATEBUTTON",""); } if(isPermitted("HelpDesk",2,$_REQUEST['record']) == 'yes') { $xtpl->assign("DELETEBUTTON",""); } $xtpl->assign("IMAGE_PATH", $image_path); $xtpl->assign("PRINT_URL", "phprint.php?jt=".session_id().$GLOBALS['request_string']); $xtpl->assign("ID", $_REQUEST['record']); if(isPermitted("HelpDesk",8,'') == 'yes') { $xtpl->assign("MERGEBUTTON",""); require_once('modules/Users/UserInfoUtil.php'); $wordTemplateResult = fetchWordTemplateList("HelpDesk"); $tempCount = $adb->num_rows($wordTemplateResult); $tempVal = $adb->fetch_array($wordTemplateResult); for($templateCount=0;$templateCount<$tempCount;$templateCount++) { $optionString .=""; $tempVal = $adb->fetch_array($wordTemplateResult); } $xtpl->assign("WORDTEMPLATEOPTIONS","  ".$app_strings['LBL_SELECT_TEMPLATE_TO_MAIL_MERGE'].""); } $xtpl->parse("main"); $xtpl->out("main"); //Security check for related list global $profile_id; $tab_per_Data = getAllTabsPermission($profile_id); $permissionData = $_SESSION['action_permission_set']; $focus->id = $_REQUEST['record']; getRelatedLists("HelpDesk",$focus); Get_Ticket_History(); function getCommentInformation($ticketid) { global $adb; global $mod_strings; $sql = "select * from ticketcomments where ticketid=".$ticketid; $result = $adb->query($sql); $noofrows = $adb->num_rows($result); if($noofrows == 0) return ''; $list .= '
'; for($i=0;$i<$noofrows;$i++) { if($adb->query_result($result,$i,'comments') != '') { $list .= '
'; $list .= nl2br($adb->query_result($result,$i,'comments')); $list .= '
'; $list .= $mod_strings['LBL_AUTHOR'].' : '; if($adb->query_result($result,$i,'ownertype') == 'user') $list .= getUserName($adb->query_result($result,$i,'ownerid')); else $list .= getCustomerName($ticketid); $list .= ' on '.$adb->query_result($result,$i,'createdtime').'  '; $list .= '
'; } } $list .= '
'; return $list; } function getCustomerName($id) { global $adb; $sql = "select * from PortalInfo inner join troubletickets on troubletickets.parent_id = PortalInfo.id where troubletickets.ticketid=".$id; $result = $adb->query($sql); $customername = $adb->query_result($result,0,'user_name'); return $customername; } //Constructing the Related Lists from here /* if($tab_per_Data[2] == 0) { if($permissionData[2][3] == 0) { $focus->get_opportunities($_REQUEST['record']); } } $focus->get_activities($_REQUEST['record']); if($tab_per_Data[8] == 0) { if($permissionData[8][3] == 0) { $focus->get_attachments($_REQUEST['record']); } } require_once('modules/Products/binaryfilelist.php'); echo '

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '
'; echo '
'.$mod_strings['LBL_ATTACHMENTS'].'
  
'; echo getAttachmentsList($productid, $theme); echo "
\n"; echo "
\n"; require_once('include/RelatedTicketListUtil.php'); $list = getTicketList($productid, "Products", $image_path,$theme); echo $list; // Stick on the form footer echo get_form_footer(); */ ?>