多表查询

最新推荐文章于 2024-01-04 21:02:58 发布

原创最新推荐文章于 2024-01-04 21:02:58 发布 · 237 阅读

本内容遵循CC 4.0 BY-SA版权协议

$model = new Model();
$list = $model->table('l_project p,l_project_user pu')->where('pu.user_id = '.$_SESSION['id'].' AND p.team_id = '.$_SESSION['team_id'].' AND pu.project_id = p.id')->field('p.name,p.id,p.description')->select();
$this->assign('list',$list);
$team_user_list = M('TeamUser')->where('team_id = '.$_SESSION['team_id'])->field('id,user_id')->select();
$model = new model();
$sql = 'SELECT tu.user_id,tu.id,u.nickname FROM l_team_user AS tu INNER JOIN l_user AS u ON u.id = tu.user_id WHERE tu.user_id != '.$_SESSION['id'].' AND tu.team_id = '.$_SESSION['team_id'];
$team_user_list = $model->query($sql);
$this->assign('team_user_list',$team_user_list);