Ejemplos de hesk_dbTime en PHP

Ejemplo n.º 1

Archivo: ticket_list.inc.php Proyecto: Orgoth/Mods-for-HESK

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&amp;s', array_keys($status)) . '=1';
        $query .= '&amp;p' . implode('=1&amp;p', array_keys($priority)) . '=1';
        $query .= '&amp;category=' . $category;
        $query .= '&amp;sort=' . $sort;
        $query .= '&amp;asc=' . $asc;

Ejemplo n.º 2

Archivo: admin_functions.inc.php Proyecto: abuhannan/aduan

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}";
}

Ejemplo n.º 3

Archivo: common.inc.php Proyecto: ermedita-xhafaj/support

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;
}