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

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