<?php

class ModelModuleEventsScheduler extends Model {

	public function getEvents($customer_id) {
		$events_data = array();
		$time = time();
		$events = $this->db->query("SELECT * FROM " . DB_PREFIX . "events_scheduler WHERE date_end <= " . $time);
		if ($events) {
			foreach ($events->rows as $event) {
				if (!empty($event['roster'])) {
					foreach (unserialize($event['roster']) as $roster) {
						if ($roster['student_id'] == $customer_id) {
							$events_data[] = array(
								'event_id'		=> $event['event_id'],
								'date_time'		=> $event['date_time'],
								'name'			=> $event['class_name'],
'product_id'		=> $event['product_id'],
								'location'		=> $event['location'],
								'class_days'	=> unserialize($event['class_days']),
								'telephone'		=> $event['telephone']
							);
							break;
						}
					}
				}
			}
		}
		return $events_data;
	}

}

?>