<?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");
		   
		}
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
$dovalue="ExpenseTransaction";
$doid='';  
?>
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <section class="content-header">
    <h1> Expense Status Report <small></small> </h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Expense Status Report</a></li>
    </ol>
  </section>
  <!-- Main content -->
  <?php 
        if(!empty($_SESSION['msg'])){
		    $msg=$_SESSION["msg"];
            echo '<div class="col-md-12">
			<div class="alert alert-success alert-dismissible">
                <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
                '.$msg.'
		    </div>'; $_SESSION["msg"]='';} ?>
  <!-- /.content -->
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
        <div class="box">
          <div class="box-header">
            <h3 class="box-title">Manage Expense Payments</h3>
          </div>
          <!-- /.box-header -->
          <div class="box-body">
            <table id="example1" class="table table-bordered table-striped">
              <thead>
                <tr>                   
                    <th scope="col">Sr no</th>
                    <th scope="col">ID</th>
                    <th scope="col">Name</th>
                    <th scope="col">Bill</th>
					<th scope="col">Approve/Disapprove</th>
                    <th scope="col">Expense For</th>
			        <th scope="col">Amount</th>
                    <th scope="col">Paid Date</th>
                    <!--<th scope="col">Action</th>-->
                    
                    <!-- <th scope="col">Action</th>  -->
                </tr>                
              </thead>
              <tbody>
                <?php $Query=mysqli_query($con,"select party_entry.partyname as name,PartyTranctions.id,PartyTranctions.Transaction_id,PartyTranctions.approve,
                PartyTranctions.expense_for,PartyTranctions.Bill,PartyTranctions.Pay_Amount,PartyTranctions.created_at from PartyTranctions
                left join party_entry on party_entry.id=PartyTranctions.Party_id
                where PartyTranctions.approve=0
                UNION   select party_entry.partyname as name,party_payamount.id,party_payamount.transaction_id,party_payamount.approve,party_payamount.expense_for,null,
                        party_payamount.transactionamount,party_payamount.created_at from party_payamount
                        left join PartyTranctions on party_payamount.transaction_id=PartyTranctions.Transaction_id
                        left join party_entry on party_entry.id=PartyTranctions.Party_id
                        where party_payamount.approve=0
                UNION   select consultants.name,installment_consultants_payments.id,installment_consultants_payments.student_id,installment_consultants_payments.approve,
                        installment_consultants_payments.expense_for,null,installment_consultants_payments.submitamount,
                        installment_consultants_payments.created_at from installment_consultants_payments
                        left join consultants on installment_consultants_payments.consultants_id=consultants.id
                        where installment_consultants_payments.approve=0
                UNION   select employeeentryform.EmployeeName as name,employeesalarypayment.EmployeeSalaryPaymentID,employeesalarypayment.EmployeeSalaryPaymentID,employeesalarypayment.approve,
                        employeesalarypayment.expense_for,null,employeesalarypayment.paidsalary,
                        employeesalarypayment.created_at from employeesalarypayment
                        left join employeeentryform on employeeentryform.EmployeeEntryFormID=employeesalarypayment.EmployeeId
                        where employeesalarypayment.approve=0
                ");
			  		$i = 1; 
	  				  while($Row=mysqli_fetch_array($Query)){ ?>
                <tr>
			
                    <td><?php echo $i; ?></td>
                    <td><?=$Row['Transaction_id'];?></td> 
                    <td><?=$Row['name'];?></td>
                    <td><a href="images/StudentEnquiry/<?php echo $Row['Bill'];?>"><img src="images/StudentEnquiry/<?php echo $Row['Bill'];?>" height="70" width="70" /></a></td>
				    <td>
				        <?php if($Row['approve']=='0'){ ?>
				            <a href="./akshay_action.php?id=<?=$Row["id"]; ?>&do=ExpenseTransaction&expense_for=<?=$Row['expense_for'];?>"><i class="fa fa-thumbs-down text-red"></i>Pending</a>
				        <?php }else{ ?>
				            <i class="fa fa-thumbs-up text-blue"></i>Cleared!
				        <?php } ?>
				    </td>
				    <td style="text-transform: capitalize;"><?=$Row['expense_for'];?></td>
			        <td><?=$Row['Pay_Amount'];?></td> 
                    <td><?=$Row['created_at'];?></td>
				  
			   
                  <!--<td><a href="?did=<?php //echo $Row["id"]; ?>"><i class="fa fa-remove text-red"></i></a></td>-->
                </tr>
                <?php $i++;} ?>
              </tbody>
            </table>
          </div>
          <!-- /.box-body --> 
        </div>
        <!-- /.box --> 
      </div>
      <!-- /.col --> 
    </div>
    <!-- /.row --> 
  </section>
</div>
<?php include('include/footer.php');?>

<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="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"  type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.colVis.min.js"  type="text/javascript"></script>


<script  type="text/javascript">
$(document).ready(function() {
    $('#example1').DataTable( {
      
        
        
    } );
} );
	//$(function () {
	//$("#example1").DataTable();
	
	//});
</script>