function CariNama()
{
$gelombang = GetaField('pmbperiod', "KodeID='" . KodeID . "' and NA", 'N', "PMBPeriodID");
TampilkanJudul("List Nama yang Cocok");
if (empty($_REQUEST['PFJ_TGL_y']) and empty($_REQUEST['PFJ_TGL_m']) and empty($_REQUEST['PFJ_TGL_d'])) {
$checktanggal = '';
} else {
$temptanggal = "{$_REQUEST['PFJ_TGL_y']}-{$_REQUEST['PFJ_TGL_m']}-{$_REQUEST['PFJ_TGL_d']}";
$checktanggal = "and TanggalLahir='{$temptanggal}'";
}
$s = "select * from `aplikan` where Nama LIKE '%{$_REQUEST['n']}%' {$checktanggal}";
//echo "Select: $s";
$r = _query($s);
$n = _num_rows($r);
if (empty($_REQUEST['PFJ_TGL_y'])) {
$temptahun = date('Y') - 19;
$opttanggal = GetDateOption("{$temptahun}-{$_REQUEST['PFJ_TGL_m']}-{$_REQUEST['PFJ_TGL_d']}", 'PFJ_TGL');
} else {
$opttanggal = GetDateOption("{$_REQUEST['PFJ_TGL_y']}-{$_REQUEST['PFJ_TGL_m']}-{$_REQUEST['PFJ_TGL_d']}", 'PFJ_TGL');
}
echo "<p><table class=box cellspacing=1 align=center>\r\n\t\t\t<form action='?' method=POST>\r\n\t\t\t\t<input type=hidden name='mnux' value='{$_SESSION['mnux']}'/>\r\n\t\t\t\t<input type=hidden name='gos' value='CariNama' />\r\n\t\t\t\t<input type=hidden name='id' value='{$_REQUEST['id']}' />\r\n\t\t\t\t<input type=hidden name='gel' value='{$_REQUEST['gel']}' />\r\n\t\t\t\t<input type=hidden name='n' value='{$_REQUEST['n']}' />\r\n\t\t\t\t\r\n\t\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Filter Tanggal Lahir: </td>\r\n\t\t\t\t<td class=ul1>{$opttanggal}</td>\r\n\t\t\t\t<td class=ul1><input type=submit name='CariTanggal' value='Filter Tanggal'></td>\r\n\t\t\t\t</tr>\r\n\t\t\t</form>\r\n\t\t</table></p>\r\n\t\t";
echo "<p><table class=box cellspacing=1 align=center width=100%>\r\n\t\t\t<form action='?' method=POST>\r\n\t\t\t\t<input type=hidden name='mnux' value='{$_SESSION['mnux']}'/>\r\n\t\t\t\t<input type=hidden name='gos' value='SelesaiCari' />\r\n\t\t\t\t<input type=hidden name='id' value='{$_REQUEST['id']}' />\r\n\t\t\t\t<input type=hidden name='gel' value='{$_REQUEST['gel']}' />\r\n\t\t\t\t";
echo "<tr>\r\n\t\t\t<td class=ul1 colspan=8><sub>Nama Filter Aktif: {$_REQUEST['n']}</sub></td>\r\n\t\t </tr>\r\n\t\t <tr>\r\n\t\t\t<td class=ul1 colspan=8><sub>Tanggal Filter Aktif: {$_REQUEST['PFJ_TGL_y']}-{$_REQUEST['PFJ_TGL_m']}-{$_REQUEST['PFJ_TGL_d']}<sub></td>\r\n\t\t </tr>";
echo "<tr>\r\n\t\t\t<th class=ttl width=15>Pilih</th>\r\n\t\t\t<th class=ttl width=30>No. Aplikan</th>\r\n\t\t\t<th class=ttl>Nama</th>\r\n\t\t\t<th class=ttl width=15>Kelamin</th>\r\n\t\t\t<th class=ttl width=30>Tempat<br> Lahir</th>\r\n\t\t\t<th class=ttl width=30>Tgl. Lahir</th>\r\n\t\t\t<th class=ttl width=50>Alamat</th>\r\n\t\t\t<th class=ttl width=20>Kota</th>\r\n\t\t\t<th class=ttl width=10>Kode<br>Pos</th>\r\n\t\t\t<th class=ttl width=20>Status</th>\r\n\t\t</tr>";
while ($w = _fetch_array($r)) {
$FormulirID = GetAField('pmbformjual', "PMBPeriodID='{$gelombang}' and AplikanID", $w[AplikanID], 'PMBFormJualID');
//if($w['PMBID']=='' or !isset($w['PMBID']) )
if (empty($FormulirID) or $FormulirID == '') {
echo "<tr>\r\n\t\t\t\t<td class=ul1><input type=checkbox name='pilihan[]' value='{$w['AplikanID']}' \r\n\t\t\t\t\tonChange='this.form.submit()' /></td>\r\n\t\t\t\t";
$Status = "";
} else {
echo "<tr bgcolor='#D3D3D3'>\r\n\t\t\t\t<td class=ul1 align=center>×</td>\r\n\t\t\t\t";
$Status = "SUDAH MEMBELI";
}
echo "\t<td class=ul1 align=center>{$w['AplikanID']}</td>\r\n\t\t\t\t<td class=ul1>{$w['Nama']}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$w['Kelamin']}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$w['TempatLahir']}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$w['TanggalLahir']}</td>\r\n\t\t\t\t<td class=ul1>{$w['Alamat']}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$w['Kota']}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$w['KodePos']}</td>\r\n\t\t\t\t<td class=ul1 align=center><b>{$Status}</b></td>\r\n\t\t\t</tr>";
}
echo "<tr>\r\n\t\t\t<td class=ul1 colspan=8 align=center><input type=button name='Batal' value='Batal'\r\n\t\t\t\tonClick=\"window.close()\" /> \r\n\t\t\t</td>\r\n\t\t\t</tr>";
echo "</form>\r\n\t\t</table></p>";
}
function CetakSuratRekomendasi($pmb, $gelombang, $NomerSurat, $pdf)
{
$NomerSurat = GetaField('pmb', "PMBID='{$pmb['PMBID']}' and KodeID", KodeID, 'NomerSurat');
if (empty($NomerSurat)) {
$NomerSurat = GetNextNomerNomerSurat($gelombang['PMBPeriodID'], $pmb['PMBID']);
}
$tahun = $gelombang['Tahun'];
$tahunnext = $tahun + 1;
$identitas = getFields('identitas', "Kode", KodeID, '*');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => "<b>No : {$NomerSurat}</b>");
$db_data[] = array('Isi' => '<b>Perihal : Pengumuman Hasil Seleksi</b>');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => 'Kepada Yth.');
$db_data[] = array('Isi' => '<b>Sdr/i ' . $pmb[Nama] . '</b>');
$db_data[] = array('Isi' => 'Di Tempat');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => 'Dengan Hormat,');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => "Dengan ini kami sampaikan bahwa berdasarkan Hasil Seleksi Ujian masuk Tahun Ajaran / Akademik {$tahun}/{$tahunnext} " . $identitas[Nama] . " pada tanggal " . GetDateInWords($gelombang['UjianMulai']) . ", maka saudara yang namanya tersebut di atas dinyatakan :");
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => ' <b>LULUS</b>');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => 'Selanjutnya saudara/i diberikan kesempatan belajar di ' . $identitas[Nama] . ' dan diwajibkan untuk:');
$db_data[] = array('Isi' => " a. Melakukan Pendaftaran Ulang di Kampus " . $identitas[Nama] . " paling lambat s/d tanggal " . GetDateInWords($gelombang['BayarSelesai']) . "");
$db_data[] = array('Isi' => ' b. Menyelesaikan Administrasi dan mengambil Slip Pembayaran di ' . $identitas[Nama] . '');
$db_data[] = array('Isi' => " c. Segera mengisi / mengambil KRS (Kartu Rencana Studi) Semester I {$tahun}/{$tahunnext} di Administrasi / Akademik " . $identitas[Nama] . "");
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => 'Bila memerlukan informasi dan pelayanan akademik dapat menghubungi :');
$db_data[] = array('Isi' => '<b>Telp ' . $identitas[Telepon] . '</b>');
$db_data[] = array('Isi' => '');
$KotaIdentitas = GetaField('identitas', "Kode", KodeID, 'Kota');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => "{$KotaIdentitas}, " . GetDateInWords(date('Y-m-d')));
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => '');
$db_data[] = array('Isi' => '');
$PejabatAkademik = GetAField('pejabat', "KodeJabatan='KABAA' and KodeID", KodeID, "Nama");
$db_data[] = array('Isi' => "<b>{$PejabatAkademik}</b>");
$db_data[] = array('Isi' => 'Bagian Akademik');
$col_names = array('Isi' => '');
$title = '';
$rowoptions = array('width' => 500, 'lineCol' => array(1, 1, 1), 'innerLineThickness' => 0, 'outerLineThickness' => 0, 'shaded' => 0, 'rowGap' => 0, 'fontSize' => 12);
$pdf->ezTable($db_data, $col_names, $title, $rowoptions);
}
function fnDaftarkanPMB()
{
$id = sqling($_REQUEST['id']);
$gel = sqling($_REQUEST['gel']);
$a = GetFields('aplikan', "AplikanID", $id, '*');
if (empty($a)) {
echo ErrorMsg("Error", "Data aplikan tidak ditemukan.<br />\r\n Hubungi Sysadmin untuk informasi lebih lanjut.\r\n <hr size=1 color=silver />\r\n <input type=button name='btnKembali' value='Kembali'\r\n onClick=\"location='?mnux={$_SESSION['mnux']}&gos='\" />");
} else {
$FormulirID = GetAField('pmbformjual', 'AplikanID', $id, 'PMBFormulirID');
if (empty($FormulirID)) {
echo ErrorMsg("Gagal", "Aplikan belum membeli formulir.<br> Data tidak disimpan. <br>\r\n\t\t\t\t\t\t\t<input type=button name='Kembali' value='Kembali'\r\n\t\t\t\t\t\t\t\tonClick=\"javascript:history.go(-1)\" />");
} else {
$PMBID = GetNextPMBID($gel);
$arrayPilihan = explode(',', $a['Pilihan1']);
$arrayPilihan2 = explode(',', $a['Pilihan2']);
$arrayGabung = array();
foreach ($arrayPilihan as $pilih) {
if (!empty($pilih)) {
$arrayGabung[] = $pilih;
}
}
foreach ($arrayPilihan2 as $pilih) {
if (!empty($pilih)) {
$arrayGabung[] = $pilih;
}
}
$s = "insert into pmb\r\n (PMBID, PMBPeriodID, KodeID, AplikanID,\r\n Nama, StatusAwalID, Kelamin, Pilihan1, Pilihan2, ProgramID, \r\n TempatLahir, TanggalLahir, Agama, PMBFormulirID, PMBFormJualID, \r\n Alamat, Kota, RT, RW, KodePos, Propinsi, Negara,\r\n Telepon, Handphone, Email, \r\n PendidikanTerakhir, AsalSekolah, JenisSekolahID,\r\n AlamatSekolah, KotaSekolah, JurusanSekolah,\r\n NilaiSekolah, TahunLulus,\r\n LoginBuat, TanggalBuat)\r\n values\r\n ('{$PMBID}', '{$gel}', '" . KodeID . "', '{$a['AplikanID']}',\r\n '{$a['Nama']}', 'B', '{$a['Kelamin']}', '{$arrayGabung['0']}', '{$arrayGabung['1']}', '{$a['ProgramID']}',\r\n '{$a['TempatLahir']}', '{$a['TanggalLahir']}', '{$a['Agama']}', '{$a['PMBFormulirID']}', '{$a['PMBFormJualID']}',\r\n '{$a['Alamat']}', '{$a['Kota']}', '{$a['RT']}', '{$a['RW']}', '{$a['KodePos']}', '{$a['Propinsi']}', '{$a['Negara']}',\r\n '{$a['Telepon']}', '{$a['Handphone']}', '{$a['Email']}',\r\n '{$a['PendidikanTerakhir']}', '{$a['AsalSekolah']}', '{$a['JenisSekolahID']}',\r\n '{$a['AlamatSekolah']}', '{$a['KotaSekolah']}', '{$a['JurusanSekolah']}',\r\n '{$a['NilaiSekolah']}', '{$a['TahunLulus']}',\r\n '{$_SESSION['_Login']}', now())";
$r = _query($s);
// Set Status Aplika menjadi DFT
SetStatusAplikan('DFT', $a['AplikanID']);
// Tampilkan pesan //$_pmbNomer
echo Konfirmasi("Proses Selesai", "Proses pendaftaran Aplikan ke PMB telah selesai.<br />\r\n Nomer PMB: <font size=+1>{$PMBID}</font>\r\n <hr size=1 color=silver /> \r\n <input type=button name='btnKembali' value='Kembali'\r\n onClick=\"window.location='?mnux={$_SESSION['mnux']}&gos='\" />\r\n <input type=button name='btnDataPMB' value='{$PMBID}'\r\n onClick=\"location='?mnux=pmb/pmbform&gos=&_pmbNomer={$PMBID}'\" /> (klik untuk masuk ke data PMB).<br />\r\n ");
// Reload
$tmr = 10000;
$_tmr = $tmr / 1000;
echo <<<SCR
<p align=center>
<font color=red>Jika dalam {$_tmr} detik tidak ada respons,<br />
maka sistem akan mengembalikan ke modul presenter.</font>
<script>
window.onload=setTimeout("window.location='?mnux={$_SESSION['mnux']}&gos='", {$tmr});
</script>
SCR;
}
}
}
