<?php |
<?php |
|
|
require_once '../include/common.inc.php'; |
require_once '../include/common.inc.php'; |
|
|
$db = $server->get_db('disclosr-agencies'); |
$db = $server->get_db('disclosr-agencies'); |
$rows = $db->get_view("app", "byName")->rows; |
$rows = $db->get_view("app", "byName")->rows; |
$nametoid = Array(); |
$nametoid = Array(); |
$sums = Array(); |
$sums = Array(); |
foreach ($rows as $row) { |
foreach ($rows as $row) { |
$nametoid[trim($row->key)] = $row->value; |
$nametoid[trim($row->key)] = $row->value; |
} |
} |
$employeeCSVs = Array("2002-2003" => "0203apsemployees.csv", |
$employeeCSVs = Array("2002-2003" => "0203apsemployees.csv", |
"2003-2004" => "0304apsemployees.csv", |
"2003-2004" => "0304apsemployees.csv", |
"2004-2005" => "0405apsemployees.csv", |
"2004-2005" => "0405apsemployees.csv", |
"2005-2006" => "0506apsemployees.csv", |
"2005-2006" => "0506apsemployees.csv", |
"2006-2007" => "0607apsemployees.csv", |
"2006-2007" => "0607apsemployees.csv", |
"2007-2008" => "0708apsemployees.csv", |
"2007-2008" => "0708apsemployees.csv", |
"2008-2009" => "0809apsemployees.csv", |
"2008-2009" => "0809apsemployees.csv", |
"2009-2010" => "0910apsemployees.csv", |
"2009-2010" => "0910apsemployees.csv", |
"2010-2011" => "1011apsemployees.csv" |
"2010-2011" => "1011apsemployees.csv" |
); |
); |
foreach ($employeeCSVs as $timePeriod => $employeeCSV) { |
foreach ($employeeCSVs as $timePeriod => $employeeCSV) { |
echo $employeeCSV . "<br>" . PHP_EOL; |
echo $employeeCSV . "<br>" . PHP_EOL; |
$row = 1; |
$row = 1; |
if (($handle = fopen($employeeCSV, "r")) !== FALSE) { |
if (($handle = fopen($employeeCSV, "r")) !== FALSE) { |
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { |
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { |
//print_r($data); |
//print_r($data); |
$name = trim($data[0]); |
$name = trim($data[0]); |
if (isset($nametoid[$name])) { |
if (isset($nametoid[$name])) { |
$id = $nametoid[$name]; |
$id = $nametoid[$name]; |
//echo $id . "<br>" . PHP_EOL; |
//echo $id . "<br>" . PHP_EOL; |
@$sums[$id][$timePeriod] += $data[1]; |
@$sums[$id][$timePeriod] += $data[1]; |
} else { |
} else { |
echo "<br>ERROR NAME MISSING FROM ID LIST<br><bR>" . PHP_EOL; |
echo "<br>ERROR NAME MISSING FROM ID LIST<br><bR>" . PHP_EOL; |
|
|
die(); |
die(); |
|
|
} |
} |
} |
} |
fclose($handle); |
fclose($handle); |
} |
} |
} |
} |
foreach ($sums as $id => $sum) { |
foreach ($sums as $id => $sum) { |
echo $id. "<br>" . PHP_EOL; |
echo $id . "<br>" . PHP_EOL; |
$doc = $db->get($id); |
$doc = $db->get($id); |
// print_r($doc); |
echo $doc->name . "<br>" . PHP_EOL; |
if (isset($doc->statistics)) $doc->statistics = Array(); |
// print_r($doc); |
|
$changed = false; |
|
if (!isset($doc->statistics)) { |
|
$changed = true; |
|
$doc->statistics = new stdClass(); |
|
} |
|
if (!isset($doc->statistics->employees)) { |
|
$changed = true; |
|
$doc->statistics->employees = new stdClass(); |
|
} |
foreach ($sum as $timePeriod => $value) { |
foreach ($sum as $timePeriod => $value) { |
$doc->statistics["employees"][$timePeriod] = Array("value"=>$value, "source"=>"http://apsc.gov.au/stateoftheservice/"); |
if (!isset($doc->statistics->employees->$timePeriod->value) |
|
|| $doc->statistics->employees->$timePeriod->value != $value) { |
|
$changed = true; |
|
$doc->statistics->employees->$timePeriod = Array("value" => $value, "source" => "http://apsc.gov.au/stateoftheservice/"); |
|
} |
} |
} |
$db->save($doc); |
if ($changed) { |
|
$db->save($doc); |
|
} else { |
|
echo "not changed" . "<br>" . PHP_EOL; |
|
} |
} |
} |
// employees: timeperiod, source = apsc state of service, value |
// employees: timeperiod, source = apsc state of service, value |
?> |
?> |
|
|