| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586 | <?phpnamespace PhpOffice\PhpSpreadsheet\Worksheet;use PhpOffice\PhpSpreadsheet\Shared\PasswordHasher;class Protection{    /**     * Sheet.     *     * @var bool     */    private $sheet = false;    /**     * Objects.     *     * @var bool     */    private $objects = false;    /**     * Scenarios.     *     * @var bool     */    private $scenarios = false;    /**     * Format cells.     *     * @var bool     */    private $formatCells = false;    /**     * Format columns.     *     * @var bool     */    private $formatColumns = false;    /**     * Format rows.     *     * @var bool     */    private $formatRows = false;    /**     * Insert columns.     *     * @var bool     */    private $insertColumns = false;    /**     * Insert rows.     *     * @var bool     */    private $insertRows = false;    /**     * Insert hyperlinks.     *     * @var bool     */    private $insertHyperlinks = false;    /**     * Delete columns.     *     * @var bool     */    private $deleteColumns = false;    /**     * Delete rows.     *     * @var bool     */    private $deleteRows = false;    /**     * Select locked cells.     *     * @var bool     */    private $selectLockedCells = false;    /**     * Sort.     *     * @var bool     */    private $sort = false;    /**     * AutoFilter.     *     * @var bool     */    private $autoFilter = false;    /**     * Pivot tables.     *     * @var bool     */    private $pivotTables = false;    /**     * Select unlocked cells.     *     * @var bool     */    private $selectUnlockedCells = false;    /**     * Password.     *     * @var string     */    private $password = '';    /**     * Create a new Protection.     */    public function __construct()    {    }    /**     * Is some sort of protection enabled?     *     * @return bool     */    public function isProtectionEnabled()    {        return $this->sheet ||            $this->objects ||            $this->scenarios ||            $this->formatCells ||            $this->formatColumns ||            $this->formatRows ||            $this->insertColumns ||            $this->insertRows ||            $this->insertHyperlinks ||            $this->deleteColumns ||            $this->deleteRows ||            $this->selectLockedCells ||            $this->sort ||            $this->autoFilter ||            $this->pivotTables ||            $this->selectUnlockedCells;    }    /**     * Get Sheet.     *     * @return bool     */    public function getSheet()    {        return $this->sheet;    }    /**     * Set Sheet.     *     * @param bool $pValue     *     * @return Protection     */    public function setSheet($pValue)    {        $this->sheet = $pValue;        return $this;    }    /**     * Get Objects.     *     * @return bool     */    public function getObjects()    {        return $this->objects;    }    /**     * Set Objects.     *     * @param bool $pValue     *     * @return Protection     */    public function setObjects($pValue)    {        $this->objects = $pValue;        return $this;    }    /**     * Get Scenarios.     *     * @return bool     */    public function getScenarios()    {        return $this->scenarios;    }    /**     * Set Scenarios.     *     * @param bool $pValue     *     * @return Protection     */    public function setScenarios($pValue)    {        $this->scenarios = $pValue;        return $this;    }    /**     * Get FormatCells.     *     * @return bool     */    public function getFormatCells()    {        return $this->formatCells;    }    /**     * Set FormatCells.     *     * @param bool $pValue     *     * @return Protection     */    public function setFormatCells($pValue)    {        $this->formatCells = $pValue;        return $this;    }    /**     * Get FormatColumns.     *     * @return bool     */    public function getFormatColumns()    {        return $this->formatColumns;    }    /**     * Set FormatColumns.     *     * @param bool $pValue     *     * @return Protection     */    public function setFormatColumns($pValue)    {        $this->formatColumns = $pValue;        return $this;    }    /**     * Get FormatRows.     *     * @return bool     */    public function getFormatRows()    {        return $this->formatRows;    }    /**     * Set FormatRows.     *     * @param bool $pValue     *     * @return Protection     */    public function setFormatRows($pValue)    {        $this->formatRows = $pValue;        return $this;    }    /**     * Get InsertColumns.     *     * @return bool     */    public function getInsertColumns()    {        return $this->insertColumns;    }    /**     * Set InsertColumns.     *     * @param bool $pValue     *     * @return Protection     */    public function setInsertColumns($pValue)    {        $this->insertColumns = $pValue;        return $this;    }    /**     * Get InsertRows.     *     * @return bool     */    public function getInsertRows()    {        return $this->insertRows;    }    /**     * Set InsertRows.     *     * @param bool $pValue     *     * @return Protection     */    public function setInsertRows($pValue)    {        $this->insertRows = $pValue;        return $this;    }    /**     * Get InsertHyperlinks.     *     * @return bool     */    public function getInsertHyperlinks()    {        return $this->insertHyperlinks;    }    /**     * Set InsertHyperlinks.     *     * @param bool $pValue     *     * @return Protection     */    public function setInsertHyperlinks($pValue)    {        $this->insertHyperlinks = $pValue;        return $this;    }    /**     * Get DeleteColumns.     *     * @return bool     */    public function getDeleteColumns()    {        return $this->deleteColumns;    }    /**     * Set DeleteColumns.     *     * @param bool $pValue     *     * @return Protection     */    public function setDeleteColumns($pValue)    {        $this->deleteColumns = $pValue;        return $this;    }    /**     * Get DeleteRows.     *     * @return bool     */    public function getDeleteRows()    {        return $this->deleteRows;    }    /**     * Set DeleteRows.     *     * @param bool $pValue     *     * @return Protection     */    public function setDeleteRows($pValue)    {        $this->deleteRows = $pValue;        return $this;    }    /**     * Get SelectLockedCells.     *     * @return bool     */    public function getSelectLockedCells()    {        return $this->selectLockedCells;    }    /**     * Set SelectLockedCells.     *     * @param bool $pValue     *     * @return Protection     */    public function setSelectLockedCells($pValue)    {        $this->selectLockedCells = $pValue;        return $this;    }    /**     * Get Sort.     *     * @return bool     */    public function getSort()    {        return $this->sort;    }    /**     * Set Sort.     *     * @param bool $pValue     *     * @return Protection     */    public function setSort($pValue)    {        $this->sort = $pValue;        return $this;    }    /**     * Get AutoFilter.     *     * @return bool     */    public function getAutoFilter()    {        return $this->autoFilter;    }    /**     * Set AutoFilter.     *     * @param bool $pValue     *     * @return Protection     */    public function setAutoFilter($pValue)    {        $this->autoFilter = $pValue;        return $this;    }    /**     * Get PivotTables.     *     * @return bool     */    public function getPivotTables()    {        return $this->pivotTables;    }    /**     * Set PivotTables.     *     * @param bool $pValue     *     * @return Protection     */    public function setPivotTables($pValue)    {        $this->pivotTables = $pValue;        return $this;    }    /**     * Get SelectUnlockedCells.     *     * @return bool     */    public function getSelectUnlockedCells()    {        return $this->selectUnlockedCells;    }    /**     * Set SelectUnlockedCells.     *     * @param bool $pValue     *     * @return Protection     */    public function setSelectUnlockedCells($pValue)    {        $this->selectUnlockedCells = $pValue;        return $this;    }    /**     * Get Password (hashed).     *     * @return string     */    public function getPassword()    {        return $this->password;    }    /**     * Set Password.     *     * @param string $pValue     * @param bool $pAlreadyHashed If the password has already been hashed, set this to true     *     * @return Protection     */    public function setPassword($pValue, $pAlreadyHashed = false)    {        if (!$pAlreadyHashed) {            $pValue = PasswordHasher::hashPassword($pValue);        }        $this->password = $pValue;        return $this;    }    /**     * 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;            }        }    }}
 |