| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556 | <?phpnamespace PhpOffice\PhpSpreadsheet\Style;use PhpOffice\PhpSpreadsheet\Exception as PhpSpreadsheetException;class Font extends Supervisor{    // Underline types    const UNDERLINE_NONE = 'none';    const UNDERLINE_DOUBLE = 'double';    const UNDERLINE_DOUBLEACCOUNTING = 'doubleAccounting';    const UNDERLINE_SINGLE = 'single';    const UNDERLINE_SINGLEACCOUNTING = 'singleAccounting';    /**     * Font Name.     *     * @var string     */    protected $name = 'Calibri';    /**     * Font Size.     *     * @var float     */    protected $size = 11;    /**     * Bold.     *     * @var bool     */    protected $bold = false;    /**     * Italic.     *     * @var bool     */    protected $italic = false;    /**     * Superscript.     *     * @var bool     */    protected $superscript = false;    /**     * Subscript.     *     * @var bool     */    protected $subscript = false;    /**     * Underline.     *     * @var string     */    protected $underline = self::UNDERLINE_NONE;    /**     * Strikethrough.     *     * @var bool     */    protected $strikethrough = false;    /**     * Foreground color.     *     * @var Color     */    protected $color;    /**     * @var int     */    public $colorIndex;    /**     * Create a new Font.     *     * @param bool $isSupervisor Flag indicating if this is a supervisor or not     *                                    Leave this value at default unless you understand exactly what     *                                        its ramifications are     * @param bool $isConditional Flag indicating if this is a conditional style or not     *                                    Leave this value at default unless you understand exactly what     *                                        its ramifications are     */    public function __construct($isSupervisor = false, $isConditional = false)    {        // Supervisor?        parent::__construct($isSupervisor);        // Initialise values        if ($isConditional) {            $this->name = null;            $this->size = null;            $this->bold = null;            $this->italic = null;            $this->superscript = null;            $this->subscript = null;            $this->underline = null;            $this->strikethrough = null;            $this->color = new Color(Color::COLOR_BLACK, $isSupervisor, $isConditional);        } else {            $this->color = new Color(Color::COLOR_BLACK, $isSupervisor);        }        // bind parent if we are a supervisor        if ($isSupervisor) {            $this->color->bindParent($this, 'color');        }    }    /**     * Get the shared style component for the currently active cell in currently active sheet.     * Only used for style supervisor.     *     * @return Font     */    public function getSharedComponent()    {        return $this->parent->getSharedComponent()->getFont();    }    /**     * Build style array from subcomponents.     *     * @param array $array     *     * @return array     */    public function getStyleArray($array)    {        return ['font' => $array];    }    /**     * Apply styles from array.     *     * <code>     * $spreadsheet->getActiveSheet()->getStyle('B2')->getFont()->applyFromArray(     *     [     *         'name' => 'Arial',     *         'bold' => TRUE,     *         'italic' => FALSE,     *         'underline' => \PhpOffice\PhpSpreadsheet\Style\Font::UNDERLINE_DOUBLE,     *         'strikethrough' => FALSE,     *         'color' => [     *             'rgb' => '808080'     *         ]     *     ]     * );     * </code>     *     * @param array $pStyles Array containing style information     *     * @throws PhpSpreadsheetException     *     * @return Font     */    public function applyFromArray(array $pStyles)    {        if ($this->isSupervisor) {            $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($this->getStyleArray($pStyles));        } else {            if (isset($pStyles['name'])) {                $this->setName($pStyles['name']);            }            if (isset($pStyles['bold'])) {                $this->setBold($pStyles['bold']);            }            if (isset($pStyles['italic'])) {                $this->setItalic($pStyles['italic']);            }            if (isset($pStyles['superscript'])) {                $this->setSuperscript($pStyles['superscript']);            }            if (isset($pStyles['subscript'])) {                $this->setSubscript($pStyles['subscript']);            }            if (isset($pStyles['underline'])) {                $this->setUnderline($pStyles['underline']);            }            if (isset($pStyles['strikethrough'])) {                $this->setStrikethrough($pStyles['strikethrough']);            }            if (isset($pStyles['color'])) {                $this->getColor()->applyFromArray($pStyles['color']);            }            if (isset($pStyles['size'])) {                $this->setSize($pStyles['size']);            }        }        return $this;    }    /**     * Get Name.     *     * @return string     */    public function getName()    {        if ($this->isSupervisor) {            return $this->getSharedComponent()->getName();        }        return $this->name;    }    /**     * Set Name.     *     * @param string $pValue     *     * @return Font     */    public function setName($pValue)    {        if ($pValue == '') {            $pValue = 'Calibri';        }        if ($this->isSupervisor) {            $styleArray = $this->getStyleArray(['name' => $pValue]);            $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);        } else {            $this->name = $pValue;        }        return $this;    }    /**     * Get Size.     *     * @return float     */    public function getSize()    {        if ($this->isSupervisor) {            return $this->getSharedComponent()->getSize();        }        return $this->size;    }    /**     * Set Size.     *     * @param float $pValue     *     * @return Font     */    public function setSize($pValue)    {        if ($pValue == '') {            $pValue = 10;        }        if ($this->isSupervisor) {            $styleArray = $this->getStyleArray(['size' => $pValue]);            $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);        } else {            $this->size = $pValue;        }        return $this;    }    /**     * Get Bold.     *     * @return bool     */    public function getBold()    {        if ($this->isSupervisor) {            return $this->getSharedComponent()->getBold();        }        return $this->bold;    }    /**     * Set Bold.     *     * @param bool $pValue     *     * @return Font     */    public function setBold($pValue)    {        if ($pValue == '') {            $pValue = false;        }        if ($this->isSupervisor) {            $styleArray = $this->getStyleArray(['bold' => $pValue]);            $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);        } else {            $this->bold = $pValue;        }        return $this;    }    /**     * Get Italic.     *     * @return bool     */    public function getItalic()    {        if ($this->isSupervisor) {            return $this->getSharedComponent()->getItalic();        }        return $this->italic;    }    /**     * Set Italic.     *     * @param bool $pValue     *     * @return Font     */    public function setItalic($pValue)    {        if ($pValue == '') {            $pValue = false;        }        if ($this->isSupervisor) {            $styleArray = $this->getStyleArray(['italic' => $pValue]);            $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);        } else {            $this->italic = $pValue;        }        return $this;    }    /**     * Get Superscript.     *     * @return bool     */    public function getSuperscript()    {        if ($this->isSupervisor) {            return $this->getSharedComponent()->getSuperscript();        }        return $this->superscript;    }    /**     * Set Superscript.     *     * @param bool $pValue     *     * @return Font     */    public function setSuperscript($pValue)    {        if ($pValue == '') {            $pValue = false;        }        if ($this->isSupervisor) {            $styleArray = $this->getStyleArray(['superscript' => $pValue]);            $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);        } else {            $this->superscript = $pValue;            $this->subscript = !$pValue;        }        return $this;    }    /**     * Get Subscript.     *     * @return bool     */    public function getSubscript()    {        if ($this->isSupervisor) {            return $this->getSharedComponent()->getSubscript();        }        return $this->subscript;    }    /**     * Set Subscript.     *     * @param bool $pValue     *     * @return Font     */    public function setSubscript($pValue)    {        if ($pValue == '') {            $pValue = false;        }        if ($this->isSupervisor) {            $styleArray = $this->getStyleArray(['subscript' => $pValue]);            $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);        } else {            $this->subscript = $pValue;            $this->superscript = !$pValue;        }        return $this;    }    /**     * Get Underline.     *     * @return string     */    public function getUnderline()    {        if ($this->isSupervisor) {            return $this->getSharedComponent()->getUnderline();        }        return $this->underline;    }    /**     * Set Underline.     *     * @param bool|string $pValue \PhpOffice\PhpSpreadsheet\Style\Font underline type     *                                    If a boolean is passed, then TRUE equates to UNDERLINE_SINGLE,     *                                        false equates to UNDERLINE_NONE     *     * @return Font     */    public function setUnderline($pValue)    {        if (is_bool($pValue)) {            $pValue = ($pValue) ? self::UNDERLINE_SINGLE : self::UNDERLINE_NONE;        } elseif ($pValue == '') {            $pValue = self::UNDERLINE_NONE;        }        if ($this->isSupervisor) {            $styleArray = $this->getStyleArray(['underline' => $pValue]);            $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);        } else {            $this->underline = $pValue;        }        return $this;    }    /**     * Get Strikethrough.     *     * @return bool     */    public function getStrikethrough()    {        if ($this->isSupervisor) {            return $this->getSharedComponent()->getStrikethrough();        }        return $this->strikethrough;    }    /**     * Set Strikethrough.     *     * @param bool $pValue     *     * @return Font     */    public function setStrikethrough($pValue)    {        if ($pValue == '') {            $pValue = false;        }        if ($this->isSupervisor) {            $styleArray = $this->getStyleArray(['strikethrough' => $pValue]);            $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);        } else {            $this->strikethrough = $pValue;        }        return $this;    }    /**     * Get Color.     *     * @return Color     */    public function getColor()    {        return $this->color;    }    /**     * Set Color.     *     * @param Color $pValue     *     * @throws PhpSpreadsheetException     *     * @return Font     */    public function setColor(Color $pValue)    {        // make sure parameter is a real color and not a supervisor        $color = $pValue->getIsSupervisor() ? $pValue->getSharedComponent() : $pValue;        if ($this->isSupervisor) {            $styleArray = $this->getColor()->getStyleArray(['argb' => $color->getARGB()]);            $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);        } else {            $this->color = $color;        }        return $this;    }    /**     * Get hash code.     *     * @return string Hash code     */    public function getHashCode()    {        if ($this->isSupervisor) {            return $this->getSharedComponent()->getHashCode();        }        return md5(            $this->name .            $this->size .            ($this->bold ? 't' : 'f') .            ($this->italic ? 't' : 'f') .            ($this->superscript ? 't' : 'f') .            ($this->subscript ? 't' : 'f') .            $this->underline .            ($this->strikethrough ? 't' : 'f') .            $this->color->getHashCode() .            __CLASS__        );    }}
 |