<?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 PartyTranctions where id='$doid'");
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=PartyTranctionEntry.php">';
	exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
	  $dovalue="PartyTranctions";
	  $doid=$_REQUEST['upid'];
	  $upuserresult=mysqli_query($con,"select * from PartyTranctions where id='".$_REQUEST['upid']."'");
	  $upuserarr=mysqli_fetch_array($upuserresult);
}else{
 	  $dovalue="PartyTranctions";
	  $doid='';  
}
?>
<div class="content-wrapper">
  <!-- Content Header (Page header) -->

  <!-- /.content -->
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
        <div class="box">
          <div class="box-header">
            <h3 class="box-title">Party Tranctions Report</h3>
			   <div class="pull-right box-tools">
              <button class="btn btn-info btn-sm" data-widget="collapse" data-toggle="tooltip" title="Collapse"><i class="fa fa-minus"></i></button>
              <button class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip" title="Remove"><i class="fa fa-times"></i></button>
            </div>
           
          </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">Transaction Id</th>
                    <th scope="col">Transaction Type</th>
					<th scope="col">Party Name</th>
                    <th scope="col">Purchase</th>
					 <th scope="col">Quantity</th>
					  <th scope="col">Bill Amount</th>
					   <th scope="col">Pay Amount</th>
					    <th scope="col">Payment Mode</th>
						 <th scope="col">Bill</th>
						 
                     <th scope="col">Created At</th>
                  
                    <th scope="col">Action</th>
                  </tr>                
              </thead>
              <tbody>
                <?php $Query=mysqli_query($con,"select *,course.id as ids,PartyTranctions.id as id from PartyTranctions
				left JOIN party_entry as
			  course ON PartyTranctions.Party_id=course.id order by PartyTranctions.id desc limit 10 ");
			  		$i = 1;
	  				  while($Row=mysqli_fetch_array($Query)){ ?>
                <tr>
			
                  <td><?php echo $i; ?></td>
				     <td><?=$Row['Transaction_id'];?></td> 
                  <td><?=$Row['Transaction_type'];?></td> 
				  <td><?=$Row['partyname'];?></td> 
                  <td><?=$Row['Purchase'];?></td>
                    <td><?=$Row['Quantity'];?></td>
					  <td><?=$Row['Bill_Amount'];?></td>
					    <td><?=$Row['Pay_Amount'];?></td>
						 <td><?=$Row['Payment_Mode'];?></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><?=$Row['created_at'];?></td>
                
                  <td><a href="?upid=<?php echo $Row["id"]; ?>"><i class="fa fa-pencil text-yellow"></i></a>&nbsp;&nbsp; <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="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}}
        ],
		
    } );
} );
	//$(function () {
	//$("#example1").DataTable();
	
	//});
</script>