Example usage for org.apache.poi.xssf.usermodel XSSFSheet getRow

List of usage examples for org.apache.poi.xssf.usermodel XSSFSheet getRow

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.xssf.usermodel.*
  5. XSSFSheet
  6. getRow

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFSheet getRow.

Prototype

@Override
public XSSFRow getRow(int rownum)

Source Link

Document

Returns the logical row ( 0-based).

Usage

From source file:com.vaadin.addon.spreadsheet.GroupingUtil.java

private static boolean isRowGroupHiddenByParent(XSSFSheet sheet, int row) {
    // Look out outline details of end
    int endLevel;
    boolean endHidden;
    int endOfOutlineGroupIdx = findEndOfRowOutlineGroup(sheet, row);
    if (sheet.getRow(endOfOutlineGroupIdx) == null) {
        endLevel = 0;/*from   ww w  .ja v a2  s .c o  m*/
        endHidden = false;
    } else {
        endLevel = sheet.getRow(endOfOutlineGroupIdx).getCTRow().getOutlineLevel();
        endHidden = sheet.getRow(endOfOutlineGroupIdx).getCTRow().getHidden();
    }

    // Look out outline details of start
    int startLevel;
    boolean startHidden;
    /** start */
    int startOfOutlineGroupIdx = findStartOfRowOutlineGroup(sheet, row);
    /** end */
    if (startOfOutlineGroupIdx < 0 || sheet.getRow(startOfOutlineGroupIdx) == null) {
        startLevel = 0;
        startHidden = false;
    } else {
        startLevel = sheet.getRow(startOfOutlineGroupIdx).getCTRow().getOutlineLevel();
        startHidden = sheet.getRow(startOfOutlineGroupIdx).getCTRow().getHidden();
    }
    if (endLevel > startLevel) {
        return endHidden;
    }
    return startHidden;
}

From source file:com.vaadin.addon.spreadsheet.GroupingUtil.java

private static int findStartOfRowOutlineGroup(XSSFSheet sheet, int rowIndex) {
    // Find the start of the group.
    short level = sheet.getRow(rowIndex).getCTRow().getOutlineLevel();
    int currentRow = rowIndex;
    while (sheet.getRow(currentRow) != null) {
        if (sheet.getRow(currentRow).getCTRow().getOutlineLevel() < level) {
            /** start */
            return currentRow;
            /** end */
        }//from   w w  w .ja  v a2  s.co m
        currentRow--;
    }
    return currentRow;
}

From source file:com.vaadin.addon.spreadsheet.GroupingUtil.java

public static void collapseRow(XSSFSheet sheet, int rowIndex) {
    XSSFRow row = sheet.getRow(rowIndex);
    if (row != null) {
        int startRow = findStartOfRowOutlineGroup(sheet, rowIndex);

        // Hide all the columns until the end of the group
        int lastRow = writeHidden(sheet, row, startRow, true);

        /** start */

        if (isRowsInverted(sheet)) {
            if (sheet.getRow(startRow) != null) {
                sheet.getRow(startRow).getCTRow().setCollapsed(true);
            } else if (startRow < 0) {
                // happens when inverted group starts at 0; Excel does not
                // write a collapsed prop for this case.
            } else {
                XSSFRow newRow = sheet.createRow(startRow);
                newRow.getCTRow().setCollapsed(true);
            }//from   w  ww .  j a v a 2 s. c o m

        } else {
            if (sheet.getRow(lastRow) != null) {
                sheet.getRow(lastRow).getCTRow().setCollapsed(true);
            } else {
                XSSFRow newRow = sheet.createRow(lastRow);
                newRow.getCTRow().setCollapsed(true);
            }
        }
        /** end */
    }
}

From source file:com.vaadin.addon.spreadsheet.GroupingUtil.java

