public function seats($reload = false)
{
if ($reload || !$this->seats_cache) {
$id = mysql_real_escape_string($this->id);
$this->seats_cache = EventSeat::find_all("event_seats.seating_group_id = '{$id}'", "event_seats.row ASC, event_seats.number + 0 ASC");
}
return $this->seats_cache;
}
protected function load_seat($event = null, $id = null)
{
if (!$event) {
$event = $this->load_event();
}
if (!$id) {
$id = $this->getData('seat_id');
}
$obj = EventSeat::find_by_id($id);
if ($obj && $obj->event_id == $event->id) {
return $obj;
} else {
throw new Error404('Unable to find the seat');
}
}
protected static function load_seat($id, $event)
{
$seat_id = mysql_real_escape_string($id);
$event_id = mysql_real_escape_string($event->id);
$seat = EventSeat::find("event_seats.id = '{$seat_id}' AND event_seats.event_id = '{$event_id}'");
if ($seat) {
return $seat;
} else {
Error404();
}
}
protected static function load_seat($event, $id = null)
{
if (!$id) {
$id = $_GET['id'];
}
$id = mysql_real_escape_string($id);
$event_id = mysql_real_escape_string($event->id);
$event_seat = EventSeat::find("event_seats.id = {$id} AND event_seats.event_id = '{$event_id}'", null, false, 1);
if ($event_seat) {
return $event_seat;
} else {
Error404();
}
}
protected static function get_fields()
{
return self::select_fields() . ", " . User::select_fields() . ", " . EventTicket::select_fields() . ", " . Event::select_fields() . ", " . EventSeat::select_fields() . ", " . User::select_fields('managers');
}
