任何人都可以检查,我在哪里弄错了,为什么下载期间我得到了空记录。请看看我的代码。
public function selloutitem_search(Request $request)
{
$dstart = $request->get('dstart');
$dstop = $request->get('dstop');
$cat = $request->get('cat');
$branch = $request->get('branch');
$ddstart = date('Y-m-d',strtotime($dstart));
$ddstop = date('Y-m-d',strtotime($dstop));
$Sellout = DB::table('Sellout')
->Where('custom2',$cat)
->Where('Code',$branch)
->whereBetween('docket_date',[$ddstart,$ddstop])
//->orderBy('description','asc');
//->paginate(100);
->get();
foreach ($Sellout as $order)
{
$data[] = array(
"Barcode"=> $order->Barcode,);
}
return Excel::download($data,'report.xlsx');
}