OpenMRS

Timestamp:

08/18/08 12:05:28 (5 months ago)

Author:

machosry

Message:

address hierarchy: done with newPatientForm and patientDashboard yet to fix the drop down in patient.form

Files:

• openmrs-modules/addresshierarchy/src/org/openmrs/module/addresshierarchy/db/hibernate/HibernateAddressHierarchyDAO.java (modified) (2 diffs)

openmrs-modules/addresshierarchy/src/org/openmrs/module/addresshierarchy/db/hibernate/HibernateAddressHierarchyDAO.java

@@ -1 +1 @@
-package org.openmrs.module.addresshierarchy.db.hibernate;
-
+import java.util.ArrayList;
-import java.util.Collections;
-import java.util.Iterator;
@@ -401 +402 @@
-    }
-    
+    public Integer getSizeOfPersonTable(){
+            List y = sessionFactory.getCurrentSession().createSQLQuery("select * from person").list();
+        Integer x = y.size();
+        
+        return x;
+    }
+    
+    
+    public List getLastRow(){
+        List y = sessionFactory.getCurrentSession().createSQLQuery("select person_id,creator,voided,voided_by,date_voided,void_reason from person").list();
+        
+        return y;
+    }
+    
+    public String[] getLocation(Integer id){
+        String[] x = {"address1","address2","country","state_province","county_district","subregion","region","township_division","city_village","neighborhood_cell","postal_code","longitude","latitude"};
+        String query ="select person_address_id,preferred,";
+        for(int i=0;i<x.length;i++){
+                query += x[i];
+                if(i!=x.length-1){
+                        query += ",";
+                }
+        }
+        query += " from person_address where person_id = "+id;
+        
+        List y = sessionFactory.getCurrentSession().createSQLQuery(query).list();
+        List<String> finalarr = new ArrayList();
+        for(int l=0;l<y.size();l++){
+        Object[] obj = (Object[]) y.get(l);
+        
+        for(int j=1;j<obj.length;j++){
+                if(obj[j]!=null)
+                        finalarr.add(obj[j].toString());
+                else
+                        finalarr.add("");
+                
+        }
+        }
+        String[] fin = new String[finalarr.size()];
+        for(int p=0;p<finalarr.size();p++){
+                fin[p]=finalarr.get(p);
+                System.out.println(fin[p]);
+        }
+        return fin;
+    }
+    
-}