| | |
| | | private TravelCountService travelCountService; |
| | | |
| | | @Override |
| | | public AjaxResult selectDataList(Long userId, Integer pageNum, Integer pageSize,TravelCount travelCount) { |
| | | public AjaxResult selectDataList(Long userId, Integer pageNum, Integer pageSize, TravelCount travelCount, String happenStartTime, String happenEndTime) { |
| | | //设置查询条件 |
| | | LambdaQueryWrapper<TravelCount> lqw = new LambdaQueryWrapper<>(); |
| | | lqw.eq(TravelCount::getUid,userId); |
| | |
| | | lqw.like(travelCount.getName()!=null,TravelCount::getName,travelCount.getName()); |
| | | lqw.like(travelCount.getName()!=null,TravelCount::getName,travelCount.getName()); |
| | | } |
| | | if(happenStartTime!=null){ |
| | | lqw.gt(TravelCount::getStartTime,happenStartTime); |
| | | } |
| | | |
| | | |
| | | if(happenEndTime!=null){ |
| | | lqw.lt(TravelCount::getEndTime,happenEndTime); |
| | | } |
| | | lqw.orderByDesc(TravelCount::getCreateTime); |
| | | |
| | | Page<TravelCount> resultPage = page(new Page<>(pageNum, pageSize), lqw); |
| | | resultPage.getRecords().forEach(this::inputTotalData); |
| | |
| | | double eatTotal = 0; |
| | | double stayTotal = 0; |
| | | double travelTotal = 0; |
| | | |
| | | double shopTotal = 0; |
| | | //把所有详细数据的费用值累加起来 |
| | | for (TravelDetail detail : travelDetailList) { |
| | | entranceTotal+=detail.getEntrance(); |
| | | eatTotal+=detail.getEat(); |
| | | stayTotal+=detail.getStay(); |
| | | travelTotal+=detail.getTravel(); |
| | | shopTotal += detail.getShop(); |
| | | } |
| | | |
| | | travelCount.setEntranceTotal(entranceTotal); |
| | | travelCount.setEatTotal(eatTotal); |
| | | travelCount.setStayTotal(stayTotal); |
| | | travelCount.setTravelTotal(travelTotal); |
| | | |
| | | travelCount.setShopTotal(shopTotal); |
| | | DecimalFormat df = new DecimalFormat("0.00"); |
| | | travelCount.setTotalPrice(Double.parseDouble(df.format(entranceTotal+eatTotal+travelCount.getGroupTotal()+stayTotal+travelTotal))); |
| | | } |