Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package id.co.sts.wms.bo.todo;
- import id.co.sts.wms.DatabaseConstant;
- import id.co.sts.wms.WmsConstant;
- import id.co.sts.wms.dao.TempDoDao;
- import id.co.sts.wms.entity.TempDo;
- import id.co.sts.wms.entity.TempRg;
- 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.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.slf4j.Logger;
- import org.slf4j.LoggerFactory;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.stereotype.Service;
- /**
- * Get To Do List
- * @author Hans Kristianto, Sep 22, 2014
- * @version 1.0
- */
- // @Service
- @InfoIn(value = {
- @Info(name = "deviceId", description = "device id", type = Long.class, required = true),
- @Info(name = "statusDocFlag", description = "status doc flag", type = String.class, required = true),
- @Info(name = "docTypeId", description = "document type id", type = String.class, required = true),
- @Info(name = "offsetFlag", description = "offset flag", type = String.class, required = true),
- @Info(name = "warehouseId", description = "WarehouseId", type = Long.class, required = true)
- })
- @InfoOut(value = {
- @Info(name = "toDoList", description = "list of to do (docId, docTypeID, docNo, docDate, partnerName, extDocNo)")
- })
- //@formatter:on
- @Deprecated
- public class GetToDoList extends AbstractBusinessFunction implements BusinessFunction {
- private static final Logger log = LoggerFactory.getLogger(GetToDoList.class);
- @Autowired
- TempDoDao tempDoDao;
- @Override
- public String getDescription() {
- return "Get to do list";
- }
- @Override
- public Dto execute(Dto inputDto) throws Exception {
- ValidationUtil.valDtoContainsKey(inputDto, "deviceId");
- ValidationUtil.valDtoContainsKey(inputDto, "statusDocFlag");
- ValidationUtil.valDtoContainsKey(inputDto, "docTypeId");
- ValidationUtil.valDtoContainsKey(inputDto, "offsetFlag");
- ValidationUtil.valDtoContainsKey(inputDto, "warehouseId");
- Long deviceId = inputDto.getLong("deviceId");
- String statusDocFlag = inputDto.getString("statusDocFlag");
- Long docTypeId= inputDto.getLong("docTypeId");
- Long warehouseId= inputDto.getLong("warehouseId");
- Long offsetFlag = inputDto.getLong("offsetFlag");
- List<Object[]> result = null;
- if(docTypeId.longValue() == WmsConstant.DOCUMENT_DOC_TYPE_TEMP_DO){
- QueryBuilder builderDo = new QueryBuilder();
- 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 ")
- .add("FROM ")
- .add(DatabaseConstant.TABLE_NAME_PARTNER)
- .add(" A JOIN ")
- .add(TempDo.TABLE_NAME)
- .add(" B ON A.partner_id = B.partner_id ")
- .add("WHERE B.status_doc=:statusDocFlag ")
- .add("AND B.device_id=:deviceId ")
- .add("AND B.warehouse_id=:warehouseId ")
- .add("ORDER BY doc_id DESC")
- .add(" LIMIT 10 OFFSET :offsetFlag");
- Query queryDo = tempDoDao.createNativeQuery(builderDo.toString());
- queryDo.setParameter("docType", WmsConstant.DOCUMENT_DOC_TYPE_TEMP_DO);
- queryDo.setParameter("statusDocFlag", statusDocFlag);
- queryDo.setParameter("deviceId", deviceId);
- queryDo.setParameter("warehouseId", warehouseId);
- queryDo.setParameter("offsetFlag", offsetFlag);
- result = queryDo.getResultList();
- }else{
- QueryBuilder builderRg = new QueryBuilder();
- 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 ")
- .add("FROM ")
- .add(DatabaseConstant.TABLE_NAME_PARTNER)
- .add(" A JOIN ")
- .add(TempRg.TABLE_NAME)
- .add(" B ON A.partner_id = B.partner_id ")
- .add("WHERE B.status_doc=:statusDocFlag ")
- .add("AND B.device_id=:deviceId ")
- .add("AND B.warehouse_id=:warehouseId ")
- .add("ORDER BY doc_id DESC")
- .add(" LIMIT 10 OFFSET :offsetFlag");
- Query queryRg = tempDoDao.createNativeQuery(builderRg.toString());
- queryRg.setParameter("docType", WmsConstant.DOCUMENT_DOC_TYPE_TEMP_RG);
- queryRg.setParameter("statusDocFlag", statusDocFlag);
- queryRg.setParameter("deviceId", deviceId);
- queryRg.setParameter("warehouseId", warehouseId);
- queryRg.setParameter("offsetFlag", offsetFlag);
- result = queryRg.getResultList();
- }
- return new Dto().putList("toDoList", DtoUtil.createDtoListFromArray(result,
- "docId", "docTypeId", "docNo", "docDate", "partnerName" , "extDocNo"));
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment