MDCC daily run report
HTML;
$dbh = new PDO('mysql:host=localhost;dbname=mdcc', 'mdcc', 'Mdcc.');
for ( $i=0; $i<7; $i++ ) {
$this_day = date("Y-m-d", strtotime("-{$i} days"));
$pretty_day = date("l, F j, Y", strtotime("-{$i} days"));
$sql_first_run = "SELECT count(court_case_no) AS cnt FROM cases WHERE DATE(date_entered) = '{$this_day}' AND TIME(date_entered) < '22:00:00'";
$sql_second_run = "SELECT count(court_case_no) AS cnt FROM cases WHERE DATE(date_entered) = '{$this_day}' AND TIME(date_entered) >= '22:00:00'";
$st_first_run = $dbh->prepare($sql_first_run);
if ( $st_first_run->execute() ) {
$first_run_count = $st_first_run->fetchColumn();
}
$st_second_run = $dbh->prepare($sql_second_run);
if ( $st_second_run->execute() ) {
$second_run_count = $st_second_run->fetchColumn();
}
echo <<
$pretty_day:
Noon pull: {$first_run_count}
6PM pull: {$second_run_count}
HTML;
}
echo <<
HTML;
?>