Advertisement
Guest User

Untitled

a guest
Dec 22nd, 2014
163
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.76 KB | None | 0 0
  1. function add_fleet_member()
  2.         {
  3.             $this->data['unit_list']= $this->munit_list->get_all_unit_list2();
  4.            
  5.             $this->data['fleet'] = $this->mfleet->get_fleet();
  6.  
  7.             $this->form_validation->set_rules('id_fleet', 'ID Fleet', 'required');
  8.             $this->form_validation->set_rules('unit_id', 'Unit', 'required');
  9.  
  10.             if ($this->form_validation->run() == FALSE)
  11.             {
  12.                 $this->data['contents'] = $this->load->view('fleet_member',$this->data, true);
  13.                 $this->load->view('template/wrapper',$this->data);
  14.             }
  15.             else
  16.             {
  17.                 /*$mul_array = $this->input->post('unit_id');
  18.                 $mul_val_string = json_encode($mul_array);*/
  19.                 //$post=$this->input->post();
  20.                 //$unit_id = (isset($post->unit_id)?array_keys($post->unit_id):array());
  21.  
  22.  
  23.                 $fleet = $this->input->post('id_fleet');
  24.                 $unit_id = $this->input->post('unit_id');
  25.  
  26.                 $records = array();
  27.  
  28.                 for ($i=0; $i < count($unit_id) ; $i++) {
  29.                     $records[] = array(
  30.                         'id_fleet' => $fleet,
  31.                         'unit_id' => $unit_id[$i]
  32.                         );
  33.                 }
  34.  
  35.                 $query = $this->database_three->query("select
  36.                     count(id_fleet_member) as unit from fleet_member
  37.                     where id_fleet = '$fleet' AND unit_id = '$unit_id'
  38.                     group by fleet_member.id_fleet");
  39.                 $ans = $query->row();
  40.  
  41.                 $check = $this->database_three->query("select fleet.fleet_status, fleet_member.unit_id from fleet Left join fleet_member
  42.                     on fleet.id_fleet=fleet_member.id_fleet AND fleet_member.unit_id = '$unit_id' AND fleet.id_fleet = '$id_fleet'");
  43.                 /*$this->database_three->affected_rows();
  44.                 $this->database_three->last_query();
  45. */
  46.                 if ($ans->unit > 0)
  47.                 {
  48.                     $this->session->set_flashdata('message', generateErrorMessage('Data Fleet ID Sudah Digunakan'));
  49.                     redirect(site_url('fleet_member'));    
  50.                 }
  51.                 else
  52.                 {
  53.                     if($check == TRUE) {
  54.                    
  55.                         $this->session->set_flashdata('message', generateErrorMessage('Data Unit ID Sudah Digunakan'));
  56.                     redirect(site_url('fleet_member'));
  57.                     }else
  58.                     {
  59.                         foreach ($records as $data) {
  60.                              $query = "insert into fleet_member (id_fleet, unit_id) values ('".$data['id_fleet']."','".$data['unit_id']."')";
  61.                              $this->database_three->query($query);
  62.                            
  63.                         }
  64.  
  65.                         $this->session->set_flashdata('message', generateSuccessMessage('Data berhasil ditambah'));
  66.                         redirect(site_url('fleet_member'));
  67.                     }
  68.                 }
  69.                
  70.  
  71.                 /*$query .= "insert into fleet_member (id_fleet, unit_id) values ('".$value['id_fleet']."','".$value['unit_id']."')";*/
  72.             }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement