Index: src/main/java/com/napa/pulse/controller/rest/SessionRestController.java =================================================================== diff -u -ra39112b79f71eaf165fa2a7db3d243e44a2dfe1d -r72337b2b4d23c409d690143c39b1d194a3509f3d --- src/main/java/com/napa/pulse/controller/rest/SessionRestController.java (.../SessionRestController.java) (revision a39112b79f71eaf165fa2a7db3d243e44a2dfe1d) +++ src/main/java/com/napa/pulse/controller/rest/SessionRestController.java (.../SessionRestController.java) (revision 72337b2b4d23c409d690143c39b1d194a3509f3d) @@ -300,18 +300,18 @@ "includeOverstocks : {}, includeSupersede : {}, includeSoldNotStocked : {}, includeNewNumbers : {}, orderAllSkus : {}, dollarLimit : {}, " + "keyLinesOrders : {}, keyLinesReturns : {}, includeLessThanStdPkg : {}, useInvColls : {}, addDepth : {}, " + "comment : {}, siteGroup : {}, sites : {}, productGroups : {},fleetGroups : {}, " + - "customProductGroup : {}, skus : {}, productLines : {}, includeOrders : {}, includeReturns : {}, " + + "customProductGroup : {}, skus : {}, productLines : {}, siteProductLines : {}, includeOrders : {}, includeReturns : {}, " + "expirationDate : {}, includeHubSpokeOrder : {}, includeHubSpokeReturn : {}, includeHubSpokeOrderOption : {}, includeHubSpokeReturnOption : {}, " + "includeDaysCount : {}, updatesToMinValue : {}, salesHistoryValue : {},displayQty :{} ,sessionType : {} , applicationPartsOnly : {}, " + - "expirationDate : {}, isGroupCode : {}", + "expirationDate : {}, isGroupCode : {},leadTimeSiteStatus : {} ", includeFleets, perCarOrder, includeSystems, includeSpecials, includeObsoletes, includeOverstocks, includeSupersede, includeSoldNotStocked, includeNewNumbers, orderAllSkus, dollarLimit, keyLinesOrders, keyLinesReturns, includeLessThanStdPkg, useInvColls, addDepth, comment, siteGroup, sites, productGroups, fleetGroups, - customProductGroup, skus, productLines, includeOrders, includeReturns, + customProductGroup, skus, productLines,siteProductLine, includeOrders, includeReturns, expirationDate, includeHubSpokeOrder, includeHubSpokeReturn, includeHubSpokeOrderOption, includeHubSpokeReturnOption, includeDaysCount, updatesToMinValue, salesHistoryValue,displayQty, sessionType, applicationPartsOnly, - expirationDate,isGroupCode); + expirationDate,isGroupCode,leadTimeSiteStatus); } catch (Exception exp) { LOGGER.error("Encountered error in createNewSession() payload logger", exp); } Index: src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java =================================================================== diff -u -r2b56e7dc9b86e7e6ed18b0ed350164d01197d5bf -r72337b2b4d23c409d690143c39b1d194a3509f3d --- 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 72337b2b4d23c409d690143c39b1d194a3509f3d) @@ -1041,7 +1041,7 @@ return siteProductLines.length; } } ); - String sql1="update MIN_MAX_SITE_PREFERENCES set USER_CREATED_DATE=SYSDATE,USER_CREATED= "+user.getUserId ()+" where site_id in ( "+ siteIds +" ) and USER_CREATED_DATE is null "; + String sql1="update MIN_MAX_SITE_PREFERENCES set USER_CREATED_DATE = SYSDATE where site_id in ( "+ siteIds +" ) and USER_CREATED_DATE is null "; String sql2="update MIN_MAX_SITE_PREFERENCES set USER_CREATED= "+user.getUserId ()+" where site_id in ( "+ siteIds +" ) and USER_CREATED is null "; jdbcTemplate.update(sql1); jdbcTemplate.update(sql2); @@ -1201,18 +1201,18 @@ "includeOverstocks : {}, includeSupersede : {}, includeSoldNotStocked : {}, includeNewNumbers : {}, orderAllSkus : {}, dollarLimit : {}, " + "keyLinesOrders : {}, keyLinesReturns : {}, includeLessThanStdPkg : {}, useInvColls : {}, addDepth : {}, " + "comment : {}, siteGroup : {}, sites : {}, productGroups : {},fleetGroups : {}, " + - "customProductGroup : {}, skus : {}, productLines : {}, includeOrders : {}, includeReturns : {}, " + + "customProductGroup : {}, skus : {}, productLines : {}, siteProductLines : {}, includeOrders : {}, includeReturns : {}, " + "expirationDate : {}, includeHubSpokeOrder : {}, includeHubSpokeReturn : {}, includeHubSpokeOrderOption : {}, includeHubSpokeReturnOption : {}, " + "includeDaysCount : {}, salesHistoryValue : {},displayQty :{} ,sessionType : {}, applicationPartsOnly : {}, " + - "expirationDate : {}, isGroupCode : {},sessionId :{}", + "expirationDate : {}, isGroupCode : {} , leadTimeSiteStatus : {},sessionId :{}", includeFleets, perCarOrder, includeSystems, includeSpecials, includeObsoletes, includeOverstocks, includeSupersede, includeSoldNotStocked, includeNewNumbers, orderAllSkus, dollarLimit, includeKeylinesOrders, includeKeylinesOrders, includeLessThanStdPkg, useInvestmentCollections, provideStoreDepth, comment, siteGroupName, sitesArray, productGroupsArray, fleetGroupsIds, - customProductGroup, skuArray, productLineIdArray, includeOrders, includeReturns, + customProductGroup, skuArray, productLineIdArray,siteProductLines, includeOrders, includeReturns, expirationDate, includeHubSpokeOrderOption, includeHubSpokeReturnOption, includeDaysCount, salesHistoryValue,displayQty, sessionType, applicationPartsOnly, - expirationDate,isGroupCode,(BigDecimal) keyHolder.getKey ( )); + expirationDate,isGroupCode,leadTime,(BigDecimal) keyHolder.getKey ( )); rollbackSession ( (BigDecimal) keyHolder.getKey ( ) ); LOGGER.error ( "rollbackSession() called for sessionId: {}" , (BigDecimal) keyHolder.getKey ( ) );