$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");