<?php
session_start();
require 'db.connect.php';
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
$prod = json_decode($_POST['prod_values'],true);
$dealer_id = $_SESSION['dealer_id'];

foreach($prod as $prods){
$get_prod_info = mysqli_query($conn, "SELECT * FROM shop_product where product_id = '".$prods['prod_id']."'");
$set_prod_info = mysqli_fetch_assoc($get_prod_info);

$amount = $prods['qty'] * $prods['price']; 
$get_prod = mysqli_query($conn, "SELECT * FROM tbl_dealer_ef_temp where prod_id='".$prods['prod_id']."' and dealer_id = '$dealer_id'");
$check_rows = mysqli_num_rows($get_prod);
if($check_rows > 0){
$update = "UPDATE tbl_dealer_ef_temp set qty='".$prods['qty']."', free_qty='0', price='".$prods['price']."', tot_price='$amount' where prod_id='".$prods['prod_id']."' and dealer_id='$dealer_id';";
mysqli_query($conn, $update);
}else{
$insert = "INSERT INTO tbl_dealer_ef_temp
(dealer_id, prod_id, qty, free_qty, price, tot_price, created_at)
VALUES('$dealer_id', '".$prods['prod_id']."', '".$prods['qty']."', '0', '".$prods['price']."', '$amount', CURRENT_TIMESTAMP);";    
mysqli_query($conn, $insert);
}
}
?>