Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
21612 ashik.ali 1
package com.spice.profitmandi.web.controller;
2
 
26817 amit.gupta 3
import com.google.gson.Gson;
23203 ashik.ali 4
import com.spice.profitmandi.common.enumuration.SearchType;
21612 ashik.ali 5
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
30322 amit.gupta 6
import com.spice.profitmandi.common.model.*;
28339 tejbeer 7
import com.spice.profitmandi.common.solr.SolrService;
33213 tejus.loha 8
import com.spice.profitmandi.common.util.FileUtil;
21689 ashik.ali 9
import com.spice.profitmandi.common.util.PdfUtils;
23638 amit.gupta 10
import com.spice.profitmandi.common.util.StringUtils;
22244 ashik.ali 11
import com.spice.profitmandi.common.web.util.ResponseSender;
33213 tejus.loha 12
import com.spice.profitmandi.dao.entity.auth.AuthUser;
33795 ranu 13
import com.spice.profitmandi.dao.entity.catalog.CustomerOffer;
14
import com.spice.profitmandi.dao.entity.catalog.CustomerOfferItem;
23638 amit.gupta 15
import com.spice.profitmandi.dao.entity.catalog.Item;
27861 tejbeer 16
import com.spice.profitmandi.dao.entity.catalog.TagListing;
33400 ranu 17
import com.spice.profitmandi.dao.entity.cs.Position;
34798 ranu 18
import com.spice.profitmandi.dao.entity.dtr.*;
30322 amit.gupta 19
import com.spice.profitmandi.dao.entity.fofo.*;
34194 ranu 20
import com.spice.profitmandi.dao.entity.transaction.EInvoiceDetails;
21
import com.spice.profitmandi.dao.entity.transaction.Order;
22
import com.spice.profitmandi.dao.entity.transaction.TransactionApproval;
23
import com.spice.profitmandi.dao.entity.transaction.UserWalletHistory;
23298 ashik.ali 24
import com.spice.profitmandi.dao.entity.user.Address;
33400 ranu 25
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
23548 ashik.ali 26
import com.spice.profitmandi.dao.enumuration.dtr.PaymentOptionReferenceType;
27046 tejbeer 27
import com.spice.profitmandi.dao.enumuration.transaction.OrderStatus;
33213 tejus.loha 28
import com.spice.profitmandi.dao.enumuration.transaction.TransactionApprovalStatus;
34788 ranu 29
import com.spice.profitmandi.dao.model.ItemWiseCustomerOfferSummaryModel;
34168 tejus.loha 30
import com.spice.profitmandi.dao.model.hdfc.IrnResetOrderModel;
33213 tejus.loha 31
import com.spice.profitmandi.dao.repository.auth.AuthRepository;
33795 ranu 32
import com.spice.profitmandi.dao.repository.catalog.*;
33400 ranu 33
import com.spice.profitmandi.dao.repository.cs.PositionRepository;
30322 amit.gupta 34
import com.spice.profitmandi.dao.repository.dtr.*;
35
import com.spice.profitmandi.dao.repository.fofo.*;
24440 amit.gupta 36
import com.spice.profitmandi.dao.repository.inventory.StateRepository;
33336 tejus.loha 37
import com.spice.profitmandi.dao.repository.transaction.*;
23298 ashik.ali 38
import com.spice.profitmandi.dao.repository.user.AddressRepository;
33336 tejus.loha 39
import com.spice.profitmandi.dao.repository.user.CartRepository;
34474 aman.kumar 40
import com.spice.profitmandi.dao.service.ScratchService;
28377 tejbeer 41
import com.spice.profitmandi.service.EmailService;
32251 amit.gupta 42
import com.spice.profitmandi.service.NotificationService;
23798 amit.gupta 43
import com.spice.profitmandi.service.authentication.RoleManager;
34798 ranu 44
import com.spice.profitmandi.service.integrations.bharti.model.PlanVariant;
45
import com.spice.profitmandi.service.integrations.icicilombard.IciciLombardService;
46
import com.spice.profitmandi.service.integrations.icicilombard.model.AfinityQuoteModel;
34805 ranu 47
import com.spice.profitmandi.service.integrations.icicilombard.model.AfinityQuoteResponseModel;
35269 ranu 48
import com.spice.profitmandi.service.integrations.oneassist.OneAssistService;
49
import com.spice.profitmandi.service.integrations.oneassist.model.CancelPlanRequestModel;
35971 aman 50
import com.spice.profitmandi.service.integrations.pinelabs.PinelabsOfferCacheService;
51
import com.spice.profitmandi.service.integrations.pinelabs.dto.Tenure;
25726 amit.gupta 52
import com.spice.profitmandi.service.integrations.zest.InsuranceService;
24440 amit.gupta 53
import com.spice.profitmandi.service.integrations.zest.MobileInsurancePlan;
33172 tejus.loha 54
import com.spice.profitmandi.service.order.BulkOrderService;
23366 ashik.ali 55
import com.spice.profitmandi.service.order.OrderService;
22069 ashik.ali 56
import com.spice.profitmandi.service.pricing.PricingService;
33696 amit.gupta 57
import com.spice.profitmandi.service.transaction.SDCreditService;
33213 tejus.loha 58
import com.spice.profitmandi.service.transaction.TransactionService;
26647 tejbeer 59
import com.spice.profitmandi.service.user.RetailerService;
33336 tejus.loha 60
import com.spice.profitmandi.service.wallet.WalletService;
32405 jai.hind 61
import com.spice.profitmandi.service.whatsapp.WhatsappMessageService;
32855 amit.gupta 62
import com.spice.profitmandi.service.whatsapp.WhatsappMessageType;
22139 amit.gupta 63
import com.spice.profitmandi.web.model.LoginDetails;
22069 ashik.ali 64
import com.spice.profitmandi.web.util.CookiesProcessor;
24105 govind 65
import com.spice.profitmandi.web.util.MVCResponseSender;
33336 tejus.loha 66
import in.shop2020.model.v1.order.WalletReferenceType;
30148 amit.gupta 67
import org.apache.logging.log4j.LogManager;
68
import org.apache.logging.log4j.Logger;
32405 jai.hind 69
import org.json.JSONArray;
30148 amit.gupta 70
import org.json.JSONObject;
71
import org.springframework.beans.factory.annotation.Autowired;
72
import org.springframework.core.io.InputStreamResource;
73
import org.springframework.http.HttpHeaders;
74
import org.springframework.http.HttpStatus;
75
import org.springframework.http.MediaType;
76
import org.springframework.http.ResponseEntity;
77
import org.springframework.stereotype.Controller;
78
import org.springframework.transaction.annotation.Transactional;
79
import org.springframework.ui.Model;
80
import org.springframework.web.bind.annotation.*;
33172 tejus.loha 81
import org.springframework.web.multipart.MultipartFile;
21612 ashik.ali 82
 
33336 tejus.loha 83
import javax.mail.MessagingException;
30148 amit.gupta 84
import javax.servlet.http.HttpServletRequest;
85
import javax.servlet.http.HttpServletResponse;
34805 ranu 86
import java.io.*;
32271 amit.gupta 87
import java.nio.charset.StandardCharsets;
34805 ranu 88
import java.nio.file.Files;
33367 ranu 89
import java.time.LocalDate;
30148 amit.gupta 90
import java.time.LocalDateTime;
91
import java.time.format.DateTimeFormatter;
92
import java.time.temporal.ChronoUnit;
93
import java.util.*;
94
import java.util.stream.Collectors;
95
 
21612 ashik.ali 96
@Controller
23973 govind 97
@Transactional(rollbackFor = Throwable.class)
21612 ashik.ali 98
public class OrderController {
99
 
33213 tejus.loha 100
    private static final Logger LOGGER = LogManager.getLogger(OrderController.class);
21985 kshitij.so 101
 
33213 tejus.loha 102
    private static final List<String> offlineOrders = Arrays.asList("EMIOD", "POD");
103
    private static final List<String> allowedDoaImeis = Arrays.asList("863903054378477");
104
    @Autowired
105
    NotificationService notificationService;
106
    @Autowired
107
    TransactionApprovalRepository transactionApprovalRepository;
108
    @Autowired
109
    LineItemRepository lineItemRepository;
110
    @Autowired
111
    AuthRepository authRepository;
112
    @Autowired
113
    TransactionService transactionService;
114
    @Autowired
115
    BulkOrderService bulkOrderService;
116
    @Autowired
117
    private CustomerRepository customerRepository;
35737 amit 118
    private static final boolean accessoriesDeals = true;
33213 tejus.loha 119
    @Autowired
120
    private RoleManager roleManager;
121
    @Autowired
122
    private Gson gson;
123
    @Autowired
124
    private CustomerReturnItemRepository customerReturnItemRepository;
125
    @Autowired
126
    private FofoOrderItemRepository fofoOrderItemRepository;
127
    @Autowired
128
    private PaymentOptionRepository paymentOptionRepository;
129
    @Autowired
130
    private StateRepository stateRepository;
131
    @Autowired
132
    private ItemRepository itemRepository;
133
    @Autowired
134
    private MVCResponseSender mvcResponseSender;
135
    @Autowired
136
    private InsuranceService insuranceService;
137
    @Autowired
138
    private FofoOrderRepository fofoOrderRepository;
139
    @Autowired
140
    private CustomerAddressRepository customerAddressRepository;
141
    @Autowired
142
    private InsurancePolicyRepository insurancePolicyRepository;
143
    @Autowired
144
    private InsuranceProviderRepository insuranceProviderRepository;
145
    @Autowired
146
    private CookiesProcessor cookiesProcessor;
147
    @Autowired
148
    private PricingService pricingService;
149
    @Autowired
150
    private OrderService orderService;
151
    @Autowired
152
    private RetailerRegisteredAddressRepository retailerRegisteredAddressRepository;
153
    @Autowired
154
    private AddressRepository addressRepository;
155
    @Autowired
156
    private PaymentOptionTransactionRepository paymentOptionTransactionRepository;
157
    @Autowired
158
    private FofoPartnerPaymentOptionRepository fofoPartnerPaymentOptionRepository;
159
    @Autowired
160
    private ResponseSender<?> responseSender;
161
    @Autowired
162
    private PendingOrderRepository pendingOrderRepository;
163
    @Autowired
164
    private OrderRepository orderRepository;
165
    @Autowired
166
    private PendingOrderItemRepository pendingOrderItemRepository;
167
    @Autowired
168
    private FofoStoreRepository fofoStoreRepository;
169
    @Autowired
170
    private RetailerService retailerService;
171
    @Autowired
172
    private CurrentInventorySnapshotRepository currentInventorySnapshotRepository;
173
    @Autowired
174
    private TagListingRepository tagListingRepository;
175
    @Autowired
176
    private PendingOrderService pendingOrderService;
177
    @Autowired
178
    private EmailService emailService;
179
    @Autowired
180
    private SolrService commonSolrService;
181
    @Autowired
182
    private MouRepository mouRepository;
183
    @Autowired
184
    private WhatsappMessageService whatsappMessageService;
185
    @Autowired
186
    private TransactionRepository transactionRepository;
33336 tejus.loha 187
    @Autowired
188
    WalletService walletService;
189
    @Autowired
190
    CartRepository cartRepository;
191
    @Autowired
192
    UserWalletRepository userWalletRepository;
28339 tejbeer 193
 
33795 ranu 194
    @Autowired
195
    private CatalogRepository catalogRepository;
33336 tejus.loha 196
 
33400 ranu 197
    @Autowired
33795 ranu 198
    private CustomerOfferRepository customerOfferRepository;
199
 
200
    @Autowired
201
    private CustomerOfferItemRepository customerOfferItemRepository;
202
 
203
    @Autowired
204
    private WebOfferRepository webOfferRepository;
205
 
206
    @Autowired
33400 ranu 207
    PositionRepository positionRepository;
32405 jai.hind 208
 
33437 ranu 209
    @Autowired
210
    PendingOrderPlanRepository pendingOrderPlanRepository;
24105 govind 211
 
34168 tejus.loha 212
    @Autowired
213
    PartnerOnBoardingPanelRepository partnerOnBoardingPanelRepository;
214
 
215
    @Autowired
216
    SDCreditService sdCreditService;
217
 
34798 ranu 218
    @Autowired
219
    IciciPolicyTrackerRepository iciciPolicyTrackerRepository;
34788 ranu 220
 
221
    @Autowired
34474 aman.kumar 222
    ScratchService scratchService;
34798 ranu 223
 
34788 ranu 224
    @Autowired
35971 aman 225
    com.spice.profitmandi.service.user.StoreTimelineTatService storeTimelineTatService;
226
 
227
    @Autowired
34798 ranu 228
    IciciLombardService iciciLombardService;
34788 ranu 229
 
35726 vikas 230
    @Autowired
231
    PinelabsOfferCacheService pinelabsOfferCacheService;
232
 
33419 amit.gupta 233
    @RequestMapping(value = "/wa-send-invoice", method = RequestMethod.GET)
234
    public String sendWhatsappMessage(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.ORDER_ID) int orderId, Model model) {
235
        try {
236
            this.sendWhatsappInvoice(fofoOrderRepository.selectByOrderId(orderId));
237
        } catch (Exception e) {
35737 amit 238
            LOGGER.error("Could not send whatsapp message for order {}", orderId, e);
33419 amit.gupta 239
        }
240
        model.addAttribute("response1", true);
241
        return "response";
242
    }
243
 
33213 tejus.loha 244
    @RequestMapping(value = "/get-order", method = RequestMethod.GET)
245
    public String getOrder(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.ORDER_ID) int orderId,
246
                           Model model) throws ProfitMandiBusinessException {
247
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
248
        FofoOrder fofoOrder = fofoOrderRepository.selectByFofoIdAndOrderId(fofoDetails.getFofoId(), orderId);
249
        List<FofoOrderItem> fofoLineItems = fofoOrderItemRepository.selectByOrderId(fofoOrder.getId());
250
        CustomerAddress customerAddress = null;
251
        if (fofoOrder.getCustomerAddressId() != 0) {
252
            customerAddress = customerAddressRepository.selectById(fofoOrder.getCustomerAddressId());
253
        }
23973 govind 254
 
33213 tejus.loha 255
        Customer customer = customerRepository.selectById(fofoOrder.getCustomerId());
256
        if (customerAddress != null) {
257
            customerAddress.setPhoneNumber(customer.getMobileNumber());
258
        }
259
        LOGGER.info("Added to get invoice - {}, {}", customer, 123);
260
        List<PaymentOptionTransaction> paymentOptionTransactions = paymentOptionTransactionRepository
261
                .selectByReferenceIdAndType(fofoOrder.getId(), PaymentOptionReferenceType.ORDER);
262
        Map<Integer, PaymentOption> paymentOptionIdPaymentOptionMap = this
263
                .paymentOptionIdPaymentOptionMap(paymentOptionTransactions);
264
        List<InsurancePolicy> insurancePolicies = insurancePolicyRepository
265
                .selectByRetailerIdInvoiceNumber(fofoOrder.getInvoiceNumber());
266
        this.addInsuranceProvider(insurancePolicies);
32627 ranu 267
 
33213 tejus.loha 268
        model.addAttribute("fofoOrder", fofoOrder);
269
        model.addAttribute("fofoLineItems", fofoLineItems);
270
        if (customerAddress != null) {
271
            model.addAttribute("customerBillingAddress", orderService.getBillingAddress(customerAddress));
272
        } else {
273
            model.addAttribute("customerBillingAddress", "");
21985 kshitij.so 274
 
33213 tejus.loha 275
        }
276
        model.addAttribute("customerBillingAddressObj", customerAddress);
277
        model.addAttribute("customerDetailsObj", customer);
278
        model.addAttribute("paymentOptionTransactions", paymentOptionTransactions);
279
        model.addAttribute("paymentOptionIdPaymentOptionMap", paymentOptionIdPaymentOptionMap);
280
        model.addAttribute("insurancePolicies", insurancePolicies);
281
        return "order-details";
282
    }
32637 amit.gupta 283
 
33213 tejus.loha 284
    private Map<Integer, InsuranceProvider> toInsuranceProviderIdInsuranceProvider(
285
            List<InsuranceProvider> insuranceProviders) {
286
        Map<Integer, InsuranceProvider> insuranceProviderIdInsuranceProviderMap = new HashMap<>();
287
        for (InsuranceProvider insuranceProvider : insuranceProviders) {
288
            insuranceProviderIdInsuranceProviderMap.put(insuranceProvider.getId(), insuranceProvider);
289
        }
290
        return insuranceProviderIdInsuranceProviderMap;
291
    }
