List Proposal

public function listproposal_post()
    {
        $username = trim($this->post('username'));
        $level    = trim($this->post('level'));
        $type     = $this->post('type');

        if ($username == '') {
            $response = [
                'resp_error' => true,
                'resp_msg'   => 'Username tidak ditemukan.',
            ];
        } elseif ($level == '') {
            $response = [
                'resp_error' => true,
                'resp_msg'   => 'Level tidak diketahui.',
            ];
        } else {
            if ($level == 'Member') {
                if ($type == 'all') {
                    $listProposal = $this->db->order_by('propose_title', 'asc')->get_where('v_proposal', array('user_username' => $username, 'propose_status <=' => 2))->result();
                } else {
                    $listProposal = $this->db->order_by('propose_title', 'asc')->get_where('v_proposal', array('user_username' => $username, 'propose_status' => (int) $type))->result();
                }
            } elseif ($level == 'Admin') {
                if ($type == 'all') {
                    $listProposal = $this->db->order_by('propose_title', 'asc')->get_where('v_proposal', array('propose_status <=' => 2))->result();
                } else {
                    $listProposal = $this->db->order_by('propose_title', 'asc')->get_where('v_proposal', array('propose_status' => (int) $type))->result();
                }
            } elseif ($level = 'Reviewer') {
                if ($type == 'all') {
                    $this->db->select('p.*, s.skim_name, u.user_name');
                    $this->db->from('lemlit_propose p');
                    $this->db->join('lemlit_users u', 'p.user_username = u.user_username');
                    $this->db->join('lemlit_skim s', 'p.skim_id = s.skim_id');
                    $this->db->join('lemlit_reviewer t', 't.propose_id = p.propose_id');
                    $this->db->where('t.user_username', $username);
                    $this->db->where('p.propose_status <=', 2);
                    $this->db->order_by('p.propose_title', 'asc');
                } else {
                    $this->db->select('p.*, s.skim_name, u.user_name');
                    $this->db->from('lemlit_propose p');
                    $this->db->join('lemlit_users u', 'p.user_username = u.user_username');
                    $this->db->join('lemlit_skim s', 'p.skim_id = s.skim_id');
                    $this->db->join('lemlit_reviewer t', 't.propose_id = p.propose_id');
                    $this->db->where('t.user_username', $username);
                    $this->db->where('p.propose_status', $type);
                    $this->db->order_by('p.propose_title', 'asc');
                }
                $listProposal = $this->db->get()->result();
            }

            if (count($listProposal) == 0) {
                $response = [
                    'resp_error' => false,
                    'resp_msg'   => 'Belum Ada Proposal',
                ];
            } else {
                foreach ($listProposal as $r) {
                    if ($r->propose_status == 1) {
                        $status = 'Baru';
                    } else {
                        $status = 'Proses';
                    }

                    $response['items'][] = [
                        'resp_error'    => false,
                        'id'            => $r->propose_id,
                        'tanggal'       => date("d-m-Y", strtotime($r->propose_date)),
                        'user_username' => $r->user_username,
                        'nama'          => trim($r->user_name),
                        'judul'         => trim($r->propose_title),
                        'kategori'      => trim($r->skim_name),
                        'status'        => $status,
                    ];
                }
            }
        }

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