取得品牌列表.md
39 additions, 48 deletions
| ... | ... | @@ -1,16 +1,17 @@ |
| 1 | - 查詢品牌館資訊列表,支援分頁及篩選功能。可依品牌館名稱、品牌館代號進行查詢,並支援排序功能。 | |
| 1 | + 取得品牌館列表 (Union List) | |
| 2 | +* `DBMT.T_INTG_BRAND` | |
| 2 | - * PATH: `/api/features/mission-board/brand` | |
| 3 | + * PATH: `/api/features/mission-board/brand/union-list` | |
| 3 | -| Name | Type/Len | Required(*) | Desc | | |
| 4 | -| ---| ---| ---| --- | | |
| 5 | -| seq_no | Integer | | 序號 | | |
| 6 | -| brand_id | String | | 品牌館代號 (精準搜尋) | | |
| 7 | - | brand_name | String | | 品牌館名稱 (模糊搜尋) | | |
| 4 | + None | |
| 8 | - GET /api/features/mission-board/brand?brand_name=星巴克 | |
| 5 | + GET /api/features/mission-board/brand/union-list | |
| 9 | -| 3 | seq_no | Integer | | 序號 | `T_BAS_BRAND_INFO.SEQ_NO` | | |
| 10 | -| 3 | brand_id | String | | 品牌館代號 | `T_BAS_BRAND_INFO.BRAND_ID` | | |
| 11 | -| 3 | brand_name | String | | 品牌館名稱 | `T_BAS_BRAND_INFO.BRAND_NAME` | | |
| 12 | -| 3 | brand_pic | String | | 品牌館圖片 | `T_BAS_BRAND_INFO.BRAND_PIC` | | |
| 13 | -| 3 | brand_order | Integer | * | 品牌館排序 | `T_BAS_BRAND_INFO.BRAND_ORDER` | | |
| 14 | -| 3 | create_id | String | * | 建立者 | `T_BAS_BRAND_INFO.CREATE_ID` | | |
| 15 | -| 3 | create_time | Datetime | * | 建立時間 | `T_BAS_BRAND_INFO.CREATE_TIME` | | |
| 16 | -| 3 | update_id | String | * | 更新者 | `T_BAS_BRAND_INFO.UPDATE_ID` | | |
| 17 | -| 3 | update_time | Datetime | * | 更新時間 | `T_BAS_BRAND_INFO.UPDATE_TIME` | | |
| 18 | - | 3 | version | Integer | | 版本 | `T_BAS_BRAND_INFO.VERSION` | | |
| 6 | + | 3 | brand_name | String | | 品牌館名稱 | `T_BAS_BRAND_INFO.BRAND_NAME` / `T_INTG_BRAND.NAME` | | |
| 7 | +| 3 | data | List | | 來源資料 | | | |
| 8 | +#### data (inside items) | |
| 9 | + | |
| 10 | +| Level | Name | Type/Len | Nullable(*) | Desc | Source | | |
| 11 | +| ---| ---| ---| ---| ---| --- | | |
| 12 | +| 4 | table | String | | 來源資料表 | | | |
| 13 | +| 4 | pk | Integer | | Primary Key | `T_BAS_BRAND_INFO.SEQ_NO` / `T_INTG_BRAND.SEQ_ID` | | |
| 14 | + | |
| 19 | 15 | "data": { |
| 20 | 16 | "items": [ |
| 21 | 17 | { |
| 22 | - "seq_no": 1, | |
| 23 | - "brand_id": "STARBUCKS", | |
| 24 | - "brand_name": "星巴克咖啡", | |
| 25 | - "brand_pic": "starbucks_logo.png", | |
| 26 | - "brand_order": 1, | |
| 27 | - "create_id": "admin", | |
| 28 | - "create_time": "2024/01/15 10:30:00", | |
| 29 | - "update_id": "admin", | |
| 30 | - "update_time": "2024/06/20 14:25:00", | |
| 31 | - "version": 2 | |
| 18 | + "brand_name": "星巴克", | |
| 19 | + "data": [ | |
| 20 | + { | |
| 21 | + "table": "t_bas_brand_info", | |
| 22 | + "pk": 1 | |
| 32 | 23 | }, |
| 33 | 24 | { |
| 34 | - "seq_no": 2, | |
| 35 | - "brand_id": "MCDONALD", | |
| 36 | - "brand_name": "麥當勞", | |
| 37 | - "brand_pic": "mcdonalds_logo.png", | |
| 38 | - "brand_order": 2, | |
| 39 | - "create_id": "admin", | |
| 40 | - "create_time": "2024/01/15 11:00:00", | |
| 41 | - "update_id": null, | |
| 42 | - "update_time": null, | |
| 43 | - "version": 0 | |
| 25 | + "table": "t_intg_brand", | |
| 26 | + "pk": 101 | |
| 27 | + } | |
| 28 | + ] | |
| 44 | 29 | }, |
| 45 | 30 | { |
| 46 | - "seq_no": 3, | |
| 47 | - "brand_id": "UNIQLO", | |
| 48 | - "brand_name": "UNIQLO", | |
| 49 | - "brand_pic": "uniqlo_logo.png", | |
| 50 | - "brand_order": 3, | |
| 51 | - "create_id": "admin", | |
| 52 | - "create_time": "2024/01/16 09:15:00", | |
| 53 | - "update_id": "editor", | |
| 54 | - "update_time": "2024/05/10 16:45:00", | |
| 55 | - "version": 1 | |
| 31 | + "brand_name": "7-11", | |
| 32 | + "data": [ | |
| 33 | + { | |
| 34 | + "table": "t_bas_brand_info", | |
| 35 | + "pk": 2 | |
| 36 | + }, | |
| 37 | + ] | |
| 38 | + }, | |
| 39 | + { | |
| 40 | + "brand_name": "FamilyMart", | |
| 41 | + "data": [ | |
| 42 | + { | |
| 43 | + "table": "t_intg_brand", | |
| 44 | + "pk": 99 | |
| 56 | 45 | } |
| 46 | + ] | |
| 47 | + }, | |
| 57 | 48 | ] |
| 58 | 49 | } |