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