/home3/vehiclea/public_html/admin-appleiitfoundationschools-com/doubleEntriesCredit.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">Daybook Credit Report</li>
</ol>
</nav>
</div>
<?php
if(!empty($_GET['upd'])){
?>
<div align="center"><h4 style="color:green;">Updated Data Successfully </h4></div>
<?php
}
?>
<?php
if(!empty($_GET['del'])){
?>
<div align="center"><h4 style="color:red;"> Data 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">DAYBOOK CREDIT 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" id="dataPrint">
<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">
<thead>
<tr role="row">
<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
// $doubleEntryCountData = mysqli_query($conn,"SELECT * from daybook_cre_deb where type = 'Credit'");
while($selectCredit = mysqli_fetch_array($select_credit_data))
{
$adcYear = $selectCredit['academicYear'];
$vocherNum = $selectCredit['VocherNumber'];
$ty = $selectCredit['type'];
$res = $selectCredit['reason'];
$cName = $selectCredit['category_name'];
$amt = $selectCredit['amount'];
$date = $selectCredit['date'];
$daybookCredit = "SELECT COUNT(*) FROM daybook_cre_deb where academicYear = '$adcYear' and VocherNumber = '$vocherNum' and reason = '$res' and date = '$date' and category_name = '$cName' and amount = '$amt'";
$daybookCreditData = mysqli_query($conn,$daybookCredit);
$countDaybookCreditData = mysqli_fetch_array($daybookCreditData)[0];
if ($countDaybookCreditData > 1) {
?>
<tr>
<td style="display: none"><?php echo $selectCredit['id']; ?></td>
<td><?php echo $selectCredit['academicYear']; ?></td>
<td><?php echo $selectCredit['VocherNumber']; ?></td>
<td><?php echo date("d-M-Y", strtotime($selectCredit['date'])); ?></td>
<td><?php echo $selectCredit['branch_name']; ?></td>
<td><?php echo $selectCredit['category_name']; ?></td>
<td><?php if($selectCredit['reason'] == ''){ ?> Empty <?php } else { echo $selectCredit['reason']; } ?></td>
<td><?php echo $selectCredit['amount']; ?></td>
<td><?php echo $selectCredit['workingUser']; ?></td>
<?php if($_SESSION['user'] == 'admin') { ?>
<td><a href="day_book_creditEdit.php?edit=<?php echo $selectCredit['id']?>" class="btn btn-success">Edit</a>
<a href="javascript:void();" onclick="confirmDelete(<?php echo $selectCredit['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'
}
},
],
"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_credit_report.php";
}
}
});
}
}
}
</script>
<?php include('include/footer.php'); ?>
@LwBee Strong Bypass
Upload File
Create New File