<?php 
           $id=array();
            $bankdetails=mysqli_query($con,'SELECT id FROM bankdetails');
            $bank_array = array();
            $PartyTranctions=array();
            $party_payamount=array();
            
            $total_payent_array = array();
              while($bankdetailsf=mysqli_fetch_array($bankdetails))
              {
                
                /****************************************************/ 
                 
                 $Query_booking=mysqli_query($con,"select sum(booking_amount) as booking_amount FROM student_enqury_form where DepositTo='".$bankdetailsf['id']."'");
                 $Query_bookingR=mysqli_fetch_array($Query_booking);
                 
                 $Query_ama=mysqli_query($con,'SELECT sum(submitfee) as submitfee FROM admission_enquiry_form WHERE bank="'.$bankdetailsf['id'].'" ');
                 $Query_ams=mysqli_fetch_array($Query_ama);
                 
                 
                 $paymiscfee=mysqli_query($con,'SELECT  sum(amount) as amount  FROM paymiscfee WHERE bank="'.$bankdetailsf['id'].'" ');
                 $paymiscfee=mysqli_fetch_array($paymiscfee);
              //   echo $bankdetailsf['id'].' '.$Query_ams['submitfee'].'<br>';
                 //array_push($bank_array,array('bank_name' => $bankdetailsf['id'],'amount' =>  $Query_ams['submitfee']));
                 
                   $payinstallment=mysqli_query($con,'SELECT  sum(payment_amount) as payment_amount FROM payinstallment WHERE bank="'.$bankdetailsf['id'].'" AND approve=1');
                 $payinstallment=mysqli_fetch_array($payinstallment);
                 
                 
                 $installment_consultants_payments=mysqli_query($con,'SELECT  sum(submitamount) as submitamount  FROM installment_consultants_payments WHERE bank="'.$bankdetailsf['id'].'" AND approve=1 AND paymentmode="Cash"');
                 $installment_consultants_payments=mysqli_fetch_array($installment_consultants_payments);
                /****************************************************/
                  $Query_amd=mysqli_query($con,'SELECT  sum(PartyTranctions.Pay_Amount) as Pay_Amount FROM PartyTranctions 
                  left join party_entry on party_entry.id=PartyTranctions.Party_id
                  WHERE PartyTranctions.bank="'.$bankdetailsf['id'].'" AND PartyTranctions.approve=1 AND PartyTranctions.Payment_Mode="ByCheque" AND party_entry.partytype="Expence"');
                 $Query_amw=mysqli_fetch_array($Query_amd);
                 
                 $Query_amd_income=mysqli_query($con,'SELECT  sum(PartyTranctions.Pay_Amount) as Pay_Amount FROM PartyTranctions 
                  left join party_entry on party_entry.id=PartyTranctions.Party_id
                  WHERE PartyTranctions.bank="'.$bankdetailsf['id'].'" AND PartyTranctions.approve=1 AND PartyTranctions.Payment_Mode="ByCheque" AND party_entry.partytype="Income"');
                 $Query_amw_income=mysqli_fetch_array($Query_amd_income);
                 
               //  echo $bankdetailsf['id'].' '.$Query_amw['Pay_Amount'].'<br>';
                 //array_push($PartyTranctions,array('bank_name' => $bankdetailsf['id'],'amount' =>  $Query_am['Pay_Amount']));
                /****************************************************/
                 $Query_amh=mysqli_query($con,'SELECT  sum(party_payamount.transactionamount) as transactionamount  FROM party_payamount
                 left join PartyTranctions on PartyTranctions.Transaction_id=party_payamount.transaction_id
                 left join party_entry on party_entry.id=PartyTranctions.Party_id
                 WHERE party_payamount.bank="'.$bankdetailsf['id'].'" AND party_payamount.approve=1 AND party_payamount.Payment_Mode="ByCheque" AND party_entry.partytype="Expence"');
                 $Query_am1=mysqli_fetch_array($Query_amh);
                 
                 $Query_amh_income=mysqli_query($con,'SELECT  sum(party_payamount.transactionamount) as transactionamount  FROM party_payamount
                 left join PartyTranctions on PartyTranctions.Transaction_id=party_payamount.transaction_id
                 left join party_entry on party_entry.id=PartyTranctions.Party_id
                 WHERE party_payamount.bank="'.$bankdetailsf['id'].'" AND party_payamount.approve=1 AND party_payamount.Payment_Mode="ByCheque" AND party_entry.partytype="Income"');
                 $Query_am1_income=mysqli_fetch_array($Query_amh_income);
                 
                   $employeesalarypayment=mysqli_query($con,'SELECT  sum(paidsalary) as paidsalary  FROM employeesalarypayment WHERE bank="'.$bankdetailsf['id'].'" AND approve=1 AND PaymentMode="ByCheque"');
                 $employeesalarypayment=mysqli_fetch_array($employeesalarypayment);
                
                 // echo $bankdetailsf['id'].' '.$Query_am1['transactionamount'].'<br>';
                 //array_push($party_payamount,array('bank_name' => $bankdetailsf['id'],'amount' =>  $Query_am['transactionamount']));
                 //echo $Query_am['transactionamount'];
                /****************************************************/
                array_push($total_payent_array,array('bank_id'=>$bankdetailsf['id'],'amount'=> ($Query_bookingR['booking_amount']+$Query_ams['submitfee'] +$paymiscfee['amount']+$payinstallment['payment_amount']+$Query_am1_income['transactionamount']+$Query_amw_income['Pay_Amount'])-($Query_amw['Pay_Amount'] +  $Query_am1['transactionamount']+$installment_consultants_payments['submitamount']+ $employeesalarypayment['paidsalary'])));
             
            
              }
              
             // echo $Query_ams['submitfee'] ;
             // print_r($total_payent_array);
             //exit;
            
           
             for($j=0; $j<count($total_payent_array); $j++)
             {
                 
             	mysqli_query($con,"update bankdetails set bank_amount='".$total_payent_array[$j]['amount']."' where id='".$total_payent_array[$j]['bank_id']."'"); 
             }
              $newsbankdetails=mysqli_query($con,'SELECT id FROM bankdetails');
            while($bankdetailsf=mysqli_fetch_array($newsbankdetails))
             {
              
             
              $CashToBankQ=mysqli_query($con,"select *,sum(transactionamount) as transactionamount from banktocash where  types='CashToBank' AND bank='".$bankdetailsf['id']."' ");
   
   // echo $numrows;
	    while($CashToBank=mysqli_fetch_array($CashToBankQ)){ 
	   
	        
	         $check=mysqli_query($con,"Update bankdetails set user_id='".$_SESSION["ecomid"]."',bank_amount=bank_amount+'".$CashToBank['transactionamount']."'
					  where id='".$CashToBank['bank']."'");
	        
	    }
             }
	 
         
             
           $transactionamount=mysqli_query($con,"select *,sum(transactionamount) as transactionamount from banktocash where  types='BankToCash' ");

	    while($Row=mysqli_fetch_array($transactionamount)){ 
	        
	         $check=mysqli_query($con,"Update bankdetails set user_id='".$_SESSION["ecomid"]."',bank_amount=bank_amount-'".$Row['transactionamount']."'
					  where id='".$Row['bank']."'");
	        
	    }
			 
            $bank_opening_balencef=mysqli_query($con,"select * from bank_opening_balence ");


      while($bank_opening_balence=mysqli_fetch_array($bank_opening_balencef)){
     
    
      
           $check=mysqli_query($con,"Update bankdetails set user_id='".$_SESSION["ecomid"]."',bank_amount=bank_amount+'".$bank_opening_balence['opening_balance']."'
					  where id='".$bank_opening_balence['bank_id']."'");
       
      }
	  
	    

	  
	  	$Query=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 
				 				
				UNION 
				 				 	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, 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 
				 				 	
				 				 	UNION  SELECT admission_enquiry_form.student_id as stuid, admission_enquiry_form.name as name, course.c_name as cname, null, feeheadmaster.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 Payment_Mode
				 				 	FROM admission_enquiry_form left JOIN feeheadmaster ON admission_enquiry_form.course=feeheadmaster.course_id 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 student_enqury_form.student_id as stuid, student_enqury_form.name as name, course.c_name as cname, null, feeheadmaster.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 Payment_Mode
				 				 	FROM student_enqury_form left JOIN feeheadmaster ON student_enqury_form.course_id=feeheadmaster.course_id 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.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 admission_enquiry_form.student_id as stuid, admission_enquiry_form.name as name, course.c_name as cname, null, feeheadmaster.incomeorexpence as incomeorexpence, paymiscfee.amount as feeamount, paymiscfee.created_at as creates ,admin.username as username 
				 				 	 ,
				 				 	 paymiscfee.payment_mode as Payment_Mode
				 				 	 FROM paymiscfee left JOIN admission_enquiry_form ON paymiscfee.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 paymiscfee.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
				 				 	 
				 				 	 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
				 				 	  
				 				 	");
			             
			 
			 $totalincomecash=0;
			  $totalexpencecash=0;
			 		  while($Row=mysqli_fetch_array($Query)){ 
        			 		  if(($Row['4']=='Income') && ($Row['8']=='Cash' || $Row['8']=='ByCash')){
        			 		      $totalincomecash +=$Row['Bill_Amount'];
        			 		        }
        			 		          if(($Row['4']=='Expence') && ($Row['8']=='Cash' || $Row['8']=='ByCash')){
        			 		      $totalexpencecash +=$Row['Bill_Amount'];
        			 		        }
			 		  }
			 		 
			 		 // echo 'Total Income Cash :'.$totalincomecash;
			 		  // echo 'Total Expence Cash :'.$totalexpencecash;
			 		   $totalcash=$totalincomecash-$totalexpencecash;
			 		        $transactionamount=mysqli_query($con,"select *,sum(transactionamount) as transactionamount from banktocash where  types='CashToBank' ");


	  $transactionamount=mysqli_fetch_array($transactionamount);
	  			 		        $BankToCash=mysqli_query($con,"select *,sum(transactionamount) as transactionamount from banktocash where  types='BankToCash' ");


	  $BankToCash=mysqli_fetch_array($BankToCash);
	 
	    $opening_balance_to_cash=mysqli_query($con,"select *,sum(cach_balance) as cach_balance from opening_balance_to_cash ");


	  $opening_balance_to_cash=mysqli_fetch_array($opening_balance_to_cash);
	        
	        $partytransactionminus=mysqli_fetch_array(mysqli_query($con,"select sum(Pay_Amount) as total from PartyTranctions where approve=0 AND Payment_Mode='ByCash'"))['total'];
	        $partypayamountminus=mysqli_fetch_array(mysqli_query($con,"select sum(transactionamount) as total  FROM party_payamount where approve=0 AND Payment_Mode='ByCash'"))['total'];
	        $consultantminus=mysqli_fetch_array(mysqli_query($con,"select sum(submitamount) as total  FROM installment_consultants_payments where approve=0 AND paymentmode='Cash'"))['total'];
	        $employeesalaryminus=mysqli_fetch_array(mysqli_query($con,"select sum(paidsalary) as total  FROM employeesalarypayment where approve=0 AND PaymentMode='ByCash'"))['total'];
	        
	        $library=mysqli_fetch_array(mysqli_query($con,"select sum(fine) as fine from return_book"))['fine'];
			 $totalcash=$library+$partytransactionminus+$partypayamountminus+$consultantminus+$employeesalaryminus+$opening_balance_to_cash['cach_balance']+$BankToCash['transactionamount']+$totalcash-$transactionamount['transactionamount'];
			 // echo  $totalcash;
			 $check=mysqli_query($con,"Update totalcash set user_id='".$_SESSION["ecomid"]."',cash='".$totalcash."'
					  where id='1'");
					  //echo $transactionamount['transactionamount'];
					  //echo $opening_balance_to_cash['cach_balance'];
					  $upuserresultgs=mysqli_query($con,"select * from totalcash where id='1'");

	  $upuserresultgsf=mysqli_fetch_array($upuserresultgs);
              
              ?>