Files
spota-dev/mahasiswa/page/praoutline/review.php
Power BI Dev efdb11db3f Add SPOTA core PHP application
Add the main admin, dosen, mahasiswa, API, and service code needed to run the core legacy application with configurable upload storage.
2026-05-02 10:08:52 +07:00

595 lines
22 KiB
PHP

<?php $db = new dB($dbsetting); ?>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css">
<style>
.mic-button {
position: absolute;
right: 10px;
bottom: 10px;
width: 30px;
height: 30px;
border: none;
border-radius: 50%;
background-color: #2196F3;
color: white;
cursor: pointer;
display: flex;
justify-content: center;
align-items: center;
z-index: 1;
}
.mic-button.recording {
background-color: #f44336;
animation: pulse 1.5s infinite;
}
</style>
<div class="row">
<div class="col-sm-12">
<ol class="breadcrumb">
<li>
<i class="clip-home-3"></i>
<a href="<?php echo MHS_PAGE; ?>">
Home
</a>
</li>
<?php
if ($_GET['prid'] != '') {
echo '
<li>
<a href="'.MHS_PAGE.'dashboard.php?page=praoutline&menu=&menu=daftar-praoutline">
Daftar Judul
</a>
</li>
<li class="active">
Review
</li>';
} else {
echo '<li class="active">
Review
</li>';
}
?>
<li class="search-box">
<label><?php echo tanggalIndo(date('Y-m-d H:i:s'), 'j F Y, H:i'); ?></label>
</li>
</ol>
<div class="page-header">
<h1>Review <?php echo($_GET['nim'] != '') ? '<small>'.$_GET['nim'].'</small>' : ''; ?><small></small></h1>
</div>
</div>
</div>
<?php
$nim = $_SESSION['login-mhs']['nim'];
unset($_SESSION['selected_user']);
$where = ' WHERE ';
if (isset($_GET['prid'])) {
//tampilan review dari hasil pencarian
$idpra = $_GET['prid'];
if (!ctype_digit($idpra)) {
$idpra = '0';
}
$where .= " tp.id='$idpra' ";
$checkpraoutline = "SELECT id,nim FROM tbpraoutline WHERE id='$idpra' LIMIT 1";
} else {
//tampilan default review milik mahasiswa
//print_r($_SESSION['new_review_mhs']);
if (count($_SESSION['new_review_mhs']) > 0) {
$id_notif_r = implode(',', $_SESSION['new_review_mhs']);
$db->runQuery("UPDATE tmp_notif_r SET `read`='Y' WHERE id IN ($id_notif_r)");
}
$checkpraoutline = "SELECT id,nim FROM tbpraoutline WHERE nim='$nim' ORDER BY id DESC LIMIT 1";
}
//echo $checkpraoutline;
$db->runQuery($checkpraoutline);
if ($db->dbRows() > 0) {
$fromtp = $db->dbFetch();
$selectednim = $fromtp['nim']; // nim dari praoutline
$selectedid = $fromtp['id'];
if (!isset($_GET['prid'])) {
$where .= "tp.nim='$selectednim' AND tp.id='$selectedid'";
}
$sqlKK = 'SELECT * FROM tb_kelompok_keahlian';
$db->runQuery($sqlKK);
$dataKK = array();
while ($kk = $db->dbFetch()) {
$idKK = $kk['idKK'];
$namaKK = $kk['namaKK'];
$dataKK[$idKK] = $namaKK;
}
$stat_judul = "SELECT
tp.id,
tp.nim,
tp.deskripsi,
tm.nmLengkap as nama,
tp.judul,
tp.tgl_upload,
tp.wkt_upload,
tp.status_usulan,
tp.kelompokKeahlian
FROM tbpraoutline tp
JOIN tbmhs tm ON (tp.nim=tm.nim)
$where";
// echo $stat_judul;
$db->runQuery($stat_judul);
$kelompokKeahlian = ' <span class="label label-success">Tidak Ada Kelompok Keahlian</span>';
if ($db->dbRows() > 0) {
$stat = $db->dbFetch();
$sql = "SELECT * FROM tbreview WHERE idpraoutline = '$selectedid'";
$resultReview = $db->runQuery($sql);
$banyakReview = 0;
$banyakKomentar = 0;
$banyakPutusan = 0;
$banyakSetuju = 0;
$banyakTidakSetuju = 0;
while ($aRowReview = $db->dbFetch($resultReview)) {
$jenisReview = $aRowReview['jenis_review'];
$banyakReview++;
switch($jenisReview){
case 0 : $banyakKomentar++; break;
case 1 : $banyakPutusan++;
if($aRowReview['putusan'] == '1'){
$banyakSetuju++;
}
if($aRowReview['putusan'] == '0'){
$banyakTidakSetuju++;
}
break;
}
}
if ($stat['status_usulan'] == 0) {
$statusPraoutline = ' - <span class="label label-default">Dalam Proses</span>';
} elseif ($stat['status_usulan'] == 1) {
$statusPraoutline = ' - <span class="label label-success">Judul Diterima</span>';
} elseif ($stat['status_usulan'] == 2) {
$statusPraoutline = ' - <span class="label label-danger">Judul Ditolak</span>';
} elseif ($stat['status_usulan'] == 3) {
$statusPraoutline = ' - <span class="label label-danger">Judul Gugur</span>';
}
$idKelompokKeahlian = $stat['kelompokKeahlian'];
if (isset($dataKK[$idKelompokKeahlian])) {
$kelompokKeahlian = ' <span class="label label-success">'.$dataKK[$idKelompokKeahlian].'</span>';
} ?>
<div class="row">
<div class="col-sm-12">
<p><h3 style="text-align:left;margin-top:0"><?php echo strtoupper($stat['judul']); ?></h3></p>
<?php echo $stat['deskripsi']; ?>
<div class="row">
<div class="col-sm-8">
<p>Kelompok Keahlian : <?php echo $kelompokKeahlian; ?></p>
<p>Oleh <?php echo $stat['nama'].' ('.$stat['nim'].'), pada tanggal '.tanggalIndo($stat['tgl_upload'], 'j F Y').' '.$statusPraoutline; ?> - <a class="btn btn-xs btn-bricky" href="<?php echo DOMAIN_UTAMA.'/download.php?doc_id='.$stat['id']; ?>"><i class="fa fa-trash-o"></i>Download File</a> - <a target="_blank" href="<?php echo DOMAIN_UTAMA.'/cetak.php?rev_id='.$stat['id']; ?>" class="btn btn-xs btn-default" title="">Cetak Isi Review</a></p>
</div>
<div class="col-sm-4 text-right">
<p>Jumlah Review : <span class="badge badge-info"><?php echo $banyakReview; ?></span> | Setuju : <span class="badge badge-success"><?php echo $banyakSetuju; ?></span> | Tidak Setuju : <span class="badge badge-danger"><?php echo $banyakTidakSetuju; ?></span></p>
</div><hr/>
</div>
<!-- UNTUK JUDUL YG SUDAH DI CLOSE SEMUA STATUS -->
<?php
$kep_final = "SELECT *,
(SELECT nmLengkap FROM tbdosen WHERE tbdosen.nip=pemb1) as dpemb1,
(SELECT nmLengkap FROM tbdosen WHERE tbdosen.nip=pemb2) as dpemb2,
(SELECT nmLengkap FROM tbdosen WHERE tbdosen.nip=peng1) as dpeng1,
(SELECT nmLengkap FROM tbdosen WHERE tbdosen.nip=peng2) as dpeng2
FROM tbrekaphasil
WHERE idProdi='".$_SESSION['login-mhs']['prodi']."'
AND idpraoutline='".$stat['id']."'
AND kep_akhir='".$stat['status_usulan']."' LIMIT 1";
switch ($stat['status_usulan']) {
case '1':
//echo $kep_final;
$db->runQuery($kep_final);
if ($db->dbRows() > 0) {
$kep = $db->dbFetch(); ?>
<div class="alert alert-block alert-info">
<!-- <h4 class="alert-heading"><i class="fa fa-info-circle"></i> Info!</h4> -->
<div class="row">
<div class="col-sm-3">
<strong><u>Ditetapkan</u></strong> <br/>
Tanggal : <?php echo tanggalIndo($kep['tgl_kep'], 'j F Y'); ?> <br/>
Waktu : <?php echo substr($kep['wkt_kep'], 0, 5); ?> <br/>
Semester : <?php echo $kep['semester']; ?> <br/>
Tahun Akademik : <?php echo $kep['tahun_ajaran']; ?>
</div>
<div class="col-sm-4">
<strong><u>Dosen Pembimbing & Penguji</u></strong><br/>
Pembimbing 1 : <?php echo $kep['dpemb1']; ?> <br/>
Pembimbing 2 : <?php echo $kep['dpemb2']; ?> <br/>
Penguji 1 : <?php echo $kep['dpeng1']; ?> <br/>
Penguji 2 : <?php echo $kep['dpeng2']; ?>
</div>
<div class="col-sm-4">
<strong><u>Judul Outline</u></strong><br/>
<?php echo $kep['judul_final']; ?><br/>
<strong><u>Catatan</u></strong><br/>
<?php echo $kep['ket']; ?>
</div>
</div>
</div>
<?php
}/*else{
echo '<div class="alert alert-danger">
<i class="clip-cancel-circle"></i>
<strong>Maaf!</strong> Data Tidak Ditemukan..
</div>';
}*/
break;
case '2':
$db->runQuery($kep_final);
if ($db->dbRows() > 0) {
$tolak = $db->dbFetch(); ?>
<div class="alert alert-block alert-danger">
<div class="row">
<div class="col-sm-3">
<strong><u>Ditetapkan</u></strong> <br/>
Tanggal : <?php echo tanggalIndo($tolak['tgl_kep'], 'j F Y'); ?> <br/>
Waktu : <?php echo substr($tolak['wkt_kep'], 0, 5); ?> <br/>
</div>
<div class="col-sm-9">
<strong><u>Catatan</u></strong><br/>
<?php echo $tolak['ket']; ?>
</div>
</div>
</div>
<?php
}
break;
} ?>
<!-- UNTUK JUDUL YG SUDAH DI CLOSE end -->
</div>
</div>
<?php
if ($banyakReview > 0) {
?>
<div class="row">
<div class="col-sm-12">
<div class="panel panel-default">
<div class="panel-body">
<?php
$rev = "SELECT tr.*,td.nmLengkap as nmDosen,td.foto as ftdosen, tm.nmLengkap as nmMhs,tm.foto as ftmhs FROM tbreview tr
LEFT JOIN tbdosen td ON (td.nip=tr.reviewer)
LEFT JOIN tbmhs tm ON (tm.nim=tr.reviewer)
HAVING tr.idpraoutline='".$stat['id']."'";
//echo $rev;
$db->runQuery($rev);
if ($db->dbRows() > 0) {
$_SESSION['selected_user'] = array();
echo '<ol class="discussion">';
while ($r = $db->dbFetch()) {
if ($r['reviewer'] == $nim) {
$jenis = 'self';
$nama = '<span style="float:right"><small class="label label-info">'.$r['nmMhs'].'</small> <small class="label label-inverse" style="cursor:pointer;" onclick="location.href=\'?page=praoutline&menu=review&quote='.$r['id'].'#post_review\'">Quote</small></span><br/>';
$foto = $r['ftmhs'];
} else {
if (!in_array($r['reviewer'], $_SESSION['selected_user'])) {
$_SESSION['selected_user'][] = $r['reviewer'];
}
$jenis = 'other';
$nama = '<small class="label label-info">'.$r['nmDosen'].'</small> <small class="label label-inverse"><span style="cursor:pointer" onclick="location.href=\'?page=praoutline&menu=review&quote='.$r['id'].'#post_review\'">Quote</span></small><br/>';
$foto = $r['ftdosen'];
}
if ($r['putusan'] == '1') {
$putusan = 'Setuju';
} elseif ($r['putusan'] == '0') {
$putusan = 'Tidak Setuju';
} else {
$putusan = '';
} ?>
<li class="<?php echo $jenis; ?>">
<div class="avatar">
<img alt="" style="width:50px;height:50px;" src="../img/<?php echo $foto; ?>">
</div>
<div class="messages">
<?php echo $nama; ?>
<p>
<?php echo bbcode_quote($r['review_text']); ?>
</p><br/>
<span class="time"><small><em><?php echo tanggalIndo($r['tgl'], 'j F Y'); ?>, <?php echo substr($r['wkt'], 0, 5); ?></em></small> <small class="label label-danger"><?php echo $putusan; ?></small></span>
</div>
</li>
<?php
}
echo '</ol>';
} else {
echo '<div class="alert alert-danger">
<i class="clip-cancel-circle"></i>
<strong>Maaf!</strong> Belum Ada Review..
</div>';
}
/*print_r($_SESSION['selected_user']);*/ ?>
</div>
</div>
</div>
<?php
//QUOTE KOMENTAR / TANGGAPAN
if ($_GET['quote']) {
if (ctype_digit($_GET['quote'])) {
$nmReviewer = '';
$text = '';
$q = "SELECT tr.review_text,tr.tgl,tr.wkt, td.nmLengkap as nmDosen, tm.nmLengkap as nmMhs
FROM tbreview tr
LEFT JOIN tbdosen td ON (td.nip=tr.reviewer)
LEFT JOIN tbmhs tm ON (tm.nim=tr.reviewer)
WHERE tr.id='".$_GET['quote']."' LIMIT 1";
$db->runQuery($q);
if ($db->dbRows() > 0) {
$qq = $db->dbFetch();
if ($qq['nmDosen'] != '') {
$nmReviewer = $qq['nmDosen'];
} elseif ($qq['nmMhs'] != '') {
$nmReviewer = $qq['nmMhs'];
}
if ($qq['putusan'] == '1') {
$putusan = 'Setuju';
} elseif ($qq['putusan'] == '0') {
$putusan = 'Tidak Setuju';
} else {
$putusan = '';
}
$text .= '[quote=';
$text .= "$nmReviewer;".tanggalIndo($qq['tgl'], 'j F Y').']';
$text .= $qq['review_text'];
$text .= '[/quote]';
}
}
}
//QUOTE KOMENTAR / TANGAPAN end?>
<?php
$tanggapan = true;
$selisih = selisih_tgl($stat['tgl_upload'], date('Y-m-d'));
if ($selectednim == $_SESSION['login-mhs']['nim'] and $stat['status_usulan'] == '0') {
$tanggapan = true;
} else {
$tanggapan = false;
}
/*if($_SESSION['login-dosen']['prodi']=="2"){
if($selisih>7){
if($stat['setuju']>1){
$tanggapan=false;
}else{
$tanggapan=true;
}
}
}*/ ?>
<?php if ($tanggapan == true) {
?>
<div class="col-sm-12">
<div class="panel panel-default">
<!-- <div class="panel-heading"></div> -->
<form id="post_review" method="POST" action="page/praoutline/act.praoutline.php">
<input type="hidden" name="act" value="post_review" />
<input type="hidden" name="idpra" value="<?php echo $stat['id']; ?>" />
<div class="panel-body">
<div class="form-group">
Tanggapan MIC: <br/>
<textarea name="text_review" rows="12" id="text_review" class=" ckeditor form-control"><?php echo $text; ?></textarea>
</div>
<div class="form-group">
<button type="submit" class="btn btn-primary" id="reply"><i class="clip-upload"></i> Submit</button>
<span id="loading" style="display:none"><i class="clip-spin-alt icon-spin"></i><em> Loading..</em></span>
</div>
</div>
</form>
<button class="mic-button" id="micButton" title="Mulai/Pause Rekaman">
<i class="fas fa-microphone"></i>
</button>
</div>
</div>
<?php
} ?>
</div>
<?php
} else {
echo "<div class='alert alert-danger'>Belum Ada Review dari Dosen.</div>"; ?>
<div class="row">
<?php
$tanggapan = true;
$selisih = selisih_tgl($stat['tgl_upload'], date('Y-m-d'));
if ($selectednim == $_SESSION['login-mhs']['nim'] and $stat['status_usulan'] == '0') {
$tanggapan = true;
} else {
$tanggapan = false;
}
/*if($_SESSION['login-dosen']['prodi']=="2"){
if($selisih>7){
if($stat['setuju']>1){
$tanggapan=false;
}else{
$tanggapan=true;
}
}
}*/ ?>
<?php if ($tanggapan == true) {
?>
<div class="col-sm-12">
<div class="panel panel-default">
<!-- <div class="panel-heading"></div> -->
<form id="post_review" method="POST" action="page/praoutline/act.praoutline.php">
<input type="hidden" name="act" value="post_review" />
<input type="hidden" name="idpra" value="<?php echo $stat['id']; ?>" />
<div class="panel-body">
<div class="form-group">
Tanggapan OKE: <br/>
<textarea name="text_review" rows="12" id="text_review" class="ckeditor form-control"></textarea>
</div>
<div class="form-group">
<button type="submit" class="btn btn-primary" id="reply"><i class="clip-upload"></i> Submit</button>
<span id="loading" style="display:none"><i class="clip-spin-alt icon-spin"></i><em> Loading..</em></span>
</div>
</div>
</form>
<button class="mic-button" id="micButton" title="Mulai/Pause Rekaman">
<i class="fas fa-microphone"></i>
</button>
</div>
</div>
<?php
} ?>
</div>
<?php
}
}
} else {
echo "<div class='alert alert-danger'>Maaf. Data Review Tidak Ditemukan. </div>";
}
?>
<script>
class SpeechToText {
constructor() {
this.micButton = document.getElementById('micButton');
this.isRecording = false;
this.recognition = null;
this.lastFinalTranscript = '';
this.init();
}
init() {
if (!('SpeechRecognition' in window || 'webkitSpeechRecognition' in window)) {
this.showError('Browser tidak mendukung fitur speech recognition');
this.micButton.disabled = true;
return;
}
this.recognition = new (window.SpeechRecognition || window.webkitSpeechRecognition)();
this.setupRecognition();
this.setupEventListeners();
}
setupRecognition() {
this.recognition.lang = 'id-ID';
this.recognition.continuous = true;
this.recognition.interimResults = true;
this.recognition.onstart = () => {
this.isRecording = true;
this.micButton.classList.add('recording');
};
this.recognition.onresult = (event) => {
let finalTranscript = '';
for (let i = event.resultIndex; i < event.results.length; ++i){
const transcript = event.results[i][0].transcript;
if(event.results[i].isFinal){
finalTranscript += transcript;
}
}
if(finalTranscript && finalTranscript !== this.lastFinalTranscript){
this.lastFinalTranscript = finalTranscript;
const editor = CKEDITOR.instances["text_review"];
editor.focus();
editor.insertText(' ' + finalTranscript);
}
};
this.recognition.onend = () => {
this.isRecording = false;
this.micButton.classList.remove('recording');
};
this.recognition.onerror = (event) => {
this.handleError(event.error);
};
}
setupEventListeners() {
this.micButton.addEventListener('click', () => this.toggleRecording());
// Handle window focus changes
window.addEventListener('focus', () => {
if (this.isRecording) {
this.recognition.stop();
this.recognition.start();
}
});
}
toggleRecording() {
if (!this.isRecording) {
this.startRecording();
} else {
this.stopRecording();
}
}
startRecording() {
try {
this.recognition.start();
} catch (error) {
this.handleError(error);
}
}
stopRecording() {
try {
this.recognition.stop();
} catch (error) {
this.handleError(error);
}
}
handleError(error) {
console.error('Speech recognition error:', error);
this.isRecording = false;
this.micButton.classList.remove('recording');
let errorMessage = 'Terjadi kesalahan saat merekam suara';
switch (error) {
case 'no-speech':
errorMessage = 'Tidak terdeteksi suara';
break;
case 'audio-capture':
errorMessage = 'Tidak dapat mengakses mikrofon';
break;
case 'not-allowed':
errorMessage = 'Akses mikrofon ditolak';
break;
}
this.showError(errorMessage);
}
showError(message) {
// Create error notification
const errorDiv = document.createElement('div');
errorDiv.className = 'alert alert-danger';
errorDiv.textContent = message;
document.querySelector('.comment-section').insertBefore(errorDiv, document.querySelector('h3'));
// Remove error after 5 seconds
setTimeout(() => errorDiv.remove(), 5000);
}
cleanup() {
if (this.recognition) {
this.recognition.stop();
}
}
}
// Initialize speech to text
const speechToText = new SpeechToText();
// Cleanup on page unload
window.addEventListener('beforeunload', () => {
speechToText.cleanup();
});
</script>