mo scrapers and apsc2012 imoort
[disclosr.git] / documents / disclogsList.php
blob:a/documents/disclogsList.php -> blob:b/documents/disclogsList.php
--- a/documents/disclogsList.php
+++ b/documents/disclogsList.php
@@ -1,7 +1,7 @@
 <?php
 
 include('template.inc.php');
-include_header_documents("");
+include_header_documents("List of Disclosure Logs");
 include_once('../include/common.inc.php');
 
 echo "<table>
@@ -12,6 +12,7 @@
 $disclogs = 0;
 $red = 0;
 $green = 0;
+$yellow = 0;
 $orange = 0;
 try {
     $rows = $agenciesdb->get_view("app", "byCanonicalName", null, true)->rows;
@@ -33,10 +34,10 @@
                 if (isset($row->value->FOIDocumentsURL)) {
                     $disclogs++;
                     echo '<a href="' . $row->value->FOIDocumentsURL . '">'
-                    . $row->value->FOIDocumentsURL . '</a>';
+                        . $row->value->FOIDocumentsURL . '</a>';
                     if ($ENV == "DEV")
                         echo '<br><small>(<a href="viewDocument.php?hash=' . md5($row->value->FOIDocumentsURL) . '">'
-                        . 'view local copy</a>)</small>';
+                            . 'view local copy</a>)</small>';
                 } else {
                     echo "<font color='red'><abbr title='No'>✘</abbr></font>";
                 }
@@ -46,8 +47,14 @@
                         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++;
+                        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++;
@@ -62,7 +69,7 @@
 }
 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 ";
+    . 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();
 ?>