/******************************************************************************
 * Copyright (C) 2012 Trek Global                                             *
 * Product: iDempiere ERP & CRM Smart Business Solution                       *
 * This program is free software; you can redistribute it and/or modify it    *
 * under the terms version 2 of the GNU General Public License as published   *
 * by the Free Software Foundation. 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 General Public License for more details.                       *
 * You should have received a copy of the GNU General Public License along    *
 * with this program; if not, write to the Free Software Foundation, Inc.,    *
 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.                     *
 *****************************************************************************/

package org.idempiere.broadcast.process;

import org.adempiere.model.MBroadcastMessage;
import org.compiere.process.SvrProcess;
import org.compiere.util.DB;
import org.compiere.util.Env;

/**
 * Process to expire a broadcast message
 * @author Vivek
 * @author Deepak Pansheriya
 */
@org.adempiere.base.annotation.Process
public class ExpireBrodcastMessage extends SvrProcess{

	@Override
	protected void prepare() {
	}

	@Override
	protected String doIt() throws Exception {
		MBroadcastMessage mbMessage = new MBroadcastMessage(Env.getCtx(), getRecord_ID(), get_TrxName());
		if (MBroadcastMessage.BROADCASTFREQUENCY_UntilExpiration.equals(mbMessage.getBroadcastFrequency())
				&& !mbMessage.isExpired() && mbMessage.isPublished()){
			String sql = "UPDATE AD_Note SET Processed='Y' WHERE AD_BroadcastMessage_ID = ?";
			DB.executeUpdateEx(sql, new Object[] {getRecord_ID()}, null);
			mbMessage.setProcessed(true);
			mbMessage.setExpired(true);				
			mbMessage.saveEx();
		}
		return "Expired";
	}
}
