X-Git-Url: https://harishankar.org/repos/?p=habeas.git;a=blobdiff_plain;f=src%2Fhabeas%2FUtility.java;fp=src%2Fhabeas%2FUtility.java;h=bc999323b4f6c6ad179b9f808f8c67b38de2c30e;hp=0dc423577bf8e1d96e18f2948906dabad3d16dc1;hb=ebe8c5c1a1ff2d63aca4d844887f39d763272eac;hpb=9ec7870cd70d09a7d67efb17dae44baa51f77957

diff --git a/src/habeas/Utility.java b/src/habeas/Utility.java
index 0dc4235..bc99932 100644
--- a/src/habeas/Utility.java
+++ b/src/habeas/Utility.java
@@ -5,11 +5,20 @@
  */
 package habeas;
 
+import java.io.FileNotFoundException;
+import java.io.FileOutputStream;
+import java.io.IOException;
+import java.io.InputStream;
 import java.util.ArrayList;
 import java.util.prefs.Preferences;
 import java.sql.*;
+import java.text.DateFormat;
+import java.text.MessageFormat;
+import java.text.SimpleDateFormat;
+import java.util.Arrays;
 import java.util.logging.Level;
 import java.util.logging.Logger;
+import jdk.dynalink.linker.support.Guards;
 
 /**
  *
@@ -22,20 +31,23 @@ public class Utility {
         leftLetterHeader = left_header;
         rightLetterHeader = right_header;
         signatoryName = signatory;
-        Preferences.userRoot().put ("LeftHeader", left_header);
-        Preferences.userRoot().put ("RightHeader", right_header);
-        Preferences.userRoot().put ("Signatory", signatory);
+        Preferences myPrefs = Preferences.userRoot().node("org/harishankar/Habeas");
+        myPrefs.put ("LeftHeader", left_header);
+        myPrefs.put ("RightHeader", right_header);
+        myPrefs.put ("Signatory", signatory);
     }
     
     static void retrieveStationerySettings () {
-        leftLetterHeader = Preferences.userRoot().get("LeftHeader", "Left Header");
-        rightLetterHeader = Preferences.userRoot().get ("RightHeader", "Right Header");
-        signatoryName = Preferences.userRoot().get ("Signatory", "Signatory Name");
+        Preferences myPrefs = Preferences.userRoot().node ("org/harishankar/Habeas");
+        leftLetterHeader = myPrefs.get("LeftHeader", "Left Header");
+        rightLetterHeader = myPrefs.get ("RightHeader", "Right Header");
+        signatoryName = myPrefs.get ("Signatory", "Signatory Name");
     }
 
     static void saveConnectionURL(String text) {
         connectionURL = text;
-        Preferences.userRoot().put("ConnectionURL", text);
+        Preferences myPrefs = Preferences.userRoot().node ("org/harishankar/Habeas");
+        myPrefs.put("ConnectionURL", text);
     }
 
     static ArrayList<Object> getClientDetails(int r) {
@@ -391,6 +403,85 @@ public class Utility {
         }
         
     }
+    
+    static ArrayList<Object> getRaisedBills (int client_id) {
+        try {
+            Connection conn = DriverManager.getConnection(JDBC + connectionURL);
+            PreparedStatement st = conn.prepareStatement("SELECT ReferenceNumber, "
+                     + "Description, BillDate, BillAmount"
+                     + " FROM legalnotices WHERE BillStatus='RAISED' AND ClientId=?;");
+            st.setInt (1, client_id);
+            
+             ResultSet rs = st.executeQuery ();
+             ArrayList<Object> bills = new ArrayList<>();
+             while (rs.next()) {
+                 bills.add (rs.getString("ReferenceNumber"));
+                 bills.add (rs.getString("Description"));
+                 bills.add (getValidDate(rs, "BillDate"));
+                 bills.add (rs.getInt("BillAmount"));
+             }
+             conn.close();
+             return bills;
+             
+        } catch (SQLException ex) {
+            Logger.getLogger(Utility.class.getName()).log(Level.SEVERE, null, ex);
+            return null;
+        }
+            
+    }
+
+    static boolean generateRaisedNoticesBill(String fileName, String clientName,
+            String clientAddress, String contactPerson, ArrayList<Object> bills) {
+        if (bills == null)
+                return false;
+        try {
+            InputStream templ = Utility.class.getClassLoader().getResourceAsStream("resources/noticebill.template.fodt");
+            if (templ == null)
+                return false;
+            DateFormat fmt = new SimpleDateFormat("dd MMM yyyy");
+            String templateMain = new String (templ.readAllBytes());
+            // this is for openoffice ODT - replace normal line breaks with the XML equivalent
+            String left = leftLetterHeader.replaceAll("\n", "<text:line-break/>");
+            String right = rightLetterHeader.replaceAll("\n", "<text:line-break/>");
+            String client_address = clientAddress.replaceAll ("\n", "<text:line-break/>");
+            String rows = generateBillRows (bills);
+            System.out.println (rows);
+            
+            String strMain = MessageFormat.format(templateMain, 
+                    left, right, 
+                    fmt.format(new Date(System.currentTimeMillis())),
+                    clientName, client_address, contactPerson, signatoryName, rows);
+            
+            FileOutputStream f = new FileOutputStream (fileName);
+            f.write (strMain.getBytes());
+            f.close();
+            return true; 
+        } catch (IOException ex) {
+            Logger.getLogger(Utility.class.getName()).log(Level.SEVERE, null, ex);
+            return false;
+        }
+    }
+
+    private static String generateBillRows(ArrayList<Object> bills) {
+        try {
+            InputStream tmpl = Utility.class.getClassLoader().getResourceAsStream("resources/tablerow.template.xml");
+            String rowtpl = new String(tmpl.readAllBytes());
+         
+            DateFormat fmt = new SimpleDateFormat("dd/MM/yyyy");
+
+          StringBuilder bldr = new StringBuilder ();
+          for (int i = 0; i < bills.size(); i += 4) {
+              String row = MessageFormat.format (rowtpl, (String)bills.get(i), 
+                      (String)bills.get(i+1), fmt.format((java.util.Date)bills.get(i+2)),
+                              (int)bills.get(i+3));
+              bldr.append(row);
+          }
+          return (bldr.toString());
+        } catch (IOException ex) {
+            Logger.getLogger(Utility.class.getName()).log(Level.SEVERE, null, ex);
+            return null;
+        }
+    }
     public Utility () {
         
     }
@@ -423,7 +514,8 @@ public class Utility {
     }
     
     public static void retrieveConnectionURL () {
-        connectionURL = Preferences.userRoot().get("ConnectionURL", "legaldb");
+        Preferences myPrefs = Preferences.userRoot().node("org/harishankar/Habeas");
+        connectionURL = myPrefs.get("ConnectionURL", "legaldb");
     }
     
 }