majiameng / spreadsheet-php

src/Gateways/Export.php

Braces +3 added lines, -3 removed lines

@@ -85,7 +85,7 @@ 
         if($this->workSheet == null){
             if($this->sheetCount==1){
                 $this->workSheet = $this->spreadSheet->getActiveSheet();
-            }else{
+            } else{
                 $this->workSheet = $this->spreadSheet->createSheet();
             }
             $this->sheetCount += 1;//总sheet数量
@@ -146,7 +146,7 @@ 
     public function download($filename=''){
         if(empty($filename)){
             $filename = $this->fileName;
-        }else{
+        } else{
             $filename = $this->getFileName($filename);
         }
 
@@ -176,7 +176,7 @@ 
         $pathName = $this->getPathName($pathName);
         if(empty($filename)){
             $filename = $this->fileName;
-        }else{
+        } else{
             $filename = $this->getFileName($filename);
         }
         FileTool::mkdir($pathName);

src/Connector/Gateway.php

Braces +3 added lines, -1 removed lines

@@ -67,7 +67,9 @@
      * @return mixed
      */
     protected function formatValue($v){
-        if($this->format === false) return $v;
+        if($this->format === false) {
+            return $v;
+        }
         if(is_numeric($v) && strlen($v)===10){
             $v = date($this->format_date,$v);//时间戳转时间格式
         }

src/Excel/SpreadSheet.php

Braces +7 added lines, -2 removed lines

@@ -136,10 +136,15 @@
                 $value = trim($cell->getFormattedValue());
                 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;
+            }
         }
 
         /*

src/Excel/TWorkSheet.php

Braces +18 added lines, -15 removed lines

@@ -106,7 +106,10 @@ 
         $this->fileTitle = [];
         $this->data = [];
         $this->field = [];
-        if($this->freezePane) $this->workSheet->freezePane($this->freezePane); //冻结窗格
+        if($this->freezePane) {
+            $this->workSheet->freezePane($this->freezePane);
+        }
+        //冻结窗格
     }
 
     /**
@@ -131,7 +134,7 @@ 
             $this->title_row = $fileTitle['title_row']??1;
             $this->group_left = $fileTitle['group_left']??[];
             $titleData = $fileTitle['title']??[];
-        }else{
+        } else{
             /**
              *  $fileTitle = [
              *       '姓名'=>'name',
@@ -142,7 +145,7 @@ 
         // 根据字段映射方式处理 title
         if ($this->fieldMappingMethod === ConstCode::FIELD_MAPPING_METHOD_FIELD_CORRESPONDING_NAME) {
             $this->fileTitle = array_flip($titleData);// 字段对应名称方式 - 需要将键值对调
-        }else{
+        } else{
             $this->fileTitle = $titleData;// 名称对应字段方式 - 保持原样
         }
         $this->data = $data;
@@ -161,7 +164,7 @@ 
                 foreach ($val as $k => $v){
                     $this->field[] = $v;
                 }
-            }else{
+            } else{
                 $this->field[] = $val;
             }
         }
@@ -182,7 +185,7 @@ 
             foreach ($this->data as $key => $val){
                 $this->excelSetCellValue($val);
             }
-        }else{   //根据设置分组字段进行分组
+        } else{   //根据设置分组字段进行分组
             /** 数据分组 **/
             $data = [];
             $group_left_count = count($this->group_left);
@@ -197,13 +200,13 @@ 
                     ];
                 }
                 $this->excelGroupLeft($data, $group_left_count);
-            }elseif($group_left_count == 2){
+            } elseif($group_left_count == 2){
                 foreach ($this->data as $v) {
                     $data[$v[$this->group_left[0]]][$v[$this->group_left[1]]][] = $v;
                 }
                 $this->data = $this->arrayCount($data);
                 $this->excelGroupLeft($this->data, $group_left_count);
-            }else{
+            } else{
                 throw new TinymengException(StatusCode::COMMON_PARAM_INVALID,
                     '左侧分组过多，导出失败！'
                 );
@@ -244,7 +247,7 @@ 
                     $this->workSheet->setCellValue($this->cellName($_cols) . ($this->_row+1), $k);
                     if(!empty($this->titleWidth)) {
                         $this->workSheet->getColumnDimension($this->cellName($_cols))->setWidth($this->titleWidth); //列宽度
-                    }else{
+                    } else{
                         $this->workSheet->getColumnDimension($this->cellName($_cols))->setAutoSize(true); //自动计算宽度
                     }
                     if ($num < count($val)) {
@@ -262,7 +265,7 @@ 
                 $this->workSheet->setCellValue($rowName . $this->_row, $key);//设置值
                 if(!empty($this->titleWidth)){
                     $this->workSheet->getColumnDimension($rowName)->setWidth($this->titleWidth); //列宽度
-                }else{
+                } else{
                     $this->workSheet->getColumnDimension($rowName)->setAutoSize(true); //自动计算宽度
                 }
             }
@@ -293,9 +296,9 @@ 
                 for ($i=0;$i<count($v);$i++){
                     $content = $content[$v[$i]]??'';
                 }
-            }elseif($v == '_id'){
+            } elseif($v == '_id'){
                 $content = $this->_row-$this->title_row;//自增序号列
-            }else{
+            } else{
                 $content = ($val[$v]??'');
             }
             if(is_array($content) && isset($content['type']) && isset($content['content'])){
@@ -319,15 +322,15 @@ 
                     $drawing->setCoordinates($rowName.$this->_row);
                     $drawing->setWorksheet($this->workSheet);
                 }
-            }else {
+            } else {
                 $content = $this->formatValue($content);//格式化数据
                 if (is_numeric($content)){
                     if($this->autoDataType && strlen($content)<11){
                         $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content,DataType::TYPE_NUMERIC);
-                    }else{
+                    } else{
                         $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content,DataType::TYPE_STRING2);
                     }
-                }else{
+                } else{
                     $this->workSheet->setCellValueExplicit($rowName.$this->_row, $content,DataType::TYPE_STRING2);
                 }
             }
@@ -369,7 +372,7 @@ 
                 foreach ($val['data'] as $data){
                     $this->excelSetCellValue($data);
                 }
-            }else{
+            } else{
                 $sub_group_start = $this->_row;
                 $rowName = $this->cellName($group_field_positions[1]); // 使用第二个分组字段的实际位置