File: /var/www/unbox/uc-live/admin-dash/invoice-list.php
<?php
include('header.php');
session_start();
unset($_SESSION['date-filter']);
unset($_SESSION['fy-filter']);
$subquery = "";
//show data as per selected date
if (isset($_POST['searchDate'])) {
// check select financial dropdown
if (($_POST['fy_list'] != '') && ($_POST['fy_list'] != '0')) {
$subTable = $_POST['fy_list'];
$_SESSION['fy-filter'] = $subTable;
$years = (explode("_", $subTable));
$last_year = $years[0];
$present_year = $years[1];
$mssg = ' of Year (' . $present_year . ' -' . $last_year . ')';
}
if (($_POST['fromdate'] != '') && ($_POST['todate'] == '')) {
$date = date('Y-m-d', strtotime($_POST['fromdate']));
$subquery = "and date(transaction_date)='$date'";
$_SESSION['date-filter'] = $subquery;
$msg = 'Showing Data of ' . date('d F Y', strtotime($date));
} else if (($_POST['fromdate'] != '') && ($_POST['todate'] != '')) {
$fromdate = date('Y-m-d', strtotime($_POST['fromdate']));
$todate = date('Y-m-d', strtotime($_POST['todate']));
$subquery = "and (date(transaction_date) >='$fromdate' AND date(transaction_date) <= '$todate')";
$_SESSION['date-filter'] = $subquery;
$msg = 'Showing Data of between ' . date('d F Y', strtotime($fromdate)) . ' to ' . date('d F Y', strtotime($todate));
}
}
// to get year name for financial yeR
if (date('m') < 4) { //Upto April
$financial_year = date('Y');
} else { //After April
$financial_year = (date('Y') + 1);
}
$earliest_year = $financial_year - 4;
// clear search date filter
// if (isset($_POST['clearSearch'])) {
// unset($_SESSION['date-filter']);
// }
?>
<!-- Plugin css for this page -->
<link rel="stylesheet" href="assets/vendors/datatables.net-bs5/dataTables.bootstrap5.css">
<!-- End plugin css for this page -->
<?php include('sidebar.php'); ?>
<div class="page-wrapper">
<?php include('navbar.php'); ?>
<div class="page-content">
<nav class="page-breadcrumb">
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="invoice-list.php">Invoice Details</a></li>
<li class="breadcrumb-item active" aria-current="page">Invoice</li>
</ol>
</nav>
<div class="row">
<div class="col-md-12 grid-margin stretch-card">
<div class="card">
<div class="card-body">
<div class="col-lg-4">
<h6 class="card-title">Invoice Details</h6>
<p class="text-muted mb-3">Get All Details Here.</p>
</div>
<div class="col-lg-12">
<div class="form-group">
<form method="post" class="form-inline d-flex gap-2 mb-2" onsubmit="return checkRadio();">
<div class="col-lg-8 d-flex gap-2">
<div class="search-btn">
<select class="form-control" name="fy_list" id="fy_list">
<?php foreach (range($financial_year, $earliest_year) as $i) { ?>
<option value="<?php echo $i - 1; ?>_<?php echo $i; ?>" <?php if (($_SESSION['fy-filter']) == (($i - 1) . '_' . $i)) {
echo "selected";
} ?>><?php echo $i - 1; ?>_<?php echo $i; ?> </option>
<?php } ?>
</select>
</div>
<div class="search-btn">
<input class="form-control" type="date" name="fromdate" id="fromdate" placeholder="From Date" />
</div>
<div class="search-btn">
<input class="form-control" type="date" name="todate" id="todate" placeholder="To Date" />
</div>
<button type="submit" name="searchDate" class="btn btn-primary">Search</button>
</div>
<div class="col-lg-4">
<a target="_blank" href="invoice-excel.php">
<button name="download" type="button" class="btn btn-secondary" style="float: right;">
<i style="font-size:15px; color:#fff500;" class="tf-icons bx bxs-download" title="Export to Excel"></i>Download Excel
</button>
</a>
</div>
</form>
</div>
</div>
<span style="font-size: 12px;color: #ff0202;"><?php if (isset($msg)) {
echo $msg;
} ?><?php if (isset($mssg)) {
echo $mssg;
} ?></span>
<div class="table-responsive text-nowrap p-2">
<!-- <table id="dataTableExample" class="table"> -->
<table id="invoice_list" class="table">
<thead>
<tr>
<th title="Invoice Id">Inv id</th>
<th title="View Receipt / Detail">View</th>
<th title="From Domain">Domain</th>
<th title="Vendor">Vendor</th>
<th title="Transaction Type"> Txn Type</th>
<th title="Order Id">Order Id</th>
<th title="Product MRP">MRP</th>
<th title="Transaction Date">Transaction Date</th>
<th title="Payment For">Payment For</th>
<th title="Customer Name">Customer Name</th>
<th title="Customer Mobile">Customer Mobile</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Receipt Modal -->
<div class="modal fade" id="detailModal" tabindex="-1" aria-labelledby="detailModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title">Customer Invoice Details </h5>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="btn-close"></button>
</div>
<div class="modal-body" id="detail_modal"> </div>
<!-- <div class="modal-footer"> <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button> </div> -->
</div>
</div>
</div>
<!-- Receipt Modal -->
<script>
//onclick open modal data for transaction receipt
function viewData(p_id) {
var site = "txn_detail.php?id=" + p_id;
jQuery.ajax({
url: site,
type: 'POST',
data: 'html',
success: function(data) {
document.getElementById("detail_modal").innerHTML = data;
}
})
}
</script>
<?php include('footer.php'); ?>
<!-- Content -->
<script src="assets/vendors/datatables.net/jquery.dataTables.js"></script>
<script src="assets/vendors/datatables.net-bs5/dataTables.bootstrap5.js"></script>
<script src="assets/js/data-table.js"></script>
<script type="text/javascript">
// var jq = jQuery.noConflict();
$(document).ready(function() {
$('#invoice_list').dataTable({
"processing": true,
"serverSide": true,
"responsive": true,
"ajax": "/admin-dash/invoice-data.php",
"columns": [{
"data": "invoice_id"
},
{
"data": "view"
},
{
"data": "domain"
},
{
"data": "vendor"
},
{
"data": "txn_type"
},
{
"data": "order_id"
},
{
"data": "product_mrp"
},
{
"data": "txn_date"
},
{
"data": "payment_for"
},
{
"data": "c_name"
},
{
"data": "c_mobile"
}
],
"order": [
[0, 'desc']
],
"bPaginate": true,
"iDisplayLength": 50,
"lengthMenu": [
[50, 100, 300, 500, 1000],
[50, 100, 300, 1000, "All"]
]
});
});
</script>
<script>
function checkRadio() {
var fy_list = document.getElementById('fy_list').value;
var fromdate = document.getElementById('fromdate').value;
var todate = document.getElementById('todate').value;
if (fromdate == '') {
document.getElementById("fromdate").focus();
document.getElementById("fromdate").style.border = "#e66262 1px solid";
return false;
}
if ((todate != '') && (fromdate == '')) {
document.getElementById("fromdate").focus();
document.getElementById("fromdate").style.border = "#e66262 1px solid";
return false;
}
if (((fy_list != '') && (fy_list != '0')) && (fromdate == '')) {
document.getElementById("fromdate").focus();
document.getElementById("fromdate").style.border = "#e66262 1px solid";
return false;
}
return true;
}
</script>
</body>
</html>