明星电力充电桩
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
Pu Zhibing
2024-09-20 a146097a15d719c60af3cdeb4de1f21aa7b5ca8d 
 ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/controller/TParkingRecordController.java


@@ -8,10 +8,9 @@


import com.ruoyi.chargingPile.api.model.TParkingLot;


import com.ruoyi.chargingPile.api.model.TParkingRecord;


import com.ruoyi.chargingPile.api.query.ParkingRecordQuery;


import com.ruoyi.chargingPile.api.vo.GetParkingRecord;


import com.ruoyi.chargingPile.api.vo.TParkingRecordPageInfoVO;


import com.ruoyi.chargingPile.api.vo.TParkingRecordVO;


import com.ruoyi.chargingPile.api.vo.*;


import com.ruoyi.chargingPile.dto.ParkingRecordPageQuery;


import com.ruoyi.chargingPile.dto.ParkingRecordQueryDto;


import com.ruoyi.chargingPile.export.TParkingRecordExport;


import com.ruoyi.chargingPile.service.TParkingLotService;


import com.ruoyi.chargingPile.service.TParkingRecordService;


@@ -22,7 +21,9 @@


import com.ruoyi.common.core.web.page.PageInfo;


import com.ruoyi.common.log.annotation.Log;


import com.ruoyi.common.log.enums.BusinessType;


import com.ruoyi.common.log.enums.OperatorType;


import com.ruoyi.order.api.query.TOrderInvoiceQuery;


import com.ruoyi.order.api.vo.TCharingUserEquimentVO;


import com.ruoyi.order.api.vo.TOrderInvoiceVO;


import io.swagger.annotations.ApiOperation;


import org.apache.poi.ss.usermodel.Workbook;


@@ -33,9 +34,12 @@


import javax.servlet.ServletOutputStream;


import javax.servlet.http.HttpServletResponse;


import java.io.IOException;


import java.math.BigDecimal;


import java.net.URLEncoder;


import java.util.ArrayList;


import java.util.List;


import java.util.Map;


import java.util.stream.Collectors;




/**


 * <p>


@@ -77,6 +81,7 @@


    }


    @ApiOperation(tags = {"后台-订单管理-停车记录"},value = "导出")


    @PutMapping("/export")


    @Log(title = "【停车记录】导出停车记录", businessType = BusinessType.EXPORT,operatorType = OperatorType.MANAGE)


    public void export(@RequestBody ParkingRecordQuery query)


    {


        List<TParkingRecordVO> records = parkingRecordService.pageList(query).getParkingRecordVOS().getRecords();


@@ -122,13 +127,12 @@


    @ApiOperation(tags = {"后台-订单管理-停车记录"},value = "详情")


    @GetMapping(value = "/detail")


    public R<TParkingRecord> detail(Long id) {




      return R.ok(parkingRecordService.getById(id));




    }




    @ApiOperation(tags = {"后台-订单管理-停车记录"},value = "出场")


    @GetMapping(value = "/out")


    @Log(title = "【停车记录】修改出场状态", businessType = BusinessType.UPDATE,operatorType = OperatorType.MANAGE)


    public R out(Long id) {


        TParkingRecord byId = parkingRecordService.getById(id);


        byId.setStatus(2);


@@ -181,5 +185,76 @@


    public void addParkingRecord(@RequestBody TParkingRecord parkingRecord){


        parkingRecordService.save(parkingRecord);


    }




    @ResponseBody


    @PostMapping(value = "/parking/data")


    @ApiOperation(value = "统计", tags = {"管理后台-数据分析-车场运营分析"})


    public R<TParkLotRecordVO> data(@RequestBody ParkingRecordQueryDto parkingRecordQueryDto){


        //上方折线图


        TParkLotRecordVO tParkLotRecordVO = new TParkLotRecordVO();




        if (parkingRecordQueryDto.getDayType()==1) {


            List<Map<String, Object>> maps = parkingRecordService.parkingData(parkingRecordQueryDto);


            tParkLotRecordVO.setMaps(maps);


        }else {


            List<Map<String, Object>> maps = parkingRecordService.parkingDataByDate(parkingRecordQueryDto);


            tParkLotRecordVO.setMaps(maps);


        }




        //车辆类型饼图


        List<Map<String, Object>> carColor  =   parkingRecordService.getCarColor(parkingRecordQueryDto);




        //出场类型


        List<Map<String, Object>> outType  =   parkingRecordService.getOutType(parkingRecordQueryDto);




        //进场充电占比


        List<Map<String, Object>> isCharge  =   parkingRecordService.getIsCharge(parkingRecordQueryDto);






        tParkLotRecordVO.setCarColor(carColor);


        tParkLotRecordVO.setOutType(outType);


        tParkLotRecordVO.setIsCharge(isCharge);


        return R.ok(tParkLotRecordVO);




    }






    @ResponseBody


    @PostMapping(value = "/parking/work")


    @ApiOperation(value = "停车订单统计", tags = {"管理后台-工作台"})


    public R<TParkLotRecordCountVo> work(@RequestBody ParkingRecordQueryDto parkingRecordQueryDto){


        List<TParkingRecord> list = parkingRecordService.lambdaQuery().eq(parkingRecordQueryDto.getParkingLotId() != null, TParkingRecord::getParkingLotId, parkingRecordQueryDto.getParkingLotId())


                .between(TParkingRecord::getCreateTime, parkingRecordQueryDto.getStartTime(), parkingRecordQueryDto.getEndTime()).list();


        int count1 = list.size();


        //统计出list中chargingOrderId为null的数据个数


        int count2 = list.stream().filter(item -> item.getChargingOrderId() == null).collect(Collectors.toList()).size();


        int count3 = count1-count2;


        //计算出list中parkingDuration的总和


        int count4 = 0;


        for (TParkingRecord tParkingRecord : list) {


            count4 = count4+tParkingRecord.getParkingDuration();


        }


        //计算出list中orderAmount的总和


        BigDecimal count5 = list.stream().map(TParkingRecord::getOrderAmount).reduce(BigDecimal.ZERO, BigDecimal::add);




        TParkLotRecordCountVo tParkLotRecordCountVo = new TParkLotRecordCountVo();


        tParkLotRecordCountVo.setCount1(count1);


        tParkLotRecordCountVo.setCount2(count2);


        tParkLotRecordCountVo.setCount3(count3);


        tParkLotRecordCountVo.setCount4(count4);


        tParkLotRecordCountVo.setCount5(count5);




        return R.ok(tParkLotRecordCountVo);




    }




    @ResponseBody


    @PostMapping(value = "/parking/income")


    @ApiOperation(value = "停车收入统计", tags = {"管理后台-工作台"})


    public R income(@RequestBody ParkingRecordQueryDto parkingRecordQueryDto){




       List<Map<String,Object>>  maps =  parkingRecordService.income(parkingRecordQueryDto);


        return R.ok(maps);


    }


}