private static int writeHidden(XSSFSheet sheet, XSSFRow xRow, int rowIndex, boolean hidden) {
    short level = xRow.getCTRow().getOutlineLevel();

    /** completely rewritten after this line */
    // row index is the first row BEFORE group, not what we want
    rowIndex++;/*from   w w  w. j a  va2 s .c o m*/

    // row will be null at some point, this is safe
    while (true) {
        XSSFRow row = sheet.getRow(rowIndex);
        if (row == null) {
            break;
        }

        short outlineLevel = row.getCTRow().getOutlineLevel();
        if (outlineLevel < level) {
            break;
        }
        row.getCTRow().setHidden(hidden);
        rowIndex++;
    }

    /** old code, for reference */
    // for (Iterator<Row> it = sheet.rowIterator(); it.hasNext();) {
    // xRow = (XSSFRow) it.next();
    //
    // // skip rows before the start of this group
    // if (xRow.getRowNum() < rowIndex) {
    // continue;
    // }
    //
    // if (xRow.getCTRow().getOutlineLevel() >= level) {
    // xRow.getCTRow().setHidden(hidden);
    // rowIndex++;
    // }
    //
    // }
    return rowIndex;
}

From source file:com.vaadin.addon.spreadsheet.Spreadsheet.java

License:Open Source License

private void updateExpandedRegion(XSSFSheet sheet, int columnIndex, int expandLevel) {
    if (expandLevel < 0) {
        return;/* www .java2  s .  co  m*/
    }
    int endIndex = -1;
    for (GroupingData data : getState().colGroupingData) {
        if (data.level == expandLevel) {
            endIndex = data.endIndex;
            break;
        }
    }
    if (endIndex < 0) {
        return;
    }
    // update the style for the region cells, effects region + 1 row&col
    int firstRowNum = sheet.getFirstRowNum();
    int lastRowNum = sheet.getLastRowNum();
    for (int r = firstRowNum; r <= lastRowNum; r++) {
        Row row = sheet.getRow(r);
        if (row != null) {
            for (int c = columnIndex; c <= endIndex; c++) {
                Cell cell = row.getCell(c);
                if (cell != null) {
                    valueManager.markCellForUpdate(cell);
                }
            }
        }
    }
}

From source file:com.vaadin.addon.spreadsheet.Spreadsheet.java

License:Open Source License

/**
 * Called when a grouping level header is clicked
 * /*from w  w w  .  ja  v  a2  s. c  om*/
 * @param isCols
 *            true if the user clicked on cols, false for row level headers
 * @param level
 *            which level the user clicked
 */
protected void levelHeaderClicked(boolean isCols, int level) {

    /*
     * A click on a header should change groupings so that all levels above
     * the selected are expanded, and the selected level is all collapsed
     * (which hides any levels underneath this).
     */

    if (getActiveSheet() instanceof HSSFSheet) {
        return;
    }

    XSSFSheet xsheet = (XSSFSheet) getActiveSheet();
    CTWorksheet ctWorksheet = xsheet.getCTWorksheet();

    if (isCols) {

        CTCols ctCols = ctWorksheet.getColsList().get(0);
        List<CTCol> colList = ctCols.getColList();
        for (CTCol col : colList) {
            short l = col.getOutlineLevel();

            // It's a lot easier to not call expand/collapse

            if (l >= 0 && l < level) {
                // expand
                if (col.isSetHidden()) {
                    col.unsetHidden();
                }
            } else {
                // collapse
                col.setHidden(true);
            }
        }

    } else {

        /*
         * Groups are more complicated than cols, use existing
         * collapse/expand functionality.
         */

        int lastlevel = 0;
        for (int i = 0; i < getRows(); i++) {

            XSSFRow row = xsheet.getRow(i);
            if (row == null) {
                lastlevel = 0;
                continue;
            }

            short l = row.getCTRow().getOutlineLevel();
            if (l != lastlevel) {

                // group starts here

                int end = (int) GroupingUtil.findEndOfRowGroup(this, i, row, l);
                long uniqueIndex = GroupingUtil.findUniqueRowIndex(this, i, end, l);

                if (l > 0 && l < level) {
                    // expand
                    GroupingUtil.expandRow(xsheet, (int) uniqueIndex);

                } else if (l >= level) {
                    // collapse
                    GroupingUtil.collapseRow(xsheet, (int) uniqueIndex);
                }

                lastlevel = l;
            }

        }

    }

    SpreadsheetFactory.reloadSpreadsheetComponent(this, workbook);
}

