| Line 36... |
Line 36... |
| 36 |
import com.spice.profitmandi.service.user.RetailerService;
|
36 |
import com.spice.profitmandi.service.user.RetailerService;
|
| 37 |
import org.apache.logging.log4j.LogManager;
|
37 |
import org.apache.logging.log4j.LogManager;
|
| 38 |
import org.apache.logging.log4j.Logger;
|
38 |
import org.apache.logging.log4j.Logger;
|
| 39 |
import org.hibernate.Session;
|
39 |
import org.hibernate.Session;
|
| 40 |
import org.hibernate.SessionFactory;
|
40 |
import org.hibernate.SessionFactory;
|
| 41 |
import org.springframework.cache.annotation.Cacheable;
|
- |
|
| 42 |
import org.hibernate.query.NativeQuery;
|
41 |
import org.hibernate.query.NativeQuery;
|
| 43 |
import org.springframework.beans.factory.annotation.Autowired;
|
42 |
import org.springframework.beans.factory.annotation.Autowired;
|
| - |
|
43 |
import org.springframework.cache.annotation.Cacheable;
|
| 44 |
import org.springframework.stereotype.Component;
|
44 |
import org.springframework.stereotype.Component;
|
| 45 |
|
45 |
|
| 46 |
import javax.persistence.TypedQuery;
|
46 |
import javax.persistence.TypedQuery;
|
| 47 |
import java.time.*;
|
47 |
import java.time.*;
|
| 48 |
import java.time.format.DateTimeFormatter;
|
48 |
import java.time.format.DateTimeFormatter;
|
| Line 513... |
Line 513... |
| 513 |
|
513 |
|
| 514 |
public List<Our15DaysOldAgingStock> our15DaysAgingStock() {
|
514 |
public List<Our15DaysOldAgingStock> our15DaysAgingStock() {
|
| 515 |
Session session = sessionFactory.getCurrentSession();
|
515 |
Session session = sessionFactory.getCurrentSession();
|
| 516 |
final TypedQuery<Our15DaysOldAgingStock> typedQuerySimilar = session.createNamedQuery("Aging.15DaysOurStock", Our15DaysOldAgingStock.class);
|
516 |
final TypedQuery<Our15DaysOldAgingStock> typedQuerySimilar = session.createNamedQuery("Aging.15DaysOurStock", Our15DaysOldAgingStock.class);
|
| 517 |
return typedQuerySimilar.getResultList();
|
517 |
return typedQuerySimilar.getResultList();
|
| - |
|
518 |
}
|
| 518 |
|
519 |
|
| - |
|
520 |
@Override
|
| - |
|
521 |
public List<WarehouseAgingStockModel> getWarehouseWiseAgingStock() {
|
| - |
|
522 |
Session session = sessionFactory.getCurrentSession();
|
| - |
|
523 |
final TypedQuery<WarehouseAgingStockModel> typedQuery = session.createNamedQuery("Aging.15DaysWarehouseWiseStock", WarehouseAgingStockModel.class);
|
| - |
|
524 |
return typedQuery.getResultList();
|
| 519 |
}
|
525 |
}
|
| 520 |
|
526 |
|
| 521 |
@Autowired
|
527 |
@Autowired
|
| 522 |
OrderRepository orderRepository;
|
528 |
OrderRepository orderRepository;
|
| 523 |
|
529 |
|