<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">


<title>Invoice - Express Fly Limited</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@4.5.0/dist/css/bootstrap.min.css" rel="stylesheet">
<style type="text/css">
 

    	body{margin-top:20px;
    color: #2e323c;
    background: #f5f6fa;
    position: relative;
    height: 100%;
    -webkit-print-color-adjust:exact !important;
  print-color-adjust:exact !important;
}
.invoice-container {
    padding: 1rem;
}
.invoice-container .invoice-header .invoice-logo {
    margin: 0.8rem 0 0 0;
    display: inline-block;
    font-size: 1.6rem;
    font-weight: 700;
    color: #2e323c;
}
.invoice-container .invoice-header .invoice-logo img {
    max-width: 200px;
    margin-right:20px;
    
}
.invoice-container .invoice-header address {
    font-size: 0.8rem;
    color: #9fa8b9;
    margin: 0;
}
.invoice-container .invoice-details {
    margin: 1rem 0 0 0;
    padding: 1rem;
    line-height: 180%;
    background: #f5f6fa;
}
.invoice-container .invoice-details .invoice-num {
    text-align: right;
    font-size: 0.8rem;
}
.invoice-container .invoice-body {
    padding: 1rem 0 0 0;
    background: #f5f6fa;
}
.invoice-container .invoice-footer {
    text-align: center;
    font-size: 0.7rem;
    margin: 5px 0 0 0;
}

.invoice-status {
    text-align: center;
    padding: 1rem;
    background: #ffffff;
    -webkit-border-radius: 4px;
    -moz-border-radius: 4px;
    border-radius: 4px;
    margin-bottom: 1rem;
}
.invoice-status h2.status {
    margin: 0 0 0.8rem 0;
}
.invoice-status h5.status-title {
    margin: 0 0 0.8rem 0;
    color: #9fa8b9;
}
.invoice-status p.status-type {
    margin: 0.5rem 0 0 0;
    padding: 0;
    line-height: 150%;
}
.invoice-status i {
    font-size: 1.5rem;
    margin: 0 0 1rem 0;
    display: inline-block;
    padding: 1rem;
    background: #f5f6fa;
    -webkit-border-radius: 50px;
    -moz-border-radius: 50px;
    border-radius: 50px;
}
.invoice-status .badge {
    text-transform: uppercase;
}

@media (max-width: 767px) {
    .invoice-container {
        padding: 1rem;
    }
}


.custom-table {
    border: 1px solid #e0e3ec;
}
.custom-table thead {
   
}

thead tr th{
background-image: url("Capture.PNG");
}



.custom-table thead th {
    border: 0;
    color: #ffffff;
}
.custom-table > tbody tr:hover {
    background: #fafafa;
}
.custom-table > tbody tr:nth-of-type(even) {
    background-color: #ffffff;
}
.custom-table > tbody td {
    border: 1px solid #e6e9f0;
}


.card {
    background: #ffffff;
    -webkit-border-radius: 5px;
    -moz-border-radius: 5px;
    border-radius: 5px;
    border: 0;
    margin-bottom: 1rem;
}

.text-success {
    color: #d81320 !important;
}

.text-muted {
    color: #9fa8b9 !important;
}

.custom-actions-btns {
    margin: auto;
    display: flex;
    justify-content: flex-end;
}

.custom-actions-btns .btn {
    margin: .3rem 0 .3rem .3rem;
}
    </style>
</head>
<body>
<div class="container">
<div class="row gutters">
<div class="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
<div class="card">
<div class="card-body p-0">
<div class="invoice-container">
<div class="invoice-header">




<div class="row gutters">
    
    
<div class="col-lg-6 col-md-6 col-sm-6">
<a href="index.html" class="invoice-logo">
<img src="barLO.png" width="400" height="70"><img src="PLAN.png" width="400" height="70">
</a>
</div>




<?php

 

