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

<p>PRD：http://192.168.1.244:7777/newOS/22756/</p>

<p>&nbsp;</p>

<p>相关需求：众唛外呼的调研 http://14.29.126.108:30001/issues/22111\</p>

<p>Apollo goods服务新增&nbsp;</p>

<p>dataDB goods服务新增&nbsp;dataDB ,&nbsp;dataDB.pool</p>

<p>goods_status = {&quot;1&quot;:&quot;正常&quot;,&quot;2&quot;:&quot;断货&quot;}<br />
is_on_sale = {&quot;0&quot;:&quot;下架&quot;,&quot;1&quot;:&quot;断货&quot;}<br />
goods_in_stock = {&quot;0&quot;:&quot;预售&quot;,&quot;1&quot;:&quot;现货&quot;}</p>

<p>apollo&nbsp; 工单服务新增&nbsp;&nbsp;redis5db8&nbsp; &nbsp;redis.pool5db8&nbsp;</p>

<p><br />
to 前端:&nbsp;设置外呼选项,用户类型,建议提供的政策在&nbsp; os/Common/getConfig里面的 data.relCallRecordOption 后端os分支:&nbsp;feature/2.1#22756电销CRM&nbsp;</p>

<p>to 前端: 接口文档&nbsp;http://yapi.yishou.com/project/85/interface/api/cat_1763 (工单服务接口)</p>

<p>to 前端: 接口文档&nbsp;http://xdebug.yishou.com/dist/project-api-list?project_id=1&amp;api_id=8022&nbsp; (CRM商品推送接口)</p>

<p>后端os分支:&nbsp;feature/2.1#22756电销CRM</p>

<p>前端os分支:feature/22756-电销crm</p>

<p>dev18</p>

<p>后端工单服务, 商品服务 gateway服务 的分支&nbsp; feature/2.1TeleCRM22756</p>

<p>相关数据表:yishou库：users,user_profile,</p>

<p>yishou_data库：data_tele_marketing</p>

<p>yishou_service_order库：tele_marketing_artificial，tele_marketing_log</p>

<p>CREATE TABLE `fmys_tele_user_info` (<br />
&nbsp; `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT &#39;id&#39;,<br />
&nbsp; `user_id` int(11) unsigned NOT NULL COMMENT &#39;用户user_id&#39;,<br />
&nbsp; `name` varchar(255) NOT NULL DEFAULT &#39;&#39; COMMENT &#39;姓名&#39;,<br />
&nbsp; `call_user_type` varchar(32) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;外呼类型的id (enum表的)&#39;,<br />
&nbsp; `call_type` varchar(32) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;用户类型的id (enum表的)&#39;,<br />
&nbsp; `policy` varchar(32) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;建议政策的id (enum表的)&#39;,<br />
&nbsp; `identity_type` varchar(16) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;身份类型 1:实体店店主,2:微商,3:网商,4:批发商,5:个人自用,6:其他&#39;,<br />
&nbsp; `reason` varchar(16) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;不满意一手原因 1.款式不好/少/不合适 2. 排单 3.发货慢 4.断货 5.价格贵&#39;,<br />
&nbsp; `remarks` varchar(512) NOT NULL DEFAULT &#39;&#39; COMMENT &#39;备注&#39;,<br />
&nbsp; `sex` varchar(16) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;性别 1男 2女&#39;,<br />
&nbsp; `experience_year` varchar(16) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;经验年限 1 新手店主、2=&gt;1-2年、3=&gt;2-3年、4=&gt;3-5年、5=&gt;5-10年、6=&gt;10年以上&#39;,<br />
&nbsp; `province` varchar(16) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;省份id &nbsp; fmys_region表&#39;,<br />
&nbsp; `city` varchar(16) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;城市id，fmys_region表&#39;,<br />
&nbsp; `money_sales` varchar(16) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;月销售额，1=&gt;5000以下、2=&gt;5000-1W、3=&gt;1W-3W、4=&gt;3W-5W 、5=&gt;5W-10W、6=&gt;10W以上&#39;,<br />
&nbsp; `experience_type` varchar(16) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;.经验模式，1=&gt;实体店、2=&gt;网店、3=&gt;微商、4=&gt;实体+网店、5=&gt;实体+微商、6=&gt;实体+网店+微商&#39;,<br />
&nbsp; `shop_position` varchar(16) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;店铺位置，1=&gt;商城、2=&gt;社区、3=&gt;步行街&#39;,<br />
&nbsp; PRIMARY KEY (`id`),<br />
&nbsp; KEY `user_id` (`user_id`)<br />
) ENGINE=InnoDB&nbsp; DEFAULT CHARSET=utf8 COMMENT=&#39;CRM 用户信息表&#39;;</p>

<p>&nbsp;</p>

<p>CREATE TABLE `fmys_tele_push` (<br />
&nbsp; `id` int(10) unsigned NOT NULL AUTO_INCREMENT,<br />
&nbsp; `goods_no` int(11) unsigned NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;商品货号&#39;,<br />
&nbsp; `user_id` int(11) unsigned NOT NULL COMMENT &#39;用户id&#39;,<br />
&nbsp; `time` int(11) NOT NULL COMMENT &#39;日期(早上0点时间戳)&#39;,<br />
&nbsp; `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT &#39;创建时间&#39;,<br />
&nbsp; PRIMARY KEY (`id`),<br />
&nbsp; KEY `user_id` (`user_id`,`goods_no`,`time`)<br />
) ENGINE=InnoDB&nbsp; DEFAULT CHARSET=utf8;</p>