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
|
-- CommonModule: AccessAuthorization
--
module(...,package.seeall)
AccessAuthorization = {}
-- Create AccessAuthorization object
function AccessAuthorization.new(self, arg)
arg = arg or {}
object = arg.object or {}
setmetatable(object, self)
self.__index = self
self.log = arg.log
self.database = arg.database
self.record = arg.record
self.session = arg.session
return object
end
-- Find AccessAuthorization by ID
function AccessAuthorization.find_by_id(self, id)
local sql_query = string.format("SELECT * FROM `access_authorizations` WHERE `id`=%d LIMIT 1", id)
local record = nil
self.database:query(sql_query, function(access_authorization_entry)
record = access_authorization_entry
end)
if record then
access_authorization = AccessAuthorization:new(self)
access_authorization.record = record
return access_authorization
end
return nil
end
-- list accessauthorization by owner
function AccessAuthorization.list_by_owner(self, owner_id, owner_type)
local sql_query = 'SELECT `a`.`id`, `a`.`name`, `a`.`login`, `a`.`pin`, `a`.`sip_account_id`, `b`.`number` AS `phone_number` \
FROM `access_authorizations` `a` \
LEFT JOIN `phone_numbers` `b` ON `b`.`phone_numberable_id` = `a`.`id` AND `b`.`phone_numberable_type` = "AccessAuthorization" \
WHERE `a`.`access_authorizationable_type` = "' .. owner_type .. '" AND `access_authorizationable_id`= ' .. tonumber(owner_id);
local access_authorizations = {}
self.database:query(sql_query, function(access_authorization_entry)
table.insert(access_authorizations, access_authorization_entry);
end);
return access_authorizations;
end
|
