$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";