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