Exemple #1
0
    }
    return $village_name;
}
function convertTownName($county_id, $year, $town_name)
{
    global $town_name_map;
    $county_id = convertCountyId($county_id, $year);
    if ($town_name_map[$county_id][$town_name]) {
        return $town_name_map[$county_id][$town_name];
    }
    return $town_name;
}
$i = new Importer();
$meta = array('license' => 'CC0', 'source' => 'http://ecolife.epa.gov.tw/ https://github.com/ronnywang/ecolife.epa.gov.tw', 'period' => 'monthly', '處理程式' => 'https://github.com/sheethub/data-import-script/tree/master/ecolife.epa.gov.tw');
foreach (array(2015) as $year) {
    $i->newSheet("/ecolife.epa.gov.tw/{$year}-縣市用電量", array('月份', '縣市代碼', '縣市名稱', '用電量'), $meta);
    $i->newSheet("/ecolife.epa.gov.tw/{$year}-鄉鎮用電量", array('月份', '縣市代碼', '縣市名稱', '鄉鎮代碼', '鄉鎮名稱', '用電量'), $meta);
    $i->newSheet("/ecolife.epa.gov.tw/{$year}-村里用電量", array('月份', '縣市代碼', '縣市名稱', '鄉鎮代碼', '鄉鎮名稱', '村里名稱', '用電量'), $meta);
    for ($month = 1; $month <= 12; $month++) {
        error_log("{$year}/{$month}");
        $curl = curl_init("https://raw.githubusercontent.com/ronnywang/ecolife.epa.gov.tw/master/outputs/town/{$year}-{$month}.csv");
        curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
        $content = curl_exec($curl);
        $info = curl_getinfo($curl);
        if (200 == $info['http_code']) {
            foreach (explode("\n", trim($content)) as $line) {
                list($county_id, $county_name, $town_id, $town_name, , $total) = explode(',', trim($line));
                if ($town_id) {
                    $i->insertData("/ecolife.epa.gov.tw/{$year}-鄉鎮用電量", array($month, convertCountyId($county_id, $year), $county_name, convertTownId($town_id, $year), convertTownName($county_id, $year, $town_name), $total), array(0, 3));
                } elseif ('總計' == $town_name) {
                    $i->insertData("/ecolife.epa.gov.tw/{$year}-縣市用電量", array($month, convertCountyId($county_id, $year), $county_name, $total), array(0, 1));