private void getAndPopulatePersonal(String roomID) {
// Get and populate operatinginfo
Statement stmnt;
try {
stmnt = conn.createStatement();
String strQuery =
"select personal_id, Roll, namn, streckkod, p.optillfalle_id, opsal_id from NarDa.dbo.v_OrbitNardaPersonal p, NarDa.dbo.v_OrbitNardaOperationsinfo op WHERE op.opsal_id = "
+ roomID
+ " AND op.optillfalle_id = p.optillfalle_id";
ResultSet res = stmnt.executeQuery(strQuery);
Room r = OrbitStamps.operatingRooms.get(roomID);
while (res.next()) {
String optillfalle_id = res.getString("optillfalle_id");
Operation op = r.operations.get(optillfalle_id);
if (op != null) {
String namn =
(res.getString("namn") != null) ? res.getString("namn") : "Inget namn angivet";
String roll = (res.getString("Roll") != null) ? res.getString("Roll") : "Okänd roll";
String personal_id =
(res.getString("personal_id") != null)
? res.getString("personal_id")
: "Inget ID angivet";
Person p = new Person(namn, new Role(roll), personal_id);
p.devices.add(new PagerReciever("1234"));
op.addPerson(p);
}
}
} catch (SQLException e) {
e.printStackTrace();
}
}
private void getAndPopulateRoomWithOperation(String roomID) {
// Get and populate operatinginfo
DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Statement stmnt;
try {
stmnt = conn.createStatement();
String strQuery =
"select optillfalle_id, opkort_id, iva, start_tidpunkt, slut_tidpunkt, beskrivning, tid_forberedelse, tid_operation from "
+ Config.DATABASE_OPERATION_VIEW
+ " WHERE opsal_id = "
+ roomID
+ " ORDER BY start_tidpunkt ASC";
ResultSet res = stmnt.executeQuery(strQuery);
Room r = OrbitStamps.operatingRooms.get(roomID);
while (res.next()) {
String op_id = res.getString("optillfalle_id");
if (!r.operations.containsKey(op_id)) {
String opkort_id = res.getString("opkort_id");
String op_desc =
(res.getString("beskrivning") != null)
? res.getString("beskrivning")
: "Saknar beskrivning";
java.util.Date op_start;
java.util.Date op_end;
try {
op_start = df.parse(res.getString("start_tidpunkt"));
op_end = df.parse(res.getString("slut_tidpunkt"));
} catch (Exception e) {
op_start = new Date(Calendar.getInstance().getTimeInMillis());
op_end = new Date(Calendar.getInstance().getTimeInMillis());
// TODO Auto-generated catch block
e.printStackTrace();
}
Operation operation = new Operation(op_id, opkort_id, op_start, op_end, op_desc);
r.operations.put(op_id, operation);
operation.debugPrint();
}
}
} catch (SQLException e) {
e.printStackTrace();
}
}
