hebei-chengben-car/modules/car/views/baseinfo/dataimport.php

<?php
use yii\widgets\ActiveForm;
?>
<?php $this->beginContent('@app/modules/admin/views/layouts/_datatable_start.php'); ?><?php $this->endContent(); ?>
<div class="row ">
    <div class="col-12">
        <div class="card">
            <div class="card-body shortcardbody">
                <!-- 搜索表单 -->
                <div class="searchbox shortsearchbox"  >
                    <?php $form = ActiveForm::begin(['options' => ['id'=>'searchform','class' => 'row gy-2 gx-3 align-items-center'], 'enableClientValidation' => false]); ?>
                    <div class="col-sm-auto">
                        <select class="form-select original p-3" name="template" style="width: 128px;" id="template">
                            <option value="">上传模板选择</option>
                            <option value="车辆违章">车辆违章</option>
                            <option value="车辆超保">车辆超保</option>
                            <option value="车辆过检">车辆过检</option>
                            <option value="车辆费用预算">车辆费用预算</option>
                        </select>
                    </div>
                    <div class="col-sm-auto">
                        <input class="form-control p3" type="text" data-toggle="datepicker" style="width: 108px;" name="statistical_month" id="statistical_month" placeholder="导入账期" autocomplete="off">
                    </div>
                    <div class="col-sm-auto">
                        <a href="../../upload/car-data/template.zip" class="btn btn-light carbtn p-3" style="border: none"><i class="layui-icon layui-icon-download-circle"></i> 模板下载</a>
                        <button type="button" class="btn btn-light carbtn p-3" id="data-upload">点击上传</button>
                    </div>
                        <div class="col-sm-auto" style="margin-left: auto;">
                            <button type="button" class="btn btn-light carbtn" id="searchform-btn">查询</button>
                            <button type="button" class="btn btn-light carbtn p-3" data-bs-toggle="modal" data-bs-target="#koujing" onclick="doKoujing()">口径描述</button>
                        </div>
                    <?php ActiveForm::end(); ?>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="row ">
    <div class="col-12">
        <ul class="nav nav-tabs nav-tabs-custom cartab" role="tablist">
            <li class="nav-item">
                <a class="nav-link"  href="<?php echo Yii::$app->controller->createRealUrl(['car/baseinfo/specar']);?>" >
                    <span class="d-none d-sm-block">特殊车辆维护</span>
                </a>
            </li>
            <li class="nav-item">
                <a class="nav-link active"  href="<?php echo Yii::$app->controller->createRealUrl(['car/baseinfo/dataimport']);?>">
                    <span class="d-none d-sm-block">数据导入查询</span>
                </a>
            </li>
        </ul>
        <div class="card main-wrapper">
            <!-- Tab panes -->
            <div class="tab-content p-3 text-muted" style="width: 99%;">
                <?php $this->beginContent('@app/modules/admin/views/layouts/_table.php'); ?><?php $this->endContent(); ?>
            </div>
        </div>
    </div>
</div>
<?php $this->beginContent('@app/modules/admin/views/layouts/_datatable_end.php'); ?><?php $this->endContent(); ?>
<?php $this->beginContent('@app/modules/admin/views/layouts/_tablejs.php'); ?><?php $this->endContent(); ?>
<script>
function doExport()
{
    $('#table').table2excel({
        filename: '数据导入.xlsx',
        sheetName: 'Sheet1'
    });
}

layui.use(function(){
    var upload = layui.upload;
    var layer = layui.layer;

    // 渲染
    upload.render({
        elem: '#data-upload',
        url: '<?php echo Yii::$app->controller->createRealUrl(["car/baseinfo/upload"]);?>', // 此处配置你自己的上传接口即可
        accept: 'file',//指定允许上传时校验的文件类型，可选值有：images（图片）、file（所有文件）、video（视频）、audio（音频）
        exts: 'xls|xlsx|csv|zip|rar',
        data:{
            _csrf:'<?php echo Yii::$app->request->getCsrfToken();?>',
            template: function(){
                return $('#template').val();
            },
            statistical_month: function(){
                return $('#statistical_month').val();
            }
        },
        before: function(obj){ // obj 参数同 choose
            // 若返回 false，则表明阻止上传
            var t = $('#template').val()
            if(t == ''){
                layer.msg('请选择上传模板！', {icon:2,time:5000, shift: 6});
              return false;
            }
            var t = $('#statistical_month').val()
            if(t == ''){
                layer.msg('请选择导入账期！', {icon:2,time:5000, shift: 6});
                return false;
            }
            layer.load(); // 上传 loading
        },
        done: function(res){
            layer.closeAll();
            //console.log(res);
            if(res.code==0){
                layer.msg('上传成功', {icon: 1}, function(){
                    // layer.msg('提示框关闭后的回调');
                    reLoad();
                });
            }else {
                layer.msg(res.msg, {icon:2,time:5000, shift: 6}, function(){
                    // layer.msg('提示框关闭后的回调');
                });
            }

        }
    });
});
</script>