PhpSpreadsheetExceptionHandler.php 1.56 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
<?php
/**
 * Created by PhpStorm.
 * User: Zero
 * Date: 2020/8/24
 * Time: 18:05
 */

namespace Meibuyu\Micro\Exceptions\Handler;

use Hyperf\ExceptionHandler\ExceptionHandler;
use Hyperf\HttpMessage\Stream\SwooleStream;
use PhpOffice\PhpSpreadsheet\Exception as PhpSpreadsheetException;
use Psr\Http\Message\ResponseInterface;
use Throwable;

class PhpSpreadsheetExceptionHandler extends ExceptionHandler
{
    public function handle(Throwable $throwable, ResponseInterface $response)
    {
        $error = $throwable->getMessage();
王源's avatar
王源 committed
22 23 24 25 26 27 28
        if ($throwable instanceof PhpSpreadsheetException) {
            if (strpos($error, 'Formula Error') !== false) {
                $msg = '表格公式错误, 请检查是否引用其它表格数据';
                return $this->jsonResponse($msg, $response);
            }
        } else if (strpos($error, 'PhpOffice\PhpSpreadsheet\Writer\Xls::writeSummaryProp()') !== false) {
            $msg = '表格格式兼容错误,请上传 xlsx 结尾的excel';
29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
            return $this->jsonResponse($msg, $response);
        }
        return $response;
    }

    public function jsonResponse($msg, ResponseInterface $response)
    {
        // 阻止异常冒泡
        $this->stopPropagation();
        // 格式化输出
        $data = json_encode([
            'code' => 400,
            'msg' => $msg,
        ], JSON_UNESCAPED_UNICODE);
        return $response->withAddedHeader('content-type', 'application/json')->withBody(new SwooleStream($data));
    }

    public function isValid(Throwable $throwable): bool
    {
王源's avatar
王源 committed
48
        return true;
49 50 51
    }

}