Subversion Repositories SmartDukaan

Rev

Rev 34240 | Rev 34250 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 34240 Rev 34249
Line 1... Line 1...
1
package com.spice.profitmandi.dao.service;
1
package com.spice.profitmandi.dao.service;
2
 
2
 
3
import com.spice.profitmandi.dao.model.purchaseSaleRatio.CatalogAgedModel;
3
import com.spice.profitmandi.dao.model.purchaseSaleRatio.CatalogAgedModel;
4
import com.spice.profitmandi.dao.repository.warehouse.WarehouseSupplierInvoiceRepository;
4
import com.spice.profitmandi.dao.repository.warehouse.WarehouseSupplierInvoiceRepository;
-
 
5
import com.spice.profitmandi.dao.service.loiForm.LoiFormServiceImpl;
-
 
6
import org.apache.logging.log4j.LogManager;
-
 
7
import org.apache.logging.log4j.Logger;
5
import org.springframework.beans.factory.annotation.Autowired;
8
import org.springframework.beans.factory.annotation.Autowired;
6
import org.springframework.mail.javamail.JavaMailSender;
9
import org.springframework.mail.javamail.JavaMailSender;
7
import org.springframework.mail.javamail.MimeMessageHelper;
10
import org.springframework.mail.javamail.MimeMessageHelper;
8
import org.springframework.stereotype.Service;
11
import org.springframework.stereotype.Service;
9
 
12
 
Line 16... Line 19...
16
import java.util.stream.Collectors;
19
import java.util.stream.Collectors;
17
 
20
 
18
@Service
21
@Service
19
public class PurSaleServiceImpl implements PurSaleService {
22
public class PurSaleServiceImpl implements PurSaleService {
20
 
23
 
-
 
24
    private static final Logger LOGGER = LogManager.getLogger(PurSaleServiceImpl.class);
-
 
25
 
-
 
26
 
21
    @Autowired
27
    @Autowired
22
    WarehouseSupplierInvoiceRepository warehouseSupplierInvoiceRepository;
28
    WarehouseSupplierInvoiceRepository warehouseSupplierInvoiceRepository;
23
 
29
 
24
    @Autowired
30
    @Autowired
25
    JavaMailSender mailSender;
31
    JavaMailSender mailSender;
26
 
32
 
27
    @Override
33
    @Override
28
    public void sendPursaleRatioReportOnMail() throws MessagingException, UnsupportedEncodingException {
34
    public void sendPursaleRatioReportOnMail() throws MessagingException, UnsupportedEncodingException {
29
        StringBuilder sb = new StringBuilder();
35
        StringBuilder sb = new StringBuilder();
30
        sb.append("<html><body><b>Stock List whose age is more then 10 days(Purchase sale Range 3 months)</b>" + "<br/><table style='border:1px solid black ;padding: 5px ;bgColor=green'>");
36
        sb.append("<html><body><b>Stock List whose age is more then 10 days(Past 3 months Range)</b>" + "<br/><table style='border:1px solid black ;padding: 5px ;bgColor=green'>");
31
        sb.append("<tbody>" +
37
        sb.append("<tbody>" +
32
                "<tr>" +
38
                "<tr>" +
33
                "<th style='border:1px solid black;padding: 5px'>No.</th>" +
39
                "<th style='border:1px solid black;padding: 5px'>No.</th>" +
34
                "<th style='border:1px solid black;padding: 5px'>Brand</th>" +
40
                "<th style='border:1px solid black;padding: 5px'>Brand</th>" +
35
                "<th style='border:1px solid black;padding: 5px'>Vendor</th>" +
41
                "<th style='border:1px solid black;padding: 5px'>Vendor</th>" +
Line 80... Line 86...
80
    @Override
86
    @Override
81
    public List<CatalogAgedModel> getMoreThen10DaysAgedCatalogModels() {
87
    public List<CatalogAgedModel> getMoreThen10DaysAgedCatalogModels() {
82
        List<CatalogAgedModel> fiterCatalogAgedModels =
88
        List<CatalogAgedModel> fiterCatalogAgedModels =
83
                warehouseSupplierInvoiceRepository.selectCatalogAge(LocalDateTime.now().minusMonths(3), LocalDateTime.now(), null, 0, null)
89
                warehouseSupplierInvoiceRepository.selectCatalogAge(LocalDateTime.now().minusMonths(3), LocalDateTime.now(), null, 0, null)
84
                        .stream().filter(x -> x.getAge() > 10 && x.getUnsold() > 0).collect(Collectors.toList());
90
                        .stream().filter(x -> x.getAge() > 10 && x.getUnsold() > 0).collect(Collectors.toList());
-
 
91
        LOGGER.info("fiterCatalogAgedModels - "+fiterCatalogAgedModels);
85
        return fiterCatalogAgedModels;
92
        return fiterCatalogAgedModels;
86
    }
93
    }
87
//    192.168.0.16:8080
94
//    192.168.0.16:8080
88
}
95
}