表格导入数据库功能开发

框架为tp5

namespace app\admin\controller;
use    think\Controller;
use    think\Request;
use    think\Db;
use think\PHPExcel\PHPExcel;
use app\admin\model\ProjectModel; //获取项目信息
use app\admin\model\DealerModel; //获取经销商信息
use app\admin\model\CarModel; //获取车系信息
use app\admin\model\ChebhModel; //获取车百汇信息
use app\admin\model\ExcelModel; //获取车百汇信息

public function excelImporttrue(){
    $file = request()->file('importexcel');
    // 移动到框架应用根目录/public/uploads/ 目录下
    $info = $file->move(ROOT_PATH . 'public' . DS . 'uploads');
    if($info){
        // 成功上传后 获取上传信息
        $extname = $info->getExtension(); //获取文件扩展名
        $urlname = $info->getSaveName(); //获取文件存储目录及名称
        $urlname = ROOT_PATH . 'public' . DS . 'uploads/'.$urlname;
        $filename = $info->getFilename();  //获取文件保存名称
    }else{
        // 上传失败获取错误信息
        echo $file->getError();
    }
    if ($extname == 'xls') {
        $result = import("Excel5",EXTEND_PATH.'PHPExcel/PHPExcel/Reader');
        $PHPReader = new \PHPExcel_Reader_Excel5();
    } elseif ($extname == 'xlsx') {
        $result = import("Excel2007",EXTEND_PATH.'PHPExcel/PHPExcel/Reader');
        $PHPReader = new \PHPExcel_Reader_Excel2007();
    } else {
        return '路径出错';
    }

    $PHPExcel = $PHPReader->load($urlname);
    $currentSheet = $PHPExcel->getSheet(0);
    $allColumn = $currentSheet->getHighestColumn(); // 表格最多列
    $allRow = $currentSheet->getHighestRow(); //表格最多行数
    $dealer = new DealerModel();
    $allColumn ='C';
    for($currentRow = 2; $currentRow <= $allRow; $currentRow++){  //遍历表行
        for($currentColumn='A'; $currentColumn <= $allColumn; $currentColumn++){ //遍历表列
            $address = $currentColumn.$currentRow;
            $arr[$currentRow][$currentColumn] = $currentSheet->getCell($address)->getValue();
             if(is_object($arr[$currentRow][$currentColumn]) ){     //富文本转换字符串
                //instanceof PHPExcel_RichText 需要检测字段类型 目前为强制转换
                //富文本转换
                $arr[$currentRow][$currentColumn] = $arr[$currentRow][$currentColumn]->__toString();
             }
        }
        //$dealminname =  $arr[$currentRow]['C'];//经销商简称
        $dealername = $arr[$currentRow]['C']; //经销商名称
        $dealprovince = $arr[$currentRow]['A']; //经销商所在省份名称
        $dealcity = $arr[$currentRow]['B']; //经销商所在城市名称
        //$addr = $arr[$currentRow]['E']; //经销商所在城市地址
        //检测经销商是否存在，存在继续下一个，不存在检测省份，城市
        if(!$dealername|| !$dealcity ||!$dealprovince){
            continue;
        }
        $dataarr = array();
        $result =  $dealer->exCadillac($dealername); //检测凯迪拉克经销商是否存在
        if(!$result){ //如果不存在
            //检测省份是否存在，不存在，创建，存在获取省份id也就是dealer_id
            $endpro =  $dealer->exCadillac($dealprovince);
            if($endpro){ //省份存在 检测城市是否存在
                $endcity =  $dealer->exCadillac($dealcity);
                if($endcity){ //城市存在，插入经销商信息
                    //$dataarr = array('dm'=>$dm); //存放传入信息
                    $dataarr['pid'] = $endcity[0]['dealer_id']; //父级id
                    $dataarr['dlname'] = $dealername; //经销商名称
                    //$dataarr['minname'] = $dealminname; //经销商名字简称
                    //dump($dataarr);
                    $insertinfo = $dealer->CadillacInsert($dataarr,'dazhongcc_dealer');
                }else{ //城市不存在，先插入城市，获取城市id，再插入经销商
                    //$dataarr = array('dm'=>'','dlmime'=>''); //存放传入信息
                    //$dataarr['minname'] = $dealminname; //经销商名字简称
                    $dataarr['dlname'] = $dealcity; //城市名称
                    $dataarr['pid'] = $endpro[0]['dealer_id']; //父级省份id

                    $insertinfo = $dealer->CadillacInsert($dataarr,'dazhongcc_dealer');
                    if($insertinfo){ //城市插入成功，插入当前经销商信息
                        $dataarr['minname'] = ""; //经销商名字简称
                        $dataarr['dlname'] = $dealername; //经销商名
                        $dataarr['pid'] = $insertinfo; //父级省份id
                        $insertinfo = $dealer->CadillacInsert($dataarr,'dazhongcc_dealer');
                    }
                }
            }
            else{ //省份不存在，创建省份，创建城市，创建经销商  == 未写 因为省份已提前录入
                $dataarr['dlname'] = $dealprovince; //城市名称
                $dataarr['pid'] = 0; //父级省份id
                //$dataarr['minname'] = ""; //经销商名字简称
                $insertinfo = $dealer->CadillacInsert($dataarr,'dazhongcc_dealer');

                //$dataarr['minname'] = ""; //经销商名字简称
                $dataarr['dlname'] = $dealcity; //城市名称
                $dataarr['pid'] = $insertinfo; //父级省份id
                //dump($dealcity);
                $insertinfo = $dealer->CadillacInsert($dataarr,'dazhongcc_dealer');
            }
        }else{//存在,继续
            continue;
        }
    }
    //p($arr);
}