需求 #23106: 平台运费券业务标签更新 - 一手商城后台优化 - 一手-项目管理

需求 #23106

平台运费券业务标签更新

由张睿张睿在超过 4 年之前添加. 更新于超过 4 年之前.

状态:

已完成

优先级:

高

指派给:

郭翔

目标版本:

开始日期:

2021-02-25

计划完成日期:

% 完成:

100%

预期时间:

(合计: 0.00 小时)

PRD时间:

2021-03-05

移交时间:

2021-03-08

提测时间:

2021-03-10

承诺上线时间:

2021-03-15

实际上线时间:

2021-03-15

截稿时间:

开发时间:

2021-03-09

联调时间:

需求方:

运营

风险评估:

未知

优先级:

开发优先级:

后端开发:

郭翔

跨组后端开发:

CodeReview:

前端开发:

IOS开发:

安卓开发:

测试:

张翠茹

UI:

数据组:

批次(PMO):

数据组完成时间:

描述

背景：当前平台运费券监控体系有待完善，缺失成本监控和权限约束。

目的：通过制定平台运费券权限约束机制完善一手邮费监控体系。

需求：

优惠券分类字段更换

http://192.168.1.244:7777/newOS/23106/#id=xil7l0&p=%E4%BC%98%E6%83%A0%E5%88%B8%E5%88%86%E7%B1%BB%E5%AD%97%E6%AE%B5%E6%9B%B4%E6%8D%A2

前端分支 feature/#23106平台运费券业务标签更新

后端分支 feature/3.9#23106平台运费券业务标签更新

---------------记得改基准时间------------------

PS：详情已上传至附件，有任何疑问请随时沟通

新增字段

ALTER TABLE `yishou`.`fmys_coupon_group_admin`
ADD COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `auto_time`;

新增表 fmys_coupon_freight

