Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.service;

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

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

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

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

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

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

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

import com.spice.profitmandi.dao.entity.inventory.SaholicCISTable;

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

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

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

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

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

import com.spice.profitmandi.service.NotificationService;

import com.spice.profitmandi.service.order.BulkOrderService;

import com.spice.profitmandi.service.whatsapp.WhatsappMessageType;

import org.apache.logging.log4j.LogManager;

import org.apache.logging.log4j.Logger;

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

import org.springframework.stereotype.Component;

import java.time.LocalDateTime;

import java.util.*;

@Component

public class LiquidationService {

    private static final Logger LOGGER = LogManager.getLogger(LiquidationService.class);

    @Autowired

    BidRepository bidRepository;

    @Autowired

    LiquidationRepository liquidationRepository;

    @Autowired

    private ItemRepository itemRepository;

    @Autowired

    private BidService bidService;

    @Autowired

    SaholicCISTableRepository saholicCISTableRepository;

    @Autowired

    private BulkOrderService bulkOrderService;

    @Autowired

    private TagListingRepository tagListingRepository;

    @Autowired

    private NotificationService notificationService;

    public void processBids(ProfitMandiConstants.BID_CRON_ENUM type) throws Exception {

        List<Liquidation> liquidations;

        if (type.equals(ProfitMandiConstants.BID_CRON_ENUM.YESTERDAY)){

            liquidations = liquidationRepository.selectAllByEndDate(LocalDateTime.now().minusDays(1));

        } else {

            liquidations = liquidationRepository.selectAllByEndDate(LocalDateTime.now());

        }

        LOGGER.info("liquidations: {}",liquidations);

        if (liquidations.size() > 0) {

            for (Liquidation liquidation : liquidations) {

                List<Item> items = itemRepository.selectAllByCatalogItemId(liquidation.getCatalogId());

                if (items.size() > 0) {

                    long remainingQty = 0;

                    for (Item item : items) {

                        List<SaholicCISTable> saholicCISTable = saholicCISTableRepository.selectAllByItemId(item.getId());

                        remainingQty += saholicCISTable.stream().mapToInt(SaholicCISTable::getAvailability).sum();

                    }

                    List<Bid> bids = bidRepository.selectAllBidByLiquidationIdAndStatus(liquidation.getId(), Arrays.asList(ProfitMandiConstants.BID_ENUM.PENDING, ProfitMandiConstants.BID_ENUM.PROCESSING));

                    for (Bid bid : bids) {

                        if (remainingQty >= bid.getQuantity()) {

                            List<BulkOrderModel> bulkOrderModels = new ArrayList<>();

                            BulkOrderModel bulkOrderModel = new BulkOrderModel();

                            bulkOrderModel.setRowIndex(bid.getId());

                            bulkOrderModel.setFofoId(bid.getFofoId());

                            bulkOrderModel.setItemId(items.get(0).getId());

                            bulkOrderModel.setQuantity(bid.getQuantity());

                            bulkOrderModel.setDescription(items.get(0).getItemDescription());

                            bulkOrderModel.setItemPrice(bid.getBiddingAmount());

                            bulkOrderModels.add(bulkOrderModel);

                            bulkOrderService.generatePurchaseOrder(bulkOrderModels, bid.getFofoId(), ProfitMandiConstants.PO_TYPE.AUTO, type);

                            remainingQty -= bid.getQuantity();

                        } else {

                            bidService.cancelYesterdayProcessBid(bid);

                        }

                    }

                    if (remainingQty <= 0) bidService.sendSummaryMailToUserAndManagers(liquidation.getCreatedBy(), bids, liquidation);

                    liquidation.setQuantity((int) remainingQty);

                    liquidation.setStatus(ProfitMandiConstants.LIQUIDATION_ENUM.CLOSED);

                }

            }

        }

    }

    public void consolidatedBiddingMessage() throws Exception {

        List<Liquidation> liquidations = liquidationRepository.selectAllByStatus(ProfitMandiConstants.LIQUIDATION_ENUM.PUBLISHED);

        LOGGER.info("consolidatedBiddingMessage liquidations: {}",liquidations);

        if (liquidations.size() > 0) {

            StringBuilder message = new StringBuilder("*Bidding Update!*\n" +

                    "Place your best bids and unlock unbeatable price on smartphones!\n");

            //StringBuilder templateMessage = new StringBuilder("bidd_live");

            for (Liquidation liquidation : liquidations) {

                List<Item> items = itemRepository.selectAllByCatalogItemId(liquidation.getCatalogId());

                List<Bid> bids = bidRepository.selectBidByLiquidationId(liquidation.getId());

                if (items.size() > 0) {

                    long remainingQty = 0;

                    for (Item item : items) {

                        List<SaholicCISTable> saholicCISTable = saholicCISTableRepository.selectAllByItemId(item.getId());

                        remainingQty += saholicCISTable.stream().mapToInt(SaholicCISTable::getAvailability).sum();

                    }

                    TagListing tagListing = tagListingRepository.selectByItemId(items.get(0).getId());

                    liquidation.setQuantity((int) remainingQty);

                    if (liquidation.getQuantity() > 0){

                        double mrp = tagListing.getMrp();

                        double discountPercentage = ((mrp - liquidation.getPrice()) / mrp) * 100;

                        message.append("\n")

                            .append("*").append(items.get(0).getItemDescription())

                            .append(" at ").append(Math.round(discountPercentage)).append("% Off*\n")

                            .append("Starting price: *").append(liquidation.getPrice()).append("*\n");

                        if (bids.size() > 0) {

                            message.append("Top Bid: *").append(bids.get(0).getBiddingAmount()).append("*\n");

                        }

                        message.append("Ending on: *").append(StringUtils.toLocalDateTime(liquidation.getEndDate().toString())).append("*\n");

                        //templateMessage.append("|").append(items.get(0).getItemDescription()).append("|").append(liquidation.getPrice()).append("|").append(StringUtils.toLocalDateTime(liquidation.getEndDate().toString()));

                    }

                }

            }

            message.append("\nDon't miss out. Submit your bid now and grab the deal before it's gone!");

            LOGGER.info("templateMessage : {}",message.toString());

            bidService.biddingLiveNotification(message.toString(), "https://images.smartdukaan.com/uploads/whatsapp.jpeg");

            //notificationService.sendWhatsappMessage(message, "Bidding Live Now!", "8529003611");

            //notificationService.sendWhatsappMediaMessage(message.toString(), "8529003611", "https://images.smartdukaan.com/uploads/whatsapp.jpeg","whatsapp.jpeg", WhatsappMessageType.IMAGE);

        }

    }

}