<?php
require_once 'header.php';
require_once 'navbar.php';

$type = $_GET['type'];
switch ($type) {

    case "driver":
    $sql = "SELECT a.*,vendor_profile.* FROM vendor_login a INNER JOIN vendor_profile ON vendor_profile.vendor_id=a.id WHERE a.id NOT IN (SELECT b.vendor_id FROM drivers b)";

    break;

    case "cab":
    $sql = "SELECT vendor_login.*,vendor_profile.* FROM vendor_login INNER JOIN vendor_profile ON vendor_profile.vendor_id=vendor_login.id WHERE vendor_login.id NOT IN (SELECT cabs.vendor_id FROM cabs)";

    break;

    default:
    $type = 'Driver & Cab';
    $sql = "SELECT vendor_login.*,vendor_profile.* FROM vendor_login INNER JOIN vendor_profile ON vendor_profile.vendor_id=vendor_login.id WHERE vendor_login.id NOT IN (SELECT cabs.vendor_id FROM cabs) AND vendor_login.id NOT IN (SELECT drivers.vendor_id FROM drivers)";
}
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $vendor_data[] = $row;
    }
}

?>

<!-- Page content -->
<div class="container-fluid pt-8">
    <div class="page-header mt-0 py-3">
        <h3 class="mb-sm-0 text-uppercase"><?=$type?></h3>
    </div>
    <div id="alert2" class="col-md-12"></div>
    <!-- Table -->
    <div class="row">
        <div class="col-12">

         <div class="card shadow p-4">
            <div class="card-header bg-transparent border-0 pl-0">
                <h2 class=" mb-0 text-capitalize"><?=$type;?> Not Attached</h2>
            </div>
            <div class="">
                <div class="grid-margin">
                    <div class="">
                        <div class="table-responsive">
                            <table id="example" class="table card-table table-vcenter text-nowrap  align-items-center">
                                <thead class="">
                                    <tr>
                                        <th style="width: 80px">S.No</th>
                                        <th>Vendor Id</th>
                                        <th>Name</th>
                                        <th>Contact</th>
                                        <th>Email</th>
                                        <th>City</th>
                                        <th>State</th>
                                    </tr>
                                </thead>
                                <tbody >
                                    <?php
                                    $x=1;
                                    foreach($vendor_data as $vd)
                                    {
                                        ?>
                                        <tr>
                                            <td style="width: 80px"><?php echo $x?></td>
                                            <td><a style="color: #4e4c73;font-weight:400" href="edit_vendor?token=<?=$vd['id'];?>"><?=$vd['id'];?></a></td>
                                            <td><?=$vd['full_name'];?></td>
                                            <td><?=$vd['contact'];?></td>
                                            <td><?=$vd['email'];?></td>
                                            <td><?=$vd['city'];?></td>
                                            <td><?=$vd['state'];?></td>
                                        </tr>
                                        <?php
                                        $x++;  
                                    }
                                    ?>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
</div>

<?php
require_once 'footer.php';
require_once 'jslinks.php';
?>
<script src="assets/js/custom.js"></script>
<script src="assets/js/datatable.js"></script>