<?php
$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]);
} 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, 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]));
//status anak
xlsBuatLabel($xlsRow, 8, $data[8]);
//anak ke
xlsBuatLabel($xlsRow, 8, $data[9]);
//jum saudara
