零点轰趴馆开发日记：二

订单形成

接口一【POST】：https://moduo.luluhoo.cn/appApi/app/order/amount

payload【所有选项都选中】：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
{
  "shopId": "f76b2e3bb6194966904816651ac471de",
  "foods": [
    {
      "foodId": "da8e628b4427400cbf931fbd06bd41dd",
      "quantity": 4,
      "foodName": "火锅",
      "price": 899
    },
    {
      "foodId": "9eaf331a272a430ab8e6ac79b5c93bea",
      "quantity": 1,
      "foodName": "烧烤",
      "price": 1158
    },
    {
      "foodId": "5da3d5e14a674394bdee43ed76053568",
      "quantity": 1,
      "foodName": "中餐",
      "price": 880
    },
    {
      "foodId": "5b62af2addcb4e138debc75e10aaf88c",
      "quantity": 1,
      "foodName": "甜品",
      "price": 580
    }
  ],
  "subjectId": "38fecebb97364ae5849ad877201bdde0",
  "selTheme": "{\"id\":\"38fecebb97364ae5849ad877201bdde0\",\"subjectName\":\"生日聚会\",\"price\":1280}",
  "servicesIds": [
    "eff1de32f5dc4d81a1a2a06f2458c488",
    "cdfd4564aacf407bb26c2c35b16b11b2"
  ],
  "selServices": "[{\"createBy\":\"\",\"createTime\":\"2024-03-08 11:07:03\",\"updateBy\":\"\",\"updateTime\":\"2024-10-12 10:25:44\",\"remark\":\"每桶零食桶里面有30款左右不同类型的小零食，颜值高，可以拍照打卡，朋友聚会，生日派对，公司团建的最佳选择\",\"params\":{\"@type\":\"java.util.HashMap\"},\"id\":\"eff1de32f5dc4d81a1a2a06f2458c488\",\"servicesName\":\"零食桶\",\"coverImage\":\"http://store.luluhoo.cn/aijuhui_mini/f20241012102543800466088049XGVJNFBC.png\",\"price\":79,\"delFlag\":\"0\",\"loginIp\":\"\",\"loginDate\":null,\"createDept\":null,\"updateIp\":null,\"version\":null,\"showDetail\":false},{\"createBy\":\"\",\"createTime\":\"2024-03-08 11:07:29\",\"updateBy\":\"\",\"updateTime\":\"2024-10-12 10:25:39\",\"remark\":\"微信扫码直接取走相片，快乐同步分享。我们就可以共享多分快乐。嘿嘿。美好的瞬间是需要被记住的哦。\",\"params\":{\"@type\":\"java.util.HashMap\"},\"id\":\"cdfd4564aacf407bb26c2c35b16b11b2\",\"servicesName\":\"摄影摄像\",\"coverImage\":\"http://store.luluhoo.cn/aijuhui_mini/f20241012102537800318137288NSS7WOOE.png\",\"price\":1500,\"delFlag\":\"0\",\"loginIp\":\"\",\"loginDate\":null,\"createDept\":null,\"updateIp\":null,\"version\":null,\"showDetail\":false}]",
  "presenterId": "fd3e3f13d4d74ccda3dfe26cb40d88d9",
  "selPresenter": "{\"createBy\":\"\",\"createTime\":\"2024-03-04 16:38:39\",\"updateBy\":\"\",\"updateTime\":\"2024-10-06 11:49:18\",\"remark\":null,\"params\":{\"@type\":\"java.util.HashMap\"},\"id\":\"fd3e3f13d4d74ccda3dfe26cb40d88d9\",\"presenterName\":\"锅巴\",\"coverImage\":\"http://store.luluhoo.cn/aijuhui_mini/f20240307103949807794505868KCCKX5AK\",\"price\":666,\"introduction\":\"非常专业非常专业非常专业非常专业非常专业非常专业非常专业非常专业非常专业非常专业非常专业非常专业非常专业非常专业非常专业非常专业\",\"stars\":null,\"delFlag\":\"0\",\"loginIp\":\"\",\"loginDate\":null,\"createDept\":null,\"updateIp\":null,\"version\":null}",
  "orderDateList": [
    {
      "selectedDate": "2025-01-14",
      "sessionIds": [
        "747816ed225e42b7aa73f434744ca5ce"
      ]
    }
  ]
}

返回数据：

1
2
3
4
5
6
7
8
{
  "msg": "操作成功",
  "code": 200,
  "data": {
    "lineAmount": 13239,
    "amount": 13239
  }
}

接口二：https://moduo.luluhoo.cn/appApi/app/free/shop/detail/f76b2e3bb6194966904816651ac471de

