/**
 * 將 DB 中的媒體路徑轉成可從網站根目錄或絕對 URL 載入的地址。
 */
export function resolveMediaUrl(url: string | null | undefined): string {
    const raw = String(url ?? '').trim()
    if (!raw) return ''

    if (/^(https?:\/\/|data:|\/\/)/i.test(raw)) {
        return raw
    }

    let path = raw.replace(/\\/g, '/')
    if (path.startsWith('public/')) {
        path = path.slice('public/'.length)
    }
    path = path.replace(/^\/+/, '')

    return `/${path}`
}