615 行
25 KiB
PHP
可执行文件
615 行
25 KiB
PHP
可执行文件
<?php
|
||
|
||
namespace Common\Business;
|
||
|
||
//[1.8.50]
|
||
|
||
/**
|
||
* 下载类
|
||
* Class DownFile
|
||
* [
|
||
* 下载指定路径文件 downFile
|
||
* 打包并下载压缩包 downloadZip
|
||
* 添加文件到压缩包 addFileToZip
|
||
* 删除目录下的所有文件 delDirFile
|
||
* 商品导入模板下载 GoodsTemplate
|
||
* 导入商品失败文件下载 GoodsImportFail
|
||
* 读取上传的文件 readFile
|
||
* 读取上传的文件新版 readFile_v1
|
||
* ]
|
||
* @package Common\Business
|
||
*/
|
||
class DownFile
|
||
{
|
||
/**
|
||
* 下载指定路径文件
|
||
* @param $param
|
||
* [
|
||
* file_path 路径
|
||
* file_name 文件名
|
||
* file_type 文件类型
|
||
* ]
|
||
*/
|
||
public function downFile($param)
|
||
{
|
||
$filename = realpath($param['file_path']); //文件名
|
||
$file_name = $param['file_name'] . $param['file_type'];
|
||
Header("Content-type: application/octet-stream ");
|
||
Header("Accept-Ranges: bytes ");
|
||
Header("Accept-Length: " . filesize($filename));
|
||
header("Content-Disposition: attachment; filename= {$file_name}");
|
||
readfile($filename);
|
||
unlink($param['file_path']);
|
||
}
|
||
|
||
|
||
/**
|
||
* 打包并下载压缩包
|
||
* @param $param
|
||
* [
|
||
* directory_name 文件夹路径
|
||
* zip_name 压缩包名称
|
||
* store_arr 门店集合[id=>name]
|
||
* file_name_arr 文件名集合[id=>name]
|
||
* file_type 压缩包中文件的后缀
|
||
* ]
|
||
*/
|
||
public function downloadZip($param)
|
||
{
|
||
header("Content-Type:text/html;charset=utf-8");
|
||
$directory_name = $param['directory_name'];
|
||
$zip_name = $param['zip_name'];
|
||
$file_type = $param['file_type'];
|
||
$file_name_arr = $param['file_name_arr'];
|
||
$store_arr = $param['store_arr'];
|
||
if (!is_dir($directory_name)) {
|
||
echo '文件不存在';
|
||
}
|
||
try {
|
||
$zip = new \ZipArchive();
|
||
$zip_url = $directory_name . '/' . $zip_name . date('Y-m-d_H_i_s') . '.zip';
|
||
if ($zip->open($zip_url, \ZipArchive::CREATE) === TRUE) {
|
||
$this->addFileToZip($directory_name, $zip, $store_arr, $file_name_arr, $file_type); //调用方法，对要打包的根目录进行操作，并将ZipArchive的对象传递给方法
|
||
$zip->close(); //关闭处理的zip文件
|
||
if (!file_exists($zip_url)) { //判断文件是否存在
|
||
echo "文件不存在";
|
||
exit();
|
||
}
|
||
$file = fopen($zip_url, "r");
|
||
Header("Content-type:application/octet-stream");
|
||
header("Accept-Ranges: bytes");
|
||
header("Accept-Length: " . filesize($zip_url));
|
||
header("Content-Disposition: attachment; filename={$zip_name}" . date('Y-m-d_H:i:s') . ".zip");
|
||
echo fread($file, filesize($zip_url));
|
||
fclose($file);
|
||
$this->delDirFile($directory_name); //删除文件夹下的所有文件
|
||
rmdir($directory_name); //删除当前文件夹
|
||
unlink($zip_url); //删除压缩包
|
||
}
|
||
} catch (\Exception $e) {
|
||
echo '文件不存在';
|
||
}
|
||
}
|
||
|
||
|
||
/**
|
||
* 添加文件到压缩包
|
||
* @param $path
|
||
* @param $zip
|
||
* @param store_arr 门店集合[id=>name] 或者 门店的名称 arr|string
|
||
* @param file_name_arr 文件名集合[id=>name] 或者文件的名称 arr|string
|
||
* @param string $file_type 文件后缀
|
||
*/
|
||
public function addFileToZip($path, $zip, $store_arr, $file_name_arr, $file_type = 'txt')
|
||
{
|
||
header("Content-Type:text/html;charset=utf-8");
|
||
$handler = opendir($path); //打开当前文件夹由$path指定。
|
||
while (($filename = readdir($handler)) !== false) {
|
||
if ($filename != "." && $filename != "..") { //文件夹文件名字为'.'和‘..'，不要对他们进行操作
|
||
if (is_dir($path . "/" . $filename)) { // 如果读取的某个对象是文件夹，则递归
|
||
$this->addFileToZip($path . "/" . $filename, $zip, $store_arr, $file_name_arr, $file_type);
|
||
} else { //将文件加入zip对象
|
||
$name = '';
|
||
$new_filename = explode('_', $filename); //服务器文件的名称
|
||
if (!empty($store_arr) && is_array($store_arr)) {
|
||
$name .= $store_arr[$new_filename[0]] . '的';
|
||
} else {
|
||
$name .= $store_arr;
|
||
}
|
||
if (!empty($file_name_arr) && is_array($file_name_arr)) {
|
||
$name .= $file_name_arr[$new_filename[1]];
|
||
} else {
|
||
$name .= $file_name_arr;
|
||
}
|
||
$name = ($name ? $name : 'w') . '.' . $file_type;
|
||
$dir = iconv("utf-8", "gb2312", $name);
|
||
$zip->addFile($path . "/" . $filename, $dir);
|
||
}
|
||
}
|
||
}
|
||
@closedir($handler);
|
||
}
|
||
|
||
|
||
/**
|
||
* 删除目录下的所有文件
|
||
* @param $dir 目录地址
|
||
*/
|
||
public function delDirFile($dir)
|
||
{
|
||
$dh = opendir($dir);
|
||
while ($file = readdir($dh)) {
|
||
if ($file != "." && $file != "..") {
|
||
$full_path = $dir . "/" . $file;
|
||
if (!is_dir($full_path)) {
|
||
unlink($full_path);
|
||
} else {
|
||
$this->delDirFile($full_path);
|
||
}
|
||
}
|
||
}
|
||
|
||
closedir($dh);
|
||
}
|
||
|
||
|
||
/**
|
||
* 图片
|
||
* @param $url
|
||
* @return string
|
||
*/
|
||
public function image($url)
|
||
{
|
||
$header = array(
|
||
'User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0',
|
||
'Accept-Language: zh-CN,zh;q=0.8,en-US;q=0.5,en;q=0.3',
|
||
'Accept-Encoding: gzip, deflate',);
|
||
|
||
$curl = curl_init();
|
||
curl_setopt($curl, CURLOPT_URL, $url);
|
||
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
|
||
curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true);
|
||
curl_setopt($curl, CURLOPT_ENCODING, 'gzip');
|
||
curl_setopt($curl, CURLOPT_HTTPHEADER, $header);
|
||
$data = curl_exec($curl);
|
||
$code = curl_getinfo($curl, CURLINFO_HTTP_CODE);
|
||
curl_close($curl);
|
||
if ($code == 200) {//把URL格式的图片转成base64_encode格式的！
|
||
$imgBase64Code = "data:image/jpeg;base64," . base64_encode($data);
|
||
}
|
||
$img_content = $imgBase64Code;//图片内容
|
||
if (preg_match('/^(data:\s*image\/(\w+);base64,)/', $img_content, $result)) {
|
||
$type = $result[2];//得到图片类型png?jpg?gif?
|
||
$fileData = base64_decode(str_replace($result[1], '', $img_content));
|
||
$image_name = "headimg." . $type;
|
||
$upload_dir = './upload/img/';
|
||
if (!file_exists($upload_dir)) {
|
||
mkdir($upload_dir, 0777, true);
|
||
}
|
||
$filedir = $upload_dir . '/' . $image_name;
|
||
$src = './upload/img/' . $image_name;
|
||
if (file_put_contents($filedir, $fileData)) {
|
||
return $src;
|
||
}
|
||
}
|
||
}
|
||
|
||
|
||
/**
|
||
* 商品导入模板下载
|
||
* @param $platform_type
|
||
* [
|
||
* platform_type 商户平台类型 1默认系统 2微礼平台
|
||
* ]
|
||
*/
|
||
public function GoodsTemplate($platform_type = 1)
|
||
{
|
||
$type = I('get.attribute_state');
|
||
switch ($platform_type) {
|
||
case 1:
|
||
switch ($type) {
|
||
case 1:
|
||
//无规格
|
||
$url = './Public/flow/zip/GoodsTemplate.xls';
|
||
break;
|
||
case 2:
|
||
//规格
|
||
$url = './Public/flow/zip/SkuGoodsTemplate.xls';
|
||
}
|
||
break;
|
||
case 2:
|
||
switch ($type) {
|
||
case 1:
|
||
//无规格
|
||
$url = './Public/flow/zip/ThirdGoodsTemplate.xls';
|
||
break;
|
||
case 2:
|
||
//规格
|
||
$url = './Public/flow/zip/ThirdSkuGoodsTemplate.xls';
|
||
}
|
||
break;
|
||
}
|
||
if (!file_exists($url)) { //判断文件是否存在
|
||
echo "文件不存在";
|
||
exit();
|
||
}
|
||
$file = fopen($url, "r");
|
||
Header("Content-type:application/octet-stream");
|
||
header("Accept-Ranges: bytes");
|
||
header("Accept-Length: " . filesize($url));
|
||
header("Content-Disposition: attachment; filename=导入模板.xls");
|
||
echo fread($file, filesize($url));
|
||
fclose($file);
|
||
}
|
||
|
||
|
||
/**
|
||
* 导入商品失败文件下载
|
||
* @param $parameter
|
||
* [
|
||
* platform_type 商户平台类型 1默认系统 2微礼平台
|
||
* user_type 3商户后台 4门店后台
|
||
* merchant_id
|
||
* store_id
|
||
* attribute_state 1无规格 2规格
|
||
* ]
|
||
* @throws \PHPExcel_Exception
|
||
* @throws \PHPExcel_Reader_Exception
|
||
* @throws \PHPExcel_Writer_Exception
|
||
*/
|
||
public function GoodsImportFail($parameter)
|
||
{
|
||
switch ($parameter['platform_type']) {
|
||
case 1:
|
||
switch ($parameter['user_type']) {
|
||
case 3:
|
||
//商户
|
||
switch ($parameter['attribute_state']) {
|
||
case 1:
|
||
$path2 = './Uploads/Temp/Mgoodsinport' . $parameter['merchant_id'] . '.txt';
|
||
break;
|
||
case 2:
|
||
$path2 = './Uploads/Temp/MSkugoodsinport' . $parameter['merchant_id'] . '.txt';
|
||
break;
|
||
}
|
||
break;
|
||
case 4:
|
||
//门店
|
||
switch ($parameter['attribute_state']) {
|
||
case 1:
|
||
$path2 = './Uploads/Temp/StoreGoodsImport' . $parameter['merchant_id'] . $parameter['store_id'] . '.txt';
|
||
break;
|
||
case 2:
|
||
//规格
|
||
$path2 = './Uploads/Temp/StoreSkuGoodsImport' . $parameter['merchant_id'] . $parameter['store_id'] . '.txt';
|
||
break;
|
||
}
|
||
break;
|
||
}
|
||
break;
|
||
case 2:
|
||
switch ($parameter['user_type']) {
|
||
case 3:
|
||
//商户
|
||
switch ($parameter['attribute_state']) {
|
||
case 1:
|
||
$path2 = './Uploads/Temp/ThirdMgoodsinport' . $parameter['merchant_id'] . '.txt';
|
||
break;
|
||
case 2:
|
||
$path2 = './Uploads/Temp/ThirdMSkugoodsinport' . $parameter['merchant_id'] . '.txt';
|
||
break;
|
||
}
|
||
break;
|
||
case 4:
|
||
//门店
|
||
switch ($parameter['attribute_state']) {
|
||
case 1:
|
||
$path2 = './Uploads/Temp/ThirdStoreGoodsImport' . $parameter['merchant_id'] . $parameter['store_id'] . '.txt';
|
||
break;
|
||
case 2:
|
||
//规格
|
||
$path2 = './Uploads/Temp/ThirdStoreSkuGoodsImport' . $parameter['merchant_id'] . $parameter['store_id'] . '.txt';
|
||
break;
|
||
}
|
||
break;
|
||
}
|
||
break;
|
||
}
|
||
//导入PHPExcel类库，因为PHPExcel没有用命名空间，只能import导入
|
||
import("Vendor.PHPExcel.PHPExcel");
|
||
import("Vendor.PHPExcel.Writer.Excel5");
|
||
import("Vendor.PHPExcel.IOFactory.php");
|
||
$arr = file_get_contents($path2);
|
||
$arr = json_decode($arr, true);
|
||
$filename = "导入失败单据明细";
|
||
switch ($parameter['attribute_state']) {
|
||
case 1:
|
||
$headArr = [
|
||
'0' => '商品名称（必填）',
|
||
'1' => '副标题',
|
||
'2' => '品牌名称',
|
||
'3' => '条码',
|
||
'4' => '货号（必填）',
|
||
'5' => '第一级分类（必填）',
|
||
'6' => '第二级分类',
|
||
'7' => '第三级分类',
|
||
'8' => '商品总库存',
|
||
'9' => '进货价',
|
||
'10' => '店内零售价（开启店内出售后必填）',
|
||
'11' => '商城零售价（开启商城出售后必填）',
|
||
'12' => '店内会员价（开启店内会员价必填）',
|
||
'13' => '商城会员价（开启商城会员价必填）',
|
||
'14' => '是否开启店内出售',
|
||
'15' => '是否开启商城出售',
|
||
'16' => '是否开启店内会员价',
|
||
'17' => '是否开启商城会员价',
|
||
'18' => '是否称重',
|
||
'19' => '是否开启线上折扣',
|
||
'20' => '是否开启线下折扣',
|
||
'21' => '是否开启串号',
|
||
'22' => '库存上限（超量值）',
|
||
'23' => '库存下限（预警值）',
|
||
'24' => '单位',
|
||
'25' => '重量（Kg）',
|
||
'26' => '规格',
|
||
'reson' => '失败原因'
|
||
];
|
||
if ($parameter['platform_type'] == 2) {
|
||
$headArr = [
|
||
'0' => '商品名称（必填）',
|
||
'1' => '副标题',
|
||
'2' => '品牌名称',
|
||
'3' => '条码',
|
||
'4' => '货号（必填）',
|
||
'5' => '第一级分类（必填）',
|
||
'6' => '第二级分类',
|
||
'7' => '第三级分类',
|
||
'8' => '商品总库存',
|
||
'9' => '进货价',
|
||
'10' => '店内零售价（开启店内出售后必填）',
|
||
'11' => '商城零售价（开启商城出售后必填）',
|
||
'12' => '店内会员价（开启店内会员价必填）',
|
||
'13' => '商城会员价（开启商城会员价必填）',
|
||
'14' => '是否开启店内出售',
|
||
'15' => '是否开启商城出售',
|
||
'16' => '是否开启店内会员价',
|
||
'17' => '是否开启商城会员价',
|
||
'18' => '是否称重',
|
||
'19' => '是否开启线上折扣',
|
||
'20' => '是否开启线下折扣',
|
||
'21' => '是否开启串号',
|
||
'22' => '库存上限（超量值）',
|
||
'23' => '库存下限（预警值）',
|
||
'24' => '单位',
|
||
'25' => '重量（Kg）',
|
||
'26' => '规格',
|
||
'27' => 'Q3 ERP平台商品编码',
|
||
'reson' => '失败原因'
|
||
];
|
||
}
|
||
break;
|
||
case 2:
|
||
$headArr = array(
|
||
'0' => '商品名称（必填）',
|
||
'1' => '副标题',
|
||
'2' => '品牌名称',
|
||
'3' => '条码',
|
||
'4' => '货号（必填）',
|
||
'5' => '第一级分类（必填）',
|
||
'6' => '第二级分类',
|
||
'7' => '第三级分类',
|
||
'8' => '商品总库存',
|
||
'9' => '进货价',
|
||
'10' => '店内零售价（开启店内出售后必填）',
|
||
'11' => '商城零售价（开启商城出售后必填）',
|
||
'12' => '店内会员价（开启店内会员价必填）',
|
||
'13' => '商城会员价（开启商城会员价必填）',
|
||
'14' => '是否开启店内出售',
|
||
'15' => '是否开启商城出售',
|
||
'16' => '是否开启店内会员价',
|
||
'17' => '是否开启商城会员价',
|
||
'18' => '是否开启线上折扣',
|
||
'19' => '是否开启线下折扣',
|
||
'20' => '是否开启串号',
|
||
'21' => '库存上限（超量值）',
|
||
'22' => '库存下限（预警值）',
|
||
'23' => '单位',
|
||
'24' => '重量（Kg）',
|
||
'25' => '规格',
|
||
'26' => '规格1',
|
||
'27' => '规格值1',
|
||
'28' => '规格2',
|
||
'29' => '规格值2',
|
||
'30' => '规格3',
|
||
'31' => '规格值3',
|
||
'32' => '规格4',
|
||
'33' => '规格值4',
|
||
'34' => '规格货号（必填）',
|
||
'35' => '规格条码',
|
||
'36' => '规格库存',
|
||
'37' => '规格上限',
|
||
'38' => '规格下限',
|
||
'39' => '规格进价',
|
||
'40' => '规格店内零售价（必填）',
|
||
'41' => '规格商城售价（必填）',
|
||
'42' => '规格店内会员价（必填）',
|
||
'43' => '规格商城会员价（必填）',
|
||
'44' => '规格重量（Kg）',
|
||
'reson' => '失败原因'
|
||
);
|
||
if ($parameter['platform_type'] == 2) {
|
||
$headArr = array(
|
||
'0' => '商品名称（必填）',
|
||
'1' => '副标题',
|
||
'2' => '品牌名称',
|
||
'3' => '条码',
|
||
'4' => '货号（必填）',
|
||
'5' => '第一级分类（必填）',
|
||
'6' => '第二级分类',
|
||
'7' => '第三级分类',
|
||
'8' => '商品总库存',
|
||
'9' => '进货价',
|
||
'10' => '店内零售价（开启店内出售后必填）',
|
||
'11' => '商城零售价（开启商城出售后必填）',
|
||
'12' => '店内会员价（开启店内会员价必填）',
|
||
'13' => '商城会员价（开启商城会员价必填）',
|
||
'14' => '是否开启店内出售',
|
||
'15' => '是否开启商城出售',
|
||
'16' => '是否开启店内会员价',
|
||
'17' => '是否开启商城会员价',
|
||
'18' => '是否开启线上折扣',
|
||
'19' => '是否开启线下折扣',
|
||
'20' => '是否开启串号',
|
||
'21' => '库存上限（超量值）',
|
||
'22' => '库存下限（预警值）',
|
||
'23' => '单位',
|
||
'24' => '重量（Kg）',
|
||
'25' => '规格',
|
||
'26' => '规格1',
|
||
'27' => '规格值1',
|
||
'28' => '规格2',
|
||
'29' => '规格值2',
|
||
'30' => '规格3',
|
||
'31' => '规格值3',
|
||
'32' => '规格4',
|
||
'33' => '规格值4',
|
||
'34' => '规格货号（必填）',
|
||
'35' => '规格条码',
|
||
'36' => '规格库存',
|
||
'37' => '规格上限',
|
||
'38' => '规格下限',
|
||
'39' => '规格进价',
|
||
'40' => '规格店内零售价（必填）',
|
||
'41' => '规格商城售价（必填）',
|
||
'42' => '规格店内会员价（必填）',
|
||
'43' => '规格商城会员价（必填）',
|
||
'44' => '规格重量（Kg）',
|
||
'45' => 'Q3 ERP平台商品编码',
|
||
'reson' => '失败原因'
|
||
);
|
||
}
|
||
break;
|
||
}
|
||
$headArr2 = array();
|
||
foreach ($headArr as $k => $v) {
|
||
$headArr2[] = array($k, $v);
|
||
}
|
||
unlink($path2);
|
||
getExcel($filename, $headArr2, $arr);
|
||
}
|
||
|
||
|
||
/**
|
||
*读取上传的文件
|
||
* @param $file 文件的路径
|
||
* @return array
|
||
* [
|
||
* error 1成功
|
||
* array
|
||
* ]
|
||
* @throws \PHPExcel_Exception
|
||
* @throws \PHPExcel_Reader_Exception
|
||
*/
|
||
public function readFile($file)
|
||
{
|
||
/* Vendor("PHPExcel.PHPExcel.IOFactory");
|
||
$objPHPExcel = \PHPExcel_IOFactory::load($file);
|
||
$allWorksheets = $objPHPExcel->getAllSheets();
|
||
$allWorksheets_count = count($allWorksheets);
|
||
$arr = [];
|
||
for($i=0;$i<$allWorksheets_count;$i++){
|
||
$arr[] = $objPHPExcel->getSheet($i)->toArray();
|
||
}
|
||
$res['error'] =1;
|
||
$res['data'] =$arr;
|
||
return $res;*/
|
||
if (!file_exists($file)) {
|
||
return array("error" => 0, 'message' => 'file not found!');
|
||
}
|
||
Vendor("PHPExcel.PHPExcel.IOFactory");
|
||
$objReader = \PHPExcel_IOFactory::createReader('Excel5');
|
||
try {
|
||
$PHPReader = $objReader->load($file);
|
||
} catch (\Exception $e) {
|
||
}
|
||
if (!isset($PHPReader)) return array("error" => 0, 'message' => 'read error!');
|
||
$allWorksheets = $PHPReader->getAllSheets();
|
||
$i = 0;
|
||
foreach ($allWorksheets as $objWorksheet) {
|
||
$sheetname = $objWorksheet->getTitle();
|
||
$allRow = $objWorksheet->getHighestRow();//how many rows
|
||
$highestColumn = $objWorksheet->getHighestColumn();//how many columns
|
||
$allColumn = \PHPExcel_Cell::columnIndexFromString($highestColumn);
|
||
$array[$i]["Title"] = $sheetname;
|
||
$array[$i]["Cols"] = $allColumn;
|
||
$array[$i]["Rows"] = $allRow;
|
||
$arr = array();
|
||
$isMergeCell = array();
|
||
foreach ($objWorksheet->getMergeCells() as $cells) {//merge cells
|
||
foreach (\PHPExcel_Cell::extractAllCellReferencesInRange($cells) as $cellReference) {
|
||
$isMergeCell[$cellReference] = true;
|
||
}
|
||
}
|
||
for ($currentRow = 1; $currentRow <= $allRow; $currentRow++) {
|
||
$row = array();
|
||
for ($currentColumn = 0; $currentColumn < $allColumn; $currentColumn++) {
|
||
$objWorksheet->getCellByColumnAndRow($currentColumn, $currentRow);
|
||
$afCol = \PHPExcel_Cell::stringFromColumnIndex($currentColumn + 1);
|
||
$bfCol = \PHPExcel_Cell::stringFromColumnIndex($currentColumn - 1);
|
||
$col = \PHPExcel_Cell::stringFromColumnIndex($currentColumn);
|
||
$address = $col . $currentRow;
|
||
$value = $objWorksheet->getCell($address)->getFormattedValue();
|
||
if (substr($value, 0, 1) == '=') {
|
||
return array("error" => 0, 'message' => 'can not use the formula!');
|
||
exit;
|
||
}
|
||
if ($isMergeCell[$col . $currentRow] && $isMergeCell[$afCol . $currentRow] && !empty($value)) {
|
||
$temp = $value;
|
||
} elseif ($isMergeCell[$col . $currentRow] && $isMergeCell[$col . ($currentRow - 1)] && empty($value)) {
|
||
$value = $arr[$currentRow - 1][$currentColumn];
|
||
} elseif ($isMergeCell[$col . $currentRow] && $isMergeCell[$bfCol . $currentRow] && empty($value)) {
|
||
$temp = $value;
|
||
}
|
||
$row[$currentColumn] = $value;
|
||
}
|
||
$arr[$currentRow] = $row;
|
||
}
|
||
$array[$i]["Content"] = $arr;
|
||
$i++;
|
||
}
|
||
unset($objWorksheet);
|
||
unset($PHPReader);
|
||
unset($PHPExcel);
|
||
unlink($file);
|
||
return array("error" => 1, "data" => $array);
|
||
}
|
||
|
||
|
||
/**
|
||
*读取上传的文件
|
||
* @param $file 文件的路径
|
||
* @return array
|
||
* [
|
||
* error 1成功
|
||
* array
|
||
* ]
|
||
* @throws \PHPExcel_Exception
|
||
* @throws \PHPExcel_Reader_Exception
|
||
*/
|
||
public function readFile_v1($file)
|
||
{
|
||
Vendor("PHPExcel.PHPExcel.IOFactory");
|
||
$objPHPExcel = \PHPExcel_IOFactory::load($file);
|
||
$allWorksheets = $objPHPExcel->getAllSheets();
|
||
$allWorksheets_count = count($allWorksheets);
|
||
$arr = [];
|
||
for ($i = 0; $i < $allWorksheets_count; $i++) {
|
||
$arr[] = $objPHPExcel->getSheet($i)->toArray();
|
||
}
|
||
if (!empty($arr)) {
|
||
return callBack(statusCode()['success'], '获取成功', $arr);
|
||
} else {
|
||
return callBack(statusCode()['error'], '该文件暂无数据');
|
||
}
|
||
}
|
||
} |