PatientList.java

Go to the documentation of this file.

import java.sql.SQLException;

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

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

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

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

    Query q = new Query(form.connectDb(), form.pw);
    try
    {
      q.query("\n"+
"        SELECT t.name, t.address, t.phone, c.name || ': ' || p.description, patient_id\n"+
"        FROM patients AS t\n"+
"        INNER JOIN insurance_policies AS p USING (insurance_policy_id)\n"+
"        INNER JOIN insurance_companies AS c USING (insurance_company_id)\n"+
"        ORDER BY t.name\n"+
"      ");
      
      if (q.r != null)
      {
        p("<table border=1>\n");
        p("<tr><td>Name</td><td>Phone</td><td>Address</td><td>Insurance</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>");
          
          action.display("Edit", EDIT, q.r.getInt(5));
          action.display("Delete", DELETE, q.r.getInt(5));
            
          p("</td></tr>\n");
        }
        p("</table>\n");
      }
    }
    catch(SQLException e)
    {
      p(e);
    }
    finally
    {
      q.close();
    }
  }
};

---