WebSVN – SmartDukaan – Diff – /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/order/OrderServiceImpl.java

 import java.util.HashMap;
 import java.util.HashSet;
 import java.util.Iterator;
 import java.util.List;
 import java.util.Map;
+import java.util.Optional;
+import java.util.Random;
 import java.util.Set;
 import java.util.function.Function;
 import java.util.stream.Collectors;
 import org.apache.logging.log4j.LogManager;
 import org.apache.logging.log4j.Logger;
 import org.json.JSONObject;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.beans.factory.annotation.Qualifier;
+import org.springframework.cache.annotation.Cacheable;
 import org.springframework.stereotype.Component;
 import com.spice.profitmandi.common.enumuration.ItemType;
 import com.spice.profitmandi.common.enumuration.SearchType;
 import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
 import com.spice.profitmandi.common.model.CreditNotePdfModel;
 import com.spice.profitmandi.common.model.CustomAddress;
 import com.spice.profitmandi.common.model.CustomCustomer;
 import com.spice.profitmandi.common.model.CustomFofoOrderItem;
 import com.spice.profitmandi.common.model.CustomInsurancePolicy;
+import com.spice.profitmandi.common.model.CustomLineItem;
 import com.spice.profitmandi.common.model.CustomOrderItem;
 import com.spice.profitmandi.common.model.CustomPaymentOption;
 import com.spice.profitmandi.common.model.CustomRetailer;
 import com.spice.profitmandi.common.model.FoiBadReturnRequest;
 import com.spice.profitmandi.common.model.GstRate;
 import com.spice.profitmandi.dao.entity.fofo.ScanRecord;
 import com.spice.profitmandi.dao.entity.transaction.Order;
 import com.spice.profitmandi.dao.entity.user.Address;
 import com.spice.profitmandi.dao.entity.user.Counter;
 import com.spice.profitmandi.dao.entity.user.PrivateDealUser;
+import com.spice.profitmandi.dao.entity.warehouse.WarehouseInventoryItem;
 import com.spice.profitmandi.dao.enumuration.catalog.SchemeType;
 import com.spice.profitmandi.dao.enumuration.dtr.PaymentOptionReferenceType;
 import com.spice.profitmandi.dao.enumuration.fofo.ReturnType;
 import com.spice.profitmandi.dao.enumuration.fofo.ScanType;
 import com.spice.profitmandi.dao.enumuration.fofo.SettlementType;
 import com.spice.profitmandi.dao.repository.inventory.StateRepository;
 import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
 import com.spice.profitmandi.dao.repository.user.AddressRepository;
 import com.spice.profitmandi.dao.repository.user.CounterRepository;
 import com.spice.profitmandi.dao.repository.user.PrivateDealUserRepository;
+import com.spice.profitmandi.dao.repository.warehouse.WarehouseInventoryItemRepository;
 import com.spice.profitmandi.service.integrations.zest.InsuranceService;
 import com.spice.profitmandi.service.inventory.InventoryService;
 import com.spice.profitmandi.service.inventory.PurchaseReturnService;
 import com.spice.profitmandi.service.inventory.SaholicInventoryService;
 import com.spice.profitmandi.service.pricing.PricingService;
 	@Autowired
 	private FofoLineItemRepository fofoLineItemRepository;
 	@Autowired