From source file:com.viettel.hqmc.DAO.FilesDAO.java

/**
 * import du lieu tu excel/*from   www  . j av  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;
}

From source file:com.viettel.hqmc.DAO.FilesDAO.java

/**
 * load mainly target tu excel/* w w w . java 2s .co  m*/
 *
 * @return
 */
public String loadMainlyTargetExcel() throws FileNotFoundException, IOException {
    // mainly target
    Category item = new Category();
    String linkFile = getRequest().getParameter("path");
    String fileError = "";
    List customInfo = new ArrayList();
    InputStream myxls = new FileInputStream(linkFile);//get file excel
    XSSFWorkbook wb = new XSSFWorkbook(myxls);
    List<MainlyTarget> lstMainlyTarget = null;
    try {
        XSSFSheet sheet2 = wb.getSheetAt(2);
        if (sheet2 == null) {
            fileError += "Khng tm thy Sheet Ch tiu cht lng ch yu, ";
        } else {
            String sheetName = sheet2.getSheetName();
            if (!"Chi_tieu_chat_luong_chu_yeu".equals(sheetName)) {
                fileError += "Sai tn Sheet Ch tiu cht lng ch yu, ";
            }
        }

        XSSFRow row;
        int rowNums2 = sheet2.getLastRowNum();
        lstMainlyTarget = new ArrayList<MainlyTarget>();
        CategoryDAOHE cdhed = new CategoryDAOHE();

        for (int i = 2; i < rowNums2; i++) {
            row = sheet2.getRow(i);
            if (row.getCell((short) 1) != null && row.getCell((short) 1).toString().trim() != "") {
                MainlyTarget temp = new MainlyTarget();
                XSSFCell targetName = row.getCell((short) 1);
                XSSFCell unitId = row.getCell((short) 2);
                XSSFCell publishLevel = row.getCell((short) 3);
                XSSFCell meetLevel = row.getCell((short) 4);
                item = cdhed.findCategoryByName("DVI", unitId.toString());
                if (item != null) {
                    temp.setMeetLevel(meetLevel.toString());
                    temp.setTargetName(targetName.toString());
                    temp.setUnitId(item.getCategoryId().toString());
                    temp.setPublishLevel(publishLevel.toString());
                    lstMainlyTarget.add(temp);
                } else {
                    fileError += "Danh mc n v " + unitId.toString() + " khng chnh xc, ";
                }
            } else {
                break;
            }
        }
        fileError += "Thm mi cc ch tiu cht lng ch yu thnh cng ";
        customInfo.add(fileError);
    } catch (Exception ex) {
        fileError += "Thm mi cc ch tiu cht lng ch yu khng thnh cng ";
        customInfo.add(fileError);
        //            log.error(e.getMessage());
        LogUtil.addLog(ex);//binhnt sonar a160901
    }
    jsonDataGrid.setCustomInfo(customInfo);
    jsonDataGrid.setItems(lstMainlyTarget);
    return GRID_DATA;
}

From source file:com.viettel.hqmc.DAO.FilesDAO.java

/**
 * load product target tu excel/*  www .j av  a 2s.c o  m*/
 *
 * @return
 */
