需求 #11705
收藏-档口新增搜索
开始日期:
2019-10-11
计划完成日期:
% 完成:
100%
预期时间:
2.00 小时
描述
相关接口:
api/supplier/search_follow_supply http://xdebug.yishou.com/dist/project-api-list?project_id=2&api_id=2665
档口名称展示逻辑
SELECT
`s`.`supply_id` ,
`gb`.`brand_name` ,
m2.market_id AS one_market_id ,
m.market_nikename AS nickname
FROM
`fmys_supply` `s`
LEFT JOIN `fmys_supply_brand` `sb` ON `sb`.`supply_id` = s.supply_id
AND sb.is_main = 1
LEFT JOIN `fmys_goods_brand` `gb` ON `sb`.`brand_id` = gb.brand_id
AND s.is_show_brand = 1
INNER JOIN `fmys_market` `m` ON `m`.`market_id` = `s`.`market_id`
INNER JOIN `fmys_market` `m2` ON `m`.`parent_id` = `m2`.`market_id`
WHERE
`s`.`supply_id` IN(72576)
先判断brand_name,有就直接展示
再判断one_market_id是否在187,186,119,145市场id里,是就展示"高端独家货源"
都没有就展示 nickname + ‘实力品牌’