<?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");
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
	$dovalue="";
	$doid=$_REQUEST['did'];
	mysqli_query($con,"delete from feeheadmaster where id='$doid'");
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=feeheadmaster.php">';
	exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
	  $dovalue="PartyTranctions";
	  $doid=$_REQUEST['upid'];
	  $upuserresult=mysqli_query($con,"select * from feeheadmaster where id='".$_REQUEST['upid']."'");
	  $upuserarr=mysqli_fetch_array($upuserresult);
}else{
 	  $dovalue="PartyTranctions";
	  $doid='';  
}
?>
<style>
table, th, td {
    border: 1px solid black;
    border-collapse: collapse;
} 
th, td {
    padding: 15px;
}
#printarea{  
  width: 27cm;
  height: 35.7cm; 
}
</style>
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <section class="content-header">
    <h1> Party Payment Report <small></small> </h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Party Payment Report</a></li>
    </ol>
  </section>
  <!-- Main content -->
  
  <!-- /.content -->
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
        <div class="box">
          <div class="box-header">
            <h3 class="box-title">Party Payment Report</h3>
          </div>
          <!-- /.box-header -->
          <div class="box-body">
      <!-- <select name="course"  class="form-control " id='course' style='width:200px;'>
                      <option value=''>-select Course-</option> 
                      <?php /* $CasteQuery=mysqli_query($con,"select * from course"); 
	  				  while($CasteRow=mysqli_fetch_array($CasteQuery)){  
                      echo '<option value="'.$CasteRow['id'].'" '.($upuserarr['course'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' '.($upuserarr['course'] == $CasteRow['id'] ? 'readonly="true"' : '' ).' >'.$CasteRow['c_name'].'</option>';
					   }  */ ?>                  
                  </select>   -->  
				  <div class='col-md-12 pull-right' style='margin-bottom:14px;'>
			<input 
    type="text" 
    id="min-date"
    class="date-range-filter form-control col-md-3  pull-right"
    placeholder="From: yyyy-mm-dd"  style='width:200px;'>

<input 
    type="text" 
    id="max-date" 
    class="date-range-filter form-control col-md-3  pull-right"
    placeholder="To: yyyy-mm-dd"  style='width:200px;'>
	</div>
            <table id="example1" class="table table-bordered table-striped">
              <thead>
              <tr>                   
                   
               	<th scope="col">Sr No</th>
					<th scope="col">Transaction ID</th>
                  <th scope="col">Transaction Amount </th>
					  <th scope="col">Payment Mode</th>
					   <th scope="col">Course</th>
					    <th scope="col">Created Date</th>
					    <th scope="col">Party Name</th>
					    <th scope="col">Account Category </th>
					   <th scope="col">Entry User</th>
					  
						 
                    
                  </tr>                
              </thead>
              <tbody>
			  
                <?php


				$Query=mysqli_query($con,"select *,party_payamount.created_at as creat,party_payamount.id as id  from party_payamount 
				left JOIN admin as
			                admin ON party_payamount.user_id=admin.id
			                left JOIN PartyTranctions as
			                PartyTranctions ON party_payamount.transaction_id=PartyTranctions.Transaction_id
			              left JOIN party_entry as  party_entry ON PartyTranctions.Party_id=party_entry.id
			                
			                  left JOIN partycategory as  partycategory ON party_entry.partyentry=partycategory.id
			                	left JOIN course as
			                course ON party_payamount.course=course.id
			
			 ");
		$i = 1; 
			while( $Row=mysqli_fetch_array($Query)){
			
			  		 ?>
					<tr>
			
                  
                  <td><?=$i;?></td>
				   <td><?=$Row['transaction_id'];?></td>
				   <td><?=$Row['transactionamount'];?></td>
				  <td><?=$Row['Payment_Mode'];?></td> 
                  <td><?=$Row['c_name'];?></td>
                   <td><?=$Row['creat'];?></td>
                    <td><?=$Row['partyname'];?></td>
                    <td><?=$Row['party_name'];?></td>
					  <td><?=$Row['username'];?></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 src="dist/js/moment.js"  type="text/javascript"></script> 


<script  type="text/javascript">
$(document).ready(function() {
  var table=  $('#example1').DataTable( {
      
        
        
    } );
 $.fn.dataTable.ext.search.push(
    function( settings, data, dataIndex ) {
        var min  = $('#min-date').val();
        var max  = $('#max-date').val(); 
       
        var createdAt = data[5] || 0; // Our date column in the table
       //console.log(createdAt);
        if  ( 
                ( min == "" || max == "" ) 
                || 
                ( moment(createdAt).isSameOrAfter(min) && moment(createdAt).isSameOrBefore(max) ) 
            )
        {
            return true; 
        }
        return false;
    }
); 
$('.date-range-filter').change( function() {
    table.draw();
} );
    
  
    
} );

</script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/PrintArea/2.4.1/jquery.PrintArea.min.js'></script> 
<script>
$(document).ready(function() {
   $("#btn").click(function(){
        var mode = 'iframe'; //popup
        var close = mode == "popup";
        var options = { mode : mode, popClose : close};
        $("#printarea").printArea( options );
    });
   
});
</script>