Skip to content

下拉菜单展示优化

下拉菜单展示结果优化

1.增加mongodb数据库sku_freq

{
    "_id" : ObjectId("58ff0652804c6324d536c0de"),
    "address_id" : "23443", ## 商户id
    "create_time" : ISODate("2017-04-25T16:18:26.770Z"), ##创建时间
    "update_time" : ISODate("2017-04-25T16:18:26.770Z"), ##更新时间
    "sku_id" : {
        "D650858" : 1, #skuid和对应的频次
        "D650844" : 1,
        "D650856" : 1,
        "D650847" : 1
    }
}

2.定时脚本任务

  • 创建脚本每天定时往sku_freq添加第二天需要的数据

3. 需要改动的接口

gm_service --- /station/skus/addr
  • 这个接口是用来获取下拉的菜单
接口名:/station/skus/addr
Method:GET
请求:
    address_id   M   int     商户ID
    search_text  M   string  商品sku_id或者商品名称
    time_config_id M string  时间配置ID
    fetch_category O int     0-表示不拉取分类;1-表示拉取分类;
    active       O   int     0-表示拉取全部状态商品;1-表示只拉取有效的商品;
    offset       O   int     分页offset
    limit        O   int     分页limit

响应:

    code    M   int     返回码,0表示成功,其他表示错误
    msg     M   string  错误信息

示例:
    request
        http://station.guanmai.cn/station/skus/addr?address_id=6191&offset=0&limit=10&search_text=上海青&fetch_category=1&active=1&time_config_id=ST001


    response
       {
            "code": 0,
            "msg": "ok",
            "data": [
                {
                    "name": "上海青|中条|优质|件",
                    "desc": "云南产,棵底直径约为3-4cm,泡沫箱装,净重35斤/件。",
                    "spu_id": "C00035",
                    "category_title_1": "蔬菜",
                    "supplier_name": "小农女",
                    "unit_price": 3.88,
                    "std_unit_name": "斤",
                    "state": 1,
                    "id": "D804813",
                    "spu_remark": "",
                    "category_id_2": "B101",
                    "sale_price": 174.6,
                    "category_id_1": "A101",
                    "sync_origin_id": "D804813",
                    "category_title_2": "叶菜类",
                    "sale_ratio": 45,
                    "sale_num_least": 1,
                    "salemenu_id": "S0520",
                    "is_weigh": true,
                    "station_id": "T002",
                    "sale_unit_name": "件"
                },
              ]
            }

  • 上面的内容是以前接口返回的json值,现在新增加frequency字段来代表搜索频次
{
            "code": 0,
            "msg": "ok",
            "data": [
                {
                    "name": "上海青|中条|优质|件",
                    "desc": "云南产,棵底直径约为3-4cm,泡沫箱装,净重35斤/件。",
                    "spu_id": "C00035",
                    "category_title_1": "蔬菜",
                    "supplier_name": "小农女",
                    "unit_price": 3.88,
                    "std_unit_name": "斤",
                    "state": 1,
                    "id": "D804813",
                    "spu_remark": "",
                    "category_id_2": "B101",
                    "sale_price": 174.6,
                    "category_id_1": "A101",
                    "sync_origin_id": "D804813",
                    "category_title_2": "叶菜类",
                    "sale_ratio": 45,
                    "sale_num_least": 1,
                    "salemenu_id": "S0520",
                    "is_weigh": true,
                    "station_id": "T002",
                    "sale_unit_name": "件",

                    "frequency" : " "
                },
              ]
}
  • frequency为一个大于等于0的数,前端根据frequency进行排序即可.