<?php
/**
 * Created by PhpStorm.
 * User: ruidiudiu
 * Date: 2018/11/20
 * Time: 16:33
 */

namespace app\portal\controller;


use app\portal\model\EquipmentModel;
use cmf\controller\AdminBaseController;
use PHPExcel_IOFactory;
use QRcode;
use think\Db;

/**
 * Class AdminEquipmentController
 * @package app\portal\controller
 * @adminMenuRoot(
 *     'name'   =>'设备管理',
 *     'action' =>'index',
 *     'parent' =>'',
 *     'display'=> true,
 *     'order'  => 30,
 *     'icon'   =>'th',
 *     'remark' =>'设备管理'
 * )
 */
class AdminEquipmentController extends AdminBaseController{

    public function index(){
        $Equipment=new EquipmentModel();
        $data=$Equipment->paginate(10);
        $this->assign('data',$data);
        return $this->fetch();
    }

    public function add(){

        return $this->fetch();
    }

    public function addPost(){
        $data=$this->request->post();
        $data['create_time']=strtotime($data['create_time']);
        $data['qr_code'] = $this->createQrCode($data['mac_address']);
        $Equipment=new EquipmentModel();
        $res=$Equipment->save($data);
        if ($res){
            $this->apiResponse(200,'保存成功');
        }else{
            $this->apiResponse(301,'error');
        }
    }

    //批量导入设备信息
    public function batch_add(){

        return $this->fetch();
    }

    public function batch_addPost(){
        //上传excel文件
        $file = $this->request->file('myfile');
        dump($file);
        //移到/public/uploads/excel/下
        $info = $file->move(ROOT_PATH.'public'.DS.'upload'.DS.'excel');
        //上传文件成功
        if($info) {
            //引入PHPExcel类
            vendor('VENDOR_PATH/phpoffice/phpexcel/Classes/PHPExcel.php');
            vendor('VENDOR_PATH/phpoffice/phpexcel/Classes/PHPExcel/IOFactory.php');
            //获取上传后的文件名
            $fileName = $info->getSaveName();
            //文件路径
            $filePath = ROOT_PATH.'public/upload/excel/'.$fileName;
            //实例化PHPExcel类
            //使用 PHPExcel_IOFactory 来鉴别文件应该使用哪一个读取类
            $inputFileType = PHPExcel_IOFactory::identify($filePath);
            //实例化类
            $objReader = PHPExcel_IOFactory::createReader($inputFileType);
            //$PHPReader = new \PHPExcel_Reader_Excel2007();
            //读取excel文件
            $objPHPExcel = $objReader->load($filePath);
            //读取excel文件中的第一个工作表
            $sheet = $objPHPExcel->getSheet(0);
            $allRow = $sheet->getHighestRow();  //取得总行数
//            $testInfo=new TestinfoModel();
            //从第二行开始插入，第一行是列名
            for ($j = 2; $j <= $allRow; $j++) {
                $data=[
                    'serial_number'=> $objPHPExcel->getActiveSheet()->getCell("a" . $j)->getValue(),
                    'mac_address' => $objPHPExcel->getActiveSheet()->getCell("b" . $j)->getValue(),
                    'name' => $objPHPExcel->getActiveSheet()->getCell("c" . $j)->getValue(),
                    'hospital' => $objPHPExcel->getActiveSheet()->getCell("d" . $j)->getValue(),
                    'note' => $objPHPExcel->getActiveSheet()->getCell("e" . $j)->getValue(),
                    'create_time' => time()
                ];
                $data['qr_code'] = $this->createQrCode($data['mac_address']);
                $Equipment=new EquipmentModel();
                try{
                    $Equipment->save($data);
                    echo "第" . $j . "行数据导入成功！<br/>";
                }catch (\Exception $exception){
                    echo "第" . $j . "行数据导入失败！错误信息:".$exception->getMessage()."<br/>";
                }
            }
        }else{
            echo "上传文件失败！";
        }
    }



    //生成二维码
    public function createQrCode($value){
        import('phpqrcode.qrlib',VENDOR_PATH,'.php');
        $name=date('YmdHis').rand(1000,9999);
        $filename='qrCode/'.$name.'.png';
        $filePath = 'upload/'.$filename; // 生成的文件名
        $errorCorrectionLevel = 'L';//容错级别
        $matrixPointSize = 6;//生成图片大小
        QRcode::png($value,$filePath, $errorCorrectionLevel, $matrixPointSize, 2);
        return $filename;
    }

}