| Line 1030... |
Line 1030... |
| 1030 |
|
1030 |
|
| 1031 |
@Autowired
|
1031 |
@Autowired
|
| 1032 |
CatalogRepository catalogRepository;
|
1032 |
CatalogRepository catalogRepository;
|
| 1033 |
|
1033 |
|
| 1034 |
private void reverseOppoPayout() throws Exception {
|
1034 |
private void reverseOppoPayout() throws Exception {
|
| 1035 |
List<Integer> schemeIds = Arrays.asList(5540, 5542, 5544,5918, 5919, 5920, 5921, 5922);
|
1035 |
//List<Integer> schemeIds = Arrays.asList(5540, 5542, 5544,5918, 5919, 5920, 5921, 5922);
|
| 1036 |
/*List<Integer> schemeIds = Arrays.asList(5540, 5542, 5544, 5545, 5550, 5555, 5556, 5557, 5564, 5565, 5566, 5567, 5569, 5570, 5582, 5590, 5592, 5593, 5594,
|
1036 |
List<Integer> schemeIds = Arrays.asList(5540, 5542, 5544, 5545, 5550, 5555, 5556, 5557, 5564, 5565, 5566, 5567, 5569, 5570, 5582, 5590, 5592, 5593, 5594,
|
| 1037 |
5595, 5598, 5602, 5604, 5605, 5606, 5607, 5608, 5611, 5618, 5620, 5621, 5622, 5623, 5624, 5625, 5626, 5629, 5631,
|
1037 |
5595, 5598, 5602, 5604, 5605, 5606, 5607, 5608, 5611, 5618, 5620, 5621, 5622, 5623, 5624, 5625, 5626, 5629, 5631,
|
| 1038 |
5633, 5634, 5635, 5637, 5644, 5649, 5655, 5659, 5662, 5668, 5672, 5674, 5679, 5683, 5684, 5685, 5688, 5689, 5690,
|
1038 |
5633, 5634, 5635, 5637, 5644, 5649, 5655, 5659, 5662, 5668, 5672, 5674, 5679, 5683, 5684, 5685, 5688, 5689, 5690,
|
| 1039 |
5692, 5694, 5697, 5699, 5700, 5706, 5718, 5729, 5730, 5754, 5756, 5758, 5759, 5761, 5762, 5766, 5769, 5771, 5772,
|
1039 |
5692, 5694, 5697, 5699, 5700, 5706, 5718, 5729, 5730, 5754, 5756, 5758, 5759, 5761, 5762, 5766, 5769, 5771, 5772,
|
| 1040 |
5773, 5774, 5775, 5776, 5781, 5782, 5783, 5786, 5788, 5790, 5795, 5800, 5803, 5804, 5807, 5809, 5815, 5816, 5819,
|
1040 |
5773, 5774, 5775, 5776, 5781, 5782, 5783, 5786, 5788, 5790, 5795, 5800, 5803, 5804, 5807, 5809, 5815, 5816, 5819,
|
| 1041 |
5820, 5821, 5822, 5823, 5824, 5825, 5826, 5827, 5828, 5829, 5830, 5832, 5833, 5834, 5835, 5836, 5837, 5839, 5840,
|
1041 |
5820, 5821, 5822, 5823, 5824, 5825, 5826, 5827, 5828, 5829, 5830, 5832, 5833, 5834, 5835, 5836, 5837, 5839, 5840,
|
| Line 1048... |
Line 1048... |
| 1048 |
5987, 5989, 5990, 5991, 5992, 5996, 5997, 5998, 5999, 6000, 6001, 6002, 6003, 6004, 6005, 6006, 6007, 6008, 6010,
|
1048 |
5987, 5989, 5990, 5991, 5992, 5996, 5997, 5998, 5999, 6000, 6001, 6002, 6003, 6004, 6005, 6006, 6007, 6008, 6010,
|
| 1049 |
6011, 6012, 6013, 6014, 6015, 6016, 6017, 6018, 6019, 6020, 6021, 6022, 6023, 6024, 6025, 6026, 6028, 6029, 6030,
|
1049 |
6011, 6012, 6013, 6014, 6015, 6016, 6017, 6018, 6019, 6020, 6021, 6022, 6023, 6024, 6025, 6026, 6028, 6029, 6030,
|
| 1050 |
6031, 6032, 6033, 6034, 6035, 6036, 6037, 6038, 6039, 6040, 6041, 6042, 6043, 6044, 6045, 6046, 6047, 6048, 6049,
|
1050 |
6031, 6032, 6033, 6034, 6035, 6036, 6037, 6038, 6039, 6040, 6041, 6042, 6043, 6044, 6045, 6046, 6047, 6048, 6049,
|
| 1051 |
6050, 6051, 6052, 6053, 6054, 6055, 6056, 6057, 6058, 6059, 6060, 6061, 6062, 6063, 6064, 6065, 6066, 6067, 6068,
|
1051 |
6050, 6051, 6052, 6053, 6054, 6055, 6056, 6057, 6058, 6059, 6060, 6061, 6062, 6063, 6064, 6065, 6066, 6067, 6068,
|
| 1052 |
6069, 6070, 6071, 6072, 6073, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6086, 6087, 6088, 6089, 6091, 6092,
|
1052 |
6069, 6070, 6071, 6072, 6073, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6086, 6087, 6088, 6089, 6091, 6092,
|
| 1053 |
6093, 6094, 6095, 6098, 6102);*/
|
1053 |
6093, 6094, 6095, 6098, 6102);
|
| 1054 |
Map<Integer, List<SchemeInOut>> inventoryItemSiosMap = schemeInOutRepository.selectBySchemeIds(new HashSet<>(schemeIds)).stream().collect(Collectors.groupingBy(x -> x.getInventoryItemId()));
|
1054 |
Map<Integer, List<SchemeInOut>> inventoryItemSiosMap = schemeInOutRepository.selectBySchemeIds(new HashSet<>(schemeIds)).stream().collect(Collectors.groupingBy(x -> x.getInventoryItemId()));
|
| 1055 |
Map<Integer, InventoryItem> inventoryItemMap = inventoryItemRepository.selectByIds(inventoryItemSiosMap.keySet()).stream().collect(Collectors.toMap(x -> x.getId(), x -> x));
|
1055 |
Map<Integer, InventoryItem> inventoryItemMap = inventoryItemRepository.selectByIds(inventoryItemSiosMap.keySet()).stream().collect(Collectors.toMap(x -> x.getId(), x -> x));
|
| 1056 |
Set<Integer> itemIds = itemRepository.selectAllByBrand("Oppo", 10006).stream().map(x -> x.getId()).collect(toSet());
|
1056 |
Set<Integer> itemIds = itemRepository.selectAllByBrand("Oppo", 10006).stream().map(x -> x.getId()).collect(toSet());
|
| 1057 |
List<InventoryItem> filteredInventoryItems = inventoryItemMap.values().stream().filter(x -> itemIds.contains(x.getItemId())).collect(Collectors.toList());
|
1057 |
List<InventoryItem> filteredInventoryItems = inventoryItemMap.values().stream().filter(x -> itemIds.contains(x.getItemId())).collect(Collectors.toList());
|
| 1058 |
for (InventoryItem filteredInventoryItem : filteredInventoryItems) {
|
1058 |
for (InventoryItem filteredInventoryItem : filteredInventoryItems) {
|
| 1059 |
System.out.println("Serial Number is - " + filteredInventoryItem.getSerialNumber());
|
1059 |
//System.out.println("Serial Number is - " + filteredInventoryItem.getSerialNumber());
|
| 1060 |
List<ScanRecord> scanRecords = scanRecordRepository.selectByInventoryItemId(filteredInventoryItem.getId());
|
1060 |
List<ScanRecord> scanRecords = scanRecordRepository.selectByInventoryItemId(filteredInventoryItem.getId());
|
| 1061 |
ScanRecord scanRecord = scanRecords.stream().filter(x -> x.getType().equals(ScanType.SALE)).findFirst().orElse(null);
|
1061 |
ScanRecord scanRecord = scanRecords.stream().filter(x -> x.getType().equals(ScanType.SALE)).findFirst().orElse(null);
|
| 1062 |
if (scanRecord == null) {
|
1062 |
if (scanRecord == null) {
|
| 1063 |
System.out.println("Could not find sale scan record for " + filteredInventoryItem.getSerialNumber());
|
- |
|
| 1064 |
continue;
|
1063 |
continue;
|
| 1065 |
//schemeService.reverseSchemes(inventoryItems, fofoOrder.getId(), reversalReason, Arrays.asList(SchemeType.INVESTMENT));
|
1064 |
//schemeService.reverseSchemes(inventoryItems, fofoOrder.getId(), reversalReason, Arrays.asList(SchemeType.INVESTMENT));
|
| 1066 |
}
|
1065 |
}
|
| 1067 |
int orderId = scanRecord.getOrderId();
|
1066 |
int orderId = scanRecord.getOrderId();
|
| 1068 |
schemeService.reverseSchemes(Arrays.asList(filteredInventoryItem), orderId, "Reissuing margins as incorrect margin disbursed", SchemeType.OUT_SCHEME_TYPES);
|
1067 |
schemeService.reverseSchemes(Arrays.asList(filteredInventoryItem), orderId, "Reissuing margins as incorrect margin disbursed", SchemeType.OUT_SCHEME_TYPES);
|
| - |
|
1068 |
schemeService.reverseSchemes(Arrays.asList(filteredInventoryItem), orderId, "Reissuing margins as incorrect margin disbursed", Arrays.asList(SchemeType.SPECIAL_SUPPORT));
|
| - |
|
1069 |
System.out.println("Out\t" + filteredInventoryItem.getId() + "\t" + filteredInventoryItem.getSerialNumber());
|
| 1069 |
}
|
1070 |
}
|
| 1070 |
Map<Integer, List<InventoryItem>> purchaseInventoryItemsMap = filteredInventoryItems.stream().filter(x -> x.getCreateTimestamp().isAfter(YearMonth.now().atDay(1).atStartOfDay())).collect(Collectors.groupingBy(x -> x.getPurchaseId()));
|
1071 |
Map<Integer, List<InventoryItem>> purchaseInventoryItemsMap = filteredInventoryItems.stream().filter(x -> x.getCreateTimestamp().isAfter(YearMonth.now().atDay(1).atStartOfDay())).collect(Collectors.groupingBy(x -> x.getPurchaseId()));
|
| 1071 |
List<Purchase> purchases = purchaseRepository.selectAllByIds(new ArrayList<>(purchaseInventoryItemsMap.keySet()));
|
1072 |
List<Purchase> purchases = purchaseRepository.selectAllByIds(new ArrayList<>(purchaseInventoryItemsMap.keySet()));
|
| 1072 |
for (Purchase purchase : purchases) {
|
1073 |
for (Purchase purchase : purchases) {
|
| 1073 |
String invoiceNumber = purchase.getPurchaseReference();
|
1074 |
String invoiceNumber = purchase.getPurchaseReference();
|
| 1074 |
LocalDateTime billingTime = orderRepository.selectByInvoiceNumber(invoiceNumber).get(0).getBillingTimestamp();
|
1075 |
LocalDateTime billingTime = orderRepository.selectByInvoiceNumber(invoiceNumber).get(0).getBillingTimestamp();
|
| 1075 |
if(billingTime.isAfter(YearMonth.now().atDay(1).atStartOfDay()) ) {
|
1076 |
if(billingTime.isAfter(YearMonth.now().atDay(1).atStartOfDay()) ) {
|
| - |
|
1077 |
List<InventoryItem> inventoryItems = purchaseInventoryItemsMap.get(purchase.getId());
|
| 1076 |
List<Integer> inventoryItems = purchaseInventoryItemsMap.get(purchase.getId()).stream().map(x -> x.getId()).collect(toList());
|
1078 |
List<Integer> inventoryItemIds = inventoryItems.stream().map(x -> x.getId()).collect(toList());
|
| 1077 |
schemeService.rollbackSchemes(inventoryItems, "Reissuing margins as incorrect margin disbursed");
|
1079 |
schemeService.rollbackSchemes(inventoryItemIds, "Reissuing margins as incorrect margin disbursed");
|
| - |
|
1080 |
for (InventoryItem inventoryItem : inventoryItems) {
|
| - |
|
1081 |
System.out.println("In\t" + inventoryItem.getId() + "\t" + inventoryItem.getSerialNumber());
|
| - |
|
1082 |
}
|
| 1078 |
}
|
1083 |
}
|
| 1079 |
}
|
1084 |
}
|
| 1080 |
}
|
1085 |
}
|
| 1081 |
|
1086 |
|
| 1082 |
public void test() throws Exception {
|
1087 |
public void test() throws Exception {
|