/**
* Process the specified HTTP request, and create the corresponding HTTP response (or forward to
* another web component that will create it). Return an <code>ActionForward</code> instance
* describing where and how control should be forwarded, or <code>null</code> if the response has
* already been completed.
*
* @param mapping The ActionMapping used to select this instance
* @param form The optional ActionForm bean for this request (if any)
* @param request The HTTP request we are processing
* @param response The HTTP response we are creating
* @exception Exception if business logic throws an exception
*/
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
// Extract attributes we will need
MessageResources messages = getResources(request);
// save errors
ActionMessages errors = new ActionMessages();
// START check for login (security)
if (!SecurityService.getInstance().checkForLogin(request.getSession(false))) {
return (mapping.findForward("welcome"));
}
// END check for login (security)
// START get id of current quote from either request, attribute, or cookie
// id of quote from request
String quoteId = null;
quoteId = request.getParameter("quoteViewId");
// check attribute in request
if (quoteId == null) {
quoteId = (String) request.getAttribute("quoteViewId");
}
// id of quote from cookie
if (quoteId == null) {
quoteId = StandardCode.getInstance().getCookie("quoteViewId", request.getCookies());
}
Integer id = Integer.valueOf(quoteId);
// END get id of current quote from either request, attribute, or cookie
// get quote to and then its sources
Quote1 q = QuoteService.getInstance().getSingleQuote(id);
// this quotes sources
Set sources = q.getSourceDocs();
DynaValidatorForm qvgatd1 = (DynaValidatorForm) form;
qvgatd1.set("sources", (SourceDoc[]) sources.toArray(new SourceDoc[0]));
// place quote into attribute for dispaly
request.setAttribute("quote", q);
// Forward control to the specified success URI
return (mapping.findForward("Success"));
}
/**
* Process the specified HTTP request, and create the corresponding HTTP response (or forward to
* another web component that will create it). Return an <code>ActionForward</code> instance
* describing where and how control should be forwarded, or <code>null</code> if the response has
* already been completed.
*
* @param mapping The ActionMapping used to select this instance
* @param form The optional ActionForm bean for this request (if any)
* @param request The HTTP request we are processing
* @param response The HTTP response we are creating
* @exception Exception if business logic throws an exception
*/
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
// Extract attributes we will need
MessageResources messages = getResources(request);
// save errors
ActionMessages errors = new ActionMessages();
// START check for login (security)
if (!SecurityService.getInstance().checkForLogin(request.getSession(false))) {
return (mapping.findForward("welcome"));
}
// END check for login (security)
// PRIVS check that hrAdmin user is viewing this page
if (!StandardCode.getInstance()
.checkPrivStringArray(
(String[]) request.getSession(false).getAttribute("userPrivs"), "hrAdmin")) {
return (mapping.findForward("accessDenied"));
} // END PRIVS check that hrAdmin user is viewing this page
// get the employee to edit from the request
String hrAdminUserId = request.getParameter("hrAdminUserId");
User u = UserService.getInstance().getSingleUser(Integer.valueOf(hrAdminUserId));
// get new performance review values
DynaValidatorForm ha = (DynaValidatorForm) form;
String dueDate = (String) ha.get("dueDate");
String actualDate = (String) ha.get("actualDate");
String signedDate = (String) ha.get("signedDate");
PerformanceReview performanceReviewNew = (PerformanceReview) ha.get("performanceReviewNew");
if (dueDate.length() > 0) // if entered
performanceReviewNew.setDueDate(DateService.getInstance().convertDate(dueDate).getTime());
if (actualDate.length() > 0) // if entered
performanceReviewNew.setActualDate(DateService.getInstance().convertDate(actualDate).getTime());
if (signedDate.length() > 0) // if entered
performanceReviewNew.setSignedDate(DateService.getInstance().convertDate(signedDate).getTime());
// add new performanceReview to the db
UserService.getInstance().addPerformanceReview(performanceReviewNew, u);
// Forward control to the specified success URI
return (mapping.findForward("Success"));
}
/**
* Process the specified HTTP request, and create the corresponding HTTP response (or forward to
* another web component that will create it). Return an <code>ActionForward</code> instance
* describing where and how control should be forwarded, or <code>null</code> if the response has
* already been completed.
*
* @param mapping The ActionMapping used to select this instance
* @param form The optional ActionForm bean for this request (if any)
* @param request The HTTP request we are processing
* @param response The HTTP response we are creating
* @exception Exception if business logic throws an exception
*/
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
// Extract attributes we will need
MessageResources messages = getResources(request);
// save errors
ActionMessages errors = new ActionMessages();
// START check for login (security)
if (!SecurityService.getInstance().checkForLogin(request.getSession(false))) {
return (mapping.findForward("welcome"));
}
// END check for login (security)
// values for adding the related contact
DynaValidatorForm qae2 = (DynaValidatorForm) form;
// from wizard add clientContact
String contactId = (String) request.getAttribute("clientContactViewId");
if (contactId == null) {
contactId = (String) (qae2.get("contact"));
}
// need the project and contact to build the link between contact and project
String projectId = StandardCode.getInstance().getCookie("projectAddId", request.getCookies());
Project p = ProjectService.getInstance().getSingleProject(Integer.valueOf(projectId));
ClientContact cc =
ClientService.getInstance().getSingleClientContact(Integer.valueOf(contactId));
// insert into db, building link between contact and project
ProjectService.getInstance().linkProjectClientContact(p, cc);
// Forward control to the specified success URI
return (mapping.findForward("Success"));
}
/**
* Process the specified HTTP request, and create the corresponding HTTP response (or forward to
* another web component that will create it). Return an <code>ActionForward</code> instance
* describing where and how control should be forwarded, or <code>null</code> if the response has
* already been completed.
*
* @param mapping The ActionMapping used to select this instance
* @param form The optional ActionForm bean for this request (if any)
* @param request The HTTP request we are processing
* @param response The HTTP response we are creating
* @exception Exception if business logic throws an exception
*/
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
// Extract attributes we will need
MessageResources messages = getResources(request);
// save errors
ActionMessages errors = new ActionMessages();
// START check for login (security)
if (!SecurityService.getInstance().checkForLogin(request.getSession(false))) {
return (mapping.findForward("welcome"));
}
// END check for login (security)
// START get id of current project from either request, attribute, or cookie
// id of project from request
String projectId = null;
projectId = request.getParameter("projectViewId");
// check attribute in request
if (projectId == null) {
projectId = (String) request.getAttribute("projectViewId");
}
// id of project from cookie
if (projectId == null) {
projectId = StandardCode.getInstance().getCookie("projectViewId", request.getCookies());
}
// default project to last if not in request or cookie
if (projectId == null) {
List results = ProjectService.getInstance().getProjectList();
ListIterator iterScroll = null;
for (iterScroll = results.listIterator(); iterScroll.hasNext(); iterScroll.next()) {}
iterScroll.previous();
Project p = (Project) iterScroll.next();
projectId = String.valueOf(p.getProjectId());
}
Integer id = Integer.valueOf(projectId);
// END get id of current project from either request, attribute, or cookie
// get project to edit
Project p = ProjectService.getInstance().getSingleProject(id);
// get this project's sources
Set sources = p.getSourceDocs();
// for each source add each sources' Tasks
List totalLinTasks = new ArrayList();
// for each source
for (Iterator sourceIter = sources.iterator(); sourceIter.hasNext(); ) {
SourceDoc sd = (SourceDoc) sourceIter.next();
// for each target of this source
for (Iterator linTargetIter = sd.getTargetDocs().iterator(); linTargetIter.hasNext(); ) {
TargetDoc td = (TargetDoc) linTargetIter.next();
// for each lin Task of this target
for (Iterator linTaskIter = td.getLinTasks().iterator(); linTaskIter.hasNext(); ) {
LinTask lt = (LinTask) linTaskIter.next();
if (lt.getPersonName() != null
&& lt.getDueDateDate() != null
&& (lt.getTaskName().equalsIgnoreCase("Translation")
|| lt.getTaskName().equalsIgnoreCase("Editing")
|| lt.getTaskName().trim().equalsIgnoreCase("Proofreading")
|| lt.getTaskName().equalsIgnoreCase("Proofreading / Linguistic QA"))) {
totalLinTasks.add(lt);
}
System.out.println(
sd.getLanguage() + "--------" + td.getLanguage() + "---------" + lt.getTaskName());
}
}
}
// Sort by task (orderNum), then source (language), then target (language)
Collections.sort(totalLinTasks, CompareTaskLin.getInstance());
Collections.sort(totalLinTasks, CompareTaskLanguages.getInstance());
// array for display in jsp
LinTask[] linTasksArray = (LinTask[]) totalLinTasks.toArray(new LinTask[0]);
for (int i = 0; i < totalLinTasks.size(); i++) {
request.setAttribute(projectId, log);
}
// place all Tasks for this project into the form for display
DynaValidatorForm qvg = (DynaValidatorForm) form;
// HERE down is standard and does not need to change when adding task blocks
// place this project into request for further display in jsp page
request.setAttribute("project", p);
// add this project id to cookies; this will remember the last project
response.addCookie(StandardCode.getInstance().setCookie("projectViewId", projectId));
// add tab location to cookies; this will remember which tab we are at
response.addCookie(StandardCode.getInstance().setCookie("projectViewTab", "Team"));
// an update of totals may be required
// Forward control to the specified success URI
return (mapping.findForward("Success"));
}
/**
* Process the specified HTTP request, and create the corresponding HTTP response (or forward to
* another web component that will create it). Return an <code>ActionForward</code> instance
* describing where and how control should be forwarded, or <code>null</code> if the response has
* already been completed.
*
* @param mapping The ActionMapping used to select this instance
* @param form The optional ActionForm bean for this request (if any)
* @param request The HTTP request we are processing
* @param response The HTTP response we are creating
* @exception Exception if business logic throws an exception
*/
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
// Extract attributes we will need
MessageResources messages = getResources(request);
// save errors
ActionMessages errors = new ActionMessages();
// START check for login (security)
if (!SecurityService.getInstance().checkForLogin(request.getSession(false))) {
return (mapping.findForward("welcome"));
}
// END check for login (security)
// PRIVS check that hrAdmin user is viewing this page
if (!StandardCode.getInstance()
.checkPrivStringArray(
(String[]) request.getSession(false).getAttribute("userPrivs"), "hrAdmin")) {
return (mapping.findForward("accessDenied"));
} // END PRIVS check that hrAdmin user is viewing this page
// get user to edit from form hidden field
String hrAdminUserId = request.getParameter("hrAdminUserId");
User u = UserService.getInstance().getSingleUser(Integer.valueOf(hrAdminUserId));
User currentUser =
UserService.getInstance()
.getSingleUser((String) request.getSession(false).getAttribute("username"));
// values for update from form; change what is stored in db to these values
DynaValidatorForm uvg = (DynaValidatorForm) form;
String username = (String) uvg.get("username");
String password = (String) uvg.get("password");
// update the user's values
if (username.length() > 0) { // if present
u.setUsername(username);
}
if (password.length() > 0) { // if present, hash password for safe db store
MessageDigest md = null;
try {
md = MessageDigest.getInstance("SHA"); // step 2
} catch (NoSuchAlgorithmException e) {
throw new RuntimeException(e);
}
try {
md.update(password.getBytes("UTF-8")); // step 3
} catch (UnsupportedEncodingException e) {
throw new RuntimeException(e);
}
byte raw[] = md.digest(); // step 4
String hash = (new BASE64Encoder()).encode(raw); // step 5
u.setPassword(hash);
}
// set updated values to db
UserService.getInstance().updateUser(u);
String firstName = u.getFirstName();
String msg =
"<font size='2'><span style='font-family: Verdana,Arial,Helvetica,sans-serif;'>Dear <span style='color: rgb(255, 0, 0);'>"
+ firstName
+ "</span>,<br><br style='font-family: Verdana,Arial,Helvetica,sans-serif;'></span><span style='font-family: Verdana,Arial,Helvetica,sans-serif;'>We have created an account for you on ExcelNet, Excel Translations' proprietary intra/extranet system. <br><br> Below you will find the information you need to enter our system, please keep this only to yourself in a secure place. </span><br style='font-family: Verdana,Arial,Helvetica,sans-serif;'><span style='font-family: Verdana,Arial,Helvetica,sans-serif;'><br>User Name: "
+ username
+ "</span><br style='font-family: Verdana,Arial,Helvetica,sans-serif;'><span style='font-family: Verdana,Arial,Helvetica,sans-serif;'>Password : "
+ password
+ "</span><br style='font-family: Verdana,Arial,Helvetica,sans-serif;'><br style='font-family: Verdana,Arial,Helvetica,sans-serif;'><span style='font-family: Verdana,Arial,Helvetica,sans-serif;'>You can log in into your Account on by clicking </span><a style='font-family: Verdana,Arial,Helvetica,sans-serif;' href='http://excelnet.xltrans.com'>here</a><span style='font-family: Verdana,Arial,Helvetica,sans-serif;'>.<br><br><br>Best Regards,</span><br style='font-family: Verdana,Arial,Helvetica,sans-serif;'><br style='font-family: Verdana,Arial,Helvetica,sans-serif;'><span style='font-family: Verdana,Arial,Helvetica,sans-serif; Best regards,<br style='font-family: Verdana,Arial,Helvetica,sans-serif;'></font><font style='font-family: Verdana,Arial,Helvetica,sans-serif;' size='2'><span class='Apple-style-span' style='border-collapse: separate; color: rgb(0, 0, 0); font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;'><span class='Apple-style-span' style='color: rgb(59, 105, 119); font-size: 11px; text-align: left;'><br> ExcelNet Administrator<br>Excel Translations, Inc.<br><br><img src=http://excelnet.xltrans.com/logo/images/-1168566039logoExcel.gif></span></span></font><br> ";
String emailMsgTxt = msg;
String emailSubjectTxt = "New User Account";
String adminEmail;
String userEmailId = "*****@*****.**";
if (!u.getWorkEmail1().equalsIgnoreCase("")) {
userEmailId = u.getWorkEmail1();
} else if (!u.getWorkEmail2().equalsIgnoreCase("")) {
userEmailId = u.getWorkEmail2();
} else {
userEmailId = "*****@*****.**";
}
if (currentUser.getWorkEmail1() == null || currentUser.getWorkEmail1().equalsIgnoreCase("")) {
adminEmail = "*****@*****.**";
} else adminEmail = currentUser.getWorkEmail1();
try {
String[] emailList = {userEmailId, adminEmail};
SendEmail smtpMailSender = new SendEmail();
smtpMailSender.postMail(emailList, emailSubjectTxt, emailMsgTxt, emailFromAddress);
} catch (Exception e) {
// String[] emailList = {"niteshwar.kumarpatialideas.com"};
// SendEmail smtpMailSender = new SendEmail();
// smtpMailSender.postMail( emailList, emailSubjectTxt, emailMsgTxt, emailFromAddress);
}
// Forward control to the specified success URI
return (mapping.findForward("Success"));
}
/**
* Process the specified HTTP request, and create the corresponding HTTP response (or forward to
* another web component that will create it). Return an <code>ActionForward</code> instance
* describing where and how control should be forwarded, or <code>null</code> if the response has
* already been completed.
*
* @param mapping The ActionMapping used to select this instance
* @param form The optional ActionForm bean for this request (if any)
* @param request The HTTP request we are processing
* @param response The HTTP response we are creating
* @exception Exception if business logic throws an exception
*/
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
// Extract attributes we will need
MessageResources messages = getResources(request);
// save errors
ActionMessages errors = new ActionMessages();
// START check for login (security)
if (!SecurityService.getInstance().checkForLogin(request.getSession(false))) {
return (mapping.findForward("welcome"));
}
// END check for login (security)
// START get id of current project from either request, attribute, or cookie
// id of project from request
String projectId = null;
projectId = request.getParameter("projectViewId");
// check attribute in request
if (projectId == null) {
projectId = (String) request.getAttribute("projectViewId");
}
// id of project from cookie
if (projectId == null) {
projectId = StandardCode.getInstance().getCookie("projectViewId", request.getCookies());
}
// default project to last if not in request or cookie
if (projectId == null) {
java.util.List results = ProjectService.getInstance().getProjectList();
ListIterator iterScroll = null;
for (iterScroll = results.listIterator(); iterScroll.hasNext(); iterScroll.next()) {}
iterScroll.previous();
Project p = (Project) iterScroll.next();
projectId = String.valueOf(p.getProjectId());
}
Integer id = Integer.valueOf(projectId);
// END get id of current project from either request, attribute, or cookie
// get project
Project p = ProjectService.getInstance().getSingleProject(id);
// get user (project manager)
User u =
UserService.getInstance()
.getSingleUserRealName(
StandardCode.getInstance().getFirstName(p.getPm()),
StandardCode.getInstance().getLastName(p.getPm()));
// START process pdf
try {
PdfReader reader = new PdfReader("C://templates/CL01_001.pdf"); // the template
// save the pdf in memory
ByteArrayOutputStream pdfStream = new ByteArrayOutputStream();
// the filled-in pdf
PdfStamper stamp = new PdfStamper(reader, pdfStream);
// stamp.setEncryption(true, "pass", "pass", PdfWriter.AllowCopy | PdfWriter.AllowPrinting);
AcroFields form1 = stamp.getAcroFields();
Date cDate = new Date();
Integer month = cDate.getMonth();
Integer day = cDate.getDate();
Integer year = cDate.getYear() + 1900;
String[] monthName = {
"January",
"February",
"March",
"April",
"May",
"June",
"July",
"August",
"September",
"October",
"November",
"December"
};
// set the field values in the pdf form
// form1.setField("", projectId)
form1.setField("currentdate", monthName[month] + " " + day + ", " + year);
form1.setField(
"firstname", StandardCode.getInstance().noNull(p.getContact().getFirst_name()));
form1.setField("pm", p.getPm());
form1.setField("emailpm", u.getWorkEmail1());
if (u.getWorkPhoneEx() != null && u.getWorkPhoneEx().length() > 0) { // ext present
form1.setField(
"phonepm",
StandardCode.getInstance().noNull(u.getWorkPhone())
+ " ext "
+ StandardCode.getInstance().noNull(u.getWorkPhoneEx()));
} else { // no ext present
form1.setField("phonepm", StandardCode.getInstance().noNull(u.getWorkPhone()));
}
form1.setField("faxpm", StandardCode.getInstance().noNull(u.getLocation().getFax_number()));
form1.setField("postalpm", StandardCode.getInstance().printLocation(u.getLocation()));
// START add images
// if(u.getPicture() != null && u.getPicture().length() > 0) {
// PdfContentByte over;
// Image img = Image.getInstance("C:/Program Files (x86)/Apache Software
// Foundation/Tomcat 7.0/webapps/logo/images/" + u.getPicture());
// img.setAbsolutePosition(200, 200);
// over = stamp.getOverContent(1);
// over.addImage(img, 54, 0,0, 65, 47, 493);
// }
// END add images
form1.setField("productname", StandardCode.getInstance().noNull(p.getProduct()));
form1.setField("project", p.getNumber() + p.getCompany().getCompany_code());
form1.setField("description", StandardCode.getInstance().noNull(p.getProductDescription()));
form1.setField("additional", p.getProjectRequirements());
// get sources and targets
StringBuffer sources = new StringBuffer("");
StringBuffer targets = new StringBuffer("");
if (p.getSourceDocs() != null) {
for (Iterator iterSource = p.getSourceDocs().iterator(); iterSource.hasNext(); ) {
SourceDoc sd = (SourceDoc) iterSource.next();
sources.append(sd.getLanguage() + " ");
if (sd.getTargetDocs() != null) {
for (Iterator iterTarget = sd.getTargetDocs().iterator(); iterTarget.hasNext(); ) {
TargetDoc td = (TargetDoc) iterTarget.next();
if (!td.getLanguage().equals("All")) targets.append(td.getLanguage() + " ");
}
}
}
}
form1.setField("source", sources.toString());
form1.setField("target", targets.toString());
form1.setField(
"start",
(p.getStartDate() != null)
? DateFormat.getDateInstance(DateFormat.SHORT).format(p.getStartDate())
: "");
form1.setField(
"due",
(p.getDueDate() != null)
? DateFormat.getDateInstance(DateFormat.SHORT).format(p.getDueDate())
: "");
if (p.getCompany().getCcurrency().equalsIgnoreCase("USD")) {
form1.setField(
"cost",
(p.getProjectAmount() != null)
? "$ " + StandardCode.getInstance().formatDouble(p.getProjectAmount())
: "");
} else {
form1.setField(
"cost",
(p.getProjectAmount() != null)
? "€ "
+ StandardCode.getInstance()
.formatDouble(p.getProjectAmount() / p.getEuroToUsdExchangeRate())
: "");
}
// stamp.setFormFlattening(true);
stamp.close();
// write to client (web browser)
response.setHeader(
"Content-disposition",
"attachment; filename="
+ p.getNumber()
+ p.getCompany().getCompany_code()
+ "-Order-Confirmation"
+ ".pdf");
OutputStream os = response.getOutputStream();
pdfStream.writeTo(os);
os.flush();
} catch (Exception e) {
System.err.println("PDF Exception:" + e.getMessage());
throw new RuntimeException(e);
}
// END process pdf
// Forward control to the specified success URI
return (mapping.findForward("Success"));
}
/**
* Process the specified HTTP request, and create the corresponding HTTP response (or forward to
* another web component that will create it). Return an <code>ActionForward</code> instance
* describing where and how control should be forwarded, or <code>null</code> if the response has
* already been completed.
*
* @param mapping The ActionMapping used to select this instance
* @param form The optional ActionForm bean for this request (if any)
* @param request The HTTP request we are processing
* @param response The HTTP response we are creating
* @exception Exception if business logic throws an exception
*/
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
// Extract attributes we will need
MessageResources messages = getResources(request);
// save errors
ActionMessages errors = new ActionMessages();
// START check for login (security)
if (!SecurityService.getInstance().checkForLogin(request.getSession(false))) {
return (mapping.findForward("welcome"));
}
// END check for login (security)
// START get id of current quote from either request, attribute, or cookie
// id of quote from request
String projectId = null;
projectId = request.getParameter("projectViewId");
// check attribute in request
if (projectId == null) {
projectId = (String) request.getAttribute("projectViewId");
}
// id of quote from cookie
if (projectId == null) {
projectId = StandardCode.getInstance().getCookie("projectViewId", request.getCookies());
}
// default client to first if not in request or cookie
if (projectId == null) {
List results = QuoteService.getInstance().getQuoteList();
Quote1 first = (Quote1) results.get(0);
projectId = String.valueOf(first.getQuote1Id());
}
// projectId="6553";
Integer id = Integer.valueOf(projectId);
String[] dataValue = new String[11];
Project p = ProjectService.getInstance().getSingleProject(Integer.parseInt(projectId));
// END get id of current quote from either request, attribute, or cookie
// get quote to add files to
// Quote1 q = QuoteService.getInstance().getSingleQuote(p.getQuotes());
Set sources = p.getSourceDocs();
// get the lin task to update
// String linTaskId = StandardCode.getInstance().getCookie("quoteViewGeneralTradosUploadId",
// request.getCookies());
System.out.println(sources.size());
File folder = new File("C:/log");
File[] listOfFiles = folder.listFiles();
for (int ij = 0; ij < listOfFiles.length; ij++) {
if (listOfFiles[ij].isFile() && (listOfFiles[ij].getName().endsWith(".log"))
|| listOfFiles[ij].getName().endsWith(".xls")
|| listOfFiles[ij].getName().endsWith(".xlsx")
|| listOfFiles[ij].getName().endsWith(".xml")) {
String lang = "";
System.out.println("File " + listOfFiles[ij].getName());
String myFile = listOfFiles[ij].getName();
Integer leng = myFile.length();
if (listOfFiles[ij].getName().endsWith(".log")) {
lang =
(String) LanguageAbs.getInstance().getAbs().get(myFile.substring(leng - 6, leng - 4));
} else if (listOfFiles[ij].getName().endsWith(".xlsx")) {
lang =
(String) LanguageAbs.getInstance().getAbs().get(myFile.substring(leng - 7, leng - 5));
} else {
lang =
(String) LanguageAbs.getInstance().getAbs().get(myFile.substring(leng - 6, leng - 4));
}
// List sourceLang = QuoteService.getInstance().getSourceLang1(q);
for (Iterator sourceIter = sources.iterator(); sourceIter.hasNext(); ) {
SourceDoc sd = (SourceDoc) sourceIter.next();
List targetLang = QuoteService.getInstance().getTargetLang(sd.getSourceDocId());
for (Iterator linTargetIter = sd.getTargetDocs().iterator(); linTargetIter.hasNext(); ) {
TargetDoc td = (TargetDoc) linTargetIter.next();
if (td.getLanguage().equalsIgnoreCase(lang)) {
List linTasklist = QuoteService.getInstance().getLinTask(td.getTargetDocId());
for (int k = 0; k < linTasklist.size(); k++) {
LinTask lt = (LinTask) linTasklist.get(k);
// get input stream
// InputStream in = listOfFiles[ij].getInputStream();
if (listOfFiles[ij].getName().endsWith(".log")) {
FileInputStream in = new FileInputStream(listOfFiles[ij]);
// byte[] fileData = listOfFiles[ij].getFileData(); //byte array of entire file
long length = listOfFiles[ij].length();
byte[] fileData = new byte[(int) length];
in.read(fileData); // read data into fileData
String entireRead = new String(fileData); // the entire file as a string
String[] lines = entireRead.split("\n"); // lines within the file
String line = new String(""); // each line
// scroll to totals
int j = 0; // line numbers
try {
while (true) {
line = lines[j++];
if (line != null
&& line.length() > 12
&& line.substring(0, 13).equals("Analyse Total")) {
break;
}
}
// move to repetitions line
j++;
j++;
j++;
String[] parts; // each number per line
String wordRep = null;
String word100 = null;
String word95 = null;
String word85 = null;
String word75 = null;
String word50 = null;
String wordNo = null;
String wordPerfect = null;
String wordContext = null;
String wordTotal = null;
// wordRep
line = lines[j++];
parts = line.split(" ");
for (int i = 0, counter = 0; i < parts.length; i++) {
if (parts[i].length() > 0) { // look for non-blank items and count them
counter++;
}
if (counter == 3) { // if at the words column
wordRep = parts[i];
break;
}
}
// word100
line = lines[j++];
parts = line.split(" ");
for (int i = 0, counter = 0; i < parts.length; i++) {
if (parts[i].length() > 0) { // look for non-blank items and count them
counter++;
}
if (counter == 3) { // if at the words column
word100 = parts[i];
break;
}
}
// word95
line = lines[j++];
parts = line.split(" ");
for (int i = 0, counter = 0; i < parts.length; i++) {
if (parts[i].length() > 0) { // look for non-blank items and count them
counter++;
}
if (counter == 5) { // if at the words column
word95 = parts[i];
break;
}
}
// word85
line = lines[j++];
parts = line.split(" ");
for (int i = 0, counter = 0; i < parts.length; i++) {
if (parts[i].length() > 0) { // look for non-blank items and count them
counter++;
}
if (counter == 5) { // if at the words column
word85 = parts[i];
break;
}
}
// word75
line = lines[j++];
parts = line.split(" ");
for (int i = 0, counter = 0; i < parts.length; i++) {
if (parts[i].length() > 0) { // look for non-blank items and count them
counter++;
}
if (counter == 5) { // if at the words column
word75 = parts[i];
break;
}
}
// word50
line = lines[j++];
parts = line.split(" ");
for (int i = 0, counter = 0; i < parts.length; i++) {
if (parts[i].length() > 0) { // look for non-blank items and count them
counter++;
}
if (counter == 5) { // if at the words column
word50 = parts[i];
break;
}
}
// wordNo
line = lines[j++];
parts = line.split(" ");
for (int i = 0, counter = 0; i < parts.length; i++) {
if (parts[i].length() > 0) { // look for non-blank items and count them
counter++;
}
if (counter == 4) { // if at the words column
wordNo = parts[i];
break;
}
}
// wordTotal
line = lines[j++];
parts = line.split(" ");
for (int i = 0, counter = 0; i < parts.length; i++) {
if (parts[i].length() > 0) { // look for non-blank items and count them
counter++;
}
if (counter == 3) { // if at the words column
wordTotal = parts[i];
break;
}
}
// END process the trados .log file
// remove commas from trados values
wordRep = wordRep.replaceAll(",", "");
word100 = word100.replaceAll(",", "");
word95 = word95.replaceAll(",", "");
word85 = word85.replaceAll(",", "");
word75 = word75.replaceAll(",", "");
word50 = word50.replaceAll(",", "");
wordNo = wordNo.replaceAll(",", "");
// wordPerfect=null;
// wordContext=null;
wordTotal = wordTotal.replaceAll(",", "");
// convert trados values from strings to numbers
Integer numRep = Integer.valueOf(wordRep);
Integer num100 = Integer.valueOf(word100);
Integer num95 = Integer.valueOf(word95);
Integer num85 = Integer.valueOf(word85);
Integer num75 = Integer.valueOf(word75);
Integer num50 = Integer.valueOf(word50);
Integer numNo = Integer.valueOf(wordNo);
Double numTotal = Double.valueOf(wordTotal);
// find totals to save to lin task
int numNew = num50.intValue() + numNo.intValue();
int num8599 = num95.intValue() + num85.intValue();
int numNew4 = num75.intValue() + numNew;
if (lt.getTaskName().equalsIgnoreCase("Translation")) {
// set new trados values for the lin task
lt.setWordRep(numRep);
lt.setWord100(num100);
lt.setWord95(num95);
lt.setWord85(num85);
lt.setWord75(num75);
lt.setWordNew(new Integer(numNew));
lt.setWord8599(new Integer(num8599));
lt.setWordNew4(new Double(numNew4));
lt.setWordTotal(numTotal);
} else if (lt.getTaskName().equalsIgnoreCase("editing")) {
lt.setWordNew4(numTotal);
lt.setWordTotal(numTotal);
}
// upload the new trados values to db
ProjectService.getInstance().updateLinTask(lt);
// START get file list
// get input stream
in.close();
in = new FileInputStream(listOfFiles[ij]);
length = listOfFiles[ij].length();
fileData = new byte[(int) length];
in.read(fileData); // read data into fileData
entireRead = new String(fileData); // the entire file as a string
lines = entireRead.split("\n"); // lines within the file
line = new String(""); // each line
} catch (Exception e) {
}
in.close();
} else if (listOfFiles[ij].isFile() && listOfFiles[ij].getName().endsWith(".xls")) {
POIFSFileSystem fs =
new POIFSFileSystem(
new FileInputStream("C:/log/" + listOfFiles[ij].getName()));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row;
HSSFCell cell;
int count = 0, i = 0;
String flag = "true";
Iterator rows = sheet.rowIterator();
while (rows.hasNext()) {
row = (HSSFRow) rows.next();
count = 0;
Iterator cells = row.cellIterator();
while (cells.hasNext()) {
cell = (HSSFCell) cells.next();
count++;
try {
if (count == 4 && flag.equalsIgnoreCase("true")) {
dataValue[i++] = cell.toString();
System.out.println("cel value----------> " + cell.toString());
if (i > 10) {
flag = "false";
}
}
} catch (Exception e) {
System.out.println("Integer Value" + count++);
}
}
}
Integer numRep = Math.round(Float.parseFloat(dataValue[2]));
Integer num100 = Math.round(Float.parseFloat(dataValue[4]));
Integer num95 = Math.round(Float.parseFloat(dataValue[5]));
Integer num85 = Math.round(Float.parseFloat(dataValue[6]));
Integer num75 = Math.round(Float.parseFloat(dataValue[7]));
Integer num50 = Math.round(Float.parseFloat(dataValue[8]));
Integer numNo = Math.round(Float.parseFloat(dataValue[9]));
Integer numPerfect = Math.round(Float.parseFloat(dataValue[1]));
Integer numContext = Math.round(Float.parseFloat(dataValue[3]));
Double numTotal = Double.valueOf(dataValue[10]);
// numRep = Integer.parseInt(dataValue[1]);
int numNew = num50.intValue() + numNo.intValue();
int num8599 = num95.intValue() + num85.intValue();
int numNew4 = num75.intValue() + numNew;
if (lt.getTaskName().equalsIgnoreCase("Translation")) {
// set new trados values for the lin task
lt.setWordRep(numRep);
lt.setWord100(num100);
lt.setWord95(num95);
lt.setWord85(num85);
lt.setWord75(num75);
lt.setWordNew(new Integer(numNew));
lt.setWord8599(new Integer(num8599));
lt.setWordNew4(new Double(numNew4));
lt.setWordContext(numContext);
lt.setWordPerfect(numPerfect);
lt.setWordTotal(numTotal);
} else if (lt.getTaskName().equalsIgnoreCase("editing")) {
lt.setWordNew4(numTotal);
lt.setWordTotal(numTotal);
}
// upload the new trados values to db
ProjectService.getInstance().updateLinTask(lt);
} else if (listOfFiles[ij].isFile()
&& listOfFiles[ij].getName().endsWith(".xlsx")) {
// POIFSFileSystem fs = new
// POIFSFileSystem(new FileInputStream("C:/log/" + listOfFiles[ij].getName()));
// File file = new File("C:/log/" +
// listOfFiles[ij].getName());
// OPCPackage pkg = OPCPackage.open(new
// FileInputStream(file.getAbsolutePath()));
// XSSFWorkbook wb = new XSSFWorkbook(pkg);
InputStream fs = new FileInputStream("C:/log/" + listOfFiles[ij].getName());
XSSFWorkbook wb = new XSSFWorkbook(fs);
// XSSFWorkbook wb = new XSSFWorkbook(fs);
XSSFSheet sheet = wb.getSheetAt(0);
XSSFRow row;
XSSFCell cell;
int count = 0, i = 0;
String flag = "true";
Iterator rows = sheet.rowIterator();
while (rows.hasNext()) {
row = (XSSFRow) rows.next();
count = 0;
Iterator cells = row.cellIterator();
while (cells.hasNext()) {
cell = (XSSFCell) cells.next();
count++;
try {
if (count == 4 && flag.equalsIgnoreCase("true")) {
dataValue[i++] = cell.toString();
System.out.println("cel value----------> " + cell.toString());
if (i > 10) {
flag = "false";
}
}
} catch (Exception e) {
System.out.println("Integer Value" + count++);
}
}
}
Integer numRep = Math.round(Float.parseFloat(dataValue[2]));
Integer num100 = Math.round(Float.parseFloat(dataValue[4]));
Integer num95 = Math.round(Float.parseFloat(dataValue[5]));
Integer num85 = Math.round(Float.parseFloat(dataValue[6]));
Integer num75 = Math.round(Float.parseFloat(dataValue[7]));
Integer num50 = Math.round(Float.parseFloat(dataValue[8]));
Integer numNo = Math.round(Float.parseFloat(dataValue[9]));
Double numTotal = Double.valueOf(dataValue[10]);
// numRep = Integer.parseInt(dataValue[1]);
int numNew = num50.intValue() + numNo.intValue();
int num8599 = num95.intValue() + num85.intValue();
int numNew4 = num75.intValue() + numNew;
if (lt.getTaskName().equalsIgnoreCase("Translation")) {
// set new trados values for the lin task
lt.setWordRep(numRep);
lt.setWord100(num100);
lt.setWord95(num95);
lt.setWord85(num85);
lt.setWord75(num75);
lt.setWordNew(new Integer(numNew));
lt.setWord8599(new Integer(num8599));
lt.setWordNew4(new Double(numNew4));
lt.setWordTotal(numTotal);
} else if (lt.getTaskName().equalsIgnoreCase("editing")) {
lt.setWordNew4(numTotal);
lt.setWordTotal(numTotal);
}
// upload the new trados values to db
ProjectService.getInstance().updateLinTask(lt);
} else if (listOfFiles[ij].isFile() && listOfFiles[ij].getName().endsWith(".xml")) {
InputStream in = new FileInputStream("C:/log/" + listOfFiles[ij].getName());
System.setProperty(
"javax.xml.parsers.DocumentBuilderFactory",
"com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl");
DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder dBuilder = dbFactory.newDocumentBuilder();
Document doc = dBuilder.parse(in);
doc.getDocumentElement().normalize();
System.out.println("Root element :" + doc.getDocumentElement().getNodeName());
Integer numRep = 0;
Integer num100 = 0;
Integer num95 = 0;
Integer num85 = 0;
Integer num75 = 0;
Integer num50 = 0;
Integer numNo = 0;
Integer numTotal = 0;
Integer numContext = 0;
Integer numPerfect = 0;
NodeList batchTotal = doc.getElementsByTagName("batchTotal");
// Element eElement = (Element) batchTotal;
// NodeList analyse =
// eElement.getElementsByTagName("analyse");
if (batchTotal != null && batchTotal.getLength() > 0) {
Node node = batchTotal.item(0);
if (node.getNodeType() == Node.ELEMENT_NODE) {
Element eElement = (Element) node;
NodeList analyse = eElement.getElementsByTagName("analyse");
if (analyse != null && analyse.getLength() > 0) {
Node node1 = analyse.item(0);
if (node1.getNodeType() == Node.ELEMENT_NODE) {
Element eElement1 = (Element) node1;
// NodeList analyse1 =
// eElement.getElementsByTagName("analyse");
eElement1.getElementsByTagName("fuzzy").item(0).getTextContent();
NodeList fuzzy = doc.getElementsByTagName("fuzzy");
for (int temp = 0; temp < fuzzy.getLength(); temp++) {
Node nNode = fuzzy.item(temp);
System.out.println("\nCurrent Element :" + nNode.getNodeName());
if (nNode.getNodeType() == Node.ELEMENT_NODE) {
Element eElement2 = (Element) nNode;
if (eElement2.getAttribute("min").equalsIgnoreCase("50")
&& eElement2.getAttribute("max").equalsIgnoreCase("74")) {
num50 = Integer.parseInt(eElement2.getAttribute("words"));
}
if (eElement2.getAttribute("min").equalsIgnoreCase("75")
&& eElement2.getAttribute("max").equalsIgnoreCase("84")) {
num75 = Integer.parseInt(eElement2.getAttribute("words"));
}
if (eElement2.getAttribute("min").equalsIgnoreCase("85")
&& eElement2.getAttribute("max").equalsIgnoreCase("94")) {
num85 = Integer.parseInt(eElement2.getAttribute("words"));
}
if (eElement2.getAttribute("min").equalsIgnoreCase("95")
&& eElement2.getAttribute("max").equalsIgnoreCase("99")) {
num95 = Integer.parseInt(eElement2.getAttribute("words"));
}
}
}
//
eElement1.getElementsByTagName("new").item(0).getTextContent();
NodeList new1 = doc.getElementsByTagName("new");
for (int temp = 0; temp < new1.getLength(); temp++) {
Node nNode = new1.item(temp);
if (nNode.getNodeType() == Node.ELEMENT_NODE) {
Element eElement2 = (Element) nNode;
numNo = Integer.parseInt(eElement2.getAttribute("words"));
}
}
eElement1.getElementsByTagName("total").item(0).getTextContent();
NodeList total = doc.getElementsByTagName("total");
for (int temp = 0; temp < total.getLength(); temp++) {
Node nNode = total.item(temp);
if (nNode.getNodeType() == Node.ELEMENT_NODE) {
Element eElement2 = (Element) nNode;
numTotal = Integer.parseInt(eElement2.getAttribute("words"));
}
}
eElement1.getElementsByTagName("exact").item(0).getTextContent();
NodeList exact = doc.getElementsByTagName("exact");
for (int temp = 0; temp < exact.getLength(); temp++) {
Node nNode = exact.item(temp);
if (nNode.getNodeType() == Node.ELEMENT_NODE) {
Element eElement2 = (Element) nNode;
num100 = Integer.parseInt(eElement2.getAttribute("words"));
}
}
eElement1.getElementsByTagName("perfect").item(0).getTextContent();
NodeList perfect = doc.getElementsByTagName("perfect");
for (int temp = 0; temp < perfect.getLength(); temp++) {
Node nNode = perfect.item(temp);
if (nNode.getNodeType() == Node.ELEMENT_NODE) {
Element eElement2 = (Element) nNode;
numPerfect = Integer.parseInt(eElement2.getAttribute("words"));
}
}
eElement1.getElementsByTagName("repeated").item(0).getTextContent();
NodeList repeated = doc.getElementsByTagName("repeated");
for (int temp = 0; temp < repeated.getLength(); temp++) {
Node nNode = repeated.item(temp);
if (nNode.getNodeType() == Node.ELEMENT_NODE) {
Element eElement2 = (Element) nNode;
numRep = Integer.parseInt(eElement2.getAttribute("words"));
}
}
try {
eElement1
.getElementsByTagName("crossFileRepeated")
.item(0)
.getTextContent();
NodeList crossFileRepeated =
doc.getElementsByTagName("crossFileRepeated");
for (int temp = 0; temp < crossFileRepeated.getLength(); temp++) {
Node nNode = crossFileRepeated.item(temp);
if (nNode.getNodeType() == Node.ELEMENT_NODE) {
Element eElement2 = (Element) nNode;
numRep += Integer.parseInt(eElement2.getAttribute("words"));
}
}
} catch (Exception e) {
}
eElement1.getElementsByTagName("inContextExact").item(0).getTextContent();
NodeList inContextExact = doc.getElementsByTagName("inContextExact");
for (int temp = 0; temp < inContextExact.getLength(); temp++) {
Node nNode = inContextExact.item(temp);
if (nNode.getNodeType() == Node.ELEMENT_NODE) {
Element eElement2 = (Element) nNode;
numContext = Integer.parseInt(eElement2.getAttribute("words"));
}
}
}
}
}
}
int numNew = num50.intValue() + numNo.intValue();
int num8599 = num95.intValue() + num85.intValue();
int numNew4 = num75.intValue() + numNew;
if (lt.getTaskName().equalsIgnoreCase("Translation")) {
// set new trados values for the lin task
lt.setWordRep(numRep);
lt.setWord100(num100);
lt.setWord95(num95);
lt.setWord85(num85);
lt.setWord75(num75);
lt.setWordNew(new Integer(numNew));
lt.setWord8599(new Integer(num8599));
lt.setWordNew4(new Double(numNew4));
lt.setWordTotal(new Double(numTotal));
lt.setWordContext(numContext);
lt.setWordPerfect(numPerfect);
} else if (lt.getTaskName().equalsIgnoreCase("editing")) {
lt.setWordNew(new Integer(numTotal));
lt.setWordNew4(new Double(numTotal));
lt.setWordTotal(new Double(numTotal));
}
// upload the new trados values to db
ProjectService.getInstance().updateLinTask(lt);
} else {
System.out.println("no Match");
request.setAttribute("isError", "error");
return (mapping.findForward("Error"));
}
}
}
}
}
} else if (listOfFiles[ij].isDirectory()) {
System.out.println("Directory " + listOfFiles[ij].getName());
}
}
deleteFile("C:/log");
// END get file list
// Forward control to the specified success URI
return (mapping.findForward("Success"));
}