<?php session_start();
include("connection.php");
error_reporting(E_ERROR | E_PARSE); 
if($_SESSION["user_id"]==true) {
} else {?><script> window.location.href='login/'; </script> <?php } 


 $bill_no=$_REQUEST["bill_no"];


 $bill=mysqli_query($con,"select * from onshop where `bill_no`='".$bill_no."' and `status`='active' and `bill_status`='pending' "); $billr=mysqli_fetch_array($bill,MYSQLI_ASSOC);
  $billn=mysqli_num_rows($bill);

?>

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<!-- /Added by HTTrack --><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<!--
<link type="text/css" rel="stylesheet" href="javax.faces.resource/themeab55.css?ln=primefaces-aristo" />
<link type="text/css" rel="stylesheet" href="javax.faces.resource/dist-butterfaces-bootstrap.min4e5d.css?ln=butterfaces-dist-css" />
-->
<link type="text/css" rel="stylesheet" href="javax.faces.resource/css/default.css" />
<link type="text/css" rel="stylesheet" href="javax.faces.resource/css/cssLayout.css" />
<link type="text/css" rel="stylesheet" href="javax.faces.resource/css/bootstrap.css" />
<link type="text/css" rel="stylesheet" href="javax.faces.resource/css/bootstrap.min.css" />
<link type="text/css" rel="stylesheet" href="javax.faces.resource/css/popup.css" />
<link type="text/css" rel="stylesheet" href="javax.faces.resource/css/menu.css" />
 <script src="https://kit.fontawesome.com/c92d43498a.js" crossorigin="anonymous"></script>
<!--
<script type="text/javascript" src="javax.faces.resource/butterfaces-all-with-jquery-and-bootstrap-bundle.min686a.js?ln=butterfaces-dist-bundle-js"></script>
<script type="text/javascript" src="javax.faces.resource/js/jquery-3.4.0.min.js"></script>
<script type="text/javascript" src="javax.faces.resource/js/bootstrap.js"></script>
<script type="text/javascript" src="javax.faces.resource/js/jquery-1.11.2.js"></script>
<script type="text/javascript" src="javax.faces.resource/js/jssor.slider-27.5.0.min.js"></script>
<script type="text/javascript" src="javax.faces.resource/jquery8490.js?ln=js"></script>
<script type="text/javascript" src="javax.faces.resource/menu8490.js?ln=js"></script>
<script type="text/javascript" src="javax.faces.resource/js/canvasjs.min.js"></script>
        
  --> 
  <link href='https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css' rel='stylesheet' type='text/css'>
<link href='https://cdn.datatables.net/buttons/1.5.6/css/buttons.dataTables.min.css' rel='stylesheet' type='text/css'>
        <script type="text/javascript">
            $(function() {
                $('ul.nav li.dropdown').hover(function() {
                    $(this).find('.dropdown-menu').stop(true, true).delay(100).fadeIn(500);
                }, function() {
                    $(this).find('.dropdown-menu').stop(true, true).delay(100).fadeOut(500);
                });
            });
        </script>
        <script type="text/javascript">
            $(function() {
                $("#notice").fadeIn("slow").append('');
                $(".dismis").click(function() {
                    $("#notice").fadeOut("slow");
                });
            });
        </script>
		
<script>
function lfn_SelectSection(p_Class)
    {
        document.getElementById('cusname').disabled=false;
		
  
        $.ajax({
		
                    type: "GET",
                    url: "ajax_location.html?classID=" + p_Class,
                    success: function(state) {
                    document.getElementById('cusname').innerHTML=state;    
					
                    }
        });
		
	 
		
		
    }

