公司信息
公司类型
所在地
{get sql="SELECT DISTINCT c.* FROM `phpcms_member_company` `c`,`phpcms_yp_relation` `r` WHERE $where" rows="20" distinctfield="\c.userid" page="$page" urlrule="$M[url]company.php?action=searchlist&areaname=$areaname&catid=$catid&genre=$genre&q=$q|$M[url]company.php?action=searchlist&areaname=$areaname&catid=$catid&genre=$genre&q=$q&page=\\$page"}
- {$r[companyname]}
{$r['genre']}{$r[areaname]}
- 公司简介:{str_cut($r['introduce'],120)}
- 主营:{substr($r['catids'],1,-1)}
{$pages}
产品库大类列表
-
{get sql="SELECT catname,catid FROM `phpcms_category` WHERE module = 'yp' AND parentid = '0' ORDER BY listorder ASC"}
- {$r['catname']} {/get}
浏览过的产品
-
{if $prowhere}
{get sql="SELECT id,title,thumb FROM `phpcms_yp_product` WHERE id IN ($prowhere) ORDER BY FIND_IN_SET(id,'$prowhere')" rows="10"}
{$r['title']}
{/get}
{else}
- 您还没有浏览过任何商品 {/if}
最新产品
-
{get sql="SELECT p.id,p.title,p.thumb,c.companyname,p.userid FROM `phpcms_yp_product` `p`,`phpcms_member_company` `c` WHERE c.userid = p.userid ORDER BY id DESC" rows="10"}
-
{str_cut($r['title'],20,'')} {$r['companyname']}
{/get}
推荐产品
-
{get sql="SELECT p.id,p.title,p.thumb,c.companyname,p.userid FROM `phpcms_yp_product` `p`,`phpcms_member_company` `c` WHERE c.userid = p.userid AND p.elite = 1 ORDER BY id DESC" rows="10"}
{str_cut($r['title'],20,'')}{$r['companyname']}
{/get}