include "dbconnection.php";
if(isset($_GET['trackingno']))
//if(isset($_POST['trackbutton']))
{

$trackingno = $_GET['trackingno'];
$d = date("Y-m-d");


//$trackingno = 'HAB1145Q';

	
	$query = "select * from tracking where trackingno = '$trackingno'"; 
	$result = mysqli_query($dbcon,$query) ;
	
	if($result->num_rows > 0)
	{
	 // $frow = mysqli_fetch_assoc($result);
	  
	 // if($frow['active'] == 1)
	 // {

		
				
		//echo"<td> SENDER:". $row['sender'] "</td><td> RECEIVER:".$row['receiver']."<br>TEL:".$row['recphone']."<br>ADDRESS:".$row['address']." </td>";
		while($row = mysqli_fetch_assoc($result))
		{
		
			if($row['active'] == 1)
			{
			
			
				
				


   

$msg = $row['msg'];


	echo



					'


<div class="col-lg-6 col-md-6 col-sm-6">
<address class="text-right">


<img height="100px" weight="120px" src="barcode.png">

<h5 class="text-success"><strong>Tracking Code '.$trackingno.'</strong></h5>

</address>

</div>
</div>

 

</div>
<div class="invoice-body">
    
    
    <p  class="term-cond-item inter-400 sm-md-text second-color" >
   This is to certify that we have collected the consignment described below from the "Sender and has accepted to deliver it to the receiver to the address given by the consignee. This parcel is carried under. This agreement herein is valid comect and binding on the parties. Alteration on this Airway Bill of Express Fly Limited after it has been dulysed and accepted renders this parcel valueless, null and void 
</p>
    
    
    
<div class="row gutters">
<div class="col-lg-12 col-md-12 col-sm-12">
<div class="table-responsive">
<table class="table custom-table m-0">
<thead>
<tr>
<th>SENDER</th>
<th></th>
<th>RECEIVER</th>
<th></th>
</tr>
</thead>
<tbody>
<tr>
<td>
<b>Name:</b>

</td>
<td>'. $row['sender'].'</td>
<td><b>Name:</b></td>
<td>'. $row['receiver'].'</td>
</tr>
<tr>
<td>
<b>Phone:</b>
 
</td>
<td>+1 (725) 287-0866</td>
<td><b>Phone:</b></td>
<td>'. $row['recphone'].'</td>
</tr>
<tr>
<td>
<b>Address:</b> 
</td>
<td>'. $row['saddress'].'</td>
<td><b>Address:</b></td>
<td>'. $row['address'].'</td>
</tr>
 
</tbody>
</table>
</div>
</div>
</div>



<div class="row gutters">
<div class="col-lg-12 col-md-12 col-sm-12">
<div class="table-responsive">
<table class="table custom-table m-0">
<thead>
<tr>
<th>SHIPMENT INFORMATION</th>
<th></th>
<th></th>
<th></th>
</tr>
</thead>
<tbody>
<tr>
<td>
<b>Dispatch Date:</b>

</td>
<td>'. $row['dispdate'].'</td>
<td><b>Amount:</b></td>
<td>'. $row['cost'].'</td>
</tr>
<tr>
<td>
<b>Expected Date of Arrival:</b>
 
</td>
<td>'. $row['pickdate'].'</td>
<td><b>Weight:</b></td>
<td>'. $row['weight'].'</td>
</tr>
<tr>
<td>
<b>Package Description:</b>	
 
</td>
<td>'. $row['packagetype'].'</td>
<td><b>Tracking Code:</b></td>
<td>'.$trackingno.'</td>
</tr>
 
</tbody>


</table>
</div>
</div>
</div>


<img height="100px" weight="100px" src="sign.png"><img height="100px" weight="100px" src="https://cargo-xpresslogistics.com/track/print/copy.png">
</div>
	';


		}
			else
			{
				echo "<span style = 'font-weight:bold; color:red;'>Invalid Tracking Code or Non Receipt of Payment/Confirmation !</span> : ";
			}
			
		}
		
		 
	}
    else
	{
           echo "<span style = 'font-weight:bold; color:red;'>Invalid Tracking No</span> : ".$trackingno;
	}	
	         
//	}
//	else
//	{
//	  echo "<span style = 'font-weight:bold; color:red;'>Invalid Tracking Code or Non Receipt of Payment/Confirmation !</span> : ";
//	}	
	
	
}






?>
				
<p class="text-success">If you have any question about this invoice, please contact  Express Fly Limited Support via email info@expressflyltd.com, or to the mobile phone</p>							
		
<div class="row gutters">
<div class="col-xl-12 col-lg-12 col-md-12 col-sm-12">
<div class="custom-actions-btns mb-5">
 
<a href="#" class="btn btn-secondary">
<i class="icon-printer"></i> <button id="sign_out" onclick="window.print()">Print</button> 

<form method="POST" action="admin.php" id="user_fo"><input type="submit" name="logoutt" value="Back" id="log">
           
</a>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<script src="https://code.jquery.com/jquery-1.10.2.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.5.0/dist/js/bootstrap.bundle.min.js"></script>
<script type="text/javascript">
	
</script>
</body>
</html>