Subversion Repositories SmartDukaan

Rev

Rev 24914 | Rev 24916 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 24914 Rev 24915
Line 35... Line 35...
35 
import com.spice.profitmandi.dao.entity.fofo.TargetSlab;
 35 
import com.spice.profitmandi.dao.entity.fofo.TargetSlab;
36 
import com.spice.profitmandi.dao.entity.transaction.LineItem;
 36 
import com.spice.profitmandi.dao.entity.transaction.LineItem;
37 
import com.spice.profitmandi.dao.entity.transaction.LineItemImei;
 37 
import com.spice.profitmandi.dao.entity.transaction.LineItemImei;
38 
import com.spice.profitmandi.dao.entity.transaction.Order;
 38 
import com.spice.profitmandi.dao.entity.transaction.Order;
39 
import com.spice.profitmandi.dao.entity.transaction.SellerWarehouse;
 39 
import com.spice.profitmandi.dao.entity.transaction.SellerWarehouse;
40 
import com.spice.profitmandi.dao.enumuration.fofo.ScanType;
 - 
 
41 
import com.spice.profitmandi.dao.repository.GenericRepository;
 40 
import com.spice.profitmandi.dao.repository.GenericRepository;
42 
import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
 - 
 
43 
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
 41 
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
44 
import com.spice.profitmandi.dao.repository.fofo.CurrentInventorySnapshotRepository;
 42 
import com.spice.profitmandi.dao.repository.fofo.CurrentInventorySnapshotRepository;
45 
import com.spice.profitmandi.dao.repository.fofo.DebitNoteRepository;
 43 
import com.spice.profitmandi.dao.repository.fofo.DebitNoteRepository;
46 
import com.spice.profitmandi.dao.repository.fofo.FofoOrderItemRepository;
 44 
import com.spice.profitmandi.dao.repository.fofo.FofoOrderItemRepository;
47 
import com.spice.profitmandi.dao.repository.fofo.FofoOrderRepository;
 45 
import com.spice.profitmandi.dao.repository.fofo.FofoOrderRepository;
Line 79... Line 77...
79 
 
 77 
 
80 
	@Autowired
 78 
	@Autowired
81 
	private LineItemRepository lineItemRepository;
 79 
	private LineItemRepository lineItemRepository;
82 
 
 80 
 
83 
	@Autowired
 81 
	@Autowired
84 
	private ItemRepository itemRepository;
 - 
 
85 
 
 - 
 
86 
	@Autowired
 - 
 
87 
	private TargetSlabRepository targetSlabRepository;
 82 
	private TargetSlabRepository targetSlabRepository;
88 
 
 83 
 
89 
	@Autowired
 84 
	@Autowired
90 
	private PartnerTargetRepository partnerTargetRepository;
 85 
	private PartnerTargetRepository partnerTargetRepository;
91 
 
 86 
 
Line 291... Line 286...
291 
				int ourSale = ourSaleItemQtyMap.get(itemQtyEntry.getKey());
 286 
				int ourSale = ourSaleItemQtyMap.get(itemQtyEntry.getKey());
292 
				int quantityToReduce = itemQtyEntry.getValue() - ourSale;
 287 
				int quantityToReduce = itemQtyEntry.getValue() - ourSale;
293 
				List<InventoryItem> itemIis = itemIdInventoryMap.get(itemQtyEntry.getKey());
 288 
				List<InventoryItem> itemIis = itemIdInventoryMap.get(itemQtyEntry.getKey());
