|
Server IP : 103.191.208.227 / Your IP : 3.143.1.161 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';
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Vflyorions Invoice</title>
<!-- Google Font: Source Sans Pro -->
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
<!-- Font Awesome -->
<link rel="stylesheet" href="../../plugins/fontawesome-free/css/all.min.css">
<!-- icheck bootstrap -->
<link rel="stylesheet" href="../../plugins/icheck-bootstrap/icheck-bootstrap.min.css">
<!-- Theme style -->
<link rel="stylesheet" href="../../dist/css/adminlte.min.css">
<!-- DataTables CSS -->
<link rel="stylesheet" href="https://cdn.datatables.net/2.0.8/css/dataTables.dataTables.css">
</head>
<body class="mb-8 my-4">
<div class="container-fluid p-3">
<a href="index.php" class="btn btn-info">Create Invoice</a>
<div class="row">
<div class="col-sm-12">
<div class="register-box" style="width:380px;"></div>
<div class="card card-outline card-primary">
<div class="card-header text-center">
<a href="" class="h1"><b>Invoice History</b></a>
</div>
<div class="card-body">
<table id="example" class="display" style="width:100%">
<thead>
<tr>
<th style="text-align:center;">Sr. No.</th>
<th style="text-align:center;">Invoice No.</th>
<th style="text-align:center;">Full Name</th>
<th style="text-align:center;">Contact</th>
<th style="text-align:center;">Plan</th>
<th style="text-align:center;">Amount</th>
<th style="text-align:center;">Offer</th>
<th style="text-align:center;">Download Invoice</th>
<th style="text-align:center;">Send Email</th>
<!--<th style="text-align:center;">Send Email with pdf</th>-->
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM invoice order by id DESC";
$result = $conn->query($sql);
$sr=1;
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
?>
<tr>
<td style="text-align:center;"><?= $sr;?></td>
<td style="text-align:center;"><?= $row['invoice_no'];?></td>
<td style="text-align:center;"><?= $row['fullname'];?></td>
<td style="text-align:center;"><?= $row['contact'];?></td>
<td style="text-align:center;"><?= $row['plan'];?></td>
<td style="text-align:center;"><?= $row['price'];?></td>
<td style="text-align:center;"><?= $row['offer'];?></td>
<td style="text-align:center;"><button class="btn btn-primary" target="_blank" onclick="downloadInvoice(<?= $row['id'] ?>)">Download</button></td>
<td style="text-align:center;"><button class="btn btn-primary" onclick="sendEmail(<?= $row['id'] ?>)">Send Email</button></td>
<!--<td style="text-align:center;"><button class="btn btn-primary" onclick="sendEmail1(<?= $row['id'] ?>)">Send Email</button></td>-->
</tr>
<?php
$sr=$sr+1; }
}
?>
</tbody>
</table>
</div>
<!-- /.form-box -->
</div><!-- /.card -->
</div>
</div>
</div>
<!-- Scripts -->
<!-- jQuery -->
<script src="../../plugins/jquery/jquery.min.js"></script>
<!-- DataTables JS -->
<script src="https://cdn.datatables.net/2.0.8/js/dataTables.js"></script>
<!-- Bootstrap 4 -->
<script src="../../plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- AdminLTE App -->
<script src="../../dist/js/adminlte.min.js"></script>
<script>
function downloadInvoice(id) {
window.open(`download_invoice.php?id=${id}`, '_blank');
}
function sendEmail(id) {
window.open(`send_email.php?id=${id}`);
}
</script>
<!-- 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 = "";
});
</script>
<?php
unset($_SESSION['status']);
}
?>
<script>
$(document).ready(function() {
$('#example').DataTable({
pagingType: 'simple_numbers'
});
});
</script>
</body>
</html>