List Biodata siOlga

public function listbiodata_post()
    {
        $username = $this->post('username');
        $cari     = trim($this->post('cari'));
        $no_kab   = $this->post('no_kab');
        $cabor_id = $this->post('cabor_id');
        if ($username == '') {
            $response = [
                'resp_error' => true,
                'resp_msg'   => 'Username Kosong',
            ];
        } else {
            if ($cari != '' && $no_kab == '' && $cabor_id == '') {
                $sql = "SELECT * FROM v_biodata_detail WHERE biodata_step=5 AND biodata_nama LIKE '%$cari%'
                OR biodata_nik LIKE '%$cari%' ORDER BY biodata_nama ASC";
            } elseif ($cari != '' && $no_kab != '' && $cabor_id == '') {
                $sql = "SELECT * FROM v_biodata_detail WHERE biodata_step=5 AND no_kab_kontingen='$no_kab' AND biodata_nama LIKE '%$cari%' OR biodata_nik LIKE '%$cari%' ORDER BY biodata_nama ASC";
            } elseif ($cari != '' && $no_kab != '' && $cabor_id != '') {
                $sql = "SELECT * FROM v_biodata_detail WHERE biodata_step=5 AND no_kab_kontingen='$no_kab'
                AND cabor_id='$cabor_id' AND biodata_nama LIKE '%$cari%'
                OR biodata_nik LIKE '%$cari%' ORDER BY biodata_nama ASC";
            } elseif ($cari != '' && $no_kab == '' && $cabor_id != '') {
                $sql = "SELECT * FROM v_biodata_detail WHERE biodata_step=5 AND cabor_id='$cabor_id'
                AND biodata_nama LIKE '%$cari%' OR biodata_nik LIKE '%$cari%' ORDER BY biodata_nama ASC";
            } elseif ($cari == '' && $no_kab != '' && $cabor_id == '') {
                $sql = "SELECT * FROM v_biodata_detail WHERE biodata_step=5 AND no_kab_kontingen='$no_kab'
                ORDER BY biodata_nama ASC";
            } elseif ($cari == '' && $no_kab == '' && $cabor_id != '') {
                $sql = "SELECT * FROM v_biodata_detail WHERE biodata_step=5 AND cabor_id='$cabor_id'
                ORDER BY biodata_nama ASC";
            } elseif ($cari == '' && $no_kab == '' && $cabor_id == '') {
                $sql = "SELECT * FROM v_biodata_detail WHERE biodata_step=5 ORDER BY biodata_nama ASC";
            } elseif ($cari == '' && $no_kab != '' && $cabor_id != '') {
                $sql = "SELECT * FROM v_biodata_detail WHERE biodata_step=5 AND no_kab_kontingen='$no_kab'
                AND cabor_id='$cabor_id' ORDER BY biodata_nama ASC";
            }

            $listData = $this->db->query($sql)->result();
            if (count($listData) == 0) {
                $response = [
                    'resp_error' => false,
                    'resp_msg'   => 'Belum Ada Data',
                ];
            } else {
                foreach ($listData as $r) {
                    if ($r->biodata_foto == '') {
                        $foto = base_url('img/no-image.jpg');
                    } else {
                        $foto = base_url('img/biodata_folder/' . $r->biodata_foto);
                    }

                    $response['items'][] = [
                        'resp_error'         => false,
                        'biodata_id'         => $r->biodata_id,
                        'biodata_no_kta'     => trim($r->biodata_nik),
                        'biodata_nama'       => trim($r->biodata_nama),
                        'biodata_alias'      => trim($r->biodata_alias),
                        'biodata_ktp'        => trim($r->biodata_ktp),
                        'biodata_tempat_lhr' => trim($r->biodata_tempat_lahir),
                        'biodata_tgl_lhr'    => date('d-m-Y', strtotime($r->biodata_tgl_lahir)),
                        'biodata_alamat'     => trim($r->biodata_alamat),
                        'desa'               => trim($r->nama_kel),
                        'kecamatan'          => trim($r->nama_kec),
                        'kabupaten'          => trim($r->nama_kab),
                        'biodata_agama'      => trim($r->agama_nama),
                        'biodata_telp'       => trim($r->biodata_telp),
                        'biodata_ponsel'     => trim($r->biodata_ponsel),
                        'biodata_email'      => trim($r->biodata_email),
                        'biodata_jk'         => ($r->biodata_jk == 'L' ? 'LAKI-LAKI' : 'PEREMPUAN'),
                        'biodata_suku'       => trim($r->biodata_suku),
                        'biodata_tb'         => trim($r->biodata_tb),
                        'biodata_bb'         => trim($r->biodata_bb),
                        'biodata_hobi'       => trim($r->biodata_hobi),
                        'gol_darah'          => trim($r->gol_darah_nama),
                        'biodata_merokok'    => ($r->biodata_merokok == 1 ? 'YA' : 'TIDAK'),
                        'biodata_miras'      => ($r->biodata_miras == 1 ? 'YA' : 'TIDAK'),
                        'status_kawin'       => trim($r->status_kawin_nama),
                        'cabor_kode'         => trim($r->cabor_kode),
                        'cabor'              => trim($r->cabor_nama_singkat),
                        'wadah'              => trim($r->cabor_singkatan),
                        'kontingen'          => trim($r->kontingen_nama),
                        'biodata_nokartu'    => trim($r->biodata_nokartu),
                        'klub'               => trim($r->klub_nama),
                        'alamat_klub'        => trim($r->klub_alamat),
                        'status'             => trim($r->status_nama),
                        'biodata_foto'       => $foto,
                        'biodata_url'        => base_url('info/biodata/' . $r->biodata_id),
                    ];
                }
            }
        }

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