<?php
ob_start();
session_start();
include("inc/config.php");
$ids = $_GET['id'];
$statement = $pdo->prepare("SELECT ftl.*,cu.cust_name FROM tbl_ftl_details_new ftl INNER JOIN tbl_customer cu on cu.id=ftl.consignee_id where 1=1 and status=1 and ftl.id in (".$ids.")");
$statement->execute();
$query = $statement->fetchAll(PDO::FETCH_ASSOC);
$totalFiltered = $statement->rowCount();
?>

<body onload="window.print();setTimeout(window.close, 0);">
 <?php foreach($query as $data){ ?> 
<table style="width:100%;border:none;">    
    <tr>
        <td style="width:10%;text-align:left;border:none;">
            <img src="https://firstmatrix.cfd/venus_cargo/assets/uploads/user-1.png">
            
        </td>
        <td style="width:90%;border:none;">
            <center style="font-weight:bolder;">Venus Cargo & Logistics Pvt Ltd</center>
            <center><b>REG OF</b> &nbsp;&nbsp;U 2069, Akshar Business Park, Plot No 3, Sector 25, Vashi, Nav</center>
            <center>Mumbai-400703</center><br>
            <center><b style="vertical-align:bottom;">FTL DIVISION</b></center>
        </td>
    </tr>
</table>
<br>
<table style="width:100%;">
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;">FTL ORDER/ADVANCE SLIP NO</td>
        <td style="width:20%;">&nbsp;<?=$data['ftl_number']?></td>
        <td style="width:20%;border:none;">&nbsp;</td>
        <td style="width:20%;font-size:12px;font-weight:bold;">Date</td>
        <td style="width:20%">&nbsp;<?=$data['ftl_date']?></td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;">Transporter name </td>
        <td style="width:20%;" colspan="3">&nbsp;<?=$data['transport_name']?></td>
        <td style="width:20%;border:none;">&nbsp;</td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="font-size:12px;font-weight:bold;">DRIVER MOB. NO.</td>
        <td >&nbsp;<?=$data['driver_mobile_no']?></td>
        <td style="width:20%;font-size:12px;font-weight:bold;">&nbsp;VEHICLE NO.</td>
        <td colspan="2">&nbsp;<?=$data['vechicle_no']?></td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="font-size:12px;font-weight:bold;">VEHICLE TYPE:-</td>
        <td >&nbsp;<?=$data['vechicle_type']?></td>
        <td colspan="3" style="border:none;">&nbsp;</td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="font-size:12px;font-weight:bold;">MODE OF DISPATCH</td>
        
        <td colspan="4">&nbsp;FTL</td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="font-size:12px;font-weight:bold;">Pick up from</td>
        <td style="font-size:12px;font-weight:bold;" colspan="2">&nbsp;Delivery Location</td>
        <td style="width:20%;font-size:12px;font-weight:bold;" colspan="2">&nbsp;Delivery State</td>
    </tr>
    <tr style="border:none;">
        <td style="font-size:12px;font-weight:bold;">&nbsp;<?=$data['pick_up_form']?></td>
        <td style="font-size:12px;font-weight:bold;" colspan="2">&nbsp;<?=$data['delivery_location']?></td>
        <td style="width:20%;font-size:12px;font-weight:bold;" colspan="2">&nbsp;<?=$data['delivery_date']?></td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;">Delivery Commitment date</td>
        <td style="width:25%;text-align:left;">&nbsp;<?=$data['delivery_commitment_date']?></td>
        <td style="width:10%;border:none;text-align:left;">&nbsp;</td>
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;">POD Received date</td>
        <td style="width:25%;text-align:left;">&nbsp;<?=$data['pod_received_date']?></td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="font-size:12px;font-weight:bold;text-align:left;">Delivered date:-</td>
        <td style="text-align:left;">&nbsp;<?=$data['deliverd_date']?></td>
        <td colspan="3" style="border:none;text-align:left;">&nbsp;</td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;">Vehicle Owner name</td>
        <td style="width:25%;text-align:left;">&nbsp;<?=$data['vehicle_owner_name']?></td>
        <td style="width:10%;border:none;text-align:left;">&nbsp;</td>
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;">Contact No:-</td>
        <td style="width:25%;text-align:left;">&nbsp;<?=$data['contact_no']?></td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;">Driver's Name :-</td>
        <td style="width:25%;text-align:left;">&nbsp;<?=$data['driver_name']?></td>
        <td style="width:10%;border:none;text-align:left;">&nbsp;</td>
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;">Contact No:-</td>
        <td style="width:25%;text-align:left;">&nbsp;<?=$data['alter_no']?></td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;">Vender Advance slip no :-</td>
        <td style="width:25%;text-align:left;">&nbsp;<?=$data['vender_advance_slip_no']?></td>
        <td style="width:10%;border:none;text-align:left;">&nbsp;</td>
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;">Date</td>
        <td style="width:25%;text-align:left;">&nbsp;<?=$data['vender_advance_date']?></td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">Our Customer name:-</td>
       
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="3">&nbsp;<?=$data['cust_name']?></td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">Venus Docket No:-</td>
       
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">&nbsp;<?=$data['docket_no']?></td>
        <td style="width:20%;border:none">&nbsp;</td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">Our Frieght Charges</td>
       
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">&nbsp;<?=$data['cus_fright_charge']?></td>
        <td style="width:20%;border:none">&nbsp;</td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">Vender cost</td>
       
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">&nbsp;<?=$data['cus_vendor_cost']?></td>
        <td style="width:20%;border:none">&nbsp;</td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">Loading & Unloading</td>
       
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">&nbsp;<?=$data['cus_loading_unloading']?></td>
        <td style="width:20%;border:none">&nbsp;</td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">Other Charges</td>
       
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">&nbsp;<?=$data['cus_other_charges']?></td>
        <td style="width:20%;border:none">&nbsp;</td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">OUR P/L</td>
       
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">&nbsp;<?=$data['cus_pl']?></td>
        <td style="width:20%;border:none">&nbsp;</td>
    </tr>
     <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:center;" colspan="2">VENDOR BANK DETAILS </td>
        <td style="width:20%;border:none">&nbsp;</td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:center;" colspan="2">Bank Name</td>
       
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">&nbsp;<?=$data['bank_name']?></td>
        <td style="width:20%;border:none">&nbsp;</td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:center;" colspan="2">Account no</td>
       
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">&nbsp;<?=$data['account_no']?></td>
        <td style="width:20%;border:none">&nbsp;</td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:center;" colspan="2">IFSC</td>
       
        <td style="width:20%;font-size:12px;font-weight:bold;text-align:left;" colspan="2">&nbsp;<?=$data['ifsc_code']?></td>
        <td style="width:20%;border:none">&nbsp;</td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="width:20%;text-align:center;" colspan="5">&nbsp;Encl: Vehicle Insurance copy Rto passing copy with Driver Licence copy with consignment Invoice Copy.</td>
        
    </tr>
     <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    <tr style="border:none;">
        <td style="font-size:12px;font-weight:bold;">Prepared by</td>
        <td style="font-size:12px;font-weight:bold;" colspan="2">&nbsp;Marketing Executive</td>
        <td style="width:20%;font-size:12px;font-weight:bold;" colspan="2">&nbsp;Approved by</td>
    </tr>
    <tr style="border:none;">
        <td style="font-size:12px;font-weight:bold;">&nbsp;<?=$data['prepared_by']?></td>
        <td style="font-size:12px;font-weight:bold;" colspan="2">&nbsp;<?=$data['marketing_executive']?></td>
        <td style="width:20%;font-size:12px;font-weight:bold;" colspan="2">&nbsp;<?=$data['approved_by']?></td>
    </tr>
    <tr style="border:none;">
        <td style="width:20%;border:none">&nbsp;</td>
        
    </tr>
    
</table>
<?php } ?>
</body>
<style>
    table,th,td{
        border:1px solid black;
        border-collapse:collapse;
        padding:2px 5px;
        text-align:center;
    }
    @page  
{ 
    size: auto; 
    margin: 5mm 5mm 5mm 5mm;  
} 
body  
{ 
    margin: 0px;  
} 
</style>
 <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
