a.ID AS "id", a.TYPE AS "type", a.TITLE AS "title", a.CONTENT AS "content", a.FILES AS "files", a.STATUS AS "status", a.CREATE_BY AS "createBy.id", a.CREATE_DATE AS "createDate", a.UPDATE_BY AS "updateBy.id", a.UPDATE_DATE AS "updateDate", a.REMARKS AS "remarks", a.DEL_FLAG AS "delFlag", u.name AS "createBy.name" LEFT JOIN jeesite_sys_user u on u.id = a.create_by SELECT FROM jeesite_oa_notify a WHERE a.id = #{id} SELECT FROM jeesite_oa_notify a WHERE a.del_flag = #{DEL_FLAG_NORMAL} AND a.TITLE LIKE '%'||#{title}||'%' '%'+#{title}+'%' CONCAT('%', #{title}, '%') AND a.TYPE = #{type} AND a.STATUS = #{status} ORDER BY a.update_date DESC SELECT FROM jeesite_oa_notify a WHERE a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY a.update_date DESC SELECT count(1) FROM jeesite_oa_notify a WHERE a.del_flag = #{DEL_FLAG_NORMAL} AND a.TITLE LIKE '%'||#{title}||'%' '%'+#{title}+'%' CONCAT('%', #{title}, '%') AND a.TYPE = #{type} AND a.STATUS = #{status} INSERT INTO jeesite_oa_notify( ID, TYPE, TITLE, CONTENT, FILES, STATUS, CREATE_BY, CREATE_DATE, UPDATE_BY, UPDATE_DATE, REMARKS, DEL_FLAG ) VALUES ( #{id}, #{type}, #{title}, #{content}, #{files}, #{status}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE jeesite_oa_notify SET TYPE = #{type}, TITLE = #{title}, CONTENT = #{content}, FILES = #{files}, STATUS = #{status}, UPDATE_BY = #{updateBy.id}, UPDATE_DATE = #{updateDate}, REMARKS = #{remarks} WHERE id = #{id} UPDATE jeesite_oa_notify SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}