. */ namespace Xibo\Entity; use Xibo\Service\LogServiceInterface; use Xibo\Storage\StorageServiceInterface; /** * Class UserOption * @package Xibo\Entity * * @SWG\Definition() */ class UserOption implements \JsonSerializable { use EntityTrait; /** * @SWG\Property(description="The userId that this Option applies to") * @var int */ public $userId; /** * @SWG\Property(description="The option name") * @var string */ public $option; /** * @SWG\Property(description="The option value") * @var string */ public $value; /** * Entity constructor. * @param StorageServiceInterface $store * @param LogServiceInterface $log * @param \Symfony\Component\EventDispatcher\EventDispatcherInterface $dispatcher */ public function __construct($store, $log, $dispatcher) { $this->setCommonDependencies($store, $log, $dispatcher); $this->excludeProperty('userId'); } /** * @inheritdoc */ public function __toString() { return $this->userId . '-' . $this->option . '-' . md5($this->value); } public function save() { // when the option is not in the database and default is on, switching option value to off // would not insert the record, hence the additional condition here xibosignage/xibo#2975 if ($this->hasPropertyChanged('value') || ($this->getOriginalValue('value') === null && $this->value !== null) ) { $this->getStore()->insert('INSERT INTO `useroption` (`userId`, `option`, `value`) VALUES (:userId, :option, :value) ON DUPLICATE KEY UPDATE `value` = :value2', [ 'userId' => $this->userId, 'option' => $this->option, 'value' => $this->value, 'value2' => $this->value, ]); } } public function delete() { $this->getStore()->update('DELETE FROM `useroption` WHERE `userId` = :userId AND `option` = :option', [ 'userId' => $this->userId, 'option' => $this->option ]); } }