<?php
	class Calendar extends DB_Connect{
		private $_useDate;
		private $_m;
		private $_y;
		private $_daysInMonth;
		private $_startDay;

		public function __construct($dbo=NULL, $_useDate=NULL)
		{
			private function _loadEventData($id=NULL){
				$sql = "SELECT
				`event_id`, `event_title`, `event_desc`, `event_start`, `event_end` FROM `calendar`";
				if(!empty($id)){
					$sql .="WHERE `event_id`=:id LIMIT 1";
				}
				else{
					$start_ts = mktime(0,0,0, $this->_m, 1, $this->_y);
					$end_ts = mktime(23,59,59,$this->_m+1,0,$this->_y);
					$start_date = date('Y-m-d H:1:s', $start_ts);
					$end_date = date('Y-m-d H:1:s', $end_ts);

					$sql .="WHERE `event_start`
						BETWEEN '$start_date'
						AND '$end_date'";
				}
				try{
					$stmt = $this->db->prepare($sql);
					if( !empty($id)){
						$stmt->bimdParam(":id", $id, PDO::PARAM_INT);
					}
					$stmt->execute();
					$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
					$stmt->closeCursor();

					return $results;
				}
				catch ( Exception $e){
					die ( $e->getMessage());
				}

			}
			private function _createEventObj(){
				$arr = $this->_loadEventData();
				$events = array();
				foreach ($arr as $event){
					$day = date('j', strtotime($event['event_start']));
					try{
						$events[$day][] = new Event($event);
					}
					catch( Exception $e){
						die ( $e->getMessage());
					}
				}
				return $events;
			}
			parent::__construct($dbo);
			if( isset($useDate)){
				$this->useDate = date('Y-m-d H:i:s');
			}
			$ts = strtotime($this->_useDate);
			$this->_m = date('m', $ts);
			$this->_y = date('Y', $ts);

			$this->_daysInMonth = cal_days_in_mounth(
				CAL_GREGORIAN,
				$this->_m,
				$this_>_y
				);

			$ts = mktime(0,0,0, $this->_m, 1, $this->_y);
			$this->_startDay = date('w', $ts);


		}	}


?>