diff options
| author | Ted Trask <ttrask01@yahoo.com> | 2013-10-07 20:42:08 +0000 |
|---|---|---|
| committer | Ted Trask <ttrask01@yahoo.com> | 2013-10-07 20:42:08 +0000 |
| commit | e0050d0a99074975602ecc4f953207aafb759625 (patch) | |
| tree | 1a0555ef3cbab54582afbc5cca931769a3e28f65 | |
| parent | 2c688f165d2f55dfb1f3f4f390d9b56b6d499e99 (diff) | |
| download | acf-provisioning-e0050d0a99074975602ecc4f953207aafb759625.tar.bz2 acf-provisioning-e0050d0a99074975602ecc4f953207aafb759625.tar.xz | |
Move local function
| -rw-r--r-- | provisioning-model.lua | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/provisioning-model.lua b/provisioning-model.lua index 8cf21ab..6e91b6f 100644 --- a/provisioning-model.lua +++ b/provisioning-model.lua @@ -251,6 +251,15 @@ duplicatestructure = function(value, saved) end end +local checkgroupdefaultoverride = function(device_id) + sql = "SELECT p.param_id ".. + "FROM (devices_to_classes d2t JOIN provisioning_classes t USING(class_id) JOIN classes_to_param_groups t2g USING (class_id) JOIN provisioning_groups g USING(group_id) ".. + "JOIN param_groups_to_params g2p USING(group_id) JOIN provisioning_params p USING(param_id) JOIN provisioning_values v USING(param_id))".. + "WHERE d2t.device_id='"..provdb.escape(device_id).."' AND v.value IS NOT NULL AND g2p.value IS NOT NULL AND v.value!=g2p.value" + local tmp = getselectresponse(sql) + return (#tmp ~= 0) +end + -- ################################################################################ -- PUBLIC FUNCTIONS @@ -1371,15 +1380,6 @@ get_all_device_params = function(self, clientdata, action) return get_device_params(self, clientdata.device_id, false) end -local checkgroupdefaultoverride = function(device_id) - sql = "SELECT p.param_id ".. - "FROM (devices_to_classes d2t JOIN provisioning_classes t USING(class_id) JOIN classes_to_param_groups t2g USING (class_id) JOIN provisioning_groups g USING(group_id) ".. - "JOIN param_groups_to_params g2p USING(group_id) JOIN provisioning_params p USING(param_id) JOIN provisioning_values v USING(param_id))".. - "WHERE d2t.device_id='"..provdb.escape(device_id).."' AND v.value IS NOT NULL AND g2p.value IS NOT NULL AND v.value!=g2p.value" - local tmp = getselectresponse(sql) - return (#tmp ~= 0) -end - -- This function is used by scripts, do not change prototype get_device_params = function(self, device_id, editable) local retval = {} |