}
include _TRACK_SHOW_COMMON_PATH . "/functions_report.php";
// Connect to DB
mysql_connect($_DB_HOST, $_DB_LOGIN, $_DB_PASSWORD) or die("Could not connect: " . mysql_error());
mysql_select_db($_DB_NAME);
mysql_query('SET NAMES utf8');
mysql_query("SET @@GLOBAL.sql_mode= ''");
mysql_query("SET @@SESSION.sql_mode= ''");
if ($_REQUEST['ajax_act'] == 'a_load_flow') {
$filter_by = isset($_REQUEST['filter_by']) ? $_REQUEST['filter_by'] : 'none';
$filter_value = isset($_REQUEST['filter_value']) ? $_REQUEST['filter_value'] : '';
// 20 - first request limit, 100 - second and next request limit
$offset = isset($_REQUEST['offset']) ? $_REQUEST['offset'] + 100 : 20;
$IN = array();
$IN['flow_report'] = array('date' => $_REQUEST['date'], 'filter_by' => $filter_by, 'filter_value' => $filter_value);
list($more, $arr_data, $offset) = get_visitors_flow_data($IN, 'flow_report', 100, $offset);
$out = array('more' => $more, 'data' => $arr_data, 'offset' => $offset);
echo json_encode($out);
exit;
}
if ($_REQUEST['ajax_act'] == 'a_load_sales_flow') {
// 20 - first request limit, 100 - second and next request limit
$offset = isset($_REQUEST['offset']) ? $_REQUEST['offset'] + 100 : 20;
if ($_REQUEST['filter_by'] == 'subid') {
$offset = 0;
}
if ($_REQUEST['limit'] != '') {
$limit = $_REQUEST['limit'];
} else {
$limit = 100;
}
case 'register_admin':
$page_top_menu = "top_menu_empty.php";
$sidebar_inc = "left-sidebar-empty.php";
$page_content = "register.php";
exit;
break;
default:
$search = $_REQUEST['search'];
$filter = '';
if ($_REQUEST['filter_by'] != '') {
switch ($_REQUEST['filter_by']) {
case 'search':
$filter = array('filter_by' => $_REQUEST['filter_by'], 'filter_value' => $_REQUEST['search'], 'date' => $_REQUEST['date']);
break;
case 'hour':
$filter = array('filter_by' => $_REQUEST['filter_by'], 'source_name' => $_REQUEST['source_name'], 'date' => $_REQUEST['date'], 'hour' => $_REQUEST['hour']);
break;
default:
$filter = array(filter_by => $_REQUEST['filter_by'], filter_value => $_REQUEST['value']);
break;
}
}
list($total, $arr_data) = get_visitors_flow_data($filter, 0, 20, $_REQUEST['date']);
$page_sidebar = 'sidebar-left-reports.inc.php';
$page_content = "stats-flow.php";
include _TRACK_SHOW_COMMON_PATH . "/templates/main.inc.php";
exit;
break;
}
break;
}
foreach ($allowed_report_in_params as $report => $data) {
foreach (array_keys($allowed_report_in_params[$report]) as $cur) {
if (isset($_REQUEST[$cur]) && $_REQUEST[$cur] != '') {
$IN[$report][$cur] = $_REQUEST[$cur];
} else {
// Set default value
$IN[$report][$cur] = $allowed_report_in_params[$report][$cur];
}
}
}
// Get hourly report data
$arr_report_data = prepare_report('main-report', $IN['hourly_report'] + array('report_type' => 'stats_flow', 'range_type' => 'hourly', 'date_start' => $IN['flow_report']['date'], 'date_end' => $IN['flow_report']['date']));
// Don't use parameters from hourly report
unset($arr_report_data['report_params']);
// Get clicks flow data
list($more, $arr_flow_data, $s, $s1) = get_visitors_flow_data($IN, 'flow_report');
// Fill variables for stats-flow report
$arr_flow_data['show_more'] = $more;
$date_prev = date('Y-m-d', strtotime('-1 days', strtotime($IN['flow_report']['date'])));
$date_next = date('Y-m-d', strtotime('+1 days', strtotime($IN['flow_report']['date'])));
$arr_template_data = array('hide-table-footer' => true, 'date_current' => $IN['flow_report']['date'], 'date_prev_caption' => mysqldate2string($date_prev), 'date_current_caption' => mysqldate2string($IN['flow_report']['date']), 'date_next_caption' => mysqldate2string($date_next), 'hide_next_day' => $IN['flow_report']['date'] == get_current_day(), 'date_prev' => $date_prev, 'date_next' => $date_next, 'csrf' => CSRF_KEY);
// Render template
echo $mTemplate->render('stats-flow-page', $arr_report_data + $arr_template_data + $arr_flow_data);
?>
<script type="text/javascript">
function refresh_report(param_name, param_value)
{
switch (param_name)
{
default:
