Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package org.jleaf.erp.commerce.bo.cekstock;
- import java.util.List;
- import javax.persistence.Query;
- import org.jleaf.erp.master.entity.Product;
- import org.slf4j.Logger;
- import org.slf4j.LoggerFactory;
- import org.jleaf.erp.master.entity.SellPriceProductForSo;
- import org.jleaf.erp.master.entity.Warehouse;
- import org.jleaf.core.AbstractBusinessFunction;
- import org.jleaf.core.BusinessFunction;
- import org.jleaf.core.Dto;
- import org.jleaf.erp.inv.entity.ProductBalanceStock;
- import org.jleaf.erp.inv.dao.ProductBalanceStockDao;
- import org.jleaf.erp.master.dao.ProductDao;
- import org.jleaf.erp.master.dao.SellPriceProductForSoDao;
- 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.util.DtoUtil;
- import org.jleaf.util.ValidationUtil;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.stereotype.Service;
- /**
- *
- * @author Widana Nur Azis, Feb 06, 2016
- *
- **/
- //@formatter:off
- @Service
- @InfoIn(value = {
- @Info(name = "tenantId", description = "tenant id", type = Long.class),
- @Info(name = "productId", description = "product id", type = Long.class)
- })
- @InfoOut(value = {
- @Info(name = "product", description = "list of product (id, productCode, productName)", type = List.class),
- @Info(name = "stock", description = "list of stock (qty,uomName,warehouseCode,warehouseName)", type = List.class),
- @Info(name = "price", description = "list of price (code,price, currCode)", type = List.class)
- })
- @ErrorList(errorKeys = {
- })
- //@formatter:on
- public class GetDetailProductById extends AbstractBusinessFunction implements BusinessFunction {
- private static Logger log = LoggerFactory.getLogger(GetDetailProductById.class);
- @Autowired
- ProductDao productDao;
- @Autowired
- SellPriceProductForSoDao sellPriceProductForSoDao;
- @Autowired
- private ProductBalanceStockDao productBalanceStockDao;
- public String getDescription() {
- // TODO Auto-generated method stub
- return " untuk mendapatkan detail produk dari produk,stock dan price ";
- }
- @SuppressWarnings({"unchecked"})
- public Dto execute(Dto inputDto) throws Exception {
- // TODO Auto-generated method stub
- ValidationUtil.valBlankOrNull(inputDto, "productId");
- ValidationUtil.valDtoContainsKey(inputDto, "productId");
- Long productId = inputDto.getLong("productId");
- Long tenantId = inputDto.getLong("tenantId");
- Dto outputDtoOfList = new Dto();
- List<Object[]> resultDetailProductStock = null;
- List<Object[]> resultDetailProductPrice = null;
- QueryBuilder builderProduct = new QueryBuilder();
- builderProduct.add(" SELECT ")
- .add(" product_id,tenant_id,product_code,product_name ")
- .add(" FROM ").add(Product.TABLE_NAME)
- .add(" WHERE product_id = :productId AND tenant_id = :tenantId LIMIT 1 ");
- Query queryProduct = productDao.createNativeQuery(builderProduct.toString());
- queryProduct.setParameter("productId", productId);
- queryProduct.setParameter("tenantId", tenantId);
- List<Object[]> list = queryProduct.getResultList();
- if(!list.isEmpty() && list.size() > 0L ) {
- outputDtoOfList = outputDtoOfList.putList("product", DtoUtil.createDtoListFromArray(list, "id","tenantId","productCode","productName"));
- }
- QueryBuilder builderDetailProductStock = new QueryBuilder();
- builderDetailProductStock.add(" SELECT ")
- .add(" COALESCE(SUM(A.qty),0),f_get_uom_name(A.base_uom_id) AS uom_name,B.warehouse_code,B.warehouse_name ")
- .add(" FROM ").add(ProductBalanceStock.TABLE_NAME).add(" A ")
- .add(" INNER JOIN ").add(Warehouse.TABLE_NAME).add(" B ON A.warehouse_id = B.warehouse_id ")
- .add(" WHERE A.product_id = :productId AND A.tenant_id = :tenantId ")
- .add(" GROUP BY A.base_uom_id,B.warehouse_code,B.warehouse_name ")
- .add(" ORDER BY B.warehouse_name ASC ");
- Query queryDetailProductStock = productBalanceStockDao.createNativeQuery(builderDetailProductStock.toString());
- queryDetailProductStock.setParameter("tenantId", tenantId);
- queryDetailProductStock.setParameter("productId", productId);
- resultDetailProductStock = queryDetailProductStock.getResultList();
- outputDtoOfList = outputDtoOfList.putList("stock", DtoUtil.createDtoListFromArray(resultDetailProductStock, "qty","uomName","warehouseCode","warehouseName"));
- QueryBuilder builderDetailProductPrice = new QueryBuilder();
- builderDetailProductPrice.add(" SELECT ")
- .add(" A.price_level,A.gross_sell_price,A.curr_code ")
- .add(" FROM ").add(SellPriceProductForSo.TABLE_NAME).add(" A ")
- .add(" WHERE A.tenant_id = :tenantId AND A.product_id = :productId ")
- .add(" GROUP BY A.price_level,A.gross_sell_price,A.curr_code ")
- .add(" ORDER BY A.gross_sell_price DESC ");
- Query queryDetailProductPrice = productBalanceStockDao.createNativeQuery(builderDetailProductPrice.toString());
- queryDetailProductPrice.setParameter("tenantId", tenantId);
- queryDetailProductPrice.setParameter("productId", productId);
- resultDetailProductPrice = queryDetailProductPrice.getResultList();
- outputDtoOfList = outputDtoOfList.putList("price", DtoUtil.createDtoListFromArray(resultDetailProductPrice, "code","price","currCode"));
- log.info(" OUTPUT INPUT " + outputDtoOfList);
- return outputDtoOfList;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment