projects
/
habeas.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Reporting Functionality - added some report
[habeas.git]
/
src
/
habeas
/
Utility.java
diff --git
a/src/habeas/Utility.java
b/src/habeas/Utility.java
index
9df1ab5
..
8602583
100644
(file)
--- 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 "
"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"
} ;
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 "
"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,
} ;
static void saveStationerySettings (String left_header,