| | |
| | | */ |
| | | @ApiModelProperty(value = "检查日期") |
| | | @TableField("reviewTime") |
| | | private String reviewtime; |
| | | private Date reviewtime; |
| | | /** |
| | | * 检查内容 |
| | | */ |
| | |
| | | |
| | | |
| | | <select id="selectCoinspectPage" resultMap="coinspectResultMap"> |
| | | select * from sys_coinspect where is_deleted = 0 |
| | | select * from sys_coinspect |
| | | </select> |
| | | |
| | | </mapper> |
| | |
| | | DirectiveFile directiveFile = new DirectiveFile(); |
| | | directiveFile.setType(1); |
| | | directiveFile.setDirectiveId(directive.getId()); |
| | | directiveFile.setUrl(urls); |
| | | directiveFile.setUrl(url); |
| | | status = directiveService.saveDirectiveFile(directiveFile); |
| | | String s2 = |
| | | "insert into sys_directive_file(id,type,directive_id,url) " + |
| | |
| | | |
| | | List<MultipartFile> fileList = new ArrayList<>(); |
| | | //获取图片文件 |
| | | fileList = fileUtil.getSubFiles(desPath+File.separator+namePath,fileList); |
| | | fileList = fileUtil.getSubFiles(desPath,fileList); |
| | | for (MultipartFile multipartFile : fileList){ |
| | | if(multipartFile.getName().toLowerCase().endsWith(".png") || multipartFile.getName().toLowerCase().endsWith(".jpg")) { |
| | | String newName = "upload/picture/" + UUID.randomUUID().toString().replaceAll("-", "") + multipartFile.getName().substring(multipartFile.getName().lastIndexOf(".")); |
| | |
| | | |
| | | <select id="selectSocialPage" resultMap="socialResultMap"> |
| | | SELECT |
| | | distinct u.id sid, |
| | | s.*, |
| | | distinct u.id, |
| | | u.real_name as realname |
| | | FROM |
| | | blade_user u |
| | |
| | | private static final long serialVersionUID = 1L; |
| | | private String realname; |
| | | |
| | | private Long sid; |
| | | |
| | | } |
| | |
| | | <if test="user.cardid!=null and user.cardid != ''"> |
| | | and bu.cardid like concat('%', #{user.cardid},'%') |
| | | </if> |
| | | <if test="user.examinationType!=null and user.examinationType != ''"> |
| | | <if test="user.examinationType==0"> |
| | | and (bu.examination_type = #{user.examinationType} or bu.examination_type is null or bu.examination_type="") |
| | | </if> |
| | | <if test="user.examinationType==1"> |
| | | and bu.examination_type = #{user.examinationType} |
| | | </if> |
| | | ORDER BY bu.id |
| | |
| | | SELECT id, name, real_name RealName |
| | | FROM blade_user |
| | | where cardid = #{param1} |
| | | and is_deleted = 0 |
| | | and status = 1 |
| | | </select> |
| | | |
| | | |