public function find()
{
// var_dump(Post::type('venues')->status('publish')->get()->toArray()); // get pages
// $venues = $this->_db->table('users')->find(1);
$venues = Post::type('venue')->status('publish')->get()->toArray();
return View::make('pages.venue.find', array('venues' => $venues));
}
/**
* Get venue details
*
* @param int $venueId
* @return array
*/
public static function details($venueId)
{
$venue = Post::type('venue')->status('publish')->whereId($venueId)->get()->first();
if ($venue) {
return $venue->toArray();
}
return NULL;
}
public function getForCurrentDate($date, $venue_id)
{
$query = Post::type('timeslot')->select(array('post_title', 'post_status'))->where('post_status', '=', 'publish')->whereRaw('`t1`.`meta_value` = ?', [$venue_id])->whereRaw('DATE(`t2`.`meta_value`) = ?', [$date]);
$relationships = array('postmeta' => array('post_id' => array('timeslot_venue', 'date', 'timeslot_user')));
$query = self::queryLevel($query, $relationships);
return $query->get()->toArray();
}
