<?php
include "master.php";
 ?>
 <script>
 function myFunction() {
 var x = document.getElementById("snackbar");
 // x.classList.add("show");
 x.className = "show";
 setTimeout(function(){ x.className = x.className.replace("show", ""); }, 3000);
 }
 </script>

<script>
        $(document).ready(function()
        {
        $('form').ajaxForm(function()
        {
        alert("Uploaded SuccessFully");
        });
        });
        function preview_image()
        {
            var total_file=document.getElementById("images").files.length;
            for(var i=0;i<total_file;i++)
            {
                var img = $('#image_preview').append("<img src='"+URL.createObjectURL(event.target.files[i])+"' height='300px' width=' 540px'><br><br>");
                $(".btnsave").click(function(){
                    $("img").addClass('d_none');
                });
            }
        }
        </script>
        <style>
          #image_preview{
            display: flex;
              justify-content: center;
          }
          #image_preview img{
            width: 200px;
            height:150px;
          }
        </style>
 <?php


 $id = $_GET['id'];
 $sql = "Select * from products where product_id = $id";
 $rs = $db->dbQuery($sql);
 $row = $db->dbFetchRecord($rs);

 if(isset($_POST['btnAdd'])){
   $name = $_POST["name"];
   $description = $_POST["description"];
   $price = $_POST["price"];
   $decPrice = $_POST["decPrice"];
   $category_id = $_POST["category_id"];
    $sql = "UPDATE `products` SET `name`='$name' ,`details`='$description' ,`price`=$price ,`dec`=$decPrice  ,`category_id`='$category_id' WHERE `product_id` = $id";
    $rs = $db->dbQuery($sql);

        $err = "تم التعديل بنجاح";


          echo '
              <script>
              $(document).ready(function(){
                $("#snackbar").addClass("show");
                      setTimeout(function(){
                       $("#snackbar").removeClass("show");
                         }, 3000);
            });
              </script>
          ';
          echo "<meta http-equiv='refresh' content='3;URL=products.php'>";


   }

 ?>

 <div class="row">
  <div class="col-sm-12">
    <div class="card-box">



      <h4 class="header-title m-t-0 m-b-30">تعديل المنتج</h4>
      <div id="snackbar" class="">تم التعديل بنجاح</div>

      <div class="row" style="display: flex;justify-content: center;">
        <div class="col-lg-6">
          <form class="form-horizontal" method="post">
                      <div class="form-group">
                          <label class="" style="display: block;text-align: center;">اسم المنتج </label>
                          <input type="text" class="form-control"  name="name" value="<?= $row['name'] ?>" placeholder="اسم المنتج ">
                      </div>
                      <div class="form-group">
                          <label class="" style="display: block;text-align: center;">وصف المنتج</label>
                          <textarea class="form-control" name="description" id="description" rows="8" cols="80"><?= $row['details'] ?></textarea>
                      </div>
                      <!-- <div class="form-group">
                          <div class="custom-file">
                            <label style="display: block;text-align: center;" for="customFile">اختر صورة المنتج</label>
                             <input type="file" class="form-control" id="images" name="image_out" onchange="preview_image();" >
                             <img src="../uploads/<?= $row['image'] ?>" width="100px" alt="">
                           </div>
                           <div id="image_preview"></div>

                        </div> -->
                      <div class="form-group">
                          <label class="" style="display: block;text-align: center;">السعر</label>
                          <input type="text" class="form-control"  name="price" value="<?= $row['price'] ?>" placeholder="السعر">
                      </div>
                      <div class="form-group">
                          <label class="" style="display: block;text-align: center;">الخصم</label>
                          <input type="text" class="form-control"  name="decPrice" value="<?= $row['dec'] ?>" placeholder="السعر">
                      </div>
                      <div class="form-group">
                        <label class="" style="display: block;text-align: center;">اختيار التصنيف</label>
                          <select class="form-control input"  name="category_id">
                            <option selected disabled>اختر التنصيف</option>
                            <?php
                              $query = "SELECT * FROM `maincategories`";
                              $result = $db->dbQuery($query);
                              if($db->dbNumRows($result)){
                              $rows = $db->dbFetchResult($result);
                              foreach($rows as $rowg){ 
                                $id = $rowg[0];?>
                                <optgroup label="<?= $rowg[1] ?>">
                                <?php
                                  $query = "SELECT * FROM `subclasses` WHERE maincategories = $id";
                                  $result = $db->dbQuery($query);
                                  if($db->dbNumRows($result)){
                                  $rows = $db->dbFetchResult($result);
                                  foreach($rows as $ro){ ?>
                                    <option value="<?= $ro[0] ?>" <?php if($row['category_id'] == $ro['id']){ ?> selected style="background:red;" <?php }  ?>><?= $ro[1] ?></option>
                                    <?php } } ?>
                                  </optgroup>
                            <?php } } ?>
                         </select>
                       </div>
                      <div class="form-group center" >
                        <button type="submit"  name="btnAdd" id="success-alert" class="btn btn-success btn-bordred waves-effect w-md waves-light m-b-5" >تعديل</button>
                      </div>
                  </form>
        </div><!-- end col -->


      </div><!-- end row -->
    </div>
  </div><!-- end col -->
 </div>
 <!-- end row -->
<?php
include "footer.php";
 ?>