<?php

namespace api\service;

class ExportService
{

 public static $outPutFile = '';

 /**
 * 導(dǎo)出文件
 * @param string $fileName
 * @param $data
 * @param array $formFields
 * @return mixed
 */
 public static function exportData($fileName = '', $data, $formFields = [])
 {
 $fileArr = [];
 $tmpPath = \Yii::$app->params['excelSavePath'];

 foreach (array_chunk($data, 10000) as $key => $value) {
  self::$outPutFile = '';
  $subject  = !empty($fileName) ? $fileName : 'data_';
  $subject  .= date('YmdHis');
  if (empty($value) || empty($formFields)) {
  continue;
  }

  self::$outPutFile = $tmpPath . $subject . $key . '.csv';
  if (!file_exists(self::$outPutFile)) {
  touch(self::$outPutFile);
  }
  $index = array_keys($formFields);
  $header = array_values($formFields);
  self::outPut($header);

  foreach ($value as $k => $v) {
  $tmpData = [];
  foreach ($index as $item) {
   $tmpData[] = isset($v[$item]) ? $v[$item] : '';
  }
  self::outPut($tmpData);
  }
  $fileArr[] = self::$outPutFile;
 }
 
 $zipFile = $tmpPath . $fileName . date('YmdHi') . '.zip';
 $zipRes = self::zipFile($fileArr, $zipFile);
 return $zipRes;
 }

 /**
 * 向文件寫(xiě)入數(shù)據(jù)
 * @param array $data
 */
 public static function outPut($data = [])
 {
 if (is_array($data) && !empty($data)) {
  $data = implode(',', $data);
  file_put_contents(self::$outPutFile, iconv("UTF-8", "GB2312//IGNORE", $data) . PHP_EOL, FILE_APPEND);
 }
 }

 /**
 * 壓縮文件
 * @param $sourceFile
 * @param $distFile
 * @return mixed
 */
 public static function zipFile($sourceFile, $distFile)
 {
 $zip = new \ZipArchive();
 if ($zip->open($distFile, \ZipArchive::CREATE) !== true) {
  return $sourceFile;
 }

 $zip->open($distFile, \ZipArchive::CREATE);
 foreach ($sourceFile as $file) {
  $fileContent = file_get_contents($file);
  $file = iconv('utf-8', 'GBK', basename($file));
  $zip->addFromString($file, $fileContent);
 }
 $zip->close();
 return $distFile;
 }
 
 /**
 * 下載文件
 * @param $filePath
 * @param $fileName
 */
 public static function download($filePath, $fileName)
 {
 if (!file_exists($filePath . $fileName)) {
  header('HTTP/1.1 404 NOT FOUND');
 } else {
  //以只讀和二進(jìn)制模式打開(kāi)文件
  $file = fopen($filePath . $fileName, "rb");

  //告訴瀏覽器這是一個(gè)文件流格式的文件
  Header("Content-type: application/octet-stream");
  //請(qǐng)求范圍的度量單位
  Header("Accept-Ranges: bytes");
  //Content-Length是指定包含于請(qǐng)求或響應(yīng)中數(shù)據(jù)的字節(jié)長(zhǎng)度
  Header("Accept-Length: " . filesize($filePath . $fileName));
  //用來(lái)告訴瀏覽器，文件是可以當(dāng)做附件被下載，下載后的文件名稱為$file_name該變量的值
  Header("Content-Disposition: attachment; filename=" . $fileName);

  //讀取文件內(nèi)容并直接輸出到瀏覽器
  echo fread($file, filesize($filePath . $fileName));
  fclose($file);
  exit();
 }
 }
}

$fileName = "庫(kù)存導(dǎo)入模板";
$stockRes = []; // 導(dǎo)出的數(shù)據(jù)
$formFields = [
 'store_id' => '門(mén)店ID',
 'storeName' => '門(mén)店名稱',
 'sku' => 'SKU編碼',
 'name' => 'SKU名稱',
 'stock' => '庫(kù)存',
 'reason' => '原因'
];
$fileRes = ExportService::exportData($fileName, $stockRes, $formFields);
$tmpPath = \Yii::$app->params['excelSavePath']; // 文件路徑
$fileName = str_replace($tmpPath, '', $fileRes);

// 下載文件
ExportService::download($tmpPath, $fileName);