Finish Proposal

public function finish_post()
    {
        $username = trim($this->post('username'));
        $id       = $this->post('id');

        if ($username == '') {
            $response = [
                'resp_error' => true,
                'resp_msg'   => 'Username kosong.',
            ];
        } elseif ($id == '') {
            $response = [
                'resp_error' => true,
                'resp_msg'   => 'ID Proposal kosong.',
            ];
        } else {
            $data = array(
                'propose_report_status' => 2,
                'propose_update'        => date('Y-m-d H:i:s'),
            );

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

            // Check Data Dosen dan Anggotanya update tanpa tanggungan
            $query     = $this->db->query("SELECT lecture_id FROM lemlit_team_position WHERE propose_id='" . $id . "'");
            $listDosen = $query->result();
            foreach ($listDosen as $r) {
                $lecture_id = $r->lecture_id;

                $data = array(
                    'lecture_tanggungan' => 'Kosong',
                    'lecture_update'     => date('Y-m-d H:i:s'),
                );

                $this->db->where('lecture_id', $lecture_id);
                $this->db->update('lemlit_lecture', $data);
            }

            $response = [
                'resp_error' => false,
                'resp_msg'   => 'Laporan Penelitian Selesai.',
            ];
        }

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