Changeset 10621 for trunk/ippMonitor/def/autocode.php

Timestamp:

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

Author:

eugene

Message:

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

File:

• trunk/ippMonitor/def/autocode.php (modified) (2 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";