public function isZipCodeRangePresent($zip_codes)
{
$res = false;
list($from, $to) = $this->breakDownZipCode($zip_codes);
if ($from == 0) {
return false;
}
if ($to != 0) {
$res = Db::getInstance()->getValue('
SELECT COUNT(*) FROM `' . _DB_PREFIX_ . 'county_zip_code` cz
LEFT JOIN `' . _DB_PREFIX_ . 'county` c ON (c.`id_county` = cz.`id_county`)
LEFT JOIN `' . _DB_PREFIX_ . 'state` s ON (s.`id_state` = c.`id_state`)
WHERE `from_zip_code` >= ' . (int) $from . '
AND `to_zip_code` <= ' . (int) $to . '
AND s.`id_country` = (SELECT `id_country`
FROM `' . _DB_PREFIX_ . 'state` s
LEFT JOIN `' . _DB_PREFIX_ . 'county` c ON (c.`id_state` = s.`id_state`)
WHERE `id_county` = ' . (int) $this->id . '
)');
}
return $res or County::isZipCodePresent($from) or County::isZipCodePresent($to);
}
