推荐招聘企业
{get sql="SELECT c.companyname, c.userid, j.title, j.id FROM phpcms_member_company c LEFT JOIN phpcms_yp_job j ON j.userid = c.userid WHERE c.elite = 1 GROUP BY j.userid" rows="12"}
{$r['companyname']}
{/get}最新招聘职位
更多职位>>-
{get sql="SELECT c.companyname, c.userid, j.title, j.id, j.updatetime FROM phpcms_yp_job j LEFT JOIN phpcms_member_company c ON j.userid = c.userid WHERE j.status = '99' ORDER BY j.updatetime DESC" rows="12"}
- {$r['companyname']}{$r['title']}[ {date("Y-m-d",$r['updatetime'])} ] {/get}
最新求职简历
更多简历>>-
{get sql="SELECT a.truename, t.name, a.userid, t.typeid FROM phpcms_yp_apply a LEFT JOIN phpcms_type t ON a.station = t.typeid WHERE a.status = '3' ORDER BY a.addtime DESC" rows="12"}
- {$r['name']}{$r['truename']} {/get}
职位分类列表
{$r['name']}({$r['number']}) |