Subversion Repositories SmartDukaan

Rev

Rev 22672 | Rev 22676 | 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
 
21689 ashik.ali 3
import java.io.ByteArrayInputStream;
4
import java.io.ByteArrayOutputStream;
5
import java.io.InputStream;
22217 ashik.ali 6
import java.time.DateTimeException;
7
import java.time.LocalDate;
22244 ashik.ali 8
import java.time.LocalDateTime;
21680 ashik.ali 9
import java.util.ArrayList;
21985 kshitij.so 10
import java.util.Collection;
21680 ashik.ali 11
import java.util.HashMap;
21612 ashik.ali 12
import java.util.HashSet;
21985 kshitij.so 13
import java.util.Iterator;
21680 ashik.ali 14
import java.util.List;
15
import java.util.Map;
21612 ashik.ali 16
import java.util.Set;
17
 
18
import javax.servlet.http.HttpServletRequest;
21689 ashik.ali 19
import javax.servlet.http.HttpServletResponse;
21612 ashik.ali 20
 
21985 kshitij.so 21
import org.json.JSONObject;
21612 ashik.ali 22
import org.slf4j.Logger;
23
import org.slf4j.LoggerFactory;
24
import org.springframework.beans.factory.annotation.Autowired;
21689 ashik.ali 25
import org.springframework.core.io.InputStreamResource;
26
import org.springframework.http.HttpHeaders;
27
import org.springframework.http.HttpStatus;
28
import org.springframework.http.MediaType;
29
import org.springframework.http.ResponseEntity;
21612 ashik.ali 30
import org.springframework.stereotype.Controller;
22064 ashik.ali 31
import org.springframework.transaction.annotation.Transactional;
21985 kshitij.so 32
import org.springframework.ui.Model;
21612 ashik.ali 33
import org.springframework.web.bind.annotation.RequestBody;
34
import org.springframework.web.bind.annotation.RequestMapping;
35
import org.springframework.web.bind.annotation.RequestMethod;
21689 ashik.ali 36
import org.springframework.web.bind.annotation.RequestParam;
21612 ashik.ali 37
 
38
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
21985 kshitij.so 39
import com.spice.profitmandi.common.model.CartFofo;
21680 ashik.ali 40
import com.spice.profitmandi.common.model.CustomAddress;
21689 ashik.ali 41
import com.spice.profitmandi.common.model.CustomCustomer;
42
import com.spice.profitmandi.common.model.CustomFofoLineItem;
43
import com.spice.profitmandi.common.model.CustomFofoOrderItem;
22217 ashik.ali 44
import com.spice.profitmandi.common.model.CustomInsurancePolicy;
21689 ashik.ali 45
import com.spice.profitmandi.common.model.CustomRetailer;
22217 ashik.ali 46
import com.spice.profitmandi.common.model.GadgetCopsInsuranceModel;
21896 ashik.ali 47
import com.spice.profitmandi.common.model.GstRate;
22660 ashik.ali 48
import com.spice.profitmandi.common.model.PdfModel;
22581 ashik.ali 49
import com.spice.profitmandi.common.model.PriceModel;
21612 ashik.ali 50
import com.spice.profitmandi.common.model.ProfitMandiConstants;
22217 ashik.ali 51
import com.spice.profitmandi.common.model.SerialNumberDetail;
52
import com.spice.profitmandi.common.util.InsuranceUtils;
21689 ashik.ali 53
import com.spice.profitmandi.common.util.PdfUtils;
21680 ashik.ali 54
import com.spice.profitmandi.common.util.StringUtils;
21896 ashik.ali 55
import com.spice.profitmandi.common.util.Utils;
22244 ashik.ali 56
import com.spice.profitmandi.common.web.util.ResponseSender;
21728 ashik.ali 57
import com.spice.profitmandi.dao.entity.catalog.Item;
22217 ashik.ali 58
import com.spice.profitmandi.dao.entity.dtr.GadgetCopsInsuranceCalc;
59
import com.spice.profitmandi.dao.entity.dtr.InsurancePolicy;
60
import com.spice.profitmandi.dao.entity.dtr.InsuranceProvider;
61
import com.spice.profitmandi.dao.entity.dtr.PolicyNumberGenerationSequence;
21728 ashik.ali 62
import com.spice.profitmandi.dao.entity.dtr.Retailer;
63
import com.spice.profitmandi.dao.entity.dtr.User;
64
import com.spice.profitmandi.dao.entity.fofo.CurrentInventorySnapshot;
65
import com.spice.profitmandi.dao.entity.fofo.Customer;
66
import com.spice.profitmandi.dao.entity.fofo.CustomerAddress;
21896 ashik.ali 67
import com.spice.profitmandi.dao.entity.fofo.FofoItemId;
21728 ashik.ali 68
import com.spice.profitmandi.dao.entity.fofo.FofoLineItem;
69
import com.spice.profitmandi.dao.entity.fofo.FofoLineItemSerialNumber;
70
import com.spice.profitmandi.dao.entity.fofo.FofoOrder;
71
import com.spice.profitmandi.dao.entity.fofo.InventoryItem;
72
import com.spice.profitmandi.dao.entity.fofo.InvoiceNumberGenerationSequence;
73
import com.spice.profitmandi.dao.entity.fofo.PaymentOption;
74
import com.spice.profitmandi.dao.entity.fofo.ScanRecord;
75
import com.spice.profitmandi.dao.entity.user.Address;
22354 ashik.ali 76
import com.spice.profitmandi.dao.entity.user.Counter;
77
import com.spice.profitmandi.dao.entity.user.PrivateDealUser;
21728 ashik.ali 78
import com.spice.profitmandi.dao.enumuration.fofo.ScanType;
21883 kshitij.so 79
import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
22217 ashik.ali 80
import com.spice.profitmandi.dao.repository.dtr.InsurancePolicyRepository;
81
import com.spice.profitmandi.dao.repository.dtr.InsuranceProviderRepository;
82
import com.spice.profitmandi.dao.repository.dtr.PolicyNumberGenerationSequenceRepository;
21728 ashik.ali 83
import com.spice.profitmandi.dao.repository.dtr.RetailerRegisteredAddressRepository;
84
import com.spice.profitmandi.dao.repository.dtr.RetailerRepository;
85
import com.spice.profitmandi.dao.repository.dtr.UserAccountRepository;
86
import com.spice.profitmandi.dao.repository.dtr.UserRepository;
87
import com.spice.profitmandi.dao.repository.fofo.CurrentInventorySnapshotRepository;
88
import com.spice.profitmandi.dao.repository.fofo.CustomerAddressRepository;
89
import com.spice.profitmandi.dao.repository.fofo.CustomerRepository;
90
import com.spice.profitmandi.dao.repository.fofo.FofoLineItemRepository;
91
import com.spice.profitmandi.dao.repository.fofo.FofoLineItemSerialNumberRepository;
92
import com.spice.profitmandi.dao.repository.fofo.FofoOrderRepository;
93
import com.spice.profitmandi.dao.repository.fofo.InventoryItemRepository;
94
import com.spice.profitmandi.dao.repository.fofo.InvoiceNumberGenerationSequenceRepository;
95
import com.spice.profitmandi.dao.repository.fofo.PaymentOptionRepository;
96
import com.spice.profitmandi.dao.repository.fofo.ScanRecordRepository;
97
import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
98
import com.spice.profitmandi.dao.repository.user.AddressRepository;
22354 ashik.ali 99
import com.spice.profitmandi.dao.repository.user.CounterRepository;
100
import com.spice.profitmandi.dao.repository.user.PrivateDealUserRepository;
22069 ashik.ali 101
import com.spice.profitmandi.service.pricing.PricingService;
22139 amit.gupta 102
import com.spice.profitmandi.web.model.LoginDetails;
21612 ashik.ali 103
import com.spice.profitmandi.web.request.CreateOrderRequest;
104
import com.spice.profitmandi.web.request.CustomPaymentOption;
21680 ashik.ali 105
import com.spice.profitmandi.web.response.ItemIdQuantityAvailability;
106
import com.spice.profitmandi.web.response.Quantity;
22069 ashik.ali 107
import com.spice.profitmandi.web.util.CookiesProcessor;
21612 ashik.ali 108
import com.spice.profitmandi.web.util.MVCResponseSender;
109
 
21985 kshitij.so 110
import in.shop2020.model.v1.catalog.ItemType;
111
 
