Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $total_mhs = count($this->input->post('mhs'));
- $ta = $this->session->userdata('ta');
- $npm = $this->input->post('mhs',TRUE);
- $this->db->where_in('npm_mahasiswa', $npm);
- $this->db->where('tahunajaran', $ta);
- $this->db->delete('tbl_khs');
- for ($i=1; $i <= $total_mhs; $i++) {
- $nim = $this->input->post('mhs['.$i.']');
- $ips = $this->input->post('ips['.$i.']');
- $totsks = $this->input->post('sks['.$i.']');
- $ipk = $this->input->post('ipk['.$i.']');
- $sks_smt = $this->input->post('smt['.$i.']');
- $datax[] = [
- 'npm_mahasiswa' => $nim,
- 'tahunajaran' => $ta,
- 'ips' => $ips,
- 'total_sks' => $totsks,
- 'ipk' => $ipk
- ];
- $param = ['THSMSTRAKM' => $ta, 'NIMHSTRAKM' => $nim];
- $is_data_available = $this->db->get_where('tbl_aktifitas_kuliah_mahasiswa', $param)->num_rows();
- if ($is_data_available > 0) {
- $datas = [
- 'SKSTTTRAKM' => $totsks,
- 'NLIPKTRAKM' => $ipk
- ];
- $this->db->where('NIMHSTRAKM', $nim);
- $this->db->where('THSMSTRAKM', $ta);
- $this->db->update('tbl_aktifitas_kuliah_mahasiswa', $datas);
- } else {
- $data_akm = [
- 'THSMSTRAKM' => $ta,
- 'KDPTITRAKM' => '031036',
- 'KDJENTRAKM' => 'C',
- 'KDPSTTRAKM' => $this->userid,
- 'NIMHSTRAKM' => $nim,
- 'SKSEMTRAKM' => $sks_smt,
- 'NLIPSTRAKM' => $ips,
- 'SKSTTTRAKM' => $totsks,
- 'NLIPKTRAKM' => $ipk
- ];
- $this->db->insert('tbl_aktifitas_kuliah_mahasiswa', $data_akm);
- }
- }
- $this->db->insert_batch('tbl_khs',$datax);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement