function getASB2($id)
{
    $sql = "select kk.* from kelompok_kegiatan kk where kk.id = " . $id . "";
    $result = gcms_query($sql);
    while ($data = gcms_fetch_object($result)) {
        $ret["belanja"]["pegawai"]["rerata"] = $data->rata_pegawai;
        $ret["belanja"]["pegawai"]["deviasi"] = $data->std_deviasi_pegawai;
        $ret["belanja"]["barang"]["rerata"] = $data->rata_barang;
        $ret["belanja"]["barang"]["deviasi"] = $data->std_deviasi_barang;
        $ret["belanja"]["modal"]["rerata"] = $data->rata_modal;
        $ret["belanja"]["modal"]["deviasi"] = $data->std_deviasi_modal;
        for ($i = 1; $i <= 4; $i++) {
            $nama = "nama_indikator_" . $i;
            $koef = "koefisien_" . $i;
            if (!empty($data->{$nama})) {
                $ret["indikator"][$i]["nama"] = $data->{$nama};
                $ret["indikator"][$i]["koef"] = $data->{$koef};
            }
        }
        $ret["konstanta"] = $data->konstanta;
    }
    //  $ret .= "<input id='btn' type='submit' name='asb' value='asb'></div></div> <!-- asb -->\n";
    //$ret .= "";
    return $ret;
}
Exemple #2
0
function main_page_content()
{
    echo '<div id="main_content">';
    $lbl = array();
    $cnt = array();
    /* ambil isi .main tiap modul */
    $csql = "select cpath from " . PREFIX . "moduls";
    $nresult = gcms_query($csql);
    while ($opath = gcms_fetch_object($nresult)) {
        $mainfile = translate_modul_path(str_replace(".php", ".main.php", strtolower($opath->cpath)));
        if (file_exists($mainfile)) {
            $ainfo = b_readinit(translate_modul_path(str_replace(".php", ".init.php", strtolower($opath->cpath))));
            $lbl[] = $ainfo['name'];
            $cnt[] = $mainfile;
        }
    }
    $sel = false;
    if (count($lbl) > 0) {
        echo '<div id="gcms_main_tab" class="yui-navset"> ' . "\n" . '  <ul class="yui-nav"> ' . "\n";
        if ($_REQUEST['page'] || $_REQUEST['mod']) {
            $sel = true;
            echo '    <li class="selected"><a href="#gcms_main_tab_menu"><em>' . ($_REQUEST['page'] ? menu_get_title($_REQUEST['page']) : 'Utama') . '</em></a></li> ' . "\n";
        }
        foreach ($lbl as $k => $v) {
            echo '    <li';
            if (!$sel) {
                $sel = true;
                echo ' class="selected"';
            }
            echo '><a href="#gcms_main_tab' . $k . '" ><em>' . $v . '</em></a></li> ' . "\n";
        }
        echo '  </ul> ' . "\n" . '  <div class="yui-content"> ' . "\n";
        foreach ($cnt as $k => $v) {
            echo '    <div id="gcms_main_tab' . $k . '">';
            include $v;
            echo '</div> ' . "\n";
        }
        if ($_REQUEST['page'] || $_REQUEST['mod']) {
            echo '    <div id="gcms_main_tab_menu"><p>';
        }
    }
    /* masukkan isi halaman sesuai menu disini */
    if ($_REQUEST['page']) {
        menu_get_content($_REQUEST['page']);
    } else {
        if ($_REQUEST['mod']) {
            menu_get_content_by_mod($_REQUEST['mod'], $_REQUEST['func']);
        }
    }
    if (count($lbl) > 0) {
        if ($_REQUEST['page'] || $_REQUEST['mod']) {
            echo '</p></div> ' . "\n";
        }
        echo '  </div> ' . "\n" . '</div> ' . "\n";
    }
    echo '</div> <!-- main content -->';
}
function getKegiatan($id)
{
    $sql = 'select first 1 k.id ' . 'from KELOMPOK_KEGIATAN kk ' . 'join kegiatan k on k.ID_KELOMPOK = kk.ID ' . 'where id = ' . $id;
    $result = gcms_query($sql);
    while ($row = gcms_fetch_object($result)) {
        $id_kel[] = $row->id;
    }
    return $id_kel;
}
function getNamaIndikator($id)
{
    $sql = 'select first 1 nama_indikator_1, nama_indikator_2, nama_indikator_3, nama_indikator_4 ' . 'from kelompok_kegiatan where id = ' . $id;
    $result = gcms_query($sql);
    while ($row = gcms_fetch_object($result)) {
        $nama[1] = $row->nama_indikator_1;
        $nama[2] = $row->nama_indikator_2;
        $nama[3] = $row->nama_indikator_3;
        $nama[4] = $row->nama_indikator_4;
    }
    return $nama;
}
Exemple #5
0
function end_entri_default($entriid, $table, $idfield, $currentid, $confirmexp = "")
{
    $new = 'form.php?page=' . $_REQUEST['page'] . '&action=edit';
    $csql = "select max(" . $idfield . ") as id from " . $table . " where " . $idfield . " < " . $currentid;
    $nresult = gcms_query($csql);
    $id = gcms_fetch_object($nresult)->id;
    if ($id) {
        $prev = 'form.php?page=' . $_REQUEST['page'] . '&action=edit&id=' . $id;
    } else {
        $prev = "";
    }
    $csql = "select min(" . $idfield . ") as id from " . $table . " where " . $idfield . " > " . $currentid;
    $nresult = gcms_query($csql);
    $id = gcms_fetch_object($nresult)->id;
    if ($id) {
        $next = 'form.php?page=' . $_REQUEST['page'] . '&action=edit&id=' . $id;
    } else {
        $next = "";
    }
    end_entri($entriid, $new, $prev, $next, $confirmexp);
}
Exemple #6
0
/**
 * SubFunction: m_doselect()
 * Main module: Delivery Order
 * Create combobox, tag select
 *
 * @param string  <b>$cvarname</b> : variable's name, select tag's name
 * @param variant <b>$cprevval</b> : previous value
 * @param string  <b>$ctblname</b> : table's name
 * @param string  <b>$cfldkeys</b> : field key
 * @param string  <b>$cwhere</b>   : where clause
 * @param string  <b>$cfldviews</b>: fields to be viewed, seperated by comma
 * @param string  <b>$ajaxdo</b>   : ajax function in string, if there, ajax will execute on onchange event
 * @return none
 */
