<?php error_reporting(E_ALL); $document_root = '/home/home365/public_html'; $domain_name = 'http://www.home365.ca/'; require_once $document_root . '/dbconnect/dbconnect.php'; require_once $document_root . '/utilities/utilities.php'; if (mysql_select_db("home365_ios", $useradmin)) { } else { echo "Error selecting database, exited."; exit; } $start_date = '2014-05-01'; $end_date = '2014-06-10'; var_dump(get_weekly_report($start_date, $end_date)); function get_weekly_report($start_date, $end_date) { global $useradmin; $end_date = strtotime($end_date); $return_array = array(); for ($i = strtotime('Monday', strtotime($start_date)); $i <= $end_date;) { $from = date('Y-m-d', $i); $i = strtotime('+1 week', $i); $to = date('Y-m-d', $i); $selectSQL = "SELECT SQL_CALC_FOUND_ROWS DISTINCT device_id FROM visitor_log WHERE DATE(time_stamp)>='{$from}' AND DATE(time_stamp)<='{$to}' AND user_state='start'"; $get_record = mysql_query_or_die($selectSQL, $useradmin); $row = mysql_fetch_row(mysql_query("SELECT FOUND_ROWS()", $useradmin)); $return_array[$from] = $row[0]; } return $return_array; }
exit; } $start_date = isset($_POST['start']) ? $_POST['start'] : $_GET['start']; $end_date = isset($_POST['end']) ? $_POST['end'] : $_GET['end']; $function = isset($_POST['function']) ? $_POST['function'] : $_GET['function']; $start_pieces = explode("/", $start_date); $start_date = $start_pieces[2] . '-' . $start_pieces[0] . '-' . $start_pieces[1]; $end_pieces = explode("/", $end_date); $end_date = $end_pieces[2] . '-' . $end_pieces[0] . '-' . $end_pieces[1]; if (!empty($function)) { switch ($function) { case "daily": $data_array = get_daily_report($start_date, $end_date); break; case "weekly": $data_array = get_weekly_report($start_date, $end_date); break; default: $data_array = get_daily_report($start_date, $end_date); } } else { $data_array = get_daily_report($start_date, $end_date); } $return_array = array("report" => $data_array); echo json_encode($return_array); function get_daily_report($start_date, $end_date) { global $useradmin; $start = new DateTime($start_date); $end = new DateTime($end_date); $end = $end->modify('+1 day');