novalsmith

simpan_entry

Jul 27th, 2016
242
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.16 KB | None | 0 0
  1. public function simpan_entry($id)
  2.     {
  3.        
  4.      $ambil_sks = $this->Entry_model->sum_sks_banding($this->session->userdata('id_mahasiswa'));
  5.    
  6. //periksa di tabel mk_syarat ada atau tidak
  7.        $mk_syarat_loop =$this->db->query('SELECT * FROM `mk_syarat` WHERE id_mk='.$id)->num_rows();
  8.      $mk_syarat =$this->db->query('SELECT * FROM `mk_syarat` WHERE id_mk='.$id)->row();
  9.       $data = $this->db->get_where('matakuliah',array('id_mk'=>$mk_syarat->syarat))->row();
  10.        $data_tampil = $this->db->get_where('matakuliah',array('id_mk'=>$id))->row();
  11.  //untuk hitung ip sebelumnya (ips)
  12.          $ips = $this->Nilai_model->mutu($this->session->userdata('id_mahasiswa'));
  13.          $ips_sks = $this->Nilai_model->ips_sks($this->session->userdata('id_mahasiswa'));
  14.            
  15.          $sks_sebelum = $ips->total_mutu / $ips_sks->total_sks ;
  16.                         echo number_format($sks_sebelum,2 );
  17.     //untuk hitung ip sebelumnya (ips)
  18.  
  19.      $mk_syarat_loop =$this->db->query('SELECT * FROM `mk_syarat` WHERE id_mk='.$id)->num_rows();
  20.                         if ($mk_syarat_loop) {
  21.                            
  22.      
  23.      // SAYA BINGGUNG NYA DI SINI
  24.     // PAKE ->row(), hanya satu data saja
  25.     //gimana biar datanya looping
  26.  
  27.  
  28.    $tampung = $this->Entry_model->join_mk_syarat($mk_syarat->syarat,$this->session->userdata('id_mahasiswa'))->row();                
  29.                        
  30.          if ($tampung->akhir < 56) {
  31.              
  32.  
  33.  $this->session->set_flashdata('message',
  34.                 '<div class="alert alert-danger">
  35. <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
  36.        <strong>Oppss!</strong>  HARUS LULUS MATAKULIAH <strong>'.$data->nama_matakuliah.' </strong>
  37.  
  38.                 </div>');
  39.  
  40.             redirect(site_url('entry'));
  41.          }else
  42.          {
  43.  
  44.  
  45.  $data = array(
  46.         'id_semester' => $data_tampil->id_semester,
  47.         'id_mahasiswa' => $this->session->userdata('id_mahasiswa'),
  48.         'id_mk' => $data_tampil->id_mk,
  49.           'waktu_entry'  => date('Y-m')
  50.         );
  51.  
  52.             $this->Entry_model->insert($data);
  53.  
  54.  $this->session->set_flashdata('message',
  55.                 '<div class="alert alert-success">
  56. <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
  57.        <strong>Success Saved!</strong> Your Data is Successful.
  58.  
  59.                 </div>');
  60.  
  61.             redirect(site_url('entry'));
  62.  
  63.          }
  64.  
  65.  
  66.                         }
  67.  
  68.                       else
  69.                       {
  70.  
  71.  $data = array(
  72.     'id_semester' => $data_tampil->id_semester,
  73.         'id_mahasiswa' => $this->session->userdata('id_mahasiswa'),
  74.         'id_mk' => $data_tampil->id_mk,
  75.           'waktu_entry'  => date('Y-m')
  76.         );
  77.  
  78.             $this->Entry_model->insert($data);
  79.  
  80.  $this->session->set_flashdata('message',
  81.                 '<div class="alert alert-success">
  82. <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
  83.        <strong>Success Saved!</strong> Your Data is Successful.
  84.  
  85.                 </div>');
  86.  
  87.             redirect(site_url('entry'));
  88.  
  89.                       }
  90.              
  91.  
  92.  
  93.  
  94.  
  95.  
  96.  
  97.  
  98.  
  99.  
  100.  
  101. }
Advertisement
Add Comment
Please, Sign In to add comment