Collyer Online Shop

From: Singapore

Choose a destination to see vessel sailings from Singapore.

/>
Search by country

>
Destination port

Select a port to view sailings to that port.

>
Destination country

Shows sailings to all available ports in this country; results list each port.

Include sailings since

Sort results by

Links to Intranet Access Pages:

'SIN.SIN_ETA, VPL.ETA, VYG.VESSEL_NAME, VYG.ID',
'eta' => 'VPL.ETA, VPL.PORT_NAME, VYG.VESSEL_NAME, VYG.ID',
'port' => 'VPL.PORT_NAME, VYG.VESSEL_NAME, VPL.ETA, VYG.ID',
'vessel' => 'VYG.VESSEL_NAME, VYG.VOYAGE_NAME, VPL.ETA, VPL.PORT_NAME, VYG.ID'
);
$destination_filter = $bycountryonly === 'yes'
? "VPL.PORT_CODE LIKE '".$countrycode."%'"
: "VPL.PORT_CODE = '".$portcode."'";

// Resolve Singapore arrival once per voyage instead of querying it for each row.
$sql = "SELECT VYG.VESSEL_NAME, VYG.VOYAGE_NAME, VYG.TEU_CAP,
VPL.PORT_NAME, VPL.PORT_CODE, VPL.ETA, VPL.ETD,
SIN.SIN_ETA
FROM VOYAGE_PORT_LINE AS VPL
INNER JOIN VOYAGE AS VYG ON VPL.ID = VYG.ID
INNER JOIN (
SELECT ID, MIN(ETA) AS SIN_ETA
FROM VOYAGE_PORT_LINE
WHERE CID='70200009' AND PORT_CODE='SGSIN' AND ETA IS NOT NULL
GROUP BY ID
) AS SIN ON SIN.ID = VPL.ID
WHERE VPL.CID='70200009' AND VPL.ETA IS NOT NULL
AND VPL.ETA != 'NULL' AND VPL.PORT_CODE!='SGSIN'
AND VPL.ETA > DATE_SUB(NOW(), INTERVAL $pastdays DAY)
AND $destination_filter AND VPL.P_PORT_CODE='-'
AND VYG.STATUS IN ('AC', 'CM')
AND (VYG.TEU_CAP IS NULL OR VYG.TEU_CAP != -1)
AND VPL.ETA > SIN.SIN_ETA
ORDER BY ".$orderings[$sortby];

$conp = collyer_schedule_connection();
try {
$result = $conp ? mysqli_query($conp, $sql) : false;
} catch (Throwable $error) {
$result = false;
}

if (!$result) {
echo '

Schedules are temporarily unavailable. Please try again shortly.

';
} else {
$schedules = array();
while ($row = mysqli_fetch_assoc($result)) {
$arrival = strtotime($row['ETA']);
$singapore_arrival = strtotime($row['SIN_ETA']);
$departure = strtotime($row['ETD']);
if ($arrival === false || $singapore_arrival === false ||
($departure !== false && date('Y-m-d', $departure) === '2001-01-01')) continue;
$row['TRAVEL_DAYS'] = (int) floor(($arrival - $singapore_arrival) / 86400) + 1;
$row['IS_PAST'] = $arrival < time(); $schedules[] = $row; } mysqli_free_result($result); $destination_name = $bycountryonly === 'yes' ? $countrycode.' â€” '.countryCode2Name($countrycode) : (isset($schedules[0]) ? $schedules[0]['PORT_NAME'].' ('.$portcode.')' : $portcode); echo '

';
if ($schedules) {
echo '

';
}
echo '

';
echo '

Collyer Shipping Â· Sailing Schedules

';
echo '

'.count($schedules).' '.(count($schedules) === 1 ? 'sailing' : 'sailings').' to '.esc_html($destination_name).'

';
if ($schedules) {
echo '

';
echo '

';
foreach ($schedules as $row) {
$cell_class = $row['IS_PAST'] ? 'schdpast' : 'schd';
$port_name = $row['PORT_NAME'].' ('.$row['PORT_CODE'].')';
echo '

';
foreach (array($row['VESSEL_NAME'], $row['VOYAGE_NAME'], 'Singapore',
Mysql2PHPDateTime($row['SIN_ETA']), $port_name,
Mysql2PHPDateTime($row['ETA']), $row['TRAVEL_DAYS']) as $value) {
echo '

';
}
echo '

Sailings from Singapore to '.esc_html($destination_name).'
Vessel Name	Voyage	Origin	ETA Singapore	Destination Port	ETA Destination	Days
'.esc_html((string) $value).'

';
} else {
echo '

No sailings match this destination and date range. Try a longer date range or another destination.

';
}
echo '

';
}
}
?>

