Subversion Repositories SmartDukaan

Rev

Rev 34263 | Rev 34275 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

package com.spice.profitmandi.dao.service;

import com.spice.profitmandi.dao.model.purchaseSaleRatio.CatalogAgedModel;
import com.spice.profitmandi.dao.repository.warehouse.WarehouseSupplierInvoiceRepository;
import com.spice.profitmandi.dao.service.loiForm.LoiFormServiceImpl;
import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.mail.javamail.JavaMailSender;
import org.springframework.mail.javamail.MimeMessageHelper;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.mail.MessagingException;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;
import java.io.UnsupportedEncodingException;
import java.time.LocalDateTime;
import java.util.List;
import java.util.stream.Collectors;

@Service
@Transactional(rollbackFor = Throwable.class)
public class PurSaleServiceImpl implements PurSaleService {

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


    @Autowired
    WarehouseSupplierInvoiceRepository warehouseSupplierInvoiceRepository;

    @Autowired
    JavaMailSender mailSender;

    @Override
    public void sendPurSaleRatioReportOnMail() throws MessagingException, UnsupportedEncodingException {
        StringBuilder sb = new StringBuilder();
        sb.append("<html><body><b>Stock List whose age is 10 or more days (Past 3 months Range)</b>" + "<br/><table style='border:1px solid black ;padding: 5px ;bgColor=green'>");
        sb.append("<tbody>" +
                "<tr>" +
                "<th style='border:1px solid black;padding: 5px'>No.</th>" +
                "<th style='border:1px solid black;padding: 5px'>Brand</th>" +
                "<th style='border:1px solid black;padding: 5px'>Vendor</th>" +
                "<th style='border:1px solid black;padding: 5px'>Category</th>" +
                "<th style='border:1px solid black;padding: 5px'>Model</th>" +
                "<th style='border:1px solid black;padding: 5px'>Purchase</th>" +
                "<th style='border:1px solid black;padding: 5px'>Sold</th>" +
                "<th style='border:1px solid black;padding: 5px'>Unsold</th>" +
                "<th style='border:1px solid black;padding: 5px'>Age</th>" +

                "</tr>");
        List<CatalogAgedModel> moreThen10DaysAgedCatalogModels = getMoreThen10DaysAgedCatalogModels();

        int i = 1;
        for (CatalogAgedModel catalogAgedModel : moreThen10DaysAgedCatalogModels) {
            sb.append("<tr>");
            sb.append("<td style='border:1px solid black;padding: 5px'>" + (i++) + "</td>");
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getBrand() + "</td>");
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getSupplier() + "</td>");
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getStatus() + "</td>");
            if(catalogAgedModel.getBrand().equals("Samsung")){
                sb.append("<td style='border:1px solid black;padding: 5px'>" +catalogAgedModel.getModel() + "</td>");
            }else{
                sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getModelName() + "</td>");
            }
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getPurchase() + "</td>");
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getSold() + "</td>");
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getUnsold() + "</td>");
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getAge() + "</td>");
            sb.append("</tr>");

        }
        String subject = "Age more than 10 days Stock Report";
        String messageText = sb.toString();
        MimeMessage message = mailSender.createMimeMessage();
        MimeMessageHelper helper = new MimeMessageHelper(message, true);
        String[] emailTo = {
                "sm@smartdukaan.com",
                "tarun.verma@smartdukaan.com",
                "mohit.gulati@smartdukaan.com",
                "tejus.lohani@smartdukaan.com"

        };
        helper.setSubject(subject);
        helper.setText(messageText, true);
        helper.setTo(emailTo);
        InternetAddress senderAddress = new InternetAddress("noreply@smartdukaan.com", "Smartdukaan Alerts");
        helper.setFrom(senderAddress);
        mailSender.send(message);

    }

    @Override
    public List<CatalogAgedModel> getMoreThen10DaysAgedCatalogModels() {
        List<CatalogAgedModel> fiterCatalogAgedModels =
                warehouseSupplierInvoiceRepository.selectCatalogAge(LocalDateTime.now().minusMonths(3), LocalDateTime.now(), null, 0, null)
                        .stream().filter(x -> x.getAge() >= 10 && x.getUnsold() > 0).collect(Collectors.toList());
        LOGGER.info("fiterCatalogAgedModels - "+fiterCatalogAgedModels);
        return fiterCatalogAgedModels;
    }
//    192.168.0.16:8080
}