<?php 
$page='store';
$page1='all-store';

include('inc/sidebar.php') ;
 if(isset($_GET['del']))
  {
      $id = $_GET['del'];
      $del = mysqli_query($con,"delete from store where id = '$id'");
     if($del){
      	echo "<script type='text/javascript'>window.location=\"store.php\";</script>"; 
     }
  }
  if(isset($_GET['act']))
  { 
      $id = $_GET['act'];
      $act = mysqli_query($con,"UPDATE `store` SET `status` = '0' where id = '$id'");
     if($act){
      echo'<div id="hide-toast"class="toast" role="alert" aria-live="assertive" aria-atomic="true">
          <div class="toast-body alert">
                <i class="fa fa-warning"></i>Store DeActivated.<i class="fa fa-close"id="close"></i>
          </div>
        </div>';
        echo "<script type='text/javascript'>window.history.pushState('object or string', 'Title', 'store.php');</script>";
      
     }
  }
  if(isset($_GET['ina']))
  {
      $id = $_GET['ina'];
      $ina = mysqli_query($con,"UPDATE `store` SET `status` = '1' where id = '$id'");
     if($ina){
     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>store Activated.<i class="fa fa-close"id="close"></i>
          </div>
        </div>';
        echo "<script type='text/javascript'>window.history.pushState('object or string', 'Title', 'store.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">All Stores </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-add.php" class="btn btn--primary"style="height: 38px;"><i class="fa fa-plus"></i>Add New</a>

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

        <div class="row">
            <div class="col-lg-12">
                <div class="card">
                    <div class="card-body p-0">
                        <div class="table-responsive--md table-responsive">
                            <table id="example" class="table table--light style--two">
                                <thead>
                                    <tr>
                                        <th>SL</th>
                                        <th>Image</th>
                                        <th>Title</th>
                                        <th>State</th>
                                        <th>City</th>
                                        <th>Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php	
                                	$sql= mysqli_query($con, "SELECT * FROM store ORDER BY 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
                                                $gallery= $con ->query("SELECT * FROM store_image Where store_id='".$data['id']."' LIMIT 1");
                                                $gallery_data = $gallery ->fetch_assoc();
                                            ?>
                                        <img src="<?php echo STORE_SITE_PATH.$gallery_data['image']; ?>"style="width:80px;height:30px;">
                                        </td>
                                        <td data-label="News"><?php echo $data['title']; ?></td>
                                        <td data-label="News">
                                        <?php	
                                        	$state_data= mysqli_fetch_array(mysqli_query($con,"SELECT * FROM states WHERE state_id='".$data['state']."'"));
                                            echo $state_data['state_name'];
                                        ?></td>
                                        <td data-label="News">
                                        <?php	
                                        	$city_data= mysqli_fetch_array(mysqli_query($con,"SELECT * FROM cities WHERE city_id='".$data['city']."'"));
                                            echo $city_data['city_name'];
                                        ?>
                                        </td>
                                        <td data-label="Action">
                                            <?php if($data['status']==1){ ?>
                                            <button onclick="location.reload();location.href='store.php?act=<?php echo $data['id'];?>'" type="button" class="icon-btn btn-success"> ACTIVE </button>
                                            <?php }else{?>
                                            <button onclick="location.reload();location.href='store.php?ina=<?php echo $data['id'];?>'" type="button" class="icon-btn btn-danger">DEACTIVE</button>
                                            <?php } ?>
                                            <a href="store-add.php?edit=<?php echo $data['id'];?>"type="button" class="icon-btn btn-success">EDIT</a>
                                            <a href="store.php?del=<?php echo $data['id'];?>" onclick="return confirm('Are you sure you want to delete this?');"type="button" class="icon-btn btn-danger">DELETE</a>
                                        </td>
                                    </tr>
                                    <?php } ?>
                                </tbody>
                            </table>
                           
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- bodywrapper__inner end -->
</div>
<!-- body-wrapper end -->

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

<!-- jQuery library -->

<?php include('inc/footer.php') ?>