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

<p>数据部需要重新确定实现方案，该需求暂停开发</p>

<p>与数据沟通对接方案，重新排期</p>

<p>后端分支&nbsp;feature/10.24#21161风格、档次维度的个性化商品投放</p>

<p>环境: dev18</p>

<p>数据组新增字段(弃用)</p>

<p><s><u>ALTER TABLE `yishou`.`fmys_data_user_style`&nbsp;<br />
ADD COLUMN `grade_one` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT &#39;档次top1 {1:高档,2:中高档,3:中档,4:中低档,5:低档,}&#39; ,<br />
ADD COLUMN `grade_two` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT &#39;档次top2 {1:高档,2:中高档,3:中档,4:中低档,5:低档,}&#39;;</u></s></p>

<p>新增数据组表&nbsp;&nbsp;fmys_data_style_grade_score(得分表)&nbsp; &nbsp; &nbsp; fmys_data_style_grade_num(风格对应的日均上架款数)&nbsp; &nbsp;fmys_data_grade_user_style(用户的偏好风格)</p>

<p>新增表&nbsp;fmys_style_grade_activity&nbsp;&nbsp;风格投放活动表&nbsp; &nbsp;&nbsp;fmys_style_grade_goods_lib&nbsp; &nbsp;风格投放商品表&nbsp; &nbsp;fmys_style_grade_user&nbsp; &nbsp;&nbsp;风格投放用户是否参与测试表</p>

<p>联查涉及的表&nbsp; &nbsp;user_region&nbsp; 用户省份表&nbsp; &nbsp;goods_fifteen_data&nbsp; 商品表&nbsp; &nbsp;fmys_data_goods_style&nbsp; &nbsp;商品风格表</p>

<p>&nbsp;</p>

<p>redis缓存&nbsp; &nbsp;grade_style_user_num 连接3 1号库 用于自增缓存num</p>

<p>&nbsp;</p>

<p>修改接口 api/home/get_special_list&nbsp; &nbsp;新增返回字段&nbsp; list_grade&nbsp; &nbsp;详情请查看xdebug&nbsp; (user_id 用 2327465 有数据)</p>

<p>新增接口&nbsp; &#39;api/special/getGradeGoodsLib&nbsp; &nbsp; 风格、档次维度的个性化商品投放-获取h5的商品列表&nbsp; &nbsp;详情请查看xdebug</p>

<p>测试链接http://static.yishouapp.com/app/h5/tests/style-grade/index.html#/?style_name=0&amp;grade_one=1&amp;grade_two=2</p>

<p>正式链接https://static.yishouapp.com/app/h5/production/style-grade/index.html#/?style_name=0&amp;grade_one=1&amp;grade_two=2</p>

<p>预发布链接https://static.yishouapp.com/app/h5/prepublish/style-grade/index.html#/?style_name=0&amp;grade_one=1&amp;grade_two=2</p>

<p>自动任务脚本&nbsp; 每天6点&nbsp; php <p>脚本&nbsp;&nbsp;php think activity -f styleGradeSave&nbsp; &nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>