2024.7.0b7

• Cleanup mqtt platform tests part 4 (init) (@jbouwh - #120574)
• Split mqtt client tests (@jbouwh - #120636)
• Fix publish cancellation handling in MQTT (@bdraco - #120826)
• Add handling for different STATFLAG formats in APCUPSD (@yuxincs - #120870)
• Bump aioautomower to 2024.6.4 (@Thomas55555 - #120875)
• Fix Shelly device shutdown (@thecode - #120881)
• Bump ical to 8.1.1 (@allenporter - #120888)
• Add missing translations for device class in Scrape (@dougiteixeira - #120891)
• Add missing translations for device class in SQL (@dougiteixeira - #120892)
• Add missing translations for device class in Template (@dougiteixeira - #120893)
• Improve add user error messages (@edenhaus - #120909)
• Bump incomfort-client dependency to 0.6.3 (@jbouwh - #120913)
• Bump openai to 1.35.1 (@balloob - #120926)
• Mark dry/fan-only climate modes as supported for Panasonic room air conditioner (@marcelveldt - #120939)
• Bump python-kasa to 0.7.0.2 (@sdb9696 - #120940)
• Downgrade logging previously reported asyncio block to debug (@bdraco - #120942)
• Fix Bang & Olufsen jumping volume bar (@mj23000 - #120946