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
