<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&amp;mod=yes&amp;aksi=del&amp;user='******'" onclick="return confirm(\'Apakah Anda Yakin Ingin Menghapus Siswa Ini ?\')"><span class="btn btn-danger">Hapus</span></a> <a href="?pilih=importsiswa&amp;mod=yes&amp;aksi=resetpassword&amp;user='******'"onclick="return confirm(\'Apakah Anda Yakin Ingin Mereset Siswa Ini ?\')"><span class="btn btn-primary">Reset Pass</span></a> <a href="?pilih=importsiswa&amp;mod=yes&amp;aksi=edit&amp;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>
Example #2
0
<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&nbsp;&nbsp;</strong></td>
   		<td width="5%" height="25" align="center">' . $pointtotal . '</td>     
        <td width="*" bgcolor="#CCCCCC"></td>
    </tr>
	<!-- END TABLE CONTENT -->
    </table>	';
Example #5
0
<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>";
Example #6
0
    $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>';
Example #7
0
$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 .= '-&nbsp;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);
Example #8
0
	<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>';