</script>
<style> 
        input.largerCheckbox { 
            width: 20px; 
            height: 20px; 
			
        } 
    </style> 
        <title>The Star Salon</title></head><body>

        <div id="top">


                    <div class="container-fluid text-center" style="margin-left: 5px"> 
                        <div class="row">
                            <div class="col-sm-1">
							<!-- Logo -->
							
							
                            </div>                           
                                       
                           
                        </div>
                    </div>

                    <!-- Menu start  -->

                    <nav class="navbar navbar-expand-lg header-m" role="navigation">
                        <div class="container-fluid">
                            <div class="navbar-header">
                                <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
                                    <span class="sr-only">Toggle navigation</span>
                                    <span class="icon-bar" style="background-color: #fff;"></span>
                                    <span class="icon-bar" style="background-color: #fff;"></span>
                                    <span class="icon-bar" style="background-color: #fff;"></span>
                                </button>
                                <a class="navbar-brand" href="#"></a>
                            </div>

                            <!-- Collect the nav links, forms, and other content for toggling -->
                            <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
                                <?php include("include/header.php"); ?>
                            </div>

                            <!-- /.navbar-collapse -->
                        </div>
                        <!-- /.container-fluid -->
                    </nav>

        </div>

        <div id="content" class="center_content" style="background-image:url(wall.jpg)">

                    <div class="container-fluid text-center">    
                        <div class="row">
                            <div class="col-sm-2" style="padding-right: 0px;">
							
							
							
							
							
                                <?php include("include/left.php"); ?>

                                </div>

                            </div>

                            <div class="col-sm-8" style="padding-right: 2px; padding-left:2px;">

                                <div class="row" >
                                    <div class="col-sm-12" >

                                        <div class="panel panel-primary" style="background-color: rgb(186,233,254);border: 1px solid #000; margin-bottom: 0px; background-image:url(wall.jpg)  ">
                                            <div class="panel-heading" style="font-size: 20px; font-family: serif; background-color: #007de8; color:#CCFF00"> <b>Selling Report</b></div>
                                            <div class="panel-body" style="text-align: justify;padding-bottom: 0px; padding-top: 6px;"><p style="font-family: Cambria;"><strong>
					 
					 
<form method="post">
   <!-- Type : 
        <select name="report_type" id="report_type" style="width:130px; height:25px; background-color:#99FF66" onChange="show_p();">
 <option value="0" <?php if($_REQUEST["id"]=="0") { ?> selected="selected" <?php } else {} ?>>Select Category</option>
<!-- <option value="1"  <?php if($_REQUEST["id"]=="1") { ?> selected="selected" <?php } else {} ?>  ><font color="#0000FF">All Category</font></option> 
<?php $c=mysqli_query($con,"select * from category"); while($cr=mysqli_fetch_array($c,MYSQLI_ASSOC)) {  $ct=$cr["cat_name"]; ?>
<option  <?php if($_REQUEST["id"]==$ct) { ?> selected="selected" <?php } else {} ?> value="<?php echo $cr["cat_name"]; ?>"><?php echo $cr["cat_name"]; ?></option>

<?php } ?>
</select>-->
<b><font color="red">From Date : </font></b>
<input type="date" data-date="" data-date-format="DD MMMM YYYY" name="fd" id="cat1" style="width:15%; height:26px; background-color:#99FF66" value="<?php echo $_REQUEST['fd']; ?>">&nbsp;&nbsp;&nbsp;
To : &nbsp;&nbsp;&nbsp;<input type="date" name="td" id="cat2" style="width:15%; height:26px; background-color:#99FF66" onChange="show_p()" value="<?php echo $_REQUEST['td']; ?>"> 
&nbsp;&nbsp;&nbsp;<?php if($_REQUEST["cat"]=="itemwise") { ?> <a href="?report_type=<?php echo $_REQUEST['report_type']; ?>&fd=<?php echo $_REQUEST["fd"]; ?>&td=<?php echo $_REQUEST["td"]; ?>&cat="><img src="http://dolphinrcb.in/javax.faces.resource/appln-statuse0f8.png?ln=img" width="30" > <font color="blue">Detail Selling Report</font></a>  <?php } 
else { ?><!--<a href="?report_type=<?php echo $_REQUEST['report_type']; ?>&fd=<?php echo $_REQUEST["fd"]; ?>&td=<?php echo $_REQUEST["td"]; ?>&cat=itemwise"><img src="http://dolphinrcb.in/javax.faces.resource/appln-statuse0f8.png?ln=img" width="30" > <font color="blue">Show by Itemwise Selling</font></a>--> <?php } ?>
</form>
<p>&nbsp;</p>
<script>
function show_p() {
 var v=document.getElementById("cat1").value;
 var vv=document.getElementById("cat2").value;
 var vvv=document.getElementById("report_type").value;
 window.location.href="?fd="+v+"&td="+vv+"&report_type="+vvv;
}
</script>	
Selling Report  As on <?php echo $_REQUEST["fd"] ?> To <?php echo $_REQUEST["td"] ?>	 <br> 
<?php 
$total=0;
$total2=0;
	 $from_date=$_REQUEST["fd"];
	 $to_date=$_REQUEST["td"];
	 
