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

Timestamp:

Aug 31, 2008, 12:42:45 PM (18 years ago)

Author:

eugene

Message:

adding summary pages, mods to generate and ipp.php to support summary pages

File:

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

trunk/ippMonitor/def/autocode.php

@@ -27 +27 @@
 
 // get the result table count
-$sql = "SELECT count(*) FROM $TABLE $WHERE";
+if ($MODE == "basic") {
+  $sql = "SELECT count(*) FROM $TABLE $WHERE";
+}
+if ($MODE == "summary") {
+  $sql = "SELECT count(*) FROM (SELECT $FIELDS FROM $TABLE $WHERE) as TEMP";
+}
 
 $qry = $db->query($sql);
@@ -52 +57 @@
 
 // query the database
-$sql = "SELECT $FIELDS FROM $TABLE $WHERE LIMIT $dTABLE OFFSET $rowStart";
+if ($MODE == "basic") {
+  $sql = "SELECT $FIELDS FROM $TABLE $WHERE LIMIT $dTABLE OFFSET $rowStart";
+}
+if ($MODE == "summary") {
+  $sql = "SELECT $FIELDS FROM $TABLE $WHERE LIMIT $dTABLE OFFSET $rowStart";
+}
 
 $qry = $db->query($sql);