kailin/app/Http/Controllers/Admin/VideoExamAnswer.php

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

use App\Models\Custom;
use App\Models\Video\ExamAnswer as Model;
use App\Models\Video\Course as VideoCourse;
use App\Models\Video\Answer as VideoAnswer;
use App\Models\Video\Question as VideoQuestion;

/**
 * 学习记录
 *
 * @author    刘相欣
 *
 */
class VideoExamAnswer extends Auth{
	
	protected function _initialize(){
		parent::_initialize();
		$this->assign('breadcrumb1','课后评测');
		$this->assign('breadcrumb2','答题记录');
	}

	/**
	 * 列表页
	 * 
	 * */
    public function index(Model $Model,VideoCourse $VideoCourse,Custom $Custom,VideoQuestion $VideoQuestion,VideoAnswer $VideoAnswer){
		// 接收参数
		$recordId					= request('record_id',0);
		$courseId					= request('course_id',0);
		$customCode					= request('custom_code','');
		$customName					= request('custom_name','');
		// 转码
		$customCode					= $Custom->codeToId($customCode);
		// 查询条件
		$map 						= [];
		// 组合条件
		if( $courseId )				$map[] = ['video_course.id','=',$courseId];
		if( $recordId )				$map[] = ['video_exam_answer.record_id','=',$recordId];
		if( $customCode )			$map[] = ['custom.uid','=',$customCode];
		if( $customName )			$map[] = ['custom.username','LIKE','%'.$customName.'%'];
		// 查询数据
		$list						= $Model->query()
									->join('video_course','video_course.id','=','video_exam_answer.course_id')
									->join('custom','custom.uid','=','video_exam_answer.custom_uid')
									->where($map)->select(['video_exam_answer.*','video_course.name as course_name','custom.username as custom_name'])
									->orderByDesc('id')->paginate(config('page_num',10));
		// 循环处理数据
		foreach ($list as $key => $value) {
			// 时间
			$value['custom_code']	= $Custom->idToCode($value['custom_uid']);
			$value['question_title']= $VideoQuestion->getOne($value['question_id'],'title');
			$value['answer_list'] 	= $VideoAnswer->getListByQuestion($value['question_id']);
			$value['answer_list'] 	= array_values($value['answer_list']);
			// 重组
			$list[$key]				= $value;
		}
		// 查询数据
		$courseList 				= $VideoCourse->query()->orderByDesc('id')->get(['id','name']);
		// 分配数据
		$this->assign('list',$list);
		$this->assign('courseList',$courseList);
		$this->assign('empty', '<tr><td colspan="20">~~暂无数据</td></tr>');
		// 加载模板
		return 						$this->fetch();
    }

}