Subversion Repositories SmartDukaan

Rev

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