Esempio n. 1
0
 public function getUpcomingEvent()
 {
     $date = new \DateTime();
     $now = $date->format("Y-m-d H:i:s");
     $ret = array();
     $ret = $this->join('eschedule', 'eschedule.event_id', '=', 'event.event_id')->where('eschedule.eschedule_end_date', '>=', $now)->select('event.*')->groupBy('event.event_id')->orderBy('eschedule.eschedule_start_date')->get();
     return $ret;
 }