widana

Untitled

May 22nd, 2017
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 4.66 KB | None | 0 0
  1. package id.co.sts.wms.bo.todo;
  2.  
  3. import id.co.sts.wms.DatabaseConstant;
  4. import id.co.sts.wms.WmsConstant;
  5. import id.co.sts.wms.dao.TempDoDao;
  6. import id.co.sts.wms.entity.TempDo;
  7. import id.co.sts.wms.entity.TempRg;
  8.  
  9. import java.util.List;
  10.  
  11. import javax.persistence.Query;
  12.  
  13. import org.jleaf.core.AbstractBusinessFunction;
  14. import org.jleaf.core.BusinessFunction;
  15. import org.jleaf.core.Dto;
  16. import org.jleaf.core.annotation.Info;
  17. import org.jleaf.core.annotation.InfoIn;
  18. import org.jleaf.core.annotation.InfoOut;
  19. import org.jleaf.core.dao.QueryBuilder;
  20. import org.jleaf.util.DtoUtil;
  21. import org.jleaf.util.ValidationUtil;
  22. import org.slf4j.Logger;
  23. import org.slf4j.LoggerFactory;
  24. import org.springframework.beans.factory.annotation.Autowired;
  25. import org.springframework.stereotype.Service;
  26.  
  27. /**
  28.  * Get To Do List
  29.  * @author Hans Kristianto, Sep 22, 2014
  30.  * @version 1.0
  31.  */
  32.  
  33. // @Service
  34. @InfoIn(value = {
  35.     @Info(name = "deviceId", description = "device id", type = Long.class, required = true),
  36.     @Info(name = "statusDocFlag", description = "status doc flag", type = String.class, required = true),
  37.     @Info(name = "docTypeId", description = "document type id", type = String.class, required = true),
  38.     @Info(name = "offsetFlag", description = "offset flag", type = String.class, required = true),
  39.     @Info(name = "warehouseId", description = "WarehouseId", type = Long.class, required = true)
  40.    
  41. })
  42. @InfoOut(value = {
  43.         @Info(name = "toDoList", description = "list of to do (docId, docTypeID, docNo, docDate, partnerName, extDocNo)")
  44.     })
  45. //@formatter:on
  46. @Deprecated
  47. public class GetToDoList extends AbstractBusinessFunction implements BusinessFunction {
  48.  
  49.     private static final Logger log = LoggerFactory.getLogger(GetToDoList.class);
  50.    
  51.     @Autowired
  52.     TempDoDao tempDoDao;
  53.    
  54.     @Override
  55.     public String getDescription() {
  56.         return "Get to do list";
  57.     }
  58.  
  59.     @Override
  60.     public Dto execute(Dto inputDto) throws Exception {
  61.  
  62.         ValidationUtil.valDtoContainsKey(inputDto, "deviceId");
  63.         ValidationUtil.valDtoContainsKey(inputDto, "statusDocFlag");
  64.         ValidationUtil.valDtoContainsKey(inputDto, "docTypeId");
  65.         ValidationUtil.valDtoContainsKey(inputDto, "offsetFlag");
  66.         ValidationUtil.valDtoContainsKey(inputDto, "warehouseId");
  67.        
  68.         Long deviceId = inputDto.getLong("deviceId");
  69.         String statusDocFlag = inputDto.getString("statusDocFlag");
  70.         Long  docTypeId= inputDto.getLong("docTypeId");
  71.         Long  warehouseId= inputDto.getLong("warehouseId");
  72.         Long offsetFlag = inputDto.getLong("offsetFlag");
  73.  
  74.         List<Object[]> result = null;
  75.  
  76.         if(docTypeId.longValue() == WmsConstant.DOCUMENT_DOC_TYPE_TEMP_DO){
  77.         QueryBuilder builderDo = new QueryBuilder();
  78.         builderDo.add("SELECT B.temp_do_id AS doc_id, :docType AS doc_type_id, B.doc_no, B.doc_date, A.partner_name, B.ext_doc_no ")
  79.                 .add("FROM ")
  80.                 .add(DatabaseConstant.TABLE_NAME_PARTNER)
  81.                 .add(" A JOIN ")
  82.                 .add(TempDo.TABLE_NAME)
  83.                 .add(" B ON A.partner_id = B.partner_id ")
  84.                 .add("WHERE B.status_doc=:statusDocFlag ")
  85.                 .add("AND B.device_id=:deviceId ")
  86.                 .add("AND B.warehouse_id=:warehouseId ")
  87.                 .add("ORDER BY doc_id DESC")
  88.                 .add(" LIMIT 10 OFFSET :offsetFlag");
  89.        
  90.         Query queryDo = tempDoDao.createNativeQuery(builderDo.toString());
  91.         queryDo.setParameter("docType", WmsConstant.DOCUMENT_DOC_TYPE_TEMP_DO);
  92.         queryDo.setParameter("statusDocFlag", statusDocFlag);
  93.         queryDo.setParameter("deviceId", deviceId);
  94.         queryDo.setParameter("warehouseId", warehouseId);
  95.         queryDo.setParameter("offsetFlag", offsetFlag);
  96.        
  97.         result = queryDo.getResultList();
  98.        
  99.         }else{
  100.  
  101.             QueryBuilder builderRg = new QueryBuilder();
  102.             builderRg.add("SELECT B.temp_rg_id AS doc_id, :docType AS doc_type_id, B.doc_no, B.doc_date, A.partner_name, B.ext_doc_no ")
  103.                     .add("FROM ")
  104.                     .add(DatabaseConstant.TABLE_NAME_PARTNER)
  105.                     .add(" A JOIN ")
  106.                     .add(TempRg.TABLE_NAME)
  107.                     .add(" B ON A.partner_id = B.partner_id ")
  108.                     .add("WHERE B.status_doc=:statusDocFlag ")
  109.                     .add("AND B.device_id=:deviceId ")
  110.                     .add("AND B.warehouse_id=:warehouseId ")
  111.                     .add("ORDER BY doc_id DESC")
  112.                     .add(" LIMIT 10 OFFSET :offsetFlag");
  113.            
  114.             Query queryRg = tempDoDao.createNativeQuery(builderRg.toString());
  115.             queryRg.setParameter("docType", WmsConstant.DOCUMENT_DOC_TYPE_TEMP_RG);
  116.             queryRg.setParameter("statusDocFlag", statusDocFlag);
  117.             queryRg.setParameter("deviceId", deviceId);
  118.             queryRg.setParameter("warehouseId", warehouseId);
  119.             queryRg.setParameter("offsetFlag", offsetFlag);
  120.            
  121.             result = queryRg.getResultList();
  122.        
  123.         }
  124.        
  125.         return new Dto().putList("toDoList", DtoUtil.createDtoListFromArray(result,
  126.                 "docId", "docTypeId", "docNo", "docDate", "partnerName" , "extDocNo"));
  127.        
  128.     }
  129.  
  130. }
Advertisement
Add Comment
Please, Sign In to add comment