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

 import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
 import com.spice.profitmandi.common.model.*;
 import com.spice.profitmandi.common.web.util.ResponseSender;
 import com.spice.profitmandi.dao.entity.auth.AuthUser;
 import com.spice.profitmandi.dao.entity.catalog.Item;
+import com.spice.profitmandi.dao.entity.catalog.Scheme;
 import com.spice.profitmandi.dao.entity.catalog.TagListing;
 import com.spice.profitmandi.dao.entity.cs.Position;
 import com.spice.profitmandi.dao.entity.cs.TicketAssigned;
 import com.spice.profitmandi.dao.entity.dtr.Document;
 import com.spice.profitmandi.dao.entity.dtr.NotificationCampaign;
 import com.spice.profitmandi.service.PartnerInvestmentService;
 import com.spice.profitmandi.service.PartnerStatsService;
 import com.spice.profitmandi.service.authentication.RoleManager;
 import com.spice.profitmandi.service.inventory.InventoryService;
 import com.spice.profitmandi.service.offers.OfferService;
+import com.spice.profitmandi.service.scheme.SchemeService;
 import com.spice.profitmandi.service.transaction.TransactionService;
 import com.spice.profitmandi.service.user.RetailerService;
 import com.spice.profitmandi.web.model.LoginDetails;
 import com.spice.profitmandi.web.util.CookiesProcessor;
 import com.spice.profitmandi.web.util.MVCResponseSender;
         model.addAttribute("monthSales", monthSaleMap);
         return "monthSales";
+    }
+    @Autowired
+    SchemeService schemeService;
     @RequestMapping(value = "/dashboard", method = RequestMethod.GET)
     public String dashboard(HttpServletRequest request, Model model) throws Exception {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         String email = loginDetails.getEmailId();
         int fofoId = loginDetails.getFofoId();
                 LocalDateTime currentMonthEnd = currentMonthStart.withDayOfMonth(1);
                 LOGGER.info("lastMonthStart" + lastMonthStart);
                 LOGGER.info("currentMonthEnd" + currentMonthEnd);
+                Scheme staticScheme = schemeService.getStaticScheme(fofoId);
+                double schemeAchievement = 0;
+                String schemeCategory = null;
+                if (staticScheme != null) {
+                    schemeAchievement = orderRepository.selectBillingDatesBetweenSumGroupByRetailerId(staticScheme.getStartDateTime(), staticScheme.getEndDateTime()).get(fofoId);
+                    if (staticScheme.getTarget() >= 2500000 && staticScheme.getTarget() < 3750000) {
+                        schemeCategory = "SD Club";
+                    } else if (staticScheme.getTarget() < 5000000) {
+                        schemeCategory = "Silver";
+                    } else if (staticScheme.getTarget() < 7500000) {
+                        schemeCategory = "Gold - 1";
+                    } else if (staticScheme.getTarget() < 10000000) {
+                        schemeCategory = "Gold - 2";
+                    } else if (staticScheme.getTarget() < 12500000) {
+                        schemeCategory = "Diamond";
+                    } else {
+                        schemeCategory = "Platinum";
+                    }
+                }
                 model.addAttribute("countOrder", countOrder);
                 model.addAttribute("onlineDeliveredOrderSum", onlineDeliveredOrderSum.getSellingPrice());
                 PartnerType partnerType = partnerTypeChangeService.getTypeOnDate(fofoStore.getId(), LocalDate.now());
                 model.addAttribute("partnerType", partnerType);
                 Map<Integer, Double> accesoriesmtdsale = fofoOrderRepository.selectSumSaleGroupByFofoIdsForMobileOrAccessories(loginDetails.getFofoId(), curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), Optional.of(false));
                 Double accesoriesStock = currentInventorySnapshotRepository.selectSumStockGroupByFofoIdsForMobileOrAccessories(loginDetails.getFofoId(), Optional.of(false)).get(loginDetails.getFofoId());
                 model.addAttribute("accesoriesStock", String.format("%.0f", accesoriesStock));
+                model.addAttribute("staticScheme", staticScheme);
+                model.addAttribute("schemeCategory", schemeCategory);
+                model.addAttribute("schemeAchievement", schemeAchievement);
                 model.addAttribute("brandStockPrices", fofoUser.getBrandStockPrices(loginDetails.getFofoId(), false));
                 model.addAttribute("salesMap", fofoUser.getSales(loginDetails.getFofoId()));
                 ChartModel cm = fofoUser.getBrandChart(loginDetails.getFofoId());
                 LOGGER.info("chartMap" + gson.toJson(cm));
                 model.addAttribute("month", 0);
                 model.addAttribute("hygienePercentage", (hygieneCount * 100) / (invalidHygieneCount + hygieneCount));
                 model.addAttribute("monthDays", LocalDate.now().minusDays(1).lengthOfMonth());
                 model.addAttribute("dayOfMonth", LocalDate.now().minusDays(1).getDayOfMonth());
