排序

16639036659

2023-10-27 ff44d8a4668db7c7b110f103bd3a3cc34086698d

排序

 src/main/resources/mybatis/tr/HiddenDangerCheckPointMapper.xml

@@ -109,7 +109,7 @@
    </resultMap>

    <sql id="selectHiddenDangerCheckPointVo">
        select a.id,a.check_point_id,a.check_id, a.create_by, a.create_time, a.update_by, a.update_time,a.remark,
        select a.id,a.check_point_id,a.check_id, a.create_by, a.create_time, a.update_by, a.update_time,a.remark,a.accept_status,
        c.plan_create_user_id,
        c.plan_name, c.troubleshoot_type_id,
        c.troubleshoot_type_name, c.organization_dept_id,
@@ -343,6 +343,8 @@

            <if test="rectifyUserIdIsNotNull != null  and rectifyUserIdIsNotNull != ''">and a.rectify_user_id is not null</if>

            <if test="acceptStatus != null  and acceptStatus != ''">and a.accept_status  = #{acceptStatus}</if>

            <if test="null != companyIdList  and companyIdList.size() > 0">
                and (a.company_id in
                <foreach collection="companyIdList" item="companyId" open="(" separator="," close=")">
@@ -350,7 +352,8 @@
                </foreach>)
            </if>
        </where>
        order by a.create_time desc
<!--     todo 查找验收条件，将待验收的放在前面-->
        order by a.accept_status, a.create_time desc
    </select>

    <select id="selectHiddenDangerCheckPointById" parameterType="Long" resultMap="HiddenDangerCheckPointResult">