Culture/Application/Admin/Controller/CourseController.class.php

<?php

namespace Admin\Controller;

/**
 * 教师课程管理
 * @author   Devil
 * @blog     http://gong.gg/
 * @version  0.0.1
 * @datetime 2016-12-01T21:51:08+0800
 */
class CourseController extends CommonController
{
	/**
	 * [_initialize 前置操作-继承公共前置方法]
	 * @author   Devil
	 * @blog     http://gong.gg/
	 * @version  0.0.1
	 * @datetime 2016-12-03T12:39:08+0800
	 */
	public function _initialize()
	{
		// 调用父类前置方法
		parent::_initialize();

		// 登录校验
		$this->Is_Login();

		// 权限校验
		$this->Is_Power();
	}

	/**
     * [Index 教师课程列表]
     * @author   Devil
     * @blog     http://gong.gg/
     * @version  0.0.1
     * @datetime 2016-12-06T21:31:53+0800
     */
	public function Index()
	{
		// 参数
		$param = array_merge($_POST, $_GET);

		// 模型对象
		$m = M('Course');

		// 条件
		$where = $this->GetIndexWhere();

		// 分页
		$number = MyC('admin_page_number');
		$total = $m->alias('AS c')->join(' INNER JOIN __TEACHER__ AS t ON c.teacher_id = t.id INNER JOIN __CLASS__ AS cs ON c.class_id = cs.id INNER JOIN __SUBJECT__ AS s ON c.subject_id = s.id INNER JOIN __WEEK__ AS w ON c.week_id = w.id INNER JOIN __INTERVAL__ AS i ON c.interval_id = i.id')->where($where)->count();
		$page_param = array(
				'number'	=>	$number,
				'total'		=>	$total,
				'where'		=>	$param,
				'url'		=>	U('Admin/Fraction/Index'),
			);
		$page = new \My\Page($page_param);

		// 获取列表
		$field = array('c.id', 'c.state', 't.username AS teacher_name', 'cs.name AS class_name', 'cs.pid AS class_pid', 's.name AS subject_name', 'w.name AS week_name', 'i.name AS interval_name', 'c.add_time AS add_time', 'r.pid AS room_pid', 'r.name AS room_name');
		$list = $this->SetDataHandle($m->alias('AS c')->join(' INNER JOIN __TEACHER__ AS t ON c.teacher_id = t.id INNER JOIN __CLASS__ AS cs ON c.class_id = cs.id INNER JOIN __SUBJECT__ AS s ON c.subject_id = s.id INNER JOIN __WEEK__ AS w ON c.week_id = w.id INNER JOIN __INTERVAL__ AS i ON c.interval_id = i.id INNER JOIN __ROOM__ AS r ON c.room_id = r.id')->where($where)->field($field)->limit($page->GetPageStarNumber(), $number)->select());

		// 数据列表
		$this->assign('list', $list);

		// 字段
		$field = array('id', 'name');

		// 条件
		$where = array('is_enable'=>1);

		// 班级
		$this->assign('class_list', $this->GetClassList());

		// 教室
		$this->assign('room_list', $this->GetRoomList());

		// 周天
		$this->assign('week_list', M('Week')->field($field)->where($where)->select());

		// 科目
		$this->assign('subject_list', M('Subject')->field($field)->where($where)->select());

		// 时段
		$this->assign('interval_list', M('Interval')->field($field)->where($where)->select());

		// 参数
		$this->assign('param', $param);

		// 分页
		$this->assign('page_html', $page->GetPageHtml());

		// Excel地址
		$this->assign('excel_url', U('Admin/Course/ExcelExport', $param));

		$this->display('Index');
	}

	/**
	 * [ExcelExport excel文件导出]
	 * @author   Devil
	 * @blog     http://gong.gg/
	 * @version  0.0.1
	 * @datetime 2017-01-10T15:46:00+0800
	 */
	public function ExcelExport()
	{
		// 条件
		$where = $this->GetIndexWhere();

		// 读取数据
		$field = array('c.id', 'c.state', 't.username AS teacher_name', 'cs.name AS class_name', 'cs.pid AS class_pid', 's.name AS subject_name', 'w.name AS week_name', 'i.name AS interval_name', 'c.add_time AS add_time', 'r.pid AS room_pid', 'r.name AS room_name');
		$data = $this->SetDataHandle(M('Course')->alias('AS c')->join(' INNER JOIN __TEACHER__ AS t ON c.teacher_id = t.id INNER JOIN __CLASS__ AS cs ON c.class_id = cs.id INNER JOIN __SUBJECT__ AS s ON c.subject_id = s.id INNER JOIN __WEEK__ AS w ON c.week_id = w.id INNER JOIN __INTERVAL__ AS i ON c.interval_id = i.id INNER JOIN __ROOM__ AS r ON c.room_id = r.id')->where($where)->field($field)->select());

		// Excel驱动导出数据
		$excel = new \My\Excel(array('filename'=>'course', 'title'=>L('excel_course_title_list'), 'data'=>$data, 'msg'=>L('common_not_data_tips')));
		$excel->Export();
	}