$i=1; 
/*if($_REQUEST["report_type"]=="others") {
$c=mysqli_query($con,"select *, SUM(total) AS prices from onshop where `product_type`='Others' and  `bill_date` BETWEEN '".$from_date."' AND '".$to_date."' and `shop_type`='onshop' GROUP BY `bill_no` "); 
} else {}*/

 $report_type=$_REQUEST["report_type"];
 $report_cat=$_REQUEST["cat"];
if($report_type=="0" && $report_cat=="" ) {
 $c=mysqli_query($con,"select *, SUM(total) as prices from onshop where  `bill_date` BETWEEN '".$from_date."' AND '".$to_date."' and `shop_type`='onshop' and `bill_status`='complete' GROUP BY `bill_no` "); 
 
} else {}

if($report_type =="0" && $report_cat=="itemwise" ) {
  $c=mysqli_query($con,"select * from onshop where `shop_type`='onshop' and `bill_status`='complete' and `bill_date` BETWEEN '".$from_date."' AND '".$to_date."'    ");
 
} else {}

if($report_type !="0" && $report_cat=="" ) {
 $c=mysqli_query($con,"select *, SUM(total) as prices from onshop where  `bill_date` BETWEEN '".$from_date."' AND '".$to_date."' and `shop_type`='onshop' and `bill_status`='complete' and `product_type`='".$report_type."' GROUP BY `bill_no` "); 
} else {}

if($report_type !="0" && $report_cat=="itemwise" ) {
  $c=mysqli_query($con,"select * from onshop where  `bill_date` BETWEEN '".$from_date."' AND '".$to_date."' and `shop_type`='onshop' and `bill_status`='complete' and `product_type`='".$report_type."'  ");
} else {}

