assign('breadcrumb1','排课管理'); $this->assign('breadcrumb2','排课列表'); } /** * 列表页 * * */ public function index(Model $Model){ // 接受参数 $name = request('name',''); $teacherName = request('teacher_name',''); $status = request('status'); $startTime = request('start_time',''); // 查询条件 $map = []; // 编码ID if( $name ) $map[] = ['course.name','=',$name]; if( $teacherName ) $map[] = ['course_teacher.name','=',$teacherName]; if( $startTime ) $map[] = ['course_schedule.insert_time','>=',Carbon::createFromFormat('Y-m-d',$startTime)->startOfDay()->getTimestamp()]; if( $startTime ) $map[] = ['course_schedule.insert_time','<=',Carbon::createFromFormat('Y-m-d',$startTime)->endOfDay()->getTimestamp()]; if( !is_null($status) ) $map[] = ['course_schedule.status','=',$status]; // 查询数据 $list = $Model->query()->join('course','course_schedule.course_id','=','course.id') ->join('course_teacher','course_schedule.teacher_id','=','course_teacher.id') ->where($map) ->orderByDesc('id') ->select(['course_schedule.*','course.name as course_name','course_teacher.name as teacher_name']) ->paginate(request('limit',config('page_num',10))) ->appends(request()->all()); // 循环处理数据 foreach ($list as $key => $value) { // 重组 $list[$key] = $value; } // 分配数据 $this->assign('empty', '~~暂无数据'); $this->assign('list', $list); // 加载模板 return $this->fetch(); } /** * 添加 * * */ public function add(Request $request,Model $Model,Course $Course,CourseTeacher $CourseTeacher){ if( request()->isMethod('post') ){ // 验证参数 $request->scene('add')->validate(); // 接收数据 $data['course_id'] = request('course_id',''); $data['teacher_id'] = request('teacher_id',''); $data['start_time'] = request('start_time',''); $data['end_time'] = request('end_time',''); $data['duration'] = request('duration',''); $data['course_number'] = request('course_number',''); $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : time(); $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : time(); if ($data['end_time'] <= $data['start_time']) return json_send(['code'=>'error','msg'=>'上课时间不能大于结束时间']); $res = $Model->query() ->where([['teacher_id','=',$data['teacher_id']],['start_time','>=',$data['start_time']],['start_time','<',$data['end_time']]]) ->orWhere([['teacher_id','=',$data['teacher_id']],['end_time','>',$data['start_time']],['end_time','<=',$data['end_time']]]) ->orWhere([['teacher_id','=',$data['teacher_id']],['start_time','>',$data['start_time']],['end_time','<',$data['end_time']]]) ->first(); if ($res) return json_send(['code'=>'error','msg'=>'老师上课时间重复']); // 写入数据表 $id = $Model->add($data); // 如果操作失败 if( !$id ) return json_send(['code'=>'error','msg'=>'新增失败']); // 记录行为 $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$data); // 告知结果 return json_send(['code'=>'success','msg'=>'新增成功','action'=>'add']); } $courseList = $Course->getList(); $courseTeacherList = $CourseTeacher->getList(); // 分配数据 $this->assign('courseList', $courseList); $this->assign('courseTeacherList', $courseTeacherList); $this->assign('crumbs','新增'); // 加载模板 return $this->fetch(); } /** * 修改 * * */ public function edit(Request $request,Model $Model,Course $Course,CourseTeacher $CourseTeacher){ // 接收参数 $id = request('id',0); // 查询用户 $oldData = $Model->where(['id'=>$id])->first(); // 修改 if(request()->isMethod('post')){ // 验证参数 $request->scene('edit')->validate(); // 接收数据 $data['course_id'] = request('course_id',''); $data['teacher_id'] = request('teacher_id',''); $data['start_time'] = request('start_time',''); $data['end_time'] = request('end_time',''); $data['duration'] = request('duration',''); $data['course_number'] = request('course_number',''); $data['start_time'] = $data['start_time'] ? strtotime($data['start_time']) : time(); $data['end_time'] = $data['end_time'] ? strtotime($data['end_time']) : time(); // 写入数据表 $result = $Model->edit($id,$data); // 如果操作失败 if( !$result ) return json_send(['code'=>'error','msg'=>'新增失败']); // 记录行为 $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,$data); // 告知结果 return json_send(['code'=>'success','msg'=>'修改成功','action'=>'edit']); } // 错误告知 if( !$oldData ) return $this->error('查无数据'); $courseList = $Course->getList(); $courseTeacherList = $CourseTeacher->getList(); // 分配数据 $this->assign('courseList', $courseList); $this->assign('courseTeacherList', $courseTeacherList); $this->assign('oldData',$oldData); $this->assign('crumbs','修改'); // 加载模板 return $this->fetch(); } /** * 修改状态 * * */ public function set_status(Request $request,Model $Model){ // 验证参数 $request->scene('set_status')->validate(); // 设置状态 $id = request('id',0); $status = request('status',0); // 查询排课表 $oldData = $Model->where(['id'=>$id])->first(); // 如果用户不存在 if( !$oldData ) return json_send(['code'=>'error','msg'=>'排课不存在']); // 执行修改 $result = $Model->edit($id,['status'=>$status]); // 提示新增失败 if( !$result ) return json_send(['code'=>'error','msg'=>'设置失败']); // 记录行为 $this->addAdminHistory(admin('uid'),$Model->getTable(),$id,2,$oldData,['status'=>$status]); // 告知结果 return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']); } }