| Line 24... |
Line 24... |
| 24 |
import com.spice.profitmandi.common.util.FileUtil;
|
24 |
import com.spice.profitmandi.common.util.FileUtil;
|
| 25 |
import com.spice.profitmandi.common.util.FormattingUtils;
|
25 |
import com.spice.profitmandi.common.util.FormattingUtils;
|
| 26 |
import com.spice.profitmandi.common.util.Utils;
|
26 |
import com.spice.profitmandi.common.util.Utils;
|
| 27 |
import com.spice.profitmandi.dao.entity.catalog.Scheme;
|
27 |
import com.spice.profitmandi.dao.entity.catalog.Scheme;
|
| 28 |
import com.spice.profitmandi.dao.entity.fofo.FofoLineItem;
|
28 |
import com.spice.profitmandi.dao.entity.fofo.FofoLineItem;
|
| - |
|
29 |
import com.spice.profitmandi.dao.entity.fofo.FofoOrder;
|
| 29 |
import com.spice.profitmandi.dao.entity.fofo.InventoryItem;
|
30 |
import com.spice.profitmandi.dao.entity.fofo.InventoryItem;
|
| 30 |
import com.spice.profitmandi.dao.entity.fofo.Purchase;
|
31 |
import com.spice.profitmandi.dao.entity.fofo.Purchase;
|
| 31 |
import com.spice.profitmandi.dao.entity.fofo.ScanRecord;
|
32 |
import com.spice.profitmandi.dao.entity.fofo.ScanRecord;
|
| 32 |
import com.spice.profitmandi.dao.entity.fofo.SchemeInOut;
|
33 |
import com.spice.profitmandi.dao.entity.fofo.SchemeInOut;
|
| 33 |
import com.spice.profitmandi.dao.entity.transaction.Order;
|
34 |
import com.spice.profitmandi.dao.entity.transaction.Order;
|
| Line 38... |
Line 39... |
| 38 |
import com.spice.profitmandi.dao.enumuration.fofo.ScanType;
|
39 |
import com.spice.profitmandi.dao.enumuration.fofo.ScanType;
|
| 39 |
import com.spice.profitmandi.dao.repository.catalog.SchemeRepository;
|
40 |
import com.spice.profitmandi.dao.repository.catalog.SchemeRepository;
|
| 40 |
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
|
41 |
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
|
| 41 |
import com.spice.profitmandi.dao.repository.fofo.FofoLineItemRepository;
|
42 |
import com.spice.profitmandi.dao.repository.fofo.FofoLineItemRepository;
|
| 42 |
import com.spice.profitmandi.dao.repository.fofo.FofoOrderItemRepository;
|
43 |
import com.spice.profitmandi.dao.repository.fofo.FofoOrderItemRepository;
|
| - |
|
44 |
import com.spice.profitmandi.dao.repository.fofo.FofoOrderRepository;
|
| 43 |
import com.spice.profitmandi.dao.repository.fofo.InventoryItemRepository;
|
45 |
import com.spice.profitmandi.dao.repository.fofo.InventoryItemRepository;
|
| 44 |
import com.spice.profitmandi.dao.repository.fofo.PurchaseRepository;
|
46 |
import com.spice.profitmandi.dao.repository.fofo.PurchaseRepository;
|
| 45 |
import com.spice.profitmandi.dao.repository.fofo.ScanRecordRepository;
|
47 |
import com.spice.profitmandi.dao.repository.fofo.ScanRecordRepository;
|
| 46 |
import com.spice.profitmandi.dao.repository.fofo.SchemeInOutRepository;
|
48 |
import com.spice.profitmandi.dao.repository.fofo.SchemeInOutRepository;
|
| 47 |
import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
|
49 |
import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
|
| Line 90... |
Line 92... |
| 90 |
@Autowired
|
92 |
@Autowired
|
| 91 |
private ReturnOrderRepository returnOrderRepository;
|
93 |
private ReturnOrderRepository returnOrderRepository;
|
| 92 |
@Autowired
|
94 |
@Autowired
|
| 93 |
private OrderRepository orderRepository;
|
95 |
private OrderRepository orderRepository;
|
| 94 |
@Autowired
|
96 |
@Autowired
|
| - |
|
97 |
private FofoOrderRepository fofoOrderRepository;
|
| - |
|
98 |
|
| - |
|
99 |
@Autowired
|
| 95 |
private JavaMailSender mailSender;
|
100 |
private JavaMailSender mailSender;
|
| 96 |
|
101 |
|
| 97 |
public void dailyReconciliation() throws Exception {
|
102 |
public void dailyReconciliation() throws Exception {
|
| 98 |
LocalDate date = LocalDate.now().minusDays(1);
|
103 |
LocalDate date = LocalDate.now().minusDays(1);
|
| 99 |
dailyReconciliation(date);
|
104 |
dailyReconciliation(date);
|
| Line 302... |
Line 307... |
| 302 |
ScanRecord outRecord = scanRecordRepository
|
307 |
ScanRecord outRecord = scanRecordRepository
|
| 303 |
.selectByInventoryItemId(schemeInOut.getInventoryItemId()).stream()
|
308 |
.selectByInventoryItemId(schemeInOut.getInventoryItemId()).stream()
|
| 304 |
.filter(x -> x.getType().equals(ScanType.SALE)).sorted((x1,x2)->x1.getId() - x2.getId()).collect(Collectors.toList()).get(0);
|
309 |
.filter(x -> x.getType().equals(ScanType.SALE)).sorted((x1,x2)->x1.getId() - x2.getId()).collect(Collectors.toList()).get(0);
|
| 305 |
if (outRecord.getCreateTimestamp().isAfter(scheme.getExpireTimestamp())) {
|
310 |
if (outRecord.getCreateTimestamp().isAfter(scheme.getExpireTimestamp())) {
|
| 306 |
InventoryItem ii = inventoryItemRepository.selectById(outRecord.getInventoryItemId());
|
311 |
InventoryItem ii = inventoryItemRepository.selectById(outRecord.getInventoryItemId());
|
| 307 |
Order order;
|
312 |
FofoOrder fofoOrder;
|
| 308 |
if(outRecord.getOrderId()==0) {
|
313 |
if(outRecord.getOrderId()==0) {
|
| 309 |
continue;
|
314 |
continue;
|
| 310 |
} else {
|
315 |
} else {
|
| 311 |
order = orderRepository.selectById(outRecord.getOrderId());
|
316 |
fofoOrder = fofoOrderRepository.selectByOrderId(outRecord.getOrderId());
|
| 312 |
if(order==null) {
|
317 |
if(fofoOrder==null) {
|
| 313 |
LOGGER.info("Order id does not exits - {}", outRecord.getOrderId());
|
318 |
LOGGER.info("Order id does not exits - {}", outRecord.getOrderId());
|
| 314 |
continue;
|
319 |
continue;
|
| 315 |
}
|
320 |
}
|
| 316 |
}
|
321 |
}
|
| 317 |
System.out.println(String.format("%d\t%s\t%d\t%d\t%s\t%s\t%f\t%f\t%d\t%s",
|
322 |
System.out.println(String.format("%d\t%s\t%d\t%d\t%s\t%s\t%f\t%f\t%d\t%s",
|
| 318 |
ii.getId(), ii.getSerialNumber(), ii.getItemId(), schemeInOut.getSchemeId(), scheme.getName(), scheme.getType(),
|
323 |
ii.getId(), ii.getSerialNumber(), ii.getItemId(), schemeInOut.getSchemeId(), scheme.getName(), scheme.getType(),
|
| 319 |
scheme.getAmount(), schemeInOut.getAmount(), order.getId(), outRecord.getCreateTimestamp()));
|
324 |
scheme.getAmount(), schemeInOut.getAmount(), fofoOrder.getId(), outRecord.getCreateTimestamp()));
|
| 320 |
|
325 |
|
| 321 |
}
|
326 |
}
|
| 322 |
|
327 |
|
| 323 |
}
|
328 |
}
|
| 324 |
}
|
329 |
}
|