Subversion Repositories SmartDukaan

Rev

Rev 36513 | 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 
 
1371 
    @RequestMapping(value = "/reports", method = RequestMethod.GET)
1372 
    public String reports(HttpServletRequest httpServletRequest, Model model) throws ProfitMandiBusinessException, UnsupportedOperationException, IOException {
1373 
        //LoginDetails loginDetails = cookiesProcessor.getCookiesObject(httpServletRequest);
1374 
        Map<ReporticoProject, List<ReporticoUrlInfo>> returnMap = ReporticoProject.reporticoProjectMap;
28137 amit.gupta 1375 
		/*if(fofoStoreRepository.getWarehousePartnerMap().get(7720).stream().filter(x->x.getId()==loginDetails.getFofoId()).count() > 0) {
28106 amit.gupta 1376 
			Map<ReporticoProject, List<ReporticoUrlInfo>> returnMap1 = new HashMap<ReporticoProject, List<ReporticoUrlInfo>>();
1377 
			returnMap1.put(ReporticoProject.FOCO, returnMap.get(ReporticoProject.FOCO));
1378 
			returnMap1.put(ReporticoProject.FOCOR, returnMap.get(ReporticoProject.FOCOR).stream().skip(1).collect(Collectors.toList()));
28107 amit.gupta 1379 
			returnMap = returnMap1;
28137 amit.gupta 1380 
		}*/
33143 tejus.loha 1381 
        model.addAttribute("reporticoProjectMap", returnMap);
1382 
        return "reports";
1383 
    }
33775 ranu 1384 
 
1385 
    @RequestMapping(value = "/account-statement", method = RequestMethod.GET)
1386 
    public String accountStatement(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,
1387 
                                   @RequestParam(required = false) LocalDate startDate,
1388 
                                   @RequestParam(required = false) LocalDate endDate)
