Index: src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java =================================================================== diff -u -r2b56e7dc9b86e7e6ed18b0ed350164d01197d5bf -rd6fe4609bafd690e3ee4121da7784812957b1bfe --- src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java (.../SessionDAOImpl.java) (revision 2b56e7dc9b86e7e6ed18b0ed350164d01197d5bf) +++ src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java (.../SessionDAOImpl.java) (revision d6fe4609bafd690e3ee4121da7784812957b1bfe) @@ -4985,14 +4985,15 @@ return sj.toString ( ); } + + @Override public List> getMinMaxSessionUnselectedProducts (int sessionId, Integer siteId ) { return jdbcTemplate.queryForList ( "select mmcl.LINE_ID as \"id\", mmcl.FIELD_ABBR as \"code\", 'false' as \"line\", 14 as \"orderCycle\",7 as \"leadTime\" , 'false' as \"perCar\", 'true' as \"isStockEditOff\" from MIN_MAX_CALC_LINE mmcl \n" + "where mmcl.ACTIVE_FLAG = 1 and mmcl.LINE_ID in (\n" + "select LINE_ID from MIN_MAX_CALC_LINE where LINE_ID not in (select PRODUCT_LINE_ID from MIN_MAX_SESSION_PROD_LINE where SESSION_ID = " + sessionId + " and site_id= "+ siteId + " )\n" + "and ACTIVE_FLAG = 1\n" + ") order by mmcl.FIELD_ABBR" ); - } @Override