Edit Data IMB

public function editdata_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 Permohonan Tidak Boleh Kosong.',
            ];
        } else {
            $detail = $this->db->get_where('v_imb_dpm', array('id' => $id))->row();

            if (count($detail) == 0) {
                $response = [
                    'resp_error' => true,
                    'resp_msg'   => 'Data Permohonan Tidak Ditemukan',
                ];
            } else {
                switch ($detail->sts_proses) {
                    case 0:
                        $status = 'Belum Validasi';
                        break;
                    case 1:
                        $status = 'Front Office';
                        break;
                    case 2:
                        $status = 'Tidak Valid';
                        break;
                    case 3:
                        $status = 'Pemroses';
                        break;
                    case 4:
                        $status = 'Ka. Seksi';
                        break;
                    case 5:
                        $status = 'Ka. Bidang';
                        break;
                    case 6:
                        $status = 'ACC Ka. Dinas';
                        break;
                    case 7:
                        $status = 'Tolak Ka. Dinas';
                        break;
                    case 8:
                        $status = 'Cetak Izin';
                        break;
                    case 9:
                        $status = 'Serahkan ke FO';
                        break;
                    case 10:
                        $status = 'Selesai';
                        break;
                    case 11:
                        $status = 'Tolak Ka. Seksi';
                        break;
                    case 12:
                        $status = 'Lunas';
                        break;
                    case 13:
                        $status = 'Tolak Ka. Bidang';
                        break;
                    default:
                        $status = 'Draft';
                        break;
                }

                // List Pendukung
                $daftarPendukung = array();
                $this->db->select('*');
                $this->db->from('c39_imb_berkas');
                $this->db->where('id', $id);
                $listPendukung = $this->db->get()->result();
                foreach ($listPendukung as $x) {
                    if ($x->berkas_file == '') {
                        $berkas = '';
                    } else {
                        $berkas = base_url('upload_file/' . $x->berkas_file);
                    }

                    $daftarPendukung[] = array(
                        'berkas_id'   => $x->berkas_id,
                        'nama_berkas' => strtoupper(trim($x->berkas_name)),
                        'berkas_file' => $berkas,
                    );
                }

                // List Berkas
                $daftarBerkas = array();
                $this->db->select('*');
                $this->db->from('v_syarat');
                $this->db->where('type_id', '31');
                $listBerkas = $this->db->get()->result();
                foreach ($listBerkas as $b) {
                    $file_id = $b->file_id;

                    $check_file = $this->db->get_where('bpmppt_upload', array('file_id' => $file_id, 'user_username' => $username))->row();

                    if (count($check_file) > 0) {
                        $file_berkas = base_url('upload_file/' . $check_file->upload_name);
                        if ($check_file->upload_status != '') {
                            $status_validasi = ($check_file->upload_status == '-' ? 'Belum Validasi' : $check_file->upload_status);
                        } else {
                            $status_validasi = 'Belum Validasi';
                        }
                    } else {
                        $file_berkas     = 'Belum Upload';
                        $status_validasi = 'Belum Upload';
                    }

                    $daftarBerkas[] = array(
                        'file_id'     => $b->file_id,
                        'file_name'   => trim($b->file_name),
                        'file_url'    => $file_berkas,
                        'file_status' => $status_validasi,
                    );
                }

                $response = [
                    'resp_error'         => false,
                    'id'                 => $detail->id,
                    'no_register'        => trim($detail->no_register),
                    'id_imb'             => $detail->id_imb,
                    'user_username'      => $detail->user_username,
                    'tanggal'            => $detail->tanggal,
                    'nama_pemohon'       => trim($detail->nama),
                    'tempat_lahir'       => trim($detail->tempat_lahir),
                    'tanggal_lahir'      => trim($detail->tanggal_lahir),
                    'alamat_pemohon'     => strtoupper(trim($detail->alamat)),
                    'provinsi_id'        => $detail->provinsi_id,
                    'provinsi'           => trim($detail->provinsi_nama),
                    'kabupaten_id'       => $detail->kabupaten_id,
                    'kabupaten'          => trim($detail->kabupaten_nama),
                    'kecamatan_id'       => $detail->kecamatan_id,
                    'kecamatan'          => trim($detail->kecamatan_nama),
                    'desa_id'            => $detail->desa_id,
                    'desa'               => trim($detail->desa_nama),
                    'kode_pos'           => trim($detail->kode_pos),
                    'email'              => trim($detail->email),
                    'no_ktp'             => trim($detail->no_ktp),
                    'pekerjaan'          => trim($detail->pekerjaan),
                    'no_telepon'         => trim($detail->no_telepon),
                    'sts_proses'         => $detail->sts_proses,
                    'tgl_selesai'        => $detail->tgl_selesai,
                    'status'             => trim($status),
                    'imb_untuk'          => trim($detail->nama_imb),
                    'nama_pengambil'     => trim($detail->nama_pengambil),
                    'alamat_pengambil'   => trim($detail->alamat_pengambil),
                    'tgl_validasi'       => $detail->tgl_validasi,
                    'user_validasi'      => $detail->user_validasi,
                    'izin_status'        => $detail->izin_status,
                    'izin_alasan'        => $detail->izin_alasan,
                    'sts_acc'            => $detail->sts_acc,
                    'validasi_kadin'     => $detail->validasi_kadin,
                    'tgl_validasi_kadin' => $detail->tgl_validasi_kadin,
                    'validasi_kasie'     => $detail->validasi_kasie,
                    'tgl_validasi_kasie' => $detail->tgl_validasi_kasie,
                    'alasan_kasie'       => stripHTMLtags($detail->alasan_kasie),
                    'email'              => trim($detail->user_email),
                    'data'               => [
                        'perusahaan'    => [
                            'nama_pemilik' => trim($detail->nama_pemilik),
                            'alamat_prsh'  => strtoupper(trim($detail->alamat_prsh)),
                            'telp_prsh'    => trim($detail->telp_prsh),
                            'fax_prsh'     => trim($detail->fax_prsh),
                            'email_prsh'   => trim($detail->email_prsh),
                            'nama_pjwb'    => trim($detail->nama_pjwb),
                        ],
                        'bangunan'      => [
                            'id_fbangun'     => $detail->id_fbangun,
                            'id_jenisbangun' => $detail->id_jenisbangun,
                            'fungsi_utama'   => strtoupper(trim($detail->fungsi_bangunan)),
                            'jenis_bangunan' => strtoupper(trim($detail->jenisgedung_desc)),
                            'nama_bangunan'  => trim($detail->nm_bangunan_gdg),
                            'peruntukan'     => trim($detail->peruntukan),
                            'rencana_kota'   => trim($detail->rencana_kota),
                            'provinsi_id'    => $detail->propinsi,
                            'provinsi'       => trim($detail->provinsi_lokasi),
                            'kabupaten_id'   => $detail->kabupaten,
                            'kabupaten'      => trim($detail->kabupaten_lokasi),
                            'kecamatan_id'   => $detail->kecamatan,
                            'kecamatan'      => trim($detail->kecamatan_lokasi),
                            'desa_id'        => $detail->kelurahan,
                            'desa_lokasi'    => trim($detail->desa_lokasi),
                            'alamat'         => strtoupper(trim($detail->alamat_bangunan)),
                            'jml_lantai'     => $detail->jum_lantai_fsutama,
                            'keterangan'     => trim($detail->ket_lantai_lain),
                            'luas'           => $detail->luas_tanah,
                            'id_statustanah' => $detail->id_statustanah,
                            'status_tanah'   => strtoupper(trim($detail->nama_statustanah)),
                            'no_sertifikat'  => trim($detail->nomor_statustanah),
                            'pemilik'        => trim($detail->pemilik_tanah),
                            'nop'            => trim($detail->nop),
                        ],
                        'batas_tanah'   => [
                            'utara'   => strtoupper(trim($detail->batas_utara)),
                            'selatan' => strtoupper(trim($detail->batas_selatan)),
                            'timur'   => strtoupper(trim($detail->batas_timur)),
                            'barat'   => strtoupper(trim($detail->batas_barat)),
                        ],
                        "listpendukung" => $daftarPendukung,
                        "listberkas"    => $daftarBerkas,
                    ],
                ];
            }
        }

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