	/**
	 * [SetDataHandle 数据处理]
	 * @author   Devil
	 * @blog     http://gong.gg/
	 * @version  0.0.1
	 * @datetime 2016-12-29T21:27:15+0800
	 * @param    [array]      $data [教师课程数据]
	 * @return   [array]            [处理好的数据]
	 */
	private function SetDataHandle($data)
	{
		if(!empty($data))
		{
			$c = M('Class');
			$r = M('Room');
			foreach($data as $k=>$v)
			{
				// 班级
				if($v['class_pid'] != 0)
				{
					$p_name = $c->where(array('id'=>$v['class_pid']))->getField('name');
					$data[$k]['class_name'] = empty($p_name) ? $v['class_name'] : $p_name.'-'.$v['class_name'];
				}

				// 教室
				if($v['room_pid'] != 0)
				{
					$p_name = $r->where(array('id'=>$v['room_pid']))->getField('name');
					$data[$k]['room_name'] = empty($p_name) ? $v['room_name'] : $p_name.'-'.$v['room_name'];
				}

				// 添加时间
				$data[$k]['add_time'] = date('Y-m-d H:i:s', $v['add_time']);

				// 状态
				$data[$k]['state_text'] = L('common_state_list')[$v['state']]['name'];
			}
		}
		return $data;
	}

	/**
	 * [GetIndexWhere 教师课程列表条件]
	 * @author   Devil
	 * @blog     http://gong.gg/
	 * @version  0.0.1
	 * @datetime 2016-12-10T22:16:29+0800
	 */
	private function GetIndexWhere()
	{
		$where = array();

		// 学期id
		$where['c.semester_id'] = MyC('admin_semester_id');

		// 模糊
		if(!empty($_REQUEST['keyword']))
		{
			$where['t.username'] = array('like', '%'.I('keyword').'%');
		}

		// 是否更多条件
		if(I('is_more', 0) == 1)
		{
			// 等值
			if(I('class_id', 0) > 0)
			{
				$where['c.class_id'] = intval(I('class_id'));
			}
			if(I('week_id', 0) > 0)
			{
				$where['c.week_id'] = intval(I('week_id'));
			}
			if(I('subject_id', 0) > 0)
			{
				$where['c.subject_id'] = intval(I('subject_id'));
			}
			if(I('interval_id', 0) > 0)
			{
				$where['c.interval_id'] = intval(I('interval_id'));
			}
			if(I('room_id', 0) > 0)
			{
				$where['c.room_id'] = intval(I('room_id'));
			}
		}
		return $where;
	}

	/**
	 * [SaveInfo 教师课程添加/编辑页面]
	 * @author   Devil
	 * @blog     http://gong.gg/
	 * @version  0.0.1
	 * @datetime 2016-12-14T21:37:02+0800
	 */
	public function SaveInfo()
	{
		// 课程信息
		if(empty($_REQUEST['id']))
		{
			$data = array('teacher_id'=>I('teacher_id'));
			$request_url = U('Admin/Teacher/Index');
		} else {
			$data = M('Course')->find(I('id'));
			$request_url = U('Admin/Course/Index');
		}
		$this->assign('request_url', $request_url);
		$this->assign('data', $data);

		// 字段
		$field = array('id', 'name');

		// 条件
		$where = array('is_enable'=>1);

		// 班级
		$this->assign('class_list', $this->GetClassList());

		// 教室
		$this->assign('room_list', $this->GetRoomList());

		// 周天
		$this->assign('week_list', M('Week')->field($field)->where($where)->select());

		// 教师贯通的科目
		$subject_list = M('TeacherSubject')->alias('AS ts')->join('__SUBJECT__ AS s ON ts.subject_id = s.id')->where(array('ts.teacher_id'=>$data['teacher_id']))->field(array('s.id AS id', 's.name AS name'))->select();
		$this->assign('subject_list', $subject_list);

		// 时段
		$this->assign('interval_list', M('Interval')->field($field)->where($where)->select());

		$this->display('SaveInfo');
	}

	/**
	 * [Save 教师课程添加/编辑]
	 * @author   Devil
	 * @blog     http://gong.gg/
	 * @version  0.0.1
	 * @datetime 2016-12-14T21:37:02+0800
	 */
	public function Save()
	{
		// 是否ajax请求
		if(!IS_AJAX)
		{
			$this->error(L('common_unauthorized_access'));
		}

		// 添加
		if(empty($_POST['id']))
		{
			$this->Add();

		// 编辑
		} else {
			$this->Edit();
		}
	}

