注意事项:
1. <select id=“名字” 名字必须跟对应的mapper的方法名一致".参数类型也要一致!>
以下是对应的mapper方法名
<!--工单列表展示-->
<select id="getVirtualTaskDetailAndInfo" parameterType="map" resultType="map">
SELECT
t.id,
t.task_num,
t.apply_num,
t.province,
t.city,
t.`status`,
t.create_time,
t.enable_time,
t.end_time,
t.task_type,
p.attribution_number,
d.real_name
FROM
gkshop_virtual_task t
LEFT JOIN gkshop_virtual_phone p ON t.id = p.task_id
LEFT JOIN gkshop_phone_library l ON l.phone_number = p.attribution_number
LEFT JOIN gkshop_users_directories d ON d.`id` = l.`directories_id`
WHERE 1=1
<if test="taskStatus != null">
and t.`status` = #{taskStatus}
</if>
<if test="taskType != null">
AND t.task_type =#{taskType}
</if>
<if test="taskNum != null">
AND t.task_num = #{taskNu