CellValueHandler::setCellValue() - Code Metrics - majiameng/spreadsheet-php - Measure and Improve Code Quality continuously with Scrutinizer

CellValueHandler::setCellValue() C
last analyzed 2025-11-03 14:32 UTC

↳ Parent: CellValueHandler

Complexity

Conditions	15
Paths	38

Size

Total Lines	65
Code Lines	34

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	15
eloc	34
c	0
b	0
f	0
nc	38
nop	9
dl	0
loc	65
rs	5.9166

How to fix Long Method Complexity Many Parameters

<?php
/**
 * @name: CellValueHandler
 * @author: JiaMeng <[email protected]>
 * @file: CellValueHandler.php
 * @Date: 2025/01/XX
 */
namespace tinymeng\spreadsheet\Excel\Handler;

use PhpOffice\PhpSpreadsheet\Cell\DataType;
use PhpOffice\PhpSpreadsheet\Worksheet\Drawing;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use tinymeng\spreadsheet\Util\WorkSheetHelper;

class CellValueHandler
{
    /**
     * 设置单元格值
     * @param Worksheet $worksheet
     * @param array $val 数据行
     * @param array $fields 字段列表
     * @param int $row 当前行
     * @param int $titleRow 标题行数
     * @param int|null $height 行高
     * @param bool $autoDataType 是否自动数据类型
     * @param bool $format 是否格式化内容
     * @param string $formatDate 日期格式
     * @return int 返回更新后的行号
     */
    public static function setCellValue(
        Worksheet $worksheet,
        array $val,
        array $fields,
        int $row,
        int $titleRow,
        ?int $height = null,
        bool $autoDataType = false,
        bool $format = true,
        string $formatDate = 'Y-m-d H:i:s'
    ): int {
        // 设置单元格行高
        if (!empty($height)) {
            $worksheet->getRowDimension($row)->setRowHeight($height);
        }
        
        $_lie = 0;
        foreach ($fields as $v) {
            $rowName = WorkSheetHelper::cellName($_lie);

            // 处理嵌套字段（如 'user.name'）
            if (strpos($v, '.') !== false) {
                $v = explode('.', $v);
                $content = $val;
                for ($i = 0; $i < count($v); $i++) {
for ($i=0; $i<count($array); $i++) { // calls count() on each iteration
}

// Better
for ($i=0, $c=count($array); $i<$c; $i++) { // calls count() just once
}
                    $content = $content[$v[$i]] ?? '';
                }
            } elseif ($v == '_id') {
                $content = $row - $titleRow; // 自增序号列
            } else {
                $content = ($val[$v] ?? '');
            }

            // 处理图片类型
            if (is_array($content) && isset($content['type']) && isset($content['content'])) {
                if ($content['type'] == 'image') {
                    self::setImage($worksheet, $content, $rowName, $row);
                }
            }
            // 处理公式类型
            elseif (is_array($content) && isset($content['formula'])) {
                $worksheet->setCellValueExplicit(
                    $rowName . $row,
                    $content['formula'],
                    DataType::TYPE_FORMULA
                );
            }
            // 处理普通值
            else {
                $content = WorkSheetHelper::formatValue($content, $format, $formatDate); // 格式化数据
                if (is_numeric($content)) {
                    if ($autoDataType && strlen($content) < 11) {
                        $worksheet->setCellValueExplicit($rowName . $row, $content, DataType::TYPE_NUMERIC);
                    } else {
                        $worksheet->setCellValueExplicit($rowName . $row, $content, DataType::TYPE_STRING2);
                    }
                } else {
                    $worksheet->setCellValueExplicit($rowName . $row, $content, DataType::TYPE_STRING2);
                }
            }
            $_lie++;
        }
        $row++;
        
        return $row;
    }

    /**
     * 设置图片到单元格
     * @param Worksheet $worksheet
     * @param array $imageConfig 图片配置 ['type'=>'image', 'content'=>'路径', 'height'=>100, 'width'=>100, 'offsetX'=>0, 'offsetY'=>0]
     * @param string $rowName 列字母
     * @param int $row 行号
     */
    private static function setImage(
        Worksheet $worksheet,
        array $imageConfig,
        string $rowName,
        int $row
    ) {
        $path = WorkSheetHelper::verifyFile($imageConfig['content']);
        $drawing = new Drawing();
        $drawing->setPath($path);
        
        if (!empty($imageConfig['height'])) {
            $drawing->setHeight($imageConfig['height']);
        }
        if (!empty($imageConfig['width'])) {
            $drawing->setWidth($imageConfig['width']); // 只设置高，宽会自适应，如果设置宽后，高则失效
        }
        if (!empty($imageConfig['offsetX'])) {
            $drawing->setOffsetX($imageConfig['offsetX']); // 设置X方向偏移量
        }
        if (!empty($imageConfig['offsetY'])) {
            $drawing->setOffsetY($imageConfig['offsetY']); // 设置Y方向偏移量
        }

        $drawing->setCoordinates($rowName . $row);
        $drawing->setWorksheet($worksheet);
    }
}



