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

<p>&nbsp;http://192.168.1.244:7777/newOS/24635/#id=kt1gg1&amp;p=%E4%BA%8C%E6%AC%A1%E6%8B%A8%E6%89%93%E5%90%8D%E5%8D%95</p>

<p>&nbsp;</p>

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

<p>工单服务：feature/062224635telsecondpolicy</p>

<p>DDL：</p>

<p>ALTER TABLE `yishou`.`fmys_tele_user_info` ADD COLUMN &nbsp; `tip_time` int(11) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;提醒时间&#39;;<br />
ALTER TABLE `yishou`.`fmys_tele_user_info` ADD INDEX `tip_time` (`tip_time`) USING BTREE;</p>

<p>CREATE TABLE `tele_marketing_recall` (<br />
&nbsp; `id` int(10) unsigned NOT NULL AUTO_INCREMENT,<br />
&nbsp; `tm_id` int(10) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;关联tele_marketing_artificial表&#39;,<br />
&nbsp; `remind_time` int(10) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;提醒时间&#39;,<br />
&nbsp; `if_called` tinyint(3) NOT NULL DEFAULT &#39;2&#39; COMMENT &#39;是否已拨打{1:是,2:否,}&#39;,<br />
&nbsp; `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT &#39;创建时间&#39;,<br />
&nbsp; PRIMARY KEY (`id`),<br />
&nbsp; KEY `tm_id` (`tm_id`)<br />
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=&#39;二次拨打表&#39;;</p>

<p>ALTER TABLE `yishou_service_order`.`tele_marketing_log`&nbsp;<br />
ADD COLUMN &nbsp;`call_times` int(11) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;拨打时长&#39;;</p>

<p>AlTER TABLE `yishou_service_order`.`tele_marketing_log` ADD INDEX &nbsp;call_times (`call_times`);</p>

<p>接口：</p>

<p>保存外呼用户信息接口： http://yapi.yishou.com/project/85/interface/api/12094<br />
serviceOrder/saveCrmTeleUserInfo&nbsp; 增加传参&nbsp; second_call (1:选中 0：未选中)&nbsp; tip_time 设置提醒时间&nbsp;</p>

<p>外呼用户池接口：&nbsp;http://yapi.yishou.com/project/85/interface/api/12022<br />
serviceOrder/telemarketingList&nbsp; 增加返回字段 data-&gt;list-&gt;call_time&nbsp; 外呼时间&nbsp; data-&gt;list-&gt;tip_time 提醒时间&nbsp; data-&gt;top_data-&gt;secondcall 二次拨打名单</p>

<p>外呼记录接口：&nbsp;http://yapi.yishou.com/project/85/interface/api/14990<br />
serviceOrder/getCrmCallList&nbsp; 增加返回字段 data-&gt;list-&gt;call_method&nbsp; 外呼方式&nbsp; data-&gt;list-&gt;call_times 外呼时长&nbsp; data-&gt;list-&gt;mission_type&nbsp;名单类型</p>

<p>外呼完成接口：&nbsp;http://yapi.yishou.com/project/85/interface/api/12038<br />
serviceOrder/doneTele&nbsp; 增加参数&nbsp; times 通话时长(s)</p>