Skip to content

商城自定义方案

注意,cmskey为 gm 的用户不能编辑任何自定义信息

表结构修改

][customized_info

label_size:         标签的大小如 'small'、 'medium'、 'large'.
homepage:
    [
        {
            'category': 'ad'
            'type': 1,
            'ad_img_ids': [

            ],
        },
        {
            'category': 'sku_groups',
            'title': 商品组标题10个字以内,     // 商品组标题
            'promotion_id': 1,             // 营销id
            'show_type': 'list',             // 列表式list,平铺式tiled
        },
    ]

字段说明:

标签大小: label_size

label_size字段,三个可选值, 'small', 'medium', 'large'

广告位:

type: 1 1行1个
type: 2 1行2个
type: 3 1左2右

homepage:

[
    {
        'category': 'ad'
        'type': 1,
        'ad_img_ids': [

        ],
    },
    {
        'category': 'sku_groups',
        'title': 商品组标题10个字以内,     // 商品组标题
        'promotion_id': 1,             // 营销id
        'show_type': 'list',             // 列表式list,平铺式tiled
    },
]

使用category区分是商品组还是广告

bhsop的接口

[老接口] 获取在station添加的营销活动

Request URL: http://bshop.guanmai.cn/product/promotion/list

Request Method: GET

接口描述
    这个接口是获取station客户自己添加的营销活动信息(一级标签的name会作为bshop的标签展示)
Method
    GET
请求
    无
响应
    code    M   int     返回码, 0表示成功,其他表示错误
    msg     M   string  错误信息
    data    M   string  返回json数据

[老接口] 标签页面的数据来源接口

Request URL: http://bshop.guanmai.cn/product/category/get

Request Method: GET

接口描述
    获取商城首页的标签数据展示
Method
    GET
请求
    无
响应
    code    M   int     返回码, 0表示成功,其他表示错误
    msg     M   string  错误信息
    data    M   string  返回json数据

[修改老接口] bshop拉取首页的商品组和广告位的接口

这个接口原来是用来拉取营销商品的接口,新修改后,增加自定义广告位和商品组信息的返回( 如果有的话)

Request URL: http://bshop.guanmai.cn/product/sku/promotion

Request Method: GET

接口描述
    获取营销活动的商品列表数据,新增广告位和商品信息的返回
Method
    GET
请求
    无
响应
    code    M   int     返回码, 0表示成功,其他表示错误
    msg     M   string  错误信息
    data    M   string  返回json数据

{
    "default_infos": [
        {
            "name":  "每日精选",
            "skus": [
            {
                 "rank":0,
                 "is_fav":false,
                 "img_url":"http://testpic.guanmai.cn/product_pic/2a263d824e36b616.jpeg",
                 "salemenu_id":"S8056",
                 "std_sale_price":1102.0,
                 "id":"C874495",
                 "std_unit_name":"斤",
                 "name":"大白菜",
                 "skus":[
                    {
                       "rule_price":null,
                       "promotion_price":null,
                       "station_id":"T7936",
                       "id":"D4122924",
                       "category_id_2":"B19074",
                       "sale_unit_name":"斤",
                       "state":1,
                       "sale_ratio":1.0,
                       "is_valid":true,
                       "limit_number":null,
                       "img_url":"http://testpic.guanmai.cn/product_pic/2a263d824e36b616.jpeg",
                       "sale_price":1102,
                       "sale_num_least":1.0,
                       "std_unit_name":"斤",
                       "name":"大白菜|称重",
                       "stocks":-99999,
                       "desc":"2555",
                       "salemenu_id":"S8056",
                       "category_id_1":"A3978",
                       "is_price_timing":false,
                       "std_sale_price":1102,
                       "cart_amount":0,
                       "clean_food":false,
                       "spu_id":"C874495"
                    }
                 ],
                 "cart_amount":0
            },
        ]}
    ]
    "is_customiszed": true,
    "label_size": "small",
    "homapage":[
        {
            'category': 'ad',
            'type': 1,
            'ad_imgs': [
                {
                    'img_id': 'sdfdfdfdf.jpg',
                    'img_url': 'http://testpic.guanmai.cn/product_pic/3c0d9a66f97c62cd.jpeg'
                }
            ]
        },
        {
            'category': 'sku_groups',
            'title': 商品组标题10个字以内,
            'promotion_id':  1,
            'show_type': 'list',
            'skus': [
                {
                   "rank":0,
                   "is_fav":false,
                   "img_url":"http://testpic.guanmai.cn/product_pic/3c0d9a66f97c62cd.jpeg",
                   "salemenu_id":"S8056",
                   "std_sale_price":0.0,
                   "id":"C874498",
                   "std_unit_name":"斤",
                   "name":"长白菜",
                   "skus":[
                      {
                         "rule_price":null,
                         "promotion_price":null,
                         "station_id":"T7936",
                         "id":"D3457160",
                         "category_id_2":"B19074",
                         "sale_unit_name":"斤",
                         "state":1,
                         "sale_ratio":1.0,
                         "is_valid":true,
                         "limit_number":null,
                         "img_url":"http://testpic.guanmai.cn/product_pic/3c0d9a66f97c62cd.jpeg",
                         "sale_price":0,
                         "sale_num_least":1.0,
                         "std_unit_name":"斤",
                         "name":"长白菜",
                         "stocks":-99999,
                         "desc":"长约30cm,菜叶包裹紧实",
                         "salemenu_id":"S8056",
                         "category_id_1":"A3978",
                         "is_price_timing":true,
                         "std_sale_price":1102,
                         "cart_amount":0,
                         "clean_food":false,
                         "spu_id":"C874498"
                      }
                   ],
                   "cart_amount":0
                },
            ]
        }
    ],
}

station的接口

[修改老接口] station获取商城自定义的信息:

Request URL: http://station.guanmai.cn/station/customized

Request Method: GET

接口描述
    station侧返回自定义信息的接口
Method
    GET
请求
    无
响应
    code    M   int     返回码,0表示成功,其他表示错误
    msg     M   string  错误信息
    data    M   string  返回json数据

例子:
    request:
    GET  https://station.guanmai.cn/station/shop/customized
    response:
    {
        "is_customiszed": true,
        "label_size": "small",
        "labels": [
                    {
                         "id":"A7665",
                         "url":"http://testpic.guanmai.cn/icon/icon-veg.4fa23256.png",
                         "name":"早点",
                         "rank":0,
                         "children":[
                            {
                               "rank":0,
                               "name":"糕点配料",
                               "first_category_id":"A7665",
                               "id":"B37062"
                            },
                            {
                               "rank":0,
                               "name":"糕点、包类",
                               "first_category_id":"A7665",
                               "id":"B37086"
                            },
                            {
                               "rank":0,
                               "name":"粉、面",
                               "first_category_id":"A7665",
                               "id":"B37099"
                            }
                         ]
                    },
        ],
        "homapage":[
            {
                'category': 'ad',
                'type': 1,
                'ad_imgs': [
                    {
                        'img_id': 'sdfdfdfdf.jpg',
                        'img_url': 'http://testpic.guanmai.cn/product_pic/3c0d9a66f97c62cd.jpeg'
                    }
                ]
            },
            {
                'category': 'sku_groups',
                'title': 商品组标题10个字以内,
                'promotion_id':  1,
                'show_type': 'list',
                'skus': [
                    {
                    "rank":0,
                    "is_fav":false,
                    "img_url":"http://testpic.guanmai.cn/product_pic/3c0d9a66f97c62cd.jpeg",
                    "salemenu_id":"S8056",
                    "std_sale_price":0.0,
                    "id":"C874498",
                    "std_unit_name":"斤",
                    "name":"长白菜",
                    "skus":[
                        {
                            "rule_price":null,
                            "promotion_price":null,
                            "station_id":"T7936",
                            "id":"D3457160",
                            "category_id_2":"B19074",
                            "sale_unit_name":"斤",
                            "state":1,
                            "sale_ratio":1.0,
                            "is_valid":true,
                            "limit_number":null,
                            "img_url":"http://testpic.guanmai.cn/product_pic/3c0d9a66f97c62cd.jpeg",
                            "sale_price":0,
                            "sale_num_least":1.0,
                            "std_unit_name":"斤",
                            "name":"长白菜",
                            "stocks":-99999,
                            "desc":"长约30cm,菜叶包裹紧实",
                            "salemenu_id":"S8056",
                            "category_id_1":"A3978",
                            "is_price_timing":true,
                            "std_sale_price":1102,
                            "cart_amount":0,
                            "clean_food":false,
                            "spu_id":"C874498"
                        }
                    ],
                    "cart_amount":0
                    },
                ]
            }
        ],
    }

[修改老接口]station更新和创建标签广告位和商品组:

Request URL: http://station.guanmai.cn/station/shop/customized/update

Request Method: POST

接口描述
    为商城添加广告位,商品组
Method
    POST
请求
    label_size   O  string   标签的大小
    homepage:   O  list     商城首页自定义信息
响应
    code    M   int     返回码,0表示成功,其他表示错误
    msg     M   string  错误信息
    data    M   string  返回json数据
例子:
    request:
    POST  https://station.guanmai.cn/station/customized/update

    {

        "label_size": "small",
        "homepage": [
             {
                'category': 'ad',
                'type': 1,
                'ad_img_ids': [
                    'shjdhfjdshf.jpg'
                ]
             },
             {
                'category': 'sku_groups',
                'title': 商品组标题10个字以内,
                'promotion_id':  1,
                'show_type': 'list'
            },

        ]

    }

    response:
    {
        code: 0,
        msg: 'ok',
        data: null
    }

以下的接口不需要改,只是看代码的时候把相关的接口罗列出来

创建营销活动的接口

Request URL: http://station.cus_shop.devhost.guanmai.cn/station/promotion/create

Request Method: POST

Response:

{
    name: 春节促销
    active: 1
    show_method: 1
    sort: 2
    enable_label_2: 0
    label_1_name: 萝卜促销
    pic_url: //img.guanmai.cn/icon/icon-meat.0651a911.png
    type: 1
    skus: [
            {"state":1,"salemenu_name":"综合商品","name":"白萝卜(去皮)","id":"D4221416","value":"D4221416","_gm_select":false,"label_1_name":"萝卜促销"},
            {"state":1,"salemenu_name":"综合商品","name":"红萝卜(去皮)","id":"D4209381","value":"D4209381","_gm_select":false,"label_1_name":"萝卜促销"},
            {"state":1,"salemenu_name":"综合商品","name":"红萝卜(去皮)","id":"D4213522","value":"D4213522","_gm_select":false,"label_1_name":"萝卜促销"}
    ]
}

拉取营销活动的接口

Request URL: http://station.cus_shop.devhost.guanmai.cn/station/promotion/list?offset=0 Request Method: GET

Response:

{
    code: 0
    data: [
    {
        operator: "miaomiao", create_time: "2018-12-17T19:38:58", sku_nums: 2, active: 1, name: "元旦热销", id: 1,…}
        active: 1
        create_time: "2018-12-17T19:38:58"
        id: 1
        name: "元旦热销"
        operator: "miaomiao"
        show_method: 1
        sku_nums: 2
        type: 1
    }
    {
        operator: "miaomiao", create_time: "2018-12-17T19:44:17", sku_nums: 3, active: 1, name: "春节促销", id: 2,…}
        active: 1
        create_time: "2018-12-17T19:44:17"
        id: 2
        name: "春节促销"
        operator: "miaomiao"
        show_method: 1
        sku_nums: 3
        type: 1
    }
    msg: "ok"
}

station权限添加:

查看基础设置 编辑基础设置 查看店铺装修 编辑店铺装修

SET @level2_id = 0;
SELECT id INTO @level2_id FROM tbl_permission_class WHERE name='店铺运营设置';

把原来的'查看店铺设置'权限的name改为'查看基础设置'权限:

UPDATE auth_permission SET name='查看基础设置' WHERE codename='get_shop_setting'

添加编辑基础设置的权限:

INSERT INTO auth_permission(
    `name`, `codename`, `level2_id`) VALUES(
    '编辑基础设置', 'edit_base_setting', @level2_id
)

添加查看店铺装修的权限:

INSERT INTO auth_permission(
    `name`, `codename`, `level2_id`) VALUES(
    '查看店铺装修', 'get_shop_decorate', @level2_id
)

添加编辑店铺装修的权限:

INSERT INTO auth_permission(
    `name`, `codename`, `level2_id`) VALUES(
    '编辑店铺装修', 'edit_shop_decorate', @level2_id
)

为站点刷权限数据