| Line 55... |
Line 55... |
| 55 |
return typedQuerySimilar.getResultList();
|
55 |
return typedQuerySimilar.getResultList();
|
| 56 |
|
56 |
|
| 57 |
}
|
57 |
}
|
| 58 |
|
58 |
|
| 59 |
@Override
|
59 |
@Override
|
| 60 |
public List<TodayAchievedMovementModel> getTodayTargetByMovement(LocalDate startDate, LocalDate endDate) {
|
60 |
public List<TodayAchievedMovementModel> getMovementWiseAchievementByDate(LocalDate startDate, LocalDate endDate) {
|
| 61 |
LOGGER.info("start date {}, end date {}", startDate, endDate);
|
61 |
LOGGER.info("start date {}, end date {}", startDate, endDate);
|
| 62 |
Session session = sessionFactory.getCurrentSession();
|
62 |
Session session = sessionFactory.getCurrentSession();
|
| 63 |
final TypedQuery<TodayAchievedMovementModel> typedQuerySimilar = session.createNamedQuery("RBMTarget.TodayTargetByMovement", TodayAchievedMovementModel.class);
|
63 |
final TypedQuery<TodayAchievedMovementModel> typedQuerySimilar = session.createNamedQuery("RBMTarget.TodayAchivementByMovement", TodayAchievedMovementModel.class);
|
| 64 |
typedQuerySimilar.setParameter("startDate", startDate);
|
64 |
typedQuerySimilar.setParameter("startDate", startDate);
|
| 65 |
typedQuerySimilar.setParameter("endDate", endDate);
|
65 |
typedQuerySimilar.setParameter("endDate", endDate);
|
| 66 |
return typedQuerySimilar.getResultList();
|
66 |
return typedQuerySimilar.getResultList();
|
| 67 |
|
67 |
|
| 68 |
}
|
68 |
}
|
| Line 236... |
Line 236... |
| 236 |
|
236 |
|
| 237 |
LocalDate startDateOfMonthDay1 = LocalDate.now().withDayOfMonth(1);
|
237 |
LocalDate startDateOfMonthDay1 = LocalDate.now().withDayOfMonth(1);
|
| 238 |
|
238 |
|
| 239 |
List<WarehouseRbmTargetModel> warehouseRbmTargetModels = this.getWarehouseWiseRbmMonthlyTarget();
|
239 |
List<WarehouseRbmTargetModel> warehouseRbmTargetModels = this.getWarehouseWiseRbmMonthlyTarget();
|
| 240 |
|
240 |
|
| 241 |
List<TodayAchievedMovementModel> todayAchievedMovementModels = getTodayTargetByMovement(todayDate, todayDate.plusDays(1));
|
241 |
List<TodayAchievedMovementModel> todayAchievedMovementModels = getMovementWiseAchievementByDate(todayDate, todayDate.plusDays(1));
|
| 242 |
|
242 |
|
| 243 |
List<MTDAchievedTargetModel> mtdAchievedTargetModels = getDateWiseAchievedTargetOfRbm(startDateOfMonthDay1, todayDate);
|
243 |
List<MTDAchievedTargetModel> mtdAchievedTargetModels = getDateWiseAchievedTargetOfRbm(startDateOfMonthDay1, todayDate);
|
| 244 |
|
244 |
|
| 245 |
int remainingWorkingDaysCount = getWorkingDaysCount(todayDate);
|
245 |
int remainingWorkingDaysCount = getWorkingDaysCount(todayDate);
|
| 246 |
|
246 |
|
| Line 379... |
Line 379... |
| 379 |
|
379 |
|
| 380 |
@Override
|
380 |
@Override
|
| 381 |
public void setMovementWiseRbmAchievement() {
|
381 |
public void setMovementWiseRbmAchievement() {
|
| 382 |
LocalDate todayDate = LocalDate.now();
|
382 |
LocalDate todayDate = LocalDate.now();
|
| 383 |
|
383 |
|
| 384 |
List<TodayAchievedMovementModel> todayAchievedMovementModels = getTodayTargetByMovement(todayDate, todayDate.plusDays(1));
|
384 |
List<TodayAchievedMovementModel> todayAchievedMovementModels = getMovementWiseAchievementByDate(todayDate, todayDate.plusDays(1));
|
| 385 |
|
385 |
|
| 386 |
|
386 |
|
| 387 |
for (TodayAchievedMovementModel achievement : todayAchievedMovementModels) {
|
387 |
for (TodayAchievedMovementModel achievement : todayAchievedMovementModels) {
|
| 388 |
|
388 |
|
| 389 |
RbmAchievements rbmAchievements = new RbmAchievements();
|
389 |
RbmAchievements rbmAchievements = new RbmAchievements();
|
| Line 402... |
Line 402... |
| 402 |
|
402 |
|
| 403 |
}
|
403 |
}
|
| 404 |
|
404 |
|
| 405 |
}
|
405 |
}
|
| 406 |
|
406 |
|
| - |
|
407 |
@Override
|
| - |
|
408 |
public List<Sold15daysOldAgingModel> getAgingSale(LocalDate startDate, LocalDate endDate) {
|
| - |
|
409 |
Session session = sessionFactory.getCurrentSession();
|
| - |
|
410 |
final TypedQuery<Sold15daysOldAgingModel> typedQuerySimilar = session.createNamedQuery("Aging.SoldAgingModel", Sold15daysOldAgingModel.class);
|
| - |
|
411 |
// typedQuerySimilar.setParameter("startDate", startDate);
|
| - |
|
412 |
// typedQuerySimilar.setParameter("endDate", endDate);
|
| - |
|
413 |
return typedQuerySimilar.getResultList();
|
| - |
|
414 |
|
| - |
|
415 |
}
|
| - |
|
416 |
|
| - |
|
417 |
public List<Our15DaysOldAgingStock> our15DaysAgingStock() {
|
| - |
|
418 |
Session session = sessionFactory.getCurrentSession();
|
| - |
|
419 |
final TypedQuery<Our15DaysOldAgingStock> typedQuerySimilar = session.createNamedQuery("Aging.15DaysOurStock", Our15DaysOldAgingStock.class);
|
| - |
|
420 |
return typedQuerySimilar.getResultList();
|
| - |
|
421 |
|
| - |
|
422 |
}
|
| - |
|
423 |
|
| 407 |
|
424 |
|
| 408 |
}
|
425 |
}
|