while ($r = mysql_fetch_array($t)) { $t1 = mysql_query("SELECT replid FROM aka_siswa WHERE angkatan='" . $r['replid'] . "'"); while ($r1 = mysql_fetch_array($t1)) { $q = dbDel("aka_siswa_ayah", "siswa='" . $r1['replid'] . "'"); $q = dbDel("aka_siswa_grup", "siswa='" . $r1['replid'] . "'"); $q = dbDel("aka_siswa_guru", "siswa='" . $r1['replid'] . "'"); $q = dbDel("aka_siswa_ibu", "siswa='" . $r1['replid'] . "'"); $q = dbDel("aka_siswa_kelas", "siswa='" . $r1['replid'] . "'"); $q = dbDel("aka_siswa_keluarga", "siswa='" . $r1['replid'] . "'"); $q = dbDel("aka_siswa_kontakdarurat", "siswa='" . $r1['replid'] . "'"); $q = dbDel("aka_siswa_saudara", "siswa='" . $r1['replid'] . "'"); $q = dbDel("aka_siswa_tesakademis", "siswa='" . $r1['replid'] . "'"); } $q = dbDel("aka_siswa", "angkatan='" . $r['replid'] . "'"); } $q = dbDel("aka_angkatan", "departemen='{$cid}'"); } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') { // Prepocessing form $r = dbSFA("*", $dbtable, "W/replid='{$cid}'"); } else { } $fform->dimension(400, 120); $fform->head(); if ($opt == 'af' || $opt == 'uf') { require_once MODDIR . 'control.php'; // Add or Edit form
$fmod = "m_level"; // db Table $dbtable = "mstr_level"; // Post Variables if ($opt == 'a' || $opt == 'u' || $opt == 'd' || $opt == 'up' || $opt == 'dn') { if ($opt == 'a') { $urut = MstrLastUrut($dbtable) + 1; dbInsert($dbtable, array('name' => $name, 'urut' => $urut)); $cid = mysql_insert_id(); } else { if ($opt == 'u') { dbUpdate($dbtable, array('name' => $name), "dcid='{$cid}'"); } else { if ($opt == 'd') { dbUpdate("employee", array('level' => 0), "status='{$cid}'"); dbDel($dbtable, "dcid='{$cid}'"); } else { if ($opt == 'up') { $a = MstrGetNextUrut($dbtable, $cid); if ($a[0] != -1) { dbUpdate($dbtable, array('urut' => $a[1]), "dcid='{$cid}'"); dbUpdate($dbtable, array('urut' => $a[2]), "dcid='" . $a[0] . "'"); } } else { if ($opt == 'dn') { $a = MstrGetNextUrut($dbtable, $cid, "DESC"); if ($a[0] != -1) { dbUpdate($dbtable, array('urut' => $a[1]), "dcid='{$cid}'"); dbUpdate($dbtable, array('urut' => $a[2]), "dcid='" . $a[0] . "'"); } }
function app_form_gpost() { $s = array(); $a = func_get_args(); $n = count($a); for ($i = 0; $i < $n; $i++) { if ($a[$i] == 'photo') { // upload foto $id = gpost('photo'); if ($id != '') { if (intval($id) != 0) { $p = dbFetch("photo", "tmp_photo", "W/replid='{$id}'") . "'"; dbDel("tmp_photo", "replid='{$id}'"); $s['photo'] = $p; } else { $s['photo'] = ''; } } } else { //selain foto $s[$a[$i]] = gpost($a[$i]); } } return $s; }
<?php $opt = gpost('opt'); if ($opt == 'lookup') { require_once VWDIR . 'vi_loan.php'; } if ($opt == 'lookup') { require_once VWDIR . 'vi_loan.php'; } else { if ($opt == 'aq') { $cid = gpost('cid'); dbInsert("p_loan", array('book' => $cid)); require_once VWDIR . 'vi_loan_list.php'; } else { if ($opt == 'rq') { $cid = gpost('cid'); dbDel("p_loan", "dcid='{$cid}'"); require_once VWDIR . 'vi_loan_list.php'; } else { if ($opt == 'uq') { require_once VWDIR . 'vi_loan_list.php'; } else { if ($opt == 'cq') { $sql = "TRUNCATE TABLE `p_loan`"; mysql_query($sql); require_once VWDIR . 'vi_loan_list.php'; } } } } }
// 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)); $fform->fa('Keterangan',iTextarea('keterangan',$r['keterangan'],$fform->rwidths,3));
$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); } else { if ($opt == 'uf' || $opt == 'df') { // Prepocessing form $r = dbSFA("*", $dbtable, "W/replid='{$cid}'"); } else { $r['departemen'] = $inp['departemen']; } $fform->head(); if ($opt == 'af' || $opt == 'uf') { require_once MODDIR . 'control.php'; // Add or Edit form
$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}'"); } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') { // Prepocessing form $db = new xdb("aka_mutasi"); $db->field("aka_mutasi:replid,jenismutasi,siswa,tanggal,keterangan", "aka_siswa:nis as snis,nama as ssiswa"); $db->join("siswa", "aka_siswa"); $db->where("aka_mutasi.siswa='{$cid}'"); $r = $db->gofetch(); } else { $r = array();
<?php appmod_use('aka/angkatan'); $opt = gpost('opt'); $cid = gpost('cid'); if ($cid == '') { $cid = 0; } dbDel("aka_tmp_saudara", "sesid='" . session_id() . "'"); $fmod = 'siswa_pendataan_angkatan'; $dept = gpost('departemen'); $departemen = departemen_r($dept); if (count($departemen) > 0) { $angk = gpost('angkatan'); $angkatan = angkatan_r($angk, $dept); // Page Selection Bar $PSBar = new PSBar_2(); $PSBar->begin(); $PSBar->selection_departemen($fmod, $dept); if (count($angkatan) > 0) { $PSBar->selection('Angkatan', iSelect('angkatan', $angkatan, $angk, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('angkatan', $angk); angkatan_warn(0, 'float:left'); $PSBar->pass = false; } $PSBar->end(); if ($PSBar->pass) { if ($opt == 'af' || $opt == 'uf') { require_once VWDIR . 'siswa_form.php';
} else { if ($opt == 'u') { $r = dbSFA("*", "mstr_user", "W/dcid='{$cid}'"); if ($password0 != '') { $password = md5($password0); if ($r['password'] = $password && $password1 == $password2) { $password = md5($password1); dbUpdate("mstr_user", array('alias' => $alias, 'password' => $password), "dcid='{$cid}'"); } } else { dbUpdate("mstr_user", array('alias' => $alias), "dcid='{$cid}'"); } require_once APPDIR . 'm_user_table.php'; } else { if ($opt == 'd') { dbDel("mstr_user", "dcid='{$cid}'"); require_once APPDIR . 'm_user_table.php'; } else { if ($opt == 'af') { // Add Form ?> <table cellspacing="0" cellpadding="0" width="100%"><tr><td align="center" style="padding-top:120px"> <div class="fformbox" style="width:400px"> <div class="sfont" style="color:#ffffff;border-radius:5px 5px 0 0;background:#6a92e5;padding:6px 0 6px 0;"> <b>Add New <?php echo $mtitle; ?> </b> </div> <div style="text-align:left;padding:10px"> <table class="stable" cellspacing="0" cellpadding="4px" width="380px">
} } } else { for ($i = 0; $i < $njam; $i++) { $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", "kelas='{$cid}'"); } } } //$fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') { // Prepocessing form $r = dbSFA("*", $dbtable, "W/replid='{$cid}'"); } else { $r = farray('kelas', 'tingkat', 'kapasitas', 'wali', 'keterangan'); $r['tahunajaran'] = gpost('tahunajaran'); $r['tingkat'] = gpost('tingkat'); $r['kapasitas'] = 1; } $fform->dimension(450, 100);
function transaksi_update($tid,$tgl,$urai,$nom,$jur){ $n=count($jur); if($n>0){ $trans=array(); $trans['tanggal']=$tgl; $trans['uraian']=$urai; $trans['nominal']=0; for($i=0;$i<$n;$i++){ $jurnal=$jur[$i]; $trans['nominal']+=$jurnal['debet']; } if(dbUpdate("keu_transaksi",$trans,"replid='$tid'")){ dbDel("keu_jurnal","transaksi='$tid'"); for($i=0;$i<$n;$i++){ $jurnal=$jur[$i]; $jurnal['transaksi']=$tid; $q=dbInsert("keu_jurnal",$jurnal); } } } transaksi_cekpembayaran($tid); return $tid; }
$n = count($did); for ($i = 0; $i < $n; $i++) { $tgl = $did[$i]; $tanggal = $tgl_cm . $tgl; $absen = gpost('absen_' . $tgl); $keterangan = gpost('keterangan_' . $tgl); dbDel("aka_absen_guru", "guru='{$cid}' AND tanggal='{$tanggal}'"); $q = dbQSql("INSERT INTO aka_absen_guru SET absen='{$absen}',keterangan='{$keterangan}',guru='{$cid}',tanggal='{$tanggal}'"); //log_print("INSERT INTO aka_siswa_kelas SET kelas='$kls',siswa='$cid'"); } } } else { if ($opt == 'd') { // delete $kls = gpost('kelas'); $q = dbDel($dbtable, "guru='{$cid}' AND kelas='{$kls}'"); } else { if ($opt == 'af' || $opt == 'uf') { $fform = new fform($fmod, $opt, $cid, 'Data presensi guru'); $fform->reg['btnlabel_a_n'] = 'Batal'; $fform->dimension(600); $fform->ptop = 5; $fform->globalkey = '0'; $fform->reg['title_af'] = 'Edit <idata>'; $fform->head(); //$fform->fl('Departemen',departemen_name(gpost('departemen'))); //$fform->fl('Tingkat',tingkat_name(gpost('tingkat'))); //$fform->fl('Tahun ajaran',tahunajaran_name(gpost('tahunajaran'))); $fform->rheight = ''; if ($opt == 'af') { //$fform->fl('Kelas',kelas_name(gpost('kelas')));
// Job History dbDel("emp_jobhis", "empid='{$dcid}'"); for ($i = 0; $i < 10; $i++) { if (gpost('jobhis_name' . $i) != '') { $name = gpost('jobhis_name' . $i); $address = gpost('jobhis_address' . $i); $date1 = gpost('jobhis_date1' . $i); $date2 = gpost('jobhis_date2' . $i); $position = gpost('jobhis_position' . $i); $salary = gpost('jobhis_salary' . $i); $reason = gpost('jobhis_reason' . $i); dbInsert("emp_jobhis", array('empid' => $dcid, 'name' => $name, 'address' => $address, 'date1' => $date1, 'date2' => $date2, 'position' => $position, 'salary' => $salary, 'reason' => $reason)); } } // References dbDel("emp_reference", "empid='{$dcid}'"); for ($i = 0; $i < 10; $i++) { if (gpost('reference_name' . $i) != '') { $name = gpost('reference_name' . $i); $address = gpost('reference_address' . $i); $phone = gpost('reference_phone' . $i); $job = gpost('reference_job' . $i); $know = gpost('reference_know' . $i); $relation = gpost('reference_relation' . $i); dbInsert("emp_reference", array('empid' => $dcid, 'name' => $name, 'address' => $address, 'phone' => $phone, 'job' => $job, 'know' => $know, 'relation' => $relation)); } } // Additional info $inp = array(); for ($i = 1; $i <= 5; $i++) { $inp['info' . $i] = gpost('ainfo' . $i);
} } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); if ($q) { dbUpdate("psb_calonsiswa", array('idsiswa' => 0, 'kelas' => 0), "idsiswa='{$cid}'"); dbDel($dbtable . '_ayah', "siswa='{$cid}'"); dbDel($dbtable . '_ibu', "siswa='{$cid}'"); dbDel($dbtable . '_keluarga', "siswa='{$cid}'"); dbDel($dbtable . '_kontakdarurat', "siswa='{$cid}'"); dbDel($dbtable . '_saudara', "siswa='{$cid}'"); } } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') { // Prepocessing form $r = dbSFA("*", $dbtable, "W/replid='{$cid}'"); } else { $r = farray('nis', 'nisn'); $r['departemen'] = gpost('departemen'); $r['tahunajaran'] = gpost('tahunajaran'); $r['kelas'] = gpost('kelas'); }
$data = gpost('data'); if ($data != "") { $q = true; $did = explode(",", $data); $n = count($did); for ($i = 0; $i < $n; $i++) { $cid = $did[$i]; $q &= dbQSql("INSERT INTO aka_siswa_kelas SET kelas='{$kls}',siswa='{$cid}'"); //log_print("INSERT INTO aka_siswa_kelas SET kelas='$kls',siswa='$cid'"); } } } else { if ($opt == 'd') { // delete $kls = gpost('kelas'); $q = dbDel($dbtable, "siswa='{$cid}' AND kelas='{$kls}'"); } else { if ($opt == 'af') { $fform = new fform($fmod, 'af', $cid, 'Cari item'); $fform->reg['title_af'] = '<idata>'; $fform->reg['btnlabel_a_y'] = 'Pilih yg ditandai'; $fform->reg['btnlabel_a_n'] = 'Batal'; $fform->dimension(500); $fform->ptop = 20; $fform->globalkey = '0'; $fform->head('Pilih Siswa'); echo '<tr><td><div id="box_siswa_pendataan_kelas_list">'; require_once APPDIR . 'siswa_pendataan_kelas_list_get.php'; echo '</div></td></tr>'; $fform->foot(); } else {
$r1=mysql_fetch_array($t1); $telat=diffDay($r1['tanggal2']); $telat=$telat<0?-$telat:0; $q=dbUpdate($dbtable,array('status'=>0,'tanggal3'=>$tanggal3,'telat'=>$telat),"replid='".$r['peminjaman']."'"); if($q){ dbUpdate("pus_buku",array('status'=>1),"replid='".$r1['buku']."'"); dbDel("pus_tpjm","replid='".$r['replid']."'"); } } } else if($opt=='u') { // edit $q=dbUpdate($dbtable,$inp,"replid='$cid'"); } else if($opt=='d'){ // delete $q=dbDel($dbtable,"replid='$cid'"); $q=dbDel("sar_pengembalian_barang","pengembalian='$cid'"); } echo $cid; $fform->notif($q); } else { if($opt=='uf'||$opt=='df'){ // Prepocessing form $r=dbSFA("*",$dbtable,"W/replid='$cid'"); } else { $r=array(); } $fform->dimension(800); $fform->ptop=10; $fform->title_style='background:#00c804;color:#fff;height:18px !important;padding:5px 10px 10px 10px !important;margin-bottom:5px'; $fform->head(); if($opt=='af'||$opt=='uf'){ echo '<tr><td>';
$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}'"); } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') { // Prepocessing form $r = dbSFA("*", $dbtable, "W/replid='{$cid}'"); } else { $r = farray('proses', 'kodeawalan', 'angkatan', 'tglmulai', 'tglselesai', 'kapasitas', 'departemen', 'aktif', 'keterangan'); $r['tglmulai'] = date("Y-m-d"); $r['tglselesai'] = date("Y-m-d", strtotime("+7 day")); $r['departemen'] = gpost('departemen'); $r['aktif'] = '1'; $r['kapasitas'] = 1;
$q = dbInsert($dbtable, $inp); } } else { $inp['urut'] = buku_idbukugeturut($inp['idbuku']); $q = dbInsert($dbtable, $inp); } log_print($_SESSION['libdb_dbIsert']); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); $q = dbDel("pus_peminjaman", "buku='{$cid}'"); } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') { // Prepocessing form $r = dbSFA("*", $dbtable, "W/replid='{$cid}'"); $tk = mysql_query("SELECT judul,klasifikasi,pengarang FROM pus_katalog WHERE replid='" . $r['katalog'] . "'"); $rk = mysql_fetch_array($tk); $lok = $r['lokasi']; $sat = $r['satuan']; $tingb = $r['tingkatbuku']; $lokasi = lokasi_r($lok); $satuan = satuan_r($sat);
$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}'"); } } } $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
echo $fwidth; ?> px"> <tr><td>Are you sure want to delete "<b><?php echo $r['title']; ?> </b>"?</td></tr> </table> <table cellspacing="0" cellpadding="3px" width="<?php echo $fwidth - 1; ?> px" style="margin:20px 0 12px 0"><tr> <td align="right"> <input type="button" class="btn" onclick="close_fform()" value="Cancel"/> <input type="button" class="btn" onclick="doDel(<?php echo $cid; ?> )" value="Delete"/> </td> </tr></table> </div> </div> </td></tr></table> <?php } else { if ($opt == 'd') { dbDel("book", "catalog='{$cid}'"); dbDel("catalog", "dcid='{$cid}'"); require_once VWDIR . 'v_catalog.php'; } }
$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(); if($opt=='df'){ // Delete form $fform->dlg_del(buku_judul($r['judul'])); } $fform->foot();
$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'] . "'"); } } } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); $q = dbDel("sar_peminjaman_barang", "peminjaman='{$cid}'"); } } } echo $cid; $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') { // Prepocessing form $r = dbSFA("*", $dbtable, "W/replid='{$cid}'"); } else { $r = array(); } $fform->dimension(800); $fform->ptop = 10; $fform->title_style = 'background:#008aff;color:#fff;height:18px !important;padding:5px 10px 10px 10px !important;margin-bottom:5px';
$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}'"); $q &= dbDel("aka_siswa", "tingkat='{$cid}'"); } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') { // Prepocessing form $r = dbSFA("*", $dbtable, "W/replid='{$cid}'"); } else { $r['departemen'] = gpost('departemen'); $r['tahunajaran'] = gpost('tahunajaran'); } $fform->head(); if ($opt == 'af' || $opt == 'uf') { require_once MODDIR . 'control.php';
<?php require_once(MODDIR.'xform/xform.php'); require_once(MODDIR.'control.php'); $opt=gpost('opt'); $cid=gpost('cid'); if($cid=='')$cid=0; $ssid=session_id(); dbDel("pus_tpjm","ssid='$ssid'"); $fmod='peminjaman'; $xform=new xform($fmod,$opt,$cid); if($opt=='uf'){ // Nilai field editan //$t=mysql_query("SELECT * FROM pus_katalog WHERE replid='$cid' LIMIT 0,1"); //$data=mysql_fetch_array($t); $ttl='Edit'; } else { // Nilai field default $data=farray(); $ttl='Tambah'; $data['tanggal1']=date("Y-m-d"); $data['tanggal2']=date("Y-m-d",strtotime("+7 day")); } $xform->title($ttl.' data peminjaman'); $xform->table_begin(); $xform->col_begin('50%'); $xform->set_fieldw(340); $xform->group_begin('Data Peminjam'); $s='<button title="Cari" class="btn" style="margin-right:4px" onclick="sirkulasi_member_add()"><div class="bi_srcb"> </div></button>'; $xform->fi('Peminjam',iText('smember','','width:250px;margin-right:4px','ID atau nama member','onkeyup="sirkulasi_member_cari(event)"').$s); hiddenval('member_id',0); hiddenval('member_tipe',0); hiddenval('sirkulasi_form',1);
$inp['idbuku']=buku_makeid($data); $inp['barkode']=buku_makebarkode($data);; $q=dbInsert($dbtable,$inp); } } else { $inp['urut']=buku_getlasturut()+1; $q=dbInsert($dbtable,$inp); } //log_print($_SESSION['libdb_dbIsert']); } else if($opt=='u') { // edit $q=dbUpdate($dbtable,$inp,"replid='$cid'"); } else if($opt=='d'){ // delete $q=dbDel($dbtable,"replid='$cid'"); $q=dbDel("pus_peminjaman","buku='$cid'"); } $fform->notif($q); } else { if($opt=='uf'||$opt=='df'){ // Prepocessing form $r=dbSFA("*",$dbtable,"W/replid='$cid'"); $tk=mysql_query("SELECT judul,klasifikasi,pengarang FROM pus_katalog WHERE replid='".$r['katalog']."'"); $rk=mysql_fetch_array($tk); $lok=$r['lokasi']; $sat=$r['satuan']; $tingb=$r['tingkatbuku']; $lokasi=lokasi_r($lok); $satuan=satuan_r($sat); $tingkatbuku=tingkatbuku_r($tingb);
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(); if ($opt == 'df') { // Delete form
$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') { // Prepocessing form $r = dbSFA("*", $dbtable, "W/replid='{$cid}'"); $tk = mysql_query("SELECT judul,klasifikasi,pengarang FROM pus_katalog WHERE replid='" . $r['katalog'] . "'"); $rk = mysql_fetch_array($tk); $lok = $r['lokasi']; $sat = $r['satuan']; $tingb = $r['tingkatbuku']; $lokasi = lokasi_r($lok); $satuan = satuan_r($sat); $tingkatbuku = tingkatbuku_r($tingb);
<?php $ssid=session_id(); require_once(MODDIR.'control.php'); dbDel("pus_tpjm","ssid='$ssid'"); ?> <table cellspacing="10px" cellpadding="0" border="0" style="border:1px solid rgba(0,0,0,0.3);background:#fcfcff;margin-top:10px;margin-bottom:10px"><tr valign="top"><td> <div style="float:left;width:500px;margin-right:20px"> <div class="sfont" style="margin-top:0px;height:24px;width:100%"><b>Daftar label item yang dicetak:</b></div> <div class="tbltopbar" style="width:100%"> <?=iText('sbuku','','width:300px;margin-right:4px','barkode atau judul item','onkeyup="tools_label_buku_list_cari(event)"')?> <button title="Cari" class="btn" style="margin-right:4px" onclick="tools_label_buku_list_open()"><div class="bi_srcb"> </div></button> </div> <div id="box_tools_label_buku" style="float:left;width:100%;margin-bottom:10px"> <?php require_once(APPDIR.'tools_label_buku_get.php'); ?> </div> </div> <div style="float:left;width:250px"> <div class="sfont" style="margin-top:0px;height:24px;width:100%"><b>Pilih informasi yang dicetak:</b></div> <table cellspacing="0" cellpadding="0"> <tr height="24px"><td><?=iCheckx('cetak_header','Header',1)?></td></tr> <tr height="24px"><td><?=iCheckx('cetak_callnumber','Callnumber',1)?></td></tr> <tr height="24px"><td><?=iCheckx('cetak_barkode','Barkode',1)?></td></tr> </table> <div class="sfont" style="margin-top:0px;height:24px;width:100%;margin-top:20px"><b>Pengaturan cetak label:</b></div> <table class="sfont" cellspacing="0" cellpadding="0"> <tr height="30px"><td width="100px">Lebar label:</td><td><?=iText('cetak_lebar',6,'width:30px;text-align:center')?> cm</td></tr> <tr height="30px"><td>Ukuran kertas:</td><td><?=iSelect('cetak_ukuran',array('F4'=>'F4 210x330mm','A4'=>'A4 210x297mm','A5'=>'A5 148x210mm'),'F4')?></td></tr> <tr height="30px"><td>Orientasi kertas:</td><td><?=iSelect('cetak_orientasi',array('P'=>'Potrait','L'=>'Landscape'),'P')?></td></tr> </table> </div> <div class="sfont" style="float:left;width:100%;margin-top:10px"> <button class="btn" style="float:left" onclick="tools_label_cancel()">Batal</button> <button class="btnz" style="float:right" onclick="tools_label_cetak()">Cetak »</button> </div>
if (mysql_num_rows($y) == 0) { $y = mysql_query("SELECT hrd_pegawai.nip,hrd_pegawai.nama FROM hrd_pegawai WHERE hrd_pegawai.replid='" . $inp['pegawai'] . "'"); $u = mysql_fetch_array($y); $q = mysql_query("INSERT INTO admin SET app='gur', nama='" . $u['nama'] . "', uname='" . $u['nip'] . "', passwd='" . md5('admin') . "', pegawai='" . $inp['pegawai'] . "', level='2'"); } } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "replid='{$cid}'"); } else { if ($opt == 'd') { // delete $t = mysql_query("SELECT pegawai FROM aka_guru WHERE replid='{$cid}'"); $r = mysql_fetch_array($t); $q = dbDel($dbtable, "replid='{$cid}'"); $q &= dbDel("admin", "pegawai='" . $r['pegawai'] . "'"); } } } $fform->notif($q); } else { // 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) {
</td> </tr> <?php } } else { echo "<span></span>"; } ?> <input type="hidden" id="qtrn" value="<?php echo $nr; ?> " /><?php } else { if ($opt == 'rq') { $cid = gpost('cid'); dbDel("p_label", "dcid='{$cid}'"); $t = dbSel("*", "p_label"); $i = 0; $nr = mysql_num_rows($t); while ($r = dbFA($t)) { $k = $k == "#f4f4f4" ? "#ffffff" : "#f4f4f4"; ?> <tr height="24px" style="background:<?php echo $k; ?> "> <td width="*"><div style="overflow:hidden;width:100%;height:15px"><?php echo $r['title']; ?> </div></td> <td width="80px"> <?php