23973 govind 292
 
33247 ranu 293
    private void addInsuranceProvider(List<InsurancePolicy> insurancePolicies) throws ProfitMandiBusinessException {
33213 tejus.loha 294
        if (insurancePolicies.isEmpty()) {
295
            return;
296
        }
297
        Set<Integer> insuranceProviderIds = new HashSet<>();
298
        for (InsurancePolicy insurancePolicy : insurancePolicies) {
299
            insuranceProviderIds.add(insurancePolicy.getProviderId());
300
        }
301
        LOGGER.info("insuranceProviderIds {}", insuranceProviderIds);
302
        List<InsuranceProvider> insuranceProviders = insuranceProviderRepository.selectByIds(insuranceProviderIds);
303
        Map<Integer, InsuranceProvider> insuranceProviderIdInsuranceProviderMap = this
304
                .toInsuranceProviderIdInsuranceProvider(insuranceProviders);
305
        for (InsurancePolicy insurancePolicy : insurancePolicies) {
306
            insurancePolicy
307
                    .setInsuranceProvider(insuranceProviderIdInsuranceProviderMap.get(insurancePolicy.getProviderId()));
308
        }
309
    }
23973 govind 310
 
33213 tejus.loha 311
    @RequestMapping(value = "/saleDetails", method = RequestMethod.GET)
312
    public String getSaleDetails(HttpServletRequest request,
313
                                 @RequestParam(name = ProfitMandiConstants.ORDER_ID) int orderId, Model model) throws Exception {
314
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
315
        boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
316
        FofoOrder fofoOrder = fofoOrderRepository.selectByFofoIdAndOrderId(fofoDetails.getFofoId(), orderId);
317
        List<FofoOrderItem> fofoOrderItems = fofoOrderItemRepository.selectByOrderId(fofoOrder.getId());
318
        CustomerAddress customerAddress = customerAddressRepository.selectById(fofoOrder.getCustomerAddressId());
319
        List<PaymentOptionTransaction> paymentOptionTransactions = paymentOptionTransactionRepository
320
                .selectByReferenceIdAndType(fofoOrder.getId(), PaymentOptionReferenceType.ORDER);
23973 govind 321
 
33213 tejus.loha 322
        // Added Migration info as we lost it.
323
        if (paymentOptionTransactions == null || paymentOptionTransactions.size() == 0) {
324
            PaymentOptionTransaction pot = new PaymentOptionTransaction();
325
            pot.setAmount(fofoOrder.getTotalAmount());
326
            pot.setCreateTimestamp(fofoOrder.getCreateTimestamp());
327
            // Mark it paid through cash
328
            pot.setPaymentOptionId(1);
329
            pot.setReferenceType(PaymentOptionReferenceType.ORDER);
330
            paymentOptionTransactionRepository.persist(pot);
331
            paymentOptionTransactions.add(pot);
332
            LOGGER.info("Added to get invoice");
333
        }
334
        Map<Integer, PaymentOption> paymentOptionIdPaymentOptionMap = this
335
                .paymentOptionIdPaymentOptionMap(paymentOptionTransactions);
336
        List<InsurancePolicy> insurancePolicies = insurancePolicyRepository
337
                .selectByRetailerIdInvoiceNumber(fofoOrder.getInvoiceNumber());
338
        this.addInsuranceProvider(insurancePolicies);
35737 amit 339
        Set<Integer> itemIds = fofoOrderItems.stream().map(FofoOrderItem::getItemId).collect(Collectors.toSet());
340
        Map<Integer, Item> itemsMap = itemRepository.selectByIds(itemIds).stream()
341
                .collect(Collectors.toMap(Item::getId, item -> item));
33213 tejus.loha 342
        Map<Integer, Set<FofoLineItem>> fofoOrderItemIdLineItemMap = fofoOrderItems.stream()
343
                .collect(Collectors.toMap(FofoOrderItem::getId, FofoOrderItem::getFofoLineItems));
23973 govind 344
 
35737 amit 345
        Map<Integer, List<CustomerReturnItem>> foiIdCustomerReturnInventoryItemsMap = new HashMap<>();
33213 tejus.loha 346
        Map<Integer, Integer> inventoryItemBilledQtyMap = new HashMap<>();
23973 govind 347
 
33213 tejus.loha 348
        for (FofoOrderItem foi : fofoOrderItems) {
35737 amit 349
            List<CustomerReturnItem> customerReturnItems = customerReturnItemRepository
350
                    .selectAllByOrderItemId(foi.getId());
351
            foiIdCustomerReturnInventoryItemsMap.put(foi.getId(), customerReturnItems);
33213 tejus.loha 352
            for (FofoLineItem fli : foi.getFofoLineItems()) {
353
                inventoryItemBilledQtyMap.put(fli.getInventoryItemId(), fli.getQuantity());
354
            }
355
            this.markDoa(fofoOrder, foi, isAdmin);
356
            for (CustomerReturnItem customerReturnItem : customerReturnItems) {
357
                inventoryItemBilledQtyMap.put(customerReturnItem.getInventoryItemId(),
358
                        inventoryItemBilledQtyMap.get(customerReturnItem.getInventoryItemId()) - 1);
359
            }
360
        }
23973 govind 361
 
33213 tejus.loha 362
        LOGGER.info("fofoOrderItemIdLineItemMap {}", fofoOrderItemIdLineItemMap);
363
        model.addAttribute("fofoOrder", fofoOrder);
364
        model.addAttribute("itemsMap", itemsMap);
365
        model.addAttribute("fofoOrderItemIdLineItemsMap", StringUtils.toString(fofoOrderItemIdLineItemMap));
366
        model.addAttribute("foiIdCustomerReturnInventoryItemsMap",
367
                StringUtils.toString(foiIdCustomerReturnInventoryItemsMap));
368
        model.addAttribute("fofoOrderItemIdLineItemMap", fofoOrderItemIdLineItemMap);
23973 govind 369
 
33213 tejus.loha 370
        model.addAttribute("fofoOrderItems", fofoOrderItems);
371
        model.addAttribute("inventoryItemBilledQtyMap", StringUtils.toString(inventoryItemBilledQtyMap));
372
        if (customerAddress != null) {
30426 tejbeer 373
 
33213 tejus.loha 374
            model.addAttribute("customerBillingAddress", orderService.getBillingAddress(customerAddress));
375
        } else {
376
            model.addAttribute("customerBillingAddress", "");
32637 amit.gupta 377
 
33213 tejus.loha 378
        }
379
        model.addAttribute("customerBillingAddressObj", customerAddress);
380
        model.addAttribute("paymentOptionTransactions", paymentOptionTransactions);
381
        model.addAttribute("paymentOptionIdPaymentOptionMap", paymentOptionIdPaymentOptionMap);
382
        model.addAttribute("insurancePolicies", insurancePolicies);
383
        model.addAttribute("markDefective", this.markDefective(fofoOrder));
384
        return "sale-details";
385
    }
32637 amit.gupta 386
 
33213 tejus.loha 387
    private void markDoa(FofoOrder fofoOrder, FofoOrderItem foi, boolean isAdmin) {
388
        if (isAdmin) {
389
            foi.setDoa(true);
390
            return;
391
        }
392
        boolean isImei = foi.getFofoLineItems().stream()
393
                .anyMatch(x -> org.apache.commons.lang3.StringUtils.isNotEmpty(x.getSerialNumber())
394
                        && allowedDoaImeis.contains(x.getSerialNumber()));
395
        LocalDateTime buyDate = fofoOrder.getCreateTimestamp().truncatedTo(ChronoUnit.DAYS);
396
        LocalDateTime curDate = LocalDateTime.now().truncatedTo(ChronoUnit.DAYS);
397
        if (buyDate.isAfter(curDate.minusDays(45)) || isImei) {
398
            foi.setDoa(true);
399
        } else
400
            foi.setDoa(
401
                    foi.getBrand().equals("Nokia") && foi.getCost() < 4990 && buyDate.isAfter(curDate.minusYears(1)));
402
    }
30426 tejbeer 403
 
33213 tejus.loha 404
    private boolean markDefective(FofoOrder fofoOrder) {
405
        return fofoOrder.getCreateTimestamp().truncatedTo(ChronoUnit.DAYS).plusDays(180)
406
                .isAfter(LocalDateTime.now().truncatedTo(ChronoUnit.DAYS));
26647 tejbeer 407
 
33213 tejus.loha 408
    }
26647 tejbeer 409
 
33213 tejus.loha 410
    @RequestMapping(value = "/getSearchOrder")
411
    public String getSearchOrder(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
412
        return "search-order";
413
    }
26647 tejbeer 414
 
33213 tejus.loha 415
    @RequestMapping(value = "/getInvoiceSearchOrder")
416
    public String getInvoiceSearchOrder(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
417
        return "invoices-cancel";
418
    }
33172 tejus.loha 419
 
33213 tejus.loha 420
    @RequestMapping(value = "/customerDetails", method = RequestMethod.PUT)
421
    public String updateCustomerDetails(HttpServletRequest request, @RequestBody CustomCustomer customCustomer,
422
                                        @RequestParam(name = ProfitMandiConstants.INVOICE_NUMBER) String invoiceNumber, Model model)
423
            throws Exception {
34338 ranu 424
        LOGGER.info("CustomCustomer {}", customCustomer);
33172 tejus.loha 425
 
33213 tejus.loha 426
        orderService.updateCustomerDetails(customCustomer, invoiceNumber);
427
        return this.getSearchOrderDetails(request, invoiceNumber, model);
428
    }
33172 tejus.loha 429
 
33213 tejus.loha 430
    @RequestMapping(value = "/searchOrderDetails", method = RequestMethod.GET)
431
    public String getSearchOrderDetails(HttpServletRequest request,
432
                                        @RequestParam(name = ProfitMandiConstants.INVOICE_NUMBER) String invoiceNumber, Model model)
433
            throws Exception {
33172 tejus.loha 434
 
33213 tejus.loha 435
        FofoOrder fofoOrder = fofoOrderRepository.selectByInvoiceNumber(invoiceNumber);
34474 aman.kumar 436
        if (fofoOrder == null) {
437
            throw new ProfitMandiBusinessException("invalid invoice number", "invoice - " + invoiceNumber, "Please enter valid invoice number");
34181 tejus.loha 438
        }
439
 
33213 tejus.loha 440
        List<FofoOrderItem> fofoOrderItems = fofoOrderItemRepository.selectByOrderId(fofoOrder.getId());
441
        Customer customer = customerRepository.selectById(fofoOrder.getCustomerId());
442
        CustomerAddress customerAddress = customerAddressRepository.selectById(fofoOrder.getCustomerAddressId());
443
        Map<Integer, PaymentOption> paymentOptionIdPaymentOptionMap = paymentOptionRepository.selectActiveOption().stream().collect(Collectors.toMap(x -> x.getId(), x -> x));
444
        List<Integer> fofoPartnerPaymentOptions = new ArrayList<>(paymentOptionIdPaymentOptionMap.keySet());
35737 amit 445
        Set<Integer> searchItemIds = fofoOrderItems.stream().map(FofoOrderItem::getItemId).collect(Collectors.toSet());
35746 amit 446
        Map<Integer, Item> itemsMap = searchItemIds.isEmpty()
447
                ? new HashMap<>()
448
                : itemRepository.selectByIds(searchItemIds).stream()
449
                        .collect(Collectors.toMap(Item::getId, item -> item));
35737 amit 450
        LOGGER.info("fofoPartnerPaymentOptions {}", fofoPartnerPaymentOptions);
33213 tejus.loha 451
        List<PaymentOptionTransaction> paymentOptionTransactions = paymentOptionTransactionRepository
452
                .selectByReferenceIdAndType(fofoOrder.getId(), PaymentOptionReferenceType.ORDER);
35737 amit 453
        LOGGER.info("paymentOptionTransactions {}", paymentOptionTransactions);
26647 tejbeer 454
 
33213 tejus.loha 455
        Map<Integer, PaymentOptionTransaction> paymentOptionIdPaymentOptionTransactionMap = this
456
                .paymentOptionIdPaymentOptionTransactionMap(paymentOptionTransactions);
35737 amit 457
        LOGGER.info("paymentOptionIdPaymentOptionTransactionMap {}", paymentOptionIdPaymentOptionTransactionMap.keySet());
33213 tejus.loha 458
        List<InsurancePolicy> insurancePolicies = insurancePolicyRepository
459
                .selectByRetailerIdInvoiceNumber(fofoOrder.getInvoiceNumber());
460
        this.addInsuranceProvider(insurancePolicies);
461
        model.addAttribute("fofoOrder", fofoOrder);
462
        for (FofoOrderItem fofoOrderItem : fofoOrderItems) {
463
            fofoOrderItem.setDoa(true);
464
        }
27861 tejbeer 465
 
33213 tejus.loha 466
        Map<Integer, Set<FofoLineItem>> fofoOrderItemIdLineItemMap = fofoOrderItems.stream()
467
                .collect(Collectors.toMap(FofoOrderItem::getId, FofoOrderItem::getFofoLineItems));
28339 tejbeer 468
 
35737 amit 469
        Map<Integer, List<CustomerReturnItem>> foiIdCustomerReturnInventoryItemsMap = new HashMap<>();
33213 tejus.loha 470
        Map<Integer, Integer> inventoryItemBilledQtyMap = new HashMap<>();
28339 tejbeer 471
 
33213 tejus.loha 472
        for (FofoOrderItem foi : fofoOrderItems) {
35737 amit 473
            List<CustomerReturnItem> customerReturnItems = customerReturnItemRepository
474
                    .selectAllByOrderItemId(foi.getId());
475
            foiIdCustomerReturnInventoryItemsMap.put(foi.getId(), customerReturnItems);
33213 tejus.loha 476
            for (FofoLineItem fli : foi.getFofoLineItems()) {
477
                inventoryItemBilledQtyMap.put(fli.getInventoryItemId(), fli.getQuantity());
478
            }
479
            for (CustomerReturnItem customerReturnItem : customerReturnItems) {
480
                inventoryItemBilledQtyMap.put(customerReturnItem.getInventoryItemId(),
481
                        inventoryItemBilledQtyMap.get(customerReturnItem.getInventoryItemId()) - 1);
482
            }
483
        }
484
        model.addAttribute("foiIdCustomerReturnInventoryItemsMap",
485
                StringUtils.toString(foiIdCustomerReturnInventoryItemsMap));
486
        model.addAttribute("fofoOrderItems", fofoOrderItems);
487
        model.addAttribute("inventoryItemBilledQtyMap", StringUtils.toString(inventoryItemBilledQtyMap));
488
        model.addAttribute("fofoOrderItemIdLineItemsMap", StringUtils.toString(fofoOrderItemIdLineItemMap));
489
        model.addAttribute("itemsMap", itemsMap);
490
        model.addAttribute("markDefective", true);
491
        model.addAttribute("customer", customer);
492
        model.addAttribute("customerAddress", customerAddress);
493
        model.addAttribute("paymentOptionTransactions", paymentOptionTransactions);
494
        model.addAttribute("paymentOptionIdPaymentOptionMap", paymentOptionIdPaymentOptionMap);
495
        model.addAttribute("paymentOptionIdPaymentOptionTransactionMap", paymentOptionIdPaymentOptionTransactionMap);
496
        model.addAttribute("insurancePolicies", insurancePolicies);
497
        model.addAttribute("fofoPartnerPaymentOptions", fofoPartnerPaymentOptions);
498
        model.addAttribute("totalNumberOfPaymentOptionId", fofoPartnerPaymentOptions.size());
499
        model.addAttribute("stateNames",
500
                stateRepository.selectAll().stream().map(x -> x.getName()).collect(Collectors.toList()));
501
        return "search-order-details";
502
    }
28420 tejbeer 503
 
33213 tejus.loha 504
    private Map<Integer, PaymentOption> paymentOptionIdPaymentOptionMap(
33247 ranu 505
            List<PaymentOptionTransaction> paymentOptionTransactions) throws ProfitMandiBusinessException {
33213 tejus.loha 506
        Set<Integer> paymentOptionIds = new HashSet<>();
507
        for (PaymentOptionTransaction paymentOptionTransaction : paymentOptionTransactions) {
508
            paymentOptionIds.add(paymentOptionTransaction.getPaymentOptionId());
509
        }
510
        List<PaymentOption> paymentOptions = paymentOptionRepository.selectByIds(paymentOptionIds);
511
        Map<Integer, PaymentOption> paymentOptionIdPaymentOptionMap = new HashMap<>();
512
        for (PaymentOption paymentOption : paymentOptions) {
513
            paymentOptionIdPaymentOptionMap.put(paymentOption.getId(), paymentOption);
514
        }
515
        return paymentOptionIdPaymentOptionMap;
516
    }
