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 .= ' ';
}
$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["filename"] ." ";
$tempVal = $adb->fetch_array($wordTemplateResult);
}
$xtpl->assign("WORDTEMPLATEOPTIONS"," ".$app_strings['LBL_SELECT_TEMPLATE_TO_MAIL_MERGE']."".$optionString." ");
}
$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 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();
*/
?>