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

Timestamp:

May 30, 2007, 6:13:58 PM (19 years ago)

Author:

eugene

Message:

various updates to the user interface: sorting, respect table selections, etc

File:

• trunk/ippMonitor/def/autocode.php (modified) (5 diffs)

trunk/ippMonitor/def/autocode.php

@@ -27 +27 @@
 
 // get the result table count
-if ($WHERE) {
-  $sql = "SELECT count(*) FROM $TABLE WHERE $WHERE";
-} else {
-  $sql = "SELECT count(*) FROM $TABLE";
-}
+$sql = "SELECT count(*) FROM $TABLE $WHERE";
+
 $qry = $db->query($sql);
 if (DB::iserror($db)) {
@@ -53 +50 @@
 
 // query the database
-if ($WHERE) {
-  $sql = "SELECT $FIELDS FROM $TABLE WHERE $WHERE LIMIT $dTABLE OFFSET $rowStart";
-} else {
-  $sql = "SELECT $FIELDS FROM $TABLE LIMIT $dTABLE OFFSET $rowStart";
-}
+$sql = "SELECT $FIELDS FROM $TABLE $WHERE LIMIT $dTABLE OFFSET $rowStart";
 
 $qry = $db->query($sql);
@@ -67 +60 @@
 // ** HEAD CODE **
 
-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";
-}
+// ** BUTTON RESTRICTIONS **
+navigate_buttons ($rowStart, $rowLast, $dTABLE, $rowTotal, $buttonLink, $ID, '$FILE');
 
 echo "&nbsp; : &nbsp; or enter start row: <input type=\"text\" name=\"from\" size=\"5\" value=\"$rowStart\">\n";
@@ -104 +69 @@
 echo "<tr>\n";
 // ** TABLE HEADER **
-// echo "<th class=list> FIELD </th>\n";
 echo "</tr>\n";
 
@@ -117 +81 @@
   // $link = "$FILE" . "?expID=" . $row[0] . "&" . $ID['link'];
 
+  $class = "list";
+  // ** TD CLASS **
+
   echo "<tr>\n";
   // ** TABLE DATA **
-  // echo "<td class=list><a href=\"$link\"> $row[0] </a></td>\n";
-  // echo "<td class=list> $row[1] </td>\n";
   echo "</tr>\n";
 }