get_db('disclosr-agencies');
$rows = $db->get_view("app", "byName")->rows;
$nametoid = Array();
$stats = Array();
foreach ($rows as $row) {
$nametoid[trim($row->key)] = $row->value;
}
$row = 0;
$headers = Array();
// source: http://data.gov.au/dataset/freedom-of-information-quarterly-request-and-review-statistical-data-2011-12/
if (($handle = fopen("FOI-quarterly-requests-and-reviews-2011-12.csv", "r")) !== FALSE) {
while (($data = fgetcsv($handle, 10000, ",")) !== FALSE) {
if ($row >= 1) {
// print_r($data);
$name = trim($data[2]);
// echo "$name
";
if ($data[0] != "TOTALS" && $data[0] != "") {
if (isset($nametoid[$name])) {
$id = $nametoid[$name];
$timePeriod = $data[0] . "-Q" . $data[1];
// echo "$timePeriod
";
unset($data[0]);
unset($data[1]);
unset($data[2]);
unset($data[3]);
unset($data[4]);
unset($data[5]);
unset($data[6]);
unset($data[7]);
unset($data[8]);
//echo $id . "
" . PHP_EOL;
$result = Array("source" => "http://data.gov.au/dataset/freedom-of-information-quarterly-request-and-review-statistical-data-2011-12/");
foreach ($data as $key => $datum) {
if ($datum != 0) {
// tODO prefix header with "FOI"
if (isset($stats[$id][$timePeriod][$key])) $datum += $stats[$id][$timePeriod][$key];
$result[trim($headers[$key])] = $datum;
}
}
$stats[$id][$timePeriod] = $result;
// TODO merge if already exists
//print_r($stats);
} else {
echo "
ERROR NAME MISSING FROM ID LIST
$row" . PHP_EOL;
print_r($data);
die();
}
}
} else {
$headers = $data;
//print_r($headers);
}
$row++;
}
fclose($handle);
}
echo "all stats loaded successfuly";
foreach ($stats as $id => $stat) {
echo $id . "
" . PHP_EOL;
$doc = $db->get($id);
echo $doc->name . "
" . PHP_EOL;
// print_r($stat);
// print_r($doc);
$changed = false;
if (!isset($doc->statistics)) {
$changed = true;
$doc->statistics = Array();
} else {
$doc->statistics = object_to_array($doc->statistics);
}
foreach ($stat as $timePeriod => $value) {
if (!isset($doc->statistics["foiRequests"][$timePeriod])
|| $doc->statistics["foiRequests"][$timePeriod] != $value
) {
$changed = true;
$doc->statistics["foiRequests"][$timePeriod] = $value;
}
}
if ($changed) {
$db->save($doc);
} else {
echo "not changed" . "
" . PHP_EOL;
}
//print_r($doc);die();
}
?>