/** * 扩展查询,用于获取学生综合成绩对应的补考成绩 * @author FuRongxin * @date 2016-01-26 * @version 2.0 * @param \Illuminate\Database\Eloquent\Builder $query 查询对象 * @param object $user 用户对象 * @param string $kch 8位课程号 * @return \Illuminate\Database\Eloquent\Builder 查询对象 */ public function scopeMakeupScore($query, $user, $kch) { $lstKcxh = Task::whereKch($kch)->distinct('kcxh')->lists('kcxh'); // 提交状态为3的成绩方可显示 return $query->whereXh($user->xh)->whereIn('kcxh', $lstKcxh)->whereTjzt(config('constants.score.dconfirmed')); }