</tr><tr> <td width="20%">No. Pendaftaran</td> <td>: ' . getNoPendaftaran($replid, $r['kelompok'])['akhir'] . '</td> <td align="right" rowspan="5"><img height="120" src="../img/upload/' . $r['photo'] . '" alt="" /></td> </tr><tr> <td width="20%">Nama Lengkap</td> <td>: ' . $r['nama'] . '</td> </tr><tr> <td width="20%">Jenis Kelamin</td> <td>: ' . $r['kelamin'] . '</td> </tr><tr> <td width="20%">Tempat, Tgl Lahir</td> <td>: ' . $r['tmplahir'] . ', ' . tgl_indo8($r['tgllahir']) . '</td> </tr><tr> <td width="20%">Agama</td> <td>: ' . getAgama($r['agama']) . '</td> </tr><tr> <td width="20%">Alamat</td> <td colspan="2">: ' . $r['alamat'] . '</td> </tr><tr> <td width="20%">No. telp</td> <td colspan="2">: ' . $r['telpon'] . '</td> </tr><tr> <td width="20%">Asal Sekolah</td> <td colspan="2">: ' . $r['sekolahasal'] . '</td> </tr><tr> <td width="20%">Golongan Darah</td> <td colspan="2">: ' . $r['darah'] . '</td> </tr><tr> <td width="20%">Penyakit</td> <td colspan="2">: ' . $r['kesehatan'] . '</td>
$dari = isset($_GET['dari']) ? $_GET['dari'] : "";
if ($dari == "umum") {
$nisn = $_GET['nisn'];
$Q = "SELECT * FROM master WHERE nisn = '{$nisn}'";
$q = mysql_query($Q);
$a = mysql_fetch_array($q);
} else {
$id_daftar = $_GET['id_daftar'];
$q = mysql_query("SELECT * FROM master WHERE id_daftar = '{$id_daftar}'");
$a = mysql_fetch_array($q);
}
echo "<tr><th colspan='2'>Data Siswa</th></tr>";
cFDfield("NISN", $a[43]);
cFDfield("Nama", $a[1]);
cFDfield("Jenis Kelamin", getJK($a[2]));
cFDfield("Agama", getAgama($a[3]));
cFDfield("Tempat, Tanggal Lahir", $a[4] . ", " . $a[5]);
cFDfield("Alamat", $a[6]);
echo "<tr><th colspan='2'>Data Keluarga</th></tr>";
cFDfield("Status Anak", getStatusAnak($a[7]));
cFDfield("Anak Ke", $a[8]);
cFDfield("Jumlah Saudara", $a[9]);
cFDfield("Nama Ayah", $a['k_nama_ay']);
cFDfield("Pendidikan Ayah", getPendidikan($a['k_pend_ay']));
cFDfield("Pekerjaan Ayah", getPekerjaan($a['k_pkj_ay']));
cFDfield("Nama Ibu", $a[13]);
cFDfield("Pendidikan Ibu", getPendidikan($a[14]));
cFDfield("Pekerjaan Ibu", getPekerjaan($a[15]));
echo "<tr><th colspan='2'>Data Lulus</th></tr>";
cFDfield("Tahun Lulus", $a[16]);
cFDfield("Nomor Ijazah", $a[17]);
echo "<table border='1' class='data'><tr><th width='10%'>No</th><th width='60%'>Items</th><th width='30%'>Jumlah</th></tr>";
if ($_by == "umur") {
$str_sql = "SELECT FLOOR(DATEDIFF(NOW(), \n\t\t\t\t\t\ts_tgl_lahir)/366) AS umur, COUNT(*) AS \n\t\t\t\t\t\tjumlah FROM master GROUP BY umur";
} else {
$str_sql = "SELECT {$_by}, COUNT({$_by}) AS 'jumlah' FROM master GROUP BY {$_by}";
}
$q_stat = mysql_query($str_sql);
$j_data = mysql_num_rows($q_stat);
if ($j_data == 0) {
echo "<tr><td id='tengah' colspan='3'>-- Tidak Ada Data --</td></tr>";
} else {
$no = 1;
while ($a_stat = mysql_fetch_array($q_stat)) {
echo "<tr>\n\t\t\t\t<td id='tengah'>{$no}</td>\n\t\t\t\t<td>";
if ($_by == "s_agama") {
echo getAgama($a_stat[0]);
} else {
if ($_by == "s_jk") {
echo getJK($a_stat[0]);
} else {
if ($_by == "k_pend_ay") {
echo getPendidikan($a_stat[0]);
} else {
if ($_by == "k_pkj_ay") {
echo getPekerjaan($a_stat[0]);
} else {
if ($_by == "umur") {
echo $a_stat[0] . " tahun";
} else {
echo $a_stat[0];
}
xlsBuatLabel(0, 18, 'Nilai B. Inggris');
xlsBuatLabel(0, 19, 'Nilai B. Indo');
xlsBuatLabel(0, 20, 'Nilai Matematika');
xlsBuatLabel(0, 21, 'Nilai IPA');
xlsBuatLabel(0, 22, 'Prestasi 1');
xlsBuatLabel(0, 23, 'Tingkat');
xlsBuatLabel(0, 24, 'Prestasi 2');
xlsBuatLabel(0, 25, 'Tingkat');
xlsBuatLabel(0, 26, 'Prestasi 3');
xlsBuatLabel(0, 27, 'Tingkat');
xlsBuatLabel(0, 28, 'Pilihan Jurusan 1');
xlsBuatLabel(0, 29, 'Pilihan Jurusan 2');
xlsBuatLabel(0, 30, 'Tanggal Daftar');
$xlsRow = 1;
while ($data = mysql_fetch_array($sql)) {
$agama = getAgama($data[3]);
xlsBuatLabel($xlsRow, 0, $data[0]);
//no
xlsBuatLabel($xlsRow, 1, $data[1]);
//nama
xlsBuatLabel($xlsRow, 2, getJK($data[2]));
//jk
xlsBuatLabel($xlsRow, 3, $agama);
//agama
xlsBuatLabel($xlsRow, 4, $data[4]);
//tmp. lahir
xlsBuatLabel($xlsRow, 5, $data[5]);
//tgl. lahir
xlsBuatLabel($xlsRow, 6, $data[6]);
//alamat
xlsBuatLabel($xlsRow, 7, getStatusAnak($data[7]));
