Exemplo n.º 1
0
 if (isset($_POST['send']) && $_POST['send'] == 'send') {
     $priority = array();
     $categories = array();
     $subject = validate($_POST['subject'], 'subject');
     $priority[0] = isset($_POST['priority1']) ? $_POST['priority1'] : '';
     $priority[1] = isset($_POST['priority2']) ? $_POST['priority2'] : '';
     $priority[2] = isset($_POST['priority3']) ? $_POST['priority3'] : '';
     $fromdate = validate($_POST['fromdate'], 'fromdate');
     $todate = validate($_POST['todate'], 'todate');
     $message = validate($_POST['message'], 'message');
     $customer = validate($_POST['customer'], 'customer');
     $cat = $db->query_first('SELECT COUNT(`id`) as `ccount` FROM `' . TABLE_PANEL_TICKET_CATS . '`');
     for ($x = 0; $x < $cat['ccount']; $x++) {
         $categories[$x] = isset($_POST['category' . $x]) ? $_POST['category' . $x] : '';
     }
     $query = ticket::getArchiveSearchStatement($db, $subject, $priority, $fromdate, $todate, $message, $customer, $userinfo['adminid'], $categories);
     $fields = array('lastchange' => $lng['ticket']['lastchange'], 'ticket_answers' => $lng['ticket']['ticket_answers'], 'subject' => $lng['ticket']['subject'], 'lastreplier' => $lng['ticket']['lastreplier'], 'priority' => $lng['ticket']['priority']);
     $paging = new paging($userinfo, $db, TABLE_PANEL_TICKETS, $fields, $settings['panel']['paging'], $settings['panel']['natsorting']);
     $result = $db->query($query . $paging->getSqlWhere(true) . " " . $paging->getSqlOrderBy() . " " . $paging->getSqlLimit());
     $sortcode = $paging->getHtmlSortCode($lng);
     $arrowcode = $paging->getHtmlArrowCode($filename . '?page=' . $page . '&s=' . $s);
     $searchcode = $paging->getHtmlSearchCode($lng);
     $pagingcode = $paging->getHtmlPagingCode($filename . '?page=' . $page . '&s=' . $s);
     $ctickets = array();
     while ($row = $db->fetch_array($result)) {
         if (!isset($ctickets[$row['customerid']]) || !is_array($ctickets[$row['customerid']])) {
             $ctickets[$row['customerid']] = array();
         }
         $ctickets[$row['customerid']][$row['id']] = $row;
     }
     if ($paging->sortfield == 'customerid' && $paging->sortorder == 'desc') {