update

liujie

2026-08-14 92a75a7b157e6fd6423df17cfd32015017bdb8c9

 backend/src/main/java/com/tourguide/modules/user/mapper/GuideUserMapper.java

@@ -15,7 +15,8 @@

    @Update("UPDATE guide_user SET status = 0, updated_at = NOW() " +
            "WHERE id = #{guideId} AND deleted = 0 AND status = 1 " +
            "AND auto_disable_whitelisted = 0 AND accepted_order_count >= #{orderThreshold} " +
            "AND COALESCE(auto_disable_whitelisted, 0) = 0 " +
            "AND accepted_order_count >= #{orderThreshold} " +
            "AND rating > 0 AND rating <= #{ratingThreshold}")
    int autoDisableIfEligible(@Param("guideId") Long guideId,
                              @Param("orderThreshold") Integer orderThreshold,