Subversion Repositories SmartDukaan

Rev

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