12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758 |
- <?php
- namespace App\Http\Controllers;
- use App\Models\Basic;
- use App\Models\Course;
- use App\Models\Enroll;
- use App\Models\User;
- use Carbon\Carbon;
- use Illuminate\Http\Request;
- use Illuminate\Support\Facades\Auth;
- use Illuminate\Support\Facades\Validator;
- class CourseController extends Controller{
- //课程列表
- public function course_list(Request $request){
- $inputData = $request->only(['page', 'page_size', 'week', 'season']);
- $messages = [
- 'required'=>':attribute为必填项',
- 'int'=>':attribute参数类型错误',
- 'max'=>':attribute长度不得超过 :size',
- ];
- $validator = Validator::make($inputData, [
- 'page' => 'required|int',
- 'page_size' => 'required|int',
- 'week' => 'required|int',
- 'season' => 'required|int',
- ], $messages,[
- 'page'=>'页码',
- 'page_size'=>'大小',
- 'week'=>'第几周',
- 'season'=>'赛季',
- ]);
- if ($validator->fails()){
- return $this->error(50024,'',current($validator->errors()->all()));
- }
- $id=Auth::user()->id;
- $re=Enroll::where('uid',$id)->where('status',0)->first();
- if ($re){
- $input=$request->all();
- $page=$input['page'];
- $page_size=$input['page_size'];
- $data=Course::where('season',$input['season'])->OrderBy('course_time')->where('week',$input['week']);
- $count=$data->count();
- $data=$data->select('*')->take($page_size)->skip(($page-1)*$page_size)->get();
- return $this->success_list($data,'',$count);
- }else{
- return $this->success_list([]);
- }
- }
- public function GetSeason(){
- $re=Course::GroupBy('season')->orderByDesc('season')->select('season')->get();
- return $this->success($re);
- }
- }
|