File manager

File manager - Edit - /home/wwwroot/camplus.hk/master.camplus.hk/public_html/application/modules/venue/models/Venue_model.php

Back
<?php Class Venue_Model extends CI_Model{ function get_venues($id = 0, $order = 0) { $eb = checkModule('event_booking'); $this->db->select('venues.,venue_group.title as venuegroup_title'); if($eb) { $this->db->select('eb_venues.is_enabled,eb_venues.need_approval,eb_venues.approver_user_id,venues.'); $this->db->select('users.username'); $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) { $eb = checkModule('event_booking'); if($eb) { $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','left'); } 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 deleteVenue($id) { $this->db->delete('eb_venues',array('venue_id' => $id)); return $this->db->delete('venues',array('id' => $id)); } function addVenue($data) { if(!isset($data['is_enabled'])) { $eb_venue['is_enabled'] = 0; } else { $eb_venue['is_enabled'] = $data['is_enabled']; } if(!isset($data['need_approval'])) { $eb_venue['need_approval'] = 0; $eb_venue['approver_user_id'] = 0; } else { $eb_venue['need_approval'] = $data['need_approval']; $eb_venue['approver_user_id'] = $data['approver_user_id']; } unset($data['is_enabled']); unset($data['need_approval']); unset($data['approver_user_id']); $this->db->insert('venues',$data); $eb_venue['venue_id'] = $this->db->insert_id(); return $this->db->insert('eb_venues',$eb_venue); } function editVenue($data,$id) { if(!isset($data['is_enabled'])) { $eb_venue['is_enabled'] = 0; } else { $eb_venue['is_enabled'] = $data['is_enabled']; } if(!isset($data['need_approval'])) { $eb_venue['need_approval'] = 0; $eb_venue['approver_user_id'] = 0; } else { $eb_venue['need_approval'] = $data['need_approval']; $eb_venue['approver_user_id'] = $data['approver_user_id']; } $exist = $this->db->get_where('eb_venues',array('venue_id' => $id))->row_array(); if(!empty($exist)){ $this->db->update('eb_venues',$eb_venue,array('venue_id' => $id)); }else { $eb_venue['venue_id']=$id; $this->db->insert('eb_venues',$eb_venue); } unset($data['is_enabled']); unset($data['need_approval']); unset($data['approver_user_id']); return $this->db->update('venues',$data,array('id' => $id)); } //need revise function importVenue($data) { $venuedata['title'] = $data['title']; $venuedata['remarks'] = $data['remarks']; if(!empty($data['order'])) $venuedata['order'] = $data['order']; $group_exist = $this->db->get_where('venue_group',array('title' => trim($data['group'])))->row_array(); if(!empty($group_exist)) $venuedata['venuegroup'] = $group_exist['id']; unset($data['group']); $this->db->insert('venues',$venuedata); //echo $this->db->last_query();exit; $data['venue_id'] = $this->db->insert_id(); $eb = checkModule('event_booking'); if($eb) { unset($data['title']); unset($data['remarks']); if(!empty($data['order'])) unset($data['order']); if($data['approver_username'] != ''){ $user = $this->db->get_where('users',array('username' => $data['approver_username']))->row_array(); if(!empty($user)){ unset($data['approver_username']); $data['approver_user_id'] = $user['id']; return $this->db->insert('eb_venues',$data); } else return false; } else { unset($data['approver_username']); return $this->db->insert('eb_venues',$data); } } } function usage() { $today = date('Y-1-1'); $this->db->select('count(venues.id) as count, venues.id, venues.title'); $this->db->from('venues'); $this->db->join('event_section_has_venues', 'event_section_has_venues.venue_id = venues.id'); $this->db->join('event_has_sections', 'event_section_has_venues.section_id = event_has_sections.id'); $this->db->group_by('venues.id'); $this->db->where(' event_has_sections.startDate >', $today,false ); return $this->db->get()->result_array(); } //check unique venue title function getVenue_title($title = 0) { return $this->db->get_where('venues',array('title' => $title))->row_array(); } function importVenues($data) { foreach($data as $key => $value) { if($key!=0) { $venuedata['title'] = $value[0]; if(!empty($value[3])) $venuedata['order'] = $value[3]; $group_exist = $this->db->get_where('venue_group',array('title' => trim($value[1])))->row_array(); if(!empty($group_exist)) $venuedata['venuegroup'] = $group_exist['id']; $this->db->insert('venues',$venuedata); //echo $this->db->last_query();exit; $eb_venues_data['venue_id'] = $this->db->insert_id(); $eb_venues_data[is_enabled]=1; $eb_venues_data['need_approval']=0; $eb = checkModule('event_booking'); if($eb) { if($value[2] != ''){ $user = $this->db->get_where('users',array('username' => $value[2]))->row_array(); if(!empty($user)){ $eb_venues_data['need_approval']=1; $eb_venues_data['approver_user_id'] = $user['id']; $this->db->insert('eb_venues',$eb_venues_data); } else { $this->db->insert('eb_venues',$eb_venues_data); } } else { $this->db->insert('eb_venues',$eb_venues_data); } }else { $eb_venues_data[is_enabled]=0; $eb_venues_data['need_approval']=0; $this->db->insert('eb_venues',$eb_venues_data); } unset($venuedata); unset($eb_venues_data); } } return true; } function checkUnique($array) { return $this->db->get_where('venues', array($array['field'] => $array[$array['field']]))->row_array(); } }

| ver. 1.4 | Github | . | PHP 7.2.34 | Generation time: 0.16 | proxy | phpinfo | Settings