WebSVN – SmartDukaan – Diff – /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/StoreController.java

 @Controller
 @Transactional(rollbackFor = Throwable.class)
 public class StoreController {
-	private static final Logger logger = LogManager.getLogger(StoreController.class);
+    private static final Logger logger = LogManager.getLogger(StoreController.class);
-	private static final LocalTime CUTOFF_TIME = LocalTime.of(15, 0);
+    private static final LocalTime CUTOFF_TIME = LocalTime.of(15, 0);
-	private static final List<Integer> TAG_IDS = Arrays.asList(4);
+    private static final List<Integer> TAG_IDS = Arrays.asList(4);
-	@Autowired
+    @Autowired
-	CustomerAddressRepository customerAddressRepository;
+    CustomerAddressRepository customerAddressRepository;
-	@Autowired
+    @Autowired
-	WebOfferRepository webOfferRepository;
+    WebOfferRepository webOfferRepository;
-	@Value("${new.solr.url}")
+    @Value("${new.solr.url}")
-	private String solrUrl;
+    private String solrUrl;
-	@Autowired
+    @Autowired
-	private PartnerIndexService partnerIndexService;
+    private PartnerIndexService partnerIndexService;
-	@Autowired
+    @Autowired
-	InventoryService inventoryService;
+    InventoryService inventoryService;
-	@Autowired
+    @Autowired
-	UserAccountRepository userAccountRepository;
+    UserAccountRepository userAccountRepository;
-	@Value("${python.api.host}")
+    @Value("${python.api.host}")
-	private String host;
+    private String host;
-	@Autowired
+    @Autowired
-	CustomerService customerService;
+    CustomerService customerService;
-	@Value("${python.api.port}")
+    @Value("${python.api.port}")
-	private int port;
+    private int port;
-	@Autowired
+    @Autowired
-	private SaholicInventoryService saholicInventoryService;
+    private SaholicInventoryService saholicInventoryService;
-	@Autowired
+    @Autowired
-	private PincodePartnerRepository pincodePartnerRepository;
+    private PincodePartnerRepository pincodePartnerRepository;
-	@Autowired
+    @Autowired
-	private FofoStoreRepository fofoStoreRepository;
+    private FofoStoreRepository fofoStoreRepository;
-	@Autowired
+    @Autowired
-	private RetailerService retailerService;
+    private RetailerService retailerService;
-	@Autowired
+    @Autowired
-	private PendingOrderRepository pendingOrderRepository;
+    private PendingOrderRepository pendingOrderRepository;
-	@Autowired
+    @Autowired
-	private PendingOrderItemRepository pendingOrderItemRepository;
+    private PendingOrderItemRepository pendingOrderItemRepository;
-	@Autowired
+    @Autowired
-	private PendingOrderService pendingOrderService;
+    private PendingOrderService pendingOrderService;
-	@Autowired
+    @Autowired
-	private CustomerRepository customerRepository;
+    private CustomerRepository customerRepository;
-	@Autowired
+    @Autowired
-	private SolrService commonSolrService;
+    private SolrService commonSolrService;
-	@Autowired
+    @Autowired
-	private OtpProcessor otpProcessor;
+    private OtpProcessor otpProcessor;
-	@Autowired
+    @Autowired
-	private CurrentInventorySnapshotRepository currentInventorySnapshotRepository;
+    private CurrentInventorySnapshotRepository currentInventorySnapshotRepository;
-	@Autowired
+    @Autowired
-	private ResponseSender<?> responseSender;
+    private ResponseSender<?> responseSender;
-	@Autowired
+    @Autowired
-	private TagListingRepository tagListingRepository;
+    private TagListingRepository tagListingRepository;
-	@Autowired
+    @Autowired
-	private ItemRepository itemRepository;
+    private ItemRepository itemRepository;
-	@Autowired
+    @Autowired
-	private SchemeService schemeService;
+    private SchemeService schemeService;
-	@Autowired
+    @Autowired
-	private UserRepository userRepository;
+    private UserRepository userRepository;
-	@Autowired
+    @Autowired
-	private ItemAvailabilityCacheRepository itemAvailabilityCacheRepository;
+    private ItemAvailabilityCacheRepository itemAvailabilityCacheRepository;
-	@Autowired
+    @Autowired
-	private WebListingRepository webListingRepository;
+    private WebListingRepository webListingRepository;
-	@Autowired
+    @Autowired
-	private WebProductListingRepository webProductListingRepository;
+    private WebProductListingRepository webProductListingRepository;
-	@Autowired
+    @Autowired
-	private RoleManager roleManagerService;
+    private RoleManager roleManagerService;
-	@Autowired
+    @Autowired
-	EmailService emailService;
+    EmailService emailService;
-	@Autowired
+    @Autowired
-	CsService csService;
+    CsService csService;
-	@Autowired
+    @Autowired
-	private NotificationService notificationService;
+    private NotificationService notificationService;
-	@Autowired
+    @Autowired
-	private com.spice.profitmandi.dao.repository.dtr.UserRepository dtrUserRepository;
+    private com.spice.profitmandi.dao.repository.dtr.UserRepository dtrUserRepository;
-	@Autowired
+    @Autowired
-	private FofoOrderRepository fofoOrderRepository;
+    private FofoOrderRepository fofoOrderRepository;
-	@Autowired
+    @Autowired
-	private FofoOrderItemRepository fofoOrderItemRepository;
+    private FofoOrderItemRepository fofoOrderItemRepository;
-	@Autowired
+    @Autowired
-	private OrderService orderService;
+    private OrderService orderService;
-	@Autowired
+    @Autowired
-	private ScratchOfferRepository scratchOfferRepository;
+    private ScratchOfferRepository scratchOfferRepository;
-	private static final List<String> offlineOrders = Arrays.asList("EMIOD", "POD");
+    private static final List<String> offlineOrders = Arrays.asList("EMIOD", "POD");
-	List<String> filterableParams = Arrays.asList("brand");
+    List<String> filterableParams = Arrays.asList("brand");
-	@RequestMapping(value = "/store/entity/{id}", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
+    @RequestMapping(value = "/store/entity/{id}", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-	@ApiImplicitParams({
+    @ApiImplicitParams({@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
-			@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header") })
+    @ApiOperation(value = "Get unit deal object")
-	@ApiOperation(value = "Get unit deal object")
+    public ResponseEntity<?> getUnitFocoDeal(HttpServletRequest request, @PathVariable(value = "id") long id) throws ProfitMandiBusinessException {
-	public ResponseEntity<?> getUnitFocoDeal(HttpServletRequest request, @PathVariable(value = "id") long id)
+        List<FofoCatalogResponse> dealResponses = new ArrayList<>();
-			throws ProfitMandiBusinessException {
+        List<Integer> tagIds = Arrays.asList(4);
-		List<FofoCatalogResponse> dealResponses = new ArrayList<>();
+        FofoCatalogResponse fofoCatalogResponse = null;
-		List<Integer> tagIds = Arrays.asList(4);
+        UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
-		FofoCatalogResponse fofoCatalogResponse = null;
+        if (roleManagerService.isPartner(userInfo.getRoleIds())) {
-		UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
+            String categoryId = "(3 OR 6)";
-		if (roleManagerService.isPartner(userInfo.getRoleIds())) {
-			String categoryId = "(3 OR 6)";
+            RestClient rc = new RestClient();
+            Map<String, String> params = new HashMap<>();
-			RestClient rc = new RestClient();
+            List<String> mandatoryQ = new ArrayList<>();
-			Map<String, String> params = new HashMap<>();
+            String catalogString = "catalog" + id;
-			List<String> mandatoryQ = new ArrayList<>();
-			String catalogString = "catalog" + id;
+            mandatoryQ.add(String.format("+(categoryId_i:%s) +(id:%s) +{!parent which=\"id:%s\"} tagId_i:(%s)", categoryId, catalogString, catalogString, StringUtils.join(tagIds, " ")));
-			mandatoryQ.add(String.format("+(categoryId_i:%s) +(id:%s) +{!parent which=\"id:%s\"} tagId_i:(%s)",
+            params.put("q", StringUtils.join(mandatoryQ, " "));
-					categoryId, catalogString, catalogString, StringUtils.join(tagIds, " ")));
+            params.put("fl", "*, [child parentFilter=id:catalog*]");
+            params.put("sort", "rank_i asc, create_s desc");
-			params.put("q", StringUtils.join(mandatoryQ, " "));
+            params.put("wt", "json");
-			params.put("fl", "*, [child parentFilter=id:catalog*]");
+            String response = null;
-			params.put("sort", "rank_i asc, create_s desc");
+            try {
-			params.put("wt", "json");
+                response = rc.get(SchemeType.HTTP, solrUrl, 8984, "solr/demo/select", params);
-			String response = null;
+            } catch (HttpHostConnectException e) {
-			try {
+                throw new ProfitMandiBusinessException("", "", "Could not connect to host");
-				response = rc.get(SchemeType.HTTP, solrUrl, 8984, "solr/demo/select", params);
+            }
-			} catch (HttpHostConnectException e) {
+            JSONObject solrResponseJSONObj = new JSONObject(response).getJSONObject("response");
-				throw new ProfitMandiBusinessException("", "", "Could not connect to host");
+            JSONArray docs = solrResponseJSONObj.getJSONArray("docs");
-			}
+            dealResponses = getCatalogResponse(docs, false, userInfo.getRetailerId());
-			JSONObject solrResponseJSONObj = new JSONObject(response).getJSONObject("response");
+            fofoCatalogResponse = dealResponses.get(0);
-			JSONArray docs = solrResponseJSONObj.getJSONArray("docs");
+            fofoCatalogResponse.setWebOffers(webOfferRepository.selectAllActiveOffers().get(fofoCatalogResponse.getCatalogId()));
-			dealResponses = getCatalogResponse(docs, false, userInfo.getRetailerId());
-			fofoCatalogResponse = dealResponses.get(0);
+        } else {
-			fofoCatalogResponse
+            return responseSender.badRequest(
-					.setWebOffers(webOfferRepository.selectAllActiveOffers().get(fofoCatalogResponse.getCatalogId()));
+                    new ProfitMandiBusinessException("Retailer id", userInfo.getUserId(), "NOT_FOFO_RETAILER"));
+        }
-		} else {
+        return responseSender.ok(dealResponses.get(0));
-			return responseSender.badRequest(
+    }
-					new ProfitMandiBusinessException("Retailer id", userInfo.getUserId(), "NOT_FOFO_RETAILER"));
-		}
+    private Object toDealObject(JsonObject jsonObject) {
-		return responseSender.ok(dealResponses.get(0));
+        if (jsonObject.get("dealObject") != null && jsonObject.get("dealObject").asInt() == 1) {
-	}
+            return new Gson().fromJson(jsonObject.toString(), DealObjectResponse.class);
+        }
-	private Object toDealObject(JsonObject jsonObject) {
+        return new Gson().fromJson(jsonObject.toString(), DealsResponse.class);
-		if (jsonObject.get("dealObject") != null && jsonObject.get("dealObject").asInt() == 1) {
+    }
-			return new Gson().fromJson(jsonObject.toString(), DealObjectResponse.class);
-		}
+    @RequestMapping(value = "/store/brands", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-		return new Gson().fromJson(jsonObject.toString(), DealsResponse.class);
+    @ApiImplicitParams({@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
-	}
+    @ApiOperation(value = "Get brand list and count for category")
+    public ResponseEntity<?> getBrands(HttpServletRequest request, @RequestParam(value = "category_id") String category_id) throws ProfitMandiBusinessException {
-	@RequestMapping(value = "/store/brands", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
+        logger.info("Request " + request.getParameterMap());
-	@ApiImplicitParams({
+        String response = null;
-			@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header") })
+        // TODO: move to properties
-	@ApiOperation(value = "Get brand list and count for category")
+        String uri = ProfitMandiConstants.URL_BRANDS;
-	public ResponseEntity<?> getBrands(HttpServletRequest request,
+        RestClient rc = new RestClient();
-			@RequestParam(value = "category_id") String category_id) throws ProfitMandiBusinessException {
+        Map<String, String> params = new HashMap<>();
-		logger.info("Request " + request.getParameterMap());
+        params.put("category_id", category_id);
-		String response = null;
+        List<DealBrands> dealBrandsResponse = null;
-		// TODO: move to properties
+        try {
-		String uri = ProfitMandiConstants.URL_BRANDS;
+            response = rc.get(SchemeType.HTTP, host, port, uri, params);
-		RestClient rc = new RestClient();
+        } catch (HttpHostConnectException e) {
-		Map<String, String> params = new HashMap<>();
+            throw new ProfitMandiBusinessException("", "", "Could not connect to host");
-		params.put("category_id", category_id);
+        }
-		List<DealBrands> dealBrandsResponse = null;
-		try {
+        dealBrandsResponse = new Gson().fromJson(response, new TypeToken<List<DealBrands>>() {
-			response = rc.get(SchemeType.HTTP, host, port, uri, params);
+        }.getType());
-		} catch (HttpHostConnectException e) {
-			throw new ProfitMandiBusinessException("", "", "Could not connect to host");
+        return responseSender.ok(dealBrandsResponse);
-		}
+    }
-		dealBrandsResponse = new Gson().fromJson(response, new TypeToken<List<DealBrands>>() {
+    @RequestMapping(value = "/store/listing/{listingUrl}", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-		}.getType());
+    public ResponseEntity<?> bestSellers(HttpServletRequest request, @PathVariable String listingUrl) throws Exception {
+        UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
-		return responseSender.ok(dealBrandsResponse);
+        WebListing webListing = webListingRepository.selectByUrl(listingUrl);
-	}
+        webListing.setFofoCatalogResponses(getDealResponses(userInfo, webListing));
+        return responseSender.ok(webListing);
-	@RequestMapping(value = "/store/listing/{listingUrl}", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
+    }
-	public ResponseEntity<?> bestSellers(HttpServletRequest request, @PathVariable String listingUrl) throws Exception {
-		UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
+    @RequestMapping(value = "/store/otp/generateOTP", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-		WebListing webListing = webListingRepository.selectByUrl(listingUrl);
+    public ResponseEntity<?> generateOtp(HttpServletRequest request, @RequestParam String mobile) throws Exception {
-		webListing.setFofoCatalogResponses(getDealResponses(userInfo, webListing));
-		return responseSender.ok(webListing);
+        return responseSender.ok(otpProcessor.generateOtp(mobile, OtpType.REGISTRATION));
-	}
+    }
-	@RequestMapping(value = "/store/otp/generateOTP", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-	public ResponseEntity<?> generateOtp(HttpServletRequest request, @RequestParam String mobile) throws Exception {
+    @RequestMapping(value = "/store/checkmobile/{mobile}", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
+    public ResponseEntity<?> checkRegistrationUsingMobile(HttpServletRequest request, @PathVariable String mobile) throws Exception {
-		return responseSender.ok(otpProcessor.generateOtp(mobile, OtpType.REGISTRATION));
+        try {
+            Customer customer = customerRepository.selectByMobileNumber(mobile);
-	}
+            customer.setPasswordExist(StringUtils.isNotEmpty(customer.getPassword()));
+            return responseSender.ok(new CustomerModel(true, customer));
-	@RequestMapping(value = "/store/checkmobile/{mobile}", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
+        } catch (Exception e) {
-	public ResponseEntity<?> checkRegistrationUsingMobile(HttpServletRequest request, @PathVariable String mobile)
+            return responseSender.ok(new CustomerModel(false, null));
-			throws Exception {
+        }
-		try {
+    }
-			Customer customer = customerRepository.selectByMobileNumber(mobile);
-			customer.setPasswordExist(StringUtils.isNotEmpty(customer.getPassword()));
-			return responseSender.ok(new CustomerModel(true, customer));
+    @RequestMapping(value = "/store/getCustomerById", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-		} catch (Exception e) {
+    public ResponseEntity<?> getCustomerById(HttpServletRequest request, @PathVariable int id) throws Exception {
-			return responseSender.ok(new CustomerModel(false, null));
-		}
+        Customer customer = customerRepository.selectById(id);
-	}
+        customer.setPasswordExist(StringUtils.isNotEmpty(customer.getPassword()));
+        return responseSender.ok(customer);
-	@RequestMapping(value = "/store/signin", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
-	public ResponseEntity<?> signIn(HttpServletRequest request, @RequestBody UserModel userModel) throws Exception {
+    }
-		if (customerService.authenticate(userModel.getMobile(), userModel.getPassword())) {
-			return responseSender.ok(true);
+    @RequestMapping(value = "/store/signin", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
-		} else {
+    public ResponseEntity<?> signIn(HttpServletRequest request, @RequestBody UserModel userModel) throws Exception {
-			return responseSender.ok(false);
+        if (customerService.authenticate(userModel.getMobile(), userModel.getPassword())) {
-		}
+            return responseSender.ok(true);
-	}
+        } else {
+            return responseSender.ok(false);
-	@RequestMapping(value = "/store/resetPassword", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
+        }
-	public ResponseEntity<?> resetPassword(HttpServletRequest request, @RequestBody UserModel userModel)
+    }
-			throws Exception {
-		customerService.changePassword(userModel.getMobile(), userModel.getPassword());
+    @RequestMapping(value = "/store/resetPassword", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
-		return responseSender.ok(true);
+    public ResponseEntity<?> resetPassword(HttpServletRequest request, @RequestBody UserModel userModel) throws Exception {
-	}
+        customerService.changePassword(userModel.getMobile(), userModel.getPassword());
+        return responseSender.ok(true);
-	@RequestMapping(value = "/store/register", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
+    }
-	public ResponseEntity<?> register(HttpServletRequest request, @RequestBody UserModel userModel) throws Exception {
-		Customer customer = new Customer();
+    @RequestMapping(value = "/store/register", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
-		customer.setPassword(userModel.getPassword());
+    public ResponseEntity<?> register(HttpServletRequest request, @RequestBody UserModel userModel) throws Exception {
-		customer.setEmailId(userModel.getEmail());
+        Customer customer = new Customer();
-		customer.setFirstName(userModel.getFirstName());
+        customer.setPassword(userModel.getPassword());
-		customer.setLastName(userModel.getLastName());
+        customer.setEmailId(userModel.getEmail());
-		customer.setMobileNumber(userModel.getMobile());
+        customer.setFirstName(userModel.getFirstName());
-		return responseSender.ok(customerService.addCustomer(customer));
+        customer.setLastName(userModel.getLastName());
-	}
+        customer.setMobileNumber(userModel.getMobile());
+        return responseSender.ok(customerService.addCustomer(customer));
-	@RequestMapping(value = "/store/confirmOrder", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
+    }
-	public ResponseEntity<?> confirmOrder(HttpServletRequest request,
-			@RequestBody CreatePendingOrderRequest createPendingOrderRequest) throws Exception {
+    @RequestMapping(value = "/store/confirmOrder", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
-		UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
+    public ResponseEntity<?> confirmOrder(HttpServletRequest request, @RequestBody CreatePendingOrderRequest createPendingOrderRequest) throws Exception {
-		Integer storeId = userInfo.getRetailerId();
+        UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
-		createPendingOrderRequest.setFofoId(storeId);
+        Integer storeId = userInfo.getRetailerId();
-		List<CreatePendingOrderItem> pendingOrderItems = createPendingOrderRequest.getCreatePendingOrderItem();
+        createPendingOrderRequest.setFofoId(storeId);
-		List<CartItem> cartItems = new ArrayList<>();
+        List<CreatePendingOrderItem> pendingOrderItems = createPendingOrderRequest.getCreatePendingOrderItem();
-		pendingOrderItems.stream().forEach(x -> {
+        List<CartItem> cartItems = new ArrayList<>();
-			CartItem ci = new CartItem();
+        pendingOrderItems.stream().forEach(x -> {
-			ci.setItemId(x.getItemId());
+            CartItem ci = new CartItem();
-			ci.setQuantity(x.getQuantity());
+            ci.setItemId(x.getItemId());
-			ci.setSellingPrice(x.getSellingPrice());
+            ci.setQuantity(x.getQuantity());
-			cartItems.add(ci);
+            ci.setSellingPrice(x.getSellingPrice());
-		});
+            cartItems.add(ci);
-		CartResponse cr = this.validateCart(storeId, cartItems);
+        });
-		if (cr.getCartMessageChanged() > 0 || cr.getTotalAmount() != createPendingOrderRequest.getTotalAmount()) {
+        CartResponse cr = this.validateCart(storeId, cartItems);
-			return responseSender.badRequest("Invalid request");
+        if (cr.getCartMessageChanged() > 0 || cr.getTotalAmount() != createPendingOrderRequest.getTotalAmount()) {
-		}
+            return responseSender.badRequest("Invalid request");
+        }
-		Map<String, String> returnMap = this.pendingOrderService.createPendingOrder(createPendingOrderRequest, cr);
+        Map<String, String> returnMap = this.pendingOrderService.createPendingOrder(createPendingOrderRequest, cr);
-		PendingOrder pendingOrder = pendingOrderRepository.selectById(Integer.parseInt(returnMap.get("poId")));
-		if (offlineOrders.contains(pendingOrder.getPayMethod())) {
+        PendingOrder pendingOrder = pendingOrderRepository.selectById(Integer.parseInt(returnMap.get("poId")));
+        if (offlineOrders.contains(pendingOrder.getPayMethod())) {
-			Map<String, Object> emailModel = pendingOrderService.sendCreateOrderMail(pendingOrder);
+            Map<String, Object> emailModel = pendingOrderService.sendCreateOrderMail(pendingOrder);
-			CustomRetailer customRetailer = retailerService.getFofoRetailer(pendingOrder.getFofoId());
-			Customer customer = customerRepository.selectById(pendingOrder.getCustomerId());
+            CustomRetailer customRetailer = retailerService.getFofoRetailer(pendingOrder.getFofoId());
-			String[] customerEmail = null;
+            Customer customer = customerRepository.selectById(pendingOrder.getCustomerId());
-			if (Utils.validateEmail(customer.getEmailId())) {
+            String[] customerEmail = null;
-				customerEmail = new String[] { customer.getEmailId() };
+            if (Utils.validateEmail(customer.getEmailId())) {
-			}
+                customerEmail = new String[]{customer.getEmailId()};
+            }
-			List<String> bccTo = Arrays.asList("kamini.sharma@smartdukaan.com", "tarun.verma@smartdukaan.com",
-					"niranjan.kala@smartdukaan.com", "sm@smartdukaan.com", "tejbeer.kaur@shop2020.in",
+            List<String> bccTo = Arrays.asList("kamini.sharma@smartdukaan.com", "tarun.verma@smartdukaan.com", "niranjan.kala@smartdukaan.com", "sm@smartdukaan.com", "tejbeer.kaur@shop2020.in", "devkinandan.lal@smartdukaan.com", customRetailer.getEmail());
-					"devkinandan.lal@smartdukaan.com", customRetailer.getEmail());
+            List<String> authUserEmails = csService.getAuthUserByPartnerId(customRetailer.getPartnerId());
-			List<String> authUserEmails = csService.getAuthUserByPartnerId(customRetailer.getPartnerId());
+            if (authUserEmails != null) {
-			if (authUserEmails != null) {
+                authUserEmails = new ArrayList<>();
-				authUserEmails = new ArrayList<>();
+            }
-			}
+            logger.info("authUserEmails {}", authUserEmails);
-			logger.info("authUserEmails {}", authUserEmails);
+            authUserEmails.addAll(bccTo);
-			authUserEmails.addAll(bccTo);
+            StringBuffer itemBuffer = new StringBuffer();
-			StringBuffer itemBuffer = new StringBuffer();
+            List<PendingOrderItem> orderItems = pendingOrderItemRepository.selectByOrderId(pendingOrder.getId());
-			List<PendingOrderItem> orderItems = pendingOrderItemRepository.selectByOrderId(pendingOrder.getId());
+            int totalItems = 0;
-			int totalItems = 0;
+            String itemNoColor = null;
-			String itemNoColor = null;
+            float maxValue = 0;
-			float maxValue = 0;
+            for (PendingOrderItem orderItem : orderItems) {
-			for (PendingOrderItem orderItem : orderItems) {
+                if (maxValue < orderItem.getSellingPrice()) {
-				if (maxValue < orderItem.getSellingPrice()) {
+                    maxValue = orderItem.getSellingPrice();
-					maxValue = orderItem.getSellingPrice();
+                    itemNoColor = itemRepository.selectById(orderItem.getItemId()).getItemDescriptionNoColor();
-					itemNoColor = itemRepository.selectById(orderItem.getItemId()).getItemDescriptionNoColor();
+                }
-				}
+                totalItems += orderItem.getQuantity();
-				totalItems += orderItem.getQuantity();
+            }
-			}
+            if (totalItems > 1) {
-			if (totalItems > 1) {
+                itemBuffer.append(StringUtils.abbreviate(itemNoColor, 22));
-				itemBuffer.append(StringUtils.abbreviate(itemNoColor, 22));
+                itemBuffer.append(" +").append(totalItems - 1).append(" items");
-				itemBuffer.append(" +").append(totalItems - 1).append(" items");
+            } else {
-			} else {
+                itemBuffer.append(StringUtils.abbreviate(itemNoColor, 30));
-				itemBuffer.append(StringUtils.abbreviate(itemNoColor, 30));
+            }
-			}
+            String message = String.format(OtpProcessor.TEMPLATE_ORDER_CREATED, pendingOrder.getId(), itemBuffer.toString(), pendingOrder.getTotalAmount());
-			String message = String.format(OtpProcessor.TEMPLATE_ORDER_CREATED, pendingOrder.getId(),
+            otpProcessor.sendSms(OtpProcessor.TEMPLATE_ORDER_CREATED_ID, message, customer.getMobileNumber());
-					itemBuffer.toString(), pendingOrder.getTotalAmount());
-			otpProcessor.sendSms(OtpProcessor.TEMPLATE_ORDER_CREATED_ID, message, customer.getMobileNumber());
+            emailService.sendMailWithAttachments("Order Created with SmartDukaan", "order-confirm.vm", emailModel, customerEmail, null, bccTo.toArray(new String[0]));
-			emailService.sendMailWithAttachments("Order Created with SmartDukaan", "order-confirm.vm", emailModel,
+            List<String> emailIds = csService.getAuthUserIdByPartnerId(customRetailer.getPartnerId()).stream().map(x -> x.getEmailId()).collect(Collectors.toList());
-					customerEmail, null, bccTo.toArray(new String[0]));
+            emailIds.addAll(
-			List<String> emailIds = csService.getAuthUserIdByPartnerId(customRetailer.getPartnerId()).stream()
+                    csService.getAuthUserIds(ProfitMandiConstants.TICKET_CATEGORY_MARKETING, Arrays.asList(EscalationType.L1, EscalationType.L2, EscalationType.L3, EscalationType.L4)).stream().map(x -> x.getEmailId()).collect(Collectors.toList()));
-					.map(x -> x.getEmailId()).collect(Collectors.toList());
+            emailIds.add("tarun.verma@smartdukaan.com");
+            emailIds.add("devkinandan.lal@smartdukaan.com");
-			emailIds.addAll(
+            emailIds.add("tejbeer.kaur@shop2020.in");
-					csService
+            List<User> user = dtrUserRepository.selectAllByEmailIds(emailIds);
-							.getAuthUserIds(ProfitMandiConstants.TICKET_CATEGORY_MARKETING,
+            List<Integer> userIds = user.stream().map(x -> x.getId()).collect(Collectors.toList());
-									Arrays.asList(EscalationType.L1, EscalationType.L2, EscalationType.L3,
-											EscalationType.L4))
+            logger.info("userIds" + userIds);
-							.stream().map(x -> x.getEmailId()).collect(Collectors.toList()));
+            SendNotificationModel sendNotificationModel = new SendNotificationModel();
-			emailIds.add("tarun.verma@smartdukaan.com");
+            sendNotificationModel.setCampaignName("Online Order Alert");
-			emailIds.add("devkinandan.lal@smartdukaan.com");
+            sendNotificationModel.setTitle("Online Order Update");
-			emailIds.add("tejbeer.kaur@shop2020.in");
+            sendNotificationModel.setMessage(String.format(
-			List<User> user = dtrUserRepository.selectAllByEmailIds(emailIds);
+                    "You have new Online Order. Please check your Dashboard. In case of an activation scheme pls ensure the handset is activated, payout will be processed as per brand's activation report."));
-			List<Integer> userIds = user.stream().map(x -> x.getId()).collect(Collectors.toList());
+            sendNotificationModel.setType("url");
+            sendNotificationModel.setUrl("https://app.smartdukaan.com/pages/home/notifications");
-			logger.info("userIds" + userIds);
+            sendNotificationModel.setExpiresat(LocalDateTime.now().plusDays(1));
-			SendNotificationModel sendNotificationModel = new SendNotificationModel();
+            sendNotificationModel.setMessageType(MessageType.notification);
-			sendNotificationModel.setCampaignName("Online Order Alert");
+            int userId = userAccountRepository.selectUserIdByRetailerId(pendingOrder.getFofoId());
-			sendNotificationModel.setTitle("Online Order Update");
+            sendNotificationModel.setUserIds(Arrays.asList(userId));
-			sendNotificationModel.setMessage(String.format(
+            notificationService.sendNotification(sendNotificationModel);
-					"You have new Online Order. Please check your Dashboard. In case of an activation scheme pls ensure the handset is activated, payout will be processed as per brand's activation report."));
-			sendNotificationModel.setType("url");
+            SendNotificationModel snm = new SendNotificationModel();
-			sendNotificationModel.setUrl("https://app.smartdukaan.com/pages/home/notifications");
+            snm.setCampaignName("Online Order Alert");
-			sendNotificationModel.setExpiresat(LocalDateTime.now().plusDays(1));
+            snm.setTitle("Online Order Update");
-			sendNotificationModel.setMessageType(MessageType.notification);
+            snm.setMessage(String.format("Your Partner " + customRetailer.getBusinessName() + " have new Online Order. Please inform your partner. In case of an activation scheme pls ensure the handset is activated, payout will be processed as per brand's activation report."));
-			int userId = userAccountRepository.selectUserIdByRetailerId(pendingOrder.getFofoId());
+            snm.setType("url");
-			sendNotificationModel.setUserIds(Arrays.asList(userId));
+            snm.setUrl("https://app.smartdukaan.com/pages/home/notifications");
-			notificationService.sendNotification(sendNotificationModel);
+            snm.setExpiresat(LocalDateTime.now().plusDays(1));
+            snm.setMessageType(MessageType.notification);
-			SendNotificationModel snm = new SendNotificationModel();
+            snm.setUserIds(userIds);
-			snm.setCampaignName("Online Order Alert");
+            notificationService.sendNotification(snm);
-			snm.setTitle("Online Order Update");
-			snm.setMessage(String.format("Your Partner " + customRetailer.getBusinessName()
+        }
-					+ " have new Online Order. Please inform your partner. In case of an activation scheme pls ensure the handset is activated, payout will be processed as per brand's activation report."));
+        return responseSender.ok(returnMap);
-			snm.setType("url");
-			snm.setUrl("https://app.smartdukaan.com/pages/home/notifications");
+    }
-			snm.setExpiresat(LocalDateTime.now().plusDays(1));
-			snm.setMessageType(MessageType.notification);
+    @RequestMapping(value = "/store/address", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-			snm.setUserIds(userIds);
+    @ApiImplicitParams({@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
-			notificationService.sendNotification(snm);
+    @ApiOperation(value = "Get brand list and count for category")
+    public ResponseEntity<?> getAddress(HttpServletRequest request) throws Exception {
-		}
+        UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
-		return responseSender.ok(returnMap);
+        Integer storeId = userInfo.getRetailerId();
+        CustomRetailer customRetailer = retailerService.getFofoRetailer(storeId);
-	}
+        return responseSender.ok(customRetailer.getAddress());
-	@RequestMapping(value = "/store/address", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-	@ApiImplicitParams({
+    }
-			@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header") })
-	@ApiOperation(value = "Get brand list and count for category")
+    @RequestMapping(value = "/store/address/{pincode}", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-	public ResponseEntity<?> getAddress(HttpServletRequest request) throws Exception {
+    @ApiImplicitParams({@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
-		UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
+    @ApiOperation(value = "Get brand list and count for category")
-		Integer storeId = userInfo.getRetailerId();
+    public ResponseEntity<?> getStoresByPincode(HttpServletRequest request, @PathVariable String pincode) throws Exception {
-		CustomRetailer customRetailer = retailerService.getFofoRetailer(storeId);
+        List<PincodePartner> pincodePartners = pincodePartnerRepository.selectPartnersByPincode(pincode);
+        int fofoId = ProfitMandiConstants.DEFAULT_STORE;
-		return responseSender.ok(customRetailer.getAddress());
+        if (pincodePartners.size() > 0) {
+            List<Integer> fofoIds = pincodePartners.stream().map(x -> x.getFofoId()).collect(Collectors.toList());
-	}
+            List<FofoStore> fofoStores = fofoStoreRepository.selectActivePartnersByRetailerIds(fofoIds);
+            if (fofoStores.size() > 0) {
-	@RequestMapping(value = "/store/address/{pincode}", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
+                fofoId = fofoStores.get(0).getId();
-	@ApiImplicitParams({
+            }
-			@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header") })
-	@ApiOperation(value = "Get brand list and count for category")
+        }
-	public ResponseEntity<?> getStoresByPincode(HttpServletRequest request, @PathVariable String pincode)
+        return responseSender.ok(fofoStoreRepository.selectByRetailerId(fofoId).getCode());
-			throws Exception {
+    }
-		List<PincodePartner> pincodePartners = pincodePartnerRepository.selectPartnersByPincode(pincode);
-		int fofoId = ProfitMandiConstants.DEFAULT_STORE;
+    @RequestMapping(value = "/store/addresses", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-		if (pincodePartners.size() > 0) {
+    @ApiImplicitParams({@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
-			List<Integer> fofoIds = pincodePartners.stream().map(x -> x.getFofoId()).collect(Collectors.toList());
+    @ApiOperation(value = "Get brand list and count for category")
-			List<FofoStore> fofoStores = fofoStoreRepository.selectActivePartnersByRetailerIds(fofoIds);
+    public ResponseEntity<?> getStoresByPincod(HttpServletRequest request, @RequestParam String pincode, @RequestParam(name = "fofoCode", defaultValue = "", required = false) String fofoCode) throws Exception {
-			if (fofoStores.size() > 0) {
-				fofoId = fofoStores.get(0).getId();
+        List<CustomRetailer> customerRetailers = new ArrayList<>();
-			}
+        logger.info("fofoCode" + fofoCode);
-		}
-		return responseSender.ok(fofoStoreRepository.selectByRetailerId(fofoId).getCode());
+        if (fofoCode != null) {
-	}
+            FofoStore fs = fofoStoreRepository.selectByStoreCode(fofoCode.toUpperCase());
+            PincodePartner pp = pincodePartnerRepository.selectPartnerByPincode(pincode, fs.getId());
-	@RequestMapping(value = "/store/addresses", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
+            if (pp != null) {
-	@ApiImplicitParams({
+                return responseSender.ok(customerRetailers.add(retailerService.getFofoRetailer(pp.getFofoId())));
-			@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header") })
+            } else {
-	@ApiOperation(value = "Get brand list and count for category")
-	public ResponseEntity<?> getStoresByPincod(HttpServletRequest request, @RequestParam String pincode,
+                List<PincodePartner> pincodePartners = pincodePartnerRepository.selectPartnersByPincode(pincode);
-			@RequestParam(name = "fofoCode", defaultValue = "", required = false) String fofoCode) throws Exception {
+                if (pincodePartners.size() > 0) {
-		List<CustomRetailer> customerRetailers = new ArrayList<>();
+                    List<Integer> fofoIds = pincodePartners.stream().map(x -> x.getFofoId()).collect(Collectors.toList());
+                    List<Integer> activefofoIds = fofoStoreRepository.selectByRetailerIds(fofoIds).stream().filter(x -> x.isActive()).map(x -> x.getId()).collect(Collectors.toList());
-		logger.info("fofoCode" + fofoCode);
+                    Map<Integer, CustomRetailer> customRetailerMap = retailerService.getAllFofoRetailers();
-		if (fofoCode != null) {
-			FofoStore fs = fofoStoreRepository.selectByStoreCode(fofoCode.toUpperCase());
+                    Map<Integer, CustomRetailer> customerRetailerMap = activefofoIds.stream().map(x -> customRetailerMap.get(x)).filter(x -> x != null).collect(Collectors.toList()).stream().collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
-			PincodePartner pp = pincodePartnerRepository.selectPartnerByPincode(pincode, fs.getId());
-			if (pp != null) {
+                    customerRetailers.addAll(customerRetailerMap.values());
-				return responseSender.ok(customerRetailers.add(retailerService.getFofoRetailer(pp.getFofoId())));
-			} else {
+                }
+                return responseSender.ok(customerRetailers);
-				List<PincodePartner> pincodePartners = pincodePartnerRepository.selectPartnersByPincode(pincode);
-				if (pincodePartners.size() > 0) {
+            }
+        } else {
-					List<Integer> fofoIds = pincodePartners.stream().map(x -> x.getFofoId())
-							.collect(Collectors.toList());
+            List<PincodePartner> pincodePartners = pincodePartnerRepository.selectPartnersByPincode(pincode);
-					List<Integer> activefofoIds = fofoStoreRepository.selectByRetailerIds(fofoIds).stream()
+            if (pincodePartners.size() > 0) {
-							.filter(x -> x.isActive()).map(x -> x.getId()).collect(Collectors.toList());
+                List<Integer> fofoIds = pincodePartners.stream().map(x -> x.getFofoId()).collect(Collectors.toList());
+                List<Integer> activefofoIds = fofoStoreRepository.selectByRetailerIds(fofoIds).stream().filter(x -> x.isActive()).map(x -> x.getId()).collect(Collectors.toList());
-					Map<Integer, CustomRetailer> customRetailerMap = retailerService.getAllFofoRetailers();
+                Map<Integer, CustomRetailer> customRetailerMap = retailerService.getAllFofoRetailers();
-					Map<Integer, CustomRetailer> customerRetailerMap = activefofoIds.stream()
-							.map(x -> customRetailerMap.get(x)).filter(x -> x != null).collect(Collectors.toList())
+                Map<Integer, CustomRetailer> customerRetailerMap = activefofoIds.stream().map(x -> customRetailerMap.get(x)).filter(x -> x != null).collect(Collectors.toList()).stream().collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
-							.stream().collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
+                customerRetailers.addAll(customerRetailerMap.values());
-					customerRetailers.addAll(customerRetailerMap.values());
+            }
-				}
+            return responseSender.ok(customerRetailers);
-				return responseSender.ok(customerRetailers);
+        }
-			}
-		} else {
+    }
-			List<PincodePartner> pincodePartners = pincodePartnerRepository.selectPartnersByPincode(pincode);
+    @RequestMapping(value = "/store/address/detail/{pincode}", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-			if (pincodePartners.size() > 0) {
+    @ApiImplicitParams({@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
-				List<Integer> fofoIds = pincodePartners.stream().map(x -> x.getFofoId()).collect(Collectors.toList());
+    @ApiOperation(value = "Get brand list and count for category")
-				List<Integer> activefofoIds = fofoStoreRepository.selectByRetailerIds(fofoIds).stream()
+    public ResponseEntity<?> getStoresDetailsByPincode(HttpServletRequest request, @PathVariable String pincode) throws Exception {
-						.filter(x -> x.isActive()).map(x -> x.getId()).collect(Collectors.toList());
+        List<CustomRetailer> customerRetailers = new ArrayList<>();
+        List<PincodePartner> pincodePartners = pincodePartnerRepository.selectPartnersByPincode(pincode);
-				Map<Integer, CustomRetailer> customRetailerMap = retailerService.getAllFofoRetailers();
+        if (!pincodePartners.isEmpty()) {
-				Map<Integer, CustomRetailer> customerRetailerMap = activefofoIds.stream()
+            List<Integer> fofoIds = pincodePartners.stream().map(x -> x.getFofoId()).collect(Collectors.toList());
-						.map(x -> customRetailerMap.get(x)).filter(x -> x != null).collect(Collectors.toList()).stream()
+            List<Integer> activefofoIds = fofoStoreRepository.selectByRetailerIds(fofoIds).stream().filter(x -> x.isActive()).map(x -> x.getId()).collect(Collectors.toList());
-						.collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
+            Map<Integer, CustomRetailer> customRetailerMap = retailerService.getAllFofoRetailers();
-				customerRetailers.addAll(customerRetailerMap.values());
-			}
+            Map<Integer, CustomRetailer> customerRetailerMap = activefofoIds.stream().map(x -> customRetailerMap.get(x)).filter(x -> x != null).collect(Collectors.toList()).stream().collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
-			return responseSender.ok(customerRetailers);
+            customerRetailers.addAll(customerRetailerMap.values());
+        }
-		}
+        logger.info("customerRetailers" + customerRetailers);
-	}
+        return responseSender.ok(customerRetailers);
+    }
-	@RequestMapping(value = "/store/address/detail/{pincode}", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-	@ApiImplicitParams({
+    @RequestMapping(value = "/store/order", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-			@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header") })
+    public ResponseEntity<?> getOrderDetail(HttpServletRequest request, @RequestParam(value = "id") int id, @RequestParam(name = "offset") int offset, @RequestParam(name = "limit") int limit) throws Exception {
-	@ApiOperation(value = "Get brand list and count for category")
+        List<CustomerOrderDetail> customerOrderDetails = new ArrayList<>();
-	public ResponseEntity<?> getStoresDetailsByPincode(HttpServletRequest request, @PathVariable String pincode)
+        List<Integer> catalogIds = new ArrayList<>();
-			throws Exception {
+        List<PendingOrder> pendingOrders = pendingOrderRepository.selectByCustomerId(id, offset, limit);
-		List<CustomRetailer> customerRetailers = new ArrayList<>();
-		List<PincodePartner> pincodePartners = pincodePartnerRepository.selectPartnersByPincode(pincode);
+        if (!pendingOrders.isEmpty()) {
+            for (PendingOrder po : pendingOrders) {
-		if (!pincodePartners.isEmpty()) {
+                List<PendingOrderItem> pois = pendingOrderItemRepository.selectByOrderId(po.getId());
-			List<Integer> fofoIds = pincodePartners.stream().map(x -> x.getFofoId()).collect(Collectors.toList());
+                for (PendingOrderItem pendingOrderItem : pois) {
-			List<Integer> activefofoIds = fofoStoreRepository.selectByRetailerIds(fofoIds).stream()
+                    Item item = itemRepository.selectById(pendingOrderItem.getItemId());
-					.filter(x -> x.isActive()).map(x -> x.getId()).collect(Collectors.toList());
+                    pendingOrderItem.setItemName(item.getItemDescription());
+                    catalogIds.add(item.getCatalogItemId());
-			Map<Integer, CustomRetailer> customRetailerMap = retailerService.getAllFofoRetailers();
+                }
-			Map<Integer, CustomRetailer> customerRetailerMap = activefofoIds.stream().map(x -> customRetailerMap.get(x))
+                Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);
-					.filter(x -> x != null).collect(Collectors.toList()).stream()
-					.collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
+                for (PendingOrderItem poi : pois) {
-			customerRetailers.addAll(customerRetailerMap.values());
+                    CustomerOrderDetail customerOrderDetail = new CustomerOrderDetail();
-		}
+                    Item item = itemRepository.selectById(poi.getItemId());
-		logger.info("customerRetailers" + customerRetailers);
+                    JSONObject jsonObj = contentMap.get(item.getCatalogItemId());
-		return responseSender.ok(customerRetailers);
+                    customerOrderDetail.setImageUrl(jsonObj.getString("imageUrl_s"));
-	}
+                    customerOrderDetail.setBrand(item.getBrand());
+                    customerOrderDetail.setColor(item.getColor());
-	@RequestMapping(value = "/store/order", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
+                    customerOrderDetail.setPendingOrderItemId(poi.getId());
-	public ResponseEntity<?> getOrderDetail(HttpServletRequest request, @RequestParam(value = "id") int id,
+                    customerOrderDetail.setId(poi.getOrderId());
-			@RequestParam(name = "offset") int offset, @RequestParam(name = "limit") int limit) throws Exception {
+                    customerOrderDetail.setItemId(poi.getItemId());
-		List<CustomerOrderDetail> customerOrderDetails = new ArrayList<>();
+                    customerOrderDetail.setModelName(item.getModelName());
-		List<Integer> catalogIds = new ArrayList<>();
+                    customerOrderDetail.setModelNumber(item.getModelNumber());
-		List<PendingOrder> pendingOrders = pendingOrderRepository.selectByCustomerId(id, offset, limit);
+                    customerOrderDetail.setQuantity(poi.getQuantity());
+                    customerOrderDetail.setBilledTimestamp(poi.getBilledTimestamp());
-		if (!pendingOrders.isEmpty()) {
+                    customerOrderDetail.setStatus(poi.getStatus());
-			for (PendingOrder po : pendingOrders) {
+                    customerOrderDetail.setTotalPrice(poi.getSellingPrice());
-				List<PendingOrderItem> pois = pendingOrderItemRepository.selectByOrderId(po.getId());
+                    customerOrderDetail.setPayMethod(po.getPayMethod());
-				for (PendingOrderItem pendingOrderItem : pois) {
+                    customerOrderDetail.setCreatedTimeStamp(po.getCreateTimestamp());
-					Item item = itemRepository.selectById(pendingOrderItem.getItemId());
+                    customerOrderDetails.add(customerOrderDetail);
-					pendingOrderItem.setItemName(item.getItemDescription());
+                }
-					catalogIds.add(item.getCatalogItemId());
+            }
-				}
+        }
-				Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);
+        return responseSender.ok(customerOrderDetails);
+    }
-				for (PendingOrderItem poi : pois) {
+    @RequestMapping(value = "/store/invoiceOrder", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-					CustomerOrderDetail customerOrderDetail = new CustomerOrderDetail();
+    public ResponseEntity<?> getOrderInvoiceDetail(HttpServletRequest request, @RequestParam(value = "id") int id, @RequestParam(name = "offset") int offset, @RequestParam(name = "limit") int limit) throws Exception {
+        List<CustomerOrderDetail> customerOrderDetails = new ArrayList<>();
-					Item item = itemRepository.selectById(poi.getItemId());
+        List<Integer> catalogIds = new ArrayList<>();
-					JSONObject jsonObj = contentMap.get(item.getCatalogItemId());
+        List<FofoOrder> fofoOrders = fofoOrderRepository.selectOrderByCustomerId(id, offset, limit);
-					customerOrderDetail.setImageUrl(jsonObj.getString("imageUrl_s"));
-					customerOrderDetail.setBrand(item.getBrand());
+        if (!fofoOrders.isEmpty()) {
-					customerOrderDetail.setColor(item.getColor());
+            for (FofoOrder fo : fofoOrders) {
-					customerOrderDetail.setPendingOrderItemId(poi.getId());
+                List<FofoOrderItem> fofoOrderItems = fofoOrderItemRepository.selectByOrderId(fo.getId());
-					customerOrderDetail.setId(poi.getOrderId());
+                for (FofoOrderItem fofoOrderItem : fofoOrderItems) {
-					customerOrderDetail.setItemId(poi.getItemId());
+                    Item item = itemRepository.selectById(fofoOrderItem.getItemId());
-					customerOrderDetail.setModelName(item.getModelName());
+                    fofoOrderItem.setItemName(item.getItemDescription());
-					customerOrderDetail.setModelNumber(item.getModelNumber());
+                    catalogIds.add(item.getCatalogItemId());
-					customerOrderDetail.setQuantity(poi.getQuantity());
+                }
-					customerOrderDetail.setBilledTimestamp(poi.getBilledTimestamp());
-					customerOrderDetail.setStatus(poi.getStatus());
+                Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);
-					customerOrderDetail.setTotalPrice(poi.getSellingPrice());
+                for (FofoOrderItem foi : fofoOrderItems) {
-					customerOrderDetail.setPayMethod(po.getPayMethod());
-					customerOrderDetail.setCreatedTimeStamp(po.getCreateTimestamp());
+                    CustomerOrderDetail customerOrderDetail = new CustomerOrderDetail();
-					customerOrderDetails.add(customerOrderDetail);
-				}
+                    Item item = itemRepository.selectById(foi.getItemId());
-			}
+                    JSONObject jsonObj = contentMap.get(item.getCatalogItemId());
-		}
+                    customerOrderDetail.setImageUrl(jsonObj.getString("imageUrl_s"));
+                    customerOrderDetail.setBrand(item.getBrand());
-		return responseSender.ok(customerOrderDetails);
+                    customerOrderDetail.setColor(item.getColor());
-	}
+                    customerOrderDetail.setFofoOrderItemId(foi.getId());
+                    customerOrderDetail.setFofoOrderId(foi.getOrderId());
-	@RequestMapping(value = "/store/invoiceOrder", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
+                    customerOrderDetail.setItemId(foi.getItemId());
-	public ResponseEntity<?> getOrderInvoiceDetail(HttpServletRequest request, @RequestParam(value = "id") int id,
+                    customerOrderDetail.setModelName(item.getModelName());
-			@RequestParam(name = "offset") int offset, @RequestParam(name = "limit") int limit) throws Exception {
+                    customerOrderDetail.setModelNumber(item.getModelNumber());
-		List<CustomerOrderDetail> customerOrderDetails = new ArrayList<>();
+                    customerOrderDetail.setQuantity(foi.getQuantity());
-		List<Integer> catalogIds = new ArrayList<>();
+                    customerOrderDetail.setTotalPrice(foi.getSellingPrice());
-		List<FofoOrder> fofoOrders = fofoOrderRepository.selectOrderByCustomerId(id, offset, limit);
+                    customerOrderDetail.setCreatedTimeStamp(foi.getCreateTimestamp());
+                    customerOrderDetail.setInvoiceNumber(fo.getInvoiceNumber());
-		if (!fofoOrders.isEmpty()) {
+                    customerOrderDetail.setCancelledTimestamp(fo.getCancelledTimestamp());
-			for (FofoOrder fo : fofoOrders) {
+                    customerOrderDetails.add(customerOrderDetail);
-				List<FofoOrderItem> fofoOrderItems = fofoOrderItemRepository.selectByOrderId(fo.getId());
+                }
-				for (FofoOrderItem fofoOrderItem : fofoOrderItems) {
+            }
-					Item item = itemRepository.selectById(fofoOrderItem.getItemId());
-					fofoOrderItem.setItemName(item.getItemDescription());
+        }
-					catalogIds.add(item.getCatalogItemId());
+        return responseSender.ok(customerOrderDetails);
-				}
+    }
-				Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);
+    @RequestMapping(value = "/store/generateInvoice", method = RequestMethod.GET)
-				for (FofoOrderItem foi : fofoOrderItems) {
+    public ResponseEntity<?> generateInvoice(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.ORDER_ID) int orderId) throws ProfitMandiBusinessException {
+        InvoicePdfModel pdfModel = null;
-					CustomerOrderDetail customerOrderDetail = new CustomerOrderDetail();
+        FofoOrder fo = fofoOrderRepository.selectByOrderId(orderId);
+        pdfModel = orderService.getInvoicePdfModel(fo.getFofoId(), orderId);
-					Item item = itemRepository.selectById(foi.getItemId());
+        ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
-					JSONObject jsonObj = contentMap.get(item.getCatalogItemId());
+        PdfUtils.generateAndWrite(Arrays.asList(pdfModel), byteArrayOutputStream);
-					customerOrderDetail.setImageUrl(jsonObj.getString("imageUrl_s"));
+        try {
-					customerOrderDetail.setBrand(item.getBrand());
+            byteArrayOutputStream.close();
-					customerOrderDetail.setColor(item.getColor());
+        } catch (IOException e) {
-					customerOrderDetail.setFofoOrderItemId(foi.getId());
+            // TODO Auto-generated catch block
-					customerOrderDetail.setFofoOrderId(foi.getOrderId());
+            e.printStackTrace();
-					customerOrderDetail.setItemId(foi.getItemId());
+        }
-					customerOrderDetail.setModelName(item.getModelName());
+        final HttpHeaders headers = new HttpHeaders();
-					customerOrderDetail.setModelNumber(item.getModelNumber());
+        headers.setContentType(MediaType.APPLICATION_PDF);
-					customerOrderDetail.setQuantity(foi.getQuantity());
+        // headers.setCacheControl("must-revalidate, post-check=0, pre-check=0");
-					customerOrderDetail.setTotalPrice(foi.getSellingPrice());
-					customerOrderDetail.setCreatedTimeStamp(foi.getCreateTimestamp());
+        headers.setContentType(MediaType.parseMediaType("application/pdf"));
-					customerOrderDetail.setInvoiceNumber(fo.getInvoiceNumber());
+        headers.set("Content-disposition", "inline; filename=invoice-" + pdfModel.getInvoiceNumber() + ".pdf");
-					customerOrderDetail.setCancelledTimestamp(fo.getCancelledTimestamp());
+        headers.add("Cache-Control", "no-cache, no-store, must-revalidate");
-					customerOrderDetails.add(customerOrderDetail);
+        headers.add("Pragma", "no-cache");
-				}
+        headers.add("Expires", "0");
-			}
+        headers.setContentLength(byteArrayOutputStream.toByteArray().length);
-		}
+        final InputStream inputStream = new ByteArrayInputStream(byteArrayOutputStream.toByteArray());
-		return responseSender.ok(customerOrderDetails);
+        final InputStreamResource inputStreamResource = new InputStreamResource(inputStream);
-	}
+        return new ResponseEntity<>(inputStreamResource, headers, HttpStatus.OK);
+        // return responseSender.ok(new
-	@RequestMapping(value = "/store/generateInvoice", method = RequestMethod.GET)
+        // ResponseEntity<byte[]>(byteArrayOutputStream.toByteArray(),
-	public ResponseEntity<?> generateInvoice(HttpServletRequest request,
+        // headers,HttpStatus.OK));
-			@RequestParam(name = ProfitMandiConstants.ORDER_ID) int orderId) throws ProfitMandiBusinessException {
+        /*
-		InvoicePdfModel pdfModel = null;
+         * ResponseEntity<byte[]> response = new
-		FofoOrder fo = fofoOrderRepository.selectByOrderId(orderId);
+         * ResponseEntity<byte[]>(byteArrayOutputStream.toByteArray(), headers,
-		pdfModel = orderService.getInvoicePdfModel(fo.getFofoId(), orderId);
+         * HttpStatus.OK); return response;
-		ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
+         */
-		PdfUtils.generateAndWrite(Arrays.asList(pdfModel), byteArrayOutputStream);
-		try {
+    }
-			byteArrayOutputStream.close();
-		} catch (IOException e) {
+    @RequestMapping(value = "/store/listing", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-			// TODO Auto-generated catch block
+    public ResponseEntity<?> getStoresListing(HttpServletRequest request) throws Exception {
-			e.printStackTrace();
+        List<WebListing> webListings = webListingRepository.selectAllWebListingByType(Optional.of(true), WebListingSource.store);
-		}
+        UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
-		final HttpHeaders headers = new HttpHeaders();
+        for (WebListing webListing : webListings) {
-		headers.setContentType(MediaType.APPLICATION_PDF);
+            webListing.setFofoCatalogResponses(getDealResponses(userInfo, webListing));
-		// headers.setCacheControl("must-revalidate, post-check=0, pre-check=0");
+        }
+        return responseSender.ok(webListings);
-		headers.setContentType(MediaType.parseMediaType("application/pdf"));
+    }
-		headers.set("Content-disposition", "inline; filename=invoice-" + pdfModel.getInvoiceNumber() + ".pdf");
-		headers.add("Cache-Control", "no-cache, no-store, must-revalidate");
+    private List<FofoCatalogResponse> getDealResponses(UserInfo userInfo, WebListing webListing) throws ProfitMandiBusinessException {
-		headers.add("Pragma", "no-cache");
+        List<Integer> webProducts = webProductListingRepository.selectAllByWebListingId(webListing.getId()).stream().filter(x -> x.getRank() > 0).map(x -> x.getEntityId()).collect(Collectors.toList());
-		headers.add("Expires", "0");
+        if (webProducts.size() == 0) {
+            return new ArrayList<>();
-		headers.setContentLength(byteArrayOutputStream.toByteArray().length);
+        }
-		final InputStream inputStream = new ByteArrayInputStream(byteArrayOutputStream.toByteArray());
+        RestClient rc = new RestClient();
-		final InputStreamResource inputStreamResource = new InputStreamResource(inputStream);
+        Map<String, String> params = new HashMap<>();
-		return new ResponseEntity<>(inputStreamResource, headers, HttpStatus.OK);
+        List<String> mandatoryQ = new ArrayList<>();
-		// return responseSender.ok(new
+        mandatoryQ.add(String.format(
-		// ResponseEntity<byte[]>(byteArrayOutputStream.toByteArray(),
+                "+{!parent which=\"catalogId_i:" + StringUtils.join(webProducts, " ") + "\"} tagId_i:(%s)", StringUtils.join(TAG_IDS, " ")));
-		// headers,HttpStatus.OK));
+        params.put("q", StringUtils.join(mandatoryQ, " "));
-		/*
+        params.put("fl", "*, [child parentFilter=id:catalog*]");
-		 * ResponseEntity<byte[]> response = new
+        // params.put("sort", "create_s desc");
-		 * ResponseEntity<byte[]>(byteArrayOutputStream.toByteArray(), headers,
+        params.put("start", String.valueOf(0));
-		 * HttpStatus.OK); return response;
+        params.put("rows", String.valueOf(100));
-		 */
+        params.put("wt", "json");
+        String response = null;
-	}
+        try {
+            response = rc.get(SchemeType.HTTP, "50.116.10.120", 8984, "solr/demo/select", params);
-	@RequestMapping(value = "/store/listing", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
+        } catch (HttpHostConnectException e) {
-	public ResponseEntity<?> getStoresListing(HttpServletRequest request) throws Exception {
+            throw new ProfitMandiBusinessException("", "", "Could not connect to host");
-		List<WebListing> webListings = webListingRepository.selectAllWebListingByType(Optional.of(true),
+        }
-				WebListingSource.store);
+        JSONObject solrResponseJSONObj = new JSONObject(response).getJSONObject("response");
-		UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
+        JSONArray docs = solrResponseJSONObj.getJSONArray("docs");
-		for (WebListing webListing : webListings) {
+        List<FofoCatalogResponse> dealResponse = getCatalogResponse(docs, false, userInfo.getRetailerId());
-			webListing.setFofoCatalogResponses(getDealResponses(userInfo, webListing));
+        return dealResponse;
-		}
+    }
-		return responseSender.ok(webListings);
-	}
+    @RequestMapping(value = "/store/cart", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
+    @ApiImplicitParams({@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
-	private List<FofoCatalogResponse> getDealResponses(UserInfo userInfo, WebListing webListing)
+    @ApiOperation(value = "Get brand list and count for category")
-			throws ProfitMandiBusinessException {
+    public ResponseEntity<?> cart(HttpServletRequest request, @RequestBody AddCartRequest cartRequest) throws Exception {
-		List<Integer> webProducts = webProductListingRepository.selectAllByWebListingId(webListing.getId()).stream()
+        UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
-				.filter(x -> x.getRank() > 0).map(x -> x.getEntityId()).collect(Collectors.toList());
+        Integer storeId = userInfo.getRetailerId();
-		if (webProducts.size() == 0) {
+        ValidateCartResponse vc = new ValidateCartResponse(this.validateCart(storeId, cartRequest.getCartItems()), "Success", "Items added to cart successfully");
-			return new ArrayList<>();
+        return responseSender.ok(vc);
-		}
+    }
-		RestClient rc = new RestClient();
-		Map<String, String> params = new HashMap<>();
+    // Validate Cart for B2C Customers
-		List<String> mandatoryQ = new ArrayList<>();
+    private CartResponse validateCart(int storeId, List<CartItem> cartItems) throws Exception {
-		mandatoryQ.add(String.format(
+        cartItems = cartItems.stream().filter(x -> x.getQuantity() > 0).collect(Collectors.toList());
-				"+{!parent which=\"catalogId_i:" + StringUtils.join(webProducts, " ") + "\"} tagId_i:(%s)",
+        List<Integer> itemIds = cartItems.stream().map(x -> x.getItemId()).collect(Collectors.toList());
-				StringUtils.join(TAG_IDS, " ")));
+        Map<Integer, AvailabilityModel> inventoryItemAvailabilityMap = inventoryService.getStoreAndOurStock(storeId, itemIds);
-		params.put("q", StringUtils.join(mandatoryQ, " "));
+        CartResponse cartResponse = new CartResponse();
-		params.put("fl", "*, [child parentFilter=id:catalog*]");
+        List<CartItemResponseModel> cartItemResponseModels = new ArrayList<>();
-		// params.put("sort", "create_s desc");
+        cartResponse.setCartItems(cartItemResponseModels);
-		params.put("start", String.valueOf(0));
+        Set<Integer> itemsIdsSet = new HashSet<>(itemIds);
-		params.put("rows", String.valueOf(100));
+        logger.info("Store Id {}, Item Ids {}", storeId, itemsIdsSet);
-		params.put("wt", "json");
-		String response = null;
+        Map<Integer, Item> itemsMap = itemRepository.selectByIds(itemsIdsSet).stream().collect(Collectors.toMap(x -> x.getId(), x -> x));
-		try {
-			response = rc.get(SchemeType.HTTP, "50.116.10.120", 8984, "solr/demo/select", params);
+        Map<Integer, TagListing> tagListingMap = tagListingRepository.selectByItemIdsAndTagIds(new HashSet<>(itemIds), new HashSet<>(Arrays.asList(4))).stream().collect(Collectors.toMap(x -> x.getItemId(), x -> x));
-		} catch (HttpHostConnectException e) {
-			throw new ProfitMandiBusinessException("", "", "Could not connect to host");
+        List<Integer> catalogIds = itemsMap.values().stream().map(x -> x.getCatalogItemId()).collect(Collectors.toList());
-		}
-		JSONObject solrResponseJSONObj = new JSONObject(response).getJSONObject("response");
+        Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);
-		JSONArray docs = solrResponseJSONObj.getJSONArray("docs");
-		List<FofoCatalogResponse> dealResponse = getCatalogResponse(docs, false, userInfo.getRetailerId());
+        // cartResponse.getCartItems()
-		return dealResponse;
+        int cartMessageChanged = 0;
-	}
+        int cartMessageOOS = 0;
+        int totalAmount = 0;
-	@RequestMapping(value = "/store/cart", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
+        int totalQty = 0;
-	@ApiImplicitParams({
+        for (CartItem cartItem : cartItems) {
-			@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header") })
+            Item item = itemsMap.get(cartItem.getItemId());
-	@ApiOperation(value = "Get brand list and count for category")
+            TagListing tagListing = tagListingMap.get(cartItem.getItemId());
-	public ResponseEntity<?> cart(HttpServletRequest request, @RequestBody AddCartRequest cartRequest)
+            Float cashback = schemeService.getCatalogSchemeCashBack().get(itemsMap.get(cartItem.getItemId()).getCatalogItemId());
-			throws Exception {
+            cashback = cashback == null ? 0 : cashback;
-		UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
+            float itemSellingPrice = tagListing.getMop() - cashback;
-		Integer storeId = userInfo.getRetailerId();
+            CartItemResponseModel cartItemResponseModel = new CartItemResponseModel();
-		ValidateCartResponse vc = new ValidateCartResponse(this.validateCart(storeId, cartRequest.getCartItems()),
+            cartItemResponseModel.setSellingPrice(cartItem.getSellingPrice());
-				"Success", "Items added to cart successfully");
+            if (itemSellingPrice != cartItem.getSellingPrice()) {
-		return responseSender.ok(vc);
+                cartItemResponseModel.setSellingPrice(itemSellingPrice);
-	}
+                cartMessageChanged++;
+            }
-	// Validate Cart for B2C Customers
+            int estimate = -2;
-	private CartResponse validateCart(int storeId, List<CartItem> cartItems) throws Exception {
+            LocalDateTime promiseDeliveryTime = LocalDateTime.now();
-		cartItems = cartItems.stream().filter(x -> x.getQuantity() > 0).collect(Collectors.toList());
+            int qtyRequired = (int) cartItem.getQuantity();
-		List<Integer> itemIds = cartItems.stream().map(x -> x.getItemId()).collect(Collectors.toList());
+            AvailabilityModel availabilityModel = inventoryItemAvailabilityMap.get(cartItem.getItemId());
-		Map<Integer, AvailabilityModel> inventoryItemAvailabilityMap = inventoryService.getStoreAndOurStock(storeId,
+            cartItemResponseModel.setMaxQuantity(availabilityModel.getMaxAvailability());
-				itemIds);
+            if (availabilityModel.getStoreAvailability() >= qtyRequired) {
-		CartResponse cartResponse = new CartResponse();
+                estimate = 0;
-		List<CartItemResponseModel> cartItemResponseModels = new ArrayList<>();
+            } else if (availabilityModel.getWarehouseAvailability() >= qtyRequired) {
-		cartResponse.setCartItems(cartItemResponseModels);
+                estimate = 2;
-		Set<Integer> itemsIdsSet = new HashSet<>(itemIds);
+            } else if (availabilityModel.getStoreAvailability() > 0) {
-		logger.info("Store Id {}, Item Ids {}", storeId, itemsIdsSet);
+                estimate = 0;
+                qtyRequired = availabilityModel.getStoreAvailability();
-		Map<Integer, Item> itemsMap = itemRepository.selectByIds(itemsIdsSet).stream()
+                cartMessageChanged++;
-				.collect(Collectors.toMap(x -> x.getId(), x -> x));
+            } else if (availabilityModel.getWarehouseAvailability() > 0) {
+                qtyRequired = availabilityModel.getWarehouseAvailability();
-		Map<Integer, TagListing> tagListingMap = tagListingRepository
+                estimate = 2;
-				.selectByItemIdsAndTagIds(new HashSet<>(itemIds), new HashSet<>(Arrays.asList(4))).stream()
+                cartMessageChanged++;
-				.collect(Collectors.toMap(x -> x.getItemId(), x -> x));
+            } else {
+                qtyRequired = 0;
-		List<Integer> catalogIds = itemsMap.values().stream().map(x -> x.getCatalogItemId())
+                cartMessageChanged++;
-				.collect(Collectors.toList());
+            }
+            cartItemResponseModel.setQuantity(qtyRequired);
-		Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);
+            if (estimate >= 0 && LocalTime.now().isAfter(CUTOFF_TIME)) {
+                estimate = estimate + 1;
-		// cartResponse.getCartItems()
+                promiseDeliveryTime = promiseDeliveryTime.plusDays(3);
-		int cartMessageChanged = 0;
+            }
-		int cartMessageOOS = 0;
+            totalQty += qtyRequired;
-		int totalAmount = 0;
+            totalAmount += qtyRequired * itemSellingPrice;
-		int totalQty = 0;
+            cartItemResponseModel.setEstimate(estimate);
-		for (CartItem cartItem : cartItems) {
+            cartItemResponseModel.setTitle(item.getItemDescriptionNoColor());
-			Item item = itemsMap.get(cartItem.getItemId());
+            cartItemResponseModel.setItemId(cartItem.getItemId());
-			TagListing tagListing = tagListingMap.get(cartItem.getItemId());
+            cartItemResponseModel.setMinBuyQuantity(1);
-			Float cashback = schemeService.getCatalogSchemeCashBack()
+            cartItemResponseModel.setQuantity(qtyRequired);
-					.get(itemsMap.get(cartItem.getItemId()).getCatalogItemId());
+            cartItemResponseModel.setQuantityStep(1);
-			cashback = cashback == null ? 0 : cashback;
+            cartItemResponseModel.setPromiseDelivery(promiseDeliveryTime);
-			float itemSellingPrice = tagListing.getMop() - cashback;
+            cartItemResponseModel.setMaxQuantity(availabilityModel.getMaxAvailability());
-			CartItemResponseModel cartItemResponseModel = new CartItemResponseModel();
+            cartItemResponseModel.setCatalogItemId(item.getCatalogItemId());
-			cartItemResponseModel.setSellingPrice(cartItem.getSellingPrice());
+            cartItemResponseModel.setImageUrl(contentMap.get(item.getCatalogItemId()).getString("imageUrl_s"));
-			if (itemSellingPrice != cartItem.getSellingPrice()) {
+            cartItemResponseModel.setColor(item.getColor());
-				cartItemResponseModel.setSellingPrice(itemSellingPrice);
+            cartItemResponseModels.add(cartItemResponseModel);
-				cartMessageChanged++;
+        }
-			}
+        cartResponse.setCartItems(cartItemResponseModels);
-			int estimate = -2;
+        cartResponse.setCartMessageChanged(cartMessageChanged);
-			LocalDateTime promiseDeliveryTime = LocalDateTime.now();
+        cartResponse.setCartMessageOOS(cartMessageOOS);
-			int qtyRequired = (int) cartItem.getQuantity();
+        int maxEstimate = cartItemResponseModels.stream().mapToInt(x -> x.getEstimate()).max().getAsInt();
-			AvailabilityModel availabilityModel = inventoryItemAvailabilityMap.get(cartItem.getItemId());
+        cartResponse.setMaxEstimate(maxEstimate);
-			cartItemResponseModel.setMaxQuantity(availabilityModel.getMaxAvailability());
+        cartResponse.setTotalAmount(totalAmount);
-			if (availabilityModel.getStoreAvailability() >= qtyRequired) {
+        cartResponse.setTotalQty(totalQty);
-				estimate = 0;
-			} else if (availabilityModel.getWarehouseAvailability() >= qtyRequired) {
+        return cartResponse;
-				estimate = 2;
-			} else if (availabilityModel.getStoreAvailability() > 0) {
+    }
-				estimate = 0;
-				qtyRequired = availabilityModel.getStoreAvailability();
+    @RequestMapping(value = "/store/partnerStock", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-				cartMessageChanged++;
+    public ResponseEntity<?> partnerStock(HttpServletRequest request, @RequestParam(value = "categoryId", required = false, defaultValue = "3") String categoryId, @RequestParam(value = "offset") String offset, @RequestParam(value = "limit") String limit, @RequestParam(value = "sort", required = false) String sort, @RequestParam(value = "brand", required = false) String brand, @RequestParam(value = "subCategoryId", required = false) int subCategoryId, @RequestParam(value = "q", required = false) String queryTerm, @RequestParam(required = false) String listing, @RequestParam(required = false, defaultValue = "true") boolean partnerStockOnly) throws Throwable {
-			} else if (availabilityModel.getWarehouseAvailability() > 0) {
+        List<FofoCatalogResponse> dealResponse = new ArrayList<>();
-				qtyRequired = availabilityModel.getWarehouseAvailability();
+        UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
-				estimate = 2;
+        FofoStore fs = fofoStoreRepository.selectByRetailerId(userInfo.getRetailerId());
-				cartMessageChanged++;
+        sort = "w" + fs.getWarehouseId() + "_i desc";
-			} else {
+        dealResponse = this.getCatalogResponse(
-				qtyRequired = 0;
+                commonSolrService.getSolrDocs(queryTerm, categoryId, offset, limit, sort, brand, subCategoryId, false), false, userInfo.getRetailerId());
-				cartMessageChanged++;
+        return responseSender.ok(dealResponse);
-			}
+    }
-			cartItemResponseModel.setQuantity(qtyRequired);
-			if (estimate >= 0 && LocalTime.now().isAfter(CUTOFF_TIME)) {
+    private List<FofoCatalogResponse> getCatalogResponse(JSONArray docs, boolean hotDeal, int fofoId) throws ProfitMandiBusinessException {
-				estimate = estimate + 1;
+        Map<Integer, Integer> ourItemAvailabilityMap = null;
-				promiseDeliveryTime = promiseDeliveryTime.plusDays(3);
+        Map<Integer, Integer> partnerStockAvailabilityMap = null;
-			}
+        List<FofoCatalogResponse> dealResponse = new ArrayList<>();
-			totalQty += qtyRequired;
+        List<Integer> tagIds = Arrays.asList(4);
-			totalAmount += qtyRequired * itemSellingPrice;
+        if (docs.length() > 0) {
-			cartItemResponseModel.setEstimate(estimate);
+            HashSet<Integer> itemsSet = new HashSet<>();
-			cartItemResponseModel.setTitle(item.getItemDescriptionNoColor());
+            for (int i = 0; i < docs.length(); i++) {
-			cartItemResponseModel.setItemId(cartItem.getItemId());
+                JSONObject doc = docs.getJSONObject(i);
-			cartItemResponseModel.setMinBuyQuantity(1);
+                if (doc.has("_childDocuments_")) {
-			cartItemResponseModel.setQuantity(qtyRequired);
+                    for (int j = 0; j < doc.getJSONArray("_childDocuments_").length(); j++) {
-			cartItemResponseModel.setQuantityStep(1);
+                        JSONObject childItem = doc.getJSONArray("_childDocuments_").getJSONObject(j);
-			cartItemResponseModel.setPromiseDelivery(promiseDeliveryTime);
+                        int itemId = childItem.getInt("itemId_i");
-			cartItemResponseModel.setMaxQuantity(availabilityModel.getMaxAvailability());
+                        itemsSet.add(itemId);
-			cartItemResponseModel.setCatalogItemId(item.getCatalogItemId());
+                    }
-			cartItemResponseModel.setImageUrl(contentMap.get(item.getCatalogItemId()).getString("imageUrl_s"));
+                }
-			cartItemResponseModel.setColor(item.getColor());
+            }
-			cartItemResponseModels.add(cartItemResponseModel);
+            if (itemsSet.size() == 0) {
-		}
+                return dealResponse;
-		cartResponse.setCartItems(cartItemResponseModels);
+            }
-		cartResponse.setCartMessageChanged(cartMessageChanged);
+            if (fofoId > 0) {
-		cartResponse.setCartMessageOOS(cartMessageOOS);
+                partnerStockAvailabilityMap = currentInventorySnapshotRepository.selectItemsStock(fofoId).stream().collect(Collectors.toMap(x -> x.getItemId(), x -> x.getAvailability()));
-		int maxEstimate = cartItemResponseModels.stream().mapToInt(x -> x.getEstimate()).max().getAsInt();
+            }
-		cartResponse.setMaxEstimate(maxEstimate);
+            ourItemAvailabilityMap = saholicInventoryService.getTotalAvailabilityByItemIds(new ArrayList<>(itemsSet));
-		cartResponse.setTotalAmount(totalAmount);
+        }
-		cartResponse.setTotalQty(totalQty);
+        for (int i = 0; i < docs.length(); i++) {
-		return cartResponse;
+            Map<Integer, FofoAvailabilityInfo> fofoAvailabilityInfoMap = new HashMap<>();
+            JSONObject doc = docs.getJSONObject(i);
-	}
+            FofoCatalogResponse ffdr = new FofoCatalogResponse();
+            ffdr.setCatalogId(doc.getInt("catalogId_i"));
-	@RequestMapping(value = "/store/partnerStock", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
+            ffdr.setImageUrl(doc.getString("imageUrl_s"));
-	public ResponseEntity<?> partnerStock(HttpServletRequest request,
+            ffdr.setTitle(doc.getString("title_s"));
-			@RequestParam(value = "categoryId", required = false, defaultValue = "3") String categoryId,
+            List<WebOffer> webOffers = webOfferRepository.selectAllActiveOffers().get(ffdr.getCatalogId());
-			@RequestParam(value = "offset") String offset, @RequestParam(value = "limit") String limit,
+            if (webOffers != null && webOffers.size() > 0) {
-			@RequestParam(value = "sort", required = false) String sort,
+                ffdr.setOffers(webOffers.stream().map(x -> x.getTitle()).collect(Collectors.toList()));
-			@RequestParam(value = "brand", required = false) String brand,
+            }
-			@RequestParam(value = "subCategoryId", required = false) int subCategoryId,
+            try {
-			@RequestParam(value = "q", required = false) String queryTerm,
+                ffdr.setFeature(doc.getString("feature_s"));
-			@RequestParam(required = false) String listing,
+            } catch (Exception e) {
-			@RequestParam(required = false, defaultValue = "true") boolean partnerStockOnly) throws Throwable {
+                ffdr.setFeature(null);
-		List<FofoCatalogResponse> dealResponse = new ArrayList<>();
+            }
-		UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");
+            ffdr.setBrand(doc.getJSONArray("brand_ss").getString(0));
-		FofoStore fs = fofoStoreRepository.selectByRetailerId(userInfo.getRetailerId());
+            if (doc.has("_childDocuments_")) {
-		sort = "w" + fs.getWarehouseId() + "_i desc";
+                for (int j = 0; j < doc.getJSONArray("_childDocuments_").length(); j++) {
-		dealResponse = this.getCatalogResponse(
+                    JSONObject childItem = doc.getJSONArray("_childDocuments_").getJSONObject(j);
-				commonSolrService.getSolrDocs(queryTerm, categoryId, offset, limit, sort, brand, subCategoryId, false),
+                    int itemId = childItem.getInt("itemId_i");
-				false, userInfo.getRetailerId());
+                    float sellingPrice = (float) childItem.getDouble("sellingPrice_f");
-		return responseSender.ok(dealResponse);
+                    if (fofoAvailabilityInfoMap.containsKey(itemId)) {
-	}
+                        if (fofoAvailabilityInfoMap.get(itemId).getSellingPrice() > sellingPrice) {
+                            fofoAvailabilityInfoMap.get(itemId).setSellingPrice(sellingPrice);
-	private List<FofoCatalogResponse> getCatalogResponse(JSONArray docs, boolean hotDeal, int fofoId)
+                            fofoAvailabilityInfoMap.get(itemId).setMop((float) childItem.getDouble("mop_f"));
-			throws ProfitMandiBusinessException {
+                        }
-		Map<Integer, Integer> ourItemAvailabilityMap = null;
+                    } else {
-		Map<Integer, Integer> partnerStockAvailabilityMap = null;
+                        FofoAvailabilityInfo fdi = new FofoAvailabilityInfo();
-		List<FofoCatalogResponse> dealResponse = new ArrayList<>();
+                        fdi.setSellingPrice(sellingPrice);
-		List<Integer> tagIds = Arrays.asList(4);
+                        fdi.setMrp(childItem.getDouble("mrp_f"));
-		if (docs.length() > 0) {
+                        fdi.setMop((float) childItem.getDouble("mop_f"));
-			HashSet<Integer> itemsSet = new HashSet<>();
+                        fdi.setColor(childItem.has("color_s") ? childItem.getString("color_s") : "");
-			for (int i = 0; i < docs.length(); i++) {
+                        fdi.setTagId(childItem.getInt("tagId_i"));
-				JSONObject doc = docs.getJSONObject(i);
+                        fdi.setItem_id(itemId);
-				if (doc.has("_childDocuments_")) {
+                        Float cashBack = schemeService.getCatalogSchemeCashBack().get(ffdr.getCatalogId());
-					for (int j = 0; j < doc.getJSONArray("_childDocuments_").length(); j++) {
+                        cashBack = cashBack == null ? 0 : cashBack;
-						JSONObject childItem = doc.getJSONArray("_childDocuments_").getJSONObject(j);
+                        // TODO:Dont commit
-						int itemId = childItem.getInt("itemId_i");
+                        // fdi.setCashback(Math.min(100, fdi.getMop()));
-						itemsSet.add(itemId);
+                        fdi.setCashback(cashBack);
-					}
+                        fdi.setMinBuyQuantity(1);
-				}
+                        int partnerAvailability = partnerStockAvailabilityMap.get(itemId) == null ? 0 : partnerStockAvailabilityMap.get(itemId);
-			}
+                        int ourStockAvailability = ourItemAvailabilityMap.get(itemId) == null ? 0 : Math.max(0, ourItemAvailabilityMap.get(itemId));
-			if (itemsSet.size() == 0) {
+                        fdi.setActive(partnerAvailability > 0);
-				return dealResponse;
+                        // fdi.setActive(true);
-			}
+                        fdi.setAvailability(Math.min(5, ourStockAvailability + partnerAvailability));
-			if (fofoId > 0) {
+                        fdi.setQuantityStep(1);
-				partnerStockAvailabilityMap = currentInventorySnapshotRepository.selectItemsStock(fofoId).stream()
+                        fdi.setMaxQuantity(fdi.getAvailability());
-						.collect(Collectors.toMap(x -> x.getItemId(), x -> x.getAvailability()));
+                        fofoAvailabilityInfoMap.put(itemId, fdi);
-			}
+                    }
-			ourItemAvailabilityMap = saholicInventoryService.getTotalAvailabilityByItemIds(new ArrayList<>(itemsSet));
+                }
-		}
+            }
+            if (fofoAvailabilityInfoMap.values().size() > 0) {
-		for (int i = 0; i < docs.length(); i++) {
+                ffdr.setItems(fofoAvailabilityInfoMap.values().stream().sorted(Comparator.comparing(FofoAvailabilityInfo::isActive, Comparator.reverseOrder()).thenComparingInt(y -> -y.getAvailability())).collect(Collectors.toList()));
-			Map<Integer, FofoAvailabilityInfo> fofoAvailabilityInfoMap = new HashMap<>();
+                dealResponse.add(ffdr);
-			JSONObject doc = docs.getJSONObject(i);
+            }
-			FofoCatalogResponse ffdr = new FofoCatalogResponse();
+        }
-			ffdr.setCatalogId(doc.getInt("catalogId_i"));
+        return dealResponse.stream().sorted(Comparator.comparing(FofoCatalogResponse::getItems, (s1, s2) -> (s2.get(0).isActive() ? 1 : 0) - (s1.get(0).isActive() ? 1 : 0)).thenComparing(FofoCatalogResponse::getItems, (x, y) -> y.get(0).getAvailability() - x.get(0).getAvailability())).collect(Collectors.toList());
-			ffdr.setImageUrl(doc.getString("imageUrl_s"));
+    }
-			ffdr.setTitle(doc.getString("title_s"));
-			List<WebOffer> webOffers = webOfferRepository.selectAllActiveOffers().get(ffdr.getCatalogId());
+    @GetMapping(value = "store/order-status/{pendingOrderId}")
-			if (webOffers != null && webOffers.size() > 0) {
+    public ResponseEntity<?> orderStatus(HttpServletRequest request, @PathVariable int pendingOrderId) throws Exception {
-				ffdr.setOffers(webOffers.stream().map(x -> x.getTitle()).collect(Collectors.toList()));
+        PendingOrder pendingOrder = pendingOrderRepository.selectById(pendingOrderId);
-			}
+        List<PendingOrderItem> pendingOrderItems = pendingOrderItemRepository.selectByOrderId(pendingOrder.getId());
-			try {
+        List<Integer> catalogIds = new ArrayList<>();
-				ffdr.setFeature(doc.getString("feature_s"));
+        for (PendingOrderItem pendingOrderItem : pendingOrderItems) {
-			} catch (Exception e) {
+            Item item = itemRepository.selectById(pendingOrderItem.getItemId());
-				ffdr.setFeature(null);
+            pendingOrderItem.setItemName(item.getItemDescription());
-			}
+            catalogIds.add(item.getCatalogItemId());
-			ffdr.setBrand(doc.getJSONArray("brand_ss").getString(0));
+        }
-			if (doc.has("_childDocuments_")) {
+        Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);
-				for (int j = 0; j < doc.getJSONArray("_childDocuments_").length(); j++) {
+        for (PendingOrderItem pendingOrderItem : pendingOrderItems) {
-					JSONObject childItem = doc.getJSONArray("_childDocuments_").getJSONObject(j);
+            Item item = itemRepository.selectById(pendingOrderItem.getItemId());
-					int itemId = childItem.getInt("itemId_i");
+            JSONObject jsonObj = contentMap.get(item.getCatalogItemId());
-					float sellingPrice = (float) childItem.getDouble("sellingPrice_f");
+            pendingOrderItem.setImgUrl(jsonObj.getString("imageUrl_s"));
-					if (fofoAvailabilityInfoMap.containsKey(itemId)) {
+        }
-						if (fofoAvailabilityInfoMap.get(itemId).getSellingPrice() > sellingPrice) {
+        pendingOrder.setPendingOrderItems(pendingOrderItems);
-							fofoAvailabilityInfoMap.get(itemId).setSellingPrice(sellingPrice);
-							fofoAvailabilityInfoMap.get(itemId).setMop((float) childItem.getDouble("mop_f"));
+        return responseSender.ok(pendingOrder);
-						}
+    }
-					} else {
-						FofoAvailabilityInfo fdi = new FofoAvailabilityInfo();
+    @RequestMapping(value = "/store/addresses/{customerId}", method = RequestMethod.GET)
-						fdi.setSellingPrice(sellingPrice);
+    public ResponseEntity<?> getAll(HttpServletRequest request, @PathVariable int customerId) throws Throwable {
-						fdi.setMrp(childItem.getDouble("mrp_f"));
+        return responseSender.ok(customerAddressRepository.selectByActiveCustomerId(customerId));
-						fdi.setMop((float) childItem.getDouble("mop_f"));
+    }
-						fdi.setColor(childItem.has("color_s") ? childItem.getString("color_s") : "");
-						fdi.setTagId(childItem.getInt("tagId_i"));
+    @RequestMapping(value = "/store/address", method = RequestMethod.POST)
-						fdi.setItem_id(itemId);
+    public ResponseEntity<?> addAddress(HttpServletRequest request, @RequestBody CustomerAddress customerAddress) throws Throwable {
-						Float cashBack = schemeService.getCatalogSchemeCashBack().get(ffdr.getCatalogId());
+        customerAddressRepository.persist(customerAddress);
-						cashBack = cashBack == null ? 0 : cashBack;
+        return responseSender.ok(customerAddress);
-						// TODO:Dont commit
+    }
-						// fdi.setCashback(Math.min(100, fdi.getMop()));
-						fdi.setCashback(cashBack);
+    @RequestMapping(value = "/store/deactivateCustomerAddress", method = RequestMethod.POST)
-						fdi.setMinBuyQuantity(1);
+    public ResponseEntity<?> deactivateAddresss(HttpServletRequest request, @RequestParam int id) throws Throwable {
-						int partnerAvailability = partnerStockAvailabilityMap.get(itemId) == null ? 0
+        CustomerAddress cust = customerAddressRepository.selectById(id);
-								: partnerStockAvailabilityMap.get(itemId);
+        cust.setActive(false);
-						int ourStockAvailability = ourItemAvailabilityMap.get(itemId) == null ? 0
+        return responseSender.ok(cust);
-								: Math.max(0, ourItemAvailabilityMap.get(itemId));
+    }
-						fdi.setActive(partnerAvailability > 0);
-						// fdi.setActive(true);
+    @RequestMapping(value = "/store/updateCustomer", method = RequestMethod.POST)
-						fdi.setAvailability(Math.min(5, ourStockAvailability + partnerAvailability));
+    public ResponseEntity<?> updateCustomerProfile(HttpServletRequest request, @RequestBody Customer customer) throws Throwable {
-						fdi.setQuantityStep(1);
+        Customer cust = customerRepository.selectById(customer.getId());
-						fdi.setMaxQuantity(fdi.getAvailability());
+        cust.setGender(customer.getGender());
-						fofoAvailabilityInfoMap.put(itemId, fdi);
+        cust.setProfileImageId(customer.getProfileImageId());
-					}
+        cust.setDob(customer.getDob());
-				}
+        return responseSender.ok(cust);
-			}
+    }
-			if (fofoAvailabilityInfoMap.values().size() > 0) {
-				ffdr.setItems(fofoAvailabilityInfoMap.values().stream()
+    @RequestMapping(value = "/stores/{state}/{city}/{storeCode}", method = RequestMethod.GET)
-						.sorted(Comparator.comparing(FofoAvailabilityInfo::isActive, Comparator.reverseOrder())
+    public void getStoreIndex(HttpServletResponse response, HttpServletRequest request, @PathVariable String state, @PathVariable String city, @PathVariable String storeCode) throws Throwable {
-								.thenComparingInt(y -> -y.getAvailability()))
+        logger.info("Store code {}", storeCode);
-						.collect(Collectors.toList()));
+        Map<String, Integer> map = retailerService.getStoreCodeRetailerMap();
-				dealResponse.add(ffdr);
+        logger.info("retailer id {}", map.get(storeCode));
-			}
+        String retailerName = retailerService.getAllFofoRetailers().get(map.get(storeCode)).getBusinessName();
-		}
+        String html = partnerIndexService.getPartnerIndexHtml();
-		return dealResponse.stream()
+        logger.info("html {}", html);
-				.sorted(Comparator
+        html = html.replace("Buy Mobiles and Accessories at exciting prices - SmartDukaan", String.format("%s is now ONLINE. Buy Mobiles, Accessories & more | SmartDukaan", retailerName));
-						.comparing(FofoCatalogResponse::getItems,
+        response.getWriter().write(html);
-								(s1, s2) -> (s2.get(0).isActive() ? 1 : 0) - (s1.get(0).isActive() ? 1 : 0))
+    }
-						.thenComparing(FofoCatalogResponse::getItems,
-								(x, y) -> y.get(0).getAvailability() - x.get(0).getAvailability()))
+    @RequestMapping(value = "/cancelPendingOrderItem", method = RequestMethod.POST)
-				.collect(Collectors.toList());
+    public ResponseEntity<?> cancelPendingOrderItem(HttpServletRequest request, @RequestParam int id,
-	}
+                                                    @RequestParam String statusDescription, @RequestParam String reason) throws Exception {
-	@GetMapping(value = "store/order-status/{pendingOrderId}")
-	public ResponseEntity<?> orderStatus(HttpServletRequest request, @PathVariable int pendingOrderId)
+        PendingOrderItem pendingOrderItem = pendingOrderItemRepository.selectById(id);
-			throws Exception {
+        PendingOrder pendingOrder = pendingOrderRepository.selectById(pendingOrderItem.getOrderId());
-		PendingOrder pendingOrder = pendingOrderRepository.selectById(pendingOrderId);
+        Customer customer = customerRepository.selectById(pendingOrder.getCustomerId());
-		List<PendingOrderItem> pendingOrderItems = pendingOrderItemRepository.selectByOrderId(pendingOrder.getId());
+        if (pendingOrderItem.getBilledTimestamp() == null) {
-		List<Integer> catalogIds = new ArrayList<>();
+            pendingOrderItem.setStatus(OrderStatus.CANCELLED);
-		for (PendingOrderItem pendingOrderItem : pendingOrderItems) {
+            pendingOrderItem.setRemark(reason);
-			Item item = itemRepository.selectById(pendingOrderItem.getItemId());
+            pendingOrderItem.setStatusDescription("cancel by self");
-			pendingOrderItem.setItemName(item.getItemDescription());
+            pendingOrderItem.setCancelledTimestamp(LocalDateTime.now());
-			catalogIds.add(item.getCatalogItemId());
+            List<OrderStatus> status = pendingOrderItemRepository.selectByOrderId(pendingOrderItem.getOrderId()).stream().map(x -> x.getStatus()).collect(Collectors.toList());
-		}
-		Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);
+            if (!status.contains(OrderStatus.PENDING) && !status.contains(OrderStatus.PROCESSING) && !status.contains(OrderStatus.BILLED) && !status.contains(OrderStatus.UNSETTLED) && !status.contains(OrderStatus.CLAIMED)) {
-		for (PendingOrderItem pendingOrderItem : pendingOrderItems) {
+                pendingOrder.setStatus(OrderStatus.CLOSED);
-			Item item = itemRepository.selectById(pendingOrderItem.getItemId());
+            }
-			JSONObject jsonObj = contentMap.get(item.getCatalogItemId());
-			pendingOrderItem.setImgUrl(jsonObj.getString("imageUrl_s"));
+            pendingOrderItemRepository.persist(pendingOrderItem);
-		}
+            String itemDescription = itemRepository.selectById(pendingOrderItem.getItemId()).getItemDescription();
-		pendingOrder.setPendingOrderItems(pendingOrderItems);
+            otpProcessor.sendSms(OtpProcessor.SELF_CANCELLED_TEMPLATE_ID, String.format(OtpProcessor.SELF_CANCELLED_TEMPLATE, pendingOrder.getId(), StringUtils.abbreviate(itemDescription, 30), FormattingUtils.format(pendingOrderItem.getCancelledTimestamp())), customer.getMobileNumber());
-		return responseSender.ok(pendingOrder);
+            List<Integer> catalogIds = new ArrayList<>();
-	}
+            Item item = itemRepository.selectById(pendingOrderItem.getItemId());
-	@RequestMapping(value = "/store/addresses/{customerId}", method = RequestMethod.GET)
+            pendingOrderItem.setItemName(item.getItemDescription());
-	public ResponseEntity<?> getAll(HttpServletRequest request, @PathVariable int customerId) throws Throwable {
+            catalogIds.add(item.getCatalogItemId());
-		return responseSender.ok(customerAddressRepository.selectByActiveCustomerId(customerId));
-	}
+            Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);
+            JSONObject jsonObj = contentMap.get(item.getCatalogItemId());
-	@RequestMapping(value = "/store/address", method = RequestMethod.POST)
+            pendingOrderItem.setImgUrl(jsonObj.getString("imageUrl_s"));
-	public ResponseEntity<?> addAddress(HttpServletRequest request, @RequestBody CustomerAddress customerAddress)
+            pendingOrder.setPendingOrderItems(Arrays.asList(pendingOrderItem));
-			throws Throwable {
+            CustomerAddress customerAddress = customerAddressRepository.selectById(pendingOrder.getCustomerAddressId());
-		customerAddressRepository.persist(customerAddress);
-		return responseSender.ok(customerAddress);
+            DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy h:mm a");
-	}
+            Map<String, Object> emailModel = new HashMap<>();
-	@RequestMapping(value = "/store/deactivateCustomerAddress", method = RequestMethod.POST)
+            emailModel.put("customer", customerAddress);
-	public ResponseEntity<?> deactivateAddresss(HttpServletRequest request, @RequestParam int id) throws Throwable {
+            emailModel.put("pendingOrder", pendingOrder);
-		CustomerAddress cust = customerAddressRepository.selectById(id);
+            emailModel.put("date", dateTimeFormatter);
-		cust.setActive(false);
-		return responseSender.ok(cust);
+            String[] customerEmail = null;
-	}
+            if (customer.getEmailId() != null) {
+                customerEmail = new String[]{customer.getEmailId()};
-	@RequestMapping(value = "/store/updateCustomer", method = RequestMethod.POST)
-	public ResponseEntity<?> updateCustomerProfile(HttpServletRequest request, @RequestBody Customer customer)
+                List<String> bccTo = Arrays.asList("tejbeer.kaur@smartdukaan.com");
-			throws Throwable {
-		Customer cust = customerRepository.selectById(customer.getId());
+                emailService.sendMailWithAttachments("Order Cancellation", "order-cancellation.vm", emailModel, customerEmail, null, bccTo.toArray(new String[0]));
-		cust.setGender(customer.getGender());
-		cust.setProfileImageId(customer.getProfileImageId());
+            }
-		cust.setDob(customer.getDob());
+        }
-		return responseSender.ok(cust);
-	}
+        return responseSender.ok(true);
-	@RequestMapping(value = "/stores/{state}/{city}/{storeCode}", method = RequestMethod.GET)
+    }
-	public void getStoreIndex(HttpServletResponse response, HttpServletRequest request, @PathVariable String state,
-			@PathVariable String city, @PathVariable String storeCode) throws Throwable {
+    @RequestMapping(value = "/store/checkEligibilityStoreOffers", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-		logger.info("Store code {}", storeCode);
+    public ResponseEntity<?> checkEligibilityStoreOffers(HttpServletRequest request, @RequestParam(value = "id") int id) throws Exception {
-		Map<String, Integer> map = retailerService.getStoreCodeRetailerMap();
-		logger.info("retailer id {}", map.get(storeCode));
+        boolean eligibility = false;
-		String retailerName = retailerService.getAllFofoRetailers().get(map.get(storeCode)).getBusinessName();
-		String html = partnerIndexService.getPartnerIndexHtml();
+        LocalDateTime startDate = LocalDateTime.of(LocalDate.now().getYear(), LocalDate.now().getMonth(), 14, 0, 0);
-		logger.info("html {}", html);
-		html = html.replace("Buy Mobiles and Accessories at exciting prices - SmartDukaan",
+        List<ScratchOffer> scratchOffers = scratchOfferRepository.selectBycCustomerIdAndDate(id, startDate.toLocalDate());
-				String.format("%s is now ONLINE. Buy Mobiles, Accessories & more | SmartDukaan", retailerName));
-		response.getWriter().write(html);
+        if (!scratchOffers.isEmpty()) {
-	}
+            eligibility = true;
-	@RequestMapping(value = "/cancelPendingOrderItem", method = RequestMethod.POST)
+        } else {
-	public ResponseEntity<?> cancelPendingOrderItem(HttpServletRequest request, @RequestParam int id,
+            eligibility = false;
+        }
-			@RequestParam String statusDescription, @RequestParam String reason) throws Exception {
+        return responseSender.ok(eligibility);
-		PendingOrderItem pendingOrderItem = pendingOrderItemRepository.selectById(id);
+    }
-		PendingOrder pendingOrder = pendingOrderRepository.selectById(pendingOrderItem.getOrderId());
-		Customer customer = customerRepository.selectById(pendingOrder.getCustomerId());
+    @RequestMapping(value = "/store/ScratchOffers", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-		if (pendingOrderItem.getBilledTimestamp() == null) {
+    public ResponseEntity<?> scratchOffers(HttpServletRequest request, @RequestParam(value = "id") int id) throws Exception {
-			pendingOrderItem.setStatus(OrderStatus.CANCELLED);
-			pendingOrderItem.setRemark(reason);
+        LocalDateTime startDate = LocalDateTime.of(LocalDate.now().getYear(), LocalDate.now().getMonth(), 14, 0, 0);
-			pendingOrderItem.setStatusDescription("cancel by self");
-			pendingOrderItem.setCancelledTimestamp(LocalDateTime.now());
+        List<ScratchOffer> scratchOffers = scratchOfferRepository.selectBycCustomerIdAndDate(id, startDate.toLocalDate());
-			List<OrderStatus> status = pendingOrderItemRepository.selectByOrderId(pendingOrderItem.getOrderId())
-					.stream().map(x -> x.getStatus()).collect(Collectors.toList());
+        // List<ScratchOffer> scratchOffers =
+        // scratchOfferRepository.selectBycCustomerId(id);
-			if (!status.contains(OrderStatus.PENDING) && !status.contains(OrderStatus.PROCESSING)
+        for (ScratchOffer so : scratchOffers) {
-					&& !status.contains(OrderStatus.BILLED) && !status.contains(OrderStatus.UNSETTLED)
+            LocalDateTime endDate = LocalDateTime.of(LocalDate.now().getYear(), LocalDate.now().getMonth(), 27, 21, 00);
-					&& !status.contains(OrderStatus.CLAIMED)) {
-				pendingOrder.setStatus(OrderStatus.CLOSED);
+            if (so.getOfferName() != null) {
-			}
+                so.setExpiredTimestamp(endDate);
+            }
-			pendingOrderItemRepository.persist(pendingOrderItem);
+            if (LocalDateTime.now().isAfter(so.getUnlockedAt())) {
-			String itemDescription = itemRepository.selectById(pendingOrderItem.getItemId()).getItemDescription();
+                so.setUnlocked(true);
-			otpProcessor.sendSms(OtpProcessor.SELF_CANCELLED_TEMPLATE_ID,
+            } else {
-					String.format(OtpProcessor.SELF_CANCELLED_TEMPLATE, pendingOrder.getId(),
+                so.setUnlocked(false);
-							StringUtils.abbreviate(itemDescription, 30),
+            }
-							FormattingUtils.format(pendingOrderItem.getCancelledTimestamp())),
+        }
-					customer.getMobileNumber());
+        return responseSender.ok(scratchOffers);
-			List<Integer> catalogIds = new ArrayList<>();
+    }
-			Item item = itemRepository.selectById(pendingOrderItem.getItemId());
+    @RequestMapping(value = "/store/ScratchedOffer", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
-			pendingOrderItem.setItemName(item.getItemDescription());
+    public ResponseEntity<?> scratchedOffer(HttpServletRequest request, @RequestParam(value = "id") int id) throws Exception {
-			catalogIds.add(item.getCatalogItemId());
+        ScratchOffer scratchOffer = scratchOfferRepository.selectById(id);
-			Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);
+        scratchOffer.setScratched(true);
-			JSONObject jsonObj = contentMap.get(item.getCatalogItemId());
+        scratchOffer.setScracthedAt(LocalDateTime.now());
-			pendingOrderItem.setImgUrl(jsonObj.getString("imageUrl_s"));
-			pendingOrder.setPendingOrderItems(Arrays.asList(pendingOrderItem));
-			CustomerAddress customerAddress = customerAddressRepository.selectById(pendingOrder.getCustomerAddressId());
-			DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy h:mm a");
-			Map<String, Object> emailModel = new HashMap<>();
-			emailModel.put("customer", customerAddress);
-			emailModel.put("pendingOrder", pendingOrder);
-			emailModel.put("date", dateTimeFormatter);
-			String[] customerEmail = null;
-			if (customer.getEmailId() != null) {
-				customerEmail = new String[] { customer.getEmailId() };
-				List<String> bccTo = Arrays.asList("tejbeer.kaur@smartdukaan.com");
-				emailService.sendMailWithAttachments("Order Cancellation", "order-cancellation.vm", emailModel,
-						customerEmail, null, bccTo.toArray(new String[0]));
-			}
-		}
-		return responseSender.ok(true);
-	}
-	@RequestMapping(value = "/store/checkEligibilityStoreOffers", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-	public ResponseEntity<?> checkEligibilityStoreOffers(HttpServletRequest request, @RequestParam(value = "id") int id)
-			throws Exception {
-		boolean eligibility = false;
-		LocalDateTime startDate = LocalDateTime.of(LocalDate.now().getYear(), LocalDate.now().getMonth(), 14, 0, 0);
-		List<ScratchOffer> scratchOffers = scratchOfferRepository.selectBycCustomerIdAndDate(id,
-				startDate.toLocalDate());
-		if (!scratchOffers.isEmpty()) {
-			eligibility = true;
-		} else {
-			eligibility = false;
-		}
-		return responseSender.ok(eligibility);
-	}
-	@RequestMapping(value = "/store/ScratchOffers", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
-	public ResponseEntity<?> scratchOffers(HttpServletRequest request, @RequestParam(value = "id") int id)
-			throws Exception {
-		LocalDateTime startDate = LocalDateTime.of(LocalDate.now().getYear(), LocalDate.now().getMonth(), 14, 0, 0);
-		List<ScratchOffer> scratchOffers = scratchOfferRepository.selectBycCustomerIdAndDate(id,
-				startDate.toLocalDate());
-		// List<ScratchOffer> scratchOffers =
-		// scratchOfferRepository.selectBycCustomerId(id);
-		for (ScratchOffer so : scratchOffers) {
-			LocalDateTime endDate = LocalDateTime.of(LocalDate.now().getYear(), LocalDate.now().getMonth(), 27, 21, 00);
-			if (so.getOfferName() != null) {
-				so.setExpiredTimestamp(endDate);
-			}
-			if (LocalDateTime.now().isAfter(so.getUnlockedAt())) {
-				so.setUnlocked(true);
-			} else {
-				so.setUnlocked(false);
-			}
-		}
-		return responseSender.ok(scratchOffers);
-	}
-	@RequestMapping(value = "/store/ScratchedOffer", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
-	public ResponseEntity<?> scratchedOffer(HttpServletRequest request, @RequestParam(value = "id") int id)
-			throws Exception {
-		ScratchOffer scratchOffer = scratchOfferRepository.selectById(id);
-		scratchOffer.setScratched(true);
-		scratchOffer.setScracthedAt(LocalDateTime.now());
-		return responseSender.ok(true);
+        return responseSender.ok(true);
-	}
+    }
+}

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/StoreController.java – Rev 31573 → 32018