- 最新加盟
- 推荐企业
-
{get sql="SELECT userid,companyname,sitedomain FROM `phpcms_member_company` WHERE status = 1 ORDER BY userid DESC" rows="7"}
{if $r[companyname]}
- {str_cut($r[companyname],26,'..')} {/if} {/get}
- 产品分类
- 行业分类
商机
-
{get sql="SELECT id,title,updatetime FROM `phpcms_yp_buy` WHERE tid = 1 AND status = 99 ORDER BY id DESC" rows="10"}
- {date("m.d",$r['updatetime'])}{str_cut($r['title'],30)} {/get}
人才
更多 企业招聘
-
{get sql="SELECT j.id,j.title,j.userid,c.companyname FROM `phpcms_yp_job` `j`,`phpcms_member_company` `c` WHERE c.userid = j.userid AND j.status = 99 ORDER BY id DESC" rows="10"}
- {str_cut($r[title],20)} [ {str_cut($r[companyname],20)} ] {/get}
更多 个人求职
-
{get sql="SELECT a.applyid,a.truename,t.name,t.typeid FROM `phpcms_yp_apply` `a`,`phpcms_type` `t` WHERE t.module = 'yp' AND t.typeid = a.station AND a.status = 3 ORDER BY applyid DESC" rows="10"}
- {$r[truename]} [ {$r[name]} ] {/get}
最新资讯
-
{get sql="SELECT id,title FROM `phpcms_yp_news` WHERE status = 99 ORDER BY id DESC" rows="10"}
- {str_cut($r[title],30,'')} {/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.status = 99 ORDER BY id DESC" rows="10"}
- {str_cut($r['title'],20,'')} {str_cut($r['companyname'],20,'')} {/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.status = 99 AND p.elite = 1 ORDER BY id DESC" rows="10"}
- {str_cut($r['title'],20)}{str_cut($r['companyname'],20,'')} {/get}