| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481 | <?phpnamespace PhpOffice\PhpSpreadsheet\Cell;class DataValidation{    // Data validation types    const TYPE_NONE = 'none';    const TYPE_CUSTOM = 'custom';    const TYPE_DATE = 'date';    const TYPE_DECIMAL = 'decimal';    const TYPE_LIST = 'list';    const TYPE_TEXTLENGTH = 'textLength';    const TYPE_TIME = 'time';    const TYPE_WHOLE = 'whole';    // Data validation error styles    const STYLE_STOP = 'stop';    const STYLE_WARNING = 'warning';    const STYLE_INFORMATION = 'information';    // Data validation operators    const OPERATOR_BETWEEN = 'between';    const OPERATOR_EQUAL = 'equal';    const OPERATOR_GREATERTHAN = 'greaterThan';    const OPERATOR_GREATERTHANOREQUAL = 'greaterThanOrEqual';    const OPERATOR_LESSTHAN = 'lessThan';    const OPERATOR_LESSTHANOREQUAL = 'lessThanOrEqual';    const OPERATOR_NOTBETWEEN = 'notBetween';    const OPERATOR_NOTEQUAL = 'notEqual';    /**     * Formula 1.     *     * @var string     */    private $formula1 = '';    /**     * Formula 2.     *     * @var string     */    private $formula2 = '';    /**     * Type.     *     * @var string     */    private $type = self::TYPE_NONE;    /**     * Error style.     *     * @var string     */    private $errorStyle = self::STYLE_STOP;    /**     * Operator.     *     * @var string     */    private $operator = self::OPERATOR_BETWEEN;    /**     * Allow Blank.     *     * @var bool     */    private $allowBlank = false;    /**     * Show DropDown.     *     * @var bool     */    private $showDropDown = false;    /**     * Show InputMessage.     *     * @var bool     */    private $showInputMessage = false;    /**     * Show ErrorMessage.     *     * @var bool     */    private $showErrorMessage = false;    /**     * Error title.     *     * @var string     */    private $errorTitle = '';    /**     * Error.     *     * @var string     */    private $error = '';    /**     * Prompt title.     *     * @var string     */    private $promptTitle = '';    /**     * Prompt.     *     * @var string     */    private $prompt = '';    /**     * Create a new DataValidation.     */    public function __construct()    {    }    /**     * Get Formula 1.     *     * @return string     */    public function getFormula1()    {        return $this->formula1;    }    /**     * Set Formula 1.     *     * @param string $value     *     * @return DataValidation     */    public function setFormula1($value)    {        $this->formula1 = $value;        return $this;    }    /**     * Get Formula 2.     *     * @return string     */    public function getFormula2()    {        return $this->formula2;    }    /**     * Set Formula 2.     *     * @param string $value     *     * @return DataValidation     */    public function setFormula2($value)    {        $this->formula2 = $value;        return $this;    }    /**     * Get Type.     *     * @return string     */    public function getType()    {        return $this->type;    }    /**     * Set Type.     *     * @param string $value     *     * @return DataValidation     */    public function setType($value)    {        $this->type = $value;        return $this;    }    /**     * Get Error style.     *     * @return string     */    public function getErrorStyle()    {        return $this->errorStyle;    }    /**     * Set Error style.     *     * @param string $value see self::STYLE_*     *     * @return DataValidation     */    public function setErrorStyle($value)    {        $this->errorStyle = $value;        return $this;    }    /**     * Get Operator.     *     * @return string     */    public function getOperator()    {        return $this->operator;    }    /**     * Set Operator.     *     * @param string $value     *     * @return DataValidation     */    public function setOperator($value)    {        $this->operator = $value;        return $this;    }    /**     * Get Allow Blank.     *     * @return bool     */    public function getAllowBlank()    {        return $this->allowBlank;    }    /**     * Set Allow Blank.     *     * @param bool $value     *     * @return DataValidation     */    public function setAllowBlank($value)    {        $this->allowBlank = $value;        return $this;    }    /**     * Get Show DropDown.     *     * @return bool     */    public function getShowDropDown()    {        return $this->showDropDown;    }    /**     * Set Show DropDown.     *     * @param bool $value     *     * @return DataValidation     */    public function setShowDropDown($value)    {        $this->showDropDown = $value;        return $this;    }    /**     * Get Show InputMessage.     *     * @return bool     */    public function getShowInputMessage()    {        return $this->showInputMessage;    }    /**     * Set Show InputMessage.     *     * @param bool $value     *     * @return DataValidation     */    public function setShowInputMessage($value)    {        $this->showInputMessage = $value;        return $this;    }    /**     * Get Show ErrorMessage.     *     * @return bool     */    public function getShowErrorMessage()    {        return $this->showErrorMessage;    }    /**     * Set Show ErrorMessage.     *     * @param bool $value     *     * @return DataValidation     */    public function setShowErrorMessage($value)    {        $this->showErrorMessage = $value;        return $this;    }    /**     * Get Error title.     *     * @return string     */    public function getErrorTitle()    {        return $this->errorTitle;    }    /**     * Set Error title.     *     * @param string $value     *     * @return DataValidation     */    public function setErrorTitle($value)    {        $this->errorTitle = $value;        return $this;    }    /**     * Get Error.     *     * @return string     */    public function getError()    {        return $this->error;    }    /**     * Set Error.     *     * @param string $value     *     * @return DataValidation     */    public function setError($value)    {        $this->error = $value;        return $this;    }    /**     * Get Prompt title.     *     * @return string     */    public function getPromptTitle()    {        return $this->promptTitle;    }    /**     * Set Prompt title.     *     * @param string $value     *     * @return DataValidation     */    public function setPromptTitle($value)    {        $this->promptTitle = $value;        return $this;    }    /**     * Get Prompt.     *     * @return string     */    public function getPrompt()    {        return $this->prompt;    }    /**     * Set Prompt.     *     * @param string $value     *     * @return DataValidation     */    public function setPrompt($value)    {        $this->prompt = $value;        return $this;    }    /**     * Get hash code.     *     * @return string Hash code     */    public function getHashCode()    {        return md5(            $this->formula1 .            $this->formula2 .            $this->type .            $this->errorStyle .            $this->operator .            ($this->allowBlank ? 't' : 'f') .            ($this->showDropDown ? 't' : 'f') .            ($this->showInputMessage ? 't' : 'f') .            ($this->showErrorMessage ? 't' : 'f') .            $this->errorTitle .            $this->error .            $this->promptTitle .            $this->prompt .            __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;            }        }    }}
 |