X-Git-Url: https://harishankar.org/repos/?p=habeas.git;a=blobdiff_plain;f=src%2Fhabeas%2FUtility.java;fp=src%2Fhabeas%2FUtility.java;h=d54ace3098ba2ba47f7bcc552df89bb7e29baa3e;hp=8795204463730b08014ff741371333ca28b931c8;hb=bc2309fb0a6c83daa94320d06619c1f8b153696c;hpb=020bf95644b2f26d9c81d66d2a752e55bcd3ad5b

diff --git a/src/habeas/Utility.java b/src/habeas/Utility.java
index 8795204..d54ace3 100644
--- a/src/habeas/Utility.java
+++ b/src/habeas/Utility.java
@@ -30,7 +30,16 @@ public class Utility {
     
             "SELECT ReferenceNumber, Description, SentDate, RPADReference, "
             + "ClientName FROM legalnotices INNER JOIN clients ON ClientId=clients.id"
-            + " WHERE NoticeSent=1 AND NoticeDelivered=0;"
+            + " WHERE NoticeSent=1 AND NoticeDelivered=0;",
+            
+            "SELECT ReferenceNumber, Description, EntrustmentDate, ClientName FROM legalnotices"
+            + " INNER JOIN clients ON ClientId=clients.id"
+            + " WHERE DraftCreated=1 AND DraftApproved=0;",
+            
+            "SELECT ReferenceNumber, Description, EntrustmentDate, "
+            + "ClarificationRemarks, ClientName FROM legalnotices INNER JOIN clients ON"
+            + " ClientId=clients.id WHERE ClarificationPending=1;"
+            
     } ;
 
     private static final String[] REPORTS_FILTERED = { "SELECT ReferenceNumber, Description"
@@ -40,7 +49,15 @@ public class Utility {
     
             "SELECT ReferenceNumber, Description, SentDate, RPADReference, "
             + "ClientName FROM legalnotices INNER JOIN clients ON ClientId=clients.id"
-            + " WHERE NoticeSent=1 AND NoticeDelivered=0 AND ClientId=?;"
+            + " WHERE NoticeSent=1 AND NoticeDelivered=0 AND ClientId=?;",
+            
+            "SELECT ReferenceNumber, Description, EntrustmentDate, ClientName FROM legalnotices"
+            + " INNER JOIN clients ON ClientId=clients.id"
+            + " WHERE DraftCreated=1 AND DraftApproved=0 AND ClientId=?;",
+
+            "SELECT ReferenceNumber, Description, EntrustmentDate, "
+            + "ClarificationRemarks, ClientName FROM legalnotices INNER JOIN clients ON"
+            + " ClientId=clients.id WHERE ClarificationPending=1 AND ClientId=?;"            
     } ;    
     
     static void saveStationerySettings (String left_header,