1389 
            throws Exception {
1390 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1391 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1392 
 
34069 aman.kumar 1393 
        boolean isRBM = false;
1394 
        if (isAdmin) {
34096 aman.kumar 1395 
            AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
1396 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 1397 
            isRBM = positions.stream()
34096 aman.kumar 1398 
                    .anyMatch(position ->
1399 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
1400 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 1401 
            if (isRBM && pp.containsKey(authUser.getId())) {
34096 aman.kumar 1402 
                Set<Integer> fofoIds = new HashSet<>(pp.get(authUser.getId()));
1403 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> {
1404 
                    try {
1405 
                        return retailerService.getFofoRetailers(true).get(x);
1406 
                    } catch (ProfitMandiBusinessException e) {
1407 
                        // TODO Auto-generated catch block
1408 
                        return null;
1409 
                    }
1410 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
1411 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 1412 
            }
34066 aman.kumar 1413 
        }
1414 
 
33775 ranu 1415 
        model.addAttribute("isAdmin", isAdmin);
34066 aman.kumar 1416 
        model.addAttribute("isRBM", isRBM);
33775 ranu 1417 
 
1418 
        return "partner-account-statement";
1419 
 
1420 
    }
1421 
 
1422 
    @RequestMapping(value = "/account-statement-report", method = RequestMethod.GET)
1423 
    public String getPartnerAccountStatement(HttpServletRequest request, @RequestParam LocalDateTime startDate, @RequestParam LocalDateTime endDate, Model model, @RequestParam(defaultValue = "0") int fofoId) throws Exception {
1424 
        boolean isAdmin = roleManager.isAdmin(cookiesProcessor.getCookiesObject(request).getRoleIds());
1425 
        if (fofoId > 0) {
1426 
            if (!isAdmin) {
1427 
                throw new ProfitMandiBusinessException("Unauthorised access", "PartnerId", "Permission Denied");
1428 
            }
1429 
        } else {
1430 
            fofoId = cookiesProcessor.getCookiesObject(request).getFofoId();
1431 
        }
1432 
        float openingBalance = walletService.getOpeningTill(fofoId, startDate);
1433 
        float closingBalance = walletService.getOpeningTill(fofoId, endDate);
1434 
        UserWallet uw = walletService.getUserWallet(fofoId);
1435 
        LOGGER.info("Start date - {}, end Date - {}", startDate, endDate);
1436 
 
1437 
        List<UserWalletHistory> history = userWalletHistoryRepository.selectPaginatedByWalletId(uw.getId(), startDate, endDate, 0, 0);
1438 
 
1439 
        history = history.stream().filter(x -> !x.getReferenceType().equals(WalletReferenceType.PURCHASE))
1440 
                .filter(x -> !WalletService.CN_WALLET_REFERENCES.contains(x.getReferenceType())).sorted(Comparator.comparing(UserWalletHistory::getId)).collect(Collectors.toList());
1441 
        Map<LocalDate, List<UserWalletHistory>> dateWalletMap = history.stream().collect(Collectors.groupingBy(x -> x.getTimestamp().toLocalDate()));
1442 
        CustomRetailer customRetailer = retailerService.getAllFofoRetailers().get(fofoId);
1443 
        List<StatementDetailModel> billedStatementDetails = orderRepository.selectDetailsBetween(fofoId, startDate, endDate);
1444 
        Map<Integer, Float> openingAmountMap = transactionService.getPendingIndentValueMap(startDate, Optional.of(fofoId));
1445 
        Map<Integer, Float> closingAmountMap = transactionService.getPendingIndentValueMap(endDate, Optional.of(fofoId));
1446 
 
1447 
        float openingPendingAmount = openingAmountMap.get(fofoId) == null ? 0 : openingAmountMap.get(fofoId);
1448 
        float closingPendingAmount = closingAmountMap.get(fofoId) == null ? 0 : closingAmountMap.get(fofoId);
1449 
        LOGGER.info("Opening - {}, Closing - {}", openingPendingAmount, closingPendingAmount);
1450 
 
1451 
        double grandTotalDebit = 0;
1452 
        double grandTotalCredit = 0;
1453 
 
1454 
        for (UserWalletHistory walletEntry : history) {
1455 
            if (walletEntry.getAmount() < 0) {
1456 
                grandTotalDebit += Math.abs(walletEntry.getAmount());
1457 
            } else {
1458 
                grandTotalCredit += walletEntry.getAmount();
1459 
            }
1460 
        }
1461 
 
1462 
        for (StatementDetailModel statement : billedStatementDetails) {
1463 
            if (statement.getAmount() < 0) {
1464 
                grandTotalCredit += Math.abs(statement.getAmount());
1465 
            } else {
1466 
                grandTotalDebit += statement.getAmount();
1467 
            }
1468 
        }
1469 
 
1470 
        model.addAttribute("billedStatementDetails", billedStatementDetails);
1471 
        model.addAttribute("customRetailer", customRetailer);
1472 
        model.addAttribute("wallethistory", history);
1473 
        model.addAttribute("startDate", startDate);
1474 
        model.addAttribute("endDate", endDate);
1475 
        model.addAttribute("dateWalletMap", dateWalletMap);
1476 
        model.addAttribute("openingBalance", (openingBalance + openingPendingAmount));
1477 
        model.addAttribute("closingBalance", (closingBalance + closingPendingAmount));
1478 
        model.addAttribute("grandTotalDebit", grandTotalDebit);
1479 
        model.addAttribute("grandTotalCredit", grandTotalCredit);
1480 
 
1481 
        return "account-statement-list";
1482 
    }
33809 ranu 1483 
 
1484 
    @RequestMapping(value = "/loan/loan-statement", method = RequestMethod.GET)
33814 ranu 1485 
    public String loanStatement(HttpServletRequest request, Model model)
33809 ranu 1486 
            throws Exception {
1487 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1488 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
34069 aman.kumar 1489 
        boolean isRBM = false;
1490 
        if (isAdmin) {
34096 aman.kumar 1491 
            AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
1492 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
34069 aman.kumar 1493 
            isRBM = positions.stream()
34096 aman.kumar 1494 
                    .anyMatch(position ->
1495 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
1496 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
34069 aman.kumar 1497 
            if (isRBM && pp.containsKey(authUser.getId())) {
1498 
                List<Integer> fofoIds = pp.get(authUser.getId());
34096 aman.kumar 1499 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(fofoId -> {
1500 
                    try {
1501 
                        return retailerService.getFofoRetailers(true).get(fofoId);
1502 
                    } catch (ProfitMandiBusinessException e) {
1503 
                        // TODO Auto-generated catch block
1504 
                        return null;
1505 
                    }
1506 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
1507 
                model.addAttribute("customRetailersMap", customRetailersMap);
34069 aman.kumar 1508 
            }
34066 aman.kumar 1509 
        }
1510 
        model.addAttribute("isRBM", isRBM);
33809 ranu 1511 
        model.addAttribute("isAdmin", isAdmin);
1512 
 
1513 
        return "partner-loan-statement";
1514 
 
1515 
    }
1516 
 
1517 
    @RequestMapping(value = "/loan/partner-loan-statement-report", method = RequestMethod.GET)
1518 
    public String partnerLoanStatement(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,
1519 
                                       @RequestParam(required = false) LocalDateTime startDate,
1520 
                                       @RequestParam(required = false) LocalDateTime endDate)
1521 
            throws Exception {
1522 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1523 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1524 
        int partnerId = 0;
1525 
 
1526 
        if (fofoId > 0) {
1527 
            partnerId = fofoId;
1528 
        } else {
1529 
            partnerId = loginDetails.getFofoId();
1530 
        }
1531 
 
1532 
        FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(partnerId);
1533 
 
1534 
        List<LoanStatementReportModel> loanStatementReportModels = loanStatementRepository.selectByDatesAndStoreCode(startDate, endDate, fofoStore.getCode());
1535 
 
1536 
        model.addAttribute("isAdmin", isAdmin);
1537 
        model.addAttribute("loanStatementReportModels", loanStatementReportModels);
1538 
 
1539 
        return "partner-loan-statement-summary";
1540 
 
1541 
    }
1542 
 
1543 
    @RequestMapping(value = "/loan/download-partner-loan-statement-report", method = RequestMethod.GET)
1544 
    public ResponseEntity<?> downloadPartnerLoanStatement(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,
1545 
                                                          @RequestParam(required = false) LocalDateTime startDate,
1546 
                                                          @RequestParam(required = false) LocalDateTime endDate)
1547 
            throws Exception {
1548 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1549 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1550 
 
1551 
        int partnerId = 0;
1552 
 
1553 
        if (fofoId > 0) {
1554 
            partnerId = fofoId;
1555 
        } else {
1556 
            partnerId = loginDetails.getFofoId();
1557 
        }
1558 
 
1559 
        FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(partnerId);
1560 
 
1561 
        List<List<?>> rows = new ArrayList<>();
1562 
 
1563 
        List<LoanStatementReportModel> loanStatementReportModels = loanStatementRepository.selectByDatesAndStoreCode(startDate, endDate, fofoStore.getCode());// Extract the store name from the first loan statement
1564 
        String storeName = loanStatementReportModels.get(0).getStoreName();
34713 aman.kumar 1565 
        DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yy");
33809 ranu 1566 
        for (LoanStatementReportModel loanStatement : loanStatementReportModels) {
1567 
            rows.add(Arrays.asList(
1568 
                    loanStatement.getCode(),  // Code
1569 
                    String.valueOf(loanStatement.getId()),  // ID (convert int to string)
1570 
                    loanStatement.getStoreName(),  // Store Name
1571 
                    loanStatement.getState(),  // State
1572 
                    loanStatement.getZone(),  // Zone
1573 
                    loanStatement.getArea(),  // Area
1574 
                    loanStatement.getTerritory(),  // Territory
1575 
                    String.valueOf(loanStatement.getLoanId()),  // Loan ID
1576 
                    loanStatement.getInterestRate().toString(),  // Interest Rate (BigDecimal to String)
1577 
                    loanStatement.getIntialAmount().toString(),  // Initial Amount (BigDecimal to String)
1578 
                    loanStatement.getPendingAmount().toString(),  // Pending Amount (BigDecimal to String)
34713 aman.kumar 1579 
                    loanStatement.getInvoiceNumber() != null ? loanStatement.getInvoiceNumber() : "-", // Invoice Number
33809 ranu 1580 
                    loanStatement.getCreatedOn().format(dateTimeFormatter),  // Created On (format LocalDateTime)
1581 
                    loanStatement.getDueDate().format(dateTimeFormatter),  // Due Date (format LocalDateTime)
1582 
                    loanStatement.getInterestAccrued().toString(),  // Interest Accrued (BigDecimal to String)
1583 
                    loanStatement.getInterestPaid().toString(),  // Interest Paid (BigDecimal to String)
1584 
                    String.valueOf(loanStatement.getFreeDays()),  // Free Days (convert int to string)
1585 
                    loanStatement.getLoanReferenceType().toString(),  // Loan Reference Type (enum or string)
1586 
                    loanStatement.getAmount().toString(),  // Amount (BigDecimal to String)
1587 
                    loanStatement.getBusinessDate().format(dateTimeFormatter),  // Business Date (format LocalDateTime)
1588 
                    loanStatement.getCreatedAt().format(dateTimeFormatter),  // Created At (format LocalDateTime)
1589 
                    loanStatement.getDescription(),  // Description
1590 
                    loanStatement.getStatus()  // Status (calculated value)
1591 
            ));
1592 
        }
1593 
 
1594 
        // Set up the headers and create the CSV
34728 amit.gupta 1595 
        List<String> headers = Arrays.asList("Code", "ID", "Store Name", "State", "Zone", "Area", "Territory", "Credit ID",
34713 aman.kumar 1596 
                "Interest Rate", "Initial Amount", "Pending Amount", "Invoice Number", "Created On", "Due Date",
34728 amit.gupta 1597 
                "Interest Accrued", "Interest Paid", "Free Days", "Credit Reference Type",
33809 ranu 1598 
                "Amount", "Business Date", "Created At", "Description", "Status");
1599 
 
1600 
        // Create the CSV byte stream
1601 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, rows);
34728 amit.gupta 1602 
        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Partner Credit Summary Report");
33809 ranu 1603 
 
1604 
        return responseEntity;
1605 
 
1606 
    }
34236 ranu 1607 
 
1608 
    @RequestMapping(value = "/report/credit-note", method = RequestMethod.GET)
1609 
    public String creditNote(HttpServletRequest request, Model model)
1610 
            throws Exception {
1611 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1612 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1613 
        boolean isRBM = false;
1614 
        if (isAdmin) {
1615 
            AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
1616 
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
1617 
            isRBM = positions.stream()
1618 
                    .anyMatch(position ->
1619 
                            ProfitMandiConstants.TICKET_CATEGORY_RBM == position.getCategoryId());
1620 
            Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
1621 
            if (isRBM && pp.containsKey(authUser.getId())) {
1622 
                List<Integer> fofoIds = pp.get(authUser.getId());
1623 
                Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(fofoId -> {
1624 
                    try {
1625 
                        return retailerService.getFofoRetailers(true).get(fofoId);
1626 
                    } catch (ProfitMandiBusinessException e) {
1627 
                        // TODO Auto-generated catch block
1628 
                        return null;
1629 
                    }
1630 
                }).filter(x -> x != null).collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
1631 
                model.addAttribute("customRetailersMap", customRetailersMap);
1632 
            }
1633 
        }
1634 
        model.addAttribute("isRBM", isRBM);
1635 
        model.addAttribute("isAdmin", isAdmin);
1636 
 
1637 
        return "credit-note";
1638 
 
1639 
    }
1640 
 
1641 
 
1642 
    @RequestMapping(value = "/credit/credit-note-report", method = RequestMethod.GET)
1643 
    public String creditNoteReport(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,
1644 
                                   @RequestParam(required = false) YearMonth yearMonth)
1645 
            throws Exception {
1646 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1647 
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1648 
        int partnerId = 0;
1649 
 
1650 
        if (fofoId > 0) {
1651 
            partnerId = fofoId;
1652 
        } else {
1653 
            partnerId = loginDetails.getFofoId();
1654 
        }
1655 
 
1656 
        LOGGER.info("partnerId: " + partnerId + " yearMonth: " + yearMonth);
1657 
 
1658 
        List<CreditNote> creditNotes = creditNoteRepository.selectAll(partnerId, yearMonth);
1659 
 
1660 
        model.addAttribute("isAdmin", isAdmin);
1661 
        model.addAttribute("creditNotes", creditNotes);
1662 
 
1663 
        return "credit-note-list";
1664 
 
1665 
    }
1666 
 
1667 
    @RequestMapping(value = "/credit-note/download", method = RequestMethod.GET)
1668 
    public ResponseEntity<?> downloadCreditNote(@RequestParam("cnNumber") String cnNumber) {
1669 
        try {
1670 
            CreditNote creditNote = creditNoteRepository.selectByCreditNoteNumber(cnNumber);
1671 
 
1672 
            YearMonth yearMonth = YearMonth.from(creditNote.getCnDate());
1673 
            int fofoId = creditNote.getFofoId();
1674 
 
1675 
            Utils.Attachment attachment = creditNoteService.downloadCN(creditNote, yearMonth, fofoId);
1676 
 
1677 
            return ResponseEntity.ok()
1678 
                    .contentType(MediaType.APPLICATION_PDF)
1679 
                    .header(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=\"" + attachment.getFileName() + "\"")
1680 
                    .body(attachment.getInputStreamSource());
1681 
        } catch (Exception e) {
1682 
            e.printStackTrace();
1683 
            return ResponseEntity.status(HttpStatus.INTERNAL_SERVER_ERROR).body("Error generating PDF: " + e.getMessage());
1684 
        }
1685 
    }
1686 
 
34256 ranu 1687 
    @RequestMapping(value = "/credit-note/attachements", method = RequestMethod.GET)
1688 
    public ResponseEntity<?> getCnAttachements(@RequestParam("cnNumber") String cnNumber) throws Exception {
1689 
        CreditNote creditNote = creditNoteRepository.selectByCreditNoteNumber(cnNumber);
1690 
        YearMonth yearMonth = YearMonth.from(creditNote.getCnDate());
1691 
        int fofoId = creditNote.getFofoId();
1692 
 
1693 
        List<InventoryMarginModel> allOffers = offerPayoutRepository.getPaidOffers(yearMonth, fofoId);
1694 
        List<InventoryMarginModel> allPriceDrops = priceDropIMEIRepository.selectPaidPriceDrops(yearMonth, fofoId);
1695 
        List<InventoryMarginModel> schemeMarginsInventoryModel = schemeInOutRepository.getPaidMargins(yearMonth, fofoId);
1696 
 
1697 
        List<InventoryMarginModel> allInventoryMarginModels = new ArrayList<>();
1698 
        allInventoryMarginModels.addAll(schemeMarginsInventoryModel);
1699 
        allInventoryMarginModels.addAll(allPriceDrops);
1700 
        allInventoryMarginModels.addAll(allOffers);
1701 
 
36708 aman 1702 
        List<List<?>> rows = allInventoryMarginModels.stream()
1703 
                .map(InventoryMarginModel::toRow)
1704 
                .map(row -> (List<?>) row.subList(0, 10))
1705 
                .collect(Collectors.toList());
34256 ranu 1706 
 
36708 aman 1707 
        List<List<String>> headerRows = Arrays.asList(
1708 
                Arrays.asList("CN Number:", cnNumber),
1709 
                Collections.emptyList(),
1710 
                Arrays.asList("CN Number", "FofoId", "InvoiceNo", "SerialNumber", "Margin", "Description",
1711 
                        "CGST", "SGST", "IGST", "Credited On")
34256 ranu 1712 
        );
1713 
 
36708 aman 1714 
        org.apache.commons.io.output.ByteArrayOutputStream byteArrayOutputStream =
1715 
                FileUtil.getCSVByteStreamWithMultiHeaders(headerRows, rows);
1716 
 
1717 
        return orderService.downloadReportInCsv(byteArrayOutputStream, rows, "CN Detail Report");
34256 ranu 1718 
    }
1719 
 
36198 amit 1720 
    @RequestMapping(value = "/credit-note/download-all", method = RequestMethod.GET)
1721 
    public ResponseEntity<?> downloadAllCreditNotes(HttpServletRequest request,
1722 
            @RequestParam("yearMonth") YearMonth yearMonth) throws Exception {
1723 
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1724 
        if (!roleManager.isAdmin(loginDetails.getRoleIds())) {
1725 
            return ResponseEntity.status(HttpStatus.FORBIDDEN).body("Admin access required");
1726 
        }
34256 ranu 1727 
 
36198 amit 1728 
        List<CreditNote> creditNotes = creditNoteRepository.selectAllMarginsTypeByMonth(yearMonth);
1729 
        if (creditNotes.isEmpty()) {
1730 
            return ResponseEntity.noContent().build();
1731 
        }
34256 ranu 1732 
 
36198 amit 1733 
        // Bulk-fetch IRN and line items
1734 
        List<String> cnNumbers = creditNotes.stream().map(CreditNote::getCreditNoteNumber).collect(Collectors.toList());
1735 
        Map<String, com.spice.profitmandi.dao.entity.transaction.EInvoiceDetails> eiMap =
1736 
                eInvoiceDetailsRepository.selectByInvoiceNumbers(cnNumbers).stream()
1737 
                        .collect(Collectors.toMap(com.spice.profitmandi.dao.entity.transaction.EInvoiceDetails::getInvoiceNumber, e -> e, (a, b) -> a));
1738 
        List<Integer> cnIds = creditNotes.stream().map(CreditNote::getId).collect(Collectors.toList());
1739 
        Map<Integer, List<com.spice.profitmandi.dao.entity.transaction.CreditNoteLine>> linesMap =
1740 
                creditNoteLineRepository.selectAllByCreditNoteIds(cnIds).stream()
1741 
                        .collect(Collectors.groupingBy(com.spice.profitmandi.dao.entity.transaction.CreditNoteLine::getCreditNoteId));
1742 
 
1743 
        // Build partner lookup
1744 
        Map<Integer, com.spice.profitmandi.common.model.CustomRetailer> retailers = retailerService.getAllFofoRetailers();
1745 
 
1746 
        List<List<?>> rows = new ArrayList<>();
1747 
        for (CreditNote cn : creditNotes) {
1748 
            com.spice.profitmandi.dao.entity.transaction.EInvoiceDetails ei = eiMap.get(cn.getCreditNoteNumber());
1749 
            List<com.spice.profitmandi.dao.entity.transaction.CreditNoteLine> lines =
1750 
                    linesMap.getOrDefault(cn.getId(), java.util.Collections.emptyList());
1751 
            float total = (float) lines.stream().mapToDouble(l -> l.getAmount()).sum();
1752 
            com.spice.profitmandi.common.model.CustomRetailer retailer = retailers.get(cn.getFofoId());
1753 
            String partnerName = retailer != null ? retailer.getBusinessName() : "";
1754 
            String partnerCode = retailer != null ? retailer.getCode() : "";
1755 
 
1756 
            rows.add(Arrays.asList(
1757 
                    cn.getCreditNoteNumber(),
1758 
                    cn.getFofoId(),
1759 
                    partnerCode,
1760 
                    partnerName,
1761 
                    com.spice.profitmandi.common.util.FormattingUtils.formatDDMMMyyyyFormatter(cn.getCnDate().toLocalDate()),
1762 
                    cn.getType(),
1763 
                    Math.round(total),
1764 
                    ei != null ? ei.getIrn() : "",
1765 
                    ei != null ? ei.getAcknowledgeNumber() : "",
1766 
                    ei != null && ei.getAcknowledgeDate() != null
1767 
                            ? com.spice.profitmandi.common.util.FormattingUtils.formatDDMMMyyyyFormatter(ei.getAcknowledgeDate().toLocalDate())
1768 
                            : ""
1769 
            ));
1770 
        }
1771 
 
1772 
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(
1773 
                Arrays.asList("CN Number", "FofoId", "Partner Code", "Partner Name", "CN Date", "CN Type",
1774 
                        "Total Amount", "IRN", "Ack Number", "IRN Ack Date"),
1775 
                rows);
1776 
 
1777 
        return orderService.downloadReportInCsv(baos, rows,
1778 
                "CN Summary Report - " + yearMonth.toString());
1779 
    }
1780 
 
23612 amit.gupta 1781 
}