List of usage examples for org.apache.poi.xssf.usermodel XSSFRow getCell
@Override public XSSFCell getCell(int cellnum)
From source file:com.sandstone_tech.lendfastselenium2.util.PoiFileReader.java
/** * //from w ww . j a v a 2s.c om * * @param row * @return */ private SignedDeclaration getSignedDeclaration(XSSFRow row) { SignedDeclaration signedDeclaration = new SignedDeclaration(); signedDeclaration.setPartySignedDeclaration(getStringValue(row.getCell(19))); signedDeclaration.setIdType(getStringValue(row.getCell(20))); signedDeclaration.setLicenseState(getStringValue(row.getCell(21))); signedDeclaration.setPartyIdNo(getStringValue(row.getCell(22))); return signedDeclaration; }
From source file:com.sandstone_tech.lendfastselenium2.util.PoiFileReader.java
/** * /*from w w w . java2 s . c om*/ * * @param row * @return */ private PersonalDetailsModel getPersonalDetail(XSSFRow row) { PersonalDetailsModel personalDetails = new PersonalDetailsModel(); personalDetails.setIsExistingCustomer(getStringValue(row.getCell(8))); personalDetails.setCustomerTitle(getStringValue(row.getCell(9))); personalDetails.setFirstname(getStringValue(row.getCell(10))); personalDetails.setSurname(getStringValue(row.getCell(11))); personalDetails.setBirthday(getStringValue(row.getCell(12))); personalDetails.setMaritalStatus(getStringValue(row.getCell(13))); personalDetails.setSpouse(getStringValue(row.getCell(14))); personalDetails.setGender(getStringValue(row.getCell(15))); personalDetails.setPrefContactMethod(getStringValue(row.getCell(16))); personalDetails.setHomePhoneNo(getStringValue(row.getCell(17))); personalDetails.setHasDependent(getStringValue(row.getCell(18))); return personalDetails; }
From source file:com.sandstone_tech.lendfastselenium2.util.PoiFileReader.java
/** * /*from w w w. j a va 2s. co m*/ * * @param row * @return */ private CurrentAddress getCurrentAddress(XSSFRow row) { CurrentAddress currentAddress = new CurrentAddress(); currentAddress.setResidentialStatus(getStringValue(row.getCell(23))); currentAddress.setResidencyStatus(getStringValue(row.getCell(24))); currentAddress.setNumber(getStringValue(row.getCell(25))); currentAddress.setStreetName(getStringValue(row.getCell(26))); currentAddress.setStreetType(getStringValue(row.getCell(27))); currentAddress.setStreetSuffix(getStringValue(row.getCell(28))); currentAddress.setSuburbName(getStringValue(row.getCell(29))); currentAddress.setState(getStringValue(row.getCell(30))); currentAddress.setPostcode(getStringValue(row.getCell(31))); currentAddress.setFullAddress(getStringValue(row.getCell(32))); currentAddress.setYears(getStringValue(row.getCell(33))); currentAddress.setMonths(getStringValue(row.getCell(34))); currentAddress.setSameAsResidential(getStringValue(row.getCell(35))); return currentAddress; }
From source file:com.sandstone_tech.lendfastselenium2.util.PoiFileReader.java
/** * //from w w w .j a v a 2 s . c o m * * @param row * @return */ private EmploymentDetails getEmploymentDetails(XSSFRow row) { EmploymentDetails employmentDetails = new EmploymentDetails(); employmentDetails.setOccupationCategory(getStringValue(row.getCell(36))); employmentDetails.setOccupationSubtype(getStringValue(row.getCell(37))); employmentDetails.setStatus(getStringValue(row.getCell(38))); employmentDetails.setEmployerType(getStringValue(row.getCell(39))); employmentDetails.setEmployerName(getStringValue(row.getCell(40))); employmentDetails.setSearchAddress(getStringValue(row.getCell(41))); employmentDetails.setAddress(getStringValue(row.getCell(42))); employmentDetails.setAddressVerify(getStringValue(row.getCell(43))); employmentDetails.setProbationaryPeriod(getStringValue(row.getCell(44))); employmentDetails.setIncomeMethod(getStringValue(row.getCell(45))); employmentDetails.setIncome(getStringValue(row.getCell(46))); employmentDetails.setIncomeStatus(getStringValue(row.getCell(47))); employmentDetails.setFrequency(getStringValue(row.getCell(48))); employmentDetails.setBonus(getStringValue(row.getCell(49))); employmentDetails.setCommisionBonusIncome(getStringValue(row.getCell(50))); employmentDetails.setYears(getStringValue(row.getCell(51))); employmentDetails.setMonths(getStringValue(row.getCell(52))); employmentDetails.setEmployeePhoneNo(getStringValue(row.getCell(53))); return employmentDetails; }
From source file:com.sandstone_tech.lendfastselenium2.util.PoiFileReader.java
/** * /*from ww w . j ava 2 s . c o m*/ * * @param row * @return */ private PreviousEmploymentDetails getPreviousEmploymentDetails(XSSFRow row) { PreviousEmploymentDetails details = new PreviousEmploymentDetails(); details.setCategory(getStringValue(row.getCell(55))); details.setSubType(getStringValue(row.getCell(56))); details.setYears(getStringValue(row.getCell(57))); details.setMonths(getStringValue(row.getCell(58))); return details; }
From source file:com.sandstone_tech.lendfastselenium2.util.PoiFileReader.java
/** * Extracts {@link PropertyContract} data from excel * // w ww. j a v a2 s . com * @param row * @return */ private PropertyContract getPropertyContract(XSSFRow row) { PropertyContract contract = new PropertyContract(); contract.setForPreApproval(getStringValue(row.getCell(60))); contract.setForSecurity(getStringValue(row.getCell(61))); ; contract.setPropertyFound(getStringValue(row.getCell(62))); contract.setAddress(getStringValue(row.getCell(63))); contract.setAddressSelect(getStringValue(row.getCell(64))); contract.setAddressVerify(getStringValue(row.getCell(65))); contract.setEnteredContractSale(getStringValue(row.getCell(66))); contract.setHasCopyOfContract(getStringValue(row.getCell(67))); contract.setHasSignedByAll(getStringValue(row.getCell(68))); contract.setVendorName(getStringValue(row.getCell(69))); return contract; }
From source file:com.sandstone_tech.lendfastselenium2.util.PoiFileReader.java
/** * Extracts {@link PropertyPurpose} data from excel * // www .j av a 2 s .c om * @param row * @return */ private PropertyPurpose getPropertyPurpose(XSSFRow row) { PropertyPurpose purpose = new PropertyPurpose(); purpose.setPurposeType(getStringValue(row.getCell(70))); purpose.setTypeANZ(getStringValue(row.getCell(71))); purpose.setPropertyType(getStringValue(row.getCell(72))); purpose.setZoning(getStringValue(row.getCell(73))); purpose.setQtyBedrooms(getStringValue(row.getCell(74))); purpose.setQtyBathrooms(getStringValue(row.getCell(75))); purpose.setPrice(getStringValue(row.getCell(76))); purpose.setForInvestment(getStringValue(row.getCell(77))); purpose.setPrincipalResidenceForAny(getStringValue(row.getCell(78))); purpose.setLandArea(getStringValue(row.getCell(79))); purpose.setMortgageFirst(getStringValue(row.getCell(80))); return purpose; }
From source file:com.smanempat.controller.ControllerClassification.java
private void showXLSX(JTextField txtFileDirectory, JTable tablePreview) throws FileNotFoundException, IOException { DefaultTableModel tableModel = new DefaultTableModel(); File fileName = new File(txtFileDirectory.getText()); FileInputStream inputStream = new FileInputStream(fileName); XSSFWorkbook workbook = new XSSFWorkbook(inputStream); XSSFSheet sheet = workbook.getSheetAt(0); int rowValue = sheet.getLastRowNum() + 1; int colValue = sheet.getRow(0).getLastCellNum(); String[][] data = new String[rowValue][colValue]; String[] colName = new String[colValue]; for (int i = 0; i < rowValue; i++) { XSSFRow row = sheet.getRow(i); for (int j = 0; j < colValue; j++) { XSSFCell cell = row.getCell(j); int type = cell.getCellType(); Object returnCellValue = null; if (type == 0) { returnCellValue = cell.getNumericCellValue(); } else if (type == 1) { returnCellValue = cell.getStringCellValue(); }//from w ww . ja va 2 s .c o m data[i][j] = returnCellValue.toString(); } } for (int i = 0; i < colValue; i++) { colName[i] = data[0][i]; } tableModel = new DefaultTableModel(data, colName); tablePreview.setModel(tableModel); tableModel.removeRow(0); }
From source file:com.smanempat.view.ReadWorkbook.java
private void ekstensiXLSXTraining() { try {//from ww w. ja v a 2 s . com FileInputStream FIS = new FileInputStream(new File(txtNamaFile.getText())); XSSFWorkbook wb = new XSSFWorkbook(FIS); XSSFSheet ws = wb.getSheetAt(0); int baris = ws.getLastRowNum() + 1; System.out.println(baris); int kolom = ws.getRow(0).getLastCellNum(); System.out.println(kolom); String[][] data = new String[baris][kolom]; String[] nKolom = new String[kolom]; for (int i = 0; i < baris; i++) { XSSFRow row = ws.getRow(i); for (int j = 0; j < kolom; j++) { XSSFCell cell = row.getCell(j); System.out.println("Isi Cell Adalah =" + cell); String value = nilaiCell(cell); data[i][j] = value; System.out.println("data['" + i + "']['" + j + "'] " + data[i][j]); } } //ambil nama kolom pada index data baris ke 0 for (int a = 0; a < kolom; a++) { nKolom[a] = data[0][a]; } //Isi ke database String nim = null; String nama = null; String nilai = null; for (int b = 1; b < baris; b++) { int c = 0; while (c < kolom) { nim = data[b][c]; nama = data[b][c + 1]; nilai = data[b][c + 2]; break; } insert(nim, nama, nilai); } DefaultTableModel DTM = new DefaultTableModel(data, nKolom); jTable1.setModel(DTM); DTM.removeRow(0); } catch (Exception er1) { System.out.print("Error : \n" + er1.toString()); } }
From source file:com.viettel.hqmc.DAO.FilesDAO.java
/** * import du lieu tu excel/* w w w .j a v a 2 s. c o m*/ * * @return */ public String importFileFromExcel() throws FileNotFoundException, IOException, ParseException { List fileInfo = new ArrayList(); String strReturn = ERROR_PERMISSION; // TechnicalStandard ts = new TechnicalStandard(); TechnicalStandardDAOHE tshe = new TechnicalStandardDAOHE(); String err = ""; Long attachId = Long.parseLong(getRequest().getParameter("attachId"));//get attactId VoAttachs att = (VoAttachs) getSession().get("com.viettel.voffice.database.BO.VoAttachs", attachId);//Attachs BO if (att == null) { fileInfo.add("File not found"); err += "File not found"; } else { Category item; ResourceBundle rb = ResourceBundle.getBundle("config");//get link tuong doi String dir = rb.getString("directoryExcel"); String linkFile = att.getAttachPath(); linkFile = dir + linkFile; createForm.setPath(linkFile); InputStream myxls = new FileInputStream(linkFile);//get file excel XSSFWorkbook wb = new XSSFWorkbook(myxls); XSSFRow row = null; String matchingTarget = null; XSSFCell productName = null; XSSFCell businessTaxCode = null; XSSFCell manufactorAddress = null; XSSFCell manufactorName = null; XSSFCell manufactorTel = null; XSSFCell manufactorFax = null; XSSFCell manufactorEmail = null; XSSFCell nationName = null; XSSFCell signer = null; XSSFCell assessmentMethod = null; XSSFCell annoucementNo = null; XSSFCell pushlishDate = null; XSSFCell nationCompanyName = null; XSSFCell nationCompanyAddress = null; try { XSSFSheet sheet = wb.getSheetAt(0); try { // XSSFSheet sheet1 = wb.getSheetAt(1); } catch (Exception ex) { LogUtil.addLog(ex);//binhnt sonar a160901 // log.error(e.getMessage()); err += "Khng tm thy Sheet Chi tit sn phm, "; } try { // XSSFSheet sheet2 = wb.getSheetAt(2); } catch (Exception ex) { // log.error(e.getMessage()); LogUtil.addLog(ex);//binhnt sonar a160901 err += "Khng tm thy Sheet Ch tiu cht lng ch yu, "; } try { // XSSFSheet sheet3 = wb.getSheetAt(3); } catch (Exception ex) { LogUtil.addLog(ex);//binhnt sonar a160901 // log.error(e.getMessage()); err += "Khng tm thy Sheet Ch tiu vi sinh vt, "; } try { // XSSFSheet sheet4 = wb.getSheetAt(4); } catch (Exception ex) { LogUtil.addLog(ex);//binhnt sonar a160901 // log.error(e.getMessage()); err += "Khng tm thy Sheet Hm lng kim loi nng, "; } try { // XSSFSheet sheet5 = wb.getSheetAt(5); } catch (Exception ex) { LogUtil.addLog(ex);//binhnt sonar a160901 // log.error(e.getMessage()); err += "Khng tm thy Sheet Hm lng ha cht, "; } try { // XSSFSheet sheet6 = wb.getSheetAt(6); } catch (Exception ex) { LogUtil.addLog(ex);//binhnt sonar a160901 // log.error(e.getMessage()); err += "Khng tm thy Sheet K hoch kim sot cht lng, "; } if (sheet == null) { err += "Khng tm thy Sheet Bn cng b, "; } else { String sheetName = sheet.getSheetName(); if (!"Ban_Cong_bo".equals(sheetName)) { err += "Sai tn sheet Bn cng b, "; } } // XSSFRow firstRow = sheet.getRow(1); int rowNums = sheet.getLastRowNum(); // UsersDAOHE sdhe = new UsersDAOHE(); // SimpleDateFormat formatter = new SimpleDateFormat("dd/MM/yyyy"); row = sheet.getRow(1); businessTaxCode = row.getCell((short) 1); productName = row.getCell((short) 3); row = sheet.getRow(4); manufactorName = row.getCell((short) 1); manufactorAddress = row.getCell((short) 3); row = sheet.getRow(5); manufactorTel = row.getCell((short) 1); manufactorFax = row.getCell((short) 3); row = sheet.getRow(6); manufactorEmail = row.getCell((short) 1); nationName = row.getCell((short) 3); row = sheet.getRow(7); nationCompanyName = row.getCell((short) 1); nationCompanyAddress = row.getCell((short) 3); row = sheet.getRow(10); annoucementNo = row.getCell((short) 1); pushlishDate = row.getCell((short) 3); row = sheet.getRow(11); signer = row.getCell((short) 1); assessmentMethod = row.getCell((short) 3); matchingTarget = ""; String standardCode; for (int i = 12; i < rowNums; i++) { row = sheet.getRow(i); if (row.getCell((short) 1).toString() != "") { XSSFCell standardCodeCell = row.getCell((short) 1); standardCode = standardCodeCell.getRichStringCellValue().toString(); if (tshe.findStandardByCode(standardCode)) { XSSFCell matchingTargetCell = row.getCell((short) 2); matchingTarget += matchingTargetCell.getRichStringCellValue() + ";"; } else { err += "Quy chun (quy nh) " + standardCode + " khng chnh xc ! "; break; } } else { break; } } } catch (Exception ex) { LogUtil.addLog(ex);//binhnt sonar a160901 // log.error(e.getMessage()); err += "li tab bn cng b hp quy "; } if (matchingTarget != "" && matchingTarget != null) { matchingTarget = matchingTarget.substring(0, matchingTarget.length() - 1); } //tab chi tiet san pham XSSFCell productNo = null; XSSFCell productStatus = null; XSSFCell productColor = null; XSSFCell productSmell = null; XSSFCell productOtherstatus = null; XSSFCell productType = null; XSSFCell otherTarget = null; XSSFCell component = null; XSSFCell timeinuse = null; XSSFCell useage = null; XSSFCell objectInUse = null; XSSFCell guideline = null; //XSSFCell packageRecipe = null; XSSFCell packageMaterial = null; XSSFCell productProcess = null; XSSFCell counterfeitDistinctive = null; XSSFCell origin = null; XSSFCell signDate = null; XSSFCell signer_productdetails = null; XSSFCell chemicalTargetUnwanted = null; try { XSSFSheet sheet1 = wb.getSheetAt(1); if (sheet1 == null) { err += "Khng tm thy Sheet Chi tit sn phm, "; } else { String sheetName = sheet1.getSheetName(); if (!"Chi_tiet_san_pham".equals(sheetName)) { err += "Sai tn Sheet Chi tit sn phm, "; } } row = sheet1.getRow(1); productType = row.getCell((short) 1); productNo = row.getCell((short) 3); row = sheet1.getRow(4); productStatus = row.getCell((short) 1); productColor = row.getCell((short) 3); row = sheet1.getRow(5); productSmell = row.getCell((short) 1); productOtherstatus = row.getCell((short) 3); row = sheet1.getRow(13); otherTarget = row.getCell((short) 1); row = sheet1.getRow(14); component = row.getCell((short) 1); timeinuse = row.getCell((short) 3); row = sheet1.getRow(15); useage = row.getCell((short) 1); objectInUse = row.getCell((short) 3); row = sheet1.getRow(16); guideline = row.getCell((short) 1); packageMaterial = row.getCell((short) 3); row = sheet1.getRow(17); productProcess = row.getCell((short) 3); //packageRecipe = row.getCell((short) 1); row = sheet1.getRow(18); counterfeitDistinctive = row.getCell((short) 1); origin = row.getCell((short) 3); row = sheet1.getRow(19); signDate = row.getCell((short) 1); signer_productdetails = row.getCell((short) 3); // bo sung ham luong hoa chat khong mong muon XSSFSheet sheet5 = wb.getSheetAt(5); int rowNums = sheet5.getLastRowNum(); do { row = sheet5.getRow(rowNums); chemicalTargetUnwanted = row.getCell((short) 2); rowNums--; } while (chemicalTargetUnwanted == null); // chemicalTargetUnwanted = row.getCell((short) 2); } catch (Exception ex) { LogUtil.addLog(ex);//binhnt sonar a160901 // log.error(e.getMessage()); err += "Li tab chi tit sn phm "; } // do du lieu vao form Long fileId = getRequest().getParameter("fileId") == null ? 0L : Long.parseLong(getRequest().getParameter("fileId")); Long fileType = getRequest().getParameter("fileType") == null ? 0L : Long.parseLong(getRequest().getParameter("fileType")); if (fileType > 0L && fileId > 0L) { createForm = new FilesForm(); createForm.setFileType(fileType); createForm.setFileId(fileId); } UsersDAOHE udhe = new UsersDAOHE(); Users user = udhe.findById(getUserId()); BusinessDAOHE bdhe = new BusinessDAOHE(); Business bus = bdhe.findById(user.getBusinessId()); if (createForm.getFileId() != null && createForm.getFileId() > 0l) { FilesDAOHE fdhe = new FilesDAOHE(); createForm = fdhe.getFilesDetail(createForm.getFileId()); if (!createForm.getFileType().equals(0L)) { ProcedureDAOHE cdhe = new ProcedureDAOHE(); List lstTTHC = cdhe.getProcedureForChange(createForm.getFileType()); lstCategory = new ArrayList(); lstCategory.addAll(lstTTHC); lstCategory.add(0, new Procedure(Constants.COMBOBOX_HEADER_VALUE, Constants.COMBOBOX_HEADER_TEXT_SELECT)); getRequest().setAttribute("lstFileType", lstCategory); } } if (createForm.getFileType() != null && createForm.getFileType() > 0l) { ProcedureDAOHE pdhe = new ProcedureDAOHE(); CategoryDAOHE cdhe = new CategoryDAOHE(); TechnicalStandardDAOHE tdhe = new TechnicalStandardDAOHE(); FilesDAOHE fdhe = new FilesDAOHE(); if (!fileType.equals(0L)) { createForm.setFileType(fileType); } Procedure tthc = pdhe.findById(createForm.getFileType()); if (tthc != null) { lstProductType = cdhe.findAllCategory("SP"); lstUnit = cdhe.findAllCategory("DVI"); lstStandard = tdhe.findAllStandard(); String lstDepts = convertToJSONData(lstStandard, "vietnameseName", "vietnameseName"); getRequest().setAttribute("lstStandard", lstDepts); UserAttachsDAOHE uahe = new UserAttachsDAOHE(); lstUserAttach = uahe.findAllUserAttach(getUserId()); String lstUserAttachs = convertToJSONData(lstUserAttach, "attachName", "attachName"); getRequest().setAttribute("lstUserAttach", lstUserAttachs); if (lstUserAttachs.trim().length() > 0) { createForm.setCountUA(1L); } else { createForm.setCountUA(0L); } getRequest().setAttribute("lstProductType", lstProductType); getRequest().setAttribute("lstUnit", lstUnit); String fileLst = tthc.getFileList(); getRequest().setAttribute("fileList", com.viettel.common.util.StringUtils.removeHTML(fileLst)); getRequest().setAttribute("agencyName", getDepartmentName()); getRequest().setAttribute("fileNameFull", tthc.getName()); strReturn = tthc.getDescription(); if (createForm.getAnnouncement() != null) { if (createForm.getAnnouncement().getAnnouncementNo() != null && createForm.getAnnouncement().getAnnouncementNo().length() > 0l) { return strReturn; } } if (strReturn.equals(Constants.FILE_DESCRIPTION.ANNOUNCEMENT_FILE01) || strReturn.equals(Constants.FILE_DESCRIPTION.ANNOUNCEMENT_FILE03) || strReturn.equals(Constants.FILE_DESCRIPTION.CONFIRM_FUNC_IMP) || strReturn.equals(Constants.FILE_DESCRIPTION.CONFIRM_FUNC_VN) || strReturn.equals(Constants.FILE_DESCRIPTION.CONFIRM_NORMAL_IMP) || strReturn.equals(Constants.FILE_DESCRIPTION.CONFIRM_NORMAL_VN) || strReturn.equals(Constants.FILE_DESCRIPTION.REC_CONFIRM_NORMAL_IMP) || strReturn.equals(Constants.FILE_DESCRIPTION.RE_ANNOUNCEMENT) || strReturn.equals(Constants.FILE_DESCRIPTION.RE_CONFIRM_FUNC_IMP) || strReturn.equals(Constants.FILE_DESCRIPTION.RE_CONFIRM_FUNC_VN) || strReturn.equals(Constants.FILE_DESCRIPTION.RE_CONFIRM_NORMAL_VN)) { String announcementNoStr = fdhe.getReceiptNoNew(getUserId(), getUserLogin(), createForm.getFileType()); createForm.setAnnouncement(new AnnouncementForm()); createForm.getAnnouncement().setAnnouncementNo(announcementNoStr); // thong tin doanh nghiep createForm.getAnnouncement().setBusinessAddress(bus.getBusinessAddress()); createForm.getAnnouncement().setBusinessFax(bus.getBusinessFax()); createForm.getAnnouncement().setBusinessName(bus.getBusinessName()); createForm.getAnnouncement().setBusinessTelephone(bus.getBusinessTelephone()); createForm.getAnnouncement().setBusinessEmail(bus.getUserEmail()); createForm.getAnnouncement().setBusinessLicence(bus.getBusinessLicense()); // ho so cap lai 7-11 createForm.setReIssueForm(new ReIssueFormForm()); createForm.getReIssueForm().setBusinessName(bus.getBusinessName()); createForm.getReIssueForm().setIdentificationNumber(bus.getBusinessLicense()); createForm.getReIssueForm().setAddress(bus.getBusinessAddress()); createForm.getReIssueForm().setEmail(bus.getUserEmail()); createForm.getReIssueForm().setTelephone(bus.getBusinessTelephone()); createForm.getReIssueForm().setFax(bus.getBusinessFax()); //set thong tin tu excel try { if (businessTaxCode != null && user.getUserName().equals(businessTaxCode.toString())) { if (matchingTarget != "" && matchingTarget != null) { createForm.getAnnouncement().setMatchingTarget(matchingTarget.toString()); } createForm.getAnnouncement().setProductName(productName.toString()); createForm.getAnnouncement().setManufactureAddress(manufactorAddress.toString()); createForm.getAnnouncement().setManufactureName(manufactorName.toString()); createForm.getAnnouncement().setManufactureTel(manufactorTel.toString()); createForm.getAnnouncement().setManufactureFax(manufactorFax.toString()); createForm.getAnnouncement().setManufactureEmail(manufactorEmail.toString()); createForm.getAnnouncement().setNationName(nationName.toString()); createForm.getAnnouncement().setSigner(signer.toString()); createForm.getAnnouncement() .setNationCompanyAddress(nationCompanyAddress.toString()); createForm.getAnnouncement().setNationCompanyName(nationCompanyName.toString()); createForm.getAnnouncement().setAssessmentMethod(assessmentMethod.toString()); if (pushlishDate.toString() != null && pushlishDate.toString().length() > 0) { createForm.getAnnouncement().setPublishDate(DateTimeUtils .convertStringToTime(pushlishDate.toString(), "dd/MM/yyyy")); } createForm.getAnnouncement().setAnnouncementNo(annoucementNo.toString()); //tab thong tin chi tiet createForm.setDetailProduct(new DetailProductForm()); createForm.getDetailProduct().setProductNo(productNo.toString()); createForm.getDetailProduct().setProductStatus(productStatus.toString()); createForm.getDetailProduct().setProductColor(productColor.toString()); createForm.getDetailProduct().setProductSmell(productSmell.toString()); createForm.getDetailProduct().setProductOtherStatus(productOtherstatus.toString()); item = cdhe.findCategoryByName("SP", productType.toString()); if (item != null) { createForm.getDetailProduct().setProductType(item.getCategoryId()); } else { err += "Danh mc " + productType.toString() + " khng chnh xc, "; } createForm.getDetailProduct().setOtherTarget(otherTarget.toString()); createForm.getDetailProduct().setComponents(component.toString()); createForm.getDetailProduct().setTimeInUse(timeinuse.toString()); createForm.getDetailProduct().setUseage(useage.toString()); createForm.getDetailProduct().setObjectUse(objectInUse.toString()); createForm.getDetailProduct().setGuideline(guideline.toString()); //createForm.getDetailProduct().setPackageRecipe(packageRecipe.toString()); createForm.getDetailProduct().setPackateMaterial(packageMaterial.toString()); createForm.getDetailProduct().setProductionProcess(productProcess.toString()); createForm.getDetailProduct() .setCounterfeitDistinctive(counterfeitDistinctive.toString()); createForm.getDetailProduct().setOrigin(origin.toString()); if (signDate.toString() != null && signDate.toString().length() > 0) { createForm.getDetailProduct().setSignDate( DateTimeUtils.convertStringToTime(signDate.toString(), "dd/MM/yyyy")); } createForm.getDetailProduct().setSigner(signer_productdetails.toString()); createForm.getDetailProduct() .setChemicalTargetUnwanted(chemicalTargetUnwanted.toString()); createForm.setStatusExcel( err += "Thm mi bn cng b hp quy thnh cng "); } else { createForm.setStatusExcel(err += "M s thu khng chnh xc "); } } catch (Exception ex) { // log.error(parseException); LogUtil.addLog(ex);//binhnt sonar a160901 createForm.setStatusExcel( err += "Thm mi bn cng b hp quy khng thnh cng "); } } } } } CategoryDAOHE ctdhe = new CategoryDAOHE(); Category cate = ctdhe.findCategoryByTypeAndCode("SP", "TPCN"); Category cateTL = ctdhe.findCategoryByTypeAndCode("SP", "TL"); List<Category> cate1 = ctdhe.findCategoryByTypeAndCodeNew("SP", "DBT"); String dbtId = ""; for (int i = 0; i < cate1.size(); i++) { dbtId += cate1.get(i).getCategoryId().toString() + ";"; } Long tpcnId = cate.getCategoryId(); Long tlId = cateTL.getCategoryId(); FeeDAOHE fdhe1 = new FeeDAOHE(); Fee findfee1 = fdhe1.findFeeByCode("TPDB"); Long priceTPDB = findfee1.getPrice(); Fee findfee2 = fdhe1.findFeeByCode("TPCN"); Long priceTPCN = findfee2.getPrice(); Fee findfee3 = fdhe1.findFeeByCode("TPK"); Long priceETC = findfee3.getPrice(); getRequest().setAttribute("dbtId", dbtId); getRequest().setAttribute("tpcnId", tpcnId); getRequest().setAttribute("tlId", tlId); getRequest().setAttribute("priceTPCN", priceTPCN); getRequest().setAttribute("priceTPDB", priceTPDB); getRequest().setAttribute("priceETC", priceETC); return strReturn; }