--- a/documents/disclogsList.php
+++ b/documents/disclogsList.php
@@ -8,45 +8,62 @@
Agency Name | Disclosure Log URL recorded? | Do we monitor this URL? |
";
$agenciesdb = $server->get_db('disclosr-agencies');
$docsdb = $server->get_db('disclosr-documents');
+$agencies = 0;
+$disclogs = 0;
+$red = 0;
+$green = 0;
+$orange = 0;
try {
$rows = $agenciesdb->get_view("app", "byCanonicalName", null, true)->rows;
if ($rows) {
foreach ($rows as $row) {
+ if ((!isset($row->value->status) || $row->value->status != "suspended") && isset($row->value->foiEmail)) {
+ echo "";
+ if (isset($row->value->website)) echo "";
+ echo "" . $row->value->name . "";
+ if (isset($row->value->website)) echo "";
+ if ($ENV == "DEV")
+ echo " (" . $row->id . ")";
+ echo " | \n";
+ $agencies++;
- echo "
" . $row->value->name . "";
- if ($ENV == "DEV")
- echo " (" . $row->id . ")";
- echo " | \n";
-
-
- echo "";
- if (isset($row->value->FOIDocumentsURL)) {
- echo ''
- . $row->value->FOIDocumentsURL . '';
- if ($ENV == "DEV")
- echo ' ('
- . 'view local copy)';
- } else {
- echo "✘";
+ echo " | ";
+ if (isset($row->value->FOIDocumentsURL)) {
+ $disclogs++;
+ echo ''
+ . $row->value->FOIDocumentsURL . '';
+ if ($ENV == "DEV")
+ echo ' ('
+ . 'view local copy)';
+ } else {
+ echo "✘";
+ }
+ echo " | \n";
+ if (isset($row->value->FOIDocumentsURL)) {
+ if (file_exists("./scrapers/" . $row->id . '.py')) {
+ echo "✔";
+ $green++;
+ } else if (file_exists("./scrapers/" . $row->id . '.txt')) {
+ echo "▬";
+ $orange++;
+ } else {
+ echo "✘";
+ $red++;
+ }
+ }
+ echo " |
\n";
}
- echo "\n";
- if (isset($row->value->FOIDocumentsURL)) {
- if (file_exists("./scrapers/" . $row->id . '.py')) {
- echo "✔";
- } else if (file_exists("./scrapers/" . $row->id . '.txt')) {
- echo "▬";
- } else {
- echo "✘";
- }
- }
- echo " | \n";
}
}
} catch (SetteeRestClientException $e) {
setteErrorHandler($e);
}
echo "";
+echo $agencies . " agencies, " . round(($disclogs / $agencies) * 100) . "% with disclosure logs; "
+ . round(($green / $disclogs) * 100) . "% logs with scrapers " . round(($red / $disclogs) * 100) . "% logs without scrapers " . round(($orange / $disclogs) * 100) . "% logs Work-In-Progress scrapers ";
+
include_footer_documents();
?>
+