data07.php

<script type="text/javascript" src="<?php echo $base_url;?>asset/ckeditor/ckeditor.js"></script>
<?php
if($_GET){
    if(isset($_POST['btnSave'])){
        $text   = $_POST['text'];
        $text   = str_replace("'","&acute;",$text);
        $mhs    = $_POST['mhs'];
        $mhs    = str_replace("'","&acute;",$mhs);
        $dosen  = $_POST['dosen'];
        $dosen  = str_replace("'","&acute;",$dosen);
        $bimb   = $_POST['bimb'];
        $bimb   = str_replace("'","&acute;",$bimb);
        $tgl = date("Y-m-d");
        $waktu = date("H:i:s");

        $allowed_ext    = array('docx', 'xls', 'mdb', 'jpeg', 'bmp', 'png', 'rar', 'zip');
        $file_name      = $_FILES['file']['name'];
        $file_ext       = strtolower(end(explode('.', $file_name)));
        $file_size      = $_FILES['file']['size'];
        $file_tmp       = $_FILES['file']['tmp_name'];
        $acak           = rand(1,9999999);
        $name = $acak.$file_name;

        if(in_array($file_ext, $allowed_ext) === true){
            if($file_size < 1044070){
                $lokasi = 'asset/files/'.$name.'.'.$file_ext;
                move_uploaded_file($file_tmp, $lokasi);
                $in = "INSERT INTO tbl_review_bimbingan SET id_mhs = '$mhs', id_dosen = '$dosen', id_bimbingan='$bimb', sender='mahasiswa', keterangan='$text', tgl='$tgl', waktu='$waktu', lampiran='$lokasi'";
                $qrySave=mysql_query($in, $koneksidb) or die ("Gagal query".mysql_error());
                if($qrySave){
                echo "<meta http-equiv='refresh' content='0; url=?page=review-mahasiswa&review=$bimb'>";
                echo "<strong>Selamat!</strong> Berhasil mengirim.";
                }else{
                    $message[] = "Gagal upload file!";
                }
            }else{
                $message[] = "Besar ukuran file (file size) maksimal 1 Mb!";
            }
        }else{
            $message[] = "Ekstensi file tidak di izinkan!";
        }
        if (! count($message)==0 ){
            echo "<strong style='color:red;'>ERROR!</strong><hr>";
                $Num=0;
                foreach ($message as $indeks=>$pesan_tampil) {
                $Num++;
                    echo "&nbsp;&nbsp;$Num. $pesan_tampil<br>";
                }
        }
    }
    $kodeEdit= isset($_GET['review']) ?  $_GET['review'] : $_POST['txtkode'];
    $sqlShow = "SELECT * FROM tbl_review_bimbingan WHERE id_bimbingan='$kodeEdit'";
    $qryShow = mysql_query($sqlShow, $koneksidb)  or die ("Query ambil bimbingan salah : ".mysql_error());
    $dataCount = mysql_num_rows($qryShow);

    $bimShow = "SELECT a.id_bimbingan, a.status_ta, a.bab_bimbingan, a.sub_bab, a.mulai_bimbingan, b.nama_dosen FROM tbl_bimbingan a left join tbl_dosen b on a.id_dosen=b.id_dosen WHERE id_bimbingan='$kodeEdit'";
    $BryShow = mysql_query($bimShow, $koneksidb)  or die ("Query bimbingan salah : ".mysql_error());
    $dbShow = mysql_fetch_array($BryShow);
    if($dbShow["bab_bimbingan"]==1){
        $bab = "BAB 1 Latar Belakang";
    }elseif($dbShow["bab_bimbingan"]==2){
        $bab = "BAB 2 Tinjauan Pustaka";
    }elseif($dbShow["bab_bimbingan"]==3){
        $bab = "BAB 3 Metodologi Penelitian dan Perancangan Sistem";
    }elseif($dbShow["bab_bimbingan"]==4){
        $bab = "BAB 4 Hasil Perancangan dan Analisi Aplikasi";
    }elseif($dbShow["bab_bimbingan"]==5){
        $bab = "BAB 5 Penutup";
    }else{
        $bab = "Tidak Ditemukan";
    }

}
?>
<strong>Review Bimbingan dengan bahasan : <u><?php echo $bab; ?> - <?php echo $dbShow["sub_bab"]; ?></u></strong>
<div class="cleaner_h10"></div>
<table border="1" cellpadding="3" cellspacing="0" width="100%" style=" border-collapse: collapse;" class="record" bordercolor="#CCCCCC">
    <tr>
        <td align="left"><a href="?page=diskusi">Kembali</a></td>
    </tr>
    <tr>
        <td>
        <table border="1" cellpadding="3" cellspacing="0" width="100%" style=" border-collapse: collapse;padding:5px;" class="record" bordercolor="#CCCCCC">
            <?php
            if($dataCount==0){
                echo "<b>Tidak ada Review Bimbingan</b>";
            }elseif ($dataCount>=1) {
                while($dataShow = mysql_fetch_assoc($qryShow)){
                    if($dataShow["sender"]=="dosen"){
                        $bg = "8BB381";
                    }elseif($dataShow["sender"]=="mahasiswa"){
                        $bg = "#659EC7";
                    }
                    if($dataShow["sender"]=="dosen"){
                        $dosenShow = mysql_fetch_array(mysql_query("SELECT * FROM tbl_dosen WHERE id_dosen='$dataShow[id_dosen]'"));
                        $nama = $dosenShow["nama_dosen"];
                    }elseif($dataShow["sender"]=="mahasiswa"){
                        $mhsShow = mysql_fetch_array(mysql_query("SELECT * FROM tbl_mahasiswa WHERE id_mhs='$dataShow[id_mhs]'"));
                        $nama = $mhsShow["nama_mhs"];
                    }
            ?>
                <tr id="review-<?php echo $dataShow["id_review_bimbingan"];?>">
                    <td colspan="2" bgcolor="<?php echo $bg; ?>"><?php echo ucwords($dataShow["sender"]); ?></td>
                </tr>
                <tr>
                    <td rowspan="2" width="20%"><b><?php echo $nama; ?></b>
                    <br><br>
                    Tanggal : <?php echo DateToIndo($dataShow["tgl"]); ?><br>
                    Waktu : <?php echo $dataShow["waktu"]; ?><br>
                    </td>
                    <td><?php echo $dataShow["keterangan"]; ?></td>
                </tr>
                <tr>
                    <td>Lampiran : </td>
                </tr>
                <tr>
                    <td colspan="2">&nbsp;</td>
                </tr>
            <?php
                }
            ?>
        </table>
        </td>
    </tr>
</table>
<br>
<form method="post" action="" enctype="multipart/form-data">
    <textarea id="text" cols="110" name="text" rows="10"></textarea>
    <script>CKEDITOR.replace( 'text' );</script>
    <br><?php $ss = mysql_fetch_array($qryShow); ?>
    <input type="file" name="file"><br><input type="text" style="display:none;" value="<?php echo $ss["id_mhs"]; ?>" name="mhs">
    <input type="text" style="display:none;" value="<?php echo $ss["id_dosen"]; ?>" name="dosen"><input type="text" style="display:none;" value="<?php echo $ss["id_bimbingan"]; ?>" name="bimb">
    <span style="color:red;">*perhatian: Lampiran diharapkan menggunakan format NIM-BAB-revisi ke </span><br>
    <span style="color:blue;">**format: .docx, .xls, .mdb, .jpeg, .bmp, .png, .rar, .zip </span><br>
    <input type="submit" name="btnSave" class="btn-kirim-login" value="Kirim">
    <?php } ?>
</form>