| | |
|---|
| | | </foreach>) |
|---|
| | | </if> |
|---|
| | | |
|---|
| | | <if test="checkUserName != null and checkUserName != ''"> and a.check_user_name like concat('%', #{checkUserName}, '%')</if> |
|---|
| | | <if test="beCheckedDeptId != null "> and a.be_checked_dept_id = #{beCheckedDeptId}</if> |
|---|
| | | <if test="beCheckedDeptName != null and beCheckedDeptName != ''"> and a.be_checked_dept_name like concat('%', #{beCheckedDeptName}, '%')</if> |
|---|
| | | <if test="checkBeginTime != null and checkBeginTime != ''"> and a.check_begin_time = #{checkBeginTime}</if> |
|---|
| | | <if test="checkEndTime != null and checkEndTime != ''"> and a.check_end_time = #{checkEndTime}</if> |
|---|
| | | |
|---|
| | | |
|---|
| | | <if test="checkBeginTime != null and checkBeginTime != ''"> AND a.create_time >= date_format(#{checkBeginTime},'%y%m%d') </if> |
|---|
| | | <if test="checkEndTime != null and checkEndTime != ''"> AND date_format(#{checkEndTime},'%y%m%d') >= a.create_time </if> |
|---|
| | | <if test="checkUserName != null and checkUserName != ''"> and a.update_by like concat('%', #{checkUserName}, '%')</if> |
|---|
| | | |
|---|
| | | |
|---|
| | | <if test="planFormulateStatus != null and planFormulateStatus != ''"> and a.plan_formulate_status = #{planFormulateStatus}</if> |
|---|
| | | <if test="planExecuteStatus != null and planExecuteStatus != ''"> and a.plan_execute_status = #{planExecuteStatus}</if> |
|---|
| | | <if test="checkStatus != null and checkStatus != ''"> and a.check_status = #{checkStatus}</if> |
|---|
