Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/nextcloud/ocsms.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorLoic Blot <loic.blot@unix-experience.fr>2015-06-24 09:40:03 +0300
committerLoic Blot <loic.blot@unix-experience.fr>2015-06-24 09:40:03 +0300
commit76b0ae3912c658aec870e33f6bb01ba26e9a5cde (patch)
tree883e695f5b987547be48b76f1d06deaf7e5bf797 /db
parent4852fa367557d3f7cadbcd347701d13953bad2c8 (diff)
smscontroller::removeConversation link with smsmapper::removeMessagesForPhoneNumber. We need to drop messages now
Diffstat (limited to 'db')
-rw-r--r--db/smsmapper.php11
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));