PHP get_weekly_report Exemples

Exemple #1

Fichier : get_weekly_report.php Projet : omusico/home365

<?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;
}

Exemple #2

Fichier : get_report.php Projet : omusico/home365

    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');