12.18

luodangjia

2025-01-16 11e816191b0319ce93262232eee01e45a8471a02

12.18

 ruoyi-service/ruoyi-other/src/main/resources/mapper/other/TechnicianSubscribeMapper.xml

@@ -76,7 +76,8 @@
        CASE
        WHEN tts.subscribe_time <![CDATA[<]]> NOW()  THEN 3
        ELSE tts.status
        END AS status
        END AS status,
        tts.create_time
        FROM
            t_technician_subscribe tts
                LEFT JOIN t_technician tt ON tts.technician_id = tt.id
@@ -92,6 +93,8 @@
               o.status = #{status}
           </if>
        </where>
        ORDER BY
        create_time DESC

    </select>
</mapper>