一键从Laravel下载2个Excell文件

Question

路线：

Route::get('/exportPurchasing', 'SummaryController@exportPurchasing')->name('exportPurchasing');

控制器：

public function exportPurchasing(Request $request)
{
return [
Excel::download(new exportRekapPurchasing, 'RekapPurchasing.xlsx'),
Excel::download(new exportChecklistWH, 'RekapChecklistWH.xlsx')
];
}

刀片：

<form method="get" action="{{ route('exportPurchasing') }}" enctype="multipart/form-data">
<div class="input-group">
<input type="text" name="date" class="form-control datepicker" autocomplete="off" value="">
<div class="input-group-append">
<button type="submit" class="btn btn-primary"><i class="fas fa-download"></i> Rekap Purchasing and Checklis WH</button>
</div>
</div>
</form>

当我单击按钮时，我想导出数据吗？我用过maatewbsite excel

Answer 1

只需在您的按钮上尝试一下：

<button type="submit" onclick="downloadTwo()" class="btn btn-primary">

Rekap采购和Checklis WH

并定义JS函数如下：

function downloadTwo(){
//jquery selection can be achieve via vanilla JS
let dateVal = $("[name='date']").val();
window.open("{{route('exportPurchasing')}}?data=purcache&date="+dateVal,"_blank");
window.open("{{route('exportPurchasing')}}?data=checklist&date="+dateVal,"_blank");
return false;
}

控制器中：

public function exportPurchasing(Request $request)
{
switch($request->data){

case "purcache":
return Excel::download(new exportRekapPurchasing, 'RekapPurchasing.xlsx');
case "checklist":
return Excel::download(new exportChecklistWH, 'RekapChecklistWH.xlsx');
default :
return null;
}
}