Index: pom.xml
===================================================================
diff -u -r02411019c7a80cb91383e65fec0baf73fce9ce71 -r181eb6d2384a23bf06e3d5f917b1a46451ec6b55
--- pom.xml (.../pom.xml) (revision 02411019c7a80cb91383e65fec0baf73fce9ce71)
+++ pom.xml (.../pom.xml) (revision 181eb6d2384a23bf06e3d5f917b1a46451ec6b55)
@@ -21,7 +21,6 @@
org.springframework.boot
spring-boot-starter-web-services
-
org.springframework.boot
spring-boot-starter-tomcat
Index: src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java
===================================================================
diff -u -r6b94185047fb649204898fa1d71764c580dcffe8 -r181eb6d2384a23bf06e3d5f917b1a46451ec6b55
--- src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java (.../ReviewDAOImpl.java) (revision 6b94185047fb649204898fa1d71764c580dcffe8)
+++ src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java (.../ReviewDAOImpl.java) (revision 181eb6d2384a23bf06e3d5f917b1a46451ec6b55)
@@ -244,34 +244,8 @@
+ "and ssp.SITE_ID=sp.SITE_ID and SSP.LEVEL4_PARENT_ID=sp.HIERARCHY_ID and sp.SITE_ID=s.SITE_ID "
+ " and (ssp.effective_pts = 230 and ssp.RECOMMENDED_ORDER_QTY > 0) ";
}
- //dcSales Filter
- if(skuTableWidgetData.getDcSalesMonth() != null ) {
- //dcSales 12 Filter
- if (skuTableWidgetData.getDcSalesMonth() == 12) {
- sql += "and ssp.dc_sales_last_12_months ";
- if (skuTableWidgetData.getDcSalesMin() != null && skuTableWidgetData.getDcSalesMax() != null && skuTableWidgetData.getDcSalesMax() >= skuTableWidgetData.getDcSalesMin()) {
- sql += " between " + skuTableWidgetData.getDcSalesMin() + " and " + skuTableWidgetData.getDcSalesMax() ;
- } else if (skuTableWidgetData.getDcSalesMax() != null && skuTableWidgetData.getDcSalesMin() == null) {
- sql += " <= " + skuTableWidgetData.getDcSalesMax();
- } else if (skuTableWidgetData.getDcSalesMin() != null && skuTableWidgetData.getDcSalesMax() == null) {
- sql += " >= " + skuTableWidgetData.getDcSalesMin();
- }
- }
- //DcSales 24 Filter
- if (skuTableWidgetData.getDcSalesMonth() == 24) {
- sql += "and ssp.dc_sales_last_24_months ";
- if (skuTableWidgetData.getDcSalesMin() != null && skuTableWidgetData.getDcSalesMax() != null && skuTableWidgetData.getDcSalesMax() >= skuTableWidgetData.getDcSalesMin()) {
- sql += " between " + skuTableWidgetData.getDcSalesMin() + " and " + skuTableWidgetData.getDcSalesMax() ;
- } else if (skuTableWidgetData.getDcSalesMax() != null && skuTableWidgetData.getDcSalesMin() == null) {
- sql += " <= " + skuTableWidgetData.getDcSalesMax();
- } else if (skuTableWidgetData.getDcSalesMin() != null && skuTableWidgetData.getDcSalesMax() == null) {
- sql += " >= " + skuTableWidgetData.getDcSalesMin();
- }
- }
- }
-
//PUL-7923 Stocked and Non Stocked
if (skuTableWidgetData.isDcStocking() && ("stockedatdc").equals(skuTableWidgetData.getSelectedStockNonStockOption().trim())) {
sql += " and (ssp.product_id = dc_sp.product_id(+) AND NVL(dc_sp.max_stocking_qty, 0) > 0 ) ";
@@ -450,7 +424,6 @@
}
-
// New Parts filter
if (skuTableWidgetData.isProspectParts()) {
sql += " and ((ssp.FORECAST_MODEL_ID IN (0,200, 20000) AND ssp.RECOMMENDED_ORDER_QTY > 0) "
Index: src/main/java/com/napa/pulse/service/impl/SessionServiceImpl.java
===================================================================
diff -u -r6b94185047fb649204898fa1d71764c580dcffe8 -r181eb6d2384a23bf06e3d5f917b1a46451ec6b55
--- src/main/java/com/napa/pulse/service/impl/SessionServiceImpl.java (.../SessionServiceImpl.java) (revision 6b94185047fb649204898fa1d71764c580dcffe8)
+++ src/main/java/com/napa/pulse/service/impl/SessionServiceImpl.java (.../SessionServiceImpl.java) (revision 181eb6d2384a23bf06e3d5f917b1a46451ec6b55)
@@ -39,10 +39,8 @@
@Autowired
private InformaticaServiceClient informaticaServiceClient;
@Autowired
- SessionServiceImpl(SessionDAO sessionDAO,AcoDAO acoDAO,InformaticaServiceClient informaticaServiceClient) {
+ SessionServiceImpl(SessionDAO sessionDAO) {
this.sessionDAO = sessionDAO;
- this.acoDAO= acoDAO;
- this.informaticaServiceClient=informaticaServiceClient;
}
/*
Index: src/test/java/com/napa/pulse/dao/impl/ReviewDAOImplUnitTest.java
===================================================================
diff -u -r02411019c7a80cb91383e65fec0baf73fce9ce71 -r181eb6d2384a23bf06e3d5f917b1a46451ec6b55
--- src/test/java/com/napa/pulse/dao/impl/ReviewDAOImplUnitTest.java (.../ReviewDAOImplUnitTest.java) (revision 02411019c7a80cb91383e65fec0baf73fce9ce71)
+++ src/test/java/com/napa/pulse/dao/impl/ReviewDAOImplUnitTest.java (.../ReviewDAOImplUnitTest.java) (revision 181eb6d2384a23bf06e3d5f917b1a46451ec6b55)
@@ -105,10 +105,10 @@
List