$hasil = $koneksi_db->sql_query("SELECT * FROM kursus_setting where guru='{$user}' order by guru asc"); $admin .= '<div class="panel-heading"><b>Daftar Kursus</b></div>'; $admin .= '<table id="example" class="table table-striped table-hover"> <thead><tr> <th>No</th> <th>Guru</th> <th>Mata Pelajaran</th> <th>Tahun Ajaran</th> <th>Nama Kursus</th> <th>Aksi</th> </tr></thead><tbody>'; $no = 1; while ($data = $koneksi_db->sql_fetchrow($hasil)) { $idkursus = $data['id']; $guru = $data['guru']; $cekjmlujian = cekjmlujian2($idkursus); $getkelasid_ks = getkelasid_ks($data['id']); if ($getkelasid_ks != '') { $tambahujian = '<a href="?pilih=ujian&mod=yes&aksi=addujian&id=' . $data['id'] . '"><span class="btn btn-warning">Tambah Ujian</span></a> '; } else { $tambahujian = ''; } $admin .= '<tr> <td><b>' . $no . '</b></td> <td>' . getnamaguru($data['guru']) . '</td> <td>' . getmapel($data['mapel']) . '</td> <td>' . $data['tahun'] . '</td> <td>' . $data['judul'] . '</td> <td>' . $tambahujian . ''; if ($cekjmlujian > 0) { $admin .= '<a href="?pilih=ujian&mod=yes&aksi=listujian&id=' . $data['id'] . '"><span class="btn btn-primary">Daftar Ujian (' . $cekjmlujian . ')</span></a>';
$admin .= '<div class="box"> <div class="box-header"> <h3 class="box-title">Ujian</h3> </div><!-- /.box-header --> <div class="box-body">'; $admin .= '<table id="example1" class="table table-striped table-hover"> <thead><tr> <th>No</th> <th>Mata Pelajaran</th> <th>Aksi</th> </tr></thead><tbody>'; $no = 1; while ($data = $koneksi_db->sql_fetchrow($hasil)) { $idmapel = $data['id']; $mapel = $data['mapel']; $cekjmlujian = cekjmlujian2($idmapel); $admin .= '<tr> <td><b>' . $no . '</b></td> <td>' . $data['mapel'] . '</td> <td>'; if ($cekjmlujian > 0) { $admin .= '<a href="?pilih=ujian&mod=yes&aksi=listujian&id=' . $data['id'] . '"><span class="btn btn-primary">Mulai</span></a>'; } else { $admin .= '<a href="#"><span class="btn btn-danger">Kosong</span></a>'; } $admin .= '</td> </tr>'; $no++; } $admin .= '</tbody></table>'; $admin .= '</div><!-- /.box-body -->
$hasil = $koneksi_db->sql_query("SELECT * FROM kursus_setting order by guru asc"); $admin .= '<div class="panel-heading"><b>Daftar Kursus</b></div>'; $admin .= '<table id="example" class="table table-striped table-hover"> <thead><tr> <th>No</th> <th>Guru</th> <th>Mata Pelajaran</th> <th>Tahun Ajaran</th> <th>Aksi</th> </tr></thead><tbody>'; $no = 1; while ($data = $koneksi_db->sql_fetchrow($hasil)) { $idujian = $data['id']; $guru = $data['guru']; $cekjmlujian = cekjmlujian2($idujian); $admin .= '<tr> <td><b>' . $no . '</b></td> <td>' . getnamaguru($data['guru']) . '</td> <td>' . getmapel($data['mapel']) . '</td> <td>' . $data['tahun'] . '</td> <td><a href="?pilih=ujian&mod=yes&aksi=addujian&id=' . $data['id'] . '"><span class="btn btn-warning">Tambah Ujian</span></a> '; if ($cekjmlujian > 0) { $admin .= '<a href="?pilih=ujian&mod=yes&aksi=listujian&id=' . $data['id'] . '"><span class="btn btn-primary">Daftar Ujian (' . $cekjmlujian . ')</span></a>'; } else { $admin .= '<a href="#"><span class="btn btn-danger">Data Kosong</span></a>'; } $admin .= '</td> </tr>'; $no++; }
$admin .= '<a href="#"><span class="btn btn-danger">Data Kosong</span></a>'; } $admin .= '</td> </tr>'; $no++; } $admin .= '</tbody></table>'; } else { $hasil = $koneksi_db->sql_query("SELECT * FROM kursus_setting WHERE LOCATE(CONCAT(',', {$kelasaktif} ,','),CONCAT(',',kelas,',')) group by guru asc"); $admin .= '<div class="panel-heading"><b>Subject Details</b></div>'; $admin .= '<table class="table"><tr>'; $no = 1; while ($data = $koneksi_db->sql_fetchrow($hasil)) { $urutan = $no; $guru = $data['guru']; $cekjmlujian = cekjmlujian2($data['id']); if ($cekjmlujian > 0) { $klikujian = '<a href="?pilih=ujian&mod=yes&aksi=listujian&id=' . $data['id'] . '"><span class="btn btn-primary">Test List (' . $cekjmlujian . ')</span></a>'; } else { $klikujian = '<a href="#"><span class="btn btn-danger">Data Kosong</span></a>'; } $admin .= '<td valign="top" align="center"><img src="' . $url_situs . 'mod/mapel/' . geticonmapel($data['mapel']) . '" width="100px" height="100px" alt="' . $judul . '"/><br>' . getmapel($data['mapel']) . '<br> ' . $klikujian . ' </td>'; if ($urutan % 4 == 0) { $admin .= '</tr>'; } $no++; } $admin .= '</table>'; }