|
Server IP : 82.112.239.40 / Your IP : 3.145.164.105 Web Server : LiteSpeed System : Linux in-mum-web1676.main-hosting.eu 5.14.0-503.35.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 4 05:23:43 EDT 2025 x86_64 User : u641149403 ( 641149403) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u641149403/domains/cabz4you.com/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'lib/config.php';
$sql = $conn->query("SELECT * FROM profiles");
$setting = mysqli_fetch_assoc($sql);
$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 bookings
LEFT JOIN users ON users.id=bookings.user_id
LEFT JOIN payment_log ON payment_log.booking_id=bookings.id
LEFT JOIN cabs ON cabs.id=bookings.cab_id
WHERE bookings.id='$id'";
$query = mysqli_query($conn,$q);
$table_data = mysqli_fetch_array($query);
$cgst=$table_data['price']*2.5/100;
$sgst=$table_data['price']*2.5/100;
$gst=$table_data['price']*5/100;
$total=$table_data['price']+$gst;
?>
<!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" integrity="sha384-B0vP5xmATw1+K9KRQjQERJvTumQW0nPEzvF6L/Z6nronJ3oUOFUFpCjEUQouq2+l" crossorigin="anonymous">
<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">
<!-- 05AATFB7096B1ZB -->
<div class="container " id="invoice">
<div class="">
<h3 class="font-weight-bold pt-3">
<img src="../logo/<?=$setting['logo']?>" width="170px"></h3>
<table class="table">
<tr>
<td><b><?=$setting['site_name']?></b>
<p><?=$setting['address']?></p></td>
<td><b>INVOICE NO.</b>
<p>C4U<?=$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 rowspan="3">
<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 rowspan="3">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>SGST</th>
<td>2.5%</td>
<td><?php echo number_format($sgst,2);?></td>
</tr>
<tr>
<th>CGST</th>
<td>2.5%</td>
<td><?php echo number_format($cgst,2);?></td>
</tr>
<tr>
<th class="text-center">Total</th>
<td></td>
<td></td>
<td></td>
<th><?php echo number_format($total,2);?></th>
</tr>
</table>
<table class="table">
<tr>
<th class="w-25">Company Pan No</th>
<th><?=$setting['pan_no']?></th>
<td rowspan="5"><p>We only deal in taxi service. call <?=$setting['contact']?> or
visit <a href="https://cabz4you.com/">www.cabz4you.com</a></p></td>
</tr>
<tr>
<th>GSTIN</th>
<th><?=$setting['gst_no']?></th>
</tr>
<tr>
<th>Account No.</th>
<th><?=$setting['account_no']?></th>
</tr>
<tr>
<th>IFSC Code</th>
<th><?=$setting['ifsc_code']?></th>
</tr>
<tr>
<th colspan="2">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>
</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>