| | |
| | | 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, |
| | |
| | | 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}, '%') |