--- a/documents/disclogsList.php +++ b/documents/disclogsList.php @@ -8,6 +8,11 @@ <tr><th>Agency Name</th><th>Disclosure Log URL recorded?</th><th>Do we monitor this URL?</th></tr>"; $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; @@ -19,10 +24,11 @@ if ($ENV == "DEV") echo "<br>(" . $row->id . ")"; echo "</td>\n"; - +$agencies++; echo "<td>"; if (isset($row->value->FOIDocumentsURL)) { + $disclogs++; echo '<a href="' . $row->value->FOIDocumentsURL . '">' . $row->value->FOIDocumentsURL . '</a>'; if ($ENV == "DEV") @@ -35,10 +41,13 @@ if (isset($row->value->FOIDocumentsURL)) { if (file_exists("./scrapers/" . $row->id . '.py')) { echo "<font color='green'>✔</font>"; + $green++; } else if (file_exists("./scrapers/" . $row->id . '.txt')) { echo "<font color='orange'><b>▬</b></font>"; + $orange++; } else { echo "<font color='red'>✘</font>"; + $red++; } } echo "</td></tr>\n"; @@ -48,6 +57,8 @@ setteErrorHandler($e); } echo "</table>"; +echo $agencies." agencies ".(($disclogs/$agencies)*100)."% with disclosure logs, ".(($green/$disclogs)*100)."% with scrapers ".(($red/$disclogs)*100)."% without scrapers ".(($orange/$disclogs)*100)."% WIP scrapers "; + include_footer_documents(); ?>