<?php
session_start();
require 'db.connect.php';
include 'Telegram.php';
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
$prod = json_decode($_POST['prod_values'],true);
$sub_id = $_POST['sub_id'];
$dealer_id = $_SESSION['dealer_id'];
foreach($prod as $prods){
    if($prods['prod_id'] == $sub_id){

        $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);
        $split = explode("+",$set_prod_info['offer_unit']);
                $quotient = floor($prods['qty'] / $split[0]);  
                $remainder = $prods['qty'] % $split[0];  
                if($remainder == 0){
                    $free_qty = $quotient * $split[1];
                }else{
                    $free_qty = $quotient;
                }
        $amount = $prods['qty'] * $prods['price']; 
        $get_prod = mysqli_query($conn, "SELECT * FROM tbl_dealer_ef_temp where prod_id='$sub_id' and dealer_id = '$dealer_id'");
        $check_rows = mysqli_num_rows($get_prod);
       
        if($check_rows > 0){
           
            $set_prod = mysqli_fetch_assoc($get_prod);
            if($set_prod['qty']=='1'){
                $delete = "DELETE FROM tbl_dealer_ef_temp where prod_id='$sub_id' and dealer_id='$dealer_id'";
                mysqli_query($conn, $delete);
            }else{
                $update = "UPDATE tbl_dealer_ef_temp set qty='".$prods['qty']."', free_qty='$free_qty', price='".$prods['price']."', tot_price='$amount' where prod_id='".$prods['prod_id']."' and dealer_id='$dealer_id';";
                mysqli_query($conn, $update);
            }
        
        }
    }

}
?>