<?php
require_once('includes.php');
?>
<!-- Page JS Plugins CSS -->
<link rel="stylesheet" href="assets/js/plugins/datatables/jquery.dataTables.min.css" />
<main class="app-layout-content">

    <!-- Page Content -->
    <div class="container-fluid p-y-md">
        <!-- Partial Table -->
        <div class="card">
            <div class="card-header">
                <h4>Enquiry</h4>
            </div>
            <div class="card-block">
                <div id="js-table-list">
                    <table class="js-table-checkable table table-vcenter table-hover">
                        <thead>
                            <tr>
                                <th>Name</th>
                                <th class="hidden-xs hidden-sm">Designation</th>
                                <th class="hidden-xs hidden-sm">Contact Number</th>
                                <th class="hidden-xs">Email ID</th>
                                <th class="hidden-xs hidden-sm">Company Name</th>
                                <th class="hidden-xs hidden-sm">Remarks</th>
                                <th class="hidden-xs hidden-sm">Type</th>
                                <th class="hidden-xs hidden-sm">Date</th>
                                <th class="text-center" style="width:50px;"></th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                                $sqlRec = mysqli_query($con,"select * from job_enquiry");
                               
                               while($res=mysqli_fetch_array($sqlRec))
                               {
                                    ?>
                                    <tr>
                                        <td><?php echo $res['name']; ?></td>
                                        <td><?php echo $res['designation']; ?></td>
                                        <td><?php echo $res['phone']; ?></td>
                                        <td><?php echo $res['email']; ?></td>
                                        <td><?php echo $res['company_name']; ?></td>
                                        <td><?php echo $res['remarks']; ?></td>
                                        <td><?php echo $res['section']; ?></td>
                                        <td><?php echo Date('d-m-Y',strtotime($res['created_at'])); ?></td>
                                        <td>
                                            <a href="delete-enquiry.php?id=<?php echo $res['id']; ?>" onclick="return confirm('Are you sure want to delete enquiry')"><i class="fa fa-trash"></i></a>
                                        </td>
                                    </tr>
                                    <?php
                                }
                            ?>
                        </tbody>
                    </table>

                </div>


            </div>
            <!-- .card-block -->
        </div>
        <!-- .card -->
        <!-- End Partial Table -->

    </div>
    <!-- .container-fluid -->
    <!-- End Page Content -->

</main>


<!-- Site Action -->
<div class="site-action">
    <button type="button" class="site-action-toggle btn-raised btn btn-warning btn-floating" style="visibility: hidden;">
        <i class="back-icon ion-android-close animation-scale-up" aria-hidden="true"></i>
    </button>
    <div class="site-action-buttons">
        <button type="button" data-ajax-response="deletemarked" data-ajax-action="deleteads"
                class="btn-raised btn btn-danger btn-floating animation-slide-bottom">
            <i class="icon ion-android-delete" aria-hidden="true"></i>
        </button>
    </div>
</div>
<!-- End Site Action -->

<?php include("footer.php"); ?>

<script>
    $(function()
    {
        // Init page helpers (Table Tools helper)
        App.initHelpers('table-tools');

        // Init page helpers (BS Notify Plugin)
        App.initHelpers('notify');
    });
</script>
</body>

</html>