</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> ';
echo "</body></html>";
/*
<th>Point</th>
<th>Aksi</th>
</tr>
</thead>';
$hasil = $koneksi_db->sql_query("SELECT * FROM akad_siswapelanggaran where siswa='{$siswa}' order by tgl desc");
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$tgl1 = $data['tgl'];
$siswa = $data['siswa'];
$kelas = $data['kelas'];
$pelanggaran = $data['pelanggaran'];
$point = $data['point'];
$admin .= '<tr>
<td>' . datetimes($tgl1, false, false) . '</td>
<td>' . getsiswa($siswa) . '</td>
<td>' . getkelas($kelas) . '</td>
<td>' . getpelanggaran($pelanggaran) . '</td>
<td>' . $point . '</td>
<td><a href="?pilih=siswapelanggaran&mod=yes&aksi=del&id=' . $data['id'] . '&siswa=' . $siswa . '" onclick="return confirm(\'Apakah Anda Yakin Ingin Menghapus Data Ini ?\')"><span class="btn btn-danger">Hapus</span></a> <a href="?pilih=siswapelanggaran&mod=yes&aksi=edit&id=' . $data['id'] . '"><span class="btn btn-warning">Edit</span></a></td>
</tr>';
}
$admin .= '</tbody></table>';
$admin .= '</div>';
}
if ($_GET['aksi'] == '') {
$admin .= '<div class="panel panel-info">
<div class="panel-heading"><h3 class="panel-title">Daftar Pelanggaran Siswa</h3></div>';
$admin .= '
<table id="example"class="table table-striped table-bordered" cellspacing="0" width="100%">
<thead>
<tr>
<th>NIS</th>