Example #1
0
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();
}
Example #2
0
 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();
 }