业务（二）资源位管理

￡神魔★判官ぃ 2022-03-16 12:15 254阅读 0赞

**一、产品列表管理**

**cfg\_product\_list\_v3**产品列表配置表

CREATE TABLE `cfg_product_list_v3` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `title` varchar(200) NOT NULL DEFAULT '' COMMENT '列表名称',
      `remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注',
      `onoff` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否上下架 1 上架 0下架',
      `show_count` int(5) NOT NULL DEFAULT '0' COMMENT '展示个数',
      `manual_recommend` varchar(255) NOT NULL DEFAULT '' COMMENT '手动推荐',
      `auto_recommend` text NOT NULL COMMENT '自动筛选条件推荐',
      `auto_sort_rule` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '自动排序规则 1 倒序',
      `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 0否，1是',
      `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
      `operator_name` varchar(255) NOT NULL COMMENT '操作人',
      `operator_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作日期',
      PRIMARY KEY (`id`),
      KEY `index_title` (`title`)
    ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='产品列表配置表';

新增产品列表时，cfg\_operation\_log\_v3会有记录

![20190227205131604.png][]

改变产品列表状态时，会有记录，这里target\_id是列表id，target\_name是列表名称

![20190228114515464.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hyYnNmZHh6aHEwMQ_size_16_color_FFFFFF_t_70][]

id对应的是产品的url\_id

$manual_recommend = [
        {"id":"40","weight":5},
        {"id":"36","weight":4},
        {"id":"39","weight":3},
        {"id":"35","weight":2},
        {"id":"37","weight":1}
    ];

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hyYnNmZHh6aHEwMQ_size_16_color_FFFFFF_t_70 1][]

$auto_recommend = {
    "weight":[
        {"min_num":"4","max_num":"6","key":"weight1551272582309"},
        {"min_num":"9","max_num":"18","key":"weight1551324707082"}
     ],
    "time":[
        {"hour":"4","key":"time1551272582309"},
        {"hour":"8","key":"time1551324719833"}
     ]
    }

[20190227205131604.png]: /images/20220316/8b4737cee3294a889ca9540fe4941a1d.png
[20190228114515464.png]: /images/20220316/2b049d08ffa64973957dfacf8c53b875.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hyYnNmZHh6aHEwMQ_size_16_color_FFFFFF_t_70]: /images/20220316/e2475bf04abe480bbabb6d506ed5aad0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hyYnNmZHh6aHEwMQ_size_16_color_FFFFFF_t_70 1]: /images/20220316/348655f7133148dfa109d0667064a00d.png