<?
REQUIRE_ONCE('functions.php');
$user=$_SESSION['user'];
REQUIRE_ONCE('mysql.php');

$ip=get_client_ip();
$tiller=teller($ip);

		
 if ( (isset($_GET['id'])) &&
 (($_GET['id'])) ) {
$id = $_GET['id'];
} elseif ( (isset($_POST['id'])) &&
 (($_POST['id'])) ) {
$id = $_POST['id'];
}
if($id){
$r="select * from hold where sessio='$id' and status='ACTIVE'";
$sql=mysqli_query($dbc,$r);
$rew=mysqli_fetch_array($sql);
$cust=$rew['cust'];
$yu="select descc from accounts where id='$cust' limit 1";
  $io=mysqli_query($dbc,$yu);
     $tp=mysqli_fetch_array($io);
	   $lim=$tp['descc'];
	      $_SESSION['limit']=$lim;
		  //echo $lim;
$_SESSION['customer']=$cust;
$n=mysqli_num_rows($sql);
if($n>0){
$t="select * from hold where sessio='$id'";
$tt=mysqli_query($dbc,$t);
while($row=mysqli_fetch_array($tt)){
$product[] = array('name'=>$row["product"],
					'code'=>$row["code"], 'qty'=>$row['qty'], 'price'=>$row["price"],'product_id'=>$row['product_id'],'vat'=>$row['vat']);

}

$y="delete from hold where sessio='$id'";
$yy=mysqli_query($dbc,$y);
$_SESSION["products"] = $product;
}

}

header("location: creditors.php");
?>