Changeset 27856 for trunk/ippTools/share/pstamptool_pendingdependent.sql

Timestamp:

May 4, 2010, 10:50:29 AM (16 years ago)

Author:

bills

Message:

Add table Label which through priority column may be used to order
items pending for processing.
Implement usage of this table in the pstamptool pending modes and
chiptool -pendingimfile.
Various other postage stamp changes including adding pstampDependent.outdir

File:

• trunk/ippTools/share/pstamptool_pendingdependent.sql (modified) (1 diff)

trunk/ippTools/share/pstamptool_pendingdependent.sql

@@ -1 @@
-SELECT DISTINCT pstampDependent.*
+SELECT DISTINCT pstampDependent.*,
+    IFNULL(Label.priority, 10000) AS priority
 FROM pstampDependent
 JOIN pstampJob USING(dep_id)
 JOIN pstampRequest USING(req_id)
+JOIN Label ON pstampRequest.label = Label.label
 WHERE pstampDependent.state = 'new'
     AND pstampDependent.fault = 0
     AND pstampJob.state = 'run'
     AND pstampRequest.state = 'run'
+    AND (Label.active OR Label.active IS NULL)