File "expense_report.php"
Full Path: /home/leadltht/fastlinkinternet.com/administrator/data-provider/admin/expense/expense_report.php
File size: 6.01 KB
MIME-type: text/html
Charset: utf-8
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Expense Report</title>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" rel="stylesheet">
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.datatables.net/1.10.24/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.10.24/js/dataTables.bootstrap4.min.js"></script>
<link href="https://cdn.datatables.net/1.10.24/css/dataTables.bootstrap4.min.css" rel="stylesheet">
</head>
<body>
<div class="container mt-4">
<div class="card card-outline card-primary">
<div class="card-header">
<h3 class="card-title">Generate Expense Report</h3>
</div>
<div class="card-body">
<div class="row">
<div class="col-md-2">
<div class="form-group">
<label for="year">Year</label>
<select id="year" class="form-control">
<option value="">All</option>
<?php for($i = date('Y'); $i >= 2022; $i--): ?>
<option value="<?= $i ?>"><?= $i ?></option>
<?php endfor; ?>
</select>
</div>
</div>
<div class="col-md-2">
<div class="form-group">
<label for="month">Month</label>
<select id="month" class="form-control">
<option value="">All</option>
<?php for($i = 1; $i <= 12; $i++): ?>
<option value="<?= $i ?>"><?= date('F', mktime(0, 0, 0, $i, 10)) ?></option>
<?php endfor; ?>
</select>
</div>
</div>
<div class="col-md-2">
<div class="form-group">
<label for="day">Day</label>
<select id="day" class="form-control">
<option value="">All</option>
<?php for($i = 1; $i <= 31; $i++): ?>
<option value="<?= $i ?>"><?= $i ?></option>
<?php endfor; ?>
</select>
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label for="collected_by">Recorded By</label>
<select id="collected_by" class="form-control">
<option value="">All</option>
<?php
$qry = $conn->query("SELECT DISTINCT `collected_by` FROM `expense_list` ORDER BY `collected_by` ASC");
while($row = $qry->fetch_assoc()):
?>
<option value="<?= $row['collected_by'] ?>"><?= $row['collected_by'] ?></option>
<?php endwhile; ?>
</select>
</div>
</div>
<button class="btn btn-primary" id="show_report">Show Report</button>
</div>
</div>
</div>
<div class="card mt-4">
<div class="card-header">
<h3 class="card-title">Expense Report</h3>
</div>
<div class="card-body">
<table class="table table-bordered table-striped" id="report_table">
<thead>
<tr>
<th>#</th>
<th>Date</th>
<th>Expense Category</th>
<th>Item Description</th>
<th>Amount</th>
<th>Staff Name</th>
</tr>
</thead>
<tbody>
<!-- Report data will be loaded here via AJAX -->
</tbody>
<tfoot>
<tr>
<th colspan="4" class="text-right">Total:</th>
<th class="text-right" id="total_amount">₱0.00</th>
<th></th>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
<script>
$(document).ready(function() {
$('#show_report').click(function() {
var year = $('#year').val();
var month = $('#month').val();
var day = $('#day').val();
var category = $('#category').val();
var collected_by = $('#collected_by').val();
$.ajax({
url: "https://fastlinkinternet.com/administrator/data-provider/admin/expense/ajax_handler.php",
method: "POST",
data: {
year: year,
month: month,
day: day,
category: category,
collected_by: collected_by
},
dataType: "json",
success: function(response) {
$('#report_table tbody').html(response.rows);
$('#total_amount').text('₱' + response.total_amount);
}
});
});
});
</script>
</body>
</html>