Reporting Functionality - added some report

[habeas.git] / src / habeas / Utility.java

diff --git a/src/habeas/Utility.java b/src/habeas/Utility.java
index d54ace3..8602583 100644 (file)
--- a/src/habeas/Utility.java
+++ b/src/habeas/Utility.java
@@ -38,8 +38,15 @@ public class Utility {
             
             "SELECT ReferenceNumber, Description, EntrustmentDate, "
             + "ClarificationRemarks, ClientName FROM legalnotices INNER JOIN clients ON"
-            + " ClientId=clients.id WHERE ClarificationPending=1;"
+            + " ClientId=clients.id WHERE ClarificationPending=1;",
             
+            "SELECT ReferenceNumber, Description, EntrustmentDate, ClarificationRemarks"
+            + ", ClientName from legalnotices INNER JOIN clients ON ClientId=clients.id "
+            + "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"
@@ -57,7 +64,15 @@ public class Utility {
 
             "SELECT ReferenceNumber, Description, EntrustmentDate, "
             + "ClarificationRemarks, ClientName FROM legalnotices INNER JOIN clients ON"
-            + " ClientId=clients.id WHERE ClarificationPending=1 AND ClientId=?;"            
+            + " ClientId=clients.id WHERE ClarificationPending=1 AND ClientId=?;",
+
+            "SELECT ReferenceNumber, Description, EntrustmentDate, ClarificationRemarks"
+            + ", ClientName from legalnotices INNER JOIN clients ON ClientId=clients.id "
+            + "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,