$_SESSION['add-order'][$prefix . 'add-cart-type-id'][] = $ajx_type;
$_SESSION['add-order'][$prefix . 'add-cart-stock-id'][] = $ajx_stock;
$_SESSION['add-order'][$prefix . 'add-cart-qty'][] = $ajx_qty;
} else {
/* --- EXISTED --- */
if (is_numeric($key) && is_numeric($check_stock)) {
$_SESSION['add-order'][$prefix . 'add-cart-type-id'][$key] = $ajx_type;
$_SESSION['add-order'][$prefix . 'add-cart-stock-id'][$check_stock] = $ajx_stock;
$_SESSION['add-order'][$prefix . 'add-cart-qty'][$check_stock] = $_SESSION['add-order'][$prefix . 'add-cart-qty'][$check_stock] + $ajx_qty;
} else {
$_SESSION['add-order'][$prefix . 'add-cart-type-id'][] = $ajx_type;
$_SESSION['add-order'][$prefix . 'add-cart-stock-id'][] = $ajx_stock;
$_SESSION['add-order'][$prefix . 'add-cart-qty'][] = $ajx_qty;
}
}
$temp_stock = $_ajax->get_stock($ajx_type, $ajx_stock);
$temp_stock = $temp_stock->stock_quantity - $ajx_qty;
$_ajax->update_temp_stock($temp_stock, $ajx_type, $ajx_stock);
$total_qty = 0;
$sess_qty = $_SESSION['add-order'][$prefix . 'add-cart-qty'];
foreach ($sess_qty as $sess_qty) {
$total_qty += $sess_qty;
}
$total_cart = $total_qty;
echo $total_cart;
}
/* --- DEFINED VARIABLE --- */
$_type_id = $_SESSION['add-order'][$prefix . 'add-cart-type-id'];
$_stock_id = $_SESSION['add-order'][$prefix . 'add-cart-stock-id'];
$_qty = $_SESSION['add-order'][$prefix . 'add-cart-qty'];
$sub_total = 0;
$_SESSION['cart_qty'][$check_stock] = $_SESSION['cart_qty'][$check_stock] + $ajx_qty;
$_SESSION['cart_time'][$key] = $_date_now;
}else{
$_SESSION['cart_type_id'][] = $ajx_type;
$_SESSION['cart_stock_id'][] = $ajx_stock;
$_SESSION['cart_qty'][] = $ajx_qty;
$_SESSION['cart_time'][] = $_date_now;
}
}
$temp_stock = $_ajax->get_stock($ajx_type, $ajx_stock);
$stock_name = $_ajax->get_stock($ajx_type, $ajx_stock);
$temp_stock = $temp_stock->stock_quantity - $ajx_qty;
if($temp_stock < 0){
$temp_stock = 0;
$success = 0;
}else{
$temp_stock = $temp_stock;
$success = 1;
}
$date = date('Y-m-d H:i:s');
$_ajax->update_temp_stock($temp_stock, $ajx_type, $ajx_stock);
$_ajax->insert_buy($ajx_type, $stock_name->stock_name, $ajx_qty, $date);
function get_stock($stock_id){
$sql = "SELECT * FROM tbl_product_stock WHERE `stock_id`= '$stock_id'";
$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
}
$_ajax = new AJAX_CLASS();
$stock_id = filter_var($_POST['ajax_stock_id'], FILTER_SANITIZE_STRING);
$count_stock = $_ajax->count_stock($stock_id);
$data_stock = $_ajax->get_stock($stock_id);
if($count_stock->rows > 0){
$stock_qty = $data_stock->stock_quantity;
if($stock_qty > 0){
if($stock_qty > 9){
$stock_qty = 9;
}else{
$stock_qty = $stock_qty;
}
}
$stmt->close();
}
}
$ajx_key = $_POST['key'];
$ajx_qty = $_SESSION['cart_qty'][$ajx_key];
$ajx_stock = $_SESSION['cart_stock_id'][$ajx_key];
$ajx_type = $_SESSION['cart_type_id'][$ajx_key];
$_ajax = new AJAX_CLASS();
$curr_stock = $_ajax->get_stock($ajx_stock);
$curr_prod = $_ajax->get_product($ajx_type, $ajx_stock);
if($curr_prod->promo_id != null and $curr_prod->promo_start_datetime <= date('Y-m-d') and $curr_prod->promo_end_datetime >= date('Y-m-d')){
if($curr_prod->promo_id == '1'){
$promo_normal_price = $curr_prod->type_price;
$promo_value = ($curr_prod->promo_value / 100) * $curr_prod->type_price;
}else if($curr_prod->promo_id == '2'){
$promo_value = $curr_prod->promo_value;
}
$curr_prod->type_price = $curr_prod->type_price - $promo_value;
}else{
$result = $this->fetchData('single', $sql);
return $result;
}
function get_stock($type_id, $stock_name)
{
$sql = "SELECT stock_quantity FROM `tbl_product_stock` WHERE `type_id`= '{$type_id}' AND `stock_name` = '{$stock_name}'";
$result = $this->fetchData('single', $sql);
return $result;
}
}
$_ajax = new AJAX_CLASS();
$type_id = filter_var($_POST['type_id'], FILTER_SANITIZE_NUMBER_INT);
$stock_name = filter_var($_POST['stock_name'], FILTER_SANITIZE_STRING);
$count_stock = $_ajax->count_stock($type_id, $stock_name);
if ($count_stock->rows > 0) {
$data_stock = $_ajax->get_stock($type_id, $stock_name);
$stock_qty = $data_stock->stock_quantity;
if ($stock_qty > 0) {
if ($stock_qty > 9) {
$stock_qty = 9;
} else {
$stock_qty = $stock_qty;
}
for ($i = 1; $i <= $stock_qty; $i++) {
echo '<option value="' . $i . '">' . $i . '</option>';
}
} else {
echo '<option value="0">1</option>';
}
}
}
