Changeset 10621

Timestamp:

Dec 11, 2006, 10:32:55 AM (19 years ago)

Author:

eugene

Message:

added forward/backward buttons; fixed table fields for pz tables

Location:

trunk/ippMonitor

Files:

• def/autocode.php (modified) (2 diffs)
• def/pzPendingExp.d (modified) (1 diff)
• def/pzPendingImfile.d (modified) (1 diff)
• raw/ipp.css (modified) (1 diff)
• raw/ipp.imfiles.dat (modified) (1 diff)
• raw/ipp.php (modified) (3 diffs)

trunk/ippMonitor/def/autocode.php

@@ -20 +20 @@
 echo "<p> $TITLE </p>";
 
+// set up the form
+echo "<form action=\"$FILE\" method=\"POST\">\n";
+
 // define restrictiosn to the queries
 // ** TABLE RESTRICTIONS **
 
+// get the result table count
+if ($WHERE) {
+  $sql = "SELECT count(*) FROM $TABLE WHERE $WHERE";
+} else {
+  $sql = "SELECT count(*) FROM $TABLE";
+}
+$qry = $db->query($sql);
+if (DB::iserror($db)) {
+  echo "<b>error reading $TABLE table count</b><br>\n";
+  menu_end();
+}
+if (!$qry->fetchInto($row)) {
+  echo "<b>error reading $TABLE table count</b><br>\n";
+  menu_end();
+}
+// set up the row counter variables
+if ($ID['from']) {
+  $rowStart = $ID['from'];
+} else {
+  $rowStart = 0;
+}
+$rowLast = $rowStart + $dTABLE;
+$rowTotal = $row[0];
+if ($rowLast > $rowTotal) { $rowLast = $rowTotal; }
+echo "<b> $rowStart to $rowLast of $rowTotal items</b><br>\n";
+
 // query the database
 if ($WHERE) {
-  $sql = "SELECT $FIELDS FROM $TABLE WHERE $WHERE LIMIT 40";
+  $sql = "SELECT $FIELDS FROM $TABLE WHERE $WHERE LIMIT $dTABLE OFFSET $rowStart";
 } else {
-  $sql = "SELECT $FIELDS FROM $TABLE LIMIT 40";
+  $sql = "SELECT $FIELDS FROM $TABLE LIMIT $dTABLE OFFSET $rowStart";
 }
 
@@ -38 +67 @@
 // ** HEAD CODE **
 
-// set up the table and form
-echo "<form action=\"$FILE\" method=\"POST\">\n";
+if ($rowStart > 0) {
+  $value = 0;
+  $link = "$FILE" . "?" . $ID['link'] . "&from=$value";
+  echo "<a width=10 class=\"button\" href=\"$link\">&#60&#60</a>\n";
+} else {
+  echo "&#60&#60\n";
+}
+if ($rowStart >= $dTABLE) {
+  $value = $rowStart - $dTABLE;
+  $link = "$FILE" . "?" . $ID['link'] . "&from=$value";
+  echo "<a class=\"button\" href=\"$link\">&#60</a>\n";
+} else {
+  echo "&#60\n";
+}
 
+if ($rowLast < $rowTotal) {
+  $value = $rowStart + $dTABLE;
+  $link = "$FILE" . "?" . $ID['link'] . "&from=$value";
+  echo "<a class=\"button\" href=\"$link\">&#62</a>\n";
+} else {
+  echo "&#62\n";
+}
+
+if ($rowLast < $rowTotal) {
+  $value = $rowTotal - $dTABLE;
+  $link = "$FILE" . "?" . $ID['link'] . "&from=$value";
+  echo "<a class=\"button\" href=\"$link\">&#62&#62</a>\n";
+} else {
+  echo "&#62&#62\n";
+}
+
+echo "&nbsp; : &nbsp; or enter start row: <input type=\"text\" name=\"from\" size=\"5\" value=\"$rowStart\">\n";
+
+// set up the table
 echo "<table class=list>\n";
 echo "<tr>\n";

trunk/ippMonitor/def/pzPendingExp.d

@@ -8 +8 @@
 FIELD    camera,        20,   camera
 FIELD    telescope,     20,   telescope
-FIELD    exp_type,      20,   type
-FIELD    imfiles,       20,   N files

trunk/ippMonitor/def/pzPendingImfile.d

@@ -8 +8 @@
 FIELD    camera,      20,   camera
 FIELD    telescope,   20,   telescope
-FIELD    bytes,       20,   number of bytes
-FIELD    md5sum,      20,   checksum
 FIELD    class,       20,   class
 FIELD    class_id,    20,   class ID 
-FIELD    uri,         20,   URI

trunk/ippMonitor/raw/ipp.css

@@ -9 +9 @@
 a:link, a:visited, a:active { text-decoration: underline; font-weight: bold; color: #ff0000 }
 
-a.menutop     { text-decoration: none; color: #ffffff; font-weight: bold }
-a.menutops    { text-decoration: none; color: #80f0ff; font-weight: bold }
-a.menuext     { text-decoration: none; color: #ffffff; font-weight: bold }
+a.button      { text-decoration: none; font-weight: bold;   color: #000000; background: #0080c0}
+a.menutop     { text-decoration: none; font-weight: bold;   color: #ffffff}
+a.menutops    { text-decoration: none; font-weight: bold;   color: #80f0ff}
+a.menuext     { text-decoration: none; font-weight: bold;   color: #ffffff}
 a.menulink    { text-decoration: none; font-weight: normal; color: #000000}
 a.menuselect  { text-decoration: none; font-weight: normal; color: #0000ff}

trunk/ippMonitor/raw/ipp.imfiles.dat

@@ -32 +32 @@
 menulink  | menuselect   | link    | detResidImfile               | detResidImfile.php            
 menulink  | menuselect   | link    | masterDetrendImfiles         | masterDetrendImfiles.php
-menulink  | menuselect   | link    | detMasterImfile              | detMasterImfile.php                   
 menulink  | menuselect   | link    | pzPendingImfile              | pzPendingImfile.php                   
 menulink  | menuselect   | link    | p2PendingImfile              | p2PendingImfile.php                   

trunk/ippMonitor/raw/ipp.php

@@ -1 +1 @@
 <?php
+
+$dTABLE = 40;
 
 function logintext () {
@@ -126 +128 @@
     $ID['proj'] = $_GET[proj];
     $ID['menu'] = $_GET[menu];
+    $ID['from'] = $_GET[from];
 
     if ($VERBOSE) {
@@ -139 +142 @@
     $ID['proj'] = $_POST[proj];
     $ID['menu'] = $_POST[menu];
+    $ID['from'] = $_POST[from];
 
     if ($VERBOSE) {