0){
$set_prod = mysqli_fetch_assoc($check_prod);
if($set_prod['stock_status'] == 'ordered' && $set_prod['ref_order_id']!=''){
echo '
This product is already converted into order
';
exit;
}if($set_prod['stock_status'] == 'ordered' && $set_prod['ref_order_id']==''){
echo '
This product is already available in the cart and has to be converted to order
';
exit;
}elseif($set_prod['stock_status'] == 'no stock'){
echo '
This product is already marked as no stock
';
exit;
}
}else{
$check_prod = mysqli_query($conn, "SELECT * FROM tbl_dealer_ef_sub WHERE order_id = '$bill_id'");
$set_prod = mysqli_fetch_assoc($check_prod);
$get_prod_info = mysqli_query($conn, "SELECT * FROM shop_product where product_id = '$prod_id'");
$set_prod_info = mysqli_fetch_assoc($get_prod_info);
$split = explode("+",$set_prod_info['offer_unit']);
$quotient = floor($qty / $split[0]);
$remainder = $qty % $split[0];
if(!in_array($set_prod['dealer_id'], $arr)){
if($remainder == 0){
$free_qty = $quotient * $split[1];
}else{
$free_qty = $quotient;
}
}else{
$free_qty = 0;
}
$tot_price = $qty * $set_prod_info['price'];
$insert_sub = "INSERT INTO tbl_dealer_ef_sub
(order_id, dealer_id, prod_id, qty, free_qty, price, tot_price, vstatus, stock_status, order_date_time)
VALUES('$bill_id', '".$set_prod['dealer_id']."', '$prod_id', '$qty', '$free_qty', '".$set_prod_info['price']."', '$tot_price', '".$set_prod_info['vstatus']."', 'added by admin', '$date');";
if(mysqli_query($conn, $insert_sub)){
echo '
Product Added successfully.
';
exit;
}else{
echo '
The product not added successfully contact Tech team.
';
exit;
}
}
?>