CREATE TABLE `fmys_coupon_freight` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名字',
`pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父id',
`create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `pid`(`pid`) USING BTREE,
INDEX `create_time`(`create_time`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠券的部门分类' ROW_FORMAT = Compact;

INSERT INTO `fmys_coupon_freight` VALUES (1, '用户运营部', 0, '2021-03-10 09:33:59', '2021-03-10 09:33:59');
INSERT INTO `fmys_coupon_freight` VALUES (2, '用户服务部', 0, '2021-03-10 09:34:07', '2021-03-10 09:34:07');
INSERT INTO `fmys_coupon_freight` VALUES (3, '用户增长部', 0, '2021-03-10 09:34:11', '2021-03-10 09:34:11');
INSERT INTO `fmys_coupon_freight` VALUES (4, '买手及直播部', 0, '2021-03-10 09:34:14', '2021-03-10 09:34:14');
INSERT INTO `fmys_coupon_freight` VALUES (5, '平台及商家发展事业部', 0, '2021-03-10 09:34:18', '2021-03-10 09:34:18');
INSERT INTO `fmys_coupon_freight` VALUES (6, '产品运营', 1, '2021-03-10 09:34:23', '2021-03-10 09:34:40');
INSERT INTO `fmys_coupon_freight` VALUES (7, '策略创新', 1, '2021-03-10 09:34:26', '2021-03-10 09:34:40');
INSERT INTO `fmys_coupon_freight` VALUES (8, '会员成长', 1, '2021-03-10 09:34:31', '2021-03-10 09:34:40');
INSERT INTO `fmys_coupon_freight` VALUES (9, '社群', 1, '2021-03-10 09:34:35', '2021-03-10 09:34:40');
INSERT INTO `fmys_coupon_freight` VALUES (10, '签到', 6, '2021-03-10 09:34:45', '2021-03-10 09:34:56');
INSERT INTO `fmys_coupon_freight` VALUES (11, 'CRM', 6, '2021-03-10 09:34:45', '2021-03-10 09:34:56');
INSERT INTO `fmys_coupon_freight` VALUES (12, '运费月卡', 7, '2021-03-10 09:34:45', '2021-03-10 09:35:00');
INSERT INTO `fmys_coupon_freight` VALUES (13, '问卷调研', 7, '2021-03-10 09:34:45', '2021-03-10 09:35:00');
INSERT INTO `fmys_coupon_freight` VALUES (14, '活动营销', 7, '2021-03-10 09:34:45', '2021-03-10 09:35:08');
INSERT INTO `fmys_coupon_freight` VALUES (15, '活动营销', 8, '2021-03-10 09:34:45', '2021-03-10 09:35:08');
INSERT INTO `fmys_coupon_freight` VALUES (16, '问卷调研', 8, '2021-03-10 09:34:45', '2021-03-10 09:35:11');
INSERT INTO `fmys_coupon_freight` VALUES (17, '进群福利', 9, '2021-03-10 09:34:45', '2021-03-10 09:35:20');
INSERT INTO `fmys_coupon_freight` VALUES (18, '活动营销', 9, '2021-03-10 09:34:45', '2021-03-10 09:35:15');
INSERT INTO `fmys_coupon_freight` VALUES (19, '安抚维护', 9, '2021-03-10 09:34:45', '2021-03-10 09:35:15');
INSERT INTO `fmys_coupon_freight` VALUES (20, 'VIP', 2, '2021-03-10 09:35:51', '2021-03-10 09:37:30');
INSERT INTO `fmys_coupon_freight` VALUES (21, '在线', 2, '2021-03-10 09:35:51', '2021-03-10 09:37:30');
INSERT INTO `fmys_coupon_freight` VALUES (22, '微信', 2, '2021-03-10 09:35:51', '2021-03-10 09:37:30');
INSERT INTO `fmys_coupon_freight` VALUES (23, '电销', 2, '2021-03-10 09:35:51', '2021-03-10 09:37:30');
INSERT INTO `fmys_coupon_freight` VALUES (24, '业务改善', 2, '2021-03-10 09:35:51', '2021-03-10 09:37:30');
INSERT INTO `fmys_coupon_freight` VALUES (25, '地推', 2, '2021-03-10 09:35:51', '2021-03-10 09:37:30');
INSERT INTO `fmys_coupon_freight` VALUES (26, '用户索要', 20, '2021-03-10 11:39:18', '2021-03-10 11:39:27');
INSERT INTO `fmys_coupon_freight` VALUES (27, '心意赠送', 20, '2021-03-10 11:39:18', '2021-03-10 11:39:27');
INSERT INTO `fmys_coupon_freight` VALUES (28, '售后补偿', 20, '2021-03-10 11:39:18', '2021-03-10 11:39:27');
INSERT INTO `fmys_coupon_freight` VALUES (29, '运费补偿', 20, '2021-03-10 11:39:18', '2021-03-10 11:39:27');
INSERT INTO `fmys_coupon_freight` VALUES (30, '安抚维护', 20, '2021-03-10 11:39:18', '2021-03-10 11:39:27');
INSERT INTO `fmys_coupon_freight` VALUES (31, '问卷调研', 20, '2021-03-10 11:39:18', '2021-03-10 11:39:27');
INSERT INTO `fmys_coupon_freight` VALUES (33, '其他', 21, '2021-03-10 11:39:38', '2021-03-11 18:24:33');
INSERT INTO `fmys_coupon_freight` VALUES (34, '发货/物流', 21, '2021-03-10 11:39:38', '2021-03-11 18:24:31');
INSERT INTO `fmys_coupon_freight` VALUES (35, '活动/差价', 21, '2021-03-10 11:39:38', '2021-03-11 18:24:26');
INSERT INTO `fmys_coupon_freight` VALUES (36, '售后补偿', 21, '2021-03-10 11:39:38', '2021-03-11 18:24:17');
INSERT INTO `fmys_coupon_freight` VALUES (37, '用户索要', 21, '2021-03-10 11:39:38', '2021-03-11 18:24:16');
INSERT INTO `fmys_coupon_freight` VALUES (38, '次品退换', 2, '2021-03-10 11:39:44', '2021-03-11 18:27:49');
INSERT INTO `fmys_coupon_freight` VALUES (39, '新客转化', 22, '2021-03-10 11:39:44', '2021-03-11 18:25:28');
INSERT INTO `fmys_coupon_freight` VALUES (40, '发货/物流', 22, '2021-03-10 11:39:44', '2021-03-11 18:25:23');
INSERT INTO `fmys_coupon_freight` VALUES (41, '活动/差价', 22, '2021-03-10 11:39:44', '2021-03-11 18:25:18');
INSERT INTO `fmys_coupon_freight` VALUES (42, '售后补偿', 22, '2021-03-10 11:39:44', '2021-03-11 18:25:14');
INSERT INTO `fmys_coupon_freight` VALUES (43, '用户索要', 22, '2021-03-10 11:39:44', '2021-03-11 18:25:06');
INSERT INTO `fmys_coupon_freight` VALUES (44, '用户索要', 23, '2021-03-10 11:39:50', '2021-03-10 11:39:50');
INSERT INTO `fmys_coupon_freight` VALUES (45, '心意赠送', 23, '2021-03-10 11:39:50', '2021-03-10 11:39:50');
INSERT INTO `fmys_coupon_freight` VALUES (46, '售后补偿', 23, '2021-03-10 11:39:50', '2021-03-10 11:39:50');
INSERT INTO `fmys_coupon_freight` VALUES (47, '运费补偿', 23, '2021-03-10 11:39:50', '2021-03-10 11:39:50');
INSERT INTO `fmys_coupon_freight` VALUES (48, '安抚维护', 23, '2021-03-10 11:39:50', '2021-03-10 11:39:50');
INSERT INTO `fmys_coupon_freight` VALUES (49, '问卷调研', 23, '2021-03-10 11:39:50', '2021-03-10 11:39:50');
INSERT INTO `fmys_coupon_freight` VALUES (50, '用户索要', 24, '2021-03-10 11:40:00', '2021-03-10 11:40:00');
INSERT INTO `fmys_coupon_freight` VALUES (51, '心意赠送', 24, '2021-03-10 11:40:00', '2021-03-10 11:40:00');
INSERT INTO `fmys_coupon_freight` VALUES (52, '售后补偿', 24, '2021-03-10 11:40:00', '2021-03-10 11:40:00');
INSERT INTO `fmys_coupon_freight` VALUES (53, '运费补偿', 24, '2021-03-10 11:40:00', '2021-03-10 11:40:00');
INSERT INTO `fmys_coupon_freight` VALUES (54, '安抚维护', 24, '2021-03-10 11:40:00', '2021-03-10 11:40:00');
INSERT INTO `fmys_coupon_freight` VALUES (55, '问卷调研', 24, '2021-03-10 11:40:00', '2021-03-10 11:40:00');
INSERT INTO `fmys_coupon_freight` VALUES (56, '首单转化', 25, '2021-03-10 11:51:24', '2021-03-10 11:51:24');
INSERT INTO `fmys_coupon_freight` VALUES (57, '二单转化', 25, '2021-03-10 11:51:24', '2021-03-10 11:51:24');
INSERT INTO `fmys_coupon_freight` VALUES (58, '安抚维护', 25, '2021-03-10 11:51:24', '2021-03-10 11:51:24');
INSERT INTO `fmys_coupon_freight` VALUES (59, '新人首单', 64, '2021-03-10 11:51:31', '2021-03-10 11:52:03');
INSERT INTO `fmys_coupon_freight` VALUES (60, '邀请有奖', 64, '2021-03-10 11:51:31', '2021-03-10 11:52:03');
INSERT INTO `fmys_coupon_freight` VALUES (61, '自动营销', 64, '2021-03-10 11:51:31', '2021-03-10 11:52:03');
INSERT INTO `fmys_coupon_freight` VALUES (62, '支付抽奖', 64, '2021-03-10 11:51:31', '2021-03-10 11:52:03');
INSERT INTO `fmys_coupon_freight` VALUES (63, '活动营销', 64, '2021-03-10 11:51:31', '2021-03-10 11:52:03');
INSERT INTO `fmys_coupon_freight` VALUES (64, '增长运营', 3, '2021-03-10 11:52:00', '2021-03-10 11:52:12');
INSERT INTO `fmys_coupon_freight` VALUES (65, '直播', 4, '2021-03-10 11:52:18', '2021-03-10 11:52:53');
INSERT INTO `fmys_coupon_freight` VALUES (66, '平台运营', 5, '2021-03-10 11:52:19', '2021-03-10 11:53:00');
INSERT INTO `fmys_coupon_freight` VALUES (67, '产品', 5, '2021-03-10 11:52:19', '2021-03-10 11:53:00');
INSERT INTO `fmys_coupon_freight` VALUES (68, '活动营销', 65, '2021-03-10 11:52:19', '2021-03-10 11:53:08');
INSERT INTO `fmys_coupon_freight` VALUES (69, '活动营销', 66, '2021-03-10 11:52:19', '2021-03-10 11:53:10');
INSERT INTO `fmys_coupon_freight` VALUES (70, '档口问答', 67, '2021-03-10 11:53:29', '2021-03-10 11:53:29');
INSERT INTO `fmys_coupon_freight` VALUES (71, '好卖反馈', 67, '2021-03-10 11:53:29', '2021-03-10 11:53:29');
INSERT INTO `fmys_coupon_freight` VALUES (72, '测试', 67, '2021-03-10 11:53:29', '2021-03-10 11:53:29');
INSERT INTO `fmys_coupon_freight` VALUES (73, '寄回补贴', 38, '2021-03-11 18:28:17', '2021-03-11 18:28:17');
INSERT INTO `fmys_coupon_freight` VALUES (74, '其他', 22, '2021-03-12 11:12:24', '2021-03-12 11:12:24');