21612 ashik.ali 112
@Controller
22037 amit.gupta 113
@Transactional(rollbackFor=Throwable.class)
21612 ashik.ali 114
public class OrderController {
115
 
116
	private static final Logger LOGGER = LoggerFactory.getLogger(OrderController.class);
21985 kshitij.so 117
 
21612 ashik.ali 118
	@Autowired
119
	OrderRepository orderRepository;
21985 kshitij.so 120
 
21612 ashik.ali 121
	@Autowired
122
	InventoryItemRepository inventoryItemRepository;
21985 kshitij.so 123
 
21612 ashik.ali 124
	@Autowired
21680 ashik.ali 125
	CurrentInventorySnapshotRepository currentInventorySnapshotRepository;
21985 kshitij.so 126
 
21680 ashik.ali 127
	@Autowired
128
	InvoiceNumberGenerationSequenceRepository invoiceNumberGenerationSequenceRepository;
21985 kshitij.so 129
 
21680 ashik.ali 130
	@Autowired
131
	CustomerRepository customerRepository;
21985 kshitij.so 132
 
21680 ashik.ali 133
	@Autowired
134
	AddressRepository addressRepository;
21985 kshitij.so 135
 
21680 ashik.ali 136
	@Autowired
137
	FofoLineItemSerialNumberRepository fofoLineItemSerialNumberRepository;
21985 kshitij.so 138
 
21680 ashik.ali 139
	@Autowired
140
	FofoLineItemRepository fofoLineItemRepository;
21985 kshitij.so 141
 
21680 ashik.ali 142
	@Autowired
143
	PaymentOptionRepository paymentOptionRepository;
21985 kshitij.so 144
 
21680 ashik.ali 145
	@Autowired
146
	ScanRecordRepository scanRecordRepository;
21985 kshitij.so 147
 
21680 ashik.ali 148
	@Autowired
149
	FofoOrderRepository fofoOrderRepository;
21985 kshitij.so 150
 
21680 ashik.ali 151
	@Autowired
21689 ashik.ali 152
	RetailerRepository retailerRepository;
21985 kshitij.so 153
 
21689 ashik.ali 154
	@Autowired
155
	UserRepository userRepository;
21985 kshitij.so 156
 
21689 ashik.ali 157
	@Autowired
158
	UserAccountRepository userAccountRepository;
21985 kshitij.so 159
 
21689 ashik.ali 160
	@Autowired
161
	RetailerRegisteredAddressRepository retailerRegisteredAddressRepository;
21985 kshitij.so 162
 
21689 ashik.ali 163
	@Autowired
21711 ashik.ali 164
	CustomerAddressRepository customerAddressRepository;
21985 kshitij.so 165
 
21711 ashik.ali 166
	@Autowired
21896 ashik.ali 167
	ItemRepository itemRepository;
22217 ashik.ali 168
 
169
	@Autowired
170
	InsuranceProviderRepository insuranceProviderRepository;
171
 
172
	@Autowired
173
	InsurancePolicyRepository insurancePolicyRepository;
174
 
175
	@Autowired
176
	PolicyNumberGenerationSequenceRepository policyNumberGenerationSequenceRepository;
21985 kshitij.so 177
 
21896 ashik.ali 178
	@Autowired
21612 ashik.ali 179
	MVCResponseSender mvcResponseSender;
21985 kshitij.so 180
 
21612 ashik.ali 181
	@Autowired
22069 ashik.ali 182
	CookiesProcessor cookiesProcessor;
183
 
184
	@Autowired
185
	PricingService pricingService;
22244 ashik.ali 186
 
22354 ashik.ali 187
	@Autowired
188
	PrivateDealUserRepository privateDealUserRepository;
22244 ashik.ali 189
 
190
	@Autowired
22354 ashik.ali 191
	CounterRepository counterRepository;
192
 
193
 
194
	@Autowired
22244 ashik.ali 195
	ResponseSender<?> responseSender;
21985 kshitij.so 196
 
197
	@RequestMapping(value = "/order")
198
	public String orderIndex(HttpServletRequest request, @RequestParam(name = "cartData") String cartData, Model model) throws Exception{
22244 ashik.ali 199
		LoginDetails loginDetails = null;
21985 kshitij.so 200
		try {
22244 ashik.ali 201
			loginDetails = cookiesProcessor.getCookiesObject(request);
21985 kshitij.so 202
		} catch (ProfitMandiBusinessException e) {
203
			model.addAttribute("loginResponse", mvcResponseSender.createResponseString("RTLR_1009", false, "/login"));
204
			return "response";
205
		}
22275 ashik.ali 206
		try{
207
			JSONObject cartObject = new JSONObject(cartData);
208
			Iterator<?> keys = cartObject.keys();
209
 
210
			Set<Integer> itemIds = new HashSet<>();
211
			List<CartFofo> cartItems = new ArrayList<CartFofo>();
212
 
213
			while( keys.hasNext() ) {
214
				String key = (String)keys.next();
215
				if ( cartObject.get(key) instanceof JSONObject ) {
216
					System.out.println(cartObject.get(key));
217
				}
218
				CartFofo cf = new CartFofo();
219
				cf.setItemId(cartObject.getJSONObject(key).getInt("itemId"));
220
				cf.setQuantity(cartObject.getJSONObject(key).getInt("quantity"));
221
 
222
				if (cf.getQuantity() <= 0){
223
					continue;
224
				}
225
				cartItems.add(cf);
226
				itemIds.add(cartObject.getJSONObject(key).getInt("itemId"));
21985 kshitij.so 227
			}
22275 ashik.ali 228
			Map<Integer, Item>  itemMap = new HashMap<Integer, Item>();
229
			if (itemIds.size() > 0){
230
				List<Item> items = itemRepository.selectByIds(itemIds);
231
				for (Item i : items){
232
					itemMap.put(i.getId(), i);
233
				}
234
 
21985 kshitij.so 235
			}
22275 ashik.ali 236
			for (CartFofo cf : cartItems){
237
				Item i = itemMap.get(cf.getItemId());
238
				if (i == null){
239
					continue;
240
				}
241
				cf.setDisplayName(getValidName(i.getBrand())+" "+getValidName(i.getModelName())+" "+getValidName(i.getModelNumber())+" "+getValidName(i.getColor()).replaceAll("\\s+", " "));
242
				cf.setItemType(i.getType());
21985 kshitij.so 243
			}
22581 ashik.ali 244
			Map<Integer, PriceModel> mopPriceMap = pricingService.getPurchasePriceMopPriceNotFound(itemIds, loginDetails.getFofoId());
22275 ashik.ali 245
			LOGGER.info("mopPriceMap {}", mopPriceMap);
246
			model.addAttribute("cartObj", cartItems);
247
			model.addAttribute("mopPriceMap", mopPriceMap);
248
			return "order-index";
249
		}catch (Exception e) {
250
			LOGGER.error("Unable to Prepare cart to place order...", e);
251
			return "error";
21985 kshitij.so 252
		}
253
	}
22660 ashik.ali 254
 
21985 kshitij.so 255
	private String getValidName(String name){
256
		return name!=null?name:"";
257
	}
21612 ashik.ali 258
 
22244 ashik.ali 259
	@RequestMapping(value = "/insurancePrices", method = RequestMethod.GET)
260
	public ResponseEntity<?> getInsurancePrices(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.PRICE) float price){
261
		LOGGER.info("Request received at url : {}", request.getRequestURI());
262
		try{
263
			Set<Float> prices = new HashSet<>();
264
			prices.add(price);
265
			return responseSender.ok(pricingService.getInsurancePrices(prices, ProfitMandiConstants.GADGET_COPS));
266
		}catch(ProfitMandiBusinessException profitMandiBusinessException){
267
			return responseSender.notFound(profitMandiBusinessException);
268
		}
269
	}
270
 
271
 
21985 kshitij.so 272
	@RequestMapping(value = "/get-order", method = RequestMethod.GET)
22244 ashik.ali 273
	public String getOrder(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.ORDER_ID) int orderId, Model model) throws ProfitMandiBusinessException, Exception{
22139 amit.gupta 274
		LoginDetails fofoDetails;
21985 kshitij.so 275
		try {
22069 ashik.ali 276
			fofoDetails = cookiesProcessor.getCookiesObject(request);
21985 kshitij.so 277
		} catch (ProfitMandiBusinessException e) {
278
			model.addAttribute("loginResponse", mvcResponseSender.createResponseString("RTLR_1009", false, "/login"));
279
			return "response";
280
		}
22277 ashik.ali 281
		try{
282
			FofoOrder fofoOrder = fofoOrderRepository.selectByFofoIdAndOrderId(fofoDetails.getFofoId(), orderId);
283
			List<FofoLineItem> fofoLineItems = fofoLineItemRepository.selectByOrderId(fofoOrder.getId());
284
			CustomerAddress customerAddress = customerAddressRepository.selectById(fofoOrder.getCustomerAddressId());
22666 amit.gupta 285
			Customer customer  = customerRepository.selectById(fofoOrder.getCustomerId());
286
			customerAddress.setPhoneNumber(customer.getMobileNumber());
22277 ashik.ali 287
			List<PaymentOption> paymentOptions = paymentOptionRepository.selectByOrderId(fofoOrder.getId());
288
			List<InsurancePolicy> insurancePolicies = insurancePolicyRepository.selectByInvoiceNumber(fofoOrder.getInvoiceNumber());
289
			model.addAttribute("fofoOrder", fofoOrder);
290
			model.addAttribute("fofoLineItems", fofoLineItems);
291
			model.addAttribute("customerBillingAddress", getBillingAddress(customerAddress));
292
			model.addAttribute("customerBillingAddressObj", customerAddress);
293
			model.addAttribute("paymentOptions", paymentOptions);
294
			model.addAttribute("insurancePolicies", insurancePolicies);
295
			return "order-details";
296
		}catch (Exception e) {
297
			LOGGER.error("Unable to get Order details...", e);
298
			return "error";
299
		}
21985 kshitij.so 300
	}
22244 ashik.ali 301
 
302
 
303
	@RequestMapping(value = "/saleDetails", method = RequestMethod.GET)
304
	public String getSaleDetails(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.ORDER_ID) int orderId, Model model) throws ProfitMandiBusinessException, Exception{
305
		LoginDetails fofoDetails;
306
		try {
307
			fofoDetails = cookiesProcessor.getCookiesObject(request);
308
		} catch (ProfitMandiBusinessException e) {
309
			model.addAttribute("loginResponse", mvcResponseSender.createResponseString("RTLR_1009", false, "/login"));
310
			return "response";
311
		}
22279 ashik.ali 312
		try{
313
			FofoOrder fofoOrder = fofoOrderRepository.selectByFofoIdAndOrderId(fofoDetails.getFofoId(), orderId);
314
			List<FofoLineItem> fofoLineItems = fofoLineItemRepository.selectByOrderId(fofoOrder.getId());
315
			CustomerAddress customerAddress = customerAddressRepository.selectById(fofoOrder.getCustomerAddressId());
316
			List<PaymentOption> paymentOptions = paymentOptionRepository.selectByOrderId(fofoOrder.getId());
317
			List<InsurancePolicy> insurancePolicies = insurancePolicyRepository.selectByInvoiceNumber(fofoOrder.getInvoiceNumber());
318
			model.addAttribute("fofoOrder", fofoOrder);
319
			model.addAttribute("fofoLineItems", fofoLineItems);
320
			model.addAttribute("customerBillingAddress", getBillingAddress(customerAddress));
321
			model.addAttribute("customerBillingAddressObj", customerAddress);
322
			model.addAttribute("paymentOptions", paymentOptions);
323
			model.addAttribute("insurancePolicies", insurancePolicies);
324
			return "sale-details";
325
		}catch (Exception e) {
326
			LOGGER.error("Unble to fetch sale details... ", e);
327
			return "error";
328
		}
22244 ashik.ali 329
	}
