需求 #11705
<p>相关接口:</p>
<p>api/supplier/search_follow_supply <a href="http://xdebug.yishou.com/dist/project-api-list?project_id=2&api_id=2665">http://xdebug.yishou.com/dist/project-api-list?project_id=2&api_id=2665</a></p>
<p>档口名称展示逻辑</p>
<p>SELECT<br />
`s`.`supply_id` ,<br />
`gb`.`brand_name` ,<br />
m2.market_id AS one_market_id ,<br />
m.market_nikename AS nickname<br />
FROM<br />
`fmys_supply` `s`<br />
LEFT JOIN `fmys_supply_brand` `sb` ON `sb`.`supply_id` = s.supply_id<br />
AND sb.is_main = 1<br />
LEFT JOIN `fmys_goods_brand` `gb` ON `sb`.`brand_id` = gb.brand_id<br />
AND s.is_show_brand = 1<br />
INNER JOIN `fmys_market` `m` ON `m`.`market_id` = `s`.`market_id`<br />
INNER JOIN `fmys_market` `m2` ON `m`.`parent_id` = `m2`.`market_id`<br />
WHERE<br />
`s`.`supply_id` IN(72576)</p>
<p>先判断brand_name,有就直接展示</p>
<p>再判断one_market_id是否在187,186,119,145市场id里,是就展示"高端独家货源"</p>
<p>都没有就展示 nickname + ‘实力品牌’</p>
<p>api/supplier/search_follow_supply <a href="http://xdebug.yishou.com/dist/project-api-list?project_id=2&api_id=2665">http://xdebug.yishou.com/dist/project-api-list?project_id=2&api_id=2665</a></p>
<p>档口名称展示逻辑</p>
<p>SELECT<br />
`s`.`supply_id` ,<br />
`gb`.`brand_name` ,<br />
m2.market_id AS one_market_id ,<br />
m.market_nikename AS nickname<br />
FROM<br />
`fmys_supply` `s`<br />
LEFT JOIN `fmys_supply_brand` `sb` ON `sb`.`supply_id` = s.supply_id<br />
AND sb.is_main = 1<br />
LEFT JOIN `fmys_goods_brand` `gb` ON `sb`.`brand_id` = gb.brand_id<br />
AND s.is_show_brand = 1<br />
INNER JOIN `fmys_market` `m` ON `m`.`market_id` = `s`.`market_id`<br />
INNER JOIN `fmys_market` `m2` ON `m`.`parent_id` = `m2`.`market_id`<br />
WHERE<br />
`s`.`supply_id` IN(72576)</p>
<p>先判断brand_name,有就直接展示</p>
<p>再判断one_market_id是否在187,186,119,145市场id里,是就展示"高端独家货源"</p>
<p>都没有就展示 nickname + ‘实力品牌’</p>