mybatis自定义传参排序

注意事项:

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