<?php
include "../dbconfig.php";
						if (ISSET($_POST['invoice_no'])) {
									//print_r($_POST);
									// -------------- add more rows and connect here to database -- all fields
									$invoice_no=$con->real_escape_string($_POST['invoice_no']);
$sql="SELECT bookings.pickup_date,bookings.start_date,bookings.id AS booking_id,bookings.comments, bookings.parking,bookings.driver_id, bookings.drop_address,bookings.drop_post_code, bookings.waiting_charges,bookings.fare,bookings.total_fare,bookings.waiting_time, bookings.hours,bookings.mins,bookings.other,
customers.id AS customer_id, customers.name AS customer_name,customers.address1,customers.post_code,customers.city, customers.mobile, payment_type.name AS payment_type, employees.first_name AS driver, vehicles.make as vehicle, company_contact.name as company_contact 
FROM bookings
LEFT JOIN customers ON bookings.customer_id = customers.id 
LEFT JOIN payment_type ON bookings.payment_type = payment_type.id 
LEFT JOIN employees ON bookings.driver_id = employees.id 
LEFT JOIN vehicles ON bookings.vehicle_id = vehicles.id 
LEFT JOIN company_contact ON customers.id = company_contact.customer_id 
WHERE bookings.invoice_no=$invoice_no GROUP BY bookings.id";
// $customer_id=$_GET['company_id'];
									//echo $sql;
									//exit;
									$res=mysqli_query($con,$sql);
									$job=mysqli_query($con,$sql);
									?>
                           
                           
 <div class="modal-dialog modal-lg">
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
        <h4 class="modal-title">List of all Jobs</h4>
      </div>
      <div class="modal-body">
     
     
							
      <div class="col-md-12" id="filter_results">
        
        <?php include "invoice_jobs_data.php";?>
        
		  
	    </div> 
                    </div>
                 <div class="modal-footer">
        <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
        </form>
      </div>
    </div><!-- /.modal-content -->
  </div><!-- /.modal-dialog -->
                <?php } ?>