X-Git-Url: https://harishankar.org/repos/?p=habeas.git;a=blobdiff_plain;f=src%2Fhabeas%2FUtility.java;h=8602583be2c111cf3a72cb3b5406c62782929847;hp=9df1ab54efd52ddafe63aac7c62152e522092a8d;hb=703ad2090595c7cf19f92a58b95ce197c60bf5ea;hpb=03c3270b01ae96bebc93917ec9c987ec5a0dd799

diff --git a/src/habeas/Utility.java b/src/habeas/Utility.java
index 9df1ab5..8602583 100644
--- a/src/habeas/Utility.java
+++ b/src/habeas/Utility.java
@@ -42,7 +42,11 @@ public class Utility {
             
             "SELECT ReferenceNumber, Description, EntrustmentDate, ClarificationRemarks"
             + ", ClientName from legalnotices INNER JOIN clients ON ClientId=clients.id "
-            + "WHERE DraftCreated=0;"            
+            + "WHERE DraftCreated=0;",
+
+            "SELECT ReferenceNumber, Description, EntrustmentDate, ClientName FROM"
+            + " legalnotices INNER JOIN clients ON ClientId=clients.id WHERE "
+            + " DraftApproved=1 AND NoticeSent=0;"
     } ;
 
     private static final String[] REPORTS_FILTERED = { "SELECT ReferenceNumber, Description"
@@ -64,7 +68,11 @@ public class Utility {
 
             "SELECT ReferenceNumber, Description, EntrustmentDate, ClarificationRemarks"
             + ", ClientName from legalnotices INNER JOIN clients ON ClientId=clients.id "
-            + "WHERE DraftCreated=0 AND ClientId=?;"            
+            + "WHERE DraftCreated=0 AND ClientId=?;",            
+
+            "SELECT ReferenceNumber, Description, EntrustmentDate, ClientName FROM"
+            + " legalnotices INNER JOIN clients ON ClientId=clients.id WHERE "
+            + " DraftApproved=1 AND NoticeSent=0 AND ClientId=?;"            
     } ;    
     
     static void saveStationerySettings (String left_header,