Ejemplo n.º 1
0
        $cfilter = "where '" . $user . "' = login";
    }
}
if (!empty($date_from) && !empty($date_to)) {
    if ($cfilter != "" && preg_match('/where/', $cfilter)) {
        $cfilter .= " AND (log_action.date BETWEEN  '{$date_from} 00:00:00' AND  '{$date_to} 23:59:59')";
    } else {
        $cfilter .= " WHERE (log_action.date BETWEEN  '{$date_from} 00:00:00' AND  '{$date_to} 23:59:59')";
    }
}
/*
 * prev and next buttons
 */
$inf_link = $_SERVER["SCRIPT_NAME"] . "?order={$order}" . "&sup=" . ($sup - $ROWS) . "&inf=" . ($inf - $ROWS) . "&user="******"&code=" . $code . "&date_from=" . $date_from . "&date_to=" . $date_to;
$sup_link = $_SERVER["SCRIPT_NAME"] . "?order={$order}" . "&sup=" . ($sup + $ROWS) . "&inf=" . ($inf + $ROWS) . "&user="******"&code=" . $code . "&date_from=" . $date_from . "&date_to=" . $date_to;
$count = Log_action::get_count($conn, $cfilter);
if ($inf >= $ROWS) {
    echo "<a href=\"{$inf_link}\">&lt;- ";
    printf(gettext("Prev %d"), $ROWS);
    echo "</a>";
}
if ($sup < $count) {
    echo "&nbsp;&nbsp;(";
    printf(gettext("%d-%d of %d"), $inf, $sup, $count);
    echo ")&nbsp;&nbsp;";
    echo "<a href=\"{$sup_link}\">";
    printf(gettext("Next %d"), $ROWS);
    echo " -&gt;</a>";
} else {
    echo "&nbsp;&nbsp;(";
    printf(gettext("%d-%d of %d"), $inf, $count, $count);
Ejemplo n.º 2
0
    } else {
        if (is_array($usersf) && !empty($usersf)) {
            $filter .= " AND log_action.login in (" . implode(",", $usersf) . ")";
        }
    }
}
//Code filter
if (!empty($code)) {
    $filter .= " AND log_action.code = '{$code}'";
}
//Date filter
if (!empty($date_from) && !empty($date_to)) {
    $tzc = Util::get_tzc();
    $filter .= " AND convert_tz(log_action.date,'+00:00','" . $tzc . "') between '" . $date_from . " 00:00:00' AND '" . $date_to . " 23:59:59'";
}
$count = Log_action::get_count($conn, "WHERE 1=1" . $filter);
$log_list = Log_action::get_list($conn, $filter, " ORDER by {$order}", $inf, $sup);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
    <title> <?php 
echo _("User action logs");
?>
 </title>
    <meta http-equiv="refresh" content="150"/>
    <meta http-equiv="Pragma" content="no-cache"/>
    <link rel="stylesheet" href="../style/av_common.css?t=<?php 
echo Util::get_css_id();
?>
"/>