public function home($from, $to, $filter) { $t = array(); $d = array(); // Ticket data.. $q = mysql_query("SELECT DATE_FORMAT(DATE(FROM_UNIXTIME(" . DB_PREFIX . "tickets.`ts`)),'{$this->date_format}') AS `dt`,count(*) AS `c` \n FROM `" . DB_PREFIX . "tickets`\n WHERE DATE(FROM_UNIXTIME(`" . DB_PREFIX . "tickets`.`ts`)) BETWEEN '" . $this->datetime->mswDatePickerFormat($from) . "' AND '" . $this->datetime->mswDatePickerFormat($to) . "'\n\t\tAND `isDisputed` = 'no'\n\t\tAND `assignedto` != 'waiting'\n\t AND `spamFlag` = 'no'\n\t\t" . mswSQLDepartmentFilter($filter) . "\n\t\tGROUP BY DATE(FROM_UNIXTIME(`" . DB_PREFIX . "tickets`.`ts`))\n "); while ($TD = mysql_fetch_object($q)) { $t[] = "['" . $TD->dt . "'," . $TD->c . "]"; } // Dispute data.. if ($this->settings->disputes == 'yes') { $q2 = mysql_query("SELECT DATE_FORMAT(DATE(FROM_UNIXTIME(" . DB_PREFIX . "tickets.`ts`)),'{$this->date_format}') AS `dt`,count(*) AS `c` \n FROM `" . DB_PREFIX . "tickets`\n WHERE DATE(FROM_UNIXTIME(`" . DB_PREFIX . "tickets`.`ts`)) BETWEEN '" . $this->datetime->mswDatePickerFormat($from) . "' AND '" . $this->datetime->mswDatePickerFormat($to) . "'\n\t\t AND `isDisputed` = 'yes'\n\t\t AND `assignedto` != 'waiting'\n\t AND `spamFlag` = 'no'\n\t\t " . mswSQLDepartmentFilter($filter) . "\n\t\t GROUP BY DATE(FROM_UNIXTIME(`" . DB_PREFIX . "tickets`.`ts`))\n "); while ($TD2 = mysql_fetch_object($q2)) { $d[] = "['" . $TD2->dt . "'," . $TD2->c . "]"; } } // JQPLOT Note // A bug apears to exist in jqplot that prevents correct tick date display for one data point.. // We can fix this by adding a blank entry for the initial view cut off point.. if (count($t) == 1) { array_unshift($t, "['" . date('n/j/Y', strtotime('-' . ($this->team->defDays > 0 ? $this->team->defDays : 45) . ' day')) . "',0]"); } return array($t, $d); }
$SQL = 'AND (LOWER(`' . DB_PREFIX . 'tickets`.`subject`) LIKE \'%' . $_GET['keys'] . '%\' OR LOWER(`' . DB_PREFIX . 'tickets`.`comments`) LIKE \'%' . $_GET['keys'] . '%\')'; } // Disputes.. if ($SETTINGS->disputes == 'yes' && isset($_GET['disputes'])) { // Disputes in other tickets.. $qD = mysql_query("SELECT `ticketID` FROM `" . DB_PREFIX . "disputes` \n WHERE `visitorID` = '{$ACC->id}'\n\t GROUP BY `ticketID`\n\t ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); while ($DP = mysql_fetch_object($qD)) { $dis[] = $DP->ticketID; } // Disputes from started tickets.. $qD2 = mysql_query("SELECT `id` FROM `" . DB_PREFIX . "tickets` \n WHERE `visitorID` = '{$ACC->id}'\n\t\t AND `isDisputed` = 'yes'\n\t\t AND `spamFlag` = 'no'\n\t ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); while ($DP2 = mysql_fetch_object($qD2)) { $dis[] = $DP2->id; } } $q = mysql_query("SELECT SQL_CALC_FOUND_ROWS *,\n `" . DB_PREFIX . "tickets`.`id` AS `ticketID`,\n\t `" . DB_PREFIX . "portal`.`name` AS `ticketName`,\n\t `" . DB_PREFIX . "tickets`.`ts` AS `ticketStamp`,\n\t `" . DB_PREFIX . "departments`.`name` AS `deptName`,\n\t `" . DB_PREFIX . "levels`.`name` AS `levelName`,\n\t (SELECT count(*) FROM `" . DB_PREFIX . "disputes` \n\t WHERE `" . DB_PREFIX . "disputes`.`ticketID` = `" . DB_PREFIX . "tickets`.`id`\n\t ) AS `disputeCount`\n\t FROM `" . DB_PREFIX . "tickets` \n LEFT JOIN `" . DB_PREFIX . "departments`\n\t ON `" . DB_PREFIX . "tickets`.`department` = `" . DB_PREFIX . "departments`.`id`\n\t LEFT JOIN `" . DB_PREFIX . "portal`\n\t ON `" . DB_PREFIX . "tickets`.`visitorID` = `" . DB_PREFIX . "portal`.`id`\n\t LEFT JOIN `" . DB_PREFIX . "levels`\n\t ON `" . DB_PREFIX . "tickets`.`priority` = `" . DB_PREFIX . "levels`.`id`\n\t OR `" . DB_PREFIX . "tickets`.`priority` = `" . DB_PREFIX . "levels`.`marker`\n " . (empty($dis) ? 'WHERE `' . DB_PREFIX . 'portal`.`email` = \'' . $ACC->email . '\'' : '') . "\n\t " . (!empty($dis) ? 'WHERE `' . DB_PREFIX . 'tickets`.`id` IN(' . implode(',', $dis) . ')' : '') . "\n\t {$SQL}\n\t AND `spamFlag` = 'no'\n " . $filterBy . mswSQLDepartmentFilter($ticketFilterAccess) . "\n " . $orderBy . "\n LIMIT {$limitvalue},{$limit}\n ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); $c = mysql_fetch_object(mysql_query("SELECT FOUND_ROWS() AS `rows`")); $countedRows = isset($c->rows) ? $c->rows : '0'; $searchBoxUrl = 'acchistory&id=' . $_GET['id'] . (isset($_GET['disputes']) ? '&disputes=yes' : ''); ?> <div class="content"> <script type="text/javascript"> //<![CDATA[ function mswHisToggle() { if (jQuery('#b2').css('display')=='none') { jQuery('#topfluid').css('margin-top','0'); jQuery('#b2').show(); jQuery('input[name="keys"]').focus(); jQuery('#search-icon-button').attr('class','icon-remove'); } else { jQuery('#topfluid').css('margin-top','20px');
</div> </div> <div class="tab-pane fade" id="two"> <div class="well"> <label class="checkbox"> <input type="checkbox" value="0" onclick="checkBoxes(this.checked,'#cb')"> <?php echo $msg_response6; ?> </label> <div id="cb"> <?php // If global log in no filter necessary.. $q_dept = mysql_query("SELECT * FROM `" . DB_PREFIX . "departments` " . mswSQLDepartmentFilter($mswDeptFilterAccess, 'WHERE') . " ORDER BY `name`") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); while ($DEPT = mysql_fetch_object($q_dept)) { ?> <label class="checkbox"> <input type="checkbox" name="dept[]"<?php echo isset($deptArr) && in_array($DEPT->id, $deptArr) ? ' checked="checked" ' : ' '; ?> value="<?php echo $DEPT->id; ?> "> <?php echo mswSpecialChars($DEPT->name); ?> </label> <input type="hidden" name="deptall[]" value="<?php echo $DEPT->id;
<?php if (!defined('PARENT')) { exit; } // Order and filter by files.. include PATH . 'templates/system/tickets/global/order-by.php'; include PATH . 'templates/system/tickets/global/filter-by.php'; $q = mysql_query("SELECT SQL_CALC_FOUND_ROWS *,\n `" . DB_PREFIX . "tickets`.`id` AS `ticketID`,\n\t `" . DB_PREFIX . "portal`.`name` AS `ticketName`,\n\t `" . DB_PREFIX . "tickets`.`ts` AS `ticketStamp`,\n\t `" . DB_PREFIX . "departments`.`name` AS `deptName`,\n\t `" . DB_PREFIX . "levels`.`name` AS `levelName`\n\t FROM `" . DB_PREFIX . "tickets`\n\t LEFT JOIN `" . DB_PREFIX . "departments`\n\t ON `" . DB_PREFIX . "tickets`.`department` = `" . DB_PREFIX . "departments`.`id`\n\t LEFT JOIN `" . DB_PREFIX . "portal`\n\t ON `" . DB_PREFIX . "tickets`.`visitorID` = `" . DB_PREFIX . "portal`.`id`\n\t LEFT JOIN `" . DB_PREFIX . "levels`\n\t ON `" . DB_PREFIX . "tickets`.`priority` = `" . DB_PREFIX . "levels`.`id`\n\t OR `" . DB_PREFIX . "tickets`.`priority` = `" . DB_PREFIX . "levels`.`marker`\n WHERE (`ticketStatus` != 'open' and `ticketStatus` != 'submit_report')\n AND `isDisputed` = 'no'\n AND `assignedto` != 'waiting'\n\t AND `spamFlag` = 'no'\n " . $filterBy . " " . mswSQLDepartmentFilter($ticketFilterAccess) . "\n " . $orderBy . "\n LIMIT {$limitvalue},{$limit}\n ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); $c = mysql_fetch_object(mysql_query("SELECT FOUND_ROWS() AS `rows`")); $countedRows = isset($c->rows) ? $c->rows : '0'; ?> <div class="content"> <script type="text/javascript"> //<![CDATA[ jQuery(document).ready(function() { jQuery('.nyroModal').nyroModal(); <?php // Remove notes icon if permission denied.. if ($MSTEAM->notePadEnable == 'no' && $MSTEAM->id != '1') { ?> jQuery('.tIcons .nyroModal').each(function(){ jQuery(this).remove(); }); <?php } ?> }); //]]> </script> <div class="header">
</div> </div> </div> <?php if ($SETTINGS->disputes == 'yes') { ?> <div class="row-fluid"> <div class="block" style="padding:0;margin:0;margin-top:10px"> <p class="block-heading uppercase"><i class="icon-bullhorn"></i> <?php echo $msg_home29; ?> </p> <div class="block-body" style="line-height:30px"> <?php $arrDispOverview = array(mswRowCount('tickets WHERE `replyStatus` = \'start\' AND `ticketStatus` = \'open\' AND `assignedto` != \'waiting\' AND `spamFlag` = \'no\' AND `isDisputed` = \'yes\' ' . mswSQLDepartmentFilter($ticketFilterAccess)), mswRowCount('tickets WHERE `replyStatus` IN(\'admin\',\'start\') AND `ticketStatus` = \'open\' AND `assignedto` != \'waiting\' AND `spamFlag` = \'no\' AND `isDisputed` = \'yes\' ' . mswSQLDepartmentFilter($ticketFilterAccess)), mswRowCount('tickets WHERE `replyStatus` = \'visitor\' AND `ticketStatus` = \'open\' AND `assignedto` != \'waiting\' AND `spamFlag` = \'no\' AND `isDisputed` = \'yes\' ' . mswSQLDepartmentFilter($ticketFilterAccess)), mswRowCount('tickets WHERE `ticketStatus` != \'open\' AND `assignedto` != \'waiting\' AND `spamFlag` = \'no\' AND `isDisputed` = \'yes\' ' . mswSQLDepartmentFilter($ticketFilterAccess))); ?> <a href="?p=disputes&status=start"><span class="label label-info"><?php echo $arrDispOverview[0] < 10 ? ' ' . $arrDispOverview[0] : $arrDispOverview[0]; ?> </span></a> - <?php echo $msg_home43; ?> <br> <a href="?p=disputes&status=adminonly"><span class="label label-info"><?php echo $arrDispOverview[1] < 10 ? ' ' . $arrDispOverview[1] : $arrDispOverview[1]; ?> </span></a> - <?php echo $msg_home26; ?> <br>
case 'tickets_desc': $orderBy = 'ORDER BY `tickCount` desc'; break; // Least tickets.. // Least tickets.. case 'tickets_asc': $orderBy = 'ORDER BY `tickCount`'; break; } } if (isset($_GET['keys']) && $_GET['keys']) { $_GET['keys'] = mswSafeImportString(strtolower($_GET['keys'])); $SQL = (mswSQLDepartmentFilter($mswDeptFilterAccess, 'WHERE') ? ' AND ' : 'WHERE ') . ' LOWER(`name`) LIKE \'%' . $_GET['keys'] . '%\''; } echo "SELECT SQL_CALC_FOUND_ROWS *, \n (SELECT count(*) FROM `" . DB_PREFIX . "tickets` \n\t\t\t WHERE `" . DB_PREFIX . "departments`.`id` = `" . DB_PREFIX . "tickets`.`department`\n\t\t\t\tAND `spamFlag` = 'no'\n\t\t\t ) AS `tickCount`\n\t\t\t FROM `" . DB_PREFIX . "departments` " . mswSQLDepartmentFilter($mswDeptFilterAccess, 'WHERE') . " \n {$SQL}\n {$orderBy}\n LIMIT {$limitvalue},{$limit}\n\t\t\t "; $q = mysql_query("SELECT SQL_CALC_FOUND_ROWS *, \n (SELECT count(*) FROM `" . DB_PREFIX . "tickets` \n\t\t\t WHERE `" . DB_PREFIX . "departments`.`id` = `" . DB_PREFIX . "tickets`.`department`\n\t\t\t\tAND `spamFlag` = 'no'\n\t\t\t ) AS `tickCount`\n\t\t\t FROM `" . DB_PREFIX . "departments` " . mswSQLDepartmentFilter($mswDeptFilterAccess, 'WHERE') . " \n {$SQL}\n {$orderBy}\n LIMIT {$limitvalue},{$limit}\n\t\t\t ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); $c = mysql_fetch_object(mysql_query("SELECT FOUND_ROWS() AS `rows`")); $countedRows = isset($c->rows) ? $c->rows : '0'; ?> <div class="content"> <div class="header"> <?php // Order By.. if (mswRowCount('departments') > 0) { $links = array(array('link' => '?p=' . $_GET['p'] . '&orderby=name_asc' . mswQueryParams(array('p', 'orderby')), 'name' => $msg_levels21), array('link' => '?p=' . $_GET['p'] . '&orderby=name_desc' . mswQueryParams(array('p', 'orderby')), 'name' => $msg_levels22), array('link' => '?p=' . $_GET['p'] . '&orderby=order_asc' . mswQueryParams(array('p', 'orderby')), 'name' => $msg_levels23), array('link' => '?p=' . $_GET['p'] . '&orderby=order_desc' . mswQueryParams(array('p', 'orderby')), 'name' => $msg_levels24), array('link' => '?p=' . $_GET['p'] . '&orderby=man_asc' . mswQueryParams(array('p', 'orderby')), 'name' => $msg_dept26), array('link' => '?p=' . $_GET['p'] . '&orderby=man_desc' . mswQueryParams(array('p', 'orderby')), 'name' => $msg_dept27), array('link' => '?p=' . $_GET['p'] . '&orderby=vis_asc' . mswQueryParams(array('p', 'orderby')), 'name' => $msg_dept28), array('link' => '?p=' . $_GET['p'] . '&orderby=vis_desc' . mswQueryParams(array('p', 'orderby')), 'name' => $msg_dept29), array('link' => '?p=' . $_GET['p'] . '&orderby=tickets_desc' . mswQueryParams(array('p', 'orderby')), 'name' => $msg_accounts11), array('link' => '?p=' . $_GET['p'] . '&orderby=tickets_asc' . mswQueryParams(array('p', 'orderby')), 'name' => $msg_accounts12)); echo $MSBOOTSTRAP->button($msg_script45, $links); // Page filter.. include PATH . 'templates/system/bootstrap/page-filter.php'; ?>
<!--[if IE 7 ]> <body class="ie ie7"> <![endif]--> <!--[if IE 8 ]> <body class="ie ie8"> <![endif]--> <!--[if IE 9 ]> <body class="ie ie9"> <![endif]--> <!--[if (gt IE 9)|!(IE)]><!--> <body class=""> <!--<![endif]--> <div class="block"> <p class="block-heading"><?php echo strtoupper($msg_merge); ?> </p> <?php $depFilters = mswSQLDepartmentFilter($ticketFilterAccess, 'WHERE'); $q = mysql_query("SELECT `id`,`subject` FROM " . DB_PREFIX . "tickets\n {$depFilters}\n\t\t " . ($depFilters ? 'AND' : 'WHERE') . " `visitorID` = '{$VIS}'\n AND `id` != '{$ID}'\n AND `assignedto` != 'waiting'\n\t\t AND `ticketStatus` = 'open'\n\t\t AND `isDisputed` = 'no'\n\t\t AND `spamFlag` = 'no'\n ORDER BY `id`\n\t\t ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); if (mysql_num_rows($q) > 0) { while ($TICKET = mysql_fetch_object($q)) { ?> <div class="block-body mergehover" style="padding:5px;margin:5px"> <div class="pull-left"> [<b>#<?php echo mswTicketNumber($TICKET->id); ?> </b>] <?php echo mswSpecialChars($TICKET->subject); ?> </div>
<?php if (!defined('PARENT')) { exit; } define('HIDE_ASSIGN_FILTERS', 1); // Order and filter by files.. include PATH . 'templates/system/tickets/global/order-by.php'; include PATH . 'templates/system/tickets/global/filter-by.php'; $q = mysql_query("SELECT SQL_CALC_FOUND_ROWS *,\n `" . DB_PREFIX . "tickets`.`id` AS `ticketID`,\n\t `" . DB_PREFIX . "portal`.`name` AS `ticketName`,\n\t `" . DB_PREFIX . "tickets`.`ts` AS `ticketStamp`,\n\t `" . DB_PREFIX . "departments`.`name` AS `deptName`,\n\t `" . DB_PREFIX . "levels`.`name` AS `levelName`\n\t FROM `" . DB_PREFIX . "tickets`\n\t LEFT JOIN `" . DB_PREFIX . "departments`\n\t ON `" . DB_PREFIX . "tickets`.`department` = `" . DB_PREFIX . "departments`.`id`\n\t LEFT JOIN `" . DB_PREFIX . "portal`\n\t ON `" . DB_PREFIX . "tickets`.`visitorID` = `" . DB_PREFIX . "portal`.`id`\n\t LEFT JOIN `" . DB_PREFIX . "levels`\n\t ON `" . DB_PREFIX . "tickets`.`priority` = `" . DB_PREFIX . "levels`.`id`\n\t OR `" . DB_PREFIX . "tickets`.`priority` = `" . DB_PREFIX . "levels`.`marker`\n WHERE `spamFlag` = 'yes'\n\t AND `source` = 'imap'\n " . $filterBy . " " . mswSQLDepartmentFilter($ticketFilterAccess) . "\n " . $orderBy . "\n LIMIT {$limitvalue},{$limit}\n ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); $c = mysql_fetch_object(mysql_query("SELECT FOUND_ROWS() AS `rows`")); $countedRows = isset($c->rows) ? $c->rows : '0'; ?> <div class="content"> <script type="text/javascript"> //<![CDATA[ jQuery(document).ready(function() { jQuery('.nyroModal').nyroModal(); <?php // Remove notes icon if permission denied.. if ($MSTEAM->notePadEnable == 'no' && $MSTEAM->id != '1') { ?> jQuery('.tIcons .nyroModal').each(function(){ jQuery(this).remove(); }); <?php } ?> }); //]]> </script>