需求 #22272
<p>- 新品标杆-排期表</p>
<p>- 新品标杆-商品审核</p>
<p>- 新品扶持-商品审核</p>
<p> </p>
<p>前端分支：feature/22266-平台化爆版4.6.0</p>
<p>后端分支：feature/爆版v4.6</p>
<p> </p>
<p>报名机会 ：fmys_supply_new_goods_activity</p>
<p>报名商品：fmys_supply_new_goods_activity_goods</p>
<p>报名记录:fmys_supply_new_goods_activity_record</p>
<p> </p>
<p> </p>
<p>下面五个指标是crm的库</p>
<p>退货率：pss_data_supply_day_index.reject_goods_rate_30</p>
<p>新增粉丝：pss_data_supply_month_index.add_fans</p>
<p>新款：pss_data_supply_month_index.total_new_goods_no</p>
<p>复购：pss_data_supply_day_index.pay_rebuy_rate_30</p>
<p>动销率:pss_data_supply_day_index.new_sale_rate_accumulate</p>
<p> </p>
<p>CREATE TABLE `fmys_supply_new_goods_activity_record` (<br />
`id` int(11) NOT NULL AUTO_INCREMENT,<br />
`supply_id` int(11) NOT NULL COMMENT '供应商ID',<br />
`shop_id` int(11) NOT NULL COMMENT '店铺ID',<br />
`shop_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '店铺名称',<br />
`create_time` int(11) NULL DEFAULT NULL COMMENT '报名时间',<br />
`sale_date` int(11) NOT NULL DEFAULT 0 COMMENT '排期时间',<br />
`activity_type` tinyint(1) NULL DEFAULT 0 COMMENT '活动类型{1:新品标杆，2：新品扶持}',<br />
`status` tinyint(1) NULL DEFAULT 1 COMMENT '排期状态{1:排期中,2:排期确定}',<br />
PRIMARY KEY (`id`) USING BTREE,<br />
INDEX `supply_id`(`supply_id`) USING BTREE,<br />
INDEX `create_time`(`create_time`) USING BTREE<br />
) ENGINE = InnoDB AUTO_INCREMENT = 1CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '供应商新品活动报名'</p>
<p>CREATE TABLE `fmys_supply_new_goods_activity_goods` (<br />
`id` int(11) NOT NULL AUTO_INCREMENT,<br />
`goods_no` int(11) NOT NULL COMMENT '货号',<br />
`supply_id` int(11) NOT NULL DEFAULT 0 COMMENT '供应商ID',<br />
`discount_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '折扣信息',<br />
`first_stock` int(11) NOT NULL DEFAULT 0 COMMENT '首批库存',<br />
`scheduling_time` smallint(5) NOT NULL DEFAULT 0 COMMENT '加单货期',<br />
`activity_type` tinyint(1) NULL DEFAULT NULL COMMENT '{1:新品标杆,2:新品扶持}',<br />
`record_id` int(11) NOT NULL COMMENT '报名ID',<br />
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '报名状态{0未审核,1:通过,2:驳回:3:取消}',<br />
`no_pass_reason` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '驳回原因',<br />
`create_time` int(11) NULL DEFAULT NULL COMMENT '提交时间',<br />
`check_time` int(11) NULL DEFAULT 0 COMMENT '审核时间',<br />
PRIMARY KEY (`id`) USING BTREE,<br />
INDEX `record_id`(`record_id`) USING BTREE,<br />
INDEX `goods_no`(`goods_no`) USING BTREE,<br />
INDEX `supply_id`(`supply_id`) USING BTREE<br />
) ENGINE = InnoDB AUTO_INCREMENT = 1CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '新品活动报名商品'</p>
<p> </p>
<p>CREATE TABLE `fmys_supply_new_goods_activity` `fmys_supply_new_goods_activity_record` (<br />
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,<br />
`supply_id` int(11) NOT NULL COMMENT '供应商ID',<br />
`num` smallint(5) UNSIGNED `shop_id` int(11) NOT NULL COMMENT '店铺ID',<br />
`shop_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 0 NULL COMMENT '固定次数',<br '店铺名称',<br />
`prize_num` smallint(5) UNSIGNED `create_time` int(11) NULL DEFAULT NULL COMMENT '报名时间',<br />
`sale_date` int(11) NOT NULL DEFAULT 0 COMMENT '奖励次数',<br '排期时间',<br />
`type` `activity_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '类型{1:新款主推,2:新品扶持}',<br '活动类型{1:新品标杆，2：新品扶持}',<br />
`auto_time` timestamp(0) `status` tinyint(1) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) 1 COMMENT '更新时间',<br '排期状态{1:排期中,2:排期确定}',<br />
PRIMARY KEY (`id`) USING BTREE,<br />
UNIQUE INDEX `idx(supply_id,type)`(`supply_id`, `type`) `supply_id`(`supply_id`) USING BTREE,<br />
INDEX `supply_id`(`supply_id`) `create_time`(`create_time`) USING BTREE<br />
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER 1CHARACTER SET = utf8 COLLATE = utf8_general_ci</p> utf8_general_ci COMMENT = '供应商新品活动报名'</p>
<p>- 新品标杆-商品审核</p>
<p>- 新品扶持-商品审核</p>
<p> </p>
<p>前端分支：feature/22266-平台化爆版4.6.0</p>
<p>后端分支：feature/爆版v4.6</p>
<p> </p>
<p>报名机会 ：fmys_supply_new_goods_activity</p>
<p>报名商品：fmys_supply_new_goods_activity_goods</p>
<p>报名记录:fmys_supply_new_goods_activity_record</p>
<p> </p>
<p> </p>
<p>下面五个指标是crm的库</p>
<p>退货率：pss_data_supply_day_index.reject_goods_rate_30</p>
<p>新增粉丝：pss_data_supply_month_index.add_fans</p>
<p>新款：pss_data_supply_month_index.total_new_goods_no</p>
<p>复购：pss_data_supply_day_index.pay_rebuy_rate_30</p>
<p>动销率:pss_data_supply_day_index.new_sale_rate_accumulate</p>
<p> </p>
<p>CREATE TABLE `fmys_supply_new_goods_activity_record` (<br />
`id` int(11) NOT NULL AUTO_INCREMENT,<br />
`supply_id` int(11) NOT NULL COMMENT '供应商ID',<br />
`shop_id` int(11) NOT NULL COMMENT '店铺ID',<br />
`shop_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '店铺名称',<br />
`create_time` int(11) NULL DEFAULT NULL COMMENT '报名时间',<br />
`sale_date` int(11) NOT NULL DEFAULT 0 COMMENT '排期时间',<br />
`activity_type` tinyint(1) NULL DEFAULT 0 COMMENT '活动类型{1:新品标杆，2：新品扶持}',<br />
`status` tinyint(1) NULL DEFAULT 1 COMMENT '排期状态{1:排期中,2:排期确定}',<br />
PRIMARY KEY (`id`) USING BTREE,<br />
INDEX `supply_id`(`supply_id`) USING BTREE,<br />
INDEX `create_time`(`create_time`) USING BTREE<br />
) ENGINE = InnoDB AUTO_INCREMENT = 1CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '供应商新品活动报名'</p>
<p>CREATE TABLE `fmys_supply_new_goods_activity_goods` (<br />
`id` int(11) NOT NULL AUTO_INCREMENT,<br />
`goods_no` int(11) NOT NULL COMMENT '货号',<br />
`supply_id` int(11) NOT NULL DEFAULT 0 COMMENT '供应商ID',<br />
`discount_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '折扣信息',<br />
`first_stock` int(11) NOT NULL DEFAULT 0 COMMENT '首批库存',<br />
`scheduling_time` smallint(5) NOT NULL DEFAULT 0 COMMENT '加单货期',<br />
`activity_type` tinyint(1) NULL DEFAULT NULL COMMENT '{1:新品标杆,2:新品扶持}',<br />
`record_id` int(11) NOT NULL COMMENT '报名ID',<br />
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '报名状态{0未审核,1:通过,2:驳回:3:取消}',<br />
`no_pass_reason` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '驳回原因',<br />
`create_time` int(11) NULL DEFAULT NULL COMMENT '提交时间',<br />
`check_time` int(11) NULL DEFAULT 0 COMMENT '审核时间',<br />
PRIMARY KEY (`id`) USING BTREE,<br />
INDEX `record_id`(`record_id`) USING BTREE,<br />
INDEX `goods_no`(`goods_no`) USING BTREE,<br />
INDEX `supply_id`(`supply_id`) USING BTREE<br />
) ENGINE = InnoDB AUTO_INCREMENT = 1CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '新品活动报名商品'</p>
<p> </p>
<p>CREATE TABLE `fmys_supply_new_goods_activity` `fmys_supply_new_goods_activity_record` (<br />
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,<br />
`supply_id` int(11) NOT NULL COMMENT '供应商ID',<br />
`num` smallint(5) UNSIGNED `shop_id` int(11) NOT NULL COMMENT '店铺ID',<br />
`shop_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 0 NULL COMMENT '固定次数',<br '店铺名称',<br />
`prize_num` smallint(5) UNSIGNED `create_time` int(11) NULL DEFAULT NULL COMMENT '报名时间',<br />
`sale_date` int(11) NOT NULL DEFAULT 0 COMMENT '奖励次数',<br '排期时间',<br />
`type` `activity_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '类型{1:新款主推,2:新品扶持}',<br '活动类型{1:新品标杆，2：新品扶持}',<br />
`auto_time` timestamp(0) `status` tinyint(1) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) 1 COMMENT '更新时间',<br '排期状态{1:排期中,2:排期确定}',<br />
PRIMARY KEY (`id`) USING BTREE,<br />
UNIQUE INDEX `idx(supply_id,type)`(`supply_id`, `type`) `supply_id`(`supply_id`) USING BTREE,<br />
INDEX `supply_id`(`supply_id`) `create_time`(`create_time`) USING BTREE<br />
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER 1CHARACTER SET = utf8 COLLATE = utf8_general_ci</p> utf8_general_ci COMMENT = '供应商新品活动报名'</p>