330
 
331
 
21985 kshitij.so 332
 
22098 kshitij.so 333
	private String getBillingAddress(CustomerAddress customerAddress) {
334
		String address = "";
335
		if ((customerAddress.getLine1() != null) && (!customerAddress.getLine1().isEmpty())) {
336
			address = address + customerAddress.getLine1();
337
			address = address + ", ";
338
		}
339
 
340
		if ((customerAddress.getLine2() != null) && (!customerAddress.getLine2().isEmpty())) {
341
			address = address + customerAddress.getLine2();
342
			address = address + ", ";
343
		}
344
 
345
		if ((customerAddress.getLandmark() != null) && (!customerAddress.getLandmark().isEmpty())) {
346
			address = address + customerAddress.getLandmark();
347
			address = address + ", ";
348
		}
349
 
350
		if ((customerAddress.getCity() != null) && (!customerAddress.getCity().isEmpty())) {
351
			address = address + customerAddress.getCity();
352
			address = address + ", ";
353
		}
354
 
355
		if ((customerAddress.getState() != null) && (!customerAddress.getState().isEmpty())) {
356
			address = address + customerAddress.getState();
357
		}
358
 
359
		if ((customerAddress.getPinCode() != null) && (!customerAddress.getPinCode().isEmpty())) {
360
			address = address + "- " + customerAddress.getPinCode();
361
		}
362
 
363
		return address;
364
	}
365
 
21985 kshitij.so 366
	@RequestMapping(value = "/create-order", method = RequestMethod.POST)
