function DftrFrm1()
{
global $_defmaxrow;
include_once "class/lister.class.php";
$arrNamaField = array('Nomer Formulir' => 'pfj.PMBFormJualID', 'Bukti Setoran' => 'pfj.BuktiSetoran', 'Reset' => '');
$pagefmt = "<a href='?mnux=pmbformjual.daftar&gos=DftrFrm&FRMSR==STARTROW='>=PAGE=</a>";
$pageoff = "<b>=PAGE=</b>";
$whr = array();
if (!empty($_SESSION['crfrmkey'])) {
$NamaField = $_SESSION[crfrmkey];
$whr[] = "{$arrNamaField[$NamaField]} like '%{$_SESSION['crfrm']}%' ";
}
if ($_SESSION['pmbtglfilter'] == 'Y') {
$whr[] = "pfj.Tanggal='{$_SESSION['pmbtgl']}'";
}
$strwhr = implode(' and ', $whr);
$strwhr = empty($strwhr) ? '' : "where {$strwhr}";
$lister = new lister();
$lister->tables = "pmbformjual pfj\r\n left outer join pmbformulir pf on pfj.PMBFormulirID=pf.PMBFormulirID\r\n {$strwhr}\r\n order by pfj.PMBFormJualID desc";
//echo $lister->tables;
$lister->fields = "pfj.*, date_format(pfj.Tanggal, '%d-%m-%Y') as TGL,\r\n format(pfj.Jumlah, 0) as JML, pf.Nama as FRM, pf.JumlahPilihan ";
$lister->startrow = $_REQUEST['FRMSR'] + 0;
$lister->maxrow = $_defmaxrow;
$lister->headerfmt = "<p><table class=box cellspacing=1 cellpadding=4>\r\n <tr>\r\n\t <th class=ttl>No.</th>\r\n\t <th class=ttl>Gel/<br />Period</th>\r\n\t <th class=ttl>Tanggal</th>\r\n\t <th class=ttl>No. Kwitansi</th>\r\n\t <th class=ttl>No. Bukti<br />Setoran</th>\r\n\t <th class=ttl>Pembeli</th>\r\n\t <th class=ttl>Formulir</th>\r\n\t <th class=ttl>Jumlah<br>Pilihan</th>\r\n\t <th class=ttl>Harga</th>\r\n\r\n </tr>";
// <th class=ttl>Ambil<br>Form?</th>
$lister->detailfmt = "<tr>\r\n\t <td class=inp1 width=18 align=right>=NOMER=</td>\r\n\t <td class=cnn=OK=>=PMBPeriodID=</td>\r\n\t <td class=cnn=OK=>=TGL=</td>\r\n <td class=cnn=OK=>=PMBFormJualID=</td>\r\n <td class=cnn=OK=>=BuktiSetoran=</td>\r\n\t <td class=cnn=OK=>=Nama=</a></td>\r\n\t <td class=cnn=OK=>=FRM=</td>\r\n\t <td class=cnn=OK= align=center>=JumlahPilihan=</td>\r\n\t <td class=cnn=OK= align=right>=JML=</td>\r\n\t </tr>";
// <td class=cnn=OK= align=center>
// <a href='?mnux=pmbformjual.daftar&gos=frmok&pfjid==PMBFormJualID=&stt==OK='><img src='img/=OK=.gif' border=0></a></td>
$lister->footerfmt = "</table></p>";
$halaman = $lister->WritePages($pagefmt, $pageoff);
$TotalNews = $lister->MaxRowCount;
$usrlist = $lister->ListIt() . "<p>Halaman: {$halaman}<br>\r\n Total: {$TotalNews}</p>";
echo $usrlist;
}
function DftrPMB1()
{
global $_defmaxrow, $_FKartuUSM, $_PMBAdminJalurKhusus;
include_once "class/lister.class.php";
if ($_SESSION['Cari'] != 'All') {
$_cari2 = !empty($_SESSION['pmbcari']) ? " and p.{$_SESSION['Cari']} like '%{$_SESSION['pmbcari']}%' " : '';
} else {
$_cari2 = '';
}
$whr = '';
$whr .= empty($_SESSION['prgid']) ? '' : "and p.ProgramID='{$_SESSION['prgid']}'";
$whr .= empty($_SESSION['stawal']) ? '' : "and p.StatusAwalID='{$_SESSION['stawal']}'";
$whr .= empty($_SESSION['pmbfid']) ? '' : "and PMBFormulirID='{$_SESSION['pmbfid']}'";
//$JalurKhusus = (strpos($_PMBAdminJalurKhusus, ".$_SESSION[_LevelID].") === false)? 'N' : 'Y';
//echo 'Jalur Khusus: '.$JalurKhusus;
$pagefmt = "<a href='?mnux=pmbform&gos=DftrPMB&SR==STARTROW='>=PAGE=</a>";
$pageoff = "<b>=PAGE=</b>";
$lister = new lister();
$lister->tables = "pmb p\r\n left outer join statusawal sa on p.StatusAwalID=sa.StatusAwalID\r\n left outer join program prg on p.ProgramID=prg.ProgramID\r\n left outer join prodi p1 on p.Pilihan1=p1.ProdiID\r\n left outer join prodi p2 on p.Pilihan2=p2.ProdiID\r\n left outer join prodi p3 on p.Pilihan3=p3.ProdiID\r\n where \r\n PMBID like '{$_SESSION['pmbaktif']}%' {$_cari2} {$whr}\r\n order by p.PMBID desc";
//echo $lister->tables;
$lister->fields = "p.PMBID, p.PMBRef, p.Nama, p.NA, p.JenisSekolahID, prg.Nama as PRG,\r\n p.SyaratLengkap, p.Syarat, sa.Nama as STA,\r\n p1.Nama as Pil1, p2.Nama as Pil2, p3.Nama as Pil3, format(Harga, 2) as HRG ";
$lister->startrow = $_REQUEST['SR'] + 0;
$lister->maxrow = $_defmaxrow;
$lister->headerfmt = "<p><table class=box cellspacing=1 cellpadding=4>\r\n <tr>\r\n\t <th class=ttl>No.</th><th class=ttl>No. PMB</th>\r\n\t <th class=ttl>No. Ujian</th>\r\n\t <th class=ttl>Nama</th>\r\n\t <th class=ttl>Program</th>\r\n\t <th class=ttl>Pilihan 1</th>\r\n\t <th class=ttl>Pilihan 2</th>\r\n\t <th class=ttl>Pilihan 3</th>\r\n\t <th class=ttl>Status</th>\r\n <th class=ttl>Asal</th>\r\n\t <th class=ttl colspan=2>Harga</th>\r\n <th class=ttl>Syarat</th>\r\n\t <th class=ttl>Kartu</th>\r\n </tr>";
$lister->detailfmt = "<tr>\r\n\t <td class=inp1 width=18 align=right>=NOMER=</td>\r\n <td class=cna=NA=><a href=\"?mnux=pmbform&gos=PMBEdt0&md=0&pmbid==PMBID=\"><img src='img/edit.png' border=0>\r\n =PMBID=</a></td>\r\n <td class=cna=NA=>=PMBRef= </td>\r\n\t <td class=cna=NA=>=Nama=</a></td>\r\n\t <td class=cna=NA=>=PRG=</td>\r\n\t <td class=cna=NA=>=Pil1= </td>\r\n\t <td class=cna=NA=>=Pil2= </td>\r\n <td class=cna=NA=>=Pil3= </td>\r\n <td class=cna=NA=>=STA=</td>\r\n <td class=cna=NA=>=JenisSekolahID=</td>\r\n\t <td class=cna=NA=><center><img src='img/=NA=.gif' border=0></td>\r\n\t <td class=cna=NA= align=right>=HRG=</td>\r\n <td class=cna=NA= align=center><a href='?mnux=pmbform&gos=SyaratEdt&pmbid==PMBID='><img src='img/=SyaratLengkap=.gif'></a></td>\r\n\t <td class=cna=NA=><a href='cetak/pmbform.kartu.php?pmbid==PMBID='>Cetak</a></td></tr>";
$lister->footerfmt = "</table></p>";
$halaman = $lister->WritePages($pagefmt, $pageoff);
$TotalNews = $lister->MaxRowCount;
$usrlist = $lister->ListIt() . "<br>Halaman: {$halaman}<br>\r\n\t Total: {$TotalNews}";
echo $usrlist;
}
function DaftarPesertaUSM()
{
global $_defmaxrow;
include_once "class/lister.class.php";
// Tampilkan jenis formulir
$optfrm = GetOption2('pmbformulir', "Nama", 'Nama', $_SESSION['pmbfid'], '', 'PMBFormulirID');
$c = 'class=ul';
$a = "<table class=box cellspacing=1 cellpadding=4>";
$a .= "<form action='?' method=POST>\r\n <input type=hidden name='mnux' value='pmbujian'>\r\n <input type=hidden name='gos' value='DefUSM'>\r\n <tr><td colspan=2 {$c}>Formulir:</td>\r\n <td colspan=3 {$c}><select name='pmbfid' onChange='this.form.submit()'>{$optfrm}</select>\r\n </td></tr></form>";
$a .= "<tr><th class=ttl>#</th><th class=ttl>PMB ID</th>\r\n <th class=ttl>Nama</th><th class=ttl># Kursi</th></tr>";
$pagefmt = "<a href='?mnux=pmbujian&SRUSM==STARTROW='>=PAGE=</a>";
$pageoff = "<b>=PAGE=</b>";
$lister = new lister();
$lister->tables = "pmb p\r\n where p.PMBFormulirID='{$_SESSION['pmbfid']}' and \r\n p.PMBPeriodID='{$_SESSION['pmbperiod']}' and p.RuangID is NULL\r\n order by p.PMBID";
//echo $lister->tables;
$lister->fields = "p.PMBID, p.Nama, p.NA";
$lister->startrow = $_REQUEST['SRUSM'] + 0;
$lister->maxrow = $_defmaxrow;
$lister->headerfmt = "";
$lister->detailfmt = "<tr>\r\n\t <td class=inp1 width=18 align=right>=NOMER=</td>\r\n <td class=cna=NA=>=PMBID=</td>\r\n\t <td class=cna=NA= nowrap>=Nama=</td>\r\n\t <td class=cna=NA= nowrap>\r\n\t <form action='?' method=GET>\r\n\t <input type=hidden name='mnux' value='pmbujian'>\r\n\t <input type=hidden name='gos' value='AddUSM'>\r\n\t <input type=hidden name='pmbid' value='=PMBID='>\r\n\t <input type=text name='pmbnmr' size=4 maxlength=4><input type=submit name='Simpan' value='>'>\r\n\t </td>\r\n\t </form></tr>";
$lister->footerfmt = "</table>";
$halaman = $lister->WritePages($pagefmt, $pageoff);
$TotalNews = $lister->MaxRowCount;
$usrlist = $lister->ListIt() . "<br>Halaman: {$halaman}<br>\r\n\t Total: {$TotalNews}";
return $a . $usrlist;
}
function DftrTahun()
{
global $_defmaxrow, $_FKartuUSM;
include_once "class/lister.class.php";
echo "<p><a href='?mnux=tahun&prodi={$_SESSION['prodi']}&prid={$_SESSION['prid']}&gos=ThnEdt&md=1'>Tambah Tahun Akademik</a></p>";
$pagefmt = "<a href='?mnux=tahun&gos=&THNSR==STARTROW='>=PAGE=</a>";
$pageoff = "<b>=PAGE=</b>";
$lister = new lister();
$lister->tables = "tahun\r\n where KodeID='" . KodeID . "' and ProdiID='{$_SESSION['prodi']}' and ProgramID='{$_SESSION['prid']}'\r\n order by TahunID desc";
//echo $lister->tables;
$lister->fields = "*,\r\n date_format(TglKRSMulai, '%d-%m-%Y') as KRSMulai,\r\n date_format(TglKRSSelesai, '%d-%m-%Y') as KRSSelesai,\r\n\tdate_format(TglKRSOnlineMulai, '%d-%m-%Y') as KRSOnlineMulai,\r\n\tdate_format(TglKRSOnlineSelesai, '%d-%m-%Y') as KRSOnlineSelesai,\r\n date_format(TglUbahKRSMulai, '%d-%m-%Y') as UbahKRSMulai,\r\n date_format(TglUbahKRSSelesai, '%d-%m-%Y') as UbahKRSSelesai,\r\n date_format(TglCetakKSS1, '%d-%m-%Y') as CetakKSS1,\r\n date_format(TglCetakKSS2, '%d-%m-%Y') as CetakKSS2,\r\n date_format(TglCuti, '%d-%m-%Y') as Cuti,\r\n date_format(TglMundur, '%d-%m-%Y') as Mundur,\r\n date_format(TglBayarMulai, '%d-%m-%Y') as BayarMulai,\r\n date_format(TglBayarSelesai, '%d-%m-%Y') as BayarSelesai,\r\n date_format(TglKembaliUangKuliah, '%d-%m-%Y') as KembaliUangKuliah,\r\n date_format(TglKuliahMulai, '%d-%m-%Y') as KuliahMulai,\r\n date_format(TglKuliahSelesai, '%d-%m-%Y') as KuliahSelesai,\r\n date_format(TglUTSMulai, '%d-%m-%Y') as UTSMulai,\r\n date_format(TglUTSSelesai, '%d-%m-%Y') as UTSSelesai,\r\n date_format(TglUASMulai, '%d-%m-%Y') as UASMulai,\r\n date_format(TglUASSelesai, '%d-%m-%Y') as UASSelesai,\r\n date_format(TglNilai, '%d-%m-%Y') as Penilaian,\r\n\t\tdate_format(TglAkhirKSS, '%d-%m-%Y') as AkhirKSS\r\n ";
$lister->startrow = $_REQUEST['THNSR'] + 0;
$lister->maxrow = $_defmaxrow;
$lister->headerfmt = "<p><table class=box cellspacing=1 cellpadding=4>\r\n <tr>\r\n <th class=ttl>#</th>\r\n <th class=ttl>Tahun</th>\r\n <th class=ttl>Nama</th>\r\n <th class=ttl>KRS</th>\r\n\t<th class=ttl>KRS Online</th>\r\n <th class=ttl>Ubah KRS</th>\r\n <th class=ttl>Masa<br />Bayar</th>\r\n <th class=ttl>Masa Kuliah</th>\r\n <th class=ttl>Masa UTS</th>\r\n <th class=ttl>Masa UAS</th>\r\n <th class=ttl>Penilaian</th>\r\n\t\t<th class=ttl>Akhir Masa KSS</th>\r\n \r\n <th class=ttl>Buka</th>\r\n <th class=ttl>Reverse</th>\r\n <th class=ttl>Tutup</th>\r\n <th class=ttl>NA</th>\r\n </tr>";
$lister->detailfmt = "<tr>\r\n <td class=inp1 width=18 align=right>=NOMER=</td>\r\n <td class=cna=NA= nowrap><a href=\"?mnux=tahun&gos=ThnEdt&md=0&tahun==TahunID=&prodi==ProdiID=&prid==ProgramID=\"><img src='img/edit.png' border=0>\r\n =TahunID=</a></td>\r\n <td class=cna=NA=>=Nama=</a></td>\r\n <td class=cna=NA=>=KRSMulai=<br />=KRSSelesai=</td>\r\n\t\t<td class=cna=NA=>=KRSOnlineMulai=<br />=KRSOnlineSelesai=</td>\r\n <td class=cna=NA=>=UbahKRSMulai=<br />=UbahKRSSelesai=</td>\r\n <td class=cna=NA=>=BayarMulai=<br />=BayarSelesai=</td>\r\n <td class=cna=NA=>=KuliahMulai=<br />=KuliahSelesai=</td>\r\n <td class=cna=NA=>=UTSMulai=<br />=UTSSelesai=</td>\r\n <td class=cna=NA=>=UASMulai=<br />=UASSelesai=</td>\r\n <td class=cna=NA=>=Penilaian=</td>\r\n\t\t<td class=cna=NA=>=AkhirKSS= </td>\r\n \r\n <td class=cna=NA=><a href='?mnux=tahun&gos=ThnPrc&tahun==TahunID=&prodi==ProdiID=&prid==ProgramID='><img src='img/gear.gif' width=20></a> =ProsesBuka=x</td>\r\n <td class=cna=NA=><a href='?mnux=tahun&gos=ThnPrcBipot&tahun==TahunID=&prodi==ProdiID=&prid==ProgramID='><img src='img/gear.gif' width=20></a></td>\r\n <td class=cna=NA=><a href='?mnux=tahun&gos=ThnPrcTutup&tahun==TahunID=&prodi==ProdiID=&prid==ProgramID='><img src='img/gear.gif' width=20></a> =ProsesTutup=x</td>\r\n <td class=cna=NA= align=center><img src='img/book=NA=.gif'></td>\r\n </tr>";
$lister->footerfmt = "</table></p>";
$halaman = $lister->WritePages($pagefmt, $pageoff);
$TotalNews = $lister->MaxRowCount;
$usrlist = $lister->ListIt() . "<p>Halaman: {$halaman}<br>\r\n Total: {$TotalNews}</p>";
echo $usrlist;
/*
<th class=ttl>Skrg KRS<br />utk Angk</th>
<form action='tahun.angk.php' method=POST target=_blank>
<input type=hidden name='KodeID' value='$_SESSION[KodeID]'>
<input type=hidden name='TahunID' value='=TahunID='>
<input type=hidden name='ProgramID' value='=ProgramID='>
<input type=hidden name='ProdiID' value='=ProdiID='>
<td class=ul><input type=text name='HanyaAngkatan' value='=HanyaAngkatan=' size=8 mexlength=8>
<input type=submit name='Set' value='Set'></td>
</form>
*/
}
function DftrAplikan()
{
global $_defmaxrow;
include_once "class/lister.class.php";
$_cari2 = !empty($_SESSION['aplikancari']) ? " and p.{$_SESSION['Cari']} like '%{$_SESSION['aplikancari']}%' " : '';
$pagefmt = "<a href='?mnux=formaplikan&gos=DftrAplikan&SR==STARTROW='>=PAGE=</a>";
$pageoff = "<b>=PAGE=</b>";
$lister = new lister();
$lister->tables = "aplikan ap\n\tleft outer join presenter p on p.Login = ap.PresenterID\n where \n AplikanID like '{$_SESSION['pmbaktif']}%' {$_cari2}\n order by ap.AplikanID desc";
$lister->fields = "ap.AplikanID, p.Nama as Presenter, ap.Nama, ap.NA, ap.Alamat, ap.TanggalDaftar";
$lister->startrow = $_REQUEST['SR'] + 0;
$lister->maxrow = $_defmaxrow;
$lister->headerfmt = "<p><table class=box cellspacing=1 cellpadding=4>\n\t\t<tr>\n\t\t <th class=ttl>No.</th>\n\t\t <th class=ttl>No. Aplikan</th>\n\t\t <th class=ttl>Presenter</th>\n\t\t <th class=ttl>Nama</th>\n\t\t <th class=ttl>Alamat</th>\n\t\t <th class=ttl>Pilihan D3</th>\n\t\t <th class=ttl>Pilihan S1</th>\n\t\t <th class=ttl>Tanggal Daftar</th>\n\t\t</tr>";
$lister->detailfmt = "<tr>\n\t\t<td class=inp1 width=18 align=right>=NOMER=</td>\n\t\t<td class=cna=NA=><a href=\"?mnux=formaplikan&gos=PMBEdt0&md=0&aplkan==AplikanID=\"><img src='img/edit.png' border=0>=AplikanID=</a></td>\n\t\t<td class=cna=NA=>=Presenter= </td>\n\t\t<td class=cna=NA=>=Nama=</a></td>\n\t\t<td class=cna=NA=>=Alamat=</td>\n\t\t<td class=cna=NA=>=PilihanD3= </td>\n\t\t<td class=cna=NA=>=PilihanS1= </td>\n\t\t<td class=cna=NA=>=TglDaftar=</td>";
$lister->footerfmt = "</table></p>";
$halaman = $lister->WritePages($pagefmt, $pageoff);
$TotalNews = $lister->MaxRowCount;
$usrlist = $lister->ListIt() . "<br>Halaman: {$halaman}<br> Total: {$TotalNews}";
echo $usrlist;
}
function DftrPer()
{
global $_defmaxrow, $mnux, $pref, $tokendef;
include_once "class/lister.class.php";
$s = "select * from pmbperiod where KodeID='{$_SESSION['KodeID']}' order by PMBPeriodID desc limit {$_SESSION['periodpg']},{$_defmaxrow}";
$pagefmt = "<a href='?mnux={$mnux}&{$pref}=Per&sub=DftrPer&SR==STARTROW='>=PAGE=</a>";
$pageoff = "<b>=PAGE=</b>";
$_KodeID = GetOption2('identitas', "concat(Kode, ' - ', Nama)", "Kode", $_SESSION['KodeID'], '', 'Kode');
$lister = new lister();
$lister->tables = "pmbperiod where KodeID='{$_SESSION['KodeID']}' order by PMBPeriodID desc ";
//echo $lister->tables;
$lister->fields = "*, \r\n concat(date_format(TglMulai, '%d/%m/%Y'), '<br />', date_format(TglSelesai, '%d/%m/%Y')) as TglDaftar, \r\n concat(date_format(UjianMulai, '%d/%m/%Y'), '<br />', date_format(UjianSelesai, '%d/%m/%Y')) as TglUSM,\r\n concat(date_format(BayarMulai, '%d/%m/%Y'), '<br />', date_format(BayarSelesai, '%d/%m/%Y')) as TglBayar ";
$lister->startrow = $_REQUEST['SR'] + 0;
$lister->maxrow = $_defmaxrow;
$lister->headerfmt = "<table class=box cellspacing=1 cellpadding=4>\r\n <tr>\r\n <form action='?' method=POST>\r\n <input type=hidden name='mnux' value='{$mnux}'>\r\n <input type=hidden name='{$pref}' value='Per'>\r\n <td class=ul colspan=8>Institusi : <select name='KodeID' onChange='this.form.submit()'>{$_KodeID}</select></td></tr>\r\n </form>\r\n <tr>\r\n\t<td class=ul colspan=8><a href=\"?mnux={$mnux}&{$pref}=Per&sub=PerEdt&md=1\">Buat Period</a></td></tr>\r\n </tr>\r\n <tr>\r\n\t <th class=ttl>#</th><th class=ttl>Kode</th>\r\n\t <th class=ttl>Nama</th>\r\n <th class=ttl nowrap>Tgl Pendaftaran</th>\r\n <th class=ttl nowrap>Tgl Ujian</th>\r\n <th class=ttl nowrap>Tgl Bayar</th>\r\n <th class=ttl nowrap>Teliti Pembayaran utk Prodi</th>\r\n\t <th class=ttl>NA</th>\r\n </tr>";
$lister->detailfmt = "<tr>\r\n\t <td class=inp1 width=18 align=right>=NOMER=</td>\r\n\t <td class=cna=NA=><a href=\"?mnux={$mnux}&{$pref}=Per&sub=PerEdt&md=0&pmbperiod==PMBPeriodID=\"><img src='img/edit.png' border=0>=PMBPeriodID=</a></td>\r\n\t <td class=cna=NA=>=Nama=</a></td>\r\n\t <td class=cna=NA=>=&TglDaftar=</td>\r\n\t <td class=cna=NA=>=&TglUSM=</td>\r\n\t <td class=cna=NA=>=&TglBayar=</b>\r\n\t <td class=cna=NA=>=TelitiBayarProdi=</td>\r\n\t <td class=cna=NA=><center><img src='img/book=NA=.gif' border=0></td></tr>";
$lister->footerfmt = "</table>";
$halaman = $lister->WritePages($pagefmt, $pageoff);
$TotalNews = $lister->MaxRowCount;
$usrlist = $lister->ListIt() . "Halaman: {$halaman}<br>\r\n\t Baris: {$TotalNews}</p>";
echo $usrlist;
}
function DftrGelombang()
{
global $_maxbaris;
include_once "class/lister.class.php";
GelEdtScript();
$_gelombangpage = GetSetVar('_gelombangpage', 0);
$pagefmt = "<a href='?mnux={$_SESSION['mnux']}&gos=gelombang&sub=&_gelombangpage==PAGE='>=PAGE=</a>";
$pageoff = "<b>=PAGE=</b>";
$brs = "<hr size=1 color=silver />";
$gantibrs = "<tr><td bgcolor=silver height=1 colspan=8></td></tr>";
$lst = new lister();
$lst->tables = "pmbperiod p where p.KodeID = '" . KodeID . "' order by p.PMBPeriodID desc";
$lst->fields = "p.PMBPeriodID, p.Nama,\n p.NA,\n date_format(p.TglMulai, '%d/%m/%y') as _TglMulai,\n date_format(p.TglSelesai, '%d/%m/%y') as _TglSelesai,\n date_format(p.UjianMulai, '%d/%m/%y') as _UjianMulai,\n date_format(p.UjianSelesai, '%d/%m/%y') as _UjianSelesai,\n date_format(p.BayarMulai, '%d/%m/%y') as _BayarMulai,\n date_format(p.BayarSelesai, '%d/%m/%y') as _BayarSelesai,\n\tdate_format(p.WawancaraMulai, '%d/%m/%y') as _WawancaraMulai,\n\tdate_format(p.WawancaraSelesai, '%d/%m/%y') as _WawancaraSelesai";
$lst->startrow = $_SESSION['_gelombangpage'] + 0;
$lst->maxrow = $_maxbaris;
$lst->headerfmt = "<p><table class=box cellspacing=1 align=center width=800>\n <tr>\n <td class=ul1 colspan=7>\n <input type=button name='Tambah' value='Tambah Gelombang'\n onClick=\"javascript:GelEdt(1, '', '{$_SESSION['mnux']}')\" />\n <input type=button name='Refresh' value='Refresh'\n onClick=\"window.location='?mnux={$_SESSION['mnux']}'\" />\n Catatan: Hanya ada 1 gelombang yang aktif.\n </td>\n </tr>\n \n <tr>\n <th class=ttl colspan=2>#</th>\n <th class=ttl>Gelombang</th>\n <th class=ttl>Nama Gelombang</th>\n <th class=ttl>Periode</th>\n <th class=ttl>Ujian</th>\n <th class=ttl>Bayar</th>\n <th class=ttl>NA</th>\n </tr>";
$lst->detailfmt = "<tr>\n <td class=inp width=10>=NOMER=</td>\n <td class=ul1 width=10>\n <a href='#' onClick=\"javascript:GelEdt(0, '=PMBPeriodID=', '{$_SESSION['mnux']}')\"><img src='img/edit.png' /></a></td>\n <td class=cna=NA= width=100>=PMBPeriodID=</td>\n <td class=cna=NA=>=Nama=</td>\n <td class=cna=NA= width=80 align=center>=_TglMulai={$brs}=_TglSelesai=</td>\n <td class=cna=NA= width=80 align=center>=_UjianMulai={$brs}=_UjianSelesai=</td>\n <td class=cna=NA= width=80 align=center>=_BayarMulai={$brs}=_BayarSelesai=</td>\n <td class=ul1 width=10 align=center><img src='img/book=NA=.gif' /></td>\n </tr>" . $gantibrs;
$lst->footerfmt = "</table>";
$hal = $lst->WritePages($pagefmt, $pageoff);
$ttl = $lst->MaxRowCount;
echo $lst->ListIt();
echo "<p align=center>Hal: {$hal} <br />(Tot: {$ttl})</p>";
}
function DftrSek()
{
global $_defmaxrow, $mnux, $pref;
$CariSekolah = GetSetVar('CariSekolah', 'Nama Sekolah');
$arrCariSekolah = array('Nama Sekolah' => 'Nama', 'Kode Sekolah' => 'SekolahID');
echo "<table class=box cellspacing=1 cellpadding=4>\r\n <form action='index.php' method=GET>\r\n <input type=hidden name='mnux' value='pmbasalsek'>\r\n <input type=hidden name='gos' value='DftrSek'>\r\n <input type=hidden name='md' value='{$md}'>\r\n <input type=hidden name='SRSEK' value='{$_REQUEST['SRSEK']}'>\r\n <tr><td class=inp1>Cari Sekolah:</td><td class=ul colspan=2><input type=text name='NamaSekolah' value='{$_SESSION['NamaSekolah']}' size=20 maxlength=20>\r\n <input type=submit name='CariSekolah' value='Nama Sekolah'> <input type=submit name='CariSekolah' value='Kode Sekolah'></td></tr>\r\n <tr><td class=inp1>Filter Kota:</td><td class=ul><input type=text name='KotaSekolah' value='{$_SESSION['KotaSekolah']}' size=20 maxlength=20></td><td class=ul><input type=submit name='KotaSekolahS' value='Filter'> *) kosongkan jika tidak ingin difilter</td>\r\n </form></table><br>";
$whr = array();
if (!empty($_SESSION['NamaSekolah'])) {
if ($arrCariSekolah[$CariSekolah] == 'SekolahID') {
$whr[] = $arrCariSekolah[$CariSekolah] . " like '{$_SESSION['NamaSekolah']}%' ";
} else {
$whr[] = $arrCariSekolah[$CariSekolah] . " like '%{$_SESSION['NamaSekolah']}%' ";
}
}
if (!empty($_SESSION['KotaSekolah'])) {
$whr[] = "Kota like '%{$_SESSION['KotaSekolah']}%' ";
}
$_whr = implode(" and ", $whr);
$_whr = empty($_whr) ? '' : "where {$_whr}";
include_once "class/lister.class.php";
$pagefmt = "<a href='?mnux={$mnux}&{$pref}=Sek&SRSEK==STARTROW='>=PAGE=</a>";
$pageoff = "<b>=PAGE=</b>";
$lister = new lister();
$lister->tables = "asalsekolah {$_whr}\r\n order by " . $arrCariSekolah[$CariSekolah];
//echo $lister->tables;
$lister->fields = "*";
$lister->startrow = $_REQUEST['SRSEK'] + 0;
$lister->maxrow = $_defmaxrow;
$lister->headerfmt = "<table class=box cellspacing=1 cellpadding=4>\r\n <tr><td class=ul colspan=8><a href='?mnux=pmbasalsek&gos=SekEdt&md=1'>Tambah Sekolah</a></td></tr>\r\n\t \r\n <tr>\r\n\t <th class=ttl>No.</th>\r\n <th class=ttl>Kode</th>\r\n\t <th class=ttl>Nama</th>\r\n <th class=ttl>Jenis</th>\r\n\t <th class=ttl>Kota</th>\r\n\t <th class=ttl>Website</th>\r\n\t <th class=ttl>Telephone</th>\r\n\t <th class=ttl>NA</th>\r\n </tr>";
$lister->detailfmt = "<tr>\r\n\t <td class=inp1 width=18 align=right>=NOMER=</td>\r\n <td class=cna=NA= nowrap><a href=\"?SRSEK={$_REQUEST['SRSEK']}&mnux=pmbasalsek&gos=SekEdt&sekid==SekolahID=\"><img src='img/edit.png' border=0>\r\n =SekolahID=</a></td>\r\n\t <td class=cna=NA=>=Nama=</a></td>\r\n\t <td class=cna=NA=>=JenisSekolahID= </td>\r\n\t <td class=cna=NA=>=Kota= </td>\r\n\t <td class=cna=NA=>=Website= </td>\r\n\t <td class=cna=NA=>=Telephone= </td>\r\n\t <td class=cna=NA=><center><img src='img/book=NA=.gif' border=0></td></tr>";
$lister->footerfmt = "</table>";
$halaman = $lister->WritePages($pagefmt, $pageoff);
$TotalNews = $lister->MaxRowCount;
$usrlist = $lister->ListIt() . "<br>\r\n\t Halaman: {$halaman}<br>\r\n\t Total: {$TotalNews}";
echo $usrlist;
}
function TampilkanDaftarUSM_x() {
global $_defmaxrow;
include_once "class/lister.class.php";
if ($_SESSION['Cari'] != 'All') {
$_cari2 = (!empty($_SESSION['pmbcari']))? " and p.$_SESSION[Cari] like '%$_SESSION[pmbcari]%' " : '';
} else $_cari2 = '';
// Filter
$whr = array();
$whr[] = "p.PMBPeriodID='$_SESSION[pmbtahun]'";
if (!empty($_SESSION['pmbfid'])) $whr[] = "p.PMBFormulirID='$_SESSION[pmbfid]'";
if (!empty($_SESSION['pmbpil1'])) $whr[] = "p.Pilihan1='$_SESSION[pmbpil1]'";
if (!empty($_SESSION['pmbprodi'])) $whr[] = "p.ProdiID='$_SESSION[pmbprodi]'";
$where = implode(" and ", $whr);
if (!empty($where)) $where = "where $where";
$pagefmt = "<a href='?mnux=pmbujian.hasil&SRHSL==STARTROW='>=PAGE=</a>";
$pageoff = "<b>=PAGE=</b>";
$lister = new lister;
$lister->tables = "pmb p
left outer join prodi p0 on p.ProdiID=p0.ProdiID
left outer join prodi p1 on p.Pilihan1=p1.ProdiID
left outer join prodi p2 on p.Pilihan2=p2.ProdiID
left outer join prodi p3 on p.Pilihan3=p3.ProdiID
$where
order by p.NilaiUjian desc";
//echo $lister->tables;
$lister->fields = "p.PMBID, p.Nama, p.NA, p.JenisSekolahID, p.NilaiUjian, p.LulusUjian, p.GradeNilai,
p.Pilihan1, p.Pilihan2, p.Pilihan3,
p0.Nama as Prodi, p1.Nama as Pil1, p2.Nama as Pil2, p3.Nama as Pil3,
format(Harga, 2) as HRG ";
$lister->startrow = $_REQUEST['SRHSL']+0;
$lister->maxrow = $_defmaxrow;
$lister->headerfmt = "<table class=box cellspacing=1 cellpadding=4>
<tr>
<th class=ttl>#</th><th class=ttl>Kode</th>
<th class=ttl>Nama</th>
<th class=ttl>Nilai USM</th>
<th class=ttl>Program Studi</th>
<th class=ttl>Pilihan1</th>
<th class=ttl>Pilihan2</th>
<th class=ttl>Pilihan3</th>
<th class=ttl>Asal</th>
<th class=ttl>Lulus</th>
<th class=ttl>Grade</th>
</tr>";
$lister->detailfmt = "<tr>
<td class=inp1 width=18 align=right>=NOMER=</td>
<td class=cnn=LulusUjian= nowrap><a href=\"?mnux=pmbform&gos=PMBEdt0&md=0&pmbid==PMBID=\"><img src='img/edit.png' border=0>
=PMBID=</a></td>
<td class=cnn=LulusUjian= nowrap>=Nama=</a></td>
<form action='?' method=POST>
<input type=hidden name='mnux' value='pmbujian.hasil'>
<input type=hidden name='gos' value='PMBHasilSav'>
<input type=hidden name='PMBID' value='=PMBID='>
<input type=hidden name='SRHSL' value='$_REQUEST[SRHSL]'>
<td class=cnn=LulusUjian= nowrap><input type=text name='NilaiUjian' value='=NilaiUjian=' size=4 maxlength=4>
<input type=submit name='Simpan' value='Simpan'></td>
</form>
<td class=cnn=LulusUjian= nowrap>=Prodi= </td>
<form action='?' method=POST>
<input type=hidden name='mnux' value='pmbujian.hasil'>
<input type=hidden name='gos' value='PMBHasilPil'>
<input type=hidden name='PMBID' value='=PMBID='>
<input type=hidden name='SRHSL' value='$_REQUEST[SRHSL]'>
<td class=cnn=LulusUjian= nowrap><input type=checkbox name='PIL' value='=Pilihan1=' onClick='this.form.submit()'>
=Pil1= </td>
</form>
<form action='?' method=POST>
<input type=hidden name='mnux' value='pmbujian.hasil'>
<input type=hidden name='gos' value='PMBHasilPil'>
<input type=hidden name='PMBID' value='=PMBID='>
<input type=hidden name='SRHSL' value='$_REQUEST[SRHSL]'>
<td class=cnn=LulusUjian= nowrap><input type=checkbox name='PIL' value='=Pilihan2=' onClick='this.form.submit()'>
=Pil2= </td>
</form>
<form action='?' method=POST>
<input type=hidden name='mnux' value='pmbujian.hasil'>
<input type=hidden name='gos' value='PMBHasilPil'>
<input type=hidden name='PMBID' value='=PMBID='>
<input type=hidden name='SRHSL' value='$_REQUEST[SRHSL]'>
<td class=cnn=LulusUjian= nowrap><input type=checkbox name='PIL' value='=Pilihan3=' onClick='this.form.submit()'>
=Pil3= </td>
</form>
<td class=cnn=LulusUjian=>=JenisSekolahID=</td>
<td class=cnn=LulusUjian=><center><a href='?mnux=pmbujian.hasil&SRHSL=$_REQUEST[SRHSL]&gos=PMBHasilLulus&Lulus==LulusUjian=&PMBID==PMBID='>
<img src='img/=LulusUjian=.gif' border=0></a></td>
<td class=cnn=LulusUjian=><a href='?mnux=pmbujian.hasil&gos=EdtGrade&SRHSL=$_REQUEST[SRHSL]&PMBID==PMBID='><img src='img/edit.png' border=0> =GradeNilai=</a></td>
</tr>";
$lister->footerfmt = "</table>";
$halaman = $lister->WritePages ($pagefmt, $pageoff);
$TotalNews = $lister->MaxRowCount;
$usrlist = $lister->ListIt () .
"<br>Halaman: $halaman<br>
Total: $TotalNews";
echo $usrlist;
}
}
}
});
}, {title: "提示信息"});
return false;
});
});
function go(){
location.href="email_list.php";
}
</script>
</head>
<body>
<?php
$sql = "select * from hy_email order by id desc";
$lister = new lister($mysqlhost, $mysqlname, $mysqlpsw, $mydata, "hy_email", $sql, "19");
?>
<table width="99%" height="393" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="17" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td>
<td valign="top" background="images/content-bg.gif"><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
<tr>
<td height="31"><div class="titlebt">管理邮件地址</div></td>
</tr>
</table></td>
<td width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td>
</tr>
<tr>
<td height="345" valign="middle" background="images/mail_leftbg.gif"> </td>
<td valign="top" bgcolor="#F7F8F9">
if (isset($_GET['type'])) {
$type = intval($_GET['type']);
}
if ($type == 2) {
$sql = "select * from hy_guestbook order by id desc";
$cSql = "hy_guestbook";
}
if ($type == 1) {
$sql = "select * from hy_guestbook where is_show=1 order by id desc";
$cSql = "hy_guestbook where is_show=1";
}
if ($type == 0) {
$sql = "select * from hy_guestbook where is_show=0 order by id desc";
$cSql = "hy_guestbook where is_show=0";
}
$lister = new lister($mysqlhost, $mysqlname, $mysqlpsw, $mydata, $cSql, $sql, "20");
?>
<table width="99%" height="393" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="17" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td>
<td valign="top" background="images/content-bg.gif"><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
<tr>
<td height="31"><div class="titlebt">管理留言</div></td>
</tr>
</table></td>
<td width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td>
</tr>
<tr>
<td height="345" valign="middle" background="images/mail_leftbg.gif"> </td>
<td valign="top" bgcolor="#F7F8F9">
function go(){
location.href="product_list.php";
}
</script>
</head>
<body>
<?php
$sql = "select * from hy_product_category";
$rs = mysql_query($sql, $conn);
while ($row = mysql_fetch_assoc($rs)) {
$cate_array[$row['id']] = $row['name'];
}
if (isset($_GET["fid"]) && is_numeric($_GET["fid"])) {
$lister = new lister($mysqlhost, $mysqlname, $mysqlpsw, $mydata, "hy_product where fid=" . $_GET["fid"], "select * from hy_product where fid=" . $_GET["fid"] . " order by id desc", "17");
} else {
$lister = new lister($mysqlhost, $mysqlname, $mysqlpsw, $mydata, "hy_product", "select * from hy_product order by id desc", "17");
}
?>
<table width="99%" height="393" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="17" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td>
<td valign="top" background="images/content-bg.gif"><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
<tr>
<td height="31"><div class="titlebt">管理产品</div></td>
</tr>
</table></td>
<td width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td>
</tr>
<tr>
<td height="345" valign="middle" background="images/mail_leftbg.gif"> </td>
<td valign="top" bgcolor="#F7F8F9">
while ($row = mysql_fetch_assoc($rs)) {
$cate_array[$row['id']] = $row['name'];
//set cate id(article fid) as cate name
}
$title = '';
$fid = 0;
if (!empty($_GET["title"])) {
$title = myfilter($_GET["title"], 3);
}
if (!empty($_GET["fid"])) {
$fid = intval($_GET["fid"]);
}
if (isset($_GET["fid"]) && is_numeric($_GET["fid"]) && intval($_GET["fid"]) > 0) {
$lister = new lister($mysqlhost, $mysqlname, $mysqlpsw, $mydata, "hy_article where fid=" . $_GET["fid"], "select * from hy_article where fid=" . $_GET["fid"] . " order by id desc", "17");
} else {
$lister = new lister($mysqlhost, $mysqlname, $mysqlpsw, $mydata, "hy_article", "select * from hy_article order by id desc", "17");
}
?>
<table width="99%" height="393" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="17" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td>
<td valign="top" background="images/content-bg.gif"><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
<tr>
<td height="31"><div class="titlebt">管理文章</div></td>
</tr>
</table></td>
<td width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td>
</tr>
<tr>
<td height="345" valign="middle" background="images/mail_leftbg.gif"> </td>
<td valign="top" bgcolor="#F7F8F9">
return false;
});
});
function go(){
location.href="single_list.php";
}
</script>
</head>
<body>
<?php
$sql = "select id,name from hy_admin";
$rs = mysql_query($sql, $conn);
while ($row = mysql_fetch_assoc($rs)) {
$admin_array[$row['id']] = $row['name'];
}
$lister = new lister($mysqlhost, $mysqlname, $mysqlpsw, $mydata, "wode_single", "select * from wode_single order by id desc", "20");
?>
<table width="99%" height="393" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="17" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td>
<td valign="top" background="images/content-bg.gif"><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
<tr>
<td height="31"><div class="titlebt">管理单页</div></td>
</tr>
</table></td>
<td width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td>
</tr>
<tr>
<td height="345" valign="middle" background="images/mail_leftbg.gif"> </td>
<td valign="top" bgcolor="#F7F8F9">
<table width="97%" height="52" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" id="bsinfo">