ColumnsEditor: based on query_editor plugin, simplified, without autocomplete filters

[myslice.git] / plugins / columns_editor / __init__.py

diff --git a/plugins/columns_editor/__init__.py b/plugins/columns_editor/__init__.py
new file mode 100644 (file)
index 0000000..3cc48a9
--- /dev/null
+++ b/plugins/columns_editor/__init__.py
@@ -0,0 +1,91 @@
+from unfold.plugin import Plugin
+
+from django.template.loader import render_to_string
+
+# XXX We need naming helpers in the python Plugin class also, used in template
+
+class ColumnsEditor(Plugin):
+    def __init__ (self, query, query_all = None, **settings):
+        Plugin.__init__ (self, **settings)
+        self.query=query
+        self.query_uuid = query.query_uuid
+        self.query_all = query_all
+        self.query_all_uuid = query_all.query_uuid if query_all else None
+
+    def template_file(self):
+        return "columns_editor.html"
+
+    def requirements (self):
+        reqs = {
+            'js_files' : [
+                # XXX datatables
+                'js/columns_editor.js',
+            ] ,
+            'css_files': [
+                'css/query_editor.css',
+                'css/jquery-ui.css',
+            ]
+        }
+        return reqs
+
+    def export_json_settings (self):
+        return True
+
+    def template_env(self, request):
+        fields = []
+        #hidden_columns = self.hidden_columns
+        metadata = self.page.get_metadata()
+        md_fields = metadata.details_by_object('resource')
+
+        # XXX use django templating system here
+        for md_field in md_fields['column']:
+            if md_field['type'] == 'string':
+                if 'allowed_values' in md_field:
+                    allowed_values = md_field['allowed_values'].split(',')
+
+                    options = []
+                    for v in allowed_values:
+                        v_desc = v.split('-')
+                        options.append(v_desc[0])
+
+                    env = {
+                        'domid': self.domid,
+                        'options': options
+                    }
+                    filter_input = render_to_string('filter_input_string_values.html', env)
+                else:
+                    env = {
+                        'domid': self.domid,
+                        'field': md_field['name']
+                    }
+                    filter_input = render_to_string('filter_input_string.html', env)
+                    
+            elif md_field['type'] == 'int':
+                allowed_values = md_field.get('allowed_values', '0,0').split(',')
+                env = {
+                    'domid': self.domid,
+                    'field': md_field['name'],
+                    'min'  : allowed_values[0],
+                    'max'  : allowed_values[1]
+                }
+                filter_input = render_to_string('filter_input_integer.html', env)
+            else:
+                env = {
+                    'domid': self.domid,
+                    'field': md_field['name']
+                }
+                filter_input = render_to_string('filter_input_others.html', env)
+
+            fields.append({
+                'name':          md_field['name'],
+                'type':          md_field['type'],
+                'resource_type': 'N/A',
+                'filter_input':  filter_input,
+                'header':        None,
+                'checked':       md_field['name'] in self.query.get_select()
+            })
+        #return { 'fields': fields, 'hidden_columns': hidden_columns }
+        #return { 'fields': fields , 'query_uuid': self.query_uuid, 'query_all_uuid': self.query_all_uuid }
+        return { 'fields': fields }
+
+    def json_settings_list (self): return ['plugin_uuid', 'domid', 'query_uuid', 'query_all_uuid', ]