<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } // form Module $fmod = 'user'; $dbtable = 'admin'; $fform = new fform($fmod, $opt, $cid); $inp = app_form_gpost('uname', 'level', 'app', 'departemen'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $inp['passwd'] = md5('admin'); $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit /update $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } } } $fform->notif($q);
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } appmod_use('aka/tahunajaran'); // form Module $fmod = 'semester'; $dbtable = 'aka_semester'; $fform = new fform($fmod, $opt, $cid); $inp = app_form_gpost('tahunajaran', 'nama', 'keterangan'); $tajar = $inp['tahunajaran']; if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $q = mysql_query("UPDATE aka_semester SET aktif='0' WHERE tahunajaran='{$tajar}'"); $inp['urut'] = urut_getlast($dbtable) + 1; $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); $q &= dbDel("aka_kelas", "tingkat='{$cid}'");
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } // form Module $fmod = "daftarbuku"; $dbtable = "pus_buku"; $fform = new fform($fmod, $opt, $cid, 'Buku'); $inp = app_form_gpost('katalog', 'idbuku', 'barkode', 'callnumber', 'sumber', 'harga', 'satuan', 'tanggal'); $nunit = intval(gpost('nbuku')); $inp['lokasi'] = gpost('tlokasi'); $inp['tingkatbuku'] = gpost('ttingkatbuku'); $inp['tahun'] = date("Y"); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') {
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } appmod_use('aka/jenismutasi'); // form Module $fmod = 'mutasi'; $dbtable = 'aka_mutasi'; $fform = new fform($fmod, $opt, $cid); $inp = app_form_gpost('jenismutasi', 'siswa', 'tanggal', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); $q = dbQSql("UPDATE aka_siswa SET aktif='3' WHERE replid='" . $inp['siswa'] . "'"); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "siswa='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "siswa='{$cid}'"); $q = dbQSql("UPDATE aka_siswa SET aktif='1' WHERE replid='{$cid}'"); } }
<?php require_once(MODDIR.'fform/fform.php'); $opt=gpost('opt');$cid=gpost('cid');if($cid=='')$cid=0; // form Module $fmod='stocktake_note'; $dbtable=stocktake_ctable(); $fform=new fform($fmod,$opt,$cid); $inp=app_form_gpost('note'); if($opt=='a'||$opt=='u'||$opt=='d'){ $q=false; $q=dbUpdate($dbtable,$inp,"replid='$cid'"); //$fform->notif($q); if($q) echo nl2br($inp['note']); else echo "-0-"; } else { $r=dbSFA("*",$dbtable,"W/replid='$cid'"); $t1=mysql_query("SELECT pus_katalog.judul FROM pus_buku LEFT JOIN pus_katalog ON pus_katalog.replid=pus_buku.katalog WHERE pus_buku.replid='".$r['buku']."' LIMIT 0,1"); $r1=mysql_fetch_array($t1); $fform->head(); if($opt=='af' || $opt=='uf'){ require_once(MODDIR.'control.php'); // Add or Edit form $fform->fc('Tambahkan catatan untuk item:'); $fform->fl('Barkode',$r['barkode']); $fform->fl('Judul',buku_judul($r1['judul'])); $fform->fa('Keterangan',iTextarea('note',$r['note'],$fform->rwidths,3)); } $fform->foot(); } ?>
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } require_once APPMOD . 'aka/angkatan.php'; // form Module $fmod = "periode"; $dbtable = "psb_proses"; $fform = new fform($fmod, $opt, $cid, 'periode penerimaan siswa'); $inp = app_form_gpost('departemen', 'proses', 'kodeawalan', 'angkatan', 'tglmulai', 'tglselesai', 'kapasitas', 'aktif', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); $q &= dbDel("psb_kelompok", "proses='{$cid}'"); $q &= dbDel("psb_calonsiswa", "proses='{$cid}'"); } }
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } // form Module $fmod = 'angkatan'; $dbtable = 'aka_angkatan'; $fform = new fform($fmod, $opt, $cid); $inp = app_form_gpost('departemen', 'angkatan', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); $q &= dbDel("aka_siswa", "angkatan='{$cid}'"); } } } $fform->notif($q);
// edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') { // Prepocessing form $r = dbSFA("*", $dbtable, "W/replid='{$cid}'"); } else { $r = app_form_gpost('departemen', 'tahunajaran', 'nama', 'keterangan'); } $fform->head(); if ($opt == 'af' || $opt == 'uf') { require_once MODDIR . 'control.php'; // Add or Edit form $fform->fl('Departemen', departemen_name($r['departemen'])); $fform->fl('Tahun ajaran', tahunajaran_name($r['tahunajaran'])); $fform->fi('Nama Kelompok', iText('nama', $r['nama'], $fform->rwidths)); $fform->fa('Keterangan', iTextarea('keterangan', $r['keterangan'], $fform->rwidths, 3)); } else { if ($opt == 'df') { // Delete form if (0 > 0) { $fform->reg['dlg_del'] = 'Tingkat masih digunakan. Apakah anda yakin untuk menghapus <idata> <data>?'; $fform->dlg_delw($r[$fmod], 'Data-data kelas dan siswa yang termasuk dalam tingkat ini juga akan dihapus. Data yang sudah dihapus tidak dapat dikembalikan.');
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid', 0); // form Module $fmod = 'grup'; $dbtable = 'admin'; $fform = new fform($fmod, $opt, $cid, 'Anggota Grup'); $inp = app_form_gpost('uname', 'nama'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $inp['app'] = APID; $inp['level'] = '2'; $inp['passwd'] = md5(gpost('passwd')); $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit if ($inp['passwd'] != '') { $inp['passwd'] = md5($inp['passwd']); } $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } }
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } appmod_use('aka/tahunajaran', 'aka/pelajaran', 'aka/kelas'); // form Module $fmod = 'sks'; $dbtable = 'aka_sks'; $fform = new fform($fmod, $opt, $cid, 'Kontrak Pelajaran'); $inp = app_form_gpost('tahunajaran', 'pelajaran', 'guru'); $inp['kelas'] = gpost('sks_kelas'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $njam = intval(gpost('njam', 1)); if (gpost('salin') == '1') { $t = dbSel("*", "aka_kelas", "W/tahunajaran='" . $inp['tahunajaran'] . "'"); while ($r = dbFA($t)) { $inp['kelas'] = $r['replid']; for ($i = 0; $i < $njam; $i++) { $q = dbInsert($dbtable, $inp); } } } else { for ($i = 0; $i < $njam; $i++) { $q = dbInsert($dbtable, $inp);
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid', 0); // form Module $fmod = 'posisi'; $dbtable = 'hrd_m_posisi'; $fform = new fform($fmod, $opt, $cid, 'posisi pegawai'); $inp = app_form_gpost('posisi', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $inp['urut'] = urut_getlast($dbtable) + 1; $q = dbInsert($dbtable, $inp); $cid = mysql_insert_id(); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') {
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid', 0); // form Module $fmod = 'kelompok'; $dbtable = 'hrd_m_kelompok'; $fform = new fform($fmod, $opt, $cid, 'kelompok pegawai'); $inp = app_form_gpost('kelompok', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $inp['urut'] = urut_getlast($dbtable) + 1; $q = dbInsert($dbtable, $inp); $cid = mysql_insert_id(); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') {
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } require_once APPMOD . 'psb/proses.php'; // form Module $fmod = "kelompok"; $dbtable = "psb_kelompok"; $fform = new fform($fmod, $opt, $cid, 'kelompok pendaftaran'); $inp = app_form_gpost('proses', 'kelompok', 'tglmulai', 'tglselesai', 'biaya', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit unset($inp['departemen']); $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); $q &= dbDel("psb_kelompok", "proses='{$cid}'"); $q &= dbDel("psb_calonsiswa", "proses='{$cid}'"); }
<?php require_once(MODDIR.'fform/fform.php'); $opt=gpost('opt');$cid=gpost('cid');if($cid=='')$cid=0; // form Module $fmod='katalog_pengarang'; $dbtable='pus_pengarang'; $fform=new fform($fmod,$opt,$cid,'pengarang'); $inp=app_form_gpost('nama','nama2','keterangan'); if($opt=='a'||$opt=='u'||$opt=='d'){ $q=false; if($opt=='a'){ // add $q=dbInsert($dbtable,$inp); if($q){ echo mysql_insert_id().';'.$inp['nama']; } } else if($opt=='u') { // edit $q=dbUpdate($dbtable,$inp,"replid='$cid'"); } else if($opt=='d'){ // delete $q=dbDel($dbtable,"replid='$cid'"); } $fform->notif($q); } else { if($opt=='uf'||$opt=='df'){ // Prepocessing form $r=dbSFA("*",$dbtable,"W/replid='$cid'"); } else { } $fform->head(); if($opt=='af' || $opt=='uf'){ require_once(MODDIR.'control.php'); // Add or Edit form
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid', 0); // form Module $fmod = 'tingkat'; $dbtable = 'hrd_m_tingkat'; $fform = new fform($fmod, $opt, $cid, 'tingkat pegawai'); $inp = app_form_gpost('tingkat', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $inp['urut'] = urut_getlast($dbtable) + 1; $q = dbInsert($dbtable, $inp); $cid = mysql_insert_id(); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') {
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } // form Module $fmod = "golongan"; $dbtable = "psb_" . $fmod; $fform = new fform($fmod, $opt, $cid, 'golongan calon siswa'); $inp = app_form_gpost('golongan', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); $q &= dbDel("psb_setbiaya", "krit='{$cid}'"); $q &= dbUpdate("psb_calonsiswa", array('golongan' => 0), "golongan='{$cid}'"); } } }
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } appmod_use('keu/inventory'); // form Module $fmod = "inventory_brg"; $dbtable = "keu_brg"; $fform = new fform($fmod, $opt, $cid, 'barang'); $inp = app_form_gpost('kelompokbrg', 'kode', 'nama', 'tanggal', 'unit', 'satuan', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } } } $fform->notif($q);
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } // form Module $fmod = 'discount'; $dbtable = 'psb_disctunai'; $fform = new fform($fmod, $opt, $cid, 'Diskon tunai'); // $inp = app_form_gpost('nilai','keterangan'); $inp = app_form_gpost('nilai', 'nilai2', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } } } $fform->notif($q);
} else { echo "2"; } } else { echo "1"; } //echo "UPDATE admin SET passwd='$new' WHERE replid='$cid'"; exit; } // form Module $fmod = "setting"; $dbtable = "Pengaturan"; $admin = admin_get(); $fform = new fform($fmod, $opt, $admin['id'], 'Pengaturan akun'); $fform->reg['title_uf'] = '<idata>'; $inp = app_form_gpost('cicilan', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } }
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } // form Module $fmod = 'peminjaman'; $dbtable = 'sar_peminjaman'; $fform = new fform($fmod, $opt, $cid, 'Peminjaman Barang'); $inp = app_form_gpost('lokasi', 'peminjam', 'tempat', 'tanggal1', 'tanggal2', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; $ec = 0; if ($opt == 'a') { // add $t = mysql_query("SELECT * FROM sar_dftp"); while ($r = mysql_fetch_array($t)) { $inp['barang'] = $r['barang']; $q = dbInsert($dbtable, $inp); if ($q) { dbUpdate("sar_barang", array('status' => 0), "replid='" . $r['barang'] . "'"); dbDel("sar_dftp", "replid='" . $r['replid'] . "'"); } } } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'");
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } // form Module $fmod = "kriteria"; $dbtable = "psb_" . $fmod; $fform = new fform($fmod, $opt, $cid, 'kriteria calon siswa'); $inp = app_form_gpost('kriteria', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); $q &= dbDel("psb_setbiaya", "krit='{$cid}'"); $q &= dbUpdate("psb_calonsiswa", array('kriteria' => 0), "kriteria='{$cid}'"); } } }
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid', 0); // form Module $fmod = 'status'; $dbtable = 'hrd_m_status'; $fform = new fform($fmod, $opt, $cid, 'status pegawai'); $inp = app_form_gpost('status', 'reminder', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $inp['urut'] = urut_getlast($dbtable) + 1; $q = dbInsert($dbtable, $inp); $cid = mysql_insert_id(); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') {
<?php require_once(MODDIR.'fform/fform.php'); $opt=gpost('opt');$cid=gpost('cid');if($cid=='')$cid=0; // form Module $fmod='katalog'; $dbtable='pus_katalog'; $fform=new fform($fmod,$opt,$cid,'Katalog Buku'); $inp=app_form_gpost('klasifikasi-kode','klasifikasi','pengarang','callnumber','penerjemah','editor','penerbit','tahunterbit','kota','isbn','issn','bahasa','seri','volume','edisi','jenisbuku','photo','deskripsi','halaman','dimensi'); $inp['judul']=gpost('judul1').'`'.gpost('judul2'); if($opt=='a'||$opt=='u'||$opt=='d'){ $q=false; $ec=0; if($opt=='a'){ // add $q=dbInsert($dbtable,$inp); $cid=mysql_insert_id(); } else if($opt=='u') { // edit $q=dbUpdate($dbtable,$inp,"replid='$cid'"); } else if($opt=='d'){ // delete $q=dbDel($dbtable,"replid='$cid'"); $q=dbDel("pus_buku","katalog='$cid'"); } echo $cid; $fform->notif($q); } else { if($opt=='uf'||$opt=='df'){ // Prepocessing form $r=dbSFA("*",$dbtable,"W/replid='$cid'"); } else { $r=array(); } $fform->head();
<?php // Default Post Variables $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } // form Module $fmod = gpost('fmod'); $dbtable = "hrd_m_" . $fmod; $idata = "Status Pernikahan Pegawai"; // Post Variables $inp = app_form_gpost($fmod, 'keterangan'); // Form Title $mdialog = app_form_title(); if ($opt == 'a' || $opt == 'u' || $opt == 'd' || $opt == 'm') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } }
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } // form Module $fmod = "pembayaran_data"; $dbtable = "keu_pembayaran"; $fform = new fform($fmod, $opt, $cid, 'Data pembayaran'); $inp = app_form_gpost('nominal', 'cicilan', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit $inp['tanggal'] = date("Y-m-d"); $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } } } $fform->notif($q);
<?php require_once MODDIR . 'fform/fform.php'; $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } $ssid = session_id(); // form Module $fmod = 'sirkulasi_peminjaman'; $dbtable = 'pus_peminjaman'; $fform = new fform($fmod, $opt, $cid, 'Data Peminjaman'); $fform->globalkey = '0'; $inp = app_form_gpost('tanggal1', 'tanggal2', 'keterangan'); $inp['member'] = gpost('member_id'); $inp['mtipe'] = gpost('member_tipe'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; $ec = 0; if ($opt == 'a') { // add $t = mysql_query("SELECT * FROM pus_tpjm WHERE ssid='{$ssid}'"); while ($r = mysql_fetch_array($t)) { $inp['buku'] = $r['buku']; $q = dbInsert($dbtable, $inp); if ($q) { dbUpdate("pus_buku", array('status' => 0), "replid='" . $r['buku'] . "'"); dbDel("pus_tpjm", "replid='" . $r['replid'] . "'"); } }
<?php require_once(MODDIR.'fform/fform.php'); $opt=gpost('opt');$cid=gpost('cid');if($cid=='')$cid=0; // form Module $fmod='jenisbuku'; $dbtable='pus_jenisbuku'; $fform=new fform($fmod,$opt,$cid,'Jenis Buku'); $inp=app_form_gpost('kode','nama','keterangan'); if($opt=='a'||$opt=='u'||$opt=='d'){ $q=false; if($opt=='a'){ // add $q=dbInsert($dbtable,$inp); } else if($opt=='u') { // edit $q=dbUpdate($dbtable,$inp,"replid='$cid'"); } else if($opt=='d'){ // delete $q=dbDel($dbtable,"replid='$cid'"); } $fform->notif($q); } else { if($opt=='uf'||$opt=='df'){ // Prepocessing form $r=dbSFA("*",$dbtable,"W/replid='$cid'"); } else { } $fform->head(); if($opt=='af' || $opt=='uf'){ require_once(MODDIR.'control.php'); // Add or Edit form $fform->fi('Kode',iText('kode',$r['kode'],"width:60px")); $fform->fi('Jenis buku',iText('nama',$r['nama'],$fform->rwidths));
<?php require_once(MODDIR.'fform/fform.php'); $opt=gpost('opt');$cid=gpost('cid');if($cid=='')$cid=0; // form Module $fmod='tools_idbuku'; $dbtable='pus_setting'; $fform=new fform($fmod,$opt,$cid,'!Format Nomor ID Item'); $inp=app_form_gpost('nilai'); if($opt=='a'||$opt=='u'||$opt=='d'){ $q=false; if($opt=='a'){ // add $q=dbInsert($dbtable,$inp); } else if($opt=='u') { // edit $q=dbUpdate($dbtable,$inp,"replid='$cid'"); if($q && gpost('updatebuku')=='1'){ $t1=mysql_query("SELECT * FROM pus_buku"); while($r1=mysql_fetch_array($t1)){ $data=array('kodelokasi'=>$r1['lokasi'],'kodetingkat'=>$r1['tingkatbuku'],'sumber'=>$r1['sumber'],'nomorauto'=>$r1['urut']); $idbuku=buku_makeid($data); $q=dbUpdate("pus_buku",array('idbuku'=>$idbuku),"replid='".$r1['replid']."'"); } } } else if($opt=='d'){ // delete $q=dbDel($dbtable,"replid='$cid'"); } $fform->notif($q); } else { if($opt=='uf'||$opt=='df'){ // Prepocessing form $r=dbSFA("*",$dbtable,"W/replid='$cid'");
// form process if ($opt == 'uf' || $opt == 'df') { // db operation for form : update , delete $r = dbSFA("*", $dbtable, "W/replid='{$cid}'"); $r['departemen'] = gpost('departemen'); $s = 'SELECT * FROM hrd_karyawan WHERE id=' . $r['pegawai'] . ' LIMIT 0,1'; // var_dump($s);exit(); $q = mysql_query($s); // $q=mysql_query("SELECT * FROM hrd_pegawai WHERE replid='".$r['pegawai']."' LIMIT 0,1"); if (mysql_num_rows($q) > 0) { $h = mysql_fetch_array($q); $r['nama'] = $h['nama']; } } else { // db operation for form : add $r = app_form_gpost('departemen', 'tahunajaran', 'pegawai', 'pelajaran', 'aktif', 'keterangan'); $r['pelajaran'] = gpost('spelajaran'); $r['aktif'] = '1'; } $fform->dimension(450); $fform->head(); if ($opt == 'af' || $opt == 'uf') { //$fform->fl('Departemen',departemen_name($r['departemen'])); //$fform->fl('Tahun ajaran',tahunajaran_name($r['tahunajaran'])); //$fform->fi('Status',iSelect('aktif',array('1'=>'Aktif','0'=>'Tidak aktif'),$r['aktif'])); //$fform->fa('Kode',iText('kode',$r['kode'],'width:40px')); require_once MODDIR . 'control.php'; // Add or Edit form $fform->fi('Mata Pelajaran', iSelect('pelajaran', pelajaran_opt(gpost('tahunajaran')), $r['pelajaran'])); $fform->fi('Pegawai', app_form_getpegawai('pegawai', $r)); $fform->fa('Keterangan', iTextarea('keterangan', $r['keterangan'], $fform->rwidths, 3));
<?php // Default Post Variables $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } // form Module $fmod = gpost('fmod'); $dbtable = "hrd_m_" . $fmod; $idata = ucfirst($fmod) . " Pegawai"; // Post Variables $inp = app_form_gpost($fmod, 'keterangan'); // Form Title $mdialog = app_form_gpost($fmod, 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd' || $opt == 'm') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } }