File manager - Edit - /home/wwwroot/camplus.hk/master.camplus.hk/public_html/application/modules/event_booking/models/Venues_model.php
Back
<?php Class Venues_Model extends CI_Model{ function get_venues($id = 0, $order = 0) { $this->db->select('venues.*,users.username,venue_group.title as venuegroup_title'); $this->db->join('eb_venues','venues.id = eb_venues.venue_id','left'); $this->db->join('users','users.id = eb_venues.approver_user_id','left'); $this->db->join('venue_group','venue_group.id = venues.venuegroup','left'); if($id > 0) $this->db->where('venuegroup',$id); if($order==1) { $this->db->order_by('order','ASC'); } return $this->db->get_where('venues')->result_array(); } function get_venue($id) { //$this->db->order_by('title', 'asc'); $this->db->select('eb_venues.is_enabled,eb_venues.need_approval,eb_venues.approver_user_id,venues.*'); $this->db->join('eb_venues','eb_venues.venue_id = venues.id'); return $this->db->get_where('venues',array('venues.id' => $id))->row_array(); } function get_venueGroups(){ $returnData = $this->db->get_where('venue_group')->result_array(); foreach ($returnData as $key => $value) { $this->db->select('eb_venues.is_enabled,eb_venues.need_approval,eb_venues.approver_user_id,venues.*'); $this->db->join('eb_venues','eb_venues.venue_id = venues.id'); $returnData[$key]['venues'] = $this->db->get_where('venues',array('venuegroup' => $value['id']))->result_array(); } return $returnData; } function list_approval($start=0,$limit=0,$search='',$uid=0) { //Venues $this->db->select('eb_venues.is_enabled,eb_venues.need_approval,eb_venues.approver_user_id,venues.*'); $this->db->join('eb_venues','eb_venues.venue_id = venues.id'); $venues = $this->db->get_where('venues',array('need_approval' => 1,'FIND_IN_SET('.$uid.',approver_user_id) !=' => 0))->result_array(); foreach ($venues as $venue) $venueArray[] = $venue['id']; if(!empty($venueArray)){ if($limit!=0 && $limit!=-1) { $this->db->limit($limit, $start); } if($search!='') { $this->db->where('events.event_title LIKE "%'.$search . '%"'); } $this->db->order_by('event_has_sections.startDate', 'ASC'); // $this->db->order_by($order, $dir); $this->db->select('events.*,event_has_sections.startDate,event_has_sections.from_time, event_has_sections.id as section_id,event_has_sections.to_time,venues.title as venue_title,venues.id as venue_id,event_section_has_venues.status as venue_status,event_section_has_venues.id as update_id'); $this->db->join('event_has_sections','event_has_sections.id = event_section_has_venues.section_id'); $this->db->join('events','events.id = event_has_sections.event_id'); $this->db->join('venues','venues.id = event_section_has_venues.venue_id'); $this->db->join('eb_venues','venues.id = eb_venues.venue_id','left'); $where="(events.status = 'PENDING' OR events.status = 'PUBLISHED')"; // $this->db->where($where); $this->db->where('event_has_sections.startDate >=', date("Y-m-d")); $this->db->where('eb_venues.approver_user_id',$uid); $this->db->where('event_section_has_venues.status','PENDING'); $this->db->where_in('event_section_has_venues.venue_id',$venueArray); $data = $this->db->get_where('event_section_has_venues')->result_array(); $last_query = $this->db->last_query(); if($limit!=0 && $limit!=-1) { $last_query = substr($last_query,0,strpos($last_query,'LIMIT')); } $result = $this->db->query($last_query)->result_array(); $return['count'] = count($result); $return['data'] = $data; return $return; } return false; } function list_no_conflict() { //Venues $this->db->select('eb_venues.is_enabled,eb_venues.need_approval,eb_venues.approver_user_id,venues.*'); $this->db->join('eb_venues','eb_venues.venue_id = venues.id'); $venues = $this->db->get_where('venues',array('need_approval' => 1))->result_array(); foreach ($venues as $venue) $venueArray[] = $venue['id']; if(!empty($venueArray)){ $this->db->order_by('event_has_sections.startDate', 'ASC'); // $this->db->order_by($order, $dir); $this->db->select('events.*,event_has_sections.startDate,event_has_sections.from_time, event_has_sections.id as section_id,event_has_sections.to_time,venues.title as venue_title,venues.id as venue_id,event_section_has_venues.status as venue_status,event_section_has_venues.id as update_id'); $this->db->join('event_has_sections','event_has_sections.id = event_section_has_venues.section_id'); $this->db->join('events','events.id = event_has_sections.event_id'); $this->db->join('venues','venues.id = event_section_has_venues.venue_id'); $this->db->join('eb_venues','venues.id = eb_venues.venue_id','left'); $where="(events.status = 'PENDING' OR events.status = 'PUBLISHED')"; // $this->db->where($where); $this->db->where('event_has_sections.startDate >=', date("Y-m-d")); $this->db->where('event_section_has_venues.status','PENDING'); $this->db->where_in('event_section_has_venues.venue_id',$venueArray); $data = $this->db->get_where('event_section_has_venues')->result_array(); return $data; } return false; } }
| ver. 1.4 |
Github
|
.
| PHP 7.2.34 | Generation time: 1.07 |
proxy
|
phpinfo
|
Settings