<!----------------------------Script code for delete confirmation-------------------------------------->
<script language="JavaScript" type="text/javascript">
function checkDelete(){
    return confirm('Are you sure?');
}
</script>
<!----------------------------End Script for delet confirmation-------------------------------------->
<?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="#">City List</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="search">
                    <h2>Search</h2>
                    <div class="s-box">
                        <input type="text" id="myInput" onkeyup="myFunction()" class="form-control" placeholder="Search...">
                        <button type="button" class="btn btn-primary">Search</button>
                    </div>
                </div>
                <div class="heading">
                    <h2>City List</h2>
                    <div class="head-right">
                        <button type="button" class="btn btn-primary" style="margin-right: 10px;" id="export-table">Export Table</button>
                    <button type="button" class="btn btn-success" data-toggle="modal" data-target="#add"><i class="fa fa-plus" aria-hidden="true"></i>Add City</button>
                    </div>
                </div>
                <div class="table-responsive">
                    <table id="myTable" class="table table-bordered">
                        <tr>
                        <th onclick="sortTable(0)">S.N <span class="sort"></span></th>
                            <th onclick="sortTable(1)">State<span class="sort"></span></th>
                            <th onclick="sortTable(2)">City <span class="sort"></span></th>
                            <th class="action">Action</th> 
                        </tr>
                          <?php 
                     $limits=30;
                     if(isset($_GET['page'])){
                      $page=$_GET['page'];
                    }else{
                      $page=1;
                    }
                     $offset= ($page-1) * $limits;
                     
                    $sql="SELECT * FROM `city_data` JOIN `state_data` ON city_data.state_id = state_data.state_id  LIMIT $limits OFFSET $offset";
                             $run=mysqli_query($db,$sql);
                          $count = 1;
                           while($data=mysqli_fetch_assoc($run)){                
                              $id=$data['city_id']; 
                              $city_name=$data['city_name'];
                              $state_name=$data['state_name'];
                              $state_code=$data['state_code'];
                             
                    ?>
                        <tr>
                            <td><?php echo $count ;?></td>
                            <td><?php echo $state_name ;?>-<?php echo $state_code ;?></td>
                            <td><?php echo $city_name ;?></td>
                            
                            <td class="action">
                                <!-- <a href="edit-user.php?sid=<?php echo $id;?>"><button type="button" class="btn" data-toggle="modal" data-target="#edit"><i class="fa fa-pencil" aria-hidden="true"></i></button></a> -->
                                 <!-- <a href="view-user.php?sid=<?php echo $id;?>"><button type="button" class="btn" data-toggle="modal" data-target="#view"><i class="fa fa-eye" aria-hidden="true"></i></button></a>  -->
                                <a href="delete-city.php?sid=<?php echo $id;?>" onclick="return checkDelete()"><button type="button" class="btn"><i class="fa fa-trash-o" aria-hidden="true"></i></button></a>
                            </td>
                        </tr>
                        <?php $count++; } ?>
                    </table>
                    <?php 
                   $sql2="SELECT * FROM `city_data` JOIN `state_data` ON city_data.state_id = state_data.state_id  ";
                    $run2=mysqli_query($db,$sql2);
                    if(mysqli_num_rows($run2)>0){
                      $total_record=mysqli_num_rows($run2);
                      
                      $total_page=ceil($total_record/$limits);
                      ?>
                       <ul class="pagination">
                        <?php if($page > 1){ ?>
                        <li style="background: #09bdda;"><a href="location.php?page=<?php echo $page-1 ;?>" style="color: white;"><i class="fa fa-arrow-left" aria-hidden="true"> Prev</i></a></li><?php } ?>
                    <?php  for($i=1; $i <= $total_page; $i++){
                      if($i==$page){
                        $active="active";
                      }else{
                         $active=""; 
                      }
                        ?>
                    <li class="<?php echo $active ;?>"><a href="location.php?page=<?php echo $i ;?>"><?php echo $i ;?></a></li>
                    <?php }?>
                    <?php if($total_page >$page ){ ?>
                    <li style="background: #09bdda;"><a href="location.php?page=<?php echo $page+1 ;?>" style="color: white;">Next <i class="fa fa-arrow-right" aria-hidden="true"></i></a></li><?php } ?>
                    
                  </ul>
                  <?php  } ?>
                </div>
               
<div class="modal fade" id="add">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h4 class="modal-title">Add New City</h4>
                <button type="button" class="close" data-dismiss="modal">&times;</button>
            </div>
            <div class="modal-body">
                <div class="col-lg-12">

                 <form method="post" class="myForm" action="add-city.php" enctype="multipart/form-data">
                    <div class="row">

                    
                        <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 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 Name</label>
                                <input type="text"  name="city_name" class="form-control" placeholder="City Name" required="">
                            </div>
                        </div>

                        <div class="col-lg-12">
                            <button type="submit" name="submit" class="btn btn-primary">Submit</button>
                        </div>
                    </div>

                </form>


                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
            </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: "Location_List.xls"
        });
      })
    });

$(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-table2').click(function(){
        $("#myTable2").table2excel({
            filename: "AdminUsers.xls"
        });
      })
    });

</script>


<!-- =================================== validation =========================== -->
<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"); 

$( ".myform" ).validate({
  rules: {
    name: {
      required: true,
      lettersonly: true
    },
    email: {
      required: true,
      emailfull: true
    },
    phone: {
      required: true,
      number: true,
        minlength: 10,
        maxlength: 10
    },
    mobile: {
      required: true,
      number: true,
        minlength: 10,
        maxlength: 10
    },
    subject: {
      required: true,
      lettersonly: true
    },
    message: {
      required: true,
      lettersonly: true
    }
  },
});
</script>
        
        <!----------- search script code end here----->