Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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.InvoiceApBalanceDao;
- import org.jleaf.erp.fin.entity.InvoiceApBalance;
- 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 = "invoiceList", description = "outstanding invoice list (invoiceApBalanceId, docTypeId, invoiceApId, docDesc, docNo, docDate, partnerName, poNo, poDate, extDocNo, extDocDate, currCode, amount, outstandingAmount, dueDate, flgPayment)", type = List.class)
- })
- @ErrorList(errorKeys ={
- })
- //@formatter:off
- public class GetHistoryInvoiceListForInquiryAp extends AbstractBusinessFunction implements BusinessFunction {
- @Autowired
- private InvoiceApBalanceDao invoiceApBalanceDao;
- @Override
- public String getDescription() {
- return "Get history invoice list for inquiry AP";
- }
- @SuppressWarnings("unchecked")
- @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.invoice_ap_balance_id, A.doc_type_id, A.invoice_ap_id, f_get_doc_desc(A.doc_type_id) AS doc_desc, A.doc_no, A.doc_date, f_get_partner_name(A.partner_id) AS partner_name, COALESCE(B.doc_no, :SPACE) AS po_no, COALESCE(B.doc_date, :SPACE) AS po_date, A.ext_doc_no, A.ext_doc_date, A.curr_code, A.amount, (A.amount - A.payment_amount) AS outstanding_amount, A.due_date, A.flg_payment ")
- .add(" FROM ")
- .add(InvoiceApBalance.TABLE_NAME)
- .add(" A ")
- .add(" LEFT OUTER JOIN ")
- .add(" pu_po B ON A.ref_doc_type_id = B.doc_type_id AND A.ref_id = B.po_id ")
- .add(" WHERE A.tenant_id = :tenantId ")
- .add(" AND A.ou_id = :ouId ")
- .add(" AND A.doc_date BETWEEN :dateFrom AND :dateTo ")
- .addIfNotEquals(partnerId, GeneralConstants.NULL_REF_VALUE_LONG, " AND A.partner_id = :partnerId ")
- .add(" AND f_authorize_user_role_policy_partner(:tenantId, :userId, :roleId, A.partner_id) = 1 ")
- .add(" AND NOT EXISTS ( ")
- .add(" SELECT 1 ")
- .add(" FROM fi_payment_order_invoice Z ")
- .add(" INNER JOIN cb_trx_cashbank_balance X ON Z.payment_order_id = X.payment_id ")
- .add(" AND X.doc_type_id = :docTypePaymentOrderAp ")
- .add(" WHERE A.doc_type_id = Z.ref_doc_type_id ")
- .add(" AND A.invoice_ap_balance_id = Z.ref_id ")
- .add(" AND X.flg_payment = :VOID ")
- .add(" ) ")
- .add(" ORDER BY A.doc_no ASC, A.doc_date ASC, A.curr_code ASC, outstanding_amount DESC ");
- Query query = invoiceApBalanceDao.createNativeQuery(queryBuilder.toString());
- query.setParameter("tenantId", tenantId);
- query.setParameter("ouId", ouId);
- query.setParameter("userId", userId);
- query.setParameter("roleId", roleId);
- query.setParameter("VOID", FinanceConstants.VOID_TRANSACTION);
- query.setParameter("docTypePaymentOrderAp", FinanceConstants.DOCUMENT_AP_PAYMENT_ORDER);
- if (!GeneralConstants.NULL_REF_VALUE_LONG.equals(partnerId)) {
- query.setParameter("partnerId", partnerId);
- }
- query.setParameter("dateFrom", dateFrom);
- query.setParameter("dateTo", dateTo);
- query.setParameter("SPACE", GeneralConstants.SPACE_VALUE);
- List<Object[]> list = query.getResultList();
- return new Dto().put("invoiceList", DtoUtil.createDtoListFromArray(list, "invoiceApBalanceId", "docTypeId", "invoiceApId", "docDesc", "docNo", "docDate", "partnerName", "poNo", "poDate", "extDocNo", "extDocDate", "currCode", "amount", "outstandingAmount", "dueDate", "flgPayment"));
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement