$page = 1;
}
$view_option = 'monthly';
$limit = 47;
if (!empty($_GET['view'])) {
if ($_GET['view'] == 'weekly') {
$limit = 7;
$view_option = 'weekly';
}
}
$start = time() + ($page - 1) * $limit * 86400;
$offset = strtotime("Monday this week", $start);
$dbh = new DBWorker();
$apps = null;
$get_apps = 'SELECT * FROM apps WHERE app_date > UNIX_TIMESTAMP(NOW())';
$apps = DBWorker::getRows($get_apps);
function search($time)
{
global $apps;
if (!empty($apps)) {
foreach ($apps as $app) {
if (in_array($time, $app)) {
return $app['app_date'];
}
}
}
return false;
}
$stats = array('today' => 0, 'this_week' => 0, 'this_month' => 0, 'this_year' => 0);
function countApps()
{
<?php
/**
* Created by JetBrains PhpStorm.
* User: Peter
* Date: 8/9/15
* Time: 11:13 PM
* To change this template use File | Settings | File Templates.
*/
require_once "auth.inc.php";
require_once "includes/database/DBWorker.php";
$day = !empty($_GET['app']) ? intval($_GET['app']) : 0;
$apps = null;
$lower_limit = strtotime('midnight today', $day);
$upper_limit = $lower_limit + 86400;
$app_to_delete = !empty($_GET['h']) ? $_GET['h'] : null;
if ($app_to_delete) {
DBWorker::lookup('DELETE FROM apps WHERE id = :id', ':id', $app_to_delete);
}
$get_apps_today = "SELECT * FROM apps WHERE app_date >= {$lower_limit} AND app_date <= {$upper_limit}";
$apps = DBWorker::getRows($get_apps_today);
//echo '<pre>', print_r($apps), '</pre>';
