<?php namespace app\admin\controller; use app\admin\model\RouteModel; use cmf\controller\AdminBaseController; use think\Db; class SchoolController extends AdminBaseController{ /* * 学校管理列表 * */ public function school_list(){ if($this -> request -> isPost()){ if(!empty($_POST['start_time']) && !empty($_POST['end_time'])){ $start_time = $_POST['start_time']; $end_time = $_POST['end_time']; $where['create_time'] = [['>=',$start_time],['<=',$end_time]]; } if(!empty($_POST['keyword'])){ $keyword = $_POST['keyword']; $where['school'] = ['like',"%$keyword%"]; } $data1 = Db::name('school') -> where($where) -> paginate(12) ; $data = $data1 -> toArray(); }else{ $data1 = Db::name('school') -> paginate(12) ; $data = $data1 -> toArray(); } foreach ($data['data'] as $key => $val){ $user_data = Db::name('user') -> where('id',$val['uid']) -> find(); $data['data'][$key]['uname'] = $user_data['user_nickname']; } $this -> assign('data',$data['data']); $this -> assign('res',$data1); return $this -> fetch(); } /* * 学校管理编辑 * */ public function school_edit(){ $id = $this -> request -> param(); $data = Db::name('school') -> where('id',$id['ids']) -> find(); $data_grade = Db::name('grade_class') -> where('school_id',$id['ids']) -> select(); foreach ($data_grade as $key => $val){ $grade_id[] = $val['id']; $grade_class[] = $val['grade'].','.$val['class']; } $grade_id_str = implode('-',$grade_id); $grade_class_str = implode('|',$grade_class); $this -> assign('data',$data); $this -> assign('grade_class_str',$grade_class_str); $this -> assign('grade_id_str',$grade_id_str); return $this -> fetch(); } /* * 学校管理编辑提交 修改数据 * */ public function school_edit_post(){ $data['id'] = $_POST['id']; $data['region'] = $_POST['region']; $data['school'] = $_POST['school']; $data['type'] = $_POST['type']; $res = Db::name('school') -> update($data); $gread = explode('|',$_POST['grade_class_str']); foreach($gread as $key => $val){ $greads[] = explode(',',$gread[$key]); } $id = explode('-',$_POST['grade_id_str']); foreach($id as $key => $val){ Db::name('grade_class') -> where('id',$id[$key]) -> update(['grade'=>$greads[$key][0],'class'=>$greads[$key][1]]); } $this -> success('保存成功',url('School/school_edit',array('ids'=>$_POST['id']))); } /** * 删除数据 * */ public function school_del(){ $id = $_POST['id']; Db::name('school') -> delete($id); return true; } }