@@ 62-68 (lines=7) @@ | ||
59 | } |
|
60 | $sql = "SELECT id, uid, name, grouping, shared, mtime, deleted, note FROM *PREFIX*ownnote n WHERE n.id= ? $uidSql $deletedSql"; |
|
61 | $results = []; |
|
62 | foreach ($this->execute($sql, $params)->fetchAll() as $item) { |
|
63 | /** |
|
64 | * @var $note NextNote |
|
65 | */ |
|
66 | $note = $this->makeEntityFromDBResult($item); |
|
67 | $results[] = $note; |
|
68 | } |
|
69 | return array_shift($results); |
|
70 | } |
|
71 | ||
@@ 94-100 (lines=7) @@ | ||
91 | } |
|
92 | $sql = "SELECT id, uid, name, grouping, shared, mtime, deleted, note FROM *PREFIX*ownnote n WHERE `uid` = ? $groupSql $deletedSql"; |
|
93 | $results = []; |
|
94 | foreach ($this->execute($sql, $params)->fetchAll() as $item) { |
|
95 | /** |
|
96 | * @var $note NextNote |
|
97 | */ |
|
98 | $note = $this->makeEntityFromDBResult($item); |
|
99 | $results[] = $note; |
|
100 | } |
|
101 | return $results; |
|
102 | } |
|
103 |