Пример #1
0
<?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);
Пример #2
0
<?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}'");
Пример #3
0
<?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') {
Пример #4
0
<?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}'");
            }
        }
Пример #5
0
<?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();
} ?>
Пример #6
0
<?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}'");
            }
        }
Пример #7
0
<?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);
Пример #8
0
            // 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.');
Пример #9
0
<?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}'");
            }
        }
Пример #10
0
<?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);
Пример #11
0
<?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') {
Пример #12
0
<?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') {
Пример #13
0
<?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}'");
            }
Пример #14
0
<?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
Пример #15
0
<?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') {
Пример #16
0
<?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}'");
            }
        }
    }
Пример #17
0
<?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);
Пример #18
0
<?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);
Пример #19
0
        } 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}'");
            }
        }
Пример #20
0
<?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}'");
Пример #21
0
<?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}'");
            }
        }
    }
Пример #22
0
<?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') {
Пример #23
0
<?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();
Пример #24
0
<?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}'");
            }
        }
Пример #25
0
<?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);
Пример #26
0
<?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'] . "'");
            }
        }
Пример #27
0
<?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));
Пример #28
0
<?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'");
Пример #29
0
 // 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));
Пример #30
0
<?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}'");
            }
        }