{
$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{
$disabledProvince = 'disabled="disabled"';
$noteDisabledProvince = '';
}*/
if ($disabledItem->rows > 0) {
$disabledProvince = '';
$noteDisabledProvince = '';
} else {
$disabledProvince = 'disabled="disabled"';
{
$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"';
$noteDisabledProvince = '';
}
echo '<option ' . $disabledProvince . ' value="' . $city->city_name . '"';
if ($_global_user->user_city != '') {
if ($city->city_name == $_global_user->user_city) {
echo 'selected="selected"';
}
} else {
