| Line 1323... |
Line 1323... |
| 1323 |
|
1323 |
|
| 1324 |
FofoStore fs = fofoStoreRepository.selectByRetailerId(fofoDetails.getFofoId());
|
1324 |
FofoStore fs = fofoStoreRepository.selectByRetailerId(fofoDetails.getFofoId());
|
| 1325 |
List<FocoSaleReportModel> focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoDetails.getFofoId(),
|
1325 |
List<FocoSaleReportModel> focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoDetails.getFofoId(),
|
| 1326 |
fs.getCode(), startDate.atStartOfDay(), endDate.atStartOfDay());
|
1326 |
fs.getCode(), startDate.atStartOfDay(), endDate.atStartOfDay());
|
| 1327 |
LOGGER.info("FocoSaleReportList {}", focoSaleReportList);
|
1327 |
LOGGER.info("FocoSaleReportList {}", focoSaleReportList);
|
| - |
|
1328 |
DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy HH:mm");
|
| 1328 |
|
1329 |
|
| 1329 |
for (FocoSaleReportModel fsr : focoSaleReportList) {
|
1330 |
for (FocoSaleReportModel fsr : focoSaleReportList) {
|
| 1330 |
|
1331 |
|
| 1331 |
rows.add(Arrays.asList(fsr.getCode(), fsr.getName(), fsr.getCity(), fsr.getState(), fsr.getRegion(),
|
1332 |
rows.add(Arrays.asList(fsr.getCode(), fsr.getName(), fsr.getCity(), fsr.getState(), fsr.getRegion(),
|
| 1332 |
fsr.getItemId(), fsr.getBrand(), fsr.getModelName(), fsr.getModelNumber(), fsr.getColor(),
|
1333 |
fsr.getItemId(), fsr.getBrand(), fsr.getModelName(), fsr.getModelNumber(), fsr.getColor(),
|
| 1333 |
fsr.getQuantity(), fsr.getDp(), fsr.getSellingPrice(), fsr.getMop(), fsr.getSerialNumber(),
|
1334 |
fsr.getQuantity(), fsr.getDp(), fsr.getSellingPrice(), fsr.getMop(), fsr.getSerialNumber(),
|
| 1334 |
fsr.getCreateDate(), fsr.getCustomerName(), fsr.getCustomerPhone(), fsr.getCustomerCity(),
|
1335 |
fsr.getCreateDate().format(dateTimeFormatter), fsr.getCustomerName(), fsr.getCustomerPhone(), fsr.getCustomerCity(),
|
| 1335 |
fsr.getCustomerPincode(), fsr.getInvoiceNumber(), fsr.getPurchaseReference(),
|
1336 |
fsr.getCustomerPincode(), fsr.getInvoiceNumber(), fsr.getPurchaseReference(),
|
| 1336 |
fsr.getCustomerGstNumber(), fsr.getCancelledTimestamp(), fsr.getGrnCompleteDate(),
|
1337 |
fsr.getCustomerGstNumber(), fsr.getCancelledTimestamp().format(dateTimeFormatter), fsr.getGrnCompleteDate().format(dateTimeFormatter),
|
| 1337 |
fsr.getHygieneRating(), fsr.getRating(), fsr.getStatus(), fsr.getRemark(),
|
1338 |
fsr.getHygieneRating(), fsr.getRating(), fsr.getStatus(), fsr.getRemark(),
|
| 1338 |
fsr.getCreatedTimestamp(), fsr.getDisposedTimestamp(), fsr.getNextTimestamp(),
|
1339 |
fsr.getCreatedTimestamp().format(dateTimeFormatter), fsr.getDisposedTimestamp().format(dateTimeFormatter), fsr.getNextTimestamp().format(dateTimeFormatter),
|
| 1339 |
fsr.getActivationTimestamp(), fsr.getActivationTimestamp(), fsr.getLabel()));
|
1340 |
fsr.getActivationTimestamp().format(dateTimeFormatter), fsr.getActivationTimestamp().format(dateTimeFormatter), fsr.getLabel()));
|
| 1340 |
|
1341 |
|
| 1341 |
}
|
1342 |
}
|
| 1342 |
|
1343 |
|
| 1343 |
org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(
|
1344 |
org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(
|
| 1344 |
Arrays.asList("Code", "Name", "City", "State", "Region", "Item Id", "Brand", "Model Name",
|
1345 |
Arrays.asList("Code", "Name", "City", "State", "Region", "Item Id", "Brand", "Model Name",
|