Subversion Repositories SmartDukaan

Rev

Rev 37037 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
23612 amit.gupta 1 
package com.spice.profitmandi.web.controller;
2 
 
3 
import com.spice.profitmandi.common.enumuration.ReporticoProject;
4 
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
33102 tejus.loha 5 
import com.spice.profitmandi.common.model.CustomRetailer;
34066 aman.kumar 6 
import com.spice.profitmandi.common.model.ProfitMandiConstants;
28106 amit.gupta 7 
import com.spice.profitmandi.common.model.ReporticoUrlInfo;
23612 amit.gupta 8 
import com.spice.profitmandi.common.services.ReporticoService;
30162 manish 9 
import com.spice.profitmandi.common.util.FileUtil;
33102 tejus.loha 10 
import com.spice.profitmandi.common.util.FormattingUtils;
34236 ranu 11 
import com.spice.profitmandi.common.util.Utils;
26298 tejbeer 12 
import com.spice.profitmandi.dao.entity.auth.AuthUser;
34066 aman.kumar 13 
import com.spice.profitmandi.dao.entity.cs.Position;
33102 tejus.loha 14 
import com.spice.profitmandi.dao.entity.fofo.FofoStore;
15 
import com.spice.profitmandi.dao.entity.fofo.PendingOrderItem;
34236 ranu 16 
import com.spice.profitmandi.dao.entity.transaction.CreditNote;
33775 ranu 17 
import com.spice.profitmandi.dao.entity.transaction.UserWallet;
18 
import com.spice.profitmandi.dao.entity.transaction.UserWalletHistory;
33102 tejus.loha 19 
import com.spice.profitmandi.dao.model.*;
26298 tejbeer 20 
import com.spice.profitmandi.dao.repository.auth.AuthRepository;
21 
import com.spice.profitmandi.dao.repository.cs.CsService;
34066 aman.kumar 22 
import com.spice.profitmandi.dao.repository.cs.PositionRepository;
28106 amit.gupta 23 
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
23784 ashik.ali 24 
import com.spice.profitmandi.dao.repository.dtr.RoleRepository;
34256 ranu 25 
import com.spice.profitmandi.dao.repository.fofo.*;
33809 ranu 26 
import com.spice.profitmandi.dao.repository.transaction.*;
23798 amit.gupta 27 
import com.spice.profitmandi.service.authentication.RoleManager;
30162 manish 28 
import com.spice.profitmandi.service.order.OrderService;
34236 ranu 29 
import com.spice.profitmandi.service.transaction.CreditNoteService;
34256 ranu 30 
import com.spice.profitmandi.service.transaction.InventoryMarginModel;
33775 ranu 31 
import com.spice.profitmandi.service.transaction.TransactionService;
33102 tejus.loha 32 
import com.spice.profitmandi.service.user.RetailerService;
33775 ranu 33 
import com.spice.profitmandi.service.wallet.WalletService;
23612 amit.gupta 34 
import com.spice.profitmandi.web.model.LoginDetails;
35 
import com.spice.profitmandi.web.util.CookiesProcessor;
33775 ranu 36 
import in.shop2020.model.v1.order.WalletReferenceType;
33092 tejus.loha 37 
import org.apache.http.HttpResponse;
38 
import org.apache.logging.log4j.LogManager;
39 
import org.apache.logging.log4j.Logger;
40 
import org.springframework.beans.factory.annotation.Autowired;
41 
import org.springframework.core.io.InputStreamResource;
42 
import org.springframework.http.HttpHeaders;
43 
import org.springframework.http.HttpStatus;
34236 ranu 44 
import org.springframework.http.MediaType;
33092 tejus.loha 45 
import org.springframework.http.ResponseEntity;
46 
import org.springframework.stereotype.Controller;
47 
import org.springframework.transaction.annotation.Transactional;
48 
import org.springframework.ui.Model;
49 
import org.springframework.web.bind.annotation.*;
23612 amit.gupta 50 
 
33092 tejus.loha 51 
import javax.servlet.http.HttpServletRequest;
52 
import java.io.IOException;
53 
import java.time.LocalDate;
54 
import java.time.LocalDateTime;
55 
import java.time.LocalTime;
34236 ranu 56 
import java.time.YearMonth;
33092 tejus.loha 57 
import java.time.format.DateTimeFormatter;
58 
import java.util.*;
33102 tejus.loha 59 
import java.util.stream.Collectors;
33092 tejus.loha 60 
 
