1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 | <?php include('template.inc.php'); include_header_documents(""); include_once('../include/common.inc.php'); echo "<table> <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; $yellow = 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 "<tr><td>"; if (isset($row->value->website)) echo "<a href='" . $row->value->website . "'>"; echo "<b>" . $row->value->name . "</b>"; if (isset($row->value->website)) echo "</a>"; 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") echo '<br><small>(<a href="viewDocument.php?hash=' . md5($row->value->FOIDocumentsURL) . '">' . 'view local copy</a>)</small>'; } else { echo "<font color='red'><abbr title='No'>✘</abbr></font>"; } echo "</td>\n<td>"; if (isset($row->value->FOIDocumentsURL)) { if (file_exists("./scrapers/" . $row->id . '.py')) { echo "<font color='green'><abbr title='Yes'>✔</abbr></font>"; $green++; } else if (file_exists("./scrapers/" . $row->id . '.txt')) { if (trim(file_get_contents("./scrapers/" . $row->id . '.txt')) == "no disclog") { echo "<font color='yellow'><abbr title='No log table exists at URL to scrape'><b>◎</b></abbr></font>"; $yellow++; } else { echo file_get_contents("./scrapers/" . $row->id . '.txt'); echo "<font color='orange'><abbr title='Work in progress'><b>▬</b></abbr></font>"; $orange++; } } else { echo "<font color='red'><abbr title='No'>✘</abbr></font>"; $red++; } } echo "</td></tr>\n"; } } } } catch (SetteeRestClientException $e) { setteErrorHandler($e); } echo "</table>"; 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(); ?> |