1			<?php
2			/**
3			* @name: CellValueHandler
4			* @author: JiaMeng <[email protected]>
5			* @file: CellValueHandler.php
6			* @Date: 2025/01/XX
7			*/
8			namespace tinymeng\spreadsheet\Excel\Handler;
9
10			use PhpOffice\PhpSpreadsheet\Cell\DataType;
11			use PhpOffice\PhpSpreadsheet\Worksheet\Drawing;
12			use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
13			use tinymeng\spreadsheet\Util\WorkSheetHelper;
14
15			class CellValueHandler
16			{
17			/**
18			* 设置单元格值
19			* @param Worksheet $worksheet
20			* @param array $val 数据行
21			* @param array $fields 字段列表
22			* @param int $row 当前行
23			* @param int $titleRow 标题行数
24			* @param int\|null $height 行高
25			* @param bool $autoDataType 是否自动数据类型
26			* @param bool $format 是否格式化内容
27			* @param string $formatDate 日期格式
28			* @return int 返回更新后的行号
29			*/
30			public static function setCellValue(
31			Worksheet $worksheet,
32			array $val,
33			array $fields,
34			int $row,
35			int $titleRow,
36			?int $height = null,
37			bool $autoDataType = false,
38			bool $format = true,
39			string $formatDate = 'Y-m-d H:i:s'
40			): int {
41			// 设置单元格行高
42			if (!empty($height)) {
43			$worksheet->getRowDimension($row)->setRowHeight($height);
44			}
45
46			$_lie = 0;
47			foreach ($fields as $v) {
48			$rowName = WorkSheetHelper::cellName($_lie);
49
50			// 处理嵌套字段（如 'user.name'）
51			if (strpos($v, '.') !== false) {
52			$v = explode('.', $v);
53			$content = $val;
54			for ($i = 0; $i < count($v); $i++) {
			0 ignored issues – show Performance Best Practice introduced 2024-12-12 08:14 UTC by Report Bug Copy Issue Report It seems like you are calling the size function `count()` as part of the test condition. You might want to compute the size beforehand, and not on each iteration. If the size of the collection does not change during the iteration, it is generally a good practice to compute it beforehand, and not on each iteration: for ($i=0; $i<count($array); $i++) { // calls count() on each iteration } // Better for ($i=0, $c=count($array); $i<$c; $i++) { // calls count() just once } Loading history...
55			$content = $content[$v[$i]] ?? '';
56			}
57			} elseif ($v == '_id') {
58			$content = $row - $titleRow; // 自增序号列
59			} else {
60			$content = ($val[$v] ?? '');
61			}
62
63			// 处理图片类型
64			if (is_array($content) && isset($content['type']) && isset($content['content'])) {
65			if ($content['type'] == 'image') {
66			self::setImage($worksheet, $content, $rowName, $row);
67			}
68			}
69			// 处理公式类型
70			elseif (is_array($content) && isset($content['formula'])) {
71			$worksheet->setCellValueExplicit(
72			$rowName . $row,
73			$content['formula'],
74			DataType::TYPE_FORMULA
75			);
76			}
77			// 处理普通值
78			else {
79			$content = WorkSheetHelper::formatValue($content, $format, $formatDate); // 格式化数据
80			if (is_numeric($content)) {
81			if ($autoDataType && strlen($content) < 11) {
82			$worksheet->setCellValueExplicit($rowName . $row, $content, DataType::TYPE_NUMERIC);
83			} else {
84			$worksheet->setCellValueExplicit($rowName . $row, $content, DataType::TYPE_STRING2);
85			}
86			} else {
87			$worksheet->setCellValueExplicit($rowName . $row, $content, DataType::TYPE_STRING2);
88			}
89			}
90			$_lie++;
91			}
92			$row++;
93
94			return $row;
95			}
96
97			/**
98			* 设置图片到单元格
99			* @param Worksheet $worksheet
100			* @param array $imageConfig 图片配置 ['type'=>'image', 'content'=>'路径', 'height'=>100, 'width'=>100, 'offsetX'=>0, 'offsetY'=>0]
101			* @param string $rowName 列字母
102			* @param int $row 行号
103			*/
104			private static function setImage(
105			Worksheet $worksheet,
106			array $imageConfig,
107			string $rowName,
108			int $row
109			) {
110			$path = WorkSheetHelper::verifyFile($imageConfig['content']);
111			$drawing = new Drawing();
112			$drawing->setPath($path);
113
114			if (!empty($imageConfig['height'])) {
115			$drawing->setHeight($imageConfig['height']);
116			}
117			if (!empty($imageConfig['width'])) {
118			$drawing->setWidth($imageConfig['width']); // 只设置高，宽会自适应，如果设置宽后，高则失效
119			}
120			if (!empty($imageConfig['offsetX'])) {
121			$drawing->setOffsetX($imageConfig['offsetX']); // 设置X方向偏移量
122			}
123			if (!empty($imageConfig['offsetY'])) {
124			$drawing->setOffsetY($imageConfig['offsetY']); // 设置Y方向偏移量
125			}
126
127			$drawing->setCoordinates($rowName . $row);
128			$drawing->setWorksheet($worksheet);
129			}
130			}
131
132

majiameng / spreadsheet-php

CellValueHandler::setCellValue() C last analyzed 2025-11-03 14:32 UTC

Complexity

Size

Duplication

Importance

How to fix Long Method Complexity Many Parameters

Long Method

Many Parameters

Duplication Side-by-Side

Filter issues like

CellValueHandler::setCellValue() C
last analyzed 2025-11-03 14:32 UTC