public String loadProductTargetExcel() throws FileNotFoundException, IOException {

    Category item = new Category();
    String linkFile = getRequest().getParameter("path");
    String fileError = "";
    List customInfo = new ArrayList();
    InputStream myxls = new FileInputStream(linkFile);//get file excel
    XSSFWorkbook wb = new XSSFWorkbook(myxls);
    List<ProductTarget> lstProductTarget = null;
    try {
        XSSFSheet sheet3 = wb.getSheetAt(3);
        if (sheet3 == null) {
            fileError += "Khng tm thy Sheet Ch tiu vi sinh vt, ";
        } else {
            String sheetName = sheet3.getSheetName();
            if (!"Chi_tieu_vi_sinh_vat".equals(sheetName)) {
                fileError += "Sai tn Sheet Ch tiu vi sinh vt, ";
            }
        }
        XSSFRow row;
        int rowNums3 = sheet3.getLastRowNum();
        lstProductTarget = new ArrayList<ProductTarget>();
        CategoryDAOHE cdhed = new CategoryDAOHE();
        // vi sinh vat
        for (int i = 2; i < rowNums3; i++) {
            row = sheet3.getRow(i);
            if (row.getCell((short) 1) != null && !"".equals(row.getCell((short) 1).toString().trim())) {
                ProductTarget temp = new ProductTarget();
                XSSFCell targetName = row.getCell((short) 1);
                XSSFCell unitId = row.getCell((short) 2);
                XSSFCell maxLevel = row.getCell((short) 3);
                item = cdhed.findCategoryByName("DVI", unitId.toString().trim());
                if (item != null) {
                    temp.setTargetName(targetName.toString());
                    temp.setUnitId(item.getCategoryId().toString());
                    temp.setMaxLevel(maxLevel.toString());
                    temp.setTargetType(1l);
                    lstProductTarget.add(temp);
                } else {
                    fileError += "Danh mc n v " + unitId.toString() + " khng chnh xc, ";
                }
            } else {
                break;
            }

        }
        //kim loai nang

        XSSFSheet sheet4 = wb.getSheetAt(4);
        if (sheet4 == null) {
            fileError += "Khng tm thy Sheet Hm lng kim loi nng, ";
        } else {
            String sheetName2 = sheet4.getSheetName();
            if (!"Ham_luong_kim_loai_nang".equals(sheetName2)) {
                fileError += "Sai tn Sheet Hm lng kim loi nng, ";
            }
        }
        int rowNums4 = sheet4.getLastRowNum();
        for (int i = 2; i < rowNums4; i++) {
            row = sheet4.getRow(i);
            if (row.getCell((short) 1) != null && !"".equals(row.getCell((short) 1).toString().trim())) {
                ProductTarget temp = new ProductTarget();
                XSSFCell targetName = row.getCell((short) 1);
                XSSFCell unitId = row.getCell((short) 2);
                XSSFCell maxLevel = row.getCell((short) 3);
                item = cdhed.findCategoryByName("DVI", unitId.toString().trim());
                if (item != null) {
                    temp.setTargetName(targetName.toString());
                    temp.setUnitId(item.getCategoryId().toString());
                    temp.setMaxLevel(maxLevel.toString());
                    temp.setTargetType(2l);
                    lstProductTarget.add(temp);
                } else {
                    fileError += "Danh mc n v " + unitId.toString() + " khng chnh xc, ";
                }
            } else {
                break;
            }
        }

        //hoa chat khong mong muon
        XSSFSheet sheet5 = wb.getSheetAt(5);
        if (sheet5 == null) {
            fileError += "Khng tm thy Sheet Hm lng ha cht khng mong mun, ";
        } else {
            String sheetName1 = sheet5.getSheetName();

            if (!"Ham_luong_hoa_chat".equals(sheetName1)) {
                fileError += "Sai tn Sheet Hm lng ha cht khng mong mun, ";
            }
        }
        int rowNums5 = sheet5.getLastRowNum();
        for (int i = 2; i < rowNums5; i++) {
            row = sheet5.getRow(i);
            if (row.getCell((short) 1) != null && !"".equals(row.getCell((short) 1).toString().trim())) {
                ProductTarget temp = new ProductTarget();
                XSSFCell targetName = row.getCell((short) 1);
                XSSFCell unitId = row.getCell((short) 2);
                XSSFCell maxLevel = row.getCell((short) 3);
                item = cdhed.findCategoryByName("DVI", unitId.toString().trim());
                if (item != null) {
                    temp.setTargetName(targetName.toString());
                    temp.setUnitId(item.getCategoryId().toString());
                    temp.setMaxLevel(maxLevel.toString());
                    temp.setTargetType(3l);
                    lstProductTarget.add(temp);
                } else {
                    fileError += "Danh mc n v " + unitId.toString() + " khng chnh xc, ";
                }
            } else {
                break;
            }
        }
        fileError += "Thm mi cc ch tiu vi sinh vt, hm lng kim loi nng, hm lng ha cht khng mong mun thnh cng ";
        customInfo.add(fileError);

    } catch (Exception ex) {
        fileError += "Thm mi cc ch tiu vi sinh vt, hm lng kim loi nng, hm lng ha cht khng mong mun khng thnh cng ";
        customInfo.add(fileError);
        //            log.error(e.getMessage());
        LogUtil.addLog(ex);//binhnt sonar a160901
    }
    jsonDataGrid.setCustomInfo(customInfo);
    jsonDataGrid.setItems(lstProductTarget);
    return GRID_DATA;
}