294 
				if (itemIdInventoryMap != null) {
 289 
				if (itemIdInventoryMap != null) {
295 
					for (InventoryItem ii : itemIis) {
 290 
					for (InventoryItem ii : itemIis) {
296 
						if (ii.getSerialNumber() == null && quantityToReduce > 0) {
 291 
						if (ii.getSerialNumber() == null && ii.getGoodQuantity() == ii.getInitialQuantity()
- 
 
 292 
								&& quantityToReduce >= ii.getInitialQuantity()) {
297 
							LOGGER.info("Changed in inventoryItems {}, {}, {}, {}, {}, {}",
 293 
							LOGGER.info("Changed in inventoryItems {}, {}, {}, {}, {}, {}",
298 
									purchase.getPurchaseReference(), ii.getId(), ii.getItemId(),
 294 
									purchase.getPurchaseReference(), ii.getId(), ii.getItemId(),
299 
									ii.getInitialQuantity(), ii.getGoodQuantity(), quantityToReduce);
 295 
									ii.getInitialQuantity(), ii.getGoodQuantity(), quantityToReduce);
300 
							List<ScanRecord> scanRecords = scanRecordRepository.selectByInventoryItemId(ii.getId());
 296 
							List<ScanRecord> scanRecords = scanRecordRepository.selectByInventoryItemId(ii.getId());
301 
							for (ScanRecord scanRecord : scanRecords) {
 297 
							for (ScanRecord scanRecord : scanRecords) {
302 
								if (scanRecord.getType().equals(ScanType.PURCHASE)) {
 298 
								CurrentInventorySnapshot cis = currentInventorySnapshotRepository
303 
									if (scanRecord.getQuantity() == 0) {
 299 
										.selectByItemIdAndFofoId(itemQtyEntry.getKey(), purchase.getFofoId());
304 
										scanRecordRepository.delete(scanRecord);
 300 
								scanRecord.setQuantity(0);
305 
										purchase.setUnfullfilledNonSerializedQuantity(ii.getInitialQuantity());
 301 
								ii.setGoodQuantity(0);
306 
										CurrentInventorySnapshot cis = currentInventorySnapshotRepository
 - 
 
307 
												.selectByItemIdAndFofoId(itemQtyEntry.getKey(), purchase.getFofoId());
 - 
 
308 
										quantityToReduce = quantityToReduce - ii.getInitialQuantity();
 302 
								quantityToReduce = quantityToReduce - ii.getInitialQuantity();
309 
										cis.setAvailability(cis.getAvailability() - ii.getGoodQuantity());
 303 
								cis.setAvailability(cis.getAvailability() - ii.getInitialQuantity());
310 
										purchase.setUnfullfilledNonSerializedQuantity(
 304 
								purchase.setUnfullfilledNonSerializedQuantity(
311 
												purchase.getUnfullfilledNonSerializedQuantity() + quantityToReduce);
 305 
										purchase.getUnfullfilledNonSerializedQuantity() + quantityToReduce);
312 
										ii.setInitialQuantity(0);
 - 
 
313 
										LOGGER.info("Rectified {}, {}, {}, {}, {}, {}", purchase.getPurchaseReference(),
 306 
								LOGGER.info("Rectified {}, {}, {}, {}, {}, {}", purchase.getPurchaseReference(),
314 
												ii.getId(), ii.getItemId(), ii.getInitialQuantity(),
 307 
										ii.getId(), ii.getItemId(), ii.getInitialQuantity(), ii.getGoodQuantity(),
315 
												ii.getGoodQuantity(), quantityToReduce);
 308 
										quantityToReduce);
316 
										break;
 - 
 
317 
 
 - 
 
318 
									}
 - 
 
319 
								}
 - 
 
320 
							}
 309 
							}
321 
						}
 310 
						}
322 
					}
 311 
					}
323 
				}
 312 
				}
324 
			}
 313 
			}
325 
		}
 314 
		}
326 
		//throw new Exception();
 315 
		throw new Exception();
327 
	}
 316 
	}
328 
 
 317 
 
329 
	public void migrateChallansToInvoices() throws Exception {
 318 
	public void migrateChallansToInvoices() throws Exception {
330 
		Map<String, List<Order>> invoiceOrdersMap = orderRepository.selectAllChallans().stream()
 319 
		Map<String, List<Order>> invoiceOrdersMap = orderRepository.selectAllChallans().stream()
331 
				.filter(x -> !x.getLineItem().getHsnCode().equals("NOGST"))
 320 
				.filter(x -> !x.getLineItem().getHsnCode().equals("NOGST"))