Material Design Components (Spreadsheet)

[
  { "row": 0, "col": 0, "rowspan": 2, "colspan": 1 },
  { "row": 0, "col": 1, "rowspan": 1, "colspan": 2, "displayValue": "結合値" }
]

[
  {
    "columns": ["department", "division"],
    "columnExpression": "sameValue",
    "rowExpression": "sameValue",
    "resultExpression": "firstCell"
  }
]

package your.package;

import java.util.Collections;
import java.util.List;
import java.util.Map;

import org.iplass.mtp.auth.AuthContext;
import org.iplass.mtp.command.RequestContext;
import org.iplass.mtp.entity.Entity;
import org.iplass.mtp.entity.ValidateError;
import org.iplass.mtp.entity.definition.EntityDefinition;
import org.iplass.mtp.mdc.view.spreadsheet.definition.MdcSpreadSheetDefinition;
import org.iplass.mtp.mdc.view.spreadsheet.definition.MdcSpreadSheetRegistrationInterrupter;
import org.iplass.mtp.mdc.view.spreadsheet.definition.MdcSpreadSheetRegistrationInterrupter.RegistrationType;

public class SampleSpreadSheetInterrupter implements MdcSpreadSheetRegistrationInterrupter {

    @Override
    public void dataMapping(Entity entity, RequestContext request,
            EntityDefinition definition, MdcSpreadSheetDefinition spreadSheetDefinition,
            Map<String, Object> row) {
        // 登録用Entityに対する値の加工や追加設定を行います
        entity.setValue("updateUser", AuthContext.getCurrentContext().getUser().getName());
    }

    @Override
    public List<ValidateError> beforeRegister(Entity entity, RequestContext request,
            EntityDefinition definition, MdcSpreadSheetDefinition spreadSheetDefinition,
            RegistrationType registrationType) {
        // 登録前のバリデーションを行います
        // エラーがある場合はValidateErrorを返却し、登録処理を中断します
        return Collections.emptyList();
    }
}

package your.package;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import org.iplass.mtp.command.RequestContext;
import org.iplass.mtp.entity.Entity;
import org.iplass.mtp.entity.ValidateError;
import org.iplass.mtp.entity.definition.EntityDefinition;
import org.iplass.mtp.mdc.view.spreadsheet.definition.MdcSpreadSheetDefinition;
import org.iplass.mtp.mdc.view.spreadsheet.definition.MdcSpreadSheetRegistrationInterrupter;
import org.iplass.mtp.mdc.view.spreadsheet.definition.MdcSpreadSheetRegistrationInterrupter.RegistrationType;

public class SampleValidationInterrupter implements MdcSpreadSheetRegistrationInterrupter {

    @Override
    public List<ValidateError> beforeRegister(Entity entity, RequestContext request,
            EntityDefinition definition, MdcSpreadSheetDefinition spreadSheetDefinition,
            RegistrationType registrationType) {
        List<ValidateError> errors = new ArrayList<>();
        // 価格が未設定の行は登録を拒否します
        if (entity.getValue("price") == null) {
            ValidateError error = new ValidateError();
            error.setPropertyName("price");
            error.addErrorMessage("価格を入力してください。");
            errors.add(error);
        }
        return errors;
    }

    @Override
    public void dataMapping(Entity entity, RequestContext request,
            EntityDefinition definition, MdcSpreadSheetDefinition spreadSheetDefinition,
            Map<String, Object> row) {
    }
}