23973 govind 517
 
33213 tejus.loha 518
    private Map<Integer, PaymentOption> paymentOptionIdPaymentOptionMapUsingPaymentOptions(
33247 ranu 519
            List<Integer> fofoPartnerPaymentOptions) throws ProfitMandiBusinessException {
33213 tejus.loha 520
        List<PaymentOption> paymentOptions = paymentOptionRepository
521
                .selectByIds(new HashSet<>(fofoPartnerPaymentOptions));
522
        Map<Integer, PaymentOption> paymentOptionIdPaymentOptionMap = new HashMap<>();
523
        for (PaymentOption paymentOption : paymentOptions) {
524
            paymentOptionIdPaymentOptionMap.put(paymentOption.getId(), paymentOption);
525
        }
526
        return paymentOptionIdPaymentOptionMap;
527
    }
23973 govind 528
 
33213 tejus.loha 529
    private Map<Integer, PaymentOptionTransaction> paymentOptionIdPaymentOptionTransactionMap(
530
            List<PaymentOptionTransaction> paymentOptionTransactions) {
531
        Map<Integer, PaymentOptionTransaction> paymentOptionIdPaymentOptionTransactionMap = new HashMap<>();
532
        for (PaymentOptionTransaction paymentOptionTransaction : paymentOptionTransactions) {
533
            paymentOptionIdPaymentOptionTransactionMap.put(paymentOptionTransaction.getPaymentOptionId(),
534
                    paymentOptionTransaction);
535
        }
536
        return paymentOptionIdPaymentOptionTransactionMap;
537
    }
28339 tejbeer 538
 
33437 ranu 539
    @RequestMapping(value = "/checkplans", method = RequestMethod.GET)
540
    public String getInsurancePrices(HttpServletRequest request, @RequestParam float price, Model model,
541
                                     @RequestParam int itemId, @RequestParam int poiId) throws ProfitMandiBusinessException {
542
        LOGGER.info("Request received at url : {}", request.getRequestURI());
28339 tejbeer 543
 
33437 ranu 544
        try {
545
            String response = mvcResponseSender.createResponseString(this.getPlans(price, itemId, poiId));
546
            model.addAttribute("response1", response);
547
        } catch (Exception e) {
548
            // TODO Auto-generated catch block
549
            LOGGER.info(e.getMessage(), e);
550
            throw new ProfitMandiBusinessException("Plans", "Plans API", "Error formatting insurance plans");
33213 tejus.loha 551
        }
33400 ranu 552
 
33437 ranu 553
        return "response";
33213 tejus.loha 554
    }
28339 tejbeer 555
 
34798 ranu 556
    @RequestMapping(value = "/getPlanQuote", method = RequestMethod.GET)
34788 ranu 557
    public String getPlanQuote(HttpServletRequest request, Model model,
35002 ranu 558
                               @RequestParam String planCode, @RequestParam int sumInsured, @RequestParam String manufacturedDate, @RequestParam int itemId, @RequestParam String planName) throws ProfitMandiBusinessException {
34788 ranu 559
 
560
        try {
34798 ranu 561
 
562
            DateTimeFormatter formatter = DateTimeFormatter.ofPattern("MM/dd/yyyy");
563
            LocalDate manufactured = LocalDate.parse(manufacturedDate, formatter);
564
 
34788 ranu 565
            PlanVariant planVariant = insuranceService.getICICIPremiumByVariantId(planCode);
566
 
35066 amit 567
            LOGGER.info("planVariant111 {}", planVariant);
34788 ranu 568
 
569
            String correlationId = UUID.randomUUID().toString();
570
            IciciPolicyTracker policyTracker = new IciciPolicyTracker();
571
            policyTracker.setCorrelationId(correlationId);
572
            iciciPolicyTrackerRepository.persist(policyTracker);
573
 
574
            // Policy validity (1 year from today)
575
            LocalDate today = LocalDate.now();
576
            LocalDate oneYearLater = today.plusYears(1);
577
 
578
            String itemBrand = itemRepository.selectById(itemId).getBrand();
579
 
580
            AfinityQuoteModel quoteModel = new AfinityQuoteModel();
35002 ranu 581
            quoteModel.setProductCode(iciciLombardService.PRODUCT_CODE_STAGGING);
582
            quoteModel.setPlanCode(String.valueOf(planVariant.getOurPlanId()));
583
            quoteModel.setPlanName(planName);
584
            quoteModel.setSumInsured((int) sumInsured);
34788 ranu 585
            quoteModel.setPolicyStartDate(today.toString());          // format: yyyy-MM-dd
586
            quoteModel.setPolicyEndDate(oneYearLater.toString());
35002 ranu 587
            quoteModel.setTaxEffectiveDate(today.toString());
588
            quoteModel.setPolicyType("New");
589
            quoteModel.setIlgicStateName(iciciLombardService.PARTY_STATE_NAME);
34805 ranu 590
            quoteModel.setPartyStateName(iciciLombardService.PARTY_STATE_NAME);
35002 ranu 591
            quoteModel.setUserLevel("UW3");
592
            quoteModel.setNoOfClaimsAllowed(999);
593
            quoteModel.setMakeAndModelOfGadget("High");
594
            quoteModel.setPremiumBeforeEndorsementCancellation(0);
595
            quoteModel.setGeographicalLimit("WithinIndia");
596
            quoteModel.setTransactionDate(today.toString());
597
            quoteModel.setEndorsementEffectiveDate(today.toString());
598
            quoteModel.setRegisteredCustomer(true);
34788 ranu 599
            quoteModel.setCorrelationId(correlationId);
600
 
35002 ranu 601
            // Set cover details
602
            AfinityQuoteModel.CoverDetail coverDetail = new AfinityQuoteModel.CoverDetail();
603
            coverDetail.setName("Accidental Damage");
604
            coverDetail.setPremium(0);
605
 
606
            // Set risk details
607
            AfinityQuoteModel.RiskDetail riskDetail = new AfinityQuoteModel.RiskDetail();
608
            riskDetail.setRiskSIComponent("MOBILE");
609
            riskDetail.setCoverDetails(Arrays.asList(coverDetail));
610
 
611
            quoteModel.setRisksDetails(Arrays.asList(riskDetail));
612
 
34805 ranu 613
            AfinityQuoteResponseModel afinityQuoteResponseModel = iciciLombardService.hitAfinityQuote(quoteModel);
614
            float planDp = insuranceService.getPlanDp(afinityQuoteResponseModel.getTotalPremium(), planVariant.getCoverage());
615
 
616
            Map<String, Object> responseMap = new HashMap<>();
617
            responseMap.put("afinityQuoteModel", afinityQuoteResponseModel);
618
            responseMap.put("planDp", planDp);
619
            model.addAttribute("response1", mvcResponseSender.createResponseString(responseMap));
34788 ranu 620
        } catch (Exception e) {
621
            // TODO Auto-generated catch block
622
            LOGGER.info(e.getMessage(), e);
623
            throw new ProfitMandiBusinessException("Plans", "Plans Quote", "Error qutotation insurance plans");
624
        }
625
 
626
        return "response";
34798 ranu 627
    }
34788 ranu 628
 
34204 tejus.loha 629
    private boolean sendWhatsappInvoice(FofoOrder fofoOrder) throws Exception {
630
        return this.sendWhatsappInvoice(fofoOrder, "");
34179 tejus.loha 631
    }
632
 
34204 tejus.loha 633
    private boolean sendWhatsappInvoice(FofoOrder fofoOrder, String whatsAppNo) throws Exception {
634
        boolean shouldSendWhatsappMessage = notificationService.shouldSendWhatsappMessage(whatsAppNo);
34474 aman.kumar 635
        boolean isSend = false;
34204 tejus.loha 636
        if (shouldSendWhatsappMessage) {
637
            Customer customer = customerRepository.selectById(fofoOrder.getCustomerId());
638
            String mobileNumber;
639
            if (!whatsAppNo.isEmpty()) {
34474 aman.kumar 640
                mobileNumber = whatsAppNo;
641
            } else {
642
                mobileNumber = customer.getMobileNumber();
643
            }
644
            CustomRetailer retailer = retailerService.getFofoRetailer(fofoOrder.getFofoId());
645
            String message = String.format("Dear %s,\n" +
646
                    "Thank you for your purchase from SmartDukaan store - %s, %s.\n" +
647
                    "Your purchase invoice is attached for your reference.\n" +
648
                    "\n" +
649
                    "Download our app for offers and updates on new products.\n" +
650
                    "https://www.smartdukaan.com/b2c\n" +
651
                    "\n" +
652
                    "Best Regards\n" +
653
                    "SmartDukaan", customer.getFirstName(), retailer.getBusinessName(), retailer.getAddress().getCity());
34204 tejus.loha 654
 
34474 aman.kumar 655
            isSend = notificationService.sendWhatsappMediaMessage(message, mobileNumber, this.getPublicInvoiceUrl(fofoOrder.getInvoiceNumber()),
33213 tejus.loha 656
                    this.getFileName(fofoOrder.getInvoiceNumber()), WhatsappMessageType.DOCUMENT);
657
        }
34204 tejus.loha 658
        return isSend;
33213 tejus.loha 659
    }
28339 tejbeer 660
 
33213 tejus.loha 661
    private String getFileName(String invoiceNumber) {
662
        return "INV-" + invoiceNumber.replace("/", "-") + ".pdf";
663
    }
31375 tejbeer 664
 
33213 tejus.loha 665
    private String getPublicInvoiceUrl(String invoiceNumber) {
666
        String base64Encoded = Base64.getMimeEncoder().encodeToString(invoiceNumber.getBytes(StandardCharsets.UTF_8));
667
        String publicUrl = "https://partners.smartdukaan.com/wa-invoice-send/" + base64Encoded + ".pdf";
668
        LOGGER.info("Public Whatsapp Url for Invoice Message - {}", publicUrl);
669
        return publicUrl;
670
    }
28339 tejbeer 671
 
33213 tejus.loha 672
    @RequestMapping(value = "/order/bad_return", method = RequestMethod.POST)
673
    public ResponseEntity<?> badReturn(HttpServletRequest request, @RequestBody FoiBadReturnRequest foiBadReturnRequest,
674
                                       Model model) throws ProfitMandiBusinessException {
675
        LOGGER.info("request at uri {} body {}", request.getRequestURI(), foiBadReturnRequest);
676
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
677
        CustomerCreditNote custmoerCreditNote;
678
        if (roleManager.isAdmin(fofoDetails.getRoleIds())) {
679
            FofoOrderItem foi = fofoOrderItemRepository.selectById(foiBadReturnRequest.getFofoOrderItemId());
680
            FofoOrder fo = fofoOrderRepository.selectByOrderId(foi.getOrderId());
34168 tejus.loha 681
            custmoerCreditNote = orderService.badReturn(fofoDetails.getEmailId(), fo.getFofoId(), foiBadReturnRequest);
33213 tejus.loha 682
        } else {
683
            custmoerCreditNote = orderService.badReturn(fofoDetails.getFofoId(), foiBadReturnRequest);
684
        }
685
        return responseSender.ok(custmoerCreditNote.getId());
686
    }
28339 tejbeer 687
 
33213 tejus.loha 688
    @GetMapping(value = "/wa-invoice-send/{invoiceHash}")
689
    public ResponseEntity<?> generateInvoice(@PathVariable String invoiceHash) throws ProfitMandiBusinessException {
690
        String decodedInvoiceNumber = new String(Base64.getMimeDecoder().decode(invoiceHash));
691
        LOGGER.info("Invoice Hash {}", invoiceHash);
28339 tejbeer 692
 
23973 govind 693
 
33213 tejus.loha 694
        FofoOrder fofoOrder = fofoOrderRepository.selectByInvoiceNumber(decodedInvoiceNumber);
24844 amit.gupta 695
 
33213 tejus.loha 696
        InvoicePdfModel pdfModel = orderService.getInvoicePdfModel(fofoOrder.getId());
24844 amit.gupta 697
 
33213 tejus.loha 698
        ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
699
        PdfUtils.generateAndWrite(Arrays.asList(pdfModel), byteArrayOutputStream);
700
        final HttpHeaders headers = new HttpHeaders();
701
        //headers.setContentDispositionFormData("inline", number + ".pdf");
702
        headers.add(HttpHeaders.CONTENT_DISPOSITION, "inline;filename=" + pdfModel.getInvoiceNumber() + ".pdf");
703
        int contentLength = byteArrayOutputStream.toByteArray().length;
704
        final InputStream inputStream = new ByteArrayInputStream(byteArrayOutputStream.toByteArray());
705
        final InputStreamResource inputStreamResource = new InputStreamResource(inputStream);
706
        return ResponseEntity.ok()
707
                .headers(headers)
708
                .contentLength(contentLength)
709
                .contentType(MediaType.parseMediaType("application/pdf"))
710
                .body(inputStreamResource);
711
    }
23973 govind 712
 
33213 tejus.loha 713
    @RequestMapping(value = "/wa-listen", method = RequestMethod.POST)
714
    public ResponseEntity<?> listenWhatsappStatus(@RequestBody String whatsappJsonResponse) {
715
        LOGGER.info("whatsappJsonResponse {}", whatsappJsonResponse);
716
        //jaihind
717
        //  String jsonString = "[{\"srcAddr\":\"TESTSM\",\"channel\":\"WHATSAPP\",\"externalId\":\"4977024756456780043-180044363908187691\",\"cause\":\"SUCCESS\",\"errorCode\":\"000\",\"destAddr\":\"919813272029\",\"eventType\":\"DELIVERED\",\"eventTs\":1692848106000}]";
718
        JSONArray jsonArray = new JSONArray(whatsappJsonResponse);
719
        for (int i = 0; i < jsonArray.length(); i++) {
32711 amit.gupta 720
 
33213 tejus.loha 721
            JSONObject jsonObject = jsonArray.getJSONObject(i);
722
            String externalId = jsonObject.getString("externalId");
723
            String destAddr = jsonObject.getString("destAddr");
724
            String eventType = jsonObject.getString("eventType");
725
            whatsappMessageService.setWhatsappResponse(externalId, destAddr, eventType);
726
        }
727
        //jaihind
728
        return responseSender.ok("Success");
32711 amit.gupta 729
 
33213 tejus.loha 730
    }
32271 amit.gupta 731
 
33213 tejus.loha 732
    @RequestMapping(value = "/generateInvoice")
733
    public ResponseEntity<?> generateInvoice(HttpServletRequest request, HttpServletResponse response,
35081 ranu 734
                                             @RequestParam(name = ProfitMandiConstants.ORDER_ID) int orderId) throws ProfitMandiBusinessException {
735
        LOGGER.info("Request received at url {} with params [{}={}] ", request.getRequestURI(),
736
                ProfitMandiConstants.ORDER_ID, orderId);
737
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
738
        InvoicePdfModel pdfModel = null;
739
        if (roleManager.isAdmin(fofoDetails.getRoleIds())) {
740
            pdfModel = orderService.getInvoicePdfModel(orderId);
741
        } else {
742
            pdfModel = orderService.getInvoicePdfModel(fofoDetails.getFofoId(), orderId);
743
        }
744
        FofoOrder fofoOrder = fofoOrderRepository.selectByOrderId(orderId);
745
        List<InsurancePolicy> insurancePolicies = insurancePolicyRepository.selectByRetailerIdInvoiceNumber(fofoOrder.getInvoiceNumber());
746
 
747
        // Step 1: Generate invoice PDF
748
        ByteArrayOutputStream invoiceOutput = new ByteArrayOutputStream();
749
        PdfUtils.generateAndWrite(Arrays.asList(pdfModel), invoiceOutput);
750
        byte[] invoicePdf = invoiceOutput.toByteArray();
751
 
752
        // Step 2: Load all policy certificate PDFs
753
        List<byte[]> pdfFiles = new ArrayList<>();
754
        pdfFiles.add(invoicePdf); // first add invoice
755
 
756
        for (InsurancePolicy insurancePolicy : insurancePolicies) {
757
            if (insurancePolicy.getProviderId() == 6) {
758
                String policyNumber = insurancePolicy.getPolicyNumber();
759
                String safePolicyNo = policyNumber.replace("/", "-");
760
                String filePath = "/uploads/policy-certificate-" + safePolicyNo + ".pdf";
761
                File file = new File(filePath);
762
 
763
                if (file.exists()) {
764
                    try {
765
                        byte[] policyPdf = Files.readAllBytes(file.toPath());
766
                        pdfFiles.add(policyPdf);
767
                    } catch (IOException e) {
768
                        LOGGER.error("Failed to read policy PDF: {}", filePath, e);
769
                    }
770
                } else {
771
                    LOGGER.warn("Policy PDF not found: {}", filePath);
772
                }
773
            }
774
        }
775
 
776
        // Step 3: Merge all PDFs
777
        byte[] mergedPdf;
778
        try {
779
            mergedPdf = PdfUtils.mergePdfFiles(pdfFiles);
780
        } catch (Exception e) {
781
            LOGGER.error("Error merging PDFs", e);
782
            throw new ProfitMandiBusinessException("Failed to generate merged PDF", "", "");
783
        }
784
 
785
        // Step 4: Return merged PDF as response
786
        HttpHeaders headers = new HttpHeaders();
787
        headers.setContentType(MediaType.APPLICATION_PDF);
788
        headers.setContentDispositionFormData("inline", "invoice-with-policies-" + pdfModel.getInvoiceNumber() + ".pdf");
789
        headers.setContentLength(mergedPdf.length);
790
 
791
        InputStreamResource resource = new InputStreamResource(new ByteArrayInputStream(mergedPdf));
792
        return new ResponseEntity<>(resource, headers, HttpStatus.OK);
793
    }
