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;
}