예제 #1
0
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;
}
예제 #2
0
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=&nbsp;</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=&nbsp;</td>\r\n\t  <td class=cna=NA=>=Pil2=&nbsp;</td>\r\n      <td class=cna=NA=>=Pil3=&nbsp;</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;
}
예제 #3
0
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;
}
예제 #4
0
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=&nbsp;</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>
    */
}
예제 #5
0
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=&nbsp;</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=&nbsp;</td>\n\t\t<td class=cna=NA=>=PilihanS1=&nbsp;</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;
}
예제 #6
0
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>";
}
예제 #8
0
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=&nbsp;</td>\r\n\t  <td class=cna=NA=>=Kota=&nbsp;</td>\r\n\t  <td class=cna=NA=>=Website=&nbsp;</td>\r\n\t  <td class=cna=NA=>=Telephone=&nbsp;</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;
}
예제 #9
0
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=&nbsp;</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=&nbsp;</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=&nbsp;</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=&nbsp;</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;
}
예제 #10
0
파일: email_list.php 프로젝트: realrain/hy
					}
				}
			});
		 }, {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">&nbsp;</td>
    <td valign="top" bgcolor="#F7F8F9">
      
예제 #11
0
파일: gbook_list.php 프로젝트: realrain/hy
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">&nbsp;</td>
    <td valign="top" bgcolor="#F7F8F9">
      
예제 #12
0
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">&nbsp;</td>
    <td valign="top" bgcolor="#F7F8F9">
예제 #13
0
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">&nbsp;</td>
    <td valign="top" bgcolor="#F7F8F9">
예제 #14
0
파일: single_list.php 프로젝트: realrain/hy
		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">&nbsp;</td>
    <td valign="top" bgcolor="#F7F8F9">      
      <table width="97%" height="52" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" id="bsinfo">