You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
52 lines
1.9 KiB
52 lines
1.9 KiB
--
|
|
-- Copyright 2014-2020 SipWise Team <development@sipwise.com>
|
|
--
|
|
-- This program is free software: you can redistribute it and/or modify
|
|
-- it under the terms of the GNU General Public License as published by
|
|
-- the Free Software Foundation, either version 3 of the License, or
|
|
-- (at your option) any later version.
|
|
--
|
|
-- This package is distributed in the hope that it will be useful,
|
|
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
-- GNU General Public License for more details.
|
|
--
|
|
-- You should have received a copy of the GNU General Public License
|
|
-- along with this program. If not, see <http://www.gnu.org/licenses/>.
|
|
-- .
|
|
-- On Debian systems, the complete text of the GNU General
|
|
-- Public License version 3 can be found in "/usr/share/common-licenses/GPL-3".
|
|
--
|
|
local NGCPPrefs = require 'ngcp.pref'
|
|
local utils = require 'ngcp.utils'
|
|
|
|
-- class NGCPProfilePrefs
|
|
local NGCPProfilePrefs = utils.inheritsFrom(NGCPPrefs)
|
|
NGCPProfilePrefs.__class__ = 'NGCPProfilePrefs'
|
|
NGCPProfilePrefs.group = "prof_prefs"
|
|
NGCPProfilePrefs.db_table = "prof_preferences"
|
|
NGCPProfilePrefs.query = "SELECT prefs.* FROM provisioning.voip_subscribers "..
|
|
"as usr LEFT JOIN %s AS prefs ON usr.profile_id = prefs.uuid "..
|
|
"WHERE usr.uuid = '%s'"
|
|
NGCPProfilePrefs.group_query = [[
|
|
SELECT prefs.*
|
|
FROM provisioning.voip_subscribers AS usr
|
|
LEFT JOIN %s AS prefs
|
|
ON usr.profile_id = prefs.uuid
|
|
JOIN provisioning.voip_preferences AS vp
|
|
ON vp.attribute = prefs.attribute
|
|
JOIN provisioning.voip_preference_groups AS vpg
|
|
ON vpg.id = vp.voip_preference_groups_id
|
|
WHERE usr.uuid = '%s' AND vpg.id = %s
|
|
]]
|
|
-- luacheck: globals KSR
|
|
function NGCPProfilePrefs:new(config)
|
|
local instance = NGCPProfilePrefs:create()
|
|
-- creates xavp usr
|
|
instance:init(config)
|
|
return instance
|
|
end
|
|
|
|
-- class
|
|
return NGCPProfilePrefs
|