业务（二）资源位管理

一、产品列表管理

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会有记录

业务（二）资源位管理

改变产品列表状态时，会有记录，这里target_id是列表id，target_name是列表名称

业务（二）资源位管理

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}
];

业务（二）资源位管理

$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"}
 ]
}

业务（二）资源位管理

相关推荐