<tr>
<th>Kelas</th>
<th>Username</th>
<th>Nama</th>
<th width="220px">Aksi</th>
</tr>
</thead>';
$admin .= '<tbody>';
$sql = "SELECT * FROM `kelas_isi` order by kelas asc";
$query = mysql_query($sql);
while ($data = mysql_fetch_array($query)) {
$id = $data['id'];
$kelas = $data['kelas'];
$siswa = $data['siswa'];
$admin .= '<tr>
<td>' . getkelas($kelas) . '</td>
<td>' . $siswa . '</td>
<td>' . getnamasiswa($siswa) . '</td>';
$admin .= '<td><a href="?pilih=importsiswa&mod=yes&aksi=del&user='******'" onclick="return confirm(\'Apakah Anda Yakin Ingin Menghapus Siswa Ini ?\')"><span class="btn btn-danger">Hapus</span></a> <a href="?pilih=importsiswa&mod=yes&aksi=resetpassword&user='******'"onclick="return confirm(\'Apakah Anda Yakin Ingin Mereset Siswa Ini ?\')"><span class="btn btn-primary">Reset Pass</span></a> <a href="?pilih=importsiswa&mod=yes&aksi=edit&user='******'"><span class="btn btn-warning">Edit</span></a></td>';
$admin .= '
</tr>';
}
$admin .= '</tbody></table>';
$admin .= '</div>';
} else {
$admin .= '<div class="panel-heading"><b>Daftar Siswa Per User</b></div>';
$admin .= '
<table id="example" class="table table-striped table-bordered" cellspacing="0">
<thead>
<tr>
<th>Kelas</th>
<td width="10%">Nama Kamar</td>
';
echo '</tr>';
$no = 1;
$hasil2 = $koneksi_db->sql_query("SELECT * FROM reservasi order by kelas,absen asc");
while ($data2 = mysql_fetch_assoc($hasil2)) {
$nama = $data2['nama'];
$kelas = $data2['kelas'];
$absen = $data2['absen'];
$kamar = $data2['kamar'];
echo '
<tr>
<td>' . $no . '</td>
<td>' . $nama . '</td>
<td></td>
<td>' . getkelas($kelas) . ' / ' . $absen . '</td>
<td>' . getkamar($kamar) . '</td>
<td></td>
';
echo '</tr>';
$no++;
}
echo '</table><br>';
echo "</body></html>";
/*
if (isset($_GET['tglmulai'])){
echo "<script language=javascript>
window.print();
</script>";
}
*/
<?php
include "includes/config.php";
include "includes/mysql.php";
$idujian = $_POST['idujian'];
$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 width="5%" class="header">Point</td>
<td class="header">Keterangan</td>
</tr>';
$no = 1;
$hasil = $koneksi_db->sql_query("SELECT * FROM akad_siswapelanggaran where tgl between '{$tgl1}' and '{$tgl2}' and siswa='{$idsiswa}' order by tgl asc");
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$id = $data['id'];
$tgl = $data['tgl'];
$kelas = $data['kelas'];
$siswa = $data['siswa'];
$pelanggaran = $data['pelanggaran'];
$point = $data['point'];
echo '<tr height="25">
<td align="center">' . $no . '</td>
<td align="center">' . tanggalindoshort($tgl) . '</td>
<td align="center">' . getkelas($kelas) . '</td>
<td align="left">' . getkatdaripelanggaran2($pelanggaran) . '</td>
<td align="left">' . getpelanggaran($pelanggaran) . '</td>
<td align="center">' . $point . '</td>
<td align="left">' . gethukuman($pelanggaran) . '</td>
</tr>';
$pointtotal += $point;
$no++;
}
echo '<tr>
<td width="5%" colspan="5" align="right" bgcolor="#CCCCCC"><strong>Jumlah </strong></td>
<td width="5%" height="25" align="center">' . $pointtotal . '</td>
<td width="*" bgcolor="#CCCCCC"></td>
</tr>
<!-- END TABLE CONTENT -->
</table> ';
<table cellspacing="0" cellpadding="0"class="table table-striped table-hover">
<tr>
<td>Nama Guru</td>
<td>:</td>
<td>' . getnamaguru($guru) . '</td>
<td>Tahun</td>
<td>:</td>
<td>' . $tahun . '</td>
</tr>
<tr>
<td>Mata Pelajaran</td>
<td>:</td>
<td>' . getmapel($mapel) . '</td>
<td>Kelas</td>
<td>:</td>
<td>' . getkelas($kelasaktif) . '</td>
</tr>
</table>';
$judul = !isset($judul) ? '' : $judul;
$konten = !isset($konten) ? '' : $konten;
/*************************************************/
$hasil = $koneksi_db->sql_query("SELECT * FROM materi where id='{$idmateri}' and LOCATE(CONCAT(',', {$kelasaktif} ,','),CONCAT(',',kelas,','))");
$data = $koneksi_db->sql_fetchrow($hasil);
$judul = $data['judul'];
$konten = $data['konten'];
$materi = $data['materi'];
$kelasmateri = explode(",", $data["kelas"]);
$jml_pil = count($kelasmateri);
$kembali = "<a href='admin.php?pilih=materi&mod=yes&aksi=lihat&materi={$idmateri}&id={$id}><span class='label label-warning'><span class='label label-info'>Kembali ke Halaman Sebelumnya</span></a>";
if ($materi) {
$mateributton = "<a href='mod/materi/download/{$materi}'><span class='label label-success'>Download materi</span></a>";
$idkelas = int_filter($_GET['idkelas']);
$idsiswa = int_filter($_GET['idsiswa']);
$query = mysql_query("SELECT * FROM `akad_kelas` WHERE `replid`='{$idkelas}'");
$data = mysql_fetch_array($query);
$jenjang = $data['jenjang'];
$departemen = $data['departemen'];
$tahunajaran = $data['tahunajaran'];
$datarapor = getidraporafkelas($jenjang, $departemen, $tahunajaran);
$idrapor = $datarapor['id'];
$admin .= '
<form method="post" action="" class="form-inline">
<table class="table">';
$admin .= '<tr>
<td>Kelas</td>
<td>:</td>
<td>' . getkelas($idkelas) . '</td>
</tr>';
$admin .= '<tr>
<td>Nama Siswa</td>
<td>:</td>
<td>' . getsiswa($idsiswa) . '</td>
</tr>
</table>';
/*******************************/
$no = 1;
$admin .= '<table class="table" width="100%">
<tr>
<td width="5%">No</td>
<td>Master ' . $idrapor . '</td>
<td colspan="2" width="10%">Nilai</td>
</tr>';
$tgl = datetimes($data['tgl']);
$admin .= '<div class="bordermenu">Dashboard</div>';
if (isset($_SESSION['LevelAkses'])) {
$username = $_SESSION['UserName'];
$query = $koneksi_db->sql_query("SELECT * FROM useraura where user = '******'");
$data = $koneksi_db->sql_fetchrow($query);
$last_ping = datetimes($data['last_ping'], false);
if ($_SESSION['LevelAkses'] == "Administrator") {
$admin .= '<div class="border">';
$admin .= '- Last Login : '******'';
$admin .= '</div>';
}
if ($_SESSION['LevelAkses'] == "Siswa") {
$user = $_SESSION['UserName'];
$kelasaktif = getkelasid($user);
$namakelas = getkelas($kelasaktif);
$admin .= '<div class="panel panel-info">';
$admin .= '<div class="panel-heading"><b>Pengumuman Sekolah</b></div>';
$admin .= '
<ul class="bxslider">
';
$hasil2 = $koneksi_db->sql_query("SELECT * FROM pengumuman_sekolah order by tgl desc limit 5 ");
while ($data2 = $koneksi_db->sql_fetchrow($hasil2)) {
$judul2 = $data2['judul'];
$konten2 = $data2['konten'];
$tgl = datetimes($data2['tgl']);
$admin .= "<li><div class='slideshow'><h3>{$judul2}</h3>\n\t<table><tr><td align='right'><span class='label label-warning'>{$tgl}</span></td></tr>\n\t<tr><td>\n <p>{$konten2}</p>\n\t</td></tr></table>\n </div>\n </li>";
}
$admin .= '</ul>';
$admin .= '<div class="panel-heading"><b>Data profil</b></div>';
$getnamasiswa = getnamasiswa($user);
<td>' . $nis . '</td>
</tr>';
$admin .= '<tr>
<td>Nama</td>
<td>:</td>
<td>' . $nama . '</td></tr>';
$admin .= '<tr>
<td>Kelas Siswa</td>
<td>:</td>
<td><select name="kelas" id="kelas"class="form-control" required>';
$hasilj = $koneksi_db->sql_query("SELECT * FROM akad_siswakelas where siswa='{$idsiswa}' ORDER BY tahunajaran desc");
$admin .= '<option value="">== Kelas ==</option>';
while ($datasj = $koneksi_db->sql_fetchrow($hasilj)) {
$pilihanj = $datasj['tahunajaran'] == $tahunajaranaktif ? "selected" : '';
$aktif = $datasj['tahunajaran'] == $tahunajaranaktif ? "(Aktif)" : '';
$admin .= '<option value="' . $datasj['kelas'] . '"class="' . $datasj['siswa'] . '"' . $pilihanj . '>' . getkelas($datasj['kelas']) . ' ' . $aktif . '</option>';
}
$admin .= '</select></td>
</tr>';
$admin .= '<tr>
<td>Semester</td>
<td>:</td>
<td><select name="semester" class="form-control" id="semester"required>';
$hasilj = $koneksi_db->sql_query("SELECT * FROM akad_semester ORDER BY nama asc");
$admin .= '<option value="">== Semester ==</option>';
while ($datasj = $koneksi_db->sql_fetchrow($hasilj)) {
$pilihan = $datasj['id'] == $semester ? "selected" : '';
$aktif = $datasj['id'] == $semesteraktif ? "(Aktif)" : '';
$admin .= '<option value="' . $datasj['id'] . '"' . $pilihan . '>' . $datasj['nama'] . ' ' . $aktif . '</option>';
}
$admin .= '</select></td></tr>';