一手商城需求管理 » 一手APP版本里程碑

api接口

获取品牌/档口 墙 http://xdebug.yishou.com/dist/project-api-list?project_id=2&api_id=2263

相关SQL：

一、王牌档口

统计品牌7天内新款数量：

SELECT `gl`.`supply_id`,COUNT(1) FROM `fmys_goods` `g` INNER JOIN `fmys_special` `s` ON `s`.`special_id`=`g`.`special_id` INNER JOIN `fmys_goods_lib` `gl` ON `gl`.`goods_no`=`g`.`goods_no` INNER JOIN `fmys_goods_ext` `ge` ON `ge`.`goods_id`=g.goods_id AND ge.is_new = 1 WHERE  `s`.`special_period` BETWEEN '1308' AND '1315'   AND `gl`.`supply_id` IN ('529','524')  AND `g`.`is_on_sale` = '1' GROUP BY `gl`.`supply_id`

近7天销量前2位：

SELECT `g`.`goods_no` FROM `fmys_goods` `g` INNER JOIN `fmys_goods_id` `gi` ON `gi`.`goods_id`=`g`.`goods_id` INNER JOIN `fmys_goods_lib` `gl` ON `gl`.`goods_no`=`g`.`goods_no` INNER JOIN `fmys_goods_lib_ext` `gle` ON `gle`.`goods_no`=`g`.`goods_no` LEFT JOIN `fmys_goods_sales` `gs` ON `gs`.`goods_no`=`g`.`goods_no` WHERE  `gl`.`supply_id` = '529'  AND `g`.`goods_status` = '1'  AND `g`.`is_on_sale` = '1'  AND `g`.`is_stockout` = '0'  AND `g`.`is_replenish` IN ('0','2')  AND `g`.`action_value` = '0' GROUP BY `g`.`goods_no` ORDER BY `gle`.`first_sale_period` DESC,`gs`.`real_sales_7` DESC,`g`.`sales_of_7` DESC,`g`.`goods_no` ASC LIMIT 2

好卖评分：

fmys_supply_degree.hot_score

二、口碑品牌

控制选项 “品牌墙-口碑档口id数组”

三、热销单品

SELECT `gl`.`goods_no` FROM `fmys_goods` `g` INNER JOIN `fmys_goods_lib` `gl` ON `gl`.`goods_no`=`g`.`goods_no` INNER JOIN `fmys_special` `s` ON `s`.`special_id`=`g`.`special_id` LEFT JOIN `fmys_goods_brand` `gb` ON `gb`.`brand_id`=`gl`.`brand_id` INNER JOIN `fmys_goods_id` `gi` ON `gi`.`goods_id`=`g`.`goods_id` LEFT JOIN `fmys_goods_sales` `gs` ON `gs`.`goods_no`=`gl`.`goods_no` LEFT JOIN `fmys_data_goods_rank` `dgr` ON `dgr`.`goods_no`=gl.goods_no and dgr.census_time_type=1 WHERE  `g`.`action_value` = '0'  AND `gl`.`supply_id` IN ('72570','11421','14386','8085','7659','3123','7234','12743','3289','10948','13378','212','7400','8222','3013','336','2227','268','11651','1622','1775','561','2315','7218','892','7368','553','11635','8006','72','604','7429','1049','1331','2327291','1252','15758','270','2364','2444','529','524')  AND `g`.`special_status` IN ('2','3')  AND `g`.`goods_status` = '1'  AND `gl`.`goods_status` = '1'  AND `g`.`is_on_sale` = '1'  AND `g`.`is_replenish` IN ('0','2')  AND `g`.`is_stockout` = '0' GROUP BY `gl`.`goods_no` ORDER BY `dgr`.`amount` DESC,`g`.`real_sales` DESC,`g`.`goods_id` DESC LIMIT 0,45

四、七日新款

SELECT `g`.`goods_no` FROM `fmys_goods` `g` INNER JOIN `fmys_goods_lib` `gl` ON `gl`.`goods_no`=`g`.`goods_no` INNER JOIN `fmys_special` `s` ON `s`.`special_id`=`g`.`special_id` INNER JOIN `fmys_goods_ext` `ge` ON `ge`.`goods_id`=g.goods_id AND ge.is_new = 1 WHERE  `gl`.`supply_id` IN ('72570','11421','14386','8085','7659','3123','7234','12743','3289','10948','13378','212','7400','8222','3013','336','2227','268','11651','1622','1775','561','2315','7218','892','7368','553','11635','8006','72','604','7429','1049','1331','2327291','1252','15758','270','2364','2444','529','524')  AND `s`.`special_period` BETWEEN '1308' AND '1315'   AND `g`.`special_status` IN ('2','3')  AND `g`.`is_on_sale` = '1'  AND `g`.`is_stockout` = '0'  AND `g`.`goods_status` = '1'  AND `gl`.`goods_status` = '1'  AND `g`.`is_replenish` IN ('0','2')  AND `g`.`action_value` = '0' GROUP BY `g`.`goods_no` ORDER BY `g`.`add_time` DESC LIMIT 45

五、销冠品牌

SELECT sum(amount) as total_amount, supply_id FROM `fmys_data_supply_daily` WHERE  `special_start_time` >= '2019-12-26 00:00:00' GROUP BY `supply_id` ORDER BY `total_amount` DESC LIMIT 48

六、档口榜单

前三榜单：

SELECT dec.category_id as example_id, dec.category_name as example_name, sum(dmsr.shuandan_7_day_sales) as shuandan_7_day_sales FROM `fmys_data_example_category` `dec` INNER JOIN `fmys_example_supply` `es` ON `es`.`market_id`=0 and dec.category_id = es.cat_id INNER JOIN `fmys_data_market_supply_rank` `dmsr` ON `es`.`supply_id`=`dmsr`.`supply_id` GROUP BY `dec`.`category_id` ORDER BY `shuandan_7_day_sales` DESC LIMIT 3

分类档口：

SELECT `supply_id` FROM `fmys_example_supply` WHERE  `cat_id` = 297  AND `market_id` = 0 ORDER BY `rank` DESC LIMIT 30