Subversion Repositories SmartDukaan

package com.spice.profitmandi.web.controller;

import java.time.LocalDateTime;

import java.time.LocalTime;

import java.time.format.DateTimeFormatter;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.Comparator;

import java.util.HashMap;

import java.util.HashSet;

import java.util.List;

import java.util.Map;

import java.util.Optional;

import java.util.Set;

import java.util.stream.Collectors;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.lang3.StringUtils;

import org.apache.http.conn.HttpHostConnectException;

import org.apache.logging.log4j.LogManager;

import org.apache.logging.log4j.Logger;

import org.json.JSONArray;

import org.json.JSONObject;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.beans.factory.annotation.Value;

import org.springframework.cache.annotation.Cacheable;

import org.springframework.http.MediaType;

import org.springframework.http.ResponseEntity;

import org.springframework.stereotype.Controller;

import org.springframework.transaction.annotation.Transactional;

import org.springframework.web.bind.annotation.GetMapping;

import org.springframework.web.bind.annotation.PathVariable;

import org.springframework.web.bind.annotation.RequestBody;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestMethod;

import org.springframework.web.bind.annotation.RequestParam;

import org.springframework.web.bind.annotation.ResponseBody;

import com.eclipsesource.json.JsonObject;

import com.fasterxml.jackson.annotation.JsonProperty;

import com.google.gson.Gson;

import com.google.gson.reflect.TypeToken;

import com.spice.profitmandi.common.enumuration.MessageType;

import com.spice.profitmandi.common.enumuration.SchemeType;

import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;

import com.spice.profitmandi.common.model.CreatePendingOrderItem;

import com.spice.profitmandi.common.model.CreatePendingOrderRequest;

import com.spice.profitmandi.common.model.CustomRetailer;

import com.spice.profitmandi.common.model.ProfitMandiConstants;

import com.spice.profitmandi.common.model.SendNotificationModel;

import com.spice.profitmandi.common.model.UserInfo;

import com.spice.profitmandi.common.solr.SolrService;

import com.spice.profitmandi.common.util.FormattingUtils;

import com.spice.profitmandi.common.web.client.RestClient;

import com.spice.profitmandi.common.web.util.ResponseSender;

import com.spice.profitmandi.dao.entity.catalog.Item;

import com.spice.profitmandi.dao.entity.catalog.TagListing;

import com.spice.profitmandi.dao.entity.dtr.User;

import com.spice.profitmandi.dao.entity.dtr.WebListing;

import com.spice.profitmandi.dao.entity.dtr.WebOffer;

import com.spice.profitmandi.dao.entity.fofo.Customer;

import com.spice.profitmandi.dao.entity.fofo.CustomerAddress;

import com.spice.profitmandi.dao.entity.fofo.FofoStore;

import com.spice.profitmandi.dao.entity.fofo.PendingOrder;

import com.spice.profitmandi.dao.entity.fofo.PendingOrderItem;

import com.spice.profitmandi.dao.entity.fofo.PincodePartner;

import com.spice.profitmandi.dao.entity.fofo.RazorPay;

import com.spice.profitmandi.dao.enumuration.dtr.OtpType;

import com.spice.profitmandi.dao.enumuration.transaction.OrderStatus;

import com.spice.profitmandi.dao.model.AddCartRequest;

import com.spice.profitmandi.dao.model.CartItem;

import com.spice.profitmandi.dao.model.CartItemResponseModel;

import com.spice.profitmandi.dao.model.CartResponse;

import com.spice.profitmandi.dao.model.CustomerOrderDetail;

import com.spice.profitmandi.dao.repository.catalog.ItemRepository;

import com.spice.profitmandi.dao.repository.catalog.TagListingRepository;

import com.spice.profitmandi.dao.repository.cs.CsService;

import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;

import com.spice.profitmandi.dao.repository.dtr.UserAccountRepository;

import com.spice.profitmandi.dao.repository.dtr.WebListingRepository;

import com.spice.profitmandi.dao.repository.dtr.WebOfferRepository;

import com.spice.profitmandi.dao.repository.dtr.WebProductListingRepository;

import com.spice.profitmandi.dao.repository.fofo.CurrentInventorySnapshotRepository;

import com.spice.profitmandi.dao.repository.fofo.CustomerAddressRepository;

import com.spice.profitmandi.dao.repository.fofo.CustomerRepository;

import com.spice.profitmandi.dao.repository.fofo.PendingOrderItemRepository;

import com.spice.profitmandi.dao.repository.fofo.PendingOrderRepository;

import com.spice.profitmandi.dao.repository.fofo.PendingOrderService;

import com.spice.profitmandi.dao.repository.fofo.PincodePartnerRepository;

import com.spice.profitmandi.dao.repository.fofo.RazorPayRepository;

import com.spice.profitmandi.dao.repository.inventory.ItemAvailabilityCacheRepository;

import com.spice.profitmandi.service.CustomerService;

import com.spice.profitmandi.service.EmailService;

import com.spice.profitmandi.service.NotificationService;

