' . $judul . ' </div>'; } else { $urlgambar = ' <img src="mod/penugasan/images/normal/penugasan-default.jpg" height="30px"width="50px">'; } $deleted = '<a href="?pilih=penugasan&mod=yes&aksi=delpenugasan&id=' . $data['id'] . '" onclick="return confirm(\'Penugasan ini akan dihapus, Apakah Anda Ingin Menghapus Data Ini ?\')" style="color:red">Delete</a>'; $topik = $data["topik"]; $hasil2 = $koneksi_db->sql_query("SELECT * FROM topik WHERE id in ({$topik})"); //$data2 = $koneksi_db->sql_fetchrow($hasil2); $topik2 = ""; while ($data2 = $koneksi_db->sql_fetchrow($hasil2)) { $topik2 .= $data2["topik"] . ","; } $topik2 = substr_replace($topik2, "", -1, 1); $data_tgl = tglsort($data['tgl']); $admin .= ' <tr> <td style="text-align:left;width:10px;padding:5px;border-left:1px solid #ccc;border-top:1px solid #ccc;" valign="top">' . $no . '</td> <td style="width:20px;padding:5px;border-left:1px solid #ccc;border-top:1px solid #ccc;" valign="top"><input type=checkbox name=check' . $no . ' value=' . $data[0] . '></td> <td style="text-align:left;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">' . $data[1] . '<br><a href="article-' . $seftitle . '.html" target="new">(' . $seftitle . ')</a></td> <td style="text-align:left;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">' . $urlgambar . '</td> <td style="text-align:left;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">' . $topik2 . '</td> <td style="text-align:left;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">' . $data_tgl . '</td> <td style="text-align:center;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;width:5px;">' . $download . '</td> <td style="text-align:center;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;border-right:1px solid #ccc;width:5px;">' . $deleted . ' - <a href=admin.php?pilih=penugasan&mod=yes&aksi=editpenugasan&id=' . $data[0] . '&topik=' . $topik . '> Edit </a></td> </tr>'; $no++; } $admin .= "<tr><td colspan='10' style='text-align:left;padding:5px;border-top:1px solid #ccc;'></td></tr>"; $admin .= "</table>";
</tr></thead><tbody>'; $no = 1; while ($data = $koneksi_db->sql_fetchrow($hasil)) { $pertemuan = $data['pertemuan']; $idujian = $data['id']; $idkursus = $data['idkursus']; $tgl = $data['tgl']; $judul = $data['judul']; $jumlahsoal = $data['jumlahsoal']; $tipe = $data['tipe']; $status = $data['status']; $idkelas = $data['kelas']; $kelas = lihatkelas($idkelas); $kelas = substr_replace($kelas, "", -1, 1); $admin .= '<tr> <td><b>' . tglsort($tgl) . '</b></td> <td>' . getpertemuan($pertemuan) . '</td> <td>' . $judul . '</td> <td>' . getjumlahsoal($idujian) . ' / ' . $jumlahsoal . '</td> <td>' . $tipe . '</td> <td>' . $status . '</td>'; if (getjumlahsoal($idujian) == $jumlahsoal) { $test = '<a href="?pilih=ujian&mod=yes&aksi=testujian&idujian=' . $data['id'] . '&id=' . $data['idkursus'] . '"><span class="btn btn-primary">Test</span></a>'; } else { $test = ''; } $admin .= ' <td><a href="?pilih=ujian&mod=yes&aksi=del&id=' . $data['id'] . '&idkursus=' . $data['idkursus'] . '" onclick="return confirm(\'Soal pada ujian tersebut akan ikut terhapus,Apakah Anda Yakin Ingin Menghapus Data Ini ?\')"><span class="btn btn-danger">Del</span></a> <a href="?pilih=ujian&mod=yes&aksi=edit&id=' . $data['id'] . '&idkursus=' . $data['idkursus'] . '" onclick="return confirm(\'Edit Ujian hanya mengedit Tipe Soal Urut/Random dan Status Ujian, Apakah ingin melanjutkan ?\')"><span class="btn btn-warning">Edit</span></a> <a href="?pilih=ujian&mod=yes&aksi=addsoal&idujian=' . $data['id'] . '&id=' . $data['idkursus'] . '"><span class="btn btn-success">Soal</span></a> ' . $test . '</td> </tr>'; $no++; }
header("Cache-Control: no-cache, must-revalidate"); header("Expires: Sat, 26 Jul 2010 05:00:00 GMT"); header("content-disposition: attachment;filename=Jurnal_Reky_" . date('Y-m') . ".xls"); echo '<table><tr><td colspan="4"><B>JURNAL BULAN ' . $bulan . ' / TAHUN ' . $tahun . '</B></td></tr>'; echo '<tr><td colspan="4"></tr>'; echo ' <tr> <td><B>#</B></td> <td><B>MULAI</B></td> <td><B>AKHIR</B></td> <td><B>KEGIATAN</B></td> </tr>'; $sql = "SELECT * FROM `jadwalku` where substring(tgl1,7,4)='{$tahun}' and substring(tgl1,1,2)='{$bulan}' order by tgl1 asc"; $query = mysql_query($sql); $nomor = 1; while ($data = mysql_fetch_array($query)) { $id = $data['id']; $tgl1 = tglsort($data['tgl1']); $tgl2 = tglsort($data['tgl2']); $hari1 = datetimes2($data['tgl1']); $hari2 = datetimes2($data['tgl2']); $judul = $data['judul']; echo '<tr> <td>' . $nomor . '</td> <td>' . $hari1 . '<br>' . $tgl1 . '</td> <td>' . $hari2 . '<br>' . $tgl2 . '</td> <td>' . $judul . '</td>'; $echo .= '</tr>'; $nomor++; } echo '</table>';