Changeset 32564

Timestamp:

Oct 20, 2011, 3:57:55 PM (15 years ago)

Author:

rhenders

Message:

added hack to count 'update' and well as 'new'. This is mainly to show accurate stats for LAP processing

File:

• trunk/ippMonitor/czartool/czartool/Gpc1Db.pm (modified) (2 diffs)

trunk/ippMonitor/czartool/czartool/Gpc1Db.pm

@@ -233 +233 @@
 
     }
-    else {
+    # 'new' stuff really includes 'update' stuff, at least for LAP. This is a hack, but there you go    
+    elsif ($state eq "new") {
 
         $query = $self->{_db}->prepare(<<SQL);
@@ -239 +240 @@
             FROM $table 
             WHERE label LIKE '$label' 
-            AND state = '$state'
+            AND (state = 'new' OR state = 'update')
+SQL
+    }
+    else {
+
+        $query = $self->{_db}->prepare(<<SQL);
+        SELECT COUNT(state)  
+            FROM $table 
+            WHERE label LIKE '$label' 
+            AND state = 'new'
 SQL
     }