chunk()闭包函数下载数据,use传递外部数据
$line = 1;
$objActSheet->setCellValue("A".$line,"sale_record_number");
$objActSheet->setCellValue("B".$line,"seller_sku");
$objActSheet->setCellValue("C".$line,"ERP Sku");
$objActSheet->setCellValue("D".$line,"principal");
$objActSheet->setCellValue("E".$line,"quantity");
$objActSheet->setCellValue("F".$line,"commission");
$objActSheet->setCellValue("G".$line,"shipping_charge");
$objActSheet->setCellValue("H".$line,"currency");
$objActSheet->setCellValue("I".$line,"update_time");
$query->chunk(100,function($finances) use(&$objActSheet,&$line){
foreach ($finances as $key => $finance)
{
$line = $line + 1;
$objActSheet->setCellValue("A".$line,$finance->sale_record_number);
$objActSheet->setCellValue("B".$line,$finance->seller_sku);
$objActSheet->setCellValue("C".$line,$finance->erpSku());
$objActSheet->setCellValue("D".$line,$finance->principal);
$objActSheet->setCellValue("E".$line,$finance->quantity);
$objActSheet->setCellValue("F".$line,$finance->commission);
$objActSheet->setCellValue("G".$line,$finance->shipping_charge);
第11行核心代码