get tnpa relasi

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

import java.util.ArrayList;
import java.util.List;

import javax.persistence.Query;

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.QueryBuilder;
import org.jleaf.erp.master.dao.region.RegionCityDao;
import org.jleaf.erp.master.entity.region.RegionCity;
import org.jleaf.util.DtoUtil;
import org.jleaf.util.ValidationUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
@InfoIn(value = {
		@Info(name = "tenantId", description = "Tenant id", type = Long.class, required = true),
		@Info(name = "regionId", description = "Region Id", type = Long.class, required = true),
		@Info(name = "cityCode", description = "City Code", type = Long.class, required = true)
})
@InfoOut(value = {
		@Info(name = "regionCityList", description = "Region City List(id,tenantId,regionId,cityCode,createDateTime,createUserId,updateDateTime,updateUserId,version)", type = Long.class, required = true)
})
public class GetRegionCityList implements BusinessFunction {
	@Autowired
	private RegionCityDao regionCityDao;
	@Override
	public Dto execute(Dto inputDto) throws Exception {
		// TODO Auto-generated method stub
		ValidationUtil.valBlankOrNull(inputDto, "tenantId");
		ValidationUtil.valBlankOrNull(inputDto, "regionId");
		ValidationUtil.valDtoContainsKey(inputDto, "cityCode");

		Long tenantId = inputDto.getLong("tenantId");
		Long regionId = inputDto.getLong("regionId");
		String cityCode = inputDto.getString("cityCode");

		QueryBuilder builder =  new QueryBuilder();
		builder.add("SELECT region_city_id, tenant_id,region_id,city_code,create_datetime,create_user_id,update_datetime,update_user_id, version");
		builder.add(" FROM ");
		builder.add(RegionCity.TABLE_NAME);
		builder.add(" WHERE tenant_id =:tenantId");
		builder.add(" AND region_id =:regionId");
		builder.addIfNotEmpty(cityCode, " AND region_city = '"+cityCode+"'");


		Query query = regionCityDao.createNativeQuery (builder.toString());
		query.setParameter("tenantId", tenantId);
		query.setParameter("regionId", regionId);

		List<Object[]> list = query.getResultList();
		if(list.size()==0){
			return new Dto().putList("regionCityList", new ArrayList<Dto>());

		}else{
			return new Dto().putList("regionCityList", DtoUtil.createDtoListFromArray(list,
					"id","tenantId","regionId","cityCode","createDateTime","createUserId",
					"updateDateTime","updateUserId","version"));
		}
	}

	@Override
	public String getDescription() {
		// TODO Auto-generated method stub
		return "Get Region City List";
	}
}