/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String url = request.getParameter("url_req");
String user = request.getParameter("username");
String password = request.getParameter("password");
String[] remember = request.getParameterValues("cookie");
try {
User u = RegistrationManager.verifyUser(user, password);
if (u != null) {
if (!u.getProfile().equals(RegistrationManager.NO_PROFILES)) {
request.getSession().setAttribute("user", u);
if (remember != null) {
Cookie cookie = new Cookie("user", user);
cookie.setMaxAge(30 * 24 * 60 * 60); // 1 month.
cookie.setPath("/");
response.addCookie(cookie);
}
u.updateLastAccess(user);
if (url.equals("null")) response.sendRedirect("index.jsp");
else response.sendRedirect(url);
} else {
request.setAttribute(
StringConstants.MESSAGE_ATTRIBUTE, StringConstants.MESSAGE_DOMAIN_ERROR);
request.getRequestDispatcher("login.jsp").forward(request, response);
}
} else {
request.setAttribute(StringConstants.MESSAGE_ATTRIBUTE, StringConstants.MESSAGE_ERROR);
request.getRequestDispatcher("login.jsp").forward(request, response);
}
} catch (IOException | ServletException e) {
request.setAttribute(StringConstants.MESSAGE_ATTRIBUTE, StringConstants.MESSAGE_ERROR_SERVER);
request.getRequestDispatcher("login.jsp").forward(request, response);
}
}
public boolean validateUser(String username, String password) {
User res = this.select(username);
if (res != null) {
if (password.equals(res.getPassword())) {
return true;
}
}
return false;
}
public static ArrayList<PickingRequisition> getFinish(String plant, String storeroom, User user)
throws SQLException {
Statement stm = StatementManager.getSQLStatement();
String query_selreq =
"SELECT selreq.selreq_id, selreq.begin_time, selreq.finish_time , user.eid, user.firstname, user.lastname "
+ "FROM selreq "
+ "join user on user.uid = selreq.uid "
+ "join requisition on selreq.selreq_id = requisition.selreq_id "
+ "WHERE selreq.status = 'finished' ";
if (user.getUsergroup() > 1) {
query_selreq +=
"and requisition.plant = '"
+ plant
+ "' and requisition.storeroom = '"
+ storeroom
+ "' ";
}
query_selreq +=
"group by selreq.selreq_id, selreq.begin_time, user.uid, user.firstname, user.lastname";
ResultSet selreq_rs = stm.executeQuery(query_selreq);
// create selreq List
ArrayList<PickingRequisition> selList = new ArrayList<PickingRequisition>();
while (selreq_rs.next()) {
selList.add(
new PickingRequisition(
selreq_rs.getInt("selreq_id"),
selreq_rs.getInt("eid"),
selreq_rs.getString("firstname"),
selreq_rs.getString("lastname"),
selreq_rs.getTimestamp("begin_time"),
selreq_rs.getTimestamp("finish_time")));
}
String query_item =
"SELECT itemusage_id , itemnum, description, binnum, amount, unit ,requisition.req_id, requisition.resv_eid "
+ "FROM itemusage join requisition on itemusage.req_id = requisition.req_id "
+ "WHERE requisition.status = 'finished' ";
if (user.getUsergroup() > 1) {
query_item +=
" AND requisition.plant = '"
+ plant
+ "' AND requisition.storeroom = '"
+ storeroom
+ "' ";
}
query_item += "ORDER BY req_id asc";
ResultSet item_rs = stm.executeQuery(query_item);
Map<Integer, ItemList> itemList = new HashMap<Integer, ItemList>();
while (item_rs.next()) {
int req_id = item_rs.getInt("req_id");
Item i =
new Item(
req_id,
item_rs.getInt("itemnum"),
item_rs.getString("description"),
item_rs.getString("binnum"),
item_rs.getInt("amount"),
item_rs.getString("unit"),
item_rs.getInt("resv_eid"));
ItemList il;
if (!itemList.containsKey(req_id)) {
il = new ItemList();
itemList.put(req_id, il);
} else {
il = itemList.get(req_id);
}
il.add(i);
}
// add Requisition to selreq
String query_req =
"SELECT req_id ,resv_eid, resv_name, resv_team, enterdate, status, type, selreq_id, plant, storeroom "
+ "FROM requisition "
+ "WHERE status = 'finished' ";
if (user.getUsergroup() > 1) {
query_req += "AND plant = '" + plant + "' AND storeroom = '" + storeroom + "' ";
}
query_req += "ORDER BY req_id asc ";
ResultSet req_rs = stm.executeQuery(query_req);
while (req_rs.next()) {
for (int i = 0; i < selList.size(); i++) {
PickingRequisition p = selList.get(i);
int selID = req_rs.getInt("selreq_id");
if (selID == p.getID()) {
Requisition r =
new Requisition(
req_rs.getInt("req_id"),
req_rs.getInt("resv_eid"),
req_rs.getString("resv_name"),
req_rs.getString("resv_team"),
req_rs.getDate("enterdate"),
req_rs.getString("plant"),
req_rs.getString("storeroom"),
req_rs.getString("status"),
req_rs.getString("type"));
ItemList il = itemList.get(req_rs.getInt("req_id"));
for (int j = 0; j < il.size(); j++) {
r.addItem(il.getItem(j));
}
p.add(r);
break;
}
}
}
stm.close();
return selList;
}
