\app\rongyu\controllerJsRongyuInfo

<?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();











    }
}