+            } catch (
-            } catch (ProfitMandiBusinessException e) {
+                    ProfitMandiBusinessException e) {
                 LOGGER.error("FofoStore Code not found of fofoId {}", loginDetails.getFofoId());
+            }
             return "dashboard1";
+        }
     @Autowired
     OfferPayoutRepository offerPayoutRepository;
     @RequestMapping(value = "/partnerTotalIncomeByMonth/{yearMonth}", method = RequestMethod.GET)
-    public String getPartnerTotalIncomeByMonth(HttpServletRequest request, @PathVariable int yearMonth, Model model) throws Exception {
+    public String getPartnerTotalIncomeByMonth(HttpServletRequest request, @PathVariable int yearMonth, Model
+            model) throws Exception {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         long pendingIncome = 0;
         long partnerPurchaseIn = 0;
         long partnerCreditedSale = 0;
         return "partner-total-income";
+    }
     @RequestMapping(value = "/getMonthsInvestment", method = RequestMethod.GET)
+    public String getMonthsInvestment(HttpServletRequest request,
-    public String getMonthsInvestment(HttpServletRequest request, @RequestParam(name = "month", required = true, defaultValue = "0") int month, Model model) throws Exception {
+                                      @RequestParam(name = "month", required = true, defaultValue = "0") int month, Model model) throws Exception {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         int fofoId = loginDetails.getFofoId();
         Map<String, Object> investment = fofoUser.getInvestmentsMonths(fofoId, month);
         LocalDateTime currentMonthStart = LocalDateTime.now().withDayOfMonth(1);
         return "bar_chart";
+    }
     @RequestMapping(value = "/getPriceDropDetails", method = RequestMethod.GET)
-    public String getPriceDropDetails(HttpServletRequest request, @RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId, @RequestParam(name = "brand", required = true, defaultValue = "0") String brand, @RequestParam(name = "yearMonth", required = false, defaultValue = "0") String yearMonth, Model model) throws Exception {
+    public String getPriceDropDetails(HttpServletRequest request,
+                                      @RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId,
+                                      @RequestParam(name = "brand", required = true, defaultValue = "0") String brand,
+                                      @RequestParam(name = "yearMonth", required = false, defaultValue = "0") String yearMonth, Model model) throws
+            Exception {
         LOGGER.info("params" + fofoId + brand + yearMonth);
         List<PriceDropWithDetailsByYearMonthModel> priceDropdetailsList = priceDropRepository.selectBrandPendingPriceDropWithDetailsByYearMonth(fofoId, brand, yearMonth);
         return "price-drop-details";
+    }
     @RequestMapping(value = "/getPriceDropDetailSixMonths", method = RequestMethod.GET)
-    public String getPriceDropDetailSixMonths(HttpServletRequest request, @RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId, @RequestParam(name = "brand", required = true, defaultValue = "0") String brand, Model model) throws Exception {
+    public String getPriceDropDetailSixMonths(HttpServletRequest request,
+                                              @RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId,
+                                              @RequestParam(name = "brand", required = true, defaultValue = "0") String brand, Model model) throws
+            Exception {
         LOGGER.info("params" + fofoId + brand);
         LocalDateTime curDate = LocalDate.now().atStartOfDay();
         LocalDateTime startfMonthSixMonth = curDate.withDayOfMonth(1).minusMonths(12);
         LocalDateTime endMonthTotal = curDate.withDayOfMonth(1).minusMonths(6);
         model.addAttribute("fofoId", fofoId);
         return "activation-tabular";
+    }
     @RequestMapping(value = "/getMonthlyActivationItemDetail", method = RequestMethod.GET)
-    public String getMonthlyActivationItemDetail(HttpServletRequest request, @RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId, @RequestParam(name = "brand", required = true, defaultValue = "0") String brand, @RequestParam(name = "yearMonth", required = false, defaultValue = "0") String yearMonth, Model model) throws Exception {
+    public String getMonthlyActivationItemDetail(HttpServletRequest request,
+                                                 @RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId,
+                                                 @RequestParam(name = "brand", required = true, defaultValue = "0") String brand,
+                                                 @RequestParam(name = "yearMonth", required = false, defaultValue = "0") String yearMonth, Model model) throws
+            Exception {
         LOGGER.info("params" + fofoId + brand + yearMonth);
         List<ActivationItemDetailModel> activationItemDetails = schemeInOutRepository.selectBrandPendingActivationItemDetails(fofoId, brand, yearMonth);
         return "activation-pending-item-details";
+    }
     @RequestMapping(value = "/getMonthlyActivationBeforeSixMonthsItemDetail", method = RequestMethod.GET)
-    public String getMonthlyActivationItemDetail(HttpServletRequest request, @RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId, @RequestParam(name = "brand", required = true, defaultValue = "0") String brand, Model model) throws Exception {
+    public String getMonthlyActivationItemDetail(HttpServletRequest request,
+                                                 @RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId,
+                                                 @RequestParam(name = "brand", required = true, defaultValue = "0") String brand, Model model) throws
+            Exception {
         LocalDateTime curDate = LocalDate.now().atStartOfDay();
         LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(6);
         List<ActivationItemDetailModel> activationItemDetails = schemeInOutRepository.selectBrandPendingActivationItemDetailByYearMonth(fofoId, brand, startOfMonth);
         return "upgrade-offer-tabular";
+    }
     @RequestMapping(value = "/getMonthlyUpgradeOfferItemDetail", method = RequestMethod.GET)
-    public String getMonthlyUpgradeOfferItemDetail(HttpServletRequest request, @RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId, @RequestParam(name = "brand", required = true, defaultValue = "0") String brand, @RequestParam(name = "yearMonth", required = false, defaultValue = "0") String yearMonth, Model model) throws Exception {
+    public String getMonthlyUpgradeOfferItemDetail(HttpServletRequest request,
+                                                   @RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId,
+                                                   @RequestParam(name = "brand", required = true, defaultValue = "0") String brand,
+                                                   @RequestParam(name = "yearMonth", required = false, defaultValue = "0") String yearMonth, Model model) throws
+            Exception {
         LOGGER.info("params" + fofoId + brand + yearMonth);
         List<UpgradeOfferItemDetailModel> offerItems = samsungUpgradeOfferRepository.selectUpgradeOfferItemDetails(fofoId, UpgradeOfferStatus.approved, brand, yearMonth);
         model.addAttribute("offerItems", offerItems);
         return "upgrade-offer-item-detail";
+    }
     @RequestMapping(value = "/getUpgradeOfferBeforeSixMonthItemDetail", method = RequestMethod.GET)
-    public String getUpgradeOfferBeforeSixMonthItemDetail(HttpServletRequest request, @RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId, @RequestParam(name = "brand", required = true, defaultValue = "0") String brand, Model model) throws Exception {
+    public String getUpgradeOfferBeforeSixMonthItemDetail(HttpServletRequest request,
+                                                          @RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId,
+                                                          @RequestParam(name = "brand", required = true, defaultValue = "0") String brand, Model model) throws
+            Exception {
         LocalDateTime curDate = LocalDate.now().atStartOfDay();
         LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(6);
         List<UpgradeOfferItemDetailModel> offerItems = samsungUpgradeOfferRepository.selectUpgradeOfferItemDetailByYearMonth(fofoId, UpgradeOfferStatus.approved, brand, startOfMonth);
         return "upgrade-offer-item-detail";
+    }
     @RequestMapping(value = "/getAuthUserPartners", method = RequestMethod.GET)
-    public String AuthUserPartnersDetail(HttpServletRequest request, Model model, @RequestParam int authId) throws Exception {
+    public String AuthUserPartnersDetail(HttpServletRequest request, Model model, @RequestParam int authId) throws
+            Exception {
         Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
         Map<Integer, CustomRetailer> fofoIdAndPartnerMap = retailerService.getFofoRetailers(false);
         Map<Integer, PartnerDetailModel> fofoIdAndallValues = partnerStatsService.getAllPartnerStats();
         return "auth_user_partner_detail";
+    }
     @RequestMapping(value = "/getWarehousePartners", method = RequestMethod.GET)
-    public String warehousePartnersDetail(HttpServletRequest request, Model model, @RequestParam int warehouseId) throws Exception {
+    public String warehousePartnersDetail(HttpServletRequest request, Model model, @RequestParam int warehouseId) throws
+            Exception {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         String email = loginDetails.getEmailId();
         Set<Integer> authfofoIds = new HashSet<>();
         authfofoIds = csService1.getAuthFofoIds(email, true);
         return "auth_user_partner_detail";
+    }
     @RequestMapping(value = "/getWarehouseWiseBrandStock", method = RequestMethod.GET)
-    public String getWarehouseWiseBrandStock(HttpServletRequest request, Model model, @RequestParam List<Integer> warehouseId) throws Exception {
+    public String getWarehouseWiseBrandStock(HttpServletRequest request, Model
+            model, @RequestParam List<Integer> warehouseId) throws Exception {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         String email = loginDetails.getEmailId();
         Set<Integer> authfofoIds = csService1.getAuthFofoIds(email, true);
         Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository.selectActivePartnersByRetailerIds(new ArrayList<>(authfofoIds)).stream().collect(Collectors.groupingBy(
                 FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));
         model.addAttribute("response1", mvcResponseSender.createResponseString(true));
         return "response";
+    }
     @RequestMapping(value = "/getWarehouseWiseBrandAndCategory", method = RequestMethod.GET)
+    public String getWarehouseWiseBrandAndCategory(HttpServletRequest request, Model
-    public String getWarehouseWiseBrandAndCategory(HttpServletRequest request, Model model, @RequestParam List<Integer> warehouseId, @RequestParam List<String> brands, @RequestParam String category) throws Exception {
+            model, @RequestParam List<Integer> warehouseId, @RequestParam List<String> brands, @RequestParam String
+                                                           category) throws Exception {
         Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
         List<String> listbrands = saholicInventoryCISRepository.selectAllBrand();
         List<String> listCategory = saholicInventoryCISRepository.selectAllSubCategory();
         return "warehouse_brand_item_stock";
+    }
     @RequestMapping(value = "/getWarehouseWiseItemStock", method = RequestMethod.GET)
+    public String getWarehouseWiseItemStock(HttpServletRequest request, Model
-    public String getWarehouseWiseItemStock(HttpServletRequest request, Model model, @RequestParam List<Integer> warehouseId, @RequestParam List<String> brands, @RequestParam String category) throws Exception {
+            model, @RequestParam List<Integer> warehouseId, @RequestParam List<String> brands, @RequestParam String
+                                                    category) throws Exception {
         Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
         if (warehouseId.contains(0)) {
             warehouseId.addAll(warehouseMap.keySet());
+        }
         List<WarehouseWiseitemStockModel> warehouseWiseItemStock = saholicInventoryCISRepository.selectWarehouseItemStock(warehouseId, brands, category);
         model.addAttribute("warehouseMap", warehouseMap);
         return "warehouse_item_details";
+    }
     @RequestMapping(value = "/getWarehouseWiseBrandPartnerSale", method = RequestMethod.GET)
-    public String getWarehouseWiseBrandPartnerSale(HttpServletRequest request, Model model, @RequestParam String brand) throws Exception {
+    public String getWarehouseWiseBrandPartnerSale(HttpServletRequest request, Model
+            model, @RequestParam String brand) throws Exception {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         String email = loginDetails.getEmailId();
         Set<Integer> authfofoIds = csService1.getAuthFofoIds(email, true);
         model.addAttribute("selectedbrand", brand);
         return "warehousewise_brand_partners_sale";
+    }
     @RequestMapping(value = "/getWarehouseWiseAccesoriesBrandPartnerSale", method = RequestMethod.GET)
-    public String getWarehouseWiseAccesoriesBrandPartnerSale(HttpServletRequest request, Model model, @RequestParam String brand) throws Exception {
+    public String getWarehouseWiseAccesoriesBrandPartnerSale(HttpServletRequest request, Model
+            model, @RequestParam String brand) throws Exception {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         String email = loginDetails.getEmailId();
         Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
         Set<Integer> authfofoIds = storeGuyMap.get(email);
         model.addAttribute("selectedbrand", brand);
         return "warehousewise_accessoriesbrand_sale";
+    }
     @RequestMapping(value = "/getWarehouseBrandWiseItemSale", method = RequestMethod.GET)
+    public String getWarehouseBrandWiseItemSale(HttpServletRequest request, Model
-    public String getWarehouseBrandWiseItemSale(HttpServletRequest request, Model model, @RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {
+            model, @RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {
         Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         String email = loginDetails.getEmailId();
         Set<Integer> authfofoIds = csService1.getAuthFofoIds(email, true);
         Map<Integer, WarehouseBrandWiseItemSaleModel> branditemSalesMap = fofoStoreRepository.selectWarehouseBrandItemSale(warehouseId, brand, new ArrayList<>(authfofoIds)).stream().collect(Collectors.toMap(x -> x.getItemId(), x -> x));
         model.addAttribute("warehouseMap", warehouseMap);
         return "warehouse_partner_itemwise_sale";
+    }
     @RequestMapping(value = "/getWarehouseAccesoriesBrandWiseItemSale", method = RequestMethod.GET)
+    public String getWarehouseAccesoriesBrandWiseItemSale(HttpServletRequest request, Model
-    public String getWarehouseAccesoriesBrandWiseItemSale(HttpServletRequest request, Model model, @RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {
+            model, @RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {
         Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         String email = loginDetails.getEmailId();
         Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
         Set<Integer> authfofoIds = storeGuyMap.get(email);
         model.addAttribute("appContextPath", request.getContextPath());
         return "contact-us";
+    }
     @RequestMapping(value = "/notifications", method = RequestMethod.GET)
-    public String getNotificationsWithType(HttpServletRequest request, @RequestParam(required = false) MessageType messageType, @RequestParam(name = "offset", defaultValue = "0") int offset, @RequestParam(name = "limit", defaultValue = "20") int limit, Model model) throws Exception {
+    public String getNotificationsWithType(HttpServletRequest
+                                                   request, @RequestParam(required = false) MessageType messageType,
+                                           @RequestParam(name = "offset", defaultValue = "0") int offset,
+                                           @RequestParam(name = "limit", defaultValue = "20") int limit, Model model) throws Exception {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         int userId = 0;
         boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
         if (isAdmin) {
             userId = loginDetails.getFofoId();
         LOGGER.info("notifications" + notifications);
         return "notification-template";
+    }
     @RequestMapping(value = "/notifyDocument/documentId", method = RequestMethod.GET)
+    public ResponseEntity<?> retailerDocumentById(HttpServletRequest request,
-    public ResponseEntity<?> retailerDocumentById(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.DOCUMENT_ID) int documentId, @RequestParam int cid) throws ProfitMandiBusinessException {
+                                                  @RequestParam(name = ProfitMandiConstants.DOCUMENT_ID) int documentId, @RequestParam int cid) throws
+            ProfitMandiBusinessException {
         Document document = documentRepository.selectById(documentId);
         NotificationCampaign nc = notificationCampaignRepository.selectById(cid);
         if (nc.getDocumentId() == null) {
             throw new ProfitMandiBusinessException("cid", nc.getId(), "not available");
+        }
+        }
         return responseSender.ok(document);
+    }
     @RequestMapping(value = "/notifyDocument/download", method = RequestMethod.GET)
-    public ResponseEntity<?> downloadRetailerDocument(HttpServletRequest request, @RequestParam int cid, Model model) throws ProfitMandiBusinessException {
+    public ResponseEntity<?> downloadRetailerDocument(HttpServletRequest request, @RequestParam int cid, Model
+            model) throws ProfitMandiBusinessException {
         NotificationCampaign nc = notificationCampaignRepository.selectById(cid);
         if (nc.getDocumentId() == null) {
             throw new ProfitMandiBusinessException("cid", nc.getId(), "not available");
             file = new FileInputStream(document.getPath() + File.separator + document.getName());
         } catch (FileNotFoundException e) {
             LOGGER.error("Retailer Document file not found : ", e);
             throw new ProfitMandiBusinessException(ProfitMandiConstants.DOCUMENT_ID, document.getId(), "RTLR_1013");
+        }
-        // ByteArrayOutputStream byteArrayOutputStream = new
+// ByteArrayOutputStream byteArrayOutputStream = new
-        // ByteArrayOutputStream();
+// ByteArrayOutputStream();
-        // ExcelUtils.writeSchemeModels(schemeModels, byteArrayOutputStream);
+// ExcelUtils.writeSchemeModels(schemeModels, byteArrayOutputStream);
         final HttpHeaders headers = new HttpHeaders();
         String contentType = "";
         if (document.getContentType() == ContentType.JPEG) {
             contentType = "image/jpeg";
         final InputStreamResource inputStreamResource = new InputStreamResource(file);
         return new ResponseEntity<InputStreamResource>(inputStreamResource, headers, HttpStatus.OK);
+    }
     @RequestMapping(value = "/getItemWiseTertiary", method = RequestMethod.GET)
+    public String getItemWiseTertiary(HttpServletRequest request,
-    public String getItemWiseTertiary(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws ProfitMandiBusinessException {
+                                      @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws
+            ProfitMandiBusinessException {
         List<ItemWiseTertiaryModel> itemWiseTertiary = fofoOrderRepository.SelectItemWiseTertiary(fofoId);
         LOGGER.info("itemWiseTertiary" + itemWiseTertiary);
         CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
         model.addAttribute("customRetailer", customRetailer);
         model.addAttribute("itemWiseTertiary", itemWiseTertiary);
         return "item-wise-tertiary";
+    }
     @RequestMapping(value = "/getItemWiseIndent", method = RequestMethod.GET)
+    public String getItemWiseIndent(HttpServletRequest request,
-    public String getItemWiseIndent(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws ProfitMandiBusinessException {
+                                    @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws
+            ProfitMandiBusinessException {
         List<Order> unbilledOrders = transactionService.getInTransitOrders(fofoId);
         model.addAttribute("unbilledOrders", unbilledOrders);
         return "item-wise-indent";
+    }
     @RequestMapping(value = "/getPartnerInvestment", method = RequestMethod.GET)
+    public String getPartnerInvestment(HttpServletRequest request,
-    public String getPartnerInvestment(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
+                                       @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
         Map<Integer, PartnerDetailModel> partnerStats = adminUser.getPartnersStatDataFromFile();
         PartnerDetailModel partnerDetailModel = partnerStats.get(fofoId);
         CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
         model.addAttribute("partnerDetailModel", partnerDetailModel);
         model.addAttribute("customRetailer", customRetailer);
         return "partner-investment";
+    }
     @RequestMapping(value = "/getPartnerPendingIndentItem", method = RequestMethod.GET)
-    public String getPartnerPendingIndentItem(HttpServletRequest request, @RequestParam int warehouseId, @RequestParam int itemId, Model model) throws ProfitMandiBusinessException {
+    public String getPartnerPendingIndentItem(HttpServletRequest request, @RequestParam int warehouseId,
+                                              @RequestParam int itemId, Model model) throws ProfitMandiBusinessException {
         List<PartnerPendingIndentItemModel> partnerPendingIndent = fofoStoreRepository.selectPartnerPendingIndentItem(itemId, warehouseId);
         model.addAttribute("partnerPendingIndent", partnerPendingIndent);
         return "partner-pending-indent-item";
+    }
     @RequestMapping(value = "/getPatnerActivateStock", method = RequestMethod.GET)
+    public String getPartnerActivateStockItem(HttpServletRequest request,
-    public String getPartnerActivateStockItem(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
+                                              @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
         List<ActivateItemModel> activateStocks = new ArrayList<>();
         List<InventoryItem> inventoryItems = inventoryItemRepository.selectByActivatedNotSold(fofoId);
         CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
         for (InventoryItem inventoryItem : inventoryItems) {
         model.addAttribute("customRetailer", customRetailer);
         return "partner-activate-stock";
+    }
     @RequestMapping(value = "/getPatnerBrandWiseMTDSale", method = RequestMethod.GET)
+    public String getPatnerBrandWiseMTDSale(HttpServletRequest request,
-    public String getPatnerBrandWiseMTDSale(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
+                                            @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
         LocalDateTime curDate = LocalDate.now().atStartOfDay();
         CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
         Map<String, Double> brandMtdAmount = fofoOrderItemRepository.selectSumAmountGroupByBrand(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId);
         Map<String, Long> brandMtdQty = fofoOrderItemRepository.selectSumQuantityGroupByBrand(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId);
         Double accesoriesmtdsale = fofoOrderRepository.selectSumSaleGroupByFofoIdsForMobileOrAccessories(fofoId, curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), Optional.of(false)).get(fofoId);
         model.addAttribute("customRetailer", customRetailer);
         return "partner-brand-mtd-sale";
+    }
     @RequestMapping(value = "/getPatnerBrandWiseLMTDSale", method = RequestMethod.GET)
+    public String getPatnerBrandWiseLMTDSale(HttpServletRequest request,
-    public String getPatnerBrandWiseLMTDSale(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
+                                             @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
         LocalDateTime curDate = LocalDate.now().atStartOfDay();
         CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
         Map<String, Double> brandLMtdAmount = fofoOrderItemRepository.selectSumAmountGroupByBrand(
                 curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1), fofoId);
         Map<String, Long> brandLmtdQty = fofoOrderItemRepository.selectSumQuantityGroupByBrand(
         model.addAttribute("customRetailer", customRetailer);
         return "partner-brand-lmtd-sale";
+    }
     @RequestMapping(value = "/getPatnerBrandWiseLMSSale", method = RequestMethod.GET)
+    public String getPatnerBrandWiseLMSSale(HttpServletRequest request,
-    public String getPatnerBrandWiseLMSSale(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
+                                            @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
         LocalDateTime curDate = LocalDate.now().atStartOfDay();
         CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
         int lengthOfMonth = YearMonth.from(curDate.minusMonths(1)).lengthOfMonth();
         Map<String, Double> brandLMSAmount = fofoOrderItemRepository.selectSumAmountGroupByBrand(
         model.addAttribute("customRetailer", customRetailer);
         return "partner-brand-lms-sale";
+    }
     @RequestMapping(value = "/getPatnerInStock", method = RequestMethod.GET)
+    public String getPatnerInStock(HttpServletRequest request,
-    public String getPatnerInStock(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
+                                   @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
         CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
         List<InStockBrandModel> mobileStocks = currentInventorySnapshotRepository.selectSumInStockMobileGroupByBrand(fofoId);
         List<InStockBrandModel> accesStock = currentInventorySnapshotRepository.selectSumInStockAccessoriesGroupByBrand(fofoId);
         model.addAttribute("customRetailer", customRetailer);
         return "partner-instock-item";
+    }
     @RequestMapping(value = "/getOpenTicketByFofoId", method = RequestMethod.GET)
+    public String getOpenTicketByFofoId(HttpServletRequest request,
-    public String getOpenTicketByFofoId(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
+                                        @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
         Map<Integer, AuthUser> ticketIdAuthUser = new HashMap<>();
         CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
         List<Integer> ticketIds = ticketRepository.selectAllOpenTicketByRetailer(fofoId).stream().map(x -> x.getId()).collect(Collectors.toList());
         List<TicketAssigned> ticketAssigns = ticketAssignedRepository.selectByTicketIds(ticketIds);
         model.addAttribute("customRetailer", customRetailer);
         return "open-ticket";
+    }
     @RequestMapping(value = "/getPartnerSecondarySale", method = RequestMethod.GET)
+    public String getPartnerSecondarySale(HttpServletRequest request,
-    public String getPartnerSecondarySale(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, @RequestParam String timeValue, Model model) throws Exception {
+                                          @RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, @RequestParam String timeValue, Model model) throws
+            Exception {
         LocalDateTime curDate = LocalDate.now().atStartOfDay();
         CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
         int lengthOfMonth = YearMonth.from(curDate.minusMonths(1)).lengthOfMonth();
         LocalDateTime startDate = null;
         LocalDateTime endDate = null;
         model.addAttribute("accessoriesBrandSales", accessoriesBrandSales);
         return "accessories-brand-wise-report";
+    }
     @RequestMapping(value = "/getMobileLMSGraph", method = RequestMethod.GET)
-    public String getMobileLMSGraph(HttpServletRequest request, @RequestParam(required = false) int warehouseId, @RequestParam(required = false) LocalDateTime date, @RequestParam(required = false) LocalDateTime endDate, @RequestParam List<Integer> fofoIds, @RequestParam String filterType, Model model) throws Exception {
+    public String getMobileLMSGraph(HttpServletRequest request, @RequestParam(required = false) int warehouseId,
+                                    @RequestParam(required = false) LocalDateTime date, @RequestParam(required = false) LocalDateTime endDate,
+                                    @RequestParam List<Integer> fofoIds, @RequestParam String filterType, Model model) throws Exception {
         Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository.selectActivePartnersByRetailerIds(new ArrayList<>(fofoIds)).stream().collect(Collectors.groupingBy(
                 FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));
         ChartModel cm;
         if (warehouseId != 0) {
         model.addAttribute("chartMap", gson.toJson(cm));
         return "brand-wise-mobile-lms-chart";
+    }
     @RequestMapping(value = "/getMobileLMSFilter", method = RequestMethod.GET)
-    public String getMobileLMSFilter(HttpServletRequest request, @RequestParam(required = false, defaultValue = "0") int warehouseId, @RequestParam(required = false) LocalDateTime date, @RequestParam(required = false) LocalDateTime endDate, Model model) throws Exception {
+    public String getMobileLMSFilter(HttpServletRequest request,
+                                     @RequestParam(required = false, defaultValue = "0") int warehouseId,
+                                     @RequestParam(required = false) LocalDateTime date,
+                                     @RequestParam(required = false) LocalDateTime endDate, Model model) throws Exception {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         String email = loginDetails.getEmailId();
         if (date == null) {
         return "chart-filter-lms";
+    }
     @RequestMapping(value = "/getMobileLMPGraph", method = RequestMethod.GET)
-    public String getMobileLMPGraph(HttpServletRequest request, @RequestParam(required = false) int warehouseId, @RequestParam(required = false) LocalDateTime date, @RequestParam(required = false) LocalDateTime endDate, @RequestParam List<Integer> fofoIds, @RequestParam String filterType, Model model) throws Exception {
+    public String getMobileLMPGraph(HttpServletRequest request, @RequestParam(required = false) int warehouseId,
+                                    @RequestParam(required = false) LocalDateTime date, @RequestParam(required = false) LocalDateTime endDate,
+                                    @RequestParam List<Integer> fofoIds, @RequestParam String filterType, Model model) throws Exception {
         Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository.selectActivePartnersByRetailerIds(new ArrayList<>(fofoIds)).stream().collect(Collectors.groupingBy(
                 FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));
         ChartModel cm;
         if (warehouseId != 0) {
         model.addAttribute("chartMap", gson.toJson(cm));
         return "brand-wise-mobile-lmp-chart";
+    }
     @RequestMapping(value = "/getSaleCountByMilestone", method = RequestMethod.GET)
+    public String getSaleCountByMilestone(HttpServletRequest request,
-    public String getSaleCountByMilestone(HttpServletRequest request, @RequestParam(required = false, defaultValue = "0") int warehouseId, Model model) throws Exception {
+                                          @RequestParam(required = false, defaultValue = "0") int warehouseId, Model model) throws Exception {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         String email = loginDetails.getEmailId();
         Set<Integer> authFofoIds = csService1.getAuthFofoIds(email, true);
         return "sale-milestone";
+    }
     @RequestMapping(value = "/getPurchaseCountByMileStone", method = RequestMethod.GET)
+    public String getPurchaseCountByMileStone(HttpServletRequest request,
-    public String getPurchaseCountByMileStone(HttpServletRequest request, @RequestParam(required = false, defaultValue = "0") int warehouseId, Model model) throws Exception {
+                                              @RequestParam(required = false, defaultValue = "0") int warehouseId, Model model) throws Exception {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         String email = loginDetails.getEmailId();
         Set<Integer> authFofoIds = csService1.getAuthFofoIds(email, true);
         return "purchase-milestone";
+    }
     @RequestMapping(value = "/getActivatedModelWarehouseWise", method = RequestMethod.GET)
-    public String getActivatedModelWarehouseWise(HttpServletRequest request, Model model, @RequestParam String brand) throws Exception {
+    public String getActivatedModelWarehouseWise(HttpServletRequest request, Model model, @RequestParam String
+            brand) throws Exception {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         List<Integer> fofoIds = getFofoIds(loginDetails);
         List<WarehouseWiseActivatedModel> warehouseWiseActivatedModels = activatedImeiRepository.selectActivatedModelGroupByWarehouse(brand, fofoIds);
         Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
         model.addAttribute("activatedModels", activatedModels);
         return "activation-brandwise-report";
+    }
     @RequestMapping(value = "/getWarehouseBrandWiseItemActivatedModel", method = RequestMethod.GET)
+    public String getWarehouseBrandWiseItemActivatedModel(HttpServletRequest request, Model
-    public String getWarehouseBrandWiseItemActivatedModel(HttpServletRequest request, Model model, @RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {
+            model, @RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         List<Integer> fofoIds = getFofoIds(loginDetails);
         Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
         List<WarehouseBrandWiseItemActivatedModel> activatedItems = activatedImeiRepository.selectWarehouseBrandActivatedItem(warehouseId, brand, fofoIds);
+        }
         return new ArrayList<>(fofoIds);
+    }
     @RequestMapping(value = "/getMonthWiseSale", method = RequestMethod.GET)
+    public String getPartnerSaleByMonth(HttpServletRequest
-    public String getPartnerSaleByMonth(HttpServletRequest request, @RequestParam List<Integer> fofoIds, Model model) throws Exception {
+                                                request, @RequestParam List<Integer> fofoIds, Model model) throws Exception {
         YearMonth now = YearMonth.now();
         YearMonth ym = YearMonth.now().minusMonths(12);
         List<YearMonth> list = new ArrayList<>();
         while (!now.isBefore(ym)) {
         return "monthly-partner-sale";
+    }
     @RequestMapping(value = "/getMonthWisePurchase", method = RequestMethod.GET)
+    public String getMonthWisePurchase(HttpServletRequest
-    public String getMonthWisePurchase(HttpServletRequest request, @RequestParam List<Integer> fofoIds, Model model) throws Exception {
+                                               request, @RequestParam List<Integer> fofoIds, Model model) throws Exception {
         YearMonth now = YearMonth.now();
         YearMonth ym = YearMonth.now().minusMonths(12);
         List<YearMonth> list = new ArrayList<>();
         while (!now.isBefore(ym)) {

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/DashboardController.java – Rev 32206 → 32308