addons/web/static/src/js/data_export.js

   1 openerp.web.data_export = function(openerp) {
   2 var QWeb = openerp.web.qweb,
   3       _t = openerp.web._t;
   4 openerp.web.DataExport = openerp.web.Dialog.extend({
   5     template: 'ExportTreeView',
   6     dialog_title: {toString: function () { return _t("Export Data"); }},
   7     init: function(parent, dataset) {
   8         this._super(parent);
   9         this.records = {};
  10         this.dataset = dataset;
  11         this.exports = new openerp.web.DataSetSearch(
  12             this, 'ir.exports', this.dataset.get_context());
  13     },
  14     start: function() {
  15         var self = this;
  16         this._super.apply(this, arguments);
  17         this.open({
  18             modal: true,
  19             width: '55%',
  20             height: 'auto',
  21             position: 'top',
  22             buttons : [
  23                 {text: _t("Close"), click: function() { self.close(); }},
  24                 {text: _t("Export To File"), click: function() { self.on_click_export_data(); }}
  25             ],
  26             close: function(event, ui){ self.close();}
  27         });
  28         self.$element.removeClass('ui-dialog-content ui-widget-content');
  29         self.$element.find('#add_field').click(function() {
  30             if ($('#field-tree-structure tr.ui-selected')) {
  31                 var fld = self.$element.find('#field-tree-structure tr.ui-selected').find('a');
  32                 for (var i = 0; i < fld.length; i++) {
  33                     var id = $(fld[i]).attr('id').split('-')[1];
  34                     var string = $(fld[i]).attr('string');
  35                     self.add_field(id, string);
  36                 }
  37                 self.$element.find('#field-tree-structure tr').removeClass('ui-selected');
  38             }
  39         });
  40         self.$element.find('#remove_field').click(function() {
  41             self.$element.find('#fields_list option:selected').remove();
  42         });
  43         self.$element.find('#remove_all_field').click(function() {
  44             self.$element.find('#fields_list').empty();
  45         });
  46         this.$element.find('#export_new_list').click(this.on_show_save_list);
  47
  48         var got_fields = new $.Deferred();
  49         this.$element.find('#import_compat').change(function() {
  50             self.$element.find('#fields_list').empty();
  51             self.$element.find('#field-tree-structure').remove();
  52             var import_comp = self.$element.find("#import_compat").val();
  53             self.rpc("/web/export/get_fields", {
  54                 model: self.dataset.model,
  55                 import_compat: Boolean(import_comp)
  56             }, function (records) {
  57                 got_fields.resolve();
  58                 self.on_show_data(records);
  59             });
  60         }).change();
  61
  62         return $.when(
  63             got_fields,
  64             this.rpc('/web/export/formats', {}, this.do_setup_export_formats),
  65             this.show_exports_list());
  66     },
  67     do_setup_export_formats: function (formats) {
  68         var $fmts = this.$element.find('#export_format');
  69         _(formats).each(function (format) {
  70             $fmts.append(new Option(format[1], format[0]));
  71         });
  72     },
  73     show_exports_list: function() {
  74         var self = this;
  75         if (self.$element.find('#saved_export_list').is(':hidden')) {
  76             self.$element.find('#ExistsExportList').show();
  77             return;
  78         }
  79         return this.exports.read_slice(['name'], {
  80             domain: [['resource', '=', this.dataset.model]]
  81         }, function (export_list) {
  82             if (!export_list.length) {
  83                 return;
  84             }
  85             self.$element.find('#ExistsExportList').append(QWeb.render('Exists.ExportList', {'existing_exports': export_list}));
  86             self.$element.find('#saved_export_list').change(function() {
  87                 self.$element.find('#fields_list option').remove();
  88                 var export_id = self.$element.find('#saved_export_list option:selected').val();
  89                 if (export_id) {
  90                     self.rpc('/web/export/namelist', {'model': self.dataset.model, export_id: parseInt(export_id)}, self.do_load_export_field);
  91                 }
  92             });
  93             self.$element.find('#delete_export_list').click(function() {
  94                 var select_exp = self.$element.find('#saved_export_list option:selected');
  95                 if (select_exp.val()) {
  96                     self.exports.unlink([parseInt(select_exp.val(), 10)]);
  97                     select_exp.remove();
  98                     if (self.$element.find('#saved_export_list option').length <= 1) {
  99                         self.$element.find('#ExistsExportList').hide();
 100                     }
 101                 }
 102             });
 103         });
 104     },
 105     do_load_export_field: function(field_list) {
 106         var export_node = this.$element.find("#fields_list");
 107         _(field_list).each(function (field) {
 108             export_node.append(new Option(field.label, field.name));
 109         });
 110     },
 111     on_show_save_list: function() {
 112         var self = this;
 113         var current_node = self.$element.find("#savenewlist");
 114         if (!(current_node.find("label")).length) {
 115             current_node.append(QWeb.render('ExportNewList'));
 116             current_node.find("#add_export_list").click(function() {
 117                 var value = current_node.find("#savelist_name").val();
 118                 if (value) {
 119                     self.do_save_export_list(value);
 120                 } else {
 121                     alert("Pleae Enter Save Field List Name");
 122                 }
 123             });
 124         } else {
 125             if (current_node.is(':hidden')) {
 126                 current_node.show();
 127                 current_node.find("#savelist_name").val("");
 128             } else {
 129                current_node.hide();
 130             }
 131         }
 132     },
 133     do_save_export_list: function(value) {
 134         var self = this;
 135         var fields = self.get_fields();
 136         if (!fields.length) {
 137             return;
 138         }
 139         this.exports.create({
 140             name: value,
 141             resource: this.dataset.model,
 142             export_fields: _(fields).map(function (field) {
 143                 return [0, 0, {name: field}];
 144             })
 145         }, function (export_list_id) {
 146             if (!export_list_id.result) {
 147                 return;
 148             }
 149             self.$element.find("#saved_export_list").append(
 150                     new Option(value, export_list_id.result));
 151             if (self.$element.find("#saved_export_list").is(":hidden")) {
 152                 self.show_exports_list();
 153             }
 154         });
 155         this.on_show_save_list();
 156         this.$element.find("#fields_list option").remove();
 157     },
 158     on_click: function(id, record) {
 159         var self = this;
 160         if (!record['children']) {
 161             return;
 162         }
 163         var model = record['params']['model'],
 164             prefix = record['params']['prefix'],
 165             name = record['params']['name'],
 166             exclude_fields = [];
 167         if (record['relation_field']) {
 168             exclude_fields.push(record['relation_field']);
 169         }
 170
 171         if (!record.loaded) {
 172             var import_comp = self.$element.find("#import_compat").val();
 173             self.rpc("/web/export/get_fields", {
 174                 model: model,
 175                 prefix: prefix,
 176                 parent_name: name,
 177                 import_compat: Boolean(import_comp),
 178                 parent_field_type : record['field_type'],
 179                 exclude: exclude_fields
 180             }, function(results) {
 181                 record.loaded = true;
 182                 self.on_show_data(results, record.id);
 183             });
 184         } else {
 185             self.showcontent(record.id);
 186         }
 187     },
 188     on_show_data: function(result, after) {
 189         var self = this;
 190         var imp_cmpt = Boolean(self.$element.find("#import_compat").val());
 191
 192         if (after) {
 193             var current_tr = self.$element.find("tr[id='treerow-" + after + "']");
 194             current_tr.addClass('open');
 195             current_tr.find('img').attr('src','/web/static/src/img/collapse.gif');
 196             current_tr.after(QWeb.render('ExportTreeView-Secondary.children', {'fields': result}));
 197         } else {
 198             self.$element.find('#left_field_panel').append(QWeb.render('ExportTreeView-Secondary', {'fields': result}));
 199         }
 200         _.each(result, function(record) {
 201             self.records[record.id] = record.value;
 202             if (record.required) {
 203                 var required_fld = self.$element.find("tr[id='treerow-" + record.id + "']").find('#tree-column');
 204                 required_fld.addClass("oe_export_requiredfield");
 205             }
 206             self.$element.find("img[id='parentimg-" + record.id +"']").click(function() {
 207                 self.on_click(this.id, record);
 208             });
 209
 210             self.$element.find("tr[id='treerow-" + record.id + "']").click(function(e) {
 211                 if (e.shiftKey) {
 212                     var frst_click, scnd_click = '';
 213                     if (self.row_index == 0) {
 214                         self.row_index = this.rowIndex;
 215                         frst_click = self.$element.find("tr[id^='treerow-']")[self.row_index-1];
 216                         $(frst_click).addClass("ui-selected");
 217                     } else {
 218                         if (this.rowIndex >=self.row_index) {
 219                             for (var i = (self.row_index-1); i < this.rowIndex; i++) {
 220                                 scnd_click = self.$element.find("tr[id^='treerow-']")[i];
 221                                 if (!$(scnd_click).find('#tree-column').hasClass("oe_export_readonlyfield")) {
 222                                     $(scnd_click).addClass("ui-selected");
 223                                 }
 224                             }
 225                         } else {
 226                             for (var i = (self.row_index-1); i >= (this.rowIndex-1); i--) {
 227                                 scnd_click = self.$element.find("tr[id^='treerow-']")[i];
 228                                 if (!$(scnd_click).find('#tree-column').hasClass("oe_export_readonlyfield")) {
 229                                     $(scnd_click).addClass("ui-selected");
 230                                 }
 231                             }
 232                         }
 233                     }
 234                 }
 235                 self.row_index = this.rowIndex;
 236
 237                 self.$element.find("tr[id='treerow-" + record.id + "']").keyup(function() {
 238                     self.row_index = 0;
 239                 });
 240                 var o2m_selection = self.$element.find("tr[id='treerow-" + record.id + "']").find('#tree-column');
 241                 if ($(o2m_selection).hasClass("oe_export_readonlyfield")) {
 242                     return false;
 243                 }
 244                 if (e.ctrlKey) {
 245                     if ($(this).hasClass('ui-selected')) {
 246                         $(this).removeClass('ui-selected').find('a').blur();
 247                     } else {
 248                         $(this).addClass('ui-selected').find('a').focus();
 249                     }
 250                 } else if (!e.shiftKey) {
 251                     self.$element.find("tr.ui-selected")
 252                             .removeClass("ui-selected").find('a').blur();
 253                     $(this).addClass("ui-selected").find('a').focus();
 254                 }
 255                 return false;
 256             });
 257
 258             self.$element.find("tr[id='treerow-" + record.id + "']").keydown(function(e) {
 259                 var keyCode = e.keyCode || e.which;
 260                 var arrow = {left: 37, up: 38, right: 39, down: 40 };
 261                 switch (keyCode) {
 262                     case arrow.left:
 263                         if ($(this).hasClass('open')) {
 264                             self.on_click(this.id, record);
 265                         }
 266                         break;
 267                     case arrow.right:
 268                         if (!$(this).hasClass('open')) {
 269                             self.on_click(this.id, record);
 270                         }
 271                         break;
 272                     case arrow.up:
 273                         var elem = this;
 274                         $(elem).removeClass("ui-selected");
 275                         while (!$(elem).prev().is(":visible")) {
 276                             elem = $(elem).prev();
 277                         }
 278                         if (!$(elem).prev().find('#tree-column').hasClass("oe_export_readonlyfield")) {
 279                             $(elem).prev().addClass("ui-selected");
 280                         }
 281                         $(elem).prev().find('a').focus();
 282                         break;
 283                     case arrow.down:
 284                         var elem = this;
 285                         $(elem).removeClass("ui-selected");
 286                         while(!$(elem).next().is(":visible")) {
 287                             elem = $(elem).next();
 288                         }
 289                         if (!$(elem).next().find('#tree-column').hasClass("oe_export_readonlyfield")) {
 290                             $(elem).next().addClass("ui-selected");
 291                         }
 292                         $(elem).next().find('a').focus();
 293                         break;
 294                 }
 295             });
 296             self.$element.find("tr[id='treerow-" + record.id + "']").dblclick(function() {
 297                 var $o2m_selection = self.$element.find("tr[id^='treerow-" + record.id + "']").find('#tree-column');
 298                 if (!$o2m_selection.hasClass("oe_export_readonlyfield")) {
 299                    self.add_field(record.id, $(this).find("a").attr("string"));
 300                 }
 301             });
 302         });
 303         self.$element.find('#fields_list').mouseover(function(event) {
 304             if (event.relatedTarget) {
 305                 if (event.relatedTarget.attributes['id'] && event.relatedTarget.attributes['string']) {
 306                     var field_id = event.relatedTarget.attributes["id"]["value"];
 307                     if (field_id && field_id.split("-")[0] === 'export') {
 308                         if (!self.$element.find("tr[id='treerow-" + field_id.split("-")[1] + "']").find('#tree-column').hasClass("oe_export_readonlyfield")) {
 309                             self.add_field(field_id.split("-")[1], event.relatedTarget.attributes["string"]["value"]);
 310                         }
 311                     }
 312                 }
 313             }
 314         });
 315     },
 316     showcontent: function(id) {
 317         // show & hide the contents
 318         var $this = this.$element.find("tr[id='treerow-" + id + "']");
 319         var is_open = $this.hasClass('open');
 320         $this.toggleClass('open');
 321
 322         var first_child = $this.find('img');
 323         if (is_open) {
 324             first_child.attr('src', '/web/static/src/img/expand.gif');
 325         } else {
 326             first_child.attr('src', '/web/static/src/img/collapse.gif');
 327         }
 328         var child_field = this.$element.find("tr[id^='treerow-" + id +"/']");
 329         var child_len = (id.split("/")).length + 1;
 330         for (var i = 0; i < child_field.length; i++) {
 331             var $child = $(child_field[i]);
 332             if (is_open) {
 333                 $child.hide();
 334             } else if (child_len == (child_field[i].id.split("/")).length) {
 335                 if ($child.hasClass('open')) {
 336                     $child.removeClass('open');
 337                     $child.find('img').attr('src', '/web/static/src/img/expand.gif');
 338                 }
 339                 $child.show();
 340             }
 341         }
 342     },
 343     add_field: function(field_id, string) {
 344         var field_list = this.$element.find('#fields_list');
 345         if (this.$element.find("#fields_list option[value='" + field_id + "']")
 346                 && !this.$element.find("#fields_list option[value='" + field_id + "']").length) {
 347             field_list.append(new Option(string, field_id));
 348         }
 349     },
 350     get_fields: function() {
 351         var export_field = [];
 352         this.$element.find("#fields_list option").each(function() {
 353             export_field.push($(this).val());
 354         });
 355         if (!export_field.length) {
 356             alert('Please select fields to save export list...');
 357         }
 358         return export_field;
 359     },
 360     on_click_export_data: function() {
 361         $.blockUI(this.$element);
 362         var exported_fields = [], self = this;
 363         this.$element.find("#fields_list option").each(function() {
 364             var fieldname = self.records[$(this).val()];
 365             exported_fields.push({name: fieldname, label: $(this).text()});
 366         });
 367         if (_.isEmpty(exported_fields)) {
 368             alert('Please select fields to export...');
 369             return;
 370         }
 371
 372         exported_fields.unshift({name: 'id', label: 'External ID'});
 373         var export_format = this.$element.find("#export_format").val();
 374         this.session.get_file({
 375             url: '/web/export/' + export_format,
 376             data: {data: JSON.stringify({
 377                 model: this.dataset.model,
 378                 fields: exported_fields,
 379                 ids: this.dataset.ids,
 380                 domain: this.dataset.domain,
 381                 import_compat: Boolean(
 382                         this.$element.find("#import_compat").val())
 383             })},
 384             complete: $.unblockUI
 385         });
 386     },
 387     close: function() {
 388         $(this.$dialog).remove();
 389         this._super();
 390     }
 391 });
 392
 393 };