794
 
795
   /* @RequestMapping(value = "/generateInvoice")
796
    public ResponseEntity<?> generateInvoice(HttpServletRequest request, HttpServletResponse response,
35066 amit 797
                                             @RequestParam(name = ProfitMandiConstants.ORDER_ID) int orderId, @RequestParam(required = false) PrinterType printerType) throws ProfitMandiBusinessException {
33213 tejus.loha 798
        LOGGER.info("Request received at url {} with params [{}={}] ", request.getRequestURI(),
799
                ProfitMandiConstants.ORDER_ID, orderId);
800
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
801
        InvoicePdfModel pdfModel = null;
35066 amit 802
        int fofoId;
33213 tejus.loha 803
        if (roleManager.isAdmin(fofoDetails.getRoleIds())) {
804
            pdfModel = orderService.getInvoicePdfModel(orderId);
35066 amit 805
            fofoId = pdfModel.getCustomer().getCustomerId();
33213 tejus.loha 806
        } else {
807
            pdfModel = orderService.getInvoicePdfModel(fofoDetails.getFofoId(), orderId);
35066 amit 808
            fofoId = fofoDetails.getFofoId();
33213 tejus.loha 809
        }
35066 amit 810
 
811
        if (printerType == null) {
812
            FofoStore fs = fofoStoreRepository.selectByRetailerId(fofoId);
813
            //printerType = fs.getPrinterType();
814
        }
815
 
816
 
34805 ranu 817
        FofoOrder fofoOrder = fofoOrderRepository.selectByOrderId(orderId);
818
        List<InsurancePolicy> insurancePolicies = insurancePolicyRepository.selectByRetailerIdInvoiceNumber(fofoOrder.getInvoiceNumber());
819
 
820
        // Step 1: Generate invoice PDF
821
        ByteArrayOutputStream invoiceOutput = new ByteArrayOutputStream();
35066 amit 822
 
823
        PdfUtils.generateAndWrite(Arrays.asList(pdfModel), printerType, invoiceOutput);
34805 ranu 824
        byte[] invoicePdf = invoiceOutput.toByteArray();
825
 
826
        // Step 2: Load all policy certificate PDFs
827
        List<byte[]> pdfFiles = new ArrayList<>();
828
        pdfFiles.add(invoicePdf); // first add invoice
829
 
830
        for (InsurancePolicy insurancePolicy : insurancePolicies) {
35076 ranu 831
            if (insurancePolicy.getProviderId() == 6) {
832
                String policyNumber = insurancePolicy.getPolicyNumber();
833
                String safePolicyNo = policyNumber.replace("/", "-");
834
                String filePath = "/uploads/policy-certificate-" + safePolicyNo + ".pdf";
835
                File file = new File(filePath);
34805 ranu 836
 
35076 ranu 837
                if (file.exists()) {
838
                    try {
839
                        byte[] policyPdf = Files.readAllBytes(file.toPath());
840
                        pdfFiles.add(policyPdf);
841
                    } catch (IOException e) {
842
                        LOGGER.error("Failed to read policy PDF: {}", filePath, e);
843
                    }
844
                } else {
845
                    LOGGER.warn("Policy PDF not found: {}", filePath);
34805 ranu 846
                }
847
            }
35076 ranu 848
 
34805 ranu 849
        }
850
 
851
        // Step 3: Merge all PDFs
852
        byte[] mergedPdf;
853
        try {
854
            mergedPdf = PdfUtils.mergePdfFiles(pdfFiles);
855
        } catch (Exception e) {
856
            LOGGER.error("Error merging PDFs", e);
857
            throw new ProfitMandiBusinessException("Failed to generate merged PDF", "", "");
858
        }
859
 
860
        // Step 4: Return merged PDF as response
861
        HttpHeaders headers = new HttpHeaders();
33213 tejus.loha 862
        headers.setContentType(MediaType.APPLICATION_PDF);
34805 ranu 863
        headers.setContentDispositionFormData("inline", "invoice-with-policies-" + pdfModel.getInvoiceNumber() + ".pdf");
864
        headers.setContentLength(mergedPdf.length);
865
 
866
        InputStreamResource resource = new InputStreamResource(new ByteArrayInputStream(mergedPdf));
867
        return new ResponseEntity<>(resource, headers, HttpStatus.OK);
35081 ranu 868
    }*/
24087 amit.gupta 869
 
33213 tejus.loha 870
    @RequestMapping(value = "/generateInvoices")
871
    public ResponseEntity<?> generateInvoice(HttpServletRequest request, HttpServletResponse response,
872
                                             @RequestParam LocalDateTime startDate, @RequestParam LocalDateTime endDate, @RequestParam int partnerId)
873
            throws ProfitMandiBusinessException {
874
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
875
        List<InvoicePdfModel> pdfModels = new ArrayList<>();
876
        if (roleManager.isAdmin(fofoDetails.getRoleIds())) {
877
            List<Integer> orderIds = fofoOrderRepository.selectByFofoId(partnerId, startDate, endDate, 0, 0).stream()
878
                    .map(x -> x.getId()).collect(Collectors.toList());
879
            for (int orderId : orderIds) {
880
                pdfModels.add(orderService.getInvoicePdfModel(orderId));
881
            }
882
            ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
883
            PdfUtils.generateAndWrite(pdfModels, byteArrayOutputStream);
884
            LOGGER.info("Pdf Stream length {}", byteArrayOutputStream.toByteArray().length);
885
            final HttpHeaders headers = new HttpHeaders();
886
            headers.setContentType(MediaType.APPLICATION_PDF);
887
            headers.set("Content-disposition", "inline; filename=invoice-" + partnerId + ".pdf");
888
            headers.setContentLength(byteArrayOutputStream.toByteArray().length);
889
            final InputStream inputStream = new ByteArrayInputStream(byteArrayOutputStream.toByteArray());
890
            final InputStreamResource inputStreamResource = new InputStreamResource(inputStream);
891
            return new ResponseEntity<InputStreamResource>(inputStreamResource, headers, HttpStatus.OK);
892
        } else {
893
            throw new ProfitMandiBusinessException("Auth", fofoDetails.getEmailId(), "Unauthorised access");
894
        }
895
    }
23973 govind 896
 
33213 tejus.loha 897
    @RequestMapping(value = "/saleHistory")
898
    public String saleHistory(HttpServletRequest request,
899
                              @RequestParam(name = "searchValue", defaultValue = "") String searchValue,
900
                              @RequestParam(name = "searchType", defaultValue = "") SearchType searchType,
901
                              @RequestParam(required = false) LocalDateTime startTime,
902
                              @RequestParam(required = false) LocalDateTime endTime,
903
                              @RequestParam(name = "offset", defaultValue = "0") int offset,
904
                              @RequestParam(name = "limit", defaultValue = "10") int limit, Model model)
905
            throws ProfitMandiBusinessException {
906
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
32405 jai.hind 907
 
33213 tejus.loha 908
        Map<String, Object> map = orderService.getSaleHistory(loginDetails.getFofoId(), searchType, searchValue,
909
                startTime, endTime, offset, limit);
910
        model.addAllAttributes(map);
911
        return "sale-history";
912
    }
32405 jai.hind 913
 
33213 tejus.loha 914
    @RequestMapping(value = "/downloadInvoices")
915
    public ResponseEntity<?> downloadInvoices(HttpServletRequest request,
916
                                              @RequestParam(name = "searchValue", defaultValue = "") String searchValue,
917
                                              @RequestParam(name = "searchType", defaultValue = "") SearchType searchType,
918
                                              @RequestParam(required = false) LocalDateTime startTime,
919
                                              @RequestParam(required = false) LocalDateTime endTime,
920
                                              @RequestParam(name = "offset", defaultValue = "0") int offset,
921
                                              @RequestParam(name = "limit", defaultValue = "10") int limit, Model model)
922
            throws ProfitMandiBusinessException {
923
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
32409 amit.gupta 924
 
33213 tejus.loha 925
        Map<String, Object> map = orderService.getSaleHistory(loginDetails.getFofoId(), searchType, searchValue,
926
                startTime, endTime, offset, 100);
927
        List<FofoOrder> fofoOrders = (List<FofoOrder>) map.get("saleHistories");
23973 govind 928
 
33213 tejus.loha 929
        if (fofoOrders.size() == 0) {
930
            throw new ProfitMandiBusinessException("Search criteria", "", "No orders found for criteria");
931
        }
23654 amit.gupta 932
 
33213 tejus.loha 933
        final HttpHeaders headers = new HttpHeaders();
934
        headers.setContentType(MediaType.APPLICATION_PDF);
935
        headers.set("Content-disposition", "inline; filename=invoices.pdf");
936
        ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
937
        List<InvoicePdfModel> pdfModels = new ArrayList<>();
938
        for (FofoOrder fofoOrder : fofoOrders) {
939
            try {
940
                pdfModels.add(orderService.getInvoicePdfModel(fofoOrder.getId()));
941
            } catch (Exception e) {
942
                LOGGER.info("could not create invoice for {}, invoice number {}", fofoOrder.getId(),
943
                        fofoOrder.getInvoiceNumber());
944
            }
945
        }
946
        PdfUtils.generateAndWrite(pdfModels, byteArrayOutputStream);
947
        headers.setContentLength(byteArrayOutputStream.toByteArray().length);
948
        final InputStream inputStream = new ByteArrayInputStream(byteArrayOutputStream.toByteArray());
949
        final InputStreamResource inputStreamResource = new InputStreamResource(inputStream);
950
        return new ResponseEntity<InputStreamResource>(inputStreamResource, headers, HttpStatus.OK);
951
    }
23654 amit.gupta 952
 
33213 tejus.loha 953
    @RequestMapping(value = "/credit-note/{creditNoteId}")
954
    public ResponseEntity<?> downloadCreditNote(HttpServletRequest request, @PathVariable int creditNoteId)
955
            throws ProfitMandiBusinessException {
956
        CreditNotePdfModel creditNotePdfModel = orderService.getCreditNotePdfModel(creditNoteId);
957
        ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
958
        PdfUtils.generateAndWriteCustomerCreditNotes(Arrays.asList(creditNotePdfModel), byteArrayOutputStream);
959
        LOGGER.info("Pdf Stream length {}", byteArrayOutputStream.toByteArray().length);
960
        final HttpHeaders headers = new HttpHeaders();
961
        headers.setContentType(MediaType.APPLICATION_PDF);
962
        headers.set("Content-disposition",
963
                "inline; filename=invoice-" + creditNotePdfModel.getCreditNoteNumber() + ".pdf");
964
        headers.setContentLength(byteArrayOutputStream.toByteArray().length);
965
        final InputStream inputStream = new ByteArrayInputStream(byteArrayOutputStream.toByteArray());
966
        final InputStreamResource inputStreamResource = new InputStreamResource(inputStream);
967
        return new ResponseEntity<InputStreamResource>(inputStreamResource, headers, HttpStatus.OK);
968
    }
23973 govind 969
 
33213 tejus.loha 970
    @RequestMapping(value = "/getPaginatedSaleHistory")
971
    public String getSaleHistoryPaginated(HttpServletRequest request,
972
                                          @RequestParam(name = "searchValue", defaultValue = "") String searchValue,
973
                                          @RequestParam(name = "searchType", defaultValue = "") SearchType searchType,
974
                                          @RequestParam(required = false) LocalDateTime startTime,
975
                                          @RequestParam(required = false) LocalDateTime endTime,
976
                                          @RequestParam(name = "offset", defaultValue = "0") int offset,
977
                                          @RequestParam(name = "limit", defaultValue = "10") int limit, Model model)
978
            throws ProfitMandiBusinessException {
979
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
980
        Map<String, Object> map = orderService.getSaleHistoryPaginated(loginDetails.getFofoId(), searchType,
981
                searchValue, startTime, endTime, offset, limit);
982
        model.addAllAttributes(map);
983
        return "sale-history-paginated";
984
    }
23973 govind 985
 
33213 tejus.loha 986
    @PutMapping(value = "/updatePaymentTransaction")
