hebei-chengben-car/modules/car/views/baseinfo/spelist.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]); ?>
                        <?php
                            echo $form->field($model, 'card_num', ['template' => '{label}{input}','options' =>['class' => 'col-sm-auto'],'inputOptions' =>['class' => 'form-control','placeholder'=>'车牌号码','autocomplete'=>'off'],'labelOptions' => ['class' => 'visually-hidden']]);
                        ?>
                        <?php
                            echo $form->field($model, 'dept', ['template' => '{label}{input}','options' =>['class' => 'col-sm-auto'],'inputOptions' =>['class' => 'form-select ', 'data-dselect-clearable'=>'true','placeholder'=>'','autocomplete'=>'off'],'labelOptions' => ['class' => 'visually-hidden']])->dropDownList($model->dptOptions(), ['prompt'=>'所属单位']);
                        ?>
                        <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"  onclick="doExport()">导出</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 active"  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"  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'
    });
}
</script>