367
	public String createOrder(HttpServletRequest request, @RequestBody CreateOrderRequest createOrderRequest, Model model)  throws Throwable{
22064 ashik.ali 368
		LOGGER.info("request at uri {} body {}", request.getRequestURI(), createOrderRequest);
22139 amit.gupta 369
		LoginDetails fofoDetails;
21985 kshitij.so 370
		try {
22069 ashik.ali 371
			fofoDetails = cookiesProcessor.getCookiesObject(request);
21985 kshitij.so 372
		} catch (ProfitMandiBusinessException e) {
373
			model.addAttribute("loginResponse", mvcResponseSender.createResponseString("RTLR_1009", false, "/login"));
374
			return "response";
375
		}
22280 ashik.ali 376
		Set<Integer> itemIds = new HashSet<>();
377
		Map<Integer, Integer> itemIdQuantity = new HashMap<>(); //this is for error
378
		Map<Integer, CustomFofoLineItem> customFofoLineItemMap = new HashMap<>();
379
		Map<Integer, Float> lineItemPrice = new HashMap<>(); //this is for pricing error
22472 ashik.ali 380
 
381
		Map<Integer, Set<String>> itemIdSerialNumbers = new HashMap<>(); // 
382
 
22280 ashik.ali 383
		float totalAmount = 0;
384
		for(CustomFofoLineItem customFofoLineItem : createOrderRequest.getFofoLineItems()){
385
			itemIds.add(customFofoLineItem.getItemId());
386
			if(!customFofoLineItem.getSerialNumberDetails().isEmpty() && customFofoLineItem.getQuantity() != customFofoLineItem.getSerialNumberDetails().size()){
387
				itemIdQuantity.put(customFofoLineItem.getItemId(), customFofoLineItem.getQuantity());
388
			}
389
			if(!(customFofoLineItem.getSellingPrice() > 0)){
390
				lineItemPrice.put(customFofoLineItem.getItemId(), customFofoLineItem.getSellingPrice());
391
			}else{
22654 ashik.ali 392
				totalAmount = totalAmount + customFofoLineItem.getSellingPrice() * customFofoLineItem.getQuantity() - customFofoLineItem.getDiscountAmount();
22280 ashik.ali 393
				for(SerialNumberDetail serialNumberDetail : customFofoLineItem.getSerialNumberDetails()){
394
					if(serialNumberDetail.isInsurance() && serialNumberDetail.getAmount() > 0){
395
						totalAmount = totalAmount + serialNumberDetail.getAmount();
22217 ashik.ali 396
					}
397
				}
21680 ashik.ali 398
			}
22280 ashik.ali 399
			customFofoLineItemMap.put(customFofoLineItem.getItemId(), customFofoLineItem);
22472 ashik.ali 400
			if(!itemIdSerialNumbers.containsKey(customFofoLineItem.getItemId())){
401
				Set<String> serialNumbers = new HashSet<>();
402
				for(SerialNumberDetail serialNumberDetail : customFofoLineItem.getSerialNumberDetails()){
403
					serialNumbers.add(serialNumberDetail.getSerialNumber());
404
				}
405
 
406
				itemIdSerialNumbers.put(customFofoLineItem.getItemId(), serialNumbers);
407
			}
22280 ashik.ali 408
		}
409
		if(!itemIdQuantity.isEmpty()){
410
			// if item quantity does not match with given serialnumbers size
411
			LOGGER.error("itemId's quantity should be equal to given serialnumber size {} ", itemIdQuantity);
412
			throw new ProfitMandiBusinessException("itemIdQuantity", itemIdQuantity, "");
413
			//return "error";
414
		}
415
		try{
416
			this.validatePaymentOptionsAndTotalAmount(createOrderRequest.getPaymentOptions(), totalAmount);
417
		}catch(ProfitMandiBusinessException profitMandiBusinessException){
418
			LOGGER.error("Error occured while validating payment options : ", profitMandiBusinessException);
419
			throw profitMandiBusinessException;
420
		}
421
		if(!lineItemPrice.isEmpty()){
422
			// given fofo line item price must be greater than zero
423
			LOGGER.error("requested itemId's selling price must greater than 0");
424
			throw new ProfitMandiBusinessException(ProfitMandiConstants.PRICE, lineItemPrice, "");
425
		}
426
 
427
		List<CurrentInventorySnapshot> currentInventorySnapshots = currentInventorySnapshotRepository.selectByFofoItemIds(fofoDetails.getFofoId(), itemIds);
428
		if(itemIds.size() != currentInventorySnapshots.size()){
429
			// error
430
		}
431
		List<ItemIdQuantityAvailability> itemIdQuantityAvailabilities = new ArrayList<>(); //this is for error
432
		LOGGER.info("currentInventorySnapshots "+currentInventorySnapshots);
433
		for(CurrentInventorySnapshot currentInventorySnapshot : currentInventorySnapshots){
434
			CustomFofoLineItem customFofoLineItem = customFofoLineItemMap.get(currentInventorySnapshot.getId().getItemId());
435
			LOGGER.info("customFofoLineItem "+customFofoLineItem);
436
			if(customFofoLineItem.getQuantity() > currentInventorySnapshot.getAvailability()){
437
				ItemIdQuantityAvailability itemIdQuantityAvailability = new ItemIdQuantityAvailability();
438
				itemIdQuantityAvailability.setItemId(customFofoLineItem.getItemId());
439
				Quantity quantity = new Quantity();
440
				quantity.setAvailable(currentInventorySnapshot.getAvailability());
441
				quantity.setRequested(customFofoLineItem.getQuantity());
442
				itemIdQuantityAvailability.setQuantity(quantity);
443
				itemIdQuantityAvailabilities.add(itemIdQuantityAvailability);
21896 ashik.ali 444
			}
22280 ashik.ali 445
 
446
		}
447
 
448
 
449
 
450
		if(!itemIdQuantityAvailabilities.isEmpty()){
451
			// itemIdQuantity request is not valid
452
			LOGGER.error("Requested quantities should not be greater than currently available quantities {}", itemIdQuantityAvailabilities);
453
			throw new ProfitMandiBusinessException("itemIdQuantityAvailabilities", itemIdQuantityAvailabilities, "");
454
		}
455
 
456
 
457
 
458
		//		Set<Integer> invalidItemIdSerialNumbers = new HashSet<>();
459
		//		Map<Integer, Set<String>> itemIdSerialNumbers = new HashMap<>();
460
		//		List<InventoryItem> inventoryItems = inventoryItemRepository.selectByFofoIdItemIds(fofoDetails.getFofoId(), itemIds); //change it
461
		//		
462
		//		Map<Integer, Float> itemIdPriceDropAmount = new HashMap<>();
463
		//		
464
		//		for(InventoryItem inventoryItem : inventoryItems){
465
		//			CustomFofoLineItem customFofoLineItem = customFofoLineItemMap.get(inventoryItem.getItemId());
466
		//			if(customFofoLineItem.getSerialNumbers().isEmpty()){
467
		//				if(!(inventoryItem.getSerialNumber() == null && inventoryItem.getSerialNumber().equals(""))){
468
		//					invalidItemIdSerialNumbers.add(inventoryItem.getItemId());
469
		//				}
470
		//			}
471
		//			if(!customFofoLineItem.getSerialNumbers().isEmpty()){
472
		//				if(!customFofoLineItem.getSerialNumbers().contains(inventoryItem.getSerialNumber())){
473
		//					if(!itemIdSerialNumbers.containsKey(customFofoLineItem.getItemId())){
474
		//						Set<String> serialNumbers = new HashSet<>();
475
		//						serialNumbers.add(inventoryItem.getSerialNumber());
476
		//						itemIdSerialNumbers.put(customFofoLineItem.getItemId(), serialNumbers);
477
		//					}else{
478
		//						itemIdSerialNumbers.get(customFofoLineItem.getItemId()).add(inventoryItem.getSerialNumber());
479
		//				}
480
		//			}
481
		//			itemIdPriceDropAmount.put(inventoryItem.getItemId(), inventoryItem.getUnitPrice() - inventoryItem.getPriceDropAmount());
482
		//		}
483
 
484
		Map<Integer, Item>  itemMap = new HashMap<Integer, Item>();
485
		List<Item> items = itemRepository.selectByIds(itemIds);
486
		for (Item i : items){
487
			itemMap.put(i.getId(), i);
488
		}
489
 
490
		Set<Integer> nonSerializedItemIds = new HashSet<>();
491
		Set<String> serialNumbers = new HashSet<>();
492
		Map<String, Float> insuranceSerialNumberItemPrice = new HashMap<>();
493
		Map<String, Float> insuranceSerialNumberSaleAmount = new HashMap<>();
494
		Map<String, String> serialNumberModelName = new HashMap<>();
495
		Map<String, String> serialNumberBrand = new HashMap<>();
496
		Collection<CustomFofoLineItem> lineItemsValues = customFofoLineItemMap.values();
497
		for (CustomFofoLineItem cli : lineItemsValues){
498
 
499
			Item item = itemMap.get(cli.getItemId());
500
			if (item.getType().equals(ItemType.SERIALIZED)){
501
				for (SerialNumberDetail serialNumberDetail : cli.getSerialNumberDetails()){
502
					serialNumbers.add(serialNumberDetail.getSerialNumber());
503
					if(serialNumberDetail.isInsurance()){
504
						insuranceSerialNumberItemPrice.put(serialNumberDetail.getSerialNumber(), cli.getSellingPrice());
505
						insuranceSerialNumberSaleAmount.put(serialNumberDetail.getSerialNumber(), serialNumberDetail.getAmount());
506
						serialNumberModelName.put(serialNumberDetail.getSerialNumber(), item.getModelName());
507
						serialNumberBrand.put(serialNumberDetail.getSerialNumber(), item.getBrand());
508
					}
21680 ashik.ali 509
				}
510
			}
22280 ashik.ali 511
			else{
512
				nonSerializedItemIds.add(cli.getItemId());
22244 ashik.ali 513
			}
22280 ashik.ali 514
		}
515
 
516
		Map<Integer, List<InventoryItem>> serializedInventoryItemMap = new HashMap<Integer, List<InventoryItem>>();
517
		Map<Integer, List<InventoryItem>> nonSerializedInventoryItemMap = new HashMap<Integer, List<InventoryItem>>();
518
		Map<Integer, List<Float>> itemIdPriceDropAmount = new HashMap<>();
22472 ashik.ali 519
		//Map<String, Float> serialNumberItemPrice = new HashMap<>();
520
 
22280 ashik.ali 521
		if (!serialNumbers.isEmpty()){
522
			List<InventoryItem> serializedInventoryItems = inventoryItemRepository.selectByFofoIdSerialNumbers(fofoDetails.getFofoId(), serialNumbers);
523
			LOGGER.info("serializedInventoryItems {}", serializedInventoryItems);
524
			for (InventoryItem it : serializedInventoryItems){
525
				if (it.getGoodQuantity() == 1){
526
					if (serializedInventoryItemMap.containsKey(it.getItemId())){
527
						serializedInventoryItemMap.get(it.getItemId()).add(it);
528
						itemIdPriceDropAmount.get(it.getItemId()).
529
						add(it.getUnitPrice() - (it.getPriceDropAmount()==null?0:it.getPriceDropAmount()));
21985 kshitij.so 530
					}
22280 ashik.ali 531
					else{
532
						ArrayList<InventoryItem> tmp = new ArrayList<InventoryItem>();
533
						tmp.add(it);
534
						serializedInventoryItemMap.put(it.getItemId(), tmp);
535
						ArrayList<Float> priceDropAmouts = new ArrayList<>();
536
						priceDropAmouts.add(it.getUnitPrice() - (it.getPriceDropAmount()==null?0:it.getPriceDropAmount()));
537
						itemIdPriceDropAmount.put(it.getItemId(), priceDropAmouts);
538
					}
21985 kshitij.so 539
				}
540
			}
22280 ashik.ali 541
		}
542
 
543
		if (!nonSerializedItemIds.isEmpty()){
544
			List<InventoryItem> nonSerializedInventoryItems = inventoryItemRepository.selectByFofoIdItemIds(fofoDetails.getFofoId(), nonSerializedItemIds);
545
			for (InventoryItem it : nonSerializedInventoryItems){
546
				if (it.getGoodQuantity() > 0){
547
					if (nonSerializedInventoryItemMap.containsKey(it.getItemId())){
548
						nonSerializedInventoryItemMap.get(it.getItemId()).add(it);
22244 ashik.ali 549
					}
22280 ashik.ali 550
					else{
551
						ArrayList<InventoryItem> tmp = new ArrayList<InventoryItem>();
552
						tmp.add(it);
553
						nonSerializedInventoryItemMap.put(it.getItemId(), tmp);
554
					}
21985 kshitij.so 555
				}
556
			}
22280 ashik.ali 557
		}
558
 
559
		List<Integer> invalidItemIdSerialNumbers = new ArrayList<Integer>();
22472 ashik.ali 560
		List<Integer> itemIdNonSerializedSerialNumbers = new ArrayList<Integer>();
22280 ashik.ali 561
 
562
		for (Item i : items){
563
			CustomFofoLineItem customFofoLineItem = customFofoLineItemMap.get(i.getId());
564
			if (i.getType().equals(ItemType.SERIALIZED)){
565
				if (customFofoLineItem ==null || customFofoLineItem.getSerialNumberDetails().isEmpty()){
566
					invalidItemIdSerialNumbers.add(i.getId());
21985 kshitij.so 567
				}
568
			}
22280 ashik.ali 569
			else{
570
				if (customFofoLineItem == null || !customFofoLineItem.getSerialNumberDetails().isEmpty()){
22472 ashik.ali 571
					itemIdNonSerializedSerialNumbers.add(i.getId());
21985 kshitij.so 572
				}
22280 ashik.ali 573
			}
574
		}
575
 
576
		if(!invalidItemIdSerialNumbers.isEmpty()){
577
			LOGGER.error("Invalid itemId's serialNumbers {}", invalidItemIdSerialNumbers);
578
			// itemId's are serialized you are saying these are not serialized
579
			throw new ProfitMandiBusinessException("invalidItemIdSerialNumbers", invalidItemIdSerialNumbers, "");
580
		}
581
 
22472 ashik.ali 582
		if(!itemIdNonSerializedSerialNumbers.isEmpty()){
583
			LOGGER.error("Invalid itemId's serialNumbers {}", itemIdNonSerializedSerialNumbers);
22280 ashik.ali 584
			// itemId's are non serialized you are saying these are serialized
22472 ashik.ali 585
			throw new ProfitMandiBusinessException("itemIdNonSerializedSerialNumbers", itemIdNonSerializedSerialNumbers, "");
22280 ashik.ali 586
		}
587
 
588
		if(items.size() != itemIds.size()){
589
			LOGGER.error("Requested ItemIds not found in catalog");
590
			// invalid itemIds 
591
			throw new ProfitMandiBusinessException("invalidItemIds", "", "");
592
		}
593
 
594
		Map<Integer, List<InventoryItem>> inventoryItemsToBill = new HashMap<Integer,List<InventoryItem>>();
595
		Map<Integer, Integer> inventoryItemQuantityUsed = new HashMap<>(); //to keep track of inventoryitem quanity used for scan records insertion
596
 
597
		LOGGER.info("itemMap keys {}", itemMap.keySet());
598
		//Lets reduce quantity and decide what inventory items to use.
599
		for (Item i : items){
600
			CustomFofoLineItem customFofoLineItem = customFofoLineItemMap.get(i.getId());
601
			if (i.getType().equals(ItemType.SERIALIZED)){
602
				//TODO:handle null
603
				if (serializedInventoryItemMap.get(i.getId()) == null || customFofoLineItem.getSerialNumberDetails().size() != serializedInventoryItemMap.get(i.getId()).size()){
604
					//not enough serial numbers
605
					//LOGGER.info("serialNumbers {}", serialNumbers);
606
					LOGGER.info("serializedInventoryItemMap {}", serializedInventoryItemMap);
607
					LOGGER.info("itemId {}", i.getId());
608
					LOGGER.error("not enough serial numbers");
609
					throw new ProfitMandiBusinessException("notEnoughSerialNumbers", "", "");
21985 kshitij.so 610
				}
22280 ashik.ali 611
				List<InventoryItem> inventoryItemsSerializedserialized = serializedInventoryItemMap.get(i.getId());
612
				for (InventoryItem it : inventoryItemsSerializedserialized){
613
					it.setGoodQuantity(0);
614
					inventoryItemQuantityUsed.put(it.getId(), 1);
615
				}
616
				inventoryItemsToBill.put(i.getId(), inventoryItemsSerializedserialized);
21985 kshitij.so 617
			}
22280 ashik.ali 618
			else{
619
				List<InventoryItem> inventoryItemsNonSerialized = nonSerializedInventoryItemMap.get(i.getId());
620
				int quantityToBill = customFofoLineItem.getQuantity();
621
				int totalLeft = quantityToBill;
622
				List<InventoryItem> inventoryItemsNonSerializedUsed = new ArrayList<InventoryItem>();
623
				if (inventoryItemsNonSerialized!=null){
624
					for (InventoryItem it : inventoryItemsNonSerialized){
625
						if (totalLeft > 0){
626
							int toUse = Math.min(totalLeft, it.getGoodQuantity());
627
							inventoryItemQuantityUsed.put(it.getId(), toUse);
628
							it.setGoodQuantity(it.getGoodQuantity()  - toUse);
629
							totalLeft = totalLeft - toUse;
630
							inventoryItemsNonSerializedUsed.add(it);
22244 ashik.ali 631
						}
632
					}
21896 ashik.ali 633
				}
22280 ashik.ali 634
 
635
				if (totalLeft > 0){
636
					//not enough quanity for non-serialized
637
					System.out.println("not enough quanity for non-serialized");
638
					throw new ProfitMandiBusinessException("notEnoughQuantityForNonSerialized", "", "");
639
				}
640
				inventoryItemsToBill.put(i.getId(), inventoryItemsNonSerializedUsed);
21896 ashik.ali 641
			}
22280 ashik.ali 642
		}
643
 
644
		// mop price validation
645
		Map<Integer, Float> invalidMopItemIdPriceMap = new HashMap<>();
22581 ashik.ali 646
		Map<Integer, Float> invalidDiscountAmountMap = new HashMap<>();
647
		Map<Integer, PriceModel> itemIdMopPriceMap = pricingService.getPurchasePriceMopPriceNotFound(itemIds, fofoDetails.getFofoId());
648
		for(Map.Entry<Integer, PriceModel> entry : itemIdMopPriceMap.entrySet()){
22280 ashik.ali 649
			CustomFofoLineItem customFofoLineItem = customFofoLineItemMap.get(entry.getKey());
22551 ashik.ali 650
			if(entry.getValue().getPrice() < Float.MAX_VALUE && customFofoLineItem.getSellingPrice() < entry.getValue().getPrice()){
22280 ashik.ali 651
				invalidMopItemIdPriceMap.put(entry.getKey(), customFofoLineItem.getSellingPrice());
652
			}
22581 ashik.ali 653
			if(entry.getValue().isMop() && customFofoLineItem.getDiscountAmount() > entry.getValue().getMaxDiscountAmount()){
654
				invalidDiscountAmountMap.put(entry.getKey(), customFofoLineItem.getDiscountAmount());
655
			}
22280 ashik.ali 656
		}
657
 
658
		if(!invalidMopItemIdPriceMap.isEmpty()){
659
			LOGGER.error("Invalid itemIds selling prices{} should be greater than mop prices {}", invalidMopItemIdPriceMap, itemIdMopPriceMap);
660
			throw new ProfitMandiBusinessException("invalidMopItemIdPrice", invalidMopItemIdPriceMap, "");
661
		}
22581 ashik.ali 662
 
663
		if(!invalidMopItemIdPriceMap.isEmpty()){
664
			LOGGER.error("Invalid itemIds discount amounts {} should be less than maxDiscount prices {}", invalidDiscountAmountMap, itemIdMopPriceMap);
665
			throw new ProfitMandiBusinessException("invalidMopItemIdPrice", invalidDiscountAmountMap, "");
666
		}
22280 ashik.ali 667
 
668
		InvoiceNumberGenerationSequence invoiceNumberGenerationSequence = null;
669
		try{
670
			invoiceNumberGenerationSequence = invoiceNumberGenerationSequenceRepository.selectByFofoId(fofoDetails.getFofoId());
671
			invoiceNumberGenerationSequence.setSequence(invoiceNumberGenerationSequence.getSequence() + 1);
672
			invoiceNumberGenerationSequenceRepository.persist(invoiceNumberGenerationSequence);
673
		}catch(ProfitMandiBusinessException profitMandiBusinessException){
674
			invoiceNumberGenerationSequence = new InvoiceNumberGenerationSequence();
675
			invoiceNumberGenerationSequence.setFofoId(fofoDetails.getFofoId());
676
			invoiceNumberGenerationSequence.setPrefix("INVOICE");
677
			invoiceNumberGenerationSequence.setSequence(1);
678
			invoiceNumberGenerationSequenceRepository.persist(invoiceNumberGenerationSequence);
679
		}
680
 
681
		CustomCustomer customCustomer = createOrderRequest.getCustomer();
682
 
683
		if(!StringUtils.isValidEmailAddress(customCustomer.getEmailId())){
684
			LOGGER.error("invalid customer emailId {} ", customCustomer.getEmailId());
685
			throw new ProfitMandiBusinessException(ProfitMandiConstants.EMAIL_ID, customCustomer.getEmailId(), "");
686
		}
687
 
688
		if(!StringUtils.isValidMobile(customCustomer.getMobileNumber())){
689
			LOGGER.error("invalid customer mobileNumber {} ", customCustomer.getMobileNumber());
690
			throw new ProfitMandiBusinessException(ProfitMandiConstants.MOBILE_NUMBER, customCustomer.getMobileNumber(), "");
691
		}
692
 
693
		boolean insurance = false;
694
		for(CustomFofoLineItem customFofoLineItem : createOrderRequest.getFofoLineItems()){
695
			for(SerialNumberDetail serialNumberDetail : customFofoLineItem.getSerialNumberDetails()){
696
				if(serialNumberDetail.getAmount() > 0){
697
					insurance = true;
698
					break;
22217 ashik.ali 699
				}
700
			}
22280 ashik.ali 701
		}
702
		LOGGER.info("insurance [{}] processing ....", insurance);
703
 
704
		LocalDate customerDateOfBirth = null;
705
		if(insurance){
22244 ashik.ali 706
			try{
22280 ashik.ali 707
				customerDateOfBirth = StringUtils.toDate(createOrderRequest.getCustomerDateOfBirth());
708
			}catch(DateTimeException dateTimeException){
709
				LOGGER.error("Unable to parse dateOfBirth", dateTimeException);
710
				throw new ProfitMandiBusinessException("dateOfBirth", createOrderRequest.getCustomerDateOfBirth(), "");
22244 ashik.ali 711
			}
22280 ashik.ali 712
		}
713
 
714
		Customer customer = null;
715
		try{
716
			customer = customerRepository.selectByMobileNumber(customCustomer.getMobileNumber());
717
		}catch(ProfitMandiBusinessException profitMandiBusinessException){
718
			LOGGER.error("Error : ", profitMandiBusinessException);
719
			customer = new Customer();
720
			customer.setFirstName(customCustomer.getFirstName());
721
			customer.setLastName(customCustomer.getLastName());
722
			customer.setEmailId(customCustomer.getEmailId());
723
			customer.setMobileNumber(customCustomer.getMobileNumber());
724
			customerRepository.persist(customer);
725
		}
726
		//TODO:Check if createOrderRequest contains addressId
727
		CustomerAddress customerAddress = this.createCustomerAddress(customCustomer.getAddress());
728
		customerAddress.setCustomerId(customer.getId());
729
		customerAddressRepository.persist(customerAddress);
730
 
731
		FofoOrder fofoOrder = new FofoOrder();
732
		fofoOrder.setCustomerId(customer.getId());
733
		fofoOrder.setFofoId(fofoDetails.getFofoId());
734
		fofoOrder.setInvoiceNumber(invoiceNumberGenerationSequence.getPrefix() + invoiceNumberGenerationSequence.getSequence());
735
		fofoOrder.setTotalAmount(totalAmount);
736
		fofoOrder.setCustomerAddressId(customerAddress.getId());
737
		fofoOrderRepository.persist(fofoOrder);
738
 
739
		for(CustomPaymentOption customPaymentOption : createOrderRequest.getPaymentOptions()){
740
			PaymentOption paymentOption = new PaymentOption();
741
			paymentOption.setOrderId(fofoOrder.getId());
742
			paymentOption.setAmount(customPaymentOption.getAmount());
743
			paymentOption.setType(customPaymentOption.getType());
744
			paymentOptionRepository.persist(paymentOption);
745
		}
746
 
747
		Address retailerAddress = addressRepository.selectById(retailerRegisteredAddressRepository.selectAddressIdByRetailerId(fofoDetails.getFofoId()));
748
		Map<String, GstRate> gstRateMap = null;
749
		if(retailerAddress.getState().equals(customerAddress.getState())){
750
			gstRateMap = Utils.getGstRates(retailerAddress.getState());
751
		}else{
752
			LOGGER.info("inter gstRate = true");
753
			gstRateMap = Utils.getInterGstRates();
754
		}
755
		LOGGER.info("gstRateMap {}", gstRateMap);
756
		for(CustomFofoLineItem customFofoLineItem : createOrderRequest.getFofoLineItems()){
757
			FofoLineItem fofoLineItem = new FofoLineItem();
758
			fofoLineItem.setItemId(customFofoLineItem.getItemId());
759
			fofoLineItem.setQuantity(customFofoLineItem.getQuantity());
760
			fofoLineItem.setSellingPrice(customFofoLineItem.getSellingPrice());
761
			fofoLineItem.setOrderId(fofoOrder.getId());
762
			fofoLineItem.setDp(customFofoLineItem.getSellingPrice());
22581 ashik.ali 763
			fofoLineItem.setDiscount(customFofoLineItem.getDiscountAmount());
22280 ashik.ali 764
			Item item = itemMap.get(customFofoLineItem.getItemId());
765
			GstRate gstRate = gstRateMap.get(item.getHsnCode());
766
			fofoLineItem.setIgstRate(gstRate.getIgstRate());
767
			fofoLineItem.setCgstRate(gstRate.getCgstRate());
768
			fofoLineItem.setSgstRate(gstRate.getSgstRate());
769
			fofoLineItem.setHsnCode(gstRate.getHsnCode());
770
			List<Float> priceDropAmounts = itemIdPriceDropAmount.get(customFofoLineItem.getItemId());
771
			float cost = 0;
772
			if (priceDropAmounts!=null){
773
				for (Float pda : priceDropAmounts){
774
					cost = cost + pda;
775
				}
22217 ashik.ali 776
			}
22280 ashik.ali 777
			else{
778
				cost = customFofoLineItem.getSellingPrice()* customFofoLineItem.getQuantity();
22244 ashik.ali 779
			}
22280 ashik.ali 780
			fofoLineItem.setCost(cost);
781
			fofoLineItem.setBrand(item.getBrand());
782
			fofoLineItem.setModelName(item.getModelName());
783
			fofoLineItem.setModelNumber(item.getModelNumber());
784
			fofoLineItem.setColor(item.getColor());
785
			fofoLineItemRepository.persist(fofoLineItem);
786
			LOGGER.info("\n\n");
787
			if(!customFofoLineItem.getSerialNumberDetails().isEmpty()){
22244 ashik.ali 788
				for(SerialNumberDetail serialNumberDetail : customFofoLineItem.getSerialNumberDetails()){
22280 ashik.ali 789
					FofoLineItemSerialNumber fofoLineItemSerialNumber = new FofoLineItemSerialNumber();
790
					fofoLineItemSerialNumber.setFofoLineItemId(fofoLineItem.getId());
791
					fofoLineItemSerialNumber.setSerialNumber(serialNumberDetail.getSerialNumber());
792
					fofoLineItemSerialNumberRepository.persist(fofoLineItemSerialNumber);
22244 ashik.ali 793
				}
794
			}
22280 ashik.ali 795
 
796
			for(CurrentInventorySnapshot currentInventorySnapshot : currentInventorySnapshots){
797
				FofoItemId fofoItemId = new FofoItemId();
798
				fofoItemId.setFofoId(fofoDetails.getFofoId());
799
				fofoItemId.setItemId(fofoLineItem.getItemId());
800
				if(currentInventorySnapshot.getId().equals(fofoItemId)){
801
					currentInventorySnapshotRepository.updateAvailabilityByFofoItemId(fofoItemId, currentInventorySnapshot.getAvailability() - customFofoLineItem.getQuantity());
22217 ashik.ali 802
				}
803
			}
22280 ashik.ali 804
			List<InventoryItem> inventoryItems = inventoryItemsToBill.get(fofoLineItem.getItemId());
805
			for(InventoryItem inventoryItem : inventoryItems){
806
				inventoryItem.setLastScanType(ScanType.SALE);
807
				inventoryItemRepository.persist(inventoryItem);
808
				ScanRecord scanRecord = new ScanRecord();
809
				scanRecord.setInventoryItemId(inventoryItem.getId());
810
				scanRecord.setFofoId(fofoDetails.getFofoId());
811
				//correct this
812
				scanRecord.setQuantity(inventoryItemQuantityUsed.get(inventoryItem.getId()));
813
				scanRecord.setType(ScanType.SALE);
814
				scanRecordRepository.persist(scanRecord);
815
			}
816
		}
817
 
818
		// insurance calculation is insurance flag is enabled
819
		if(!insuranceSerialNumberItemPrice.isEmpty()){
820
			LOGGER.info("Processing for insurence for serialNumbers");
821
			Map<Float, GadgetCopsInsuranceCalc> insurancePricesMap = pricingService.getInsurancePrices(new HashSet<>(insuranceSerialNumberItemPrice.values()), ProfitMandiConstants.GADGET_COPS);
822
			InsuranceProvider insuranceProvider = insuranceProviderRepository.selectByName(ProfitMandiConstants.GADGET_COPS);
22244 ashik.ali 823
 
22280 ashik.ali 824
 
825
			Map<Float, Float> invalidInsurancePurchaseSaleAmount = new HashMap<>();
826
			Map<Float, Float> invalidInsuranceSalePurchaseAmount = new HashMap<>();
827
			for(Map.Entry<String, Float> entry : insuranceSerialNumberItemPrice.entrySet()){
828
				if(insuranceSerialNumberSaleAmount.get(entry.getKey()) < insurancePricesMap.get(entry.getValue()).getDealerPrice()){
829
					invalidInsurancePurchaseSaleAmount.put(insurancePricesMap.get(entry.getValue()).getDealerPrice(), insuranceSerialNumberSaleAmount.get(entry.getKey()));
22244 ashik.ali 830
				}
22280 ashik.ali 831
 
832
				if(insuranceSerialNumberSaleAmount.get(entry.getKey()) > insurancePricesMap.get(entry.getValue()).getSellingPrice()){
833
					invalidInsuranceSalePurchaseAmount.put(insuranceSerialNumberSaleAmount.get(entry.getKey()), insurancePricesMap.get(entry.getValue()).getDealerPrice());
22244 ashik.ali 834
				}
835
			}
836
 
22280 ashik.ali 837
			// insurance sale amount can not be lesser than insurance purchase amount
838
			if(!invalidInsurancePurchaseSaleAmount.isEmpty()){
839
				LOGGER.error("Invalid Insurance prices [{}], insurance sale amount can not be lesser than insurance purchase amount", invalidInsurancePurchaseSaleAmount);
840
				return "error";
841
			}
842
 
843
			if(!invalidInsuranceSalePurchaseAmount.isEmpty()){
844
				LOGGER.error("Invalid Insurance prices [{}], insurance sale amount can not be greater than than insurance max amount", invalidInsuranceSalePurchaseAmount);
845
				return "error";
846
			}
847
 
22472 ashik.ali 848
			Map<Float, Float> invalidInsuranceMarginAmount = new HashMap<>();
22280 ashik.ali 849
 
850
			for(Map.Entry<String, Float> entry : insuranceSerialNumberItemPrice.entrySet()){
22472 ashik.ali 851
				int itemId = this.getItemIdFromSerialNumber(itemIdSerialNumbers, entry.getKey());
22675 amit.gupta 852
				LOGGER.info("itemIdMopPriceMap.get(itemId).getPrice() -->{}", itemId);
853
				LOGGER.info("itemIdMopPriceMap.get(itemId) -->{}", itemIdMopPriceMap.get(itemId));
22551 ashik.ali 854
				float itemPurchasePrice = itemIdMopPriceMap.get(itemId).getPrice();
22472 ashik.ali 855
				float itemSellingPrice = entry.getValue();
856
				float itemMargin = itemSellingPrice - itemPurchasePrice;
857
				float insurancePurchasePrice = insurancePricesMap.get(entry.getValue()).getDealerPrice();
858
				float insuranceSellingPrice = insuranceSerialNumberSaleAmount.get(entry.getKey());
859
				float insuranceMargin = insuranceSellingPrice - insurancePurchasePrice;
860
				if(insuranceMargin < (itemMargin * 30 / 100)){
861
					invalidInsuranceMarginAmount.put(insuranceMargin, (itemMargin * 30 / 100));
862
				}
863
			}
864
 
865
			if(!invalidInsuranceMarginAmount.isEmpty()){
866
				LOGGER.error("insurance marging should be greater than equal to item profit margin insuranceMarginItemIdMargin {}", invalidInsuranceMarginAmount);
22486 ashik.ali 867
				return "error";
22472 ashik.ali 868
			}
869
 
870
 
871
			for(Map.Entry<String, Float> entry : insuranceSerialNumberItemPrice.entrySet()){
22280 ashik.ali 872
				PolicyNumberGenerationSequence policyNumberGenerationSequence = null;
873
				try{
874
					policyNumberGenerationSequence = policyNumberGenerationSequenceRepository.select();
875
					policyNumberGenerationSequence.setSequence(policyNumberGenerationSequence.getSequence() + 1);
876
					policyNumberGenerationSequenceRepository.persist(policyNumberGenerationSequence);
877
				}catch(ProfitMandiBusinessException profitMandiBusinessException){
878
					policyNumberGenerationSequence = new PolicyNumberGenerationSequence();
879
					policyNumberGenerationSequence.setSequence(1);
880
					policyNumberGenerationSequenceRepository.persist(policyNumberGenerationSequence);
22244 ashik.ali 881
				}
882
 
22280 ashik.ali 883
				InsurancePolicy insurancePolicy = new InsurancePolicy();
884
				insurancePolicy.setInvoiceNumber(invoiceNumberGenerationSequence.getPrefix() + invoiceNumberGenerationSequence.getSequence());
885
				insurancePolicy.setRetailerId(fofoDetails.getFofoId());
886
				insurancePolicy.setPurchaseAmount(insurancePricesMap.get(entry.getValue()).getDealerPrice());
887
				insurancePolicy.setSaleAmount(insuranceSerialNumberSaleAmount.get(entry.getKey()));
888
				insurancePolicy.setSellingPrice(entry.getValue());
889
				insurancePolicy.setSerialNumber(entry.getKey());
890
				insurancePolicy.setModelName(serialNumberModelName.get(entry.getKey()));
891
				insurancePolicy.setBrand(serialNumberBrand.get(entry.getKey()));
892
				insurancePolicy.setPolicyNumber(StringUtils.generatePolicyNumber(ProfitMandiConstants.POLICY_NUMBER_PREFIX, policyNumberGenerationSequence.getSequence()));
893
				insurancePolicy.setProviderId(insuranceProvider.getId());
894
				insurancePolicy.setCustomerFirstName(customer.getFirstName());
895
				insurancePolicy.setCustomerLastName(customer.getLastName());
896
				insurancePolicy.setCustomerMobileNumber(customer.getMobileNumber());
897
				insurancePolicy.setCustomerEmailId(customer.getEmailId());
898
				insurancePolicy.setCustomerDateOfBirth(customerDateOfBirth);
899
				insurancePolicy.setCustomerAddress1(customerAddress.getLine1());
900
				insurancePolicy.setCustomerAddress2(customerAddress.getLine2());
901
				insurancePolicy.setCustomerCity(customerAddress.getCity());
902
				insurancePolicy.setCustomerPinCode(customerAddress.getPinCode());
903
				insurancePolicy.setCustomerState(customerAddress.getState());
22244 ashik.ali 904
 
22280 ashik.ali 905
				GadgetCopsInsuranceModel gadgetCopsInsuranceModel = new GadgetCopsInsuranceModel();
906
				gadgetCopsInsuranceModel.setBrand(serialNumberBrand.get(entry.getKey()));
907
				gadgetCopsInsuranceModel.setModelName(serialNumberModelName.get(entry.getKey()));
908
				gadgetCopsInsuranceModel.setSerialNumber(entry.getKey());
909
				gadgetCopsInsuranceModel.setCustomerFirstName(customer.getFirstName());
910
				gadgetCopsInsuranceModel.setCustomerLastName(customer.getLastName());
911
				gadgetCopsInsuranceModel.setCustomerDateOfBirth(customerDateOfBirth);
912
				gadgetCopsInsuranceModel.setCustomerMobileNumber(customer.getMobileNumber());
913
				gadgetCopsInsuranceModel.setCustomerEmailId(customer.getEmailId());
914
				gadgetCopsInsuranceModel.setCustomerAddress1(customerAddress.getLine1());
915
				gadgetCopsInsuranceModel.setCustomerAddress2(customerAddress.getLine2());
916
				gadgetCopsInsuranceModel.setCustomerCity(customerAddress.getCity());
917
				gadgetCopsInsuranceModel.setCustomerPinCode(customerAddress.getPinCode());
918
				gadgetCopsInsuranceModel.setCustomerState(customerAddress.getState());
919
				gadgetCopsInsuranceModel.setPrice(insurancePolicy.getSellingPrice());
920
				gadgetCopsInsuranceModel.setInvoiceNumber(insurancePolicy.getInvoiceNumber());
921
				gadgetCopsInsuranceModel.setPolicyNumber(insurancePolicy.getPolicyNumber());
22244 ashik.ali 922
 
22280 ashik.ali 923
				try{
924
					InsuranceUtils.submitToGadgetCops(gadgetCopsInsuranceModel);
925
					insurancePolicy.setPosted(true);
926
				}catch (ProfitMandiBusinessException profitMandiBusinessException) {
927
					LOGGER.info("Unable to submit insurance policy details to {}", insuranceProvider.getName(), profitMandiBusinessException);
22244 ashik.ali 928
				}
22280 ashik.ali 929
				insurancePolicyRepository.persist(insurancePolicy);
22244 ashik.ali 930
			}
22217 ashik.ali 931
		}
22280 ashik.ali 932
		LOGGER.info("Order has been created successfully...");
933
		return "redirect:/get-order/?orderId="+fofoOrder.getId();
21612 ashik.ali 934
	}
