◉ClassyGitshadowzzh

categories.rs

categories.rs
use axum::{
    Json,
    extract::{Query, State},
};
use serde::{Deserialize, Serialize};
use sqlx::FromRow;

use crate::{error::AppError, state::AppState};

/// `GET /api/categories` 單列。欄位順序對齊 Express SELECT。
#[derive(Debug, Serialize, FromRow, utoipa::ToSchema, specta::Type)]
pub struct CategoryRow {
    #[specta(type = specta_typescript::Number)]
    pub id: i64,
    pub name: String,
    pub slug: String,
    pub description: Option<String>,
    pub short_description: Option<String>,
    pub updated_at: Option<String>,
    #[specta(type = specta_typescript::Number)]
    pub post_count: i64,
    /// 顯示用譯名(name 仍是資料鍵)。沒填就由前端 fallback 回 name。
    pub name_en: Option<String>,
    pub name_ja: Option<String>,
    pub name_ko: Option<String>,
    pub name_zh_cn: Option<String>,
    /// 描述的譯文(tooltip 用)。
    pub description_en: Option<String>,
    pub description_ja: Option<String>,
    pub description_ko: Option<String>,
    pub description_zh_cn: Option<String>,
    pub short_description_en: Option<String>,
    pub short_description_ja: Option<String>,
    pub short_description_ko: Option<String>,
    pub short_description_zh_cn: Option<String>,
}

#[derive(Debug, Serialize, utoipa::ToSchema, specta::Type)]
pub struct CategoriesResponse {
    pub message: &'static str,
    pub categories: Vec<CategoryRow>,
}

#[derive(Debug, Deserialize, utoipa::IntoParams)]
pub struct CategoriesQuery {
    /// 只計入有該語系內容的文章(同 `/api/posts?lang=`)。省略=計入全部。
    pub lang: Option<String>,
}

/// `GET /api/categories` —— 公開純讀。SQL 逐字照抄 Express,另加 `?lang=` 的語系過濾。
#[utoipa::path(get, path = "/api/categories", tag = "categories",
    params(CategoriesQuery),
    responses((status = 200, body = CategoriesResponse)))]
pub async fn list_categories(
    State(state): State<AppState>,
    Query(q): Query<CategoriesQuery>,
) -> Result<Json<CategoriesResponse>, AppError> {
    // `/api/posts?lang=` 會濾掉沒該語系譯文的文章,這裡的 post_count 若不跟著濾,側欄就會
    // 出現「歲月留痕 4」點進去卻是空的。條件放在 LEFT JOIN 的 ON 而**不是** WHERE:放
    // WHERE 會把該語系 0 篇的分類整列打掉(LEFT JOIN 退化成 INNER),前端就拿不到那筆
    // 分類資料;放 ON 則會照樣回該列、post_count = 0,由前端的 `post_count > 0` 隱藏。
    let locale_cond = crate::handlers::posts::parse_locale(q.lang.as_deref())
        .map(|loc| format!(" AND {}", crate::handlers::posts::locale_available_sql(loc, "p")))
        .unwrap_or_default();
    let sql = format!(
        r"
        SELECT
          c.id,
          c.name,
          c.slug,
          c.description,
          c.short_description,
          c.updated_at,
          COUNT(p.id) as post_count,
          c.name_en, c.name_ja, c.name_ko, c.name_zh_cn,
          c.description_en, c.description_ja, c.description_ko, c.description_zh_cn, c.short_description_en, c.short_description_ja, c.short_description_ko, c.short_description_zh_cn
        FROM categories c
        LEFT JOIN posts p ON p.category = c.name AND p.status = 'published'{locale_cond}
        GROUP BY c.id, c.name, c.slug, c.description, c.short_description, c.updated_at,
                 c.name_en, c.name_ja, c.name_ko, c.name_zh_cn,
                 c.description_en, c.description_ja, c.description_ko, c.description_zh_cn, c.short_description_en, c.short_description_ja, c.short_description_ko, c.short_description_zh_cn
        ORDER BY post_count DESC, c.name ASC
        "
    );
    let categories =
        sqlx::query_as::<_, CategoryRow>(sqlx::AssertSqlSafe(sql.as_str())).fetch_all(&state.pool).await?;

    Ok(Json(CategoriesResponse { message: "success", categories }))
}