find dari generate nadia

package org.jleaf.erp.master.bo.customervsrayon;

import java.util.List;
import javax.persistence.Query;

import org.jleaf.core.AbstractBusinessFunction;
import org.jleaf.core.BusinessFunction;
import org.jleaf.core.CoreException;
import org.jleaf.core.Dto;
import org.jleaf.core.annotation.ErrorList;
import org.jleaf.core.annotation.Info;
import org.jleaf.core.annotation.InfoIn;
import org.jleaf.core.annotation.InfoOut;
import org.jleaf.util.ValidationUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import org.jleaf.erp.master.entity.RegionCustomer;
import org.jleaf.erp.master.dao.RegionCustomerDao;
import org.jleaf.erp.master.MasterExceptionConstantsForDlg;


/**
 * Find RegionCustomer by index
 * @author Nadia, Sep 19, 2016
 * @version 1.0
 */

@Service
@InfoIn(value = {
	@Info(name = "regionId", description = "Region id", type = Long.class, required = true),
	@Info(name = "customerId", description = "Customer id", type = Long.class, required = true)
})
@InfoOut(value = {
	@Info(name = "regionCustomerId", description = "Region customer id", type = Long.class, required = true),
	@Info(name = "tenantId", description = "Tenant id", type = Long.class, required = true),
	@Info(name = "regionId", description = "Region id", type = Long.class, required = true),
	@Info(name = "customerId", description = "Customer id", type = Long.class, required = true),
	@Info(name = "active", description = "Active", type = String.class, required = true),
	@Info(name = "activeDateTime", description = "Active date time", type = String.class, required = true),
	@Info(name = "nonActiveDateTime", description = "Non active date time", type = String.class, required = true),
	@Info(name = "createUserId", description = "Create user id", type = Long.class, required = true),
	@Info(name = "createDateTime", description = "Create date time", type = String.class, required = true),
	@Info(name = "updateUserId", description = "Update user id", type = Long.class, required = true),
	@Info(name = "updateDateTime", description = "Update date time", type = String.class, required = true),
	@Info(name = "version", description = "Version", type = Long.class, required = true)
})
@ErrorList(errorKeys = {
	MasterExceptionConstantsForDlg.REGION_CUSTOMER_NOT_FOUND
})
public class FindRegionCustomerByIndex extends AbstractBusinessFunction implements BusinessFunction {

	@Autowired
	private RegionCustomerDao regionCustomerDao;

	@SuppressWarnings("unchecked")
	@Override
	public Dto execute(Dto inputDto) throws Exception {
		ValidationUtil.valDtoContainsKey(inputDto, "regionId");
		ValidationUtil.valDtoContainsKey(inputDto, "customerId");


		Dto outputDto = null;

		Long regionId = inputDto.getLong("regionId");
		Long customerId = inputDto.getLong("customerId");


		Query query = regionCustomerDao
			.createQuery("SELECT e FROM "+RegionCustomer.ENTITY_NAME+" e WHERE e.regionId = :regionId AND e.customerId = :customerId");

		query.setParameter("regionId", regionId);
		query.setParameter("customerId", customerId);


		List<RegionCustomer> regionCustomerList = query.getResultList();
		if (regionCustomerList.size() != 0) {
			outputDto = new Dto(regionCustomerList.get(0));
		} else {
			throw new CoreException(MasterExceptionConstantsForDlg.REGION_CUSTOMER_NOT_FOUND,regionId,customerId);
		}

		return outputDto;
	}

	@Override
	public String getDescription() {
		return "Find RegionCustomer by index ";
	}

}