if($_REQUEST["td"]!="" ) {

?>




 <table class="table table-bordered table-hover" id="example">
      <thead>
<tr style="height:30px; background-color:#0066FF; color:#FFFFFF;">
<th align="center"><b>Sl No.</b></th>
<th align="center"><b>Bill No.</b></th>
<th align="center"><b>Bill Date </b></th>

<th align="center"><b>Customer Name </b></td>
<th align="center"><b><?php if($_REQUEST["cat"]=="itemwise") { ?> Quantity <?php } else { ?> Bill Amount. <?php } ?> </b></th>

<th align="center"><b><?php if($_REQUEST["cat"]=="itemwise") { ?> Sell. Rs. <?php } else { ?> Discount <?php } ?> </b></th>

<th align="center"><b>Net Amount</b></th>
</tr>
 </thead>
  <tbody>
<?php
 while($cr=mysqli_fetch_array($c,MYSQLI_ASSOC)) { ?><?php // $cat= $cr["bill_no"]; $cp=mysqli_query($con,"select * from onshop where `bill_no`='".$cat."' GROUP BY `bill_no` ");
 
 // while($cpr=mysqli_fetch_array($cp,MYSQLI_ASSOC)) {
   //   $sr=mysqli_query($con,"select SUM(payable) AS prices from onshop where `bill_no`='".$cat."'  ");
   //   $ssr=mysqli_fetch_array($sr,MYSQLI_ASSOC);
?>
<tr <?php if($i%2 =="0") { ?> style="background-color:#FFE9D2" <?php } else { ?> style="background-color:#A4FFA4" <?php } ?> height="20" >

<td align="center"><?php echo $i; ?></td>
<td align="center"> <?php echo $cpn= $cr["bill_no"]; ?> </td>

<td align="center"><?php $temp_date=date_create($cr["bill_date"]); echo date_format($temp_date,"d/m/y"); ?></td> 
<td align="center"><?php echo $cr["cus_name"]; ?></td>
<td align="center"><?php if($_REQUEST["cat"]=="itemwise") { echo $qt=$cr["qnty"]; } else {  echo $cr["prices"]; } ?></td>

<td align="center"><?php if($_REQUEST["cat"]=="itemwise") { echo $cr["price"]; } else {    if($_REQUEST["report_type"]!="0") { } else { echo $cr["prices"]-$cr["payable"]; } } ?>
</td>
<td>&nbsp; <?php if($_REQUEST["cat"]=="itemwise") { echo $cr["price"]*$cr["qnty"]; $total=($cr["price"]*$cr["qnty"])+$total; } else {  echo $cr["payable"]; $total=$total+$cr["payable"]; } ?> /-
</td></tr>

<?php $i++; }
// } ?>
</tbody>
<tr>
<td colspan="6" align="right" style="height:30px;">Total Rs. :&nbsp;&nbsp; </td><td>&nbsp;<?php echo $a=$total; ?> /-</td>
</tr>

</table> 






Due amount Payment Received :
<table style="width:100%;" border="1"	>
<tr style="height:30px; background-color:#0066FF; color:#FFFFFF;">
<td align="center"><b>Sl No.</b></td>

<td align="center"><b>Bill No. / Name</b></td>
<td align="center"><b>Bill Date</b></td>
<td align="center"><b>Paid Amount</b></td>

</tr>
<?php $i=1; $t_receive=0; 
 $from_date=$_REQUEST["fd"];
	 $to_date=$_REQUEST["td"];
$cs=mysqli_query($con,"select * from due_receive where `date` BETWEEN '".$from_date."' AND '".$to_date."'"); while($cr=mysqli_fetch_array($cs,MYSQLI_ASSOC)) { ?>
<tr <?php if($i%2 =="0") { ?> style="background-color:#FFE9D2" <?php } else { ?> style="background-color:#FFFFCC" <?php } ?> height="20">
<?php $bill_no=$cr["bill_no"]; ?>
<td align="center"><?php echo $i; ?></td>
<td >&nbsp;<?php echo  $cr["bill_no"]; ?></td>
<td >&nbsp;<?php $temp_date=date_create($cr["bill_date"]); echo date_format($temp_date,"d-m-Y"); ?></td> 
<td >&nbsp;<?php echo $cr["amount"]; $t_receive=$t_receive+$cr["amount"]; ?> /-</td></tr>
<?php $i++; } ?>
<?php  $rk=mysqli_query($con,"select * from manual_due_pay where `date` BETWEEN '".$from_date."' AND '".$to_date."' "); 
while($rkr=mysqli_fetch_array($rk,MYSQLI_ASSOC)) { ?>
<tr <?php if($i%2 =="0") { ?> style="background-color:#FFE9D2" <?php } else { ?> style="background-color:#FFFFCC" <?php } ?> height="20">

<td align="center"><?php echo $i; ?></td>
<td >&nbsp;<?php $dci=$rkr["cus_id"];
$md=mysqli_query($con,"select * from manual_due where `id`='".$dci."'"); $mdr=mysqli_fetch_array($md,MYSQLI_ASSOC); echo $mdr["name"];?></td>
<td >&nbsp;<?php $temp_date=date_create($rkr["date"]); echo date_format($temp_date,"d-m-Y"); ?></td> 
<td >&nbsp;<?php echo $rkr["amount"]; $t_receive2=$t_receive2+$rkr["amount"]; ?> /-</td></tr>

<?php $i++; } ?>
</table>
Total Receive : <?php echo $c=$t_receive+$t_receive2; ?> /-
<br><br>    

Due bill amount :
<table style="width:100%;" border="1"	>
<tr style="height:30px; background-color:#0066FF; color:#FFFFFF;">
<td align="center"><b>Sl No.</b></td>
<td align="center"><b>Customer Name</b></td>
<td align="center"><b>Phone No.</b></td>
<td align="center"><b>Bill No.</b></td>
<td align="center"><b>Bill Date</b></td>
<td align="center"><b>Bill Amount</b></td>
<td align="center"><b>Due Amount</b></td>


</tr>
<?php $i=1; $t_due=0; $cp=mysqli_query($con,"select * from onshop where due!='' and `bill_date` BETWEEN '".$from_date."' AND '".$to_date."'  GROUP BY `bill_no`"); while($cr=mysqli_fetch_array($cp,MYSQLI_ASSOC)) { ?>
<tr <?php if($i%2 =="0") { ?> style="background-color:#FFE9D2" <?php } else { ?> style="background-color:#FFFFCC" <?php } ?> height="20">
<?php $bill_no=$cr["bill_no"]; ?>
<td align="center"><?php echo $i; ?></td>
<td >&nbsp;<?php echo $cn= $cr["cus_name"]; ?></td>
<td >&nbsp;<?php echo $cr["phone"]; ?></td> 
<td >&nbsp;<?php echo $cr["bill_no"]; ?></td>
<td >&nbsp;<?php //echo $cr["bill_date"]; 
$temp_date=date_create($cr["bill_date"]); echo date_format($temp_date,"d/m/y"); ?>

</td>
<td >&nbsp;<?php echo $cr["payable"]; ?> /-</td>
<?php 
$intotal=$cr['due']; ?>
<td align="center"><font color="red"><b><?php echo $intotal; $t_due=$t_due+$intotal; ?> /-</b></font></td>
</tr>
<?php $i++; } ?>

</table>














			
<b>Total Due Amount : <?php echo $d=$t_due; ?> /-</b>
<hr>
<?php $cabin=0; $dis=0; $cb=mysqli_query($con,"select cabin_charge, payable, SUM(total) as t from onshop where `paid_status`='paid' and `bill_date` BETWEEN '".$from_date."' AND '".$to_date."'  GROUP BY `bill_no`"); while($cbr=mysqli_fetch_array($cb,MYSQLI_ASSOC)) { ?>
<?php  $cabin=$cabin+$cbr["cabin_charge"]; $dis=$dis+($cbr["payable"]-($cbr["t"]+$cbr["cabin_charge"])); } ?>

<?php $ex=mysqli_query($con,"select SUM(amount) as amounts from expense where `date` BETWEEN '".$from_date."' AND '".$to_date."' "); 
$exr=mysqli_fetch_array($ex,MYSQLI_ASSOC);
$f=$exr["amounts"];
?>
Others Expenses : <?php echo $f; ?> /-
<hr>
<!-- Total Sell : <?php echo $a+$b; ?> /- ( Onshop + Offshop Selling ) <br>-->
<?php /* parcel is $e, due amount pay rec. is $c, due bill amount is $d, expense $f   */ ?>
<font color="red">Total Counter Rs. : <?php echo $a+$b+$c+$e-$d-$f; ?> /- </font>( Onshop [ <?php echo $a; ?> ]+Parcel [ <?php echo $e; ?> ]+Due Rs. receive [ <?php echo $c; ?> ]-Due bill Rs. [ <?php echo $d; ?> ]-Total Expenses [ <?php echo $f; ?> ] )






<!-- Total Received Rs. <?php echo $a+$b; ?> /- -->
<p>&nbsp;</p>
<?php 
} else {} ?>


			

