{ $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 {