public static function getZones($id, $select = 0, $table = 'shipping')
{
if ($table == 'shipping') {
$t = '#__phocacart_shipping_method_zones';
$c = 'shipping_id';
} else {
if ($table == 'payment') {
$t = '#__phocacart_payment_method_zones';
$c = 'payment_id';
}
}
$db = Factory::getDBO();
if ($select == 1) {
$query = 'SELECT c.zone_id';
} else {
$query = 'SELECT a.*';
}
$query .= ' FROM #__phocacart_zones AS a' . ' LEFT JOIN ' . $t . ' AS c ON a.id = c.zone_id' . ' WHERE c.' . $c . ' = ' . (int) $id . ' ORDER BY a.id';
$db->setQuery($query);
if ($select == 1) {
$zones = $db->loadColumn();
} else {
$zones = $db->loadObjectList();
}
return $zones;
}