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

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