987
    public String updateTransactionDetails(HttpServletRequest request, @RequestParam String referenceType,
988
                                           @RequestParam int fofoId, @RequestParam int referenceId,
989
                                           @RequestBody PartnerOptionsAndItemAmountModel partnerOptionsAndItemAmountModel,
990
                                           @RequestParam float totalAmount, Model model) throws Exception {
29707 tejbeer 991
 
33213 tejus.loha 992
        List<PaymentOptionTransactionModel> paymentOptionTransactionModels = partnerOptionsAndItemAmountModel
993
                .getPaymentOptionTransactionModel();
994
        LOGGER.info(paymentOptionTransactionModels);
995
        FofoOrder fofoOrder = fofoOrderRepository.selectByFofoIdAndOrderId(fofoId, referenceId);
35737 amit 996
        LOGGER.info("fofoOrder: {}", fofoOrder);
33213 tejus.loha 997
        fofoOrder.setTotalAmount(totalAmount);
998
        List<FofoItemIdAmountModel> fofoItemIdAmountModel = partnerOptionsAndItemAmountModel.getItemAmountModel();
35737 amit 999
 
1000
        Set<Integer> fimItemIds = fofoItemIdAmountModel.stream().map(FofoItemIdAmountModel::getItemId).collect(Collectors.toSet());
1001
        Map<Integer, Item> fimItemMap = itemRepository.selectByIds(fimItemIds).stream()
1002
                .collect(Collectors.toMap(Item::getId, item -> item));
1003
        Map<Integer, TagListing> fimTagMap = tagListingRepository.selectByItemIds(fimItemIds);
1004
        List<Integer> fimFofoItemIds = fofoItemIdAmountModel.stream().map(FofoItemIdAmountModel::getFofoItemId).collect(Collectors.toList());
1005
        Map<Integer, FofoOrderItem> fimFofoItemMap = fofoOrderItemRepository.selectByIds(fimFofoItemIds).stream()
1006
                .collect(Collectors.toMap(FofoOrderItem::getId, foi -> foi));
1007
 
33213 tejus.loha 1008
        for (FofoItemIdAmountModel fim : fofoItemIdAmountModel) {
35737 amit 1009
            LOGGER.info("fim: {}", fim.getFofoItemId());
1010
            LOGGER.info("fimAmount: {}", fim.getAmount());
1011
            Item item = fimItemMap.get(fim.getItemId());
1012
            TagListing tagListing = fimTagMap.get(item.getId());
1013
            FofoOrderItem fofoOrderItem = fimFofoItemMap.get(fim.getFofoItemId());
1014
            LOGGER.info("category: {}", item.getCategoryId());
33213 tejus.loha 1015
            if (item.getCategoryId() == ProfitMandiConstants.MOBILE_CATEGORY_ID) {
1016
                if (fofoOrderItem.getMop() <= fim.getAmount()) {
23973 govind 1017
 
33213 tejus.loha 1018
                    if (fim.getAmount() <= tagListing.getMrp()) {
1019
                        fofoOrderItem.setSellingPrice(fim.getAmount());
1020
                    } else {
1021
                        throw new ProfitMandiBusinessException("Amount", fim.getAmount(),
1022
                                "Sum of amount is not less than  to MRP");
1023
                    }
23973 govind 1024
 
35737 amit 1025
                    LOGGER.info("fofoOrderItem2: {}", fofoOrderItem);
23973 govind 1026
 
33213 tejus.loha 1027
                } else {
1028
                    // TODO below mop condition need to added added
1029
                    fofoOrderItem.setSellingPrice(fim.getAmount());
1030
                }
23973 govind 1031
 
33213 tejus.loha 1032
            } else {
1033
                fofoOrderItem.setSellingPrice(fim.getAmount());
35737 amit 1034
                LOGGER.info("fofoOrderItem1: {}", fofoOrderItem);
27819 tejbeer 1035
 
33213 tejus.loha 1036
            }
35737 amit 1037
            LOGGER.info("fofoOrderItem: {}", fofoOrderItem);
23973 govind 1038
 
33213 tejus.loha 1039
        }
23973 govind 1040
 
33213 tejus.loha 1041
        /*
1042
         * for (PaymentOptionTransactionModel paymentOptionTransactionModel :
1043
         * paymentOptionTransactionModels) { amount = amount +
1044
         * paymentOptionTransactionModel.getAmount(); } LOGGER.info("FofoOrder amount" +
1045
         * fofoOrder.getUnitPrice() + "amount" + amount); if (amount ==
1046
         * fofoOrder.getUnitPrice()) {
1047
         */
1048
        if (paymentOptionTransactionModels.size() > 0) {
1049
            List<PaymentOptionTransaction> paymentOptionTransactions = paymentOptionTransactionRepository
1050
                    .selectByReferenceIdAndType(referenceId, PaymentOptionReferenceType.ORDER);
1051
            Map<Integer, PaymentOptionTransaction> paymentOptionIdPaymentOptionTransactionMap = this
1052
                    .paymentOptionIdPaymentOptionTransactionMap(paymentOptionTransactions);
35737 amit 1053
            LOGGER.info("paymentOptionIdPaymentOptionTransactionMap: {}", paymentOptionIdPaymentOptionTransactionMap.keySet());
33213 tejus.loha 1054
            for (PaymentOptionTransactionModel paymentOptionTransactionModel : paymentOptionTransactionModels) {
1055
                if (paymentOptionIdPaymentOptionTransactionMap
1056
                        .containsKey(paymentOptionTransactionModel.getPaymentOptionId())) {
23973 govind 1057
 
33213 tejus.loha 1058
                    PaymentOptionTransaction paymentOptionTransaction = paymentOptionIdPaymentOptionTransactionMap
1059
                            .get(paymentOptionTransactionModel.getPaymentOptionId());
31739 amit.gupta 1060
 
33213 tejus.loha 1061
                    if (paymentOptionTransactionModel.getAmount() == 0) {
1062
                        paymentOptionTransactionRepository.delete(paymentOptionTransaction);
1063
                        LOGGER.info("deleted successfully");
1064
                    } else {
24844 amit.gupta 1065
 
33213 tejus.loha 1066
                        paymentOptionTransaction.setAmount(paymentOptionTransactionModel.getAmount());
1067
                        paymentOptionTransactionRepository.persist(paymentOptionTransaction);
1068
                        LOGGER.info("updated successfully");
24281 amit.gupta 1069
 
33213 tejus.loha 1070
                    }
1071
                } else {
1072
                    if (paymentOptionTransactionModel.getAmount() > 0) {
1073
                        PaymentOptionTransaction paymentOptionTransaction = new PaymentOptionTransaction();
1074
                        paymentOptionTransaction.setReferenceId(referenceId);
1075
                        paymentOptionTransaction.setReferenceType(PaymentOptionReferenceType.ORDER);
1076
                        paymentOptionTransaction.setPaymentOptionId(paymentOptionTransactionModel.getPaymentOptionId());
1077
                        paymentOptionTransaction.setAmount(paymentOptionTransactionModel.getAmount());
1078
                        paymentOptionTransaction.setFofoId(fofoId);
1079
                        paymentOptionTransaction.setCreateTimestamp(fofoOrder.getCreateTimestamp());
1080
                        paymentOptionTransactionRepository.persist(paymentOptionTransaction);
1081
                        LOGGER.info("inserted successfully");
1082
                    }
1083
                }
24281 amit.gupta 1084
 
33213 tejus.loha 1085
            }
24281 amit.gupta 1086
 
33213 tejus.loha 1087
            model.addAttribute("response1", mvcResponseSender.createResponseString(true));
1088
        }
1089
        /*
1090
         * else
1091
         *
1092
         * { throw new ProfitMandiBusinessException("Amount", amount,
1093
         * "Sum of amount is not equal to total amount"); }
1094
         */
23973 govind 1095
 
33213 tejus.loha 1096
        return "response";
23973 govind 1097
 
33213 tejus.loha 1098
    }
24105 govind 1099
 
33437 ranu 1100
    @RequestMapping(value = "/order")
1101
    public String orderIndex(HttpServletRequest request, @RequestParam(name = "cartData") String cartData, Model model)
33213 tejus.loha 1102
            throws ProfitMandiBusinessException {
33437 ranu 1103
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1104
 
1105
        int addressId = retailerRegisteredAddressRepository.selectAddressIdByRetailerId(loginDetails.getFofoId());
1106
        Address address = addressRepository.selectById(addressId);
1107
 
1108
        List<CartFofo> cartItems = orderService.cartCheckout(cartData);
1109
        Set<Integer> itemIds = new HashSet<>();
1110
        List<Integer> poIds = new ArrayList<>();
1111
        List<Integer> poItemIds = new ArrayList<>();
1112
        for (CartFofo cartFofo : cartItems) {
1113
            itemIds.add(cartFofo.getItemId());
1114
            if (cartFofo.getPoId() != 0) {
1115
                poIds.add(cartFofo.getPoId());
1116
                poItemIds.add(cartFofo.getPoItemId());
1117
            }
1118
        }
1119
 
1120
        PendingOrder po = null;
1121
        Customer customer = null;
1122
        PendingOrderItem poi = null;
1123
        Map<Integer, PriceModel> mopPriceMap = pricingService.getPurchasePriceMopPriceNotFound(itemIds,
1124
                loginDetails.getFofoId());
1125
        List<Integer> paymentOptionIds = fofoPartnerPaymentOptionRepository
1126
                .selectPaymentOptionIdsByFofoId(loginDetails.getFofoId());
1127
 
1128
        if (!poIds.isEmpty()) {
1129
            po = pendingOrderRepository.selectById(poIds.get(0));
1130
            customer = customerRepository.selectById(po.getCustomerId());
1131
            if (!offlineOrders.contains(po.getPayMethod())) {
1132
                paymentOptionIds.add(23);
1133
            }
1134
        }
1135
 
1136
        if (!poItemIds.isEmpty()) {
1137
            poi = pendingOrderItemRepository.selectById(poItemIds.get(0));
1138
        }
1139
 
1140
        // List<PaymentOption> paymentOptions = paymentOptionRepository.selectByIds(new
1141
        // HashSet<>(paymentOptionIds));
1142
 
1143
        List<PaymentOption> paymentOptions = paymentOptionRepository.selectActiveOption();
1144
 
35737 amit 1145
        LOGGER.info("pendingOrder: {}", po);
1146
        LOGGER.info("pendingOrderItem: {}", poi);
33437 ranu 1147
 
1148
        int onlineSellingPrice = 0;
1149
        Map<Integer, PendingOrderItem> itemIdAndPoiMap = new HashMap<>();
1150
 
1151
        if (po != null) {
1152
            List<PendingOrderItem> pendingOrderItems = pendingOrderItemRepository.selectByOrderId(po.getId());
35737 amit 1153
            Map<Integer, PendingOrderItem> poiByIdMap = pendingOrderItems.stream()
1154
                    .collect(Collectors.toMap(PendingOrderItem::getId, x -> x));
33437 ranu 1155
            if (!(po.getPayMethod().equals("EMIOD") || po.getPayMethod().equals("POD"))) {
1156
                for (CartFofo cartItem : cartItems) {
35737 amit 1157
                    PendingOrderItem pendingOItem = poiByIdMap.get(cartItem.getPoItemId());
33437 ranu 1158
                    PendingOrderPlan pendingOrderPlan = pendingOrderPlanRepository.selectByPoid(cartItem.getPoItemId());
1159
                    if (pendingOrderPlan != null) {
1160
                        onlineSellingPrice += pendingOItem.getSellingPrice() * pendingOItem.getQuantity() + pendingOrderPlan.getPremiumPrice() * pendingOItem.getQuantity();
1161
                    } else {
1162
                        onlineSellingPrice += pendingOItem.getSellingPrice() * pendingOItem.getQuantity();
1163
                    }
1164
                }
1165
            }
1166
 
35737 amit 1167
            itemIdAndPoiMap = pendingOrderItems.stream().collect(Collectors.toMap(PendingOrderItem::getItemId, x -> x));
33437 ranu 1168
        }
1169
 
33795 ranu 1170
 
1171
//        get the list of customer item for every item code start here
1172
//        ...............................................................
1173
 
1174
        LocalDateTime todayDate = LocalDateTime.now();
1175
        LocalDate todayDate2 = LocalDate.now();
1176
 
1177
        Map<Integer, List<CustomerOfferItem>> offerItemMap = new HashMap<>();
1178
        Map<Integer, List<WebOffer>> webOfferMap = new HashMap<>();
1179
 
1180
        List<CustomerOffer> customerOffers = customerOfferRepository.selectOffersByDate(todayDate);
1181
        List<Integer> customerOfferIds = customerOffers.stream().map(x -> x.getId()).distinct().collect(Collectors.toList());
34788 ranu 1182
        /*for (CartFofo cartItem : cartItems) {
33795 ranu 1183
            Item item = itemRepository.selectById(cartItem.getItemId());
33907 amit.gupta 1184
            if (customerOfferIds.size() > 0) {
33795 ranu 1185
 
33907 amit.gupta 1186
                List<CustomerOfferItem> customerOfferItems = customerOfferItemRepository.selectByOfferIds(customerOfferIds, item.getCatalogItemId(), todayDate2);
33795 ranu 1187
 
33907 amit.gupta 1188
                List<CustomerOfferItem> filteredCustomerOfferItems = customerOfferItems.stream()
1189
                        .filter(x -> x.getEndDate() != null && !x.getEndDate().isBefore(todayDate2))
1190
                        .collect(Collectors.toList());
33795 ranu 1191
 
33907 amit.gupta 1192
                offerItemMap.put(item.getId(), filteredCustomerOfferItems);
1193
            }
33818 ranu 1194
 
33907 amit.gupta 1195
 
33795 ranu 1196
            List<WebOffer> webOffers = webOfferRepository.selectAllActiveOffers().get(item.getCatalogItemId());
1197
            webOfferMap.put(item.getId(), webOffers);
34788 ranu 1198
        }*/
1199
 
1200
 
1201
        Map<Integer, ItemWiseCustomerOfferSummaryModel> offerItemSummaryMap = new HashMap<>();
35737 amit 1202
        Map<Integer, Item> cartItemMap = itemRepository.selectByIds(itemIds).stream()
1203
                .collect(Collectors.toMap(Item::getId, item -> item));
34788 ranu 1204
 
1205
        for (CartFofo cartItem : cartItems) {
35737 amit 1206
            Item item = cartItemMap.get(cartItem.getItemId());
34838 amit 1207
            List<CustomerOfferItem> customerOfferItems = null;
1208
            if (customerOfferIds.size() > 0) {
1209
                customerOfferItems = customerOfferItemRepository
1210
                        .selectByOfferIds(customerOfferIds, item.getCatalogItemId(), todayDate2)
1211
                        .stream()
1212
                        .filter(x -> x.getEndDate() != null && !x.getEndDate().isBefore(todayDate2))
1213
                        .collect(Collectors.toList());
1214
            }
34788 ranu 1215
 
1216
 
1217
            ItemWiseCustomerOfferSummaryModel summary = new ItemWiseCustomerOfferSummaryModel();
1218
            summary.setItemId(item.getId());
1219
            summary.setCatalogId(item.getCatalogItemId());
1220
 
34838 amit 1221
            if (customerOfferItems != null) {
1222
                for (CustomerOfferItem coi : customerOfferItems) {
1223
                    String key = coi.getOfferType().name() + "-" + coi.getCustomerOfferId();
34788 ranu 1224
 
34838 amit 1225
                    ItemWiseCustomerOfferSummaryModel.OfferTypeSummary typeSummary =
1226
                            summary.getOfferTypeMap().computeIfAbsent(key, k -> {
1227
                                ItemWiseCustomerOfferSummaryModel.OfferTypeSummary ts = new ItemWiseCustomerOfferSummaryModel.OfferTypeSummary();
1228
                                ts.setOfferType(coi.getOfferType());
1229
                                ts.setCustomerOfferId(coi.getCustomerOfferId());
1230
                                return ts;
1231
                            });
34788 ranu 1232
 
34838 amit 1233
                    typeSummary.setTotalSchemePayout(typeSummary.getTotalSchemePayout() + coi.getSchemePayout());
1234
                    typeSummary.setTotalDealerPayout(typeSummary.getTotalDealerPayout() + coi.getDealerPayout());
1235
                    typeSummary.getDescriptions().add(coi.getAdditionalInfo());
1236
                    typeSummary.getOfferItemIds().add(coi.getId());
1237
                }
34788 ranu 1238
            }
1239
 
1240
            offerItemSummaryMap.put(item.getId(), summary);
33795 ranu 1241
        }
1242
 
34788 ranu 1243
 
33795 ranu 1244
//        get the list of customer item for every item code end here
1245
//        ...............................................................
1246
 
33437 ranu 1247
        LOGGER.info("itemIdAndPoiMap {}", itemIdAndPoiMap);
1248
        LOGGER.info("mopPriceMap {}", mopPriceMap);
1249
        model.addAttribute("stateNames",
1250
                stateRepository.selectAll().stream().map(x -> x.getName()).collect(Collectors.toList()));
1251
        model.addAttribute("retailerStateName", address.getState());
1252
        model.addAttribute("pendingPOCustomer", gson.toJson(customer));
1253
        model.addAttribute("pendingPO", gson.toJson(po));
1254
 
1255
        model.addAttribute("cartItems", cartItems);
1256
        model.addAttribute("pendingOrder", po);
1257
        model.addAttribute("pendingOrderItem", poi);
1258
        model.addAttribute("itemIdAndPoiMap", itemIdAndPoiMap);
1259
        model.addAttribute("onlineSellingPrice", onlineSellingPrice);
1260
 
1261
        model.addAttribute("mopPriceMap", mopPriceMap);
1262
        model.addAttribute("paymentOptions", paymentOptions);
1263
        model.addAttribute("accessoriesDeals", accessoriesDeals);
33795 ranu 1264
        model.addAttribute("webOfferMap", webOfferMap);
34788 ranu 1265
        model.addAttribute("offerItemSummaryMap", offerItemSummaryMap);
35726 vikas 1266
 
1267
        // Fetch pinelabs offers from cache and group by issuer display name
1268
        Map<Integer, Map<String, List<Tenure>>> pinelabsOfferMap =
1269
                pinelabsOfferCacheService.getGroupedCachedOffersForItems(new ArrayList<>(itemIds));
1270
        model.addAttribute("pinelabsOfferMap", pinelabsOfferMap);
1271
 
33437 ranu 1272
        return "order-index";
1273
    }
1274
 
1275
    private Map<String, List<MobileInsurancePlan>> getPlans(float sellingPrice, int itemId, int poiId)
1276
            throws ProfitMandiBusinessException {
33213 tejus.loha 1277
        try {
33437 ranu 1278
            Map<String, List<MobileInsurancePlan>> productDurationPlans = new HashMap<>();
1279
            PendingOrderPlan pendingOrderPlan = null;
1280
            if (poiId > 0) {
1281
                pendingOrderPlan = pendingOrderPlanRepository.selectByPoid(poiId);
1282
            }
1283
            if (pendingOrderPlan != null) {
33715 ranu 1284
                MobileInsurancePlan productDurationPlan = insuranceService.getPlanById(String.valueOf(pendingOrderPlan.getPlanId()), sellingPrice);
33437 ranu 1285
                productDurationPlans.put(pendingOrderPlan.getPlanName(), Collections.singletonList(productDurationPlan));
1286
 
1287
            } else {
1288
                productDurationPlans = insuranceService.getAllPlans(itemId,
1289
                        sellingPrice, false);
1290
            }
1291
 
33213 tejus.loha 1292
            return productDurationPlans;
1293
        } catch (Exception e) {
1294
            LOGGER.info(e, e);
1295
            throw new ProfitMandiBusinessException("Fetch Insurance Plans", "Insurance",
1296
                    "Could not fetch insurance Plans");
1297
        }
24105 govind 1298
 
33213 tejus.loha 1299
    }
