一手商城需求管理 » 一手商城后台优化

<p><span style="font-size:14px;"><span style="color:#e74c3c;">大数据7月24日上线</span></span></p>

<p>&nbsp;http://192.168.1.244:7777/newOS/24728/#id=e2qc27&amp;p=%E7%94%B5%E9%94%80%E6%95%B0%E6%8D%AE%E8%AF%B4%E6%98%8E</p>

<p>&nbsp;</p>

<p>前端分支：feature/24728-电销新增实时数据名单</p> <p>&nbsp;</p>

<p>to 开发、测试：</p>

<p><br />
上线当天/前一天，一定要让大数据开发先上线，确保上线有数据，可以立刻发现问题。</p>

<p>&nbsp;</p>

<p>-格鲁特</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>开发分支：</p>

<p>工单服务:feature/071224728crmlist&nbsp; &nbsp; &nbsp; dev1</p>

<p>api:feature/0714#24728电销新增实时数据名单</p>

<p>DDL:</p>

<p>&nbsp; ALTER TABLE `yishou_data`.`data_tele_marketing` MODIFY COLUMN &nbsp;`user_type` tinyint(1) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;用户类型 1：昨天注册未激活 &nbsp;2：首二单 3：预流失 4：流失 5：今天+昨天注册名单（实时）&#39;;</p>

<p>&nbsp;ALTER TABLE `yishou_data`.`data_tele_marketing` ADD COLUMN &nbsp; `open_time` int NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;打开时间&#39;;</p>

<p>&nbsp; ALTER TABLE `yishou_service_order`.`zhongmai_mission` MODIFY COLUMN `from` tinyint NOT NULL DEFAULT &#39;1&#39; COMMENT &#39;类型{1:筛选取号,2:导入取号,3:流失,4:预流失,5:首二单,6:昨天+今天注册名单（实时）}&#39;;</p>

<p>&nbsp; ALTER TABLE&nbsp;&nbsp;`yishou_service_order`.`zhongmai_mission` ADD&nbsp;COLUMN `reg_time_set` int NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;注册时间筛选&#39;;</p>

<p>CREATE TABLE `data_tele_marketing_real_time` (<br />
&nbsp; `id` int unsigned NOT NULL AUTO_INCREMENT,<br />
&nbsp; `user_id` int NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;用户ID&#39;,<br />
&nbsp; `user_type` tinyint(1) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;用户类型 1：昨天注册未激活 &nbsp;2：首二单 3：预流失 4：流失 5：今天+昨天注册名单（实时）&#39;,<br />
&nbsp; `open_time` int NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;打开时间&#39;,<br />
&nbsp; `start_time` int NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;开始时间&#39;,<br />
&nbsp; `end_time` int NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;结束时间&#39;,<br />
&nbsp; `update_time` int NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;更新时间&#39;,<br />
&nbsp; `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT &#39;创建时间&#39;,<br />
&nbsp; PRIMARY KEY (`id`),<br />
&nbsp; KEY `idx_user_type` (`user_type`),<br />
&nbsp; KEY `user_id` (`user_id`)<br />
) ENGINE=InnoDB &nbsp;DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT=&#39;电销用户实时打开情况&#39;;</p>

<p>接口：</p>

<p>（修改）获取自动外呼名单列表展示数据&nbsp; &nbsp;http://yapi.yishou.com/project/85/interface/api/15053</p>

<p>（修改）自动外呼任务绑定保存&nbsp; &nbsp;&nbsp;http://yapi.yishou.com/project/85/interface/api/15044</p>

<p>脚本：</p>

<p>实时生成电销用户数据&nbsp;&nbsp;php think user -f buildCrmUserData&nbsp; 每半小时一次&nbsp; 30分 00分 各一次&nbsp; &nbsp; &nbsp;首次手动执行加参数&nbsp; -p 1</p>