Guest User

Untitled

a guest
Jun 18th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. @Query(value="select date(start_time) as ride_date, count(distinct(ride_id)) as rides from ride where is_ended = 1 and ride_amount > 0 and start_time >= date_sub(curdate(), interval 6 day) group by ride_date",nativeQuery=true)
  2. public List<Object[]> getForVBChart();
  3.  
  4. List<Object[]> object = rideRepository.getRidesPerDayForVBChart();
  5. for (Object[] a : object) {
  6. System.out.println("Details "
  7. + a[0]
  8. + " "
  9. + a[1]);
  10. }
  11.  
  12. Details 2018-06-16 8
  13. Details 2018-06-17 3
Add Comment
Please, Sign In to add comment