alien_cloud/alien-second/doc/二手委托人.md

二手委托人信息管理接口测试文档

接口列表

1. 创建委托人信息

接口地址: POST /secondEntrustUser/create

请求参数:

{
  "entrustTradeId": 1,
  "entrustTradeNo": "TRADE202511210001",
  "entrustUserPhone": "13800138000",
  "entrustUserName": "张三",
  "entrustIdCard": "110101199001011234",
  "entrustIdCardImg": "https://example.com/id_card.jpg"
}

响应示例:

{
  "code": 200,
  "msg": "创建成功",
  "data": true
}

---

2. 根据交易ID获取委托人信息

接口地址: GET /secondEntrustUser/getByTradeId?entrustTradeId=1

响应示例:

{
  "code": 200,
  "msg": "操作成功",
  "data": {
    "id": 1,
    "entrustTradeId": 1,
    "entrustTradeNo": "TRADE202511210001",
    "entrustUserPhone": "13800138000",
    "entrustUserName": "张三",
    "entrustIdCard": "110101199001011234",
    "entrustIdCardImg": "https://example.com/id_card.jpg",
    "deleteFlag": 0,
    "createdTime": "2025-11-21 10:00:00",
    "createdUserId": 1,
    "updatedTime": "2025-11-21 10:00:00",
    "updatedUserId": 1
  }
}

---

3. 根据交易编号获取委托人信息

接口地址: GET /secondEntrustUser/getByTradeNo?entrustTradeNo=TRADE202511210001

响应示例: 同上

---

4. 根据ID获取委托人信息

接口地址: GET /secondEntrustUser/getById?id=1

响应示例: 同上

---

5. 更新委托人信息

接口地址: PUT /secondEntrustUser/update/1

请求参数:

{
  "entrustTradeId": 1,
  "entrustTradeNo": "TRADE202511210001",
  "entrustUserPhone": "13800138001",
  "entrustUserName": "李四",
  "entrustIdCard": "110101199001011235",
  "entrustIdCardImg": "https://example.com/id_card2.jpg"
}

响应示例:

{
  "code": 200,
  "msg": "更新成功",
  "data": true
}

---

6. 删除委托人信息

接口地址: DELETE /secondEntrustUser/delete?id=1

响应示例:

{
  "code": 200,
  "msg": "删除成功",
  "data": true
}

---

7. 根据用户电话查询委托人信息列表

接口地址: GET /secondEntrustUser/getByUserPhone?entrustUserPhone=13800138000

响应示例:

{
  "code": 200,
  "msg": "操作成功",
  "data": [
    {
      "id": 1,
      "entrustTradeId": 1,
      "entrustTradeNo": "TRADE202511210001",
      "entrustUserPhone": "13800138000",
      "entrustUserName": "张三",
      "entrustIdCard": "110101199001011234",
      "entrustIdCardImg": "https://example.com/id_card.jpg",
      "deleteFlag": 0,
      "createdTime": "2025-11-21 10:00:00",
      "createdUserId": 1,
      "updatedTime": "2025-11-21 10:00:00",
      "updatedUserId": 1
    }
  ]
}

---

Postman 测试步骤

1. 创建委托人信息

   • Method: POST
   • URL: http://localhost:端口/secondEntrustUser/create

   • Body (raw JSON):

     {
     "entrustTradeId": 1,
     "entrustTradeNo": "TRADE202511210001",
     "entrustUserPhone": "13800138000",
     "entrustUserName": "张三",
     "entrustIdCard": "110101199001011234",
     "entrustIdCardImg": "https://example.com/id_card.jpg"
     }
     

2. 根据交易ID查询委托人信息

   • Method: GET
   • URL: http://localhost:端口/secondEntrustUser/getByTradeId?entrustTradeId=1

3. 根据交易编号查询委托人信息

   • Method: GET
   • URL: http://localhost:端口/secondEntrustUser/getByTradeNo?entrustTradeNo=TRADE202511210001

4. 更新委托人信息

   • Method: PUT
   • URL: http://localhost:端口/secondEntrustUser/update/1

   • Body (raw JSON):

     {
     "entrustTradeId": 1,
     "entrustTradeNo": "TRADE202511210001",
     "entrustUserPhone": "13800138001",
     "entrustUserName": "李四"
     }
     

5. 删除委托人信息

   • Method: DELETE
   • URL: http://localhost:端口/secondEntrustUser/delete?id=1

---

测试数据 SQL

-- 插入测试数据
INSERT INTO second_entrust_user (entrust_trade_id, entrust_trade_no, entrust_user_phone, entrust_user_name, entrust_id_card, entrust_id_card_img, delete_flag, created_time, created_user_id, updated_time, updated_user_id)
VALUES (1, 'TRADE202511210001', '13800138000', '张三', '110101199001011234', 'https://example.com/id_card.jpg', 0, NOW(), 1, NOW(), 1);

-- 查询数据
SELECT * FROM second_entrust_user WHERE delete_flag = 0;

-- 根据交易ID查询
SELECT * FROM second_entrust_user WHERE entrust_trade_id = 1 AND delete_flag = 0;

-- 根据交易编号查询
SELECT * FROM second_entrust_user WHERE entrust_trade_no = 'TRADE202511210001' AND delete_flag = 0;

-- 根据用户电话查询
SELECT * FROM second_entrust_user WHERE entrust_user_phone = '13800138000' AND delete_flag = 0;