/* * Aipo is a groupware program developed by TOWN, Inc. * Copyright (C) 2004-2015 TOWN, Inc. * http://www.aipo.com * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as * published by the Free Software Foundation, either version 3 of the * License, or (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ package com.aimluck.eip.facilities; import java.util.List; import org.apache.cayenne.exp.Expression; import org.apache.cayenne.exp.ExpressionFactory; import org.apache.jetspeed.services.logging.JetspeedLogFactoryService; import org.apache.jetspeed.services.logging.JetspeedLogger; import org.apache.turbine.util.RunData; import org.apache.velocity.context.Context; import com.aimluck.eip.cayenne.om.portlet.EipMFacility; import com.aimluck.eip.cayenne.om.portlet.EipMFacilityGroupMap; import com.aimluck.eip.cayenne.om.portlet.EipTScheduleMap; import com.aimluck.eip.common.ALAbstractCheckList; import com.aimluck.eip.orm.Database; import com.aimluck.eip.orm.query.Operations; import com.aimluck.eip.orm.query.SelectQuery; import com.aimluck.eip.services.eventlog.ALEventlogConstants; import com.aimluck.eip.services.eventlog.ALEventlogFactoryService; import com.aimluck.eip.util.ALLocalizationUtils; /** * 設備の複数削除を行うためのクラスです。 <BR> * */ public class FacilityMultiDelete extends ALAbstractCheckList { /** logger */ private static final JetspeedLogger logger = JetspeedLogFactoryService .getLogger(FacilityMultiDelete.class.getName()); /** * * @param rundata * @param context * @param values * @param msgList * @return */ @Override protected boolean action(RunData rundata, Context context, List<String> values, List<String> msgList) { try { // delete schedule maps SelectQuery<EipTScheduleMap> query1 = Database.query(EipTScheduleMap.class); Expression exp1 = ExpressionFactory.inExp(EipTScheduleMap.USER_ID_PROPERTY, values); Expression exp2 = ExpressionFactory.matchExp(EipTScheduleMap.TYPE_PROPERTY, "F"); query1.setQualifier(exp1.andExp(exp2)); List<EipTScheduleMap> slist = query1.fetchList(); if (slist != null && slist.size() > 0) { Database.deleteAll(slist); } // delete facilities SelectQuery<EipMFacility> query = Database.query(EipMFacility.class); Expression exp = ExpressionFactory.inDbExp(EipMFacility.FACILITY_ID_PK_COLUMN, values); query.setQualifier(exp); List<EipMFacility> flist = query.fetchList(); if (flist == null || flist.size() == 0) { return false; } Database.deleteAll(flist); // delete maps SelectQuery<EipMFacilityGroupMap> fmaps = Database.query(EipMFacilityGroupMap.class); fmaps.where(Operations.in( EipMFacilityGroupMap.FACILITY_ID_PROPERTY, values)); fmaps.deleteAll(); Database.commit(); for (EipMFacility facility : flist) { // イベントログに保存 ALEventlogFactoryService.getInstance().getEventlogHandler().log( facility.getFacilityId(), ALEventlogConstants.PORTLET_TYPE_FACILITY, ALLocalizationUtils.getl10nFormat( "FACILITIES_DELETED_FACILITY_WITH_NAME", facility.getFacilityName())); } } catch (Exception ex) { Database.rollback(); logger.error("facilities", ex); return false; } return true; } }