private function fpost() { $data['id'] = $this->input->post('id'); $data['nama'] = $this->input->post('nama'); $data['nilai'] = pad_to_decimal($this->input->post('nilai')); return $data; }
private function fpost() { $data['id'] = $this->input->post('id'); $data['nama'] = $this->input->post('nama'); $data['singkatan'] = $this->input->post('singkatan'); $data['kriteria'] = $this->input->post('kriteria'); $data['nilai'] = pad_to_decimal($this->input->post('nilai')); $data['enabled'] = $this->input->post('enabled'); return $data; }
private function fpost() { $data['id'] = $this->input->post('id'); $data['kode'] = $this->input->post('kode'); $data['kecamatan_id'] = $this->input->post('kecamatan_id'); $data['kelurahan_id'] = $this->input->post('kelurahan_id'); $data['latitude'] = pad_to_decimal($this->input->post('latitude')); $data['longitude'] = pad_to_decimal($this->input->post('longitude')); $data['pemilik_nama'] = $this->input->post('pemilik_nama'); $data['pemilik_alamat'] = $this->input->post('pemilik_alamat'); $data['pemilik_kecamatan'] = $this->input->post('pemilik_kecamatan'); $data['pemilik_kelurahan'] = $this->input->post('pemilik_kelurahan'); $data['pemilik_kota'] = $this->input->post('pemilik_kota'); return $data; }
private function fpost() { $data['id'] = $this->input->post('id'); $data['type'] = $this->input->post('type'); $data['pemda_nama'] = $this->input->post('pemda_nama'); $data['pemda_nama_singkat'] = $this->input->post('pemda_nama_singkat'); $data['kepala_nama'] = $this->input->post('kepala_nama'); $data['jabatan'] = $this->input->post('jabatan'); $data['alamat'] = $this->input->post('alamat'); $data['ibukota'] = $this->input->post('ibukota'); $data['telp'] = $this->input->post('telp'); $data['ppkd_id'] = $this->input->post('ppkd_id'); $data['tmt'] = $this->input->post('tmt'); $data['alamat_lengkap'] = $this->input->post('alamat_lengkap'); $data['daerah'] = $this->input->post('daerah'); $data['fax'] = $this->input->post('fax'); $data['website'] = $this->input->post('website'); $data['email'] = $this->input->post('email'); $data['reklame_id'] = pad_to_decimal($this->input->post('reklame_id')); $data['airtanah_id'] = pad_to_decimal($this->input->post('airtanah_id')); $data['parkir_id'] = pad_to_decimal($this->input->post('parkir_id')); $data['hiburan_id'] = pad_to_decimal($this->input->post('hiburan_id')); $data['ppj_id'] = pad_to_decimal($this->input->post('ppj_id')); $data['restauran_id'] = pad_to_decimal($this->input->post('restauran_id')); $data['hotel_id'] = pad_to_decimal($this->input->post('hotel_id')); $data['walet_id'] = pad_to_decimal($this->input->post('walet_id')); $data['surat_no'] = $this->input->post('surat_no'); $data['ijin_kd'] = $this->input->post('ijin_kd'); $data['reklame_kd'] = $this->input->post('reklame_kd'); $data['airtanah_kd'] = $this->input->post('airtanah_kd'); $data['parkir_kd'] = $this->input->post('parkir_kd'); $data['hiburan_kd'] = $this->input->post('hiburan_kd'); $data['ppj_kd'] = $this->input->post('ppj_kd'); $data['restauran_kd'] = $this->input->post('restauran_kd'); $data['hotel_kd'] = $this->input->post('hotel_kd'); $data['self_dok_id'] = pad_to_decimal($this->input->post('self_dok_id')); $data['office_dok_id'] = pad_to_decimal($this->input->post('office_dok_id')); $data['tgl_jatuhtempo_self'] = pad_to_decimal($this->input->post('tgl_jatuhtempo_self')); $data['spt_denda'] = pad_to_decimal($this->input->post('spt_denda')); $data['tgl_spt'] = pad_to_decimal($this->input->post('tgl_spt')); $data['pad_bunga'] = pad_to_decimal($this->input->post('pad_bunga')); $data['thn_ang'] = pad_to_decimal($this->input->post('thn_ang')); return $data; }
private function fpost() { $data['id'] = $this->input->post('id'); $data['rekening_id'] = $this->input->post('rekening_id'); $data['tahun'] = $this->input->post('tahun'); $data['status_anggaran'] = $this->input->post('status_anggaran'); $data['target'] = pad_to_decimal($this->input->post('target')); $data['bulan1'] = pad_to_decimal($this->input->post('bulan1')); $data['bulan2'] = pad_to_decimal($this->input->post('bulan2')); $data['bulan3'] = pad_to_decimal($this->input->post('bulan3')); $data['bulan4'] = pad_to_decimal($this->input->post('bulan4')); $data['bulan5'] = pad_to_decimal($this->input->post('bulan5')); $data['bulan6'] = pad_to_decimal($this->input->post('bulan6')); $data['bulan7'] = pad_to_decimal($this->input->post('bulan7')); $data['bulan8'] = pad_to_decimal($this->input->post('bulan8')); $data['bulan9'] = pad_to_decimal($this->input->post('bulan9')); $data['bulan10'] = pad_to_decimal($this->input->post('bulan10')); $data['bulan11'] = pad_to_decimal($this->input->post('bulan11')); $data['bulan12'] = pad_to_decimal($this->input->post('bulan12')); $data['jumlah'] = pad_to_decimal($this->input->post('jumlah')); return $data; }
function cetak() { $type = $this->uri->segment(4); $rpt = $this->input->get('rpt'); $kondisi = ""; if ($rpt == 'sptpd_tr') { $wp_id = $this->input->get('w'); if (!empty($wp_id)) { $kondisi .= " AND c.id={$wp_id} "; } $type_id = $this->input->get('t'); if ($type_id != 999) { $kondisi .= " AND st.id={$type_id} "; } $usaha_id = $this->input->get('u'); if ($usaha_id != 999) { $kondisi .= " AND u.id={$usaha_id} "; } $kondisi .= " AND s.tahun=" . pad_tahun_anggaran(); $params = array("daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), 'kondisi' => (string) $kondisi); } elseif ($rpt == 'sptpd_omset') { $rpt = 'sptpd_rincian_omset'; $sptpd_id = $this->input->get('no'); $terbilang = terbilang(pad_to_decimal($this->input->get('val')), 3) . " Rupiah"; $params = array('sptpd_id' => (int) $sptpd_id, "terbilang" => $terbilang, "alamat" => pad_pemda_alamat(), "telp" => pad_pemda_telp(), "fax" => pad_pemda_fax(), "website" => pad_pemda_website(), "email" => pad_pemda_email(), "alamat_lengkap" => pad_pemda_alamat_lengkap(), "daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), "logo" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/logorpt__.jpg", "logobjb" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/bank-bjb.jpg"); } else { $rpt = 'sptpd_slip'; $sptpd_id = $this->input->get('no'); $terbilang = terbilang(pad_to_decimal($this->input->get('val')), 3) . " Rupiah"; $params = array('sptpd_id' => (int) $sptpd_id, "terbilang" => $terbilang, "alamat" => pad_pemda_alamat(), "telp" => pad_pemda_telp(), "fax" => pad_pemda_fax(), "website" => pad_pemda_website(), "email" => pad_pemda_email(), "alamat_lengkap" => pad_pemda_alamat_lengkap(), "daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), "logo" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/logorpt__.jpg", "logobjb" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/bank-bjb.jpg"); } $ignore_html_pg = TRUE; $rpt = 'wp/' . $rpt; $db_pad = $this->load->database('pad', TRUE); $jasper = $this->load->library('Jasper'); $jasper->db = $db_pad->database; $jasper->usr = $db_pad->username; $jasper->pwd = $db_pad->password; $jasper->port = $db_pad->port; echo $jasper->cetak($rpt, $params, $type, $ignore_html_pg); }
public function update() { if (!$this->module_auth->update) { $this->session->set_flashdata('msg_warning', $this->module_auth->msg_update); redirect(active_module_url('air_hda')); } $p_id = $this->uri->segment(4); $post_data = $this->fpost(); $data['current'] = 'referensi'; $data['apps'] = $this->apps_model->get_active_only(); $data['faction'] = active_module_url("air_hda/update/{$p_id}"); $this->fvalidation(); if ($this->form_validation->run() == TRUE) { $input_post = $post_data; $hda = pad_to_decimal($input_post['hda']); $volume = pad_to_decimal($input_post['volume']); $update_data = array('id' => empty($input_post['id']) ? NULL : $input_post['id'], 'golongan' => empty($input_post['golongan']) ? NULL : $input_post['golongan'], 'manfaat_id' => empty($input_post['manfaat_id']) ? NULL : $input_post['manfaat_id'], 'zona_id' => empty($input_post['zona_id']) ? NULL : $input_post['zona_id'], 'kelompok_usaha_id' => empty($input_post['kelompok_usaha_id']) ? NULL : $input_post['kelompok_usaha_id'], 'volume' => empty($volume) ? NULL : $volume, 'hda' => empty($hda) ? NULL : $hda, 'updated' => date('Y-m-d h:i:s'), 'update_uid' => sipkd_user_id()); $this->air_hda_model->update($p_id, $update_data); $this->session->set_flashdata('msg_success', 'Data telah disimpan'); redirect(active_module_url('air_hda')); } $get = $post_data; $select_data = $this->load->model('air_zona_model')->get_select2(); $options = array(); foreach ($select_data as $row) { $options[$row->id] = $row->nama; } $js = 'id="id" class="input-xlarge" required '; $data['select_air_zona'] = form_dropdown('id', $options, $get->id, $js); $data['dt'] = $post_data; $this->load->view('vair_hda_form', $data); }
private function fpost($jenis_usaha = NULL) { //spt global $data['id'] = $this->input->post('id'); $data['sptno'] = $this->input->post('sptno'); $data['tahun'] = $this->input->post('tahun'); $data['terimatgl'] = $this->input->post('terimatgl'); $data['customer_id'] = $this->input->post('customer_id'); $data['customer_usaha_id'] = $this->input->post('customer_usaha_id'); $data['pajak_id'] = $this->input->post('pajak_id'); $data['rekening_id'] = $this->input->post('rekening_id'); $data['so'] = $this->input->post('so'); $data['type_id'] = $this->input->post('type_id'); $data['masadari'] = $this->input->post('masadari'); $data['masasd'] = $this->input->post('masasd'); $data['jatuhtempotgl'] = $this->input->post('jatuhtempotgl'); $data['minimal_omset'] = $this->input->post('minimal_omset'); $data['dasar'] = pad_to_decimal($this->input->post('dasar')); $data['tarif'] = pad_to_decimal($this->input->post('tarif')); $data['denda'] = pad_to_decimal($this->input->post('denda')); $data['bunga'] = pad_to_decimal($this->input->post('bunga')); $data['setoran'] = pad_to_decimal($this->input->post('setoran')); $data['kenaikan'] = pad_to_decimal($this->input->post('kenaikan')); $data['kompensasi'] = pad_to_decimal($this->input->post('kompensasi')); $data['lain2'] = pad_to_decimal($this->input->post('lain2')); $data['r_nsr'] = pad_to_decimal($this->input->post('r_nsr')); $data['r_bayarid'] = $this->input->post('r_bayarid'); $data['kirimtgl'] = $this->input->post('kirimtgl'); $data['notes'] = $this->input->post('notes'); $data['no_skpd_lama'] = $this->input->post('no_skpd_lama'); $data['unit_id'] = $this->input->post('unit_id'); $data['enabled'] = $this->input->post('enabled'); $data['terimanip'] = $this->input->post('terimanip'); $data['isprint_dc'] = $this->input->post('isprint_dc'); $data['created'] = $this->input->post('created'); $data['create_uid'] = $this->input->post('create_uid'); $data['updated'] = $this->input->post('updated'); $data['update_uid'] = $this->input->post('update_uid'); //air if ($jenis_usaha == pad_air_tanah_id()) { $data['air_manfaat_id'] = $this->input->post('air_manfaat_id'); $data['air_zona_id'] = $this->input->post('air_zona_id'); $data['meteran_awal'] = pad_to_decimal($this->input->post('meteran_awal')); $data['meteran_akhir'] = pad_to_decimal($this->input->post('meteran_akhir')); $data['volume'] = pad_to_decimal($this->input->post('volume')); $data['satuan'] = $this->input->post('satuan'); } //reklame if ($jenis_usaha == pad_reklame_id()) { $data['r_nsrno'] = $this->input->post('r_nsrno'); $data['r_nsrtgl'] = $this->input->post('r_nsrtgl'); $data['r_jalanklas_id'] = $this->input->post('r_jalanklas_id'); $data['r_jalan_id'] = $this->input->post('r_jalan_id'); $data['r_lokasi'] = $this->input->post('r_lokasi'); $data['r_judul'] = $this->input->post('r_judul'); $data['r_panjang'] = pad_to_decimal($this->input->post('r_panjang'), 1); $data['r_lebar'] = pad_to_decimal($this->input->post('r_lebar'), 1); $data['r_muka'] = pad_to_decimal($this->input->post('r_muka'), 1); $data['r_banyak'] = pad_to_decimal($this->input->post('r_banyak'), 1); $data['r_luas'] = pad_to_decimal($this->input->post('r_luas'), 1); $data['r_tarifid'] = $this->input->post('r_tarifid'); $data['r_nsl_nilai'] = pad_to_decimal($this->input->post('r_nsl_nilai')); $data['r_lama'] = pad_to_decimal($this->input->post('r_lama')); $data['r_kontrak'] = pad_to_decimal($this->input->post('r_kontrak')); $data['r_calculated'] = pad_to_decimal($this->input->post('r_calculated')); $data['r_nsl_kecamatan_id'] = $this->input->post('r_nsl_kecamatan_id'); $data['r_nsl_type_id'] = $this->input->post('r_nsl_type_id'); $data['r_lokasi_id'] = $this->input->post('r_lokasi_id'); $data['r_kelurahan_id'] = $this->input->post('r_kelurahan_id'); } return $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); }
public function update() { if (!$this->module_auth->update) { $this->session->set_flashdata('msg_warning', $this->module_auth->msg_update); redirect(active_module_url('objek_pajak')); } $data['current'] = 'pendaftaran'; $data['apps'] = $this->apps_model->get_active_only(); $data['faction'] = active_module_url('objek_pajak/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($this->input->get_post('op_usaha_id')); $post_data = array('customer_id' => empty($input_post['customer_id']) ? NULL : $input_post['customer_id'], 'usaha_id' => empty($input_post['usaha_id']) ? NULL : $input_post['usaha_id'], 'so' => $so, 'kecamatan_id' => empty($input_post['kecamatan_id']) ? NULL : $input_post['kecamatan_id'], 'kelurahan_id' => empty($input_post['kelurahan_id']) ? NULL : $input_post['kelurahan_id'], 'notes' => empty($input_post['notes']) ? NULL : $input_post['notes'], 'aktifnotes' => empty($input_post['aktifnotes']) ? NULL : $input_post['aktifnotes'], 'tmt' => empty($input_post['tmt']) ? NULL : date('Y-m-d', strtotime($input_post['tmt'])), 'customer_status_id' => empty($input_post['customer_status_id']) ? NULL : $input_post['customer_status_id'], 'latitude' => $input_post['latitude'], 'longitude' => $input_post['longitude'], 'opnm' => $input_post['opnm'], 'opalamat' => $input_post['opalamat'], 'def_pajak_id' => $input_post['def_pajak_id'], 'kd_restojmlmeja' => pad_to_decimal($input_post['kd_restojmlmeja']), 'kd_restojmlkursi' => pad_to_decimal($input_post['kd_restojmlkursi']), 'kd_restojmltamu' => pad_to_decimal($input_post['kd_restojmltamu']), 'kd_filmkursi' => pad_to_decimal($input_post['kd_filmkursi']), 'kd_filmpertunjukan' => pad_to_decimal($input_post['kd_filmpertunjukan']), 'kd_filmtarif' => pad_to_decimal($input_post['kd_filmtarif']), 'kd_bilyarmeja' => pad_to_decimal($input_post['kd_bilyarmeja']), 'kd_bilyartarif' => pad_to_decimal($input_post['kd_bilyartarif']), 'kd_bilyarkegiatan' => pad_to_decimal($input_post['kd_bilyarkegiatan']), 'kd_diskopengunjung' => pad_to_decimal($input_post['kd_diskopengunjung']), 'kd_diskotarif' => pad_to_decimal($input_post['kd_diskotarif']), 'mall_id' => pad_to_decimal($input_post['op_mall_id']), 'updated' => date('Y-m-d'), 'update_uid' => sipkd_user_id()); $this->objek_pajak_model->update($this->input->post('id'), $post_data); if (isset($dtKD)) { $i = 1; $dtKD = json_decode($dtKD, true); if (count($dtKD['dtKD']) > 0) { $cid = $input_post['customer_id']; $op_u_id = $input_post['usaha_id']; $rd_row = array(); foreach ($dtKD['dtKD'] as $rows) { $rd_row = array('customer_id' => $cid, 'konterid' => $konter, 'usaha_id' => $op_u_id, '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 $query = "delete from pad_customer_detail where (customer_id={$cid} and konterid={$konter})"; $this->db->query($query); $this->db->insert_batch('pad_customer_detail', $tambahan_data2); } } $this->session->set_flashdata('msg_success', 'Data telah disimpan'); redirect(active_module_url('objek_pajak')); } $get = (object) $post_data; $data['dt']['nopd'] = $this->objek_pajak_model->get_nopd($get->id); $select_data = $this->load->model('usaha_model')->get_select(); $options = array(); $usaha_id = ''; foreach ($select_data as $row) { $options[$row->id] = $row->nama; } $js = 'id="usaha_id" class="input-medium" onChange="get_pajak(this.value);" required '; $data['select_usaha'] = form_dropdown('usaha_id', $options, $get->usaha_id, $js); $select_data = $this->load->model('pajak_model')->get_select2($get->usaha_id); $options = array(); foreach ($select_data as $row) { $options[$row->id] = $row->nama; } $js = 'id="def_pajak_id" class="input-medium" required '; $data['select_pajak'] = form_dropdown('def_pajak_id', $options, '', $js); $select_data = $this->load->model('kecamatan_model')->get_select(); $options = array(); foreach ($select_data as $row) { $options[$row->id] = $row->nama; } $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(); foreach ($select_data as $row) { $options[$row->id] = $row->nama; } $js = 'id="kelurahan_id" class="input-large" required '; $data['select_kelurahan'] = form_dropdown('kelurahan_id', $options, $get->kelurahan_id, $js); //read again ? tujuan nanti sih kayanya masuk ke op_status_usaha $options = array('1' => 'AKTIF', '2' => 'TUTUP', '3' => 'TUTUP SEMENTARA', '4' => 'NORMAL', '5' => 'LIBUR'); $js = 'id="customer_status_id" class="input-medium" required '; $data['select_status'] = form_dropdown('customer_status_id', $options, $get->customer_status_id, $js); $this->load->view('vobjek_pajak_form', $data); }
function proces_op() { $mode = $this->uri->segment(4); $op_id = $this->input->get_post('op_id'); $usaha_model = $this->load->model('usaha_model'); $so = $usaha_model->get_so($this->input->get_post('op_usaha_id')); $update_data = array('customer_id' => $this->input->get_post('customer_id'), 'usaha_id' => $this->input->get_post('op_usaha_id'), 'so' => $so, 'kecamatan_id' => $this->input->get_post('op_kecamatan_id'), 'kelurahan_id' => $this->input->get_post('op_kelurahan_id'), 'notes' => $this->input->get_post('op_keterangan'), 'aktifnotes' => $this->input->get_post('aktifnotes'), 'customer_status_id' => $this->input->get_post('op_status'), 'enabled' => 1, 'tmt' => $this->input->get_post('op_tmt') == '' ? NULL : date('Y-m-d', strtotime($this->input->get_post('op_tmt'))), 'opnm' => $this->input->get_post('op_nama'), 'opalamat' => $this->input->get_post('op_alamat'), 'latitude' => pad_to_decimal($this->input->get_post('op_latitude')), 'longitude' => pad_to_decimal($this->input->get_post('op_longitude')), 'def_pajak_id' => $this->input->get_post('op_pajak_id'), 'kd_restojmlmeja' => pad_to_decimal($this->input->get_post('kd_restojmlmeja')), 'kd_restojmlkursi' => pad_to_decimal($this->input->get_post('kd_restojmlkursi')), 'kd_restojmltamu' => pad_to_decimal($this->input->get_post('kd_restojmltamu')), 'kd_filmkursi' => pad_to_decimal($this->input->get_post('kd_filmkursi')), 'kd_filmpertunjukan' => pad_to_decimal($this->input->get_post('kd_filmpertunjukan')), 'kd_filmtarif' => pad_to_decimal($this->input->get_post('kd_filmtarif')), 'kd_bilyarmeja' => pad_to_decimal($this->input->get_post('kd_bilyarmeja')), 'kd_bilyartarif' => pad_to_decimal($this->input->get_post('kd_bilyartarif')), 'kd_bilyarkegiatan' => pad_to_decimal($this->input->get_post('kd_bilyarkegiatan')), 'kd_diskopengunjung' => pad_to_decimal($this->input->get_post('kd_diskopengunjung')), 'kd_diskotarif' => pad_to_decimal($this->input->get_post('kd_diskotarif')), 'mall_id' => pad_to_decimal($this->input->get_post('op_mall_id')), 'cash_register' => pad_to_decimal($this->input->get_post('op_cash_register')), 'pelaporan' => pad_to_decimal($this->input->get_post('op_pelaporan')), 'pembukuan' => pad_to_decimal($this->input->get_post('op_pembukuan')), 'bandara' => pad_to_decimal($this->input->get_post('op_bandara')), 'wajib_pajak' => pad_to_decimal($this->input->get_post('op_wajib_pajak')), 'jumlah_karyawan' => pad_to_decimal($this->input->get_post('jumlah_karyawan')), 'tanggal_tutup' => $this->input->get_post('tanggal_tutup') == '' ? NULL : date('Y-m-d', strtotime($this->input->get_post('tanggal_tutup'))), 'parkir_luas' => pad_to_decimal($this->input->get_post('parkir_luas')), 'parkir_masuk' => pad_to_decimal($this->input->get_post('parkir_masuk')), 'parkir_keluar' => pad_to_decimal($this->input->get_post('parkir_keluar')), 'parkir_tarif_mobil' => pad_to_decimal($this->input->get_post('parkir_tarif_mobil')), 'parkir_tambahan' => pad_to_decimal($this->input->get_post('parkir_tambahan')), 'parkir_kapasitas_mobil' => pad_to_decimal($this->input->get_post('parkir_kapasitas_mobil')), 'parkir_mobil_hari' => pad_to_decimal($this->input->get_post('parkir_mobil_hari')), 'parkir_motor_luas' => pad_to_decimal($this->input->get_post('parkir_motor_luas')), 'parkir_motor_masuk' => pad_to_decimal($this->input->get_post('parkir_motor_masuk')), 'parkir_motor_keluar' => pad_to_decimal($this->input->get_post('parkir_motor_keluar')), 'parkir_tarif_motor' => pad_to_decimal($this->input->get_post('parkir_tarif_motor')), 'parkir_motor_tambahan' => pad_to_decimal($this->input->get_post('parkir_motor_tambahan')), 'parkir_kapasitas_motor' => pad_to_decimal($this->input->get_post('parkir_kapasitas_motor')), 'parkir_motor_hari' => pad_to_decimal($this->input->get_post('parkir_motor_hari')), 'kelompok_usaha_id' => pad_to_decimal($this->input->get_post('op_kelompok_usaha_id')), 'zona_id' => pad_to_decimal($this->input->get_post('op_zona')), 'manfaat_id' => pad_to_decimal($this->input->get_post('op_golongan')), 'golongan_id' => pad_to_decimal($this->input->get_post('op_manfaat'))); $op_model = $this->load->model('objek_pajak_model'); if ($mode == 'add') { $konter = $op_model->max_konter($this->input->get_post('customer_id')); $this->session->set_userdata('konter', $konter); $new_data = array('konterid' => $konter, 'reg_date' => date('Y-m-d'), 'created' => date('Y-m-d h:i:s'), 'create_uid' => sipkd_user_id()); $update_data = array_merge($update_data, $new_data); $op_model->save($update_data); } if ($mode == 'edit') { $new_data = array('updated' => date('Y-m-d h:i:s'), 'update_uid' => sipkd_user_id()); $update_data = array_merge($update_data, $new_data); $op_model->update($op_id, $update_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) { if ($mode == 'add') { $konter = $this->session->userdata('konter'); $this->session->unset_userdata('konter'); $query = $this->db->query("SELECT id FROM pad_customer_usaha ORDER BY id DESC LIMIT 1"); foreach ($query->result() as $row) { $cu_id = $row->id; } } if ($mode == 'edit') { $konter = $this->input->get_post('op_konterid'); $cu_id = $this->input->get_post('op_id'); } $cid = $this->input->get_post('customer_id'); $op_u_id = $this->input->get_post('op_usaha_id'); $rd_row = array(); foreach ($dtKD['dtKD'] as $rows) { $rd_row = array('customer_id' => $cid, 'customer_usaha_id' => $cu_id, 'konterid' => $konter, 'usaha_id' => $op_u_id, '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 $query = "delete from pad_customer_detail where (customer_id={$cid} and konterid={$konter})"; $this->db->query($query); $this->db->insert_batch('pad_customer_detail', $tambahan_data2); } } $dtAT = $this->input->post('dtAT'); $tambahan_data2 = array(); if (isset($dtAT)) { $i = 1; $dtAT = json_decode($dtAT, true); if (count($dtAT['dtAT']) > 0) { if ($mode == 'add') { $konter = $this->session->userdata('konter'); $this->session->unset_userdata('konter'); $query = $this->db->query("SELECT id FROM pad_customer_usaha ORDER BY id DESC LIMIT 1"); foreach ($query->result() as $row) { $cu_id = $row->id; } } if ($mode == 'edit') { $konter = $this->input->get_post('op_konterid'); $cu_id = $this->input->get_post('op_id'); } $cid = $this->input->get_post('customer_id'); $op_u_id = $this->input->get_post('op_usaha_id'); $rd_row = array(); foreach ($dtAT['dtAT'] as $rows) { $rd_row = array('customer_id' => $cid, 'konterid' => $konter, 'customer_usaha_id' => $cu_id, 'sumur_ke' => $i, 'sipa_no' => $rows[1], 'max_volume' => pad_to_decimal($rows[2]), 'disabled' => $rows[3]); $i++; $tambahan_data2 = array_merge($tambahan_data2, array($rd_row)); } //langsung ajah dah - sementara $query = "delete from pad_customer_usaha_air_tanah where (customer_id={$cid} and konterid={$konter})"; $this->db->query($query); $this->db->insert_batch('pad_customer_usaha_air_tanah', $tambahan_data2); } } }
function proces_op() { $mode = $this->uri->segment(4); $op_id = $this->input->get_post('op_id'); $usaha_model = $this->load->model('usaha_model'); $so = $usaha_model->get_so($this->input->get_post('op_usaha_id')); $update_data = array('customer_id' => $this->input->get_post('customer_id'), 'usaha_id' => $this->input->get_post('op_usaha_id'), 'so' => $so, 'kecamatan_id' => $this->input->get_post('op_kecamatan_id'), 'kelurahan_id' => $this->input->get_post('op_kelurahan_id'), 'notes' => $this->input->get_post('op_keterangan'), 'customer_status_id' => $this->input->get_post('op_status'), 'enabled' => 1, 'tmt' => $this->input->get_post('op_tmt') == '' ? NULL : date('Y-m-d', strtotime($this->input->get_post('op_tmt'))), 'opnm' => $this->input->get_post('op_nama'), 'opalamat' => $this->input->get_post('op_alamat'), 'latitude' => pad_to_decimal($this->input->get_post('op_latitude')), 'longitude' => pad_to_decimal($this->input->get_post('op_longitude')), 'def_pajak_id' => $this->input->get_post('op_pajak_id')); $op_model = $this->load->model('objek_pajak_model'); if ($mode == 'add') { $konter = $op_model->max_konter($this->input->get_post('customer_id')); $new_data = array('konterid' => $konter, 'reg_date' => date('Y-m-d'), 'created' => date('Y-m-d'), 'create_uid' => sipkd_user_id()); $update_data = array_merge($update_data, $new_data); $op_model->save($update_data); } if ($mode == 'edit') { $new_data = array('updated' => date('Y-m-d'), 'update_uid' => sipkd_user_id()); $update_data = array_merge($update_data, $new_data); $op_model->update($op_id, $update_data); } }
public function update() { if (!$this->module_auth->update) { $this->session->set_flashdata('msg_warning', $this->module_auth->msg_update); redirect(active_module_url('reklame_nsr')); } $p_id = $this->uri->segment(4); $post_data = $this->fpost(); $data['current'] = 'referensi'; $data['apps'] = $this->apps_model->get_active_only(); $data['faction'] = active_module_url("reklame_nsr/update/{$p_id}"); $this->fvalidation(); if ($this->form_validation->run() == TRUE) { $input_post = $post_data; $update_data = array('kelas_jalan_id' => empty($input_post['kelas_jalan_id']) ? NULL : $input_post['kelas_jalan_id'], 'media_id' => empty($input_post['media_id']) ? NULL : $input_post['media_id'], 'satuan' => empty($input_post['satuan']) ? NULL : $input_post['satuan'], 'njopr' => pad_to_decimal($input_post['njopr']), 'nspr' => pad_to_decimal($input_post['nspr']), 'nsr' => pad_to_decimal($input_post['nsr']), 'tmt' => empty($input_post['tmt']) ? NULL : date('Y-m-d', strtotime($input_post['tmt'])), 'enabled' => empty($input_post['enabled']) ? 0 : 1, 'updated' => date('Y-m-d h:i:s'), 'update_uid' => sipkd_user_id()); $this->reklame_nsr_model->update($p_id, $update_data); $this->session->set_flashdata('msg_success', 'Data telah disimpan'); redirect(active_module_url('reklame_nsr')); } $data['dt'] = $post_data; $this->load->view('vreklame_nsr_form', $data); }
private function fpost() { $data['id'] = $this->input->post('id'); $data['tahun'] = $this->input->post('tahun'); $data['terimano'] = $this->input->post('terimano'); $data['terimatgl'] = $this->input->post('terimatgl'); $data['jmlterima'] = pad_to_decimal($this->input->post('jmlterima')); $data['npwpd'] = $this->input->post('npwpd'); $data['customer_id'] = $this->input->post('customer_id'); $data['nobukti'] = $this->input->post('nobukti'); $data['notes'] = $this->input->post('notes'); $data['enabled'] = $this->input->post('enabled'); return $data; }
function proces_tarif() { $mode = $this->uri->segment(4); $tarif_id = $this->input->get_post('tarif_id'); $aktif = $this->input->get_post('p_enabled'); $update_data = array('pajak_id' => $this->input->get_post('pajak_id'), 'tarif' => pad_to_decimal($this->input->get_post('p_tarif')), 'reklame' => pad_to_decimal($this->input->get_post('p_reklame')), 'minimal_omset' => pad_to_decimal($this->input->get_post('p_minimal_omset')), 'tmt' => trim($this->input->get_post('p_tmt')) == '' ? NULL : date('Y-m-d', strtotime($this->input->get_post('p_tmt'))), 'enabled' => empty($aktif) ? 0 : 1); $tarif_model = $this->load->model('pajak_tarif_model'); if ($mode == 'add') { $new_data = array('created' => date('Y-m-d'), 'create_uid' => sipkd_user_id()); $update_data = array_merge($update_data, $new_data); $tarif_model->save($update_data); } if ($mode == 'edit') { $new_data = array('updated' => date('Y-m-d'), 'update_uid' => sipkd_user_id()); $update_data = array_merge($update_data, $new_data); $tarif_model->update($tarif_id, $update_data); } }