<?php
namespace app\rongyu\controller;
// 引用控制器基类
use app\common\controller\Base;
// 引用教师数据模型类
use app\rongyu\model\JsRongyuInfo as ryinfo;
// 引用PhpSpreadsheet类
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\IOFactory;
class JsRongyuInfo extends Base
{
/**
* 显示教师荣誉册列表
*
* @return \think\Response
*/
public function index()
{
// 设置数据总数
$list['count'] = ryinfo::count();
// 设置页面标题
$list['title'] = '教师荣誉信息';
// 模板赋值
$this->assign('list', $list);
// 渲染模板
return $this->fetch();
}
/**
*荣誉册中荣誉信息列表
*
* @return \think\Response
*/
public function rongyuList($id)
{
// 获取变量
$list['id'] = $id;
// 设置页面标题
$list['title'] = '教师荣誉信息';
// 设置数据总数
$list['count'] = ryinfo::where('rongyuce',$id)->count();
// 模板赋值
$this->assign('list',$list);
return $this->fetch('');
}
/**
* 显示教师荣誉册列表
*
* @return \think\Response
*/
public function ajaxData()
{
// 获取DT的传值
$getdt = request()->param();
//得到排序的方式
$order = $getdt['order'][0]['dir'];
//得到排序字段的下标
$order_column = $getdt['order'][0]['column'];
//根据排序字段的下标得到排序字段
$order_field = $getdt['columns'][$order_column]['name'];
if($order_field=='')
{
$order_field = $getdt['columns'][$order_column]['data'];
}
//得到limit参数
$limit_start = $getdt['start'];
$limit_length = $getdt['length'];
//得到搜索的关键词
$search = [
'hjschool'=>$getdt['hjschool'],
'fzschool'=>$getdt['fzschool'],
'category'=>$getdt['category'],
'rongyuce'=>$getdt['rongyuce'],
'search'=>$getdt['search']['value'],
'order'=>$order,
'order_field'=>$order_field
];
// 实例化
$ryinfo = new ryinfo;
// 获取荣誉总数
$cnt = $ryinfo->select()->count();
// 查询数据
$data = $ryinfo->search($search);
$datacnt = $data->count();
// 获取当前页数据
$data = $data->slice($limit_start,$limit_length);
// 重组返回内容
$data = [
'draw'=> $getdt["draw"] , // ajax请求次数，作为标识符
'recordsTotal'=>$cnt, // 获取到的结果数(每页显示数量)
'recordsFiltered'=>$datacnt, // 符合条件的总数据量
'data'=>$data, //获取到的数据结果
];
return json($data);
}
/**
* 显示创建资源表单页.
*
* @return \think\Response
*/
public function create($id = 0)
{
// 设置页面标题
$list['title'] = '添加教师荣誉';
$list['id'] = $id;
// 模板赋值
$this->assign('list',$list);
// 渲染
return $this->fetch();
}
/**留备用
* 保存新建的资源
*
* @param \think\Request $request
* @return \think\Response
*/
public function save()
{
// 获取表单数据
$list = request()->only(['rongyuce','title','bianhao','category','hjschool','subject','hjshijian','jiangxiang','hjteachers','cyteachers','pic'],'put');
// 实例化验证类
$validate = new \app\rongyu\validate\JsRongyuInfo;
// 验证表单数据
$result = $validate->scene('add')->check($list);
$msg = $validate->getError();
// 如果验证不通过则停止保存
if(!$result){
return json(['msg'=>$msg,'val'=>0]);
}
// 更新数据
$data = ryinfo::create($list);
// 声明教师数组
$teacherlist = [];
// 循环组成获奖教师信息
foreach ($list['hjteachers'] as $key => $value) {
$canyulist[] = [
'teacherid' => $value,
'category' => 1,
];
}
if(!empty($list['cyteachers'])){
// 循环组成参与教师信息
foreach ($list['cyteachers'] as $key => $value) {
$canyulist[] = [
'teacherid' => $value,
'category' => 2,
];
}
}
// 添加新的获奖人与参与人信息
$data->allJsry()->saveAll($canyulist);
// 根据更新结果设置返回提示信息
$data ? $data=['msg'=>'添加成功','val'=>1] : $data=['msg'=>'数据处理错误','val'=>0];
// 返回信息
return json($data);
}
/**
* 批量上传教师荣誉册图片
*
* @param \think\Request $request
* @return \think\Response
*/
public function createall($id)
{
// 设置页面标题
$list['title'] = '添加教师荣誉册';
$list['rongyuce'] = $id;
// 模板赋值
$this->assign('list',$list);
// 渲染
return $this->fetch();
}
/**
* 上传荣誉图片并保存
*
* @param \think\Request $request
* @return \think\Response
*/
public function upload()
{
// 获取文件信息
$rongyuce=input('post.rongyuce');
// 获取表单上传文件 例如上传了001.jpg
$file = request()->file('file');
// 移动到框架应用根目录/uploads/ 目录下
$info = $file->validate(['size'=>2*1024*1024,'ext'=>'jpg,png,gif,jpeg'])->move('uploads\jiaoshirongyu');
if($info){
// 成功上传后 获取上传信息
$list['url'] = $info->getSaveName();
// $list['category'] = $info->getExtension();
// $list['newname'] = $info->getFilename();
// $myfileurl = '\uploads\\'.$list['url'];
// $list['bianjitime'] = filemtime('uploads\danweirongyu\\'.$list['url']);
$list['url'] = str_replace('\\','/',$list['url']);
// 如果图片上传成功，则添加荣誉记录
$data = ryinfo::create(['pic'=>$list['url'],'rongyuce'=>$rongyuce]);
$id = $data->id;
$id ? $data = array('msg'=>'上传成功','val'=>true,'url'=>$list['url'],'ryid'=>$id) : $data = array('msg'=>'保存文件信息失败','val'=>false,'url'=>null);
}else{
// 上传失败获取错误信息
$data = array('msg'=>$file->getError(),'val'=>false,'url'=>null);
}
// 返回信息
return json($data);
}
/**
* 荣誉册中荣誉信息列表
*
* @param int $id
* @return \think\Response
*/
public function read($id)
{
}
/**
* 显示编辑资源表单页.
*
* @param int $id
* @return \think\Response
*/
public function edit($id)
{
// 获取荣誉信息
$list = ryinfo::where('id',$id)
->field('id,rongyuce,title,bianhao,hjschool,subject,jiangxiang,hjshijian,pic')
->with([
'hjJsry'=>function($query){
$query->field('rongyuid,teacherid')
->with(['teacher'=>function($query){
$query->field('id,xingming');
}]);
},
'cyJsry'=>function($query){
$query->field('rongyuid,teacherid')
->with(['teacher'=>function($query){
$query->field('id,xingming');
}]);
},
'ryTuce'=>function($query){
$query->field('id,fzshijian');
}
])
->find();
$this->assign('list',$list);
return $this->fetch();
}
/**
* 保存更新的资源
*
* @param \think\Request $request
* @param int $id
* @return \think\Response
*/
public function update($id)
{
// 获取表单数据
$list = request()->only(['bianhao','title','category','hjschool','subject','hjshijian','jiangxiang','hjteachers','cyteachers','pic'],'put');
$list['id'] = $id;
// 实例化验证类
$validate = new \app\rongyu\validate\JsRongyuInfo;
// 验证表单数据
$result = $validate->scene('edit')->check($list);
$msg = $validate->getError();
// 如果验证不通过则停止保存
if(!$result){
return json(['msg'=>$msg,'val'=>0]);
}
// 更新数据
$data = ryinfo::update($list);
// 删除原来的获奖人与参与人信息
$data->allJsry()->where('rongyuid',$list['id'])->delete(true);
// 声明教师数组
$teacherlist = [];
// 循环组成获奖教师信息
foreach ($list['hjteachers'] as $key => $value) {
$canyulist[] = [
'teacherid' => $value,
'rongyuid' => $list['id'],
'category' => 1,
];
}
if(!empty($list['cyteachers'])){
// 循环组成参与教师信息
foreach ($list['cyteachers'] as $key => $value) {
$canyulist[] = [
'teacherid' => $value,
'rongyuid' => $list['id'],
'category' => 2,
];
}
}
// 添加新的获奖人与参与人信息
$data->allJsry()->saveAll($canyulist);
// 根据更新结果设置返回提示信息
$data ? $data=['msg'=>'更新成功','val'=>1] : $data=['msg'=>'数据处理错误','val'=>0];
// 返回信息
return json($data);
}
/**
* 删除指定资源
*
* @param int $id
* @return \think\Response
*/
public function delete($id)
{
if($id == 'm')
{
$id = request()->delete('ids/a');// 获取delete请求方式传送过来的数据并转换成数据
}
$data = ryinfo::destroy($id);
// 根据更新结果设置返回提示信息
$data ? $data=['msg'=>'删除成功','val'=>1] : $data=['msg'=>'数据处理错误','val'=>0];
// 返回信息
return json($data);
}
// 设置荣誉状态
public function setStatus()
{
// 获取id变量
$id = request()->post('id');
$value = request()->post('value');
// 获取学生信息
$data = ryinfo::where('id',$id)->update(['status'=>$value]);
// 根据更新结果设置返回提示信息
$data ? $data=['msg'=>'状态设置成功','val'=>1] : $data=['msg'=>'数据处理错误','val'=>0];
// 返回信息
return json($data);
}
// 下载荣誉信息
public function outXlsx($id)
{
// 查询数据
$list = ryinfo::where('rongyuce',$id)
->field('id,rongyuce,title,bianhao,hjschool,subject,jiangxiang,hjshijian,pic')
->with([
'hjJsry'=>function($query){
$query->field('rongyuid,teacherid')
->with(['teacher'=>function($query){
$query->field('id,xingming');
}]);
},
'cyJsry'=>function($query){
$query->field('rongyuid,teacherid')
->with(['teacher'=>function($query){
$query->field('id,xingming');
}]);
},
'ryTuce'=>function($query){
$query->field('id,title,fzshijian');
}
])
->select();
if($list->isEmpty())
{
$this->error('兄弟，没有要下载的信息呀~');
return '';
}else{
$filename = $list[0]['ryTuce']['title'];
}
//通过工厂模式创建内容
$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load('jsRongyu.xlsx');
$worksheet = $spreadsheet->getActiveSheet();
// $worksheet->getCell('A1')->setValue($filename);
// // 循环为excel每行赋值
// foreach ($list as $key => $value) {
// $worksheet->getCell('A'.($key+3))->setValue($key+1);
// $worksheet->getCell('B'.($key+3))->setValue($value->title);
// $worksheet->getCell('C'.($key+3))->setValue($value->title);
// $worksheet->getCell('D'.($key+3))->setValue($value->title);
// $worksheet->getCell('E'.($key+3))->setValue($value->title);
// $worksheet->getCell('F'.($key+3))->setValue($value->title);
// $worksheet->getCell('G'.($key+3))->setValue($value->title);
// $worksheet->getCell('H'.($key+3))->setValue($value->title);
// }
$worksheet->getCell('A2');
//通过工厂模式来写内容
// $writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xlsx');
// header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
// //告诉浏览器输出07Excel文件
// header('Content-Type:application/vnd.ms-excel');
// //告诉浏览器将要输出Excel03版本文件
// header('Content-Disposition: attachment;filename=01simple.xlsx');
// //告诉浏览器输出浏览器名称
// header('Cache-Control: max-age=0');//禁止缓存
// $writer = new Xlsx($spreadsheet);
// $writer->save('php://output');
// $writer->save('write.xlsx');
// $spreadsheet->disconnectWorksheets();
// unset($spreadsheet);
// return true;
// $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
// // header('Content-Disposition: attachment;filename="01simple.xlsx"');
// header('Cache-Control: max-age=0');
// // // If you're serving to IE 9, then the following may be needed
// // header('Cache-Control: max-age=1');
// // If you're serving to IE over SSL, then the following may be needed
// header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
// header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
// header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
// header('Pragma: public'); // HTTP/1.0
// $writer->save('php://output');
// exit;
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="fasdfas.xlsx"');
header('Cache-Control: max-age=0');
$writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('php://output');
ob_flush();
flush();
}
}