server/src/main/java/doumeemes/dao/ext/dto/QueryWorkPlansDTO.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
server/src/main/resources/mappers/WorkPlansExtMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
server/src/main/java/doumeemes/dao/ext/dto/QueryWorkPlansDTO.java
@@ -47,4 +47,13 @@ @ApiModelProperty(value = "成品计划主键", hidden = true) private Integer workPlanId; @ApiModelProperty(value = "销售单号") private String salesorder; @ApiModelProperty(value = "计划开始时间 开始" ) private String startDateStart; @ApiModelProperty(value = "计划开始时间 结束") private String startDateEnd; } server/src/main/resources/mappers/WorkPlansExtMapper.xml
@@ -151,6 +151,15 @@ </if> <if test="batch != null and batch != ''"> AND `a`.`batch` like concat('%',#{batch},'%') </if> <if test="salesorder != null and salesorder != ''"> AND `a`.`SALESORDER` like concat('%',#{salesorder},'%') </if> <if test="startDateStart != null and startDateStart != ''"> AND `a`.`START_DATE` >= concat(#{planDateStart},' 00:00:00') </if> <if test="startDateEnd != null and startDateEnd != ''"> AND concat(#{planDateEnd},' 23:59:59') >= `a`.`START_DATE` </if> <if test="planDateStart != null and planDateStart != ''"> AND `a`.`PLAN_DATE` >= concat(#{planDateStart},' 00:00:00')