bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

hjkhhjhjol;io;ioio;ioiio;ioreererereio;;iooi;i;o;oii;o;ioo;iio;oi; bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

<?php
include 'lib/config.php';
$date=date('Y-m-d H:i:s');
$id=$_GET['id'];
// $q = "select bookings.*,bookings.id as bk_id,payment_log.txn_amount,payment_log.booking_id,users.*,cabs.rc_no from cabs,bookings,payment_log,users where users.id=bookings.user_id and cabs.id=bookings.cab_id or cabs.id=bookings.cab_id and payment_log.txn_status is true and bookings.status in('completed') and bookings.id=payment_log.booking_id and bookings.id=$id ";
$q = "select bookings.*,bookings.id as bk_id,payment_log.txn_amount,payment_log.booking_id,users.*,cabs.rc_no from cabs,bookings,payment_log,users where users.id=bookings.user_id and cabs.id=bookings.cab_id and payment_log.txn_status is true and bookings.status in('completed') and bookings.id=payment_log.booking_id order by bookings.pickup_date";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query))  {
    $table_data=$res;
}
$sql="select * from profiles";
$result=$conn->query($sql);
if($result->num_rows>0)
{
    $profile_data=$result->fetch_assoc();
}
?>
<!doctype html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <title>Invoice</title>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.0/dist/css/bootstrap.min.css">
    <script src="https://cdnjs.cloudflare.com/ajax/libs/html2pdf.js/0.9.2/html2pdf.bundle.js"></script>
    <style>
        #invoice {
            border: 3px solid #b9b2b2;
        }
        .border  {
            border-color: #cce8cf !important
        }
        span,
        h6  {
            font-size: 16px !important;
            font-weight: 700 !important;
            color: #000000 !important;
        }
        p  {
            color: #454242 !important
        }
        b {
            font-weight: bold;
        }
        table {
            font-size: 14px;
        }
        .navbar-brand .brand_name {
            color: #a6ce39!important;
            font-size: 2rem!important;
        }
        a {
            text-decoration: none;
        }
        th,td,tr,table {
            border: none;
        }
        .table td,.table th {
            border: 2px solid #ebdbdb;
        }
        tr {
            border: 2px solid #ebdbdb!important;
        }
    </style>
</head>
<body class="pt-5 mt-2">
    
    <div class="container " id="invoice">
        <div class="">
            <h3 class="text-center font-weight-bold pt-3"><img src="../logo/<?=$profile_data['logo'];?>" width="100px"></h3>
            <table class="table">
                <tr>
                    <td><b><?=$profile_data['site_name'];?></b>
                        <p><?=$profile_data['contact'];?><br>
                            <?=$profile_data['email'];?><br>
                            <?=$profile_data['address'];?></p>
                        </td>
                        <td><b>INVOICE NO.</b>
                            <p>AWTS<?=$table_data['bk_id'];?></p>
                        </td>
                        <td><b>On Dated</b>
                            <p><?php echo $date;?></p></td>
                        </tr>
                        <tr>
                            <td colspan="3">
                                <b>Customer Details</b>
                                <p><?=$table_data['name'];?></p>
                            </td>
                        </tr>
                    </table>
                </div>
                <table class="table">
                    <tr>
                        <th>Goods/Service Description </th>
                        <th>Quantity</th>
                        <th>Rate</th>
                        <th>TOLL</th>
                        <th>Amount</th>
                    </tr>
                    <tr>
                        <td>
                            <b>Package:-</b><?=$table_data['trip_type'];
                        ?><br><br>
                        <?=$table_data['cab_type'];
                        ?> - <?=$table_data['rc_no'];
                    ?><br>
                    <?=$table_data['booking_from'];
                    ?> To <?=$table_data['booking_to'];
                ?><br>
                On Dated <?=$table_data['pickup_date'];
                ?> <?=$table_data['pickup_time'];
                ?> TO <?=$table_data['drop_date'];
            ?><br><br>
        </td>
        <td>1</td>
        <td><?=number_format($table_data['price'],2);
    ?><br><br><br><br><br><br></td>
    <td><?=$table_data['toll_tax'];
?></td>
<td><?=number_format($table_data['price'],2);
?></td>
</tr>
<tr>
    <th class="text-center">Total</th>
    <td></td>
    <td></td>
    <td></td>
    <th><?php echo number_format($table_data['price'],2);
?></th>
</tr>
</table>
<table class="table">
    <th>Declaration:-<br>
        We declare that this invoice shows the actual price of the goods/service
        described and that all particulars are true
        and correct.<br>
        <small>Terms and conditions as per company policy.</small></th>
        <td><p>we alsodealinhotel,tour packages,camping,rafting,trekking
            and homestay.call <?=$profile_data['contact'];?> or
        visit www.rockonwheelstravels.in</p></td>
    </tr>
</table>
<div class="text-center"><b>This is a computer generated invoice no signature required.</b></div>
</div>
<center class="mb-4 mt-4">
    <button onclick="window.print()" class="btn btn-info px-5">Print</button>
</center>
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.6.0/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>