WebSVN – SmartDukaan – Diff – /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/OfferController.java

 import com.spice.profitmandi.common.enumuration.MessageType;
 import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
 import com.spice.profitmandi.common.model.CustomRetailer;
 import com.spice.profitmandi.common.model.ProfitMandiConstants;
 import com.spice.profitmandi.common.model.SendNotificationModel;
-import com.spice.profitmandi.common.util.FileUtil;
 import com.spice.profitmandi.common.util.FormattingUtils;
 import com.spice.profitmandi.common.web.util.ResponseSender;
 import com.spice.profitmandi.dao.entity.catalog.Offer;
 import com.spice.profitmandi.dao.entity.fofo.PartnerType;
 import com.spice.profitmandi.dao.enumuration.catalog.ItemCriteriaType;
 import com.spice.profitmandi.dao.enumuration.catalog.OfferSchemeType;
 import com.spice.profitmandi.dao.model.CreateOfferRequest;
-import com.spice.profitmandi.dao.model.OfferRowModel;
 import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
 import com.spice.profitmandi.dao.repository.catalog.OfferMarginRepository;
 import com.spice.profitmandi.dao.repository.catalog.OfferPartnerRepository;
 import com.spice.profitmandi.dao.repository.catalog.OfferRepository;
 import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
+    }
     @RequestMapping(value = "/offerDownload", method = RequestMethod.GET)
     public ResponseEntity<?> dowloadOfferSummary(HttpServletRequest request, @RequestParam int offerId, Model model)
             throws Exception {
-        List<List<?>> listOfRows = new ArrayList<>();
         final HttpHeaders headers = new HttpHeaders();
         headers.set("Content-Type", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
         headers.set("Content-disposition", "inline; filename=offer-" + offerId + ".csv");
         CreateOfferRequest createOfferRequest = offerService.getOffer(0, offerId);
-        Collection<OfferRowModel> offerRowModels = offerRepository.getOfferRows(createOfferRequest);
+        ByteArrayOutputStream baos = offerService.createCSVOfferReport(createOfferRequest);
-        ByteArrayOutputStream baos = null;
-        if (createOfferRequest.getSchemeType().equals(OfferSchemeType.SELLIN)) {
-            for (OfferRowModel offerRowModel : offerRowModels) {
-                CustomRetailer customRetailer = retailerService.getFofoRetailer(offerRowModel.getFofoId());
-                listOfRows.add(Arrays.asList(createOfferRequest.getId(), createOfferRequest.getName(),
-                        createOfferRequest.getTargetType(), createOfferRequest.getSchemeType(),
-                        createOfferRequest.getBrandShareTerms(), createOfferRequest.getSellinPercentage(),
-                        "--", createOfferRequest.getItemCriteriaString(),
-                        createOfferRequest.getStartDate(), createOfferRequest.getEndDate(),
-                        createOfferRequest.getCreatedOn(), customRetailer.getPartnerId(), customRetailer.getBusinessName(),
-                        customRetailer.getCode(), offerRowModel.getTotalBasePurchaseValue(), offerRowModel.getAchievedTarget(),
-                        offerRowModel.getPayoutPurchaseValue(), offerRowModel.getPayout(), offerRowModel.getPayoutType(), offerRowModel.getFinalPayout(), String.join(", ", offerRowModel.getEligibleImeis())));
-            }
-            baos = FileUtil.getCSVByteStream(
-                    Arrays.asList("Id", "Name", "Target Type", "Scheme Type", "Brand %", "Sellin %", "Partner Criteria",
-                            "Item Criteria", "Start", "End", "Created", "Partner Id", "Partner Name", "Partner Code",
-                            "Base Purchase", "Achieved Target", "Eligible Purchase", "Slab Amount", "Slab Amount Type", "Payout Value(Rs.)",
-                            "Eligible IMEIs", "Billing Pending Imeis"
-                    ), listOfRows);
-        } else {
-            for (OfferRowModel offerRowModel : offerRowModels) {
-                CustomRetailer customRetailer = retailerService.getFofoRetailer(offerRowModel.getFofoId());
-                listOfRows.add(Arrays.asList(createOfferRequest.getId(), createOfferRequest.getName(),
-                        createOfferRequest.getTargetType(), createOfferRequest.getSchemeType(),
-                        createOfferRequest.getBrandShareTerms(), createOfferRequest.getSellinPercentage(),
-                        createOfferRequest.getPartnerCriteriaString(), createOfferRequest.getItemCriteriaString(),
-                        createOfferRequest.getStartDate(), createOfferRequest.getEndDate(),
-                        createOfferRequest.getCreatedOn(), customRetailer.getPartnerId(), customRetailer.getBusinessName(),
-                        customRetailer.getCode(),
-                        offerRowModel.getTotalSale(),
-                        offerRowModel.getEligibleSale(),
-                        offerRowModel.getPayoutTargetAchieved(),
-                        offerRowModel.getPayoutValue(),
-                        offerRowModel.getPayoutType(),
-                        offerRowModel.getPayoutValueDp(), offerRowModel.getFinalPayout(),
-                        String.join(", ", offerRowModel.getEligibleImeis()),
-                        String.join(", ", offerRowModel.getBaseCriteria()))
-                );
-            }
-            baos = FileUtil.getCSVByteStream(
-                    Arrays.asList("Id", "Name", "Target Type", "Scheme Type", "Brand %", "Sellin %", "Partner Criteria",
-                            "Item Criteria", "Start", "End", "Created", "Partner Id", "Partner Name", "Partner Code",
-                            "Total Value",
-                            "Eligible Value",
-                            "Payout Target Achieved", "Payout Amount", "Payout Amount Type",
-                            "Payout Value DP", "Amount to be credited", "Eligible Activated Imeis"
-                    ), listOfRows);
-        }
         final InputStream inputStream = new ByteArrayInputStream(baos.toByteArray());
         final InputStreamResource inputStreamResource = new InputStreamResource(inputStream);
         return new ResponseEntity<>(inputStreamResource, headers, HttpStatus.OK);
+    }
     @RequestMapping(value = "/offerById", method = RequestMethod.GET)
     public String offerById(HttpServletRequest request, int offerId, Model model) throws ProfitMandiBusinessException {
         Offer offer = offerRepository.selectById(offerId);
         model.addAttribute("offer", offer);
         return "offer-edit";
+    }
     @RequestMapping(value = "/published-offers/{yearMonth}", method = RequestMethod.GET)

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/OfferController.java – Rev 33713 → 33999