| Line 4... |
Line 4... |
| 4 |
import com.spice.profitmandi.common.enumuration.SearchType;
|
4 |
import com.spice.profitmandi.common.enumuration.SearchType;
|
| 5 |
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
|
5 |
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
|
| 6 |
import com.spice.profitmandi.common.model.*;
|
6 |
import com.spice.profitmandi.common.model.*;
|
| 7 |
import com.spice.profitmandi.common.solr.SolrService;
|
7 |
import com.spice.profitmandi.common.solr.SolrService;
|
| 8 |
import com.spice.profitmandi.common.util.FileUtil;
|
8 |
import com.spice.profitmandi.common.util.FileUtil;
|
| - |
|
9 |
import com.spice.profitmandi.common.util.FormattingUtils;
|
| 9 |
import com.spice.profitmandi.common.util.PdfUtils;
|
10 |
import com.spice.profitmandi.common.util.PdfUtils;
|
| 10 |
import com.spice.profitmandi.common.util.StringUtils;
|
11 |
import com.spice.profitmandi.common.util.StringUtils;
|
| 11 |
import com.spice.profitmandi.common.web.util.ResponseSender;
|
12 |
import com.spice.profitmandi.common.web.util.ResponseSender;
|
| 12 |
import com.spice.profitmandi.dao.entity.catalog.Item;
|
13 |
import com.spice.profitmandi.dao.entity.catalog.Item;
|
| 13 |
import com.spice.profitmandi.dao.entity.catalog.TagListing;
|
14 |
import com.spice.profitmandi.dao.entity.catalog.TagListing;
|
| Line 1324... |
Line 1325... |
| 1324 |
|
1325 |
|
| 1325 |
FofoStore fs = fofoStoreRepository.selectByRetailerId(fofoDetails.getFofoId());
|
1326 |
FofoStore fs = fofoStoreRepository.selectByRetailerId(fofoDetails.getFofoId());
|
| 1326 |
List<FocoSaleReportModel> focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoDetails.getFofoId(),
|
1327 |
List<FocoSaleReportModel> focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoDetails.getFofoId(),
|
| 1327 |
fs.getCode(), startDate.atStartOfDay(), endDate.atStartOfDay());
|
1328 |
fs.getCode(), startDate.atStartOfDay(), endDate.atStartOfDay());
|
| 1328 |
LOGGER.info("FocoSaleReportList {}", focoSaleReportList);
|
1329 |
LOGGER.info("FocoSaleReportList {}", focoSaleReportList);
|
| 1329 |
DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy HH:mm");
|
- |
|
| 1330 |
|
1330 |
|
| 1331 |
for (FocoSaleReportModel fsr : focoSaleReportList) {
|
1331 |
for (FocoSaleReportModel fsr : focoSaleReportList) {
|
| 1332 |
|
1332 |
|
| 1333 |
rows.add(Arrays.asList(fsr.getCode(), fsr.getName(), fsr.getCity(), fsr.getState(), fsr.getRegion(),
|
1333 |
rows.add(Arrays.asList(fsr.getCode(), fsr.getName(), fsr.getCity(), fsr.getState(), fsr.getRegion(),
|
| 1334 |
fsr.getItemId(), fsr.getBrand(), fsr.getModelName(), fsr.getModelNumber(), fsr.getColor(),
|
1334 |
fsr.getItemId(), fsr.getBrand(), fsr.getModelName(), fsr.getModelNumber(), fsr.getColor(),
|
| 1335 |
fsr.getQuantity(), fsr.getDp(), fsr.getSellingPrice(), fsr.getMop(), fsr.getSerialNumber(),
|
1335 |
fsr.getQuantity(), fsr.getDp(), fsr.getSellingPrice(), fsr.getMop(), fsr.getSerialNumber(),
|
| 1336 |
fsr.getCreateDate().format(dateTimeFormatter), fsr.getCustomerName(), fsr.getCustomerPhone(),
|
1336 |
FormattingUtils.format(fsr.getCreateDate()), fsr.getCustomerName(), fsr.getCustomerPhone(),
|
| 1337 |
fsr.getCustomerCity(), fsr.getCustomerPincode(), fsr.getInvoiceNumber(), fsr.getPurchaseReference(),
|
1337 |
fsr.getCustomerCity(), fsr.getCustomerPincode(), fsr.getInvoiceNumber(), fsr.getPurchaseReference(),
|
| 1338 |
fsr.getCustomerGstNumber(), dateTimeFormatter.format(fsr.getCancelledTimestamp()),
|
1338 |
fsr.getCustomerGstNumber(), FormattingUtils.format(fsr.getCancelledTimestamp()),
|
| 1339 |
dateTimeFormatter.format(fsr.getGrnCompleteDate()), fsr.getHygieneRating(), fsr.getRating(),
|
1339 |
FormattingUtils.format(fsr.getGrnCompleteDate()), fsr.getHygieneRating(), fsr.getRating(),
|
| 1340 |
fsr.getStatus(), fsr.getRemark(), dateTimeFormatter.format(fsr.getCreatedTimestamp()),
|
1340 |
fsr.getStatus(), fsr.getRemark(), FormattingUtils.format(fsr.getCreatedTimestamp()),
|
| 1341 |
dateTimeFormatter.format(fsr.getDisposedTimestamp()),
|
1341 |
FormattingUtils.format(fsr.getDisposedTimestamp()),
|
| 1342 |
dateTimeFormatter.format(fsr.getNextTimestamp()),
|
1342 |
FormattingUtils.format(fsr.getNextTimestamp()),
|
| 1343 |
dateTimeFormatter.format(fsr.getActivationTimestamp()),
|
1343 |
FormattingUtils.format(fsr.getActivationTimestamp()),
|
| 1344 |
dateTimeFormatter.format(fsr.getActivationTimestamp()), fsr.getLabel()));
|
1344 |
FormattingUtils.format(fsr.getActivationTimestamp()), fsr.getLabel()));
|
| 1345 |
|
1345 |
|
| 1346 |
}
|
1346 |
}
|
| 1347 |
|
1347 |
|
| 1348 |
org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(
|
1348 |
org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(
|
| 1349 |
Arrays.asList("Code", "Name", "City", "State", "Region", "Item Id", "Brand", "Model Name",
|
1349 |
Arrays.asList("Code", "Name", "City", "State", "Region", "Item Id", "Brand", "Model Name",
|