From source file:com.viettel.hqmc.DAO.FilesDAO.java

/**
 * load quality control plan excel/*from w w  w .j  a va 2  s . c o  m*/
 *
 * @return
 */
public String loadQualityControlsExcel() throws FileNotFoundException, IOException {
    // mainly target
    //        Category item = new Category();
    String linkFile = getRequest().getParameter("path");
    String fileError = "";
    List customInfo = new ArrayList();
    InputStream myxls = new FileInputStream(linkFile);//get file excel
    XSSFWorkbook wb = new XSSFWorkbook(myxls);
    List<QualityControlPlan> lstQualityControl = null;
    try {
        XSSFSheet sheet6 = wb.getSheetAt(6);
        if (sheet6 == null) {
            fileError += "Khng tm thy Sheet K hoch kim sot, ";
        } else {
            String sheetName1 = sheet6.getSheetName();

            if (!"Ke_Hoach_Kiem_soat".equals(sheetName1)) {
                fileError += "Khng tm thy Sheet K hoch kim sot, ";
            }
        }
        XSSFRow row;
        int rowNums6 = sheet6.getLastRowNum();
        lstQualityControl = new ArrayList<QualityControlPlan>();
        //            CategoryDAOHE cdhed = new CategoryDAOHE();

        for (int i = 2; i < rowNums6; i++) {
            row = sheet6.getRow(i);
            if (row.getCell((short) 1).toString().trim() != "") {
                QualityControlPlan temp = new QualityControlPlan();
                XSSFCell processDetails = row.getCell((short) 1);
                XSSFCell controlTarget = row.getCell((short) 2);
                XSSFCell technicalRegulation = row.getCell((short) 3);
                XSSFCell patternFrequence = row.getCell((short) 4);
                XSSFCell testDevice = row.getCell((short) 5);
                XSSFCell testMethod = row.getCell((short) 6);
                //                    XSSFCell noteForm = row.getCell((short) 7);
                XSSFCell note = row.getCell((short) 8);
                temp.setProductProcessDetail(processDetails.toString());
                temp.setControlTarget(controlTarget.toString());
                temp.setTechnicalRegulation(technicalRegulation.toString());
                temp.setPatternFrequence(patternFrequence.toString());
                temp.setTestDevice(testDevice.toString());
                temp.setTestMethod(testMethod.toString());
                temp.setNote(note.toString());
                temp.setNoteForm(note.toString());
                lstQualityControl.add(temp);
            } else {
                break;
            }

        }
        fileError = "Thm mi k hoch kim sot cht lng thnh cng ";
        customInfo.add(fileError);
    } catch (Exception ex) {
        fileError = "Thm mi k hoch kim sot cht lng khng thnh cng ";
        customInfo.add(fileError);
        //            log.error(e.getMessage());
        LogUtil.addLog(ex);//binhnt sonar a160901
    }

    jsonDataGrid.setCustomInfo(customInfo);
    jsonDataGrid.setItems(lstQualityControl);
    return GRID_DATA;
}