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

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