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