check.php

<?php

$fp = fopen('input.csv', 'r');
$column = fgetcsv($fp);

$output = fopen('php://output', 'w');
fputcsv($output, array(
    '名稱', '版本', '議案代碼', '現行條文', '修正條文', '說明',
));

while ($row = fgetcsv($fp)) {
    list($date, $name, $proposal, $status) = $row;
    if (!$date) {
        continue;
    }

    // 先用 /api/searchbill API 去抓取最有可能的議案
    // (檢查議案名稱和提案人都符合，如果符合多筆的話，抓跟提案日期最近的)
    $obj = json_decode(file_get_contents("https://openly.muyueh.com/api/searchbill?q=" . urlencode($name)));
    $proposal = explode(' ; ', $proposal);
    $proposal[0] = str_replace('黨團', '立法院黨團', $proposal[0]);
    $billno = false;
    $hitbill = array();
    foreach ($obj->result->hits->hits as $hit) {
        if (strpos($hit->_source->{'提案人'}, $proposal[0]) !== false) {
            $d = abs($row[0] - substr($hit->_id, 0, 7));
            $hitbill[$hit->_id] = $d;
        }
    }
    asort($hitbill);
    if (!$hitbill) {
        print_r($row);
        exit;
    }

    // 把搜尋到的議案代碼存入 $bills 中，開始處理
    $billno = array_keys($hitbill)[0];
    $showed_bills = new StdClass;
    $bills = array();
    $bills[] = $billno;
    $showed_bills->{$billno} = true;


    // 處理 $bills ，如果有讀到關連議案就塞進去 $bills 中
    while ($bills) {
        $billno = array_pop($bills);
        // 用 /api/bill API 抓取單一議案詳情
        $obj = json_decode(file_get_contents("https://openly.muyueh.com/api/bill/" . $billno));

        // 處理關連議案
        foreach ($obj->data->related as $related) {
            if (!property_exists($showed_bills, $related[0])) {
                $showed_bills->{$related[0]} = true;
                $bills[] = $related[0];
            }
        }

        // 如果沒有 content 表示程式沒抓到法律對照表
        if (!property_exists($obj->data, 'content')) {
                foreach ($law_content->content as $content) {
                    fputcsv($output, array(
                        $row[1],
                        $obj->proposed_by,
                        $billno,
                        '找不到條文內容',
                        '',
                        '',
                    ));
                }
            continue;
        }

        // 輸出條文對照表
        //'名稱', '版本', '議案代碼', '現行條文', '修正條文', '說明',
        foreach ($obj->data->content as $law_content) {
            if ($law_content->type == '修正條文' or $law_content->type == '審查會版本') {
                if ($law_content->type == '審查會版本') {
                    $obj->proposed_by = '審查會版';
                }
                foreach ($law_content->content as $content) {
                    fputcsv($output, array(
                        $row[1],
                        $obj->proposed_by,
                        $billno,
                        $content[0],
                        $content[1],
                        $content[2],
                    ));
                }
            } else if ($law_content->type == '增訂條文' or $law_content->type == '制定條文') {
                foreach ($law_content->content as $content) {
                    fputcsv($output, array(
                        $row[1],
                        $obj->proposed_by,
                        $billno,
                        '',
                        $content[0],
                        $content[1],
                    ));
                }

            } else {
                print_r($law_content);
                exit;
            }
        }
    }

}

input.csv