' . $judul . '
</div>';
            } else {
                $urlgambar = '
<img src="mod/penugasan/images/normal/penugasan-default.jpg" height="30px"width="50px">';
            }
            $deleted = '<a href="?pilih=penugasan&amp;mod=yes&amp;aksi=delpenugasan&amp;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&amp;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>";
Example #2
0
</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&amp;mod=yes&amp;aksi=testujian&amp;idujian=' . $data['id'] . '&amp;id=' . $data['idkursus'] . '"><span class="btn btn-primary">Test</span></a>';
            } else {
                $test = '';
            }
            $admin .= '
<td><a href="?pilih=ujian&amp;mod=yes&amp;aksi=del&amp;id=' . $data['id'] . '&amp;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>&nbsp;<a href="?pilih=ujian&amp;mod=yes&amp;aksi=edit&amp;id=' . $data['id'] . '&amp;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>&nbsp;<a href="?pilih=ujian&amp;mod=yes&amp;aksi=addsoal&amp;idujian=' . $data['id'] . '&amp;id=' . $data['idkursus'] . '"><span class="btn btn-success">Soal</span></a>&nbsp;' . $test . '</td>
</tr>';
            $no++;
        }
Example #3
0
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>';