You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
152 lines
5.6 KiB
152 lines
5.6 KiB
<?php
|
|
|
|
/*********************************************************************************
|
|
** The contents of this file are subject to the vtiger CRM Public License Version 1.0
|
|
* ("License"); You may not use this file except in compliance with the License
|
|
* The Original Code is: vtiger CRM Open Source
|
|
* The Initial Developer of the Original Code is vtiger.
|
|
* Portions created by vtiger are Copyright (C) vtiger.
|
|
* All Rights Reserved.
|
|
*
|
|
********************************************************************************/
|
|
|
|
require_once('include/database/PearDatabase.php');
|
|
|
|
//or die("Couldn't connect to database $dbDatabase");
|
|
|
|
function getTicketList($id,$module,$image_path,$theme)
|
|
{
|
|
|
|
global $app_strings,$adb;
|
|
if($module == "Contacts")
|
|
{
|
|
$dbQuery = "select troubletickets.id,groupname,priority,troubletickets.status,parent_id,parent_type,category,troubletickets.title,troubletickets.assigned_user_id,users.user_name from troubletickets left join users on troubletickets.assigned_user_id=users.id where troubletickets.deleted=0 and troubletickets.status !='Closed' and contact_id='".$id."'";
|
|
}
|
|
else
|
|
{
|
|
$dbQuery = "select troubletickets.id,groupname,priority,troubletickets.status,parent_id,parent_type,category,troubletickets.title,troubletickets.assigned_user_id,users.user_name from troubletickets left join users on troubletickets.assigned_user_id=users.id where troubletickets.deleted=0 and troubletickets.status !='Closed' and parent_type='".$module."' and parent_id='".$id."'";
|
|
}
|
|
$result = $adb->query($dbQuery);
|
|
|
|
$list = '<br><br>';
|
|
$list .= '<table width="100%" cellpadding="0" cellspacing="0" border="0"><tbody><tr>';
|
|
$list .= '<form border="0" action="index.php" method="post" name="form" id="form">';
|
|
|
|
$list .= '<input type="hidden" name="module">';
|
|
$list .= '<input type="hidden" name="return_module" value="'.$module.'">';
|
|
$list .= '<input type="hidden" name="return_id" value="'.$id.'">';
|
|
if($module == "Products")
|
|
{
|
|
$list .= '<input type="hidden" name="return_action" value="ProductDetailView">';
|
|
}
|
|
else
|
|
{
|
|
$list .= '<input type="hidden" name="return_action" value="DetailView">';
|
|
}
|
|
$list .= '<input type="hidden" name="action">';
|
|
|
|
$list .= '<td>';
|
|
$list .= '<table cellpadding="0" cellspacing="0" border="0"><tbody><tr>
|
|
<td class="formHeader" vAlign="top" align="left" height="20">
|
|
<img src="' .$image_path. '/left_arc.gif" border="0"></td>
|
|
|
|
<td class="formHeader" vAlign="middle" background="' . $image_path. '/header_tile.gif" align="left" noWrap width="100%" height="20">Tickets</td>
|
|
<td class="formHeader" vAlign="top" align="right" height="20">
|
|
<img src="' .$image_path. '/right_arc.gif" border="0"></td>
|
|
</tr></tbody></table>
|
|
</td>';
|
|
$list .= '<td> </td>';
|
|
$list .= '<td> </td>';
|
|
$list .="<input type='hidden' name='contact_id' value='".$id."'>";
|
|
$list .= '<td valign="bottom"><input title="New Ticket" accessyKey="F" class="button" onclick="this.form.action.value=\'CreateTicket\';this.form.module.value=\'HelpDesk\'" type="submit" name="button" value="'.$app_strings['LBL_NEW_TICKET'].'"></td>';
|
|
$list .= '<td width="100%"></td>';
|
|
|
|
$list .= '</td></tr></form></tbody></table>';
|
|
|
|
$list .= '<table border="0" cellpadding="0" cellspacing="0" class="FormBorder" width="100%">';
|
|
|
|
$list .= '<tr class="ModuleListTitle" height=20>';
|
|
|
|
$list .= '';
|
|
|
|
$list .= '<td class="moduleListTitle" height="21" style="padding:0px 3px 0px 3px;">';
|
|
|
|
|
|
$list .= $app_strings['LBL_TITLE'].'</td>';
|
|
$list .= '<td WIDTH="1" class="blackLine"><IMG SRC="themes/'.$theme.'/images/blank.gif">';
|
|
$list .= '<td class="moduleListTitle" style="padding:0px 3px 0px 3px;">';
|
|
|
|
|
|
$list .= $app_strings['LBL_PRIORITY'].'</td>';
|
|
$list .= '<td WIDTH="1" class="blackLine"><IMG SRC="themes/'.$theme.'/images/blank.gif">';
|
|
$list .= '<td class="moduleListTitle" style="padding:0px 3px 0px 3px;">';
|
|
|
|
|
|
|
|
$list .= $app_strings['LBL_STATUS'].'</td>';
|
|
$list .= '<td WIDTH="1" class="blackLine"><IMG SRC="themes/'.$theme.'/images/blank.gif">';
|
|
$list .= '<td class="moduleListTitle" style="padding:0px 3px 0px 3px;">';
|
|
|
|
|
|
$list .= $app_strings['LBL_GROUP_NAME'].'</td>';
|
|
|
|
$list .= '<td WIDTH="1" class="blackLine"><IMG SRC="themes/'.$theme.'/images/blank.gif">';
|
|
$list .= '<td class="moduleListTitle" style="padding:0px 3px 0px 3px;">';
|
|
|
|
$list .= $app_strings['LBL_LIST_ASSIGNED_USER'].'</td>';
|
|
|
|
|
|
$list .= '</tr>';
|
|
|
|
//$list .= '<tr><td COLSPAN="7" class="blackLine"><IMG SRC="themes/'.$theme.'/images//blank.gif"></td></tr>';
|
|
|
|
$i=1;
|
|
while($row = $adb->fetch_array($result))
|
|
{
|
|
|
|
|
|
if ($i%2==0)
|
|
$trowclass = 'evenListRow';
|
|
else
|
|
$trowclass = 'oddListRow';
|
|
$list .= '<tr class="'. $trowclass.'"><td height="21" style="padding:0px 3px 0px 3px;">';
|
|
$subject = '<a href="index.php?action=TicketInfoView&module=HelpDesk&record='.$row['id'].'">'.$row["title"].'</a>';
|
|
|
|
$list .= $subject;
|
|
|
|
$list .= '</td>';
|
|
|
|
|
|
$list .= '<td WIDTH="1" class="blackLine"><IMG SRC="themes/'.$theme.'/images/blank.gif"></td><td height="21" style="padding:0px 3px 0px 3px;">';
|
|
|
|
$list .= $row["priority"];
|
|
|
|
$list .= '</td>';
|
|
|
|
|
|
$list .= '<td WIDTH="1" class="blackLine"><IMG SRC="themes/'.$theme.'/images/blank.gif"></td><td height="21" style="padding:0px 3px 0px 3px;">';
|
|
|
|
$list .= $row["status"];
|
|
|
|
$list .= '</td>';
|
|
|
|
|
|
$list .= '<td WIDTH="1" class="blackLine"><IMG SRC="themes/'.$theme.'/images/blank.gif"></td><td height="21" style="padding:0px 3px 0px 3px;">';
|
|
|
|
$list .= $row["groupname"];
|
|
|
|
$list .= '</td>';
|
|
|
|
|
|
$list .= '<td WIDTH="1" class="blackLine"><IMG SRC="themes/'.$theme.'/images/blank.gif"></td><td height="21" style="padding:0px 3px 0px 3px;">';
|
|
|
|
$list .= $row["user_name"];
|
|
|
|
$list .= '</td></tr>';
|
|
$i++;
|
|
}
|
|
$list .= '</table>';
|
|
|
|
return $list;
|
|
}
|
|
?>
|
|
|