需求 #11259
由 陈泽富 更新于 超过 5 年 之前
<p>榜单首页接口 <a href="http://xdebug.yishou.com/dist/project-api-list?project_id=2&api_id=2592">http://xdebug.yishou.com/dist/project-api-list?project_id=2&api_id=2592</a></p>
<p>榜单列表接口 <a href="http://xdebug.yishou.com/dist/project-api-list?project_id=2&api_id=2593">http://xdebug.yishou.com/dist/project-api-list?project_id=2&api_id=2593</a></p>
<p>新增数据表</p>
<p>fmys_example_category</p>
<p>fmys_example_must</p>
<p>fmys_example_popularity</p>
<p>fmys_example_replenish</p>
<p>新增字段</p>
<p>fmys_supply fans粉丝数</p>
<p> </p>
<p>人气档口取数SQL</p>
<p>1.用户类型3 （5级以上没有下单）</p>
<p>3SELECT `s`.`fans`,`s`.`supply_id`,`s`.`supply_name`,`s`.`picture`,`sd`.`48_allot_score`,(IFNULL(sd.hot_score, 0) * 0.2 + IFNULL(s.fans, 0) * 0.3 + IFNULL(dmsr.7_day_sales, 0) * 0.2) as rank FROM fmys_supply s LEFT JOIN `fmys_data_market_supply_rank` `dmsr` ON `dmsr`.`supply_id`=`s`.`supply_id` LEFT JOIN `fmys_supply_degree` `sd` ON `s`.`supply_id`=`sd`.`supply_id` WHERE `supply_status` = 1 GROUP BY `supply_id` ORDER BY `rank` DESC,`dmsr`.`7_day_sales` DESC,`s`.`fans` DESC LIMIT 10</p>
<p>2用户类型4（5级以上有下单）</p>
<p>SELECT `s`.`fans`,`s`.`supply_id`,`s`.`supply_name`,`s`.`picture`,`sd`.`48_allot_score`,(IFNULL(dmsr.7_day_sales, 0) * 0.5 + IFNULL(s.fans, 0) * 0.5 ) as rank FROM fmys_supply s LEFT JOIN `fmys_data_market_supply_rank` `dmsr` ON `dmsr`.`supply_id`=`s`.`supply_id` LEFT JOIN `fmys_supply_degree` `sd` ON `s`.`supply_id`=`sd`.`supply_id` WHERE `supply_status` = 1 GROUP BY `supply_id` ORDER BY `rank` DESC,`dmsr`.`7_day_sales` DESC,`s`.`fans` DESC LIMIT 10</p>
<p>3默认类型</p>
<p>SELECT (IFNULL(sd.hot_score, 0) * 0.3 + IFNULL(sd.48_allot_score, 0) * 0.5 + IFNULL(dmsr.7_day_sales, 0) * 0.2) as , <p>SELECT `s`.`fans`,`s`.`supply_id`,`s`.`supply_name`,`s`.`picture`,`sd`.`48_allot_score` FROM fmys_supply s LEFT JOIN `fmys_data_market_supply_rank` `dmsr` ON `dmsr`.`supply_id`=`s`.`supply_id` LEFT JOIN `fmys_supply_degree` `sd` ON `s`.`supply_id`=`sd`.`supply_id` WHERE `supply_status` = 1 GROUP BY `supply_id` ORDER BY `rank` DESC,`sd`.`48_allot_score` DESC,`s`.`fans` DESC LIMIT 10</p>
<p>榜单列表接口 <a href="http://xdebug.yishou.com/dist/project-api-list?project_id=2&api_id=2593">http://xdebug.yishou.com/dist/project-api-list?project_id=2&api_id=2593</a></p>
<p>新增数据表</p>
<p>fmys_example_category</p>
<p>fmys_example_must</p>
<p>fmys_example_popularity</p>
<p>fmys_example_replenish</p>
<p>新增字段</p>
<p>fmys_supply fans粉丝数</p>
<p> </p>
<p>人气档口取数SQL</p>
<p>1.用户类型3 （5级以上没有下单）</p>
<p>3SELECT `s`.`fans`,`s`.`supply_id`,`s`.`supply_name`,`s`.`picture`,`sd`.`48_allot_score`,(IFNULL(sd.hot_score, 0) * 0.2 + IFNULL(s.fans, 0) * 0.3 + IFNULL(dmsr.7_day_sales, 0) * 0.2) as rank FROM fmys_supply s LEFT JOIN `fmys_data_market_supply_rank` `dmsr` ON `dmsr`.`supply_id`=`s`.`supply_id` LEFT JOIN `fmys_supply_degree` `sd` ON `s`.`supply_id`=`sd`.`supply_id` WHERE `supply_status` = 1 GROUP BY `supply_id` ORDER BY `rank` DESC,`dmsr`.`7_day_sales` DESC,`s`.`fans` DESC LIMIT 10</p>
<p>2用户类型4（5级以上有下单）</p>
<p>SELECT `s`.`fans`,`s`.`supply_id`,`s`.`supply_name`,`s`.`picture`,`sd`.`48_allot_score`,(IFNULL(dmsr.7_day_sales, 0) * 0.5 + IFNULL(s.fans, 0) * 0.5 ) as rank FROM fmys_supply s LEFT JOIN `fmys_data_market_supply_rank` `dmsr` ON `dmsr`.`supply_id`=`s`.`supply_id` LEFT JOIN `fmys_supply_degree` `sd` ON `s`.`supply_id`=`sd`.`supply_id` WHERE `supply_status` = 1 GROUP BY `supply_id` ORDER BY `rank` DESC,`dmsr`.`7_day_sales` DESC,`s`.`fans` DESC LIMIT 10</p>
<p>3默认类型</p>
<p>SELECT (IFNULL(sd.hot_score, 0) * 0.3 + IFNULL(sd.48_allot_score, 0) * 0.5 + IFNULL(dmsr.7_day_sales, 0) * 0.2) as , <p>SELECT `s`.`fans`,`s`.`supply_id`,`s`.`supply_name`,`s`.`picture`,`sd`.`48_allot_score` FROM fmys_supply s LEFT JOIN `fmys_data_market_supply_rank` `dmsr` ON `dmsr`.`supply_id`=`s`.`supply_id` LEFT JOIN `fmys_supply_degree` `sd` ON `s`.`supply_id`=`sd`.`supply_id` WHERE `supply_status` = 1 GROUP BY `supply_id` ORDER BY `rank` DESC,`sd`.`48_allot_score` DESC,`s`.`fans` DESC LIMIT 10</p>
