fsafsag

<?php
session_start();
if (!isset($_SESSION["user"])) {
    echo "<script>alert('Kamu Harus Login Dulu, Terima Kasih')</script>";
    header("location: login.php");
}
?><html><?php
    include"header.php";
    include"navbar.php";
    ?>

    <?php
    if (!isset($_POST["submit"]) && !isset($_GET['id'])) {
        header("location: databooking.php");
    }

    if (isset($_POST["submit"])) {

        $nama = $_POST["nama"];
        $ruangan = $_POST["ruangan"];
        $prodi = $_POST["prodi"];
        $jam = $jam1 = $_POST["jam"];
        $sks = $_POST["sks"];
        $tanggal = $_POST["tanggal"];
        $time=array();
        for($i=0;$i<$sks;$i++){
            $time[]=$jam1++;
        }
/*
select p.tanggal,p.status,p.ruang_id,
pj.ruang_id r2, pj.jadwal_id jam
        from pemesanan p
          join
        pemesanan_jadwal pj
        on p.id=pj.pemesanan_id

*/
        $time_str=implode(",",$time);
        $sql="select count(*) c
        from pemesanan p
          join
        pemesanan_jadwal pj
        on p.id=pj.pemesanan_id
        where p.ruang_id = {$ruangan}
        and p.tanggal like '{$tanggal}'
        and pj.jadwal_id in({$time_str})
        and p.status='yes'";
        $result = $db->query($sql);
         if ($result) {
            $hasil = $result->fetch_assoc();
            if($hasil['c']!=0){
            //  die('stop');
                $url=$_SERVER['HTTP_REFERER']."&jadwal=invalid";
                header('location:'.$url);exit;
                /*
                echo '<pre>'.print_r($_SERVER,1);die;
                echo "<script>alert('Jadwal Tidak Tersedia')</script>";
                echo "Waktu dan Ruang yang dipilih telah digunakan oleh mahasiswa/dosen yang lain";
                */
            }else{
                $ok=TRUE;
                $query = "INSERT INTO pemesanan
        (nama_pemesan, ruang_id, prodi_dosen, jadwal_id, sks,status,tanggal)
        VALUES
        ('$nama', '$ruangan', '$prodi', '$jam', '$sks','waiting','$tanggal')";
        $z = '';

                $result = $db->query($query);
                if ($result) {
                    $id_pemesanan = $db->insert_id;

                    for ($i = 0; $i < $sks; $i++) {
                        $query = "insert into pemesanan_jadwal(pemesanan_id,ruang_id,jadwal_id) values(
                        '{$id_pemesanan}','{$ruangan}','{$jam}'
                        )";
                        $result = $db->query($query);
                        $jam++;
                    }
                    //die($query.$z);

                    header('location:?id=' .  $id_pemesanan);

                } else {
                    echo "select failed, error: ", $db->error;
                    $hasil = array();
                }

            }
        //echo $sql.'<pre>'.print_r($_POST,1).print_r($hasil,1);die;

        } else {
            echo "<script>alert('Data Gagal Ditambahkan, Terima Kasih')</script>";
        }
    }

    if (isset($_GET['id'])) {
        $id = $_GET['id'];
        //echo $id;
        $sql = "SELECT rp.*,r.nama_ruang  ruang,j.jam, group_concat(j.jam) jam_str
        FROM pemesanan rp
        left join pemesanan_jadwal pj on pj.pemesanan_id=rp.id
        left join ruang r on r.id_ruang=rp.ruang_id
        left join jadwal j on j.id_jadwal=pj.jadwal_id
        where rp.id='$id'
        group by rp.id";
    //  die($sql);
        $hasil = $db->query($sql);
        if ($hasil) {
            $menu = $hasil->fetch_assoc();
        } else {
            echo "select failed, error: ".$sql.'<br/>'. $db->error;
            $menu = array();
        }
    }

    $ar=explode(',',$menu['jam_str']);
    $jam_mulai=$jam_akhir='';
    $ar0=explode("-",$ar[0]);
    $jam_mulai=$ar0[0];
    $ar1=explode("-",$ar[count($ar)-1]);
    $jam_akhir=$ar1[1];
    ?>

    <body>
        <div class="container">
    <?php
    if (isset($_POST["submit"])) {
        echo'
                <div class="row">
                    <div class="col-md-6">
                        <label>Berhasil!!</label><br>
                        <label>Pesanan anda sedang menunggu</label><br>
                        <label>persetujuan operator.</label>
                    </div>
                    <div class="col-md-6">
                    </div>
                </div>';
    }
    ?>
            <div class="row">
                <div class="col-md-6">
            <?php
            // echo'<pre>'.print_r($menu,1).'</pre>';
            if (isset($_POST["submit"])) {
                echo'
                        <h2><strong>Data yang telah anda pesan :</strong></h2>';
            } else {
                echo'
                        <h2><strong>Data yang telah dipesan :</strong></h2>';
            }
            ?>
                    <hr>
                    <form>
                        <div class="row">
                            <div class="col-md-3">
                                <label>Nama </label>
                            </div>
                            <div class="col-md-1">
                                <label>:</label>
                            </div>
                            <div class="col-md-4">
                                <label><?php
                    if (isset($_POST["submit"])) {
                        echo $nama;
                    }
                    if (isset($_GET['id'])) {
                        echo isset($menu['nama_pemesan'])?$menu['nama_pemesan']:'-';
                    }
            ?>
                                </label>
                            </div>
                        </div>
                        <br>
                        <div class="row">
                            <div class="col-md-3">
                                <label>Ruangan</label>
                            </div>
                            <div class="col-md-1">
                                <label>:</label>
                            </div>
                            <div class="col-md-4">
                                <label><?php
                                    if (isset($_POST["submit"])) {
                                        echo $ruangan;
                                    }
                                    if (isset($_GET['id'])) {
                                        echo isset($menu['ruang'])?$menu['ruang']:'-';
                                    }
            ?>
                                </label>
                            </div>
                        </div>
                        <br>
                        <div class="row">
                            <div class="col-md-3">
                                <label>Prodi-Dosen </label>
                            </div>
                            <div class="col-md-1">
                                <label>:</label>
                            </div>
                            <div class="col-md-4">
                                <label><?php
                                    if (isset($_POST["submit"])) {
                                        echo $prodi;
                                    }
                                    if (isset($_GET['id'])) {
                                        echo isset($menu['prodi_dosen'])?$menu['prodi_dosen']:'-';
                                    }
            ?>
                                </label>
                            </div>
                        </div>
                        <br>
                        <div class="row">
                            <div class="col-md-3">
                                <label>Jam Mulai</label>
                            </div>
                            <div class="col-md-1">
                                <label>:</label>
                            </div>
                            <div class="col-md-4">
                                <label><?php
                                    if (isset($_POST["submit"])) {
                                        echo $jam;
                                    }
                                    if (isset($_GET['id'])) {
                                        echo $jam_mulai;
                                    }
                                    //echo '<pre>'.print_r($menu,1).'</pre>';
            ?> WIB
                                </label>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col-md-3">
                                <label>Jam Akhir</label>
                            </div>
                            <div class="col-md-1">
                                <label>:</label>
                            </div>
                            <div class="col-md-4">
                                <label><?php
                                    if (isset($_POST["submit"])) {
                                        echo $jam;
                                    }
                                    if (isset($_GET['id'])) {

                                        echo $jam_akhir;
                                    }
                                    //echo '<pre>'.print_r($menu,1).'</pre>';
            ?> WIB
                                </label>
                            </div>
                        </div>
                        <br>
                        <div class="row">
                            <div class="col-md-3">
                                <label>Durasi</label>
                            </div>
                            <div class="col-md-1">
                                <label>:</label>
                            </div>
                            <div class="col-md-4">
                                <label><?php
                                    if (isset($_POST["submit"])) {
                                        echo $sks;
                                    }
                                    if (isset($_GET['id'])) {
                                        echo isset($menu['sks'])?$menu['sks']:0;
                                    }
            ?> SKS
                                </label>
                            </div>
                        </div>
                        <br>

                    </form>
                    <hr>
                <!--<table>
                    <tr>
                        <th><label> Username :</label></th>
                        <th>
                            <div class="form-group">
                            <input type="text" name="username">
                            </div>
                        </th>
                    </tr>
                    <tr>
                        <th><label> Password :</label></th>
                        <th><input type="password" name="password"></th>
                    </tr>


                </table>-->
                </div>
                <div class="col-md-6">
                </div>
            </div>

        </div>
    </body>
</html>