}
$tgl = tgli($row['tanggal']);
$text = html_entity_decode($row['review_text']);
echo "<table width='100%' align='center'>\r\n <tr>\r\n <td width='15%' style='background-color:{$color1};'><img src='../images/user.gif'> {$title}</td>\r\n\t<td width='85%' align='right' style='background-color:{$color1};'>";
echo "<a name='{$no}'><a href='#'><img src='images/top.gif'></a></a></td>\r\n </tr>\r\n <tr>\r\n <td rowspan='3' style='background-color:{$warna};' valign='top'><b>{$row['nama_dosen']}{$row['nama_mhs']}</b><br><br>Tanggal : {$tgl}<br>Waktu : {$row['waktu']}</td>\r\n <td>{$text}</td>\r\n </tr>\r\n <tr>\r\n \t<td>Review Suara : {$rev_suara}</td>\r\n </tr>\r\n <tr>\r\n <td>Sifat Review : <font color='{$color}'>{$con} {$con1}</font></td>\r\n </tr>\r\n</table><br>";
$no++;
}
?>
</div><br>
<div id="rev_mhs">
<?php
$sqlb = mysql_query("SELECT id_rev_mhs, \r\nreview_mhs.NIM as 'rev', \r\nreview, review_mhs.tanggal as 'tglb', review_mhs.waktu as 'wktb', status, \r\nupload_mhs.NIM as 'up', \r\nnama_mhs, status_review FROM review_mhs, data_mahasiswa, upload_mhs \r\nWHERE review_mhs.NIM=data_mahasiswa.NIM and review_mhs.id_judul=upload_mhs.id and id_judul='{$id_jud}' and status='1'");
$jum = mysql_num_rows($sqlb) + $no;
$in = $no;
while ($rowa = mysql_fetch_array($sqlb)) {
$tglm = tgli($rowa['tglb']);
$textm = html_entity_decode($rowa['review']);
$statusm = $rowa['status'] == "0" ? "#A3A3A3" : "#DCDCDC";
$milik = $rowa['rev'] == $initid ? "#CCFF8A" : "#B9D3FF";
/*if ($rowa['status_review']=="1")
{
//if ($rowa['rev']!=$initid)
//{
$navigasi = "
<a href='replymqcari.php?key=$key&field=$field&urutan=$urutan&id_jud=$id_jud&halaman=$halaman&id_rev=$rowa[id_rev_mhs]&urutan_rep=$in'><img src='images/quote.gif'>
<a href='privatemcari.php?key=$key&field=$field&urutan=$urutan&id_jud=$id_jud&halaman=$halaman&reviewer=$rowa[rev]&urutan_rep=$in'><img src='images/pm.gif'> ";
//}
/*else
{
$navigasi = "
<th width="10%">Putusan</th>
<th width="10%">Review Mahasiswa</th>
<th colspan="2">Detail</th>
</tr>
<?php
$no = 1;
while ($r = mysql_fetch_array($execsql)) {
$id = $r['id'];
$sqla = "SELECT COUNT(id_judul) as 'rev' FROM review_mhs WHERE id_judul='{$id}' and status='1'";
$execsqla = mysql_query($sqla);
$data = mysql_fetch_array($execsqla);
$isi = $r['judul_praoutline'];
$status = $r['status_review'] == "1" ? "Opened" : "Closed";
$tgl_indo = tgli($r['A']);
$tgltetap = tgli($r['tgr']);
if ($r['kep_akhir'] == "0") {
$kep = "<b>Tidak Disetujui</b>";
} else {
if ($r['kep_akhir'] == "1") {
$kep = "<b>Disetujui</b>";
} else {
$kep = "<b>Dalam PROSES</b>";
}
}
$cekdos = mysql_query("SELECT nama_dosen FROM data_dosen WHERE NIP='{$r['pemb1']}'");
$cekdosa = mysql_query("SELECT nama_dosen FROM data_dosen WHERE NIP='{$r['pemb2']}'");
$cekdosb = mysql_query("SELECT nama_dosen FROM data_dosen WHERE NIP='{$r['peng1']}'");
$cekdosc = mysql_query("SELECT nama_dosen FROM data_dosen WHERE NIP='{$r['peng2']}'");
$a = mysql_fetch_array($cekdos);
$b = mysql_fetch_array($cekdosa);
$rev_suara = $row['review_sound'] == "" ? "N/A" : "<a href='../dosen-spota/upload/{$row['review_sound']}'><img src='../images/sound.gif'></a> [..: Klik kanan Save Target As untuk download :..]";
$color = $row['jenis_rev'] == "1" ? "#FF0000" : "#000000";
$color1 = $row['jenis_rev'] == "1" ? "#E8DDB3" : "#DCDCDC";
$con = $row['jenis_rev'] == "1" ? "<b>Putusan</b>" : "<b>Komentar</b>";
$title = $row['nama_dosen'] == NULL ? "Mahasiswa" : "Dosen";
$warna = $row['nama_dosen'] == NULL ? "#CCFF8A" : "#B9D3FF";
if (empty($row['hasil'])) {
$con1 = "";
}
if ($row['hasil'] == "1") {
$con1 = "<b>[..: Setuju :..]</b>";
}
if ($row['hasil'] == "0") {
$con1 = "<b>[..: Tidak Setuju :..]</b>";
}
$tgl = tgli($row['tanggal']);
$text = html_entity_decode($row['review_text']);
echo "<table width='100%' align='center'>\r\n <tr>\r\n <td width='15%' style='background-color:{$color1};'><img src='../images/user.gif'> {$title}</td>\r\n\t<td width='85%' align='right' style='background-color:{$color1};'>";
/*if ($result['status_review']=="1")
{
if ($row['reviewer']!=$initid)
{
$navigasi = "
<a href='replydq.php?key=$key&field=$field&urutan=$urutan&id_jud=$id_jud&halaman=$halaman&id_rev=$row[id_review]&urutan_rep=$no'><img src='images/quote.gif'>
<a href='privatem.php?key=$key&field=$field&urutan=$urutan&id_jud=$id_jud&halaman=$halaman&reviewer=$row[reviewer]&urutan_rep=$no'><img src='images/pm.gif'> ";
}
else
{
$navigasi = "
<a href='replydq.php?key=$key&field=$field&urutan=$urutan&id_jud=$id_jud&halaman=$halaman&id_rev=$row[id_review]&urutan_rep=$no'><img src='images/quote.gif'>
<a href='edita.php?key=$key&field=$field&urutan=$urutan&id_jud=$id_jud&halaman=$halaman&id_rev=$row[id_review]&urutan_rep=$no'><img src='images/edit.gif'></a>
<tr>
<?php
$no = $posisi + 1;
while ($row = mysql_fetch_array($result_tampil)) {
$id = $row['id'];
$sql = "SELECT COUNT(id_judul) as 'rev' FROM review_mhs WHERE id_judul='{$id}'";
$execsql = mysql_query($sql);
$data = mysql_fetch_array($execsql);
$isi = $row['judul_praoutline'];
$isi_baru = str_replace($multikey, $search_replace, $isi);
$isi_display = substr($isi_baru, 0, 800);
//$isi_display = substr($isi_baru, 0, strrpos($isi_display, " "));
//echo "$isi_baru<br>";
$status = $row['status_review'] == "1" ? "Opened" : "Closed";
$tgl_indo = tgli($row['A']);
$tgltetap = tgli($row['tgr']);
if ($row['kep_akhir'] == "0") {
$kep = "<b>Tidak Disetujui</b>";
} else {
if ($row['kep_akhir'] == "1") {
$kep = "<b>Disetujui</b>";
} else {
$kep = "<b>Dalam PROSES</b>";
}
}
$cekdos = mysql_query("SELECT nama_dosen FROM data_dosen WHERE NIP='{$row['pemb1']}'");
$cekdosa = mysql_query("SELECT nama_dosen FROM data_dosen WHERE NIP='{$row['pemb2']}'");
$cekdosb = mysql_query("SELECT nama_dosen FROM data_dosen WHERE NIP='{$row['peng1']}'");
$cekdosc = mysql_query("SELECT nama_dosen FROM data_dosen WHERE NIP='{$row['peng2']}'");
$a = mysql_fetch_array($cekdos);
$b = mysql_fetch_array($cekdosa);
<meta name="copyright" content="nikolaidiez - Teknik Informatika - UNTAN" />
<link href="default.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body class="admin">
<div id="header"></div>
<div id="main">
<?php
include "menu.php";
?>
<div id="tam">
<?php
$sqlb = mysql_query("SELECT * FROM review_mhs, data_mahasiswa WHERE data_mahasiswa.NIM=review_mhs.NIM and status='0'");
$no = 1;
while ($rowa = mysql_fetch_array($sqlb)) {
$tglm = tgli($rowa['tanggal']);
$textm = html_entity_decode($rowa['review']);
//$milik = ($rowa['up']==$rowa['rev']? "#CCFF8A" : "#B9D3FF");
//if ($rowa['status']=="0")
//{
$navigasi = "\r\n\t<a href='tubahstatus.php?id_rev={$rowa['id_rev_mhs']}' onclick=\"return confirm('Apakah Anda ingin menampilkan review mahasiswa ini?')\"><img src='images/izin.gif'></a> \r\n\t<a href='teditrev.php?id_rev={$rowa['id_rev_mhs']}&urutan_rep={$no}'><img src='images/edit.gif'></a> \r\n\t<a href='tdeleterev.php?id_rev={$rowa['id_rev_mhs']}' onclick=\"return confirm('Apakah Anda benar-benar akan menghapus review ini?')\"><img src='images/delete.gif'></a> \t\r\n\t";
//}
//else
//{
/*$navigasi =
"
<a href='editrevmhs.php?key=$key&field=$field&urutan=$urutan&id_jud=$id_jud&halaman=$halaman&id_rev=$rowa[id_rev_mhs]&urutan_rep=$in'><img src='images/edit.gif'></a>
<a href='deleterevmhs.php?key=$key&field=$field&urutan=$urutan&id_jud=$id_jud&halaman=$halaman&id_rev=$rowa[id_rev_mhs]&urutan_rep=$in' onclick=\"return confirm('Apakah Anda benar-benar akan menghapus review ini?')\"><img src='images/delete.gif'></a>
<a href='privatem.php?key=$key&field=$field&urutan=$urutan&id_jud=$id_jud&halaman=$halaman&reviewer=$rowa[rev]&id_rev=$rowa[id_rev_mhs]&kode=Mahasiswa&urutan_rep=$in'><img src='images/pm.gif'>
<a name='$in'><a href='#'><img src='images/top.gif'></a></a>
";
<th colspan="3">Detail</th>
</tr><tr>
<?php
$no = $posisi + 1;
while ($row = mysql_fetch_array($result_tampil)) {
$id = $row['id'];
$sql = "SELECT COUNT(id_judul) as 'rev' FROM review_mhs WHERE id_judul='{$id}'";
$execsql = mysql_query($sql);
$data = mysql_fetch_array($execsql);
$isi = $row['judul_praoutline'];
//$isi_baru = str_replace($multikey, $search_replace, $isi);
//$isi_display = substr($isi_baru, 0, 800);
//$isi_display = substr($isi_baru, 0, strrpos($isi_display, " "));
//echo "$isi_baru<br>";
$status = $row['status_review'] == "1" ? "Opened" : "Closed";
$tgl_indo = tgli($row['A']);
/*if ($row['T'] > $row['S'])
{
$link = "ubahstatus.php?act=app&id=$id&halaman=$halaman&punya=$row[NIM]' onclick=\"return confirm('Apakah Anda benar-benar akan menutup desain praoutline ini?')\"";
}
else if ($row['T'] < $row['S'])
{
$link = "ubahstatus.php?act=dis&id=$id&halaman=$halaman&punya=$row[NIM]' onclick=\"return confirm('Apakah Anda benar-benar akan menutup desain praoutline ini?')\"";
}
else
{*/
$link = "lbhjauh.php?id={$id}&halaman={$halaman}&punya={$row['NIM']}&urutan={$no}";
//}
echo "\r\n <td align='center'><img src='../images/show.jpg'></td>\r\n <td><font color='#B61C03'><b>{$isi}</b></font></td>\r\n <td align='center'>{$row['P']}</td>\r\n <td align='center'>{$row['R']}<br><br>Y : <font color=#01016F><b>{$row['T']}</b></font> -- N : <font color=#FA0303><b>{$row['S']}</b></font></td>\r\n <td align='center'>{$data['rev']}</td>\r\n <td width='12%'>\r\n Oleh : <font color=#583000><b>{$row['NIM']}</b></font><br>\r\n Tanggal : {$tgl_indo}<br>\r\n Waktu : {$row['B']}<br>\r\n Status : <font color=#7BC409><b>{$status}</b></font>\r\n </td>\r\n\t <td width='2%'><a href='{$link}'><img src='../images/tutup.gif' title='Tutup'></a></td>\r\n <td width='2%'><a name='{$no}'><a href='#'><img src='images/top.gif'></a></a></td>\r\n </tr>";
$no++;
}
$sqlb = mysql_query("SELECT \r\n\tCOUNT(id_upload) as 'M',\r\n\tCOUNT(IF(jenis_rev=0,1,null)) as 'Q',\r\n COUNT(IF(jenis_rev=1,1,null)) as 'R',\r\n COUNT(IF(hasil='0',1,null)) as 'S',\r\n COUNT(IF(hasil=1,1,null)) as 'T' \r\n \tfrom upload_mhs, review_praoutline WHERE id=id_upload and id_upload='{$result['id_upload']}'");
$row = mysql_fetch_array($sqlb);
$status = $result['status_review'] == "1" ? "Opened" : "Closed";
$tgl_indo = tgli($result['A']);
$cetaknm = nama($result['NIM']);
echo "\r\n <td align='center'><img src='../images/show.jpg'></td>\r\n <td><a href='recent1.php?mode=rep&id_jud={$result['id']}#bottom'>{$result['judul_praoutline']}</a></td>\r\n <td align='center'>{$row['M']}</td>\r\n <td align='center'>{$row['R']}<br><br>Y : <font color=#01016F><b>{$row['T']}</b></font> -- N : <font color=#FA0303><b>{$row['S']}</b></font></td>\r\n <td width='14%'>\r\n Oleh : <font color=#583000><b>{$result['NIM']}</b></font><br><font color=#072dba><b>{$cetaknm}</b></font><br>\r\n Tanggal : {$tgl_indo}<br>\r\n Waktu : {$result['B']}<br>\r\n Status : <font color=#7BC409><b>{$status}</b></font>\r\n </td>\r\n <td width='2%'><a name='{$no}'><a href='#'><img src='images/top.gif'></a></a></td>\r\n </tr>";
$no++;
}
echo "\r\n <tr colspan='6'>\r\n\r\n </tr>";
echo "</table>";
} else {
$sqld = "SELECT DISTINCT(id_upload) as 'new', \r\n\tjudul_praoutline, \r\n\tNIM, status_review, \r\n upload_mhs.tanggal as 'A',\r\n upload_mhs.waktu as 'B', \r\n\tCOUNT(id_upload) as 'M',\r\n\tCOUNT(IF(jenis_rev=0,1,null)) as 'Q',\r\n COUNT(IF(jenis_rev=1,1,null)) as 'R',\r\n COUNT(IF(hasil='0',1,null)) as 'S',\r\n COUNT(IF(hasil=1,1,null)) as 'T'\r\n\tFROM review_praoutline, upload_mhs \r\n\tWHERE id_upload NOT IN (SELECT id_upload FROM review_praoutline, upload_mhs WHERE id=id_upload and jenis_rev='1' and reviewer='{$initid}' ORDER by id_upload) \r\n\tand id=id_upload \r\n\tand status_review='1' GROUP by new";
$hasild = mysql_query($sqld);
//$jum = mysql_num_rows($hasil);
$no = 1;
while ($resultd = mysql_fetch_array($hasild)) {
$status = $resultd['status_review'] == "1" ? "Opened" : "Closed";
$tgl_indo = tgli($resultd['A']);
$cetaknm = nama($resultd['NIM']);
echo "\r\n <td align='center'><img src='../images/show.jpg'></td>\r\n <td><a href='recent1.php?mode=nodes&id_jud={$resultd['new']}'>{$resultd['judul_praoutline']}</a></td>\r\n <td align='center'>{$resultd['M']}</td>\r\n <td align='center'>{$resultd['R']}<br><br>Y : <font color=#01016F><b>{$resultd['T']}</b></font> -- N : <font color=#FA0303><b>{$resultd['S']}</b></font></td>\r\n <td width='14%'>\r\n Oleh : <font color=#583000><b>{$resultd['NIM']}</b></font><br><font color=#072dba><b>{$cetaknm}</b></font><br>\r\n Tanggal : {$tgl_indo}<br>\r\n Waktu : {$resultd['B']}<br>\r\n Status : <font color=#7BC409><b>{$status}</b></font>\r\n </td>\r\n <td width='2%'><a name='{$no}'><a href='#'><img src='images/top.gif'></a></a></td>\r\n </tr>";
$no++;
}
echo "\r\n <tr colspan='6'>\r\n\r\n </tr>";
echo "</table>";
}
}
?>
</body>
</html>
