<?php include('header.php') ?>
        <div class="breadcrumb-top">
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
                <li class="breadcrumb-item active"><a href="#">Edit Product</a></li>
                <!---<li class="breadcrumb-item active">Accessories</li> -->
            </ol>
        </div>
        <!--------------------------------Start main body section----------------------------------->
        <div class="col-lg-12">
            <div class="primary-panel">
                <div class="heading">
                    <h2>Edit Product</h2>
                </div>
                    <?php                  
                         $id= $_REQUEST['sid'];
                         $sql="SELECT * FROM `products`  WHERE `product_id`='$id' ";
                         $run=mysqli_query($db,$sql); 
                             $data=mysqli_fetch_assoc($run);
                             $product_id=$data['product_id'];    
                              $product_name=$data['product_name'];
                              $category_id=$data['category_id'];
                              $product_code=$data['product_code'];
                              $sale_price=$data['sale_price']; 
                              $purchase_price=$data['purchasePrice'];   
                        ?>

                <form method="post" class="editForm" action="" enctype="multipart/form-data">
                    <div class="row">
                    <div class="col-lg-4 col-md-6">
                            <div class="form-group">
                                <label>Product Code</label>
                                <input type="text"  name="product_code" class="form-control" value="<?php echo $product_code ;?>" readonly>
                            </div>
                        </div> 
                         <div class="col-lg-4 col-md-6">
                            <div class="form-group">
                                <label>Product Name</label>
                                <input type="text"  name="product_name" class="form-control" value="<?php echo $product_name ;?>" required="">
                            </div>
                        </div> 
                        <div class="col-lg-4 col-md-6">
                            <div class="form-group">
                                <label>Product Category:</label>
                                <select name="category_id" id="StateID" class="form-control" required="">
                                    <option value="">Select Category</option>
                                <?php 
                                $sql="SELECT * FROM `category` ";
                                $run=mysqli_query($db,$sql);
                           while($data=mysqli_fetch_assoc($run)){                
                              $catgory_ID=$data['category_id']; 
                              $category_name=$data['category_name'];
                              
                            ?>
                            <option value="<?php echo $category_id ;?>" <?php if($category_id == $catgory_ID) echo 'selected="selected"' ?> ><?php echo $category_name ;?> </option>
                            <?php }?>
                                </select>
                            </div>
                        </div>
                        <div class="col-lg-4 col-md-6">
                            <div class="form-group">
                                <label>Sale Price</label>
                                <input type="text"  name="sale_price" class="form-control" value="<?php echo $sale_price ;?>" >
                            </div>
                        </div>
                        
                        <div class="col-lg-4 col-md-6">
                            <div class="form-group">
                                <label>Purchase Price</label>
                                <input type="text"  name="purchase_price" class="form-control" value="<?php echo $purchase_price ;?>" >
                            </div>
                        </div>
                        <div class="col-lg-12">
                            <button type="submit" name="submit" class="btn btn-primary">Update</button>
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
<!----------------------------------End Main body Section----------------------------------->      
    </div>
</div>
<?php include('footer.php') ?>
<!----- search script code start here--------->
<script src="https://cdn.rawgit.com/rainabba/jquery-table2excel/1.1.0/dist/jquery.table2excel.min.js"></script>
<script>
    $(document).ready(function(){
      /* Search table */
      
      $("#myInput").on("keyup", function() {
        var value = $(this).val().toLowerCase();
        $("#myTable tr").filter(function() {
          $(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
        });
      });
      /* Export table */
      $('#export-table').click(function(){
        $("#myTable").table2excel({
            filename: "Users.xls"
        });
      })
    });
</script>

<!-- <script src="https://cdn.jsdelivr.net/jquery.validation/1.16.0/jquery.validate.min.js"></script>
<script src="https://cdn.jsdelivr.net/jquery.validation/1.16.0/additional-methods.min.js"></script>
<script>
jQuery.validator.addMethod("emailfull", function(value, element) {
  return this.optional(element) || /^([a-z\d!#$%&'*+\-\/=?^_`{|}~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]+(\.[a-z\d!#$%&'*+\-\/=?^_`{|}~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]+)*|"((([ \t]*\r\n)?[ \t]+)?([\x01-\x08\x0b\x0c\x0e-\x1f\x7f\x21\x23-\x5b\x5d-\x7e\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]|\\[\x01-\x09\x0b\x0c\x0d-\x7f\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))*(([ \t]*\r\n)?[ \t]+)?")@(([a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]|[a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\-._~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]*[a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])\.)+([a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]|[a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\-._~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]*[a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])\.?$/i.test(value);
 }, "Please enter valid email address!");
 jQuery.validator.addMethod("lettersonly", function(value, element) {
   return this.optional(element) || /^[a-z\s]+$/i.test(value);
 }, "Only alphabetical characters"); 

$(".editForm").validate({
    
  rules: {
    name: {
      required: true,
      lettersonly: true
    },
    role: {
      required: true,
      lettersonly: true
    },
    email: {
      required: true,
      emailfull: true
    },
    mobile: {
      required: true,
      number: true,
        minlength: 11,
        maxlength: 11
    },
    password: {
      required: true,
      
    },
    
    status: {
      required: true,
      
    }
  },
});
</script> -->


<!----------- search script code end here----->
<?php 
     if(isset($_POST['submit'])){  

        $category_id= $_POST['category_id'];
         $product_name= $_POST['product_name'];
         $product_code= $_POST['product_code'];
         $sale_price= $_POST['sale_price'];
         $purchase_price= $_POST['purchase_price'];
         

         $admin_query="UPDATE `products` SET `category_id`='$category_id',`product_name`='$product_name',`product_code`='$product_code',`sale_price`='$sale_price' ,`purchasePrice`='$purchase_price'  WHERE `product_id`='$id' ";
        
         $run= mysqli_query($db,$admin_query);
     
    echo "<script> alert('Product Updated Successfuly.')</script>";
    echo "<script> window.open('products.php','_self')</script>";
         
    
     }
?>