function form_office() { $this->db->trans_start(); list($day, $month, $year) = explode('/', $_REQUEST['tgl_penerimaan']); $arr['ID'] = $this->data_model->setID(); $no_bayar = getNoPenerimaan($_REQUEST['jenis_pungutan'], $_REQUEST['tgl_penerimaan']); $this->data_model->data = array('penerimaan_pr_id' => $arr['ID'], 'penetapan_pr_id' => $this->input->post('id_kohir'), 'pendataan_id' => $this->input->post('id_spt'), 'pendaftaran_id' => $this->input->post('id_npwp'), 'pemohon_id' => $this->input->post('id_pemohon'), 'skpd_id' => $this->input->post('id_dinas'), 'penerimaan_pr_no' => $no_bayar, 'tgl_penerimaan' => prepare_date($_REQUEST['tgl_penerimaan']), 'thn_penerimaan' => date('Y', strtotime(prepare_date($_REQUEST['tgl_penerimaan']))), 'bank_no' => $this->input->post('bank_no'), 'jenis_pungutan' => $this->input->post('jenis_pungutan'), 'nominal_pajak' => str_replace(',', '', $this->input->post('nominal_pajak')), 'id_ref_pembayaran' => $this->input->post('cpenyetoran'), 'keterangan' => $this->input->post('keterangan'), 'logs' => 'NOW', 'user_id' => $this->session->userdata('SESS_USER_ID')); $hsl = $this->data_model->insert_data(); $qy = 'select id_rekening, nominal from v_pendataan_content where pendataan_id=' . $this->db->escape($_REQUEST['id_spt']); $result = $this->db->query($qy); if ($result->num_rows() > 0) { foreach ($result->result() as $row) { $this->data_model->data_rincian = array('penerimaan_pr_id' => $arr['ID'], 'id_rekening' => $row->ID_REKENING, 'nominal' => $row->NOMINAL); $hsl = $this->data_model->insert_rincian_data(); } } if ($hsl) { $this->result_msg = '<li>:: Data telah tersimpan ::</li>'; } else { $this->result_msg = '<li>:: Error tersimpan data ::</li>'; } updateNoPenerimaan($_REQUEST['jenis_pungutan'], $_REQUEST['tgl_penerimaan']); echo $this->result_msg; $this->db->trans_complete(); }
<div id="tabs"> <ul> <li><a href="#tabs-1">Input</a></li> <li><a href="#tabs-2">Data</a></li> </ul> <div id="tabs-1"> <div style='padding:5px;'> <fieldset> <legend>Form Penerimaan Pajak/Retribusi Office Assesment</legend> <div> <div class="form_master"> <fieldset class="form_frame"> <input type='hidden' name='jenis_pungutan' id='jenis_pungutan' value='OFFICE'> <!--<div><label>Duplikasi Nomor</label><input type='checkbox' name='cnomor' id='cnomor' checked /></div>--> <div><label>No. Penerimaan</label><input type="text" name="nomor_reg" id='nomor_reg' size='10' value="<?php echo sprintf('%05d', getNoPenerimaan('OFFICE')); ?> " readonly/></div> <div><label>Tgl. Penerimaan <b class="wajib">*</b></label><input type="text" name="tgl_penerimaan" title='Tgl. Penerimaan' id="tgl_penerimaan" value='<?php echo date('d/m/Y'); ?> ' onchange="" size="10"/></div> <!--<div><label>Thn. SPT</label><input type='text' name='thn_spt' id='thn_spt' size='3' value='<?php echo date('Y'); ?> '></div>--> <div> <label>No. Kohir <b class="wajib">*</b></label> <input type='text' name='no_kohir' id='no_kohir' title='No. Kohir' readonly > <input type='hidden' name='id_kohir' id='id_kohir'> <input type="button" id="trigger_kohir" size="2" value=" * ">
where a.pendataan_id=' . quote_smart($_REQUEST['id']); $result = gcms_query($qy); $rs = gcms_fetch_object($result); $arr = array('no_kohir' => $rs->no_kohir, 'nominal_pajak' => $rs->nominal_pajak, 'no_pokok' => $rs->npwp, 'id_npwp' => $rs->pendaftaran_id, 'id_spt' => $rs->pendataan_id, 'nama_pemohon' => $rs->nama, 'id_pemohon' => $rs->pemohon_id, 'alamat' => $rs->alamat, 'kecamatan' => $rs->kecamatan, 'kelurahan' => $rs->kelurahan); echo json_encode($arr); } elseif ($_REQUEST['sender'] == 'list_npwp') { $crudColumns = array('id' => 'id', 'nama' => 'nama', 'npwp' => 'npwp'); $crudTableName = 'penetapan_pr'; include $expath . 'handler_list_npwp.php'; } elseif ($_REQUEST['sender'] == 'get_tgl_setor') { $tempo = b_fetch('select jatem_bayar from ref_jatuh_tempo'); $tgl_setor = getExpired($_REQUEST['tgl'], $tempo); echo $tgl_setor; } elseif ($_REQUEST['sender'] == 'set_nomor_office') { $no_bayar = getNoPenerimaan('OFFICE', $_REQUEST['tgl']); echo sprintf('%05d', $no_bayar); } elseif ($_REQUEST['sender'] == 'set_nomor_self') { $no_bayar = getNoPenerimaan('SELF', $_REQUEST['tgl']); echo sprintf('%05d', $no_bayar); } elseif ($_REQUEST['sender'] == 'daftar_office') { $crudColumns = array('id' => 'penerimaan_pr_id', 'no_bukti' => 'penerimaan_pr_no', 'nominal' => 'nominal', 'tgl_bayar' => 'tgl_penerimaan', 'no_kohir' => 'no_penetapan', 'jenis' => 'jenis', 'keterangan' => 'keterangan', 'nama_skpd' => 'nama_skpd'); include $expath . 'handler_daftar_penerimaan_office.php'; } elseif ($_REQUEST['sender'] == 'daftar_self') { $crudColumns = array('id' => 'penerimaan_pr_id', 'no_bukti' => 'penerimaan_pr_no', 'nominal' => 'nominal', 'tgl_bayar' => 'tgl_penerimaan', 'no_kohir' => 'no_penetapan', 'jenis' => 'jenis', 'keterangan' => 'keterangan', 'nama_skpd' => 'nama_skpd'); include $expath . 'handler_daftar_penerimaan_self.php'; } elseif ($_REQUEST['sender'] == 'default') { $crudColumns = array('pendataan_id' => 'pendataan_id', 'pendataan_no' => 'pendataan_no', 'tgl_entry' => 'tgl_entry', 'npwp' => 'npwp', 'nama' => 'nama', 'jenis_pendataan' => 'jenis_pendataan', 'jenis_pungutan' => 'jenis_pungutan', 'jenis_pendaftaran' => 'jenis_pendaftaran', 'spt_no' => 'spt_no', 'spt_tgl' => 'spt_tgl', 'nominal' => 'nominal'); $ID = 'pendataan_'; $crudTableName = 'v_pendataan'; include $expath . 'handler_penetapan_pr.php'; }
<?php include './config.php'; //include('global.php'); $expath = "." . str_replace("\\", "/", str_replace(realpath("."), "", dirname(__FILE__))) . "/"; if ($_REQUEST['sender'] == 'entri_penerimaan_pr') { //print_r($_REQUEST); if ($_REQUEST['action'] == 'edit') { } else { list($day, $month, $year) = explode('/', $_REQUEST['tgl_penerimaan']); $ID_HEADER = $fbird->setGenerator('GEN_PENERIMAAN_PR'); $no_bayar = getNoPenerimaan($_REQUEST['jenis_pungutan'], $_REQUEST['tgl_penerimaan']); $exception = array(); $other_request = array('penerimaan_pr_id' => $ID_HEADER, 'penetapan_pr_id' => $_REQUEST['id_kohir'], 'pendataan_id' => $_REQUEST['id_spt'], 'pendaftaran_id' => $_REQUEST['id_npwp'], 'pemohon_id' => $_REQUEST['id_pemohon'], 'skpd_id' => $_REQUEST['id_dinas'], 'penerimaan_pr_no' => $no_bayar, 'thn_penerimaan' => $year, 'id_ref_pembayaran' => $_REQUEST['cpenyetoran']); ibase_trans(); $a = $fbird->FBInsert('penerimaan_pr', $other_request, $exception); unset($exception); unset($other_request); $err = 0; if ($a) { $qy = 'select id_rekening, nominal from v_pendataan_content where pendataan_id=' . quote_smart($_REQUEST['id_spt']); $result = gcms_query($qy); while ($rs = gcms_fetch_object($result)) { $exception = array('penerimaan_pr_content_id'); $other_request = array('penerimaan_pr_id' => $ID_HEADER, 'id_rekening' => $rs->id_rekening, 'nominal' => $rs->nominal); $b = $fbird->FBInsert('penerimaan_pr_content', $other_request, $exception); if (!$b) { $err = 1; } } if ($b) {
<div id="tabs"> <ul> <li><a href="#tabs-1">Input</a></li> <li><a href="#tabs-2">Data</a></li> </ul> <div id="tabs-1"> <div style='padding:5px;'> <fieldset> <legend>Form Penerimaan Pajak/Retribusi Self Assesment</legend> <div> <div class="form_master"> <fieldset class="form_frame"> <input type='hidden' name='jenis_pungutan' id='jenis_pungutan' value='SELF'> <!--<div><label>Duplikasi Nomor</label><input type='checkbox' name='cnomor' id='cnomor' checked /></div>--> <div><label>No. Penerimaan</label><input type="text" name="nomor_reg" id='nomor_reg' size='10' value="<?php echo sprintf('%05d', getNoPenerimaan('SELF')); ?> " readonly/></div> <div><label>Tgl. Penerimaan <b class="wajib">*</b></label><input type="text" name="tgl_penerimaan" title='Tgl. Penerimaan' id="tgl_penerimaan" value='<?php echo date('d/m/Y'); ?> ' onchange="" size="10"/></div> <!--<div><label>Thn. SPT</label><input type='text' name='thn_spt' id='thn_spt' size='3' value='<?php echo date('Y'); ?> '></div>--> <div> <label>No. Pendataan <b class="wajib">*</b></label> <input type='text' name='no_kohir' id='no_kohir' title='No. Kohir' readonly > <input type='hidden' name='id_kohir' id='id_kohir'> <input type="button" id="trigger_kohir" size="2" value=" * ">