name = ''; $this->description = ''; $this->worksheet = null; $this->coordinates = 'A1'; $this->offsetX = 0; $this->offsetY = 0; $this->width = 0; $this->height = 0; $this->resizeProportional = true; $this->rotation = 0; $this->shadow = new PHPExcel_Worksheet_Drawing_Shadow(); // Set image index self::$imageCounter++; $this->imageIndex = self::$imageCounter; } /** * Get image index * * @return int */ public function getImageIndex() { return $this->imageIndex; } /** * Get Name * * @return string */ public function getName() { return $this->name; } /** * Set Name * * @param string $pValue * @return PHPExcel_Worksheet_BaseDrawing */ public function setName($pValue = '') { $this->name = $pValue; return $this; } /** * Get Description * * @return string */ public function getDescription() { return $this->description; } /** * Set Description * * @param string $pValue * @return PHPExcel_Worksheet_BaseDrawing */ public function setDescription($pValue = '') { $this->description = $pValue; return $this; } /** * Get Worksheet * * @return PHPExcel_Worksheet */ public function getWorksheet() { return $this->worksheet; } /** * Set Worksheet * * @param PHPExcel_Worksheet $pValue * @param bool $pOverrideOld If a Worksheet has already been assigned, overwrite it and remove image from old Worksheet? * @throws PHPExcel_Exception * @return PHPExcel_Worksheet_BaseDrawing */ public function setWorksheet(PHPExcel_Worksheet $pValue = null, $pOverrideOld = false) { if (is_null($this->worksheet)) { // Add drawing to PHPExcel_Worksheet $this->worksheet = $pValue; $this->worksheet->getCell($this->coordinates); $this->worksheet->getDrawingCollection()->append($this); } else { if ($pOverrideOld) { // Remove drawing from old PHPExcel_Worksheet $iterator = $this->worksheet->getDrawingCollection()->getIterator(); while ($iterator->valid()) { if ($iterator->current()->getHashCode() == $this->getHashCode()) { $this->worksheet->getDrawingCollection()->offsetUnset($iterator->key()); $this->worksheet = null; break; } } // Set new PHPExcel_Worksheet $this->setWorksheet($pValue); } else { throw new PHPExcel_Exception("A PHPExcel_Worksheet has already been assigned. Drawings can only exist on one PHPExcel_Worksheet."); } } return $this; } /** * Get Coordinates * * @return string */ public function getCoordinates() { return $this->coordinates; } /** * Set Coordinates * * @param string $pValue * @return PHPExcel_Worksheet_BaseDrawing */ public function setCoordinates($pValue = 'A1') { $this->coordinates = $pValue; return $this; } /** * Get OffsetX * * @return int */ public function getOffsetX() { return $this->offsetX; } /** * Set OffsetX * * @param int $pValue * @return PHPExcel_Worksheet_BaseDrawing */ public function setOffsetX($pValue = 0) { $this->offsetX = $pValue; return $this; } /** * Get OffsetY * * @return int */ public function getOffsetY() { return $this->offsetY; } /** * Set OffsetY * * @param int $pValue * @return PHPExcel_Worksheet_BaseDrawing */ public function setOffsetY($pValue = 0) { $this->offsetY = $pValue; return $this; } /** * Get Width * * @return int */ public function getWidth() { return $this->width; } /** * Set Width * * @param int $pValue * @return PHPExcel_Worksheet_BaseDrawing */ public function setWidth($pValue = 0) { // Resize proportional? if ($this->resizeProportional && $pValue != 0) { $ratio = $this->height / ($this->width != 0 ? $this->width : 1); $this->height = round($ratio * $pValue); } // Set width $this->width = $pValue; return $this; } /** * Get Height * * @return int */ public function getHeight() { return $this->height; } /** * Set Height * * @param int $pValue * @return PHPExcel_Worksheet_BaseDrawing */ public function setHeight($pValue = 0) { // Resize proportional? if ($this->resizeProportional && $pValue != 0) { $ratio = $this->width / ($this->height != 0 ? $this->height : 1); $this->width = round($ratio * $pValue); } // Set height $this->height = $pValue; return $this; } /** * Set width and height with proportional resize * Example: * * $objDrawing->setResizeProportional(true); * $objDrawing->setWidthAndHeight(160,120); * * * @author Vincent@luo MSN:kele_100@hotmail.com * @param int $width * @param int $height * @return PHPExcel_Worksheet_BaseDrawing */ public function setWidthAndHeight($width = 0, $height = 0) { $xratio = $width / ($this->width != 0 ? $this->width : 1); $yratio = $height / ($this->height != 0 ? $this->height : 1); if ($this->resizeProportional && !($width == 0 || $height == 0)) { if (($xratio * $this->height) < $height) { $this->height = ceil($xratio * $this->height); $this->width = $width; } else { $this->width = ceil($yratio * $this->width); $this->height = $height; } } else { $this->width = $width; $this->height = $height; } return $this; } /** * Get ResizeProportional * * @return boolean */ public function getResizeProportional() { return $this->resizeProportional; } /** * Set ResizeProportional * * @param boolean $pValue * @return PHPExcel_Worksheet_BaseDrawing */ public function setResizeProportional($pValue = true) { $this->resizeProportional = $pValue; return $this; } /** * Get Rotation * * @return int */ public function getRotation() { return $this->rotation; } /** * Set Rotation * * @param int $pValue * @return PHPExcel_Worksheet_BaseDrawing */ public function setRotation($pValue = 0) { $this->rotation = $pValue; return $this; } /** * Get Shadow * * @return PHPExcel_Worksheet_Drawing_Shadow */ public function getShadow() { return $this->shadow; } /** * Set Shadow * * @param PHPExcel_Worksheet_Drawing_Shadow $pValue * @throws PHPExcel_Exception * @return PHPExcel_Worksheet_BaseDrawing */ public function setShadow(PHPExcel_Worksheet_Drawing_Shadow $pValue = null) { $this->shadow = $pValue; return $this; } /** * Get hash code * * @return string Hash code */ public function getHashCode() { return md5( $this->name . $this->description . $this->worksheet->getHashCode() . $this->coordinates . $this->offsetX . $this->offsetY . $this->width . $this->height . $this->rotation . $this->shadow->getHashCode() . __CLASS__ ); } /** * 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; } } } }