diff options
author | Loic Blot <loic.blot@unix-experience.fr> | 2015-06-24 09:40:03 +0300 |
---|---|---|
committer | Loic Blot <loic.blot@unix-experience.fr> | 2015-06-24 09:40:03 +0300 |
commit | 76b0ae3912c658aec870e33f6bb01ba26e9a5cde (patch) | |
tree | 883e695f5b987547be48b76f1d06deaf7e5bf797 /db | |
parent | 4852fa367557d3f7cadbcd347701d13953bad2c8 (diff) |
smscontroller::removeConversation link with smsmapper::removeMessagesForPhoneNumber. We need to drop messages now
Diffstat (limited to 'db')
-rw-r--r-- | db/smsmapper.php | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/db/smsmapper.php b/db/smsmapper.php index dfbe35e..9fe422e 100644 --- a/db/smsmapper.php +++ b/db/smsmapper.php @@ -85,7 +85,7 @@ class SmsMapper extends Mapper { $query = \OCP\DB::prepare('SELECT max(sms_date) as mx FROM ' . '*PREFIX*ocsms_smsdatas WHERE user_id = ?'); $result = $query->execute(array($userId)); - + if ($row = $result->fetchRow()) { return $row["mx"]; } @@ -173,11 +173,14 @@ class SmsMapper extends Mapper { return $cnt; } + public function removeMessagesForPhoneNumber ($userId, $phoneNumber) { + } + public function getLastMessageTimestampForAllPhonesNumbers ($userId, $order = true) { $sql = 'SELECT sms_address,MAX(sms_date) as mx FROM ' . '*PREFIX*ocsms_smsdatas WHERE user_id = ? AND sms_mailbox IN (?,?) ' . 'GROUP BY sms_address'; - + if ($order === true) { $sql .= ' ORDER BY mx DESC'; } @@ -201,7 +204,7 @@ class SmsMapper extends Mapper { $sql = 'SELECT sms_address,count(sms_date) as ct FROM ' . '*PREFIX*ocsms_smsdatas WHERE user_id = ? AND sms_mailbox IN (?,?) ' . 'AND sms_date > ? GROUP BY sms_address'; - + $query = \OCP\DB::prepare($sql); $result = $query->execute(array($userId, 0, 1, $ld)); @@ -218,7 +221,7 @@ class SmsMapper extends Mapper { public function getLastReadDate ($userId) { $sql = 'SELECT MAX(datavalue) as mx FROM ' . '*PREFIX*ocsms_user_datas WHERE user_id = ?'; - + $query = \OCP\DB::prepare($sql); $result = $query->execute(array($userId)); |