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; } }