23612 amit.gupta 61 
@Controller
26298 tejbeer 62 
@Transactional(rollbackFor = Throwable.class)
23612 amit.gupta 63 
public class ReportsController {
33143 tejus.loha 64 
    private static final Logger LOGGER = LogManager.getLogger(OrderController.class);
65 
    private static final Logger Logger = LogManager.getLogger(OrderController.class);
66 
    @Autowired
67 
    private RoleRepository roleRepository;
68 
    @Autowired
69 
    private FofoOrderRepository fofoOrderRepository;
70 
    @Autowired
71 
    private RetailerService retailerService;
72 
    @Autowired
73 
    private PendingOrderItemRepository pendingOrderItemRepository;
74 
    @Autowired
75 
    private PendingOrderService pendingOrderService;
76 
    @Autowired
77 
    private CookiesProcessor cookiesProcessor;
78 
    @Autowired
79 
    private FofoStoreRepository fofoStoreRepository;
80 
    @Autowired
81 
    private ReporticoService reporticoService;
82 
    @Autowired
83 
    private OrderRepository orderRepository;
84 
    @Autowired
85 
    private RoleManager roleManager;
86 
    @Autowired
87 
    private OrderService orderService;
88 
    @Autowired
89 
    private CsService csService;
90 
    @Autowired
91 
    private AuthRepository authRepository;
33775 ranu 92 
    @Autowired
93 
    private WalletService walletService;
94 
    @Autowired
95 
    private UserWalletHistoryRepository userWalletHistoryRepository;
96 
    @Autowired
97 
    private TransactionService transactionService;
33809 ranu 98 
    @Autowired
99 
    private LoanStatementRepository loanStatementRepository;
34066 aman.kumar 100 
    @Autowired
101 
    PositionRepository positionRepository;
26298 tejbeer 102 
 
34096 aman.kumar 103 
    @Autowired
34236 ranu 104 
    CreditNoteRepository creditNoteRepository;
105 
 
106 
    @Autowired
107 
    CreditNoteService creditNoteService;
108 
 
109 
    @Autowired
36198 amit 110 
    com.spice.profitmandi.dao.repository.transaction.EInvoiceDetailsRepository eInvoiceDetailsRepository;
111 
 
112 
    @Autowired
113 
    com.spice.profitmandi.dao.repository.transaction.CreditNoteLineRepository creditNoteLineRepository;
114 
 
115 
    @Autowired
34256 ranu 116 
    PriceDropIMEIRepository priceDropIMEIRepository;
117 
 
118 
    @Autowired
119 
    SchemeInOutRepository schemeInOutRepository;
120 
 
121 
    @Autowired
122 
    OfferPayoutRepository offerPayoutRepository;
123 
 
124 
    @Autowired
34096 aman.kumar 125 
    UserWalletRepository userWalletRepository;
33186 amit.gupta 126 
    @PostMapping(value = "/reports/{projectName}/{fileName}")
33143 tejus.loha 127 
    public ResponseEntity<?> fetchReport(HttpServletRequest request, @PathVariable String fileName,
33187 amit.gupta 128 
                                         @PathVariable ReporticoProject projectName, @RequestBody Map<String, String> paramsMap)
33143 tejus.loha 129 
            throws ProfitMandiBusinessException, UnsupportedOperationException, IOException {
130 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
131 
        HttpResponse response;
132 
        if (roleManager.isAdmin(loginDetails.getRoleIds())) {
33102 tejus.loha 133 
 
33143 tejus.loha 134 
            if (fileName.equalsIgnoreCase("LeadsReport")) {
135 
                if (paramsMap == null) {
136 
                    paramsMap = new HashMap<String, String>();
137 
                }
138 
                Map<Integer, List<Integer>> mapping = csService.getL2L1Mapping();
33102 tejus.loha 139 
 
33143 tejus.loha 140 
                AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
33102 tejus.loha 141 
 
33143 tejus.loha 142 
                List<Integer> authIds = mapping.get(authUser.getId());
143 
                if (authIds == null) {
144 
                    authIds = new ArrayList<>();
145 
                }
146 
                authIds.add(authUser.getId());
33102 tejus.loha 147 
 
33143 tejus.loha 148 
                paramsMap.put("authId", authIds + "");
149 
            }
150 
        } else {
151 
            if (paramsMap == null) {
152 
                paramsMap = new HashMap<String, String>();
153 
            }
26298 tejbeer 154 
 
33143 tejus.loha 155 
            paramsMap.put("MANUAL_fofoId", loginDetails.getFofoId() + "");
23764 amit.gupta 156 
 
33143 tejus.loha 157 
        }
158 
        response = getAdminReportFile(loginDetails.getEmailId(), projectName, fileName + ".xml", paramsMap);
159 
        HttpHeaders headers = new HttpHeaders();
160 
        InputStreamResource is = new InputStreamResource(response.getEntity().getContent());
161 
        headers.set("Content-Type", "application/vnd.ms-excel");
162 
        headers.set("Content-disposition", "inline; filename=report-" + fileName + ".csv");
163 
        headers.setContentLength(response.getEntity().getContentLength());
164 
        return new ResponseEntity<InputStreamResource>(is, headers, HttpStatus.OK);
165 
    }
26298 tejbeer 166 
 
33143 tejus.loha 167 
    private HttpResponse getAdminReportFile(String email, ReporticoProject projectName, String fileName,
168 
                                            Map<String, String> reportParams) throws ProfitMandiBusinessException, IOException {
169 
        return reporticoService.getReportFile(projectName, fileName, reportParams);
170 
    }
26298 tejbeer 171 
 
33143 tejus.loha 172 
    @RequestMapping(value = "/collectionSummary", method = RequestMethod.GET)
173 
    public String getCollectionSummary(HttpServletRequest request,
174 
                                       Model model) throws ProfitMandiBusinessException {
175 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
176 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
177 
        LocalDateTime currentDate = LocalDate.now().atStartOfDay();
178 
        LocalDateTime currentStartMonth = currentDate.minusDays(30).toLocalDate().atStartOfDay();
179 
        List<CollectionSummary> collectionSummaryList = orderRepository.selectCollectionSummary(fofoDetails.getFofoId(), currentStartMonth, currentDate);
180 
        Logger.info("CollectionSummaryList {}", collectionSummaryList);
34069 aman.kumar 181 
        boolean isRBM = false;
182 
        if (isAdmin) {
183 
            AuthUser authUser = authRepository.selectByEmailOrMobile(fofoDetails.getEmailId());
184 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
185 
            isRBM = positions.stream()
186 
                    .anyMatch(position ->
187 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
188 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
189 
            if (isRBM && pp.containsKey(authUser.getId())) {
190 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
191 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
192 
                    try {
193 
                        return retailerService.getFofoRetailers(true).get(x);
194 
                    } catch (ProfitMandiBusinessException e) {
195 
                        // TODO Auto-generated catch block
196 
                        return null;
197 
                    }
198 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
199 
                model.addAttribute("customRetailersMap", customRetailersMap);
200 
            }
34066 aman.kumar 201 
        }
202 
        model.addAttribute("isRBM", isRBM);
33143 tejus.loha 203 
        model.addAttribute("startDate", currentDate.minusDays(30).toLocalDate());
204 
        model.addAttribute("endDate", LocalDate.now());
205 
        model.addAttribute("collectionSummaryList", collectionSummaryList);
206 
        model.addAttribute("isAdmin", isAdmin);
207 
        return "partner-collection-summary";
208 
    }
26298 tejbeer 209 
 
33143 tejus.loha 210 
    @RequestMapping(value = "/collectionSummaryFetchReportByDate", method = RequestMethod.GET)
211 
    public String getcollectionSummaryFetchReport(HttpServletRequest request,
212 
                                                  @RequestParam(defaultValue = "0") int fofoId,
213 
                                                  @RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,
214 
                                                  @RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate, Model model)
215 
            throws Exception {
216 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
217 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
218 
        if (isAdmin) {
219 
            startDate = LocalDate.now().minusDays(30);
220 
            endDate = LocalDate.now();
221 
        }
34069 aman.kumar 222 
        boolean isRBM = false;
223 
        if (isAdmin) {
34096 aman.kumar 224 
            AuthUser authUser = authRepository.selectByEmailOrMobile(fofoDetails.getEmailId());
225 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 226 
            isRBM = positions.stream()
34096 aman.kumar 227 
                    .anyMatch(position ->
228 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
229 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 230 
            if (isRBM && pp.containsKey(authUser.getId())) {
34096 aman.kumar 231 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
232 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
233 
                    try {
234 
                        return retailerService.getFofoRetailers(true).get(x);
235 
                    } catch (ProfitMandiBusinessException e) {
236 
                        // TODO Auto-generated catch block
237 
                        return null;
238 
                    }
239 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
240 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 241 
            }
34066 aman.kumar 242 
        }
243 
        model.addAttribute("isRBM", isRBM);
33143 tejus.loha 244 
        model.addAttribute("startDate", startDate);
245 
        model.addAttribute("endDate", endDate);
246 
        model.addAttribute("isAdmin", isAdmin);
23612 amit.gupta 247 
 
26298 tejbeer 248 
 
33143 tejus.loha 249 
        if (isAdmin) {
250 
            if (fofoId == 0) {
251 
                //No need to send any data
252 
                model.addAttribute("collectionSummaryList", new ArrayList<>());
253 
                return "partner-collection-summary";
254 
            } else {
255 
                List<CollectionSummary> collectionSummaryList = orderRepository
256 
                        .selectCollectionSummary(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
257 
                model.addAttribute("collectionSummaryList", collectionSummaryList);
258 
                return "partner-collection-summary";
259 
            }
260 
        } else {
261 
            fofoId = fofoDetails.getFofoId();
262 
            List<CollectionSummary> collectionSummaryList = orderRepository
263 
                    .selectCollectionSummary(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
264 
            model.addAttribute("collectionSummaryList", collectionSummaryList);
265 
            return "partner-collection-summary";
26298 tejbeer 266 
 
33143 tejus.loha 267 
        }
268 
    }
26298 tejbeer 269 
 
33143 tejus.loha 270 
    @RequestMapping(value = "/downloadCollectionSummary", method = RequestMethod.GET)
271 
    public ResponseEntity<?> getDownloadCollectionSummary(HttpServletRequest request,
272 
                                                          @RequestParam(defaultValue = "0") int fofoId,
273 
                                                          @RequestParam(name = "startDate") LocalDate startDate,
274 
                                                          @RequestParam(name = "endDate") LocalDate endDate, Model model) throws Exception {
275 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
276 
        List<List<?>> rows = new ArrayList<>();
277 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
278 
        List<CollectionSummary> collectionSummaryList = null;
279 
        if (isAdmin) {
280 
            if (fofoId == 0) {
281 
                collectionSummaryList = new ArrayList<>();
282 
            } else {
283 
                collectionSummaryList = orderRepository.selectCollectionSummary(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
284 
            }
285 
        } else {
286 
            collectionSummaryList = orderRepository.selectCollectionSummary(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
287 
        }
288 
        Logger.info("CollectionSummaryList {}", collectionSummaryList);
289 
        DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy HH:mm");
290 
        for (CollectionSummary cs : collectionSummaryList) {
291 
            rows.add(Arrays.asList(cs.getDate().format(
292 
                            dateTimeFormatter), cs.getReferenceType(), cs.getCash(), cs.getPinelabs(), cs.getBajajFinserv(), cs.getHomeCredit(), cs.getPaytm(),
293 
                    cs.getCapitalFirst(), cs.getZestMoney(), cs.getSamsungSure(), cs.getTotalAmount()));
294 
        }
295 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil
296 
                .getCSVByteStream(Arrays.asList("Date", "Reference Type", "Cash", "Pinelabs", "Bajaj Finservice", "Home Credit", "Paymt",
297 
                        "Capital First", "Zest Money", "Samsung Sure", "Total Amount"), rows);
298 
        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Collection Summary Report");
26298 tejbeer 299 
 
33143 tejus.loha 300 
        return responseEntity;
301 
    }
26298 tejbeer 302 
 
33143 tejus.loha 303 
    @RequestMapping(value = "/franchiseeSalesReport", method = RequestMethod.GET)
304 
    public String getFranchiseeSalesReport(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,
305 
                                           @RequestParam(required = false) LocalDate startDate, @RequestParam(required = false) LocalDate endDate)
306 
            throws ProfitMandiBusinessException {
307 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
308 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
309 
        if (startDate == null) {
310 
            startDate = LocalDate.now().minusDays(30);
26298 tejbeer 311 
 
33143 tejus.loha 312 
        }
313 
        endDate = LocalDate.now();
34069 aman.kumar 314 
        boolean isRBM = false;
315 
        if (isAdmin) {
34096 aman.kumar 316 
            AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
317 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 318 
            isRBM = positions.stream()
34096 aman.kumar 319 
                    .anyMatch(position ->
320 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
321 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 322 
            if (isRBM && pp.containsKey(authUser.getId())) {
34096 aman.kumar 323 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
324 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
325 
                    try {
326 
                        return retailerService.getFofoRetailers(true).get(x);
327 
                    } catch (ProfitMandiBusinessException e) {
328 
                        // TODO Auto-generated catch block
329 
                        return null;
330 
                    }
331 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
332 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 333 
            }
34066 aman.kumar 334 
        }
335 
        model.addAttribute("isRBM", isRBM);
33143 tejus.loha 336 
        model.addAttribute("startDate", startDate);
337 
        model.addAttribute("endDate", endDate);
338 
        model.addAttribute("isAdmin", isAdmin);
339 
        LOGGER.info("q {}, starDate - {}, endDate - {}", fofoId, startDate, endDate);
340 
        if (isAdmin) {
341 
            if (fofoId == 0) {
342 
                //No need to pull any data
343 
                model.addAttribute("focoSaleReportList", new ArrayList<>());
344 
                return "foco-sale-report";
23637 amit.gupta 345 
 
33143 tejus.loha 346 
            }
347 
        } else {
348 
            fofoId = loginDetails.getFofoId();
349 
        }
33102 tejus.loha 350 
 
351 
 
33143 tejus.loha 352 
        FofoStore fs = fofoStoreRepository.selectByRetailerId(fofoId);
33067 shampa 353 
 
33143 tejus.loha 354 
        List<FocoSaleReportModel> focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoId, fs.getCode(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
355 
        model.addAttribute("focoSaleReportList", focoSaleReportList);
356 
        return "foco-sale-report";
357 
    }
33067 shampa 358 
 
33143 tejus.loha 359 
    @RequestMapping(value = "/franchiseeSalesFetchReportByDate", method = RequestMethod.GET)
360 
    public String getfranchiseeSalesFetchReport(HttpServletRequest request, Model model,
361 
                                                @RequestParam(defaultValue = "0") int fofoId,
362 
                                                @RequestParam(required = false) LocalDate startDate,
363 
                                                @RequestParam(required = false) LocalDate endDate)
364 
            throws Exception {
365 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
366 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
367 
        if (startDate == null) {
33067 shampa 368 
 
33143 tejus.loha 369 
            startDate = LocalDate.now().minusDays(30);
370 
            endDate = LocalDate.now();
371 
        }
34069 aman.kumar 372 
        boolean isRBM = false;
373 
        if (isAdmin) {
34096 aman.kumar 374 
            AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
375 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 376 
            isRBM = positions.stream()
34096 aman.kumar 377 
                    .anyMatch(position ->
378 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
379 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 380 
            if (isRBM && pp.containsKey(authUser.getId())) {
34096 aman.kumar 381 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
382 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
383 
                    try {
384 
                        return retailerService.getFofoRetailers(true).get(x);
385 
                    } catch (ProfitMandiBusinessException e) {
386 
                        // TODO Auto-generated catch block
387 
                        return null;
388 
                    }
389 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
390 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 391 
            }
34066 aman.kumar 392 
        }
393 
        model.addAttribute("isRBM", isRBM);
33143 tejus.loha 394 
        model.addAttribute("startDate", startDate);
395 
        model.addAttribute("endDate", endDate);
396 
        model.addAttribute("isAdmin", isAdmin);
33102 tejus.loha 397 
 
33143 tejus.loha 398 
        // List<List<?>> rows = new ArrayList<>();
30162 manish 399 
 
33143 tejus.loha 400 
        LOGGER.info("q {}, starDate - {}, endDate - {}", fofoId, startDate, endDate);
401 
        if (isAdmin) {
402 
            if (fofoId == 0) {
403 
                //no need any data
404 
                model.addAttribute("focoSaleReportList", new ArrayList<>());
405 
                return "foco-sale-report";
406 
            }
407 
        } else {
408 
            fofoId = loginDetails.getFofoId();
409 
        }
410 
        FofoStore fs = fofoStoreRepository.selectByRetailerId(fofoId);
411 
        List<FocoSaleReportModel> focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoId, fs.getCode(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
412 
        model.addAttribute("focoSaleReportList", focoSaleReportList);
413 
        return "foco-sale-report";
414 
    }
30162 manish 415 
 
416 
 
33143 tejus.loha 417 
    @RequestMapping(value = "/downloadFranchiseeSales", method = RequestMethod.GET)
418 
    public ResponseEntity<?> getdownloadFranchiseeSales(HttpServletRequest request,
419 
                                                        @RequestParam(defaultValue = "0") int fofoId,
420 
                                                        @RequestParam(name = "startDate") LocalDate startDate,
421 
                                                        @RequestParam(name = "endDate") LocalDate endDate,
422 
                                                        Model model)
423 
            throws Exception {
424 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
33102 tejus.loha 425 
 
33143 tejus.loha 426 
        List<List<?>> rows = new ArrayList<>();
427 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
428 
        List<FocoSaleReportModel> focoSaleReportList = null;
429 
        FofoStore fs = null;
430 
        if (isAdmin) {
431 
            fs = fofoStoreRepository.selectByRetailerId(fofoId);
432 
            if (fofoId == 0) {
433 
                focoSaleReportList = new ArrayList<>();
434 
            } else {
33102 tejus.loha 435 
 
33143 tejus.loha 436 
                focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoId,
34093 ranu 437 
                        fs.getCode(), startDate.atStartOfDay(), endDate.atStartOfDay().plusDays(1));
33143 tejus.loha 438 
            }
33102 tejus.loha 439 
 
33143 tejus.loha 440 
        } else {
441 
            fs = fofoStoreRepository.selectByRetailerId(fofoDetails.getFofoId());
33102 tejus.loha 442 
 
33143 tejus.loha 443 
            focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoDetails.getFofoId(),
34093 ranu 444 
                    fs.getCode(), startDate.atStartOfDay(), endDate.atStartOfDay().plusDays(1));
33143 tejus.loha 445 
        }
446 
        LOGGER.info("FocoSaleReportList {}", focoSaleReportList);
447 
        String partnerName = null;
448 
        for (FocoSaleReportModel fsr : focoSaleReportList) {
449 
            partnerName = fsr.getName();
450 
            rows.add(Arrays.asList(fsr.getCode(), fsr.getName(), fsr.getCity(), fsr.getState(), fsr.getRegion(),
451 
                    fsr.getItemId(), fsr.getBrand(), fsr.getModelName(), fsr.getModelNumber(), fsr.getColor(),
452 
                    fsr.getQuantity(), fsr.getDp(), fsr.getSellingPrice(), fsr.getMop(), fsr.getSerialNumber(),
453 
                    FormattingUtils.format(fsr.getCreateDate()), fsr.getCustomerName(), fsr.getCustomerPhone(),
454 
                    fsr.getCustomerCity(), fsr.getCustomerPincode(), fsr.getInvoiceNumber(), fsr.getPurchaseReference(),
455 
                    fsr.getCustomerGstNumber(), FormattingUtils.format(fsr.getCancelledTimestamp()),
456 
                    FormattingUtils.format(fsr.getGrnCompleteDate()), fsr.getHygieneRating(), fsr.getRating(),
457 
                    fsr.getStatus(), fsr.getRemark(), FormattingUtils.format(fsr.getCreatedTimestamp()),
458 
                    FormattingUtils.format(fsr.getDisposedTimestamp()),
459 
                    FormattingUtils.format(fsr.getNextTimestamp()),
460 
                    FormattingUtils.format(fsr.getActivationTimestamp()),
461 
                    FormattingUtils.format(fsr.getActivationTimestamp()), fsr.getLabel()));
33102 tejus.loha 462 
 
33143 tejus.loha 463 
        }
33102 tejus.loha 464 
 
33143 tejus.loha 465 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(
466 
                Arrays.asList("Code", "Name", "City", "State", "Region", "Item Id", "Brand", "Model Name",
467 
                        "Model Number", "Color", "Quantity", "Dp", "Selling_Price", "mop", "Serial Number",
468 
                        "Create Date", "Customer Name", "Customer Phone", "Customer City", " Customer Pincode",
469 
                        "Invoice  Number", "Purchase Reference", "Customer Gst Number", " Cancelled Timestamp",
470 
                        "GRN Complete Date", "Hygiene Rating", "Rating", "Status", "Remark", "Created Timestamp",
471 
                        "Disposed Timestamp", " Next Timestamp", "Activation Timestamp", "Create Timestamp", "Label"),
472 
                rows);
33102 tejus.loha 473 
 
33143 tejus.loha 474 
        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, partnerName + " Franchisee Sales Report");
33102 tejus.loha 475 
 
33143 tejus.loha 476 
        return responseEntity;
33102 tejus.loha 477 
 
33143 tejus.loha 478 
    }
33102 tejus.loha 479 
 
33143 tejus.loha 480 
    @RequestMapping(value = "/downloadWalletSummaryReport", method = RequestMethod.GET)
481 
    public ResponseEntity<?> getDownloadWalletSummaryReport(HttpServletRequest request,
482 
                                                            @RequestParam(defaultValue = "0", name = "fofoId") int fofoId,
483 
                                                            @RequestParam(name = "startDate") LocalDate startDate,
484 
                                                            @RequestParam(name = "endDate") LocalDate endDate, Model model)
485 
            throws Exception {
33102 tejus.loha 486 
 
33143 tejus.loha 487 
        List<List<?>> rows = new ArrayList<>();
488 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
489 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
33815 ranu 490 
 
34096 aman.kumar 491 
        if (!isAdmin) fofoId = fofoDetails.getFofoId();
492 
        List<WalletSummaryReportModel> walletSummaryList = fofoOrderRepository.selectWalletSummaryReport(
493 
                fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
494 
        double openingBalance = walletService.getOpeningTill(fofoId, startDate.atStartOfDay());
33815 ranu 495 
 
33143 tejus.loha 496 
        DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy HH:mm");
497 
        String partnerDetail = null;
33815 ranu 498 
// Headers for the table data
34066 aman.kumar 499 
        rows.add(Arrays.asList(
34096 aman.kumar 500 
                "Timestamp", "Reference_type", "Reference", "Amount", "Running Balance", "Description"));
501 
        for (
502 
                WalletSummaryReportModel walletSummary : walletSummaryList) {
33143 tejus.loha 503 
            partnerDetail = walletSummary.getName() + "(" + walletSummary.getCode() + "-" + walletSummary.getPhone() + ")" + "-" + walletSummary.getEmail();
33102 tejus.loha 504 
 
33143 tejus.loha 505 
            rows.add(Arrays.asList(
34096 aman.kumar 506 
                    FormattingUtils.format(walletSummary.getTimestamp()),
34066 aman.kumar 507 
                    walletSummary.getReferenceType(),
508 
                    walletSummary.getReference(),
33143 tejus.loha 509 
                    walletSummary.getAmount(),
36513 amit 510 
                    walletSummary.getRunningBalance(),
33143 tejus.loha 511 
                    walletSummary.getDescription()
512 
            ));
33102 tejus.loha 513 
 
33143 tejus.loha 514 
        }
33102 tejus.loha 515 
 
33815 ranu 516 
 
33143 tejus.loha 517 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil
34096 aman.kumar 518 
                .getCSVByteStream(Arrays.asList("Opening Balance - : " + openingBalance), rows);
33143 tejus.loha 519 
        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, partnerDetail + " Wallet Statement Report");
33102 tejus.loha 520 
 
33143 tejus.loha 521 
        return responseEntity;
33102 tejus.loha 522 
 
33143 tejus.loha 523 
    }
524 
    @RequestMapping(value = "/walletSummaryFetchReportByDate", method = RequestMethod.GET)
525 
    public String getwalletSummaryFetchReport(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,
526 
                                              @RequestParam(required = false) LocalDate startDate,
527 
                                              @RequestParam(required = false) LocalDate endDate)
528 
            throws Exception {
529 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
34096 aman.kumar 530 
        UserWallet userWallet = userWalletRepository.selectByRetailerId(fofoId);
33143 tejus.loha 531 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
532 
        if (startDate == null) {
533 
            startDate = LocalDate.now().minusDays(30);
534 
        }
34011 tejus.loha 535 
        if (endDate == null) {
536 
            endDate = LocalDate.now();
537 
        }
36513 amit 538 
        List<WalletSummaryReportModel> walletSummaryList = new ArrayList<>();
34011 tejus.loha 539 
        float openingBalance = 0;
540 
        float openingPendingAmount = 0;
33143 tejus.loha 541 
        if (isAdmin) {
34011 tejus.loha 542 
            if (fofoId > 0) {
543 
                openingBalance = walletService.getOpeningTill(fofoId, startDate.atStartOfDay());
33815 ranu 544 
                Map<Integer, Float> openingAmountMap = transactionService.getPendingIndentValueMap(startDate.atStartOfDay(), Optional.of(fofoId));
34011 tejus.loha 545 
                openingPendingAmount = openingAmountMap.get(fofoId) == null ? 0 : openingAmountMap.get(fofoId);
36513 amit 546 
                walletSummaryList = fofoOrderRepository.selectWalletSummaryReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
34011 tejus.loha 547 
                LOGGER.info("startDate - " + startDate.atStartOfDay());
548 
                LOGGER.info("endDate - " + endDate.atTime(LocalTime.MAX));
33143 tejus.loha 549 
            }
550 
        } else {
36513 amit 551 
            walletSummaryList = fofoOrderRepository.selectWalletSummaryReport(loginDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
33143 tejus.loha 552 
        }
34069 aman.kumar 553 
        boolean isRBM = false;
554 
        if (isAdmin) {
34096 aman.kumar 555 
            AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
556 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 557 
            isRBM = positions.stream()
34096 aman.kumar 558 
                    .anyMatch(position ->
559 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
560 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 561 
            if (isRBM && pp.containsKey(authUser.getId())) {
34096 aman.kumar 562 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
563 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
564 
                    try {
565 
                        return retailerService.getFofoRetailers(true).get(x);
566 
                    } catch (ProfitMandiBusinessException e) {
567 
                        // TODO Auto-generated catch block
568 
                        return null;
569 
                    }
570 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
571 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 572 
            }
34066 aman.kumar 573 
        }
574 
        model.addAttribute("isRBM", isRBM);
575 
 
36513 amit 576 
        LOGGER.info("walletSummaryList {}", walletSummaryList);
577 
        model.addAttribute("walletSummaryList", walletSummaryList);
34011 tejus.loha 578 
        model.addAttribute("openingBalance", (openingBalance + openingPendingAmount));
579 
        model.addAttribute("startDate", startDate);
580 
        model.addAttribute("endDate", endDate);
581 
        model.addAttribute("isAdmin", isAdmin);
34096 aman.kumar 582 
        model.addAttribute("userWallet", userWallet);
34011 tejus.loha 583 
        return "wallet-summary-report";
33143 tejus.loha 584 
    }
33102 tejus.loha 585 
 
33143 tejus.loha 586 
    @RequestMapping(value = "/walletSummaryReport", method = RequestMethod.GET)
587 
    public String getWalletSummaryReport(HttpServletRequest request, Model model) throws Exception {
588 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
589 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
34011 tejus.loha 590 
        LocalDateTime startDate = LocalDateTime.now().minusDays(30);
591 
        LocalDateTime endDate = LocalDateTime.now();
36513 amit 592 
        List<WalletSummaryReportModel> walletSummaryList = new ArrayList<>();
34011 tejus.loha 593 
        if (!isAdmin) {
36513 amit 594 
            walletSummaryList = fofoOrderRepository
34011 tejus.loha 595 
                    .selectWalletSummaryReport(fofoDetails.getFofoId(), startDate, endDate);
596 
        }
34069 aman.kumar 597 
        boolean isRBM = false;
598 
        if (isAdmin) {
599 
            AuthUser authUser = authRepository.selectByEmailOrMobile(fofoDetails.getEmailId());
600 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
601 
            isRBM = positions.stream()
602 
                    .anyMatch(position ->
603 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
604 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
605 
            if (isRBM && pp.containsKey(authUser.getId())) {
606 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
607 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
608 
                    try {
609 
                        return retailerService.getFofoRetailers(true).get(x);
610 
                    } catch (ProfitMandiBusinessException e) {
611 
                        // TODO Auto-generated catch block
612 
                        return null;
613 
                    }
614 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
615 
                model.addAttribute("customRetailersMap", customRetailersMap);
616 
            }
34066 aman.kumar 617 
        }
618 
        model.addAttribute("isRBM", isRBM);
619 
 
36513 amit 620 
        LOGGER.info("walletSummaryList {}", walletSummaryList);
34011 tejus.loha 621 
        model.addAttribute("startDate", startDate.toLocalDate());
622 
        model.addAttribute("endDate", endDate.toLocalDate());
36513 amit 623 
        model.addAttribute("walletSummaryList", walletSummaryList);
33143 tejus.loha 624 
        model.addAttribute("isAdmin", isAdmin);
33102 tejus.loha 625 
 
33143 tejus.loha 626 
        return "wallet-summary-report";
627 
    }
33102 tejus.loha 628 
 
33143 tejus.loha 629 
    @RequestMapping(value = "/pendingIndentReport", method = RequestMethod.GET)
630 
    public String getPendingIndentReport(HttpServletRequest request, Model model) throws Exception {
631 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
632 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
34069 aman.kumar 633 
        boolean isRBM = false;
634 
        if (isAdmin) {
34096 aman.kumar 635 
            AuthUser authUser = authRepository.selectByEmailOrMobile(fofoDetails.getEmailId());
636 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 637 
            isRBM = positions.stream()
34096 aman.kumar 638 
                    .anyMatch(position ->
639 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
640 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 641 
            if (isRBM && pp.containsKey(authUser.getId())) {
34096 aman.kumar 642 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
643 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
644 
                    try {
645 
                        return retailerService.getFofoRetailers(true).get(x);
646 
                    } catch (ProfitMandiBusinessException e) {
647 
                        // TODO Auto-generated catch block
648 
                        return null;
649 
                    }
650 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
651 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 652 
            }
34066 aman.kumar 653 
        }
654 
        model.addAttribute("isRBM", isRBM);
33102 tejus.loha 655 
 
33143 tejus.loha 656 
        LocalDateTime currentDate = LocalDate.now().atStartOfDay();
657 
        LocalDateTime currentStartMonth = currentDate.minusMonths(2).toLocalDate().atStartOfDay();
33102 tejus.loha 658 
 
33143 tejus.loha 659 
        List<PendingIndentReportModel> pendingIndentReports = fofoOrderRepository
660 
                .selectPendingIndentReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);
661 
        LOGGER.info("pendingIndentReports {}", pendingIndentReports);
33102 tejus.loha 662 
 
33143 tejus.loha 663 
        model.addAttribute("startDate", currentDate.minusMonths(2).toLocalDate());
664 
        model.addAttribute("endDate", LocalDate.now());
665 
        model.addAttribute("pendingIndentReports", pendingIndentReports);
666 
        model.addAttribute("isAdmin", isAdmin);
33102 tejus.loha 667 
 
668 
 
33143 tejus.loha 669 
        return "pending-indent-report";
670 
    }
33102 tejus.loha 671 
 
33143 tejus.loha 672 
    @RequestMapping(value = "/pendingIndentFetchReportByDate", method = RequestMethod.GET)
673 
    public String getpendingIndentFetchReport(
674 
            HttpServletRequest request,
675 
            @RequestParam(defaultValue = "0") int fofoId,
676 
            @RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,
677 
            @RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate,
678 
            Model model
679 
    ) throws Exception {
680 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
681 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
682 
        if (startDate == null) {
683 
            startDate = LocalDate.now().minusDays(30);
684 
            endDate = LocalDate.now();
685 
        }
34069 aman.kumar 686 
        boolean isRBM = false;
687 
        if (isAdmin) {
34096 aman.kumar 688 
            AuthUser authUser = authRepository.selectByEmailOrMobile(fofoDetails.getEmailId());
689 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 690 
            isRBM = positions.stream()
34096 aman.kumar 691 
                    .anyMatch(position ->
692 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
693 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 694 
            if (isRBM && pp.containsKey(authUser.getId())) {
34096 aman.kumar 695 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
696 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
697 
                    try {
698 
                        return retailerService.getFofoRetailers(true).get(x);
699 
                    } catch (ProfitMandiBusinessException e) {
700 
                        // TODO Auto-generated catch block
701 
                        return null;
702 
                    }
703 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
704 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 705 
            }
34066 aman.kumar 706 
        }
707 
        model.addAttribute("isRBM", isRBM);
708 
 
33143 tejus.loha 709 
        model.addAttribute("startDate", startDate);
710 
        model.addAttribute("endDate", endDate);
711 
        model.addAttribute("isAdmin", isAdmin);
712 
        if (isAdmin) {
713 
            if (fofoId == 0) {
714 
                model.addAttribute("pendingIndentReports", new ArrayList<>());
715 
                return "pending-indent-report";
716 
            } else {
717 
                List<PendingIndentReportModel> pendingIndentReports = fofoOrderRepository
718 
                        .selectPendingIndentReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
719 
                model.addAttribute("pendingIndentReports", pendingIndentReports);
720 
                return "pending-indent-report";
721 
            }
722 
        } else {
723 
            LocalDateTime currentDate = LocalDate.now().atStartOfDay();
724 
            List<PendingIndentReportModel> pendingIndentReports = fofoOrderRepository
725 
                    .selectPendingIndentReport(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
726 
            model.addAttribute("pendingIndentReports", pendingIndentReports);
727 
            return "pending-indent-report";
33102 tejus.loha 728 
 
33143 tejus.loha 729 
        }
730 
    }
33102 tejus.loha 731 
 
732 
 
33143 tejus.loha 733 
    @RequestMapping(value = "/pendingIndentReportDownload", method = RequestMethod.GET)
734 
    public ResponseEntity<?> getPendingIndentReportDownload(HttpServletRequest request,
735 
                                                            @RequestParam(defaultValue = "0") int fofoId,
736 
                                                            @RequestParam(name = "startDate") LocalDate startDate,
737 
                                                            @RequestParam(name = "endDate") LocalDate endDate, Model model)
738 
            throws Exception {
739 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
740 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
33102 tejus.loha 741 
        /*LocalDateTime currentDate = LocalDate.now().atStartOfDay();
742 
        LocalDateTime currentStartMonth = currentDate.minusMonths(2).toLocalDate().atStartOfDay();*/
33143 tejus.loha 743 
        List<PendingIndentReportModel> pendingIndentReports = null;
744 
        List<List<?>> rows = new ArrayList<>();
745 
        if (isAdmin) {
746 
            if (fofoId == 0)
747 
                pendingIndentReports = new ArrayList<>();
748 
            else
749 
                pendingIndentReports = fofoOrderRepository
750 
                        .selectPendingIndentReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
751 
        } else {
752 
            pendingIndentReports = fofoOrderRepository
753 
                    .selectPendingIndentReport(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
33102 tejus.loha 754 
 
33143 tejus.loha 755 
        }
756 
        LOGGER.info("pendingIndentReports {}", pendingIndentReports);
757 
        DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy HH:mm");
33102 tejus.loha 758 
 
33143 tejus.loha 759 
        for (PendingIndentReportModel pir : pendingIndentReports) {
33102 tejus.loha 760 
 
33143 tejus.loha 761 
            rows.add(Arrays.asList(pir.getTransactionId(), pir.getOrderId(),
762 
                    pir.getCreatTimestamp().format(dateTimeFormatter), pir.getItemId(), pir.getBrand(),
763 
                    pir.getModelName(), pir.getModelNumber(), pir.getColor(), pir.getQuantity(), pir.getUnitPrice(),
764 
                    pir.getWalletAmount(), pir.getStatus(), pir.getInvoiceNumber(),
765 
                    pir.getBillingTimestamp() == null ? "" : pir.getBillingTimestamp().format(dateTimeFormatter)));
33102 tejus.loha 766 
 
33143 tejus.loha 767 
        }
33102 tejus.loha 768 
 
33143 tejus.loha 769 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(Arrays.asList(
770 
                "Transaction Id", "Order Id", "Created_At", "Item_Id", "Brand", "Model Name", "Model Number", "Color",
771 
                "Quantity", "Unit Price", "Wallet Deduction", "Status", "Invoice Number", "Billing Timestamp"), rows);
33102 tejus.loha 772 
 
33143 tejus.loha 773 
        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Order Status Summary Report");
33102 tejus.loha 774 
 
33143 tejus.loha 775 
        return responseEntity;
776 
    }
33102 tejus.loha 777 
 
33143 tejus.loha 778 
    @RequestMapping(value = "/schemePayoutReport", method = RequestMethod.GET)
779 
    public String getschemePayoutReport(HttpServletRequest request, Model model,
780 
                                        @RequestParam(required = false) LocalDate startDate, @RequestParam(required = false) LocalDate endDate)
781 
            throws ProfitMandiBusinessException {
33102 tejus.loha 782 
 
33143 tejus.loha 783 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
784 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
785 
        if (startDate == null) {
786 
            startDate = LocalDate.now().minusDays(30);
787 
            endDate = LocalDate.now();
788 
        }
34069 aman.kumar 789 
        boolean isRBM = false;
790 
        if (isAdmin) {
34096 aman.kumar 791 
            AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
792 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 793 
            isRBM = positions.stream()
34096 aman.kumar 794 
                    .anyMatch(position ->
795 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
796 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 797 
            if (isRBM && pp.containsKey(authUser.getId())) {
34096 aman.kumar 798 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
799 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
800 
                    try {
801 
                        return retailerService.getFofoRetailers(true).get(x);
802 
                    } catch (ProfitMandiBusinessException e) {
803 
                        // TODO Auto-generated catch block
804 
                        return null;
805 
                    }
806 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
807 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 808 
            }
34066 aman.kumar 809 
        }
810 
        model.addAttribute("isRBM", isRBM);
33143 tejus.loha 811 
        model.addAttribute("startDate", startDate);
812 
        model.addAttribute("endDate", endDate);
813 
        model.addAttribute("isAdmin", isAdmin);
814 
        //LOGGER.info("schemePayoutReports {}", schemePayoutReports);
815 
        List<SchemePayoutReportModel> schemePayoutReports = fofoOrderRepository
816 
                .selectSchemePayoutReport(loginDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
817 
        model.addAttribute("schemePayoutReports", schemePayoutReports);
818 
        return "scheme-payout-report";
33102 tejus.loha 819 
 
33143 tejus.loha 820 
    }
33102 tejus.loha 821 
 
33143 tejus.loha 822 
    @RequestMapping(value = "/schemePayoutFetchReportByDate", method = RequestMethod.GET)
823 
    public String getschemePayoutFetchReportByDate(
824 
            HttpServletRequest request,
825 
            Model model,
826 
            @RequestParam(defaultValue = "0") int fofoId,
827 
            @RequestParam(required = false) LocalDate startDate,
828 
            @RequestParam(required = false) LocalDate endDate)
829 
            throws ProfitMandiBusinessException {
830 
        //LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
831 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
832 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
833 
        if (startDate == null) {
834 
            startDate = LocalDate.now().minusDays(30);
835 
            endDate = LocalDate.now();
836 
        }
34069 aman.kumar 837 
        boolean isRBM = false;
838 
        if (isAdmin) {
34096 aman.kumar 839 
            AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
840 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 841 
            isRBM = positions.stream()
34096 aman.kumar 842 
                    .anyMatch(position ->
843 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
844 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 845 
            if (isRBM && pp.containsKey(authUser.getId())) {
34096 aman.kumar 846 
                List<Integer> fofoIds = pp.get(authUser.getId());
847 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
848 
                    try {
849 
                        return retailerService.getFofoRetailers(true).get(x);
850 
                    } catch (ProfitMandiBusinessException e) {
851 
                        // TODO Auto-generated catch block
852 
                        return null;
853 
                    }
854 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
855 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 856 
            }
34066 aman.kumar 857 
        }
858 
 
859 
        model.addAttribute("isRBM", isRBM);
33143 tejus.loha 860 
        model.addAttribute("startDate", startDate);
861 
        model.addAttribute("endDate", endDate);
862 
        model.addAttribute("isAdmin", isAdmin);
33102 tejus.loha 863 
 
33143 tejus.loha 864 
        LOGGER.info("q {}, starDate - {}, endDate - {}", fofoId, startDate, endDate);
865 
        if (isAdmin) {
866 
            if (fofoId == 0) {
867 
                //No need to pull any data
868 
                model.addAttribute("schemePayoutReports", new ArrayList<>());
869 
                return "scheme-payout-report";
33102 tejus.loha 870 
 
33143 tejus.loha 871 
            } else {
872 
                List<SchemePayoutReportModel> schemePayoutReports = fofoOrderRepository
873 
                        .selectSchemePayoutReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
33102 tejus.loha 874 
 
33143 tejus.loha 875 
                model.addAttribute("schemePayoutReports", schemePayoutReports);
876 
                return "scheme-payout-report";
877 
            }
878 
        } else {
879 
            fofoId = loginDetails.getFofoId();
33102 tejus.loha 880 
 
33143 tejus.loha 881 
            List<SchemePayoutReportModel> schemePayoutReports = fofoOrderRepository
882 
                    .selectSchemePayoutReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
33102 tejus.loha 883 
 
33143 tejus.loha 884 
            model.addAttribute("schemePayoutReports", schemePayoutReports);
885 
            return "scheme-payout-report";
886 
        }
33102 tejus.loha 887 
 
33143 tejus.loha 888 
    }
33102 tejus.loha 889 
 
33143 tejus.loha 890 
    @RequestMapping(value = "/offerPayoutReport", method = RequestMethod.GET)
891 
    public String getOfferPayoutReport(HttpServletRequest request, Model model, @RequestParam(required = false) LocalDate startDate, @RequestParam(required = false) LocalDate endDate) throws Exception {
892 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
893 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
34069 aman.kumar 894 
        boolean isRBM = false;
895 
        if (isAdmin) {
34096 aman.kumar 896 
            AuthUser authUser = authRepository.selectByEmailOrMobile(fofoDetails.getEmailId());
897 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 898 
            isRBM = positions.stream()
34096 aman.kumar 899 
                    .anyMatch(position ->
900 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
901 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 902 
            if (isRBM && pp.containsKey(authUser.getId())) {
34096 aman.kumar 903 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
904 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
905 
                    try {
906 
                        return retailerService.getFofoRetailers(true).get(x);
907 
                    } catch (ProfitMandiBusinessException e) {
908 
                        // TODO Auto-generated catch block
909 
                        return null;
910 
                    }
911 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
912 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 913 
            }
34066 aman.kumar 914 
        }
915 
        model.addAttribute("isRBM", isRBM);
33143 tejus.loha 916 
        if (startDate == null) {
917 
            startDate = LocalDate.now().minusDays(30);
918 
            endDate = LocalDate.now();
919 
        }
920 
        model.addAttribute("startDate", startDate);
921 
        model.addAttribute("endDate", endDate);
33102 tejus.loha 922 
 
923 
 
33143 tejus.loha 924 
        List<OfferPayoutDumpReportModel> offerPayoutDumpReports = fofoOrderRepository
925 
                .selectOfferPayoutDumpReport(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
926 
        LOGGER.info("offerPayoutDumpReports {}", offerPayoutDumpReports);
33102 tejus.loha 927 
 
33143 tejus.loha 928 
        model.addAttribute("offerPayoutDumpReports", offerPayoutDumpReports);
929 
        model.addAttribute("isAdmin", isAdmin);
33102 tejus.loha 930 
 
33143 tejus.loha 931 
        return "offer-payout-dump-report";
932 
    }
33102 tejus.loha 933 
 
33143 tejus.loha 934 
    @RequestMapping(value = "/offerPayoutFetchReportByDate", method = RequestMethod.GET)
935 
    public String getofferPayoutFetchReportByDate(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,
936 
                                                  @RequestParam(required = false) LocalDate startDate, @RequestParam(required = false) LocalDate endDate)
937 
            throws ProfitMandiBusinessException {
33102 tejus.loha 938 
 
33143 tejus.loha 939 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
940 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
941 
        if (startDate == null) {
942 
            startDate = LocalDate.now().minusDays(30);
943 
            endDate = LocalDate.now();
944 
        }
34069 aman.kumar 945 
        boolean isRBM = false;
946 
        if (isAdmin) {
34096 aman.kumar 947 
            AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
948 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 949 
            isRBM = positions.stream()
34096 aman.kumar 950 
                    .anyMatch(position ->
951 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
952 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 953 
            if (isRBM && pp.containsKey(authUser.getId())) {
34096 aman.kumar 954 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
955 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
956 
                    try {
957 
                        return retailerService.getFofoRetailers(true).get(x);
958 
                    } catch (ProfitMandiBusinessException e) {
959 
                        // TODO Auto-generated catch block
960 
                        return null;
961 
                    }
962 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
963 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 964 
            }
34066 aman.kumar 965 
        }
966 
        model.addAttribute("isRBM", isRBM);
33143 tejus.loha 967 
        model.addAttribute("startDate", startDate);
968 
        model.addAttribute("endDate", endDate);
969 
        model.addAttribute("isAdmin", isAdmin);
970 
        LOGGER.info("q {}, starDate - {}, endDate - {}", fofoId, startDate, endDate);
971 
        if (isAdmin) {
972 
            if (fofoId == 0) {
973 
                //No need to pull any data
974 
                model.addAttribute("offerPayoutReports", new ArrayList<>());
975 
                return "offer-payout-dump-report";
33102 tejus.loha 976 
 
33143 tejus.loha 977 
            } else {
978 
                List<OfferPayoutDumpReportModel> offerPayoutDumpReports = fofoOrderRepository
979 
                        .selectOfferPayoutDumpReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
33102 tejus.loha 980 
 
33143 tejus.loha 981 
                model.addAttribute("offerPayoutDumpReports", offerPayoutDumpReports);
33102 tejus.loha 982 
 
983 
 
33143 tejus.loha 984 
                return "offer-payout-dump-report";
33102 tejus.loha 985 
 
33143 tejus.loha 986 
            }
987 
        } else {
988 
            fofoId = loginDetails.getFofoId();
989 
            List<OfferPayoutDumpReportModel> offerPayoutDumpReports = fofoOrderRepository
990 
                    .selectOfferPayoutDumpReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
33102 tejus.loha 991 
 
33143 tejus.loha 992 
            model.addAttribute("offerPayoutDumpReports", offerPayoutDumpReports);
33102 tejus.loha 993 
 
994 
 
33143 tejus.loha 995 
            return "offer-payout-dump-report";
996 
        }
997 
    }
33102 tejus.loha 998 
 
999 
 
33143 tejus.loha 1000 
    @RequestMapping(value = "/selectPartnerBillingSummaryReport", method = RequestMethod.GET)
1001 
    public String getselectPartnerBillingSummaryReport(HttpServletRequest request, Model model) throws Exception {
1002 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
33102 tejus.loha 1003 
 
33143 tejus.loha 1004 
        LocalDateTime currentDate = LocalDate.now().atStartOfDay();
1005 
        LocalDateTime currentStartMonth = currentDate.minusMonths(3).toLocalDate().atStartOfDay();
33102 tejus.loha 1006 
 
33143 tejus.loha 1007 
        List<PartnerBillingSummaryModel> partnerBillingSummaryReports = fofoOrderRepository
1008 
                .selectPartnerBillingSummaryReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);
33102 tejus.loha 1009 
 
33143 tejus.loha 1010 
        model.addAttribute("startDate", currentDate.minusMonths(3).toLocalDate());
1011 
        model.addAttribute("endDate", LocalDate.now());
1012 
        model.addAttribute("partnerBillingSummaryReports", partnerBillingSummaryReports);
33102 tejus.loha 1013 
 
33143 tejus.loha 1014 
        return "partner-billing-summary-report";
1015 
    }
33102 tejus.loha 1016 
 
33143 tejus.loha 1017 
    @RequestMapping(value = "/priceDropReport", method = RequestMethod.GET)
1018 
    public String getSelectPriceDropReport(HttpServletRequest request, @RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,
1019 
                                           @RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate, Model model) throws Exception {
1020 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
1021 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
1022 
        if (startDate == null) {
1023 
            startDate = LocalDate.now().minusDays(30);
1024 
            endDate = LocalDate.now();
1025 
        }
34069 aman.kumar 1026 
        boolean isRBM = false;
1027 
        if (isAdmin) {
1028 
            AuthUser authUser = authRepository.selectByEmailOrMobile(fofoDetails.getEmailId());
1029 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
1030 
            isRBM = positions.stream()
1031 
                    .anyMatch(position ->
1032 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
1033 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
1034 
            if (pp.containsKey(authUser.getId())) {
1035 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
1036 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
1037 
                    try {
1038 
                        return retailerService.getFofoRetailer(x);
1039 
                    } catch (ProfitMandiBusinessException e) {
1040 
                        // TODO Auto-generated catch block
1041 
                        return null;
1042 
                    }
1043 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
1044 
                model.addAttribute("customRetailersMap", customRetailersMap);
1045 
            }
34066 aman.kumar 1046 
        }
1047 
        model.addAttribute("isRBM", isRBM);
33143 tejus.loha 1048 
        model.addAttribute("startDate", startDate);
1049 
        model.addAttribute("endDate", endDate);
1050 
        model.addAttribute("isAdmin", isAdmin);
1051 
        List<PriceDropReportModel> priceDropReports = orderRepository.selectPriceDropReport(fofoDetails.getFofoId(),
1052 
                startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
33102 tejus.loha 1053 
 
33143 tejus.loha 1054 
        model.addAttribute("priceDropReports", priceDropReports);
33102 tejus.loha 1055 
 
33143 tejus.loha 1056 
        return "price-drop-report";
1057 
    }
33102 tejus.loha 1058 
 
33143 tejus.loha 1059 
    @RequestMapping(value = "/priceDropFetchReportByDate", method = RequestMethod.GET)
1060 
    public String getpriceDropFetchReportByDate(HttpServletRequest request,
1061 
                                                @RequestParam(defaultValue = "0") int fofoId,
1062 
                                                @RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,
1063 
                                                @RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate, Model model)
1064 
            throws Exception {
33102 tejus.loha 1065 
 
33143 tejus.loha 1066 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
1067 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
1068 
        if (startDate == null) {
1069 
            startDate = LocalDate.now().minusDays(30);
1070 
            endDate = LocalDate.now();
1071 
        }
34069 aman.kumar 1072 
        boolean isRBM = false;
1073 
        if (isAdmin) {
1074 
            AuthUser authUser = authRepository.selectByEmailOrMobile(fofoDetails.getEmailId());
1075 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
1076 
            isRBM = positions.stream()
1077 
                    .anyMatch(position ->
1078 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
1079 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
1080 
            if (pp.containsKey(authUser.getId())) {
1081 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
1082 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
1083 
                    try {
1084 
                        return retailerService.getFofoRetailer(x);
1085 
                    } catch (ProfitMandiBusinessException e) {
1086 
                        // TODO Auto-generated catch block
1087 
                        return null;
1088 
                    }
1089 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
1090 
                model.addAttribute("customRetailersMap", customRetailersMap);
1091 
            }
34066 aman.kumar 1092 
        }
1093 
        model.addAttribute("isRBM", isRBM);
33143 tejus.loha 1094 
        model.addAttribute("startDate", startDate);
1095 
        model.addAttribute("endDate", endDate);
1096 
        model.addAttribute("isAdmin", isAdmin);
1097 
        if (isAdmin) {
1098 
            if (fofoId == 0) {
1099 
                model.addAttribute("priceDropReports", new ArrayList<>());
1100 
                return "price-drop-report";
1101 
            } else {
1102 
                List<PriceDropReportModel> priceDropReports = orderRepository.selectPriceDropReport(fofoId,
1103 
                        startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
1104 
                model.addAttribute("priceDropReports", priceDropReports);
1105 
                return "price-drop-report";
1106 
            }
33102 tejus.loha 1107 
 
33143 tejus.loha 1108 
        } else {
1109 
            List<PriceDropReportModel> priceDropReports = orderRepository.selectPriceDropReport(fofoDetails.getFofoId(),
1110 
                    startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
1111 
            model.addAttribute("priceDropReports", priceDropReports);
1112 
            return "price-drop-report";
1113 
        }
1114 
    }
33102 tejus.loha 1115 
 
1116 
 
33143 tejus.loha 1117 
    @RequestMapping(value = "/downloadPriceDropReport", method = RequestMethod.GET)
1118 
    public ResponseEntity<?> getSelectDownloadPriceDropReport(HttpServletRequest request,
1119 
                                                              @RequestParam(defaultValue = "0") int fofoId,
1120 
                                                              @RequestParam(name = "startDate") LocalDate startDate,
1121 
                                                              @RequestParam(name = "endDate") LocalDate endDate, Model model)
1122 
            throws Exception {
1123 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
1124 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
1125 
        List<List<?>> rows = new ArrayList<>();
1126 
        List<PriceDropReportModel> priceDropReports = null;
1127 
        if (isAdmin) {
1128 
            if (fofoId == 0)
1129 
                priceDropReports = new ArrayList<>();
1130 
            else
1131 
                priceDropReports = orderRepository.selectPriceDropReport(fofoId,
1132 
                        startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
1133 
        } else {
1134 
            fofoId = fofoDetails.getFofoId();
1135 
            priceDropReports = orderRepository.selectPriceDropReport(fofoId,
1136 
                    startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
1137 
        }
1138 
        for (PriceDropReportModel pdr : priceDropReports) {
33102 tejus.loha 1139 
 
33143 tejus.loha 1140 
            rows.add(Arrays.asList(pdr.getCode(), pdr.getId(), pdr.getBrand(), pdr.getModelName(), pdr.getModelNumber(),
1141 
                    FormattingUtils.formatDate(pdr.getAffectedOn()), pdr.getAmount(), FormattingUtils.format(pdr.getCreditTimestamp()), pdr.getImei(), pdr.getStatus(),
1142 
                    FormattingUtils.format(pdr.getRejectedTimestamp()), pdr.getRejectionReason()));
33102 tejus.loha 1143 
 
33143 tejus.loha 1144 
        }
1145 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil
1146 
                .getCSVByteStream(Arrays.asList("code", "Price_Drop_Id", "brand", "model_name", "model_number",
1147 
                        "affected_on", "amount", "Credit Date", "Imei", "status", "Rejected Date", "Rejected Reason"), rows);
33102 tejus.loha 1148 
 
33143 tejus.loha 1149 
        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "price drop report");
33102 tejus.loha 1150 
 
33143 tejus.loha 1151 
        return responseEntity;
33102 tejus.loha 1152 
 
33143 tejus.loha 1153 
    }
33102 tejus.loha 1154 
 
33143 tejus.loha 1155 
    @RequestMapping(value = "/downloadPartnerBillingSummaryReport", method = RequestMethod.GET)
1156 
    public ResponseEntity<?> getdownloadPartnerBillingSummaryReport(HttpServletRequest request,
1157 
                                                                    @RequestParam(name = "startDate") LocalDate startDate,
1158 
                                                                    @RequestParam(name = "endDate") LocalDate endDate, Model model)
1159 
            throws Exception {
33102 tejus.loha 1160 
 
33143 tejus.loha 1161 
        List<List<?>> rows = new ArrayList<>();
1162 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
33102 tejus.loha 1163 
 
33143 tejus.loha 1164 
        LocalDateTime currentDate = LocalDate.now().atStartOfDay();
1165 
        LocalDateTime currentStartMonth = currentDate.minusMonths(3).toLocalDate().atStartOfDay();
33102 tejus.loha 1166 
 
33143 tejus.loha 1167 
        List<PartnerBillingSummaryModel> partnerBillingSummaryReports = fofoOrderRepository
1168 
                .selectPartnerBillingSummaryReport(fofoDetails.getFofoId(), startDate.atStartOfDay(),
1169 
                        endDate.atTime(LocalTime.MAX));
33102 tejus.loha 1170 
 
33143 tejus.loha 1171 
        for (PartnerBillingSummaryModel pbsr : partnerBillingSummaryReports) {
33102 tejus.loha 1172 
 
33143 tejus.loha 1173 
            rows.add(Arrays.asList(pbsr.getId(),
1174 
                    FormattingUtils.format(pbsr.getCreateTimestamp()),
1175 
                    FormattingUtils.format(pbsr.getBillingTimestamp()),
1176 
                    FormattingUtils.format(pbsr.getDeliveryTimestamp()),
1177 
                    FormattingUtils.format(pbsr.getPartnerGrnTimestamp()),
1178 
                    pbsr.getTransactionId(),
1179 
                    pbsr.getLogisticsTransactionId(), pbsr.getAirwayBillNumber(), pbsr.getStatusSubGroup(),
1180 
                    pbsr.getStatusName(), pbsr.getRetailerId(), pbsr.getRetailerName(), pbsr.getItemId(),
1181 
                    pbsr.getBrand(), pbsr.getModelName(), pbsr.getModelNumber(), pbsr.getColor(), pbsr.getUnitPrice(),
1182 
                    pbsr.getQuantity(), pbsr.getTotalPrice(), pbsr.getInvoiceNumber(), pbsr.getSellerName(), pbsr.getGstNumber(), pbsr.getHsnCode(), pbsr.getIgstRate(),
1183 
                    pbsr.getCgstRate(), pbsr.getSgstRate()));
33102 tejus.loha 1184 
 
33143 tejus.loha 1185 
        }
33102 tejus.loha 1186 
 
33143 tejus.loha 1187 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(Arrays.asList("OrderId",
1188 
                "Created On", "Billed On", "Delivered On", "Grned On", "Transaction_id", "master_order_id",
1189 
                "airwaybill_no", "statusSubGroupp", "statusName", "customer_id", "customer_name", "Item_Id", "brand",
1190 
                "model_name", "model_number", "color", "selling_price", "Quantity", "total_price", "invoice_number",
1191 
                "seller_name", "gst_number", "hsn_code", "igstrate", "cgstrate", "sgstrate"), rows);
33102 tejus.loha 1192 
 
33143 tejus.loha 1193 
        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Billing Statement Report");
33102 tejus.loha 1194 
 
33143 tejus.loha 1195 
        return responseEntity;
33102 tejus.loha 1196 
 
1197 
 
33143 tejus.loha 1198 
    }
33102 tejus.loha 1199 
 
33143 tejus.loha 1200 
    @RequestMapping(value = "/invoiceSchemeOutSummaryReport", method = RequestMethod.GET)
1201 
    public String getInvoiceSchemeOutSummaryReport(HttpServletRequest request, Model model) throws Exception {
1202 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
33102 tejus.loha 1203 
 
33143 tejus.loha 1204 
        LocalDateTime currentDate = LocalDate.now().atStartOfDay();
1205 
        LocalDateTime currentStartMonth = currentDate.minusMonths(3).toLocalDate().atStartOfDay();
33102 tejus.loha 1206 
 
33143 tejus.loha 1207 
        List<FocoSchemeOutReportModel> focoSchemeOutReports = fofoOrderRepository
1208 
                .selectInvoiceSchemeOutSummaryReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);
1209 
        LOGGER.info("focoSchemeOutReportModel {}", focoSchemeOutReports);
33102 tejus.loha 1210 
 
33143 tejus.loha 1211 
        model.addAttribute("startDate", currentDate.minusMonths(3).toLocalDate());
1212 
        model.addAttribute("endDate", LocalDate.now());
1213 
        model.addAttribute("focoSchemeOutReports", focoSchemeOutReports);
33102 tejus.loha 1214 
 
33143 tejus.loha 1215 
        return "invoicewise-scheme-out-report";
1216 
    }
33102 tejus.loha 1217 
 
33143 tejus.loha 1218 
    @RequestMapping(value = "/downloadInvoiceSchemeOutSummaryReport", method = RequestMethod.GET)
1219 
    public ResponseEntity<?> getDownloadInvoiceSchemeOutSummaryReport(HttpServletRequest request, Model model)
1220 
            throws Exception {
1221 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
33102 tejus.loha 1222 
 
33143 tejus.loha 1223 
        List<List<?>> rows = new ArrayList<>();
1224 
        LocalDateTime currentDate = LocalDate.now().atStartOfDay();
1225 
        LocalDateTime currentStartMonth = currentDate.minusMonths(3).toLocalDate().atStartOfDay();
33102 tejus.loha 1226 
 
33143 tejus.loha 1227 
        List<FocoSchemeOutReportModel> focoSchemeOutReports = fofoOrderRepository
1228 
                .selectInvoiceSchemeOutSummaryReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);
1229 
        LOGGER.info("focoSchemeOutReportModel {}", focoSchemeOutReports);
33102 tejus.loha 1230 
 
33143 tejus.loha 1231 
        for (FocoSchemeOutReportModel fsor : focoSchemeOutReports) {
1232 
            rows.add(Arrays.asList(fsor.getInvoiceNumber(), fsor.getQuantity(), fsor.getBrand(), fsor.getModelName(),
1233 
                    fsor.getModelNumber(), fsor.getColor(), fsor.getAmount()));
33102 tejus.loha 1234 
 
33143 tejus.loha 1235 
        }
33102 tejus.loha 1236 
 
33143 tejus.loha 1237 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(
1238 
                Arrays.asList("InvoiceNumber", "Quantity", "Brand", "Model Name", "Model Number", "Color", "Amount"),
1239 
                rows);
33102 tejus.loha 1240 
 
33143 tejus.loha 1241 
        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows,
1242 
                "invoice wise scheme out Summary Report");
33102 tejus.loha 1243 
 
33143 tejus.loha 1244 
        return responseEntity;
1245 
    }
33102 tejus.loha 1246 
 
33143 tejus.loha 1247 
    @RequestMapping(value = "/schemePayoutReportDownload", method = RequestMethod.GET)
1248 
    public ResponseEntity<?> getSchemePayoutReportDownload(HttpServletRequest request,
1249 
                                                           @RequestParam(defaultValue = "0") int fofoId,
1250 
                                                           @RequestParam(name = "startDate") LocalDate startDate,
1251 
                                                           @RequestParam(name = "endDate") LocalDate endDate, Model model)
1252 
            throws Exception {
1253 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
33102 tejus.loha 1254 
 
33143 tejus.loha 1255 
        List<List<?>> rows = new ArrayList<>();
33102 tejus.loha 1256 
 
33143 tejus.loha 1257 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
33102 tejus.loha 1258 
 
33143 tejus.loha 1259 
        List<SchemePayoutReportModel> schemePayoutReports = null;
1260 
        if (isAdmin) {
1261 
            if (fofoId == 0)
1262 
                schemePayoutReports = new ArrayList<>();
1263 
            else
1264 
                schemePayoutReports = fofoOrderRepository
1265 
                        .selectSchemePayoutReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
1266 
        } else {
1267 
            fofoId = fofoDetails.getFofoId();
1268 
            schemePayoutReports = fofoOrderRepository
1269 
                    .selectSchemePayoutReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
1270 
        }
1271 
        LOGGER.info("schemePayoutReports {}", schemePayoutReports);
33102 tejus.loha 1272 
 
33143 tejus.loha 1273 
        for (SchemePayoutReportModel spr : schemePayoutReports) {
33102 tejus.loha 1274 
 
33143 tejus.loha 1275 
            rows.add(Arrays.asList(spr.getId(), spr.getSerialNumber(), spr.getBrand(), spr.getModelName(),
1276 
                    spr.getModelNumber(), spr.getColor(), spr.getSchemeInDp(), spr.getSchemeOutDp(), spr.getSchemeId(),
33646 amit.gupta 1277 
                    spr.getName(), spr.getType(), spr.getAmount(), spr.getAmountType(), spr.getSioAmount(), spr.getPurchaseReference(),
33656 amit.gupta 1278 
                    spr.getInvoiceNumber(), spr.getStatus(), spr.getStatusDescription(),
33646 amit.gupta 1279 
                    FormattingUtils.formatDateTime(spr.getCreateTimestamp()), FormattingUtils.formatDateTime(spr.getRolledBackTimestamp())));
33102 tejus.loha 1280 
 
33143 tejus.loha 1281 
        }
33646 amit.gupta 1282 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(Arrays.asList("Item Id",
1283 
                "Serial No", "Brand", "Model Name", "Model Number", "Color", "Scheme In Dp", "Scheme Out Dp",
33656 amit.gupta 1284 
                "Scheme Id", "Name", "Scheme Type", "Amount", "Amount Type", "Amount Paid", "Purchase Invoice", "Sale Invoice", "Status",
33646 amit.gupta 1285 
                "Description", "Created on", "Reversed On"), rows);
33102 tejus.loha 1286 
 
33143 tejus.loha 1287 
        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Scheme Payout Summary Report");
33102 tejus.loha 1288 
 
33143 tejus.loha 1289 
        return responseEntity;
1290 
    }
33102 tejus.loha 1291 
 
1292 
 
33143 tejus.loha 1293 
    @RequestMapping(value = "/offerPayoutDumpReportDownload", method = RequestMethod.GET)
1294 
    public ResponseEntity<?> getOfferPayoutDumpReportDownload(HttpServletRequest request,
1295 
                                                              @RequestParam(defaultValue = "0") int fofoId,
1296 
                                                              @RequestParam(name = "startDate") LocalDate startDate,
1297 
                                                              @RequestParam(name = "endDate") LocalDate endDate, Model model)
1298 
            throws Exception {
1299 
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
1300 
        List<List<?>> rows = new ArrayList<>();
1301 
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
1302 
        List<OfferPayoutDumpReportModel> offerPayoutReports = null;
1303 
        if (isAdmin) {
1304 
            if (fofoId == 0)
1305 
                offerPayoutReports = new ArrayList<>();
1306 
            else
1307 
                offerPayoutReports = fofoOrderRepository
1308 
                        .selectOfferPayoutDumpReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
1309 
        } else {
1310 
            fofoId = fofoDetails.getFofoId();
1311 
            offerPayoutReports = fofoOrderRepository
1312 
                    .selectOfferPayoutDumpReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
1313 
        }
33102 tejus.loha 1314 
 
1315 
 
33143 tejus.loha 1316 
        for (OfferPayoutDumpReportModel opdr : offerPayoutReports) {
33102 tejus.loha 1317 
 
33143 tejus.loha 1318 
            rows.add(Arrays.asList(opdr.getId(), opdr.getBrand(), opdr.getModelName(),
1319 
                    opdr.getModelNumber(), opdr.getColor(), opdr.getSerialNumber(), opdr.getOfferId(),
1320 
                    opdr.getName(), opdr.getType(),
1321 
                    opdr.getSlabAmount(), opdr.getAmount(), opdr.getDescription(),
1322 
                    opdr.getCreateTimestamp(), opdr.getRejectTimestamp()));
33102 tejus.loha 1323 
 
33143 tejus.loha 1324 
        }
1325 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(Arrays.asList("Id",
1326 
                "Brand", "Model Name", "Model Number", "Color", "Serial number",
1327 
                "Offer Id", "Name", "Type", "Slab Amount", "Amount",
1328 
                "Description", "Credited On", "Rejected On"), rows);
33102 tejus.loha 1329 
 
33143 tejus.loha 1330 
        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Offer Payout Summary Report");
33102 tejus.loha 1331 
 
33143 tejus.loha 1332 
        return responseEntity;
1333 
    }
33102 tejus.loha 1334 
 
1335 
 
33143 tejus.loha 1336 
    @GetMapping("/getAllOnlineOrder")
1337 
    public String getAllOrders(HttpServletRequest request, @RequestParam(required = false) LocalDate date, Model model)
1338 
            throws ProfitMandiBusinessException {
1339 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1340 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1341 
        if (date == null) {
1342 
            date = LocalDate.now().minusDays(3);
1343 
        }
33102 tejus.loha 1344 
 
33143 tejus.loha 1345 
        LOGGER.info("date" + date);
1346 
        List<Integer> fofoIds = fofoStoreRepository.selectActiveStores().stream().map(x -> x.getId())
1347 
                .collect(Collectors.toList());
33102 tejus.loha 1348 
 
33143 tejus.loha 1349 
        Map<Integer, CustomRetailer> customRetailerMap = retailerService.getAllFofoRetailers();
33102 tejus.loha 1350 
 
33143 tejus.loha 1351 
        Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> customRetailerMap.get(x))
1352 
                .filter(x -> x != null).collect(Collectors.toList()).stream()
1353 
                .collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
33102 tejus.loha 1354 
 
33143 tejus.loha 1355 
        model.addAttribute("customRetailersMap", customRetailersMap);
33102 tejus.loha 1356 
 
33143 tejus.loha 1357 
        List<PendingOrderItem> pendingOrderItem = null;
33102 tejus.loha 1358 
 
33143 tejus.loha 1359 
        pendingOrderItem = pendingOrderItemRepository.selectAll(date.atStartOfDay(), LocalDateTime.now());
33102 tejus.loha 1360 
 
33143 tejus.loha 1361 
        Map<String, Object> map = pendingOrderService.getItemOrders(pendingOrderItem, 0);
33102 tejus.loha 1362 
 
33143 tejus.loha 1363 
        model.addAttribute("pendingOrderItem", map.get("pendingOrderItem"));
1364 
        model.addAttribute("partnerInventoryMap", map.get("partnerInventoryMap"));
1365 
        model.addAttribute("date", date);
1366 
        model.addAttribute("isAdmin", isAdmin);
1367 
        return "online-all-order-item";
1368 
    }
33102 tejus.loha 1369 
 
33143 tejus.loha 1370 
 
37037 amit 1371 
    @RequestMapping(value = "/orderReport", method = RequestMethod.GET)
1372 
    public String getOrderReport(HttpServletRequest request, Model model) throws Exception {
1373 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1374 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1375 
        LocalDate startDate = LocalDate.now().withDayOfMonth(1);
1376 
        LocalDate endDate = LocalDate.now();
1377 
        model.addAttribute("startDate", startDate);
1378 
        model.addAttribute("endDate", endDate);
1379 
        model.addAttribute("isAdmin", isAdmin);
1380 
        return "order-report";
1381 
    }
1382 
 
1383 
    @RequestMapping(value = "/downloadOrderReport", method = RequestMethod.GET)
1384 
    public ResponseEntity<?> getDownloadOrderReport(HttpServletRequest request,
1385 
                                                    @RequestParam(name = "startDate") LocalDate startDate,
1386 
                                                    @RequestParam(name = "endDate") LocalDate endDate,
1387 
                                                    @RequestParam(name = "fofoId", required = false) Integer fofoId,
1388 
                                                    Model model)
1389 
            throws Exception {
1390 
        // Period not more than a month (safety net behind the date filter)
1391 
        if (endDate.isAfter(startDate.plusMonths(1))) {
1392 
            endDate = startDate.plusMonths(1);
1393 
        }
1394 
 
1395 
        // Scope: an admin may target a partner (blank fofoId = all partners); a non-admin
1396 
        // is always restricted to their own store, whatever fofoId the client sends.
37057 amit 1397 
        // Kept as an if/else, not a ternary: mixing Integer (fofoId) and int (getFofoId)
1398 
        // in a conditional unboxes the whole expression and would NPE on a blank admin fofoId.
37037 amit 1399 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1400 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
37057 amit 1401 
        Integer scopedFofoId;
1402 
        if (isAdmin) {
1403 
            scopedFofoId = fofoId;
1404 
        } else {
1405 
            scopedFofoId = loginDetails.getFofoId();
1406 
        }
37037 amit 1407 
 
1408 
        List<com.spice.profitmandi.dao.entity.transaction.Order> orders =
1409 
                scopedFofoId == null
1410 
                        ? orderRepository.selectAllByDatesBetween(startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX))
1411 
                        : orderRepository.selectAllByDatesBetween(scopedFofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
1412 
 
1413 
        List<List<?>> rows = new ArrayList<>();
1414 
        rows.add(Arrays.asList(
1415 
                "Order ID", "Created", "Verified", "Invoice No", "Billed By", "Billing Date", "Shipping Date",
1416 
                "AWB", "Logistics Provider", "Delivery Date", "Quantity", "Amount", "Type", "Status", "Refund Reason",
1417 
                "Customer ID", "Customer Name", "Customer City", "Customer Pincode", "Customer State",
1418 
                "Item ID", "Product", "Logistics Txn ID", "Received Return Date", "Refund Date"));
1419 
 
1420 
        for (com.spice.profitmandi.dao.entity.transaction.Order o : orders) {
1421 
            com.spice.profitmandi.dao.entity.transaction.LineItem li = o.getLineItem();
1422 
            float amount = (o.getTotalAmount() == null ? 0f : o.getTotalAmount())
1423 
                    + (o.getShippingCost() == null ? 0f : o.getShippingCost());
1424 
            String product = li == null ? "" : (defaultString(li.getBrand()) + " "
1425 
                    + defaultString(li.getModelName()) + " " + defaultString(li.getModelNumber())).trim();
1426 
            rows.add(Arrays.asList(
1427 
                    o.getId(),
1428 
                    FormattingUtils.format(o.getCreateTimestamp()),
1429 
                    FormattingUtils.format(o.getVerificationTimestamp()),
1430 
                    o.getInvoiceNumber(),
1431 
                    o.getBilledBy(),
1432 
                    FormattingUtils.format(o.getBillingTimestamp()),
1433 
                    FormattingUtils.format(o.getShippingTimestamp()),
1434 
                    o.getAirwayBillNumber(),
1435 
                    o.getLogisticsProviderId(),
1436 
                    FormattingUtils.format(o.getDeliveryTimestamp()),
1437 
                    li == null ? null : li.getQuantity(),
1438 
                    amount,
1439 
                    Boolean.TRUE.equals(o.getCod()) ? "COD" : "PREPAID",
1440 
                    o.getStatusDescription(),
1441 
                    o.getRefundReason(),
1442 
                    o.getRetailerId(),
1443 
                    o.getRetailerName(),
1444 
                    o.getRetailerCity(),
1445 
                    o.getRetailerPinCode(),
1446 
                    o.getRetailerState(),
1447 
                    li == null ? null : li.getItemId(),
1448 
                    product,
1449 
                    o.getLogisticsTransactionId(),
1450 
                    FormattingUtils.format(o.getReceiverReturnTimestamp()),
1451 
                    FormattingUtils.format(o.getRefundTimestamp())));
1452 
        }
1453 
 
1454 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil
1455 
                .getCSVByteStream(Arrays.asList("Order Report : " + startDate + " to " + endDate), rows);
1456 
        return orderService.downloadReportInCsv(baos, rows, "Order Report " + startDate + " to " + endDate);
1457 
    }
1458 
 
1459 
    private static String defaultString(String value) {
1460 
        return value == null ? "" : value;
1461 
    }
1462 
 
33143 tejus.loha 1463 
    @RequestMapping(value = "/reports", method = RequestMethod.GET)
1464 
    public String reports(HttpServletRequest httpServletRequest, Model model) throws ProfitMandiBusinessException, UnsupportedOperationException, IOException {
1465 
        //LoginDetails loginDetails = cookiesProcessor.getCookiesObject(httpServletRequest);
1466 
        Map<ReporticoProject, List<ReporticoUrlInfo>> returnMap = ReporticoProject.reporticoProjectMap;
28137 amit.gupta 1467 
		/*if(fofoStoreRepository.getWarehousePartnerMap().get(7720).stream().filter(x->x.getId()==loginDetails.getFofoId()).count() > 0) {
28106 amit.gupta 1468 
			Map<ReporticoProject, List<ReporticoUrlInfo>> returnMap1 = new HashMap<ReporticoProject, List<ReporticoUrlInfo>>();
1469 
			returnMap1.put(ReporticoProject.FOCO, returnMap.get(ReporticoProject.FOCO));
1470 
			returnMap1.put(ReporticoProject.FOCOR, returnMap.get(ReporticoProject.FOCOR).stream().skip(1).collect(Collectors.toList()));
28107 amit.gupta 1471 
			returnMap = returnMap1;
28137 amit.gupta 1472 
		}*/
33143 tejus.loha 1473 
        model.addAttribute("reporticoProjectMap", returnMap);
1474 
        return "reports";
1475 
    }
33775 ranu 1476 
 
1477 
    @RequestMapping(value = "/account-statement", method = RequestMethod.GET)
1478 
    public String accountStatement(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,
1479 
                                   @RequestParam(required = false) LocalDate startDate,
1480 
                                   @RequestParam(required = false) LocalDate endDate)
1481 
            throws Exception {
1482 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1483 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1484 
 
34069 aman.kumar 1485 
        boolean isRBM = false;
1486 
        if (isAdmin) {
34096 aman.kumar 1487 
            AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
1488 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 1489 
            isRBM = positions.stream()
34096 aman.kumar 1490 
                    .anyMatch(position ->
1491 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
1492 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 1493 
            if (isRBM && pp.containsKey(authUser.getId())) {
34096 aman.kumar 1494 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
1495 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
1496 
                    try {
1497 
                        return retailerService.getFofoRetailers(true).get(x);
1498 
                    } catch (ProfitMandiBusinessException e) {
1499 
                        // TODO Auto-generated catch block
1500 
                        return null;
1501 
                    }
1502 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
1503 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 1504 
            }
34066 aman.kumar 1505 
        }
1506 
 
33775 ranu 1507 
        model.addAttribute("isAdmin", isAdmin);
34066 aman.kumar 1508 
        model.addAttribute("isRBM", isRBM);
33775 ranu 1509 
 
1510 
        return "partner-account-statement";
1511 
 
1512 
    }
1513 
 
1514 
    @RequestMapping(value = "/account-statement-report", method = RequestMethod.GET)
1515 
    public String getPartnerAccountStatement(HttpServletRequest request, @RequestParam LocalDateTime startDate, @RequestParam LocalDateTime endDate, Model model, @RequestParam(defaultValue = "0") int fofoId) throws Exception {
1516 
        boolean isAdmin = roleManager.isAdmin(cookiesProcessor.getCookiesObject(request).getRoleIds());
1517 
        if (fofoId > 0) {
1518 
            if (!isAdmin) {
1519 
                throw new ProfitMandiBusinessException("Unauthorised access", "PartnerId", "Permission Denied");
1520 
            }
1521 
        } else {
1522 
            fofoId = cookiesProcessor.getCookiesObject(request).getFofoId();
1523 
        }
1524 
        float openingBalance = walletService.getOpeningTill(fofoId, startDate);
1525 
        float closingBalance = walletService.getOpeningTill(fofoId, endDate);
1526 
        UserWallet uw = walletService.getUserWallet(fofoId);
1527 
        LOGGER.info("Start date - {}, end Date - {}", startDate, endDate);
1528 
 
1529 
        List<UserWalletHistory> history = userWalletHistoryRepository.selectPaginatedByWalletId(uw.getId(), startDate, endDate, 0, 0);
1530 
 
1531 
        history = history.stream().filter(x -> !x.getReferenceType().equals(WalletReferenceType.PURCHASE))
1532 
                .filter(x -> !WalletService.CN_WALLET_REFERENCES.contains(x.getReferenceType())).sorted(Comparator.comparing(UserWalletHistory::getId)).collect(Collectors.toList());
1533 
        Map<LocalDate, List<UserWalletHistory>> dateWalletMap = history.stream().collect(Collectors.groupingBy(x -> x.getTimestamp().toLocalDate()));
1534 
        CustomRetailer customRetailer = retailerService.getAllFofoRetailers().get(fofoId);
1535 
        List<StatementDetailModel> billedStatementDetails = orderRepository.selectDetailsBetween(fofoId, startDate, endDate);
1536 
        Map<Integer, Float> openingAmountMap = transactionService.getPendingIndentValueMap(startDate, Optional.of(fofoId));
1537 
        Map<Integer, Float> closingAmountMap = transactionService.getPendingIndentValueMap(endDate, Optional.of(fofoId));
1538 
 
1539 
        float openingPendingAmount = openingAmountMap.get(fofoId) == null ? 0 : openingAmountMap.get(fofoId);
1540 
        float closingPendingAmount = closingAmountMap.get(fofoId) == null ? 0 : closingAmountMap.get(fofoId);
1541 
        LOGGER.info("Opening - {}, Closing - {}", openingPendingAmount, closingPendingAmount);
1542 
 
1543 
        double grandTotalDebit = 0;
1544 
        double grandTotalCredit = 0;
1545 
 
1546 
        for (UserWalletHistory walletEntry : history) {
1547 
            if (walletEntry.getAmount() < 0) {
1548 
                grandTotalDebit += Math.abs(walletEntry.getAmount());
1549 
            } else {
1550 
                grandTotalCredit += walletEntry.getAmount();
1551 
            }
1552 
        }
1553 
 
1554 
        for (StatementDetailModel statement : billedStatementDetails) {
1555 
            if (statement.getAmount() < 0) {
1556 
                grandTotalCredit += Math.abs(statement.getAmount());
1557 
            } else {
1558 
                grandTotalDebit += statement.getAmount();
1559 
            }
1560 
        }
1561 
 
1562 
        model.addAttribute("billedStatementDetails", billedStatementDetails);
1563 
        model.addAttribute("customRetailer", customRetailer);
1564 
        model.addAttribute("wallethistory", history);
1565 
        model.addAttribute("startDate", startDate);
1566 
        model.addAttribute("endDate", endDate);
1567 
        model.addAttribute("dateWalletMap", dateWalletMap);
1568 
        model.addAttribute("openingBalance", (openingBalance + openingPendingAmount));
1569 
        model.addAttribute("closingBalance", (closingBalance + closingPendingAmount));
1570 
        model.addAttribute("grandTotalDebit", grandTotalDebit);
1571 
        model.addAttribute("grandTotalCredit", grandTotalCredit);
1572 
 
1573 
        return "account-statement-list";
1574 
    }
33809 ranu 1575 
 
1576 
    @RequestMapping(value = "/loan/loan-statement", method = RequestMethod.GET)
33814 ranu 1577 
    public String loanStatement(HttpServletRequest request, Model model)
33809 ranu 1578 
            throws Exception {
1579 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1580 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
34069 aman.kumar 1581 
        boolean isRBM = false;
1582 
        if (isAdmin) {
34096 aman.kumar 1583 
            AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
1584 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 1585 
            isRBM = positions.stream()
34096 aman.kumar 1586 
                    .anyMatch(position ->
1587 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
1588 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 1589 
            if (isRBM && pp.containsKey(authUser.getId())) {
1590 
                List<Integer> fofoIds = pp.get(authUser.getId());
34096 aman.kumar 1591 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(fofoId -> {
1592 
                    try {
1593 
                        return retailerService.getFofoRetailers(true).get(fofoId);
1594 
                    } catch (ProfitMandiBusinessException e) {
1595 
                        // TODO Auto-generated catch block
1596 
                        return null;
1597 
                    }
1598 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
1599 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 1600 
            }
34066 aman.kumar 1601 
        }
1602 
        model.addAttribute("isRBM", isRBM);
33809 ranu 1603 
        model.addAttribute("isAdmin", isAdmin);
1604 
 
1605 
        return "partner-loan-statement";
1606 
 
1607 
    }
1608 
 
1609 
    @RequestMapping(value = "/loan/partner-loan-statement-report", method = RequestMethod.GET)
1610 
    public String partnerLoanStatement(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,
1611 
                                       @RequestParam(required = false) LocalDateTime startDate,
1612 
                                       @RequestParam(required = false) LocalDateTime endDate)
1613 
            throws Exception {
1614 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1615 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1616 
        int partnerId = 0;
1617 
 
1618 
        if (fofoId > 0) {
1619 
            partnerId = fofoId;
1620 
        } else {
1621 
            partnerId = loginDetails.getFofoId();
1622 
        }
1623 
 
1624 
        FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(partnerId);
1625 
 
1626 
        List<LoanStatementReportModel> loanStatementReportModels = loanStatementRepository.selectByDatesAndStoreCode(startDate, endDate, fofoStore.getCode());
1627 
 
1628 
        model.addAttribute("isAdmin", isAdmin);
1629 
        model.addAttribute("loanStatementReportModels", loanStatementReportModels);
1630 
 
1631 
        return "partner-loan-statement-summary";
1632 
 
1633 
    }
1634 
 
1635 
    @RequestMapping(value = "/loan/download-partner-loan-statement-report", method = RequestMethod.GET)
1636 
    public ResponseEntity<?> downloadPartnerLoanStatement(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,
1637 
                                                          @RequestParam(required = false) LocalDateTime startDate,
1638 
                                                          @RequestParam(required = false) LocalDateTime endDate)
1639 
            throws Exception {
1640 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1641 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1642 
 
1643 
        int partnerId = 0;
1644 
 
1645 
        if (fofoId > 0) {
1646 
            partnerId = fofoId;
1647 
        } else {
1648 
            partnerId = loginDetails.getFofoId();
1649 
        }
1650 
 
1651 
        FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(partnerId);
1652 
 
1653 
        List<List<?>> rows = new ArrayList<>();
1654 
 
1655 
        List<LoanStatementReportModel> loanStatementReportModels = loanStatementRepository.selectByDatesAndStoreCode(startDate, endDate, fofoStore.getCode());// Extract the store name from the first loan statement
1656 
        String storeName = loanStatementReportModels.get(0).getStoreName();
34713 aman.kumar 1657 
        DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yy");
33809 ranu 1658 
        for (LoanStatementReportModel loanStatement : loanStatementReportModels) {
1659 
            rows.add(Arrays.asList(
1660 
                    loanStatement.getCode(),  // Code
1661 
                    String.valueOf(loanStatement.getId()),  // ID (convert int to string)
1662 
                    loanStatement.getStoreName(),  // Store Name
1663 
                    loanStatement.getState(),  // State
1664 
                    loanStatement.getZone(),  // Zone
1665 
                    loanStatement.getArea(),  // Area
1666 
                    loanStatement.getTerritory(),  // Territory
1667 
                    String.valueOf(loanStatement.getLoanId()),  // Loan ID
1668 
                    loanStatement.getInterestRate().toString(),  // Interest Rate (BigDecimal to String)
1669 
                    loanStatement.getIntialAmount().toString(),  // Initial Amount (BigDecimal to String)
1670 
                    loanStatement.getPendingAmount().toString(),  // Pending Amount (BigDecimal to String)
34713 aman.kumar 1671 
                    loanStatement.getInvoiceNumber() != null ? loanStatement.getInvoiceNumber() : "-", // Invoice Number
33809 ranu 1672 
                    loanStatement.getCreatedOn().format(dateTimeFormatter),  // Created On (format LocalDateTime)
1673 
                    loanStatement.getDueDate().format(dateTimeFormatter),  // Due Date (format LocalDateTime)
1674 
                    loanStatement.getInterestAccrued().toString(),  // Interest Accrued (BigDecimal to String)
1675 
                    loanStatement.getInterestPaid().toString(),  // Interest Paid (BigDecimal to String)
1676 
                    String.valueOf(loanStatement.getFreeDays()),  // Free Days (convert int to string)
1677 
                    loanStatement.getLoanReferenceType().toString(),  // Loan Reference Type (enum or string)
1678 
                    loanStatement.getAmount().toString(),  // Amount (BigDecimal to String)
1679 
                    loanStatement.getBusinessDate().format(dateTimeFormatter),  // Business Date (format LocalDateTime)
1680 
                    loanStatement.getCreatedAt().format(dateTimeFormatter),  // Created At (format LocalDateTime)
1681 
                    loanStatement.getDescription(),  // Description
1682 
                    loanStatement.getStatus()  // Status (calculated value)
1683 
            ));
1684 
        }
1685 
 
1686 
        // Set up the headers and create the CSV
34728 amit.gupta 1687 
        List<String> headers = Arrays.asList("Code", "ID", "Store Name", "State", "Zone", "Area", "Territory", "Credit ID",
34713 aman.kumar 1688 
                "Interest Rate", "Initial Amount", "Pending Amount", "Invoice Number", "Created On", "Due Date",
34728 amit.gupta 1689 
                "Interest Accrued", "Interest Paid", "Free Days", "Credit Reference Type",
33809 ranu 1690 
                "Amount", "Business Date", "Created At", "Description", "Status");
1691 
 
1692 
        // Create the CSV byte stream
1693 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, rows);
34728 amit.gupta 1694 
        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Partner Credit Summary Report");
33809 ranu 1695 
 
1696 
        return responseEntity;
1697 
 
1698 
    }
34236 ranu 1699 
 
1700 
    @RequestMapping(value = "/report/credit-note", method = RequestMethod.GET)
1701 
    public String creditNote(HttpServletRequest request, Model model)
1702 
            throws Exception {
1703 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1704 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1705 
        boolean isRBM = false;
1706 
        if (isAdmin) {
1707 
            AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
1708 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
1709 
            isRBM = positions.stream()
1710 
                    .anyMatch(position ->
1711 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
1712 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
1713 
            if (isRBM && pp.containsKey(authUser.getId())) {
1714 
                List<Integer> fofoIds = pp.get(authUser.getId());
1715 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(fofoId -> {
1716 
                    try {
1717 
                        return retailerService.getFofoRetailers(true).get(fofoId);
1718 
                    } catch (ProfitMandiBusinessException e) {
1719 
                        // TODO Auto-generated catch block
1720 
                        return null;
1721 
                    }
1722 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
1723 
                model.addAttribute("customRetailersMap", customRetailersMap);
1724 
            }
1725 
        }
1726 
        model.addAttribute("isRBM", isRBM);
1727 
        model.addAttribute("isAdmin", isAdmin);
1728 
 
1729 
        return "credit-note";
1730 
 
1731 
    }
1732 
 
1733 
 
1734 
    @RequestMapping(value = "/credit/credit-note-report", method = RequestMethod.GET)
1735 
    public String creditNoteReport(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,
1736 
                                   @RequestParam(required = false) YearMonth yearMonth)
1737 
            throws Exception {
1738 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1739 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1740 
        int partnerId = 0;
1741 
 
1742 
        if (fofoId > 0) {
1743 
            partnerId = fofoId;
1744 
        } else {
1745 
            partnerId = loginDetails.getFofoId();
1746 
        }
1747 
 
1748 
        LOGGER.info("partnerId: " + partnerId + " yearMonth: " + yearMonth);
1749 
 
1750 
        List<CreditNote> creditNotes = creditNoteRepository.selectAll(partnerId, yearMonth);
1751 
 
1752 
        model.addAttribute("isAdmin", isAdmin);
1753 
        model.addAttribute("creditNotes", creditNotes);
1754 
 
1755 
        return "credit-note-list";
1756 
 
1757 
    }
1758 
 
1759 
    @RequestMapping(value = "/credit-note/download", method = RequestMethod.GET)
1760 
    public ResponseEntity<?> downloadCreditNote(@RequestParam("cnNumber") String cnNumber) {
1761 
        try {
1762 
            CreditNote creditNote = creditNoteRepository.selectByCreditNoteNumber(cnNumber);
1763 
 
1764 
            YearMonth yearMonth = YearMonth.from(creditNote.getCnDate());
1765 
            int fofoId = creditNote.getFofoId();
1766 
 
1767 
            Utils.Attachment attachment = creditNoteService.downloadCN(creditNote, yearMonth, fofoId);
1768 
 
1769 
            return ResponseEntity.ok()
1770 
                    .contentType(MediaType.APPLICATION_PDF)
1771 
                    .header(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=\"" + attachment.getFileName() + "\"")
1772 
                    .body(attachment.getInputStreamSource());
1773 
        } catch (Exception e) {
1774 
            e.printStackTrace();
1775 
            return ResponseEntity.status(HttpStatus.INTERNAL_SERVER_ERROR).body("Error generating PDF: " + e.getMessage());
1776 
        }
1777 
    }
1778 
 
34256 ranu 1779 
    @RequestMapping(value = "/credit-note/attachements", method = RequestMethod.GET)
1780 
    public ResponseEntity<?> getCnAttachements(@RequestParam("cnNumber") String cnNumber) throws Exception {
1781 
        CreditNote creditNote = creditNoteRepository.selectByCreditNoteNumber(cnNumber);
1782 
        YearMonth yearMonth = YearMonth.from(creditNote.getCnDate());
1783 
        int fofoId = creditNote.getFofoId();
1784 
 
1785 
        List<InventoryMarginModel> allOffers = offerPayoutRepository.getPaidOffers(yearMonth, fofoId);
1786 
        List<InventoryMarginModel> allPriceDrops = priceDropIMEIRepository.selectPaidPriceDrops(yearMonth, fofoId);
1787 
        List<InventoryMarginModel> schemeMarginsInventoryModel = schemeInOutRepository.getPaidMargins(yearMonth, fofoId);
1788 
 
1789 
        List<InventoryMarginModel> allInventoryMarginModels = new ArrayList<>();
1790 
        allInventoryMarginModels.addAll(schemeMarginsInventoryModel);
1791 
        allInventoryMarginModels.addAll(allPriceDrops);
1792 
        allInventoryMarginModels.addAll(allOffers);
1793 
 
36708 aman 1794 
        List<List<?>> rows = allInventoryMarginModels.stream()
1795 
                .map(InventoryMarginModel::toRow)
1796 
                .map(row -> (List<?>) row.subList(0, 10))
1797 
                .collect(Collectors.toList());
34256 ranu 1798 
 
36708 aman 1799 
        List<List<String>> headerRows = Arrays.asList(
1800 
                Arrays.asList("CN Number:", cnNumber),
1801 
                Collections.emptyList(),
1802 
                Arrays.asList("CN Number", "FofoId", "InvoiceNo", "SerialNumber", "Margin", "Description",
1803 
                        "CGST", "SGST", "IGST", "Credited On")
34256 ranu 1804 
        );
1805 
 
36708 aman 1806 
        org.apache.commons.io.output.ByteArrayOutputStream byteArrayOutputStream =
1807 
                FileUtil.getCSVByteStreamWithMultiHeaders(headerRows, rows);
1808 
 
1809 
        return orderService.downloadReportInCsv(byteArrayOutputStream, rows, "CN Detail Report");
34256 ranu 1810 
    }
1811 
 
36198 amit 1812 
    @RequestMapping(value = "/credit-note/download-all", method = RequestMethod.GET)
1813 
    public ResponseEntity<?> downloadAllCreditNotes(HttpServletRequest request,
1814 
            @RequestParam("yearMonth") YearMonth yearMonth) throws Exception {
1815 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1816 
        if (!roleManager.isAdmin(loginDetails.getRoleIds())) {
1817 
            return ResponseEntity.status(HttpStatus.FORBIDDEN).body("Admin access required");
1818 
        }
34256 ranu 1819 
 
36198 amit 1820 
        List<CreditNote> creditNotes = creditNoteRepository.selectAllMarginsTypeByMonth(yearMonth);
1821 
        if (creditNotes.isEmpty()) {
1822 
            return ResponseEntity.noContent().build();
1823 
        }
34256 ranu 1824 
 
36198 amit 1825 
        // Bulk-fetch IRN and line items
1826 
        List<String> cnNumbers = creditNotes.stream().map(CreditNote::getCreditNoteNumber).collect(Collectors.toList());
1827 
        Map<String, com.spice.profitmandi.dao.entity.transaction.EInvoiceDetails> eiMap =
1828 
                eInvoiceDetailsRepository.selectByInvoiceNumbers(cnNumbers).stream()
1829 
                        .collect(Collectors.toMap(com.spice.profitmandi.dao.entity.transaction.EInvoiceDetails::getInvoiceNumber, e -> e, (a, b) -> a));
1830 
        List<Integer> cnIds = creditNotes.stream().map(CreditNote::getId).collect(Collectors.toList());
1831 
        Map<Integer, List<com.spice.profitmandi.dao.entity.transaction.CreditNoteLine>> linesMap =
1832 
                creditNoteLineRepository.selectAllByCreditNoteIds(cnIds).stream()
1833 
                        .collect(Collectors.groupingBy(com.spice.profitmandi.dao.entity.transaction.CreditNoteLine::getCreditNoteId));
1834 
 
1835 
        // Build partner lookup
1836 
        Map<Integer, com.spice.profitmandi.common.model.CustomRetailer> retailers = retailerService.getAllFofoRetailers();
1837 
 
1838 
        List<List<?>> rows = new ArrayList<>();
1839 
        for (CreditNote cn : creditNotes) {
1840 
            com.spice.profitmandi.dao.entity.transaction.EInvoiceDetails ei = eiMap.get(cn.getCreditNoteNumber());
1841 
            List<com.spice.profitmandi.dao.entity.transaction.CreditNoteLine> lines =
1842 
                    linesMap.getOrDefault(cn.getId(), java.util.Collections.emptyList());
1843 
            float total = (float) lines.stream().mapToDouble(l -> l.getAmount()).sum();
1844 
            com.spice.profitmandi.common.model.CustomRetailer retailer = retailers.get(cn.getFofoId());
1845 
            String partnerName = retailer != null ? retailer.getBusinessName() : "";
1846 
            String partnerCode = retailer != null ? retailer.getCode() : "";
1847 
 
1848 
            rows.add(Arrays.asList(
1849 
                    cn.getCreditNoteNumber(),
1850 
                    cn.getFofoId(),
1851 
                    partnerCode,
1852 
                    partnerName,
1853 
                    com.spice.profitmandi.common.util.FormattingUtils.formatDDMMMyyyyFormatter(cn.getCnDate().toLocalDate()),
1854 
                    cn.getType(),
1855 
                    Math.round(total),
1856 
                    ei != null ? ei.getIrn() : "",
1857 
                    ei != null ? ei.getAcknowledgeNumber() : "",
1858 
                    ei != null && ei.getAcknowledgeDate() != null
1859 
                            ? com.spice.profitmandi.common.util.FormattingUtils.formatDDMMMyyyyFormatter(ei.getAcknowledgeDate().toLocalDate())
1860 
                            : ""
1861 
            ));
1862 
        }
1863 
 
1864 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(
1865 
                Arrays.asList("CN Number", "FofoId", "Partner Code", "Partner Name", "CN Date", "CN Type",
1866 
                        "Total Amount", "IRN", "Ack Number", "IRN Ack Date"),
1867 
                rows);
1868 
 
1869 
        return orderService.downloadReportInCsv(baos, rows,
1870 
                "CN Summary Report - " + yearMonth.toString());
1871 
    }
1872 
 
23612 amit.gupta 1873 
}