23973 govind 1300
 
33795 ranu 1301
 
1302
    @GetMapping("/getItemWiseUpgradeOffer")
1303
    public String getItemWiseUpgradeOffer(HttpServletRequest request, @RequestParam int itemId, Model model)
1304
            throws ProfitMandiBusinessException {
1305
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1306
 
1307
        Item item = itemRepository.selectById(itemId);
1308
 
1309
        LocalDateTime todayDate = LocalDateTime.now();
1310
        LocalDate todayDate2 = LocalDate.now();
1311
 
1312
        List<CustomerOffer> customerOffers = customerOfferRepository.selectOffersByDate(todayDate);
1313
        Map<Integer, CustomerOffer> customerOfferMap = customerOffers.stream().collect(Collectors.toMap(x -> x.getId(), x -> x));
1314
        List<Integer> customerOfferIds = customerOffers.stream().map(x -> x.getId()).distinct().collect(Collectors.toList());
1315
        List<CustomerOfferItem> customerOfferItems = customerOfferItemRepository.selectByOfferIds(customerOfferIds, item.getCatalogItemId(), todayDate2);
1316
 
33818 ranu 1317
        List<CustomerOfferItem> filteredCustomerOfferItems = customerOfferItems.stream()
33822 ranu 1318
                .filter(x -> x.getEndDate() != null && !x.getEndDate().isBefore(todayDate2))
33818 ranu 1319
                .collect(Collectors.toList());
1320
 
33795 ranu 1321
        List<WebOffer> webOffers = webOfferRepository.selectAllActiveOffers().get(item.getCatalogItemId());
1322
 
1323
        model.addAttribute("webOffers", webOffers);
1324
        model.addAttribute("customerOfferMap", customerOfferMap);
33818 ranu 1325
        model.addAttribute("customerOfferItems", filteredCustomerOfferItems);
33795 ranu 1326
 
1327
        return "upgrade-customer-offer-model";
1328
    }
1329
 
33213 tejus.loha 1330
    @GetMapping("/insuranceDetails")
1331
    public String getInsuranceDetails(HttpServletRequest request,
1332
                                      @RequestParam(name = "offset", defaultValue = "0") int offset,
1333
                                      @RequestParam(name = "limit", defaultValue = "10") int limit, Model model)
1334
            throws ProfitMandiBusinessException {
1335
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1336
        long size = 0;
1337
        List<InsurancePolicy> insurancePolicies = insurancePolicyRepository.selectByRetailerId(loginDetails.getFofoId(),
1338
                offset, limit);
1339
        size = insurancePolicyRepository.selectCountByRetailerId(loginDetails.getFofoId());
1340
        Map<Integer, String> providerPolicyNameAndIdMap = insuranceProviderRepository
1341
                .selectByIds(insurancePolicies.stream().map(x -> x.getProviderId()).collect(Collectors.toSet()))
1342
                .stream().collect(Collectors.toMap(InsuranceProvider::getId, InsuranceProvider::getName));
1343
        if (size < limit) {
1344
            model.addAttribute("end", offset + size);
1345
        } else {
1346
            model.addAttribute("end", offset + limit);
1347
        }
1348
        model.addAttribute("start", offset + 1);
1349
        model.addAttribute("size", size);
1350
        model.addAttribute("insurancePolicies", insurancePolicies);
1351
        model.addAttribute("providerPolicyNameAndIdMap", providerPolicyNameAndIdMap);
1352
        return "insurance-details";
1353
    }
28339 tejbeer 1354
 
33213 tejus.loha 1355
    @GetMapping("/insuranceDetailsPaginated")
1356
    public String getInsuranceDetailsPaginated(HttpServletRequest request,
1357
                                               @RequestParam(name = "offset", defaultValue = "0") int offset,
1358
                                               @RequestParam(name = "limit", defaultValue = "10") int limit, Model model)
1359
            throws ProfitMandiBusinessException {
1360
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1361
        List<InsurancePolicy> insurancePolicies = insurancePolicyRepository.selectByRetailerId(loginDetails.getFofoId(),
1362
                offset, limit);
1363
        Map<Integer, String> providerPolicyNameAndIdMap = insuranceProviderRepository
1364
                .selectByIds(insurancePolicies.stream().map(x -> x.getProviderId()).collect(Collectors.toSet()))
1365
                .stream().collect(Collectors.toMap(InsuranceProvider::getId, InsuranceProvider::getName));
1366
        model.addAttribute("insurancePolicies", insurancePolicies);
1367
        model.addAttribute("providerPolicyNameAndIdMap", providerPolicyNameAndIdMap);
1368
        return "insurance-details-paginated";
1369
    }
23973 govind 1370
 
33213 tejus.loha 1371
    @GetMapping("/getMouForm")
1372
    public String getMouForm(HttpServletRequest request, Model model) throws Exception {
1373
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
21985 kshitij.so 1374
 
33213 tejus.loha 1375
        Mou mou = mouRepository.selectByFofoId(loginDetails.getFofoId());
1376
        if (mou != null) {
1377
            if (mou.getUpdateTimestamp().getMonth().equals(LocalDateTime.now().getMonth())) {
1378
                model.addAttribute("response1", mvcResponseSender.createResponseString(true));
1379
            } else {
1380
                model.addAttribute("response1", mvcResponseSender.createResponseString(false));
1381
            }
32238 amit.gupta 1382
 
33213 tejus.loha 1383
        } else {
1384
            model.addAttribute("response1", mvcResponseSender.createResponseString(false));
32238 amit.gupta 1385
 
33213 tejus.loha 1386
        }
1387
        return "response";
32238 amit.gupta 1388
 
33213 tejus.loha 1389
    }
23973 govind 1390
 
33213 tejus.loha 1391
    @GetMapping("/pendingOrders")
1392
    public String getPendingOrders(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
1393
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1394
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1395
        Mou mou = mouRepository.selectByFofoId(loginDetails.getFofoId());
1396
        if (mou == null) {
1397
            mou = new Mou();
1398
            mou.setFofoId(loginDetails.getFofoId());
1399
            mou.setCreateTimestamp(LocalDateTime.now());
1400
            mou.setUpdateTimestamp(LocalDateTime.now());
1401
            mouRepository.persist(mou);
1402
        } else if (!mou.getUpdateTimestamp().getMonth().equals(LocalDateTime.now().getMonth())) {
1403
            mou.setUpdateTimestamp(LocalDateTime.now());
1404
        }
24844 amit.gupta 1405
 
33213 tejus.loha 1406
        List<PendingOrderItem> pendingOrderItems = pendingOrderItemRepository.selectOrderItemByStatusAndFofoId(OrderStatus.PROCESSING,
1407
                loginDetails.getFofoId());
23973 govind 1408
 
34387 vikas.jang 1409
        Map<String, List<PendingOrderPlan>> pendingOrderPlansMap = pendingOrderPlanRepository.selectAll().stream()
1410
                .collect(Collectors.groupingBy(PendingOrderPlan::getPlanId));
33213 tejus.loha 1411
        Map<String, Object> map = pendingOrderService.getItemOrders(pendingOrderItems, loginDetails.getFofoId());
1412
        model.addAttribute("inventoryMap", map.get("inventoryMap"));
33437 ranu 1413
        model.addAttribute("pendingOrderPlansMap", pendingOrderPlansMap);
33213 tejus.loha 1414
        model.addAttribute("pendingOrderItems", (List<PendingOrderItem>) map.get("pendingOrderItems"));
23973 govind 1415
 
33213 tejus.loha 1416
        model.addAttribute("isAdmin", isAdmin);
1417
        return "pending_fofo_order";
25092 amit.gupta 1418
 
33213 tejus.loha 1419
    }
25092 amit.gupta 1420
 
33400 ranu 1421
    @RequestMapping(value = "/create-order", method = RequestMethod.POST)
1422
    public String createOrder(HttpServletRequest request, @RequestBody CreateOrderRequest createOrderRequest,
34194 ranu 1423
                              Model model) throws Exception {
33400 ranu 1424
        // throw new ProfitMandiBusinessException("Billing is on hold temporarily",
1425
        // "Billing is on hold temporarily", "Billing is on hold temporarily");
1426
        LOGGER.info("request at uri {}", request.getRequestURI());
1427
        LOGGER.info("request body {}", createOrderRequest);
1428
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
1429
        int fofoOrderId = orderService.createOrder(createOrderRequest, fofoDetails.getFofoId(), accessoriesDeals);
35084 aman 1430
        try {
35064 aman 1431
            Set<Integer> fofoOrderItemIds = createOrderRequest.getFofoOrderItems()
1432
                    .stream().map(CustomFofoOrderItem::getItemId).collect(Collectors.toSet());
1433
            scratchService.processScratchOffer(fofoOrderId, createOrderRequest.getPaymentOptions(), fofoOrderItemIds);
1434
        } catch (Exception e) {
35095 aman 1435
            LOGGER.error("Exception during processScratchOffer for order {}: {}", fofoOrderId, e.getMessage(), e);
35084 aman 1436
        }
34479 tejus.loha 1437
 
34179 tejus.loha 1438
        LOGGER.info("Order has been created successfully...");
33400 ranu 1439
        return "redirect:/get-order/?orderId=" + fofoOrderId;
1440
    }
1441
 
33213 tejus.loha 1442
    @GetMapping("/billedOrders")
1443
    public String getBilledOrders(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
1444
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1445
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
25092 amit.gupta 1446
 
33400 ranu 1447
        List<PendingOrderItem> pendingOrderItems;
23973 govind 1448
 
33213 tejus.loha 1449
        if (isAdmin) {
27861 tejbeer 1450
 
33400 ranu 1451
            pendingOrderItems = pendingOrderItemRepository.selectOrderItemByStatus(OrderStatus.BILLED);
27861 tejbeer 1452
 
33213 tejus.loha 1453
        } else {
33400 ranu 1454
            pendingOrderItems = pendingOrderItemRepository.selectOrderItemByStatusAndFofoId(OrderStatus.BILLED,
33213 tejus.loha 1455
                    loginDetails.getFofoId());
33400 ranu 1456
 
1457
 
33213 tejus.loha 1458
        }
27861 tejbeer 1459
 
33400 ranu 1460
        Map<String, Object> map = pendingOrderService.getItemOrders(pendingOrderItems, loginDetails.getFofoId());
1461
        model.addAttribute("pendingOrderItems", (List<PendingOrderItem>) map.get("pendingOrderItems"));
27861 tejbeer 1462
 
33213 tejus.loha 1463
        model.addAttribute("isAdmin", isAdmin);
1464
        return "billed_order_item";
1465
    }
27861 tejbeer 1466
 
33213 tejus.loha 1467
    @GetMapping("/settledOrders")
1468
    public String getSettledOrders(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
1469
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1470
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
27861 tejbeer 1471
 
33213 tejus.loha 1472
        List<PendingOrderItem> pendingOrderItem = null;
27861 tejbeer 1473
 
33213 tejus.loha 1474
        if (isAdmin) {
24105 govind 1475
 
33213 tejus.loha 1476
            pendingOrderItem = pendingOrderItemRepository.selectOrderItemByStatus(OrderStatus.SETTLED);
24105 govind 1477
 
33213 tejus.loha 1478
        } else {
1479
            pendingOrderItem = pendingOrderItemRepository.selectOrderItemByStatusAndFofoId(OrderStatus.SETTLED,
1480
                    loginDetails.getFofoId());
1481
        }
24105 govind 1482
 
33213 tejus.loha 1483
        Map<String, Object> map = pendingOrderService.getItemOrders(pendingOrderItem, loginDetails.getFofoId());
24105 govind 1484
 
33400 ranu 1485
        model.addAttribute("pendingOrderItems", (List<PendingOrderItem>) map.get("pendingOrderItems"));
33213 tejus.loha 1486
        model.addAttribute("isAdmin", isAdmin);
1487
        return "settled_order_item";
1488
    }
27861 tejbeer 1489
 
33213 tejus.loha 1490
    @GetMapping("/unsettledOrders")
1491
    public String getunsettledOrders(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
1492
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1493
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
24105 govind 1494
 
33213 tejus.loha 1495
        List<PendingOrderItem> pendingOrderItem = null;
27861 tejbeer 1496
 
33213 tejus.loha 1497
        if (isAdmin) {
24105 govind 1498
 
33213 tejus.loha 1499
            pendingOrderItem = pendingOrderItemRepository.selectOrderItemByStatus(OrderStatus.UNSETTLED);
27861 tejbeer 1500
 
33213 tejus.loha 1501
        } else {
1502
            pendingOrderItem = pendingOrderItemRepository.selectOrderItemByStatusAndFofoId(OrderStatus.UNSETTLED,
1503
                    loginDetails.getFofoId());
1504
        }
24440 amit.gupta 1505
 
33213 tejus.loha 1506
        Map<String, Object> map = pendingOrderService.getItemOrders(pendingOrderItem, loginDetails.getFofoId());
25726 amit.gupta 1507
 
33400 ranu 1508
        model.addAttribute("pendingOrderItems", (List<PendingOrderItem>) map.get("pendingOrderItems"));
33213 tejus.loha 1509
        model.addAttribute("isAdmin", isAdmin);
1510
        return "unsettled_order_item";
1511
    }
24880 govind 1512
 
33213 tejus.loha 1513
    @GetMapping("/getPendingOrderItem")
1514
    public String getPendingOrderItem(HttpServletRequest request, @RequestParam int orderId, Model model)
1515
            throws ProfitMandiBusinessException {
1516
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1517
        Map<Integer, Item> itemMap = new HashMap<>();
1518
        Map<Integer, CurrentInventorySnapshot> inventoryMap = new HashMap<>();
1519
        PendingOrder pendingPO = pendingOrderRepository.selectById(orderId);
1520
        Customer customer = customerRepository.selectById(pendingPO.getCustomerId());
1521
        List<PendingOrderItem> pendingOrderItems = pendingOrderItemRepository.selectByOrderId(orderId);
35737 amit 1522
        Set<Integer> poItemIds = pendingOrderItems.stream().map(PendingOrderItem::getItemId).collect(Collectors.toSet());
1523
        itemMap = itemRepository.selectByIds(poItemIds).stream()
1524
                .collect(Collectors.toMap(Item::getId, item -> item));
1525
        List<CurrentInventorySnapshot> snapshots = currentInventorySnapshotRepository
1526
                .selectByFofoItemIds(pendingPO.getFofoId(), poItemIds);
1527
        for (CurrentInventorySnapshot cis : snapshots) {
1528
            LOGGER.info("cis: {}", cis);
1529
            inventoryMap.put(cis.getItemId(), cis);
33213 tejus.loha 1530
        }
28339 tejbeer 1531
 
35737 amit 1532
        LOGGER.info("inventoryMap: {}", inventoryMap);
33213 tejus.loha 1533
        model.addAttribute("pendingOrderItems", pendingOrderItems);
1534
        model.addAttribute("itemMap", itemMap);
1535
        model.addAttribute("inventoryMap", inventoryMap);
1536
        model.addAttribute("pendingPO", gson.toJson(pendingPO));
1537
        model.addAttribute("pendingPOCustomer", gson.toJson(customer));
1538
        model.addAttribute("isAdmin", roleManager.isAdmin(loginDetails.getRoleIds()));
1539
        return "pending-order-item";
1540
    }
28339 tejbeer 1541
 
33213 tejus.loha 1542
    @RequestMapping(value = "/getPendingOrderItemById", method = RequestMethod.GET)
1543
    public String getPendingOrderItemById(HttpServletRequest request, @RequestParam int id, Model model)
1544
            throws Exception {
27046 tejbeer 1545
 
33213 tejus.loha 1546
        PendingOrderItem pendingOrderItem = pendingOrderItemRepository.selectById(id);
1547
        model.addAttribute("pendingOrderItem", pendingOrderItem);
1548
        return "cancel-pending-order";
1549
    }
27046 tejbeer 1550
 
33213 tejus.loha 1551
    @RequestMapping(value = "/getPendingOrderChangePartnerById", method = RequestMethod.GET)
33367 ranu 1552
    public String getPendingOrderChangePartnerById(HttpServletRequest request, @RequestParam int id, @RequestParam String pinCode, Model model)