+	private WarehouseInventoryItemRepository warehouseInventoryItemRepository;
+	@Autowired
 	private FofoOrderItemRepository fofoOrderItemRepository;
 	@Autowired
 	private PaymentOptionRepository paymentOptionRepository;
 	public PdfModel getInvoicePdfModel(int orderId) throws ProfitMandiBusinessException {
 		FofoOrder fofoOrder = fofoOrderRepository.selectByOrderId(orderId);
 		return this.getInvoicePdfModel(fofoOrder);
+	}
+	@Override
+	@Cacheable(value = "order.dummymodel", cacheManager = "oneDayCacheManager")
+	public PdfModel getDummyPdfModel(String serialNumber) throws ProfitMandiBusinessException {
+		List<WarehouseInventoryItem> warehouseInventoryItems = warehouseInventoryItemRepository
+				.selectWarehouseInventoryItemBySerailNumbers(Arrays.asList(serialNumber));
+		if (warehouseInventoryItems.size() > 0) {
+			WarehouseInventoryItem warehouseInventoryItem = warehouseInventoryItems.get(0);
+			int currentQuantity = warehouseInventoryItems.get(0).getCurrentQuantity();
+			if (currentQuantity > 0) {
+				throw new ProfitMandiBusinessException("Serial Number", serialNumber,
+						"Serial Number exist in our warehouse");
+			} else {
+				try {
+					InventoryItem inventoryItem = inventoryItemRepository.selectBySerialNumber(serialNumber);
+					if (inventoryItem.getGoodQuantity() > 0) {
+						throw new ProfitMandiBusinessException("Serial Number", serialNumber,
+								"Serial Number is not yet billed by the partner");
+					} else {
+						List<ScanRecord> scanRecords = scanRecordRepository
+								.selectByInventoryItemId(inventoryItem.getId());
+						Optional<ScanRecord> scanRecord = scanRecords.stream().filter(x -> x.getOrderId() != 0)
+								.findFirst();
+						if (scanRecord.isPresent()) {
+							FofoOrder fofoOrder = fofoOrderRepository.selectByOrderId(scanRecord.get().getOrderId());
+							return this.getInvoicePdfModel(fofoOrder);
+						} else {
+							throw new ProfitMandiBusinessException("Serial Number", serialNumber,
+									"Serial Number returned by partner, but in transit");
+						}
+					}
+				} catch (Exception e) {
+					// Map this serialNumber for dummy billing
+					int itemId = warehouseInventoryItem.getItemId();
+					LocalDateTime grnDate = warehouseInventoryItem.getCreated();
+					Random random = new Random();
+					int randomDays = random.ints(2, 15).findFirst().getAsInt();
+					LocalDateTime saleDate = grnDate.plusDays(randomDays);
+					FofoOrder fofoOrder = fofoOrderRepository.selectFirstOrderAfterDate(saleDate);
+					PdfModel pdfModel = this.getInvoicePdfModel(fofoOrder.getId());
+					this.modifyDummyModel(fofoOrder, pdfModel, itemId, serialNumber);
+					return pdfModel;
+				}
+			}
+		} else {
+			throw new ProfitMandiBusinessException("Serial Number", serialNumber,
+					"Serial Number does not exist in our warehouse");
+		}
+	}
+	void modifyDummyModel(FofoOrder fofoOrder, PdfModel pdfModel, int itemId, String serialNumber) throws ProfitMandiBusinessException {
+		int retailerAddressId = retailerRegisteredAddressRepository.selectAddressIdByRetailerId(fofoOrder.getFofoId());
+		Address retailerAddress = addressRepository.selectById(retailerAddressId);
+		Customer customer = customerRepository.selectById(fofoOrder.getCustomerId());
+		CustomerAddress customerAddress = customer.getCustomerAddress().stream()
+				.filter(x -> x.getId() == fofoOrder.getCustomerAddressId()).findFirst().get();
+		Integer stateId = null;
+		if (customerAddress.getState().equals(retailerAddress.getState())) {
+			try {
+				stateId = Long.valueOf(Utils.getStateInfo(customerAddress.getState()).getId()).intValue();
+			} catch (Exception e) {
+				LOGGER.error("Unable to get state rates");
+			}
+		}
+		CustomOrderItem cli = pdfModel.getOrderItems().stream().findFirst().get();
+		List<FofoOrderItem> fofoOrderItems = Arrays.asList(this.getDummyFofoOrderItem(itemId, fofoOrder.getId(), serialNumber, stateId));
+		CustomPaymentOption paymentOption = pdfModel.getPaymentOptions().get(0);
+		paymentOption.setAmount(fofoOrderItems.get(0).getMop());
+		Set<CustomOrderItem> customerFofoOrderItems = new HashSet<>();
+		for (FofoOrderItem fofoOrderItem : fofoOrderItems) {
+			CustomOrderItem customFofoOrderItem = new CustomOrderItem();
+			float totalTaxRate = fofoOrderItem.getIgstRate() + fofoOrderItem.getSgstRate()
+					+ fofoOrderItem.getCgstRate();
+			float taxableSellingPrice = fofoOrderItem.getSellingPrice() / (1 + totalTaxRate / 100);
+			float taxableDiscountPrice = fofoOrderItem.getDiscount() / (1 + totalTaxRate / 100);
+			customFofoOrderItem.setAmount(fofoOrderItem.getQuantity() * (taxableSellingPrice - taxableDiscountPrice));
+			customFofoOrderItem.setDescription(fofoOrderItem.getBrand() + " " + fofoOrderItem.getModelName() + " "
+					+ fofoOrderItem.getModelNumber() + "-" + fofoOrderItem.getColor());
+			Set<String> serialNumbers = this.toSerialNumbers(fofoOrderItem.getFofoLineItems());
+			// LOGGER.info("serialNumbers {}", serialNumbers);
+			// LOGGER.info("serialNumbers is empty {}", serialNumbers.isEmpty());
+			if (!serialNumbers.isEmpty()) {
+				customFofoOrderItem.setDescription(
+						customFofoOrderItem.getDescription() + "\n IMEIS - " + String.join(", ", serialNumbers));
+			}
+			customFofoOrderItem.setRate(taxableSellingPrice);
+			customFofoOrderItem.setDiscount(taxableDiscountPrice);
+			customFofoOrderItem.setQuantity(fofoOrderItem.getQuantity());
+			customFofoOrderItem.setNetAmount(
+					(fofoOrderItem.getSellingPrice() - fofoOrderItem.getDiscount()) * fofoOrderItem.getQuantity());
+			float igstAmount = (customFofoOrderItem.getAmount() * fofoOrderItem.getIgstRate()) / 100;
+			float cgstAmount = (customFofoOrderItem.getAmount() * fofoOrderItem.getCgstRate()) / 100;
+			float sgstAmount = (customFofoOrderItem.getAmount() * fofoOrderItem.getSgstRate()) / 100;
+			customFofoOrderItem.setIgstRate(fofoOrderItem.getIgstRate());
+			customFofoOrderItem.setIgstAmount(igstAmount);
+			customFofoOrderItem.setCgstRate(fofoOrderItem.getCgstRate());
+			customFofoOrderItem.setCgstAmount(cgstAmount);
+			customFofoOrderItem.setSgstRate(fofoOrderItem.getSgstRate());
+			customFofoOrderItem.setSgstAmount(sgstAmount);
+			customFofoOrderItem.setHsnCode(fofoOrderItem.getHsnCode());
+			customerFofoOrderItems.add(customFofoOrderItem);
+		}
+		pdfModel.setOrderItems(customerFofoOrderItems);
+	}
 	private PdfModel getInvoicePdfModel(FofoOrder fofoOrder) throws ProfitMandiBusinessException {
 		List<PaymentOptionTransaction> paymentOptionTransactions = paymentOptionTransactionRepository
 				.selectByReferenceIdAndType(fofoOrder.getId(), PaymentOptionReferenceType.ORDER);
 		fofoOrderItem.setColor(item.getColor());
 		fofoOrderItemRepository.persist(fofoOrderItem);
 		return fofoOrderItem;
+	}
+	private FofoOrderItem getDummyFofoOrderItem(int itemId, int fofoOrderId,
+			String serialNumber, Integer stateId) throws ProfitMandiBusinessException {
+		Item item = itemRepository.selectById(itemId);
+		TagListing tl = tagListingRepository.selectByItemId(itemId);
+		FofoOrderItem fofoOrderItem = new FofoOrderItem();
+		fofoOrderItem.setItemId(itemId);
+		fofoOrderItem.setQuantity(1);
+		fofoOrderItem.setSellingPrice(tl.getMop());
+		fofoOrderItem.setOrderId(fofoOrderId);
+		// In case listing gets removed rebill it using the selling price
+		fofoOrderItem.setDp(tl.getSellingPrice());
+		fofoOrderItem.setMop(tl.getMop());
+		fofoOrderItem.setDiscount(0);
+		Map<Integer, GstRate> itemIdStateTaxRateMap = null;
+		Map<Integer, Float> itemIdIgstTaxRateMap = null;
+		if (stateId != null) {
+			itemIdStateTaxRateMap = stateGstRateRepository.getStateTaxRate(Arrays.asList(itemId), stateId);
+		} else {
+			itemIdIgstTaxRateMap = stateGstRateRepository.getIgstTaxRate(Arrays.asList(itemId));
+		}
+		if (stateId == null) {
+			fofoOrderItem.setIgstRate(itemIdIgstTaxRateMap.get(itemId));
+		} else {
+			fofoOrderItem.setCgstRate(itemIdStateTaxRateMap.get(itemId).getCgstRate());
+			fofoOrderItem.setSgstRate(itemIdStateTaxRateMap.get(itemId).getSgstRate());
+		}
+		fofoOrderItem.setHsnCode(item.getHsnCode());
+		fofoOrderItem.setBrand(item.getBrand());
+		fofoOrderItem.setModelName(item.getModelName());
+		fofoOrderItem.setModelNumber(item.getModelNumber());
+		fofoOrderItem.setColor(item.getColor());
+		Set<FofoLineItem> fofoLineItems = new HashSet<>();
+		FofoLineItem fli = new FofoLineItem();
+		fli.setQuantity(1);
+		fli.setSerialNumber(serialNumber);
+		fofoLineItems.add(fli);
+		fofoOrderItem.setFofoLineItems(fofoLineItems);
+		return fofoOrderItem;
+	}
 	private void updateCurrentInventorySnapshot(List<CurrentInventorySnapshot> currentInventorySnapshots, int fofoId,
 			int itemId, int quantity) throws ProfitMandiBusinessException {
 		for (CurrentInventorySnapshot currentInventorySnapshot : currentInventorySnapshots) {
 			if (currentInventorySnapshot.getItemId() == itemId && currentInventorySnapshot.getFofoId() == fofoId) {
 				currentInventorySnapshotRepository.updateAvailabilityByItemIdAndFofoId(itemId, fofoId,
 		CustomerCreditNote creditNote = generateCreditNote(fofoOrder, customerReturnItems);
 		for (CustomerReturnItem customerReturnItem : customerReturnItems) {
 			purchaseReturnService.returnInventoryItem(fofoId, false, customerReturnItem.getInventoryItemId(),
 					ReturnType.BAD);
+		}
-		//This should cancel the order
+		// This should cancel the order
 		fofoOrder.setCancelledTimestamp(LocalDateTime.now());
 		return creditNote;
+	}
 	private CustomerCreditNote generateCreditNote(FofoOrder fofoOrder, List<CustomerReturnItem> customerReturnItems)
 		LocalDateTime dateTime = fofoOrderRepository.selectMaxSaleDateGroupByFofoIds(startDate, endDate).get(fofoId);
 		return dateTime;
+	}
 	@Override
-	//Only being used internally
+	// Only being used internally
 	public float getSales(int fofoId, LocalDate onDate) {
 		LocalDateTime startTime = LocalDateTime.of(onDate, LocalTime.MIDNIGHT);
 		LocalDateTime endTime = LocalDateTime.of(onDate, LocalTime.MIDNIGHT).plusDays(1);
 		return this.getSales(fofoId, startTime, endTime);
+	}

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/order/OrderServiceImpl.java – Rev 27411 → 27516