/home3/vehiclea/public_html/admin-appleiitfoundationschools-com/billBookReports.php
<?php
session_start();
$_SESSION['active'] = 'billBookRep';
include('include/header.php');
$billBook_data = billBook_data();
?>
<main id="main" class="main">
<div class="pagetitle">
<h1>School Data</h1>
<nav>
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="index.php">Home</a></li>
<li class="breadcrumb-item">Reports</li>
<li class="breadcrumb-item ">Billbook Reports</li>
</ol>
</nav>
</div>
<?php
if(!empty($_GET['upd'])){
?>
<div align="center"><h4 style="color:green;">Updated Data Successfully </h4></div>
<?php
}
if(!empty($_GET['del'])){
?>
<div align="center"><h4 style="color:red;"> Data Deleted Successfully </h4></div>
<?php
}
?>
<section class="section">
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-body">
<h5 class="card-title">BILLBOOK REPORT</h5>
<div class="row">
<div class="col-md-4">
<label class="control-label"><b>From Date:</b></label>
<div class="form-group">
<input class="form-control" id="min" placeholder="DD-MM-YYYY" type="text"/>
</div>
</div>
<div class="col-md-4">
<label class="control-label"><b>To Date:</b></label>
<div class="form-group">
<input class="form-control" id="max" placeholder="DD-MM-YYYY" type="text"/>
</div>
</div>
<div class="col-sm-4">
<h4 style="font-size:16px;">
<b>Total Value :</b><b style="color:Red;"> <label id="Sum_TotalRecords"></label></b></h4>
</div>
</div><br>
<div class="row g-6">
<div class="col-lg-12">
<div class="card">
<div class="card-body">
<h5 class="card-title">BILLBOOK REPORT</h5>
<div class="table-responsive">
<table class="table datatable" id="getting_data">
<thead style="background-color:#7E57C2; color: #ffff;">
<tr>
<th scope="col" style="display: none;">Id</th>
<th scope="col">S.No</th>
<th scope="col">Bill No</th>
<th scope="col">Academic Year</th>
<th scope="col">Date</th>
<th scope="col">Branch Name</th>
<th scope="col">Category</th>
<th scope="col">Reason</th>
<th scope="col">Amount</th>
<th scope="col">Working User</th>
<?php if($_SESSION['user'] == 'admin') { ?>
<th scope="col">Action</th>
<?php } ?>
</tr>
</thead>
<tfoot id="tfoot1">
<tr>
<th style="display: none;" rowspan="1" colspan="1">
<input type="text" placeholder="Search ID">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Bill No">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Academic Year">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Date">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Branch Name">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Category">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Reason">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Amount">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Working User">
</th>
<?php if($_SESSION['user'] == 'admin') { ?>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Action">
</th>
<?php } ?>
</tr>
</tfoot>
<tbody>
<?php
$i=1;
while ($billBook_dataRec = mysqli_fetch_array($billBook_data))
{
?>
<tr>
<td style="display: none"><?php echo $billBook_dataRec['id']; ?></td>
<td><?php echo $i;?></td>
<td><?php echo $billBook_dataRec['billNo']; ?></td>
<td><?php echo $billBook_dataRec['academicYear']; ?></td>
<td><?php echo date('d-M-Y',strtotime($billBook_dataRec['date'])); ?></td>
<td><?php echo $billBook_dataRec['branch_name']; ?></td>
<td><?php echo $billBook_dataRec['category_name']; ?></td>
<td><?php if($billBook_dataRec['reason'] == ''){ ?> Empty <?php } else { echo $billBook_dataRec['reason']; } ?></td>
<td><?php echo $billBook_dataRec['amount']; ?></td>
<td><?php echo $billBook_dataRec['workingUser']; ?></td>
<?php if($_SESSION['user'] == 'admin') { ?>
<td>
<div class="dropdown">
<button class="btn btn-secondary dropdown-toggle" type="button" id="dropdownMenuButton1" data-bs-toggle="dropdown" aria-expanded="false" style="background-color:#69F0AE;">
Action
</button>
<ul class="dropdown-menu" aria-labelledby="dropdownMenuButton1">
<li><a class="dropdown-item text-center" target="_target" href="day_bill_pdf.php?print=<?php echo $billBook_dataRec['id']?>">PRINT</a></li>
<li><a class="dropdown-item text-center" href="BillbookEdit.php?edit=<?php echo $billBook_dataRec['id']?>">EDIT</a></li>
<li><a class="dropdown-item text-center" href="javascript:void();" onclick="confirmDelete(<?php echo $billBook_dataRec['id']?>)">DELETE</a></li>
</ul>
</div>
</td>
<?php } ?>
</tr>
<?php $i++; } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
</main>
<script>
$(document).ready(function() {
$('#getting_data tfoot th').each(function () {
var title = $('#getting_data thead th').eq($(this).index()).text();
$(this).html('<input type="text" placeholder="Search ' + title + '" />');
});
var table = $('#getting_data').DataTable({
dom: 'Bfrtip',
buttons: [
'colvis',
{
extend: 'excelHtml5',
title: 'Apple IIT Schools',
messageTop: function(){
return "Total Amount: " + $('#Sum_TotalRecords').text()
},
exportOptions: {
columns: [1,2,3,4,5,6,7,8]
}
},
{
extend: 'pdfHtml5',
title: 'Apple IIT Schools',
messageTop: function(){
return "Total Amount: " + $('#Sum_TotalRecords').text()
},
exportOptions: {
columns: [1,2,3,4,5,6,7,8]
}
},
],
"fnDrawCallback": function (oSettings) {
var api = this.api(), data;
var intVal = function (i) {
return typeof i === 'string' ?
i.replace(/[\$,]/g, '') * 1 :
typeof i === 'number' ?
i : 0;
};
CountofAmount = api
.column(8, { 'search': 'applied' })
.data()
.reduce(function (a, b) {
return intVal(a) + intVal(b);
}, 0);
CountofAmountcurrent = api
.column(8, { page: 'current' })
.data()
.reduce(function (a, b) {
return intVal(a) + intVal(b);
}, 0);
$('#Sum_TotalRecords').text('Rs.'+ CountofAmountcurrent + '(' +'Rs.'+ CountofAmount + ')');
}
});
$("#getting_data tfoot input").on('keyup change', function () {
table
.column($(this).parent().index() + ':visible')
.search(this.value)
.draw();
});
});
</script>
<script type="text/javascript">
$(document).ready(function() {
$.fn.dataTable.ext.search.push(
function(settings, data, dataIndex) {
var min = $('#min').datepicker("getDate");
var max = $('#max').datepicker("getDate");
var startDate = new Date(data[3]);
if (min == null && max == null) {
return true;
}
if (min == null && startDate <= max) {
return true;
}
if (max == null && startDate >= min) {
return true;
}
if (startDate <= max && startDate >= min) {
return true;
}
return false;
}
);
$("#min").datepicker({
onSelect: function() {
table.draw();
},
changeMonth: true,
changeYear: true
});
$("#max").datepicker({
onSelect: function() {
table.draw();
},
changeMonth: true,
changeYear: true
});
var table = $('#getting_data').DataTable();
$('#min, #max').change(function() {
table.draw();
});
});
</script>
<script>
function confirmDelete(Billid)
{
if (Billid != '') {
var x = confirm('Are you sure to Delete?');
if(x){
$.ajax({
url : "delete.php",
data : {Billid : Billid},
type : 'POST',
success : function(response) {
if(response ==1){
window.location.href = "billBookReports.php";
}
}
});
}
}
}
</script>
<?php include('include/footer.php'); ?>
@LwBee Strong Bypass
Upload File
Create New File