java110-bean/src/main/java/com/java110/dto/workPoolFile/WorkPoolFileDto.java
@@ -20,7 +20,6 @@ public static final String FILE_TYPE_END = "E"; //文件类型,S 工作单附件，J 任务图片 E 任务附件 private String pathUrl; private String communityId; private String storeId; @@ -30,6 +29,7 @@ private String fileType; private String staffName; private String staffNameLike; private Date createTime; @@ -117,4 +117,12 @@ public void setStaffName(String staffName) { this.staffName = staffName; } public String getStaffNameLike() { return staffNameLike; } public void setStaffNameLike(String staffNameLike) { this.staffNameLike = staffNameLike; } } java110-db/src/main/resources/mapper/oa/WorkPoolFileV1ServiceDaoImplMapper.xml
@@ -47,6 +47,9 @@ <if test="fileType !=null and fileType != ''"> and t.file_type= #{fileType} </if> <if test="staffNameLike !=null and staffNameLike != ''"> and wt.staff_name like concat('%', #{staffNameLike},'%') </if> order by t.create_time desc <if test="page != -1 and page != null "> limit #{page}, #{row} @@ -118,6 +121,9 @@ <if test="fileType !=null and fileType != ''"> and t.file_type= #{fileType} </if> <if test="staffNameLike !=null and staffNameLike != ''"> and wt.staff_name like concat('%', #{staffNameLike},'%') </if> </select>
