summaryrefslogtreecommitdiff
path: root/misc/freeswitch/scripts/dialplan/phone_book.lua
diff options
context:
space:
mode:
Diffstat (limited to 'misc/freeswitch/scripts/dialplan/phone_book.lua')
-rw-r--r--misc/freeswitch/scripts/dialplan/phone_book.lua63
1 files changed, 63 insertions, 0 deletions
diff --git a/misc/freeswitch/scripts/dialplan/phone_book.lua b/misc/freeswitch/scripts/dialplan/phone_book.lua
new file mode 100644
index 0000000..089f115
--- /dev/null
+++ b/misc/freeswitch/scripts/dialplan/phone_book.lua
@@ -0,0 +1,63 @@
+-- Gemeinschaft 5 module: phone book class
+-- (c) AMOOMA GmbH 2012
+--
+
+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)
+ 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" \
+ 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