Dr.NO/src/drno/swingui/guiController/TableHandler.java

   1 /*
   2  * TableHandler.java
   3  *
   4  * Created on 10. april 2005, 13:50
   5  */
   6
   7 package drno.swingui.guiController;
   8
   9 import java.rmi.RemoteException;
  10 import java.sql.Timestamp;
  11 import java.util.Vector;
  12 import java.util.*;
  13
  14 import java.text.DateFormat;
  15 import java.util.GregorianCalendar;
  16
  17 import drno.interfaces.EmployeeHandler;
  18 import drno.interfaces.IEmployee;
  19 import drno.interfaces.IPatient;
  20 import drno.interfaces.ITidsreservation;
  21 import drno.interfaces.LoginHandler;
  22 import drno.interfaces.PatientHandler;
  23 import drno.interfaces.TidsreservationsHandler;
  24 import drno.server.*;
  25
  26
  27 /**
  28  *
  29  * @author  Leo
  30  */
  31 public class TableHandler {
  32     LoginHandler lh;
  33     PatientHandler p_handler;
  34     EmployeeHandler e_handler;
  35     TidsreservationsHandler t_handler;
  36     Hashtable reservations;
  37     //Object[][] data;
  38     DateFormat df2;
  39
  40     /** Creates a new instance of TableHandler
  41      * @param lh
  42      * @param t_handler
  43      * @param e_handler
  44      * @param p_handler*/
  45     public TableHandler(PatientHandler p_handler, EmployeeHandler e_handler, TidsreservationsHandler t_handler, LoginHandler lh){//throws SecurityDisallowedException {
  46         try{
  47             this.lh = lh;
  48             this.p_handler = p_handler;
  49             this.e_handler = e_handler;
  50             this.t_handler = t_handler;
  51             reservations = new Hashtable();
  52             //data = new Object[28][2];
  53             df2 = DateFormat.getTimeInstance(DateFormat.SHORT);
  54         }
  55         catch(Exception e){
  56             e.printStackTrace();
  57         }
  58     }
  59
  60     public Object[] getDoctors(){
  61         try{
  62             Vector docs = e_handler.getAllDoctors();
  63             Object[] docData = new Object[docs.size()];
  64             docs.copyInto(docData);
  65             return docData;
  66         }
  67         catch(Exception e){
  68             e.printStackTrace();
  69         }
  70         return null;
  71     }
  72
  73     public Object[][] getTableData(){
  74         try{
  75             Vector ip = p_handler.getAllPatients();
  76             Object[][] Pdata = new Object[ip.size()][6];
  77
  78                 for(int i=0; i<ip.size(); i++) {
  79                     Pdata[i][0] = ((IPatient)ip.elementAt(i)).getFornavn()+" "+((IPatient)ip.elementAt(i)).getEfternavn();
  80                     Pdata[i][1] = ((IPatient)ip.elementAt(i)).getCpr();
  81                     Pdata[i][2] = ((IPatient)ip.elementAt(i)).getAdresse();
  82                     Pdata[i][3] = ((IPatient)ip.elementAt(i)).getTlf();
  83                     Pdata[i][4] = new Integer(((IPatient)ip.elementAt(i)).getSex());
  84                     Pdata[i][5] = ((IPatient)ip.elementAt(i)).getDoctor();
  85                 }
  86              return Pdata;
  87         }
  88         catch(Exception e){
  89             e.printStackTrace();
  90         }
  91        return null;
  92     }
  93
  94     public Object[][] makeCalendar(int kolloner, int tidsopdeling) {
  95         Object[][] data = new Object[33][kolloner];
  96         GregorianCalendar c = new GregorianCalendar();
  97         DateFormat df2 = DateFormat.getTimeInstance(DateFormat.SHORT);
  98         //Timestamp t = new Timestamp(c.getTimeInMillis());
  99         Timestamp t = new Timestamp(c.getTimeInMillis());
 100         t.setHours(07);
 101         t.setMinutes(00);
 102         String s = df2.format(t);
 103         for(int i=0; i<data.length;i++){
 104             data[i][0]= s;
 105             t.setMinutes(t.getMinutes()+tidsopdeling);
 106             s = df2.format(t);
 107         }
 108         return data;
 109     }
 110
 111     public Object[][] makeCalendarFromLogin() {
 112         try{
 113             IEmployee e = lh.getUser();
 114             int tidsopdeling = e.getTidsOpdeling();
 115             Object[][] data = new Object[60/tidsopdeling*8][2];
 116             GregorianCalendar c = new GregorianCalendar();
 117             //Timestamp t = new Timestamp(c.getTimeInMillis());
 118             Timestamp t = new Timestamp(c.getTimeInMillis());
 119             t.setHours(8);
 120             t.setMinutes(00);
 121             String s = df2.format(t);
 122             //set tids kolloner:
 123             for(int i=0; i<data.length;i++){
 124                 data[i][0]= s;
 125                 t.setMinutes(t.getMinutes()+tidsopdeling);
 126                 s = df2.format(t);
 127             }
 128             return data;
 129         }
 130         catch(Exception exception){
 131             exception.printStackTrace();
 132         }
 133         return null;
 134     }
 135     public Object[][] makeCalendarFromEmployee(IEmployee e) {
 136         try{
 137             int tidsopdeling = e.getTidsOpdeling();
 138             Object[][] data = new Object[60/tidsopdeling*8][2];
 139             GregorianCalendar c = new GregorianCalendar();
 140             //Timestamp t = new Timestamp(c.getTimeInMillis());
 141             Timestamp t = new Timestamp(c.getTimeInMillis());
 142             t.setHours(8);
 143             t.setMinutes(00);
 144             String s = df2.format(t);
 145             //set tids kolloner:
 146             for(int i=0; i<data.length;i++){
 147                 data[i][0]= s;
 148                 t.setMinutes(t.getMinutes()+tidsopdeling);
 149                 s = df2.format(t);
 150             }
 151             return data;
 152         }
 153         catch(Exception exception){
 154             exception.printStackTrace();
 155         }
 156         return null;
 157     }
 158     //Laver en Util date objekt til et SQL timestamp objekt
 159     public java.sql.Timestamp DateToTimestamp(java.util.Date d){
 160         Calendar c = new GregorianCalendar();
 161         c.setTime(d);
 162         Timestamp h = new Timestamp(c.getTimeInMillis());
 163         //Dump tidsreservations databasen i tabellen
 164         return h;
 165     }
 166
 167     public Object[][] getReservationFromDateAndDoc(Object[][] data, Timestamp t, IEmployee e){
 168         try{
 169             reservations.clear();
 170             Vector reservation = t_handler.getFromDate(t,e);
 171             if(reservation.size()==0){
 172                 return data;
 173             }
 174             else{
 175                 for(int i=0; i<reservation.size(); i++){
 176                     ITidsreservation rv = (ITidsreservation)reservation.elementAt(i);
 177                     String tbase =  df2.format(rv.getTidStart()); //tid fra databasen
 178
 179                     for(int j=0; j<data.length;j++){
 180                         if(data[j][0].equals(tbase)){
 181                             reservations.put(data[j][0],rv);
 182                             IPatient p = rv.getPatient();
 183                             String navn = p.getFornavn()+" "+p.getEfternavn();
 184                             data[j][1] = navn;
 185                         }
 186                     }
 187                 }
 188                 return data;
 189             }
 190         }
 191         catch(Exception exception){
 192             exception.printStackTrace();
 193         }
 194         return null;
 195     }
 196
 197     public Object[][] getReservationFromDate(Object[][] data, Timestamp t){
 198         try{
 199             reservations.clear();
 200             Vector reservation = t_handler.getFromDate(t); //henter alle reservationer for idag
 201             if(reservation.size()==0){
 202                 return null;
 203             }
 204             else{
 205                 for(int i = 0; i<reservation.size(); i++){
 206                     ITidsreservation rv = (ITidsreservation)reservation.elementAt(i);
 207                     String tbase =  df2.format(rv.getTidStart()); //tid fra databasen
 208
 209                     for(int j=0; j<data.length;j++){
 210                         if(data[j][0].equals(tbase)){
 211                             reservations.put(data[j][0],rv);
 212                             IPatient p = rv.getPatient();
 213                             String navn = p.getFornavn()+" "+p.getEfternavn();
 214                             data[j][1] = navn;
 215                         }
 216                     }
 217                 }
 218                 return data;
 219             }
 220         }
 221         catch(Exception e){
 222             e.printStackTrace();
 223         }
 224         return null;
 225     }
 226
 227     public Hashtable getHashtable(){
 228         if(reservations.isEmpty()){
 229                         return null;
 230         }
 231         else{
 232                         return reservations;
 233         }
 234     }
 235
 236     public int getTidsopdeling(){
 237
 238         try {
 239                         IEmployee e = lh.getUser();
 240                         int tidsopdeling = e.getTidsOpdeling();
 241                         return tidsopdeling;
 242                 } catch (RemoteException e) {
 243                         // TODO Auto-generated catch block
 244                         e.printStackTrace();
 245                         return -1;
 246                 }
 247     }
 248
 249
 250     public Vector getReservationFromPatient(IPatient p){
 251         try{
 252             Vector v = t_handler.getFromPatient(p);
 253             if(v.size()==0){
 254                 return null;
 255             }
 256             else{
 257                 return v;
 258             }
 259         }
 260         catch(Exception exception){
 261             exception.printStackTrace();
 262         }
 263         return null;
 264     }
 265     public String PInfo_toString(IPatient p){
 266         try {
 267                         String output = "PATIENT INFO:\n"+
 268                                         "Fornavn:\t"+p.getFornavn()+"\n"+
 269                                         "Efternavn:\t"+p.getEfternavn()+"\n"+
 270                                         "CPR:\t"+p.getCpr()+"\n"+
 271                                         "Adresse:\t"+p.getAdresse()+"\n"+
 272                                         "TLF:\t"+p.getTlf()+"\n"+
 273                                         "Alder:\t"+p.getAlder()+"\n\n";
 274                         return output;
 275                 } catch (RemoteException e) {
 276                         // TODO Auto-generated catch block
 277                         e.printStackTrace();
 278                         return null;
 279                 }
 280     }
 281
 282     public String TInfo_toString(ITidsreservation t){
 283         try {
 284                         String output = "RESERVATION INFO:\n"+
 285                                         "Tidstart:\t"+t.getTidStart()+"\n"+
 286                                         "Emne:\t"+t.getEmne()+"\n";
 287                         return output;
 288                 } catch (RemoteException e) {
 289                         // TODO Auto-generated catch block
 290                         e.printStackTrace();
 291                         return null;
 292                 }
 293     }
 294
 295     public void print(String str) {
 296         //System.out.print(str);
 297     }
 298     public void println(String str) {
 299         //System.out.println(str);
 300     }
 301
 302 }