/home3/vehiclea/public_html/admin-appleiitfoundationschools-com/dateCheckingCredit.php
<?php
include('include/header.php');
$select_credit_data = select_credit_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 active">Date Checking in Credit Report</li>
</ol>
</nav>
</div><!-- End Page Title -->
<?php
if(!empty($_GET['upd'])){
?>
<div align="center"><h4 style="color:green;">Update Date Successfully </h4></div>
<?php
}
?>
<?php
if(!empty($_GET['del'])){
?>
<div align="center"><h4 style="color:green;"> Date Delete 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">DATE CHECKING DEBIT 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>
<table class="table datatable" id="getting_data" style="width: auto;">
<thead>
<tr>
<th scope="col" style="display: none;">Id</th>
<th scope="col">Academic Year</th>
<th scope="col">Voucher No</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 Academic Year">
</th>
<th rowspan="1" colspan="1">
<input type="text" placeholder="Search Voucher No">
</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
// $dateCheck = mysqli_query($conn,"SELECT * from daybook_cre_deb where type = 'Credit'");
while($dateCheckData = mysqli_fetch_array($select_credit_data))
{
$years = $dateCheckData['academicYear'];
$yearData = explode("-", $years);
$strYear = $yearData[0];
$endYear = '20'.$yearData[1];
$date = $dateCheckData['date'];
$dateData = explode("-", $date);
if($dateData[0] < $yearData[0] || $dateData[0] > $endYear)
{
?>
<tr>
<td style="display: none"><?php echo $dateCheckData['id']; ?></td>
<td><?php echo $dateCheckData['academicYear']; ?></td>
<td><?php echo $dateCheckData['VocherNumber']; ?></td>
<td><?php echo date("d-M-Y", strtotime($dateCheckData['date'])); ?></td>
<td><?php echo $dateCheckData['branch_name']; ?></td>
<td><?php echo $dateCheckData['category_name']; ?></td>
<td><?php if($dateCheckData['reason'] == ''){ ?> Empty <?php } else { echo $dateCheckData['reason']; } ?></td>
<td><?php echo $dateCheckData['amount']; ?></td>
<td><?php echo $dateCheckData['workingUser']; ?></td>
<?php if($_SESSION['user'] == 'admin') { ?>
<td>
<a href="day_book_debitEdit.php?edit=<?php echo $dateCheckData['id']?>" class="btn btn-success">Edit</a>
<a href="javascript:void();" onclick="confirmDelete(<?php echo $dateCheckData['id']?>)" class="btn btn-danger">Delete</a>
</td>
<?php } } ?>
</tr>
<?php } ?>
</tbody>
</table>
</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',
exportOptions: {
columns: ':visible'
}
},
{
extend: 'pdfHtml5',
exportOptions: {
columns: ':visible'
}
},
],
"columnDefs": [
{ "width": "20%", "targets": 0 }
],
"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(7, { 'search': 'applied' })
.data()
.reduce(function (a, b) {
return intVal(a) + intVal(b);
}, 0);
CountofAmountcurrent = api
.column(7, { 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({
dateFormat: "dd-M-yy",
type: 'datetime',
onSelect: function() {
table.draw();
},
changeMonth: true,
changeYear: true
});
$("#max").datepicker({
dateFormat: "dd-M-yy",
type: 'datetime',
onSelect: function() {
table.draw();
},
changeMonth: true,
changeYear: true
});
var table = $('#getting_data').DataTable();
$('#min, #max').change(function() {
table.draw();
});
});
</script>
<script>
function confirmDelete(creditid)
{
if (creditid != '') {
var x = confirm('Are you sure to Delete?');
if(x){
$.ajax({
url : "delete.php",
data : {creditid : creditid},
type : 'POST',
success : function(response) {
if(response ==1){
window.location.href = "day_book_debit_report.php";
}
}
});
}
}
}
</script>
<?php include('include/footer.php'); ?>
@LwBee Strong Bypass
Upload File
Create New File