GetRegionCustomerList

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

import java.util.List;

import javax.persistence.Query;

import org.jleaf.core.AbstractBusinessFunction;
import org.jleaf.core.BusinessFunction;
import org.jleaf.core.Dto;
import org.jleaf.core.annotation.Info;
import org.jleaf.core.annotation.InfoIn;
import org.jleaf.core.annotation.InfoOut;
import org.jleaf.core.dao.BaseDao;
import org.jleaf.core.dao.CriteriaHelper;
import org.jleaf.core.dao.QueryBuilder;
import org.jleaf.erp.master.dao.RegionCustomerDao;
import org.jleaf.erp.master.entity.City;
import org.jleaf.erp.master.entity.Partner;
import org.jleaf.erp.master.entity.RegionCustomer;
import org.jleaf.erp.master.entity.region.Region;
import org.jleaf.util.DtoUtil;
import org.jleaf.util.ValidationUtil;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * BF Get Region Customer List
 *
 * @author Nadia , Sept 07, 2016
 * @version 1.0
 */
@Service
@InfoIn(value = {
		@Info(name = "tenantId", description = "tenant id", type = Long.class),
		@Info(name = "regionId", description = "region id", type = String.class),
		@Info(name = "customerCodeName", description = "customer code name", type = String.class),
		@Info(name = "tenantLoginId", description = "tenant login id", type = Long.class),
		@Info(name = "limit", description = "limit", type = Long.class, required = false),
		@Info(name = "offset", description = "offset", type = Long.class, required = false)

})
@InfoOut(value = { @Info(name = "regionCustomerList", description = "region customer list( id, regionId, regionCode, regionName, customerId, customerCode, customerName, version ) ") })
public abstract class GetRegionCustomerList extends AbstractBusinessFunction implements
		BusinessFunction {
	private static final Logger log = LoggerFactory
			.getLogger(GetRegionCustomerList.class);

	@Autowired
	private RegionCustomerDao regionCustomerDao;

	@SuppressWarnings("unchecked")
	public Dto execute(Dto inputDto, BaseDao<Long, RegionCustomer> posDao, Object partnerName, Object partnerCode) throws Exception {
		List<Object[]> result = null;
		log.debug("ini input Dto" + inputDto);
		// Pastikan input benar/lengkap
		ValidationUtil.valBlankOrNull(inputDto, "tenantId");
		ValidationUtil.valDtoContainsKey(inputDto, "customerCodeName");
		ValidationUtil.valDtoContainsKey(inputDto, "cityId");
		ValidationUtil.valDtoContainsKey(inputDto, "regionId");
		ValidationUtil.valDtoContainsKey(inputDto, "limit");
		ValidationUtil.valDtoContainsKey(inputDto, "offset");

		Long tenantId = inputDto.getLong("tenantId");
		String customerCodeName = inputDto.getString("customerCodeName");
		//String cityId = inputDto.getString("cityId");
		String regionId = inputDto.getString("regionId");
		Long limit = inputDto.getLong("limit");
		Long offset = inputDto.getLong("offset");

		QueryBuilder builder = new QueryBuilder();
		builder.add(
				"SELECT A.region_customer_id, A. region_id, B.region_code,B.region_name, B.customer_id, c.partner_code, c.partner_name, a,version FROM ")
				.add(RegionCustomer.TABLE_NAME)
				.add(" A ")
				.add(" INNER JOIN ")
				.add(Region.TABLE_NAME)
				.add(" B ON A.region_id = B.region_id ")
				.add(" INNER JOIN ")
				.add(City.TABLE_NAME)
				.add(" C ON A.city_id = c.city_id ")
				.add(" INNER JOIN ")
				.add(Partner.TABLE_NAME)
				.add(" D ON A.customer_id = c.partner_id ")
				.add(" WHERE A.tenant_id = :tenantId ")

				.addIfNotEquals(regionId, " AND A.region_id =  " + regionId,
						regionId)
				.addIfNotEmpty(
						customerCodeName,
						" AND (  "
								+ CriteriaHelper.likeExpressionIgnoreCase(
										customerCodeName, "A.partner_code")
								+ " OR "
								+ CriteriaHelper.likeExpressionIgnoreCase(
										customerCodeName, "A.partner_name")
								+ " ) ").add("LIMIT :limit OFFSET :offset");


		Query q = posDao.createNativeQuery(builder.toString());
		q.setParameter("tenantId", tenantId);
		q.setParameter("regionId", regionId);
		q.setParameter("partnerCode", partnerCode);
		q.setParameter("partnerName", partnerName);
		q.setParameter("limit", limit);
		q.setParameter("offset", offset);

		result = q.getResultList();

		return new Dto().putList("RegionCustomerList", DtoUtil.createDtoListFromArray(result, "regionCustomerId", "regionId", "regionCode", "regionName", "customerId", "partnerCode", "partnerName", "version"));

	}

	@Override
	public String getDescription() {
		return "Get Region Customer List";
	}
}