<?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' "); $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 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>
        
  -->     
        <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>Customer List</b></div>
                                            <div class="panel-body" style="text-align: justify;padding-bottom: 0px; padding-top: 6px;"><p style="font-family: Cambria;"><strong>
					 
<?php if($_REQUEST["id"]!="") { ?>
    
 <form method="POST" action="#">
    <font color="red"> Total Due : <?php echo $_REQUEST["amount"]; ?> /- </font><br>
Receive : Rs. <input type="text" style="width: 70px;" name="amount2"> &nbsp; <input type="submit" name="pays2" value="Receive" style="width: 80px;"> 
<a href="" ><img href="back.png" width="30"></a>
</form>
<br><br>
<h4>Payment history of this Customer (Register Khata)</h4>
<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>Return Amount</b></td><td align="center"><b>Date</b></td>
</tr>
<?php $i=1; $id=$_REQUEST["id"]; $c=mysqli_query($con,"select * from manual_due_pay where  `cus_id`='".$id."'"); while($cr=mysqli_fetch_array($c,MYSQLI_ASSOC)) { ?>
<tr <?php if($i%2 =="0") { ?> style="background-color:#FFE9D2" <?php } else { ?> style="background-color:#FFFFCC" <?php } ?> height="25">

<td align="center"><?php echo $i; ?></td>
<?php
$qx=mysqli_query($con,"select SUM(amount) AS price from manual_due_pay where `cus_id`='".$id."' ");	
$qxr=mysqli_fetch_array($qx,MYSQLI_ASSOC); 
$intotal=$qxr['price']; ?>
<td align="center"><?php echo $cr["amount"]; ?> /-</td>
<td align="center"><?php echo $cr["date"]; ?> </td>
</tr>
<?php $i++; } ?>
</table>
<?php
if(isset($_POST["pays2"]))
        {
$id=$_REQUEST["id"];
$date=date('Y-m-d');
$due=$_REQUEST["amount"];
$receive=$_POST["amount2"];
$c_due=$due - $receive;
if($c_due==0) { $c_due=""; } else {}
mysqli_query($con,"insert into manual_due_pay (`cus_id`,`amount`,`date`,`remain_due`) values ('".$id."','".$receive."','".$date."','".$c_due."')");
mysqli_query($con,"update manual_due set `amount`='".$c_due."' where `id`='".$id."'")
?><script>alert("Successfully Done");
window.location.href="pay.php?id=<?php echo $id; ?>&amount=<?php echo $c_due; ?>";</script><?php

}?>



   
<?php } else { ?>
<h4>Payment history of this Customer</h4>
Bill No. : <?php echo $billr["bill_no"]; ?><br>
Bill Date. : <?php  $bill_date=$billr["bill_date"]; $temp_date=date_create($billr["bill_date"]); echo date_format($temp_date,"d/m/y"); ?><br>
Cus. Name : <?php echo $billr["cus_name"]; ?><br>
Phone No. : <?php echo $billr["phone"]; ?><br>
<font color="red">Total Due : Rs. <?php echo $due=$billr["due"]; ?> /-</font><br>
<br>
<form method="POST" action="#">
Receive : Rs. <input type="text" style="width: 70px;" name="amount"> &nbsp; <input type="submit" name="pays" value="Receive">
</form>
<br><br>
<h4>Payment history of this Bill No.</h4>

<?php
if(isset($_POST["pays"]))
        {
$due= $billr["due"];
$date=date('Y-m-d');
$receive=$_POST["amount"];
$c_due=$due - $receive;
if($c_due==0) { $c_due=""; } else {}
mysqli_query($con,"insert into due_receive (`bill_no`,`bill_date`,`amount`,`date`) values ('".$bill_no."','".$bill_date."','".$receive."','".$date."')");
mysqli_query($con,"update onshop set `due`='".$c_due."' where `bill_no`='".$bill_no."'")
?><script>alert("Successfully Done");
window.location.href="pay.php?bill_no=<?php echo $bill_no; ?>";</script><?php

}?>







<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>Return Amount</b></td><td align="center"><b>Date</b></td>
</tr>
<?php $i=1; $c=mysqli_query($con,"select * from due_receive where  `bill_no`='".$bill_no."'"); while($cr=mysqli_fetch_array($c,MYSQLI_ASSOC)) { ?>
<tr <?php if($i%2 =="0") { ?> style="background-color:#FFE9D2" <?php } else { ?> style="background-color:#FFFFCC" <?php } ?> height="25">

<td align="center"><?php echo $i; ?></td>
<?php
$qx=mysqli_query($con,"select SUM(amount) AS price from due_receive where `bill_no`='".$bill_no."' ");	
$qxr=mysqli_fetch_array($qx,MYSQLI_ASSOC); 
$intotal=$qxr['price']; ?>
<td align="center"><?php echo $cr["amount"]; ?> /-</td>
<td align="center"><?php echo $cr["date"]; ?> </td>
</tr>
<?php $i++; } ?>
</table>
			
<?php } ?>
<?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"); ?>

                       

		
		
		</body>



</html>