public function index() { $model = $this->load->model('pad_model'); if ($row = $model->get_pemda()) { $ta = date('Y'); $sess_data = array('pad_tahun_anggaran' => $ta, 'pad_pemda_daerah' => $row->daerah, 'pad_pemda_alamat' => $row->alamat, 'pad_pemda_alamat_lengkap' => $row->alamat_lengkap, 'pad_pemda_telp' => $row->telp, 'pad_pemda_fax' => $row->fax, 'pad_pemda_website' => $row->website, 'pad_pemda_email' => $row->email, 'pad_pemda_nama' => $row->pemdanm, 'pad_pemda_singkatan' => $row->pemdanmskt, 'pad_pemda_type' => $row->type, 'pad_pemda_kepala' => $row->kepalanm, 'pad_pemda_jabatan' => $row->jabatan, 'pad_pemda_ibukota' => $row->ibukota, 'pad_pemda_unitid' => $row->ppkd_id, 'pad_reklame_id' => $row->reklame_id, 'pad_air_tanah_id' => $row->airtanah_id, 'pad_dok_self_id' => $row->self_dok_id, 'pad_dok_office_id' => $row->office_dok_id, 'pad_spt_date' => $row->tgl_spt, 'pad_spt_due_date' => $row->tgl_jatuhtempo_self, 'pad_spt_denda' => $row->spt_denda, 'pad_bunga' => $row->pad_bunga); $this->session->set_userdata($sess_data); } $data['current'] = 'beranda'; $data['apps'] = $this->apps_model->get_active_only(); if (!cwp_login()) { $this->load->view('vmain', $data); } else { $this->load->view('cwp/vmain', $data); } }
public function update() { $this->load_auth(); if (!$this->module_auth->update) { $this->session->set_flashdata('msg_warning', $this->module_auth->msg_update); redirect(active_module_url('daftar')); } if (cwp_login()) { if ($this->db_pad->get_where('pad_daftar_hist', array('daftar_id' => cwp_id()))->result()) { $this->session->set_flashdata('msg_warning', 'Data tidak dapat diedit lagi. Status sudah bukan Draft.'); redirect(active_module_url('daftar')); } } $data['current'] = 'pendaftaran'; $data['apps'] = $this->apps_model->get_active_only(); $data['faction'] = active_module_url('daftar/update'); $post_data = $this->fpost(); $data['dt'] = $post_data; $this->fvalidation(); if ($this->form_validation->run() == TRUE) { $input_post = $post_data; $usaha_model = $this->load->model('usaha_model'); $so = $usaha_model->get_so($input_post['op_usaha_id']); $post_data = array('rp' => $input_post['rp'], 'pb' => $input_post['pb'], 'customernm' => $input_post['customernm'], 'alamat' => $input_post['alamat'], 'kecamatan_id' => $input_post['kecamatan_id'], 'kelurahan_id' => $input_post['kelurahan_id'], 'kabupaten' => $input_post['kabupaten'], 'telphone' => $input_post['telphone'], 'kodepos' => $input_post['kodepos'], 'wpnama' => $input_post['wpnama'], 'wpalamat' => $input_post['wpalamat'], 'wpkelurahan' => $input_post['wpkelurahan'], 'wpkecamatan' => $input_post['wpkecamatan'], 'wpkabupaten' => $input_post['wpkabupaten'], 'wptelp' => $input_post['wptelp'], 'wpkodepos' => $input_post['wpkodepos'], 'pnama' => $input_post['wpnama'], 'palamat' => $input_post['wpalamat'], 'pkelurahan' => $input_post['wpkelurahan'], 'pkecamatan' => $input_post['wpkecamatan'], 'pkabupaten' => $input_post['wpkabupaten'], 'ptelp' => $input_post['wptelp'], 'pkodepos' => $input_post['wpkodepos'], 'ijin1' => $input_post['ijin1'], 'ijin1no' => $input_post['ijin1no'], 'ijin1tgl' => $input_post['ijin1tgl'] == '' ? NULL : date('Y-m-d', strtotime($input_post['ijin1tgl'])), 'ijin1tglakhir' => $input_post['ijin1tglakhir'] == '' ? NULL : date('Y-m-d', strtotime($input_post['ijin1tglakhir'])), 'ijin2' => $input_post['ijin2'], 'ijin2no' => $input_post['ijin2no'], 'ijin2tgl' => $input_post['ijin2tgl'] == '' ? NULL : date('Y-m-d', strtotime($input_post['ijin2tgl'])), 'ijin2tglakhir' => $input_post['ijin2tglakhir'] == '' ? NULL : date('Y-m-d', strtotime($input_post['ijin2tglakhir'])), 'ijin3' => $input_post['ijin3'], 'ijin3no' => $input_post['ijin3no'], 'ijin3tgl' => $input_post['ijin3tgl'] == '' ? NULL : date('Y-m-d', strtotime($input_post['ijin3tgl'])), 'ijin3tglakhir' => $input_post['ijin3tglakhir'] == '' ? NULL : date('Y-m-d', strtotime($input_post['ijin3tglakhir'])), 'ijin4' => $input_post['ijin4'], 'ijin4no' => $input_post['ijin4no'], 'ijin4tgl' => $input_post['ijin4tgl'] == '' ? NULL : date('Y-m-d', strtotime($input_post['ijin4tgl'])), 'ijin4tglakhir' => $input_post['ijin4tglakhir'] == '' ? NULL : date('Y-m-d', strtotime($input_post['ijin4tglakhir'])), 'write_date' => date('Y-m-d'), 'write_uid' => 90909090, 'kd_restojmlmeja' => $input_post['kd_restojmlmeja'], 'kd_restojmlkursi' => $input_post['kd_restojmlkursi'], 'kd_restojmltamu' => $input_post['kd_restojmltamu'], 'kd_filmkursi' => $input_post['kd_filmkursi'], 'kd_filmpertunjukan' => $input_post['kd_filmpertunjukan'], 'kd_filmtarif' => $input_post['kd_filmtarif'], 'kd_bilyarmeja' => $input_post['kd_bilyarmeja'], 'kd_bilyartarif' => $input_post['kd_bilyartarif'], 'kd_bilyarkegiatan' => $input_post['kd_bilyarkegiatan'], 'kd_diskopengunjung' => $input_post['kd_diskopengunjung'], 'kd_diskotarif' => $input_post['kd_diskotarif'], 'kd_waletvolume' => $input_post['kd_waletvolume'], 'op_nm' => $this->input->get_post('op_nm'), 'op_alamat' => $this->input->get_post('op_alamat'), 'op_usaha_id' => $this->input->get_post('op_usaha_id'), 'op_pajak_id' => $this->input->get_post('op_pajak_id'), 'op_so' => $so, 'op_kecamatan_id' => $this->input->get_post('op_kecamatan_id'), 'op_kelurahan_id' => $this->input->get_post('op_kelurahan_id'), 'op_latitude' => pad_to_decimal($this->input->get_post('op_latitude')), 'op_longitude' => pad_to_decimal($this->input->get_post('op_longitude'))); $this->daftar_model->update($this->input->post('id'), $post_data); // data tambahan / detail $dtKD = $this->input->post('dtKD'); $tambahan_data2 = array(); if (isset($dtKD)) { $i = 1; $dtKD = json_decode($dtKD, true); if (count($dtKD['dtKD']) > 0) { $cid = $this->input->post('id'); $rd_row = array(); foreach ($dtKD['dtKD'] as $rows) { $rd_row = array('daftar_id' => $cid, 'nourut' => $i, 'notes' => $rows[0], 'tarif' => pad_to_decimal($rows[1]), 'kamar' => pad_to_decimal($rows[2]), 'volume' => pad_to_decimal($rows[3])); $i++; $tambahan_data2 = array_merge($tambahan_data2, array($rd_row)); } //langsung ajah dah - sementara $this->db->delete('pad_daftar_kd_det', array('daftar_id' => $cid)); $this->db->insert_batch('pad_daftar_kd_det', $tambahan_data2); } } // uplod dokeumen // $this->unggah($cid); // -- END data tambahan / detail $this->session->set_flashdata('msg_success', 'Data telah disimpan'); redirect(active_module_url('daftar')); } $get = (object) $post_data; $options = array('1' => 'PRIBADI', '2' => 'BADAN'); $js = 'id="pb" class="input-medium" required '; $data['select_pb'] = form_dropdown('pb', $options, $get->pb, $js); $select_data = $this->load->model('kecamatan_model')->get_select(); $options = array(); if ($select_data) { foreach ($select_data as $row) { $options[$row->id] = $row->kecamatannm; } } $js = 'id="kecamatan_id" class="input-medium" onChange="get_kelurahan(this.value);" required '; $data['select_kecamatan'] = form_dropdown('kecamatan_id', $options, $get->kecamatan_id, $js); $select_data = $this->load->model('kelurahan_model')->get_select($get->kecamatan_id); $options = array(); if ($select_data) { foreach ($select_data as $row) { $options[$row->id] = $row->kelurahannm; } } $js = 'id="kelurahan_id" class="input-large" required '; $data['select_kelurahan'] = form_dropdown('kelurahan_id', $options, $get->kelurahan_id, $js); //op $select_data = $this->load->model('kecamatan_model')->get_select(); $options = array(); $kec_id = $get->op_kecamatan_id; if ($select_data) { foreach ($select_data as $row) { if ($kec_id == '') { $kec_id = $row->id; } $options[$row->id] = $row->kecamatannm; } } $js = 'id="op_kecamatan_id" class="input-medium" onChange="get_op_kelurahan(this.value);" required '; $data['select_op_kecamatan'] = form_dropdown('op_kecamatan_id', $options, $get->op_kecamatan_id, $js); $select_data = $this->load->model('kelurahan_model')->get_select($kec_id); $options = array(); if ($select_data) { foreach ($select_data as $row) { $options[$row->id] = $row->kelurahannm; } } $js = 'id="op_kelurahan_id" class="input-large" required '; $data['select_op_kelurahan'] = form_dropdown('op_kelurahan_id', $options, $get->op_kelurahan_id, $js); $select_data = $this->load->model('usaha_model')->get_select(); $options = array(); $usaha_id = $get->op_usaha_id; if ($select_data) { foreach ($select_data as $row) { if ($usaha_id == '') { $usaha_id = $row->id; } $options[$row->id] = $row->usahanm; } } $js = 'id="op_usaha_id" class="input-medium" onChange="get_op_pajak(this.value);" required '; $data['select_op_usaha'] = form_dropdown('op_usaha_id', $options, $get->op_usaha_id, $js); $select_data = $this->load->model('pajak_model')->get_select2($usaha_id); $options = array(); if ($select_data) { foreach ($select_data as $row) { $options[$row->id] = $row->pajaknm; } } $js = 'id="op_pajak_id" class="input-large" required '; $data['select_op_pajak'] = form_dropdown('op_pajak_id', $options, $get->op_pajak_id, $js); $this->load->view('vdaftar_form2', $data); }