	/**
	 * [Add 教师课程添加]
	 * @author   Devil
	 * @blog     http://gong.gg/
	 * @version  0.0.1
	 * @datetime 2016-12-18T16:20:59+0800
	 */
	private function Add()
	{
		// 教师课程模型
		$m = D('Course');

		// 数据自动校验
		if($m->create($_POST, 1))
		{
			// 校验数据不能重复添加
			$this->IsExistData();

			// 额外数据处理
			$m->add_time	=	time();
			$m->semester_id	=	MyC('admin_semester_id');
			
			// 写入数据库
			if($m->add())
			{
				$this->ajaxReturn(L('common_operation_add_success'));
			} else {
				$this->ajaxReturn(L('common_operation_add_error'), -100);
			}
		} else {
			$this->ajaxReturn($m->getError(), -1);
		}
	}

	/**
	 * [Edit 教师课程编辑]
	 * @author   Devil
	 * @blog     http://gong.gg/
	 * @version  0.0.1
	 * @datetime 2016-12-17T22:13:40+0800
	 */
	private function Edit()
	{
		// 教师课程模型
		$m = D('Course');

		// 数据自动校验
		if($m->create($_POST, 2))
		{
			// 校验数据不能重复添加
			$this->IsExistData();

			// 移除 id
			unset($m->id, $m->teacher_id);

			// 更新数据库
			if($m->where(array('id'=>I('id'), 'teacher_id'=>I('teacher_id')))->save())
			{
				$this->ajaxReturn(L('common_operation_edit_success'));
			} else {
				$this->ajaxReturn(L('common_operation_edit_error'), -100);
			}
		}
	}

	/**
	 * [IsExistData 校验数据不能重复添加]
	 * @author   Devil
	 * @blog     http://gong.gg/
	 * @version  0.0.1
	 * @datetime 2017-01-08T22:08:46+0800
	 */
	private function IsExistData()
	{
		// 课程模型
		$m = M('Course');

		// 整条数据是否已存在
		$where = array(
				'teacher_id'	=>	I('teacher_id'),
				'class_id'		=>	I('class_id'),
				'subject_id'	=>	I('subject_id'),
				'week_id'		=>	I('week_id'),
				'interval_id'	=>	I('interval_id'),
				'room_id'		=>	I('room_id'),
				'semester_id'	=>	MyC('admin_semester_id'),
			);
		$temp = $m->where($where)->getField('id');
		if(!empty($temp))
		{
			$this->ajaxReturn(L('common_data_is_exist_error'), -2);
		}

		// 学期-教室-周天-时段 是否已存在
		$where = array(
				'week_id'		=>	I('week_id'),
				'interval_id'	=>	I('interval_id'),
				'room_id'		=>	I('room_id'),
				'semester_id'	=>	MyC('admin_semester_id'),
			);
		$temp = $m->where($where)->getField('id');
		if(!empty($temp))
		{
			// 如果编辑的不是当前数据则校验
			if($temp != I('id'))
			{
				$this->ajaxReturn(L('course_room_occupy_tips'), -2);
			}
		}
	}

	/**
	 * [Delete 教师课程删除]
	 * @author   Devil
	 * @blog     http://gong.gg/
	 * @version  0.0.1
	 * @datetime 2016-12-15T11:03:30+0800
	 */
	public function Delete()
	{
		// 是否ajax请求
		if(!IS_AJAX)
		{
			$this->error(L('common_unauthorized_access'));
		}

		// 参数处理
		if(empty($_POST['id']))
		{
			$this->ajaxReturn(L('common_param_error'), -1);
		}

		// 删除数据
		if(M('Course')->delete(I('id')))
		{
			$this->ajaxReturn(L('common_operation_delete_success'));
		} else {
			$this->ajaxReturn(L('common_operation_delete_error'), -100);
		}
	}

	/**
	 * [StateUpdate 状态更新]
	 * @author   Devil
	 * @blog     http://gong.gg/
	 * @version  0.0.1
	 * @datetime 2017-01-12T22:23:06+0800
	 */
	public function StateUpdate()
	{
		// 参数
		if(empty($_POST['id']) || !isset($_POST['state']))
		{
			$this->ajaxReturn(L('common_param_error'), -1);
		}

		// 数据更新
		if(M('Course')->where(array('id'=>I('id')))->save(array('state'=>I('state'))))
		{
			$this->ajaxReturn(L('common_operation_edit_success'));
		} else {
			$this->ajaxReturn(L('common_operation_edit_error'), -100);
		}
	}
}
?>