BF COUNT

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

import javax.persistence.Query;

import org.jleaf.core.AbstractBusinessFunction;
import org.jleaf.core.BusinessFunction;
import org.jleaf.core.CoreExceptionConstants;
import org.jleaf.core.Dto;
import org.jleaf.core.GeneralConstants;
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.core.dao.CriteriaHelper;
import org.jleaf.core.dao.QueryBuilder;
import org.jleaf.erp.master.dao.RegionCustomerDao;
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.ValidationUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * BusinessFunction: Get count region customer list
 *
 * @author Nadia , Sept 08, 2016
 *
 */
@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) })
@InfoOut(value = { @Info(name = "count", description = "count", type = Long.class) })
@ErrorList(errorKeys = { CoreExceptionConstants.PARAMETER_NOT_SPECIFIED })
public class CountRegionCustomerList extends AbstractBusinessFunction implements
		BusinessFunction {

	@Autowired
	private RegionCustomerDao regionCustomerDao;

	@Override
	public String getDescription() {
		return "count get region customer list ";
	}

	@Override
	public Dto execute(Dto inputDto) throws Exception {
		ValidationUtil.valDtoContainsKey(inputDto, "tenantId");

		ValidationUtil.valBlankOrNull(inputDto, "tenantId");
		ValidationUtil.valDtoContainsKey(inputDto, "regionId");
		ValidationUtil.valDtoContainsKey(inputDto, "customerCodeName");

		ValidationUtil.valDtoContainsKey(inputDto, "limit");
		ValidationUtil.valDtoContainsKey(inputDto, "offset");

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

		QueryBuilder builder = new QueryBuilder();
		builder.add(
				" SELECT COUNT(region_customer_id) ")
				.add(" 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(Partner.TABLE_NAME)
				.add(" C ON A.customer_id = C.partner_id ")
				.add(" WHERE  A.tenant_id = :tenantId ")
				     .addIfNotEquals( GeneralConstants.NULL_REF_VALUE_LONG, regionId, " AND A.region_id =  "+regionId )
				     .addIfNotEmpty(
				    		 customerCodeName,
				    		 " AND (  "
				    		  + CriteriaHelper.likeExpressionIgnoreCase(
				    				  customerCodeName, "C.partner_code" )
					          + " OR "
					          + CriteriaHelper.likeExpressionIgnoreCase(
					        		  		customerCodeName, "C.partner_name" )
					          + " ) " ).add("LIMIT :limit OFFSET :offset");

		Query q = regionCustomerDao.createNativeQuery(builder.toString());
		q.setParameter("tenantId", tenantId);
		q.setParameter("limit", limit);
		q.setParameter("offset", offset);


		Dto outputDto = new Dto();
		outputDto.put("count", q.getSingleResult());

		return outputDto;
	}

}