Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function update_data_nilai()
- {
- $propose_id = $this->uri->segment(4);
- $username = $this->session->userdata('username');
- $namaReviewer = $this->session->userdata('nama');
- // Update ID Point
- $point_id = $this->input->post('id', 'true');
- $jml_data = count($point_id); // Jumlah Data
- $update = date('Y-m-d H:i:s');
- $score = $this->input->post('score', 'true');
- $total = $this->input->post('total', 'true');
- for ($i = 1; $i <= $jml_data; $i++) {
- $q = "UPDATE lemlit_point_proposal SET point_score = '" . $score[$i] . "', point_total = '" . $total[$i] . "' WHERE point_id= " . $point_id[$i];
- $this->db->query($q);
- }
- // Update Total Point Proposal
- $QReviewer = $this->db->query("SELECT * FROM lemlit_reviewer WHERE propose_id='$propose_id'");
- $HReview = $QReviewer->result();
- $Jml_reviewer = count($HReview); // Jumlah Reviewer
- // Hitung Total Point Proposal dibagi Jumlah Reviewer
- $QNilai = $this->db->query("SELECT SUM(point_total) as total FROM lemlit_point_proposal WHERE propose_id='$propose_id'");
- $HNilai = $QNilai->row();
- // Point Proposal
- $Point = ($HNilai->total / $Jml_reviewer);
- $data = array(
- 'propose_point' => $Point,
- 'propose_update' => date('Y-m-d H:i:s'),
- );
- $this->db->where('propose_id', $propose_id);
- $this->db->update('lemlit_propose', $data);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement