if (!isset($admins)) { $admins = array(); $res2 = hesk_dbQuery("SELECT `id`,`name` FROM `" . hesk_dbEscape($hesk_settings['db_pfix']) . "users` ORDER BY `name` ASC"); while ($row = hesk_dbFetchAssoc($res2)) { $admins[$row['id']] = $row['name']; } } /* List of categories */ $orderBy = $modsForHesk_settings['category_order_column']; $hesk_settings['categories'] = array(); $res2 = hesk_dbQuery('SELECT `id`, `name` FROM `' . hesk_dbEscape($hesk_settings['db_pfix']) . 'categories` WHERE ' . hesk_myCategories('id') . ' ORDER BY `' . $orderBy . '` ASC'); while ($row = hesk_dbFetchAssoc($res2)) { $hesk_settings['categories'][$row['id']] = $row['name']; } /* Current MySQL time */ $mysql_time = hesk_dbTime(); /* Get number of tickets and page number */ $result = hesk_dbQuery($sql_count); $total = hesk_dbResult($result); //-- Precondition: The panel has already been created, and there is NO open <div class="panel-body"> tag yet. echo '<div class="panel-body">'; if ($total > 0) { /* This query string will be used to browse pages */ if ($href == 'show_tickets.php') { #$query = 'status='.$status; $query = ''; $query .= 's' . implode('=1&s', array_keys($status)) . '=1'; $query .= '&p' . implode('=1&p', array_keys($priority)) . '=1'; $query .= '&category=' . $category; $query .= '&sort=' . $sort; $query .= '&asc=' . $asc;
function hesk_dateToString($dt, $returnName = 1, $returnTime = 0, $returnMonth = 0, $from_database = false) { global $hesk_settings, $hesklang; $dt = strtotime($dt); // Adjust MySQL time if different from PHP time if ($from_database) { if (!defined('MYSQL_TIME_DIFF')) { define('MYSQL_TIME_DIFF', time() - hesk_dbTime()); } if (MYSQL_TIME_DIFF != 0) { $dt += MYSQL_TIME_DIFF; } // Add HESK set time difference $dt += 3600 * $hesk_settings['diff_hours'] + 60 * $hesk_settings['diff_minutes']; // Daylight saving? if ($hesk_settings['daylight'] && date('I', $dt)) { $dt += 3600; } } list($y, $m, $n, $d, $G, $i, $s) = explode('-', date('Y-n-j-w-G-i-s', $dt)); $m = $hesklang['m' . $m]; $d = $hesklang['d' . $d]; if ($returnName) { return "{$d}, {$m} {$n}, {$y}"; } if ($returnTime) { return "{$d}, {$m} {$n}, {$y} {$G}:{$i}:{$s}"; } if ($returnMonth) { return "{$m} {$y}"; } return "{$m} {$n}, {$y}"; }
function hesk_date($dt = '', $from_database = false, $is_str = true, $return_str = true) { global $hesk_settings; if (!$dt) { $dt = time(); } elseif ($is_str) { $dt = strtotime($dt); } // Adjust MySQL time if different from PHP time if ($from_database) { if (!defined('MYSQL_TIME_DIFF')) { define('MYSQL_TIME_DIFF', time() - hesk_dbTime()); } if (MYSQL_TIME_DIFF != 0) { $dt += MYSQL_TIME_DIFF; } } // Add HESK set time difference $dt += 3600 * $hesk_settings['diff_hours'] + 60 * $hesk_settings['diff_minutes']; // Daylight saving? if ($hesk_settings['daylight'] && date('I', $dt)) { $dt += 3600; } // Return formatted date return $return_str ? date($hesk_settings['timeformat'], $dt) : $dt; }