1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
|
<?php
/*
* Spring Signage Ltd - http://www.springsignage.com
* Copyright (C) 2016 Spring Signage Ltd
* (UserOptionFactory.php)
*/
namespace Xibo\Factory;
use Xibo\Entity\UserOption;
use Xibo\Service\LogServiceInterface;
use Xibo\Service\SanitizerServiceInterface;
use Xibo\Storage\StorageServiceInterface;
/**
* Class UserOptionFactory
* @package Xibo\Factory
*/
class UserOptionFactory extends BaseFactory
{
/**
* Construct a factory
* @param StorageServiceInterface $store
* @param LogServiceInterface $log
* @param SanitizerServiceInterface $sanitizerService
*/
public function __construct($store, $log, $sanitizerService)
{
$this->setCommonDependencies($store, $log, $sanitizerService);
}
/**
* Load by User Id
* @param int $userId
* @return array[UserOption]
*/
public function getByUserId($userId)
{
return $this->query(null, array('userId' => $userId));
}
/**
* Create Empty
* @return UserOption
*/
public function createEmpty()
{
return new UserOption($this->getStore(), $this->getLog());
}
/**
* Create a user option
* @param int $userId
* @param string $option
* @param mixed $value
* @return UserOption
*/
public function create($userId, $option, $value)
{
$userOption = $this->createEmpty();
$userOption->userId = $userId;
$userOption->option = $option;
$userOption->value = $value;
return $userOption;
}
/**
* Query User options
* @param array $sortOrder
* @param array $filterBy
* @return array[UserOption]
*/
public function query($sortOrder = null, $filterBy = null)
{
if (DBVERSION < 122)
return [];
$entries = array();
$sql = 'SELECT * FROM `useroption` WHERE userId = :userId';
foreach ($this->getStore()->select($sql, array('userId' => $this->getSanitizer()->getInt('userId', $filterBy))) as $row) {
$entries[] = $this->createEmpty()->hydrate($row);
}
return $entries;
}
}
|