education/app/Http/Controllers/Admin/CourseReservation.php

<?php namespace App\Http\Controllers\Admin;

use App\Http\Requests\Admin\CourseReservation as Request;
use App\Models\CourseReservation as Model;
use App\Models\Course as Course;
use App\Models\CourseTeacher as CourseTeacher;
use Illuminate\Support\Carbon;

/**
 * 课程预约
 *
 * @author   jun
 *
 */
class CourseReservation extends Auth{
	
	protected function _initialize(){
		parent::_initialize();
		$this->assign('breadcrumb1','预约管理');
		$this->assign('breadcrumb2','预约列表');
	}

	/**
	 * 列表页
	 * 
	 * */
    public function index(Model $Model){
        // 接受参数
        $name					= request('name','');
        $status					= request('status');
        $startTime				= request('start_time','');
        // 查询条件
        $map 					= [];
        // 编码ID
        if( $name )				$map[] = ['name','=',$name];
        if( $startTime )		$map[] = ['insert_time','>=',Carbon::createFromFormat('Y-m-d',$startTime)->startOfDay()->getTimestamp()];
        if( $startTime )		$map[] = ['insert_time','<=',Carbon::createFromFormat('Y-m-d',$startTime)->endOfDay()->getTimestamp()];
        if( !is_null($status) )	$map[] = ['status','=',$status];
        // 查询数据
        $list					= $Model->query()
            ->join('course_schedule','course_reservation.schedule_id','=','course_schedule.id')
            ->join('course','course_schedule.course_id','=','course.id')
            ->join('course_teacher','course_schedule.teacher_id','=','course_teacher.id')
            ->join('custom','course_reservation.uid','=','custom.uid')
            ->where($map)
            ->orderByDesc('id')
            ->select(['course_schedule.*','course.name as course_name','course_teacher.name as teacher_name','custom.username as user_name','custom.phone as user_phone'])
            ->paginate(request('limit',config('page_num',10)))
            ->appends(request()->all());
        // 循环处理数据
        foreach ($list as $key => $value) {
            // 重组
            $list[$key]			= $value;
        }
        // 分配数据
        $this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
        $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();
			// 写入数据表
			$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('uid',0);
		$status			= request('status',0);
		// 查询用户
		$oldData		= $Model->where(['uid'=>$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'=>'']);
	}

}