Collection Branch
Select Collection Location
0 && (time() - filemtime($txtFile)) < 86400) {
echo file_get_contents($txtFile);
return;
}
// Otherwise rebuild from database
$envFile = __DIR__ . '/.env';
if (!file_exists($envFile)) {
error_log("selectone.php: .env file not found at $envFile");
return;
}
$env = [];
foreach (file($envFile, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES) as $line) {
$line = trim($line);
if ($line === '' || $line[0] === '#') continue;
if (strpos($line, '=') === false) continue;
list($key, $value) = explode('=', $line, 2);
$env[trim($key)] = trim($value);
}
$conn = new mysqli($env['DB_HOST'] ?? '', $env['DB_USER'] ?? '', $env['DB_PASS'] ?? '', $env['DB_NAME'] ?? '');
if ($conn->connect_error) {
error_log("selectone.php: DB connection failed - " . $conn->connect_error);
return;
}
$sql = "SELECT bs.branchid, bs.branchname, c.country AS country_name
FROM branchessummary bs
LEFT JOIN countries c ON bs.db = c.code COLLATE utf8mb4_general_ci
WHERE bs.brand = 'Zezgo'
AND bs.branchid IS NOT NULL
AND bs.branchname IS NOT NULL
AND c.country IS NOT NULL
ORDER BY c.country ASC, bs.branchname ASC";
$result = $conn->query($sql);
if (!$result) {
error_log("selectone.php: Query failed - " . $conn->error);
$conn->close();
return;
}
if ($result->num_rows === 0) {
error_log("selectone.php: Query returned 0 rows for brand=Zezgo");
$conn->close();
return;
}
$countries = [];
while ($rowxx = $result->fetch_assoc()) {
$country = strtoupper(trim($rowxx['country_name']));
$countries[$country][] = $rowxx;
}
$conn->close();
$html = '';
foreach ($countries as $country => $branches) {
$html .= '' . "\n";
foreach ($branches as $b) {
$html .= '' . htmlspecialchars($b['branchname']) . ' ' . "\n";
}
$html .= ' ' . "\n";
}
// Only cache if we actually got content
if (!empty($html)) {
file_put_contents($txtFile, $html);
}
echo $html;
Drop-Off Location:
Select Drop-Off Location
0 && (time() - filemtime($txtFile)) < 86400) {
echo file_get_contents($txtFile);
return;
}
// Otherwise rebuild from database
$envFile = __DIR__ . '/.env';
if (!file_exists($envFile)) {
error_log("selectone.php: .env file not found at $envFile");
return;
}
$env = [];
foreach (file($envFile, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES) as $line) {
$line = trim($line);
if ($line === '' || $line[0] === '#') continue;
if (strpos($line, '=') === false) continue;
list($key, $value) = explode('=', $line, 2);
$env[trim($key)] = trim($value);
}
$conn = new mysqli($env['DB_HOST'] ?? '', $env['DB_USER'] ?? '', $env['DB_PASS'] ?? '', $env['DB_NAME'] ?? '');
if ($conn->connect_error) {
error_log("selectone.php: DB connection failed - " . $conn->connect_error);
return;
}
$sql = "SELECT bs.branchid, bs.branchname, c.country AS country_name
FROM branchessummary bs
LEFT JOIN countries c ON bs.db = c.code COLLATE utf8mb4_general_ci
WHERE bs.brand = 'Zezgo'
AND bs.branchid IS NOT NULL
AND bs.branchname IS NOT NULL
AND c.country IS NOT NULL
ORDER BY c.country ASC, bs.branchname ASC";
$result = $conn->query($sql);
if (!$result) {
error_log("selectone.php: Query failed - " . $conn->error);
$conn->close();
return;
}
if ($result->num_rows === 0) {
error_log("selectone.php: Query returned 0 rows for brand=Zezgo");
$conn->close();
return;
}
$countries = [];
while ($rowxx = $result->fetch_assoc()) {
$country = strtoupper(trim($rowxx['country_name']));
$countries[$country][] = $rowxx;
}
$conn->close();
$html = '';
foreach ($countries as $country => $branches) {
$html .= '' . "\n";
foreach ($branches as $b) {
$html .= '' . htmlspecialchars($b['branchname']) . ' ' . "\n";
}
$html .= ' ' . "\n";
}
// Only cache if we actually got content
if (!empty($html)) {
file_put_contents($txtFile, $html);
}
echo $html;
