예제 #1
0
 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));
 }
예제 #2
0
 public function insert($data, $userId)
 {
     $post = new Post();
     $post->post_title = $data['title_a'];
     $post->post_name = sanitize_title_with_dashes($data['title_a']);
     $post->post_type = $this->slug;
     $post->post_status = 'publish';
     $post->post_author = $userId;
     $post->ping_status = 'closed';
     $temp = array('address' => $data['address'], 'city' => $data['city'], 'state' => $data['state'], 'postcode' => $data['postcode'], 'country' => $data['country']);
     $post->save();
     foreach ($temp as $metaKey => $metaValue) {
         $postmeta = new PostMeta();
         $postmeta->timestamps = FALSE;
         $postmeta->post_id = $post->ID;
         $postmeta->meta_key = $metaKey;
         $postmeta->meta_value = $metaValue;
         $postmeta->save();
     }
     return $post;
 }
예제 #3
0
 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();
 }