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>
