dingding/application/api/controller/Subscribe.php

<?php
namespace app\api\controller;

use app\api\controller\Base;
use think\Db;
use hg\apidoc\annotation as Apidoc;
/**
 * @Apidoc\Title("申购模块")
 * @Apidoc\Group("api")
 */
class Subscribe extends Base
{
    public function initialize()
    {
        parent::initialize();
        parent::checkLogin();
    }
    /**
     * @Apidoc\Title("获取商品导入模板地址")
     * @Apidoc\Desc("获取审批流程")
     * @Apidoc\Method("GET")
     * @Apidoc\Author("HG")
     * @Apidoc\Tag("")
     * @Apidoc\Returned("", type="string", desc="模板链接地址")
     */
    public function template_url()
    {
        $url = 'https://'.$_SERVER['HTTP_HOST'].'/template.xlsx';
        $this->success('获取成功',$url);
    }
    /**
     * @Apidoc\Title("获取商品导入后的商品信息")
     * @Apidoc\Desc("获取审批流程")
     * @Apidoc\Method("GET")
     * @Apidoc\Author("HG")
     * @Apidoc\Tag("")
     * @Apidoc\Query("url", type="string", desc="导入文件上传后的路径")
     * @Apidoc\Returned("", type="string", desc="模板链接地址")
     */
    public function goods_info()
    {
        $url = input('url');
        if(empty($url)){
            $this->error('参数错误');
        }
        $file_name = explode('/',$url);
        $import_path = $_SERVER['DOCUMENT_ROOT'].'/upload/excel/'.$file_name;
        $objReader =\PHPExcel_IOFactory::createReader('Excel2007');
        $objExcel = $objReader->load($import_path);
        $list = $objExcel->getActiveSheet()->toArray();
        if(empty($list)){
            $this->error('暂无数据');
        }
        foreach ($list as $k=>$v){
            if($k > 0 && $v[0]){
                $array = array();
                $array['name'] = $v[0];
                $array['record_name'] = $v[1];
                $array['avg_price'] = $v[2];
                $array['fitment_state'] = $v[3];
                $array['trait'] = $v[4].'、';
                $array['sale_state'] = $v[5];
                $array['floor_area'] = $v[6];
                $array['covered_area'] = $v[7];
                $array['property_class'] = $v[8].'、';
                $array['property_deadline'] = $v[9];
                $array['plot_ratio'] = $v[10];
                $array['greening_rate'] = $v[11];
                $array['tower_num'] = $v[12];
                $array['resident_num'] = $v[13];
                $array['floor_case'] = $v[14];
                $array['floor_height'] = $v[15];
                $array['stall_num'] = $v[16];
                $array['stall_ratio'] = $v[17];
                Db::name('store_property')->insert($array);
            }
        }

        var_dump($list);exit();
        $this->success('获取成功',$url);
    }
}