本文整理汇总了PHP中gcms_query函数的典型用法代码示例。如果您正苦于以下问题：PHP gcms_query函数的具体用法？PHP gcms_query怎么用？PHP gcms_query使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了gcms_query函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: getASB2
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;
}
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:25，代码来源:kegiatan.lib.php
示例2: getKegiatan
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;
}
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:9，代码来源:kelompok.lib.php
示例3: main_page_content
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 -->';
}
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:57，代码来源:main.php
示例4: getNamaIndikator
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;
}
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:12，代码来源:master.init.php
示例5: end_entri_default
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);
}
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:21，代码来源:_entri.php
示例6: str_replace
<li class="yuimenuitem"><a class="yuimenuitemlabel" style="padding-Left:0px; padding-bottom:2px;font-size:11px; font-family:Arial; font-weight:bold;" ><img src="<?php
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 . ")";
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:31，代码来源:menu_old.php
示例7: b_htmlselect
/**
* 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
}
}
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:74，代码来源:lib_pr.php
示例8:
<?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
}
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:24，代码来源:ajaxdo_info.php
示例9: mean
$i += 1;
}
/*menghitung rata-rata */
$average_pegawai = mean($a);
$average_barang = mean($b);
$average_modal = mean($c);
/*menghitung standar deviasi */
$standard_deviation_pegawai = standard_deviation_population($a);
$standard_deviation_barang = standard_deviation_population($b);
$standard_deviation_modal = standard_deviation_population($c);
}
//while
$dataX = $ind;
$dataY = $tot;
$M = new matrix($dataX);
$X = $M->ArrayData;
$M = new matrix($dataY);
$Y = $M->ArrayData;
$Xt = $M->Transpose($X);
$XtX = $M->MultiplyMatrix($Xt, $X);
$XtY = $M->MultiplyMatrix($Xt, $Y);
$XtXi = $M->InverseMatrix($XtX);
$b = $M->MultiplyMatrix($XtXi, $XtY);
$usql = "update kelompok_kegiatan set " . "koefisien_1=" . (empty($b[1][0]) ? 'null' : sprintf("%01.3f", $b[1][0])) . ",koefisien_2=" . (empty($b[2][0]) ? 'null' : sprintf("%01.3f", $b[2][0])) . ",koefisien_3=" . (empty($b[3][0]) ? 'null' : sprintf("%01.3f", $b[3][0])) . ",koefisien_4=" . (empty($b[4][0]) ? 'null' : sprintf("%01.3f", $b[4][0])) . ",konstanta=" . (empty($b[0][0]) ? 'null' : sprintf("%01.3f", $b[0][0])) . ",rata_pegawai=" . (empty($average_pegawai) ? 'null' : sprintf("%01.3f", $average_pegawai)) . ",rata_barang=" . (empty($average_barang) ? 'null' : sprintf("%01.3f", $average_barang)) . ",rata_modal=" . (empty($average_modal) ? 'null' : sprintf("%01.3f", $average_modal)) . ",std_deviasi_pegawai=" . (empty($standard_deviation_pegawai) ? 'null' : sprintf("%01.3f", $standard_deviation_pegawai)) . ",std_deviasi_barang=" . (empty($standard_deviation_barang) ? 'null' : sprintf("%01.3f", $standard_deviation_barang)) . ",std_deviasi_modal=" . (empty($standard_deviation_modal) ? 'null' : sprintf("%01.3f", $standard_deviation_modal)) . " where id=" . $_REQUEST[gid];
gcms_query($usql);
echo $usql;
?>
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:27，代码来源:asb.php
示例10: gcms_query
/* add any additonal update statements here */
$sql .= ' where ' . $crudFK . ' = ' . $crudColumnValues['id'];
if ($DEBUGMODE == 1) {
$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');
}
print_r($crudColumnValues);
echo '----';
print_r($crudColumnValues);
if ($postConfig['q'] != q) {
$crudColumnValues[$crudFK] = $postConfig[$crudFK];
}
$sql = 'Delete from ' . $crudTableName . ' where ' . $crudFK . ' = ' . $crudColumnValues['id'];
//echo $crudColumnValues['id'];die;
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);
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:31，代码来源:handler_pendaftaran_bu.php
示例11: elseif
';
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;
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:31，代码来源:setForm.php
示例12: gcms_query
echo $row->jumlah_kursi;
?>
');
// 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 = "";
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:31，代码来源:SetData.php
示例13: quote_smart
b.dasar_pengenaan as pengenaan,
b.persen_tarif as persen,
b.nominal as pajak
from pendataan_spt a
join pendataan_galianc b on a.pendataan_id=b.pendataan_id
join rekening_kode c on c.id=b.id_rekening
where a.pendataan_id=' . quote_smart($_REQUEST['id']) . ' order by b.galianc_id ';
$o->page = 1;
$o->total = 1;
$o->records = 1;
$i = 0;
$jumlah = 0;
$pajak = 0;
$result = gcms_query($sql);
while ($row = gcms_fetch_row($result)) {
$o->rows[$i]['id'] = $row[0];
$o->rows[$i]['cell'] = $row;
$i++;
$jumlah += $row['2'];
$pajak += $row['6'];
}
$o->userdata['rekening'] = 'Total';
$o->userdata['jumlah'] = $jumlah;
$o->userdata['pajak'] = $pajak;
print json_encode($o);
break;
case 'update':
echo 'update';
break;
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:31，代码来源:pendataan_golc.request.php
示例14: gcms_query
?>
';
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
}
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:31，代码来源:SetData.php
示例15: getViaPembayaran
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;
}
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:10，代码来源:simpatda_core.lib.php
示例16: gcms_query
<?php
include 'config.php';
$sql = "SELECT * FROM INFO_PEMDA";
$res = gcms_query($sql);
$rs = gcms_fetch_object($res);
$datapicture = gcms_blob_echo($rs->logo);
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:7，代码来源:showimage.php
示例17: setNomor
alert(response);
jQuery("#htmlTable3").trigger("reloadGrid");
formObject.reset();
}else{
alert('error '+response);
}
}
})
//
//var transaction = YAHOO.util.Connect.asyncRequest('POST',"request.php",callback,null);
}
});
function setNomor(){
<?php
$cr = gcms_query("select max(teguran_pr_no) AS IdMax from teguran_pr");
$max = gcms_fetch_object($cr);
$new_max = $max->IDMAX + 1;
$new_no = sprintf("%06d", $new_max);
?>
document.getElementById('NoRegForm').value = <?php
echo $new_no;
?>
;
}
$('#cari_npwp').click(function(){
//$("#htmlTable2").setGridParam({url:'request.php?mod=pendataan&func=list&sender=daftarnpwp', datatype:'json'}).setCaption("Daftar NPWPD/RW ").trigger("reloadGrid");
$('#Npwp').dialog('open');
//alert('xxxx');
});
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:31，代码来源:FormTeguran.php
示例18: substr
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');
}
//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');
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:31，代码来源:handler_daftar_kohir.php
示例19: quote_smart
ps.periode_akhir,ph.dasar_pengenaan,
rk.kode_rekening,s.spt_id,pm.id_desa,k.lurah_kecamatan,
p.no_pendaftaran,p.jenis_pendaftaran,
s.spt_no
from pendataan_phiburan ph
left join pendataan_spt ps on ph.pendataan_id = ps.pendataan_id
left join pendataan_phiburan_detail pd on ps.pendataan_id = pd.pendataan_id
left join pendaftaran p on ps.pendaftaran_id = p.pendaftaran_id
left join rekening_kode rk on ph.id_rekening = rk.id
left join spt s on p.pendaftaran_id = s.pendaftaran_id
left join pemohon pm on p.id_pemohon = pm.pemohon_id
left join kelurahan k on pm.id_desa = k.lurah_id
left join kecamatan kc on k.lurah_kecamatan = kc.camat_id
where ph.pendataan_id=' . quote_smart($_REQUEST['val']);
$data = gcms_query($sql);
$x = 1;
$rs = gcms_fetch_object($data);
$pendataan_no = sprintf('%06d', $rs->pendataan_no);
//$spt_no = ($rs->spt_no!='') ? sprintf('%05d',$rs->spt_no) : '';
if ($row->tanggal_kembali == "" || $rs->tanggal_kembali == NULL) {
$Tgl = "";
} else {
$Tgl = date("Y", strtotime($rs->periode_akhir));
}
$replace = explode(".", $rs->kode_rekening);
$KodeRek1 = $replace[0] . $replace[1] . $replace[2];
$KodeRek2 = $replace[3];
$KodeRek3 = $replace[4];
if ($rs->jenis_pendaftaran == "PAJAK") {
$kode = "PAJAK";
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:31，代码来源:pendataan_hiburan.request.php
示例20: quote_smart
elseif($data[0] == $tabel."_IBUKOTA") $value = $_REQUEST['ibukotaKab'];
elseif($data[0] == $tabel."_TELP") $value = $_REQUEST['telp'] ;
elseif($data[0] == $tabel."_PEJABAT") $value = $_REQUEST['pejabat'];
elseif($data[0] == $tabel."_BANK") $value = $_REQUEST['namaBank'];
elseif($data[0] == $tabel."_BANK_NOREK") $value = $_REQUEST[''];
else $value = $_REQUEST[$data[0]];
if ( $value != ''){
$record = $value ;
}else{
$record = $data[4] ;
}
$insert .= quote_smart($record).",";
}
$insert .= ")";
$insert = str_replace(",)",")",$insert);*/
gcms_query($insert);
//echo $new_id."---".$insert."--".$max;
echo "Data berhasil disimpan";
}
if ($_REQUEST['sender'] == "entri_kecamatan") {
$tabel = "kecamatan";
echo $_REQUEST['sender'] . "xxx" . $_REQUEST['KodeKecamatan'];
}
if ($_REQUEST['sender'] == "entri_kelurahan") {
echo $_REQUEST['sender'] . "xxx" . $_REQUEST['kecamatan'];
}
if ($_REQUEST['sender'] == "entri_anggaran") {
echo $_REQUEST['sender'] . "xxx";
}
if ($_REQUEST['sender'] == "entri_keterangan_spt") {
echo $_REQUEST['sender'] . "xxx";
开发者ID:ibnoe，项目名称:simpatda-thinkfrogs，代码行数:31，代码来源:master.asyc.php
注：本文中的gcms_query函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论