22472 ashik.ali 935
 
936
	private int getItemIdFromSerialNumber(Map<Integer, Set<String>> itemIdSerialNumbers, String serialNumber){
937
		for(Map.Entry<Integer, Set<String>> entry : itemIdSerialNumbers.entrySet()){
938
			if(entry.getValue().contains(serialNumber)){
939
				return entry.getKey();
940
			}
941
		}
942
		return 0;
943
	}
21985 kshitij.so 944
 
21711 ashik.ali 945
	private CustomerAddress createCustomerAddress(CustomAddress customAddress){
946
		CustomerAddress customerAddress = new CustomerAddress();
947
		customerAddress.setName(customAddress.getName());
948
		customerAddress.setLine1(customAddress.getLine1());
949
		customerAddress.setLine2(customAddress.getLine2());
950
		customerAddress.setLandmark(customAddress.getLandmark());
951
		customerAddress.setCity(customAddress.getCity());
952
		customerAddress.setPinCode(customAddress.getPinCode());
953
		customerAddress.setState(customAddress.getState());
954
		customerAddress.setCountry(customAddress.getCountry());
955
		customerAddress.setPhoneNumber(customAddress.getPhoneNumber());
956
		return customerAddress;
21680 ashik.ali 957
	}
21985 kshitij.so 958
 
