zh_esign/app/Servers/Wps/ExcelServer.php

<?php


namespace App\Servers\Wps;



use App\Imports\ExcelImport;
use App\Servers\Financing\PropertyServer;
use App\Servers\Firm\FirmServer;
use App\Servers\System\CommonServer;

class ExcelServer
{
    static private $server = null;

    function __construct()
    {

    }

    /**
     * 创建对象
     * @return ExcelServer
     */
    static function creatServer()
    {
        if (empty(self::$server)) self::$server = new ExcelServer();
        return self::$server;
    }

    /**
     * 企业信息导入
     * @param $excel
     * @throws \Throwable
     */
    function importCooperationData($excel){
        $clientImport=new ExcelImport();
        $data=$clientImport->toArray($excel);
        if(!empty($data[0])){
            foreach ($data[0] as $key=>$item){
                if(empty($item[0])){
                    break;
                }
                if($key>1){
                    FirmServer::creatServer()->saveCooperation($item[0],'',$item[1],$item[2],$item[3]);
                }

            }
        }
    }

    /**
     * 资产信息导入
     * @param $excel
     * @param $factoringId
     */
    function importPropertyData($excel,$factoringId){
        if(strstr($excel,'http')!==false){
            $fileName=CommonServer::creatServer()->getFileName($excel);
            $path=public_path('storage/excel/'.date('Ymd').'/');
            if(!is_dir($path))mkdir($path,0777,true);
            file_put_contents($path.$fileName,file_get_contents($excel));
            $excel=$path.$fileName;
        }
        $clientImport=new ExcelImport();
        $data=$clientImport->toArray($excel);
        $row=['total'=>0,'succeed'=>0,'error'=>0,'list'=>[]];
        if(!empty($data[0])){
            foreach ($data[0] as $key=>$item){
                if(empty($item[0])){
                    break;
                }
                if($key>1){
                    if(count($item)<16){
                        continue;
                    }
                    ++$row['total'];

                    $ret=PropertyServer::creatServer()->importPropertyItem($item,$factoringId);
                    $row['list'][]=$ret;
                    if($ret['status']==1){
                        ++$row['succeed'];
                    }else{
                        ++$row['error'];
                    }
                }

            }
        }
        return $row;
    }






}