<?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'] = '';