33213 tejus.loha 1553
            throws Exception {
28350 tejbeer 1554
 
33213 tejus.loha 1555
        PendingOrder pendingOrder = pendingOrderRepository.selectById(id);
33374 ranu 1556
        Map<Integer, CustomRetailer> customRetailersMap = retailerService.getFofoRetailers(true);
33213 tejus.loha 1557
        model.addAttribute("customRetailersMap", customRetailersMap);
1558
        model.addAttribute("pendingOrder", pendingOrder);
1559
        return "change-partner-po";
1560
    }
28358 tejbeer 1561
 
33213 tejus.loha 1562
    @RequestMapping(value = "/changePendingOrderPartner", method = RequestMethod.POST)
1563
    public String changePendingOrderPartner(HttpServletRequest request, @RequestParam int id, @RequestParam int fofoId,
1564
                                            Model model) throws Exception {
28350 tejbeer 1565
 
33213 tejus.loha 1566
        PendingOrder pendingOrder = pendingOrderRepository.selectById(id);
1567
        pendingOrder.setFofoId(fofoId);
1568
        model.addAttribute("response1", mvcResponseSender.createResponseString(true));
28339 tejbeer 1569
 
33213 tejus.loha 1570
        return "response";
1571
    }
28339 tejbeer 1572
 
33213 tejus.loha 1573
    @RequestMapping(value = "/cancelPendingOrderItem", method = RequestMethod.POST)
1574
    public String cancelPendingOrderItem(HttpServletRequest request, @RequestParam int id, @RequestParam String reason,
1575
                                         Model model) throws Exception {
28339 tejbeer 1576
 
33213 tejus.loha 1577
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1578
        PendingOrderItem pendingOrderItem = pendingOrderItemRepository.selectById(id);
28339 tejbeer 1579
 
33213 tejus.loha 1580
        pendingOrderItem.setStatus(OrderStatus.CANCELLED);
1581
        pendingOrderItem.setStatusDescription(loginDetails.getEmailId());
1582
        pendingOrderItem.setRemark(reason);
1583
        pendingOrderItem.setCancelledTimestamp(LocalDateTime.now());
1584
        PendingOrder pendingOrder = pendingOrderRepository.selectById(pendingOrderItem.getOrderId());
27046 tejbeer 1585
 
33213 tejus.loha 1586
        List<OrderStatus> status = pendingOrderItemRepository.selectByOrderId(pendingOrderItem.getOrderId()).stream()
1587
                .map(x -> x.getStatus()).collect(Collectors.toList());
28339 tejbeer 1588
 
33213 tejus.loha 1589
        Customer customer = customerRepository.selectById(pendingOrder.getCustomerId());
26647 tejbeer 1590
 
33213 tejus.loha 1591
        List<Integer> catalogIds = new ArrayList<>();
28339 tejbeer 1592
 
33213 tejus.loha 1593
        Item item = itemRepository.selectById(pendingOrderItem.getItemId());
1594
        pendingOrderItem.setItemName(item.getItemDescription());
1595
        catalogIds.add(item.getCatalogItemId());
28339 tejbeer 1596
 
33213 tejus.loha 1597
        Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);
1598
        JSONObject jsonObj = contentMap.get(item.getCatalogItemId());
1599
        pendingOrderItem.setImgUrl(jsonObj.getString("imageUrl_s"));
1600
        pendingOrder.setPendingOrderItems(Arrays.asList(pendingOrderItem));
1601
        CustomerAddress customerAddress = customerAddressRepository.selectById(pendingOrder.getCustomerAddressId());
28339 tejbeer 1602
 
33213 tejus.loha 1603
        DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy h:mm a");
28339 tejbeer 1604
 
33213 tejus.loha 1605
        Map<String, Object> emailModel = new HashMap<>();
1606
        emailModel.put("customer", customerAddress);
1607
        emailModel.put("pendingOrder", pendingOrder);
1608
        emailModel.put("date", dateTimeFormatter);
35737 amit 1609
        LOGGER.info("email: {}", customer.getEmailId());
33213 tejus.loha 1610
        String[] customerEmail = null;
1611
        if (customer.getEmailId() != null && !customer.getEmailId().isEmpty()) {
1612
            customerEmail = new String[]{customer.getEmailId()};
28339 tejbeer 1613
 
34211 vikas.jang 1614
            List<String> bccTo = Arrays.asList("vikas.jangra@smartdukaan.com");
28339 tejbeer 1615
 
33213 tejus.loha 1616
            emailService.sendMailWithAttachments("Order Cancellation", "order-cancellation.vm", emailModel,
1617
                    customerEmail, null, bccTo.toArray(new String[0]));
28339 tejbeer 1618
 
33213 tejus.loha 1619
        }
28339 tejbeer 1620
 
33213 tejus.loha 1621
        if (!status.contains(OrderStatus.PENDING) && !status.contains(OrderStatus.PROCESSING)
1622
                && !status.contains(OrderStatus.BILLED) && !status.contains(OrderStatus.UNSETTLED)
1623
                && !status.contains(OrderStatus.CLAIMED)) {
1624
            pendingOrder.setStatus(OrderStatus.CLOSED);
1625
        }
1626
        pendingOrderItemRepository.persist(pendingOrderItem);
28339 tejbeer 1627
 
33213 tejus.loha 1628
        model.addAttribute("response1", mvcResponseSender.createResponseString(true));
28339 tejbeer 1629
 
33213 tejus.loha 1630
        return "response";
1631
    }
28339 tejbeer 1632
 
33400 ranu 1633
    @GetMapping("/claimedOrders")
1634
    public String getclaimedOrders(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
33213 tejus.loha 1635
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
33400 ranu 1636
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
1637
        List<Integer> fofoIds = fofoStoreRepository.selectActiveStores().stream().map(x -> x.getId())
1638
                .collect(Collectors.toList());
28339 tejbeer 1639
 
33400 ranu 1640
        List<PendingOrderItem> pendingOrderItem = null;
28339 tejbeer 1641
 
33400 ranu 1642
        if (isAdmin) {
28339 tejbeer 1643
 
33400 ranu 1644
            pendingOrderItem = pendingOrderItemRepository.selectOrderItemByStatus(OrderStatus.CLAIMED);
1645
            Map<Integer, CustomRetailer> customRetailerMap = retailerService.getAllFofoRetailers();
28339 tejbeer 1646
 
33400 ranu 1647
            Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> customRetailerMap.get(x))
1648
                    .filter(x -> x != null).collect(Collectors.toList()).stream()
1649
                    .collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
1650
            model.addAttribute("customRetailersMap", customRetailersMap);
28339 tejbeer 1651
 
33400 ranu 1652
        } else {
1653
            pendingOrderItem = pendingOrderItemRepository.selectOrderItemByStatusAndFofoId(OrderStatus.CLAIMED,
1654
                    loginDetails.getFofoId());
1655
        }
30426 tejbeer 1656
 
33400 ranu 1657
        Map<String, Object> map = pendingOrderService.getItemOrders(pendingOrderItem, loginDetails.getFofoId());
28339 tejbeer 1658
 
33400 ranu 1659
        model.addAttribute("pendingOrderItems", map.get("pendingOrderItems"));
1660
        model.addAttribute("isAdmin", isAdmin);
1661
        return "claim_raised_order_item";
33213 tejus.loha 1662
    }
27046 tejbeer 1663
 
33213 tejus.loha 1664
    @RequestMapping(value = "/raiseClaimOrderItem", method = RequestMethod.POST)
1665
    public String raiseClaimOrderItem(HttpServletRequest request, @RequestParam int id, Model model) throws Exception {
28352 tejbeer 1666
 
33213 tejus.loha 1667
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1668
        PendingOrderItem pendingOrderItem = pendingOrderItemRepository.selectById(id);
1669
        PendingOrder pendingOrder = pendingOrderRepository.selectById(pendingOrderItem.getOrderId());
28437 tejbeer 1670
 
33213 tejus.loha 1671
        if (pendingOrder.getTotalAmount() == pendingOrder.getPaidAmount()) {
1672
            pendingOrderItem.setStatus(OrderStatus.CLAIMED);
1673
            pendingOrderItem.setClaimedTimestamp(LocalDateTime.now());
28437 tejbeer 1674
 
33213 tejus.loha 1675
        }
1676
        pendingOrderItemRepository.persist(pendingOrderItem);
1677
        model.addAttribute("response1", mvcResponseSender.createResponseString(true));
28437 tejbeer 1678
 
33213 tejus.loha 1679
        return "response";
1680
    }
28437 tejbeer 1681
 
33213 tejus.loha 1682
    @RequestMapping(value = "/verifyOrderItem", method = RequestMethod.POST)
1683
    public String verifyOrderItem(HttpServletRequest request, @RequestParam int id, Model model) throws Exception {
28437 tejbeer 1684
 
33213 tejus.loha 1685
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1686
        PendingOrderItem pendingOrderItem = pendingOrderItemRepository.selectById(id);
1687
        pendingOrderItem.setVerifiedTimestamp(LocalDateTime.now());
28352 tejbeer 1688
 
33213 tejus.loha 1689
        model.addAttribute("response1", mvcResponseSender.createResponseString(true));
26721 tejbeer 1690
 
33213 tejus.loha 1691
        return "response";
1692
    }
26721 tejbeer 1693
 
33213 tejus.loha 1694
    @RequestMapping(value = "/cancelOrderByInvoice", method = RequestMethod.POST)
1695
    public String cancelOrder(HttpServletRequest request, @RequestParam List<String> invoiceNumbers, Model model)
1696
            throws Exception {
1697
        orderService.cancelOrder(invoiceNumbers);
1698
        model.addAttribute("response1", mvcResponseSender.createResponseString(true));
26721 tejbeer 1699
 
33213 tejus.loha 1700
        return "response";
1701
    }
28352 tejbeer 1702
 
33213 tejus.loha 1703
    @RequestMapping(value = "/getOnlineOrder", method = RequestMethod.GET)
1704
    public String cancelOrder(HttpServletRequest request, Model model) throws Exception {
1705
        return "online-order";
1706
    }
28352 tejbeer 1707
 
33400 ranu 1708
    @RequestMapping(value = "/deliveredPendingOrderItem", method = RequestMethod.POST)
1709
    public String deliveredPendingOrderItem(HttpServletRequest request, @RequestParam(name = "id") int pendingOrderItemId, Model model)
1710
            throws Exception {
1711
 
1712
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1713
        PendingOrderItem pendingOrderItem = pendingOrderItemRepository.selectById(pendingOrderItemId);
1714
        PendingOrder pendingOrder = pendingOrderRepository.selectById(pendingOrderItem.getOrderId());
1715
 
1716
        //Prepaid payment successful
1717
        if (pendingOrder.getTotalAmount() == pendingOrder.getPaidAmount()) {
1718
            //pendingOrderItem.setStatus(OrderStatus.UNSETTLED);
1719
//            pendingOrderItem.setSettled(false);
1720
            pendingOrderItem.setStatus(OrderStatus.CLAIMED);
1721
            pendingOrderItem.setClaimedTimestamp(LocalDateTime.now());
1722
        } else {
1723
            pendingOrderItem.setStatus(OrderStatus.SETTLED);
1724
        }
1725
        pendingOrderItem.setDeliveredTimestamp(LocalDateTime.now());
1726
 
1727
        List<OrderStatus> pendingOrderItemStatusList = pendingOrderItemRepository.selectByOrderId(pendingOrderItem.getOrderId()).stream()
1728
                .map(x -> x.getStatus()).collect(Collectors.toList());
1729
 
1730
        List<Integer> catalogIds = new ArrayList<>();
1731
 
1732
        Item item = itemRepository.selectById(pendingOrderItem.getItemId());
1733
        pendingOrderItem.setItemName(item.getItemDescription());
1734
        catalogIds.add(item.getCatalogItemId());
1735
 
1736
        Map<Integer, JSONObject> contentMap = commonSolrService.getContentByCatalogIds(catalogIds);
1737
        JSONObject jsonObj = contentMap.get(item.getCatalogItemId());
1738
        pendingOrderItem.setImgUrl(jsonObj.getString("imageUrl_s"));
1739
        pendingOrder.setPendingOrderItems(Arrays.asList(pendingOrderItem));
1740
        CustomerAddress customerAddress = customerAddressRepository.selectById(pendingOrder.getCustomerAddressId());
1741
        DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy h:mm a");
1742
        Map<String, Object> emailModel = new HashMap<>();
1743
        emailModel.put("customer", customerAddress);
1744
        emailModel.put("pendingOrder", pendingOrder);
1745
        emailModel.put("date", dateTimeFormatter);
1746
        Customer customer = customerRepository.selectById(pendingOrder.getCustomerId());
1747
        String[] customerEmail = null;
1748
        if (customer.getEmailId() != null && !customer.getEmailId().isEmpty()) {
1749
            customerEmail = new String[]{customer.getEmailId()};
34211 vikas.jang 1750
            List<String> bccTo = Arrays.asList("vikas.jangra@smartdukaan.com");
33400 ranu 1751
 
1752
            emailService.sendMailWithAttachments("Order Delivered with SmartDukaan", "order-delivered.vm", emailModel,
1753
                    customerEmail, null, bccTo.toArray(new String[0]));
1754
 
1755
        }
1756
        if (!pendingOrderItemStatusList.contains(OrderStatus.PENDING) && !pendingOrderItemStatusList.contains(OrderStatus.PROCESSING)
1757
                && !pendingOrderItemStatusList.contains(OrderStatus.BILLED) && !pendingOrderItemStatusList.contains(OrderStatus.UNSETTLED)
1758
                && !pendingOrderItemStatusList.contains(OrderStatus.CLAIMED)) {
1759
            pendingOrder.setStatus(OrderStatus.CLOSED);
1760
        }
1761
        pendingOrderItemRepository.persist(pendingOrderItem);
1762
        model.addAttribute("response1", mvcResponseSender.createResponseString(true));
1763
 
1764
        return "response";
1765
    }
1766
 
33213 tejus.loha 1767
    @GetMapping("/getAllOrdersByStatus")
1768
    public String getAllOrdersByStatus(HttpServletRequest request, @RequestParam OrderStatus status,
1769
                                       @RequestParam(required = false) LocalDateTime startTime,
1770
                                       @RequestParam(required = false) LocalDateTime endTime, Model model) throws ProfitMandiBusinessException {
1771
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1772
        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
33437 ranu 1773
        boolean isAccountsL2AndL3 = false;
33400 ranu 1774
        if (isAdmin) {
1775
            AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
1776
            List<Position> positions = positionRepository.selectPositionByAuthId(authUser.getId());
1777
            for (Position position : positions) {
33437 ranu 1778
                if (((position.getEscalationType().equals(EscalationType.L2) || position.getEscalationType().equals(EscalationType.L3))
33400 ranu 1779
                        && position.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_ACCOUNTS)) {
33437 ranu 1780
                    isAccountsL2AndL3 = true;
33400 ranu 1781
                    break;
1782
                }
1783
            }
1784
        }
1785
 
33213 tejus.loha 1786
        LOGGER.info("startTime {}", startTime);
1787
        LOGGER.info("endTime {}", endTime);
28352 tejbeer 1788
 
33213 tejus.loha 1789
        List<PendingOrderItem> pendingOrderItems;
1790
        if (startTime == null) {
33367 ranu 1791
            LocalDate date = LocalDate.now().minusDays(15);
1792
            if (status.equals(OrderStatus.PENDING)) {
1793
                pendingOrderItems = pendingOrderItemRepository.selectByStatusAndCreateTimestamp(Collections.singletonList(status), date.atStartOfDay(), LocalDateTime.now());
1794
            } else {
1795
                pendingOrderItems = pendingOrderItemRepository.selectOrderItemByStatus(status);
1796
            }
1797
 
33213 tejus.loha 1798
        } else {
1799
            List<OrderStatus> statusList = new ArrayList<>();
1800
            if (status.equals(OrderStatus.DELIVERED)) {
1801
                statusList.add(OrderStatus.SETTLED);
1802
                statusList.add(OrderStatus.UNSETTLED);
1803
            } else {
1804
                statusList.add(status);
1805
            }
1806
            pendingOrderItems = pendingOrderItemRepository.selectByStatusAndCreateTimestamp(statusList,
1807
                    startTime.toLocalDate().atStartOfDay(), endTime);
1808
        }
28352 tejbeer 1809
 
33213 tejus.loha 1810
        List<Integer> pendingOrderIds = pendingOrderItems.stream().map(x -> x.getOrderId()).collect(Collectors.toList());
28352 tejbeer 1811
 
33213 tejus.loha 1812
        List<Integer> fofoIds = pendingOrderRepository.selectByIds(pendingOrderIds)
1813
                .stream().map(x -> x.getFofoId()).distinct().collect(Collectors.toList());
28356 tejbeer 1814
 
33213 tejus.loha 1815
        Map<Integer, CustomRetailer> customRetailerMap = retailerService.getAllFofoRetailers();
28352 tejbeer 1816
 
33213 tejus.loha 1817
        Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> customRetailerMap.get(x))
