<?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