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{
$disabledProvince = 'disabled="disabled"';
$noteDisabledProvince = '';
}*/
