Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function add_fleet_member()
- {
- $this->data['unit_list']= $this->munit_list->get_all_unit_list2();
- $this->data['fleet'] = $this->mfleet->get_fleet();
- $this->form_validation->set_rules('id_fleet', 'ID Fleet', 'required');
- $this->form_validation->set_rules('unit_id', 'Unit', 'required');
- if ($this->form_validation->run() == FALSE)
- {
- $this->data['contents'] = $this->load->view('fleet_member',$this->data, true);
- $this->load->view('template/wrapper',$this->data);
- }
- else
- {
- /*$mul_array = $this->input->post('unit_id');
- $mul_val_string = json_encode($mul_array);*/
- //$post=$this->input->post();
- //$unit_id = (isset($post->unit_id)?array_keys($post->unit_id):array());
- $fleet = $this->input->post('id_fleet');
- $unit_id = $this->input->post('unit_id');
- $records = array();
- for ($i=0; $i < count($unit_id) ; $i++) {
- $records[] = array(
- 'id_fleet' => $fleet,
- 'unit_id' => $unit_id[$i]
- );
- }
- $query = $this->database_three->query("select
- count(id_fleet_member) as unit from fleet_member
- where id_fleet = '$fleet' AND unit_id = '$unit_id'
- group by fleet_member.id_fleet");
- $ans = $query->row();
- $check = $this->database_three->query("select fleet.fleet_status, fleet_member.unit_id from fleet Left join fleet_member
- on fleet.id_fleet=fleet_member.id_fleet AND fleet_member.unit_id = '$unit_id' AND fleet.id_fleet = '$id_fleet'");
- /*$this->database_three->affected_rows();
- $this->database_three->last_query();
- */
- if ($ans->unit > 0)
- {
- $this->session->set_flashdata('message', generateErrorMessage('Data Fleet ID Sudah Digunakan'));
- redirect(site_url('fleet_member'));
- }
- else
- {
- if($check == TRUE) {
- $this->session->set_flashdata('message', generateErrorMessage('Data Unit ID Sudah Digunakan'));
- redirect(site_url('fleet_member'));
- }else
- {
- foreach ($records as $data) {
- $query = "insert into fleet_member (id_fleet, unit_id) values ('".$data['id_fleet']."','".$data['unit_id']."')";
- $this->database_three->query($query);
- }
- $this->session->set_flashdata('message', generateSuccessMessage('Data berhasil ditambah'));
- redirect(site_url('fleet_member'));
- }
- }
- /*$query .= "insert into fleet_member (id_fleet, unit_id) values ('".$value['id_fleet']."','".$value['unit_id']."')";*/
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement