| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190 | 
							- <?php
 
- namespace PhpOffice\PhpSpreadsheet\Style;
 
- use PhpOffice\PhpSpreadsheet\Exception as PhpSpreadsheetException;
 
- class Protection extends Supervisor
 
- {
 
-     /** Protection styles */
 
-     const PROTECTION_INHERIT = 'inherit';
 
-     const PROTECTION_PROTECTED = 'protected';
 
-     const PROTECTION_UNPROTECTED = 'unprotected';
 
-     /**
 
-      * Locked.
 
-      *
 
-      * @var string
 
-      */
 
-     protected $locked;
 
-     /**
 
-      * Hidden.
 
-      *
 
-      * @var string
 
-      */
 
-     protected $hidden;
 
-     /**
 
-      * Create a new Protection.
 
-      *
 
-      * @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->locked = self::PROTECTION_INHERIT;
 
-             $this->hidden = self::PROTECTION_INHERIT;
 
-         }
 
-     }
 
-     /**
 
-      * Get the shared style component for the currently active cell in currently active sheet.
 
-      * Only used for style supervisor.
 
-      *
 
-      * @return Protection
 
-      */
 
-     public function getSharedComponent()
 
-     {
 
-         return $this->parent->getSharedComponent()->getProtection();
 
-     }
 
-     /**
 
-      * Build style array from subcomponents.
 
-      *
 
-      * @param array $array
 
-      *
 
-      * @return array
 
-      */
 
-     public function getStyleArray($array)
 
-     {
 
-         return ['protection' => $array];
 
-     }
 
-     /**
 
-      * Apply styles from array.
 
-      *
 
-      * <code>
 
-      * $spreadsheet->getActiveSheet()->getStyle('B2')->getLocked()->applyFromArray(
 
-      *     [
 
-      *         'locked' => TRUE,
 
-      *         'hidden' => FALSE
 
-      *     ]
 
-      * );
 
-      * </code>
 
-      *
 
-      * @param array $pStyles Array containing style information
 
-      *
 
-      * @throws PhpSpreadsheetException
 
-      *
 
-      * @return Protection
 
-      */
 
-     public function applyFromArray(array $pStyles)
 
-     {
 
-         if ($this->isSupervisor) {
 
-             $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($this->getStyleArray($pStyles));
 
-         } else {
 
-             if (isset($pStyles['locked'])) {
 
-                 $this->setLocked($pStyles['locked']);
 
-             }
 
-             if (isset($pStyles['hidden'])) {
 
-                 $this->setHidden($pStyles['hidden']);
 
-             }
 
-         }
 
-         return $this;
 
-     }
 
-     /**
 
-      * Get locked.
 
-      *
 
-      * @return string
 
-      */
 
-     public function getLocked()
 
-     {
 
-         if ($this->isSupervisor) {
 
-             return $this->getSharedComponent()->getLocked();
 
-         }
 
-         return $this->locked;
 
-     }
 
-     /**
 
-      * Set locked.
 
-      *
 
-      * @param string $pValue see self::PROTECTION_*
 
-      *
 
-      * @return Protection
 
-      */
 
-     public function setLocked($pValue)
 
-     {
 
-         if ($this->isSupervisor) {
 
-             $styleArray = $this->getStyleArray(['locked' => $pValue]);
 
-             $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
 
-         } else {
 
-             $this->locked = $pValue;
 
-         }
 
-         return $this;
 
-     }
 
-     /**
 
-      * Get hidden.
 
-      *
 
-      * @return string
 
-      */
 
-     public function getHidden()
 
-     {
 
-         if ($this->isSupervisor) {
 
-             return $this->getSharedComponent()->getHidden();
 
-         }
 
-         return $this->hidden;
 
-     }
 
-     /**
 
-      * Set hidden.
 
-      *
 
-      * @param string $pValue see self::PROTECTION_*
 
-      *
 
-      * @return Protection
 
-      */
 
-     public function setHidden($pValue)
 
-     {
 
-         if ($this->isSupervisor) {
 
-             $styleArray = $this->getStyleArray(['hidden' => $pValue]);
 
-             $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
 
-         } else {
 
-             $this->hidden = $pValue;
 
-         }
 
-         return $this;
 
-     }
 
-     /**
 
-      * Get hash code.
 
-      *
 
-      * @return string Hash code
 
-      */
 
-     public function getHashCode()
 
-     {
 
-         if ($this->isSupervisor) {
 
-             return $this->getSharedComponent()->getHashCode();
 
-         }
 
-         return md5(
 
-             $this->locked .
 
-             $this->hidden .
 
-             __CLASS__
 
-         );
 
-     }
 
- }
 
 
  |