Ejemplo n.º 1
0
 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=" * ">