function TampilkanIsinya($gel, $id, $p)
{
$t = 6;
$Kolom1 = 50;
$Kolom2 = 3;
$Kolom3 = 100;
$aplikan = GetFields('aplikan', "AplikanID='{$id}' and KodeID", KodeID, "*");
$p->SetFont('Helvetica', '', 11, 'C');
$p->Cell($Kolom1, $t, 'Aplikan ID', 0, 0);
$p->Cell($Kolom2, $t, ':', 0, 0, 'C');
$p->Cell($Kolom3, $t, $aplikan['AplikanID'], 0, 0);
$p->Ln($t);
$p->Cell($Kolom1, $t, 'Nama', 0, 0);
$p->Cell($Kolom2, $t, ':', 0, 0, 'C');
$p->Cell($Kolom3, $t, $aplikan['Nama'], 0, 0);
$p->Ln($t);
$p->Cell($Kolom1, $t, 'Tanggal Lahir', 0, 0);
$p->Cell($Kolom2, $t, ':', 0, 0, 'C');
$p->Cell($Kolom3, $t, GetDateInWords($aplikan['TanggalLahir']), 0, 0);
$p->Ln($t);
$p->Ln($t);
$p->SetFont('Helvetica', 'B', 11, 'C');
$p->Cell(0, $t, 'Catatan: Password default untuk aplikan baru adalah Tanggal Lahir yang tertera.', 0, 0);
$p->Ln($t);
$p->Cell(0, $t, ' Masukkan password dengan format TTTT-BB-HH. Contoh: 1999-12-31 untuk 31 Desember 1999', 0, 0);
$p->Ln($t);
}
function Isinya($p)
{
$lbr = 290;
$t = 5;
JudulKolomnya($p);
$p->SetFont('Helvetica', '', 8);
$s = "select k.*, m.MhswID,left(m.Nama, 28) as Mhsw,m.KelasID\r\n \t\tfrom kompre k\r\n left outer join mhsw m on m.MhswID = k.MhswID and m.KodeID = '" . KodeID . "'\r\n\twhere k.KodeID = '" . KodeID . "'\r\n and k.TahunID = '{$_SESSION['TahunID']}'\r\n\t and k.Lulus = 'N'\r\n\t and k.NA = 'N'\r\n Group by k.MhswID";
$r = _query($s);
$n = 0;
$jum = _num_rows($r);
while ($w = _fetch_array($r)) {
$hari = AmbilHari($w[_Hari]);
$n++;
$ss = "select k.*, LEFT(k.JamMulai, 5) as JM, LEFT(k.JamSelesai, 5) as JS, d.Nama as _Dosen\r\n\t\tfrom kompredosen k left outer join dosen d on k.DosenID=d.Login \r\n\t\twhere k.KompreID = '{$w['KompreID']}' and k.NA = 'N'\r\n\t\torder by k.Tanggal, k.JamMulai, k.JamSelesai";
$qq = _query($ss);
$nn = _num_rows($qq);
$tt = $nn * $t;
$p->Cell(5, $tt, '', '', 0);
$p->Cell(8, $tt, $n, 1, 0);
$p->Cell(20, $tt, $w['MhswID'], 1, 0);
$p->Cell(60, $tt, $w['Mhsw'], 1, 0);
while ($ww = _fetch_array($qq)) {
$p->Cell(40, $t, $ww['_Dosen'], 1, 0);
$p->Cell(55, $t, GetDateInWords($ww['Tanggal']) . " / " . $ww['JM'] . " - " . $ww['JS'] . " / " . $ww['RuangID'], 1, 1);
$p->Cell(93);
}
//$p->Cell(55, $t, '', 'T', 0);
$p->SetX(10);
}
$bulan = AmbilBulan(date('m'));
$p->Ln($t);
$identitas = GetFields('identitas', 'Kode', KodeID, "*");
$pejabat = GetFields('pejabat', "KodeJabatan='KABAA' and KodeID", KodeID, 'Nama, Jabatan');
$p->Cell(5, $t, '', '', 0);
$p->Cell(50, $t, $identitas['Kota'] . ', ' . date('d') . " " . $bulan . " " . date('Y'), '', 0, 'C');
$p->Ln($t * 4);
$p->Cell(50, $t, $pejabat[Nama], 0, 0, 'C');
$p->Ln($t);
$p->Cell(50, $t, $pejabat[Jabatan], 0, 0, 'C');
}
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 BuatFooternya($p)
{
$t = 6;
$identitas = GetFields('identitas', 'Kode', KodeID, '*');
$p->SetFont('Helvetica', 'B', 10);
$p->Ln($t);
$p->Ln($t);
$p->Cell(175);
$p->Cell(50, $t, $identitas['Kota'] . ', ' . GetDateInWords(date('Y-m-d')), 0);
$p->Ln($t);
$BAAK = GetFields('pejabat', "KodeJabatan='KABAA' and KodeID", KodeID, "*");
$Ketua = GetFields('pejabat', "KodeJabatan='KETUA' and KodeID", KodeID, "*");
$p->Cell(175, $t, $BAAK['Jabatan'], 0, 0);
$p->Cell(50, $t, $Ketua['Jabatan'], 0, 0);
$p->Ln($t);
$p->Ln($t);
$p->Ln($t);
$p->Ln($t);
$p->Cell(175, $t, $BAAK['Nama'], 0, 0);
$p->Cell(50, $t, $Ketua['Nama'], 0, 0);
}
function CekTanggal($w, $id, $prd)
{
$pmbperiod = GetFields('pmbperiod', "PMBPeriodID='{$w['PMBPeriodID']}' and KodeID", KodeID, "*");
$a = '';
include_once "../util.lib.php";
// Cek Tanggal Ujian
echo "Bandingkan: {$w['TanggalUjian']} dan {$pmbperiod['WawancaraMulai']}<br>";
if (strtotime($w['TanggalUjian']) < strtotime($pmbperiod['WawancaraMulai']) or strtotime($pmbperiod['WawancaraSelesai']) < strtotime($w['TanggalUjian'])) {
$a .= "<li>\r\n\t\t\t\t<b> Tanggal Ujian berada di luar rentang waktu yang disediakan untuk penjadwalan Wawancara </b><br>\r\n\t\t\t\t<table class=bsc width=400>\r\n\t\t\t\t\t<tr><td class=inp width=150>Tanggal Jadwal Wawancara Gagal:</td>\r\n\t\t\t\t\t<td class=ul1>" . GetDateInWords($w['TanggalUjian']) . "</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr><td class=inp width=150>Rentang Waktu Wawancara:</td>\r\n\t\t\t\t\t<td class=ul1>" . GetDateInWords($pmbperiod['UjianMulai']) . " - " . GetDateInWords($pmbperiod['UjianSelesai']) . "</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>\r\n\t\t\t </li>";
}
return $a;
}
<td width="584" style="text-align:left;padding-left:5px;"><b>TOTAL YANG HARUS DIBAYARKAN : </b></td>
<td width="95" style="text-align:right;padding-right:5px;"><b>' . number_format($Total, 0, ',', '.') . '</b></td>
</tr>
</table>
';
$identitas = GetFields('identitas', 'Kode', KodeID, '*');
$rekening = GetFields('rekening', "Def='Y' and KodeID", KodeID, '*');
$current_date = date('Y-m-d');
$content .= '
<br>
<table class="tidakgaris">
<tr>
<td width="220">PEMBAYARAN DG TRANSFER KIRIM KE : </td>
<td width="250" class="tengah">TANDA TERIMA TAGIHAN</td>
<td>' . strtoupper($identitas['Kota']) . ',' . strtoupper(GetDateInWords($current_date)) . '</td>
</tr>
<tr>
<td> BANK ' . strtoupper($rekening['Bank']) . ',' . strtoupper($rekening['Cabang']) . '</td>
<td></td>
<td></td>
</tr>
<tr>
<td>NO REK :' . $rekening['RekeningID'] . '</td>
<td></td>
<td></td>
</tr>
<tr>
<td>AN. ' . strtoupper($rekening['Nama']) . '</td>
<td class="tengah">(.......................................)</td>
<td></td>
';
$identitas = GetFields('identitas', 'Kode', KodeID, '*');
$rekening = GetFields('rekening', "Def='Y' and KodeID", KodeID, '*');
$ket_bayar = GetFields("bayarmhsw", "BayarMhswID", $id, "Keterangan,Tanggal");
$current_date = date('Y-m-d');
$content .= '
<br>
<br>
<table class="tidakgaris">
<tr>
<td width="200" class="tengah">TANDA TERIMA KWITANSI <br><br><br><br><br>(.......................................)</td>
<td width="240" class="kiri2">CATATAN : <br>
<table class="garis"><tr><td width="200" height="40" class="keterangan">' . $ket_bayar["Keterangan"] . '</td></tr></table>
</td>
<td class="tengah">' . strtoupper($identitas['Kota']) . ', ' . strtoupper(GetDateInWords($ket_bayar["Tanggal"])) . '<br><br><br><br><br>(.......................................)</td>
</tr>
</table>
</div>
<!--<div class="footer">
</div>-->
';
require_once '../html2pdf/html2pdf.class.php';
$html2pdf = new HTML2PDF('L', 'A5');
$html2pdf->WriteHTML($content);
$html2pdf->Output('Kwitansi_' . $MhswID . '_' . $TahunID . '.pdf');
?>
