kindlecsv2scrapbox.php

<?php
function rowToString(array $row)
{
    $amzn = '[link http://amazon.jp/dp/' . $row[0] . ']';
    $title = str_replace('[',' ',str_replace(']',' ',$row[1]));
    $author = $row[2];
    $d = strtotime($row[3]);
    $ym = date('Y-m',$d);
    $ymd = date('Y-m-d',$d);
    $v = " [" . $title . "] $amzn [" . $author . "]";
    return [$ym,$ymd,$v];
}

$handle = fopen("Kindle.csv", "r");
$books = [];
while (($data = fgetcsv($handle))) {
    [$ym,$ymd,$v] = rowToString($data);
    if ($ym !== '1970-01')
    $books[$ym][$ymd][] = $v;
}
ksort($books);

$pages = [];
foreach ($books as $ym => $ymbooks) {
    $title = 'Kindle::' . $ym;
    $lines = [$title];
    ksort($ymbooks);
    foreach ($ymbooks as $ymd => $ymdbooks) {
        $lines[] = '[' . $ymd . ']';
        foreach ($ymdbooks as $b) {
            $lines[] = $b;
        }
        $lines[] = "";
    }
    $lines[] = '[Kindle]';
    $lines[] = '[Kindle::' . substr($ym,0,4) . ']';
    $page['title'] = $title;
    $page['lines'] = $lines;
    $pages[] = $page;
}
echo json_encode(['pages' => $pages]);