Advertisement
jamboljack

Proses Update Data Nilai

Jan 14th, 2019
397
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.54 KB | None | 0 0
  1. public function update_data_nilai()
  2.     {
  3.         $propose_id   = $this->uri->segment(4);
  4.         $username     = $this->session->userdata('username');
  5.         $namaReviewer = $this->session->userdata('nama');
  6.  
  7.         // Update ID Point
  8.         $point_id = $this->input->post('id', 'true');
  9.         $jml_data = count($point_id); // Jumlah Data
  10.         $update   = date('Y-m-d H:i:s');
  11.         $score    = $this->input->post('score', 'true');
  12.         $total    = $this->input->post('total', 'true');
  13.  
  14.         for ($i = 1; $i <= $jml_data; $i++) {
  15.             $q = "UPDATE lemlit_point_proposal SET point_score = '" . $score[$i] . "', point_total = '" . $total[$i] . "' WHERE point_id= " . $point_id[$i];
  16.             $this->db->query($q);
  17.         }
  18.  
  19.         // Update Total Point Proposal
  20.         $QReviewer    = $this->db->query("SELECT * FROM lemlit_reviewer WHERE propose_id='$propose_id'");
  21.         $HReview      = $QReviewer->result();
  22.         $Jml_reviewer = count($HReview); // Jumlah Reviewer
  23.         // Hitung Total Point Proposal dibagi Jumlah Reviewer
  24.         $QNilai = $this->db->query("SELECT SUM(point_total) as total FROM lemlit_point_proposal WHERE propose_id='$propose_id'");
  25.         $HNilai = $QNilai->row();
  26.         // Point Proposal
  27.         $Point = ($HNilai->total / $Jml_reviewer);
  28.  
  29.         $data = array(
  30.             'propose_point'  => $Point,
  31.             'propose_update' => date('Y-m-d H:i:s'),
  32.         );
  33.  
  34.         $this->db->where('propose_id', $propose_id);
  35.         $this->db->update('lemlit_propose', $data);
  36.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement