$today = $to_pass['y'] . '/' . $to_pass['m'] . '/' . $to_pass['d'];
$Month = new Calendar_Month_Weekdays($to_pass['y'], $to_pass['m']);
$Day = new Calendar_Day($to_pass['y'], $to_pass['m'], $to_pass['d']);
$currentDateShown = strtotime($to_pass['y'] . '-' . $to_pass['m'] . '-' . $to_pass['d']);
$Yesterday = array('d' => date('d', $Day->prevDay($currentDateShown)), 'm' => date('m', $Day->prevDay($currentDateShown)), 'y' => date('Y', $Day->prevDay($currentDateShown)));
$Tomorrow = array('d' => date('d', $Day->nextDay($currentDateShown)), 'm' => date('m', $Day->nextDay($currentDateShown)), 'y' => date('Y', $Day->nextDay($currentDateShown)));
$selection = array($Day);
$ThisMonth = date("F");
// go to next year if current month is dec
if ($Month->thisMonth() == 12) {
$navNextYear = $Month->nextYear();
} else {
$navNextYear = $Month->thisYear();
}
if ($Month->thisMonth() == 1) {
$navPrevYear = $Month->prevYear();
} else {
$navPrevYear = $Month->thisYear();
}
if (!$to_pass["branch"]) {
$to_pass["branch"] = $_SESSION["auth"]["use_branch"];
}
foreach ($to_pass as $key => $val) {
$query_string .= $key . '=' . $val . '&';
$hidden_fields .= '<input type="hidden" name="' . $key . '" value="' . $val . '" />' . "\n";
}
// url of the calendar frame
$calendar_url = GLOBAL_URL . 'calendar_day.php?' . $query_string;
$today = $to_pass['y'] . '/' . $to_pass['m'] . '/' . $to_pass['d'];
// get list of branches
$sql = "SELECT bra_id,bra_title,bra_colour, COUNT(app_id) AS apps\nFROM branch\nLEFT JOIN appointment ON bra_id = appointment.calendarID AND (app_start >= '" . $today . " 00:00:00' AND app_start <= '" . $today . " 23:59:59') AND appointment.app_status = 'Active'\nWHERE\nbra_status = 'Active' AND bra_id != 4\nGROUP BY bra_id\nORDER BY bra_id";
