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
|
<?php
/**
* @fils
* Database functions.
*/
/**
* Check if user already requested an item.
*
* @param $nid
* Item nid.
*
* @param $uid
* Requester user nid.
*
* @return
* TRUE if user already requested an item, FALSE otherwise.
*/
function muamba_check_user_request($nid, $uid) {
$nid = (int) $nid;
$uid = (int) $uid;
$query = db_select('muamba', 'm');
$query
->condition('m.nid', $nid, '=')
->condition('m.uid', $uid, '=')
->condition('m.status', MUAMBA_REQUESTED, '=');
$result = $query->countQuery()->execute()->fetchField();
if ($result > 0) {
return TRUE;
}
return FALSE;
}
/**
* Get the requests sent or received.
*
* @param $uid
* Requester user uid.
*/
function muamba_get_transactions($uid, $type = 'sent', $status = MUAMBA_REQUESTED) {
$uid = (int) $uid;
$query = db_select('muamba', 'm');
if ($type == 'sent') {
$query
->condition('m.uid', $uid, '=')
->condition('m.status', $status, '=')
->fields('m', array('mid', 'nid', 'uid', 'owner', 'thread_id'));
}
else {
$query
->condition('m.owner', $uid, '=')
->condition('m.status', $status, '=')
->fields('m', array('mid', 'nid', 'uid', 'owner', 'status', 'thread_id'));
}
$rows = array();
$results = $query->execute()->fetchAll();
// Sanitize the data before handing it off to the theme layer.
foreach ($results as $entry) {
$rows[] = array_map('check_plain', (array) $entry);
}
return $rows;
}
|