Update Nilai dari Reviewer

public function updatenilai_post()
    {
        $username    = trim($this->post('username'));
        $id          = $this->post('id');
        $point_id    = $this->post('point_id');
        $reviewer_id = $this->post('reviewer_id');
        $score       = $this->post('score');

        if ($username == '') {
            $response = [
                'resp_error' => true,
                'resp_msg'   => 'Username Kosong.',
            ];
        } elseif ($id == '') {
            $response = [
                'resp_error' => true,
                'resp_msg'   => 'ID Proposal Kosong.',
            ];
        } elseif ($point_id == '') {
            $response = [
                'resp_error' => true,
                'resp_msg'   => 'ID Nilai Kosong.',
            ];
        } elseif ($reviewer_id == '') {
            $response = [
                'resp_error' => true,
                'resp_msg'   => 'ID Reviewer Kosong.',
            ];
        } elseif ($score > 5) {
            $response = [
                'resp_error' => true,
                'resp_msg'   => 'Score maksimal 5.',
            ];
        } else {
            $dataBobot = $this->db->get_where('lemlit_point_proposal', array('point_id' => $point_id))->row();
            $total     = ($score * $dataBobot->component_bobot);
            // Update Nilai
            $dataNilai = array(
                'point_score'  => $this->post('score'),
                'point_total'  => $total,
                'point_update' => date('Y-m-d H:i:s'),
            );

            $this->db->where('point_id', $point_id);
            $this->db->update('lemlit_point_proposal', $dataNilai);

            // Update Total Nilai Proposal dari Reviewer
            $QReviewer    = $this->db->query("SELECT * FROM lemlit_reviewer WHERE propose_id='$id'");
            $HReview      = $QReviewer->result();
            $Jml_reviewer = count($HReview);
            $QNilai       = $this->db->query("SELECT SUM(point_total) as total FROM lemlit_point_proposal WHERE propose_id='$id'");
            $HNilai       = $QNilai->row();
            $Point        = ($HNilai->total / $Jml_reviewer);

            $dataTotal = array(
                'propose_point'  => $Point,
                'propose_update' => date('Y-m-d H:i:s'),
            );

            $this->db->where('propose_id', $id);
            $this->db->update('lemlit_propose', $dataTotal);

            $dataPoin = $this->db->get_where('lemlit_point_proposal', array('point_id' => $point_id))->row();
            $response = [
                'resp_error'    => false,
                'resp_msg'      => 'sukses',
                'point_id'      => $dataPoin->point_id,
                'reviewer_id'   => $dataPoin->reviewer_id,
                'nama_komponen' => trim($dataPoin->component_name),
                'indikator'     => trim($dataPoin->component_indicator),
                'bobot'         => $dataPoin->component_bobot,
                'score'         => $dataPoin->point_score,
                'total'         => $dataPoin->point_total,
            ];
        }

        $this->response($response, 200);
    }