接口三：https://moduo.luluhoo.cn/appApi/app/promotion/orderPromotion

{“msg”:”操作成功”,”code”:200}

接口四：https://moduo.luluhoo.cn/appApi/app/order/create

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
{
  "shopId": "f76b2e3bb6194966904816651ac471de",
  "booker": "",
  "phone": "15188753131",
  "peopleNum": 1,
  "payMode": "1",
  "subjectId": "38fecebb97364ae5849ad877201bdde0",
  "presenterId": "fd3e3f13d4d74ccda3dfe26cb40d88d9",
  "servicesIds": [
    "eff1de32f5dc4d81a1a2a06f2458c488",
    "cdfd4564aacf407bb26c2c35b16b11b2"
  ],
  "orderDateList": [
    {
      "selectedDate": "2025-01-14",
      "sessionIds": [
        "747816ed225e42b7aa73f434744ca5ce"
      ]
    }
  ],
  "foods": [
    {
      "foodId": "da8e628b4427400cbf931fbd06bd41dd",
      "quantity": 4,
      "foodName": "火锅",
      "price": 899
    },
    {
      "foodId": "9eaf331a272a430ab8e6ac79b5c93bea",
      "quantity": 1,
      "foodName": "烧烤",
      "price": 1158
    },
    {
      "foodId": "5da3d5e14a674394bdee43ed76053568",
      "quantity": 1,
      "foodName": "中餐",
      "price": 880
    },
    {
      "foodId": "5b62af2addcb4e138debc75e10aaf88c",
      "quantity": 1,
      "foodName": "甜品",
      "price": 580
    }
  ]
}

返回数据：
{“msg”:”操作成功”,”code”:200,”data”:{“id”:”53d27eaf7f0a42e48013586c72010ef0”}}

接口五：https://moduo.luluhoo.cn/appApi/app/order/pay

payload：

1
2
3
4
{
  "id": "53d27eaf7f0a42e48013586c72010ef0",
  "payMode": "1"
}

返回数据：
{“msg”:”操作成功”,”code”:200,”data”:

1
{"miniProgramOrgId":"gh_75b350055f04","miniProgramPath":"pages/fromAppPay/index","code":"00000","orderId":"P20250114120313811833147642","appId":"wx9a95331605fc5eb5","prePayTn":"pages/fromAppPay/index?state=6f928a3d-d326-4064-9ffd-267a560f0703&customerNo=10090688959&goodsName=%E7%94%A8%E6%88%B7%E4%B8%8B%E5%8D%95&customerRequestNo=P20250114120313811833147642&orderAmount=14739&launchSource=MINI_PROGRAM","uniqueOrderNo":"1013202501140000017557810407","message":"成功"}}

具体实现：
一：
订单表：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
CREATE TABLE as_orders (  
                        id INT AUTO_INCREMENT PRIMARY KEY COMMENT '订单ID',  
                        shop_id VARCHAR(255) NOT NULL COMMENT '店铺ID',  
                        booker VARCHAR(255) DEFAULT NULL COMMENT '预订人',  
                        phone VARCHAR(20) NOT NULL COMMENT '联系电话',  
                        people_num INT NOT NULL COMMENT '人数',  
                        pay_mode VARCHAR(10) NOT NULL COMMENT '支付方式',  
                        subject_id VARCHAR(255) NOT NULL COMMENT '主题ID',  
                        presenter_id VARCHAR(255) NOT NULL COMMENT '主持人ID',  
                        services_ids JSON DEFAULT NULL COMMENT '服务ID列表',  
                        order_date_list JSON DEFAULT NULL COMMENT '订单日期列表',  
                        foods JSON DEFAULT NULL COMMENT '食品列表',  
                        created_at DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',  
                        updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单表';+

eyJhbGciOiJIUzUxMiJ9.eyJhcHBfdXVpZF9rZXkiOiJhZmU5YTRhOC1mNTFlLTQ5N2YtYTNiZS1hNDU1ZGJlZWRmNjIifQ.ULjuZT_Wwjan7cuQqlbziv8OwQo4_8Pz3UphWX2ddK9mTTW84CVPzRX48yXe_QbgcVisI6rrM2QbTGgQwNqPUg

Bearer eyJhbGciOiJIUzUxMiJ9.eyJhcHBfdXVpZF9rZXkiOiIxZTAwMTBiZC1iOTNmLTQ2NzgtOTg1YS00ZjQxYjNkMWQzM2IifQ.ZP3aqJ8HM_Yg9SL3lPgkg3BaGJNaN9c3m0jYsidFgmdcZEMowsU1ENLUQDMV0eTeHgFjFJuID4kYAUZdTaTmwg