21689 ashik.ali 959
	private CustomAddress createCustomAddress(Address address){
960
		CustomAddress customAddress = new CustomAddress();
961
		customAddress.setName(address.getName());
962
		customAddress.setLine1(address.getLine1());
963
		customAddress.setLine2(address.getLine2());
964
		customAddress.setLandmark(address.getLandmark());
965
		customAddress.setCity(address.getCity());
966
		customAddress.setPinCode(address.getPinCode());
967
		customAddress.setState(address.getState());
968
		customAddress.setCountry(address.getCountry());
969
		customAddress.setPhoneNumber(address.getPhoneNumber());
970
		return customAddress;
21680 ashik.ali 971
	}
21985 kshitij.so 972
 
21711 ashik.ali 973
	private CustomAddress createCustomAddress(CustomerAddress customerAddress){
974
		CustomAddress customAddress = new CustomAddress();
975
		customAddress.setName(customerAddress.getName());
976
		customAddress.setLine1(customerAddress.getLine1());
977
		customAddress.setLine2(customerAddress.getLine2());
978
		customAddress.setLandmark(customerAddress.getLandmark());
979
		customAddress.setCity(customerAddress.getCity());
980
		customAddress.setPinCode(customerAddress.getPinCode());
981
		customAddress.setState(customerAddress.getState());
982
		customAddress.setCountry(customerAddress.getCountry());
983
		customAddress.setPhoneNumber(customerAddress.getPhoneNumber());
984
		return customAddress;
985
	}
