<?php
$dept = gpost('departemen');
$optcari = gpost('optcari');
$a = 0;
$s = "";
$t = mysql_query("SELECT * FROM psb_calonsiswa LEFT JOIN psb_proses ON psb_calonsiswa.proses=psb_proses.replid WHERE departemen='{$dept}'");
if (mysql_num_rows($t) > 0) {
if ($optcari == 'agama') {
$agama = agama_r($a);
foreach ($agama as $k => $v) {
$sql = "SELECT psb_calonsiswa.* FROM psb_calonsiswa LEFT JOIN psb_proses ON psb_calonsiswa.proses=psb_proses.replid WHERE departemen='{$dept}' AND agama='{$k}'";
$t = mysql_query($sql);
if ($s != "") {
$s .= "~";
}
$s .= $v . ";" . mysql_num_rows($t);
}
$s = "0~" . $s;
} else {
if ($optcari == 'kelamin') {
$sql = "SELECT psb_calonsiswa.* FROM psb_calonsiswa LEFT JOIN psb_proses ON psb_calonsiswa.proses=psb_proses.replid WHERE psb_proses.departemen='{$dept}' AND psb_calonsiswa.kelamin='L'";
$t = mysql_query($sql);
$L = mysql_num_rows($t);
$sql = "SELECT psb_calonsiswa.* FROM psb_calonsiswa LEFT JOIN psb_proses ON psb_calonsiswa.proses=psb_proses.replid WHERE psb_proses.departemen='{$dept}' AND psb_calonsiswa.kelamin='P'";
$t = mysql_query($sql);
$P = mysql_num_rows($t);
$s = "Laki-laki;" . $L . "~Perempuan;" . $P;
$s = "1~" . $s;
} else {
if ($optcari == 'kelompok') {
if (strlen($r['photo']) > 0) {
$cx = $pdf->GetX();
$cy = $pdf->GetY();
$pdf->SetX(100);
$pdf->SetY(30);
$imgdata = base64_decode(chunk_split($r['photo']));
$pdf->Image('@' . $imgdata, 155, 73);
$pdf->SetX($cx);
$pdf->SetY($cy);
}
group_label('Keterangan Kesehatan Siswa');
head_label('Golongan darah', $r['darah']);
head_label('Penyakit yang pernah diderita', $r['kesehatan']);
head_label('Alergi terhadap', $r['ketkesehatan']);
$pdf->Ln();
$agama = agama_r(0);
$t = mysql_query("SELECT * FROM psb_calonsiswa_ayah WHERE calonsiswa='{$cid}'");
$ayah = mysql_fetch_array($t);
$t = mysql_query("SELECT * FROM psb_calonsiswa_ibu WHERE calonsiswa='{$cid}'");
$ibu = mysql_fetch_array($t);
group_label('Data Orang Tua Siswa');
head_label2x('', ' Ayah', 'Ibu');
head_label2('Nama', $ayah['nama'], $ibu['nama']);
head_label2('Kebangsaan', $ayah['warga'], $ibu['warga']);
head_label2('Tempat Lahir', $ayah['tmplahir'], $r['tmplahiribu']);
head_label2('Tanggal Lahir', fftgl($ayah['tgllahir']), fftgl($ibu['tgllahir']));
head_label2('Pekerjaan', $ayah['pekerjaan'], $ibu['pekerjaan']);
head_label2('Telepon Orangtua', $ayah['telpon'], $ibu['telpon']);
head_label2('PIN BB Orangtua', $ayah['pinbb'], $ibu['pinbb']);
head_label2('Email Orang Tua', $ayah['email'], $ibu['email']);
$pdf->Ln();
$row = mysql_fetch_array($res);
$kode_no = $row['kodeawalan'];
$thn_no = substr(date("Y"), 2, 2);
$nomor = sprintf("%04d", intval($nom) + 1);
$no = sprintf("%s%02d%04d", $kode_no, $thn_no, $nomor);
$data['nopendaftaran'] = $no;
}
//if($opt=='uf'){
$xform->fi('Nomor pendaftaran', iText('nopendaftaran', $data['nopendaftaran'], $xform->fieldws));
//}
//$xform->fi('Nomor Formulir',iText('noformulir',$data['noformulir'],$xform->fieldws));
$xform->fi('Nama lengkap', iText('nama', $data['nama'], $xform->fieldws));
$xform->fi('Jenis kelamin', iSelect('kelamin', array('L' => 'Laki-laki', 'P' => 'Perempuan'), $data['kelamin']));
$xform->fi('Tempat lahir', iText('tmplahir', $data['tmplahir'], $xform->fieldws));
$xform->fi('Tanggal lahir', inputDate('tgllahir', $data['tgllahir']));
$xform->fi('Agama', iSelect('agama', agama_r(0), $data['agama']));
$xform->fi('Alamat rumah', iTextarea('alamat', $data['alamat'], $xform->fieldws, 3));
$xform->fi('Nomor telepon', iText('telpon', $data['telpon'], 'width:120px'));
$xform->fi('Sekolah asal', iText('sekolahasal', $data['sekolahasal'], $xform->fieldws));
if ($opt == 'uf') {
$t = mysql_query("SELECT * FROM psb_calonsiswa_ayah WHERE calonsiswa='" . $data['replid'] . "'");
$ayah = mysql_fetch_array($t);
} else {
$ayah['nama'] = '';
$ayah['warga'] = '';
$ayah['tmplahir'] = '';
$ayah['tgllahir'] = '0000-00-00';
$ayah['pekerjaan'] = '';
$ayah['telpon'] = '';
$ayah['pinbb'] = '';
$ayah['email'] = '';
