| @@ 54-60 (lines=7) @@ | ||
| 51 | } |
|
| 52 | $sql = "SELECT id, uid, name, grouping, shared, mtime, deleted, note FROM *PREFIX*ownnote n WHERE n.id= ? $uidSql and n.deleted = 0"; |
|
| 53 | $results = []; |
|
| 54 | foreach($this->execute($sql, $params)->fetchAll() as $item){ |
|
| 55 | /** |
|
| 56 | * @var $note OwnNote |
|
| 57 | */ |
|
| 58 | $note = $this->makeEntityFromDBResult($item); |
|
| 59 | $results[] = $note; |
|
| 60 | } |
|
| 61 | return array_shift($results); |
|
| 62 | } |
|
| 63 | ||
| @@ 74-80 (lines=7) @@ | ||
| 71 | $params = [$userId, $deleted]; |
|
| 72 | $sql = "SELECT id, uid, name, grouping, shared, mtime, deleted, note FROM *PREFIX*ownnote n WHERE `uid` = ? and n.deleted = ?"; |
|
| 73 | $results = []; |
|
| 74 | foreach($this->execute($sql, $params)->fetchAll() as $item){ |
|
| 75 | /** |
|
| 76 | * @var $note OwnNote |
|
| 77 | */ |
|
| 78 | $note = $this->makeEntityFromDBResult($item); |
|
| 79 | $results[] = $note; |
|
| 80 | } |
|
| 81 | return $results; |
|
| 82 | } |
|
| 83 | /** |
|