OsTicket 1.9.4 - Ticket View with Due Date Column
| <?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