| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494 | <?php/** * PHPExcel_Worksheet_HeaderFooter * * Copyright (c) 2006 - 2015 PHPExcel * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not,241 write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA * * @category   PHPExcel * @package    PHPExcel_Worksheet * @copyright  Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel) * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt    LGPL * @version    ##VERSION##, ##DATE## * * <code> * Header/Footer Formatting Syntax taken from Office Open XML Part 4 - Markup Language Reference, page 1970: * * There are a number of formatting codes that can be written inline with the actual header / footer text, which * affect the formatting in the header or footer. * * Example: This example shows the text "Center Bold Header" on the first line (center section), and the date on * the second line (center section). *         &CCenter &"-,Bold"Bold&"-,Regular"Header_x000A_&D * * General Rules: * There is no required order in which these codes must appear. * * The first occurrence of the following codes turns the formatting ON, the second occurrence turns it OFF again: * - strikethrough * - superscript * - subscript * Superscript and subscript cannot both be ON at same time. Whichever comes first wins and the other is ignored, * while the first is ON. * &L - code for "left section" (there are three header / footer locations, "left", "center", and "right"). When * two or more occurrences of this section marker exist, the contents from all markers are concatenated, in the * order of appearance, and placed into the left section. * &P - code for "current page #" * &N - code for "total pages" * &font size - code for "text font size", where font size is a font size in points. * &K - code for "text font color" * RGB Color is specified as RRGGBB * Theme Color is specifed as TTSNN where TT is the theme color Id, S is either "+" or "-" of the tint/shade * value, NN is the tint/shade value. * &S - code for "text strikethrough" on / off * &X - code for "text super script" on / off * &Y - code for "text subscript" on / off * &C - code for "center section". When two or more occurrences of this section marker exist, the contents * from all markers are concatenated, in the order of appearance, and placed into the center section. * * &D - code for "date" * &T - code for "time" * &G - code for "picture as background" * &U - code for "text single underline" * &E - code for "double underline" * &R - code for "right section". When two or more occurrences of this section marker exist, the contents * from all markers are concatenated, in the order of appearance, and placed into the right section. * &Z - code for "this workbook's file path" * &F - code for "this workbook's file name" * &A - code for "sheet tab name" * &+ - code for add to page #. * &- - code for subtract from page #. * &"font name,font type" - code for "text font name" and "text font type", where font name and font type * are strings specifying the name and type of the font, separated by a comma. When a hyphen appears in font * name, it means "none specified". Both of font name and font type can be localized values. * &"-,Bold" - code for "bold font style" * &B - also means "bold font style". * &"-,Regular" - code for "regular font style" * &"-,Italic" - code for "italic font style" * &I - also means "italic font style" * &"-,Bold Italic" code for "bold italic font style" * &O - code for "outline style" * &H - code for "shadow style" * </code> * */class PHPExcel_Worksheet_HeaderFooter{    /* Header/footer image location */    const IMAGE_HEADER_LEFT   = 'LH';    const IMAGE_HEADER_CENTER = 'CH';    const IMAGE_HEADER_RIGHT  = 'RH';    const IMAGE_FOOTER_LEFT   = 'LF';    const IMAGE_FOOTER_CENTER = 'CF';    const IMAGE_FOOTER_RIGHT  = 'RF';    /**     * OddHeader     *     * @var string     */    private $oddHeader = '';    /**     * OddFooter     *     * @var string     */    private $oddFooter = '';    /**     * EvenHeader     *     * @var string     */    private $evenHeader = '';    /**     * EvenFooter     *     * @var string     */    private $evenFooter = '';    /**     * FirstHeader     *     * @var string     */    private $firstHeader = '';    /**     * FirstFooter     *     * @var string     */    private $firstFooter = '';    /**     * Different header for Odd/Even, defaults to false     *     * @var boolean     */    private $differentOddEven = false;    /**     * Different header for first page, defaults to false     *     * @var boolean     */    private $differentFirst = false;    /**     * Scale with document, defaults to true     *     * @var boolean     */    private $scaleWithDocument = true;    /**     * Align with margins, defaults to true     *     * @var boolean     */    private $alignWithMargins = true;    /**     * Header/footer images     *     * @var PHPExcel_Worksheet_HeaderFooterDrawing[]     */    private $headerFooterImages = array();    /**     * Create a new PHPExcel_Worksheet_HeaderFooter     */    public function __construct()    {    }    /**     * Get OddHeader     *     * @return string     */    public function getOddHeader()    {        return $this->oddHeader;    }    /**     * Set OddHeader     *     * @param string $pValue     * @return PHPExcel_Worksheet_HeaderFooter     */    public function setOddHeader($pValue)    {        $this->oddHeader = $pValue;        return $this;    }    /**     * Get OddFooter     *     * @return string     */    public function getOddFooter()    {        return $this->oddFooter;    }    /**     * Set OddFooter     *     * @param string $pValue     * @return PHPExcel_Worksheet_HeaderFooter     */    public function setOddFooter($pValue)    {        $this->oddFooter = $pValue;        return $this;    }    /**     * Get EvenHeader     *     * @return string     */    public function getEvenHeader()    {        return $this->evenHeader;    }    /**     * Set EvenHeader     *     * @param string $pValue     * @return PHPExcel_Worksheet_HeaderFooter     */    public function setEvenHeader($pValue)    {        $this->evenHeader = $pValue;        return $this;    }    /**     * Get EvenFooter     *     * @return string     */    public function getEvenFooter()    {        return $this->evenFooter;    }    /**     * Set EvenFooter     *     * @param string $pValue     * @return PHPExcel_Worksheet_HeaderFooter     */    public function setEvenFooter($pValue)    {        $this->evenFooter = $pValue;        return $this;    }    /**     * Get FirstHeader     *     * @return string     */    public function getFirstHeader()    {        return $this->firstHeader;    }    /**     * Set FirstHeader     *     * @param string $pValue     * @return PHPExcel_Worksheet_HeaderFooter     */    public function setFirstHeader($pValue)    {        $this->firstHeader = $pValue;        return $this;    }    /**     * Get FirstFooter     *     * @return string     */    public function getFirstFooter()    {        return $this->firstFooter;    }    /**     * Set FirstFooter     *     * @param string $pValue     * @return PHPExcel_Worksheet_HeaderFooter     */    public function setFirstFooter($pValue)    {        $this->firstFooter = $pValue;        return $this;    }    /**     * Get DifferentOddEven     *     * @return boolean     */    public function getDifferentOddEven()    {        return $this->differentOddEven;    }    /**     * Set DifferentOddEven     *     * @param boolean $pValue     * @return PHPExcel_Worksheet_HeaderFooter     */    public function setDifferentOddEven($pValue = false)    {        $this->differentOddEven = $pValue;        return $this;    }    /**     * Get DifferentFirst     *     * @return boolean     */    public function getDifferentFirst()    {        return $this->differentFirst;    }    /**     * Set DifferentFirst     *     * @param boolean $pValue     * @return PHPExcel_Worksheet_HeaderFooter     */    public function setDifferentFirst($pValue = false)    {        $this->differentFirst = $pValue;        return $this;    }    /**     * Get ScaleWithDocument     *     * @return boolean     */    public function getScaleWithDocument()    {        return $this->scaleWithDocument;    }    /**     * Set ScaleWithDocument     *     * @param boolean $pValue     * @return PHPExcel_Worksheet_HeaderFooter     */    public function setScaleWithDocument($pValue = true)    {        $this->scaleWithDocument = $pValue;        return $this;    }    /**     * Get AlignWithMargins     *     * @return boolean     */    public function getAlignWithMargins()    {        return $this->alignWithMargins;    }    /**     * Set AlignWithMargins     *     * @param boolean $pValue     * @return PHPExcel_Worksheet_HeaderFooter     */    public function setAlignWithMargins($pValue = true)    {        $this->alignWithMargins = $pValue;        return $this;    }    /**     * Add header/footer image     *     * @param PHPExcel_Worksheet_HeaderFooterDrawing $image     * @param string $location     * @throws PHPExcel_Exception     * @return PHPExcel_Worksheet_HeaderFooter     */    public function addImage(PHPExcel_Worksheet_HeaderFooterDrawing $image = null, $location = self::IMAGE_HEADER_LEFT)    {        $this->headerFooterImages[$location] = $image;        return $this;    }    /**     * Remove header/footer image     *     * @param string $location     * @throws PHPExcel_Exception     * @return PHPExcel_Worksheet_HeaderFooter     */    public function removeImage($location = self::IMAGE_HEADER_LEFT)    {        if (isset($this->headerFooterImages[$location])) {            unset($this->headerFooterImages[$location]);        }        return $this;    }    /**     * Set header/footer images     *     * @param PHPExcel_Worksheet_HeaderFooterDrawing[] $images     * @throws PHPExcel_Exception     * @return PHPExcel_Worksheet_HeaderFooter     */    public function setImages($images)    {        if (!is_array($images)) {            throw new PHPExcel_Exception('Invalid parameter!');        }        $this->headerFooterImages = $images;        return $this;    }    /**     * Get header/footer images     *     * @return PHPExcel_Worksheet_HeaderFooterDrawing[]     */    public function getImages()    {        // Sort array        $images = array();        if (isset($this->headerFooterImages[self::IMAGE_HEADER_LEFT])) {            $images[self::IMAGE_HEADER_LEFT] =         $this->headerFooterImages[self::IMAGE_HEADER_LEFT];        }        if (isset($this->headerFooterImages[self::IMAGE_HEADER_CENTER])) {            $images[self::IMAGE_HEADER_CENTER] =     $this->headerFooterImages[self::IMAGE_HEADER_CENTER];        }        if (isset($this->headerFooterImages[self::IMAGE_HEADER_RIGHT])) {            $images[self::IMAGE_HEADER_RIGHT] =     $this->headerFooterImages[self::IMAGE_HEADER_RIGHT];        }        if (isset($this->headerFooterImages[self::IMAGE_FOOTER_LEFT])) {            $images[self::IMAGE_FOOTER_LEFT] =         $this->headerFooterImages[self::IMAGE_FOOTER_LEFT];        }        if (isset($this->headerFooterImages[self::IMAGE_FOOTER_CENTER])) {            $images[self::IMAGE_FOOTER_CENTER] =     $this->headerFooterImages[self::IMAGE_FOOTER_CENTER];        }        if (isset($this->headerFooterImages[self::IMAGE_FOOTER_RIGHT])) {            $images[self::IMAGE_FOOTER_RIGHT] =     $this->headerFooterImages[self::IMAGE_FOOTER_RIGHT];        }        $this->headerFooterImages = $images;        return $this->headerFooterImages;    }    /**     * Implement PHP __clone to create a deep clone, not just a shallow copy.     */    public function __clone()    {        $vars = get_object_vars($this);        foreach ($vars as $key => $value) {            if (is_object($value)) {                $this->$key = clone $value;            } else {                $this->$key = $value;            }        }    }}
 |