| Line 1... |
Line 1... |
| 1 |
package com.smartdukaan.cron.migrations;
|
1 |
package com.smartdukaan.cron.migrations;
|
| 2 |
|
2 |
|
| 3 |
import java.time.LocalDate;
|
3 |
import java.time.LocalDate;
|
| 4 |
import java.time.LocalDateTime;
|
4 |
import java.time.LocalDateTime;
|
| 5 |
import java.time.LocalTime;
|
5 |
import java.time.LocalTime;
|
| - |
|
6 |
import java.time.Month;
|
| 6 |
import java.util.Arrays;
|
7 |
import java.util.Arrays;
|
| 7 |
import java.util.Collections;
|
8 |
import java.util.Collections;
|
| 8 |
import java.util.List;
|
9 |
import java.util.List;
|
| 9 |
|
10 |
|
| 10 |
import org.apache.commons.lang.StringUtils;
|
11 |
import org.apache.commons.lang.StringUtils;
|
| Line 12... |
Line 13... |
| 12 |
import org.apache.logging.log4j.Logger;
|
13 |
import org.apache.logging.log4j.Logger;
|
| 13 |
import org.springframework.beans.factory.annotation.Autowired;
|
14 |
import org.springframework.beans.factory.annotation.Autowired;
|
| 14 |
import org.springframework.stereotype.Component;
|
15 |
import org.springframework.stereotype.Component;
|
| 15 |
import org.springframework.transaction.annotation.Transactional;
|
16 |
import org.springframework.transaction.annotation.Transactional;
|
| 16 |
|
17 |
|
| - |
|
18 |
import com.spice.profitmandi.dao.entity.fofo.Purchase;
|
| 17 |
import com.spice.profitmandi.dao.entity.transaction.LineItem;
|
19 |
import com.spice.profitmandi.dao.entity.transaction.LineItem;
|
| 18 |
import com.spice.profitmandi.dao.entity.transaction.LineItemImei;
|
20 |
import com.spice.profitmandi.dao.entity.transaction.LineItemImei;
|
| 19 |
import com.spice.profitmandi.dao.entity.transaction.Order;
|
21 |
import com.spice.profitmandi.dao.entity.transaction.Order;
|
| - |
|
22 |
import com.spice.profitmandi.dao.repository.fofo.PurchaseRepository;
|
| 20 |
import com.spice.profitmandi.dao.repository.transaction.LineItemImeisRepository;
|
23 |
import com.spice.profitmandi.dao.repository.transaction.LineItemImeisRepository;
|
| 21 |
import com.spice.profitmandi.dao.repository.transaction.LineItemRepository;
|
24 |
import com.spice.profitmandi.dao.repository.transaction.LineItemRepository;
|
| 22 |
import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
|
25 |
import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
|
| 23 |
|
26 |
|
| 24 |
@Component
|
27 |
@Component
|
| Line 33... |
Line 36... |
| 33 |
@Autowired
|
36 |
@Autowired
|
| 34 |
private OrderRepository orderRepository;
|
37 |
private OrderRepository orderRepository;
|
| 35 |
|
38 |
|
| 36 |
@Autowired
|
39 |
@Autowired
|
| 37 |
private LineItemImeisRepository lineItemImeisRepository;
|
40 |
private LineItemImeisRepository lineItemImeisRepository;
|
| - |
|
41 |
|
| - |
|
42 |
@Autowired
|
| - |
|
43 |
private PurchaseRepository purchaseRepository;
|
| 38 |
|
44 |
|
| - |
|
45 |
|
| - |
|
46 |
|
| - |
|
47 |
public void populateGrnTimestamp() {
|
| - |
|
48 |
List<Purchase> allPurchases = purchaseRepository.selectAll();
|
| - |
|
49 |
for(Purchase p : allPurchases) {
|
| - |
|
50 |
String invoiceNumber = p.getPurchaseReference();
|
| - |
|
51 |
if(p.getCompleteTimestamp() == null) {
|
| - |
|
52 |
LOGGER.info("GRN for invoice {} is delivered but partially Completed.", p.getPurchaseReference());
|
| - |
|
53 |
} else {
|
| - |
|
54 |
List<Order> orders = orderRepository.selectByAirwayBillOrInvoiceNumber(invoiceNumber, p.getFofoId());
|
| - |
|
55 |
for(Order order : orders) {
|
| - |
|
56 |
if(order.getPartnerPurchaseTimestamp() == null) {
|
| - |
|
57 |
order.setPartnerPurchaseTimestamp(p.getCompleteTimestamp());
|
| - |
|
58 |
orderRepository.persist(order);
|
| - |
|
59 |
}
|
| - |
|
60 |
}
|
| - |
|
61 |
}
|
| - |
|
62 |
}
|
| - |
|
63 |
|
| - |
|
64 |
}
|
| - |
|
65 |
|
| 39 |
public void migarateLineItemsToNewTable() {
|
66 |
public void migarateLineItemsToNewTable() {
|
| 40 |
LOGGER.info("Before Migrated LineItems Successfully");
|
67 |
LOGGER.info("Before Migrated LineItems Successfully");
|
| 41 |
int lineItemImeiId = 0;
|
68 |
int lineItemImeiId = 0;
|
| 42 |
LocalDateTime startDate = null;
|
69 |
LocalDateTime startDate = null;
|
| 43 |
try {
|
70 |
try {
|