function calendar_userapi_getevents($args) { extract($args); $xartable = xarDB::getTables(); $q = new Query('SELECT'); $q->addtable($xartable['calendar_event']); $q->ge('start_time', $day->thisDay(TRUE)); $q->lt('start_time', $day->nextDay(TRUE)); if (!$q->run()) { return; } return $q->output(); }
public function getEvents($start_time, $end_time, $role_id) { // get all the events. need to improve this query and combine it with the query in the template $xartable = xarDB::getTables(); $q = new Query('SELECT', $xartable['calendar_event']); $q->ge('start_time', $start_time); $q->lt('start_time', $end_time); $q->eq('role_id', $role_id); // $q->qecho(); if (!$q->run()) { return; } return $q->output(); }