<?php   if(isset($_POST["save"]))
        {
		 $pt=$_POST["pt"];
		 $bill_no=$_REQUEST["bill_no"];
$b=mysqli_query($con,"select * from onshop where `bill_status`='pending' and `bill_no`='".$bill_no."'  "); $i=1; while($br=mysqli_fetch_array($b,MYSQLI_ASSOC)) {	
  $p_id=$br["product_id"];
  $p=mysqli_query($con,"select * from product where `id`='".$p_id."'" ); $pr=mysqli_fetch_array($p,MYSQLI_ASSOC);
		 $qnty=$br["qnty"];	
           $quantity=$pr["quantity"];
		if($br["peg_bottle"]=="peg") {  
					
					 $p=mysqli_query($con,"select * from product where `id`='".$p_id."'" ); $pr=mysqli_fetch_array($p,MYSQLI_ASSOC);
					  $total_peg=$pr["total_peg"];  //bottle
					  $current_peg=$pr["curent_peg"]; //bottle
					  
					  $remain=$total_peg - $current_peg; // peg to empty bottle 
					// $current_peg=$current_peg+ $qnty;
		 		if($qnty==$remain) {
		   			  $quantity=$quantity-1; // final quantity
					  $current_peg=0;  // final current peg
		 		} else { 
				     if($qnty > $remain) {  $qnty=$qnty-$remain;   $quantity=$quantity-1;  
					 $bc=intval($qnty/$total_peg);
					 $quantity=$quantity-$bc;
					 $remain2=$bc*$total_peg;
					 $remain2=$qnty-$remain2;
					 $current_peg=$remain2;
					 } else { $quantity;  $current_peg=$current_peg+1; }
				   /* $bc=intval($qnty/$total_peg);
				    $quantity=$quantity-$bc;
					 $remain2=$bc*$total_peg;
					 $remain2=$qnty-$remain2; //remain peg
					if($remain2>=$remain) { echo $quantity=$quantity-1;  echo $current_peg=$remain2-$remain;  } else {  }*/
				   
				}
				mysqli_query($con,"update product set `curent_peg`='".$current_peg."', `quantity`='".$quantity."' where `id`='".$p_id."' ");	
			
		
		} else { 
		$quantity=$pr["quantity"];
		 $quantity=$quantity-$qnty;
	mysqli_query($con,"update product set `quantity`='".$quantity."' where `id`='".$p_id."' ");
		}
		
 		
 mysqli_query($con,"update onshop set `bill_status`='complete', `payable`='".$pt."' where `bill_no`='".$bill_no."' ");	



?><script>window.location.href="index.php";</script><?php 	
}		
		}?>				 
