PHP Decode

<?php
 class PHPExcel_Writer_Excel5_Xf { private $isStyleXf; private $fontIndex; private $numberFormatIndex; private $textJustLast; private $foregroundColor; private $backgroundColor; private $bottomBorderColor; private $topBorderColor; private $leftBorderColor; private $rightBorderColor; public function __construct(PHPExcel_Style $style = null) { $this->isStyleXf = false; $this->fontIndex = 0; $this->numberFormatIndex = 0; $this->textJustLast = 0; $this->foregroundColor = 64; $this->backgroundColor = 65; $this->_diag = 0; $this->bottomBorderColor = 64; $this->topBorderColor = 64; $this->leftBorderColor = 64; $this->rightBorderColor = 64; $this->_diag_color = 64; $this->_style = $style; } public function writeXf() { if ($this->isStyleXf) { $style = 65525; } else { $style = self::mapLocked($this->_style->getProtection()->getLocked()); $style |= self::mapHidden($this->_style->getProtection()->getHidden()) << 1; } $atr_num = $this->numberFormatIndex != 0 ? 1 : 0; $atr_fnt = $this->fontIndex != 0 ? 1 : 0; $atr_alc = (int) $this->_style->getAlignment()->getWrapText() ? 1 : 0; $atr_bdr = self::mapBorderStyle($this->_style->getBorders()->getBottom()->getBorderStyle()) || self::mapBorderStyle($this->_style->getBorders()->getTop()->getBorderStyle()) || self::mapBorderStyle($this->_style->getBorders()->getLeft()->getBorderStyle()) || self::mapBorderStyle($this->_style->getBorders()->getRight()->getBorderStyle()) ? 1 : 0; $atr_pat = $this->foregroundColor != 64 || $this->backgroundColor != 65 || self::mapFillType($this->_style->getFill()->getFillType()) ? 1 : 0; $atr_prot = self::mapLocked($this->_style->getProtection()->getLocked()) | self::mapHidden($this->_style->getProtection()->getHidden()); if (self::mapBorderStyle($this->_style->getBorders()->getBottom()->getBorderStyle()) == 0) { $this->bottomBorderColor = 0; } if (self::mapBorderStyle($this->_style->getBorders()->getTop()->getBorderStyle()) == 0) { $this->topBorderColor = 0; } if (self::mapBorderStyle($this->_style->getBorders()->getRight()->getBorderStyle()) == 0) { $this->rightBorderColor = 0; } if (self::mapBorderStyle($this->_style->getBorders()->getLeft()->getBorderStyle()) == 0) { $this->leftBorderColor = 0; } if (self::mapBorderStyle($this->_style->getBorders()->getDiagonal()->getBorderStyle()) == 0) { $this->_diag_color = 0; } $record = 224; $length = 20; $ifnt = $this->fontIndex; $ifmt = $this->numberFormatIndex; $align = $this->mapHAlign($this->_style->getAlignment()->getHorizontal()); $align |= (int) $this->_style->getAlignment()->getWrapText() << 3; $align |= self::mapVAlign($this->_style->getAlignment()->getVertical()) << 4; $align |= $this->textJustLast << 7; $used_attrib = $atr_num << 2; $used_attrib |= $atr_fnt << 3; $used_attrib |= $atr_alc << 4; $used_attrib |= $atr_bdr << 5; $used_attrib |= $atr_pat << 6; $used_attrib |= $atr_prot << 7; $icv = $this->foregroundColor; $icv |= $this->backgroundColor << 7; $border1 = self::mapBorderStyle($this->_style->getBorders()->getLeft()->getBorderStyle()); $border1 |= self::mapBorderStyle($this->_style->getBorders()->getRight()->getBorderStyle()) << 4; $border1 |= self::mapBorderStyle($this->_style->getBorders()->getTop()->getBorderStyle()) << 8; $border1 |= self::mapBorderStyle($this->_style->getBorders()->getBottom()->getBorderStyle()) << 12; $border1 |= $this->leftBorderColor << 16; $border1 |= $this->rightBorderColor << 23; $diagonalDirection = $this->_style->getBorders()->getDiagonalDirection(); $diag_tl_to_rb = $diagonalDirection == PHPExcel_Style_Borders::DIAGONAL_BOTH || $diagonalDirection == PHPExcel_Style_Borders::DIAGONAL_DOWN; $diag_tr_to_lb = $diagonalDirection == PHPExcel_Style_Borders::DIAGONAL_BOTH || $diagonalDirection == PHPExcel_Style_Borders::DIAGONAL_UP; $border1 |= $diag_tl_to_rb << 30; $border1 |= $diag_tr_to_lb << 31; $border2 = $this->topBorderColor; $border2 |= $this->bottomBorderColor << 7; $border2 |= $this->_diag_color << 14; $border2 |= self::mapBorderStyle($this->_style->getBorders()->getDiagonal()->getBorderStyle()) << 21; $border2 |= self::mapFillType($this->_style->getFill()->getFillType()) << 26; $header = pack("\x76\166", $record, $length); $biff8_options = $this->_style->getAlignment()->getIndent(); $biff8_options |= (int) $this->_style->getAlignment()->getShrinkToFit() << 4; $data = pack("\166\x76\x76\x43", $ifnt, $ifmt, $style, $align); $data .= pack("\x43\103\x43", self::mapTextRotation($this->_style->getAlignment()->getTextRotation()), $biff8_options, $used_attrib); $data .= pack("\126\x56\x76", $border1, $border2, $icv); return $header . $data; } public function setIsStyleXf($value) { $this->isStyleXf = $value; } public function setBottomColor($colorIndex) { $this->bottomBorderColor = $colorIndex; } public function setTopColor($colorIndex) { $this->topBorderColor = $colorIndex; } public function setLeftColor($colorIndex) { $this->leftBorderColor = $colorIndex; } public function setRightColor($colorIndex) { $this->rightBorderColor = $colorIndex; } public function setDiagColor($colorIndex) { $this->_diag_color = $colorIndex; } public function setFgColor($colorIndex) { $this->foregroundColor = $colorIndex; } public function setBgColor($colorIndex) { $this->backgroundColor = $colorIndex; } public function setNumberFormatIndex($numberFormatIndex) { $this->numberFormatIndex = $numberFormatIndex; } public function setFontIndex($value) { $this->fontIndex = $value; } private static $mapBorderStyles = array(PHPExcel_Style_Border::BORDER_NONE => 0, PHPExcel_Style_Border::BORDER_THIN => 1, PHPExcel_Style_Border::BORDER_MEDIUM => 2, PHPExcel_Style_Border::BORDER_DASHED => 3, PHPExcel_Style_Border::BORDER_DOTTED => 4, PHPExcel_Style_Border::BORDER_THICK => 5, PHPExcel_Style_Border::BORDER_DOUBLE => 6, PHPExcel_Style_Border::BORDER_HAIR => 7, PHPExcel_Style_Border::BORDER_MEDIUMDASHED => 8, PHPExcel_Style_Border::BORDER_DASHDOT => 9, PHPExcel_Style_Border::BORDER_MEDIUMDASHDOT => 10, PHPExcel_Style_Border::BORDER_DASHDOTDOT => 11, PHPExcel_Style_Border::BORDER_MEDIUMDASHDOTDOT => 12, PHPExcel_Style_Border::BORDER_SLANTDASHDOT => 13); private static function mapBorderStyle($borderStyle) { if (isset(self::$mapBorderStyles[$borderStyle])) { return self::$mapBorderStyles[$borderStyle]; } return 0; } private static $mapFillTypes = array(PHPExcel_Style_Fill::FILL_NONE => 0, PHPExcel_Style_Fill::FILL_SOLID => 1, PHPExcel_Style_Fill::FILL_PATTERN_MEDIUMGRAY => 2, PHPExcel_Style_Fill::FILL_PATTERN_DARKGRAY => 3, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTGRAY => 4, PHPExcel_Style_Fill::FILL_PATTERN_DARKHORIZONTAL => 5, PHPExcel_Style_Fill::FILL_PATTERN_DARKVERTICAL => 6, PHPExcel_Style_Fill::FILL_PATTERN_DARKDOWN => 7, PHPExcel_Style_Fill::FILL_PATTERN_DARKUP => 8, PHPExcel_Style_Fill::FILL_PATTERN_DARKGRID => 9, PHPExcel_Style_Fill::FILL_PATTERN_DARKTRELLIS => 10, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTHORIZONTAL => 11, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTVERTICAL => 12, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTDOWN => 13, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTUP => 14, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTGRID => 15, PHPExcel_Style_Fill::FILL_PATTERN_LIGHTTRELLIS => 16, PHPExcel_Style_Fill::FILL_PATTERN_GRAY125 => 17, PHPExcel_Style_Fill::FILL_PATTERN_GRAY0625 => 18, PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR => 0, PHPExcel_Style_Fill::FILL_GRADIENT_PATH => 0); private static function mapFillType($fillType) { if (isset(self::$mapFillTypes[$fillType])) { return self::$mapFillTypes[$fillType]; } return 0; } private static $mapHAlignments = array(PHPExcel_Style_Alignment::HORIZONTAL_GENERAL => 0, PHPExcel_Style_Alignment::HORIZONTAL_LEFT => 1, PHPExcel_Style_Alignment::HORIZONTAL_CENTER => 2, PHPExcel_Style_Alignment::HORIZONTAL_RIGHT => 3, PHPExcel_Style_Alignment::HORIZONTAL_FILL => 4, PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY => 5, PHPExcel_Style_Alignment::HORIZONTAL_CENTER_CONTINUOUS => 6); private function mapHAlign($hAlign) { if (isset(self::$mapHAlignments[$hAlign])) { return self::$mapHAlignments[$hAlign]; } return 0; } private static $mapVAlignments = array(PHPExcel_Style_Alignment::VERTICAL_TOP => 0, PHPExcel_Style_Alignment::VERTICAL_CENTER => 1, PHPExcel_Style_Alignment::VERTICAL_BOTTOM => 2, PHPExcel_Style_Alignment::VERTICAL_JUSTIFY => 3); private static function mapVAlign($vAlign) { if (isset(self::$mapVAlignments[$vAlign])) { return self::$mapVAlignments[$vAlign]; } return 2; } private static function mapTextRotation($textRotation) { if ($textRotation >= 0) { return $textRotation; } elseif ($textRotation == -165) { return 255; } elseif ($textRotation < 0) { return 90 - $textRotation; } } private static function mapLocked($locked) { switch ($locked) { case PHPExcel_Style_Protection::PROTECTION_INHERIT: return 1; case PHPExcel_Style_Protection::PROTECTION_PROTECTED: return 1; case PHPExcel_Style_Protection::PROTECTION_UNPROTECTED: return 0; default: return 1; } } private static function mapHidden($hidden) { switch ($hidden) { case PHPExcel_Style_Protection::PROTECTION_INHERIT: return 0; case PHPExcel_Style_Protection::PROTECTION_PROTECTED: return 1; case PHPExcel_Style_Protection::PROTECTION_UNPROTECTED: return 0; default: return 0; } } }