<?php
if (!isset($_GET['act'])) {
?>
<div class="col-lg-12">
<h1 class="page-header">Data Sanksi <?php
echo tbl_tambah('Input Sanksi', '?hal=sanksi&act=ubah');
?>
</h1>
</div>
<table class="table table-hover table-bordered" id="tbl">
<thead>
<tr>
<th class="col-lg-1 text-center">No</th>
<th>Jenis Sanksi</th>
<th class="col-lg-2 text-center">Poin</th>
<th class="col-lg-2 text-center">Status</th>
<th class="col-lg-1 text-center">#</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$db = new Database();
$db->connect();
$db->select('sanksi', '*', null, null, 'minimal asc');
// Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions
$res = $db->getResult();
foreach ($res as $d) {
?>
<tr>
<?php
if (!isset($_GET['act'])) {
?>
<div class="col-lg-12">
<h1 class="page-header">Data Tata Tertib <?php
echo tbl_tambah('Input Tata Tertib', '?hal=tatatertib&act=ubah');
?>
</h1>
</div>
<table class="table table-hover table-bordered" id="tbl">
<thead>
<tr>
<th class="col-lg-1 text-center">Poin</th>
<th class="col-lg-1 text-center">Kode</th>
<th>Nama Tata Tertib</th>
<th class="col-lg-2 text-center">Jenis</th>
<th class="col-lg-2 text-center">Status</th>
<th class="col-lg-1 text-center">#</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$db = new Database();
$db->connect();
$db->select('tata_tertib', '*', null, null, "poin asc");
// Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions
$res = $db->getResult();
foreach ($res as $d) {
?>
<?php
if (!isset($_GET['act'])) {
?>
<div class="col-lg-12">
<h1 class="page-header">Siswa <?php
echo tbl_tambah('Input Data Siswa', '?hal=siswa&act=ubah');
?>
</h1>
</div>
<table class="table table-hover table-bordered" id="tbl">
<thead>
<tr>
<th class="col-lg-1 text-center">No</th>
<th class="col-lg-2 text-center">NIS</th>
<th>Nama Siswa</th>
<th class="col-lg-3 text-center">Jurusan</th>
<th class="col-lg-2 text-center">Kelas</th>
<th class="col-lg-1 text-center">#</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$db = new Database();
$db->connect();
$db->select('siswa');
// Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions
$res = $db->getResult();
foreach ($res as $d) {
?>
<?php
if (!isset($_GET['act'])) {
?>
<div class="col-lg-12">
<h1 class="page-header">Data Kelas <?php
echo tbl_tambah('Input Kelas', '?hal=kelas&act=ubah');
?>
</h1>
</div>
<table class="table table-hover table-bordered" id="tbl">
<thead>
<tr>
<th class="col-lg-1 text-center">No</th>
<th class="col-lg-2 text-center">Nama Kelas</th>
<th>Wali Kelas</th>
<th class="col-lg-2 text-center">Status</th>
<th class="col-lg-1 text-center">#</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$db = new Database();
$db->connect();
$db->select('kelas');
// Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions
$res = $db->getResult();
foreach ($res as $d) {
?>
<tr>
<?php
if (!isset($_GET['act'])) {
?>
<div class="col-lg-12">
<h1 class="page-header">Master Data Pengguna <?php
echo tbl_tambah('Input Data Pengguna', '?hal=pengguna&act=ubah');
?>
</h1>
</div>
<table class="table table-hover table-bordered" id="tbl">
<thead>
<tr>
<th class="col-lg-1 text-center">No</th>
<th class="col-lg-2 text-center">Username</th>
<th>Nama Guru</th>
<th class="col-lg-3 text-center">Jurusan</th>
<th class="col-lg-2 text-center">Level</th>
<th class="col-lg-1 text-center">#</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$db = new Database();
$db->connect();
$db->select('users', '*', null, null, 'id asc');
// Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions
$res = $db->getResult();
foreach ($res as $d) {
?>
<?php
if (!isset($_GET['act'])) {
?>
<div class="col-lg-12">
<h1 class="page-header">Data Jurusan <?php
echo tbl_tambah('Input Jurusan', '?hal=jurusan&act=ubah');
?>
</h1>
</div>
<table class="table table-hover table-bordered" id="tbl">
<thead>
<tr>
<th class="col-lg-1 text-center">No</th>
<th class="col-lg-1 text-center">Kode</th>
<th>Nama Jurusan</th>
<th class="col-lg-2 text-center">Jumlah Siswa</th>
<th class="col-lg-2 text-center">Status</th>
<th class="col-lg-1 text-center">#</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$db = new Database();
$db->connect();
$db->select('jurusan');
// Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions
$res = $db->getResult();
foreach ($res as $d) {
?>
<?php
if (!isset($_GET['act'])) {
?>
<div class="col-lg-12">
<h1 class="page-header">Data Tahun Pelajaran <?php
echo tbl_tambah('Input Tapel', '?hal=tapel&act=ubah');
?>
</h1>
</div>
<table class="table table-hover table-bordered" id="tbl">
<thead>
<tr>
<th class="col-lg-1 text-center">No</th>
<th>Tahun Pelajaran</th>
<th class="col-lg-2 text-center">Status</th>
<th class="col-lg-1 text-center">#</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$db = new Database();
$db->connect();
$db->select('tapel');
// Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions
$res = $db->getResult();
foreach ($res as $d) {
?>
<tr>
<td class="text-center"><?php
<?php
if (!isset($_GET['act'])) {
?>
<div class="col-lg-12">
<h1 class="page-header">Data Pelanggaran <?php
echo tbl_tambah('Input Pelanggaran', '?hal=pelanggaran&act=ubah');
?>
</h1>
</div>
<table class="table table-hover table-bordered" id="tbl">
<thead>
<tr>
<th class="col-lg-1 text-center">No</th>
<th>Nama Siswa</th>
<th class="col-lg-2 text-center">Jumlah Pelanggaran</th>
<th class="col-lg-1 text-center">Poin</th>
<th class="col-lg-2 text-center">Waktu</th>
<!--<th class="col-lg-1 text-center">#</th>-->
</tr>
</thead>
<tbody>
<?php
$i = 1;
$db = new Database();
$db->connect();
//$db->select('pelanggaran','*',null,null,'tanggal desc'); // Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions
$db->sql("select * from pelanggaran group by idsiswa order by tanggal desc");
$res = $db->getResult();
foreach ($res as $d) {
?>
