项目

一般

简介

需求 #11705

叶振鹏 更新于 超过 5 年 之前

<p>相关接口:</p>

<p>api/supplier/search_follow_supply&nbsp;<a href="http://xdebug.yishou.com/dist/project-api-list?project_id=2&amp;api_id=2665">http://xdebug.yishou.com/dist/project-api-list?project_id=2&amp;api_id=2665</a></p>

<p>档口名称展示逻辑</p>

<p>SELECT<br />
&nbsp;&nbsp; &nbsp;`s`.`supply_id` ,<br />
&nbsp;&nbsp; &nbsp;`gb`.`brand_name` ,<br />
&nbsp;&nbsp; &nbsp;m2.market_id AS one_market_id ,<br />
&nbsp;&nbsp; &nbsp;m.market_nikename AS nickname<br />
FROM<br />
&nbsp;&nbsp; &nbsp;`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 />
&nbsp;&nbsp; &nbsp;`s`.`supply_id` IN(72576)</p>

<p>先判断brand_name,有就直接展示</p>

<p>再判断one_market_id是否在187,186,119,145市场id里,是就展示&quot;高端独家货源&quot;</p>

<p>都没有就展示&nbsp;nickname + &lsquo;实力品牌&rsquo;</p>

返回

从剪贴板添加图片 (最大尺寸: 50.8 MB)