<?php
namespace PhpOffice\PhpSpreadsheet\Chart;
/**
* Created by PhpStorm.
* User: Wiktor Trzonkowski
* Date: 6/17/14
* Time: 12:11 PM.
*/
class Axis extends Properties
{
/**
* Axis Number.
*
< * @var array of mixed
> * @var mixed[]
*/
private $axisNumber = [
'format' => self::FORMAT_CODE_GENERAL,
'source_linked' => 1,
];
/**
* Axis Options.
*
< * @var array of mixed
> * @var mixed[]
*/
private $axisOptions = [
'minimum' => null,
'maximum' => null,
'major_unit' => null,
'minor_unit' => null,
'orientation' => self::ORIENTATION_NORMAL,
'minor_tick_mark' => self::TICK_MARK_NONE,
'major_tick_mark' => self::TICK_MARK_NONE,
'axis_labels' => self::AXIS_LABELS_NEXT_TO,
'horizontal_crosses' => self::HORIZONTAL_CROSSES_AUTOZERO,
'horizontal_crosses_value' => null,
];
/**
* Fill Properties.
*
< * @var array of mixed
> * @var mixed[]
*/
private $fillProperties = [
'type' => self::EXCEL_COLOR_TYPE_ARGB,
'value' => null,
'alpha' => 0,
];
/**
* Line Properties.
*
< * @var array of mixed
> * @var mixed[]
*/
private $lineProperties = [
'type' => self::EXCEL_COLOR_TYPE_ARGB,
'value' => null,
'alpha' => 0,
];
/**
* Line Style Properties.
*
< * @var array of mixed
> * @var mixed[]
*/
private $lineStyleProperties = [
'width' => '9525',
'compound' => self::LINE_STYLE_COMPOUND_SIMPLE,
'dash' => self::LINE_STYLE_DASH_SOLID,
'cap' => self::LINE_STYLE_CAP_FLAT,
'join' => self::LINE_STYLE_JOIN_BEVEL,
'arrow' => [
'head' => [
'type' => self::LINE_STYLE_ARROW_TYPE_NOARROW,
'size' => self::LINE_STYLE_ARROW_SIZE_5,
],
'end' => [
'type' => self::LINE_STYLE_ARROW_TYPE_NOARROW,
'size' => self::LINE_STYLE_ARROW_SIZE_8,
],
],
];
/**
* Shadow Properties.
*
< * @var array of mixed
> * @var mixed[]
*/
private $shadowProperties = [
'presets' => self::SHADOW_PRESETS_NOSHADOW,
'effect' => null,
'color' => [
'type' => self::EXCEL_COLOR_TYPE_STANDARD,
'value' => 'black',
'alpha' => 40,
],
'size' => [
'sx' => null,
'sy' => null,
'kx' => null,
],
'blur' => null,
'direction' => null,
'distance' => null,
'algn' => null,
'rotWithShape' => null,
];
/**
* Glow Properties.
*
< * @var array of mixed
> * @var mixed[]
*/
private $glowProperties = [
'size' => null,
'color' => [
'type' => self::EXCEL_COLOR_TYPE_STANDARD,
'value' => 'black',
'alpha' => 40,
],
];
/**
* Soft Edge Properties.
*
< * @var array of mixed
> * @var mixed[]
*/
private $softEdges = [
'size' => null,
];
/**
* Get Series Data Type.
*
* @param mixed $format_code
< *
< * @return string
*/
< public function setAxisNumberProperties($format_code)
> public function setAxisNumberProperties($format_code): void
{
$this->axisNumber['format'] = (string) $format_code;
$this->axisNumber['source_linked'] = 0;
}
/**
* Get Axis Number Format Data Type.
*
* @return string
*/
public function getAxisNumberFormat()
{
return $this->axisNumber['format'];
}
/**
* Get Axis Number Source Linked.
*
* @return string
*/
public function getAxisNumberSourceLinked()
{
return (string) $this->axisNumber['source_linked'];
}
/**
* Set Axis Options Properties.
*
< * @param string $axis_labels
< * @param string $horizontal_crosses_value
< * @param string $horizontal_crosses
< * @param string $axis_orientation
< * @param string $major_tmt
< * @param string $minor_tmt
> * @param string $axisLabels
> * @param string $horizontalCrossesValue
> * @param string $horizontalCrosses
> * @param string $axisOrientation
> * @param string $majorTmt
> * @param string $minorTmt
* @param string $minimum
* @param string $maximum
< * @param string $major_unit
< * @param string $minor_unit
> * @param string $majorUnit
> * @param string $minorUnit
*/
< public function setAxisOptionsProperties($axis_labels, $horizontal_crosses_value = null, $horizontal_crosses = null, $axis_orientation = null, $major_tmt = null, $minor_tmt = null, $minimum = null, $maximum = null, $major_unit = null, $minor_unit = null): void
> public function setAxisOptionsProperties($axisLabels, $horizontalCrossesValue = null, $horizontalCrosses = null, $axisOrientation = null, $majorTmt = null, $minorTmt = null, $minimum = null, $maximum = null, $majorUnit = null, $minorUnit = null): void
{
< $this->axisOptions['axis_labels'] = (string) $axis_labels;
< ($horizontal_crosses_value !== null) ? $this->axisOptions['horizontal_crosses_value'] = (string) $horizontal_crosses_value : null;
< ($horizontal_crosses !== null) ? $this->axisOptions['horizontal_crosses'] = (string) $horizontal_crosses : null;
< ($axis_orientation !== null) ? $this->axisOptions['orientation'] = (string) $axis_orientation : null;
< ($major_tmt !== null) ? $this->axisOptions['major_tick_mark'] = (string) $major_tmt : null;
< ($minor_tmt !== null) ? $this->axisOptions['minor_tick_mark'] = (string) $minor_tmt : null;
< ($minor_tmt !== null) ? $this->axisOptions['minor_tick_mark'] = (string) $minor_tmt : null;
> $this->axisOptions['axis_labels'] = (string) $axisLabels;
> ($horizontalCrossesValue !== null) ? $this->axisOptions['horizontal_crosses_value'] = (string) $horizontalCrossesValue : null;
> ($horizontalCrosses !== null) ? $this->axisOptions['horizontal_crosses'] = (string) $horizontalCrosses : null;
> ($axisOrientation !== null) ? $this->axisOptions['orientation'] = (string) $axisOrientation : null;
> ($majorTmt !== null) ? $this->axisOptions['major_tick_mark'] = (string) $majorTmt : null;
> ($minorTmt !== null) ? $this->axisOptions['minor_tick_mark'] = (string) $minorTmt : null;
> ($minorTmt !== null) ? $this->axisOptions['minor_tick_mark'] = (string) $minorTmt : null;
($minimum !== null) ? $this->axisOptions['minimum'] = (string) $minimum : null;
($maximum !== null) ? $this->axisOptions['maximum'] = (string) $maximum : null;
< ($major_unit !== null) ? $this->axisOptions['major_unit'] = (string) $major_unit : null;
< ($minor_unit !== null) ? $this->axisOptions['minor_unit'] = (string) $minor_unit : null;
> ($majorUnit !== null) ? $this->axisOptions['major_unit'] = (string) $majorUnit : null;
> ($minorUnit !== null) ? $this->axisOptions['minor_unit'] = (string) $minorUnit : null;
}
/**
* Get Axis Options Property.
*
* @param string $property
*
* @return string
*/
public function getAxisOptionsProperty($property)
{
return $this->axisOptions[$property];
}
/**
* Set Axis Orientation Property.
*
* @param string $orientation
*/
public function setAxisOrientation($orientation): void
{
$this->axisOptions['orientation'] = (string) $orientation;
}
/**
* Set Fill Property.
*
* @param string $color
* @param int $alpha
< * @param string $type
> * @param string $AlphaType
*/
< public function setFillParameters($color, $alpha = 0, $type = self::EXCEL_COLOR_TYPE_ARGB): void
> public function setFillParameters($color, $alpha = 0, $AlphaType = self::EXCEL_COLOR_TYPE_ARGB): void
{
< $this->fillProperties = $this->setColorProperties($color, $alpha, $type);
> $this->fillProperties = $this->setColorProperties($color, $alpha, $AlphaType);
}
/**
* Set Line Property.
*
* @param string $color
* @param int $alpha
< * @param string $type
> * @param string $alphaType
*/
< public function setLineParameters($color, $alpha = 0, $type = self::EXCEL_COLOR_TYPE_ARGB): void
> public function setLineParameters($color, $alpha = 0, $alphaType = self::EXCEL_COLOR_TYPE_ARGB): void
{
< $this->lineProperties = $this->setColorProperties($color, $alpha, $type);
> $this->lineProperties = $this->setColorProperties($color, $alpha, $alphaType);
}
/**
* Get Fill Property.
*
* @param string $property
*
* @return string
*/
public function getFillProperty($property)
{
return $this->fillProperties[$property];
}
/**
* Get Line Property.
*
* @param string $property
*
* @return string
*/
public function getLineProperty($property)
{
return $this->lineProperties[$property];
}
/**
* Set Line Style Properties.
*
< * @param float $line_width
< * @param string $compound_type
< * @param string $dash_type
< * @param string $cap_type
< * @param string $join_type
< * @param string $head_arrow_type
< * @param string $head_arrow_size
< * @param string $end_arrow_type
< * @param string $end_arrow_size
< */
< public function setLineStyleProperties($line_width = null, $compound_type = null, $dash_type = null, $cap_type = null, $join_type = null, $head_arrow_type = null, $head_arrow_size = null, $end_arrow_type = null, $end_arrow_size = null): void
< {
< ($line_width !== null) ? $this->lineStyleProperties['width'] = $this->getExcelPointsWidth((float) $line_width) : null;
< ($compound_type !== null) ? $this->lineStyleProperties['compound'] = (string) $compound_type : null;
< ($dash_type !== null) ? $this->lineStyleProperties['dash'] = (string) $dash_type : null;
< ($cap_type !== null) ? $this->lineStyleProperties['cap'] = (string) $cap_type : null;
< ($join_type !== null) ? $this->lineStyleProperties['join'] = (string) $join_type : null;
< ($head_arrow_type !== null) ? $this->lineStyleProperties['arrow']['head']['type'] = (string) $head_arrow_type : null;
< ($head_arrow_size !== null) ? $this->lineStyleProperties['arrow']['head']['size'] = (string) $head_arrow_size : null;
< ($end_arrow_type !== null) ? $this->lineStyleProperties['arrow']['end']['type'] = (string) $end_arrow_type : null;
< ($end_arrow_size !== null) ? $this->lineStyleProperties['arrow']['end']['size'] = (string) $end_arrow_size : null;
> * @param float $lineWidth
> * @param string $compoundType
> * @param string $dashType
> * @param string $capType
> * @param string $joinType
> * @param string $headArrowType
> * @param string $headArrowSize
> * @param string $endArrowType
> * @param string $endArrowSize
> */
> public function setLineStyleProperties($lineWidth = null, $compoundType = null, $dashType = null, $capType = null, $joinType = null, $headArrowType = null, $headArrowSize = null, $endArrowType = null, $endArrowSize = null): void
> {
> ($lineWidth !== null) ? $this->lineStyleProperties['width'] = $this->getExcelPointsWidth((float) $lineWidth) : null;
> ($compoundType !== null) ? $this->lineStyleProperties['compound'] = (string) $compoundType : null;
> ($dashType !== null) ? $this->lineStyleProperties['dash'] = (string) $dashType : null;
> ($capType !== null) ? $this->lineStyleProperties['cap'] = (string) $capType : null;
> ($joinType !== null) ? $this->lineStyleProperties['join'] = (string) $joinType : null;
> ($headArrowType !== null) ? $this->lineStyleProperties['arrow']['head']['type'] = (string) $headArrowType : null;
> ($headArrowSize !== null) ? $this->lineStyleProperties['arrow']['head']['size'] = (string) $headArrowSize : null;
> ($endArrowType !== null) ? $this->lineStyleProperties['arrow']['end']['type'] = (string) $endArrowType : null;
> ($endArrowSize !== null) ? $this->lineStyleProperties['arrow']['end']['size'] = (string) $endArrowSize : null;
}
/**
* Get Line Style Property.
*
* @param array|string $elements
*
* @return string
*/
public function getLineStyleProperty($elements)
{
return $this->getArrayElementsValue($this->lineStyleProperties, $elements);
}
/**
* Get Line Style Arrow Excel Width.
*
* @param string $arrow
*
* @return string
*/
public function getLineStyleArrowWidth($arrow)
{
return $this->getLineStyleArrowSize($this->lineStyleProperties['arrow'][$arrow]['size'], 'w');
}
/**
* Get Line Style Arrow Excel Length.
*
* @param string $arrow
*
* @return string
*/
public function getLineStyleArrowLength($arrow)
{
return $this->getLineStyleArrowSize($this->lineStyleProperties['arrow'][$arrow]['size'], 'len');
}
/**
* Set Shadow Properties.
*
< * @param int $sh_presets
< * @param string $sh_color_value
< * @param string $sh_color_type
< * @param string $sh_color_alpha
< * @param float $sh_blur
< * @param int $sh_angle
< * @param float $sh_distance
> * @param int $shadowPresets
> * @param string $colorValue
> * @param string $colorType
> * @param string $colorAlpha
> * @param float $blur
> * @param int $angle
> * @param float $distance
*/
< public function setShadowProperties($sh_presets, $sh_color_value = null, $sh_color_type = null, $sh_color_alpha = null, $sh_blur = null, $sh_angle = null, $sh_distance = null): void
> public function setShadowProperties($shadowPresets, $colorValue = null, $colorType = null, $colorAlpha = null, $blur = null, $angle = null, $distance = null): void
{
< $this->setShadowPresetsProperties((int) $sh_presets)
> $this->setShadowPresetsProperties((int) $shadowPresets)
->setShadowColor(
< $sh_color_value === null ? $this->shadowProperties['color']['value'] : $sh_color_value,
< $sh_color_alpha === null ? (int) $this->shadowProperties['color']['alpha'] : $sh_color_alpha,
< $sh_color_type === null ? $this->shadowProperties['color']['type'] : $sh_color_type
> $colorValue ?? $this->shadowProperties['color']['value'],
> $colorAlpha ?? (int) $this->shadowProperties['color']['alpha'],
> $colorType ?? $this->shadowProperties['color']['type']
)
< ->setShadowBlur($sh_blur)
< ->setShadowAngle($sh_angle)
< ->setShadowDistance($sh_distance);
> ->setShadowBlur($blur)
> ->setShadowAngle($angle)
> ->setShadowDistance($distance);
}
/**
* Set Shadow Color.
*
< * @param int $shadow_presets
> * @param int $presets
*
* @return $this
*/
< private function setShadowPresetsProperties($shadow_presets)
> private function setShadowPresetsProperties($presets)
{
< $this->shadowProperties['presets'] = $shadow_presets;
< $this->setShadowProperiesMapValues($this->getShadowPresetsMap($shadow_presets));
> $this->shadowProperties['presets'] = $presets;
> $this->setShadowPropertiesMapValues($this->getShadowPresetsMap($presets));
return $this;
}
/**
* Set Shadow Properties from Mapped Values.
*
< * @param mixed &$reference
> * @param mixed $reference
*
* @return $this
*/
< private function setShadowProperiesMapValues(array $properties_map, &$reference = null)
> private function setShadowPropertiesMapValues(array $propertiesMap, &$reference = null)
{
$base_reference = $reference;
< foreach ($properties_map as $property_key => $property_val) {
> foreach ($propertiesMap as $property_key => $property_val) {
if (is_array($property_val)) {
if ($reference === null) {
$reference = &$this->shadowProperties[$property_key];
} else {
$reference = &$reference[$property_key];
}
< $this->setShadowProperiesMapValues($property_val, $reference);
> $this->setShadowPropertiesMapValues($property_val, $reference);
} else {
if ($base_reference === null) {
$this->shadowProperties[$property_key] = $property_val;
} else {
$reference[$property_key] = $property_val;
}
}
}
return $this;
}
/**
* Set Shadow Color.
*
* @param string $color
* @param int $alpha
< * @param string $type
> * @param string $alphaType
*
* @return $this
*/
< private function setShadowColor($color, $alpha, $type)
> private function setShadowColor($color, $alpha, $alphaType)
{
< $this->shadowProperties['color'] = $this->setColorProperties($color, $alpha, $type);
> $this->shadowProperties['color'] = $this->setColorProperties($color, $alpha, $alphaType);
return $this;
}
/**
* Set Shadow Blur.
*
* @param float $blur
*
* @return $this
*/
private function setShadowBlur($blur)
{
if ($blur !== null) {
$this->shadowProperties['blur'] = (string) $this->getExcelPointsWidth($blur);
}
return $this;
}
/**
* Set Shadow Angle.
*
* @param int $angle
*
* @return $this
*/
private function setShadowAngle($angle)
{
if ($angle !== null) {
$this->shadowProperties['direction'] = (string) $this->getExcelPointsAngle($angle);
}
return $this;
}
/**
* Set Shadow Distance.
*
* @param float $distance
*
* @return $this
*/
private function setShadowDistance($distance)
{
if ($distance !== null) {
$this->shadowProperties['distance'] = (string) $this->getExcelPointsWidth($distance);
}
return $this;
}
/**
* Get Shadow Property.
*
* @param string|string[] $elements
*
* @return null|array|int|string
*/
public function getShadowProperty($elements)
{
return $this->getArrayElementsValue($this->shadowProperties, $elements);
}
/**
* Set Glow Properties.
*
* @param float $size
< * @param string $color_value
< * @param int $color_alpha
< * @param string $color_type
> * @param string $colorValue
> * @param int $colorAlpha
> * @param string $colorType
*/
< public function setGlowProperties($size, $color_value = null, $color_alpha = null, $color_type = null): void
> public function setGlowProperties($size, $colorValue = null, $colorAlpha = null, $colorType = null): void
{
$this->setGlowSize($size)
->setGlowColor(
< $color_value === null ? $this->glowProperties['color']['value'] : $color_value,
< $color_alpha === null ? (int) $this->glowProperties['color']['alpha'] : $color_alpha,
< $color_type === null ? $this->glowProperties['color']['type'] : $color_type
> $colorValue ?? $this->glowProperties['color']['value'],
> $colorAlpha ?? (int) $this->glowProperties['color']['alpha'],
> $colorType ?? $this->glowProperties['color']['type']
);
}
/**
* Get Glow Property.
*
* @param array|string $property
*
* @return string
*/
public function getGlowProperty($property)
{
return $this->getArrayElementsValue($this->glowProperties, $property);
}
/**
* Set Glow Color.
*
* @param float $size
*
* @return $this
*/
private function setGlowSize($size)
{
if ($size !== null) {
$this->glowProperties['size'] = $this->getExcelPointsWidth($size);
}
return $this;
}
/**
* Set Glow Color.
*
* @param string $color
* @param int $alpha
< * @param string $type
> * @param string $colorType
*
* @return $this
*/
< private function setGlowColor($color, $alpha, $type)
> private function setGlowColor($color, $alpha, $colorType)
{
< $this->glowProperties['color'] = $this->setColorProperties($color, $alpha, $type);
> $this->glowProperties['color'] = $this->setColorProperties($color, $alpha, $colorType);
return $this;
}
/**
* Set Soft Edges Size.
*
* @param float $size
*/
public function setSoftEdges($size): void
{
if ($size !== null) {
$softEdges['size'] = (string) $this->getExcelPointsWidth($size);
}
}
/**
* Get Soft Edges Size.
*
* @return string
*/
public function getSoftEdgesSize()
{
return $this->softEdges['size'];
}
}