$data = Db::table('shejishi')->field('name,headimg,jibie,linian,zizhi,nianxian,fengge,zuopin,click')->where('id', $id)->find();
// 作品数量
$data['count'] = Db::table('anli')->where(['sjs' => $data['name']])->count();
// 代表作品
$zuopin = Db::table('anli')->alias('a')
->field('a.id,a.title,a.litpic,a.mianji,a.xiaoqu,s.name,s.headimg,a.huxing,a.fengge,a.click')
->join('(shejishi s)','a.sjs = s.name','left')
->where('a.sjs',$data['name'])
->order('id desc')
->select();
$this->assign('data', $data);
$this->assign('zuopin', $zuopin);
return $this->fetch('/info_sjs');
}
/*
* 热门楼盘