// range no. data
$qy = 'select a.*
from v_pendataan a
left join penetapan_pr_content b on b.pendataan_id=a.pendataan_id
where b.pendataan_id is null and a.jenis_pungutan=\'OFFICE\' and a.pendataan_no between ' . quote_smart($_REQUEST['no_data_awal']) . ' and ' . quote_smart($_REQUEST['no_data_akhir']) . ' order by a.pendataan_no ';
$result = gcms_query($qy);
while ($rs = gcms_fetch_object($result)) {
if ($_REQUEST['cnomor'] == '') {
// tdk duplikasi
//echo 'Tdk Duplikasi, Range'."\n";
list($day, $month, $year) = explode('/', $_REQUEST['tgl_penetapan']);
$ID_HEADER = $fbird->setGenerator('GEN_PENETAPAN_PR');
$no_kohir = getNoKohir();
$exception = array();
$other_request = array('penetapan_pr_id' => $ID_HEADER, 'no_penetapan' => $no_kohir, 'thn_penetapan' => $year, 'nominal_penetapan' => $rs->nominal);
updateNoKohir($_REQUEST['tgl_penetapan']);
$a = $fbird->FBInsert('penetapan_pr', $other_request, $exception);
unset($exception);
unset($other_request);
}
$exception = array('penetapan_pr_content_id');
$other_request = array('penetapan_pr_id' => $ID_HEADER, 'pendataan_id' => $rs->pendataan_id, 'nominal' => $rs->nominal, 'jenis_pendataan' => $rs->jenis_pendataan, 'jenis_pungutan' => $rs->jenis_pungutan);
$b = $fbird->FBInsert('penetapan_pr_content', $other_request, $exception);
if (!$b) {
$cdetail = 0;
}
}
}
if ($a && ($_REQUEST['cinput'] != '' && $cdetail)) {
ibase_commit();
} elseif ($a) {
// range no. data
$qy = 'select a.*
from v_penerimaan_pendataan a
left join penerimaan_pr_content b on b.pendataan_id=a.pendataan_id
where b.pendataan_id is null and a.pendataan_no between ' . quote_smart($_REQUEST['no_data_awal']) . ' and ' . quote_smart($_REQUEST['no_data_akhir']) . ' order by a.pendataan_no ';
$result = gcms_query($qy);
while ($rs = gcms_fetch_object($result)) {
if ($_REQUEST['cnomor'] == '') {
// tdk duplikasi
//echo 'Tdk Duplikasi, Range'."\n";
list($day, $month, $year) = explode('/', $_REQUEST['tgl_penerimaan']);
$ID_HEADER = $fbird->setGenerator('GEN_PENERIMAAN_PR');
$no_kohir = getNoKohir();
$exception = array();
$other_request = array('penerimaan_pr_id' => $ID_HEADER, 'no_penerimaan' => $no_kohir, 'thn_penerimaan' => $year, 'nominal_penerimaan' => $_REQUEST['nominal_pajak']);
updateNoKohir($_REQUEST['tgl_penerimaan']);
$a = $fbird->FBInsert('penerimaan_pr', $other_request, $exception);
unset($exception);
unset($other_request);
}
$exception = array('penerimaan_pr_content_id');
$other_request = array('penerimaan_pr_id' => $ID_HEADER, 'pendataan_id' => $rs->pendataan_id, 'nominal' => $rs->nominal, 'jenis_pendataan' => $rs->jenis_pendataan, 'jenis_pungutan' => $rs->jenis_pungutan);
$b = $fbird->FBInsert('penerimaan_pr_content', $other_request, $exception);
if (!$b) {
$cdetail = 0;
}
}
}
if ($a && ($_REQUEST['cinput'] != '' && $cdetail)) {
ibase_commit();
} elseif ($a) {
