$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}\"><- "; printf(gettext("Prev %d"), $ROWS); echo "</a>"; } if ($sup < $count) { echo " ("; printf(gettext("%d-%d of %d"), $inf, $sup, $count); echo ") "; echo "<a href=\"{$sup_link}\">"; printf(gettext("Next %d"), $ROWS); echo " -></a>"; } else { echo " ("; printf(gettext("%d-%d of %d"), $inf, $count, $count);
} 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(); ?> "/>