} } } } if (!$error) { $_SESSION["aps_range"] = $_POST ? $range : 10; $_SESSION["aps_range_start"] = $_POST && $range == 50 ? $range_start : ""; $_SESSION["aps_range_end"] = $_POST && $range == 50 ? $range_end : ""; // render results $tday = date("Y-m-d"); $tdayStart = $tday . " 00:00:00"; $tmrwStart = date("Y-m-d", time() + 60 * 60 * 24) . " 00:00:00"; $dayAfterTmrwStart = date("Y-m-d", time() + 60 * 60 * 24 * 2) . " 00:00:00"; $thisYearWeek = date("Y") . date("W"); $nextYearWeek = date("Y", time() + 60 * 60 * 24 * 7) . date("W", time() + 60 * 60 * 24 * 7); $qBeef = BookingsHelper::getRowQueryBeef(); // defaults to today switch ($range) { default: case 10: // today $qw = "\nWHERE\n b.statii_id != '6'\n AND\n(b.meet >= '{$tdayStart}' and b.meet < '{$tmrwStart}')\nOR\n(b.arrive >= '{$tdayStart}' and b.arrive < '{$tmrwStart}')\nAND\nb.statii_id != '6'\n"; $qt = "\n(b.meet >= '{$tdayStart}' and b.meet < '{$tmrwStart}') AS use_depart,\n(b.arrive >= '{$tdayStart}' and b.arrive < '{$tmrwStart}') AS use_arrive\n"; break; case 20: // tomorrow $qw = "\nWHERE\nb.statii_id != '6'\nAND\n(b.meet >= '{$tmrwStart}' and b.meet < '{$dayAfterTmrwStart}')\nOR\n(b.arrive >= '{$tmrwStart}' and b.arrive < '{$dayAfterTmrwStart}')\nAND b.statii_id != 6\n"; $qt = "\n(b.meet >= '{$tmrwStart}' and b.meet < '{$dayAfterTmrwStart}') AS use_depart,\n(b.arrive >= '{$tmrwStart}' and b.arrive < '{$dayAfterTmrwStart}') AS use_arrive\n"; break; case 30: // this week