ReferralList.java

Go to the documentation of this file.

import java.util.Vector;
import java.sql.SQLException;

public class ReferralList extends Widget
{ 
        ActionButton action;
        ReferralEditor editor;
        Vector referrals = new Vector();
        int active;
        
        public static final int ADD = 1;
        public static final int EDIT = 2;
        public static final int DELETE = 3;
        
        public ReferralList(String prefix, Form form)
        {
    super(prefix, form); 
    action = new ActionButton(n("action"), form);
    addChild(action);
        }
        
        public void loadValues()
        {
    super.loadValues();
    
    modal = loadAttribute("modal") != null;
    
    String l = loadAttribute("referrals");
    if (l != null) referrals = (Vector) unserialize(l);
    
    String a = loadAttribute("active");    
    
    for(;;)
    if (modal)
    {
      if (a != null) active = toInt(a, -1);      
      editor = new ReferralEditor(active, referrals, n("editor"), form);
      if (a == null) editor.loadDefaults(); else editor.loadValues();        
      
      if (editor.done)
        modal = false;
      else if (editor.more)
      {
        a = null;
        active = -1;
      }
      else
         return;
    }   
    else
    {   
      switch (action.action)
      {
        case ADD:
          modal = true;
          active = -1;
        break;
        case EDIT:
          modal = true;
          active = action.param;
        break;
        case DELETE:
          referrals.remove(action.param);
          return;
        default:
          return;
      }
    }
        }
                
        public void display(boolean hidden)
        {
    printAttribute("referrals", serialize(referrals));

    if (modal)
    {
      printAttribute("modal", "1");
      printAttribute("active", Integer.toString(active));
      editor.display(hidden);
      return;
    }
    else if (hidden)
      return;
    
    if (referrals.size() <= 0)
    {
      action.display("Add a referral...", ADD);
    }
    else
    {
      action.display("Add another referral...", ADD);
      p("<br>\n<table>\n");
      int l = referrals.size();
      
      Query q = new Query(form.connectDb(), form.pw);
      try
      {
        for(int i = 0; i < l; ++i)
        {
          Referral r = (Referral) referrals.get(i);
          
          q.query("\n"+
"            SELECT d.name, p.name\n"+
"            FROM doctors AS d\n"+
"            INNER JOIN practices AS p USING (practice_id)\n"+
"            WHERE d.doctor_ID = " + r.doctor_id
          );
          
          if (q.r == null) continue;
          
          String doctor = "unknown";
          String practice = "unknown";
          if (q.r.next() && q.r.isLast())
          {
            doctor = q.r.getString(1);
            practice = q.r.getString(2);
          }

          p(
"\n"+
"<tr>\n"+
"  <td>\n"+
"    <table border=1 RULES=NONE FRAME=BOX>\n"+
"    <tr><td colspan=2><strong>Referral " + (r.incoming ? "From" : "To") + "</strong></td></tr>\n"+
"    <tr>\n"+
"      <td valign=top><i>Doctor:</i></td>\n"+
"      <td>" + doctor + "</td>  \n"+
"    </tr>\n"+
"    <tr>\n"+
"      <td valign=top><i>Practice:</i></td>\n"+
"      <td>" + practice + "</td>  \n"+
"    </tr>    \n"+
"    </table>\n"+
"  </td>\n"+
"  <td>\n"+
"  "); 
    action.display("Edit...", EDIT, i); p(" ");
    action.display("Delete", DELETE, i); p("\n"+
"  </td>\n"+
"</tr>\n"+
"");
        } // for
      } // try
      catch (SQLException e)
      {
        p(e);
      }
      finally
      {
        q.close();
      }
      p("</table>\n");     
    }
        }
};

---