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;
- }
- }
- }
- }
|