--- a/documents/disclogsList.php +++ b/documents/disclogsList.php @@ -1,4 +1,5 @@ <?php + include('template.inc.php'); include_header_documents(""); include_once('../include/common.inc.php'); @@ -7,38 +8,62 @@ <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; 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 "<tr><td><b>" . $row->value->name . "</b> (".$row->id.")</td>\n"; - - echo "<td>"; - if (isset($row->value->FOIDocumentsURL)) { - echo '<a href="viewDocument.php?hash='.md5($row->value->FOIDocumentsURL).'">' - .$row->value->FOIDocumentsURL.'</a>'; - } else { - echo "<font color='red'>✘</font>"; + 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')) { + 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"; } - echo "</td>\n<td>"; - if (isset($row->value->FOIDocumentsURL)) { - if (file_exists("./scrapers/".$row->id.'.py')) { - echo "<font color='green'>✔</font>"; - } else if (file_exists("./scrapers/".$row->id.'.txt')){ - echo "<font color='blue'><b>▬</b></font>"; - } else { - echo "<font color='red'>✘</font>"; - } - } - 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(); ?> +