Qingpu 用户设置 API
本模块为 qingpu 主题提供了一套私有 PostgreSQL 用户设置配置桶。它按用户维度把工作台偏好统一收口到 qingpu_settings 表中,而不是继续往 APayShop 全局 settings 表里追加零散键值。
初始化步骤
- 配置
QINGPU_DATABASE_URL,或者直接复用DATABASE_URL。 - 执行
app/themes/qingpu/database/settings.sql中的建表 SQL。 - 通过
/api/qingpu/settings读写 Qingpu 通用配置。
存储约定
- 配置按
user_id隔离。 - 根 JSON 文档保存在
qingpu_settings.settings中。 - 当前的模型偏好保存在
listing.modelSettings下。 - 后续如果增加采集、发布或工作流相关偏好,也继续往同一个 JSON 配置桶里扩展,不再拆新的零散配置表。
1. 获取 Qingpu 基础设置
- 请求地址:
/api/qingpu/settings - 请求方法:
GET - 权限要求: 已登录用户或 Bearer 租户 Key
该通用地址只验证身份与租户隔离,不要求用户开通 Listing 功能。旧地址 /api/qingpu/listing/settings 保留用于兼容尚未升级的客户端,但仍位于 Listing 功能权限域内。
成功响应
{
"code": 0,
"persisted": true,
"data": {
"generalModelApiKey": "sk-live-xxxx",
"generalModelBaseUrl": "https://api.openai.com/v1",
"generalModelName": "gpt-4.1-mini",
"imageModelName": "gpt-image-1",
"imageGenSize": "1008x1344",
"imageGenQuality": "medium",
"imageProviderProfiles": [
{
"id": "imgp_demo",
"name": "高清竖图",
"model": "gpt-image-1",
"size": "1024x1536",
"quality": "high"
}
],
"activeImageProfileId": "imgp_demo",
"videoModelName": "veo-3-fast",
"videoGenQuality": "medium",
"translationModelName": "gpt-4.1-mini",
"offerIdPrefix": "QP",
"exchangeRate": 12.5,
"commissionRate": 0.15,
"freightCny": 5,
"domesticFeeCny": 2,
"profitRate": 0.2,
"oldPriceMarkupRate": 0.3,
"frontDiscountRate": 0.23076923076923075,
"priceRoundRule": "to9",
"storageFeeRub": 0,
"storageMonths": 1,
"adBudgetRub": 0,
"adRate": 0,
"otherRate": 0.03,
"returnRate": 0.05,
"translationGlossary": [
{ "source": "收纳盒", "target": "коробка для хранения" },
{ "source": "加厚", "target": "утолщенный" }
]
}
}
persisted=true表示当前用户已经在云端保存过这份配置。persisted=false表示当前接口返回的是服务端默认值,云端还没有真实保存记录。oldPriceMarkupRate是划线价相对售价的上浮比例,默认0.3,即售价100自动生成划线价130;frontDiscountRate是服务端为共享引擎派生的兼容字段,客户端不应直接修改。
2. 保存 Qingpu 基础设置
- 请求地址:
/api/qingpu/settings - 请求方法:
POST - 权限要求: 已登录用户或 Bearer 租户 Key
请求体
{
"generalModelApiKey": "sk-live-xxxx",
"generalModelBaseUrl": "https://api.openai.com/v1",
"generalModelName": "gpt-4.1-mini",
"imageModelName": "gpt-image-1",
"imageGenSize": "1008x1344",
"imageGenQuality": "high",
"imageProviderProfiles": [
{
"id": "imgp_demo",
"name": "高清竖图",
"model": "gpt-image-1",
"size": "1024x1536",
"quality": "high"
}
],
"activeImageProfileId": "imgp_demo",
"videoModelName": "veo-3-fast",
"videoGenQuality": "medium",
"translationModelName": "gpt-4.1-mini",
"offerIdPrefix": "QP",
"exchangeRate": 12.5,
"commissionRate": 0.15,
"freightCny": 5,
"domesticFeeCny": 2,
"profitRate": 0.2,
"oldPriceMarkupRate": 0.3,
"priceRoundRule": "to9",
"storageFeeRub": 0,
"storageMonths": 1,
"adBudgetRub": 0,
"adRate": 0,
"otherRate": 0.03,
"returnRate": 0.05,
"translationGlossary": [
{ "source": "收纳盒", "target": "коробка для хранения" },
{ "source": "加厚", "target": "утолщенный" }
]
}
成功响应
{
"code": 0,
"message": "Listing model settings saved successfully",
"data": {
"generalModelApiKey": "sk-live-xxxx",
"generalModelBaseUrl": "https://api.openai.com/v1",
"generalModelName": "gpt-4.1-mini",
"imageModelName": "gpt-image-1",
"imageGenSize": "1008x1344",
"imageGenQuality": "high",
"imageProviderProfiles": [
{
"id": "imgp_demo",
"name": "高清竖图",
"model": "gpt-image-1",
"size": "1024x1536",
"quality": "high"
}
],
"activeImageProfileId": "imgp_demo",
"videoModelName": "veo-3-fast",
"videoGenQuality": "medium",
"translationModelName": "gpt-4.1-mini",
"offerIdPrefix": "QP",
"exchangeRate": 12.5,
"commissionRate": 0.15,
"freightCny": 5,
"domesticFeeCny": 2,
"profitRate": 0.2,
"oldPriceMarkupRate": 0.3,
"frontDiscountRate": 0.23076923076923075,
"priceRoundRule": "to9",
"storageFeeRub": 0,
"storageMonths": 1,
"adBudgetRub": 0,
"adRate": 0,
"otherRate": 0.03,
"returnRate": 0.05,
"translationGlossary": [
{ "source": "收纳盒", "target": "коробка для хранения" },
{ "source": "加厚", "target": "утолщенный" }
]
}
}
说明
imageGenSize支持:auto、1008x1344、1024x1536、768x1024、1024x1024、1536x1024imageGenQuality与videoGenQuality支持:auto、low、medium、highimageProviderProfiles为可选字段,用于保存可复用的图片方案;activeImageProfileId指向当前启用的方案offerIdPrefix、exchangeRate、commissionRate等字段为铺货工作台默认定价参数,供 Dash 与官网设置页共用translationGlossary为用户手工维护的固定术语表;它与本地运行期translationMemory缓存分开存储- 模型名称允许留空,表示后续工作流可回退到通用模型或系统默认模型