/** Write the message with attributes and set the result. */
@Override
public void run() throws IOException {
MessageWriter writer = scon.startMessage(T_BINDER_UPDATE);
writer.writeAttribute(A_PAGE_ID, pageId);
if (isToRemovePage) {
writer.writeAttribute(A_REMOVE, "YES");
}
addStandardAttributes(writer);
writer.endElement();
writer.close();
Log.print("(TaskBinderUpdate.run) page=" + pageId + " isToRemovePage=" + isToRemovePage);
Element reply = scon.receiveMessage();
String ok = reply.getNodeName();
if (!T_OK.equals(ok) && !T_FAIL.equals(ok)) {
Log.quit("BatchBoundary unexpected message type: " + ok);
}
}
/** Write the message with attributes and set the result. */
@Override
public void run() throws IOException {
MessageWriter writer = scon.startMessage(T_USERS_DATA);
writer.encode(UsersData.class, usersData);
writer.endElement();
writer.close();
Element reply = scon.receiveMessage();
String ok = reply.getNodeName();
// Log.print("T_USERS_DATA reply " + ok);
setResult((Object) ok);
if (!T_OK.equals(ok) && !T_FAIL.equals(ok)) {
// Log.quit("SendUsersData unexpected message type: "+ok);
JOptionPane.showMessageDialog(
null,
"Duplicate User Id." + "\n\nPlease re-enter user data.",
"Error",
JOptionPane.ERROR_MESSAGE);
return;
}
}
public void run(ServerTask task, Element action) throws SQLException, IOException {
int volumeId = task.getLockVolumeId();
assert volumeId != 0;
assert task.getLockBatchId() == 0;
int percent = Integer.parseInt(action.getAttribute(A_PERCENT));
String usersIdString = action.getAttribute(A_USERS_ID);
String teamsIdString = action.getAttribute(A_TEAMS_ID);
boolean newSample = "YES".equals(action.getAttribute(A_NEW_SAMPLE));
Log.print(
"in Handler_sample_qa.run vol="
+ volumeId
+ " pct="
+ percent
+ " user: "******" team: "
+ teamsIdString
+ " new_sample: "
+ newSample);
Statement st = null;
int count;
if (newSample) {
// save batches around choose code
st = task.getStatement();
st.executeUpdate(
"update batch"
+ " set status =''"
+ " where volume_id="
+ volumeId
+ " and status = 'QA'");
}
if (usersIdString.length() > 0) {
assert teamsIdString.length() == 0;
if (newSample) {
// move QCComplete batches to QA (managed)
task.executeUpdate(
"update batch B"
+ " inner join batchuser BU using (batch_id)"
+ " set B.status ='QA'"
+ " where B.volume_id="
+ volumeId
+ " and B.status = 'QCComplete'"
+ " and BU.coder_id="
+ usersIdString);
}
count = chooseQAChildrenForCoder(task, percent, Integer.parseInt(usersIdString));
} else if (teamsIdString.length() > 0) {
if (newSample) {
// move QCComplete batches to QA (managed)
task.executeUpdate(
"update batch B"
+ " inner join batchuser BU using (batch_id)"
+ " inner join users U on BU.coder_id=U.users_id"
+ " set B.status ='QA'"
+ " where B.volume_id="
+ volumeId
+ " and B.status = 'QCComplete'"
+ " and U.teams_id="
+ teamsIdString);
}
count = chooseQAChildrenForTeam(task, percent, Integer.parseInt(teamsIdString));
} else {
if (newSample) {
// move QCComplete batches to QA (managed)
task.executeUpdate(
"update batch"
+ " set status ='QA'"
+ " where volume_id="
+ volumeId
+ " and status = 'QCComplete'");
}
count = chooseQAChildren(task, percent);
}
if (newSample) {
// restore old QA batches
st.executeUpdate(
"update batch"
+ " set status ='QA'"
+ " where volume_id="
+ volumeId
+ " and status = ''");
}
// send back info
MessageWriter writer = task.getMessageWriter();
writer.startElement(T_UPDATE_COUNT);
writer.writeAttribute(A_COUNT, count);
writer.endElement();
}
private void saveDelimiterData(ServerTask task, DelimiterData data) throws java.io.IOException {
try {
Log.print("(Handler_delimiter_data.save) '" + data.value_separator + "'");
Connection con = task.getConnection();
Statement st = task.getStatement();
PreparedStatement pst = null;
if (data.force.equals("")) {
// delete
pst = con.prepareStatement("delete from export" + " where export_name = ?");
pst.setString(1, data.delimiter_set_name);
pst.executeUpdate();
} else {
// see if the export_name exists
pst = con.prepareStatement("select export_name" + " from export" + " where export_name=?");
pst.setString(1, data.delimiter_set_name);
ResultSet rs = pst.executeQuery();
if (rs.next()) {
// Log.print("(Handler_export_data.saveExportData) update " + data.delimiter_set_name);
// update
rs.close();
pst =
con.prepareStatement(
"update export set"
+ " force_export = ?,"
+ " uppercase = ?,"
+ " uppercase_names = ?,"
+ " field_delimiter = ?,"
+ " text_qualifier = ?,"
+ " value_separator = ?,"
+ " date_format = ?,"
+ " missing_date = ?,"
+ " missing_year = ?,"
+ " missing_month = ?,"
+ " missing_day = ?,"
+ " missing_date_character = ?,"
+ " name_mask1 = ?,"
+ " name_mask2 = ?,"
+ " name_mask3 = ?,"
+ " name_mask4 = ?,"
+ " brs_format = ?"
+ " where export_name = ?");
pst.setString(1, data.force);
pst.setString(2, data.uppercase);
pst.setString(3, data.uppercase_names);
pst.setString(4, data.field_delimiter);
pst.setString(5, data.text_qualifier);
pst.setString(6, data.value_separator);
pst.setString(7, data.date_format);
pst.setString(8, data.missing_date);
pst.setString(9, data.missing_year);
pst.setString(10, data.missing_month);
pst.setString(11, data.missing_day);
pst.setString(12, data.missing_date_character);
pst.setString(13, data.name_mask1);
pst.setString(14, data.name_mask2);
pst.setString(15, data.name_mask3);
pst.setString(16, data.name_mask4);
pst.setString(17, data.brs_format);
pst.setString(18, data.delimiter_set_name);
pst.executeUpdate();
pst.close();
} else {
// insert
// Log.print("(Handler_export_data.saveExportData) insert " + data.delimiter_set_name);
rs.close();
pst =
con.prepareStatement(
"insert into export set"
+ " force_export = ?,"
+ " uppercase = ?,"
+ " uppercase_names = ?,"
+ " field_delimiter = ?,"
+ " text_qualifier = ?,"
+ " value_separator = ?,"
+ " date_format = ?,"
+ " missing_date = ?,"
+ " missing_year = ?,"
+ " missing_month = ?,"
+ " missing_day = ?,"
+ " missing_date_character = ?,"
+ " export_name = ?,"
+ " name_mask1 = ?,"
+ " name_mask2 = ?,"
+ " name_mask3 = ?,"
+ " name_mask4 = ?,"
+ " brs_format = ?");
pst.setString(1, data.force);
pst.setString(2, data.uppercase);
pst.setString(3, data.uppercase_names);
pst.setString(4, data.field_delimiter);
pst.setString(5, data.text_qualifier);
pst.setString(6, data.value_separator);
pst.setString(7, data.date_format);
pst.setString(8, data.missing_date);
pst.setString(9, data.missing_year);
pst.setString(10, data.missing_month);
pst.setString(11, data.missing_day);
pst.setString(12, data.missing_date_character);
pst.setString(13, data.delimiter_set_name);
pst.setString(14, data.name_mask1);
pst.setString(15, data.name_mask2);
pst.setString(16, data.name_mask3);
pst.setString(17, data.name_mask4);
pst.setString(18, data.brs_format);
pst.executeUpdate();
pst.close();
}
}
pst.close();
} catch (Throwable t) {
Log.quit(t);
}
MessageWriter writer = task.getMessageWriter();
writer.startElement(T_OK);
writer.endElement();
}