import com.spice.profitmandi.service.authentication.RoleManager;

import com.spice.profitmandi.service.inventory.AvailabilityModel;

import com.spice.profitmandi.service.inventory.FofoAvailabilityInfo;

import com.spice.profitmandi.service.inventory.FofoCatalogResponse;

import com.spice.profitmandi.service.inventory.InventoryService;

import com.spice.profitmandi.service.inventory.SaholicInventoryService;

import com.spice.profitmandi.service.scheme.SchemeService;

import com.spice.profitmandi.service.user.RetailerService;

import com.spice.profitmandi.web.processor.OtpProcessor;

import com.spice.profitmandi.web.res.DealBrands;

import com.spice.profitmandi.web.res.DealObjectResponse;

import com.spice.profitmandi.web.res.DealsResponse;

import com.spice.profitmandi.web.res.ValidateCartResponse;

import com.spice.profitmandi.web.services.PartnerIndexService;

import io.swagger.annotations.ApiImplicitParam;

import io.swagger.annotations.ApiImplicitParams;

import io.swagger.annotations.ApiOperation;

@Controller

@Transactional(rollbackFor = Throwable.class)

public class StoreController {

	private static final Logger logger = LogManager.getLogger(StoreController.class);

	private static final LocalTime CUTOFF_TIME = LocalTime.of(15, 0);

	private static final List<Integer> TAG_IDS = Arrays.asList(4);

	@Autowired

	CustomerAddressRepository customerAddressRepository;

	@Autowired

	WebOfferRepository webOfferRepository;

	@Value("${new.solr.url}")

	private String solrUrl;

	@Autowired

	private PartnerIndexService partnerIndexService;

	@Autowired

	InventoryService inventoryService;

	@Autowired

	UserAccountRepository userAccountRepository;

	@Value("${python.api.host}")

	private String host;

	@Autowired

	CustomerService customerService;

	@Value("${python.api.port}")

	private int port;

	@Autowired

	private SaholicInventoryService saholicInventoryService;

	@Autowired

	private PincodePartnerRepository pincodePartnerRepository;

	@Autowired

	private FofoStoreRepository fofoStoreRepository;

	@Autowired

	private RetailerService retailerService;

	@Autowired

	private PendingOrderRepository pendingOrderRepository;

	@Autowired

	private PendingOrderItemRepository pendingOrderItemRepository;

	@Autowired

	private PendingOrderService pendingOrderService;

	@Autowired

	private CustomerRepository customerRepository;

	@Autowired

	private SolrService commonSolrService;

	@Autowired

	private OtpProcessor otpProcessor;

	@Autowired

	private CurrentInventorySnapshotRepository currentInventorySnapshotRepository;

	@Autowired

	private ResponseSender<?> responseSender;

	@Autowired

	private TagListingRepository tagListingRepository;

	@Autowired

	private ItemRepository itemRepository;

	@Autowired

	private SchemeService schemeService;

	@Autowired

	private ItemAvailabilityCacheRepository itemAvailabilityCacheRepository;

	@Autowired

	private WebListingRepository webListingRepository;

	@Autowired

	private WebProductListingRepository webProductListingRepository;

	@Autowired

	private RoleManager roleManagerService;

	@Autowired

	EmailService emailService;

	@Autowired

	CsService csService;

	@Autowired

	private NotificationService notificationService;

	@Autowired

	private com.spice.profitmandi.dao.repository.dtr.UserRepository dtrUserRepository;

	private static final List<String> offlineOrders = Arrays.asList("EMIOD", "POD");

	List<String> filterableParams = Arrays.asList("brand");

	@RequestMapping(value = "/store/entity/{id}", 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 unit deal object")

	public ResponseEntity<?> getUnitFocoDeal(HttpServletRequest request, @PathVariable(value = "id") long id)

			throws ProfitMandiBusinessException {

		List<FofoCatalogResponse> dealResponse = new ArrayList<>();

		List<Integer> tagIds = Arrays.asList(4);

		UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");

		if (roleManagerService.isPartner(userInfo.getRoleIds())) {

			String categoryId = "(3 OR 6)";

			RestClient rc = new RestClient();

			Map<String, String> params = new HashMap<>();

			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, " ")));

			params.put("q", StringUtils.join(mandatoryQ, " "));

			params.put("fl", "*, [child parentFilter=id:catalog*]");

			params.put("sort", "rank_i asc, create_s desc");

			params.put("wt", "json");

			String response = null;

			try {

				response = rc.get(SchemeType.HTTP, solrUrl, 8984, "solr/demo/select", params);

			} catch (HttpHostConnectException e) {

				throw new ProfitMandiBusinessException("", "", "Could not connect to host");

			}

			JSONObject solrResponseJSONObj = new JSONObject(response).getJSONObject("response");

			JSONArray docs = solrResponseJSONObj.getJSONArray("docs");

