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
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
|
<?php
/*
* Spring Signage Ltd - http://www.springsignage.com
* Copyright (C) 2015 Spring Signage Ltd
* (HelpFactory.php)
*/
namespace Xibo\Factory;
use Xibo\Entity\Help;
use Xibo\Exception\NotFoundException;
use Xibo\Service\LogServiceInterface;
use Xibo\Service\SanitizerServiceInterface;
use Xibo\Storage\StorageServiceInterface;
class HelpFactory 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);
}
/**
* @return Help
*/
public function createEmpty()
{
return new Help(
$this->getStore(),
$this->getLog()
);
}
/**
* @param int $helpId
* @return Help
* @throws NotFoundException
*/
public function getById($helpId)
{
$help = $this->query(null, ['helpId' => $helpId]);
if (count($help) <= 0)
throw new NotFoundException();
return $help[0];
}
/**
* @param array $sortOrder
* @param array $filterBy
* @return array[Transition]
* @throws NotFoundException
*/
public function query($sortOrder = null, $filterBy = [])
{
$entries = array();
$params = array();
$select = 'SELECT `helpId`, `topic`, `category`, `link` ';
$body = '
FROM `help`
WHERE 1 = 1
';
if ($this->getSanitizer()->getInt('helpId', $filterBy) !== null) {
$body .= ' AND help.helpId = :helpId ';
$params['helpId'] = $this->getSanitizer()->getInt('helpId', $filterBy);
}
// Sorting?
$order = '';
if (is_array($sortOrder))
$order .= ' ORDER BY ' . implode(',', $sortOrder);
$limit = '';
if ($filterBy !== null && $this->getSanitizer()->getInt('start', $filterBy) !== null && $this->getSanitizer()->getInt('length', $filterBy) !== null) {
$limit .= ' LIMIT ' . intval($this->getSanitizer()->getInt('start')) . ', ' . $this->getSanitizer()->getInt('length', 10);
}
$sql = $select . $body . $order . $limit;
foreach ($this->getStore()->select($sql, $params) as $row) {
$entries[] = $this->createEmpty()->hydrate($row);
}
// Paging
if ($limit != '' && count($entries) > 0) {
$results = $this->getStore()->select('SELECT COUNT(*) AS total ' . $body, $params);
$this->_countLast = intval($results[0]['total']);
}
return $entries;
}
}
|