|
Server IP : 82.112.239.40 / Your IP : 18.217.142.228 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('d-m-Y');
$id=$_GET['id'];
$q ="SELECT *,booking_quotation.id as bk_id FROM booking_quotation LEFT JOIN users ON users.id=booking_quotation.user_id WHERE booking_quotation.id='$id'";
$query = mysqli_query($conn,$q);
$table_data = mysqli_fetch_array($query);
// echo '<pre>';
// print_r($table_data);
// echo '</pre>';
$bookid=explode('-', $table_data['pickup_date']);
$bookingID = implode('', $bookid).$table_data['bk_id'];
?>
<!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>Quotation</title>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.0/dist/css/bootstrap.min.css">
<script src="https://cdn.bootcss.com/html2pdf.js/0.9.1/html2pdf.bundle.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/html2pdf.js/0.9.1/html2pdf.bundle.min.js"></script>
<style>
@media print {
center{
display: none;
}
}
#invoice{
border: 3px solid #b9b2b2;
padding:20px;
}
h1{
border-bottom: 2px solid #ccc;
}
.border {
border-color: #cce8cf !important
}
span,
h6 {
font-size: 16px !important;
color: #000000 !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;
padding: 5px 20px;
}
tr{
border: 2px solid #ebdbdb!important;
}
.text-uppercase{
text-transform: uppercase;
}
.company-details{
border: 2px solid #ebdbdb;
padding:10px;
}
.company-details p{
margin-bottom:0;
font-weight:bold;
color:#000;
}
.text-right{
text-align:right;
}
.d-flex{
display:flex;
}
.bordered{
border: 2px solid #ebdbdb;
}
.footer{
justify-content: space-around;
padding: 10px 0;
}
.footer a{
font-weight: 600;
font-size: 18px;
}
.theme-color{
color:#012c6d;
}
.text-capitalize{
text-transform:capitalize;
}
.bg-grey{
background-color: #ccc!important;
}
.w-50{
width: 50%;
}
.customer-details td,.trip-details td{
width: 50%;
}
.customer-details td b{
display: inline-block;
width: 110px;
}
.trip-details td p{
display: flex;
gap: 20px;
margin-bottom: 8px;
}
.trip-details td b{
width: 30%;
display: inline-block;
}
.trip-details td span{
width: 70%;
}
.border-0,.border-0 td{
border: none;
}
img{
width: 25%;
border-radius: 6px;
}
.border-0 p{
font-size: 18px;
margin-bottom: 0;
}
.top td{
width: 50%;
padding: 10px 0;
}
.top{
margin-bottom: 0;
}
.mb-0{
margin-bottom: 0;
}
.brand-name{
/* border-bottom: 1px solid #ccc;*/
margin-top: 50px;
color: #ccc;
padding-bottom: 10px;
text-transform: uppercase;
}
.mb-0{
margin-bottom: 0;
}
</style>
</head>
<body class="pt-5 mt-2">
<div class="container " id="invoice">
<div class="">
<h1 class="text-center font-weight-bold pb-2 text-uppercase theme-color"><img src="../logo/<?=$setting['logo']?>"></h1>
<table class="table table-borderless">
<tr class="text-center bg-grey">
<th colspan="2">Customer Details</th>
</tr>
<tr class="customer-details">
<td>
<p><b>Name</b> <span>: <?=$table_data['name'];?></span></p>
<p><b>Phone</b> <span>: <?=$table_data['contact'];?></span></p>
<p><b>Email</b> <span>: <?=$table_data['email'];?></span></p>
</td>
<td>
<p><b>Quotation ID</b> <span>: <?=$bookingID;?></span></p>
<p><b>Quotation on</b> <span>: <?php echo $date;?></span></p>
</td>
</tr>
</table>
<table class="table table-borderless">
<tr class="text-center bg-grey">
<th colspan="2">Trip Details</th>
</tr>
<tr class="trip-details">
<td style="width: 50%;">
<p><b>Pick Up Location</b><span>: <?=$table_data['pickup_address'];?></span></p>
<p><b>Booking Stops</b><span>: <?php echo str_replace('/',".<br>: ",$table_data['booking_stops']);?></span></p>
<p><b>Drop Up Location</b><span>: <?=$table_data['booking_to'];?></span></p>
<p><b>Pickup date</b><span>: <?=$table_data['pickup_date'];?></span></p>
<p><b>Pickup Time</b><span>: <?=$table_data['pickup_time'];?></span></p>
<p><b>Drop Date</b><span>: <?=$table_data['drop_date'];?></span></p>
</td>
<td>
<p><b>Trip Type</b> <span>: <?=$table_data['trip_type'];?></span></p>
<p><b>Cab Type</b> <span>: <?=$table_data['cab_type'];?></span></p>
<p><b>No. of Passenger</b> <span>: <?=$table_data['number_passenger'];?></span></p>
<p><b>Number Of Day</b> <span>: <?=$table_data['no_of_day'];?></span></p>
<p><b>Distance (Km)</b> <span>: <?=$table_data['distance'];?></span></p>
<p><b>Night Charge</b> <span>: <?=$table_data['night_charge'];?></span></p>
<p><b>Luggage</b> <span>: <?=$table_data['luggage'] ?></span></p>
<p><b>Extra Price</b> <span>: <?php $table_data['after_extra_price']; ?></span></p>
<p><b>Toll</b> <span>: <?php if($table_data['toll_tax']==0) echo "Excluding"; else echo "Including" ?></span></p>
<p><b>State Tax</b> <span>: <?php if($table_data['state_tax']==0) echo "Excluding"; else echo "Including" ?></span></p>
<p><b>Parking</b> <span>: <?php if($table_data['parking']==0) echo "Excluding"; else echo "Including" ?></span></p>
<p><b>Remark</b> <span>: <?php $table_data['remark']; ?></span></p>
<p><b>Base Fare</b> <span>: Rs. <?=number_format($table_data['price'],2);?></span></p>
</td>
</tr>
<!-- <tr class="trip-details">
<td></td>
<td>
<p class="mb-0"><b>Total Amount Paid</b> <span><b>: Rs. <?=number_format($table_data['price'],2);?></b></span></p>
</td>
</tr> -->
</table>
</div>
<!-- <h6 class="text-right brand-name">For <?=$setting['site_name']?></h6> -->
</div>
<center class="mb-4 mt-4">
<button onclick="window.print()" class="btn btn-info px-5">Print</button>
<button class="btn btn-primary" onclick="createPDF()">Download Pdf </button>
</center>
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js"></script>
<script>
function createPDF() {
var element = document.getElementById('invoice');
html2pdf(element, {
margin:1,
padding:0,
filename: 'quotation.pdf',
image: { type: 'jpeg', quality: 1 },
html2canvas: { scale: 2, logging: true },
jsPDF: { unit: 'in', format: 'A2', orientation: 'P' },
class: createPDF
});
};
</script>
</body>
</html>