public function index()
{
if (self::isLogin()) {
$about = new Platform();
$new = $about->all();
return view('admin/home', compact('new'), 'baseAdmin');
}
return view('admin/login', '', 'noBase');
}
/**
* 扩展查询，用于获取课程类型相应课程的课程列表
* @author FuRongxin
* @date 2016-06-21
* @version 2.1
* @param \Illuminate\Database\Eloquent\Builder $query 查询对象
* @param string $type 课程类型
* @return \Illuminate\Database\Eloquent\Builder 查询对象
*/
public function scopeOfType($query, $type)
{
switch ($type) {
case 'public':
// 2016-06-21：应教务处要求修改为只显示社科类课程（TB15开头）
return $query->where('pk_kczy.pt', '=', 'T')->where('pk_kczy.xz', '=', 'B')->where('pk_kczy.nj', '=', session('grade'))->where('pk_kczy.zy', '=', session('major'))->where('pk_kczy.kcxh', 'like', 'TB15%');
case 'require':
$platforms = array_pluck(Platform::all()->toArray(), 'dm');
unset($platforms[array_search('T', $platforms)]);
return $query->whereIn('pk_kczy.pt', $platforms)->where('pk_kczy.xz', '=', 'B')->where('pk_kczy.nj', '=', session('grade'))->where('pk_kczy.zy', '=', session('major'));
case 'elect':
return $query->where('pk_kczy.xz', '=', 'X')->where('pk_kczy.nj', '=', session('grade'))->where('pk_kczy.zy', '=', session('major'));
case 'human':
return $query->where('pk_kczy.pt', '=', 'T')->where('pk_kczy.xz', '=', 'W');
case 'nature':
return $query->where('pk_kczy.pt', '=', 'T')->where('pk_kczy.xz', '=', 'I');
case 'art':
return $query->where('pk_kczy.pt', '=', 'T')->where('pk_kczy.xz', '=', 'Y');
case 'other':
return $query->where('pk_kczy.pt', '=', 'T')->where('pk_kczy.xz', '=', 'Q');
case 'pubsport':
return $query->where('pk_kczy.pt', '=', 'T')->where('pk_kczy.xz', '=', 'B')->where('pk_kczy.nj', '=', session('grade'))->where('pk_kczy.zy', '=', session('major'))->where('pk_kczy.kcxh', 'like', 'TB14%');
default:
break;
}
}
/**
* 扩展查询：用于获取课程类型相应课程的课程列表
* @author FuRongxin
* @date 2016-03-02
* @version 2.0
* @param \Illuminate\Database\Eloquent\Builder $query 查询对象
* @param string $type 课程类型
* @return \Illuminate\Database\Eloquent\Builder 查询对象
*/
public function scopeOfType($query, $type)
{
switch ($type) {
case 'public':
return $query->where('xk_xkxx.pt', '=', 'T')->where('xk_xkxx.xz', '=', 'B');
case 'require':
$platforms = array_pluck(Platform::all()->toArray(), 'dm');
unset($platforms[array_search('T', $platforms)]);
return $query->whereIn('xk_xkxx.pt', $platforms)->where('xk_xkxx.xz', '=', 'B');
case 'elect':
return $query->where('xk_xkxx.xz', '=', 'X');
case 'human':
case 'nature':
case 'art':
case 'other':
return $query->where('xk_xkxx.pt', '=', 'T')->whereIn('xk_xkxx.xz', ['W', 'I', 'Y', 'Q']);
case 'pubsport':
return $query->where('xk_xkxx.pt', '=', 'T')->where('xk_xkxx.xz', '=', 'B')->where('xk_xkxx.kcxh', 'like', 'TB14%');
default:
break;
}
}
