invite.php
1.88 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
<?php
/**
* ownCloud - Documents App
*
* @author Victor Dubiniuk
* @copyright 2013 Victor Dubiniuk victor.dubiniuk@gmail.com
*
* This file is licensed under the Affero General Public License version 3 or
* later.
*/
namespace OCA\Documents;
class Invite {
const STATUS_SENT = 0;
const STATUS_DECLINED = 1;
const STATUS_ACCEPTED = 2;
public static function add($esId, $userId){
$query = \OCP\DB::prepare('
INSERT INTO `*PREFIX*documents_invite` (`es_id`, `uid`, `status`, `sent_on`)
VALUES (?, ?, ?, ?)
');
$query->execute(array(
$esId,
$userId,
self::STATUS_SENT,
time()
));
return \OCP\DB::insertid(`*PREFIX*documents_invite`);
}
public static function accept($esId){
$query = \OCP\DB::prepare('UPDATE `*PREFIX*documents_invite` SET `status`=? WHERE `es_id`=? AND `uid`=?');
$query->execute(array(
self::STATUS_ACCEPTED,
$esId,
\OCP\User::getUser()
));
}
public static function decline($esId){
$query = \OCP\DB::prepare('UPDATE `*PREFIX*documents_invite` SET `status`=? WHERE `es_id`=? AND `uid`=?');
$query->execute(array(
self::STATUS_DECLINED,
$esId,
\OCP\User::getUser()
));
}
public static function getAllInvites(){
$query = \OCP\DB::prepare('SELECT * FROM `*PREFIX*documents_invite` WHERE `uid`= ?');
$result = $query->execute(array(\OCP\User::getUser()));
return $result->fetchAll();
}
public static function getSenderStatusesAsArray(){
$l10n = \OCP\Util::getL10N('documents');
return array(
self::STATUS_SENT => $l10n->t('Sent'),
self::STATUS_DECLINED => $l10n->t('Declined'),
self::STATUS_ACCEPTED => $l10n->t('Accepted')
);
}
public static function getRecipientStatusesAsArray(){
$l10n = \OCP\Util::getL10N('documents');
return array(
self::STATUS_SENT => $l10n->t('Incoming'),
self::STATUS_DECLINED => $l10n->t('Declined'),
self::STATUS_ACCEPTED => $l10n->t('Accepted')
);
}
}