From 3751379f1e9a4c215fb6eb898b4ccc67659b9ace Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 10 May 2022 21:51:50 +0700 Subject: initial commit 2 --- addons/base_import/static/src/js/import_action.js | 927 +++++++++++++++++++++ addons/base_import/static/src/js/import_menu.js | 63 ++ .../base_import/static/src/scss/base_import.scss | 164 ++++ addons/base_import/static/src/xml/base_import.xml | 227 +++++ 4 files changed, 1381 insertions(+) create mode 100644 addons/base_import/static/src/js/import_action.js create mode 100644 addons/base_import/static/src/js/import_menu.js create mode 100644 addons/base_import/static/src/scss/base_import.scss create mode 100644 addons/base_import/static/src/xml/base_import.xml (limited to 'addons/base_import/static/src') diff --git a/addons/base_import/static/src/js/import_action.js b/addons/base_import/static/src/js/import_action.js new file mode 100644 index 00000000..0b608953 --- /dev/null +++ b/addons/base_import/static/src/js/import_action.js @@ -0,0 +1,927 @@ +odoo.define('base_import.import', function (require) { +"use strict"; + +var AbstractAction = require('web.AbstractAction'); +var config = require('web.config'); +var core = require('web.core'); +var session = require('web.session'); +var time = require('web.time'); +var AbstractWebClient = require('web.AbstractWebClient'); +var Loading = require('web.Loading'); + +var QWeb = core.qweb; +var _t = core._t; +var _lt = core._lt; +var StateMachine = window.StateMachine; + +/** + * Safari does not deal well at all with raw JSON data being + * returned. As a result, we're going to cheat by using a + * pseudo-jsonp: instead of getting JSON data in the iframe, we're + * getting a ``script`` tag which consists of a function call and + * the returned data (the json dump). + * + * The function is an auto-generated name bound to ``window``, + * which calls back into the callback provided here. + * + * @param {Object} form the form element (DOM or jQuery) to use in the call + * @param {Object} attributes jquery.form attributes object + * @param {Function} callback function to call with the returned data + */ +function jsonp(form, attributes, callback) { + attributes = attributes || {}; + var options = {jsonp: _.uniqueId('import_callback_')}; + window[options.jsonp] = function () { + delete window[options.jsonp]; + callback.apply(null, arguments); + }; + if ('data' in attributes) { + _.extend(attributes.data, options); + } else { + _.extend(attributes, {data: options}); + } + _.extend(attributes, { + dataType: 'script', + }); + $(form).ajaxSubmit(attributes); +} +function _make_option(term) { return {id: term, text: term }; } +function _from_data(data, term) { + return _.findWhere(data, {id: term}) || _make_option(term); +} + +/** + * query returns a list of suggestion select2 objects, this function: + * + * * returns data exactly matching query by either id or text if those exist + * * otherwise it returns a select2 option matching the term and any data + * option whose id or text matches (by substring) + */ +function dataFilteredQuery(q) { + var suggestions = _.clone(this.data); + if (q.term) { + var exact = _.filter(suggestions, function (s) { + return s.id === q.term || s.text === q.term; + }); + if (exact.length) { + suggestions = exact; + } else { + suggestions = [_make_option(q.term)].concat(_.filter(suggestions, function (s) { + return s.id.indexOf(q.term) !== -1 || s.text.indexOf(q.term) !== -1 + })); + } + } + q.callback({results: suggestions}); +} + +var DataImport = AbstractAction.extend({ + hasControlPanel: true, + contentTemplate: 'ImportView', + opts: [ + {name: 'encoding', label: _lt("Encoding:"), value: ''}, + {name: 'separator', label: _lt("Separator:"), value: ''}, + {name: 'quoting', label: _lt("Text Delimiter:"), value: '"'} + ], + spreadsheet_opts: [ + {name: 'sheet', label: _lt("Selected Sheet:"), value: ''}, + ], + parse_opts_formats: [ + {name: 'date_format', label: _lt("Date Format:"), value: ''}, + {name: 'datetime_format', label: _lt("Datetime Format:"), value: ''}, + ], + parse_opts_separators: [ + {name: 'float_thousand_separator', label: _lt("Thousands Separator:"), value: ','}, + {name: 'float_decimal_separator', label: _lt("Decimal Separator:"), value: '.'} + ], + events: { + // 'change .oe_import_grid input': 'import_dryrun', + 'change .oe_import_file': 'loaded_file', + 'change input.oe_import_has_header, .js_import_options input': 'settings_changed', + 'change input.oe_import_advanced_mode': function (e) { + this.do_not_change_match = true; + this['settings_changed'](); + }, + 'click a.oe_import_toggle': function (e) { + e.preventDefault(); + this.$('.oe_import_options').toggle(); + }, + 'click .oe_import_report a.oe_import_report_count': function (e) { + e.preventDefault(); + $(e.target).parent().parent().toggleClass('oe_import_report_showmore'); + }, + 'click .oe_import_report_see_possible_value': function (e) { + e.preventDefault(); + $(e.target).parent().toggleClass('oe_import_report_showmore'); + }, + 'click .oe_import_moreinfo_action a': function (e) { + e.preventDefault(); + // #data will parse the attribute on its own, we don't like + // that sort of things + var action = JSON.parse($(e.target).attr('data-action')); + // FIXME: when JS-side clean_action + action.views = _(action.views).map(function (view) { + var id = view[0], type = view[1]; + return [ + id, + type !== 'tree' ? type + : action.view_type === 'form' ? 'list' + : 'tree' + ]; + }); + this.do_action(_.extend(action, { + target: 'new', + flags: { + search_view: true, + display_title: true, + pager: true, + list: {selectable: false} + } + })); + }, + }, + init: function (parent, action) { + this._super.apply(this, arguments); + this.action_manager = parent; + this.res_model = action.params.model; + this.parent_context = action.params.context || {}; + // import object id + this.id = null; + this.session = session; + this._title = _t('Import a File'); // Displayed in the breadcrumbs + this.do_not_change_match = false; + this.sheets = []; + }, + /** + * @override + */ + willStart: function () { + var self = this; + var def = this._rpc({ + model: this.res_model, + method: 'get_import_templates', + context: this.parent_context, + }).then(function (result) { + self.importTemplates = result; + }); + return Promise.all([this._super.apply(this, arguments), def]); + }, + start: function () { + var self = this; + this.$form = this.$('form'); + this.setup_encoding_picker(); + this.setup_separator_picker(); + this.setup_float_format_picker(); + this.setup_date_format_picker(); + this.setup_sheets_picker(); + + return Promise.all([ + this._super(), + self.create_model().then(function (id) { + self.id = id; + self.$('input[name=import_id]').val(id); + + self.renderButtons(); + var status = { + cp_content: {$buttons: self.$buttons}, + }; + self.updateControlPanel(status); + }), + ]); + }, + create_model: function() { + return this._rpc({ + model: 'base_import.import', + method: 'create', + args: [{res_model: this.res_model}], + kwargs: {context: session.user_context}, + }); + }, + renderButtons: function() { + var self = this; + this.$buttons = $(QWeb.render("ImportView.buttons", this)); + this.$buttons.filter('.o_import_validate').on('click', this.validate.bind(this)); + this.$buttons.filter('.o_import_import').on('click', this.import.bind(this)); + this.$buttons.filter('.oe_import_file').on('click', function () { + self.$('.o_content .oe_import_file').click(); + }); + this.$buttons.filter('.o_import_cancel').on('click', function(e) { + e.preventDefault(); + self.exit(); + }); + }, + setup_encoding_picker: function () { + this.$('input.oe_import_encoding').select2({ + width: '50%', + data: _.map(('utf-8 utf-16 windows-1252 latin1 latin2 big5 gb18030 shift_jis windows-1251 koir8_r').split(/\s+/), _make_option), + query: dataFilteredQuery, + initSelection: function ($e, c) { + return c(_make_option($e.val())); + } + }); + }, + setup_separator_picker: function () { + var data = [ + {id: ',', text: _t("Comma")}, + {id: ';', text: _t("Semicolon")}, + {id: '\t', text: _t("Tab")}, + {id: ' ', text: _t("Space")} + ]; + this.$('input.oe_import_separator').select2({ + width: '50%', + data: data, + query: dataFilteredQuery, + // this is not provided to initSelection so can't use this.data + initSelection: function ($e, c) { + c(_from_data(data, $e.val()) || _make_option($e.val())) + } + }); + }, + setup_float_format_picker: function () { + var data_decimal = [ + {id: ',', text: _t("Comma")}, + {id: '.', text: _t("Dot")}, + ]; + var data_digits = data_decimal.concat([{id: '', text: _t("No Separator")}]); + this.$('input.oe_import_float_thousand_separator').select2({ + width: '50%', + data: data_digits, + query: dataFilteredQuery, + initSelection: function ($e, c) { + c(_from_data(data_digits, $e.val()) || _make_option($e.val())) + } + }); + this.$('input.oe_import_float_decimal_separator').select2({ + width: '50%', + data: data_decimal, + query: dataFilteredQuery, + initSelection: function ($e, c) { + c(_from_data(data_decimal, $e.val()) || _make_option($e.val())) + } + }); + }, + setup_date_format_picker: function () { + var data = _([ + 'YYYY-MM-DD', + 'DD/MM/YY', + 'DD/MM/YYYY', + 'DD-MM-YYYY', + 'DD-MMM-YY', + 'DD-MMM-YYYY', + 'MM/DD/YY', + 'MM/DD/YYYY', + 'MM-DD-YY', + 'MM-DD-YYYY', + 'DDMMYY', + 'DDMMYYYY', + 'YYMMDD', + 'YYYYMMDD', + 'YY/MM/DD', + 'YYYY/MM/DD', + 'MMDDYY', + 'MMDDYYYY', + ]).map(_make_option); + this.$('input.oe_import_date_format').select2({ + width: '50%', + data: data, + query: dataFilteredQuery, + initSelection: function ($e, c) { + c(_from_data(data, $e.val()) || _make_option($e.val())); + } + }) + }, + setup_sheets_picker: function () { + var data = this.sheets.map(_make_option); + this.$('input.oe_import_sheet').select2({ + width: '50%', + data: data, + query: dataFilteredQuery, + initSelection: function ($e, c) { + c(_from_data(data, $e.val()) || _make_option($e.val())) + }, + minimumResultsForSearch: 10, + }); + }, + + import_options: function () { + var self = this; + var options = { + headers: this.$('input.oe_import_has_header').prop('checked'), + advanced: this.$('input.oe_import_advanced_mode').prop('checked'), + keep_matches: this.do_not_change_match, + name_create_enabled_fields: {}, + // start at row 1 = skip 0 lines + skip: Number(this.$('#oe_import_row_start').val()) - 1 || 0, + limit: Number(this.$('#oe_import_batch_limit').val()) || null, + }; + _.each(_.union(this.opts, this.spreadsheet_opts), function (opt) { + options[opt.name] = + self.$('input.oe_import_' + opt.name).val(); + }); + _(this.parse_opts_formats).each(function (opt) { + options[opt.name] = time.moment_to_strftime_format(self.$('input.oe_import_' + opt.name).val()); + }); + _(this.parse_opts_separators).each(function (opt) { + options[opt.name] = self.$('input.oe_import_' + opt.name).val(); + }); + options['fields'] = []; + if (this.do_not_change_match) { + options['fields'] = this.$('.oe_import_fields input.oe_import_match_field').map(function (index, el) { + return $(el).select2('val') || false; + }).get(); + } + this.do_not_change_match = false; + this.$('input.o_import_create_option').each(function () { + var field = this.getAttribute('field'); + if (field) { + options.name_create_enabled_fields[field] = this.checked; + } + }); + return options; + }, + + //- File & settings change section + onfile_loaded: function (event, from, to, arg) { + // arg is null if reload -> don't reset partial import + if (arg != null ) { + this.toggle_partial(null); + } + + this.$buttons.filter('.o_import_import, .o_import_validate').addClass('d-none'); + if (!this.$('input.oe_import_file').val()) { return this['settings_changed'](); } + this.$('.oe_import_date_format').select2('val', ''); + this.$('.oe_import_datetime_format').val(''); + this.$('.oe_import_sheet').val(''); + + this.$form.removeClass('oe_import_preview oe_import_error'); + var import_toggle = false; + var file = this.$('input.oe_import_file')[0].files[0]; + // some platforms send text/csv, application/csv, or other things if Excel is prevent + if ((file.type && _.last(file.type.split('/')) === "csv") || ( _.last(file.name.split('.')) === "csv")) { + import_toggle = true; + } + this.$form.find('.oe_import_box').toggle(import_toggle); + jsonp(this.$form, { + url: '/base_import/set_file' + }, this.proxy('settings_changed')); + }, + onpreviewing: function () { + var self = this; + this.$buttons.filter('.o_import_import, .o_import_validate').addClass('d-none'); + this.$form.addClass('oe_import_with_file'); + // TODO: test that write // succeeded? + this.$form.removeClass('oe_import_preview_error oe_import_error'); + this.$form.toggleClass( + 'oe_import_noheaders text-muted', + !this.$('input.oe_import_has_header').prop('checked')); + + // Clear the input value to allow onchange to be triggered + // if the file is the same (for all browsers) + self.$('input.oe_import_file').val(''); + + this._rpc({ + model: 'base_import.import', + method: 'parse_preview', + args: [this.id, this.import_options()], + kwargs: {context: session.user_context}, + }).then(function (result) { + var signal = result.error ? 'preview_failed' : 'preview_succeeded'; + self[signal](result); + }); + }, + onpreview_error: function (event, from, to, result) { + this.$('.oe_import_options').show(); + this.$form.addClass('oe_import_preview_error oe_import_error'); + this.$form.find('.oe_import_box, .oe_import_with_file').removeClass('d-none'); + this.$form.find('.o_view_nocontent').addClass('d-none'); + this.$('.oe_import_error_report').html( + QWeb.render('ImportView.preview.error', result)); + }, + onpreview_success: function (event, from, to, result) { + var self = this; + this.$buttons.filter('.oe_import_file') + .text(_t('Load New File')) + .removeClass('btn-primary').addClass('btn-secondary') + .blur(); + this.$buttons.filter('.o_import_import, .o_import_validate').removeClass('d-none'); + this.$form.find('.oe_import_box, .oe_import_with_file').removeClass('d-none'); + this.$form.find('.o_view_nocontent').addClass('d-none'); + this.$form.addClass('oe_import_preview'); + this.$('input.oe_import_advanced_mode').prop('checked', result.advanced_mode); + this.$('.oe_import_grid').html(QWeb.render('ImportView.preview', result)); + + this.$('.o_import_batch_alert').toggleClass('d-none', !result.batch); + + var messages = []; + if (result.headers.length === 1) { + messages.push({type: 'warning', message: _t("A single column was found in the file, this often means the file separator is incorrect")}); + } + + if (!_.isEmpty(messages)) { + this.$('.oe_import_options').show(); + this.onresults(null, null, null, {'messages': messages}); + } + + if (!_.isEqual(this.sheets, result.options.sheets)) { + this.sheets = result.options.sheets || []; + this.setup_sheets_picker(); + } + this.$('div.oe_import_has_multiple_sheets').toggle( + this.sheets.length > 1 + ); + + // merge option values back in case they were updated/guessed + _.each(['encoding', 'separator', 'float_thousand_separator', 'float_decimal_separator', 'sheet'], function (id) { + self.$('.oe_import_' + id).select2('val', result.options[id]) + }); + this.$('.oe_import_date_format').select2('val', time.strftime_to_moment_format(result.options.date_format)); + this.$('.oe_import_datetime_format').val(time.strftime_to_moment_format(result.options.datetime_format)); + // hide all "true debug" options when not in debug mode + this.$('.oe_import_debug_option').toggleClass('d-none', !result.debug); + + var $fields = this.$('.oe_import_fields input'); + this.render_fields_matches(result, $fields); + var data = this.generate_fields_completion(result); + var item_finder = function (id, items) { + items = items || data; + for (var i=0; i < items.length; ++i) { + var item = items[i]; + if (item.id === id) { + return item; + } + var val; + if (item.children && (val = item_finder(id, item.children))) { + return val; + } + } + return ''; + }; + $fields.each(function (k,v) { + var filtered_data = self.generate_fields_completion(result, k); + + var $thing = $(); + var bind = function (d) {}; + if (config.isDebug()) { + $thing = $(QWeb.render('ImportView.create_record_option')).insertAfter(v).hide(); + bind = function (data) { + switch (data.type) { + case 'many2one': case 'many2many': + $thing.find('input').attr('field', data.id); + $thing.show(); + break; + default: + $thing.find('input').attr('field', '').prop('checked', false); + $thing.hide(); + } + } + } + + $(v).select2({ + allowClear: true, + minimumInputLength: 0, + data: filtered_data, + initSelection: function (element, callback) { + var default_value = element.val(); + if (!default_value) { + callback(''); + return; + } + + var data = item_finder(default_value); + bind(data); + callback(data); + }, + placeholder: _t('Don\'t import'), + width: 'resolve', + dropdownCssClass: 'oe_import_selector' + }).on('change', function (e) { + bind(item_finder(e.currentTarget.value)); + }); + }); + }, + generate_fields_completion: function (root, index) { + var self = this; + var basic = []; + var regulars = []; + var o2m = []; + var headers_type = root.headers_type; + function traverse(field, ancestors, collection, type) { + var subfields = field.fields; + var advanced_mode = self.$('input.oe_import_advanced_mode').prop('checked'); + var field_path = ancestors.concat(field); + var label = _(field_path).pluck('string').join(' / '); + var id = _(field_path).pluck('name').join('/'); + if (type === undefined || (type !== undefined && (type.indexOf('all') !== -1 || type.indexOf(field['type']) !== -1))){ + // If non-relational, m2o or m2m, collection is regulars + if (!collection) { + if (field.name === 'id') { + collection = basic; + } else if (_.isEmpty(subfields) + || _.isEqual(_.pluck(subfields, 'name'), ['id', '.id'])) { + collection = regulars; + } else { + collection = o2m; + } + } + + collection.push({ + id: id, + text: label, + required: field.required, + type: field.type + }); + + } + if (advanced_mode){ + for(var i=0, end=subfields.length; i} + * @private + */ + _batchedImport: function (opts, args, kwargs, rec) { + opts.callback && opts.callback(rec.done || 0); + var self = this; + return this._rpc({ + model: 'base_import.import', + method: 'do', + args: args.concat([opts]), + kwargs: kwargs + }).then(function (results) { + _.each(results.messages, offset_by(opts.skip)); + if (!kwargs.dryrun && !results.ids) { + // update skip to failed batch + self.$('#oe_import_row_start').val(opts.skip + 1); + if (opts.skip) { + // there's been an error during a "proper" import, stop & warn + // about partial import maybe + results.messages.push({ + type: 'info', + priority: true, + message: _.str.sprintf(_t("This file has been successfully imported up to line %d."), opts.skip) + }); + } + return results; + } + if (!results.nextrow) { + // we're done + return results; + } + + // do the next batch + return self._batchedImport( + // avoid modifying opts in-place + _.defaults({skip: results.nextrow}, opts), + args, kwargs, { + done: rec.done + (results.ids || []).length, + prev: results.nextrow + } + ).then(function (r2) { + return { + name: _.zip(results.name, r2.name).map(function (names) { + return names[0] || names[1]; + }), + ids: (results.ids || []).concat(r2.ids || []), + messages: results.messages.concat(r2.messages), + skip: r2.skip || results.nextrow, + nextrow: r2.nextrow + } + }); + }); + }, + onvalidate: function () { + var prom = this.call_import({ dryrun: true, tracking_disable: true }); + prom.then(this.proxy('validated')); + return prom; + }, + onimport: function () { + var self = this; + var prom = this.call_import({ dryrun: false }); + prom.then(function (results) { + var message = results.messages; + if (!_.any(message, function (message) { + return message.type === 'error'; })) { + self['import_succeeded'](results); + return; + } + self['import_failed'](results); + }); + return prom; + }, + onimported: function (event, from, to, results) { + this.do_notify(false, _.str.sprintf( + _t("%d records successfully imported"), + results.ids.length + )); + this.exit(); + }, + exit: function () { + this.trigger_up('history_back'); + }, + onresults: function (event, from, to, results) { + var fields = this.$('.oe_import_fields input.oe_import_match_field').map(function (index, el) { + return $(el).select2('val') || false; + }).get(); + + var message = results.messages; + var no_messages = _.isEmpty(message); + if (no_messages) { + message.push({ + type: 'info', + message: _t("Everything seems valid.") + }); + } else if (event === 'import_failed' && results.ids) { + // both ids in a failed import -> partial import + this.toggle_partial(results); + } + + // row indexes come back 0-indexed, spreadsheets + // display 1-indexed. + var offset = 1; + // offset more if header + if (this.import_options().headers) { offset += 1; } + + var messagesSorted = _.sortBy(_(message).groupBy('message'), function (group) { + if (group[0].priority){ + return -2; + } + + // sort by gravity, then, order of field in list + var order = 0; + switch (group[0].type) { + case 'error': order = 0; break; + case 'warning': order = fields.length + 1; break; + case 'info': order = 2 * (fields.length + 1); break; + default: order = 3 * (fields.length + 1); break; + } + return order + _.indexOf(fields, group[0].field); + }); + + this.$form.addClass('oe_import_error'); + this.$('.oe_import_error_report').html( + QWeb.render('ImportView.error', { + errors: messagesSorted, + at: function (rows) { + var from = rows.from + offset; + var to = rows.to + offset; + var rowName = ''; + if (results.name.length > rows.from && results.name[rows.from] !== '') { + rowName = _.str.sprintf(' (%s)', results.name[rows.from]); + } + if (from === to) { + return _.str.sprintf(_t("at row %d%s"), from, rowName); + } + return _.str.sprintf(_t("between rows %d and %d"), + from, to); + }, + at_multi: function (rows) { + var from = rows.from + offset; + var to = rows.to + offset; + var rowName = ''; + if (results.name.length > rows.from && results.name[rows.from] !== '') { + rowName = _.str.sprintf(' (%s)', results.name[rows.from]); + } + if (from === to) { + return _.str.sprintf(_t("Row %d%s"), from, rowName); + } + return _.str.sprintf(_t("Between rows %d and %d"), + from, to); + }, + at_multi_header: function (numberLines) { + return _.str.sprintf(_t("at %d different rows:"), + numberLines); + }, + more: function (n) { + return _.str.sprintf(_t("(%d more)"), n); + }, + info: function (msg) { + if (typeof msg === 'string') { + return _.str.sprintf( + '
%s
', + _.str.escapeHTML(msg)); + } + if (msg instanceof Array) { + return _.str.sprintf( + '
%s
    %s
', + _.str.escapeHTML(_t("See possible values")), + _(msg).map(function (msg) { + return '
  • ' + + _.str.escapeHTML(msg) + + '
    • '; + }).join('')); + } + // Final should be object, action descriptor + return [ + '
    ', + _.str.sprintf(' ', + _.str.escapeHTML(JSON.stringify(msg))), + _.str.escapeHTML( + _t("See possible values")), + '', + '
    ' + ].join(''); + }, + })); + }, + toggle_partial: function (result) { + var $form = this.$('.oe_import'); + var $partial_warning = this.$('.o_import_partial_alert'); + var $partial_count = this.$('.o_import_partial_count'); + if (result == null) { + $partial_warning.addClass('d-none'); + $form.add(this.$buttons).removeClass('o_import_partial_mode'); + var $skip = this.$('#oe_import_row_start'); + $skip.val($skip.attr('value')); + $partial_count.text(''); + return; + } + + this.$('.o_import_batch_alert').addClass('d-none'); + $partial_warning.removeClass('d-none'); + $form.add(this.$buttons).addClass('o_import_partial_mode'); + $partial_count.text((result.skip || 0) + 1); + } +}); +core.action_registry.add('import', DataImport); + +// FSM-ize DataImport +StateMachine.create({ + target: DataImport.prototype, + events: [ + { name: 'loaded_file', + from: ['none', 'file_loaded', 'preview_error', 'preview_success', 'results'], + to: 'file_loaded' }, + { name: 'settings_changed', + from: ['file_loaded', 'preview_error', 'preview_success', 'results'], + to: 'previewing' }, + { name: 'preview_failed', from: 'previewing', to: 'preview_error' }, + { name: 'preview_succeeded', from: 'previewing', to: 'preview_success' }, + { name: 'validate', from: 'preview_success', to: 'validating' }, + { name: 'validate', from: 'results', to: 'validating' }, + { name: 'validated', from: 'validating', to: 'results' }, + { name: 'import', from: ['preview_success', 'results'], to: 'importing' }, + { name: 'import_succeeded', from: 'importing', to: 'imported'}, + { name: 'import_failed', from: 'importing', to: 'results' } + ], +}); + +Loading.include({ + on_rpc_event: function () { + if (this.ignore_events) { + return + } + this._super.apply(this, arguments); + } +}); +AbstractWebClient.prototype.custom_events['with_client'] = function (ev) { + ev.data.callback.call(this); +}; + +function offset_by(by) { + return function offset_message(msg) { + if (msg.rows) { + msg.rows.from += by; + msg.rows.to += by; + } + } +} + +return { + DataImport: DataImport, +}; + +}); diff --git a/addons/base_import/static/src/js/import_menu.js b/addons/base_import/static/src/js/import_menu.js new file mode 100644 index 00000000..e5442fac --- /dev/null +++ b/addons/base_import/static/src/js/import_menu.js @@ -0,0 +1,63 @@ +odoo.define('base_import.ImportMenu', function (require) { + "use strict"; + + const DropdownMenuItem = require('web.DropdownMenuItem'); + const FavoriteMenu = require('web.FavoriteMenu'); + const { useModel } = require('web/static/src/js/model.js'); + + /** + * Import Records menu + * + * This component is used to import the records for particular model. + * + * @extends DropdownMenuItem + */ + class ImportMenu extends DropdownMenuItem { + constructor() { + super(...arguments); + this.model = useModel('searchModel'); + } + + //--------------------------------------------------------------------- + // Handlers + //--------------------------------------------------------------------- + + /** + * @private + */ + _onImportClick() { + const action = { + type: 'ir.actions.client', + tag: 'import', + params: { + model: this.model.config.modelName, + context: this.model.config.context, + } + }; + this.trigger('do-action', {action: action}); + } + + //--------------------------------------------------------------------- + // Static + //--------------------------------------------------------------------- + + /** + * @param {Object} env + * @returns {boolean} + */ + static shouldBeDisplayed(env) { + return env.view && + ['kanban', 'list'].includes(env.view.type) && + !env.device.isMobile && + !!JSON.parse(env.view.arch.attrs.import || '1') && + !!JSON.parse(env.view.arch.attrs.create || '1'); + } + } + + ImportMenu.props = {}; + ImportMenu.template = 'base_import.ImportMenu'; + + FavoriteMenu.registry.add('import-menu', ImportMenu, 1); + + return ImportMenu; +}); diff --git a/addons/base_import/static/src/scss/base_import.scss b/addons/base_import/static/src/scss/base_import.scss new file mode 100644 index 00000000..7e737a71 --- /dev/null +++ b/addons/base_import/static/src/scss/base_import.scss @@ -0,0 +1,164 @@ +.oe_import { + @include o-webclient-padding($top: 8px); + overflow: auto; + position: absolute; // Needed for chrome + top: 0; + right: 0; + bottom: 0; + left: 0; + @include media-breakpoint-down(sm) { + position: static; + } + + > p { + text-align: justify + } + h2 { + margin-top: 0.5em; + font-size: large; // override h2 font-size which is too large + } + .oe_padding { + padding: 13px 0; + } + + .oe_import_box { + padding: 8px; + background: #F0EEEE; + border-radius: $border-radius; + border: solid 1px #dddddd; + label { + font-weight: normal; + } + .oe_import_file { + display: inline-block; + } + } + + a.oe_import_toggle { + display: block; + &:before { + content: '+' + } + } + .oe_import_options { + margin-top: 8px; + p { + margin: 0; + } + label { + width: 48%; + line-height: 32px; + text-align: right; + } + } + /* ----------- INITIAL SETUP ------------ */ + dd, + .oe_import_toggled, + .oe_import_grid, + .oe_import_error_report, + .oe_import_noheaders, + .oe_import_report_more { + display: none; + } + + .oe_import_with_file label { + font-weight: normal; + } + .oe_import_debug_options { + max-width: 800px; + columns: 1; + @include media-breakpoint-up(md) { + columns: 2; + } + // try to keep the batch fields together, doesn't work on firefox & + // not sure how to do that (except by adding intermediate dom + // elements) + .oe_import_batch_limit { + break-before: column; + } + } + + &.oe_import_preview .oe_import_grid { + display: table; + } + &.oe_import_error .oe_import_error_report, + &.oe_import_noheaders .oe_import_noheaders{ + display: block; + } + .oe_import_report_showmore .oe_import_report_more { + display: list-item; + } + + /* ------------- ERRORS AND WARNINGS REPORT ------------ */ + .oe_import_error_report > ul { + padding: 0; + } + .oe_import_report { + list-style: none; + } + .alert { + padding: 0.50rem 1.25rem; + margin: 0.25rem 0; + + a { + @extend .alert-link; + &:hover {opacity: 0.8;} + } + + // alias -error to -danger + &.alert-error { + @extend .alert-danger; + } + &.text-error { + @extend .text-danger; + } + } + + /* ------------- THE CSV TABLE ------------ */ + + $cell-max-width: 350px; + $cell-padding: 4px; + .oe_import_grid { + tr { + &.oe_import_grid-header:first-child { + line-height: 24px; + font-weight: normal; + } + .oe_import_grid-cell { + max-width: $cell-max-width; + padding: $cell-padding; + vertical-align: top; + .o_multi_line_text { + word-break: break-word; + } + .o_single_line_text { + @include o-text-overflow($display: table-cell, $max-width: $cell-max-width - $cell-padding); + } + } + } + } + + /* Default Color for placeholder on import fields*/ + .select2-default{ + color: #F00 !important; + } +} +/* ------------- PARTIAL MODE buttons ------------ */ +// hide import in partial mode, resume otherwise +.o_import_import_full.o_import_partial_mode, +.o_import_import_partial:not(.o_import_partial_mode) { + display: none; +} + +/* Field dropdown */ +.oe_import_selector { + font-size: $font-size-sm; + ul, li { + margin: 0; padding: 0; + } + width: 250px !important; +} + +.o-list-buttons.o-editing .o_button_import { + display: none; // hidden for list view editable +} diff --git a/addons/base_import/static/src/xml/base_import.xml b/addons/base_import/static/src/xml/base_import.xml new file mode 100644 index 00000000..4bee0203 --- /dev/null +++ b/addons/base_import/static/src/xml/base_import.xml @@ -0,0 +1,227 @@ + + + + + + + +
    + + +
    + +
    + + Formatting Options… +
    +
    +

    + + + +

    +
    +
    +

    + + + +

    +
    +
    +
    +
    +
    + Due to its large size, the file will be imported by batches. +
    +
    + Click 'Resume' to proceed with the import, resuming at line + 0.
    + You can test or reload your file before resuming the import. +
    + +
    +

    Map your columns to import

    +
    +
    + + +
    + +
    + + +
    + +
    + + +
    +
    + + +
    +
    + + +
    +
    + + +
    +
    +

    If the file contains + the column names, Odoo can try auto-detecting the + field corresponding to the column. This makes imports + simpler especially when the file has many columns.

    + +
    +
    + + +
    This is a preview of the first 10 rows of your file
    + +
    +
    +

    + Select a CSV or Excel file to import. +

    +

    + Excel files are recommended as fields formatting is automatic. +

    +
    Need Help?
    +
    + + + +
    + Import FAQ +
    +
    + + + + + + + + + + + + +
    + +
    +     + + +     + + + + + + + + + + + + + + + +
    +

    Import preview failed due to: .

    +

    For CSV files, you may need to select the correct separator.

    +

    Here is the start of the file we could not import:

    +
    +
    +     +
      +
    • + + + + + +
        + +
      • + + + + +
        • +
      • + + + +
        • +         +
      + + + + + + + + +
      • +
    + + + + + + + + + + + + + + + + + + + -- cgit v1.2.3
    + +
    + + + + + + + + +