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

	$sql="SELECT * from bookings ORDER BY `id` DESC";
     $res=$conn->query($sql);
     if($res->num_rows > 0)
     {
        while($row=$res->fetch_assoc())
        {
            $booking_data[]=$row;
        }
     }
?>

<style>
	.vendor_pass{
		background-color: #ffc800;
		color: #fff;
	}
	.confirmed{
		background-color: #0aa50a;
		color: #fff;
	}
	.cancelled{
		background-color: red;
		color: #fff;
	}
    .booked{
        background-color: #3485b6;
        color: #fff;
    }
</style>
<!-- Page content -->
<div class="container-fluid pt-8">
    <div class="page-header mt-0 p-3">
        <h3 class="mb-sm-0">All Bookings</h3>
    </div>
    <div id="alert2" class="col-md-12"></div>
    	<!-- Table -->
    <div class="row">
        <div class="col-12">
        
           <div class="alert alert-success" id="success" style="display:none">Success! Your Request has been submited.</div>
            
              
            <div class="card shadow">
                <!-- <div class="card-header bg-transparent border-0">
                    <h2 class=" mb-0">Pending Vendors</h2>
                </div> -->
                
                                        
 <div class="card-body">
                    <div class="grid-margin">
                        <div class="">
                            <div class="table-responsive">
                                <table id="example" class="text-center table card-table table-vcenter text-nowrap  align-items-center table-bordered">
                                    <thead>              
                                    <tr>                         	
                                            				<th>S.No</th>
                                            				<th>Status</th>
                                                            <th>Booking Id</th>
                                                            <th>From </th>
                                                            <th>To</th>
                                                            <th>Pickup_date</th>
                                                            <th>pickup_time</th>
                                                            <th>Cab Type</th>
                                                            <th>Drop Date</th>
                                                            <th>Trip_type</th>
                                                            <th>Your Commission</th>
                                                            <th>Pickup Address</th>
                                                            <th>Toll Tax</th>
                                                            <th>Night Charge</th>
                                                            <th>Remark</th>
                                                            <th>Vendor id</th>
                                                            <th>User id</th>
                                                            <th>Agent id</th>
                                                            <th>cab Id</th>
                                                            <th>Driver id</th>
                                                            <th>Bid By</th>
                                                            <th>Admin Bid Price</th>
                                          </tr>
                                    </thead>
                                      <tbody>
										  <?php
										  if(isset($booking_data))
										  {
											  $x=1;
											  foreach($booking_data as $vd)
											  {
												?>
										  <tr>
                                            <td><?=$x?></td>
                                            <td class="<?=$vd['status'];?>"><?=$vd['status'];?></td>
					  						<td>C4U<?=$vd['id'];?></td>
                                            <td><?=$vd['booking_from'];?></td>
                                            <td><?=$vd['booking_to'];?></td>
                                            <td><?=$vd['pickup_date'];?></td>
                                            <td><?=$vd['pickup_time'];?></td>
                                            <td><?=$vd['cab_type'];?></td>
                                            <td><?=$vd['drop_date'];?></td>
                                            <td><?=$vd['trip_type'];?></td>
                                            <td><?=$vd['admin_commission'];?></td>
                                            <td><?=$vd['pickup_address'];?></td>
                                            <td><?=$vd['toll_tax'];?></td>
                                            <td><?=$vd['night_charge'];?></td>
                                            <td><?=$vd['remark'];?></td>
                                            <td><?=$vd['vendor_id'];?></td>
                                            <td><?=$vd['user_id'];?></td>
                                            <td><?=$vd['agent_id'];?></td>
                                            <td><?=$vd['cab_id'];?></td>
                                            <td><?=$vd['driver_id'];?></td>
                                            <td><?=$vd['bid_by'];?></td>
                                            <td><?=$vd['admin_bid_price'];?></td>
                                            
                                          </tr>
										  <?php
												$x++;  
											  }
										  }
										  ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>





<?php 
require_once 'footer.php';
//require_once 'jslinks.php';
?>                          

    <!-- Adon Scripts -->
    <!-- Core -->
    <script src="assets/plugins/jquery/dist/jquery.min.js"></script>
    <script src="assets/js/popper.js"></script>
    <script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>

    <!-- Optional JS -->
    <script src="assets/plugins/chart.js/dist/Chart.min.js"></script>
    <script src="assets/plugins/chart.js/dist/Chart.extension.js"></script>

    <!-- Data tables -->
    <script src="assets/plugins/datatable/jquery.dataTables.min.js"></script>
    <script src="assets/plugins/datatable/dataTables.bootstrap4.min.js"></script>
    <script src="assets/plugins/datatable/dataTables.responsive.min.js"></script>
    <script src="assets/plugins/datatable/responsive.bootstrap4.min.js"></script>

    <!-- Fullside-menu Js-->
    <script src="assets/plugins/toggle-sidebar/js/sidemenu.js"></script>

    <!-- Custom scroll bar Js-->
    <script src="assets/plugins/customscroll/jquery.mCustomScrollbar.concat.min.js"></script>

    <!-- Adon JS -->
    <script src="assets/js/custom.js"></script>
    <script src="assets/js/datatable.js"></script>

</script>