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);
}
}