function b_htmlselect()
{
    $narg = func_num_args();
    $aarg = func_get_args();
    if ($narg > 3) {
        $cvarname = $aarg[0];
        $cprevval = $aarg[1];
        $ctblname = $aarg[2];
        $cfldkeys = $aarg[3];
        $cwhere = $narg > 4 ? $aarg[4] : '';
        $cfldview = explode(",", $narg > 5 ? $aarg[5] : $aarg[3]);
        $cajaxdo = "";
        if ($narg > 6) {
            $cajaxdo = $aarg[6];
        }
        ?>
<select name="<?php 
        echo $cvarname;
        ?>
" id="<?php 
        echo $cvarname;
        ?>
" style="width: 155px;"<?php 
        echo trim($cajaxdo) == "" ? "" : " onchange=\"" . $cajaxdo . "\"";
        ?>
><?php 
        ?>
<option style="width:315px" value=""<?php 
        echo trim($cprevval) == "" ? " selected" : "";
        ?>
></option><?php 
        $csqlselect = "SELECT * FROM " . PREFIX . $ctblname;
        if (trim($cwhere) != "") {
            $csqlselect .= " WHERE " . $cwhere;
        }
        // echo $csqlselect.'<br>';
        $nsqlselect = gcms_query($csqlselect);
        while ($osqlselect = gcms_fetch_object($nsqlselect)) {
            $strfldview = $cfldview;
            ?>
<option value="<?php 
            echo $osqlselect->{$cfldkeys};
            ?>
" style="width:100%"<?php 
            echo $osqlselect->{$cfldkeys} == $cprevval ? " selected" : "";
            ?>
><?php 
            $nfldcount = count($cfldview);
            $nfldloop = 0;
            for ($nfldloop = 0; $nfldloop < $nfldcount; $nfldloop++) {
                $xfldview = $cfldview[$nfldloop];
                echo ($nfldloop > 0 ? " - " : "") . $osqlselect->{$xfldview};
            }
            ?>
</option><?php 
        }
        ?>
</select><?php 
    }
}
         //echo $a;
         if ($a && $_REQUEST['rows'] == $_REQUEST['count']) {
             ibase_commit();
             //echo "xxx";
         }
     }
     if (!$a) {
         //	echo "no";
         ibase_rollback();
     }
 } else {
     unset($exception);
     unset($other_request);
     $ID_HEADER = $fbird->setGenerator('GEN_PENDATAAN_SPT');
     $cr_spt_no = gcms_query("select max(" . $tabel_spt_no . ") AS IdMax from " . $tabel_spt . " ");
     $max_spt = gcms_fetch_object($cr_spt_no);
     $new_no_spt = $max_spt->IDMAX + 1;
     if ($_REQUEST['SptIdHid'] == '') {
         $exception = array('spt_id', 'nama_kegiatan');
         $other_request = array('pendataan_id' => $ID_HEADER, 'pendataan_no' => $new_no_spt, 'tgl_proses' => $_REQUEST['TglProses'], 'tgl_entry' => $_REQUEST['TglEntri'], 'jenis_pendataan' => $_REQUEST['NamaPendataan'], 'jenis_pungutan' => $_REQUEST['SystemPemungutan'], 'periode_awal' => $_REQUEST['TglJualMulai'], 'periode_akhir' => $_REQUEST['TglJualSampai'], 'nominal' => str_replace(",", "", $_REQUEST['Pajak']));
     } else {
         $exception = array('nama_kegiatan');
         $other_request = array('pendataan_id' => $ID_HEADER, 'pendataan_no' => $new_no_spt, 'tgl_proses' => $_REQUEST['TglProses'], 'tgl_entry' => $_REQUEST['TglEntri'], 'jenis_pendataan' => $_REQUEST['NamaPendataan'], 'jenis_pungutan' => $_REQUEST['SystemPemungutan'], 'periode_awal' => $_REQUEST['TglJualMulai'], 'periode_akhir' => $_REQUEST['TglJualSampai'], 'nominal' => str_replace(",", "", $_REQUEST['Pajak']), 'spt_id' => $_REQUEST['SptIdHid']);
     }
     ibase_trans();
     $a = $fbird->FBInsert('pendataan_spt', $other_request, $exception);
     unset($exception);
     unset($other_request);
     $exceptionxx = array('hotel_id');
     $other_requestxxx = array('pendataan_id' => $ID_HEADER, 'hotel_nama' => $_REQUEST['nama_wp_wr'], 'hotel_alamat' => $_REQUEST['Alamat'], 'hotel_id_desa' => $_REQUEST['id_desa'], 'nominal' => str_replace(",", "", $_REQUEST['Tarif']), 'persen_tarif' => $_REQUEST['persen'], 'id_rekening' => $_REQUEST['IdRekening'], 'dasar_pengenaan' => str_replace(",", "", $_REQUEST['Pajak']));
     $ab = $fbird->FBInsert('pendataan_hotel', $other_requestxxx, $exceptionxx);
	</tr>

<?php 
    if (USERLEVEL >= bc_supervisor and !b_admin($_POST['nid']) and b_getuserlogin() != $_POST['nid']) {
        ?>
	<tr>
		<td colspan="2"><h2>Grant Modul</h2></td>
	</tr>
	<tr>
		<td colspan="2">
		<table>
<?php 
        $csql = "select * from " . PREFIX . "moduls order by nid";
        $nresult = gcms_query($csql);
        $i = 0;
        while ($omoduls = gcms_fetch_object($nresult)) {
            b_fetch("select count(nid) from " . PREFIX . "granted where nid_users='" . $_POST['nid'] . "' and nid_moduls='{$omoduls->nid}'") > 0 ? $ccheck = "checked" : ($ccheck = "");
            $ainfo = b_readinit(str_replace(".php", ".init.php", $omoduls->cpath));
            if (($ainfo['level'] <= USERLEVEL or b_admin(b_getuserlogin())) and $ainfo['type'] != "lib") {
                //(strtolower($ainfo['type'])=="admin")?$ctype="(Admin)":$ctype="(Frontend)";
                if (strtolower($ainfo['type']) == "admin") {
                    ?>
			<tr>
				<td><input type="checkbox" name="modul[<?php 
                    echo $i;
                    ?>
]" value="<?php 
                    echo $omoduls->nid;
                    ?>
" <?php 
                    echo $ccheck;
        }
        /* ubah id data yang dihapus ke dalam bentuk array */
        ${$daftar . '_deleted'} = array();
        $ds = explode(",", $_REQUEST[$daftar . '_deleted']);
        foreach ($ds as $d) {
            if ($d) {
                ${$daftar . '_deleted'}[] = $d;
            }
        }
    }
}
/* pada awalnya, untuk konek ke ekstensi disini, yaitu melalui 'page' yang akan menuju ke fungsi terkait di ekstensi
 * ke depan perlu mekanisme baru yang memungkinkan suatu ekstensi diakses tanpa lewat menu seperti terjadi di request data, 
 * buka pilihan dari modul lain, dll
 * 
 * --------------- PERLU DIPIKIRKAN DAN DIBENAHI LAGI ------------------
 */
/* perlu reverse untuk pemanggilan menggunakan nama modul dan fungsi - backward compatibility */
if (!$_REQUEST['page'] && $_REQUEST['mod'] && $_REQUEST['func']) {
    if (b_antisqlinjection($_REQUEST['mod']) && b_antisqlinjection($_REQUEST['func'])) {
        $func = $_REQUEST['func'];
        $csql = "select * from g_frontmenus where cfunction = '" . $func . "'";
        $page = gcms_fetch_object(gcms_query($csql))->nid;
        if (!$page) {
            $func = "m_" . $_REQUEST['mod'] . "_" . $_REQUEST['func'];
            $csql = "select * from g_frontmenus where cfunction = '" . $func . "'";
            $page = gcms_fetch_object(gcms_query($csql))->nid;
        }
        $_REQUEST['page'] = $page;
    }
}
<?php

include './../../../config.php';
include './../../../lib.php';
if (!b_antisqlinjection($_GET['id_kelompok'])) {
    die;
}
if (!empty($_GET['nomor_id'])) {
    $csql = "select * from kegiatan where id_kelompok=" . $_GET['nid'];
    if ($nresult = gcms_query($csql)) {
        $row = gcms_fetch_object($nresult);
        ?>
 			document.getElementById('nid').value="<?php 
        echo $row->id_kelompok;
        ?>
";
			
<?php 
    }
} else {
    ?>
		document.getElementById('nid').value='';
<?php 
}
function gcms_insert_id($table)
{
    $res = gcms_query("select gen_id(g_" . $table . "_nid, 0) as NID from rdb\$database");
    $obj = gcms_fetch_object($res);
    return $obj->NID;
}
<?php

$expath = "." . str_replace("\\", "/", str_replace(realpath("."), "", dirname(__FILE__))) . "/";
$qy = 'select lurah_id, lurah_nama from kelurahan ';
$data = gcms_query($qy);
$value = '';
while ($rs = gcms_fetch_object($data)) {
    $value .= "'{$rs->lurah_id}':'{$rs->lurah_nama}',";
}
if (isset($_REQUEST['page'])) {
    $param = 'page=' . $_REQUEST['page'];
} else {
    $param = 'mod=pendaftaran&func=pemohon';
}
?>

<script type="text/javascript"> 

function mycheck(val){
	if(parseFloat(value) >= 200 && parseFloat(value)<=300) { return [true,"",""]; } else { return [false,"The value should be between 200 and 300!",""]; } 
}

var lastsel;
jQuery(document).ready(function(){ 
	jQuery("#htmlTable").jqGrid({
		url:'request.php?<?php 
echo $param;
?>
&sender=pendaftaran_pemohon',		
		editurl:'request.php?<?php 
echo $param;
			<li><a href="#tabs-2"><em>Detail</em></a></li>
			<li><a href="#tabs-3"><em>Data</em></a></li>
		</ul>
		<div id="tabs-1">
			<input type="hidden" id="IdEdit" name="IdEdit" />
			<input type='hidden' name='NamaPendataan' id='NamaPendataan' value='RESTORAN'>
			<div style='padding:5px;'>
				<fieldset>
				<legend>PENETAPAN PAJAK RESTORAN</legend>
					<div id='asb_simulasi_form'>
						<div class="singleSide">
							<fieldset class="mainForm">
							<label class="leftField"><span>No. Reg Form</span>
							<?php 
$cr = gcms_query("select max(pendataan_no) AS IdMax from pendataan_spt");
$max = gcms_fetch_object($cr);
$new_max = $max->IDMAX + 1;
$new_no = sprintf("%06d", $new_max);
?>
							<input type="text" name="no_pendaftaran" id='NoRegForm' size='25' value="<?php 
echo $new_no;
?>
" readonly/>
							<input type="hidden" id="idHid" name="NoHid" value="<?php 
echo $new_max;
?>
" /> 
							</label>
							<label class="leftField"><span>Tgl Proses <b class="wajib">*</b></span>
							<input id='date_1' name='TglProses' type='text' title='Tanggal Proses' /><!--<input type="button" id="reset_tgl" size="2" value=".." />-->
								
                                    echo THEME_DIR;
                                    ?>
/images/icon/install.png" style="padding-left:5px;padding-right:5px;/*background-color:#B3D4FF*/; vertical-align:bottom;" /><?php 
                                    echo $omenu->cmenu;
                                    ?>
</a>
                                                                                        <div id="<?php 
                                    echo "sub_granted_menu_" . str_replace(" ", "_", $omenu->cmenu) . "menu_4";
                                    ?>
" class="yuimenu">
                                                                                            <div class="bd">
                                                                                                <ul class="first-of-type">
																								 <?php 
                                    $csql2 = "select a.* from " . PREFIX . "frontmenus as a where a.NID_GROUPFRONT_SUBMENUS = " . $omenu->nid . " order By a.NID_GROUPFRONT_SUBMENUS,a.nurut";
                                    $nres_submenu_2 = gcms_query($csql2);
                                    while ($omenu2 = gcms_fetch_object($nres_submenu_2)) {
                                        $nm = str_replace(".", "_", str_replace("-", "_", str_replace(" ", "_", stripslashes($omenu2->cmenu))));
                                        if (!$omenu2->width) {
                                            $omenu2->width = 600;
                                        } else {
                                            if (!$omenu2->height) {
                                                $omenu2->height = 500;
                                            } else {
                                            }
                                        }
                                        if ($omenu2->is_main == 1) {
                                            $load_menu2 = "index.php?page=" . $omenu2->nid;
                                        } else {
                                            if ($omenu2->is_main == 2) {
                                                $load_menu2 = "javascript:gcms_open_form('form_entri.php?page=" . $omenu2->nid . "','" . $nm . "'," . $omenu2->width . "," . $omenu2->height . ")";
                                            } else {
Exemple #15
0
    ?>
';
	document.getElementById('nominal').value='<?php 
    echo $row->nominal;
    ?>
';
	document.getElementById('penetapan_pr_id').value='<?php 
    echo $row->id;
    ?>
';
	document.getElementById('badan_id').value='<?php 
    echo $row->id_badan;
    ?>
';
<?php 
}
if (!empty($_GET['Petugas'])) {
    $sql = "select p.pejabat_id,p.nip,p.nama,g.nama AS golongan,pk.nama AS pangkat,j.nama AS jabatan\r\n\t\t\t\tfrom pejabat p\r\n\t\t\t\tleft join pangkat pk on p.pangkat_id = pk.id\r\n\t\t\t\tleft join golongan g on p.golongan_id = g.id\r\n\t\t\t\tleft join jabatan j on p.jabatan_id = j.id\r\n\t\t\t\twhere p.pejabat_id ='" . $_GET['Petugas'] . "'\r\n\t\t\t\t";
    $xx = gcms_query($sql);
    $row = gcms_fetch_object($xx);
    ?>
	document.getElementById('petugas_id').value='<?php 
    echo $row->pejabat_id;
    ?>
';
	document.getElementById('nama_petugas').value='<?php 
    echo $row->nama;
    ?>
';
	<?php 
}
	
	<tr>
		<td colspan="10"><br><hr><br></td>
	</tr>

	<tr><th colspan="7">New Menu</th></tr>
	<tr>
		<td><select name="cgroup[<?php 
echo $nindex;
?>
]" style="width:105px">
			<option style="width:200px"></option>
<?php 
$csql = "select nid, cgroup, bhide from  " . PREFIX . "groupfrontmenus order by nurut";
$nresult = gcms_query($csql);
while ($ogroup = gcms_fetch_object($nresult)) {
    $ogroup->bhide ? $copt = $ogroup->cgroup . " (hide)" : ($copt = $ogroup->cgroup);
    ?>
			<option value="<?php 
    echo $ogroup->nid;
    ?>
"><?php 
    echo $copt;
    ?>
</option>
<?php 
}
?>
		
		</select></td>
		<td><input type="text" name="cmenu[<?php 
function getViaPembayaran()
{
    $qy = 'select * from ref_pembayaran ';
    $result = gcms_query($qy);
    $option = '';
    while ($rs = gcms_fetch_object($result)) {
        $option .= "<option value='{$rs->kode}'>{$rs->keterangan}</option>";
    }
    return $option;
}
<?php

include 'config.php';
$sql = "SELECT * FROM INFO_PEMDA";
$res = gcms_query($sql);
$rs = gcms_fetch_object($res);
$datapicture = gcms_blob_echo($rs->logo);
Exemple #19
0
');
		//		document.getElementById('jumlah_tamu'+<?php 
            echo $i;
            ?>
).value=formatCurrency('<?php 
            echo $row->jumlah_tamu_per_hari;
            ?>
');
				<?php 
            $i++;
        }
    } else {
        $cari_master = "select * from pendataan_restoran pr\r\n\t\t\t\t\t\t\tleft join pendataan_spt ps on pr.pendataan_id = ps.pendataan_id\r\n\t\t\t\t\t\t\tleft join pendataan_restoran_detail pd on ps.pendataan_id = pd.pendataan_id\r\n\t\t\t\t\t\t\tleft join pendaftaran p on ps.pendaftaran_id = p.pendaftaran_id\r\n\t\t\t\t\t\t\tleft join rekening_kode rk on pr.id_rekening = rk.id\r\n\t\t\t\t\t\t\tleft join pemohon pm on p.id_pemohon = pm.pemohon_id \r\n\t\t\t\t\t\t\tleft join spt s on p.pendaftaran_id = s.pendaftaran_id\r\n\t\t\t\t\t\t\tleft join kelurahan k on pm.id_desa = k.lurah_id\r\n\t\t\t\t\t\t\tleft join kecamatan kc on k.lurah_kecamatan = kc.camat_id\r\n\t\t\t\t\t\t\twhere pr.restoran_id ='" . $_GET['DataForm'] . "'";
        $query_master = gcms_query($cari_master);
        //$total = 0;
        $row = gcms_fetch_object($query_master);
        //$total += $row->jumlah_kamar*$row->tarif_kamar;
        $NoReg = sprintf("%06d", $row->restoran_id);
        $TglProses = date("d-m-Y", strtotime($row->tgl_proses));
        $TglEntri = date("d-m-Y", strtotime($row->tgl_entry));
        $IdEdit = $row->restoran_id;
        $id_desa = $row->restoran_id_desa;
        $pendaftaran_id = $row->pendaftaran_id;
        $id_rekening = $row->id_rekening;
        $pendataan_id_hid = $row->pendataan_id;
        $Npwp = $row->npwp;
        $periodeSpt1 = $row->spt_no;
        if ($row->tgl_kembali == "" || $row->tgl_kembali == NULL) {
            $Tgl = "";
        } else {
            $Tgl = date("Y", strtotime($row->tgl_kembali));
    					"records":0,
    					"rows":[
    						{"id":0,"cell":[0,"","","","","","","","","",""]},
    					]
    				}';
    	*/
    include $expath . 'handler_rekening_kode.php';
} elseif ($_REQUEST['sender'] == 'set_list') {
    $qy = 'select * from rekening_kategori ';
    $data = gcms_query($qy);
    $val = '';
    while ($rs = gcms_fetch_object($data)) {
        $val .= "'{$rs->id}':'{$rs->nama_kategori}',";
    }
    echo $val;
} elseif ($_REQUEST['sender'] == 'pilih-rekening') {
    $crudColumns = array('id' => 'id', 'kode' => 'kode_rekening', 'nama' => 'nama_rekening');
    $crudTableName = 'rekening_kode';
    include 'jqGridCrud.php';
} elseif ($_REQUEST['sender'] == 'set_form') {
    $id = getIdRekening($_REQUEST['id']);
    $qry = 'select persen_tarif, tarif_dasar from rekening_kode where id=' . quote_smart($id);
    $result = gcms_query($qry);
    $rs = gcms_fetch_object($result);
    $arr = array('persen' => $rs->persen_tarif, 'tarif' => $rs->tarif_dasar);
    echo json_encode($arr);
} else {
    $crudColumns = array('id' => 'id', 'kode' => 'kode_skpd', 'nama' => 'nama_skpd');
    $crudTableName = 'skpd';
    include 'jqGridCrud.php';
}
Exemple #21
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') {
    $rs = gcms_fetch_object(gcms_query('select kode_rekening,nama_rekening,persen_tarif,tarif_dasar from rekening_kode where id=' . quote_smart($_REQUEST['val'])));
    ?>
	document.getElementById('rekening').value='<?php 
    echo $_REQUEST['val'];
    ?>
';
	document.getElementById('kode_rekening').value='<?php 
    echo $rs->kode_rekening;
    ?>
';
	document.getElementById('nama_rekening').value='<?php 
    echo $rs->nama_rekening;
    ?>
';
	document.getElementById('tarif_dasar').value='<?php 
    echo $rs->tarif_dasar;
<?php

/*
Bagian Ini untuk memproses data
*/
if ($_REQUEST['sender'] == "entri_SatuanKerja") {
    echo $_REQUEST['sender'] . "---" . $_REQUEST['KodeUnitKerja'];
}
if ($_REQUEST['sender'] == "entri_Pemda") {
    //echo $_REQUEST['sender']."xxx".$_REQUEST['kabKota'];
    $tabel = "PEMDA";
    $tabel_id = $tabel . "_ID";
    $max = "select max(PEMDA_ID) AS NMAX\r\n\t\t\t\t   from PEMDA";
    $Nmax = gcms_query($max);
    $new = gcms_fetch_object($Nmax);
    //echo $new->Nmax;
    $new_id = number_format($new->NMAX) + 1;
    $insert = "insert into " . $tabel . " values('" . $new_id . "','" . $_REQUEST['namaKab'] . "',\r\n\t\t\t\t\t\t\t\t\t\t\t'" . $_REQUEST['alamat'] . "','" . $_REQUEST['logo'] . "',\r\n\t\t\t\t\t\t\t\t\t\t\t'" . $_REQUEST['kodeLokasi'] . "','" . $_REQUEST['kabKota'] . "',\r\n\t\t\t\t\t\t\t\t\t\t\t'" . $_REQUEST['ibukotaKab'] . "','" . $_REQUEST['telp'] . "',\r\n\t\t\t\t\t\t\t\t\t\t\t'" . $_REQUEST['pejabat'] . "','" . $_REQUEST['namaBank'] . "',\r\n\t\t\t\t\t\t\t\t\t\t\t'" . $_REQUEST['noRek'] . "')";
    /*$insert	= "INSERT INTO ".$tabel." VALUES (";		
    	$sql = "DESCRIBE ".$tabel."";
    	$qry = gcms_query($sql);
    	$max="select max(".$tabel_id.") AS Nmax
    				   from ".$tabel."";
    	$Nmax=gcms_query($max);
    	$new_id = gcms_fetch_object($Nmax)->Nmax+1;
    		while($data = gcms_fetch_array($qryDesc)) {
    			if($data[0] == $tabel_id) $value =  $new_id ;
    			elseif($data[0] == $tabel."_NAMA") $value = $_REQUEST['namaKab'] ;
    			elseif($data[0] == $tabel."_LOKASI") $value = $_REQUEST['alamat'];
    			elseif($data[0] == $tabel."_LOGO_PATH") $value = $_REQUEST['logo'];
    			elseif($data[0] == $tabel."_KODE") $value = $_REQUEST['kodeLokasi'];
/**
 * 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;
    }
}
Exemple #24
0
                    $creff = "<a href=\"?cact=" . $_REQUEST['cact'] . "&csub={$omoduls->nid}\">" . trim($ainfo_menu['name']) . "</a>";
                }
            }
            $csubmenu .= "<li " . $ccurrent . ">" . $creff . "</li>\r\n";
        }
    }
    $cgroups = "('Manage'";
    foreach ($agroup as $cgroups_temp) {
        if ($cgroups_temp != "") {
            $cgroups .= ",'" . $cgroups_temp . "'";
        }
    }
    $cgroups .= ")";
    $csql = "select * from " . PREFIX . "groupmenus where cgroup in " . $cgroups . " order by nurut";
    $nresult = gcms_query($csql);
    while ($omenu = gcms_fetch_object($nresult)) {
        if ($_REQUEST['cact'] == $omenu->nid) {
            $creff = "<a href=\"?cact={$omenu->nid}\" class=\"current\">" . $omenu->cgroup . "</a>";
        } else {
            $creff = "<a href=\"?cact={$omenu->nid}\">" . $omenu->cgroup . "</a>";
        }
        ?>
    <li <?php 
        echo $ccurrent;
        ?>
 ><?php 
        echo $creff;
        ?>
</li>
<?php 
    }
Exemple #25
0
$nresult = gcms_query($csql);
while ($rox = gcms_fetch_object($nresult)) {
    $nama = array($rox->nama_indikator_1, $rox->nama_indikator_2, $rox->nama_indikator_3, $rox->nama_indikator_4);
    /*mereset data*/
    reset_arr($a);
    reset_arr($b);
    reset_arr($c);
    reset_arr($y);
    $sql = 'SELECT id id, (a.BELANJA_PEGAWAI) pegawai, 
            (a.BELANJA_BARANG_JASA) barang, (a.BELANJA_MODAL) modal, 
            (a.belanja_pegawai+a.belanja_barang_jasa+a.belanja_modal) total,
             a.indikator_1, a.indikator_2, a.indikator_3, a.indikator_4            
            from kegiatan a where a.id_kelompok = ' . $rox->id;
    $result = gcms_query($sql);
    $i = 0;
    while ($row = gcms_fetch_object($result)) {
        $a[] = $row->pegawai;
        $b[] = $row->barang;
        $c[] = $row->modal;
        $tot[] = $row->total;
        $ind[$i][] = 1;
        foreach ($nama as $key => $value) {
            if ($value != '') {
                switch ($key) {
                    case 0:
                        $ind[$i][] = $row->indikator_1;
                        break;
                    case 1:
                        $ind[$i][] = $row->indikator_2;
                        break;
                    case 2:
Exemple #26
0
/**
 * Mengambil konfigurasi
 *
 * @return unknown
 * @param variant $config
 */
function b_getconfig($config)
{
    $csql = "select * from " . PREFIX . "config where cname='" . $config . "'";
    $nreturn = gcms_query($csql);
    $oconfig = gcms_fetch_object($nreturn);
    if (strtolower(substr($config, 0, 1)) == 'c') {
        $return = $oconfig->cconfig;
    }
    if (strtolower(substr($config, 0, 1)) == 'n') {
        $return = $oconfig->nconfig;
    }
    if (strtolower(substr($config, 0, 1)) == 'd') {
        $return = $oconfig->dconfig;
    }
    return $return;
}
Exemple #27
0
    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);
    }
    ?>
	document.getElementById('pendaftaran_id').value='<?php 
    echo $_REQUEST['val'];
    ?>
';
	document.getElementById('nama_pemohon').value='<?php 
    echo $rs->nama;
    ?>
';
	document.getElementById('alamat').value='<?php 
    echo showMultiLine($rs->alamat);
    ?>
';
	document.getElementById('kecamatan').value='<?php 
<?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)) {