<?php
if($_SERVER['REQUEST_METHOD']=='POST'){
include "connect.php";

    $response = array();

    //mendapatkan data
    $id_mhs = $_POST['id_mhs'];
    $nim_mhs = $_POST['nim_mhs'];
    $nama_mhs = $_POST['nama_mhs'];
    $prodi = $_POST['prodi'];
    $sks = $_POST['sks'];
    $judul_skripsi = $_POST['judul_skripsi'];
    $setuju_pa = $_POST['setuju_pa'];
    $setuju_kaprodi = $_POST['setuju_kaprodi'];
    $tanggal_permohonan = $_POST['tanggal_permohonan'];
    $waktu_tunggu = $_POST['waktu_tunggu'];

    $jenis_surat   = $_POST['jenis_surat'];
    $status   = $_POST['status'];
    $kondisi   = $_POST['kondisi'];

    $foto_accjudul = $_FILES['foto_accjudul']['name'];
    $folder_path = 'assest/images/fotoacc/';
    $filename = basename($foto_accjudul);
    $newname = $folder_path.$filename;

    $file_nilai = $_FILES['file_nilai']['name'];
    $filename2 = basename($file_nilai);
    $folder_path2 = 'assest/images/filenilai/';
    $newname2 = $folder_path2.$filename2;

    $cekkondisi = "SELECT kondisi FROM tb_administrasi WHERE id_mhs='$id_mhs' ";
    $resultsd1 = mysqli_query($conn, $cekkondisi);
    $row = mysqli_fetch_assoc($resultsd1);
    $kondisi = $row['kondisi'];

    $birth_newformat = date('Y-m-d H:i:s', strtotime($tanggal_permohonan));
    $birth_newformat2 = date('Y-m-d', strtotime($waktu_tunggu));


    if ($kondisi != 1 || $kondisi == '') {
        $kondisi_awal = 1;
        if ($_FILES['file_nilai']['type'] == "application/pdf") {
                  if (move_uploaded_file($_FILES['foto_accjudul']['tmp_name'], $newname)) {
                         if (move_uploaded_file($_FILES['file_nilai']['tmp_name'], $newname2)) {

                         $sqluser = "INSERT INTO tb_administrasi (id_mhs, nama_mhs, nim_mhs, jenis_surat, sks, judul_skripsi, prodi, setuju_pa, setuju_kaprodi, foto_accjudul, file_nilai, tanggal_permohonan, waktu_tunggu, status, kondisi) VALUES ('$id_mhs', '$nama_mhs', '$nim_mhs', '$jenis_surat', '$sks', '$judul_skripsi', '$prodi', '$setuju_pa', '$setuju_kaprodi', '$filename', '$filename2', '$birth_newformat', '$birth_newformat2', '$status', '$kondisi_awal')";

                          $result = mysqli_query($conn, $sqluser);
                }
                        else {
                            $response["value"] = 0;
                            $response["message"] = "Oops! Gagal Upload";
                            echo json_encode($response);
                            }

                } else {
                    $response["value"] = 0;
                    $response["message"] = "Oops! Gagal Upload";
                    echo json_encode($response);
                    }

             }   else {
                $response["value"] = 0;
                $response["message"] = "Oops! Uplaod PDF";
                echo json_encode($response);
                }

             if (isset($result)) {
                            $response["value"] = 1;
                            $response["message"] = "Success Comments";
                            echo json_encode($response);
                        } else {
                            $response["value"] = 0;
                            $response["message"] = "Oops! Try again!";
                            echo json_encode($response);
                        }


        }


        else {

             $response["value"] = 0;
             $response["message"] = "Anda Sudah Melakukan Pelayanan Surat";
             echo json_encode($response);

            }




mysqli_close($conn);
}

?>