Subversion Repositories SmartDukaan

Rev

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