File manager - Edit - /home/wwwroot/camplus.hk/master.camplus.hk/public_html/application/modules/event_booking/models/Participants_model.php
Back
<?php Class Participants_Model extends CI_Model{ function get_groups() { return $this->db->get_where('participant_group')->result_array(); } function get_participants() { $this->db->order_by('participants.title','asc'); $data = $this->db->get_where('participants')->result_array(); foreach ($data as $key => $value) { $grpsArray = array(); $this->db->select('participant_group.title as group_title'); $this->db->join('participant_group','participant_group.id = participants_has_groups.group_id'); $this->db->order_by('participant_group.title','asc'); $groups = $this->db->get_where('participants_has_groups',array('participant_id' => $value['id']))->result_array(); if(!empty($groups)) { foreach ($groups as $group) { array_push($grpsArray,$group['group_title']); } } $data[$key]['groups'] = $grpsArray; } return $data; } function get_participant($id) { $data = $this->db->get_where('participants',array('id' => $id))->row_array(); $grpsArray = array(); $this->db->select('participant_group.id as group_id,participant_group.title as group_title'); $this->db->join('participant_group','participant_group.id = participants_has_groups.group_id'); $groups = $this->db->get_where('participants_has_groups',array('participant_id' => $id))->result_array(); if(!empty($groups)) { foreach ($groups as $group) { array_push($grpsArray,$group['group_id']); } } $data['groups'] = $grpsArray; return $data; } function addParticipant($data) { $groups = array(); if(isset($data['groups']) && !empty($data['groups'])) { $groups = $data['groups']; unset($data['groups']); } $this->db->insert('participants',$data); $id = $this->db->insert_id(); if(!empty($groups)) { foreach ($groups as $group) { $dt['participant_id'] = $id; $dt['group_id'] = $group; $this->db->insert('participants_has_groups',$dt); } } return true; } function editParticipant($data,$id) { $groups = array(); if(isset($data['groups']) && !empty($data['groups'])) { $groups = $data['groups']; unset($data['groups']); } if(!isset($data['is_enabled'])) $data['is_enabled'] = 0; $this->db->update('participants',$data,array('id' => $id)); $this->db->delete('participants_has_groups',array('participant_id' => $id)); if(!empty($groups)) { foreach ($groups as $group) { $dt['participant_id'] = $id; $dt['group_id'] = $group; $this->db->insert('participants_has_groups',$dt); } } return true; } function delete_participant($id) { $this->db->delete('participants_has_groups',array('participant_id' => $id)); return $this->db->delete('participants',array('id' => $id)); } function importParticipant($data) { $group = $data['group']; $group_exist = $this->db->get_where('participant_group',array('title' => trim($group)))->row_array(); unset($data['group']); $this->db->insert('participants',$data); $insert_id = $this->db->insert_id(); print_r($insert_id); if(!empty($group)) { if(empty($group_exist)){ $this->db->insert('participant_group',array('title'=>$group)); $group_exist['id'] = $this->db->insert_id(); } $group_insert['group_id'] = $group_exist['id']; $group_insert['participant_id'] = $insert_id; $this->db->insert('participants_has_groups',$group_insert); } return $data; } } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.2.34 | Generation time: 0.35 |
proxy
|
phpinfo
|
Settings