function DaftarMhsw($mnux, $lnk = '', $keluar = 0)
{
include_once "class/xthlister.class.php";
$inqMhswPage = GetSetVar('inqMhswPage');
$arrKey = array('NIM' => 'MhswID', 'Nama' => 'Nama', 'Semua' => '');
// filter
$whr = array();
if (!empty($arrKey[$_SESSION['crmhswkey']]) && !empty($_SESSION['crmhswval'])) {
$whr[] = "m." . $arrKey[$_SESSION['crmhswkey']] . " like '%" . $_SESSION['crmhswval'] . "%' ";
}
if ($keluar > 0) {
$whr[] = "sm.Keluar <> 1";
}
if ($_SESSION['_LevelID'] > 1) {
if (empty($_SESSION['_LevelID'])) {
die(ErrorMsg("Tidak Dapat Akses", "Anda tidak memiliki hak akses ke data Mahasiswa."));
}
$_ProdiID = trim($_SESSION['_ProdiID'], ',');
$arrProdi = explode(',', $_ProdiID);
$_prodi = '';
for ($i = 0; $i < sizeof($arrProdi); $i++) {
$_prodi .= ",'" . $arrProdi[$i] . "'";
}
$_prodi = trim($_prodi, ',');
$_prodi = empty($arrProdi) ? '-1' : $_prodi;
//implode(', ', $arrProdi);
if ($_SESSION['_LevelID'] == 100) {
} else {
$whr[] = "m.ProdiID in ({$_prodi})";
}
}
// Satukan filter
$_whr = implode(' and ', $whr);
$_whr = empty($_whr) ? '' : "where {$_whr}";
// Tampilkan daftar
$lst = new xthlister();
$lst->page = $_SESSION['inqMhswPage'] + 0;
$lst->pageactive = "=PAGE=";
$lst->pages = "<a href='?mnux={$lnk}&inqMhswPage==PAGE='>=PAGE=</a>";
$lst->tables = "mhsw m\n left outer join program prg on m.ProgramID=prg.ProgramID\n left outer join prodi prd on m.ProdiID=prd.ProdiID\n left outer join statusmhsw sm on m.StatusMhswID=sm.StatusMhswID\n {$_whr}\n order by m.MhswID";
$lst->fields = "m.MhswID, m.Nama, m.ProgramID, m.ProdiID, m.SKKeluar, m.Foto,\n prg.Nama as PRG, prd.Nama as PRD, sm.Nama as SM, sm.Keluar";
$lst->headerfmt = "<p><table class=box cellspacing=1 cellpadding=4>\n <tr><th class=ttl>#</th>\n <th class=ttl>No Mhsw</th>\n <th class=ttl>Nama Mhsw</th>\n <th class=ttl>Program</th>\n <th class=ttl>Program Studi</th>\n <th class=ttl>Status</th>\n <th class=ttl>SK Lulus/Keluar</th>\n </tr>";
$lst->footerfmt = "</table></p>";
$lst->detailfmt = "<tr><td class=inp1>=NOMER=</td>\n <td bgcolor='#9BBB59' class=cna=Keluar=><a href='?mnux={$mnux}&mhswid==MhswID=&{$lnk}'><img src='img/edit.png'>\n =MhswID=</a></td>\n <td bgcolor='#8DB3E2' class=cna=Keluar=><a id='=MhswID=' class='jTip' name=' Foto Mahasiswa' href='foto.pop.php?width=156&mhswid==MhswID=&foto==Foto='>=Nama=</a></td>\n <td bgcolor='#E5B8B7' class=cna=Keluar=>=ProgramID=-=PRG=</td>\n <td bgcolor='#B2A1C7' class=cna=Keluar=>=ProdiID=-=PRD=</td>\n <td bgcolor='#FABF8F' class=cna=Keluar=>=SM=</td>\n <td bgcolor='#BFBFBF' class=cna=Keluar=>=SKKeluar= </td>\n </tr>";
echo $lst->TampilkanData();
echo "Halaman : " . $lst->TampilkanHalaman();
}
function DaftarMhsw($mnux, $lnk = '', $keluar = 0)
{
include_once "class/xthlister.class.b.php";
$inqMhswPage = GetSetVar('inqMhswPage');
$arrKey = array('NIM' => 'MhswID', 'Nama' => 'Nama', 'Semua' => '');
// filter
$whr = array();
if (!empty($arrKey[$_SESSION['crmhswkey']]) && !empty($_SESSION['crmhswval'])) {
$whr[] = "m." . $arrKey[$_SESSION['crmhswkey']] . " like '%" . $_SESSION['crmhswval'] . "%' ";
}
if ($keluar > 0) {
$whr[] = "sm.Keluar <> 1";
}
if ($_SESSION['_LevelID'] > 1) {
if (empty($_SESSION['_LevelID'])) {
die(ErrorMsg("Tidak Dapat Akses", "Anda tidak memiliki hak akses ke data Mahasiswa."));
}
$_ProdiID = trim($_SESSION['_ProdiID'], ',');
$arrProdi = explode(',', $_ProdiID);
$_prodi = '';
for ($i = 0; $i < sizeof($arrProdi); $i++) {
$_prodi .= ",'" . $arrProdi[$i] . "'";
}
$_prodi = trim($_prodi, ',');
$_prodi = empty($arrProdi) ? '-1' : $_prodi;
//implode(', ', $arrProdi);
if ($_SESSION['LevelID'] == 100) {
} else {
$whr[] = "m.ProdiID in ({$_prodi})";
}
}
// Satukan filter
$_whr = implode(' and ', $whr);
$_whr = empty($_whr) ? '' : "where {$_whr}";
// Tampilkan daftar
$lst = new xthlister();
$lst->page = $_SESSION['inqMhswPage'] + 0;
$lst->pageactive = "=PAGE=";
$lst->pages = "<a href='?mnux={$lnk}&inqMhswPage==PAGE='>=PAGE=</a>";
$lst->tables = "mhsw m\n left outer join program prg on m.ProgramID=prg.ProgramID\n left outer join prodi prd on m.ProdiID=prd.ProdiID\n left outer join statusmhsw sm on m.StatusMhswID=sm.StatusMhswID\n {$_whr}\n order by m.MhswID";
$lst->fields = "m.MhswID, m.Nama, m.ProgramID, m.ProdiID, m.SKKeluar, m.Foto,\n prg.Nama as PRG, prd.Nama as PRD, sm.Nama as SM, sm.Keluar";
$lst->detailfmt = "\n <tr>\n <td class=inp1>=NOMER=</td>\n </tr>";
echo $lst->TampilkanData();
echo $lst->TampilkanHalaman();
}
function DaftarMhsw($mnux, $lnk = '', $keluar = 0)
{
include_once "class/xthlister.class.php";
$dataMhswPage = GetSetVar('dataMhswPage');
$arrKey = array('NIM' => 'MhswID');
// filter
$whr = array();
if (!empty($arrKey[$_SESSION['crmhswkeyx']]) && !empty($_SESSION['crmhswvalx'])) {
$whr[] = "m." . $arrKey[$_SESSION['crmhswkeyx']] . " like '%" . $_SESSION['crmhswvalx'] . "%' ";
}
if ($_SESSION['_LevelID'] > 1) {
if (empty($_SESSION['_LevelID'])) {
die(ErrorMsg("Tidak Dapat Akses", "Anda tidak memiliki hak akses ke data Mahasiswa."));
}
$_ProdiID = trim($_SESSION['_ProdiID'], ',');
$arrProdi = explode(',', $_ProdiID);
$_prodi = '';
for ($i = 0; $i < sizeof($arrProdi); $i++) {
$_prodi .= ",'" . $arrProdi[$i] . "'";
}
$_prodi = trim($_prodi, ',');
$_prodi = empty($arrProdi) ? '-1' : $_prodi;
//implode(', ', $arrProdi);
if ($_SESSION['LevelID'] == 7) {
} else {
$whr[] = "m.ProdiID in ({$_prodi})";
}
}
// Satukan filter
$_whr = implode(' and ', $whr);
$_whr = empty($_whr) ? '' : "where {$_whr}";
// Tampilkan daftar
$lst = new xthlister();
$lst->tables = "mhsw m\n left outer join program prg on m.ProgramID=prg.ProgramID\n left outer join prodi prd on m.ProdiID=prd.ProdiID\n left outer join statusmhsw sm on m.StatusMhswID=sm.StatusMhswID\n {$_whr}\n order by m.MhswID";
$lst->fields = "m.MhswID,\n prg.Nama as PRG, prd.Nama as PRD, sm.Nama as SM, sm.Keluar";
$lst->headerfmt = "<p>\n <table class=box cellspacing=1 cellpadding=4>\n <tr bgcolor='#9BBB59'>\n <th rowspan='2' nowrap='true' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Tahun Akade-mik</span></strong></th>\n <th rowspan='2' nowrap='true' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Daya Tampung</span></strong></th>\n <th colspan='2' nowrap='true' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Jumlah Calon<br>Mahasiswa Reguler </span></strong></th>\n <th colspan='2' nowrap='true' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Jumlah<br>Mahasiswa Baru</span></strong></th>\n <th colspan='2' nowrap='true' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Jumlah<br>Total Mahasiswa</span></strong></th>\n <th colspan='2' nowrap='true' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Jumlah Lulusan</span></strong></th>\n <th colspan='3' nowrap='true' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>IPK<br>Lulusan Reguler</span></strong></th>\n <th colspan='3' nowrap='true' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Persentase<br>Lulusan Reguler<br>dengan IPK :</span></strong></th>\n </tr>\n <tr>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Ikut Seleksi</span></strong></td>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Lulus Seleksi</span></strong></td>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Reguler</span></strong></td>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Transfer</span></strong></td>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Reguler</span></strong></td>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Transfer</span></strong></td>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Reguler </span></strong></td>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Transfer</span></strong></td>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Min</span></strong></td>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Rat</span></strong></td>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>Mak</span></strong></td>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>< 2,75</span></strong></td>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>2,75-3,50</span></strong></td>\n <td bgcolor='#9BBB59' class='ttl'><strong><span style='line-height:115%; font-family:'Calibri','sans-serif'; font-size:8.0pt; '>> 3,50</span></strong></td>\n </tr>\n <tr bgcolor='#9BBB59'>\n <td class='cna'>(1)</td>\n <td class='cna'>(2)</td>\n <td class='cna'>(3)</td>\n <td class='cna'>(4)</td>\n <td class='cna'>(5)</td>\n <td class='cna'>(6)</td>\n <td class='cna'>(7)</td>\n <td class='cna'>(8)</td>\n <td class='cna'>(9)</td>\n <td class='cna'>(10)</td>\n <td class='cna'>(11)</td>\n <td class='cna'>(12)</td>\n <td class='cna'>(13)</td>\n <td class='cna'>(14)</td>\n <td class='cna'>(15)</td>\n <td class='cna'>(16)</td>\n </tr>\n <tr>\n <td bgcolor='#9BBB59' class='cna'>TS-4</td>\n <td bgcolor='#DDD9C3' class='cna'>\n\t \n\t \n\t </td>\n <td bgcolor='#8DB3E2' class='cna'> </td>\n <td bgcolor='#8DB3E2' class='cna'> </td>\n <td bgcolor='#E5B8B7' class='cna'> </td>\n <td bgcolor='#E5B8B7' class='cna'> </td>\n <td bgcolor='#D6E3BC' class='cna'> </td>\n <td bgcolor='#D6E3BC' class='cna'> </td>\n <td bgcolor='#B2A1C7' class='cna'> </td>\n <td bgcolor='#B2A1C7' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n </tr>\n <tr>\n <td bgcolor='#9BBB59' class='cna'>TS-3</td>\n <td bgcolor='#DDD9C3' class='cna'> </td>\n <td bgcolor='#8DB3E2' class='cna'> </td>\n <td bgcolor='#8DB3E2' class='cna'> </td>\n <td bgcolor='#E5B8B7' class='cna'></td>\n <td bgcolor='#E5B8B7' class='cna'> </td>\n <td bgcolor='#D6E3BC' class='cna'> </td>\n <td bgcolor='#D6E3BC' class='cna'> </td>\n <td bgcolor='#B2A1C7' class='cna'> </td>\n <td bgcolor='#B2A1C7' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n </tr>\n <tr>\n <td bgcolor='#9BBB59' class='cna'>TS-2</td>\n <td bgcolor='#DDD9C3' class='cna'> </td>\n <td bgcolor='#8DB3E2' class='cna'> </td>\n <td bgcolor='#8DB3E2' class='cna'> </td>\n <td bgcolor='#E5B8B7' class='cna'></td>\n <td bgcolor='#E5B8B7' class='cna'> </td>\n <td bgcolor='#D6E3BC' class='cna'> </td>\n <td bgcolor='#D6E3BC' class='cna'> </td>\n <td bgcolor='#B2A1C7' class='cna'> </td>\n <td bgcolor='#B2A1C7' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n </tr>\n <tr>\n <td bgcolor='#9BBB59' class='cna'>TS-1</td>\n <td bgcolor='#DDD9C3' class='cna'> </td>\n <td bgcolor='#8DB3E2' class='cna'> </td>\n <td bgcolor='#8DB3E2' class='cna'> </td>\n <td bgcolor='#E5B8B7' class='cna'></td>\n <td bgcolor='#E5B8B7' class='cna'> </td>\n <td bgcolor='#D6E3BC' class='cna'> </td>\n <td bgcolor='#D6E3BC' class='cna'> </td>\n <td bgcolor='#B2A1C7' class='cna'> </td>\n <td bgcolor='#B2A1C7' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n </tr>\n <tr>\n <td bgcolor='#9BBB59' class='cna'>TS</td>\n <td bgcolor='#DDD9C3' class='cna'><countif></td>\n <td bgcolor='#8DB3E2' class='cna'> </td>\n <td bgcolor='#8DB3E2' class='cna'> </td>\n <td bgcolor='#E5B8B7' class='cna'></td>\n <td bgcolor='#E5B8B7' class='cna'> </td>\n <td bgcolor='#D6E3BC' class='cna'> </td>\n <td bgcolor='#D6E3BC' class='cna'> </td>\n <td bgcolor='#B2A1C7' class='cna'> </td>\n <td bgcolor='#B2A1C7' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#FABF8F' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n <td bgcolor='#BFBFBF' class='cna'> </td>\n </tr>\n <tr>\n <td bgcolor='#9BBB59' class='cna'>Jumlah</td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n <td bgcolor='#9BBB59' class='cna'></td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n <td bgcolor='#9BBB59' class='cna'> </td>\n </tr>";
$lst->footerfmt = "</table></p>";
echo $lst->TampilkanData();
echo "Halaman : " . $lst->TampilkanHalaman();
}
function DaftarDosen($mnux = '', $lnk = '', $fields = '')
{
global $_defmaxrow, $_FKartuUSM;
include_once "class/xthlister.class.php";
//$lnk = "gos=DsnEdt&md=0&dsnid==Login="******"<th class=ttl>" . $_f[$i] . "</th>";
$brs .= "<td class=cna=NA=>=" . $_f[$i] . "= </td>";
}
$whr = array();
if (!empty($_SESSION['dsnkeycr']) && !empty($_SESSION['dsncr'])) {
if ($_SESSION['dsnkeycr'] == 'Login') {
$whr[] = "{$_SESSION['dsnkeycr']} like '{$_SESSION['dsncr']}%'";
} else {
$whr[] = "{$_SESSION['dsnkeycr']} like '%{$_SESSION['dsncr']}%'";
}
}
$where = implode(' and ', $whr);
$where = empty($where) ? '' : "and {$where}";
$hom = empty($_SESSION['prodi']) ? '' : "and Homebase = '{$_SESSION['prodi']}'";
$lst = new xthlister();
$lst->maxrow = 20;
$lst->page = $_SESSION['dsnpage'] + 0;
$lst->pageactive = "=PAGE=";
$lst->pages = "<a href='?mnux={$mnux}&gos=&dsnpage==PAGE='>=PAGE=</a>";
$lst->tables = "dosen\n where KodeID='{$_SESSION['KodeID']}' {$where} {$hom}\n order by {$_SESSION['dsnurt']}";
$lst->fields = "* ";
$lst->headerfmt = "<p><table class=box cellspacing=1 cellpadding=4>\n <tr>\n\t <th class=ttl>#</th>\n\t <th class=ttl>Login/NIP</th>\n {$hdr}\n\t <th class=ttl>NA</th>\n </tr>";
$lst->detailfmt = "<tr>\n\t <td class=inp1 width=18 align=right>=NOMER=</td>\n <td class=cna=NA=><a href=\"?mnux={$mnux}&{$lnk}\"><img src='img/edit.png' border=0>\n =Login=</a></td>\n {$brs}\n\t <td class=cna=NA= align=center><img src='img/book=NA=.gif'></td>\n\t </tr>";
$lst->footerfmt = "</table></p>";
echo $lst->TampilkanData();
$halaman = $lst->TampilkanHalaman();
$total = $lst->MaxRowCount;
$total = number_format($total);
echo "<p>Halaman : " . $halaman . "<br />" . "Total: " . $total . "</p>";
}
function DaftarAntriDosen()
{
include_once "class/xthlister.class.php";
$AntrianIDPage = GetSetVar('AntrianIDPage');
$arrKey = array('NIM' => 'nim', 'Nama' => 'nama', 'Semua' => '');
// filter
$whr = array();
// Satukan filter
$_whr = implode(' and ', $whr);
$_whr = empty($_whr) ? '' : "where {$_whr}";
// Tampilkan daftar
$lst = new xthlister();
$lst->page = $_SESSION['AntrianIDPage'] + 0;
$lst->pageactive = "=PAGE=";
$lst->pages = "=PAGE=";
$lst->tables = "antridosenid d\n left outer join prodi prd on d.ProdiID=prd.ProdiID\n {$_whr}\n order by d.Login";
$lst->fields = "d.Login, d.Nama, d.LevelID, d.KodeID, d.Password, d.ProdiID, d.Foto";
$lst->headerfmt = "<p><table class=box cellspacing=1 cellpadding=4>\n <tr><th class=ttl>#</th>\n <th class=ttl>NIP</th>\n <th class=ttl>Nama Dosen</th>\n <th class=ttl>Prodi</th>\n <th class=ttl>Konfirmasi</th>\n </tr>";
$lst->footerfmt = "</table></p>";
$lst->detailfmt = "<tr><td>=NOMER=</td>\n <td bgcolor='#9BBB59' class=cna=Keluar=>=Login=</td>\n <td bgcolor='#8DB3E2' class=cna=Keluar=>=Nama=</td>\n <td bgcolor='#B2A1C7' class=cna=Keluar=>=ProdiID=</td>\n <td bgcolor='#BFBFBF' class=cna=Keluar=>\n\t\n\t\t<form action='?' method='post'>\n\t\t<input type=hidden name='mnux' value='modules/antrianid/antrianid.dosen'>\n\t\t <input type=hidden name='gos' value='UsrSav'>\n\t\t\n\t\t<input type='hidden' name='Login' value='=Login='******'hidden' name='Nama' value='=Nama='>\n\t\t<input type='hidden' name='Password' value='=Password='******'hidden' name='lvlid' value='=LevelID='>\n\t\t<input type='hidden' name='kid' value='=KodeID='>\n\t\t\n\t\t<input type='submit' class='btn light' value='Simpan' name='Salin'>\n\t\t</form>\n\t\t\n\t</td>\n </tr>";
echo $lst->TampilkanData();
echo "Halaman : " . $lst->TampilkanHalaman();
}
function DaftarAntriMhsw1()
{
include_once "class/xthlister.class.php";
$AntrianIDPage = GetSetVar('AntrianIDPage');
$arrKey = array('NIM' => 'nim', 'Nama' => 'nama', 'Semua' => '');
// filter
$whr = array();
// Satukan filter
$_whr = implode(' and ', $whr);
$_whr = empty($_whr) ? '' : "where {$_whr}";
// Tampilkan daftar
$lst = new xthlister();
$lst->page = $_SESSION['AntrianIDPage'] + 0;
$lst->pageactive = "=PAGE=";
$lst->pages = "=PAGE=";
$lst->tables = "antrimhswid a\n left outer join program prg on a.ProgramID=prg.ProgramID\n left outer join prodi prd on a.ProdiID=prd.ProdiID\n left outer join statusmhsw sm on a.StatusMhswID=sm.StatusMhswID\n {$_whr}\n order by a.MhswID";
$lst->fields = "a.MhswID, a.Nama, a.LevelID, a.KodeID, a.Password, a.ProgramID, a.ProdiID, a.SKKeluar, a.Foto,\n sm.Keluar";
$lst->headerfmt = "<p><table class=box cellspacing=1 cellpadding=4>\n <tr><th class=ttl>#</th>\n <th class=ttl>No Mhsw</th>\n <th class=ttl>Nama Mhsw</th>\n <th class=ttl>Program</th>\n <th class=ttl>Prodi</th>\n </tr>";
$lst->footerfmt = "</table></p>";
$lst->detailfmt = "<tr><td>=NOMER=</td>\n <td bgcolor='#9BBB59' class=cna=Keluar=>=MhswID=</td>\n <td bgcolor='#8DB3E2' class=cna=Keluar=>=Nama=</td>\n <td bgcolor='#E5B8B7' class=cna=Keluar=>=ProgramID=</td>\n <td bgcolor='#B2A1C7' class=cna=Keluar=>=ProdiID=</td>\n\t</form>\n\t\t\n\t</td>\n </tr>";
echo $lst->TampilkanData();
echo "Halaman : " . $lst->TampilkanHalaman();
}
function DaftarAntri()
{
include_once "class/xthlister.class.php";
$DaftarAntrianPage = GetSetVar('DaftarAntrianPage');
$arrKey = array('NIM' => 'nim', 'Nama' => 'nama', 'Semua' => '');
// filter
$whr = array();
// Satukan filter
$_whr = implode(' and ', $whr);
$_whr = empty($_whr) ? '' : "where {$_whr}";
// Tampilkan daftar
$lst = new xthlister();
$lst->page = $_SESSION['DaftarAntrianPage'] + 0;
$lst->pageactive = "=PAGE=";
$lst->pages = "=PAGE=";
$lst->tables = "antrian a {$_whr} order by a.lastmodified";
$lst->fields = "a.nim, a.nama, a.jenis, a.judul, a.kodjenis";
$lst->headerfmt = "<p><table class=box cellspacing=1 cellpadding=4 width='100%'>\n <tr>\n\t<th class=ttl>#</th>\n <th class=ttl>NIM</th>\n <th class=ttl>Nama Mahasiswa</th>\n <th class=ttl>Jenis Surat</th>\n <th class=ttl>Judul Surat</th>\n <th class=ttl>Kode Jenis</th>\n <th class=ttl>Print</th>\n </tr>";
$lst->footerfmt = "</table></p>";
$lst->detailfmt = "<tr>\n\t<td>=NOMER=</td>\n <td bgcolor='#9BBB59' class=cna=Keluar=>=nim=</td>\n <td bgcolor='#8DB3E2' class=cna=Keluar=>=nama=</td>\n <td bgcolor='#E5B8B7' class=cna=Keluar=>=jenis=</td>\n <td bgcolor='#B2A1C7' class=cna=Keluar=>=judul=</td>\n <td bgcolor='#FABF8F' class=cna=Keluar=>=kodjenis=</td>\n <td bgcolor='#BFBFBF' class=cna=Keluar=>\n\t\t<form action='modules/cetak.php' method='post' target='_parent'>\n\t\t<input type='hidden' name='cetak_id' value='nim'>\n\t\t<input type='submit' value='Print'>\n\t\t</form>\n\t</td>\n </tr>";
echo $lst->TampilkanData();
echo "Halaman : " . $lst->TampilkanHalaman();
}
function DaftarMhsw()
{
// setup where-statement
$whr = array();
$ord = '';
$strwhr = '';
if ($_SESSION['srcmhswkey'] != 'Reset' && !empty($_SESSION['srcmhswkey']) && !empty($_SESSION['srcmhswval'])) {
$whr[] = "m.{$_SESSION['srcmhswkey']} like '%{$_SESSION['srcmhswval']}%' ";
$ord = "order by m.{$_SESSION['srcmhswkey']}";
}
if (!empty($_SESSION['prodi'])) {
$whr[] = "m.ProdiID='{$_SESSION['prodi']}'";
}
if (!empty($_SESSION['prid'])) {
$whr[] = "m.ProgramID='{$_SESSION['prid']}'";
}
if (!empty($whr)) {
$strwhr = "where " . implode(' and ', $whr);
}
$strwhr = str_replace('NIM', "MhswID", $strwhr);
$ord = str_replace('NIM', "MhswID", $ord);
// Tampilkan
include_once "class/xthlister.class.php";
$lst = new xthlister();
$lst->maxrow = 20;
$lst->page = $_SESSION['mhswpage'] + 0;
$lst->pageactive = "=PAGE=";
$lst->pages = "<a href='?mnux=mhsw&mhswpage==PAGE='>=PAGE=</a>";
$lst->tables = "mhsw m\n left outer join prodi prd on m.ProdiID=prd.ProdiID\n left outer join statusmhsw sm on m.StatusMhswID=sm.StatusMhswID\n {$strwhr} {$ord}";
$lst->fields = "m.MhswID, m.Nama, m.StatusAwalID, m.StatusMhswID,\n m.Telepon, m.Handphone, m.Email, m.Foto,\n m.ProgramID, m.ProdiID, m.Alamat, m.Kota,\n prd.Nama as PRD, sm.Nama as SM, sm.Keluar";
$lst->headerfmt = "<p><table class=box cellspacing=1 cellpadding=4>\n <tr><th class=ttl>No.</th>\n <th class=ttl>NIM</th>\n <th class=ttl>Nama</th>\n <th class=ttl>Program Studi</th>\n <th class=ttl>Status</th>\n <th class=ttl>Telp/HP</th>\n <th class=ttl>Alamat</th>\n </tr>";
$lst->footerfmt = "</table></p>";
$lst->detailfmt = "<tr>\n <td class=inp1>=NOMER=</td>\n <td class=cna=Keluar=><a href='?mnux=mhsw.edt&gos=MhswEdt&mhswid==MhswID='><img src='img/edit.png'>\n =MhswID=</a></td>\n <td class=cna=Keluar= nowrap><a id='=MhswID=' class='jTip' name='Foto Mahasiswa' href='foto.pop.php?width=156&mhswid==MhswID=&foto==Foto='>=Nama=</a></td>\n <td class=cna=Keluar=>=ProgramID= - =PRD=</td>\n <td class=cna=Keluar=>=SM=</td>\n <td class=cna=Keluar=>=Telepon=/=Handphone=</td>\n <td class=cna=Keluar=>=Alamat=, =Kota=</td>\n </tr>";
echo $lst->TampilkanData();
echo $ttl;
echo "<p>Hal.: " . $lst->TampilkanHalaman() . "<br />" . "Total: " . number_format($lst->MaxRowCount) . "</p>";
}
function TampilDetailPendidikan()
{
include_once "class/xthlister.class.php";
$lst = new xthlister();
$lst->maxrow = 10;
$lst->page = $_SESSION['dsnpage'] + 0;
$lst->pageactive = "=PAGE=";
$lst->pages = "<a href='?mnux=dosen&gos=&dsnpage==PAGE='>=PAGE=</a>";
$lst->tables = "dosenpendidikan left outer join perguruantinggi pt on pt.PerguruanTinggiID = dosenpendidikan.PerguruanTinggiID \n \t\t\t\t left outer join jenjang j on j.JenjangID = dosenpendidikan.JenjangID\n where DosenID='{$_SESSION['dsnid']}' {$where}\n order by dosenpendidikan.jenjangID";
$lst->fields = "dosenpendidikan.*, pt.Nama as Nama, j.Nama as jnama ";
$lst->headerfmt = "<p><table class=box cellspacing=1 cellpadding=4>\n \t<tr>\n\t <th class=ttl>#</th>\n\t <th class=ttl>Detail</th>\n\t <th class=ttl>Gelar</th>\n\t <th class=ttl>Jenjang</th>\n\t <th class=ttl>Tanggal Lulus Ijazah</th>\n\t <th class=ttl>Nama Perguruan Tinggi</th>\n\t <th class=ttl>Negara</th>\n\t <th class=ttl>Bidang Ilmu</th>\n\t <th class=ttl>NA</th>\n </tr>";
$lst->detailfmt = "<tr>\n\t <td class=inp1 width=18 align=right>=NOMER=</td>\n <td class=cna=NA=><a href=\"?mnux=modules/inq.dosen&gos=DsnDetail&dsnid={$_SESSION['dsnid']}&dsndtl=DtlPendidikan\"><img src='img/edit.png' border=0>\n </a></td>\n\t <td class=cna=NA= nowrap>=Gelar=</a></td>\n\t <td class=cna=NA=>=jnama=</td>\n\t <td class=cna=NA=>=TanggalIjazah=</td>\n\t <td class=cna=NA=>=Nama=</td>\n\t <td class=cna=NA=>=NamaNegara=</td>\n\t <td class=cna=NA=>=BidangIlmu=</td>\n\t <td class=cna=NA= align=center><img src='img/book=NA=.gif'></td>\n\t </tr>";
$lst->footerfmt = "</table></p>";
echo $lst->TampilkanData();
$halaman = $lst->TampilkanHalaman();
$total = $lst->MaxRowCount;
$total = number_format($total);
echo "<p>Halaman : " . $halaman . "<br />" . "Total: " . $total . "</p>";
}
function DsnEdtPengajaran()
{
$dsnajarpage = GetSetVar('dsnajarpage', 1);
$lst = new xthlister();
$lst->maxrow = 20;
$lst->page = $_SESSION['dsnajarpage'] + 0;
$lst->pageactive = "=PAGE=";
$lst->pages = "<a href='?mnux=modules/dosen&gos=DsnEdt&dsnajarpage==PAGE='>=PAGE=</a>";
$lst->tables = "jadwal j\n left outer join hari h on j.HariID=h.HariID\n where j.DosenID='{$_SESSION['dsnid']}'\n order by j.TahunID, j.HariID, j.JamMulai desc";
//$NamaPT = GetaField('perguruantinggi','PerguruanTinggiID','=PerguruanTinggiID=','Nama');
$lst->fields = "j.TahunID, j.MKKode, j.MKID, j.Nama, j.NamaKelas, j.JenisJadwalID, h.Nama as HR,\n j.JamMulai, j.JamSelesai ";
$lst->headerfmt = "<p><table class=box cellspacing=1 cellpadding=4>\n <tr><th class=ttl>#</th>\n <th class=ttl>Tahun</th>\n <th class=ttl>Kode</th>\n <th class=ttl>Matakuliah</th>\n <th class=ttl>Kelas</th>\n <th class=ttl>Jenis</th>\n <th class=ttl>Hari</th>\n <th class=ttl>Jam</th>\n </tr>";
$lst->detailfmt = "<tr>\n\t <td class=inp1 width=18 align=right>=NOMER=</td>\n\t <td class=ul>=TahunID=</td>\n\t <td class=ul>=MKKode=</td>\n\t <td class=ul>=Nama=</td>\n\t <td class=ul>=NamaKelas=</td>\n\t <td class=ul>=JenisJadwalID=</td>\n\t <td class=ul>=HR=</td>\n\t <td class=ul>=JamMulai= ~ =JamSelesai=</td>\n\t </tr>";
$lst->footerfmt = "</table></p>";
echo $lst->TampilkanData();
$halaman = $lst->TampilkanHalaman();
$total = $lst->MaxRowCount;
$total = number_format($total);
echo "<p>Halaman : " . $halaman . "<br />" . "Total: " . $total . "</p>";
}