Please select a destination and choose Show sailings.

'Since yesterday', 8 => 'Past week', 15 => 'Past two weeks',
30 => 'Past month', 60 => 'Past two months');
$options = '';
foreach ($labels as $days => $label) {
$options .= '';
}
return $options;
}

function select_sortby($sortby) {
$labels = array('etasin' => 'Arrival in Singapore', 'eta' => 'Arrival at destination',
'port' => 'Destination port', 'vessel' => 'Vessel name');
$options = '';
foreach ($labels as $key => $label) {
$options .= '';
}
return $options;
}

//=== select_portcode ===============================================

// Countries come only from eligible destination ports, with one option per code.
function select_portcode($portcode) {
global $pastdays, $collyer_schedule_countries;
$collyer_schedule_countries = array();
$sql = "SELECT DISTINCT VPL.PORT_CODE, VPL.PORT_NAME
FROM VOYAGE_PORT_LINE AS VPL
INNER JOIN VOYAGE AS VYG ON VPL.ID = VYG.ID
WHERE VPL.CID='70200009' AND VPL.ETA IS NOT NULL
AND VPL.ETA != 'NULL' AND VPL.PORT_CODE!='SGSIN'
AND VPL.P_PORT_CODE='-'
AND VPL.ETA > DATE_SUB(NOW(), INTERVAL $pastdays DAY)
AND VYG.STATUS IN ('AC', 'CM')
ORDER BY VPL.PORT_NAME, VPL.PORT_CODE";
$conp = collyer_schedule_connection();
if (!$conp) return '';
try {
$result = mysqli_query($conp, $sql);
} catch (Throwable $error) {
$result = false;
}
if (!$result) return '';
$ports = array();
while ($row = mysqli_fetch_assoc($result)) {
$code = strtoupper(trim($row['PORT_CODE']));
if (!preg_match('/^[A-Z]{2}[A-Z0-9]{3}$/D', $code)) continue;
$country = substr($code, 0, 2);
$collyer_schedule_countries[$country] = countryCode2Name($country);
$ports[$code] = countryCode2Name($country).', '.$row['PORT_NAME'].' ('.$code.')';
}
mysqli_free_result($result);
asort($ports, SORT_NATURAL | SORT_FLAG_CASE);
$options = '';
foreach ($ports as $code => $label) {
$options .= '';
}
return $options;
}

function collyer_schedule_country_options($selected) {
global $collyer_schedule_countries;
$countries = (array) $collyer_schedule_countries;
asort($countries, SORT_NATURAL | SORT_FLAG_CASE);
$options = '';
foreach ($countries as $code => $name) {
$options .= '';
}
return $options;
}

function countryCode2Name($code) {
$code = strtoupper(trim($code));
$countries = collyer_schedule_iso_countries();
return isset($countries[$code]) ? $countries[$code] : $code;
}

Collyer Online Shop

Collyer Shipping Â· Sailing Schedules

Mr Healthy Sugar Free Pistachio

Mr Healthy Sugar Free Tandoori Masala

Mr Healthy Sugar Free Vanilla Sticks