			dealResponse = getCatalogResponse(docs, false, userInfo.getRetailerId());

		} else {

			return responseSender.badRequest(

					new ProfitMandiBusinessException("Retailer id", userInfo.getUserId(), "NOT_FOFO_RETAILER"));

		}

		return responseSender.ok(dealResponse.get(0));

	}

	private Object toDealObject(JsonObject jsonObject) {

		if (jsonObject.get("dealObject") != null && jsonObject.get("dealObject").asInt() == 1) {

			return new Gson().fromJson(jsonObject.toString(), DealObjectResponse.class);

		}

		return new Gson().fromJson(jsonObject.toString(), DealsResponse.class);

	}

	@RequestMapping(value = "/store/brands", 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")

	public ResponseEntity<?> getBrands(HttpServletRequest request,

			@RequestParam(value = "category_id") String category_id) throws ProfitMandiBusinessException {

		logger.info("Request " + request.getParameterMap());

		String response = null;

		// TODO: move to properties

		String uri = ProfitMandiConstants.URL_BRANDS;

		RestClient rc = new RestClient();

		Map<String, String> params = new HashMap<>();

		params.put("category_id", category_id);

		List<DealBrands> dealBrandsResponse = null;

		try {

			response = rc.get(SchemeType.HTTP, host, port, uri, params);

		} catch (HttpHostConnectException e) {

			throw new ProfitMandiBusinessException("", "", "Could not connect to host");

		}

		dealBrandsResponse = new Gson().fromJson(response, new TypeToken<List<DealBrands>>() {

		}.getType());

		return responseSender.ok(dealBrandsResponse);

	}

	@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");

		WebListing webListing = webListingRepository.selectByUrl(listingUrl);

		webListing.setFofoCatalogResponses(getDealResponses(userInfo, webListing));

		return responseSender.ok(webListing);

	}

	@RequestMapping(value = "/store/otp/generateOTP", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)

	public ResponseEntity<?> generateOtp(HttpServletRequest request, @RequestParam String mobile) throws Exception {

		return responseSender.ok(otpProcessor.generateOtp(mobile, OtpType.REGISTRATION));

	}

	@RequestMapping(value = "/store/checkmobile/{mobile}", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)

	public ResponseEntity<?> checkRegistrationUsingMobile(HttpServletRequest request, @PathVariable String mobile)

			throws Exception {

		try {

			Customer customer = customerRepository.selectByMobileNumber(mobile);

			customer.setPasswordExist(StringUtils.isNotEmpty(customer.getPassword()));

			return responseSender.ok(new CustomerModel(true, customer));

		} catch (Exception e) {

			return responseSender.ok(new CustomerModel(false, null));

		}

	}

	@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);

		} 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());

		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();

		customer.setPassword(userModel.getPassword());

		customer.setEmailId(userModel.getEmail());

		customer.setFirstName(userModel.getFirstName());

		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 {

		UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");

		Integer storeId = userInfo.getRetailerId();

		createPendingOrderRequest.setFofoId(storeId);

		List<CreatePendingOrderItem> pendingOrderItems = createPendingOrderRequest.getCreatePendingOrderItem();

		List<CartItem> cartItems = new ArrayList<>();

		pendingOrderItems.stream().forEach(x -> {

			CartItem ci = new CartItem();

			ci.setItemId(x.getItemId());

			ci.setQuantity(x.getQuantity());

			ci.setSellingPrice(x.getSellingPrice());

			cartItems.add(ci);

		});

		CartResponse cr = this.validateCart(storeId, cartItems);

		if (cr.getCartMessageChanged() > 0 || cr.getTotalAmount() != createPendingOrderRequest.getTotalAmount()) {

			return responseSender.badRequest("Invalid request");

		}

		Map<String, String> returnMap = this.pendingOrderService.createPendingOrder(createPendingOrderRequest, cr);

		PendingOrder pendingOrder = pendingOrderRepository.selectById(Integer.parseInt(returnMap.get("poId")));

		if (offlineOrders.contains(pendingOrder.getPayMethod())) {

			Map<String, Object> emailModel = pendingOrderService.sendCreateOrderMail(pendingOrder);

			CustomRetailer customRetailer = retailerService.getFofoRetailer(pendingOrder.getFofoId());

			Customer customer = customerRepository.selectById(pendingOrder.getCustomerId());

			String[] customerEmail = null;

			if (customer.getEmailId() != null) {

				customerEmail = new String[] { customer.getEmailId() };

			}

			List<String> bccTo = Arrays.asList("kamini.sharma@smartdukaan.com", "tarun.verma@smartdukaan.com",

					"hemant.kaura@smartdukaan.com", "niranjan.kala@smartdukaan.com", "sm@smartdukaan.com",

					"tejbeer.kaur@shop2020.in", customRetailer.getEmail());

			List<String> authUserEmails = csService.getAuthUserByPartnerId(customRetailer.getPartnerId());

			if (authUserEmails != null) {

				authUserEmails = new ArrayList<>();

			}

			logger.info("authUserEmails {}", authUserEmails);

			authUserEmails.addAll(bccTo);

			StringBuffer itemBuffer = new StringBuffer();

			List<PendingOrderItem> orderItems = pendingOrderItemRepository.selectByOrderId(pendingOrder.getId());

			int totalItems = 0;

			String itemNoColor = null;

			float maxValue = 0;

			for (PendingOrderItem orderItem : orderItems) {

				if (maxValue < orderItem.getSellingPrice()) {

					maxValue = orderItem.getSellingPrice();

					itemNoColor = itemRepository.selectById(orderItem.getItemId()).getItemDescriptionNoColor();

				}

				totalItems += orderItem.getQuantity();

			}

			if (totalItems > 1) {

				itemBuffer.append(StringUtils.abbreviate(itemNoColor, 22));

				itemBuffer.append(" +").append(totalItems - 1).append(" items");

			} else {

				itemBuffer.append(StringUtils.abbreviate(itemNoColor, 30));

			}

			String message = String.format(OtpProcessor.TEMPLATE_ORDER_CREATED, pendingOrder.getId(),

					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]));

			List<String> emailIds = csService.getAuthUserIdByPartnerId(customRetailer.getPartnerId()).stream()

					.map(x -> x.getEmailId()).collect(Collectors.toList());

			emailIds.add("tarun.verma@smartdukaan.com");

			emailIds.add("tejbeer.kaur@shop2020.in");

			List<User> user = dtrUserRepository.selectAllByEmailIds(emailIds);

			List<Integer> userIds = user.stream().map(x -> x.getId()).collect(Collectors.toList());

			logger.info("userIds" + userIds);

			SendNotificationModel sendNotificationModel = new SendNotificationModel();

			sendNotificationModel.setCampaignName("Online Order Alert");

			sendNotificationModel.setTitle("Online Order Update");

			sendNotificationModel.setMessage(String.format(

					"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.setUrl("https://app.smartdukaan.com/pages/home/notifications");

			sendNotificationModel.setExpiresat(LocalDateTime.now().plusDays(1));

			sendNotificationModel.setMessageType(MessageType.notification);

			int userId = userAccountRepository.selectUserIdByRetailerId(pendingOrder.getFofoId());

			sendNotificationModel.setUserIds(Arrays.asList(userId));

			notificationService.sendNotification(sendNotificationModel);

			SendNotificationModel snm = new SendNotificationModel();

			snm.setCampaignName("Online Order Alert");

			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."));

			snm.setType("url");

			snm.setUrl("https://app.smartdukaan.com/pages/home/notifications");

			snm.setExpiresat(LocalDateTime.now().plusDays(1));

			snm.setMessageType(MessageType.notification);

			snm.setUserIds(userIds);

			notificationService.sendNotification(snm);

		}

		return responseSender.ok(returnMap);

	}

	@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")

	public ResponseEntity<?> getAddress(HttpServletRequest request) throws Exception {

		UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");

		Integer storeId = userInfo.getRetailerId();

		CustomRetailer customRetailer = retailerService.getFofoRetailer(storeId);

		return responseSender.ok(customRetailer.getAddress());

	}

	@RequestMapping(value = "/store/address/{pincode}", 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")

	public ResponseEntity<?> getStoresByPincode(HttpServletRequest request, @PathVariable String pincode)

			throws Exception {

		List<PincodePartner> pincodePartners = pincodePartnerRepository.selectPartnersByPincode(pincode);

		int fofoId = ProfitMandiConstants.DEFAULT_STORE;

		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) {

				fofoId = fofoStores.get(0).getId();

			}

		}

		return responseSender.ok(fofoStoreRepository.selectByRetailerId(fofoId).getCode());

	}

	@RequestMapping(value = "/store/address/detail/{pincode}", 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")

	public ResponseEntity<?> getStoresDetailsByPincode(HttpServletRequest request, @PathVariable String pincode)

			throws Exception {

		List<CustomRetailer> customerRetailers = new ArrayList<>();

		List<PincodePartner> pincodePartners = pincodePartnerRepository.selectPartnersByPincode(pincode);

		if (!pincodePartners.isEmpty()) {

			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> customerRetailerMap = retailerService.getFofoRetailers(activefofoIds);

			customerRetailers.addAll(customerRetailerMap.values());

		}

		logger.info("customerRetailers" + customerRetailers);

		return responseSender.ok(customerRetailers);

	}

	@RequestMapping(value = "/store/order", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)

	public ResponseEntity<?> getOrderDetail(HttpServletRequest request, @RequestParam(value = "id") int id,

			@RequestParam(name = "offset") int offset, @RequestParam(name = "limit") int limit) throws Exception {

		List<CustomerOrderDetail> customerOrderDetails = new ArrayList<>();

		List<Integer> catalogIds = new ArrayList<>();

		List<PendingOrder> pendingOrders = pendingOrderRepository.selectByCustomerId(id, offset, limit);

		if (!pendingOrders.isEmpty()) {

			for (PendingOrder po : pendingOrders) {

				List<PendingOrderItem> pois = pendingOrderItemRepository.selectByOrderId(po.getId());

				for (PendingOrderItem pendingOrderItem : pois) {

					Item item = itemRepository.selectById(pendingOrderItem.getItemId());

					pendingOrderItem.setItemName(item.getItemDescription());

					catalogIds.add(item.getCatalogItemId());

				}

				Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);

				for (PendingOrderItem poi : pois) {

					CustomerOrderDetail customerOrderDetail = new CustomerOrderDetail();

					Item item = itemRepository.selectById(poi.getItemId());

					JSONObject jsonObj = contentMap.get(item.getCatalogItemId());

					customerOrderDetail.setImageUrl(jsonObj.getString("imageUrl_s"));

					customerOrderDetail.setBrand(item.getBrand());

					customerOrderDetail.setColor(item.getColor());

					customerOrderDetail.setPendingOrderItemId(poi.getId());

					customerOrderDetail.setId(poi.getOrderId());

					customerOrderDetail.setItemId(poi.getItemId());

					customerOrderDetail.setModelName(item.getModelName());

					customerOrderDetail.setModelNumber(item.getModelNumber());

					customerOrderDetail.setQuantity(poi.getQuantity());

					customerOrderDetail.setBilledTimestamp(poi.getBilledTimestamp());

					customerOrderDetail.setStatus(poi.getStatus());

					customerOrderDetail.setTotalPrice(poi.getSellingPrice());

					customerOrderDetail.setPayMethod(po.getPayMethod());

					customerOrderDetail.setCreatedTimeStamp(po.getCreateTimestamp());

					customerOrderDetails.add(customerOrderDetail);

				}

			}

		}

		return responseSender.ok(customerOrderDetails);

	}

	@RequestMapping(value = "/store/listing", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)

	public ResponseEntity<?> getStoresListing(HttpServletRequest request) throws Exception {

		List<WebListing> webListings = webListingRepository.selectAllWebListing(Optional.of(true));

		UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");

		for (WebListing webListing : webListings) {

			webListing.setFofoCatalogResponses(getDealResponses(userInfo, webListing));

		}

		return responseSender.ok(webListings);

	}

	private List<FofoCatalogResponse> getDealResponses(UserInfo userInfo, WebListing webListing)

			throws ProfitMandiBusinessException {

		List<Integer> webProducts = webProductListingRepository.selectAllByWebListingId(webListing.getId()).stream()

				.filter(x -> x.getRank() > 0).map(x -> x.getEntityId()).collect(Collectors.toList());

		if (webProducts.size() == 0) {

			return new ArrayList<>();

		}

		RestClient rc = new RestClient();

		Map<String, String> params = new HashMap<>();

		List<String> mandatoryQ = new ArrayList<>();

		mandatoryQ.add(String.format(

				"+{!parent which=\"catalogId_i:" + StringUtils.join(webProducts, " ") + "\"} tagId_i:(%s)",

				StringUtils.join(TAG_IDS, " ")));

		params.put("q", StringUtils.join(mandatoryQ, " "));

		params.put("fl", "*, [child parentFilter=id:catalog*]");

		// params.put("sort", "create_s desc");

		params.put("start", String.valueOf(0));

		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);

		} catch (HttpHostConnectException e) {

			throw new ProfitMandiBusinessException("", "", "Could not connect to host");

		}

		JSONObject solrResponseJSONObj = new JSONObject(response).getJSONObject("response");

		JSONArray docs = solrResponseJSONObj.getJSONArray("docs");

		List<FofoCatalogResponse> dealResponse = getCatalogResponse(docs, false, userInfo.getRetailerId());

		return dealResponse;

	}

	@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") })

	@ApiOperation(value = "Get brand list and count for category")

	public ResponseEntity<?> cart(HttpServletRequest request, @RequestBody AddCartRequest cartRequest)

			throws Exception {

		UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");

		Integer storeId = userInfo.getRetailerId();

		ValidateCartResponse vc = new ValidateCartResponse(this.validateCart(storeId, cartRequest.getCartItems()),

				"Success", "Items added to cart successfully");

		return responseSender.ok(vc);

	}

	// Validate Cart for B2C Customers

	private CartResponse validateCart(int storeId, List<CartItem> cartItems) throws Exception {

		cartItems = cartItems.stream().filter(x -> x.getQuantity() > 0).collect(Collectors.toList());

		List<Integer> itemIds = cartItems.stream().map(x -> x.getItemId()).collect(Collectors.toList());

		Map<Integer, AvailabilityModel> inventoryItemAvailabilityMap = inventoryService.getStoreAndOurStock(storeId,

				itemIds);

		CartResponse cartResponse = new CartResponse();

		List<CartItemResponseModel> cartItemResponseModels = new ArrayList<>();

		cartResponse.setCartItems(cartItemResponseModels);

		Set<Integer> itemsIdsSet = new HashSet<>(itemIds);

		logger.info("Store Id {}, Item Ids {}", storeId, itemsIdsSet);

		Map<Integer, Item> itemsMap = itemRepository.selectByIds(itemsIdsSet).stream()

				.collect(Collectors.toMap(x -> x.getId(), x -> x));

		Map<Integer, TagListing> tagListingMap = tagListingRepository

				.selectByItemIdsAndTagIds(new HashSet<>(itemIds), new HashSet<>(Arrays.asList(4))).stream()

				.collect(Collectors.toMap(x -> x.getItemId(), x -> x));

		List<Integer> catalogIds = itemsMap.values().stream().map(x -> x.getCatalogItemId())

				.collect(Collectors.toList());

		Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);

		// cartResponse.getCartItems()

		int cartMessageChanged = 0;

		int cartMessageOOS = 0;

		int totalAmount = 0;

		int totalQty = 0;

		for (CartItem cartItem : cartItems) {

			Item item = itemsMap.get(cartItem.getItemId());

			TagListing tagListing = tagListingMap.get(cartItem.getItemId());

			Float cashback = schemeService.getItemSchemeCashBack().get(cartItem.getItemId());

			cashback = cashback == null ? 0 : cashback;

			float itemSellingPrice = tagListing.getMop() - cashback;

			CartItemResponseModel cartItemResponseModel = new CartItemResponseModel();

			cartItemResponseModel.setSellingPrice(cartItem.getSellingPrice());

			if (itemSellingPrice != cartItem.getSellingPrice()) {

				cartItemResponseModel.setSellingPrice(itemSellingPrice);

				cartMessageChanged++;

			}

			int estimate = -2;

			LocalDateTime promiseDeliveryTime = LocalDateTime.now();

			int qtyRequired = (int) cartItem.getQuantity();

			AvailabilityModel availabilityModel = inventoryItemAvailabilityMap.get(cartItem.getItemId());

			cartItemResponseModel.setMaxQuantity(availabilityModel.getMaxAvailability());

			if (availabilityModel.getStoreAvailability() >= qtyRequired) {

				estimate = 0;

			} else if (availabilityModel.getWarehouseAvailability() >= qtyRequired) {

				estimate = 2;

			} else if (availabilityModel.getStoreAvailability() > 0) {

				estimate = 0;

				qtyRequired = availabilityModel.getStoreAvailability();

				cartMessageChanged++;

			} else if (availabilityModel.getWarehouseAvailability() > 0) {

				qtyRequired = availabilityModel.getWarehouseAvailability();

				estimate = 2;

				cartMessageChanged++;

			} else {

				qtyRequired = 0;

				cartMessageChanged++;

			}

			cartItemResponseModel.setQuantity(qtyRequired);

			if (estimate >= 0 && LocalTime.now().isAfter(CUTOFF_TIME)) {

				estimate = estimate + 1;

				promiseDeliveryTime = promiseDeliveryTime.plusDays(3);

			}

			totalQty += qtyRequired;

			totalAmount += qtyRequired * itemSellingPrice;

			cartItemResponseModel.setEstimate(estimate);

			cartItemResponseModel.setTitle(item.getItemDescriptionNoColor());

			cartItemResponseModel.setItemId(cartItem.getItemId());

			cartItemResponseModel.setMinBuyQuantity(1);

			cartItemResponseModel.setQuantity(qtyRequired);

			cartItemResponseModel.setQuantityStep(1);

			cartItemResponseModel.setPromiseDelivery(promiseDeliveryTime);

			cartItemResponseModel.setMaxQuantity(availabilityModel.getMaxAvailability());

			cartItemResponseModel.setCatalogItemId(item.getCatalogItemId());

			cartItemResponseModel.setImageUrl(contentMap.get(item.getCatalogItemId()).getString("imageUrl_s"));

			cartItemResponseModel.setColor(item.getColor());

			cartItemResponseModels.add(cartItemResponseModel);

		}

		cartResponse.setCartItems(cartItemResponseModels);

		cartResponse.setCartMessageChanged(cartMessageChanged);

		cartResponse.setCartMessageOOS(cartMessageOOS);

		int maxEstimate = cartItemResponseModels.stream().mapToInt(x -> x.getEstimate()).max().getAsInt();

		cartResponse.setMaxEstimate(maxEstimate);

		cartResponse.setTotalAmount(totalAmount);

		cartResponse.setTotalQty(totalQty);

		return cartResponse;

	}

	@RequestMapping(value = "/store/partnerStock", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)

	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 {

		List<FofoCatalogResponse> dealResponse = new ArrayList<>();

		UserInfo userInfo = (UserInfo) request.getAttribute("userInfo");

		FofoStore fs = fofoStoreRepository.selectByRetailerId(userInfo.getRetailerId());

		sort = "w" + fs.getWarehouseId() + "_i desc";

		dealResponse = this.getCatalogResponse(

				commonSolrService.getSolrDocs(queryTerm, categoryId, offset, limit, sort, brand, subCategoryId, false),

				false, userInfo.getRetailerId());

		return responseSender.ok(dealResponse);

	}

	private List<FofoCatalogResponse> getCatalogResponse(JSONArray docs, boolean hotDeal, int fofoId)

			throws ProfitMandiBusinessException {

		Map<Integer, Integer> ourItemAvailabilityMap = null;

		Map<Integer, Integer> partnerStockAvailabilityMap = null;

		List<FofoCatalogResponse> dealResponse = new ArrayList<>();

		List<Integer> tagIds = Arrays.asList(4);

		if (docs.length() > 0) {

			HashSet<Integer> itemsSet = new HashSet<>();

			for (int i = 0; i < docs.length(); i++) {

				JSONObject doc = docs.getJSONObject(i);

				if (doc.has("_childDocuments_")) {

					for (int j = 0; j < doc.getJSONArray("_childDocuments_").length(); j++) {

						JSONObject childItem = doc.getJSONArray("_childDocuments_").getJSONObject(j);

						int itemId = childItem.getInt("itemId_i");

						itemsSet.add(itemId);

					}

				}

			}

			if (itemsSet.size() == 0) {

				return dealResponse;

			}

			if (fofoId > 0) {

				partnerStockAvailabilityMap = currentInventorySnapshotRepository.selectItemsStock(fofoId).stream()

						.collect(Collectors.toMap(x -> x.getItemId(), x -> x.getAvailability()));

			}

			ourItemAvailabilityMap = saholicInventoryService.getTotalAvailabilityByItemIds(new ArrayList<>(itemsSet));

		}

		for (int i = 0; i < docs.length(); i++) {

			Map<Integer, FofoAvailabilityInfo> fofoAvailabilityInfoMap = new HashMap<>();

			JSONObject doc = docs.getJSONObject(i);

			FofoCatalogResponse ffdr = new FofoCatalogResponse();

			ffdr.setCatalogId(doc.getInt("catalogId_i"));

			ffdr.setImageUrl(doc.getString("imageUrl_s"));

			ffdr.setTitle(doc.getString("title_s"));

			List<WebOffer> webOffers = webOfferRepository.selectAllActiveOffers().get(ffdr.getCatalogId());

			if (webOffers != null && webOffers.size() > 0) {

				ffdr.setOffers(webOffers.stream().map(x -> x.getSmallText()).collect(Collectors.toList()));

			}

			try {

				ffdr.setFeature(doc.getString("feature_s"));

			} catch (Exception e) {

				ffdr.setFeature(null);

			}

			ffdr.setBrand(doc.getJSONArray("brand_ss").getString(0));

			if (doc.has("_childDocuments_")) {

				for (int j = 0; j < doc.getJSONArray("_childDocuments_").length(); j++) {

					JSONObject childItem = doc.getJSONArray("_childDocuments_").getJSONObject(j);

					int itemId = childItem.getInt("itemId_i");

					float sellingPrice = (float) childItem.getDouble("sellingPrice_f");

					if (fofoAvailabilityInfoMap.containsKey(itemId)) {

						if (fofoAvailabilityInfoMap.get(itemId).getSellingPrice() > sellingPrice) {

							fofoAvailabilityInfoMap.get(itemId).setSellingPrice(sellingPrice);

							fofoAvailabilityInfoMap.get(itemId).setMop((float) childItem.getDouble("mop_f"));

						}

					} else {

						FofoAvailabilityInfo fdi = new FofoAvailabilityInfo();

						fdi.setSellingPrice(sellingPrice);

						fdi.setMrp(childItem.getDouble("mrp_f"));

						fdi.setMop((float) childItem.getDouble("mop_f"));

						fdi.setColor(childItem.has("color_s") ? childItem.getString("color_s") : "");

						fdi.setTagId(childItem.getInt("tagId_i"));

						fdi.setItem_id(itemId);

						Float cashBack = schemeService.getItemSchemeCashBack().get(itemId);

						cashBack = cashBack == null ? 0 : cashBack;

						// TODO:Dont commit

						// fdi.setCashback(Math.min(100, fdi.getMop()));

						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));

						fdi.setActive(partnerAvailability > 0);

						fdi.setAvailability(Math.min(5, ourStockAvailability + partnerAvailability));

						fdi.setQuantityStep(1);

						fdi.setMaxQuantity(fdi.getAvailability());

						fofoAvailabilityInfoMap.put(itemId, fdi);

					}

				}

			}

			if (fofoAvailabilityInfoMap.values().size() > 0) {

				ffdr.setItems(fofoAvailabilityInfoMap.values().stream()

						.sorted(Comparator.comparing(FofoAvailabilityInfo::isActive, Comparator.reverseOrder())

								.thenComparingInt(y -> -y.getAvailability()))

						.collect(Collectors.toList()));

				dealResponse.add(ffdr);

			}

		}

		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());

	}

	@GetMapping(value = "store/order-status/{pendingOrderId}")

	public ResponseEntity<?> orderStatus(HttpServletRequest request, @PathVariable int pendingOrderId)

			throws Exception {

		PendingOrder pendingOrder = pendingOrderRepository.selectById(pendingOrderId);

		List<PendingOrderItem> pendingOrderItems = pendingOrderItemRepository.selectByOrderId(pendingOrder.getId());

		List<Integer> catalogIds = new ArrayList<>();

		for (PendingOrderItem pendingOrderItem : pendingOrderItems) {

			Item item = itemRepository.selectById(pendingOrderItem.getItemId());

			pendingOrderItem.setItemName(item.getItemDescription());

			catalogIds.add(item.getCatalogItemId());

		}

		Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);

		for (PendingOrderItem pendingOrderItem : pendingOrderItems) {

			Item item = itemRepository.selectById(pendingOrderItem.getItemId());

			JSONObject jsonObj = contentMap.get(item.getCatalogItemId());

			pendingOrderItem.setImgUrl(jsonObj.getString("imageUrl_s"));

		}

		pendingOrder.setPendingOrderItems(pendingOrderItems);

		return responseSender.ok(pendingOrder);

	}

	@RequestMapping(value = "/store/addresses/{customerId}", method = RequestMethod.GET)

	public ResponseEntity<?> getAll(HttpServletRequest request, @PathVariable int customerId) throws Throwable {

		return responseSender.ok(customerAddressRepository.selectByActiveCustomerId(customerId));

	}

	@RequestMapping(value = "/store/address", method = RequestMethod.POST)

	public ResponseEntity<?> addAddress(HttpServletRequest request, @RequestBody CustomerAddress customerAddress)

			throws Throwable {

		customerAddressRepository.persist(customerAddress);

		return responseSender.ok(customerAddress);

	}

	@RequestMapping(value = "/store/deactivateCustomerAddress", method = RequestMethod.POST)

	public ResponseEntity<?> deactivateAddresss(HttpServletRequest request, @RequestParam int id) throws Throwable {

		CustomerAddress cust = customerAddressRepository.selectById(id);

		cust.setActive(false);

		return responseSender.ok(cust);

	}

	@RequestMapping(value = "/store/updateCustomer", method = RequestMethod.POST)

	public ResponseEntity<?> updateCustomerProfile(HttpServletRequest request, @RequestBody Customer customer)

			throws Throwable {

		Customer cust = customerRepository.selectById(customer.getId());

		cust.setGender(customer.getGender());

		cust.setProfileImageId(customer.getProfileImageId());

		cust.setDob(customer.getDob());

		return responseSender.ok(cust);

	}

	@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 {

		logger.info("Store code {}", storeCode);

		Map<String, Integer> map = retailerService.getStoreCodeRetailerMap();

		logger.info("retailer id {}", map.get(storeCode));

		String retailerName = retailerService.getAllFofoRetailers().get(map.get(storeCode)).getBusinessName();

		String html = partnerIndexService.getPartnerIndexHtml();

		logger.info("html {}", html);

		html = html.replace("Buy Mobiles and Accessories at exciting prices - SmartDukaan",

				String.format("%s is now ONLINE. Buy Mobiles, Accessories & more | SmartDukaan", retailerName));

		response.getWriter().write(html);

	}

	@RequestMapping(value = "/cancelPendingOrderItem", method = RequestMethod.POST)

	public ResponseEntity<?> cancelPendingOrderItem(HttpServletRequest request, @RequestParam int id,

			@RequestParam String statusDescription, @RequestParam String reason) throws Exception {

		PendingOrderItem pendingOrderItem = pendingOrderItemRepository.selectById(id);

		PendingOrder pendingOrder = pendingOrderRepository.selectById(pendingOrderItem.getOrderId());

		Customer customer = customerRepository.selectById(pendingOrder.getCustomerId());

		if (pendingOrderItem.getBilledTimestamp() == null) {

			pendingOrderItem.setStatus(OrderStatus.CANCELLED);

			pendingOrderItem.setRemark(reason);

			pendingOrderItem.setStatusDescription("cancel by self");

			pendingOrderItem.setCancelledTimestamp(LocalDateTime.now());

			List<OrderStatus> status = pendingOrderItemRepository.selectByOrderId(pendingOrderItem.getOrderId())

					.stream().map(x -> x.getStatus()).collect(Collectors.toList());

			if (!status.contains(OrderStatus.PENDING) && !status.contains(OrderStatus.PROCESSING)

					&& !status.contains(OrderStatus.BILLED) && !status.contains(OrderStatus.UNSETTLED)

					&& !status.contains(OrderStatus.CLAIMED)) {

				pendingOrder.setStatus(OrderStatus.CLOSED);

			}

			pendingOrderItemRepository.persist(pendingOrderItem);

			String itemDescription = itemRepository.selectById(pendingOrderItem.getItemId()).getItemDescription();

			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());

			List<Integer> catalogIds = new ArrayList<>();

			Item item = itemRepository.selectById(pendingOrderItem.getItemId());

			pendingOrderItem.setItemName(item.getItemDescription());

			catalogIds.add(item.getCatalogItemId());

			Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);

			JSONObject jsonObj = contentMap.get(item.getCatalogItemId());

			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);

	}

}

class UserModel {

	@JsonProperty(required = true)