<?php 
$page='store_city';
$page1='';

include('inc/sidebar.php') ;
if(isset($_GET['edit'])){
   
    $get_store_city= "select * from store_city WHERE id='".$_GET['edit']."'";
    $query=mysqli_query($con,$get_store_city);
    $store_city_data=mysqli_fetch_array($query); 
    
}
if(isset($_REQUEST['datafrmSubmit'])){
    if($_REQUEST['datafrmSubmit'] == 'Submit'){
        $date=date("Y-m-d h:i:s");
        
            $sql_insert = "insert into cities set state_id = '".$_REQUEST['state']."',city_name = '".$_REQUEST['city']."'"; 
            $query_insert = mysqli_query($con, $sql_insert);
            if($query_insert){
                echo'<div id="hide-toast"class="toast" role="success" aria-live="assertive" aria-atomic="true">
                        <div class="toast-body success">
                            <i class="fa fa-warning"></i>City Added.<i class="fa fa-close"id="close"></i>
                        </div>
                    </div>';
                echo "<script type='text/javascript'>window.location=\"city.php\";</script>"; 
            }
        
        }

} 
?>


<!-- navbar-wrapper start -->
  <div class="body-wrapper">
    <div class="bodywrapper__inner">
        <div class="row align-items-center mb-30 justify-content-between">
            <div class="col-lg-4 col-sm-6">
                <h6 class="page-title">Add City</h6>
            </div>
            <div class="col-lg-8 col-sm-6 text-sm-right mt-sm-0 mt-3 right-part">
                <div class="d-flex flex-wrap justify-content-end flex-gap-8">
                    <a type="button"href="store-city.php" class="btn btn--primary"style="height: 38px;"><i class="fa fa-plus"></i>Go Back</a>
                </div>
            </div>
        </div>
    <div class="row">
    <div class="col-md-12 mb-30">
        <div class="card">
            <div class="card-body">
                <form method="post" action="" name="datafrm" id="datafrm" enctype="multipart/form-data">
                    <input type="hidden" name="_token" value="F3hYZRLH4v3C9Ru6ljqKNSmfRwKJx6eXLvbIf74y" /> <input type="hidden" name="type" value="element" />
                    <div class="form-row">
                        
                        <div class="col-md-6">
                                <div class="row">
                                    <div class="col-md-12">
                                        <div class="form-group">
                                            <label>Store State</label>
                                            <select class="form-control" name="state"id="stateID" required="">
                                                <option value="">Select State</option>
                                                <?php	
                                                    $sql_states= mysqli_query($con,"SELECT * FROM `states` ORDER BY state_id ASC");
                                                    while($states_data= mysqli_fetch_array($sql_states))
                                                    {
                                                ?>
                                                <option value="<?php echo $states_data['state_id'] ?>" <?php if($states_data['state_id']==$store_city_data['state']){ echo 'selected'; } ?>><?php echo $states_data['state_name'] ?></option>
                                                <?php } ?>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-12">
                                        <div class="form-group">
                                            <label>Store City</label>
                                            <input type="text" class="form-control" name="city"id="city" required="">
                                        </div>
                                         <div class="form-group">
                                        <button type="submit" name="datafrmSubmit" id="datafrmSubmit"value="<?php if(isset($_GET['edit']))
                                       { echo 'Update';  }else{ echo 'Submit'; } ?>"class="btn btn--primary btn-block btn-lg"><?php if(isset($_GET['edit']))
                                       { echo 'Update';  }else{ echo 'Submit'; } ?></button>
                                    </div>
                                    </div>
                                    
                                </div>
                        </div>
                        <div class="col-md-6">
                            <div class="table-responsive--md table-responsive">
                            <table id="example" class="table table--light style--two">
                                <thead>
                                    <tr>
                                        <th>SL</th>
                                        <th>City</th>
                                        <th>State</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php	
                                	$sql= mysqli_query($con, "SELECT * FROM cities ORDER BY city_id DESC");
                                	$i=0;
                                	while($data= mysqli_fetch_array($sql))
                                	{
                                	   
                                          $i++; 
                                  ?>
                                    <tr>
                                        <td data-label="SL"><?php echo $i; ?></td>
                                        <td data-label="News">
                                        <?php echo $data['city_name']; ?>
                                        </td>
                                        <td data-label="News">
                                        <?php	
                                        	$city_data= mysqli_fetch_array(mysqli_query($con,"SELECT * FROM states WHERE state_id='".$data['state_id']."'"));
                                            echo $city_data['state_name'];
                                        ?>
                                        </td>
                                        
                                    </tr>
                                    <?php } ?>
                                </tbody>
                            </table>
                           
                        </div>
                        </div>
                    </div>

                   
                </form>
            </div>
        </div>
    </div>
</div>

    
    </div>
    <!-- bodywrapper__inner end -->
</div>
<!-- body-wrapper end -->

    </div>
 
 <!-- body-wrapper end -->
    </div>

<!-- jQuery library -->

<script>
		jQuery('#title').change(function(){
			jQuery('#result').html('');
			var title=jQuery('#title').val();
			jQuery.ajax({
				url:'inc/get-store_city-slug.php',
				type:'post',
				data:'title='+title,
				success:function(result){
					// jQuery('#slug').val(result);
                    var trimStr = $.trim(result);
                    jQuery('#slug').val(trimStr);
				}
			});
		});
</script>
<script>
    $(document).ready(function() {
        $('#stateID').on('change', function() {
            var state_id = this.value;
                $.ajax({
                    url: "inc/fetch-city.php",
                    type: "POST",
                    data: {
                        state_id: state_id
                    },
                    cache: false,
                    success: function(result){
                        $("#cityID").html(result);
                    }
            });
        });
    });
</script>
<script>
    function dell_gallery(pid,type){
        jQuery.ajax({
            url:'inc/DelGallery.php',
            type:'post',
            data:'pid='+pid+'&type='+type,
            success:function(result){
                window.location.reload();
            }	
        });	
    }
</script>
<?php include('inc/footer.php') ?>