無燒燙傷病房的有急診醫院

code.php

<?php

$sql = "SELECT * FROM this WHERE 病床名稱 = '燒傷病床' AND  (City = '臺北市' OR City = '桃園市' OR City = '新北市')";
$url = 'https://sheethub.com/clementtang/醫事機構病床類別與床數資料?sql=' . urlencode($sql) . '&format=array_json';
$hospitals = json_decode(file_get_contents($url));
$skip = array();
foreach ($hospitals as $h) {
    $skip["{$h->City},{$h->Area},{$h->Name},{$h->Zone}"] = true;
}

$sql = "SELECT * FROM this WHERE \"Department Name\" = '急診醫學科' AND (City = '臺北市' OR City = '桃園市' OR City = '新北市
')";
$url = 'https://sheethub.com/clementtang/醫事機構診療科別資料?sql=' . urlencode($sql) . '&format=array_json';
$hospitals = json_decode(file_get_contents($url));
$output = fopen('php://output', 'w');
fputcsv($output, array_keys((array)$hospitals[0]));
foreach ($hospitals as $h) {
    // 有燒燙傷病房的濾掉=
    if ($skip["{$h->City},{$h->Area},{$h->Name},{$h->Zone}"]) {
        continue;
    }
    fputcsv($output, array_values((array)$h));
}

list.csv