org.riotfamily.dbmsgsrc.riot.ImportMessageEntriesCommand.java Source code

Introduction

Here is the source code for org.riotfamily.dbmsgsrc.riot.ImportMessageEntriesCommand.java

Source

/* Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.riotfamily.dbmsgsrc.riot;

import java.io.ByteArrayInputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.OfficeXmlFileException;
import org.riotfamily.core.dao.InvalidPropertyValueException;
import org.riotfamily.core.screen.list.command.CommandContext;
import org.riotfamily.core.screen.list.command.CommandResult;
import org.riotfamily.core.screen.list.command.Selection;
import org.riotfamily.core.screen.list.command.impl.dialog.DialogCommand;
import org.riotfamily.core.screen.list.command.result.RefreshListResult;
import org.riotfamily.core.security.AccessController;
import org.riotfamily.core.security.auth.RiotUser;
import org.riotfamily.dbmsgsrc.DbMessageSource;
import org.riotfamily.dbmsgsrc.model.MessageBundleEntry;
import org.riotfamily.forms.Form;
import org.riotfamily.forms.element.Checkbox;
import org.riotfamily.forms.element.upload.FileUpload;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.util.StringUtils;

public class ImportMessageEntriesCommand extends DialogCommand {

    private static final Logger log = LoggerFactory.getLogger(ImportMessageEntriesCommand.class);

    private String bundle = DbMessageSource.DEFAULT_BUNDLE;

    public void setBundle(String bundle) {
        this.bundle = bundle;
    }

    @Override
    protected String getIcon() {
        return "table_row_insert";
    }

    @Override
    public Form createForm(CommandContext context, Selection selection) {
        Form form = new Form(Upload.class);
        form.setId("importMessageEntriesForm");
        FileUpload fileUpload = new FileUpload();
        fileUpload.setRequired(true);
        form.addElement(fileUpload, "data");
        form.addElement(new Checkbox(), "addNewMessages");
        addButton(form, "import");
        return form;
    }

    @Override
    public CommandResult handleInput(CommandContext context, Selection selection, Object input, String button) {

        Upload upload = (Upload) input;
        try {
            RiotUser user = AccessController.getCurrentUser();
            log.info("Global messages uploaded by {}", user.getUserId());
            updateMessages(upload.getData(), upload.isAddNewMessages());
        } catch (OfficeXmlFileException e) {
            throw new InvalidPropertyValueException("data", "error.dbmsgsrc.unsupportedExcelVersion",
                    "The Excel version is not support. Please save Excel file as version 97 - 2003");
        } catch (IOException e) {
        }
        return new RefreshListResult();
    }

    private void updateMessages(byte[] data, boolean addNewMessages) throws IOException {
        HSSFWorkbook wb = new HSSFWorkbook(new ByteArrayInputStream(data));
        HSSFSheet sheet = wb.getSheet("Translations");

        if (isValid(sheet)) {
            for (int i = 1; i < sheet.getPhysicalNumberOfRows(); i++) {
                HSSFRow row = sheet.getRow(i);
                if (row.getCell(1) != null && row.getCell(2) != null) {
                    String code = row.getCell(1).getRichStringCellValue().getString();
                    String defaultMessage = row.getCell(2).getRichStringCellValue().getString();
                    String comment = null;
                    if (row.getCell(3) != null) {
                        comment = row.getCell(3).getRichStringCellValue().getString();
                    }
                    if (StringUtils.hasText(defaultMessage) || StringUtils.hasText(comment)) {
                        MessageBundleEntry entry = MessageBundleEntry.loadByBundleAndCode(bundle, code);
                        if (entry != null) {
                            entry.getDefaultMessage().setText(defaultMessage);
                            entry.setComment(comment);
                            entry.save();
                        } else if (addNewMessages) {
                            entry = new MessageBundleEntry(bundle, code, defaultMessage);
                            entry.setComment(comment);
                            entry.save();
                        } else {
                            log.info("Message Code does not exist and creation not allowed - " + code);
                        }
                    }
                } else {
                    log.info("Skipping invalid row {}", i);
                }
            }
        }
    }

    private boolean isValid(HSSFSheet sheet) {
        if (sheet == null) {
            return false;
        }
        HSSFRow headings = sheet.getRow(0);
        String code = headings.getCell(1).getRichStringCellValue().getString();
        String defaultMessage = headings.getCell(2).getRichStringCellValue().getString();
        String comment = headings.getCell(3).getRichStringCellValue().getString();
        return "Code".equals(code) && "Default Message".equals(defaultMessage) && "Comment".equals(comment);

    }

    public static class Upload {

        private byte[] data;

        private boolean addNewMessages;

        public byte[] getData() {
            return data;
        }

        public void setData(byte[] data) {
            this.data = data;
        }

        public boolean isAddNewMessages() {
            return addNewMessages;
        }

        public void setAddNewMessages(boolean addNewMessages) {
            this.addNewMessages = addNewMessages;
        }
    }

}