<p>&nbsp;</p>					 
				
					 
					 
					 
	<!--				 					
											 <select name="class" id="class" class="form-control" onChange="lfn_SelectSection(this.value);">
                                            <option value="">--- Please Select Class ----</option>
                                             <option value="A">A</option>
											 <option value="B">B</option>
											 <option value="C">C</option>
                                             </select>
											Section
											 <select type="text" name="secname" id="secname" class="form-control" >
                                        	<option value="0">------select Section_o------</option>

                                        </select> -->	
										
                                                    </strong></p></div>
                                        </div>



                                    </div>
                                </div>

                            <!--   <div class="well" style="padding: 5px;background-color: rgb(186,233,254); border: 1px solid #000; margin-bottom: 1px;">
                                    <div class="row">
                                        
                                        
                                       
                                        
                                        
                                        
                                    </div> 
                                </div>-->
                                <div class="row">
                                   <!-- <div class="col-sm-2">
                                        <div class="panel panel-primary" style="background-color: antiquewhite;">
                                            <div class="panel-body" style="border: 1px solid #000"><img src="javax.faces.resource/school-educatione0f8.png?ln=img" width="50" />  </div>
                                            <div class="panel-footer" style="padding: 1px 2px; background-color: #007de8; font-size: 13px;"><a href="../e_Pension/AdminLogin.html"> School Education Department Users</a>  </div>
                                        </div>
                                    </div>
                                    <div class="col-sm-2">
                                        <div class="panel panel-primary" style="background-color: #7c5a5e;">
                                            <div class="panel-body" style="border: 1px solid #000"><img src="javax.faces.resource/villagee0f8.png?ln=img" width="50" /></div>
                                            <div class="panel-footer" style="padding: 1px 2px;background-color: #007de8; font-size: 13px;"><a href="../e_Pension/AdminLogin.html">P &amp; R D Department Users</a>  </div>
                                        </div>
                                    </div>
                                    <div class="col-sm-2">
                                        <div class="panel panel-primary" style="background-color: #f6f191;">
                                            <div class="panel-body" style="border: 1px solid #000"><img src="javax.faces.resource/librarye0f8.png?ln=img" width="50" /></div>
                                            <div class="panel-footer" style="padding: 1px 2px;background-color: #007de8; font-size: 13px;"><a href="../e_Pension/AdminLogin.html">UD &amp; MA Department Users</a>  </div>
                                        </div>
                                    </div>
                                    <div class="col-sm-2">
                                        <div class="panel panel-primary" style="background-color: #fff;">
                                            <div class="panel-body" style="border: 1px solid #000"><img src="javax.faces.resource/images6e0f8.png?ln=img" width="50" /></div>
                                            <div class="panel-footer" style="padding: 1px 2px;background-color: #007de8; font-size: 13px;"><a href="../e_Pension/AdminLogin.html"> MEE &amp; LS Department Users</a>  </div>
                                        </div>
                                    </div>
                                    <div class="col-sm-2">
                                        <div class="panel panel-primary" style="background-color: #ffdc6a;">
                                            <div class="panel-body" style="border: 1px solid #000"><img src="javax.faces.resource/treasurye0f8.png?ln=img" width="50" /></div>
                                            <div class="panel-footer" style="padding: 10px 5px;background-color: #007de8; font-size: 13px;"><a href="../e_Pension/AdminLogin.html">Treasury Users</a>  </div>
                                        </div>
                                    </div>
                                    <div class="col-sm-2">
                                        <div class="panel panel-primary" style="background-color: #5cfef2;">
                                            <div class="panel-body" style="border: 1px solid #000"><img src="javax.faces.resource/users-groupe0f8.png?ln=img" width="50" /></div>
                                            <div class="panel-footer" style="padding: 1px 2px;background-color: #007de8; font-size: 12px;"><a href="../e_Pension/AdminLogin.html">Other Departments Users</a>  </div>
                                        </div>
                                    </div>    -->
                                </div>
                            
                               

                            </div>
                            <div class="col-sm-2" style="padding-left:0px;">
                                <?php include("include/right.php"); ?>
                            </div>                     
                        </div>

                    </div>
</form>
        </div>


         <?php include("include/footer.php"); ?>
		

<script src="../assets/plugins/jQuery/jquery-1.12.4.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js" type="text/javascript"></script>
 <script src="https://cdn.datatables.net/buttons/1.5.6/js/dataTables.buttons.min.js" type="text/javascript"></script>
 <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.flash.min.js" type="text/javascript"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" type="text/javascript"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js" type="text/javascript"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js" type="text/javascript"></script>
 <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.html5.min.js" type="text/javascript"></script>
 <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.print.min.js" type="text/javascript"></script>


    <script >
        $(document).ready(function() {
    $('#example').DataTable( {
        dom: 'Bfrtip',
        buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
        ]
    } );
} );
 $(document).ready(function() {
    $('#example2').DataTable( {
        dom: 'Bfrtip',
        buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
        ]
    } );
} );
</script>		
		
		</body>



</html>