heheng
2025-11-14 c8be659bd7a8fd50be7dd5fd257d7966e63c1b03
功能修改
2 files modified
5 ■■■■■ changed files
multi-system/src/main/resources/mapper/system/MemoMapper.xml 3 ●●●● patch | view | raw | blame | history
multi-system/src/main/resources/mapper/system/SysNoticeMapper.xml 2 ●●● patch | view | raw | blame | history
multi-system/src/main/resources/mapper/system/MemoMapper.xml
@@ -42,9 +42,10 @@
                 INNER JOIN item b ON b.id = a.item_id
            AND b.del_flag = 1
                 INNER JOIN item_review_user c ON c.review_id = a.id
        inner join ex_student ex on ex.id = c.review_user_id
            AND c.del_flag = 0
        WHERE a.del_flag = 0
          AND c.review_user_id = #{userId}
        AND ex.user_id = #{userId}
          AND c.`status` = 2 and a.company_id = #{companyId}
        UNION ALL
        SELECT a.use_seal_cause AS title,
multi-system/src/main/resources/mapper/system/SysNoticeMapper.xml
@@ -51,7 +51,7 @@
            AND a.type = #{type}
        </if>
        <if test="deptId != null">
            AND a.deptId = #{dept_id}
            AND a.dept_id = #{deptId}
        </if>
        <if test="createBy != null and createBy != ''">
            AND a.create_by like concat('%', #{createBy}, '%')