majiameng / spreadsheet-php

src/Excel/SpreadSheet.php

Spacing +26 added lines, -26 removed lines

@@ -12,7 +12,7 @@ 
 use PhpOffice\PhpSpreadsheet\Worksheet\Drawing;
 use tinymeng\tools\FileTool;
 
-trait SpreadSheet{
+trait SpreadSheet {
 
     /**
      * sheet名称
@@ -29,7 +29,7 @@ 
      * 文件信息
      * @var array
      */
-    private $fileTitle=[];
+    private $fileTitle = [];
 
     /**
      * 标题占用行数
@@ -90,7 +90,7 @@ 
      */
     public $image_path = '/images';
 
-    public function setTitle($title){
+    public function setTitle($title) {
         $this->title = $title;
         $this->getTitleFields();
         return $this;
@@ -100,7 +100,7 @@ 
      * @param $value
      * @return $this
      */
-    public function setRelativePath($value){
+    public function setRelativePath($value) {
         $this->relative_path = $value;
         return $this;
     }
@@ -109,7 +109,7 @@ 
      * @param $value
      * @return $this
      */
-    public function setImagePath($value){
+    public function setImagePath($value) {
         $this->image_path = $value;
         return $this;
     }
@@ -121,40 +121,40 @@ 
      * @author: Tinymeng <666@majiameng.com>
      * @time: 2022/2/22 11:30
      */
-    public function getExcelData(){
+    public function getExcelData() {
         /* 循环读取每个单元格的数据 */
         $result = [];
-        $dataRow = $this->titleFieldsRow+1;
+        $dataRow = $this->titleFieldsRow + 1;
 
         //行数循环
-        for ($row = $dataRow; $row <= $this->rowCount; $row++){
-            $rowFlog = false;//行是否有内容（过滤空行）
+        for ($row = $dataRow; $row <= $this->rowCount; $row++) {
+            $rowFlog = false; //行是否有内容（过滤空行）
             //列数循环 , 列数是以A列开始
             $data = [];
-            foreach ($this->cellName as $column){
+            foreach ($this->cellName as $column) {
                 $cell = $this->workSheet->getCell($column.$row);
                 $value = trim($cell->getFormattedValue());
-                if(isset($this->title_fields[$column])){
+                if (isset($this->title_fields[$column])) {
                     $data[$this->title_fields[$column]] = $value;
-                    if(!empty($value)) $rowFlog = true;//有内容
+                    if (!empty($value)) $rowFlog = true; //有内容
                 }
             }
-            if($rowFlog) $result[] = $data;
+            if ($rowFlog) $result[] = $data;
         }
 
         /*
          * 读取表格图片数据
          * (如果为空右击图片转为浮动图片)
          */
-        $image_filename_prefix = time().rand(100,999).$this->sheet;
+        $image_filename_prefix = time().rand(100, 999).$this->sheet;
         foreach ($this->workSheet->getDrawingCollection() as $drawing) {
             /**@var $drawing Drawing* */
             list($column, $row) = Coordinate::coordinateFromString($drawing->getCoordinates());
-            $image_filename = "/{$image_filename_prefix}-" . $drawing->getCoordinates();
+            $image_filename = "/{$image_filename_prefix}-".$drawing->getCoordinates();
             $image_suffix = $this->saveImage($drawing, $image_filename);
-            $image_name = ltrim($this->relative_path, '/') . "{$image_filename}.{$image_suffix}";
-            if(isset($this->title_fields[$column])) {
-                $result[$row-($this->titleFieldsRow+1)][$this->title_fields[$column]] = $image_name;
+            $image_name = ltrim($this->relative_path, '/')."{$image_filename}.{$image_suffix}";
+            if (isset($this->title_fields[$column])) {
+                $result[$row - ($this->titleFieldsRow + 1)][$this->title_fields[$column]] = $image_name;
             }
         }
         return $result;
@@ -166,7 +166,7 @@ 
      * @author: Tinymeng <666@majiameng.com>
      * @time: 2022/2/22 11:30
      */
-    public function getTitle(){
+    public function getTitle() {
         return $this->title;
     }
 
@@ -176,21 +176,21 @@ 
      * @author: Tinymeng <666@majiameng.com>
      * @time: 2022/2/22 11:30
      */
-    public function getTitleFields(){
+    public function getTitleFields() {
         $title = $this->getTitle();
 
         $row = $this->titleFieldsRow;
         $titleDataArr = [];
 
-        foreach ($this->cellName as $column){
+        foreach ($this->cellName as $column) {
             $value = trim($this->workSheet->getCell($column.$row)->getValue());
-            if(!empty($value)){
+            if (!empty($value)) {
                 $titleDataArr[$value] = $column;
             }
         }
         $title_fields = [];
         foreach ($title as $key=>$value) {
-            if(isset($titleDataArr[$key])){
+            if (isset($titleDataArr[$key])) {
                 $title_fields[$titleDataArr[$key]] = $value;
             }
         }
@@ -220,13 +220,13 @@ 
                 $real_extension = 'jpg';
                 $image_filename .= '.'.$real_extension;
                 $source = imagecreatefromjpeg($drawing->getPath());
-                imagejpeg($source, $this->image_path . $image_filename);
+                imagejpeg($source, $this->image_path.$image_filename);
                 break;
             case 'image/gif':
                 $real_extension = 'gif';
                 $image_filename .= '.'.$real_extension;
                 $source = imagecreatefromgif($drawing->getPath());
-                imagegif($source, $this->image_path . $image_filename);
+                imagegif($source, $this->image_path.$image_filename);
                 break;
             case 'image/png':
                 $real_extension = 'png';
@@ -235,7 +235,7 @@ 
                 // 保持透明度设置
                 imagealphablending($source, false);
                 imagesavealpha($source, true);
-                imagepng($source, $this->image_path . $image_filename);
+                imagepng($source, $this->image_path.$image_filename);
                 break;
             default:
                 throw new Exception('image format error!');