21985 kshitij.so 986
 
21680 ashik.ali 987
	private void validatePaymentOptionsAndTotalAmount(Set<CustomPaymentOption> customPaymentOptions, float totalAmount) throws ProfitMandiBusinessException
21612 ashik.ali 988
	{
989
		float calculatedAmount = 0;
990
		Set<String> paymentOptionTypes = new HashSet<>();
991
		for(CustomPaymentOption customPaymentOption : customPaymentOptions){
21680 ashik.ali 992
			if(paymentOptionTypes.contains(customPaymentOption.getType().name())){
21612 ashik.ali 993
				throw new ProfitMandiBusinessException(ProfitMandiConstants.PAYMENT_OPTION_TYPE, customPaymentOption.getType().name(), "");
21680 ashik.ali 994
			}else{
995
				paymentOptionTypes.add(customPaymentOption.getType().name());
996
				calculatedAmount = calculatedAmount + customPaymentOption.getAmount();
21612 ashik.ali 997
			}
998
		}
999
		if(calculatedAmount != totalAmount){
22244 ashik.ali 1000
			LOGGER.error("PaymentOptionCalculatedAmount [{}] != TotalAmount [{}]", calculatedAmount, totalAmount);
21612 ashik.ali 1001
			throw new ProfitMandiBusinessException(ProfitMandiConstants.PAYMENT_OPTION_CALCULATED_AMOUNT, calculatedAmount, "");
1002
		}
1003
	}
21985 kshitij.so 1004
 
1005
 
21689 ashik.ali 1006
	@RequestMapping(value = "/generateInvoice")
