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
80
81
82
83
84
|
-- Gemeinschaft 5 module: phone book class
-- (c) AMOOMA GmbH 2012-2013
--
module(...,package.seeall)
PhoneBook = {}
-- create phone_book object
function PhoneBook.new(self, arg)
arg = arg or {}
object = arg.object or {}
setmetatable(object, self);
self.__index = self;
self.class = 'phonebook';
self.log = arg.log;
self.database = arg.database;
return object;
end
function PhoneBook.find_entry_by_number_user_tenant(self, numbers, user_id, tenant_id, name)
user_id = tonumber(user_id) or 0;
tenant_id = tonumber(tenant_id) or 0;
if not numbers or #numbers == 0 then
return nil;
end
local numbers_sql = '"' .. table.concat(numbers, '","') .. '"';
local sql_query = 'SELECT `a`.`name` AS `number_name`, \
`a`.`number`, \
`b`.`id`, \
`b`.`value_of_to_s`, \
`b`.`phone_book_id`, \
`b`.`image`, \
`c`.`name` AS `phone_book_name`, \
`d`.`bellcore_id` \
FROM `phone_numbers` `a` \
JOIN `phone_book_entries` `b` ON `a`.`phone_numberable_id` = `b`.`id` AND `a`.`phone_numberable_type` = "PhoneBookEntry" \
JOIN `phone_books` `c` ON `b`.`phone_book_id` = `c`.`id` \
LEFT JOIN `ringtones` `d` ON `a`.`id` = `d`.`ringtoneable_id` AND `d`.`ringtoneable_type` = "PhoneNumber" \
WHERE ((`c`.`phone_bookable_type` = "User" AND `c`.`phone_bookable_id` = ' .. user_id .. ') \
OR (`c`.`phone_bookable_type` = "Tenant" AND `c`.`phone_bookable_id` = ' .. tenant_id .. ')) \
AND `a`.`number` IN (' .. numbers_sql .. ') \
AND `a`.`state` = "active" \
AND `b`.`state` = "active" \
AND `c`.`state` = "active"';
if name then
sql_query = sql_query ..' AND `a`.`name` = ' .. self.database:escape(name, '"');
end
sql_query = sql_query ..' ORDER BY `c`.`phone_bookable_type` DESC LIMIT 1';
local phone_book_entry = nil;
self.database:query(sql_query, function(entry)
phone_book_entry = entry;
if entry.number_name then
phone_book_entry.caller_id_name = tostring(entry.value_of_to_s) .. ' (' .. entry.number_name .. ')';
else
phone_book_entry.caller_id_name = entry.value_of_to_s;
end
end)
return phone_book_entry;
end
function PhoneBook.numbers(self, phone_book_entry_id, name, not_name)
local sql_query = 'SELECT * FROM `phone_numbers` \
WHERE `phone_numberable_id` = ' .. phone_book_entry_id .. ' AND `phone_numberable_type` = "PhoneBookEntry"';
if name then
sql_query = sql_query ..' AND `name` = ' .. self.database:escape(name, '"');
end
if not_name then
sql_query = sql_query ..' AND `name` != ' .. self.database:escape(not_name, '"');
end
return self.database:query_return_all(sql_query);
end
|
