BEGIN
    UPDATE users u
    JOIN drivers d ON u.id = d.user_id
    JOIN order_holds oh ON d.id = oh.driver_id
    SET u.wallet_balance = u.wallet_balance + oh.hold_amount
    WHERE oh.status = 'holding' 
      AND oh.claim_deadline <= NOW();

    INSERT INTO wallet_transactions (user_id, amount, type, status, reference_id, description)
    SELECT 
        d.user_id, 
        oh.hold_amount, 
        'refund', 
        'success', 
        CONCAT('RELEASE_HOLD_', oh.order_id), 
        'Ho??n ph?? t???m gi??? sau 3 ng??y kh??ng c?? khi???u n???i'
    FROM order_holds oh
    JOIN drivers d ON d.id = oh.driver_id
    WHERE oh.status = 'holding' 
      AND oh.claim_deadline <= NOW();

    UPDATE order_holds
    SET status = 'released', resolved_at = NOW()
    WHERE status = 'holding' 
      AND claim_deadline <= NOW();
END

BEGIN
    UPDATE drivers SET is_auto_accept = TRUE;

    INSERT INTO driver_daily_stats (
        driver_id, 
        stat_date, 
        auto_completed_count, 
        manual_completed_count, 
        total_completed_count, 
        is_auto_accept_locked
    )
    SELECT 
        id AS driver_id, 
        CURDATE() AS stat_date, 
        0, 0, 0, TRUE
    FROM drivers
    ON DUPLICATE KEY UPDATE 
        auto_completed_count = 0,
        manual_completed_count = 0,
        total_completed_count = 0,
        is_auto_accept_locked = TRUE;
END

BEGIN
    
    UPDATE driver_online_sessions
    SET last_active_at = CONCAT(session_date, ' 23:59:59'),
        current_session_start = NULL
    WHERE session_date < CURDATE() AND current_session_start IS NOT NULL;

    
    INSERT INTO driver_online_sessions (driver_id, session_date, first_online_time, last_active_at, current_session_start)
    SELECT id, CURDATE(), NOW(), NOW(), NOW()
    FROM drivers
    WHERE status IN ('online', 'busy')
    ON DUPLICATE KEY UPDATE last_active_at = NOW();
END