ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/OrderController.java
@@ -152,7 +152,7 @@ @ApiImplicitParam(value = "订单状态", name = "status", required = true, dataType = "int"), }) @GetMapping("/getMyOrderList") public TableDataInfo<OrderVO> getMyOrderList(@ApiParam("订单状态") Integer status) { public TableDataInfo<OrderVO> getMyOrderList(@RequestParam("订单状态") Integer status) { startPage(); LoginUser loginUserApplet = tokenService.getLoginUserApplet(); return getDataTable(orderService.selectOrderListByUserId(status, loginUserApplet.getUserid())); @@ -195,18 +195,18 @@ */ @ApiOperation(value = "订单核销", tags = {"小程序-个人中心-门店管理"}) @GetMapping("/writeOff") public R<Void> writeOff(@ApiParam("id") String id, @ApiParam("shopId") Integer shopId) { public R<Void> writeOff(@RequestParam("id") String id, @RequestParam("shopId") Integer shopId) { orderService.writeOff(id, shopId); return R.ok(); } @GetMapping("/getShopOrderList") @ApiOperation(value = "获取订单列表", tags = {"门店后台-订单管理", }) public R<IPage<OrderPageListVo>> getShopOrderList(@ApiParam("模糊查询:订单编号/商品名/手机号 ") String content , @ApiParam("订单状态") Integer status, @ApiParam("门店id") Integer shopId, @ApiParam("页码") @RequestParam("pageNum") Integer pageNum, @ApiParam("每一页数据大小") @RequestParam("pageSize") Integer pageSize) { public R<IPage<OrderPageListVo>> getShopOrderList(@RequestParam("content") String content , @RequestParam("status") Integer status, @RequestParam("shopId") Integer shopId, @RequestParam("pageNum") Integer pageNum, @RequestParam("pageSize") Integer pageSize) { return R.ok(orderService.getShopOrderList(content,status,shopId,pageNum,pageSize)); } @PostMapping("/importExpress") ruoyi-service/ruoyi-order/src/main/resources/mapper/order/ChargeOrderMapper.xml
@@ -32,26 +32,26 @@ order by begin_time DESC </select> <select id="chargingOrderGroup" resultType="com.ruoyi.common.core.dto.ChargingOrderGroup"> SELECT SUM(tc.charging_capacity) as charging_capacity,tc.site_id SELECT SUM(tc.charging_capacity) as charging_capacity,tc.power_station_id FROM t_charge_order tc left join `gy_jifenshangcheng_service`.`t_site` ts on tc.site_id = ts.id left join `gy_jifenshangcheng_service`.`t_site` ts on tc.power_station_id = ts.id <where> <if test="chargingPercentProvinceDto.date1 != null"> AND tc.create_time >= #{chargingPercentProvinceDto.date1} AND tc.begin_time >= #{chargingPercentProvinceDto.date1} </if> <if test="chargingPercentProvinceDto.date2 != null"> AND tc.create_time <= #{chargingPercentProvinceDto.date2} AND tc.begin_time <= #{chargingPercentProvinceDto.date2} </if> <if test="chargingPercentProvinceDto.provinceCode != null"> AND ts.province_code = #{chargingPercentProvinceDto.provinceCode} </if> <if test="chargingPercentProvinceDto.siteIds != null and chargingPercentProvinceDto.siteIds.size() > 0"> AND site_id IN AND power_station_id IN <foreach collection="chargingPercentProvinceDto.siteIds" item="siteId" open="(" separator="," close=")"> #{siteId} </foreach> </if> </where> GROUP BY site_id GROUP BY power_station_id </select> </mapper>