<?php 
$page='query';
$page1='allforms';

include('inc/sidebar.php') ;
 if(isset($_GET['del']))
  {
      $id = $_GET['del'];
      $del = mysqli_query($con,"delete from query_form where id = '$id'");
     if($del){
      	echo "<script type='text/javascript'>window.location=\"query.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 Query</h6>
            </div>
            <div class="col-lg-8 col-sm-6 text-sm-right mt-sm-0 mt-3 right-part">
                <button type="button" class="btn btn--primary exampleModal" data-modal_title="Add Model"data-toggle="modal" data-target="#exampleModal"style="height: 38px;"><i class='fas fa-file-csv'></i>Export by Date</button>
                <a href="export/exportQuery.php" class="btn btn--primary"><i class="fas fa-file-csv"></i> Export</a>
            </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>Name</th>
                                        <th>Phone</th>
                                        <th>Email</th>
                                        <th>Profession</th>
                                        <th>City</th>
                                        <th>Space</th>
                                        <th>Comfortable With This Budget</th>
                                        <th>Date</th>
                                        <th>Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php	
                                        $sql= "SELECT * FROM query_form ORDER BY id DESC";
                                        $qry= mysqli_query($con,$sql);
                                        $i=0;
                                        while($data= mysqli_fetch_array($qry))
                                        { $i++; 
                                    ?>
                                    <tr>
                                        <td data-label="SL"><?php echo $i; ?></td>
                                        <td data-label="News"><?php echo $data['name']; ?></td>
                                        <td data-label="News"><?php echo $data['phone']; ?></td>
                                        <td data-label="News"><?php echo $data['email']; ?></td>
                                        <td data-label="News"><?php echo $data['profession']; ?></td>
                                        <td data-label="News"><?php echo $data['city']; ?></td>
                                        <td data-label="News"><?php echo $data['property']; ?></td>
                                        <td data-label="News"><?php echo $data['budget']; ?></td>
                                        <td><?php echo date('M d, Y', strtotime($data['date'])) ?></td>
                                        <td data-label="Action">
                                            <a href="query.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>
</div>

    </div>
    </div>
<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
            <div class="modal-dialog" role="document">
                <div class="modal-content">
                    <div class="modal-header">
                        <h5 class="modal-title" id="exampleModalLabel">Select Dates To filter</h5>
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">&times;</span>
                        </button>
                    </div>
                    <div id="ShowData">
                        <form method="post" action="export/exportQuery.php" name="datafrm" id="datafrm" enctype="multipart/form-data">
                            <div class="modal-body">
                                <div class="form-group row">
                                    <div class="col-md-6">
                                        <label class="form-control-label font-weight-bold">From Date<span class="text-danger">*</span></label>
                                        <input type="date" class="form-control" placeholder="" value=""id="model" name="from" required="" />
                                    </div>
                                    <div class="col-md-6">
                                        <label class="form-control-label font-weight-bold">To Date<span class="text-danger">*</span></label>
                                        <input type="date" class="form-control" placeholder="" value=""id="model" name="to" required="" />
                                    </div>
                                </div>
                                <div class="status"></div>
                            </div>
                            <div class="modal-footer">
                                <input type="submit" name="datafrmSubmit" id="datafrmSubmit" onClick="window.location.reload();" value="Export Now"class="btn btn--primary w-100">
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
<script>
    $(document).ready(function() {
        $("#datafrmSubmit").click(function() {
            $("#exampleModal").modal("hide");
        });
    });
</script>
<?php include('inc/footer.php') ?>