<?php
include("connect.php");

if(isset($_POST['btn_tempahan']))
{


//        $nama_pelanggan = $_POST['nama_pelanggan'];
//        $no_tel = $_POST['no_tel'];
//        $alamat = $_POST['alamat'];
//        $tarikh_tempahan = $_POST['tarikh_tempahan'];
//        $tarikh_siap = $_POST['tarikh_siap'];
//        $nama_produk = $_POST['nama_produk'];
//        $kategori = $_POST['kategori'];
//

        // $kod_pelanggan = $_POST['kod_pelanggan'];
        // $bingkai = $_POST['bingkai'];
        // $kanta = $_POST['kanta'];
        // $tarikhtempah = $_POST['tarikhtempah'];
        // $tarikhsiap = $_POST['tarikhsiap'];
        // $kuasa_kanan = $_POST['kuasa_kanan'];
        // $kuasa_kiri = $_POST['kuasa_kiri'];
        // $p_d = $_POST['p_d'];

  //       echo $tarikh_tempahan = $_POST['tarikh_tempahan'] ;
  //       echo "<br/>";
  //       echo $tarikh_siap = $_POST['tarikh_siap'];
  //       echo "<br/>";
  //       echo $jrk_rabun_kanan = $_POST['jrk_rabun_kanan'];  echo "<br/>";
  //       echo $jrk_rabun_kiri = $_POST['jrk_rabun_kiri'];  echo "<br/>";
  //       echo $jrk_silau_kanan = $_POST['jrk_silau_kanan'];  echo "<br/>";
  //       echo $jrk_silau_kiri = $_POST['jrk_silau_kiri'];  echo "<br/>";
  //       echo $axis_dis_r = $_POST['axis_dis_r'];  echo "<br/>";
  //       echo $axis_dis_l = $_POST['axis_dis_l'];  echo "<br/>";
  //       echo $axis_reading_r = $_POST['axis_reading_r'];  echo "<br/>";
  //       echo $axis_reading_l = $_POST['axis_reading_l'];  echo "<br/>";
  //       echo $add = $_POST['add'];  echo "<br/>";
  //       echo $baca_rabun_kanan = $_POST['baca_rabun_kanan'];  echo "<br/>";
  //       echo $baca_rabun_kiri = $_POST['baca_rabun_kiri'];  echo "<br/>";
  //       echo $baca_silau_kanan = $_POST['baca_silau_kanan'];  echo "<br/>";
  //       echo $baca_silau_kiri = $_POST['baca_silau_kiri'];  echo "<br/>";
  //       echo $p_d = $_POST['p_d'];  echo "<br/>";
  //       echo $tempahan_eye = $_POST['tempahan_eye'];  echo "<br/>";
  //       echo $tempahan_bridge = $_POST['tempahan_bridge'];  echo "<br/>";
  //       echo $tempahan_seg = $_POST['tempahan_seg'];  echo "<br/>";
  //       echo $tempahan_height_r = $_POST['tempahan_height_r'];  echo "<br/>";
  //       echo $tempahan_height_l = $_POST['tempahan_height_l'];  echo "<br/>";

  //       echo $id_pelanggan = $_POST['kod_pelanggan'];  echo "<br/>";
  //       echo $id_produk_bingkai = $_POST['bingkai'];  echo "<br/>";
  //       echo $id_produk_kanta = $_POST['kanta'];  echo "<br/>";
  // echo "<br/>";

    $tarikh_tempahan = $_POST['tarikh_tempahan'] ;
         "<br/>";
         $tarikh_siap = $_POST['tarikh_siap'];
         "<br/>";
         $jrk_rabun_kanan = $_POST['jrk_rabun_kanan'];   "<br/>";
         $jrk_rabun_kiri = $_POST['jrk_rabun_kiri'];   "<br/>";
         $jrk_silau_kanan = $_POST['jrk_silau_kanan'];   "<br/>";
         $jrk_silau_kiri = $_POST['jrk_silau_kiri'];   "<br/>";
         $axis_dis_r = $_POST['axis_dis_r'];   "<br/>";
         $axis_dis_l = $_POST['axis_dis_l'];   "<br/>";
         $axis_reading_r = $_POST['axis_reading_r'];   "<br/>";
         $axis_reading_l = $_POST['axis_reading_l'];   "<br/>";
         $add = $_POST['add'];   "<br/>";
         $baca_rabun_kanan = $_POST['baca_rabun_kanan'];   "<br/>";
         $baca_rabun_kiri = $_POST['baca_rabun_kiri'];   "<br/>";
         $baca_silau_kanan = $_POST['baca_silau_kanan'];   "<br/>";
         $baca_silau_kiri = $_POST['baca_silau_kiri'];   "<br/>";
         $p_d = $_POST['p_d'];   "<br/>";
         $tempahan_eye = $_POST['tempahan_eye'];   "<br/>";
         $tempahan_bridge = $_POST['tempahan_bridge'];   "<br/>";
         $tempahan_seg = $_POST['tempahan_seg'];   "<br/>";
         $tempahan_height_r = $_POST['tempahan_height_r'];   "<br/>";
         $tempahan_height_l = $_POST['tempahan_height_l'];   "<br/>";

         $id_pelanggan = $_POST['kod_pelanggan'];   "<br/>";
         $id_produk_bingkai = $_POST['bingkai'];   "<br/>";
         $id_produk_kanta = $_POST['kanta'];   "<br/>";
   "<br/>";
        //GET TODAY
        $today = date('Y-m-d H:i:s');

         $sql_insert = "INSERT INTO `tempahan`( `tarikh_tempahan`, `tarikh_siap`, `jrk_rabun_kanan`, `jrk_rabun_kiri`, `jrk_silau_kanan`, `jrk_silau_kiri`, `axis_dis_r`, `axis_dis_l`, `axis_reading_r`, `axis_reading_l`, `add`, `baca_rabun_kanan`, `baca_rabun_kiri`, `baca_silau_kanan`, `baca_silau_kiri`, `p_d`, `tempahan_eye`, `tempahan_bridge`, `tempahan_seg`, `tempahan_height_r`, `tempahan_height_l`, `id_pelanggan`, `id_produk_bingkai`, `id_produk_kanta`) VALUES ('$tarikh_tempahan','$tarikh_siap','$jrk_rabun_kanan','$jrk_rabun_kiri','$jrk_silau_kanan','$jrk_silau_kiri','$axis_dis_r','$axis_dis_l','$axis_reading_r','$axis_reading_l','$add','$baca_rabun_kanan','$baca_rabun_kiri','$baca_silau_kanan','$baca_silau_kiri','$p_d','$tempahan_eye','$tempahan_bridge','$tempahan_seg','$tempahan_height_r','$tempahan_height_l', '$id_pelanggan', '$id_produk_bingkai','$id_produk_kanta')";

        $result = mysqli_query($con,$sql_insert);

        if($result)
        {
        $sqlbingkai = "SELECT * FROM stok_produk where id_produk = $id_produk_bingkai";
        $sqlkanta = "SELECT * FROM stok_produk where id_produk = $id_produk_kanta";
        $b = mysqli_query($con,$sqlbingkai);
        $k =mysqli_query($con,$sqlkanta);
        while($row1 = mysqli_fetch_assoc($b)){
            $newval1 = $row1['kuantiti_produk'];
        }
        while($row2 = mysqli_fetch_assoc($k)){
            $newval2 = $row2['kuantiti_produk'];
        }
        $newval1 -= 1;
        $newval2 -= 1;

        $sql_update_stok_bingkai = "UPDATE stok_produk set kuantiti_produk = $newval1 where id_produk = $id_produk_bingkai";
        $sql_update_stok_kanta = "UPDATE stok_produk set kuantiti_produk = $newval2 where id_produk = $id_produk_kanta";
        mysqli_query($con,$sql_update_stok_bingkai);
        mysqli_query($con,$sql_update_stok_kanta);

                 ?>
            <script>
                alert('Tempahan Berjaya Di daftarkan');
           window.location.replace("http://localhost/bomis/tempahan.php");
            </script>



            <?php
        }
        else
        {
                      ?>
            <script>
                alert('Tempahan Tidak Berjaya Di daftarkan');
           window.location.replace("http://localhost/bomis/tempahan.php");
            </script>


            <?php
        }
//
}

    if($_GET['action']=='delete')
    {
        $tempahan_id = $_GET['id'];

        $sql_delete = "DELETE FROM tempahan WHERE id_tempahan ='$tempahan_id' ";

        $result_delete = mysqli_query($con,$sql_delete);

        if($result_delete)
        {
                                  ?>
                <script>
                    alert('Tempahan Berjaya Di padam');
               window.location.replace("http://localhost/bomis/tempahan.php");
                </script>


                <?php
        }
        else
        {
                                  ?>
                <script>
                    alert('Tempahan Tidak Berjaya Di padam');
               window.location.replace("http://localhost/bomis/tempahan.php");
                </script>


                <?php
        }
    }


?>