$stmt = $this->conn->prepare($sql);
if($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $conn->errno . ' ' . $conn->error, E_USER_ERROR);
}else{
$stmt->bind_param("isis", $type_id, $stock_id, $qty, $buy_time);
$stmt->execute();
}
$stmt->close();
}
}
$_ajax = new AJAX_CLASS();
/*
* ----------------------------------------------------------------------
* DEFINED VARIABLE
* ----------------------------------------------------------------------
*/
/* --- TYPE ID--- */
$ajx_type = $_POST['type_id'];
/*
if(isset($_POST['type_id']) and $_POST['type_id'] != ''){
$ajx_type = $ajx_type;
$this->conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
}
function count_stock($type_id, $stock_name)
{
$sql = "SELECT COUNT(stock_id) AS rows FROM `tbl_product_stock` WHERE type_id = '{$type_id}' AND `stock_name` = '{$stock_name}'";
$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>';
}
$stmt->execute();
}
$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;
$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
function get_collection()
{
$sql = "SELECT * FROM `tbl_gender` ORDER BY `gender_order` DESC";
$query = $this->conn->query($sql);
$row = array();
while ($result = $query->fetch_object()) {
array_push($row, $result);
}
return $row;
}
}
$_ajax = new AJAX_CLASS();
$count = $_ajax->count_collection();
$data = $_ajax->get_collection();
$product_id = filter_var($_POST['product_id'], FILTER_SANITIZE_NUMBER_INT);
$_data = $_ajax->data_collection($product_id);
echo '<li class="form-group row" id="id-row-collection">';
echo '<label class="col-xs-3 control-label" for="sizegroup">Gender</label>';
echo '<div class="col-xs-9">';
echo '<select class="form-control" id="id-collection" name="gender">';
echo '<option value="">-- Select Gender --</option>';
foreach ($data as $data) {
echo '<option value="' . $data->gender_id . '" ';
if ($_data->product_gender == $data->gender_id) {
echo 'selected="selected"';
}
echo '>' . $data->gender_name . '</option>';
function __construct()
{
$this->conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
}
function get_city($post_province)
{
$sql = "SELECT * FROM cities WHERE `province` = '{$post_province}' ORDER BY `city_name`";
$query = $this->conn->query($sql);
$row = array();
while ($result = $query->fetch_object()) {
array_push($row, $result);
}
return $row;
}
}
$_ajax = new AJAX_CLASS();
if ($_POST['province'] != '') {
$ajx_province = filter_var($_POST['province'], FILTER_SANITIZE_STRING);
$city = $_ajax->get_city($ajx_province);
/* --- DATA --- */
echo '<select class="form-control" id="id-city-billing" name="checkout_billing_city">';
echo '<option value="">-- City --</option>';
foreach ($city as $city) {
echo '<option value="' . $city->city_name . '"';
if ($_global_user->user_city != '') {
if ($city->city_name == $_global_user->user_city) {
echo 'selected="selected"';
}
} else {
/*
if($city->city_name == 'Jakarta'){
}else{
$stmt->bind_param("ss", $qty, $stock_id);
$stmt->execute();
}
$stmt->close();
}
}
$return = '';
$subitem = 0;
$_ajax = new AJAX_CLASS();
$ajx_type = $_SESSION['cart_type_id'];
foreach($ajx_type as $key=>$type){
$ajx_stock = $_SESSION['cart_stock_id'][$key];
$curr_prod = $_ajax->get_product($type, $ajx_stock);
$price = $_shop->discount_price($curr_prod->promo_id, $curr_prod->promo_value, $curr_prod->type_price, $curr_prod->promo_start_datetime, $curr_prod->promo_end_datetime, $temp_currency);
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;
$promo_normal_price = $price['was_price'];
$promo_value = ($curr_prod->promo_value / 100) * $price['was_price'];
trigger_error('Database error: ' . $sql . ' Error: ' . $conn->errno . ' ' . $conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("iis", $qty, $type_id, $stock_name);
$stmt->execute();
}
$stmt->close();
}
function get_carts($post_type_id, $stock_name)
{
$sql = "SELECT img_src, product_name, type_name, stock_name, stock_quantity, promo_id, promo_value, type_price, promo_start_datetime, promo_end_datetime\n\t\t \t\t\tFROM tbl_product_type AS type_ LEFT JOIN tbl_product AS prod_ ON type_.product_id = prod_.id\n LEFT JOIN tbl_product_image AS img_ ON type_.type_id = img_.type_id\n\t\t\t\t\t\t\t\t\t\t\t\t LEFT JOIN tbl_product_stock AS stock_ ON type_.type_id = stock_.type_id\n\t\t\t\t\t\t\t\t\t\t\t\t LEFT JOIN tbl_promo_item AS discount_ ON type_.type_id = discount_.product_type_id\n\t\t\t\t\t\t\t\t\t\t\t\t LEFT JOIN tbl_category AS cat_ ON cat_.category_id = prod_.product_category\n WHERE type_.type_id = '{$post_type_id}' AND stock_.stock_name = '{$stock_name}' AND img_.image_order = '0'\n\t\t\t ";
$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
}
$_ajax = new AJAX_CLASS();
/*
* ----------------------------------------------------------------------
* DEFINED VARIABLE
* ----------------------------------------------------------------------
*/
/* --- TYPE ID--- */
$ajx_type = $_POST['type_id'];
/* --- STOCK ID--- */
$ajx_stock = $_POST['stock_id'];
/* --- QTY--- */
$ajx_qty = $_POST['qty'];
if (isset($_POST['qty']) and $_POST['qty'] != '') {
$ajx_qty = $ajx_qty;
} else {
$ajx_qty = 1;
$result = $query->fetch_object();
return $result;
}
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;
$sql = "UPDATE tbl_voucher SET `voucher_used` = '$voucher_used' WHERE `voucher_id` = ?";
$stmt = $this->conn->prepare($sql);
if($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $this->conn->errno . ' ' . $this->conn->error, E_USER_ERROR);
}else{
$stmt->bind_param("s", $order_id);
$stmt->execute();
}
$stmt->close();
}
}
$_ajax = new AJAX_CLASS();
$ajx_code = filter_var($_POST['voucher'], FILTER_SANITIZE_STRING);
$ajx_status = '1';
$count = $_ajax->count_voucher($ajx_code, '1');
/* --- LOGIC --- */
if($count->rows > 0){
$data = $_ajax->get_voucher($ajx_code);
/*
* TYPE: $data->voucher_usability
* 1 => One Time
return $result;
}
function insert($product_id, $type_id, $stock_name, $qty, $time, $user_id, $email, $status)
{
$sql = "INSERT INTO tbl_back_order (`product_id`, `type_id`, `stockname`, `qty`, `time`, `user_id`, `email`, `status`)\n\t\t \t\t\t\t\t\tVALUES(?, ?, ?, ?, ?, ?, ?, ?)\n\t\t\t\t ";
$stmt = $this->conn->prepare($sql);
if ($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $this->conn->errno . ' ' . $this->conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("ssssssss", $product_id, $type_id, $stock_name, $qty, $time, $user_id, $email, $status);
$stmt->execute();
}
$stmt->close();
}
}
$_ajax = new AJAX_CLASS();
if (isset($_POST['type_id'])) {
$type_id = filter_var($_POST['type_id'], FILTER_SANITIZE_NUMBER_INT);
}
if (isset($_POST['stock_id'])) {
$stock_id = filter_var($_POST['stock_id'], FILTER_SANITIZE_NUMBER_INT);
}
if (isset($_POST['email'])) {
$email = filter_var($_POST['email'], FILTER_SANITIZE_EMAIL);
}
$data_product = $_ajax->get_product_data($type_id, $stock_id);
$count_user = $_ajax->count_email_data($email);
if ($count_user->rows > 0) {
$data_user = $_ajax->get_email_data($email);
$user_id = $data_user->user_id;
} else {
$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
function forgot_insert_log($user_id, $code, $status, $log_time)
{
$sql = "INSERT INTO `tbl_user_log` (`user_id`, `code`, `status`, `log_time`) VALUES(?, ?, ?, ?)";
$stmt = $this->conn->prepare($sql);
if ($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $this->conn->errno . ' ' . $this->conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("ssss", $user_id, $code, $status, $log_time);
$stmt->execute();
}
$stmt->close();
}
}
$_ajax = new AJAX_CLASS();
$email = filter_var($_POST['email'], FILTER_SANITIZE_EMAIL);
$count = $_ajax->count_email($email);
if ($count->rows > 0) {
$data = $_ajax->get_email($email);
$user_id = $data->user_id;
$code = strtolower(randomchr($length));
$status = 1;
$log_time = "NOW()";
$_ajax->forgot_insert_log($user_id, $code, $status, $log_time);
require_once '../../admin/emails/_forgot/_user_forgot.php';
} else {
}
}
{
/*
$sql = "SELECT * FROM tbl_product_type AS type_ LEFT JOIN tbl_product AS prod_ ON type_.product_id = prod_.id
LEFT JOIN tbl_product_image AS img_ ON type_.type_id = img_.type_id
LEFT JOIN tbl_product_stock AS stock_ ON stock_.type_id = type_.type_id
LEFT JOIN tbl_promo_item AS promo_ ON type_.type_id = promo_.product_type_id
WHERE `stock_id` = '$stock_id' AND `type_`.`type_id` = '$type_id'
GROUP BY `stock_id`
";
*/
$sql = "SELECT promo_id, promo_value, type_price, promo_start_datetime, promo_end_datetime, img_src, product_name, type_name, stock_name\n\t\t \t\t \tFROM tbl_product_type AS type_ LEFT JOIN tbl_product AS prod_ ON type_.product_id = prod_.id\n\t \t \t\t\t\t\t\t\t\t\t\t\t\t LEFT JOIN tbl_product_image AS img_ ON type_.type_id = img_.type_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t LEFT JOIN tbl_product_stock AS stock_ ON stock_.type_id = type_.type_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t LEFT JOIN tbl_promo_item AS promo_ ON type_.type_id = promo_.product_type_id\n\t WHERE `stock_name` = '{$stock_name}' AND `type_`.`type_id` = '{$type_id}'\n\t\t\t\t GROUP BY `stock_id`\n\t\t\t\t ";
$result = $this->fetchData('single', $sql);
return $result;
}
}
$_ajax = new AJAX_CLASS();
/* --- MINI NAVBAR CART --- */
if (isset($_SESSION['cart_type_id'])) {
$nav_mini_type = $_SESSION['cart_type_id'];
$nav_mini_stock = $_SESSION['cart_stock_id'];
$nav_mini_qty = $_SESSION['cart_qty'];
}
if (isset($_SESSION['cart_type_id'])) {
echo '<!--MINI SHOPPING BAG-->';
echo '<div id="navbar-mini-bag" class="mini-bag hidden">';
echo '<div class="navigator" id="navigator-up">';
echo '<i class="fa fa-angle-up"></i>';
echo '</div><!--.navigator-->';
echo '<!-- START: IMPORTANT -->';
echo '<div class="mini-container">';
echo '<div class="mini-item">';
$result = 'Very Good';
}else if($_condition == 5){
$result = 'Good';
}elseif($_condition == 6){
$result = 'Loved';
}elseif($_condition == 7){
$result = 'Well Loved';
}
return $result;
}
}
$_ajax = new AJAX_CLASS();
//echo '<pre>'.print_r($_POST).'</pre>';
/* --- DEFINED VARIABLE --- */
$_fname = $_POST['data']['fname'];
$_lname = $_POST['data']['lname'];
$_email = $_POST['data']['email'];
$_day = $_POST['data']['day'];
$_month = $_POST['data']['month'];
$_year = $_POST['data']['year'];
$_gender = $_POST['data']['gender'];
$_country = $_POST['data']['country'];
$_addr_1 = $_POST['data']['addr_1'];
$_addr_2 = $_POST['data']['addr_2'];
$stmt->execute();
}
$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);
$price = $_shop->discount_price($curr_prod->promo_id, $curr_prod->promo_value, $curr_prod->type_price, $curr_prod->promo_start_datetime, $curr_prod->promo_end_datetime, $temp_currency);
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;
//echo "<span class=\"price now-price \">".$currency." ".price(CURRENCY, $price['now_price'])."</span> \n";
//echo "<span class=\"price was-price \">".$currency." ".price(CURRENCY, $price['was_price'])."</span> \n";
$promo_normal_price = $price['was_price'];
$stmt = $this->conn->prepare($sql);
if($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $conn->errno . ' ' . $conn->error, E_USER_ERROR);
}else{
$stmt->bind_param("sssss", $ajx_user, $date, $ajx_type ,$ajx_stock, $ajx_qty);
$stmt->execute();
}
$stmt->close();
}
}
$_ajax = new AJAX_CLASS();
$ajx_type = filter_var($_POST['type_id'], FILTER_SANITIZE_NUMBER_INT);
$ajx_stock = filter_var($_POST['stock_id'], FILTER_SANITIZE_NUMBER_INT);
$ajx_qty = filter_var($_POST['qty'], FILTER_SANITIZE_NUMBER_INT);
if($_SESSION['account']['login_id'] == null){
$_SESSION['wishlist_tmp'] = '1';
$_SESSION['wishlist_tmp_type'] = $ajx_type;
$_SESSION['wishlist_tmp_stock'] = $ajx_stock;
$_SESSION['wishlist_tmp_qty'] = $ajx_qty;
echo 'user_notok';
}else{
$stmt = $this->conn->prepare($sql);
if($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $conn->errno . ' ' . $conn->error, E_USER_ERROR);
}else{
$stmt->bind_param("ss", $status, $id);
$stmt->execute();
}
$stmt->close();
}
}
$_ajax = new AJAX_CLASS();
/* --- DEFINED VARIABLE --- */
$_type_id = $_POST['data']['type_id'];
$_stock = $_POST['data']['stock'];
$stock = $_ajax->get_product_stock($_stock, $_type_id);
$buy = $_ajax->get_buy_now($_stock, $_type_id);
$expired = $_ajax->check_on_hold($buy->buy_time);
if($expired->second > 10){
$_ajax->update_stock(($_stock->stock_quantity + $buy->qty), $buy->type_id, $buy->stock_id);
$_ajax->update_buy_now('0', $buy->id);
}else{
echo 'SQL: ' . $sql;
$stmt = $this->conn->prepare($sql);
if ($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $conn->errno . ' ' . $conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("ssss", $qty, $typeID, $stockName, $cartHash);
$stmt->execute();
}
$stmt->close();
} else {
echo 'Bawah';
$this->insertCartItem($cartHash, $typeID, $stockName, $qty);
}
}
}
$_ajax = new AJAX_CLASS();
/*
* ----------------------------------------------------------------------
* DEFINED VARIABLE
* ----------------------------------------------------------------------
*/
/* --- DEFINED VARIABLE -- */
$ajx_type = filter_var($_POST['type_id'], FILTER_SANITIZE_NUMBER_INT);
$ajx_stock = filter_var($_POST['stock_name'], FILTER_SANITIZE_STRING);
$ajx_qty = filter_var($_POST['qty'], FILTER_SANITIZE_NUMBER_INT);
if (isset($_POST['qty']) and $_POST['qty'] != '') {
$ajx_qty = $ajx_qty;
} else {
$ajx_qty = 1;
}
$temp_stock = $_ajax->get_stock($ajx_type, $ajx_stock);
return $result;
}
function update_temp_stock($qty, $type_id, $stock_name)
{
$sql = "UPDATE tbl_product_stock set `stock_quantity` = ? WHERE `type_id` = ? AND `stock_name` = ?";
$stmt = $this->conn->prepare($sql);
if ($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $conn->errno . ' ' . $conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("iis", $qty, $type_id, $stock_name);
$stmt->execute();
}
$stmt->close();
}
}
$_ajax = new AJAX_CLASS();
/*
* ----------------------------------------------------------------------
* DEFINED VARIABLE
* ----------------------------------------------------------------------
*/
/* --- DEFINED VARIABLE -- */
$ajx_type = filter_var($_POST['type_id'], FILTER_SANITIZE_NUMBER_INT);
$ajx_stock = filter_var($_POST['stock_name'], FILTER_SANITIZE_STRING);
$ajx_qty = filter_var($_POST['qty'], FILTER_SANITIZE_NUMBER_INT);
if (isset($_POST['qty']) and $_POST['qty'] != '') {
$ajx_qty = $ajx_qty;
} else {
$ajx_qty = 1;
}
$temp_stock = $_ajax->get_stock($ajx_type, $ajx_stock);
function __construct()
{
$this->conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
}
function get_city($post_courier_province)
{
$sql = "SELECT * FROM tbl_courier_rate WHERE `courier_province` = '{$post_courier_province}' GROUP BY `courier_city` ORDER BY courier_city ASC";
$query = $this->conn->query($sql);
$row = array();
while ($result = $query->fetch_object()) {
array_push($row, $result);
}
return $row;
}
}
$_ajax = new AJAX_CLASS();
$ajax_city = filter_var($_POST['province'], FILTER_SANITIZE_STRING);
$ajax_country = filter_var($_POST['temp'], FILTER_SANITIZE_STRING);
$city = $_ajax->get_city($ajax_city);
if ($_global_user->user_city == '') {
$_global_user->user_city = '';
} else {
$_global_user->user_city = $_global_user->user_city;
}
if ($ajax_country == 'Indonesia') {
echo '<select class="form-control" id="id-city" name="city">';
foreach ($city as $city) {
echo '<option value="' . $city->courier_city . '" ';
if ($_global_user->user_city != '' && $_global_user->user_city == $city->courier_city) {
echo 'selected="selected"';
}
function __construct()
{
$this->conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
}
function get_province()
{
$sql = "SELECT * FROM province ORDER BY province_name ASC";
$query = $this->conn->query($sql);
$row = array();
while ($result = $query->fetch_object()) {
array_push($row, $result);
}
return $row;
}
}
$_ajax = new AJAX_CLASS();
$country = filter_var($_POST['country'], FILTER_SANITIZE_STRING);
if ($country == 'Indonesia') {
$province = $_ajax->get_province();
/* --- DATA --- */
echo '<select class="form-control w50" id="id-province-billing" name="checkout_billing_province">';
echo '<option value="">-- Province --</option>';
foreach ($province as $province) {
//if($_global_user->user_province != ''){
echo '<option value="' . $province->province_name . '" ';
if ($province->province_name == $_global_user->user_province) {
echo 'selected="selected"';
}
echo ' >' . $province->province_name . '</option>';
//}else{
/*
function get_courier_rate_international($courier_name, $courier_city){
$sql = "SELECT * FROM tbl_courier AS courier_ LEFT JOIN tbl_courier_rate AS rate_ ON courier_.courier_id = rate_.courier_name
WHERE `courier_rate` != '0' AND `rate_`.`courier_name` = '$courier_name' AND `rate_`.`courier_city` = '$courier_city'
";
$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
}
$_ajax = new AJAX_CLASS();
$ajx_country = filter_var($_POST['country'], FILTER_SANITIZE_STRING);
$ajx_city = filter_var($_POST['city'], FILTER_SANITIZE_STRING);
$session_type = $_SESSION['cart_type_id'];
$session_qty = $_SESSION['cart_qty'];
/* --- TOTAL WEIGHT --- */
$total = 0;
foreach($session_type as $key=>$type){
$weight = $_ajax->get_cart($type);
$total += $weight->type_weight * $_SESSION['cart_qty'][$key];
}
$query = $this->conn->query($sql);
$row = array();
while ($result = $query->fetch_object()) {
array_push($row, $result);
}
return $row;
}
function countCity($courier_city)
{
$sql = "SELECT COUNT(`courier_rate_id`) AS `rows` FROM `tbl_courier_rate` AS `rate_` INNER JOIN \n\t `tbl_courier` AS `courier_` ON `rate_`.courier_name = `courier_`.courier_id\n\t WHERE `courier_rate` > 0 AND `courier_city` = '{$courier_city}' AND `active_status` = 'Active'";
$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
}
$_ajax = new AJAX_CLASS();
if ($_POST['province'] != '') {
$ajx_province = filter_var($_POST['province'], FILTER_SANITIZE_STRING);
$city = $_ajax->get_city($ajx_province);
/* --- DATA --- */
echo '<select class="form-control" id="id-city" name="checkout_user_city">';
echo '<option value="">-- City --</option>';
foreach ($city as $city) {
$disabledItem = $_ajax->countCity($city->city_name);
$disabledProvince = '';
$noteDisabledProvince = '';
if ($disabledItem->rows > 0) {
$disabledProvince = '';
$noteDisabledProvince = '';
} else {
$disabledProvince = 'disabled="disabled"';
$query = $this->conn->query($sql);
$row = array();
while ($result = $query->fetch_object()) {
array_push($row, $result);
}
return $row;
}
function countCity($courier_province)
{
$sql = "SELECT COUNT(`courier_rate_id`) AS `rows` FROM `tbl_courier_rate` AS `rate_` INNER JOIN \n\t `tbl_courier` AS `courier_` ON `rate_`.courier_name = `courier_`.courier_id\n\t WHERE `courier_rate` > 0 AND `courier_province` = '{$courier_province}' AND `active_status` = 'Active'";
$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
}
$_ajax = new AJAX_CLASS();
$country = filter_var($_POST['country'], FILTER_SANITIZE_STRING);
if ($country == 'Indonesia') {
$province = $_ajax->get_province();
/* --- DATA --- */
echo '<select class="form-control w50" id="id-province" name="checkout_user_province">';
echo '<option value="">-- Province --</option>';
foreach ($province as $province) {
$disabledItem = $_ajax->countCity($province->province_name);
$disabledProvince = '';
$noteDisabledProvince = '';
/* --- START: DISABLED PROVINCE --- */
/*if(in_array($province->province_name, $globalShopProvinceAvailable)){
$disabledProvince = '';
$noteDisabledProvince = '';
}else{
$sql = "SELECT COUNT(*) AS rows FROM tbl_collection ORDER BY collection_order DESC";
$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
function get_collection()
{
$sql = "SELECT * FROM tbl_collection ORDER BY collection_order DESC";
$query = $this->conn->query($sql);
$row = array();
while ($result = $query->fetch_object()) {
array_push($row, $result);
}
return $row;
}
}
$_ajax = new AJAX_CLASS();
$count = $_ajax->count_collection();
$data = $_ajax->get_collection();
echo '<li class="form-group row" id="id-row-collection">';
echo '<label class="col-xs-3 control-label" for="sizegroup">Designer</label>';
echo '<div class="col-xs-9">';
echo '<select class="form-control" id="id-collection" name="collection">';
echo '<option value="">-- Select Designer --</option>';
foreach ($data as $data) {
echo '<option value="' . $data->collection_id . '">' . $data->collection_name . '</option>';
}
echo '</select>';
echo '</div>';
echo '</li>';
}
/*
* ----------------------------------------------------------------------
* AJAX: REMOVE WISHLIST
* ----------------------------------------------------------------------
*/
if (isset($_POST)) {
require_once '../../admin/static/_header.php';
class AJAX_CLASS
{
private $conn;
function __construct()
{
$this->conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
}
function delete_wishlist($wishlist_id)
{
$sql = "DELETE FROM tbl_wishlist WHERE `wishlist_id` = ?";
$stmt = $this->conn->prepare($sql);
if ($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $conn->errno . ' ' . $conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("s", $wishlist_id);
$stmt->execute();
}
$stmt->close();
}
}
$_ajax = new AJAX_CLASS();
$wishlist_id = filter_var($_POST['key'], FILTER_SANITIZE_NUMBER_INT);
$_ajax->delete_wishlist($wishlist_id);
}
$this->conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
}
function insert_wishlist($ajx_user, $date, $ajx_type, $ajx_stock, $ajx_qty)
{
$sql = "INSERT INTO `tbl_wishlist`(user_id, wishlist_date, type_id, `stock_name`, item_quantity)\n\t\t\t VALUES (?, ?, ?, ?, ?)\n\t\t\t\t ";
$stmt = $this->conn->prepare($sql);
if ($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $conn->errno . ' ' . $conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("sssss", $ajx_user, $date, $ajx_type, $ajx_stock, $ajx_qty);
$stmt->execute();
}
$stmt->close();
}
}
$_ajax = new AJAX_CLASS();
$ajx_type = filter_var($_POST['type_id'], FILTER_SANITIZE_NUMBER_INT);
$ajx_stock = filter_var($_POST['stock_name'], FILTER_SANITIZE_STRING);
$ajx_qty = filter_var($_POST['qty'], FILTER_SANITIZE_NUMBER_INT);
if ($_SESSION['account']['login_id'] == null) {
$_SESSION['wishlist_tmp'] = '1';
$_SESSION['wishlist_tmp_type'] = $ajx_type;
$_SESSION['wishlist_tmp_stock'] = $ajx_stock;
$_SESSION['wishlist_tmp_qty'] = $ajx_qty;
echo 'user_notok';
} else {
$date = date('Y-m-d H:i:s');
/* --- DATE --- */
$ord_day = date("d");
$ord_month = date("m");
$ord_year = date("y");
