| <?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 = Array(); | |
| } | |
| 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 |
| ?> | ?> |