| | |
| | | <if test="assessmentScore.scoreUserName != null and assessmentScore.scoreUserName != ''"> |
| | | and a.user_name like concat('%', #{assessmentScore.scoreUserName}, '%') |
| | | </if> |
| | | <if test="assessmentScore.deptName != null and assessmentScore.deptName != '' and assessmentScore.type != null and assessmentScore.type == 1"> |
| | | and d.dept_name like concat('%', #{assessmentScore.deptName}, '%') |
| | | </if> |
| | | <if test="assessmentScore.deptName != null and assessmentScore.deptName != '' and assessmentScore.type != null and assessmentScore.type == 0"> |
| | | and c.dept_name like concat('%', #{assessmentScore.deptName}, '%') |
| | | <if test="assessmentScore.deptName != null and assessmentScore.deptName != ''"> |
| | | and b.dept_name like concat('%', #{assessmentScore.deptName}, '%') |
| | | </if> |
| | | </where> |
| | | </select> |