MAINHACK

Viewing / Editing File: orders_submit.php

<?php include("../admin/includes/functions/functions.php");?>
<?php include("../admin/db/db.php");?>

<?php 
$username = $_SESSION['username_Xw211qAAsq4'];
$shopname = $_SESSION['business_name_Xw211qAAsq4'];

/*** ADD NEW SERVICE ***/
if(isset($_POST['add_new_service']))
{

$buy_id = test_input($_POST['buy_id']);
$amount_paid = test_input($_POST['amount_paid']);
$payment_mode = test_input($_POST['payment_mode']);
$discount = test_input($_POST['discount']);
$date = date("Y-m-d");
$total = test_input($_POST['total']);

if(empty($discount)){
    $dis = 0;
}else {
    $dis = $discount;
}

$pro_id = $_POST['ppro_id'];
$qty = $_POST['qqty'];
$amount = $_POST['amount'];

if(!empty($pro_id )){

$stmt_appointment = mysqli_query($new,"insert into product_sales(buy_id,discount,total_amount,amount_paid,payment_mode,sold_date,business_name)values('$buy_id','$dis','$total','$amount_paid','$payment_mode','$date','$shopname')");

$sales_id = mysqli_insert_id($new);

for ($i=0; $i < count($pro_id) ; $i++) {

$pro_idd = $pro_id[$i];
     $qtyy = $qty[$i];
     $amountt = $amount[$i];

$xy = "INSERT INTO invoice_order_item (sales_id,pro_id,qty,amount) VALUES 
  ('$sales_id','$pro_idd','$qtyy','$amountt')";
  $x = mysqli_query($new,$xy);

$stmtt = mysqli_query($new,"Select qty FROM products WHERE pro_id = '$pro_idd'");
    $row = mysqli_fetch_array($stmtt);
    
    $dbqty = $row['qty'];

$remain = $dbqty - $qtyy;

$stmt = $con->prepare("update  products set qty = ? where pro_id = ? ");
    $stmt->execute(array($remain,$pro_idd));

}

$del = "DELETE FROM cart WHERE user_id = '$shopname'";
$l = mysqli_query($new,$del);
header("location:pos");
} else {}

}
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: orders_submit.php

Server Info

System Features

User Info