diff options
author | Bernhard Posselt <nukeawhale@gmail.com> | 2013-05-10 13:30:00 +0200 |
---|---|---|
committer | Bernhard Posselt <nukeawhale@gmail.com> | 2013-05-10 13:30:00 +0200 |
commit | 347000cc2d5597c1971942ebdbe97461c9fa5802 (patch) | |
tree | 8a2f6dc166ad871c646b4cf8bf13f4a9fcd02e55 /db/foldermapper.php | |
parent | c487bfe23312a5b266d8eb21a3825ab791a1c3e8 (diff) |
use a deleted flag for deleted feeds to handle undo
Diffstat (limited to 'db/foldermapper.php')
-rw-r--r-- | db/foldermapper.php | 22 |
1 files changed, 20 insertions, 2 deletions
diff --git a/db/foldermapper.php b/db/foldermapper.php index 8978bb45b..f8d088cdb 100644 --- a/db/foldermapper.php +++ b/db/foldermapper.php @@ -65,7 +65,8 @@ class FolderMapper extends Mapper implements IMapper { public function findAllFromUser($userId){ $sql = 'SELECT * FROM `*PREFIX*news_folders` ' . - 'WHERE `user_id` = ?'; + 'WHERE `user_id` = ? ' . + 'AND `deleted_at` = 0'; $params = array($userId); return $this->findAllRows($sql, $params); @@ -74,7 +75,7 @@ class FolderMapper extends Mapper implements IMapper { public function findByName($folderName, $userId){ $sql = 'SELECT * FROM `*PREFIX*news_folders` ' . - 'WHERE `name` = ?' . + 'WHERE `name` = ? ' . 'AND `user_id` = ?'; $params = array($folderName, $userId); @@ -96,4 +97,21 @@ class FolderMapper extends Mapper implements IMapper { } + public function getToDelete($deleteOlderThan, $userId=null) { + $sql = 'SELECT * FROM `*PREFIX*news_folders` ' . + 'WHERE `deleted_at` > 0 ' . + 'AND `deleted_at` < ?'; + $params = array($deleteOlderThan); + + // we need to sometimes only delete feeds of a user + if($userId !== null) { + $sql .= ' AND `user_id` = ?'; + array_push($params, $userId); + } + + return $this->findAllRows($sql, $params); + } + + + }
\ No newline at end of file |