GetHistoryPaymentOrderListForInquiryAp

package org.jleaf.erp.fin.bo.inquiryap;

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.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.QueryBuilder;
import org.jleaf.erp.fin.FinanceConstants;
import org.jleaf.erp.fin.dao.InvoiceApDao;
import org.jleaf.erp.fin.entity.ApPaymentOrder;
import org.jleaf.util.DtoUtil;
import org.jleaf.util.ValidationUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

//@formatter:off
@Service
@InfoIn(value = {
    @Info(name = "tenantId", description = "Tenant id", type = Long.class),
    @Info(name = "ouId", description = "OU id", type = Long.class),
    @Info(name = "userId", description = "user id", type = Long.class),
    @Info(name = "roleId", description = "role id", type = Long.class),
    @Info(name = "partnerId", description = "partner id", type = Long.class),
    @Info(name = "dateFrom", description = "date from", type = String.class),
    @Info(name = "dateTo", description = "date to", type = String.class)
})
@InfoOut(value = {
    @Info(name = "paymentOrderList", description = "outstanding payment order list (trxCashbankBalanceId, paymentOrderId, docNo, docDate, currCode, debitAmount, creditAmount, paymentAmount, partnerId, partnerCode, partnerName, statusDoc)", type = List.class)
})
@ErrorList(errorKeys ={

})
//@formatter:off
public class GetHistoryPaymentOrderListForInquiryAp  extends AbstractBusinessFunction implements BusinessFunction {

    @Autowired
    private InvoiceApDao invoiceApDao;

    @Override
    public String getDescription() {
        return "Get history payment order list for inquiry AP";
    }

    @Override
    public Dto execute(Dto inputDto) throws Exception {
        ValidationUtil.valDtoContainsKey(inputDto, "tenantId");
        ValidationUtil.valDtoContainsKey(inputDto, "ouId");
        ValidationUtil.valDtoContainsKey(inputDto, "userId");
        ValidationUtil.valDtoContainsKey(inputDto, "roleId");
        ValidationUtil.valDtoContainsKey(inputDto, "partnerId");
        ValidationUtil.valDtoContainsKey(inputDto, "dateFrom");
        ValidationUtil.valDtoContainsKey(inputDto, "dateTo");

        Long tenantId = inputDto.getLong("tenantId");
        Long ouId = inputDto.getLong("ouId");
        Long userId = inputDto.getLong("userId");
        Long roleId = inputDto.getLong("roleId");
        Long partnerId = inputDto.getLong("partnerId");
        String dateFrom = inputDto.getString("dateFrom");
        String dateTo = inputDto.getString("dateTo");

        QueryBuilder queryBuilder = new QueryBuilder();
        queryBuilder.add(" SELECT A.trx_cashbank_balance_id, B.payment_order_id, B.doc_no, B.doc_date, B.curr_code, B.debit_amount, B.credit_amount, B.payment_amount, A.partner_id, f_get_partner_code(A.partner_id) AS partner_code, f_get_partner_name(A.partner_id) AS partner_name, B.status_doc FROM ")
                    .add(" cb_trx_cashbank_balance A ")
                    .add(" INNER JOIN ")
                    .add(ApPaymentOrder.TABLE_NAME)
                    .add(" B ON A.doc_type_id = B.doc_type_id AND A.payment_id = B.payment_order_id ")
                    .add(" WHERE A.tenant_id = :tenantId ")
                    .add(" AND A.doc_type_id = :DOCUMENT_PAYMENT_ORDER_AP ")
                    .add(" AND A.ou_id = :ouId ")
                    .addIfNotEquals(partnerId, GeneralConstants.NULL_REF_VALUE_LONG, " AND A.partner_id = :partnerId ")
                    .add(" AND B.doc_date BETWEEN :dateFrom AND :dateTo ")
                    .add(" AND f_authorize_user_role_policy_partner(:tenantId, :userId, :roleId, A.partner_id) = 1 ");

        Query query = invoiceApDao.createNativeQuery(queryBuilder.toString());
        query.setParameter("tenantId", tenantId);
        query.setParameter("ouId", ouId);
        query.setParameter("userId", userId);
        query.setParameter("roleId", roleId);
        if (!GeneralConstants.NULL_REF_VALUE_LONG.equals(partnerId)) {
            query.setParameter("partnerId", partnerId);
        }
        query.setParameter("dateFrom", dateFrom);
        query.setParameter("dateTo", dateTo);
        query.setParameter("DOCUMENT_PAYMENT_ORDER_AP", FinanceConstants.DOCUMENT_AP_PAYMENT_ORDER);

        List<Object[]> list = query.getResultList();

        return new Dto().put("paymentOrderList", DtoUtil.createDtoListFromArray(list, "trxCashbankBalanceId", "paymentOrderId", "docNo", "docDate", "currCode", "debitAmount", "creditAmount", "paymentAmount", "partnerId", "partnerCode", "partnerName", "statusDoc"));
    }

}