From e3bac98f092a10c0e897143bece3abbcc59469f2 Mon Sep 17 00:00:00 2001 From: cjl <276999030@qq.com> Date: Fri, 27 Oct 2023 10:06:24 +0800 Subject: [PATCH] fix:小程序提交 --- screen-api/src/main/java/com/moral/api/exception/consumer/SecondDataConsumer.java | 2 screen-api/src/main/java/com/moral/api/mapper/AllocationMapper.java | 4 screen-api/src/main/java/com/moral/api/service/impl/UserServiceImpl.java | 11 + screen-api/src/main/java/com/moral/api/service/AllocationService.java | 11 + screen-api/src/main/java/com/moral/api/pojo/ext/allocation/AllocationPageExt.java | 4 screen-api/src/main/java/com/moral/api/pojo/query/app/AppAllocationFileCond.java | 31 +++++ screen-api/src/main/java/com/moral/api/pojo/vo/app/AppAllocationFindVo.java | 94 +++++++++++++++ screen-api/src/main/java/com/moral/api/service/impl/AllocationServiceImpl.java | 70 +++++++++++ screen-api/src/main/java/com/moral/api/pojo/query/app/AppAllocationPageCond.java | 42 +++++++ screen-api/src/main/java/com/moral/api/exception/consumer/CruiserDataConsumer.java | 2 screen-api/src/main/java/com/moral/api/controller/AppAllocationController.java | 32 +++++ screen-api/src/main/java/com/moral/api/controller/AppUserController.java | 2 screen-api/src/main/java/com/moral/api/pojo/enums/FileTableEnum.java | 5 screen-api/src/main/resources/application-qa.yml | 2 screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java | 5 screen-api/src/main/resources/mapper/AllocationMapper.xml | 31 +++++ 16 files changed, 341 insertions(+), 7 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/controller/AppAllocationController.java b/screen-api/src/main/java/com/moral/api/controller/AppAllocationController.java index 02165ba..c75a0e4 100644 --- a/screen-api/src/main/java/com/moral/api/controller/AppAllocationController.java +++ b/screen-api/src/main/java/com/moral/api/controller/AppAllocationController.java @@ -1,6 +1,16 @@ package com.moral.api.controller; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.google.common.collect.Lists; +import com.moral.api.pojo.enums.AllocationApproveEnum; +import com.moral.api.pojo.enums.AppAllocationStateEnum; +import com.moral.api.pojo.ext.allocation.AllocationPageExt; +import com.moral.api.pojo.query.app.AppAllocationFileCond; +import com.moral.api.pojo.query.app.AppAllocationPageCond; +import com.moral.api.pojo.vo.allocation.AllocationPageVo; +import com.moral.api.pojo.vo.app.AppAllocationFindVo; +import com.moral.constant.PageResult; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import io.swagger.annotations.ApiParam; @@ -13,6 +23,8 @@ import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; +import java.util.Arrays; +import java.util.Collections; import java.util.List; import javax.validation.Valid; @@ -44,6 +56,26 @@ return ResultMessage.ok(ObjectUtils.isEmpty(allocationFindVos)? "0":allocationFindVos); } + @PostMapping("/page") + @ApiOperation("���������������������") + public ResultMessage<PageResult<AppAllocationFindVo>> page(@Valid @RequestBody AppAllocationPageCond allocationPageCond){ + Page<AllocationPageExt> allocationFindVos = allocationService.pageApp(allocationPageCond); + PageResult<AppAllocationFindVo> result = new PageResult<>(allocationFindVos); + result.setList(AppAllocationFindVo.convert(allocationFindVos.getRecords())); + return ResultMessage.ok(result); + } + + public static void main(String[] args) { + List<String> list = Arrays.asList("aaa", "bbb","aaa"); + System.out.println("num;" + Collections.frequency(list, "aaa")); + } + + @PostMapping("appFile") + @ApiOperation("������������������or������") + public ResultMessage appFile(@Valid @RequestBody AppAllocationFileCond appAllocationFileCond){ + allocationService.saveFile(appAllocationFileCond); + return ResultMessage.ok(); + } @PostMapping("changeRoutine") @ApiOperation("���������������") diff --git a/screen-api/src/main/java/com/moral/api/controller/AppUserController.java b/screen-api/src/main/java/com/moral/api/controller/AppUserController.java index ffe52c1..0b70e52 100644 --- a/screen-api/src/main/java/com/moral/api/controller/AppUserController.java +++ b/screen-api/src/main/java/com/moral/api/controller/AppUserController.java @@ -55,7 +55,7 @@ } @GetMapping("/wx/exit") - @ApiOperation(value = "���������������") + @ApiOperation(value = "���������������") public ResultMessage updateUserId(@RequestParam @ApiParam(value = "userId",name = "������������") Integer userId) { userService.updateUserId(userId); return ResultMessage.ok(); diff --git a/screen-api/src/main/java/com/moral/api/exception/consumer/CruiserDataConsumer.java b/screen-api/src/main/java/com/moral/api/exception/consumer/CruiserDataConsumer.java index 8ebcc3d..4cd66bc 100644 --- a/screen-api/src/main/java/com/moral/api/exception/consumer/CruiserDataConsumer.java +++ b/screen-api/src/main/java/com/moral/api/exception/consumer/CruiserDataConsumer.java @@ -34,7 +34,7 @@ -@Component +/*@Component*/ @Slf4j public class CruiserDataConsumer implements ConsumerSeekAware { diff --git a/screen-api/src/main/java/com/moral/api/exception/consumer/SecondDataConsumer.java b/screen-api/src/main/java/com/moral/api/exception/consumer/SecondDataConsumer.java index 4882e3d..929dfff 100644 --- a/screen-api/src/main/java/com/moral/api/exception/consumer/SecondDataConsumer.java +++ b/screen-api/src/main/java/com/moral/api/exception/consumer/SecondDataConsumer.java @@ -35,7 +35,7 @@ -@Component +/*@Component*/ @Slf4j public class SecondDataConsumer implements ConsumerSeekAware { diff --git a/screen-api/src/main/java/com/moral/api/mapper/AllocationMapper.java b/screen-api/src/main/java/com/moral/api/mapper/AllocationMapper.java index 93544d2..51d6ef6 100644 --- a/screen-api/src/main/java/com/moral/api/mapper/AllocationMapper.java +++ b/screen-api/src/main/java/com/moral/api/mapper/AllocationMapper.java @@ -8,6 +8,7 @@ import com.moral.api.pojo.ext.allocation.AllocationPageExt; import com.moral.api.pojo.query.allocation.AllocationListCond; import com.moral.api.pojo.query.allocation.AllocationPageCond; +import com.moral.api.pojo.query.app.AppAllocationPageCond; import com.moral.api.pojo.vo.allocation.AllocationFindVo; import org.apache.ibatis.annotations.Param; @@ -25,6 +26,9 @@ Page<AllocationPageExt> extPage(Page page, @Param("allocation") AllocationPageCond allocationPageCond); + + Page<AllocationPageExt> extAppPage(Page page, @Param("allocation") AppAllocationPageCond allocationPageCond); + /** * ������������������ * @param allocationListCond diff --git a/screen-api/src/main/java/com/moral/api/pojo/enums/FileTableEnum.java b/screen-api/src/main/java/com/moral/api/pojo/enums/FileTableEnum.java index 7907409..ca9b0bf 100644 --- a/screen-api/src/main/java/com/moral/api/pojo/enums/FileTableEnum.java +++ b/screen-api/src/main/java/com/moral/api/pojo/enums/FileTableEnum.java @@ -37,6 +37,11 @@ */ ALLOCATION_EXTENSION(1251701, "������������"), + /** + * ��������������� + */ + APP_ALLOCATION(1202401, "app������"), + ; @EnumValue diff --git a/screen-api/src/main/java/com/moral/api/pojo/ext/allocation/AllocationPageExt.java b/screen-api/src/main/java/com/moral/api/pojo/ext/allocation/AllocationPageExt.java index ec7aec1..3b4b5d2 100644 --- a/screen-api/src/main/java/com/moral/api/pojo/ext/allocation/AllocationPageExt.java +++ b/screen-api/src/main/java/com/moral/api/pojo/ext/allocation/AllocationPageExt.java @@ -3,6 +3,7 @@ import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableId; import com.moral.api.entity.Allocation; +import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; import lombok.experimental.Accessors; @@ -23,4 +24,7 @@ private Integer applyState; private Integer isApprove; + + @ApiModelProperty(value = "������������") + private String stateName; } diff --git a/screen-api/src/main/java/com/moral/api/pojo/query/app/AppAllocationFileCond.java b/screen-api/src/main/java/com/moral/api/pojo/query/app/AppAllocationFileCond.java new file mode 100644 index 0000000..4cffdc9 --- /dev/null +++ b/screen-api/src/main/java/com/moral/api/pojo/query/app/AppAllocationFileCond.java @@ -0,0 +1,31 @@ +package com.moral.api.pojo.query.app; + +import com.moral.api.pojo.vo.file.FileVo; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.experimental.Accessors; + +import java.util.List; + +/** + * @ClassName AppAllocationFileCond + * @Description TODO + * @Author @cjl + * @Date 2023-10-26 10:48 + * @Version 1.0 + */ +@Data +@EqualsAndHashCode(callSuper = false) +@Accessors(chain = true) +@ApiModel(value="AppAllocationFileCond - App������������", description="AppAllocationFileCond - App������������") +public class AppAllocationFileCond { + + @ApiModelProperty(value = "������id") + private Integer userId; + + @ApiModelProperty(value = "������������") + private FileVo file; + +} diff --git a/screen-api/src/main/java/com/moral/api/pojo/query/app/AppAllocationPageCond.java b/screen-api/src/main/java/com/moral/api/pojo/query/app/AppAllocationPageCond.java new file mode 100644 index 0000000..945f699 --- /dev/null +++ b/screen-api/src/main/java/com/moral/api/pojo/query/app/AppAllocationPageCond.java @@ -0,0 +1,42 @@ +package com.moral.api.pojo.query.app; + +import com.moral.api.pojo.query.PageCond; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.experimental.Accessors; + +import java.util.List; + +/** + * @ClassName AppAllocationPageCond + * @Description TODO + * @Author @cjl + * @Date 2023-10-25 16:13 + * @Version 1.0 + */ +@Data +@EqualsAndHashCode(callSuper = false) +@Accessors(chain = true) +@ApiModel(value="AppAllocation - App������������������", description="AppAllocation - App������������������") +public class AppAllocationPageCond { + + @ApiModelProperty(value = "������,0������ 1������2���������������������") + private Integer state; + + @ApiModelProperty(value = "������������") + private String startTime; + + @ApiModelProperty(value = "������������") + private String endTime; + + @ApiModelProperty(value = "������������") + private PageCond page; + + @ApiModelProperty(value = "������list") + private List<Integer> stateList; + + @ApiModelProperty(value = "������list") + private List<Integer> unitList; +} diff --git a/screen-api/src/main/java/com/moral/api/pojo/vo/app/AppAllocationFindVo.java b/screen-api/src/main/java/com/moral/api/pojo/vo/app/AppAllocationFindVo.java new file mode 100644 index 0000000..b5fb539 --- /dev/null +++ b/screen-api/src/main/java/com/moral/api/pojo/vo/app/AppAllocationFindVo.java @@ -0,0 +1,94 @@ +package com.moral.api.pojo.vo.app; + +import com.fasterxml.jackson.annotation.JsonFormat; +import com.moral.api.pojo.enums.AllocationApproveEnum; +import com.moral.api.pojo.ext.allocation.AllocationPageExt; +import com.moral.api.pojo.vo.allocation.AllocationPageVo; +import com.moral.api.utils.BeanConverts; +import com.moral.util.DateUtils; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.experimental.Accessors; + +import java.util.Date; +import java.util.List; +import java.util.stream.Collectors; + +/** + * @ClassName AppAllocationFindVo + * @Description TODO + * @Author @cjl + * @Date 2023-10-26 10:28 + * @Version 1.0 + */ +@Data +@EqualsAndHashCode(callSuper = false) +@Accessors(chain = true) +@ApiModel(value="AppAllocation - ������VO������", description="AppAllocation - ������VO������") +public class AppAllocationFindVo { + + @ApiModelProperty(value = "������id") + private Integer allocationId; + + @ApiModelProperty(value = "������������") + private String allocationNum; + + @ApiModelProperty(value = "������������") + @JsonFormat(pattern="yyyy-MM-dd") + private Date escalationTime; + + @ApiModelProperty(value = "������������id") + private Integer unitId; + + @ApiModelProperty(value = "������������id") + private Integer polluteType; + + @ApiModelProperty(value = "������������id") + private Integer changeType; + @ApiModelProperty(value = "������������") + private String pollutePosition; + + @ApiModelProperty(value = "������������") + private Integer changeDay; + + @ApiModelProperty(value = "������������") + private Integer residueDay; + + @ApiModelProperty(value = "������������id") + private Integer escalationUnitId; + + @ApiModelProperty(value = "���������") + private String escalationName; + + @ApiModelProperty(value = "������������id") + private Integer investigationType; + + @ApiModelProperty(value = "������") + private Integer state; + + @ApiModelProperty(value = "������������") + private Integer isInvalid; + + @ApiModelProperty(value = "������������") + private String stateName; + + public Integer getResidueDay() { + int day = this.changeDay; + if(AllocationApproveEnum.UNDER_RECTIFICATION.value.equals(state)){ + Date date = new Date(); + int days = DateUtils.getDays(escalationTime, date); + return day-days; + } + return day; + } + public static AppAllocationFindVo convert(AllocationPageExt allocationPageExt) { + AppAllocationFindVo allocationPageVo = BeanConverts.convert(allocationPageExt, AppAllocationFindVo.class); + return allocationPageVo; + } + + public static List<AppAllocationFindVo> convert(List<AllocationPageExt> allocationPageExtList) { + return allocationPageExtList.stream().map(AppAllocationFindVo::convert).collect(Collectors.toList()); + } +} diff --git a/screen-api/src/main/java/com/moral/api/service/AllocationService.java b/screen-api/src/main/java/com/moral/api/service/AllocationService.java index 58f721f..f98f7e4 100644 --- a/screen-api/src/main/java/com/moral/api/service/AllocationService.java +++ b/screen-api/src/main/java/com/moral/api/service/AllocationService.java @@ -14,8 +14,11 @@ import com.moral.api.pojo.query.allocation.*; import com.moral.api.pojo.dto.allocation.AllocationUnitDto; import com.moral.api.pojo.query.allocationextension.AllocationExtensionAddCond; +import com.moral.api.pojo.query.app.AppAllocationFileCond; +import com.moral.api.pojo.query.app.AppAllocationPageCond; import com.moral.api.pojo.vo.allocation.AllocationFindVo; import com.moral.api.pojo.vo.allocation.AllocationPageVo; +import com.moral.api.pojo.vo.app.AppAllocationFindVo; public interface AllocationService extends IService<Allocation> { @@ -107,6 +110,14 @@ */ List<AllocationFindVo> selectSmallRoutine(Integer state,String startTime,String endTime); + /** + * ��������������� + * @param allocationPageCond + * @return + */ + Page<AllocationPageExt> pageApp(AppAllocationPageCond allocationPageCond); + + boolean saveFile(AppAllocationFileCond appAllocationFileCond); /** * ��������������� diff --git a/screen-api/src/main/java/com/moral/api/service/impl/AllocationServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/AllocationServiceImpl.java index 1dbffad..4d0afd5 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/AllocationServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/AllocationServiceImpl.java @@ -20,7 +20,10 @@ import com.moral.api.pojo.ext.allocation.AllocationPageExt; import com.moral.api.pojo.query.allocation.*; import com.moral.api.pojo.query.allocationextension.AllocationExtensionAddCond; +import com.moral.api.pojo.query.app.AppAllocationFileCond; +import com.moral.api.pojo.query.app.AppAllocationPageCond; import com.moral.api.pojo.vo.allocation.AllocationFindVo; +import com.moral.api.pojo.vo.app.AppAllocationFindVo; import com.moral.api.pojo.vo.user.QxUser; import com.moral.api.service.*; import com.moral.constant.Constants; @@ -687,6 +690,73 @@ return allocationFindVos; } + @Override + public Page<AllocationPageExt> pageApp(AppAllocationPageCond allocationPageCond) { + List<Integer> listUnit = unitResult(); + Integer integer = unitAreaCode(); + allocationPageCond.setUnitList(listUnit); + allocationPageCond.setStateList(stateAllocationList(allocationPageCond.getState(),integer)); + Page<AllocationPageExt> extAppPage = this.baseMapper.extAppPage(allocationPageCond.getPage().convertPage(),allocationPageCond); + extAppPage.getRecords().forEach(it->{ + Integer state = it.getState(); + if (state.equals(AllocationApproveEnum.DRAFT.value)||state.equals(AllocationApproveEnum.UNDER_RECTIFICATION.value)){ + if(integer==0||integer==1){ + it.setStateName(AppAllocationStateEnum.TO_BE_PROCESSED.name); + }else if(integer==2){ + it.setStateName(AppAllocationStateEnum.TO_BE_COMPLETED.name); + } + }else if(state.equals(AllocationApproveEnum.IN_APPROVAL.value)){ + if(integer==2||integer==1){ + it.setStateName(AppAllocationStateEnum.TO_BE_PROCESSED.name); + }else if(integer==0){ + it.setStateName(AppAllocationStateEnum.TO_BE_COMPLETED.name); + } + }else{ + it.setStateName(AppAllocationStateEnum.COMPLETED.name); + } + }); + + return extAppPage; + } + + @Override + @Transactional + public boolean saveFile(AppAllocationFileCond appAllocationFileCond) { + fileTableService.upDateResult(Arrays.asList(appAllocationFileCond.getFile()),appAllocationFileCond.getUserId(), FileTableEnum.APP_ALLOCATION.value); + return true; + } + + private List<Integer> stateAllocationList(Integer type, Integer integer){ + List<Integer> integerList = new ArrayList<>(); + // type 0 ������ 1������ 2��������� 3 ��������� + if(integer.equals(0)){ + if(type.equals(1)){ + integerList.add(AllocationApproveEnum.UNDER_RECTIFICATION.value); + integerList.add(AllocationApproveEnum.DRAFT.value); + }else if(type.equals(2)){ + integerList.add(AllocationApproveEnum.IN_APPROVAL.value); + } + }else if(integer.equals(2)){ + if(type.equals(1)){ + integerList.add(AllocationApproveEnum.IN_APPROVAL.value); + }else if(type.equals(2)){ + integerList.add(AllocationApproveEnum.UNDER_RECTIFICATION.value); + integerList.add(AllocationApproveEnum.DRAFT.value); + } + }else if(integer.equals(1)){ + if(type.equals(1)){ + integerList.add(AllocationApproveEnum.IN_APPROVAL.value); + integerList.add(AllocationApproveEnum.UNDER_RECTIFICATION.value); + integerList.add(AllocationApproveEnum.DRAFT.value); + } + } + if(type.equals(3)){ + integerList.add(AllocationApproveEnum.PASS.value); + integerList.add(AllocationApproveEnum.REFUSE.value); + } + return integerList; + } + /** * ��������������� * diff --git a/screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java index d6ceef5..e8204e2 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/SpecialDeviceServiceImpl.java @@ -110,9 +110,10 @@ orgIds.add(orgId); integerList.addAll(orgIds); QueryWrapper<SpecialDeviceHistory> queryWrapper = new QueryWrapper<>(); - queryWrapper.select("mac", "name") + queryWrapper.select("DISTINCT mac, name").lambda(); + //.eq("special_type", Constants.SPECIAL_DEVICE_CRUISER) - .eq("is_delete", Constants.NOT_DELETE) + queryWrapper.eq("is_delete", Constants.NOT_DELETE) .in("organization_id", integerList); return specialDeviceHistoryService.listMaps(queryWrapper); } diff --git a/screen-api/src/main/java/com/moral/api/service/impl/UserServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/UserServiceImpl.java index fc63bce..4ef1f94 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/UserServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/UserServiceImpl.java @@ -11,6 +11,9 @@ import com.moral.api.entity.*; import com.moral.api.mapper.*; import com.moral.api.pojo.bo.UserBO; +import com.moral.api.pojo.enums.FileTableEnum; +import com.moral.api.pojo.vo.file.FileVo; +import com.moral.api.service.FileTableService; import com.moral.api.service.UserService; import com.moral.api.utils.OperationLogUtils; import com.moral.api.utils.WechatUtils; @@ -18,6 +21,7 @@ import com.moral.constant.ResponseCodeEnum; import com.moral.util.*; import lombok.extern.slf4j.Slf4j; +import org.apache.commons.collections4.CollectionUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; @@ -53,6 +57,9 @@ @Autowired private UserLogMapper userLogMapper; + + @Autowired + private FileTableService fileTableService; @Autowired private OperationLogUtils operationLogUtils; @@ -115,6 +122,8 @@ result.put("unitId",userBo.getUnitId()); result.put("userId", userBo.getId()); result.put("account", userBo.getAccount()); + List<FileVo> listFile = fileTableService.list(userBo.getId(), FileTableEnum.APP_ALLOCATION.value); + result.put("file", CollectionUtils.isNotEmpty(listFile)?listFile.get(0):new FileVo()); result.put("unName",Objects.nonNull(responsibilityUnit)&&Objects.nonNull(responsibilityUnit.getAreaName())?responsibilityUnit.getAreaName():"���������������������"); } catch (Exception e) { log.error("token���������������" + e.getMessage()); @@ -183,6 +192,8 @@ result.put("token", token); result.put("userName", user.getUserName()); result.put("unitId",user.getUnitId()); + List<FileVo> listFile = fileTableService.list(user.getId(), FileTableEnum.APP_ALLOCATION.value); + result.put("file", CollectionUtils.isNotEmpty(listFile)?listFile.get(0):new FileVo()); result.put("userId", user.getId()); result.put("account", user.getAccount()); result.put("unName",Objects.nonNull(responsibilityUnit)&&Objects.nonNull(responsibilityUnit.getAreaName())?responsibilityUnit.getAreaName():"���������������������"); diff --git a/screen-api/src/main/resources/application-qa.yml b/screen-api/src/main/resources/application-qa.yml index 3cbbba3..f9dde1a 100644 --- a/screen-api/src/main/resources/application-qa.yml +++ b/screen-api/src/main/resources/application-qa.yml @@ -141,4 +141,4 @@ foh3wi2ooghiCh5 file: - path: E:/upload \ No newline at end of file + path: /data/upload/ \ No newline at end of file diff --git a/screen-api/src/main/resources/mapper/AllocationMapper.xml b/screen-api/src/main/resources/mapper/AllocationMapper.xml index 4b9159b..6460447 100644 --- a/screen-api/src/main/resources/mapper/AllocationMapper.xml +++ b/screen-api/src/main/resources/mapper/AllocationMapper.xml @@ -95,7 +95,7 @@ and allocation.allocation_num LIKE CONCAT('%',#{allocation.allocationNum},'%') </if> <if test="allocation.unitList != null and allocation.unitList.size !=0"> - and allocation.unit_id in + and allocation.state in <foreach collection="allocation.unitList" item="id" index="index" open="(" close=")" separator=","> #{id} </foreach> @@ -104,4 +104,33 @@ </where> order by allocation.escalation_time desc,allocation.allocation_id desc </select> + + <select id="extAppPage" resultType="com.moral.api.pojo.ext.allocation.AllocationPageExt"> + SELECT + <include refid="Allocation_Column_List"/> + FROM allocation allocation + <where> + 1 = 1 and allocation.is_del = 0 + <if test="allocation.startTime != null and allocation.startTime != '' "> + and date(allocation.escalation_time) <![CDATA[>=]]> #{allocation.startTime} + </if> + <if test="allocation.endTime != null and allocation.endTime !='' "> + and date(allocation.escalation_time) <![CDATA[<=]]> #{allocation.endTime} + </if> + <if test="allocation.stateList != null and allocation.stateList.size !=0"> + and allocation.state in + <foreach collection="allocation.stateList" item="id" index="index" open="(" close=")" separator=","> + #{id} + </foreach> + + </if> + <if test="allocation.unitList != null and allocation.unitList.size !=0"> + and allocation.unit_id in + <foreach collection="allocation.unitList" item="id" index="index" open="(" close=")" separator=","> + #{id} + </foreach> + </if> + </where> + order by allocation.escalation_time desc,allocation.allocation_id desc + </select> </mapper> -- Gitblit v1.8.0