/**
* Handles when aides cover each other. They must tell
* us who they're covering so that that poor person
* doesn't get a missed shift. This of course means i
* have to work on MyHours some more... If they select
* a valid userid to cover for makes the appropriate
* entry in AIDELOG.
*
* @param An SaoWorker who is covering someone else
*/
public void WhoRUCovering(final SaoWorker w)
{
int i = 0;
int h = bd.getHours();
int m = bd.getMinutes();
if (((m >= 20) && (m < 30)) || ((m >= 50) && (m < 60)))
{
if (m < 30) { m = m + 10; }
else { m = m + 10 - 60; h = h + 1; }
}
int dopp = bd.getDoPP();
if (dopp > 7) { dopp = dopp - 7; }
String slotid = bd.getSlot(h, m, dopp);
String q = "select * from AIDESCHED where " + slotid + "=1";
final String[] userids = {"", "", "", "", "", "", "", "", "", ""};
final BatSQL bSQL = new BatSQL();
ResultSet rs = bSQL.query(q);
try
{
boolean more = rs.next();
if (more) //because there might be only one person for this slot
{
while (more)
{
userids[i] = rs.getString(1);
i++;
more = rs.next();
}
} //end of if more
} //end of try
catch (SQLException ex)
{
System.out.println("!*******SQLException caught*******!");
System.out.println("WhoRUCovering");
while (ex != null)
{
System.out.println ("SQLState: " + ex.getSQLState ());
System.out.println ("Message: " + ex.getMessage ());
System.out.println ("Vendor: " + ex.getErrorCode ());
ex = ex.getNextException ();
System.out.println ("");
}
System.exit(0);
} //end catching SQLExceptions
catch (java.lang.Exception ex)
{
System.out.println("!*******Exception caught*******!");
System.out.println("WhoRUCovering");
System.exit(0);
} //end catching other Exceptions
final Frame coverF = new Frame("Covering?");
final Panel p = new Panel();
final Panel btnP = new Panel();
final List coverL = new List();
Button ok = new Button("Cover");
Button nok = new Button("Cancel");
final int i2 = i;
ok.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e)
{
String id = coverL.getSelectedItem();
BatSQL bS = new BatSQL();
String a = "insert into aidelog values ('C', \"" + id + "\", \"" + bd.getDate() + "\", " + bd.getStringHours() + bd.getStringMinutes() + ", 'I')";
bS.update(a);
a = "update AIDEDIN set COVERING='" + id + "' where USERID='" + w.getUserID() + "'";
bS.update(a);
bS.disconnect();
coverF.dispose();
}
});
nok.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e)
{
coverF.dispose();
}
});
btnP.setLayout(new FlowLayout());
btnP.add(ok);
btnP.add(nok);
p.setLayout(new BorderLayout());
p.add(new Label("Who are you covering for?"), BorderLayout.NORTH);
int j;
for (j = 0; j <= i; j++)
{
coverL.add(userids[j]);
}
p.add(coverL, BorderLayout.CENTER);
p.add(btnP, BorderLayout.SOUTH);
coverL.select(0);
coverF.setLayout(new FlowLayout());
coverF.add(p);
coverF.pack();
coverF.setLocation(200, 200);
coverF.show();
} //end of WhoRUCovering
