package com.ruoyi.service.impl;
|
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.ruoyi.common.core.domain.AjaxResult;
|
import com.ruoyi.common.utils.MapUtils;
|
import com.ruoyi.domain.TravelCount;
|
import com.ruoyi.domain.TravelDetail;
|
import com.ruoyi.mapper.TravelCountMapper;
|
import com.ruoyi.service.TravelCountService;
|
import com.ruoyi.service.TravelDetailService;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import java.text.DecimalFormat;
|
import java.util.List;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author ojq
|
* @since 2023-10-06
|
*/
|
@Service
|
public class TravelCountServiceImpl extends ServiceImpl<TravelCountMapper, TravelCount> implements TravelCountService {
|
|
@Autowired
|
private TravelDetailService travelDetailService;
|
|
@Autowired
|
private TravelCountService travelCountService;
|
|
@Override
|
public AjaxResult selectDataList(Long userId, Integer pageNum, Integer pageSize) {
|
LambdaQueryWrapper<TravelCount> lqw = new LambdaQueryWrapper<>();
|
lqw.eq(TravelCount::getUid,userId);
|
|
Page<TravelCount> resultPage = page(new Page<>(pageNum, pageSize), lqw);
|
|
resultPage.getRecords().forEach(data ->{
|
//先找到对应一条统计数据的所有详细数据
|
List<TravelDetail> travelDetailList = travelDetailService.getDataByCid(data.getId());
|
double entranceTotal = 0;
|
double eatTotal = 0;
|
double stayTotal = 0;
|
double travelTotal = 0;
|
|
//把所有详细数据的费用值累加起来
|
for (TravelDetail detail : travelDetailList) {
|
entranceTotal+=detail.getEntrance();
|
eatTotal+=detail.getEat();
|
stayTotal+=detail.getStay();
|
travelTotal+=detail.getTravel();
|
}
|
|
data.setEntranceTotal(entranceTotal);
|
data.setEatTotal(eatTotal);
|
data.setStayTotal(stayTotal);
|
data.setTravelTotal(travelTotal);
|
|
DecimalFormat df = new DecimalFormat("0.00");
|
data.setTotalPrice(Double.parseDouble(df.format(entranceTotal+eatTotal+data.getGroupTotal()+stayTotal+travelTotal)));
|
});
|
|
return AjaxResult.success(MapUtils.getResult(resultPage));
|
}
|
|
/**
|
* 批量删除统计表数据
|
*/
|
@Override
|
@Transactional
|
public void removeData(List<Long> list) {
|
|
//在删除统计表数据之前，要先删除明细表的数据
|
travelDetailService.removeBatchByCid(list);
|
|
//再删除自己表的数据
|
travelCountService.removeBatchByIds(list);
|
}
|
}
|