1818
                .filter(x -> x != null).collect(Collectors.toList()).stream()
1819
                .collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
1820
        model.addAttribute("customRetailersMap", customRetailersMap);
28352 tejbeer 1821
 
33213 tejus.loha 1822
        LOGGER.info("customRetailersMap {}", customRetailersMap);
28339 tejbeer 1823
 
33213 tejus.loha 1824
        Map<String, Object> map = pendingOrderService.getItemOrders(pendingOrderItems, 0);
32697 ranu 1825
 
33213 tejus.loha 1826
        model.addAttribute("pendingOrderItems", (List<PendingOrderItem>) map.get("pendingOrderItems"));
1827
        model.addAttribute("partnerInventoryMap", map.get("partnerInventoryMap"));
32697 ranu 1828
 
33213 tejus.loha 1829
        model.addAttribute("isAdmin", isAdmin);
33437 ranu 1830
        model.addAttribute("isAccountsL2AndL3", isAccountsL2AndL3);
33213 tejus.loha 1831
        return "online-order-item";
1832
    }
32697 ranu 1833
 
33400 ranu 1834
    @RequestMapping(value = "/onlinePaymentAddToPartnerWallet", method = RequestMethod.POST)
1835
    public String onlinePaymentAddToPartnerWallet(HttpServletRequest request, @RequestParam int id,
1836
                                                  Model model) throws Exception {
1837
        PendingOrderItem pendingOrderItem = pendingOrderItemRepository.selectById(id);
1838
        PendingOrder pendingOrder = pendingOrderRepository.selectById(pendingOrderItem.getOrderId());
1839
        int fofoId = pendingOrder.getFofoId();
1840
        double deductionPayment = (pendingOrderItem.getSellingPrice() * 2.36) / 100;
1841
        walletService.addAmountToWallet(fofoId, id, WalletReferenceType.ONLINE_ORDER_PAYMENT, "Online Order Payment", pendingOrderItem.getSellingPrice(), LocalDateTime.now());
1842
        walletService.consumeAmountFromWallet(fofoId, id,
1843
                WalletReferenceType.ONLINE_GATEWAY_FEE, "Payment Gatewayfee", (float) deductionPayment, LocalDateTime.now());
1844
 
1845
        pendingOrderItem.setStatus(OrderStatus.CLOSED);
1846
        pendingOrder.setStatus(OrderStatus.CLOSED);
1847
 
1848
        model.addAttribute("response1", mvcResponseSender.createResponseString(true));
1849
 
1850
        return "response";
1851
    }
1852
 
33213 tejus.loha 1853
    //TODO Tejus
1854
    @RequestMapping(value = "/getBulkOrder")
33336 tejus.loha 1855
    public String getBulkOrder(HttpServletRequest request, Model model) throws ProfitMandiBusinessException, MessagingException, IOException {
33213 tejus.loha 1856
        return "bulk-order";
1857
    }
32697 ranu 1858
 
33213 tejus.loha 1859
    @PostMapping(value = "/bulkOrder/upload")
1860
    public String uploadCatalog(HttpServletRequest request, @RequestPart("file") MultipartFile file, Model model)
1861
            throws Exception {
1862
        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
1863
        int authId = authRepository.selectByEmailOrMobile(fofoDetails.getEmailId()).getId();
1864
        LOGGER.info("authId - {}", authId);
1865
        bulkOrderService.parseBulkOrders(file, authId);
1866
        model.addAttribute("response1", mvcResponseSender.createResponseString(true));
1867
        return "response";
1868
    }
32697 ranu 1869
 
33213 tejus.loha 1870
    // This method is use for sending all pending transaction to Transation Approval menu
1871
    @RequestMapping(value = "/transaction/pendingApprovals", method = RequestMethod.GET)
1872
    public String getTransactionApproval(HttpServletRequest request, Model model) throws Exception {
33219 tejus.loha 1873
        List<TransactionApproval> transactionApprovals = transactionApprovalRepository.selectAllPending();
35737 amit 1874
        LOGGER.info("list of Approval transaction Id: {}", transactionApprovals);
33336 tejus.loha 1875
        List<TransactionApprovalModel> approvalModelList = bulkOrderService.getAllPendingTransactionApproval();
33213 tejus.loha 1876
        model.addAttribute("approvalModelList", approvalModelList);
1877
        return "transaction/transaction-approvals";
1878
    }
33092 tejus.loha 1879
 
33213 tejus.loha 1880
    @RequestMapping(value = "transaction/approval", method = RequestMethod.PUT)
1881
    public String transactionApproval(HttpServletRequest request, Model model,
1882
                                      @RequestParam int transactionId,
1883
                                      @RequestParam String remark,
1884
                                      @RequestParam TransactionApprovalStatus transactionApprovalStatus
1885
    ) throws Exception {
1886
        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
1887
        AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
1888
        int approvalId = authUser.getId();
1889
        String approvedBy = authUser.getFullName();
1890
        LocalDateTime approvedOn = LocalDateTime.now();
1891
        this.updateApprovalStatus(transactionId, approvalId, approvedBy, approvedOn, remark, transactionApprovalStatus);
1892
        model.addAttribute("response1", mvcResponseSender.createResponseString(true));
1893
        return "response";
1894
 
1895
    }
1896
 
33696 amit.gupta 1897
 
33213 tejus.loha 1898
    private void updateApprovalStatus(int transactionId, int approvalId, String approvedBy, LocalDateTime approvedOn, String remark, TransactionApprovalStatus transactionApprovalStatus) throws Exception {
1899
        TransactionApproval transactionApproval = transactionApprovalRepository.selectById(transactionId);
33336 tejus.loha 1900
        int retailerId = transactionRepository.selectById(transactionId).getRetailerId();
33213 tejus.loha 1901
        if (!transactionApproval.getStatus().equals(TransactionApprovalStatus.PENDING)) {
1902
            throw new ProfitMandiBusinessException("Transaction already Processed", "Transaction already Processed", "Transaction already Processed");
1903
        }
1904
        transactionApproval.setStatus(transactionApprovalStatus);
1905
        transactionApproval.setRemark(remark);
1906
        transactionApproval.setApprovalId(approvalId);
1907
        transactionApproval.setApprovedBy(approvedBy);
1908
        transactionApproval.setApprovedOn(approvedOn);
1909
        if (transactionApprovalStatus.equals(TransactionApprovalStatus.APPROVED)) {
34313 ranu 1910
            transactionService.processTransaction(transactionId, 0);
35971 aman 1911
            // Track PO_APPROVAL on timeline (validateEvent handles duplicate/blocker checks)
1912
            try {
1913
                FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(retailerId);
1914
                if (fofoStore != null && fofoStore.getCode() != null) {
1915
                    PartnerOnBoardingPanel pob = partnerOnBoardingPanelRepository.selectByCode(fofoStore.getCode());
1916
                    if (pob != null) {
1917
                        storeTimelineTatService.onPoApprovalComplete(pob.getId());
1918
                    }
1919
                }
1920
            } catch (Exception e) {
1921
                LOGGER.error("Failed to track PO_APPROVAL timeline for transactionId: " + transactionId, e);
1922
            }
33336 tejus.loha 1923
        } else {
1924
            float totalAmount = 0;
1925
            // referense id = transaction id
1926
            // here refund the amount of an order
1927
            List<UserWalletHistory> uwhList = walletService.getAllByReference(retailerId, transactionId, WalletReferenceType.PURCHASE);
33687 amit.gupta 1928
            //Refund only if any amount is deducted from wallet for that particular Transaction
33696 amit.gupta 1929
            if (uwhList.size() > 0) {
33687 amit.gupta 1930
                totalAmount = -uwhList.get(0).getAmount();
1931
                walletService.refundToWallet(retailerId, totalAmount, transactionId, WalletReferenceType.PURCHASE, "Order canceled");
34733 amit.gupta 1932
                sdCreditService.settleBlockedLoan(transactionId, totalAmount);
33687 amit.gupta 1933
            }
33213 tejus.loha 1934
        }
1935
    }
1936
 
35965 amit 1937
    @RequestMapping(value = "/transaction/bulkOrderApprovalReport", method = RequestMethod.GET)
1938
    public String getBulkOrderApprovalReport(
1939
            @RequestParam(required = false) String startDate,
1940
            @RequestParam(required = false) String endDate,
1941
            HttpServletRequest request, Model model) throws Exception {
1942
        DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
1943
        LocalDate end = (endDate != null && !endDate.isEmpty()) ? LocalDate.parse(endDate, formatter) : LocalDate.now();
1944
        LocalDate start = (startDate != null && !startDate.isEmpty()) ? LocalDate.parse(startDate, formatter) : end.minusDays(7);
1945
        List<TransactionApprovalModel> approvalModelList = bulkOrderService.getBulkOrderApprovalReport(
1946
                start.atStartOfDay(), end.plusDays(1).atStartOfDay());
1947
        model.addAttribute("approvalModelList", approvalModelList);
1948
        model.addAttribute("startDate", start.format(formatter));
1949
        model.addAttribute("endDate", end.format(formatter));
1950
        return "transaction/bulk-order-approval-report";
1951
    }
1952
 
33213 tejus.loha 1953
    @RequestMapping(value = "/bulkOrderTemplate", method = RequestMethod.GET)
1954
    public ResponseEntity<?> bulkOrderTemplate() throws Exception {
1955
        List<List<?>> rows = new ArrayList<>();
1956
        rows.add(Arrays.asList("Mahaveer", "Change description for your reference", "175139287", "28264", "0", "4"));
1957
        rows.add(Arrays.asList("Mahaveer", "Price =0 means system price", "175139287", "28268", "0", "7"));
1958
        rows.add(Arrays.asList("Jas", "You give custom price also ", "171273247", "28264", "300", "3"));
1959
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil
1960
                .getCSVByteStream(Arrays.asList("Partner name", "Description", "Partner Id", "Item Id", "Price", "Quantity"), rows);
1961
        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Bulk order template");
1962
 
1963
        return responseEntity;
1964
 
1965
    }
34168 tejus.loha 1966
 
1967
    @Autowired
1968
    EInvoiceDetailsRepository eInvoiceDetailsRepository;
1969
 
1970
    @GetMapping("/resetIrnGeneratedPanel")
1971
    public String resetIrnGeneratedPanel() {
1972
        return "reset-irn-panel";
1973
    }
1974
 
1975
    @GetMapping("/getTransactionForIrnReset")
1976
    public String getTransactionForIrnReset(@RequestParam String invoiceNumber, Model model) throws Exception {
1977
        List<String> invoiceNumbers = Arrays.asList(invoiceNumber.split(","));
1978
        List<EInvoiceDetails> eInvoiceDetailsList = eInvoiceDetailsRepository.selectByInvoiceNumbers(invoiceNumbers);
1979
        if (invoiceNumbers.size() == eInvoiceDetailsList.size()) {
1980
            model.addAttribute("irnResetOrderModelList", new ArrayList<>());
1981
            model.addAttribute("notEligibleInvoiceNumbers", invoiceNumber);
1982
            return "eligible-irn-reset-orders";
1983
        }
1984
        Set<String> existingInvoiceInEInvoiceDtl = eInvoiceDetailsList.stream().map(x -> x.getInvoiceNumber()).collect(Collectors.toSet());
1985
        List<String> missingInvoiceInEInvoiceDtl = invoiceNumbers.stream().filter(x -> !existingInvoiceInEInvoiceDtl.contains(x)).collect(Collectors.toList());
1986
 
1987
        List<Order> orderList = orderRepository.selectByInvoiceNumbers(missingInvoiceInEInvoiceDtl).stream().filter(x -> x.getIrnGenerated() != null).collect(Collectors.toList());
1988
        Map<String, List<Order>> invoiceMap = orderList.stream().collect(Collectors.groupingBy(x -> x.getInvoiceNumber()));
1989
        Set<String> notEligibleInvoiceNumbers = new HashSet<>();
1990
        notEligibleInvoiceNumbers.addAll(existingInvoiceInEInvoiceDtl);
1991
        List<IrnResetOrderModel> irnResetOrderModelList = new ArrayList<>();
1992
        for (Map.Entry<String, List<Order>> invoiceMapEntry : invoiceMap.entrySet()) {
1993
            String invoice = invoiceMapEntry.getKey();
1994
            List<Order> orders = invoiceMapEntry.getValue();
35066 amit 1995
            LocalDate earlierDate = LocalDate.now().minusDays(5);
1996
            boolean isEligible = !orders.isEmpty() && orders.stream().allMatch(x -> x.getBillingTimestamp().toLocalDate().isAfter(earlierDate) && x.getIrnGenerated() != null);
34168 tejus.loha 1997
            if (isEligible) {
1998
                Order order = orders.get(0);
1999
                FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(order.getRetailerId());
2000
 
2001
                IrnResetOrderModel irnResetOrderModel = new IrnResetOrderModel();
2002
                irnResetOrderModel.setName(partnerOnBoardingPanelRepository.selectByCode(fofoStore.getCode()).getOutLetName());
2003
                irnResetOrderModel.setInvoiceNumber(order.getInvoiceNumber());
2004
                irnResetOrderModel.setInvoiceDate(order.getBillingTimestamp());
2005
                irnResetOrderModel.setWarehouseId(ProfitMandiConstants.WAREHOUSE_MAP.get(order.getWarehouseId()));
2006
                irnResetOrderModel.setTotalOrderValue(orders.stream().mapToDouble(Order::getTotalAmount).sum());
2007
                irnResetOrderModelList.add(irnResetOrderModel);
2008
            } else {
2009
                notEligibleInvoiceNumbers.add(invoice);
2010
            }
2011
        }
2012
        model.addAttribute("irnResetOrderModelList", irnResetOrderModelList);
2013
        model.addAttribute("notEligibleInvoiceNumbers", notEligibleInvoiceNumbers.stream().collect(Collectors.joining(", ")));
2014
        return "eligible-irn-reset-orders";
2015
    }
2016
 
2017
    @PutMapping("/resetOrdersIrn")
2018
    public String resetIrn(@RequestParam String invoiceNumbers, Model model) throws Exception {
2019
        List<String> invoices = new ArrayList<>();
2020
        if (!invoiceNumbers.isEmpty()) {
2021
            invoices = Arrays.asList(invoiceNumbers.split(","));
2022
        }
2023
        List<Order> orderList = orderRepository.selectByInvoiceNumbers(invoices);
2024
        orderList.forEach(order -> {
2025
            order.setIrnGenerated(null);
2026
        });
2027
        model.addAttribute("response1", mvcResponseSender.createResponseString(true));
2028
        return "response";
2029
    }
34179 tejus.loha 2030
 
34474 aman.kumar 2031
    @PutMapping(value = "/sendInvoiceOnWhatsApp")
2032
    public String sendInvoiceOnWhatsApp(HttpServletRequest request, @RequestParam int orderId, @RequestParam String whatsAppMobile, Model model) throws Exception {
2033
        boolean isSend = this.sendWhatsappInvoice(fofoOrderRepository.selectByOrderId(orderId), whatsAppMobile);
2034
        model.addAttribute("response1", isSend);
34179 tejus.loha 2035
        return "response";
2036
    }
2037
 
35269 ranu 2038
    @Autowired
2039
    OneAssistService oneAssistService;
34179 tejus.loha 2040
 
35269 ranu 2041
    @RequestMapping(value = "/cancelInsuranceWithoutInvoice/{applicationNumber}/{memberShipNumber}", method = RequestMethod.GET)
2042
    public String cancelInsuranceWithoutInvoice(HttpServletRequest request, @PathVariable int applicationNumber, @PathVariable int memberShipNumber, Model model) throws Exception {
2043
        CancelPlanRequestModel cancelPlanRequestModel = new CancelPlanRequestModel();
2044
        cancelPlanRequestModel.setMembershipId(Long.parseLong(String.valueOf(memberShipNumber)));
2045
        cancelPlanRequestModel.setApplicationNo(applicationNumber + "");
2046
        oneAssistService.cancelCertificate(cancelPlanRequestModel);
2047
 
2048
        model.addAttribute("response1", mvcResponseSender.createResponseString(true));
2049
 
2050
        return "response";
2051
 
2052
    }
2053
 
32409 amit.gupta 2054
}
32405 jai.hind 2055