AppointmentList.java

Go to the documentation of this file.

import java.sql.SQLException;

public class AppointmentList extends Widget
{ 
  public ActionButton action;
  public AppointmentEditor editor;
  public int appointment_id = 0;  
        
        public static final int EDIT = 1;
        public static final int DELETE = 2;
        
        public AppointmentList(String prefix, Form form)
        {
          super(prefix, form);
          action = new ActionButton(n("action"), form);
          addChild(action);
        }
        
        public void loadValues()
        {
    super.loadValues();

    int a = toInt(loadAttribute("appointment_id"),0);
    boolean editing = a != 0;
    
    for(;;)
    if (editing)
    {
      if (a != 0) appointment_id = a;
      editor = new AppointmentEditor(appointment_id, n("editor"), form);
      addChild(editor);
      if (a != 0) editor.loadValues(); else editor.loadDefaults(); 
      if (editor.done)
        appointment_id = 0;
      else
      {
        modalChild = editor;
        editor.modal = true;
      }
      return;
    }   
    else
    {   
      switch (action.action)
      {
        case EDIT:
          editing = true;
          appointment_id = action.param;
        break;
        case DELETE:
          deleteAppointment(action.param);
          return;
        default:
          return;
      }
    }
        }
        
        public void deleteAppointment(int id)
        {
          Query q = new Query(form.connectDb(), form.pw);
          try
          {
            String where = " WHERE appointment_id = " + id + ";\n";
            q.execute(
              "DELETE FROM appointment_services" + where +
              "DELETE FROM diagnoses" + where +
              "DELETE FROM referrals" + where +
              "DELETE FROM appointments" + where
            );
          }
          finally
          {
            q.close();
          }
        }
        
        public void display(boolean hidden)
        {
    super.display(hidden);
  
    printAttribute("appointment_id", "" + appointment_id);

    if (hidden || modalChild != null) return;

    p("<p align=center>");
    action.display("Create new appointment...", EDIT, -1);
    p("</p>");

    Query q = new Query(form.connectDb(), form.pw);
    try
    {
      q.query("\n"+
"        SELECT to_char(a.begintime, 'DD Mon YYYY HH:MI AM'), \n"+
"          to_char(a.endtime, 'DD Mon YYYY HH:MI AM'), d.name, p.name,\n"+
"          a.appointment_id\n"+
"        FROM appointments AS a\n"+
"        INNER JOIN doctors AS d USING (doctor_id)\n"+
"        INNER JOIN patients AS p USING (patient_id)\n"+
"        ORDER BY a.begintime, a.endtime\n"+
"      ");
      
      if (q.r != null)
      {
        p("<table border=1>\n");
        p("<tr><td>Begin Time</td><td>End Time</td><td>Patient</td><td>Doctor</td><td>&nbsp;</td></tr>\n");
        while(q.r.next())
        {
          p("<tr><td>" + q.r.getString(1) + "</td><td>" + q.r.getString(2)
            + "</td><td>" + q.r.getString(3) + "</td><td>" + q.r.getString(4)
            + "</td><td>");
          
          int id = q.r.getInt(5);
          
          action.display("Edit", EDIT, id);
          action.display("Delete", DELETE, id);
            
          p("</td></tr>\n");
        }
        p("</table>\n");
      }
    }
    catch(SQLException e)
    {
      p(e);
    }
    finally
    {
      q.close();
    }
  }
};

---