****************************************************************************
* PLEASE READ THE FULL TEXT OF THE SOFTWARE LICENSE AGREEMENT IN THE *
* "copyright.txt" FILE PROVIDED WITH THIS DISTRIBUTION PACKAGE. *
****************************************************************************/
//
// $Id: logs.php 10229 2010-07-27 14:21:39Z 2tl $
//
if (!defined('AREA')) {
die('Access denied');
}
if ($mode == 'clean') {
db_query("TRUNCATE TABLE ?:logs");
return array(CONTROLLER_STATUS_REDIRECT, "logs.manage");
}
if ($mode == 'manage') {
list($logs, $search, $total) = fn_get_logs($_REQUEST);
$view->assign('logs', $logs);
$view->assign('search', $search);
$view->assign('log_types', fn_get_log_types());
$view->assign('total', $total);
}
function fn_get_logs($params, $items_per_page = null)
{
// Init filter
$params = fn_init_view('logs', $params);
if ($items_per_page === null) {
$items_per_page = Registry::get('settings.Appearance.admin_elements_per_page');
}
$sortings = array('timestamp' => '?:logs.timestamp', 'user' => array('?:users.lastname', '?:users.firstname'));
$directions = array('asc' => 'asc', 'desc' => 'desc');
$fields = array('?:logs.*', '?:users.firstname', '?:users.lastname');
}
if (!fn_check_view_permissions('sales_reports.view', 'GET')) {
$orders_stat['orders_total'] = array();
$orders_stat['prev_orders_total'] = array();
}
/* /Orders */
/* Order statuses */
$order_statuses = array();
if (fn_check_view_permissions('orders.manage', 'GET')) {
$order_statuses = fn_get_statuses(STATUSES_ORDER, array(), false, true);
}
/* /Order statuses */
/* Recent activity block */
$logs = array();
if (fn_check_view_permissions('logs.manage', 'GET')) {
list($logs, $search) = fn_get_logs(array('time_from' => $time_from, 'time_to' => $time_to, 'period' => 'C'), 10);
// Get last 10 items
}
/* /Recent activity block */
/* Order by statuses */
$order_by_statuses = array();
if (fn_check_view_permissions('orders.manage', 'GET')) {
$company_condition = fn_get_company_condition('?:orders.company_id');
$order_by_statuses = db_get_array("SELECT " . "?:status_descriptions.description as status_name, " . "?:orders.status, " . "COUNT(*) as count, " . "SUM(?:orders.total) as total, " . "SUM(?:orders.shipping_cost) as shipping " . "FROM ?:orders " . "INNER JOIN ?:status_descriptions " . "ON ?:status_descriptions.status = ?:orders.status " . "WHERE ?:status_descriptions.type = ?s " . "AND ?:orders.timestamp > ?i " . "AND ?:orders.timestamp < ?i " . "AND ?:status_descriptions.lang_code = ?s " . "?p " . "GROUP BY ?:orders.status ", 'O', $time_from, $time_to, CART_LANGUAGE, $company_condition);
}
/* /Order by statuses */
/* Statistics */
$graphs = fn_dashboard_get_graphs_data($time_from, $time_to, $is_day);
/* /Statistics */
if (!empty($_SESSION['stats'])) {
$stats .= implode('', $_SESSION['stats']);
* *
* (c) 2004 Vladimir V. Kalynyak, Alexey V. Vinokurov, Ilya M. Shalnev *
* *
* This is commercial software, only users who have purchased a valid *
* license and accept to the terms of the License Agreement can install *
* and use this program. *
* *
****************************************************************************
* PLEASE READ THE FULL TEXT OF THE SOFTWARE LICENSE AGREEMENT IN THE *
* "copyright.txt" FILE PROVIDED WITH THIS DISTRIBUTION PACKAGE. *
****************************************************************************/
use Tygh\Registry;
if (!defined('BOOTSTRAP')) {
die('Access denied');
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if ($mode == 'clean') {
if (Registry::get('runtime.company_id')) {
db_query('DELETE FROM ?:logs WHERE company_id = ?i', Registry::get('runtime.company_id'));
} else {
db_query('TRUNCATE TABLE ?:logs');
}
}
return array(CONTROLLER_STATUS_REDIRECT, "logs.manage");
}
if ($mode == 'manage') {
list($logs, $search) = fn_get_logs($_REQUEST, Registry::get('settings.Appearance.admin_elements_per_page'));
Tygh::$app['view']->assign('logs', $logs);
Tygh::$app['view']->assign('search', $search);
Tygh::$app['view']->assign('log_types', fn_get_log_types());
}
