API tools faq
paste
Advertisement
Guest User

ShipmentPickingMonitorSCH

a guest
Mar 30th, 2018
116
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 18.09 KB | None | 0 0
raw download clone embed print report
  1. // $Id: Sch.xml 2808 2014-10-27 05:13:07Z noriyuki_sawa_ha.daifuku.co.jp $
  2. package jp.co.daifuku.wms.gadgets.gadget.shipmentpicking;
  3.  
  4. /*
  5.  * Copyright(c) 2000-2013 DAIFUKU Co.,Ltd. All Rights Reserved.
  6.  *
  7.  * This software is the proprietary information of DAIFUKU Co.,Ltd.
  8.  * Use is subject to license terms.
  9.  */
  10. import static jp.co.daifuku.wms.gadgets.gadget.shipmentpicking.ShipmentPickingMonitorSCHParams.ASPG_BAR;
  11. import static jp.co.daifuku.wms.gadgets.gadget.shipmentpicking.ShipmentPickingMonitorSCHParams.ASPG_BAR_MAX;
  12. import static jp.co.daifuku.wms.gadgets.gadget.shipmentpicking.ShipmentPickingMonitorSCHParams.PROGRESS_BAR1_DATA1;
  13. import static jp.co.daifuku.wms.gadgets.gadget.shipmentpicking.ShipmentPickingMonitorSCHParams.PROGRESS_MAX;
  14. import static jp.co.daifuku.wms.gadgets.gadget.shipmentpicking.ShipmentPickingMonitorSCHParams.SRPG_BAR;
  15. import static jp.co.daifuku.wms.gadgets.gadget.shipmentpicking.ShipmentPickingMonitorSCHParams.SRPG_BAR_MAX;
  16. import static jp.co.daifuku.wms.gadgets.gadget.shipmentpicking.ShipmentPickingMonitorSCHParams.TXT_ASCASEPICK;
  17. import static jp.co.daifuku.wms.gadgets.gadget.shipmentpicking.ShipmentPickingMonitorSCHParams.TXT_ASPALLETPICK;
  18. import static jp.co.daifuku.wms.gadgets.gadget.shipmentpicking.ShipmentPickingMonitorSCHParams.TXT_SHIPNUM;
  19. import static jp.co.daifuku.wms.gadgets.gadget.shipmentpicking.ShipmentPickingMonitorSCHParams.TXT_SRCASEPICK;
  20. import static jp.co.daifuku.wms.gadgets.gadget.shipmentpicking.ShipmentPickingMonitorSCHParams.TXT_SRPALLETPICK;
  21. import static jp.co.daifuku.wms.gadgets.gadget.shipmentpicking.ShipmentPickingMonitorSCHParams.TXT_STATUS;
  22. import static jp.co.daifuku.wms.gadgets.gadget.shipmentpicking.ShipmentPickingMonitorSCHParams.TXT_WORKDATE;
  23.  
  24. import java.sql.Connection;
  25. import java.sql.SQLException;
  26. import java.util.Date;
  27. import java.util.Locale;
  28.  
  29. import jp.co.daifuku.dgate.dashboard.function.AbstractParams;
  30. import jp.co.daifuku.dgate.dashboard.function.AbstractSCH;
  31. import jp.co.daifuku.dgate.dashboard.function.GadgetUserInfo;
  32. import jp.co.daifuku.dgate.util.DgateUserResource;
  33. import jp.co.daifuku.wms7.base.util.FormatUtil;
  34. import jp.co.daifuku.wms7.dbhandler.DBConstants;
  35. import jp.co.daifuku.wms7.dbhandler.DBHandler;
  36. import jp.co.daifuku.wms7.dbhandler.DBRecord;
  37. import jp.co.daifuku.wms7.dbhandler.DBStores;
  38. import jp.co.daifuku.wms7.dbhandler.SQLQuery;
  39. import jp.co.daifuku.wms7.dbhandler.DBConstants.dnretrievalPlanStatusFlag;
  40. import jp.co.daifuku.wms7.dbhandler.DBConstants.dnshipworkinfo;
  41. import jp.co.daifuku.wms7.dbhandler.DBConstants.dnwaveStatus;
  42. import jp.co.daifuku.wms7.dbhandler.DBConstants.dnworkinfoTypes;
  43. import jp.co.daifuku.wms7.dbhandler.DBConstants.dnworkinfoloadwork;
  44. import jp.co.daifuku.wms7.dgatecollect.GadgetUtil;
  45.  
  46. /**
  47.  * Scheduler(SCH) class  generated by BusiTune
  48.  *
  49.  * @version $Revision: 2808 $, $Date: 2014-10-27 14:13:07 +0900 (隴幢ｿｽ, 27 10 2014) $
  50.  * @author  Dgate Designer.
  51.  * @author  Last commit: $Author: noriyuki_sawa_ha.daifuku.co.jp $
  52.  */
  53. public class ShipmentPickingMonitorSCH
  54.         extends AbstractSCH
  55. {
  56.     //------------------------------------------------------------
  57.     // fields (upper case only)
  58.     //------------------------------------------------------------
  59.  
  60.     //------------------------------------------------------------
  61.     // class variables (prefix '$')
  62.     //------------------------------------------------------------
  63.  
  64.     //------------------------------------------------------------
  65.     // instance variables (prefix '_')
  66.     //------------------------------------------------------------
  67.  
  68.     //------------------------------------------------------------
  69.     // constructors
  70.     //------------------------------------------------------------
  71.     /**
  72.      * Constructor to create SCH object
  73.      * @param conn Database Connection
  74.      * @param locale Browser Locale
  75.      * @param userInfo UserInfo
  76.      * @throws SQLException
  77.      */
  78.     public ShipmentPickingMonitorSCH(Connection conn, Locale locale, GadgetUserInfo userInfo) throws SQLException
  79.     {
  80.         //super(conn, locale, userInfo);
  81.         super(java.sql.DriverManager.getConnection("jdbc:oracle:thin:@172.16.142.101:1521:orcl", "wms", "wms"), locale, userInfo);
  82.     }    
  83.     //------------------------------------------------------------
  84.     // public methods
  85.     //------------------------------------------------------------
  86.     /**
  87.      *
  88.      * @return
  89.      */
  90.     public AbstractParams query()
  91.     {
  92.         ShipmentPickingMonitorSCHParams params = new ShipmentPickingMonitorSCHParams();
  93.         initiate(params);
  94.         SQLQuery _sqlQuery=createSqlOfWorkStatus();
  95.         try
  96.         {
  97.              DBHandler handler = new DBHandler();
  98.              DBStores dbWorkStatus = null;
  99.              DBStores dbProgress = null;    
  100.              dbWorkStatus = handler.select(getConnection(), _sqlQuery);
  101.              int TOTAL_WORK_QTY=0,TOTAL_RESULT_QTY=0;
  102.              int PALLET_PICK_QTY=0,CASE_PICK_QTY=0;
  103.              int TOTAL_PALLET_PICK_QTY=0,TOTAL_CASE_PICK_QTY=0;
  104.              Date workDate= new Date();
  105.              params.set(TXT_WORKDATE, FormatUtil.convertDateToString(workDate,DBConstants.WMS_FORMATTER.DATE_FORMAT));
  106.              if (!dbWorkStatus.isEmpty())
  107.              {
  108.                  for (DBRecord record : dbWorkStatus)
  109.                  {   
  110.                      params.set(TXT_SHIPNUM, record.getString("SHIP_TICKET_NUM"));
  111.                      params.set(TXT_STATUS, record.getInt("STATUS_FLAG"));
  112.                      params.set(PROGRESS_BAR1_DATA1, record.getInt("RESULT_QTY")*100/record.getInt("TOTAL_PLAN_QTY"));
  113.                      params.set(PROGRESS_MAX, 100);
  114.                      _sqlQuery.clear();
  115.                      _sqlQuery=createSqlOfProgress(record.getString("WAVE_SEQ"));
  116.                      dbProgress=handler.select(getConnection(), _sqlQuery);
  117.                      for (DBRecord record1 : dbProgress) {
  118.                          if(record1.getInt("WORK_TYPE")==DBConstants.dnworkinfoTypes.WORK_TYPE.RETRIEVAL
  119.                                  ||record1.getInt("WORK_TYPE")==DBConstants.dnworkinfoTypes.WORK_TYPE.RETRIEVAL_ESHAPE) {
  120.                              TOTAL_WORK_QTY+=record1.getInt("TOTAL_WORK_QTY");
  121.                              TOTAL_RESULT_QTY+=record1.getInt("TOTAL_RESULT_QTY");
  122.                              PALLET_PICK_QTY+=record1.getInt("PALLET_PICK_QTY");
  123.                              TOTAL_PALLET_PICK_QTY+=record1.getInt("TOTAL_PALLET_PICK_QTY");
  124.                              CASE_PICK_QTY+=record1.getInt("CASE_PICK_QTY");
  125.                              TOTAL_CASE_PICK_QTY+=record1.getInt("TOTAL_CASE_PICK_QTY");
  126.                              
  127.                          }
  128.                         //2018/03/30 EDIT:START
  129.                          else if(record1.getInt("WORK_TYPE")==DBConstants.dnworkinfoTypes.WORK_TYPE.SELECTIVE_RACK_PICKING) {
  130.                         //2018/03/30 EDIT:END    
  131.                              params.set(SRPG_BAR, record1.getInt("TOTAL_RESULT_QTY")*100/record1.getInt("TOTAL_WORK_QTY"));
  132.                              params.set(SRPG_BAR_MAX,100);
  133.                              params.set(TXT_SRCASEPICK,record1.getInt("CASE_PICK_QTY")+"/"+record1.getInt("TOTAL_CASE_PICK_QTY"));
  134.                              params.set(TXT_SRPALLETPICK,record1.getInt("PALLET_PICK_QTY")+"/"+record1.getInt("TOTAL_PALLET_PICK_QTY"));
  135.                          }        
  136.                      }                  
  137.                      params.set(ASPG_BAR, TOTAL_RESULT_QTY*100/TOTAL_WORK_QTY);
  138.                      params.set(ASPG_BAR_MAX,100);
  139.                      params.set(TXT_ASCASEPICK,CASE_PICK_QTY+"/"+TOTAL_CASE_PICK_QTY);
  140.                      params.set(TXT_ASPALLETPICK,PALLET_PICK_QTY+"/"+TOTAL_PALLET_PICK_QTY);
  141.                  }
  142.              }
  143.         }catch (Exception e)
  144.         {
  145.            
  146.         }
  147.         return params;      
  148.     }
  149.  
  150.     //------------------------------------------------------------
  151.     // accessor methods
  152.     //------------------------------------------------------------
  153.  
  154.     //------------------------------------------------------------
  155.     // package methods
  156.     //------------------------------------------------------------
  157.  
  158.     //------------------------------------------------------------
  159.     // protected methods
  160.     //------------------------------------------------------------
  161.  
  162.     //------------------------------------------------------------
  163.     // private methods
  164.     //------------------------------------------------------------
  165.     private void initiate(ShipmentPickingMonitorSCHParams params) {
  166.         params.set(TXT_WORKDATE, null);
  167.         params.set(TXT_SHIPNUM, null);
  168.         params.set(TXT_STATUS, null);
  169.         params.set(PROGRESS_BAR1_DATA1,0);
  170.         params.set(PROGRESS_MAX, 100);
  171.         params.set(ASPG_BAR, 0);
  172.         params.set(ASPG_BAR_MAX,100);
  173.         params.set(TXT_ASCASEPICK,0+"/"+0);
  174.         params.set(TXT_ASPALLETPICK,0+"/"+0);
  175.         params.set(SRPG_BAR, 0);
  176.         params.set(SRPG_BAR_MAX,100);
  177.         params.set(TXT_SRCASEPICK,0+"/"+0);
  178.         params.set(TXT_SRPALLETPICK,0+"/"+0);
  179.     }
  180.     private SQLQuery createSqlOfWorkStatus()
  181.     {
  182.         SQLQuery sqlQuery = new SQLQuery();
  183.         sqlQuery.append("SELECT RetrivalPlan.WAVE_SEQ,");
  184.         sqlQuery.append("       RetrivalPlan.SHIP_TICKET_NUM,");
  185.         sqlQuery.append("       RetrivalPlan.STATUS_FLAG,");
  186.         sqlQuery.append("       (SELECT SUM(DNRETRIEVALPLAN.PLAN_QTY)");
  187.         sqlQuery.append("               FROM DNRETRIEVALPLAN");
  188.         sqlQuery.append("        WHERE DNRETRIEVALPLAN.WAVE_SEQ = RetrivalPlan.WAVE_SEQ");
  189.         sqlQuery.append("        AND DNRETRIEVALPLAN.STATUS_FLAG != ").append(dnretrievalPlanStatusFlag.STATUS_FLAG.DELTED);
  190.         sqlQuery.append("        GROUP BY DNRETRIEVALPLAN.WAVE_SEQ) TOTAL_PLAN_QTY,");
  191.         sqlQuery.append("         NVL((SELECT SUM(DNSHIPWORKINFO.RESULT_QTY)");
  192.         sqlQuery.append("                         FROM DNSHIPWORKINFO");
  193.         sqlQuery.append("                  WHERE DNSHIPWORKINFO.WAVE_SEQ = RetrivalPlan.WAVE_SEQ");
  194.         sqlQuery.append("                  AND DNSHIPWORKINFO.STATUS_FLAG = ").append(dnshipworkinfo.STATUS_FLAG.COMPLETED).append(" ),0) AS RESULT_QTY ");
  195.         sqlQuery.append(" FROM  (SELECT DISTINCT DNWAVE.WAVE_SEQ,DNRETRIEVALPLAN.SHIP_TICKET_NUM,DNWAVE.STATUS_FLAG");
  196.         sqlQuery.append("             FROM DNWAVE,DNRETRIEVALPLAN,");
  197.         sqlQuery.append("             (SELECT *FROM (SELECT DNWAVE.WAVE_SEQ");
  198.         sqlQuery.append("                                   FROM DNWAVE");
  199.         sqlQuery.append("                   WHERE ( DNWAVE.STATUS_FLAG = ").append(dnwaveStatus.DNWAVE_STATUS_TYPE.ONQUEUE);
  200.         sqlQuery.append("                   OR DNWAVE.STATUS_FLAG = ").append(dnwaveStatus.DNWAVE_STATUS_TYPE.WORKING);
  201.         sqlQuery.append("                   OR DNWAVE.STATUS_FLAG = ").append(dnwaveStatus.DNWAVE_STATUS_TYPE.SHORTAGE).append(" ) ");
  202.         sqlQuery.append("                            AND   DNWAVE.WAVE_TYPE = ").append(dnwaveStatus.DNWAVE_TYPE.SHIPMENT);
  203.         sqlQuery.append("                            ORDER BY DNWAVE.STATUS_FLAG DESC, DNWAVE.PRIORITY DESC,DNWAVE.SHORTAGE_ALLOC_FLAG DESC,DNWAVE.WAVE_START_TIME ASC)");
  204.         sqlQuery.append("              WHERE ROWNUM <= 1) CURRENT_WORK");
  205.         sqlQuery.append(" WHERE CURRENT_WORK.WAVE_SEQ = DNWAVE.WAVE_SEQ ");
  206.         sqlQuery.append(" AND   DNWAVE.WAVE_TYPE = ").append(dnwaveStatus.DNWAVE_TYPE.SHIPMENT);
  207.         sqlQuery.append(" AND   DNWAVE.WAVE_SEQ = DNRETRIEVALPLAN.WAVE_SEQ) RetrivalPlan");
  208.         sqlQuery.append(" GROUP BY RetrivalPlan.WAVE_SEQ,RetrivalPlan.SHIP_TICKET_NUM,RetrivalPlan.STATUS_FLAG");      
  209.         return sqlQuery;
  210.     }
  211.     private SQLQuery createSqlOfProgress(String wave_seq)
  212.     {
  213.         SQLQuery sqlQuery = new SQLQuery();
  214.         sqlQuery.append("SELECT CASE WHEN PROGRESS.WORK_TYPE= ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.RFT_CONSOLIDATE));
  215.         sqlQuery.append("                 AND PROGRESS.PICKING_TYPE= ").append(dnshipworkinfo.PICKING_TYPE.CASE_INDUCTION);
  216.         sqlQuery.append("            THEN ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.RETRIEVAL_ESHAPE));
  217.         sqlQuery.append("       ELSE PROGRESS.WORK_TYPE END WORK_TYPE,");
  218.         sqlQuery.append("       SUM(PROGRESS.RESULT_QTY) AS TOTAL_RESULT_QTY,");
  219.         sqlQuery.append("       SUM(PROGRESS.WORK_QTY) AS TOTAL_WORK_QTY,");
  220.         sqlQuery.append("       SUM(PROGRESS.CASE_PICK) AS CASE_PICK_QTY,");
  221.         sqlQuery.append("       SUM(PROGRESS.TOTAL_CASE_PICK) AS TOTAL_CASE_PICK_QTY,");
  222.         sqlQuery.append("       SUM(PROGRESS.PALLET_PICK) AS PALLET_PICK_QTY,");
  223.         sqlQuery.append("       SUM(PROGRESS.TOTAL_PALLET_PICK) AS TOTAL_PALLET_PICK_QTY");
  224.         sqlQuery.append("FROM (SELECT DNWORKINFO.WORK_TYPE,");
  225.         sqlQuery.append("             CASE WHEN DNWORKINFO.WORK_TYPE != ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.RFT_CONSOLIDATE));
  226.         sqlQuery.append("                  THEN DNWORKINFO.WORK_QTY ELSE 0  ");
  227.         sqlQuery.append("             END WORK_QTY,");
  228.         sqlQuery.append("             DNSHIPWORKINFO.PICKING_TYPE,");
  229.         sqlQuery.append("             CASE");
  230.         sqlQuery.append("               WHEN DNSHIPWORKINFO.STATUS_FLAG = ").append(dnshipworkinfo.STATUS_FLAG.COMPLETED);
  231.         sqlQuery.append("               THEN DNSHIPWORKINFO.RESULT_QTY ELSE 0");
  232.         sqlQuery.append("             END AS RESULT_QTY,");
  233.         sqlQuery.append("             CASE");
  234.         sqlQuery.append("               WHEN (DNWORKINFO.WORK_TYPE = ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.RETRIEVAL_ESHAPE));
  235.         sqlQuery.append("                    OR (DNWORKINFO.WORK_TYPE = ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.RFT_CONSOLIDATE)).append(" AND DNSHIPWORKINFO.PICKING_TYPE = ").append(dnshipworkinfo.PICKING_TYPE.CASE_INDUCTION).append(" ) ");
  236.         sqlQuery.append("                    OR (DNWORKINFO.WORK_TYPE = ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.SELECTIVE_RACK_PICKING)).append(" AND (DNWORKINFO.WORK_QTY != DNSTOCK.STOCK_QTY OR DNSTOCK.STOCK_QTY != DMITEM.PIECE_PER_PALLET) AND MOD(DNWORKINFO.WORK_QTY,NVL(DMITEM.PIECE_PER_CASE,1)) = 0)) AND DNSHIPWORKINFO.STATUS_FLAG = ").append(dnshipworkinfo.STATUS_FLAG.COMPLETED);
  237.         sqlQuery.append("               THEN FLOOR(DNSHIPWORKINFO.RESULT_QTY / NVL(DMITEM.PIECE_PER_CASE,1)) ELSE 0");
  238.         sqlQuery.append("             END AS CASE_PICK,");
  239.         sqlQuery.append("             CASE");
  240.         sqlQuery.append("               WHEN (DNWORKINFO.WORK_TYPE = ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.RETRIEVAL_ESHAPE));
  241.         sqlQuery.append("                    OR (DNWORKINFO.WORK_TYPE = ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.SELECTIVE_RACK_PICKING)).append(" AND (DNWORKINFO.WORK_QTY != DNSTOCK.STOCK_QTY OR DNSTOCK.STOCK_QTY != DMITEM.PIECE_PER_PALLET ) AND MOD(DNWORKINFO.WORK_QTY,NVL(DMITEM.PIECE_PER_CASE,1)) = 0))  ");
  242.         sqlQuery.append("               THEN FLOOR(DNWORKINFO.WORK_QTY / NVL(DMITEM.PIECE_PER_CASE,1)) ELSE 0");
  243.         sqlQuery.append("             END AS TOTAL_CASE_PICK,");
  244.         sqlQuery.append("             CASE");
  245.         sqlQuery.append("               WHEN (DNWORKINFO.WORK_TYPE = ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.RETRIEVAL));
  246.         sqlQuery.append("                    OR (DNWORKINFO.WORK_TYPE = ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.SELECTIVE_RACK_PICKING)).append(" AND (DNWORKINFO.WORK_QTY = DNSTOCK.STOCK_QTY AND DNSTOCK.STOCK_QTY = DMITEM.PIECE_PER_PALLET ))) AND DNSHIPWORKINFO.STATUS_FLAG = ").append(dnshipworkinfo.STATUS_FLAG.COMPLETED);
  247.         sqlQuery.append("               THEN FLOOR(DNSHIPWORKINFO.RESULT_QTY/NVL(DMITEM.PIECE_PER_PALLET,1)) ELSE 0");  
  248.         sqlQuery.append("             END AS PALLET_PICK,");
  249.         sqlQuery.append("             CASE");
  250.         sqlQuery.append("               WHEN (DNWORKINFO.WORK_TYPE = ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.RETRIEVAL));
  251.         sqlQuery.append("                    OR (DNWORKINFO.WORK_TYPE = ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.SELECTIVE_RACK_PICKING)).append(" AND (DNWORKINFO.WORK_QTY = DNSTOCK.STOCK_QTY AND DNSTOCK.STOCK_QTY = DMITEM.PIECE_PER_PALLET ))) ");
  252.         sqlQuery.append("               THEN FLOOR(DNWORKINFO.WORK_QTY/NVL(DMITEM.PIECE_PER_PALLET,1)) ELSE 0");  
  253.         sqlQuery.append("             END AS TOTAL_PALLET_PICK");
  254.         sqlQuery.append("       FROM DNWAVE JOIN DNRETRIEVALPLAN ON DNWAVE.WAVE_SEQ=DNRETRIEVALPLAN.WAVE_SEQ ");
  255.         sqlQuery.append("            LEFT JOIN DNWORKINFO ON DNRETRIEVALPLAN.PLAN_UKEY = DNWORKINFO.PLAN_UKEY ").append(" AND DNWORKINFO.LOAD_WORK_STATUS != ").append(dnworkinfoTypes.LOAD_WORK_STATUS.DELETE);  
  256.         sqlQuery.append("            JOIN DNSTOCK ON DNSTOCK.STOCK_ID=DNWORKINFO.STOCK_ID");
  257.         sqlQuery.append("            JOIN DMITEM  ON DMITEM.ITEM_CODE=DNSTOCK.ITEM_CODE");
  258.         sqlQuery.append("            LEFT JOIN DNSHIPWORKINFO ON DNSHIPWORKINFO.WAVE_SEQ = DNWAVE.WAVE_SEQ AND DNWORKINFO.STOCK_ID=DNSHIPWORKINFO.STOCK_ID");
  259.         sqlQuery.append("       WHERE DNWAVE.WAVE_SEQ = '"+wave_seq+"'");
  260.         sqlQuery.append("       AND   DNWAVE.WAVE_TYPE = ").append(dnwaveStatus.DNWAVE_TYPE.SHIPMENT);
  261.         sqlQuery.append("       AND ( DNWAVE.STATUS_FLAG = ").append(dnwaveStatus.DNWAVE_STATUS_TYPE.ONQUEUE);
  262.         sqlQuery.append("           OR DNWAVE.STATUS_FLAG = ").append(dnwaveStatus.DNWAVE_STATUS_TYPE.WORKING);
  263.         sqlQuery.append("           OR DNWAVE.STATUS_FLAG = ").append(dnwaveStatus.DNWAVE_STATUS_TYPE.SHORTAGE).append(" ) ");
  264.         sqlQuery.append("       AND DNRETRIEVALPLAN.STATUS_FLAG != ").append(dnretrievalPlanStatusFlag.STATUS_FLAG.DELTED);
  265.         sqlQuery.append("       AND ( DNWORKINFO.WORK_TYPE = ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.RETRIEVAL));
  266.         sqlQuery.append("           OR DNWORKINFO.WORK_TYPE = ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.RETRIEVAL_ESHAPE));
  267.         sqlQuery.append("           OR DNWORKINFO.WORK_TYPE = ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.SELECTIVE_RACK_PICKING));
  268.         sqlQuery.append("           OR DNWORKINFO.WORK_TYPE = ").append(String.valueOf(dnworkinfoTypes.WORK_TYPE.RFT_CONSOLIDATE)).append(" ))PROGRESS ");
  269.         sqlQuery.append("GROUP BY PROGRESS.WORK_TYPE,PROGRESS.PICKING_TYPE");
  270.         return sqlQuery;
  271.     }
  272.     //------------------------------------------------------------
  273.     // utility methods
  274.     //------------------------------------------------------------
  275.     /**
  276.      * Returns current repository info for this class
  277.      * @return version
  278.      */
  279.     public static String getVersion()
  280.     {
  281.         return "$Id: Sch.xml 2808 2014-10-27 05:13:07Z noriyuki_sawa_ha.daifuku.co.jp $";
  282.     }
  283. }
  284. //end of class
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!