} else {
            }
            unset($exception);
            unset($other_request);
        }
    }
}
if ($_REQUEST['sender'] == "entri_pendaftaran_bu") {
    $cek = b_fetch('select count(*) from pendaftaran where no_pendaftaran=' . quote_smart($_REQUEST['no_pendaftaran']));
    if (!$cek) {
        $nomor = $_REQUEST['no_pendaftaran'];
        $nmax = (int) substr($_REQUEST['no_pendaftaran'], 1);
    } else {
        $nomor = setNomorPendaftaran($_REQUEST['jenis_pendaftaran'], $_REQUEST['objek_pdrd']);
        $message = $_REQUEST['no_pendaftaran'] . ' sudah terdaftar, ' . "\n" . 'diganti dengan ' . $nomor . "\n";
        $nmax = b_fetch('select max(nurut) from pendaftaran where jenis_pendaftaran=' . quote_smart($_REQUEST['jenis_pendaftaran']) . ' and objek_pdrd=' . quote_smart($_REQUEST['objek_pdrd']));
        //$nmax = b_fetch('select max(nurut) from pendaftaran where jenis_pendaftaran='.quote_smart($_REQUEST['jenis_pendaftaran']).' ');
        $nmax++;
    }
    $npwp = setNoNPWP($nmax, $_REQUEST['jenis_pendaftaran'], $_REQUEST['objek_pdrd'], $_REQUEST['pemohon']);
    $nokartu = setNoKartu($nmax, $_REQUEST['jenis_pendaftaran'], $_REQUEST['objek_pdrd'], $_REQUEST['tanggal_kartu']);
    $arr_field = array('id_pemohon', 'jenis_pendaftaran', 'nurut', 'no_pendaftaran', 'no_kartu', 'npwp', 'objek_pdrd', 'kode_usaha', 'tanggal_kartu', 'tanggal_terima', 'tanggal_kembali', 'tanggal_kirim', 'tanggal_tutup');
    $field = implode(',', $arr_field);
    $qy = 'insert into pendaftaran (' . $field . ') values (';
    $qy .= quote_smart($_REQUEST['pemohon']) . ',' . quote_smart($_REQUEST['jenis_pendaftaran']) . ",'{$nmax}'" . ',' . quote_smart($nomor) . ',' . quote_smart($nokartu) . ',' . quote_smart($npwp) . ',' . quote_smart($_REQUEST['objek_pdrd']) . ',' . quote_smart($_REQUEST['kode_usaha']) . ',' . quote_smart($_REQUEST['tanggal_kartu']) . ',' . quote_smart(blkDate($_REQUEST['tanggal_terima'])) . ',' . quote_smart(blkDate($_REQUEST['tanggal_kembali'])) . ',' . quote_smart(blkDate($_REQUEST['tanggal_kirim'])) . ',' . quote_smart(blkDate($_REQUEST['tanggal_tutup'])) . ')';
    if (gcms_query($qy)) {
        echo $message . 'Data telah tersimpan ';
    } else {
        echo '!';
    }
}
示例#2
0
<?php

if (isset($_POST['submit']) and b_admin(b_getuserlogin())) {
    if ($_POST['submit'] == "Disable") {
        if (b_checkdisabledependency($_POST['path'])) {
            $csql = "select nid from " . PREFIX . "moduls where cpath='" . $_POST['path'] . "'";
            $nid_moduls = b_fetch($csql);
            $csql = "delete from " . PREFIX . "granted where nid_moduls='{$nid_moduls}'";
            gcms_query($csql);
            if ($_POST['premove'] == "remove") {
                $csql = "select * from " . PREFIX . "tableinstalled where  nid_moduls='{$nid_moduls}'";
                $nresult = gcms_query($csql);
                while ($otable = gcms_fetch_object($nresult)) {
                    $csql2 = "drop table " . $otable->ctable;
                    gcms_query($csql2);
                }
            }
            $csql = "delete from " . PREFIX . "tableinstalled where nid_moduls='{$nid_moduls}'";
            gcms_query($csql);
            $csql = "delete from " . PREFIX . "moduls where cpath='" . $_POST['path'] . "'";
        } else {
            $ainfoerror = b_readinit(str_replace(".php", ".init.php", strtolower($_POST['path'])));
            $cerror = "Extension <b>" . $ainfoerror['name'] . " " . $ainfoerror['version'] . "</b> can't be disabled, \r\n                please check extension's dependency from the others<br/>";
        }
    }
    if ($_POST['submit'] == "Enable") {
        include "./../config.php";
        if (b_checkenabledependency($_POST['path'])) {
            // create list of current tables before process
            $nresult = gcms_list_tables(DATABASE);
            while ($atables = gcms_fetch_row($nresult)) {
示例#3
0
            $rows->nama_rekening = substr($rows->nama_rekening, 0, 24);
        }
        $nama_rek = strtolower($rows->nama_rekening);
        $str .= '<option value="' . $rows->persen_tarif . '">' . $rows->kode_rekening . " - " . $nama_rek . '</option>';
    }
    $str .= '</select>';
    ?>
	var kodeRek='<?php 
    echo $str;
    ?>
';
	<?php 
}
if (!empty($_GET['DataForm'])) {
    $idPendataan = b_fetch("select pendataan_id from pendataan_restoran where restoran_id ='" . $_GET['DataForm'] . "'");
    $count = b_fetch("select count(*) from pendataan_restoran_detail where pendataan_id ='" . $idPendataan . "'");
    if ($count) {
        ?>
		/*	$("tr.isi_detail").remove();
			for(id=1; id <= <?php 
        echo $count;
        ?>
; id++){
			//alert(id);
				var str = " <tr id='" + id + "' "
						 +" class='isi_detail'> ";			
				//var data = kodeRek;
				str += "<td><input type='hidden' id=\"DetailHid"+id+"\" name=\"DetailHid"+id+"\" ><input  id=\"jumlah_meja"+id+"\" type='text' name=\"jumlah_meja"+id+"\" value='' size='30'></td><td><input class='field_angka' id=\"jumlah_kursi"+id+"\" type='text' name=\"jumlah_kursi"+id+"\" size='10'></td><td><input class='field_angka' id=\"jumlah_tamu"+id+"\" type='text' name=\"jumlah_tamu"+id+"\" size='20' /></td>";
				
				str += "<td><input type='button' onclick=\"hapus_data('"+id+"');\" name='hapus' value='hapus' />";
				
         unset($other_request);
         if ($b) {
             ibase_commit();
             echo 'Data Telah Diupdate..';
         } else {
             ibase_rollback();
             echo 'Gagal Di Content';
         }
     } else {
         ibase_rollback();
         echo 'Gagal d Header ';
     }
 } else {
     $cek = b_fetch('select count(*) from pendataan_spt where pendataan_no=' . quote_smart((int) $_REQUEST['nomor']));
     if (!$cek) {
         $next_no = b_fetch('select max(pendataan_no) from pendataan_spt ');
         $next_no++;
         $no_spt = $next_no;
     } else {
         $message = 'Nomor ' . $_REQUEST['nomor'] . 'Sudah Ada !' . "\n" . 'Diganti dengan ' . sprintf('%05d', $next_no);
         $no_spt = (int) $_REQUEST['nomor'];
     }
     $ID_HEADER = $fbird->setGenerator('GEN_PENDATAAN_SPT');
     if ($_REQUEST['spt'] == '') {
         $exception = array('spt_id', 'nama_kegiatan');
         $other_request = array('pendataan_id' => $ID_HEADER, 'pendataan_no' => $no_spt, 'jenis_pendataan' => 'LISTRIK');
     } else {
         $exception = array('nama_kegiatan');
         $other_request = array('pendataan_id' => $ID_HEADER, 'pendataan_no' => $no_spt, 'jenis_pendataan' => 'LISTRIK', 'spt_id' => $_REQUEST['spt']);
     }
     ibase_trans();
示例#5
0
<ul id="adminmenu">
<?php 
if (!$_REQUEST['cact']) {
    $cact = 0;
} else {
    $cact = $_REQUEST['cact'];
}
$csql = "select cgroup from " . PREFIX . "groupmenus where nid='" . $cact . "'";
$cgroup = b_fetch($csql);
if ($_REQUEST['cact'] > 0) {
    $creff = "<a href=\"?cact=0\">Dashboard</a>";
} else {
    $creff = "<a href=\"?cact=0\" class=\"current\">Dashboard</a>";
}
?>
<li <?php 
echo $ccurrent;
?>
><?php 
echo $creff;
?>
</li>
<?php 
if ($bv_level > bc_inactive or true) {
    $csubmenu = "<ul id=\"submenu\">";
    $ccurrent = "";
    $creff = "";
    if ($_REQUEST['cact'] == 1) {
        if ($_REQUEST['csub'] > 0) {
            $creff = "<a href=\"?cact=" . $_REQUEST['cact'] . "&csub=0\">Extensions</a>\n";
        } else {
示例#6
0
/**
 * Fungsi untuk memanggil fungsi-fungsi start-up
 *
 */
function b_startup()
{
    $afunction = get_defined_functions();
    foreach ($afunction['user'] as $cfunction) {
        if (strtolower(substr($cfunction, 0, 2)) == "s_") {
            if (function_exists($cfunction)) {
                $ctempath = PATHEXTENSION;
            }
            $ctemp = substr($cfunction, 2, strlen($cfunction) - 2);
            $csql = "select cpath from " . PREFIX . "moduls where cpath like '%" . substr($ctemp, 0, strpos($ctemp, "_")) . ".php'";
            $initfile = str_replace(".php", ".init.php", strtolower(b_fetch($csql)));
            $initfile = translate_modul_path($initfile);
            $GLOBALS['bv_pathextension'] = dirname($initfile) . "/";
            define('PATHEXTENSION_STARTUP', dirname($initfile) . "/");
            call_user_func($cfunction, "");
        }
    }
}
<?php

if (basename(__FILE__) == basename($_SERVER['PHP_SELF'])) {
    die;
}
if ($_REQUEST['proses'] == 'Simpan') {
    $n = b_fetch("select count(*) from info_pemda");
    /*
    Cek Nilai n, 
    Jika kosong berarti Buat Baru, 
    else Update
    */
    if (!$n) {
        $id = 1;
        // inisialisasi, bahwa hanya ada satu data yang tersimpan
        $img_path = './images/pemda';
        //target penyimpanan file logo
        $csql = 'insert into info_pemda(id,pemda_nama,kode_lokasi,opt_kab,pejabat,pemda_alamat,pemda_kabupaten,
				ibu_kota,pemda_telp,pemda_fax,nama_bank,no_rekening,logo,tipe_gambar) 
				values(' . quote_smart($id) . ',' . "''," . quote_smart($_REQUEST['kodeLokasi']) . ',' . quote_smart($_REQUEST['kabKota']) . ',' . quote_smart($_REQUEST['pejabat']) . ',' . quote_smart($_REQUEST['alamat']) . ',' . quote_smart($_REQUEST['namaKab']) . ',' . quote_smart($_REQUEST['ibukotaKab']) . ',' . quote_smart($_REQUEST['telp']) . ',' . quote_smart($_REQUEST['fax']) . ',' . quote_smart($_REQUEST['namaBank']) . ',' . quote_smart($_REQUEST['noRek']);
        if (!empty($_FILES['logo']['tmp_name'])) {
            $tmpName = $_FILES['logo']['tmp_name'];
            $fileType = $_FILES['logo']['type'];
            global $fbdb;
            $blh = ibase_blob_create($fbdb);
            if ($_FILES['logo']['tmp_name'] != '') {
                ibase_blob_add($blh, file_get_contents($_FILES['logo']['tmp_name']));
            }
            $blobid = ibase_blob_close($blh);
            $csql .= ',?,' . sqlvalue($fileType, true) . ')';
            $target_file = $img_path . basename($_FILES['logo']['name']);
 }
 //echo print_r($_REQUEST);
 unset($exception);
 unset($other_request);
 $exception = array('penetapan_pr_content_id');
 $other_request = array('penetapan_pr_id' => $ID_HEADER, 'pendataan_id' => $_REQUEST['id']);
 $a = $fbird->FBInsert('penetapan_pr_content', $other_request, $exception);
 if ($a && $_REQUEST['rows'] == $_REQUEST['count']) {
     ibase_commit();
 }
 if (!$a) {
     ibase_rollback();
 }
 unset($exception);
 unset($other_request);
 $jenis_pendataan = b_fetch('select jenis_pendataan from pendataan_spt where pendataan_id=' . quote_smart($_REQUEST['id']));
 //echo $jenis_pendataan;
 /*switch $jenis_pendataan {
 			case 'LISTRIK': 
 				$table_name='pendataan_listrik';
 			break;
 			case 'GALIAN C': 
 				$table_name='pendataan_galianc';
 			break;
 			case 'AIR':
 				$table_name='pendataan_air';
 			break;
 		}*/
 /*$qy = 'select * from '.$table_name;
 		$result = gcms_query($qy);
 		while($rs = gcms_fetch_object($result)){
示例#9
0
function setNomor()
{
    $no = b_fetch('select max(spt_no) from spt');
    $no++;
    return sprintf('%05d', $no);
}
示例#10
0
        echo $rows->kode_rekening . " - " . $nama_rek;
        ?>
",
		  "persen"  : "<?php 
        echo $rows->persen_tarif;
        ?>
" },
		<?php 
    }
    ?>
	]
	<?php 
}
if ($_GET['persentarif']) {
    $sql = "SELECT a.PERSEN_TARIF from rekening_kode a where a.ID = " . $_GET['persentarif'];
    $persentarif = b_fetch($sql);
    echo "[{ 'tarif' : '" . $persentarif . "' }]";
}
if ($_GET['setnomor']) {
    $query = "select max(pendataan_no) from pendataan_spt where jenis_pendataan = 'PARKIR';";
    $result = gcms_query($query);
    $str = "[";
    while ($rows = gcms_fetch_object($result)) {
        $nomor = $rows->max;
        $nomor += 1;
        $str .= "{ \"nomor\" : \"" . sprintf("%06d", $nomor) . "\"},";
    }
    $str .= "]";
    echo $str;
}
//if( $_GET['edit'] && $_GET['edit'] == 'umum' ) {
         $firephp->info($sql, 'query');
     }
     gcms_query($sql) or die($firephp->error('Couldn t execute query.' . mysql_error()));
     break;
 case $crudConfig['delete']:
     /* ----====|| ACTION = DELETE ||====----*/
     if ($DEBUGMODE == 1) {
         $firephp->info('DELETE', 'action');
     }
     if ($postConfig['q'] != q) {
         $crudColumnValues[$crudFK] = $postConfig[$crudFK];
     }
     $val = substr(trim($crudColumnValues['id']), 1, count($crudColumnValues['id']) - 2);
     $id_del = explode(',', $val);
     foreach ($id_del as $del) {
         $cek = b_fetch('select count(*) from penerimaan_pr where penetapan_pr_id=' . quote_smart($del) . '');
         if (!$cek) {
             $qy_del2 = 'delete from penetapan_pr_content where penetapan_pr_id=' . quote_smart($del) . '';
             $qy_del1 = 'delete from penetapan_pr where penetapan_pr_id=' . quote_smart($del) . '';
             //echo $qy_del2."\n".$qy_del1."\n\n";
             gcms_query($qy_del2);
             gcms_query($qy_del1);
         } else {
             echo 'Gak Bisa' . "\n";
         }
     }
     $sql = 'Delete from ' . $crudTableName . ' where ' . $crudFK . ' = ' . $crudColumnValues['id'];
     //echo $crudColumnValues['id'];die;
     if ($DEBUGMODE == 1) {
         $firephp->info($sql, 'query');
     }
示例#12
0
            ?>
" <?php 
            echo $ccheck;
            ?>
>&nbsp;<?php 
            echo $omenus->cgroup . " - " . $omenus->cmenu;
            ?>
&nbsp;&nbsp;                </td>
				<td>&nbsp;&nbsp;&nbsp;&nbsp;Menu Level&nbsp;&nbsp;&nbsp;&nbsp;<select name="clevel[<?php 
            echo $i;
            ?>
]">
<?php 
            for ($ii = 0; $ii < USERLEVEL; $ii++) {
                if ($check = "checked") {
                    $nstatus = b_fetch("select nstatus from " . PREFIX . "grantedfrontmenus where nid_users='" . $_POST['nid'] . "' and nid_frontmenus='{$omenus->nid}'");
                    $nstatus == $ii ? $cselected = "selected" : ($cselected = "");
                }
                ?>
                    <option value="<?php 
                echo $ii;
                ?>
" <?php 
                echo $cselected;
                ?>
><?php 
                echo ucfirst($GLOBALS['bva_levelname'][$ii]);
                ?>
</option>
<?php 
            }
				<fieldset>
				<legend>FORM PENETAPAN</legend>
					<div>
						<div class="form_master">
							<fieldset class="form_frame">
								<!--<div><label>Duplikasi Nomor</label><input type='checkbox' name='cnomor' id='cnomor' checked /></div>-->
								<div><label>No. Penetapan</label><input type="text" name="nomor_reg" id='nomor_reg' size='10' value="<?php 
echo sprintf('%05d', getNoKohir());
?>
" readonly/></div>
								<div><label>Tgl. Penetapan<b class="wajib">*</b></label><input type="text" name="tgl_penetapan" title='Tgl. Penetapan' id="tgl_penetapan" value='<?php 
echo date('d/m/Y');
?>
' onchange="" size="10"/></div>
								<div><label>Tgl. Batas Setor<b class="wajib">*</b></label><input type="text" name="tgl_setor" title='Tgl. Batas Setor' id="tgl_setor" value='<?php 
echo getExpired(date('d/m/Y'), b_fetch('select jatem_bayar from ref_jatuh_tempo'));
?>
' onchange="" size="10"/></div>
								<!--<div><label>Jenis Penetapan</label><select name='jenis_penetapan' id='jenis_penetapan'><?php 
echo getKeteranganSPT();
?>
</select></div>-->
								<div><label>No. Pendataan<input type='checkbox' name='cinput' id='cinput' ></label><input type='text' name='no_data_awal' id='no_data_awal' size='5' readonly /> S/D <input type='text' name='no_data_akhir' id='no_data_akhir' size='5' readonly /></div>
								<div><label>Keterangan</label><textarea name='memo' id='memo'></textarea></div>
								<div><label>&nbsp;</b></label><input type='button' id='proses' class='btn' value='Simpan'></input></div>
							</fieldset>
							<fieldset class="form_frame">
								<div><label>Jenis Pendaftaran </label><select name="jenis_pendaftaran" id='jenis_pendaftaran'><option value=''></option><option value="PAJAK">Pajak</option><option value="RETRIBUSI">Retribusi</option></select></div>
								<div><label>Sistem Pemungutan </label><select name="pungutan"  id='pungutan'><option value=''></option><option value="SELF">Selft Assesment</option><option value="OFFICE">Office Assesment</option></select></div>
								<div><label>Tanggal Pendataan </label><input type="text" name="tgl_kirim" id="tgl_kirim" onchange="" size="10"/> S/D <input type="text" name="tgl_kembali" id="tgl_kembali" onchange="" size="10"/></div>
								<div><label>&nbsp;</label><input type='button' class='btn' id='cari' name='cari' value='Cari'></input></input></div>
<?php

include 'config.php';
include 'global.php';
$expath = "." . str_replace("\\", "/", str_replace(realpath("."), "", dirname(__FILE__))) . "/";
if ($_REQUEST['sender'] == 'kategori') {
    $crudColumns = array('id' => 'id', 'kode' => 'tipe_kategori', 'nama' => 'nama_kategori', 'saldo' => 'saldo_normal');
    $crudTableName = 'rekening_kategori';
    include 'jqGridCrud.php';
} elseif ($_REQUEST['sender'] == 'getiperekening') {
    if ($_REQUEST['val'] != '') {
        $kode = b_fetch('select id from rekening_kategori where tipe_kategori=' . quote_smart($_REQUEST['val']));
    } else {
        $kode = b_fetch('select tipe_kategori from rekening_kategori where id=' . quote_smart($_REQUEST['id']));
    }
    echo $kode;
} elseif ($_REQUEST['sender'] == 'getkoderekening') {
    /*if($_REQUEST['val']!=''){
    		$kode = b_fetch('select id from rekening_kategori where tipe_kategori='.quote_smart($_REQUEST['val']));	
    	}else{
    		$kode = b_fetch('select tipe_kategori from rekening_kategori where id='.quote_smart($_REQUEST['id']));		
    	}*/
    echo $_REQUEST['id'];
} elseif ($_REQUEST['sender'] == 'rekening') {
    $crudColumns = array('id' => 'id', 'tipe' => 'tipe', 'kelompok' => 'kelompok', 'jenis' => 'jenis', 'objek' => 'objek', 'rincian' => 'rincian', 'sub1' => 'sub1', 'sub2' => 'sub2', 'sub3' => 'sub3', 'kode' => 'kode_rekening', 'nama' => 'nama_rekening', 'kategori' => 'id_kategori');
    $crudFK = 'id';
    $crudTableName = 'rekening_kode';
    $table1 = 'rekening_kode';
    $pk_table1 = 'id';
    $table2 = 'rekening_kategori';
    $pk_table2 = 'id';
function setNomor()
{
    $no = b_fetch('select max(pendataan_no) from pendataan_spt');
    $no++;
    return sprintf('%05d', $no);
}
示例#16
0
/**
 * Mendapatkan title berdasarkan menu yang dipilih
 *
 * @param string $cpage
 * @return unknown
 */
function menu_get_title($cpage)
{
    if (b_antisqlinjection($cpage) and $cpage != "") {
        if (b_admin(b_getuserlogin())) {
            $csql = "select * from " . PREFIX . "frontmenus where nid='" . $cpage . "'";
        } else {
            $csql = "select a.* from " . PREFIX . "frontmenus as a\r\n\t\t       left join " . PREFIX . "grantedfrontmenus as b on a.nid=b.nid_frontmenus\r\n\t\t       where a.nid='" . $cpage . "' and \r\n\t\t       (b.nid_users='" . b_getuserlogin() . "' or a.bsecure=0)";
        }
        $nresult = gcms_query($csql);
        $opage = gcms_fetch_object($nresult);
        $csql = "select cgroup from " . PREFIX . "groupfrontmenus where nid='" . $opage->nid_groupfrontmenus . "'";
        $creturn = b_fetch($csql) . " - " . $opage->cmenu;
        return $creturn;
    }
}
示例#17
0
}
include 'header-admin.php';
if (!b_logged()) {
    include 'login.php';
} else {
    include 'menu.php';
    if ($_REQUEST['cact'] == 0) {
        include 'dashboard.php';
    } else {
        if ($bdash) {
            include 'extension.php';
        } else {
            if (isset($cpath)) {
                ?>
<div class="judul"><?php 
                echo $ainfo['name'];
                ?>
</div>
<?php 
                $ainfo = b_readinit(str_replace(".php", ".init.php", $cpath));
                $csql = "select nstatus from " . PREFIX . "granted where nid_users='" . $_SESSION['nid_login'] . "' and nid_moduls='" . $_REQUEST['csub'] . "'";
                if (b_fetch($csql) >= $ainfo['level'] or b_admin(b_getuserlogin())) {
                    if (file_exists($cpath)) {
                        include $cpath;
                    }
                }
            }
        }
    }
}
include 'footer-admin.php';
示例#18
0
?>
>
<div class="layar">
<table cellpadding="0" cellspacing="0" width="100%">
    <tr>
        <td align="left"><img src="../images/bandung.jpg"></td>
        <td align="right" valign="top">
    </tr>
</table>
</div>


<?php 
if (b_logged()) {
    $csql = "select cname from " . PREFIX . "users where nid=" . $_SESSION['nid_login'];
    $info_left = '&nbsp;&nbsp;&nbsp;Logged as ' . b_fetch($csql);
    $info_right = '&nbsp;&nbsp;<a href="?cact=logout">[ Logout ]</a> <a href="../">[  Main Menu ]</a>&nbsp;&nbsp;';
}
?>
<table align="center" cellpadding="0" cellspacing="0" border="0" width="61%" style="padding-bottom:10px;padding-top:10px; background-color:#CCCCCC; border-bottom:1px solid #999999; border-top:1px solid #999999">
<tr>
<td align="left">
<div class="top_menu_admin">
<?php 
echo $info_left;
?>
</div>
</td>
<td align="right" valign="top">
<div class="top_menu_admin">
<?php 
        $other_request = array('id_desa' => $_REQUEST['desa']);
        $str_where = ' where ' . $crudFK . '=' . quote_smart($_REQUEST['id']);
        $a = $fbird->FBUpdate($crudTableName, $other_request, $exception, $str_where);
        break;
    case $crudConfig['delete']:
        /* ----====|| ACTION = DELETE ||====----*/
        if ($DEBUGMODE == 1) {
            $firephp->info('DELETE', 'action');
        }
        if ($postConfig['q'] != q) {
            $crudColumnValues[$crudFK] = $postConfig[$crudFK];
        }
        $val = substr(trim($crudColumnValues['id']), 1, count($crudColumnValues['id']) - 2);
        $id_del = explode(',', $val);
        foreach ($id_del as $del) {
            $cek = b_fetch('select count(*) from pendaftaran where id_pemohon=' . quote_smart($del) . ' and objek_pdrd=\'PRIBADI\'');
            if (!$cek) {
                $sql = 'Delete from ' . $crudTableName . ' where ' . $crudFK . ' = ' . quote_smart($del);
                if ($DEBUGMODE == 1) {
                    $firephp->info($sql, 'query');
                }
                gcms_query($sql) or die($firephp->error('Couldn t execute query.' . mysql_error()));
            }
        }
        break;
}
/* ----====|| SEND OUTPUT ||====----*/
if ($DEBUGMODE == 1) {
    $firephp->info('End Of Script', 'status');
}
print json_encode($o);
示例#20
0
" <?php 
                    echo $ccheck;
                    ?>
>&nbsp;
				<?php 
                    echo $ainfo['name'];
                    ?>
&nbsp;&nbsp;
				</td>
				<td>&nbsp;&nbsp;Modul Level&nbsp;&nbsp;&nbsp;&nbsp;<select name="clevel[<?php 
                    echo $i;
                    ?>
]"><?php 
                    for ($ii = $ainfo['level']; $ii < USERLEVEL; $ii++) {
                        if ($check = "checked") {
                            $nstatus = b_fetch("select nstatus from " . PREFIX . "granted where nid_users='" . $_POST['nid'] . "' and nid_moduls='{$omoduls->nid}'");
                            $nstatus == $ii ? $cselected = "selected" : ($cselected = "");
                        }
                        ?>
    				<option value="<?php 
                        echo $ii;
                        ?>
" <?php 
                        echo $cselected;
                        ?>
><?php 
                        echo ucfirst($GLOBALS['bva_levelname'][$ii]);
                        ?>
</option>
<?php 
                    }
<?php

include 'config.php';
include 'global.php';
$expath = "." . str_replace("\\", "/", str_replace(realpath("."), "", dirname(__FILE__))) . "/";
if ($_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') {
    $no_kohir = getNoKohir($_REQUEST['tgl']);
    echo sprintf('%05d', $no_kohir);
} elseif ($_REQUEST['sender'] == 'pilih_kohir') {
    $ID = 'penetapan_pr_';
    $crudColumns = array('id' => 'penetapan_pr_id', 'nomor' => 'no_penetapan', 'tgl' => 'tgl_penetapan', 'setor' => 'tgl_setor', 'nominal' => 'nama');
    $crudTableName = 'penetapan_pr';
    include $expath . 'handler_pilih_kohir.php';
} elseif ($_REQUEST['sender'] == 'pilih_spt') {
    $ID = 'penetapan_pr_';
    $crudColumns = array('id' => 'penetapan_pr_id', 'nomor' => 'no_penetapan', 'tgl' => 'tgl_penetapan', 'setor' => 'tgl_setor', 'nominal' => 'nama');
    $crudTableName = 'penetapan_pr';
    include $expath . 'handler_pilih_no_pendataan.php';
} elseif ($_REQUEST['sender'] == 'daftar') {
    $crudColumns = array('id' => 'penetapan_pr_id', 'no_kohir' => 'no_penetapan', 'tgl_kohir' => 'tgl_penetapan', 'tgl_setor' => 'tgl_setor', 'nominal' => 'nominal', 'pendataan_no' => 'pendataan_no', 'periode_awal' => 'periode_awal', 'periode_akhir' => 'periode_akhir', 'jenis' => 'jenis');
    include $expath . 'handler_daftar_kohir.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';
}
示例#22
0
<?php

include "./../../../config.php";
include "./../../../lib.php";
$nomax = b_fetch('select max(pendataan_no) from pendataan_spt ');
$nomax++;
?>
document.getElementById('nomor').value='<?php 
echo sprintf('%05d', $nomax);
?>
';
示例#23
0
			<IMG SRC="<?php 
echo THEME_DIR;
?>
/images/form2_05.png" WIDTH=21 HEIGHT=73 ALT=""></TD>
		</TR>
		<TR>
			<TD WIDTH=20 HEIGHT=149 style="background-image:url(<?php 
echo THEME_DIR;
?>
/images/form2_06.png)">&nbsp;</TD>
			<TD colspan="3" bgcolor="#F2F1E6">
				<table width="100%" border="0" cellpadding="0" cellspacing="0">
					<tr>
						<td align="center">
						<?php 
$logo = b_fetch('select logo from info_pemda');
if (!empty($logo)) {
    echo "<img src=\"showimage.php?id=1\" height='157'>";
} else {
    echo '<img src="images/garuda.gif" width="139" height="133"  style="margin-left:10%; margin-top:5%">';
}
?>
						</td>
						<td><div style="border:1px solid #CCCCCC; padding:10; background-color:#E9ECEF">
							<form action="login.php" method="POST">
								<table border="0" cellpadding="0" cellspacing="0" width="100%">
									<tr>
										<td>
											Username<br>
											<input class="login_input" type="text" name="cuser" style="width:100%"><br><br>
											Password<br>
<?php

$expath = "." . str_replace("\\", "/", str_replace(realpath("."), "", dirname(__FILE__))) . "/";
include "entri.php";
yuiBeginEntry("entri_penerimaan_pr");
$include = '<script type="text/javascript" src="lib.js"></script>' . "\n";
$kabupaten = b_fetch('select pemda_kabupaten from info_pemda');
gcms_add_to_head($include);
?>
<script>

var lastsel,lastsel2,lastsel3;
var timeoutHnd; var flAuto = false; 

$().ready(function(){
	
	jQuery("#htmlTable").jqGrid(
	{
		 url:'request.php?mod=penetapan_pr&func=list&sender=pilih_kohir',
		 datatype: 'json',
		 mtype: 'POST',
		 colNames:['id','No. Kohir','Tgl. Penetapan','Tgl. Jatuh Tempo','Nominal Penetapan'],
		 colModel :[
			{ name:'id' ,index:'id',search:false},
			{ name:'kohir',index:'kohir',width:80},
			{ name:'tgl' ,index:'tgl',width:120,align:'center',formatter:'date', sorttype:"date"},
			{ name:'setor' ,index:'setor',width:120,align:'center',formatter:'date', sorttype:"date"},
			{ name:'nominal' ,index:'nominal',width:150,align:'right',formatter:'currency',formatoptions:{decimalSeparator:".",thousandsSeparator:",",decimalPlaces:2}},
		 ],
		pager: jQuery('#htmlPager'),
		height:150,
function getExpired($val, $max, $format = 'd/m/Y')
{
    list($hari, $bulan, $tahun) = explode('/', $val);
    $tahun = (int) $tahun;
    $bulan = (int) $bulan;
    $hari = (int) $hari;
    $sabtu_minggu = '';
    $hari_kerja = '';
    $nlibur = '';
    $close = 0;
    while ($hari_kerja <= $max) {
        if ($close) {
            break;
        }
        if ($bulan > 12) {
            $bulan = 1;
            $tahun++;
        }
        $tgl_merah = b_fetch("select tgl_merah from ref_tanggal_merah where id=" . $bulan);
        $nmerah = explode(".", $tgl_merah);
        $nhari = cal_days_in_month(CAL_GREGORIAN, $bulan, $tahun);
        $start = !empty($hari) ? $hari + 1 : 1;
        while ($start <= $nhari) {
            $nday = date("w", $f_day = mktime(0, 0, 0, $bulan, $start, $tahun));
            if ($nday == 0 || $nday == 6) {
                $sabtu_minggu++;
            } else {
                if (in_array($start, $nmerah)) {
                    $nlibur++;
                } else {
                    $hari_kerja++;
                }
            }
            if ($hari_kerja == $max) {
                return date($format, mktime(0, 0, 0, $bulan, $tgl, $tahun));
                $close = 1;
            }
            $start++;
            $tgl = $start;
            if ($close) {
                break;
            }
        }
        $bulan++;
        $hari = 0;
    }
}
示例#26
0
<?php

include "./../../../config.php";
include "./../../../lib.php";
if ($_REQUEST['type'] == 'npwp') {
    $id_pemohon = b_fetch('select id_pemohon from pendaftaran where pendaftaran_id=' . quote_smart($_REQUEST['val']));
    $npwp = b_fetch('select npwp from pendaftaran where pendaftaran_id=' . quote_smart($_REQUEST['val']));
    $jenis = b_fetch('select objek_pdrd from pendaftaran where pendaftaran_id=' . quote_smart($_REQUEST['val']));
    $spt_no = b_fetch('select b.spt_no from pendaftaran a join spt b on b.pendaftaran_id=a.pendaftaran_id where a.pendaftaran_id=' . quote_smart($_REQUEST['val']));
    $spt_id = b_fetch('select b.spt_id from pendaftaran a join spt b on b.pendaftaran_id=a.pendaftaran_id where a.pendaftaran_id=' . quote_smart($_REQUEST['val']));
    $spt_no = $spt_no != '' ? sprintf('%05d', $spt_no) : '';
    $wp_wr_gol = substr($npwp, 1, 1);
    $wp_wr_no_urut = substr($npwp, 2, 5);
    $wp_wr_kd_camat = substr($npwp, 7, 2);
    $wp_wr_kd_lurah = substr($npwp, 9, 2);
    if ($jenis == 'PRIBADI') {
        $qy = 'select a.nama, a.alamat, b.lurah_nama, c.camat_nama 
			   from pemohon a 
			   join kelurahan b on a.id_desa=b.lurah_id
			   join kecamatan c on c.camat_id=b.lurah_kecamatan
			   where a.pemohon_id=' . quote_smart($id_pemohon);
        $data = gcms_query($qy);
        $rs = gcms_fetch_object($data);
    } else {
        $qy = 'select a.nama, a.alamat, b.lurah_nama, c.camat_nama 
			   from badan_usaha a 
			   join kelurahan b on a.badan_id_desa=b.lurah_id
			   join kecamatan c on c.camat_id=b.lurah_kecamatan		   
			   where a.id=' . quote_smart($id_pemohon);
        $data = gcms_query($qy);
        $rs = gcms_fetch_object($data);
示例#27
0
$count_users = b_fetch('select count(*) from ' . PREFIX . 'users where nstatus=4');
/* ambil theme */
require_once THEME_DIR . "/theme.php";
if (b_logged()) {
    $ainfouser = b_userinfo();
    $user_name = $ainfouser['name'];
    $spbu_no = $_SESSION['spbu_no'];
    $branch = $_SESSION['branch_name'];
    if ($user_name == "Administrator") {
        $header = "&nbsp;&nbsp;Management " . $user_name;
    } elseif (!$spbu_no) {
        $header = "&nbsp;&nbsp;Divisi Head Office - " . $user_name;
    } else {
        $header = "&nbsp;&nbsp;Unit SPBU : " . $spbu_no . " - " . $user_name;
    }
    $memo = b_fetch('select memo from memorandum WHERE status = 1');
}
?>
<html>
<head>
<title><?php 
echo WEB_TITLE;
?>
</title>
<link rel="shortcut icon" href="./images/controlpanel.png" type="image/ico">
<link rel="stylesheet" type="text/css" href="gcms.css">
<script type="text/javascript" src="gcms.js"></script>
<script type="text/javascript" src="<?php 
echo THEME_DIR;
?>
/theme.js"></script>
示例#28
0
	document.getElementById('wp_wr_no_urut').value='<?php 
    echo $wp_wr_no_urut;
    ?>
';
	document.getElementById('wp_wr_kd_camat').value='<?php 
    echo $wp_wr_kd_camat;
    ?>
';
	document.getElementById('wp_wr_kd_lurah').value='<?php 
    echo $wp_wr_kd_lurah;
    ?>
';	
<?php 
} elseif ($_REQUEST['type'] == 'rekening') {
    $kode_rekening = b_fetch('select kode_rekening from rekening_kode where id=' . quote_smart($_REQUEST['val']));
    $nama_rekening = b_fetch('select nama_rekening from rekening_kode where id=' . quote_smart($_REQUEST['val']));
    ?>
	document.getElementById('rekening_id').value='<?php 
    echo $_REQUEST['val'];
    ?>
';
	document.getElementById('kode_rekening').value='<?php 
    echo $kode_rekening;
    ?>
';
	document.getElementById('nama_rekening').value='<?php 
    echo $nama_rekening;
    ?>
';
<?php 
}
示例#29
0
if ($_REQUEST['sender'] == 'entri_spt') {
    if ($_REQUEST['action'] == 'edit') {
        $exception = array('spt_id', 'penerima_nama', 'penerima_alamat', 'spt_no');
        //$other_request = array('spt_no'=>$no_spt);
        $other_request = array();
        $str_where = ' where spt_id=' . quote_smart($_REQUEST['idmasters']);
        $a = $fbird->FBUpdate('spt', $other_request, $exception, $str_where);
        if ($a) {
            echo 'Data Telah diupdate';
        } else {
            echo 'Error';
        }
    } else {
        $cek = b_fetch('select count(*) from spt where spt_no=' . quote_smart((int) $_REQUEST['nomor']));
        if (!$cek) {
            $next_no = b_fetch('select max(spt_no) from spt ');
            $next_no++;
            $no_spt = $next_no;
        } else {
            $message = 'Nomor ' . $_REQUEST['nomor'] . 'Sudah Ada !' . "\n" . 'Diganti dengan ' . sprintf('%05d', $next_no);
            $no_spt = (int) $_REQUEST['nomor'];
        }
        $exception = array('spt_id', 'penerima_nama', 'penerima_alamat');
        $other_request = array('spt_no' => $no_spt);
        $a = $fbird->FBInsert('spt', $other_request, $exception);
        if ($a) {
            echo 'Data telah tersimpan';
        } else {
            echo 'Error';
        }
    }