OpenMRS

Timestamp:

08/11/08 16:11:10 (5 months ago)

Author:

machosry

Message:

address hierarchy: completed few enhancements suggested in the dev call. still the portlet overriding is not solved yet.

Files:

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

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

@@ -2 +2 @@
-
-import java.util.Collections;
-import java.util.HashMap;
-import java.util.Iterator;
-import java.util.List;
@@ -14 +13 @@
-import org.hibernate.SessionFactory;
-import org.openmrs.module.addresshierarchy.AddressHierarchy;
+import org.openmrs.module.addresshierarchy.AddressHierarchyType;
-import org.openmrs.module.addresshierarchy.db.AddressHierarchyDAO;
-import org.openmrs.module.addresshierarchy.nodes.Child;
-import org.openmrs.module.addresshierarchy.nodes.Parent;
-import org.openmrs.module.addresshierarchy.nodes.TreeNode;
-
-public class HibernateAddressHierarchyDAO implements AddressHierarchyDAO {
@@ -346 +343 @@
-    }
-    
+    public String[] getLocationType(){
+        List<String> arrList = null;
+        String query = "select name from AddressHierarchyType";
+        arrList = sessionFactory.getCurrentSession().find(query);
+        String[] arr = new String[arrList.size()];
+        for(int i=0;i<arrList.size();i++){
+                arr[i] = arrList.get(i);
+        }
+        return arr;
+    }
+    
+    public String[] getLocationTypeTable(){
+        Iterator iter = null;
+        String query = "select typeId,name,choice,listorder from AddressHierarchyType order by listorder";
+        iter = sessionFactory.getCurrentSession().find(query).iterator();
+        String[] arr = new String[44];
+        int i = 0;
+        while(iter.hasNext()){
+                Object[] x = (Object[]) iter.next();
+                arr[i] = x[0].toString();
+                i++;
+                arr[i] = x[1].toString();
+                i++;
+                arr[i] = x[2].toString();
+                i++;
+                arr[i] = x[3].toString();
+                i++;
+        }
+        return arr;
+    }
+    
+    public void updateLocationTypeTable(AddressHierarchyType aht){
+        sessionFactory.getCurrentSession().beginTransaction();
+        sessionFactory.getCurrentSession().createQuery("update AddressHierarchyType set listorder = '"+aht.getListorder()+"', choice = '"+aht.getChoice()+"' where name = '"+aht.getName()+"'").executeUpdate();
+        sessionFactory.getCurrentSession().getTransaction().commit();
+        
+    }
+    
+    public void loadTable(){
+        
+    }
+    
+    public void unloadTable(){
+        sessionFactory.getCurrentSession().beginTransaction();
+        sessionFactory.getCurrentSession().createQuery("delete * from AddressHierarchy").executeUpdate();
+        sessionFactory.getCurrentSession().getTransaction().commit();
+    }
+    
+    public String[] getAddressHierarchyTypeList(Integer typeid){
+        String query = "select name from AddressHierarchyType where typeId > "+typeid+" and choice = 1 order by listorder";
+        List<String> x = sessionFactory.getCurrentSession().find(query);
+        String[] arr = new String[x.size()];
+        for(int i=0;i<x.size();i++){
+                arr[i]=x.get(i);
+        }
+        return arr;
+    }
+    
-}