include '../config_menu.php';
$amount = $_SESSION['amount']/100.0;unset($_SESSION['amount']);
$table_id = $_SESSION["qr_menu_type"].$_SESSION["qr_table_number"];
$con =  mysqli_connect($servername, $username, $password, $database);
$extract1 = mysqli_query($con,"SELECT * FROM order_view WHERE table_id='$table_id' AND payment_method='Pay Online'");
while ($row1 = mysqli_fetch_assoc($extract1)) {
  $bill_id = $row1['bill_id'];
  $order_id = $row1['order_id'];
  $discount = $row1['discount'];
  $tax = $row1['tax'];
  $extra_charge = $row1['extra'];
  $address = $row1['address'];
  mysqli_query($con,"DELETE FROM order_view WHERE order_id='$order_id'");
  $extract2 = mysqli_query($con,"SELECT * FROM order_present WHERE order_id='$order_id'");
  while ($row2 = mysqli_fetch_assoc($extract2)) {
    $pid = $row2['pid'];
    $pname = $row2['pname'];
    $type= $row2['type'];
    $size = $row2['size'];
    $toppings = $row2['toppings'];
    $comments = $row2['comments'];
    $extra = $row2['extra'];
    $quantity = $row2['quantity'];
    $price = $row2['price'];
    $time_start = $row2['time'];
    $time_end = date("d-m-Y.H:i:s");
    $extract3 = mysqli_query($con,"SELECT cid FROM product WHERE pid='$pid'");
    $row3 = mysqli_fetch_assoc($extract3);
    $cid = $row3['cid'];
    mysqli_query($con,"DELETE FROM order_present WHERE order_id='$order_id'");
    mysqli_query($con,"INSERT INTO order_kitchen VALUES('','$table_id','$order_id','$cid','$pid','$pname','$type','$size','$toppings','$comments','$extra','$quantity','$time_start')");
    mysqli_query($con,"INSERT INTO order_history VALUES(
      '',
      '$table_id','$bill_id','$order_id','0','0','0','$amount','$fee','$dpayment_id','$email','$contact',
      '$pid','$pname','$type','$size','$toppings','$comments','$extra','$quantity','$price','$discount','$spl','$tax','$extra_charge','$address',
      '$time_start',
      '$time_end'
    )");
  }
}