<td>Jumlah Soal</td>
<td>:</td>
<td>' . $jumlahsoal . '</td>
</tr>
<tr>
<td>Nama Guru</td>
<td>:</td>
<td>' . getnamaguru($guru) . '</td>
<td>Tipe / Status Soal</td>
<td>:</td>
<td>' . $tipeujian . ' / ' . $status . '</td>
</tr>
<tr>
<td>Nilai Sebelumnya</td>
<td>:</td>
<td>' . getnilaiujian($idujian, $user) . '</td>
<td></td>
<td></td>
<td></td>
</tr>
' . $petunjukumum . '
</table>';
$tipejawaban = getjumlahjawaban($idujian);
$jawaban = explode(",", $tipejawaban);
$jml_jawaban = count($jawaban);
if ($tipe == 'random') {
$hasil = mysql_query("SELECT * FROM soal where ujian='{$idujian}' ORDER BY RAND()");
} else {
$hasil = mysql_query("SELECT * FROM soal where ujian='{$idujian}'order by id asc");
}
$admin .= '
$kelasid = $_POST['kelasid'];
$kelas = getkelas($kelasid);
$namaujian = getnamaujian($idujian);
$namaguru = getnamaguruujian($idujian);
header("Content-Type: application/force-download");
header("Cache-Control: no-cache, must-revalidate");
header("Expires: Sat, 26 Jul 2010 05:00:00 GMT");
header("content-disposition: attachment;filename=elearning_nilaiujian_" . $kelas . ".xls");
echo "<table>\n<tr><td colspan='2'></td>\n<td><b>LAPORAN NILAI SISWA</b></td>\n</tr>";
echo " <tr>\n <td colspan='2'></td>\n <td></td>\n </tr>";
echo " <tr>\n <td colspan='2'>Kelas </td>\n <td>{$kelas}</td>\n </tr>";
echo " <tr>\n <td colspan='2'>Nama Ujian </td>\n <td>{$namaujian}</td>\n </tr>";
echo " <tr>\n <td colspan='2'>Nama Guru </td>\n <td>{$namaguru}</td>\n </tr>";
echo " <tr>\n <td colspan='2'></td>\n <td></td>\n </tr></table>";
echo "<table border='1'>\n<tr bgcolor='#ECECEC'>\n <th>No.</th>\n <th>No.Induk</th>\n <th>Nama</th>\n <th>Nilai</th>\n </tr>";
/************************************/
$no = '1';
$hasil = $koneksi_db->sql_query("SELECT * FROM `kelas_isi`where kelas ='{$kelasid}'");
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$namasiswa = getnamasiswa($data['siswa']);
$nilaiujian = getnilaiujian($idujian, $data['siswa']);
echo '
<tr>
<td>' . $no . '</td>
<td>' . $data['siswa'] . '</td>
<td>' . $namasiswa . '</td>
<td>' . $nilaiujian . '</td>
</tr>';
$no++;
}
echo "</table>";
$admin .= '
<table id="example" class="table table-striped table-hover">
<thead><tr>
<td align="left"><b>No</b></td>
<td align="left"><b>No.Induk</b></td>
<td align="left"><b>Nama</b></td>
<td align="left"><b>Tanggal</b></td>
<td align="left"><b>Jam</b></td>
<td align="left"><b>Nilai</b></td>
<td align="left"><b>Aksi</b></td>
</tr></thead><tbody>';
$no = 1;
while ($data2 = $koneksi_db->sql_fetchrow($hasil2)) {
$user = $data2['siswa'];
$namasiswa = getnamasiswa($data2['siswa']);
$nilaiujian = getnilaiujian($idmapel, $dat2['siswa']);
$tanggalujian = gettanggalujian($idmapel, $data2['siswa']);
$jamujian = getjamujian($idmapel, $data2['siswa']);
if ($koneksi_db->sql_numrows($koneksi_db->sql_query("SELECT * FROM ujiannilai WHERE mapel = '{$idmapel}' and user = '******'")) > 0) {
$lihathistory = "<a href='admin.php?pilih=ujian&mod=yes&aksi=nilaihistorysiswa&idmapel={$idmapel}&user={$user}' class='btn btn-success'>Lihat History</a>";
}
$admin .= '
<tr>
<td>' . $no . '</td>
<td>' . $data2['siswa'] . '</td>
<td>' . $namasiswa . '</td>
<td>' . $tanggalujian . '</td>
<td>' . $jamujian . '</td>
<td>' . $nilaiujian . '</td>
<td>' . $lihathistory . '</td>
</tr>';
