private SocketInfo getUserData(String login, boolean senderIsMailUser) {
SocketInfo user = null;
QueryRunner qRunner = null;
ResultSet resultSet = null;
if (!senderIsMailUser) {
// Check is POS user is online
user = SocketServer.getSocketInfo(login);
if (user != null) {
return user;
}
}
// If user is POP or if is a POS user offline
int i = 0;
try {
if (senderIsMailUser) {
qRunner = new QueryRunner("SEL0036", new String[] {login});
} else {
qRunner = new QueryRunner("SEL0026", new String[] {login});
}
resultSet = qRunner.select();
if (resultSet.next()) {
i++;
user = SocketServer.getInstaceOfSocketInfo();
user.setUid(resultSet.getInt(1));
user.setLogin(resultSet.getString(2));
user.setNames(resultSet.getString(3));
user.setEmail(resultSet.getString(4));
user.setAdmin(resultSet.getBoolean(5));
user.setAudit(resultSet.getBoolean(6));
user.setGroupID(resultSet.getInt(7));
user.setWsName(resultSet.getString(9));
user.setGroupName(resultSet.getString(12));
}
} catch (SQLNotFoundException e) {
e.printStackTrace();
} catch (SQLBadArgumentsException e) {
e.printStackTrace();
} catch (SQLException e) {
LogWriter.write("ERROR: Falla mientras se consultaba la informacion del usuario: " + login);
e.printStackTrace();
} finally {
QueryClosingHandler.close(resultSet);
qRunner.closeStatement();
}
return user;
}
public MessageDistributor(Element element, boolean senderIsMailUser) {
// Captures the info from the message
getMessageParams(element);
// Gets the sender info
SocketInfo sender = getSenderInfo(senderIsMailUser);
// Getting the destination list for this message
Vector<SocketInfo> usersVector = getDestinationList(element, senderIsMailUser);
int groupSize = usersVector.size();
String many = "";
if (groupSize > 1 || groupSize == 0) {
many = "s";
}
LogWriter.write("INFO: Enviando mensaje a " + groupSize + " usuario" + many);
// In this cycle, the message is sent to every user in the destination list
for (SocketInfo destination : usersVector) {
SocketChannel sock =
destination.getSock() != null ? destination.getSock().getChannel() : null;
// If the POS user is online
if (sock != null) {
Element message = new Element("Message");
Element root = new Element("root");
message.addContent(root);
root.addContent(addColumn(dateString));
root.addContent(addColumn(hourString));
root.addContent(addColumn(sender.getGroupName()));
root.addContent(addColumn(subject));
root.addContent(addColumn(body));
root.addContent(addColumn("f"));
Document doc = new Document((Element) message.clone());
// Sending message to POS user online
try {
SocketWriter.write(sock, doc);
LogWriter.write(
"INFO: [Envio a Punto de Venta] Remitente {"
+ sender.getLogin()
+ "} - Destino: "
+ destination.getLogin()
+ " - Asunto: "
+ subject);
} catch (ClosedChannelException e) {
LogWriter.write(
"INFO: El colocador " + destination.getLogin() + " no se encuentra en linea.");
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
// Sending message to pop users (admin users)
if (!senderIsMailUser) {
EmailSender mail = new EmailSender();
mail.setFrom(Pop3Handler.getUser() + "@" + Pop3Handler.getHost());
mail.setSender(destination.getEmail());
mail.setSubject(sender.getLogin() + "," + subject);
mail.setDate(date);
mail.setMessage(body);
mail.setSenderFullName(sender.getNames());
mail.setWorkStation(sender.getWsName());
mail.send();
LogWriter.write(
"INFO: [Envio a Cuenta de Correo] Remitente {"
+ sender.getLogin()
+ "} - Destino: "
+ destination.getLogin()
+ " - Asunto: "
+ subject);
}
// if destination user is offline
if (!control || (control && (sock != null))) {
String isValid = groupSize > 0 ? "true" : "false";
String[] argsArray = {
String.valueOf(destination.getUid()),
String.valueOf(sender.getUid()),
dateString,
hourString,
subject.trim(),
body.trim(),
isValid,
String.valueOf(ConfigFileHandler.getMessageLifeTimeForClients()),
String.valueOf(control),
String.valueOf(lifeTime)
};
QueryRunner qRunner = null;
try {
LogWriter.write(
"INFO: Almacenando registro de mensaje en la base de datos ["
+ destination.getLogin()
+ "]");
qRunner = new QueryRunner("INS0003", argsArray);
qRunner.setAutoCommit(false);
qRunner.executeSQL();
qRunner.commit();
} catch (SQLNotFoundException e) {
qRunner.rollback();
LogWriter.write(
"ERROR: No se pudo almacenar mensaje en la base de datos. Instruccion SQL no encontrada");
e.printStackTrace();
} catch (SQLBadArgumentsException e) {
qRunner.rollback();
LogWriter.write(
"ERROR: No se pudo almacenar mensaje en la base de datos. Argumentos Invalidos");
e.printStackTrace();
} catch (SQLException e) {
qRunner.rollback();
LogWriter.write("ERROR: No se pudo almacenar mensaje en la base de datos. Excepcion SQL");
e.printStackTrace();
} finally {
qRunner.closeStatement();
qRunner.setAutoCommit(true);
}
}
}
}
// This method insert a pop user into the CoMeet system
private SocketInfo insertPopUser(String login) {
SocketInfo socketInfo = null;
String line = "";
String names = "";
boolean userExists = false;
try {
BufferedReader in = new BufferedReader(new FileReader("/etc/passwd"));
while ((line = in.readLine()) != null) {
if (line.startsWith(login)) {
userExists = true;
String[] userData = line.split(":");
names = userData[4];
if (names.length() == 0) {
names = "Usuario de Correo";
}
int index = names.indexOf(',');
if (index > 0) {
names = names.substring(0, index);
}
break;
}
}
in.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
// If the user doesn't exist in the file /etc/passwd, do not add him to the CoMeet server
if (!userExists) {
LogWriter.write("ERROR: El usuario {" + login + "} no existe en el servidor de correo");
return null;
}
String[] userInfoArray = {
login,
"d41d8cd98f00b204e9800998ecf8427e",
names,
login + "@" + Pop3Handler.getHost(),
"true",
"false",
ServerConstants.ADMINGROUP + ""
};
QueryRunner qRunner = null;
try {
qRunner = new QueryRunner("INS0001", userInfoArray);
qRunner.setAutoCommit(false);
qRunner.executeSQL();
qRunner.commit();
LogWriter.write("INFO: Usuario {" + login + "} adicionado satisfactoriamente al sistema");
} catch (SQLNotFoundException SNFE) {
qRunner.rollback();
SNFE.printStackTrace();
} catch (SQLBadArgumentsException SBAE) {
qRunner.rollback();
SBAE.printStackTrace();
} catch (SQLException SQLE) {
qRunner.rollback();
String msg =
"ERROR: Falla mientras se ingresaba un nuevo usuario de correo\n"
+ "que no estaba registrado en el sistema.\nLogin: "******"Error adicionando usuario", msg);
SQLE.printStackTrace();
return null;
} finally {
qRunner.closeStatement();
qRunner.setAutoCommit(true);
}
ResultSet resultSet = null;
int uid = -1;
String groupName = "";
try {
qRunner = new QueryRunner("SEL0008", new String[] {login});
resultSet = qRunner.select();
int i = 0;
if (resultSet.next()) {
i++;
uid = resultSet.getInt(1);
groupName = resultSet.getString(2);
}
} catch (SQLNotFoundException e) {
e.printStackTrace();
} catch (SQLBadArgumentsException e) {
e.printStackTrace();
} catch (SQLException e) {
LogWriter.write("ERROR: Falla mientras se consultaba la informacion del usuario: " + login);
e.printStackTrace();
return null;
} finally {
QueryClosingHandler.close(resultSet);
qRunner.closeStatement();
}
socketInfo = SocketServer.getInstaceOfSocketInfo();
socketInfo.setUid(uid);
socketInfo.setLogin(userInfoArray[0]);
socketInfo.setNames(userInfoArray[2]);
socketInfo.setEmail(userInfoArray[3]);
socketInfo.setAdmin(new Boolean(userInfoArray[4]).booleanValue());
socketInfo.setAudit(new Boolean(userInfoArray[5]).booleanValue());
socketInfo.setGroupID(Integer.parseInt(userInfoArray[6]));
socketInfo.setWsName("");
socketInfo.setGroupName(groupName);
return socketInfo;
}
// This method sends an alarm message to the CoMeet group when the system fails
public static void sendAlarm(String subject, String body) {
Vector<SocketInfo> usersVector = SocketServer.getAllClients("COMEET");
int groupSize = usersVector.size();
Date date = Calendar.getInstance().getTime();
String dateString = formatDate.format(date);
String hourString = formatHour.format(date);
for (SocketInfo destination : usersVector) {
EmailSender mail = new EmailSender();
mail.setFrom(Pop3Handler.getUser() + "@" + Pop3Handler.getHost());
mail.setSender(destination.getEmail());
mail.setSubject("[Error CoMeet]: " + subject);
mail.setDate(date);
mail.setMessage(body);
mail.setSenderFullName("Sistema CoMeet");
mail.setWorkStation("Servidor");
mail.send();
LogWriter.write(
"INFO: Enviando notificacion de alarma a {"
+ destination.getEmail()
+ "} / Asunto: ["
+ subject
+ "]");
String isValid = groupSize > 0 ? "true" : "false";
String[] argsArray = {
String.valueOf(destination.getUid()),
String.valueOf(0),
dateString,
hourString,
subject.trim(),
body.trim(),
isValid,
String.valueOf(ConfigFileHandler.getMessageLifeTimeForClients()),
"false",
"-1"
};
QueryRunner qRunner = null;
try {
LogWriter.write("INFO: Almacenando registro de alarma en la base de datos...");
qRunner = new QueryRunner("INS0003", argsArray);
qRunner.setAutoCommit(false);
qRunner.executeSQL();
qRunner.commit();
} catch (SQLNotFoundException e) {
qRunner.rollback();
LogWriter.write(
"ERROR: No se pudo almacenar mensaje en la base de datos. Instruccion SQL no encontrada");
e.printStackTrace();
} catch (SQLBadArgumentsException e) {
qRunner.rollback();
LogWriter.write(
"ERROR: No se pudo almacenar mensaje en la base de datos. Argumentos Invalidos");
e.printStackTrace();
} catch (SQLException e) {
qRunner.rollback();
LogWriter.write("ERROR: No se pudo almacenar mensaje en la base de datos. Excepcion SQL");
e.printStackTrace();
} finally {
qRunner.closeStatement();
qRunner.setAutoCommit(true);
}
}
}
