通过ajax上传excel文件

最新推荐文章于 2023-02-22 18:20:28 发布

xqt15538076006

最新推荐文章于 2023-02-22 18:20:28 发布

阅读量3.2k

点赞数 1

分类专栏： jquery 文章标签： ajax

jquery 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

html部分:

<li>
         <span>上&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;传：</span>
         <span class="input">
   <input type="file" id="upfile" name="upfile" placeholder=""/>
</span>
         <button onclick="importExp();">导入</button>
         <span>格式：.xls</span>
     </li>

js部分:

//导入文件
function importExp() {
    var formData = new FormData();
    var name = $("#upfile").val();
    formData.append("file",$("#upfile")[0].files[0]);
    formData.append("name",name);
    $.ajax({
        url : '#springUrl('')/summary/importExp',
        type : 'POST',
        async : false,
        data : formData,
        // 告诉jQuery不要去处理发送的数据
        processData : false,
        // 告诉jQuery不要去设置Content-Type请求头
        contentType : false,
        beforeSend:function(){
            console.log("正在进行，请稍候");
        },
        success : function(responseStr) {
            if(responseStr=="01"){
                alert("导入成功");
            }else{
                alert("导入失败");
            }
        }
    });
}

控制器Controller

 public function upSmsPackage() {
        //执行上传
        $upload = new \Think\Upload();
        $upload->maxSize = 104857600;
        $upload->allowExts = array('xls','xlsx');
        $upload->rootPath = './Public/Uploads/SmsPackage/';
        $upload->savePath = '';
        $upload->autoSub = false;
        //判断目录是否存在
        if(!is_dir('/Public/Uploads/SmsPackage')){
            mkdir('/Public/Uploads/SmsPackage');
        }
        $info = $upload->upload();
        if(!$info)
        {
            $this->error($upload->getError());
        }

        $url = '/www/huarun-web-osp/Public/Uploads/SmsPackage/'.$info['file']['savepath'].$info['file']['savename'];
        $data = [
            'org_skey'    => session('storeinfo.org_skey'),
            'org_code'    => session('storeinfo.org_code'),
            'package_name'=> I('package_name')?I('package_name'):'111111',
            'filepath'    => $url,
            'add_user'    => session('userinfo.uid'),
            'upload_type' => I('upload_type') ? I('upload_type'):1 ,
            'add_time'    => date('Y-m-d H:i:s')
        ];
        // 进行存储
        $result = M('upload_sms_page')->add($data);
        if($result){
            $this->success('上传成功');
        }
    }