Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package org.jleaf.erp.sls.bo.salesorder;
- import java.math.BigDecimal;
- import java.math.BigInteger;
- import java.util.List;
- import javax.persistence.Query;
- import org.jleaf.common.entity.ComboValue;
- import org.jleaf.core.AbstractBusinessFunction;
- import org.jleaf.core.BusinessFunction;
- import org.jleaf.core.Dto;
- 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.master.bo.ComboIdMasterConstants;
- import org.jleaf.erp.master.entity.Tax;
- import org.jleaf.erp.sls.bo.returninvoice.SubmitReturnSalesInvoiceForCland;
- import org.jleaf.erp.sls.dao.SalesOrderDao;
- import org.jleaf.erp.sls.entity.SalesOrder;
- import org.jleaf.erp.sls.entity.SalesOrderItem;
- import org.jleaf.util.Calc;
- 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;
- //@formatter:off
- @Service("findTotalSummarySalesOrder")
- @InfoIn(value = {
- @Info(name = "tenantId", description = "tenant Id", type = Long.class),
- @Info(name = "soId", description = "so id", type = Long.class)})
- @InfoOut(value = {
- @Info(name = "totalItem", description = "total item", type = Long.class),
- @Info(name = "totalItemAmount", description = "total item amount", type = Double.class),
- @Info(name = "totalTaxAmount", description = "total tax amount", type = Double.class),
- @Info(name = "grandTotal", description = "grandTotal", type = Double.class),
- @Info(name = "currCode", description = "currCode", type = String.class),
- @Info(name = "currPropKey", description = "currPropKey", type = String.class)
- })
- @ErrorList(errorKeys = {})
- //@formatter:on
- public class FindTotalSummarySalesOrderForCland extends AbstractBusinessFunction implements BusinessFunction {
- private final Logger log = LoggerFactory.getLogger(FindTotalSummarySalesOrderForCland.class);
- @Autowired
- SalesOrderDao salesOrderDao;
- @Override
- public String getDescription() {
- return "Find total summary sales order";
- }
- @SuppressWarnings("unchecked")
- @Override
- public Dto execute(Dto inputDto) throws Exception {
- Dto outputDto = new Dto();
- ValidationUtil.valDtoContainsKey(inputDto, "tenantId");
- ValidationUtil.valDtoContainsKey(inputDto, "soId");
- Long tenantId = inputDto.getLong("tenantId");
- Long soId = inputDto.getLong("soId");
- // get total products
- QueryBuilder queryBuilderTotalItem = new QueryBuilder();
- queryBuilderTotalItem.add("SELECT COUNT(a.so_item_id) AS totalItem FROM ")
- .add(SalesOrderItem.TABLE_NAME)
- .add(" a WHERE a.tenant_id = :tenantId ")
- .add(" AND a.so_id = :soId ");
- Query queryTotalItem = salesOrderDao.createNativeQuery(queryBuilderTotalItem.toString());
- queryTotalItem.setParameter("tenantId", tenantId);
- queryTotalItem.setParameter("soId", soId);
- List<Object> resultTotalItem = queryTotalItem.getResultList();
- Long totalItem = 0L;
- if (resultTotalItem.size() > 0) {
- totalItem = ((BigInteger) resultTotalItem.get(0)).longValue();
- }
- outputDto.put("totalItem", totalItem);
- ////////////////////
- QueryBuilder builderSummaryTotal = new QueryBuilder();
- builderSummaryTotal.add(" SELECT ")
- .add(" COALESCE(SUM(A.qty_so),0) AS total_qty_item_so , COALESCE(A.qty_so * A.gross_sell_price,0) AS total_amount_so ")
- .add(" FROM ")
- .add(SalesOrderItem.TABLE_NAME).add(" A ")
- .add(" WHERE true ")
- .add(" AND ")
- .add(" A.tenant_id = :tenantId ")
- .add(" AND ")
- .add(" A.so_id = :soId ");
- Query resultQuerySummaryTotal = salesOrderDao.createNativeQuery(builderSummaryTotal.toString());
- resultQuerySummaryTotal.setParameter("tenantId", tenantId);
- resultQuerySummaryTotal.setParameter("soId", soId);
- List<Object[]> listForSummaryTotal = resultQuerySummaryTotal.getResultList();
- if(listForSummaryTotal.size() > 0) {
- List<Dto> summaryTotal = DtoUtil.createDtoListFromArray(listForSummaryTotal, "totalQtyItemSo","totalAmountSo");
- outputDto.put("totalQtyItemSo", summaryTotal.get(0).getDouble("totalQtyItemSo"));
- outputDto.put("totalAmountSo", summaryTotal.get(0).getDouble("totalAmountSo"));
- }
- ////////////////////
- // get currency for this sales order
- QueryBuilder queryBuilderCurrency = new QueryBuilder();
- queryBuilderCurrency.add("SELECT a.curr_code, b.prop_key FROM ")
- .add(SalesOrder.TABLE_NAME)
- .add(" a INNER JOIN ")
- .add(ComboValue.TABLE_NAME)
- .add(" b ON a.curr_code = b.code AND b.combo_id = :COMBO_CURRENCY ")
- .add(" WHERE a.tenant_id = :tenantId ")
- .add(" AND a.so_id = :soId ");
- Query queryCurrency = salesOrderDao.createNativeQuery(queryBuilderCurrency.toString());
- queryCurrency.setParameter("tenantId", tenantId);
- queryCurrency.setParameter("soId", soId);
- queryCurrency.setParameter("COMBO_CURRENCY", ComboIdMasterConstants.COMBO_CURRENCY);
- List<Object[]> resultCurrency = queryCurrency.getResultList();
- if (resultCurrency.size() > 0) {
- List<Dto> currency = DtoUtil.createDtoListFromArray(resultCurrency, "currCode", "currPropKey");
- outputDto.put("currCode", currency.get(0).getString("currCode"));
- outputDto.put("currPropKey", currency.get(0).getString("currPropKey"));
- }
- Calc totalItemAmount = new Calc(0);
- Calc totalDiscountAmount = new Calc(0);
- if (totalItem > 0) {
- // get total nett item amount (kena pajak + tidak kena pajak) dan grand total
- QueryBuilder queryBuilderTotal = new QueryBuilder();
- queryBuilderTotal.add("SELECT SUM(a.nett_item_amount) AS totalItemAmount, SUM(a.discount_amount) * a.qty_so AS total_discount_amount FROM ")
- .add(SalesOrderItem.TABLE_NAME)
- .add(" a WHERE a.tenant_id = :tenantId ")
- .add(" AND a.so_id = :soId ")
- .add(" GROUP BY a.qty_so ");
- Query queryTotal = salesOrderDao.createNativeQuery(queryBuilderTotal.toString());
- queryTotal.setParameter("tenantId", tenantId);
- queryTotal.setParameter("soId", soId);
- List<Dto> resultTotal = DtoUtil.createDtoListFromArray(queryTotal.getResultList(), "totalItemAmount", "totalDiscountAmount");
- if (resultTotal != null && !resultTotal.isEmpty()) {
- for (Dto dto : resultTotal) {
- Double sumItemAmount = Double.valueOf(dto.getString("totalItemAmount"));
- Double sumDiscountAmount = Double.valueOf(dto.getString("totalDiscountAmount"));
- totalItemAmount = totalItemAmount.add(sumItemAmount);
- totalDiscountAmount = totalDiscountAmount.add(sumDiscountAmount);
- }
- }
- }
- outputDto.put("totalItemAmount", totalItemAmount.doubleValue());
- outputDto.put("totalDiscountAmount", totalDiscountAmount.doubleValue());
- Calc totalTaxAmountBigDecimal = new Calc(0);
- if (totalItem > 0) {
- QueryBuilder builderTotalTax = new QueryBuilder();
- builderTotalTax.add("SELECT a.tax_id, d.flg_amount, f_tax_rounding(a.tenant_id, SUM(a.nett_item_amount), a.tax_percentage) AS sumTaxAmount FROM ")
- .add(SalesOrderItem.TABLE_NAME)
- .add(" a INNER JOIN ")
- .add(SalesOrder.TABLE_NAME)
- .add(" b ON a.tenant_id = b.tenant_id AND a.so_id = b.so_id ")
- .add(" INNER JOIN ")
- .add(Tax.TABLE_NAME)
- .add(" d ON a.tax_id = d.tax_id AND a.tenant_id = d.tenant_id ")
- .add(" WHERE a.tenant_id = :tenantId AND a.so_id = :soId ")
- .add(" GROUP BY a.tax_id, d.flg_amount, a.tax_percentage, a.tenant_id ");
- Query queryTotalTax = salesOrderDao.createNativeQuery(builderTotalTax.toString());
- queryTotalTax.setParameter("tenantId", tenantId);
- queryTotalTax.setParameter("soId", soId);
- List<Object[]> resultTotalTax = queryTotalTax.getResultList();
- if (resultTotalTax.size() > 0) {
- List<Dto> returnList = DtoUtil.createDtoListFromArray(resultTotalTax, "taxId", "flgAmount", "sumTaxAmount");
- for (Dto dto : returnList) {
- Double flgAmount = Double.valueOf(dto.getString("flgAmount"));
- Double sumTaxAmount = Double.valueOf(dto.getString("sumTaxAmount"));
- Calc taxBigDecimal = new Calc(sumTaxAmount).multiply(flgAmount);
- totalTaxAmountBigDecimal = totalTaxAmountBigDecimal.add(taxBigDecimal);
- }
- }
- }
- Double grandTotal = totalItemAmount.add(totalTaxAmountBigDecimal.doubleValue()).getValue().doubleValue();
- outputDto.put("totalTaxAmount", totalTaxAmountBigDecimal.doubleValue());
- Double grandTotalWithTax = new Calc(grandTotal).doubleValue();
- outputDto.put("grandTotal", grandTotalWithTax);
- log.info(" LOAD outputDto " + outputDto);
- return outputDto;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment