<?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 Customer</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 Customer</h2>
                </div>
                    <?php                  
                         $id= $_REQUEST['sid'];
                         $sql="SELECT * FROM `customer` JOIN `state_data` ON customer.state = state_data.state_id JOIN city_data ON customer.user_city_id = city_data.city_id WHERE `cust_id`='$id'  ";
                         $run=mysqli_query($db,$sql); 
                             $data=mysqli_fetch_assoc($run);
                             $id=$data['cust_id'];    
                             $name=$data['name'];
                             $mobile=$data['mobile'];
                             $state=$data['state'];
                             $user_city_id=$data['user_city_id'];
                             $city_name=$data['city_name'];
                             $address=$data['address'];
                             $email=$data['email'];
                             $gst_no=$data['gst_no'];
                                
                        ?>

                <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>Customer Name</label>
                                <input type="text" id="name" name="name" class="form-control" value="<?php echo $name ; ?>">
                            </div>
                        </div>
                         

                        <div class="col-lg-4 col-md-6">
                            <div class="form-group">
                                <label>Mobile No. </label>
                                <input type="text" id="mobile" name="mobile" class="form-control" value="<?php echo $mobile ;?>" required="">
                            </div>
                        </div>
                        <div class="col-lg-4 col-md-6">
                            <div class="form-group">
                                <label>State</label>
                                <select name="state_id" id="StateID" class="form-control" required="">
                                    <option value="">Select state</option>
                                <?php 
                                $sql="SELECT * FROM `state_data` ";
                                $run=mysqli_query($db,$sql);
                           while($data=mysqli_fetch_assoc($run)){                
                              $state_id=$data['state_id'];    
                              $state_code=$data['state_code'];
                              $state_name=$data['state_name'];
                              
                            ?>
                            <option value="<?php echo $state_id ;?>" <?php if($state == $state_id) echo 'selected ="selected"' ?>><?php echo $state_name ;?> - <?php echo $state_code ;?></option>
                            <?php }?>
                                </select>
                            </div>
                        </div>
                       
                        <div class="col-lg-4 col-md-6">
                            <div class="form-group">
                                <label>City</label>
                                <select name="city_id" id="cityID" class="form-control" required="">
                                <option value="<?php echo $user_city_id ;?>" ><?php echo $city_name ;?> </option>
                                </select>
                            </div>
                        </div>

                        <div class="col-lg-4 col-md-6">
                            <div class="form-group">
                                <label>User Email</label>
                                <input type="text" id="email" name="email" class="form-control" value="<?php echo $email ; ?>">
                            </div>
                        </div>
                        
                        <div class="col-lg-4 col-md-6">
                            <div class="form-group">
                                <label>GST Number</label>
                                <input type="text" name="gst_no"  class="form-control" value="<?php echo $gst_no ; ?>">
                            </div>
                        </div>
                        

                        <div class="col-lg-8 col-md-6">
                            <div class="form-group">
                                <label>Address</label>
                                <textarea name="address" class="form-control" ><?php echo $address ; ?></textarea>
                            </div>
                        </div>
                        
                        
                        

                        <div class="col-lg-12">
                            <button type="submit" name="submit" class="btn btn-primary">Submit</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: 10,
        maxlength: 10
    },
    password: {
      required: true,
      
    },
    
    status: {
      required: true,
      
    }
  },
});

$(document).ready(function(){

$("#StateID").change(function(){
               
               var stateID = $(this).val();
            
               $("#cityID option").remove();
              
               if(stateID != '0')
               {
                   $.ajax({
                       type: 'GET',
                       url: 'getCity.php',
                       data: {state_id:stateID},
                       success: function(data){
                          /* var jsonData1 = JSON.parse(data);
                           for (var i = 0; i < jsonData1.length; i++) {
                               appenddata1 += "<option value = '" + jsonData1[i].id + " '>" + jsonData1[i].state_name + " </option>";
                           }*/
                           $("#cityID").append(data);
                                   
                       }
                   });
               }
       });

});

</script>


<!----------- search script code end here----->
<?php 
     if(isset($_POST['submit'])){    
      $name= $_POST['name'];
      $mobile= $_POST['mobile'];
      $state_id= $_POST['state_id'];
      $city_id= $_POST['city_id'];
      $address= $_POST['address'];
      $email= $_POST['email'];
      $gst_no= $_POST['gst_no'];
      

         $admin_query="UPDATE `customer` SET `name`='$name', `mobile`='$mobile', `state`='$state_id', `user_city_id`='$city_id', `address`='$address', `email`='$email', `gst_no`='$gst_no' WHERE `cust_id`='$id' ";
    $run= mysqli_query($db,$admin_query);
    echo "<script> alert('Customer detail updated successfully')</script>";
    echo "<script> window.open('vendors.php','_self')</script>";
         
    
     }
?>