Example #1
0
 /**
  * 扩展查询,用于获取学生综合成绩对应的补考成绩
  * @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'));
 }