Created
November 29, 2014 07:18
-
-
Save a-bennett/ecaef7d22c4a9d575385 to your computer and use it in GitHub Desktop.
OsTicket 1.9.4 - Ticket View with Due Date Column
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /* | |
| * OsTicket 1.9.4 | |
| * Edited by: Andrew Bennett - http://andrewbennett.com.au | |
| * Show Due Date Column and allow sorting | |
| * Remember to backup your orginal ticket.inc.php file! | |
| * This file goes into the following folder: /[osticket-install]/include/staff/tickets.inc.php | |
| */ | |
| if(!defined('OSTSCPINC') || !$thisstaff || !@$thisstaff->isStaff()) die('Access Denied'); | |
| $qstr='&'; //Query string collector | |
| if($_REQUEST['status']) { //Query string status has nothing to do with the real status used below; gets overloaded. | |
| $qstr.='status='.urlencode($_REQUEST['status']); | |
| } | |
| //See if this is a search | |
| $search=($_REQUEST['a']=='search'); | |
| $searchTerm=''; | |
| //make sure the search query is 3 chars min...defaults to no query with warning message | |
| if($search) { | |
| $searchTerm=$_REQUEST['query']; | |
| if( ($_REQUEST['query'] && strlen($_REQUEST['query'])<3) | |
| || (!$_REQUEST['query'] && isset($_REQUEST['basic_search'])) ){ //Why do I care about this crap... | |
| $search=false; //Instead of an error page...default back to regular query..with no search. | |
| $errors['err']=__('Search term must be more than 3 chars'); | |
| $searchTerm=''; | |
| } | |
| } | |
| $showoverdue=$showanswered=false; | |
| $staffId=0; //Nothing for now...TODO: Allow admin and manager to limit tickets to single staff level. | |
| $showassigned= true; //show Assigned To column - defaults to true | |
| //Get status we are actually going to use on the query...making sure it is clean! | |
| $status=null; | |
| switch(strtolower($_REQUEST['status'])){ //Status is overloaded | |
| case 'open': | |
| $status='open'; | |
| $results_type=__('Open Tickets'); | |
| break; | |
| case 'closed': | |
| $status='closed'; | |
| $results_type=__('Closed Tickets'); | |
| $showassigned=true; //closed by. | |
| break; | |
| case 'overdue': | |
| $status='open'; | |
| $showoverdue=true; | |
| $results_type=__('Overdue Tickets'); | |
| break; | |
| case 'assigned': | |
| $status='open'; | |
| $staffId=$thisstaff->getId(); | |
| $results_type=__('My Tickets'); | |
| break; | |
| case 'answered': | |
| $status='open'; | |
| $showanswered=true; | |
| $results_type=__('Answered Tickets'); | |
| break; | |
| default: | |
| if (!$search && !isset($_REQUEST['advsid'])) { | |
| $_REQUEST['status']=$status='open'; | |
| $results_type=__('Open Tickets'); | |
| } | |
| } | |
| $qwhere =''; | |
| /* | |
| STRICT DEPARTMENTS BASED PERMISSION! | |
| User can also see tickets assigned to them regardless of the ticket's dept. | |
| */ | |
| $depts=$thisstaff->getDepts(); | |
| $qwhere =' WHERE ( ' | |
| .' ( ticket.staff_id='.db_input($thisstaff->getId()) | |
| .' AND status.state="open") '; | |
| if(!$thisstaff->showAssignedOnly()) | |
| $qwhere.=' OR ticket.dept_id IN ('.($depts?implode(',', db_input($depts)):0).')'; | |
| if(($teams=$thisstaff->getTeams()) && count(array_filter($teams))) | |
| $qwhere.=' OR (ticket.team_id IN ('.implode(',', db_input(array_filter($teams))) | |
| .') AND status.state="open") '; | |
| $qwhere .= ' )'; | |
| //STATUS to states | |
| $states = array( | |
| 'open' => array('open'), | |
| 'closed' => array('closed')); | |
| if($status && isset($states[$status])) { | |
| $qwhere.=' AND status.state IN ( | |
| '.implode(',', db_input($states[$status])).' ) '; | |
| } | |
| if (isset($_REQUEST['uid']) && $_REQUEST['uid']) { | |
| $qwhere .= ' AND (ticket.user_id='.db_input($_REQUEST['uid']) | |
| .' OR collab.user_id='.db_input($_REQUEST['uid']).') '; | |
| $qstr .= '&uid='.urlencode($_REQUEST['uid']); | |
| } | |
| //Queues: Overloaded sub-statuses - you've got to just have faith! | |
| if($staffId && ($staffId==$thisstaff->getId())) { //My tickets | |
| $results_type=__('Assigned Tickets'); | |
| $qwhere.=' AND ticket.staff_id='.db_input($staffId); | |
| $showassigned=false; //My tickets...already assigned to the staff. | |
| }elseif($showoverdue) { //overdue | |
| $qwhere.=' AND ticket.isoverdue=1 '; | |
| }elseif($showanswered) { ////Answered | |
| $qwhere.=' AND ticket.isanswered=1 '; | |
| }elseif(!strcasecmp($status, 'open') && !$search) { //Open queue (on search OPEN means all open tickets - regardless of state). | |
| //Showing answered tickets on open queue?? | |
| if(!$cfg->showAnsweredTickets()) | |
| $qwhere.=' AND ticket.isanswered=0 '; | |
| /* Showing assigned tickets on open queue? | |
| Don't confuse it with show assigned To column -> F'it it's confusing - just trust me! | |
| */ | |
| if(!($cfg->showAssignedTickets() || $thisstaff->showAssignedTickets())) { | |
| $qwhere.=' AND ticket.staff_id=0 '; //XXX: NOT factoring in team assignments - only staff assignments. | |
| $showassigned=false; //Not showing Assigned To column since assigned tickets are not part of open queue | |
| } | |
| } | |
| //Search?? Somebody...get me some coffee | |
| $deep_search=false; | |
| $order_by=$order=null; | |
| if($search): | |
| $qstr.='&a='.urlencode($_REQUEST['a']); | |
| $qstr.='&t='.urlencode($_REQUEST['t']); | |
| //query | |
| if($searchTerm){ | |
| $qstr.='&query='.urlencode($searchTerm); | |
| $queryterm=db_real_escape($searchTerm,false); //escape the term ONLY...no quotes. | |
| if (is_numeric($searchTerm)) { | |
| $qwhere.=" AND ticket.`number` LIKE '$queryterm%'"; | |
| } elseif (strpos($searchTerm,'@') && Validator::is_email($searchTerm)) { | |
| //pulling all tricks! | |
| # XXX: What about searching for email addresses in the body of | |
| # the thread message | |
| $qwhere.=" AND email.address='$queryterm'"; | |
| } else {//Deep search! | |
| //This sucks..mass scan! search anything that moves! | |
| require_once(INCLUDE_DIR.'ajax.tickets.php'); | |
| $tickets = TicketsAjaxApi::_search(array('query'=>$queryterm)); | |
| if (count($tickets)) { | |
| $ticket_ids = implode(',',db_input($tickets)); | |
| $qwhere .= ' AND ticket.ticket_id IN ('.$ticket_ids.')'; | |
| $order_by = 'FIELD(ticket.ticket_id, '.$ticket_ids.')'; | |
| $order = ' '; | |
| } | |
| else | |
| // No hits -- there should be an empty list of results | |
| $qwhere .= ' AND false'; | |
| } | |
| } | |
| endif; | |
| if ($_REQUEST['advsid'] && isset($_SESSION['adv_'.$_REQUEST['advsid']])) { | |
| $ticket_ids = implode(',', db_input($_SESSION['adv_'.$_REQUEST['advsid']])); | |
| $qstr.='advsid='.$_REQUEST['advsid']; | |
| $qwhere .= ' AND ticket.ticket_id IN ('.$ticket_ids.')'; | |
| // Thanks, http://stackoverflow.com/a/1631794 | |
| $order_by = 'FIELD(ticket.ticket_id, '.$ticket_ids.')'; | |
| $order = ' '; | |
| } | |
| $sortOptions=array('date'=>'effective_date','duedate'=>'duedate','ID'=>'ticket.`number`*1', | |
| 'pri'=>'pri.priority_urgency','name'=>'user.name','subj'=>'cdata.subject', | |
| 'status'=>'status.name','assignee'=>'assigned','staff'=>'staff', | |
| 'dept'=>'dept.dept_name'); | |
| $orderWays=array('DESC'=>'DESC','ASC'=>'ASC'); | |
| //Sorting options... | |
| $queue = isset($_REQUEST['status'])?strtolower($_REQUEST['status']):$status; | |
| if($_REQUEST['sort'] && $sortOptions[$_REQUEST['sort']]) | |
| $order_by =$sortOptions[$_REQUEST['sort']]; | |
| elseif($sortOptions[$_SESSION[$queue.'_tickets']['sort']]) { | |
| $_REQUEST['sort'] = $_SESSION[$queue.'_tickets']['sort']; | |
| $_REQUEST['order'] = $_SESSION[$queue.'_tickets']['order']; | |
| $order_by = $sortOptions[$_SESSION[$queue.'_tickets']['sort']]; | |
| $order = $_SESSION[$queue.'_tickets']['order']; | |
| } | |
| if($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) | |
| $order=$orderWays[strtoupper($_REQUEST['order'])]; | |
| //Save sort order for sticky sorting. | |
| if($_REQUEST['sort'] && $queue) { | |
| $_SESSION[$queue.'_tickets']['sort'] = $_REQUEST['sort']; | |
| $_SESSION[$queue.'_tickets']['order'] = $_REQUEST['order']; | |
| } | |
| //Set default sort by columns. | |
| if(!$order_by ) { | |
| if($showanswered) | |
| $order_by='ticket.lastresponse, ticket.created'; //No priority sorting for answered tickets. | |
| elseif(!strcasecmp($status,'closed')) | |
| $order_by='ticket.closed, ticket.created'; //No priority sorting for closed tickets. | |
| elseif($showoverdue) //priority> duedate > age in ASC order. | |
| $order_by='pri.priority_urgency ASC, ISNULL(ticket.duedate) ASC, ticket.duedate ASC, effective_date ASC, ticket.created'; | |
| else //XXX: Add due date here?? No - | |
| $order_by='pri.priority_urgency ASC, effective_date DESC, ticket.created'; | |
| } | |
| $order=$order?$order:'DESC'; | |
| if($order_by && strpos($order_by,',') && $order) | |
| $order_by=preg_replace('/(?<!ASC|DESC),/', " $order,", $order_by); | |
| $sort=$_REQUEST['sort']?strtolower($_REQUEST['sort']):'pri.priority_urgency'; //Urgency is not on display table. | |
| $x=$sort.'_sort'; | |
| $$x=' class="'.strtolower($order).'" '; | |
| if($_GET['limit']) | |
| $qstr.='&limit='.urlencode($_GET['limit']); | |
| $qselect ='SELECT ticket.ticket_id,tlock.lock_id,ticket.`number`,ticket.dept_id,ticket.staff_id,ticket.team_id ' | |
| .' ,user.name' | |
| .' ,email.address as email, dept.dept_name, status.state ' | |
| .' ,status.name as status,ticket.source,ticket.isoverdue,ticket.isanswered,ticket.created '; | |
| $qfrom=' FROM '.TICKET_TABLE.' ticket '. | |
| ' LEFT JOIN '.TICKET_STATUS_TABLE. ' status | |
| ON (status.id = ticket.status_id) '. | |
| ' LEFT JOIN '.USER_TABLE.' user ON user.id = ticket.user_id'. | |
| ' LEFT JOIN '.USER_EMAIL_TABLE.' email ON user.id = email.user_id'. | |
| ' LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id '; | |
| if ($_REQUEST['uid']) | |
| $qfrom.=' LEFT JOIN '.TICKET_COLLABORATOR_TABLE.' collab | |
| ON (ticket.ticket_id = collab.ticket_id )'; | |
| $sjoin=''; | |
| if($search && $deep_search) { | |
| $sjoin.=' LEFT JOIN '.TICKET_THREAD_TABLE.' thread ON (ticket.ticket_id=thread.ticket_id )'; | |
| } | |
| //get ticket count based on the query so far.. | |
| $total=db_count("SELECT count(DISTINCT ticket.ticket_id) $qfrom $sjoin $qwhere"); | |
| //pagenate | |
| $pagelimit=($_GET['limit'] && is_numeric($_GET['limit']))?$_GET['limit']:PAGE_LIMIT; | |
| $page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1; | |
| $pageNav=new Pagenate($total,$page,$pagelimit); | |
| $pageNav->setURL('tickets.php',$qstr.'&sort='.urlencode($_REQUEST['sort']).'&order='.urlencode($_REQUEST['order'])); | |
| //ADD attachment,priorities, lock and other crap | |
| $qselect.=' ,IF(ticket.duedate IS NULL,IF(sla.id IS NULL, NULL, DATE_ADD(ticket.created, INTERVAL sla.grace_period HOUR)), ticket.duedate) as duedate ' | |
| .' ,CAST(GREATEST(IFNULL(ticket.lastmessage, 0), IFNULL(ticket.closed, 0), IFNULL(ticket.reopened, 0), ticket.created) as datetime) as effective_date ' | |
| .' ,ticket.created as ticket_created, CONCAT_WS(" ", staff.firstname, staff.lastname) as staff, team.name as team ' | |
| .' ,IF(staff.staff_id IS NULL,team.name,CONCAT_WS(" ", staff.lastname, staff.firstname)) as assigned ' | |
| .' ,IF(ptopic.topic_pid IS NULL, topic.topic, CONCAT_WS(" / ", ptopic.topic, topic.topic)) as helptopic ' | |
| .' ,cdata.priority as priority_id, cdata.subject, pri.priority_desc, pri.priority_color'; | |
| $qfrom.=' LEFT JOIN '.TICKET_LOCK_TABLE.' tlock ON (ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() | |
| AND tlock.staff_id!='.db_input($thisstaff->getId()).') ' | |
| .' LEFT JOIN '.STAFF_TABLE.' staff ON (ticket.staff_id=staff.staff_id) ' | |
| .' LEFT JOIN '.TEAM_TABLE.' team ON (ticket.team_id=team.team_id) ' | |
| .' LEFT JOIN '.SLA_TABLE.' sla ON (ticket.sla_id=sla.id AND sla.isactive=1) ' | |
| .' LEFT JOIN '.TOPIC_TABLE.' topic ON (ticket.topic_id=topic.topic_id) ' | |
| .' LEFT JOIN '.TOPIC_TABLE.' ptopic ON (ptopic.topic_id=topic.topic_pid) ' | |
| .' LEFT JOIN '.TABLE_PREFIX.'ticket__cdata cdata ON (cdata.ticket_id = ticket.ticket_id) ' | |
| .' LEFT JOIN '.PRIORITY_TABLE.' pri ON (pri.priority_id = cdata.priority)'; | |
| TicketForm::ensureDynamicDataView(); | |
| $query="$qselect $qfrom $qwhere ORDER BY $order_by $order LIMIT ".$pageNav->getStart().",".$pageNav->getLimit(); | |
| //echo $query; | |
| $hash = md5($query); | |
| $_SESSION['search_'.$hash] = $query; | |
| $res = db_query($query); | |
| $showing=db_num_rows($res)? ' — '.$pageNav->showing():""; | |
| if(!$results_type) | |
| $results_type = sprintf(__('%s Tickets' /* %s will be a status such as 'open' */), | |
| mb_convert_case($status, MB_CASE_TITLE)); | |
| if($search) | |
| $results_type.= ' ('.__('Search Results').')'; | |
| $negorder=$order=='DESC'?'ASC':'DESC'; //Negate the sorting.. | |
| // Fetch the results | |
| $results = array(); | |
| while ($row = db_fetch_array($res)) { | |
| $results[$row['ticket_id']] = $row; | |
| } | |
| // Fetch attachment and thread entry counts | |
| if ($results) { | |
| $counts_sql = 'SELECT ticket.ticket_id, | |
| count(DISTINCT attach.attach_id) as attachments, | |
| count(DISTINCT thread.id) as thread_count, | |
| count(DISTINCT collab.id) as collaborators | |
| FROM '.TICKET_TABLE.' ticket | |
| LEFT JOIN '.TICKET_ATTACHMENT_TABLE.' attach ON (ticket.ticket_id=attach.ticket_id) ' | |
| .' LEFT JOIN '.TICKET_THREAD_TABLE.' thread ON ( ticket.ticket_id=thread.ticket_id) ' | |
| .' LEFT JOIN '.TICKET_COLLABORATOR_TABLE.' collab | |
| ON ( ticket.ticket_id=collab.ticket_id) ' | |
| .' WHERE ticket.ticket_id IN ('.implode(',', db_input(array_keys($results))).') | |
| GROUP BY ticket.ticket_id'; | |
| $ids_res = db_query($counts_sql); | |
| while ($row = db_fetch_array($ids_res)) { | |
| $results[$row['ticket_id']] += $row; | |
| } | |
| } | |
| //YOU BREAK IT YOU FIX IT. | |
| ?> | |
| <!-- SEARCH FORM START --> | |
| <div id='basic_search'> | |
| <form action="tickets.php" method="get"> | |
| <?php csrf_token(); ?> | |
| <input type="hidden" name="a" value="search"> | |
| <table> | |
| <tr> | |
| <td><input type="text" id="basic-ticket-search" name="query" size=30 value="<?php echo Format::htmlchars($_REQUEST['query']); ?>" | |
| autocomplete="off" autocorrect="off" autocapitalize="off"></td> | |
| <td><input type="submit" name="basic_search" class="button" value="<?php echo __('Search'); ?>"></td> | |
| <td> <a href="#" id="go-advanced">[<?php echo __('advanced'); ?>]</a> <i class="help-tip icon-question-sign" href="#advanced"></i></td> | |
| </tr> | |
| </table> | |
| </form> | |
| </div> | |
| <!-- SEARCH FORM END --> | |
| <div class="clear"></div> | |
| <div style="margin-bottom:20px; padding-top:10px;"> | |
| <div> | |
| <div class="pull-left flush-left"> | |
| <h2><a href="<?php echo Format::htmlchars($_SERVER['REQUEST_URI']); ?>" | |
| title="<?php echo __('Refresh'); ?>"><i class="icon-refresh"></i> <?php echo | |
| $results_type.$showing; ?></a></h2> | |
| </div> | |
| <div class="pull-right flush-right"> | |
| <?php | |
| if ($thisstaff->canDeleteTickets()) { ?> | |
| <a id="tickets-delete" class="action-button pull-right tickets-action" | |
| href="#tickets/status/delete"><i | |
| class="icon-trash"></i> <?php echo __('Delete'); ?></a> | |
| <?php | |
| } ?> | |
| <?php | |
| if ($thisstaff->canManageTickets()) { | |
| echo TicketStatus::status_options(); | |
| } | |
| ?> | |
| </div> | |
| </div> | |
| <div class="clear" style="margin-bottom:10px;"></div> | |
| <form action="tickets.php" method="POST" name='tickets' id="tickets"> | |
| <?php csrf_token(); ?> | |
| <input type="hidden" name="a" value="mass_process" > | |
| <input type="hidden" name="do" id="action" value="" > | |
| <input type="hidden" name="status" value="<?php echo Format::htmlchars($_REQUEST['status']); ?>" > | |
| <table class="list" border="0" cellspacing="1" cellpadding="2" width="940"> | |
| <thead> | |
| <tr> | |
| <?php if($thisstaff->canManageTickets()) { ?> | |
| <th width="8px"> </th> | |
| <?php } ?> | |
| <th width="70"> | |
| <a <?php echo $id_sort; ?> href="tickets.php?sort=ID&order=<?php echo $negorder; ?><?php echo $qstr; ?>" | |
| title="<?php echo sprintf(__('Sort by %s %s'), __('Ticket ID'), __($negorder)); ?>"><?php echo __('Ticket'); ?></a></th> | |
| <th width="70"> | |
| <a <?php echo $date_sort; ?> href="tickets.php?sort=date&order=<?php echo $negorder; ?><?php echo $qstr; ?>" | |
| title="<?php echo sprintf(__('Sort by %s %s'), __('Date'), __($negorder)); ?>"><?php echo __('Date'); ?></a></th> | |
| <th width="70"> | |
| <a <?php echo $duedate_sort; ?> href="tickets.php?sort=duedate&order=<?php echo $negorder; ?><?php echo $qstr; ?>" | |
| title="<?php echo sprintf(__('Sort by %s %s'), __('Due Date'), __($negorder)); ?>"><?php echo __('Due Date'); ?></a></th> | |
| <th width="280"> | |
| <a <?php echo $subj_sort; ?> href="tickets.php?sort=subj&order=<?php echo $negorder; ?><?php echo $qstr; ?>" | |
| title="<?php echo sprintf(__('Sort by %s %s'), __('Subject'), __($negorder)); ?>"><?php echo __('Subject'); ?></a></th> | |
| <th width="170"> | |
| <a <?php echo $name_sort; ?> href="tickets.php?sort=name&order=<?php echo $negorder; ?><?php echo $qstr; ?>" | |
| title="<?php echo sprintf(__('Sort by %s %s'), __('Name'), __($negorder)); ?>"><?php echo __('From');?></a></th> | |
| <?php | |
| if($search && !$status) { ?> | |
| <th width="60"> | |
| <a <?php echo $status_sort; ?> href="tickets.php?sort=status&order=<?php echo $negorder; ?><?php echo $qstr; ?>" | |
| title="<?php echo sprintf(__('Sort by %s %s'), __('Status'), __($negorder)); ?>"><?php echo __('Status');?></a></th> | |
| <?php | |
| } else { ?> | |
| <th width="60" <?php echo $pri_sort;?>> | |
| <a <?php echo $pri_sort; ?> href="tickets.php?sort=pri&order=<?php echo $negorder; ?><?php echo $qstr; ?>" | |
| title="<?php echo sprintf(__('Sort by %s %s'), __('Priority'), __($negorder)); ?>"><?php echo __('Priority');?></a></th> | |
| <?php | |
| } | |
| if($showassigned ) { | |
| //Closed by | |
| if(!strcasecmp($status,'closed')) { ?> | |
| <th width="150"> | |
| <a <?php echo $staff_sort; ?> href="tickets.php?sort=staff&order=<?php echo $negorder; ?><?php echo $qstr; ?>" | |
| title="<?php echo sprintf(__('Sort by %s %s'), __("Closing Agent's Name"), __($negorder)); ?>"><?php echo __('Closed By'); ?></a></th> | |
| <?php | |
| } else { //assigned to ?> | |
| <th width="150"> | |
| <a <?php echo $assignee_sort; ?> href="tickets.php?sort=assignee&order=<?php echo $negorder; ?><?php echo $qstr; ?>" | |
| title="<?php echo sprintf(__('Sort by %s %s'), __('Assignee'), __($negorder)); ?>"><?php echo __('Assigned To'); ?></a></th> | |
| <?php | |
| } | |
| } else { ?> | |
| <th width="150"> | |
| <a <?php echo $dept_sort; ?> href="tickets.php?sort=dept&order=<?php echo $negorder;?><?php echo $qstr; ?>" | |
| title="<?php echo sprintf(__('Sort by %s %s'), __('Department'), __($negorder)); ?>"><?php echo __('Department');?></a></th> | |
| <?php | |
| } ?> | |
| </tr> | |
| </thead> | |
| <tbody> | |
| <?php | |
| // Setup Subject field for display | |
| $subject_field = TicketForm::objects()->one()->getField('subject'); | |
| $class = "row1"; | |
| $total=0; | |
| if($res && ($num=count($results))): | |
| $ids=($errors && $_POST['tids'] && is_array($_POST['tids']))?$_POST['tids']:null; | |
| //echo "AB<pre>"; | |
| //print_r($results); | |
| foreach ($results as $row) { | |
| $tag=$row['staff_id']?'assigned':'openticket'; | |
| $flag=null; | |
| if($row['lock_id']) | |
| $flag='locked'; | |
| elseif($row['isoverdue']) | |
| $flag='overdue'; | |
| $lc=''; | |
| if($showassigned) { | |
| if($row['staff_id']) | |
| $lc=sprintf('<span class="Icon staffAssigned">%s</span>',Format::truncate($row['staff'],40)); | |
| elseif($row['team_id']) | |
| $lc=sprintf('<span class="Icon teamAssigned">%s</span>',Format::truncate($row['team'],40)); | |
| else | |
| $lc=' '; | |
| }else{ | |
| $lc=Format::truncate($row['dept_name'],40); | |
| } | |
| $tid=$row['number']; | |
| $subject = Format::truncate($subject_field->display( | |
| $subject_field->to_php($row['subject']) ?: $row['subject'] | |
| ), 40); | |
| $threadcount=$row['thread_count']; | |
| if(!strcasecmp($row['state'],'open') && !$row['isanswered'] && !$row['lock_id']) { | |
| $tid=sprintf('<b>%s</b>',$tid); | |
| } | |
| ?> | |
| <tr id="<?php echo $row['ticket_id']; ?>"> | |
| <?php if($thisstaff->canManageTickets()) { | |
| $sel=false; | |
| if($ids && in_array($row['ticket_id'], $ids)) | |
| $sel=true; | |
| ?> | |
| <td align="center" class="nohover"> | |
| <input class="ckb" type="checkbox" name="tids[]" | |
| value="<?php echo $row['ticket_id']; ?>" <?php echo $sel?'checked="checked"':''; ?>> | |
| </td> | |
| <?php } ?> | |
| <td title="<?php echo $row['email']; ?>" nowrap> | |
| <a class="Icon <?php echo strtolower($row['source']); ?>Ticket ticketPreview" title="Preview Ticket" | |
| href="tickets.php?id=<?php echo $row['ticket_id']; ?>"><?php echo $tid; ?></a></td> | |
| <td align="center" nowrap><?php echo Format::db_datetime($row['effective_date']); ?></td> | |
| <td align="center" nowrap><?php echo Format::db_datetime($row['duedate']); ?></td> | |
| <td><a <?php if ($flag) { ?> class="Icon <?php echo $flag; ?>Ticket" title="<?php echo ucfirst($flag); ?> Ticket" <?php } ?> | |
| href="tickets.php?id=<?php echo $row['ticket_id']; ?>"><?php echo $subject; ?></a> | |
| <?php | |
| if ($threadcount>1) | |
| echo "<small>($threadcount)</small> ".'<i | |
| class="icon-fixed-width icon-comments-alt"></i> '; | |
| if ($row['collaborators']) | |
| echo '<i class="icon-fixed-width icon-group faded"></i> '; | |
| if ($row['attachments']) | |
| echo '<i class="icon-fixed-width icon-paperclip"></i> '; | |
| ?> | |
| </td> | |
| <td nowrap> <?php echo Format::htmlchars( | |
| Format::truncate($row['name'], 22, strpos($row['name'], '@'))); ?> </td> | |
| <?php | |
| if($search && !$status){ | |
| $displaystatus=ucfirst($row['status']); | |
| if(!strcasecmp($row['state'],'open')) | |
| $displaystatus="<b>$displaystatus</b>"; | |
| echo "<td>$displaystatus</td>"; | |
| } else { ?> | |
| <td class="nohover" align="center" style="background-color:<?php echo $row['priority_color']; ?>;"> | |
| <?php echo $row['priority_desc']; ?></td> | |
| <?php | |
| } | |
| ?> | |
| <td nowrap> <?php echo $lc; ?></td> | |
| </tr> | |
| <?php | |
| } //end of while. | |
| else: //not tickets found!! set fetch error. | |
| $ferror=__('There are no tickets matching your criteria.'); | |
| endif; ?> | |
| </tbody> | |
| <tfoot> | |
| <tr> | |
| <td colspan="8"> | |
| <?php if($res && $num && $thisstaff->canManageTickets()){ ?> | |
| <?php echo __('Select');?>: | |
| <a id="selectAll" href="#ckb"><?php echo __('All');?></a> | |
| <a id="selectNone" href="#ckb"><?php echo __('None');?></a> | |
| <a id="selectToggle" href="#ckb"><?php echo __('Toggle');?></a> | |
| <?php }else{ | |
| echo '<i>'; | |
| echo $ferror?Format::htmlchars($ferror):__('Query returned 0 results.'); | |
| echo '</i>'; | |
| } ?> | |
| </td> | |
| </tr> | |
| </tfoot> | |
| </table> | |
| <?php | |
| if($num>0){ //if we actually had any tickets returned. | |
| echo '<div> '.__('Page').':'.$pageNav->getPageLinks().' '; | |
| echo '<a class="export-csv no-pjax" href="?a=export&h=' | |
| .$hash.'&status='.$_REQUEST['status'] .'">'.__('Export').'</a> <i class="help-tip icon-question-sign" href="#export"></i></div>'; | |
| } ?> | |
| </form> | |
| </div> | |
| <div style="display:none;" class="dialog" id="confirm-action"> | |
| <h3><?php echo __('Please Confirm');?></h3> | |
| <a class="close" href=""><i class="icon-remove-circle"></i></a> | |
| <hr/> | |
| <p class="confirm-action" style="display:none;" id="mark_overdue-confirm"> | |
| <?php echo __('Are you sure want to flag the selected tickets as <font color="red"><b>overdue</b></font>?');?> | |
| </p> | |
| <div><?php echo __('Please confirm to continue.');?></div> | |
| <hr style="margin-top:1em"/> | |
| <p class="full-width"> | |
| <span class="buttons pull-left"> | |
| <input type="button" value="<?php echo __('No, Cancel');?>" class="close"> | |
| </span> | |
| <span class="buttons pull-right"> | |
| <input type="button" value="<?php echo __('Yes, Do it!');?>" class="confirm"> | |
| </span> | |
| </p> | |
| <div class="clear"></div> | |
| </div> | |
| <div class="dialog" style="display:none;" id="advanced-search"> | |
| <h3><?php echo __('Advanced Ticket Search');?></h3> | |
| <a class="close" href=""><i class="icon-remove-circle"></i></a> | |
| <hr/> | |
| <form action="tickets.php" method="post" id="search" name="search"> | |
| <input type="hidden" name="a" value="search"> | |
| <fieldset class="query"> | |
| <input type="input" id="query" name="query" size="20" placeholder="<?php echo __('Keywords') . ' — ' . __('Optional'); ?>"> | |
| </fieldset> | |
| <fieldset class="span6"> | |
| <label for="statusId"><?php echo __('Statuses');?>:</label> | |
| <select id="statusId" name="statusId"> | |
| <option value="">— <?php echo __('Any Status');?> —</option> | |
| <?php | |
| foreach (TicketStatusList::getStatuses( | |
| array('states' => array('open', 'closed'))) as $s) { | |
| echo sprintf('<option data-state="%s" value="%d">%s</option>', | |
| $s->getState(), $s->getId(), __($s->getName())); | |
| } | |
| ?> | |
| </select> | |
| </fieldset> | |
| <fieldset class="span6"> | |
| <label for="deptId"><?php echo __('Departments');?>:</label> | |
| <select id="deptId" name="deptId"> | |
| <option value="">— <?php echo __('All Departments');?> —</option> | |
| <?php | |
| if(($mydepts = $thisstaff->getDepts()) && ($depts=Dept::getDepartments())) { | |
| foreach($depts as $id =>$name) { | |
| if(!in_array($id, $mydepts)) continue; | |
| echo sprintf('<option value="%d">%s</option>', $id, $name); | |
| } | |
| } | |
| ?> | |
| </select> | |
| </fieldset> | |
| <fieldset class="span6"> | |
| <label for="flag"><?php echo __('Flags');?>:</label> | |
| <select id="flag" name="flag"> | |
| <option value="">— <?php echo __('Any Flags');?> —</option> | |
| <?php | |
| if (!$cfg->showAnsweredTickets()) { ?> | |
| <option data-state="open" value="answered"><?php echo __('Answered');?></option> | |
| <?php | |
| } ?> | |
| <option data-state="open" value="overdue"><?php echo __('Overdue');?></option> | |
| </select> | |
| </fieldset> | |
| <fieldset class="owner span6"> | |
| <label for="assignee"><?php echo __('Assigned To');?>:</label> | |
| <select id="assignee" name="assignee"> | |
| <option value="">— <?php echo __('Anyone');?> —</option> | |
| <option value="0">— <?php echo __('Unassigned');?> —</option> | |
| <option value="s<?php echo $thisstaff->getId(); ?>"><?php echo __('Me');?></option> | |
| <?php | |
| if(($users=Staff::getStaffMembers())) { | |
| echo '<OPTGROUP label="'.sprintf(__('Agents (%d)'),count($users)).'">'; | |
| foreach($users as $id => $name) { | |
| $k="s$id"; | |
| echo sprintf('<option value="%s">%s</option>', $k, $name); | |
| } | |
| echo '</OPTGROUP>'; | |
| } | |
| if(($teams=Team::getTeams())) { | |
| echo '<OPTGROUP label="'.__('Teams').' ('.count($teams).')">'; | |
| foreach($teams as $id => $name) { | |
| $k="t$id"; | |
| echo sprintf('<option value="%s">%s</option>', $k, $name); | |
| } | |
| echo '</OPTGROUP>'; | |
| } | |
| ?> | |
| </select> | |
| </fieldset> | |
| <fieldset class="span6"> | |
| <label for="topicId"><?php echo __('Help Topics');?>:</label> | |
| <select id="topicId" name="topicId"> | |
| <option value="" selected >— <?php echo __('All Help Topics');?> —</option> | |
| <?php | |
| if($topics=Topic::getHelpTopics()) { | |
| foreach($topics as $id =>$name) | |
| echo sprintf('<option value="%d" >%s</option>', $id, $name); | |
| } | |
| ?> | |
| </select> | |
| </fieldset> | |
| <fieldset class="owner span6"> | |
| <label for="staffId"><?php echo __('Closed By');?>:</label> | |
| <select id="staffId" name="staffId"> | |
| <option value="0">— <?php echo __('Anyone');?> —</option> | |
| <option value="<?php echo $thisstaff->getId(); ?>"><?php echo __('Me');?></option> | |
| <?php | |
| if(($users=Staff::getStaffMembers())) { | |
| foreach($users as $id => $name) | |
| echo sprintf('<option value="%d">%s</option>', $id, $name); | |
| } | |
| ?> | |
| </select> | |
| </fieldset> | |
| <fieldset class="date_range"> | |
| <label><?php echo __('Date Range').' — '.__('Create Date');?>:</label> | |
| <input class="dp" type="input" size="20" name="startDate"> | |
| <span class="between"><?php echo __('TO');?></span> | |
| <input class="dp" type="input" size="20" name="endDate"> | |
| </fieldset> | |
| <?php | |
| $tform = TicketForm::objects()->one(); | |
| echo $tform->getForm()->getMedia(); | |
| foreach ($tform->getInstance()->getFields() as $f) { | |
| if (!$f->hasData()) | |
| continue; | |
| elseif (!$f->getImpl()->hasSpecialSearch()) | |
| continue; | |
| ?><fieldset class="span6"> | |
| <label><?php echo $f->getLabel(); ?>:</label><div><?php | |
| $f->render('search'); ?></div> | |
| </fieldset> | |
| <?php } ?> | |
| <hr/> | |
| <div id="result-count" class="clear"></div> | |
| <p> | |
| <span class="buttons pull-right"> | |
| <input type="submit" value="<?php echo __('Search');?>"> | |
| </span> | |
| <span class="buttons pull-left"> | |
| <input type="reset" value="<?php echo __('Reset');?>"> | |
| <input type="button" value="<?php echo __('Cancel');?>" class="close"> | |
| </span> | |
| <span class="spinner"> | |
| <img src="./images/ajax-loader.gif" width="16" height="16"> | |
| </span> | |
| </p> | |
| </form> | |
| </div> | |
| <script type="text/javascript"> | |
| $(function() { | |
| $(document).off('.tickets'); | |
| $(document).on('click.tickets', 'a.tickets-action', function(e) { | |
| e.preventDefault(); | |
| var count = checkbox_checker($('form#tickets'), 1); | |
| if (count) { | |
| var url = 'ajax.php/' | |
| +$(this).attr('href').substr(1) | |
| +'?count='+count | |
| +'&_uid='+new Date().getTime(); | |
| $.dialog(url, [201], function (xhr) { | |
| window.location.href = window.location.href; | |
| }); | |
| } | |
| return false; | |
| }); | |
| }); | |
| </script> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment