ruoyi-api/ruoyi-api-order/src/main/java/com/ruoyi/order/api/query/SettlementListQuery.java
@@ -14,7 +14,7 @@ @ApiModelProperty(value = "类型(1=开始,2=结束)") private Integer type; @ApiModelProperty(value = "站点ids 选择全部 不传") private List<Integer> siteIds; private Integer siteIds; @ApiModelProperty(value = "合作商id ") private Integer partnerId; @ApiModelProperty(value = "开始时间2020-01-01 00:00:00") @@ -22,4 +22,5 @@ @ApiModelProperty(value = "结束时间2021-01-01 23:59:59") private String endTime; } ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/util/CarUtil.java
@@ -877,91 +877,91 @@ " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + " \"AreaCode\": \"110110\"\n" + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京B\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + " \"AreaCode\": \"110110\"\n" + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京C\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + " \"AreaCode\": \"110110\"\n" + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京D\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + " \"AreaCode\": \"110110\"\n" + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京E\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + " \"AreaCode\": \"110110\"\n" + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京F\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + " \"AreaCode\": \"110110\"\n" + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京G\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + " \"AreaCode\": \"110110\"\n" + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京H\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + " \"AreaCode\": \"110110\"\n" + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京J\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + " \"AreaCode\": \"110110\"\n" + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京K\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + " \"AreaCode\": \"110110\"\n" + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京L\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + " \"AreaCode\": \"110110\"\n" + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京M\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + " \"AreaCode\": \"110110\"\n" + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"京Y\",\n" + " \"city\": \"北京\",\n" + " \"province\": \"北京\",\n" + " \"Pcode\": \"BJ\",\n" + " \"AreaCode\": \"110110\"\n" + " \"AreaCode\": \"110100\"\n" + " },\n" + " {\n" + " \"Hp\": \"豫A\",\n" + ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TChargingOrderServiceImpl.java
@@ -2435,6 +2435,18 @@ @Override public PageInfo<TSettlementConfirm> settlementList(SettlementListQuery dto) { if (StringUtils.hasLength(dto.getStartTime())){ dto.setType(1); String[] split = dto.getStartTime().split(" - "); dto.setStartTime(split[0]); dto.setEndTime(split[1]); } if (StringUtils.hasLength(dto.getEndTime())){ dto.setType(2); String[] split = dto.getStartTime().split(" - "); dto.setStartTime(split[0]); dto.setEndTime(split[1]); } PageInfo<TSettlementConfirm> pageInfo = new PageInfo<>(dto.getPageCurr(),dto.getPageSize()); List<TSettlementConfirm> list = tSettlementConfirmMapper.settlementList(pageInfo,dto); for (TSettlementConfirm tSettlementConfirm : list) { ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TSettlementConfirmMapper.xml
@@ -13,28 +13,22 @@ select t1.* from t_settlement_confirm t1 where 1=1 <if test="req.type != null "> and t1.type = #{req.type} </if> <if test="req.partnerId != null "> and t1.partnerId = #{req.partnerId} and t1.partner_id = #{req.partnerId} </if> <if test="req.siteIds != null "> and t1.site_id = #{req.siteIds} </if> <if test="req.type == 1 "> <if test="req.startTime != null and req.startTime!=''"> and (t1.start_time between #{req.startTime} and #{req.endTime} </if> </if> <if test="req.siteIds != null and req.siteIds.size() > 0"> AND t1.site_id IN <foreach collection="req.siteIds" item="siteId" open="(" separator="," close=")"> #{siteId} </foreach> </if> <if test="req.type == 2 "> <if test="req.startTime != null and req.startTime!=''"> and (t1.end_time between #{req.startTime} and #{req.endTime} </if> </if> and t1.del_flag = 0 and t1.del_flag = 0 </select> </mapper>