21896 ashik.ali 1007
	public ResponseEntity<?> generateInvoice(HttpServletRequest request, HttpServletResponse response, @RequestParam(name = ProfitMandiConstants.ORDER_ID) int orderId) throws Throwable{
22064 ashik.ali 1008
		LOGGER.info("Request received at url {} with params [{}={}] ", request.getRequestURI(), ProfitMandiConstants.ORDER_ID, orderId);
22139 amit.gupta 1009
		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
22217 ashik.ali 1010
		FofoOrder fofoOrder = fofoOrderRepository.selectByFofoIdAndOrderId(fofoDetails.getFofoId(), orderId);
22026 ashik.ali 1011
 
21689 ashik.ali 1012
		PdfModel pdfModel = new PdfModel();
1013
		pdfModel.setAuther("profitmandi");
1014
		pdfModel.setTitle("Retailer Invoice");
22217 ashik.ali 1015
 
1016
		// insurance calculation
1017
		List<InsurancePolicy> insurancePolicies = insurancePolicyRepository.selectByInvoiceNumber(fofoOrder.getInvoiceNumber());
1018
		Set<CustomInsurancePolicy> customInsurancePolicies = new HashSet<>();
1019
		final float totalInsuranceTaxRate = 18;
1020
		for(InsurancePolicy insurancePolicy : insurancePolicies){
1021
			float taxableInsurancePrice = insurancePolicy.getSaleAmount() / (1 + totalInsuranceTaxRate / 100);
1022
			CustomInsurancePolicy customInsurancePolicy = new CustomInsurancePolicy();
22667 amit.gupta 1023
			customInsurancePolicy.setDescription("Theft Protection Plan for IMEI-" + insurancePolicy.getSerialNumber() + "\n Certificate No - " + insurancePolicy.getPolicyNumber());
22217 ashik.ali 1024
			customInsurancePolicy.setHsnCode("");
1025
			customInsurancePolicy.setRate(taxableInsurancePrice);
1026
			customInsurancePolicy.setIgstRate(18);
1027
			customInsurancePolicy.setIgstAmount(taxableInsurancePrice * 18 /100);
1028
			customInsurancePolicy.setCgstRate(18);
1029
			customInsurancePolicy.setCgstAmount(taxableInsurancePrice * 9 /100);
1030
			customInsurancePolicy.setSgstRate(9);
1031
			customInsurancePolicy.setSgstAmount(taxableInsurancePrice * 9 /100);
1032
			customInsurancePolicies.add(customInsurancePolicy);
1033
		}
1034
		pdfModel.setInsurancePolicies(customInsurancePolicies);
21689 ashik.ali 1035
		Customer customer = customerRepository.selectById(fofoOrder.getCustomerId());
1036
		CustomCustomer customCustomer = new CustomCustomer();
22217 ashik.ali 1037
		customCustomer.setFirstName(customer.getFirstName());
1038
		customCustomer.setLastName(customer.getLastName());
21689 ashik.ali 1039
		customCustomer.setEmailId(customer.getEmailId());
1040
		customCustomer.setMobileNumber(customer.getMobileNumber());
21711 ashik.ali 1041
		CustomerAddress customerAddress = customerAddressRepository.selectById(fofoOrder.getCustomerAddressId()); 
21689 ashik.ali 1042
		customCustomer.setAddress(this.createCustomAddress(customerAddress));
1043
		pdfModel.setCustomer(customCustomer);
1044
		pdfModel.setInvoiceNumber(fofoOrder.getInvoiceNumber());
22244 ashik.ali 1045
		pdfModel.setTotalAmount(fofoOrder.getTotalAmount());
22026 ashik.ali 1046
 
21689 ashik.ali 1047
		Retailer retailer = retailerRepository.selectById(fofoDetails.getFofoId());
22592 ashik.ali 1048
		PrivateDealUser privateDealUser = null;
1049
		try{
1050
			privateDealUser = privateDealUserRepository.selectById(retailer.getId());
1051
		}catch(ProfitMandiBusinessException profitMandiBusinessException){
1052
			LOGGER.error("Private Deal User not found : ", profitMandiBusinessException);
1053
		}
22354 ashik.ali 1054
 
21689 ashik.ali 1055
		User user = userRepository.selectById(userAccountRepository.selectUserIdByRetailerId(retailer.getId()));
1056
		CustomRetailer customRetailer = new CustomRetailer();
1057
		customRetailer.setBusinessName(retailer.getName());
1058
		customRetailer.setMobileNumber(user.getMobileNumber());
1059
		customRetailer.setTinNumber(retailer.getNumber());
22592 ashik.ali 1060
		if(privateDealUser == null){
1061
			customRetailer.setGstNumber(null);
1062
		}else{
22595 ashik.ali 1063
			if(null != privateDealUser.getCounterId()){
1064
				Counter counter = counterRepository.selectById(privateDealUser.getCounterId());
1065
				customRetailer.setGstNumber(counter.getGstin());
1066
			}else{
1067
				customRetailer.setGstNumber(null);
1068
			}
22354 ashik.ali 1069
		}
21689 ashik.ali 1070
		Address retailerAddress = addressRepository.selectById(retailerRegisteredAddressRepository.selectAddressIdByRetailerId(retailer.getId()));
1071
		customRetailer.setAddress(this.createCustomAddress(retailerAddress));
1072
		pdfModel.setRetailer(customRetailer);
1073
		List<FofoLineItem> fofoLineItems = fofoLineItemRepository.selectByOrderId(fofoOrder.getId());
22026 ashik.ali 1074
 
21689 ashik.ali 1075
		Set<CustomFofoOrderItem> customerFofoOrderItems = new HashSet<>();
1076
		for(FofoLineItem fofoLineItem : fofoLineItems){
1077
			CustomFofoOrderItem customFofoOrderItem = new CustomFofoOrderItem();
22026 ashik.ali 1078
			float totalTaxRate = fofoLineItem.getIgstRate() + fofoLineItem.getSgstRate() + fofoLineItem.getCgstRate();
1079
			float taxableSellingPrice = fofoLineItem.getSellingPrice() / (1 + totalTaxRate / 100);
22668 amit.gupta 1080
			float taxableDiscountPrice = fofoLineItem.getDiscount() / (1 + totalTaxRate / 100);
22026 ashik.ali 1081
 
22668 amit.gupta 1082
			customFofoOrderItem.setAmount(fofoLineItem.getQuantity() * (taxableSellingPrice-taxableDiscountPrice));
22672 amit.gupta 1083
			customFofoOrderItem.setDescription(fofoLineItem.getBrand() + " " + fofoLineItem.getModelName() + " " + fofoLineItem.getModelNumber() + "-" + fofoLineItem.getColor() + "\n IMEIS - " + String.join(", ",this.toSerialNumbers(fofoLineItem.getFofoLineItemSerialNumbers())));
22026 ashik.ali 1084
			customFofoOrderItem.setRate(taxableSellingPrice);
22668 amit.gupta 1085
			customFofoOrderItem.setDiscount(taxableDiscountPrice);
21689 ashik.ali 1086
			customFofoOrderItem.setQuantity(fofoLineItem.getQuantity());
22026 ashik.ali 1087
			float igstAmount = (customFofoOrderItem.getAmount() * fofoLineItem.getIgstRate()) / 100;
1088
			float cgstAmount = (customFofoOrderItem.getAmount() * fofoLineItem.getCgstRate()) / 100;
1089
			float sgstAmount = (customFofoOrderItem.getAmount() * fofoLineItem.getSgstRate()) / 100;
21896 ashik.ali 1090
			customFofoOrderItem.setIgstRate(fofoLineItem.getIgstRate());
22026 ashik.ali 1091
			customFofoOrderItem.setIgstAmount(igstAmount);
1092
			customFofoOrderItem.setCgstRate(fofoLineItem.getCgstRate());
1093
			customFofoOrderItem.setCgstAmount(cgstAmount);
1094
			customFofoOrderItem.setSgstRate(fofoLineItem.getSgstRate());
1095
			customFofoOrderItem.setSgstAmount(sgstAmount);
21896 ashik.ali 1096
			customFofoOrderItem.setHsnCode(fofoLineItem.getHsnCode());
21689 ashik.ali 1097
			customerFofoOrderItems.add(customFofoOrderItem);
1098
		}
1099
		pdfModel.setOrderItems(customerFofoOrderItems);
1100
		ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
1101
		PdfUtils.generateAndWrite(pdfModel, byteArrayOutputStream);
1102
		//final MediaType mediaType=MediaType.parseMediaType(profilePhotoModel.getContentType().getValue());
1103
		LOGGER.info("Pdf Stream length {}", byteArrayOutputStream.toByteArray().length);
22026 ashik.ali 1104
        final HttpHeaders headers=new HttpHeaders();
1105
        headers.setContentType(MediaType.APPLICATION_PDF);
22099 kshitij.so 1106
        headers.set("Content-disposition", "inline; filename=invoice-" + fofoOrder.getInvoiceNumber() + ".pdf");
22026 ashik.ali 1107
        headers.setContentLength(byteArrayOutputStream.toByteArray().length);
1108
        final InputStream inputStream=new ByteArrayInputStream(byteArrayOutputStream.toByteArray());
1109
        final InputStreamResource inputStreamResource=new InputStreamResource(inputStream);
1110
        return new ResponseEntity<InputStreamResource>(inputStreamResource, headers, HttpStatus.OK);
21689 ashik.ali 1111
	}
21985 kshitij.so 1112
 
21689 ashik.ali 1113
	private Set<String> toSerialNumbers(Set<FofoLineItemSerialNumber> fofoLineItemSerialNumbers){
1114
		Set<String> serialNumbers = new HashSet<>(fofoLineItemSerialNumbers.size());
1115
		for(FofoLineItemSerialNumber fofoLineItemSerialNumber : fofoLineItemSerialNumbers){
1116
			serialNumbers.add(fofoLineItemSerialNumber.getSerialNumber());
1117
		}
1118
		return serialNumbers;
1119
	}
22244 ashik.ali 1120
 
1121
	@RequestMapping(value = "/saleHistory")
1122
	public String saleHistory(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.START_TIME, required = false) String startTimeString, @RequestParam(name = ProfitMandiConstants.END_TIME, required = false) String endTimeString, @RequestParam(name = "offset", defaultValue = "0") int offset, @RequestParam(name = "limit", defaultValue = "10") int limit, @RequestParam(name = ProfitMandiConstants.INVOICE_NUMBER, defaultValue = "") String invoiceNumber, @RequestParam(name = "searchType",defaultValue="") String searchType, Model model) throws Exception{
1123
		LoginDetails loginDetails = null;
1124
		try {
1125
			loginDetails = cookiesProcessor.getCookiesObject(request);
1126
		} catch (ProfitMandiBusinessException e) {
1127
			model.addAttribute("loginResponse", mvcResponseSender.createResponseString("RTLR_1009", false, "/login"));
1128
			return "response";
1129
		}
1130
 
1131
		LocalDateTime startDateTime = StringUtils.toDateTime(startTimeString);
1132
		LocalDateTime endDateTime = StringUtils.toDateTime(endTimeString);
1133
		long countItems = 0;
1134
		List<FofoOrder> fofoOrders = new ArrayList<>();
22284 ashik.ali 1135
		if(searchType.equalsIgnoreCase(ProfitMandiConstants.INVOICE_NUMBER) && !invoiceNumber.isEmpty()){
22244 ashik.ali 1136
			try {
1137
				FofoOrder fofoOrder = fofoOrderRepository.selectByFofoIdAndInvoiceNumber(loginDetails.getFofoId(), invoiceNumber);
1138
				fofoOrders.add(fofoOrder);
1139
			} catch (ProfitMandiBusinessException e) {
1140
				LOGGER.info("Sale history not found : ", e);
1141
			}
1142
		}else{
1143
			fofoOrders = fofoOrderRepository.selectByFofoId(loginDetails.getFofoId(),startDateTime, endDateTime, offset, limit);
1144
			countItems = fofoOrderRepository.selectCount(loginDetails.getFofoId(), startDateTime, endDateTime, invoiceNumber, searchType);
1145
		}
1146
 
1147
		model.addAttribute("saleHistories", fofoOrders);
22551 ashik.ali 1148
		model.addAttribute("start", offset + 1);
1149
		model.addAttribute("size", countItems);
1150
		model.addAttribute("searchType", searchType);
22244 ashik.ali 1151
		model.addAttribute(ProfitMandiConstants.START_TIME, startTimeString);
1152
		model.addAttribute(ProfitMandiConstants.END_TIME, endTimeString);
1153
		if (fofoOrders.size() < limit){
22551 ashik.ali 1154
			model.addAttribute("end", offset + fofoOrders.size());
22244 ashik.ali 1155
		}
1156
		else{
22551 ashik.ali 1157
			model.addAttribute("end", offset + limit);
22244 ashik.ali 1158
		}
1159
 
1160
		return "sale-history";
1161
	}
22291 ashik.ali 1162
 
1163
 
1164
	@RequestMapping(value = "/getPaginatedSaleHistory")
1165
	public String getSaleHistoryPaginated(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.START_TIME, required = false) String startTimeString, @RequestParam(name = ProfitMandiConstants.END_TIME, required = false) String endTimeString, @RequestParam(name = "offset", defaultValue = "0") int offset, @RequestParam(name = "limit", defaultValue="10") int limit, @RequestParam(name = ProfitMandiConstants.INVOICE_NUMBER, defaultValue="") String invoiceNumber, @RequestParam(name = "searchType", defaultValue = "") String searchType, Model model) throws Exception{
1166
		LoginDetails loginDetails;
1167
		try {
1168
			loginDetails = cookiesProcessor.getCookiesObject(request);
1169
		} catch (ProfitMandiBusinessException e) {
1170
			model.addAttribute("loginResponse", mvcResponseSender.createResponseString("RTLR_1009", false, "/login"));
1171
			return "response";
1172
		}
1173
		LocalDateTime startDateTime = StringUtils.toDateTime(startTimeString);
1174
		LocalDateTime endDateTime = StringUtils.toDateTime(endTimeString);
21985 kshitij.so 1175
 
22291 ashik.ali 1176
		List<FofoOrder> saleHistories = fofoOrderRepository.selectByFofoId(loginDetails.getFofoId(), startDateTime, endDateTime, offset, limit);
1177
		model.addAttribute("saleHistories", saleHistories);
1178
		return "sale-history-paginated";
1179
	}
1180
 
21612 ashik.ali 1181
}