$_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>'; } } }