五月 | 2016 | Odoo Connects Everything

odoo列表视图分页默认80条记录，但可以点击切换选择200、500、2000、无限制，相关源码如下：

/**
 * Render the pager according to the ListView.pager template and add listeners on it.
 * Set this.$pager with the produced jQuery element
 * @param {jQuery} [$node] a jQuery node where the rendered pager should be inserted
 * $node may be undefined, in which case the ListView inserts the pager into this.options.$pager
 * or into a div of its template
 */
render_pager: function($node) {
    if (!this.$pager && this.options.pager) {
        var self =  this;

        this.$pager = $(QWeb.render("ListView.pager", {'widget': self}));
        this.$pager
            .on('click', 'a[data-pager-action]', function () {
                var $this = $(this);
                var max_page_index = Math.ceil(self.dataset.size() / self._limit) - 1;
                switch ($this.data('pager-action')) {
                    case 'first':
                        self.page = 0;
                        break;
                    case 'last':
                        self.page = max_page_index;
                        break;
                    case 'next':
                        self.page += 1;
                        break;
                    case 'previous':
                        self.page -= 1;
                        break;
                }
                if (self.page < 0) {
                    self.page = max_page_index;
                } else if (self.page > max_page_index) {
                    self.page = 0;
                }
                self.reload_content();
            }).find('.oe_list_pager_state')
                .click(function (e) {
                    e.stopPropagation();
                    var $this = $(this);

                    var $select = $('<select>')
                        .appendTo($this.empty())
                        .click(function (e) {e.stopPropagation();})
                        .append('<option value="80">80</option>' +
                                '<option value="200">200</option>' +
                                '<option value="500">500</option>' +
                                '<option value="2000">2000</option>' +
                                '<option value="NaN">' + _t("Unlimited") + '</option>')
                        .change(function () {
                            var val = parseInt($select.val(), 10);
                            self._limit = (isNaN(val) ? null : val);
                            self.page = 0;
                            self.reload_content();
                        }).blur(function() {
                            $(this).trigger('change');
                        })
                        .val(self._limit || 'NaN');
                });
        this.configure_pager(this.dataset);

        $node = $node || this.options.$pager;
        if ($node) {
            this.$pager.appendTo($node);
        } else {
            this.$('.oe_list_pager').replaceWith(this.$pager);
        }
    }
}

/**

* Render the pager according to the ListView.pager template and add listeners on it.

* Set this.$pager with the produced jQuery element

* @param {jQuery} [$node] a jQuery node where the rendered pager should be inserted

* $node may be undefined, in which case the ListView inserts the pager into this.options.$pager

* or into a div of its template

render_pager: function($node) {

if (!this.$pager && this.options.pager) {

var self = this;

this.$pager = $(QWeb.render("ListView.pager", {'widget': self}));

this.$pager

.on('click', 'a[data-pager-action]', function () {

var $this = $(this);

var max_page_index = Math.ceil(self.dataset.size() / self._limit) - 1;

switch ($this.data('pager-action')) {

case 'first':

self.page = 0;

break;

case 'last':

self.page = max_page_index;

break;

case 'next':

self.page += 1;

break;

case 'previous':

self.page -= 1;

break;

}

if (self.page < 0) {

self.page = max_page_index;

} else if (self.page > max_page_index) {

self.page = 0;

}

self.reload_content();

}).find('.oe_list_pager_state')

.click(function (e) {

e.stopPropagation();

var $this = $(this);

var $select = $('<select>')

.appendTo($this.empty())

.click(function (e) {e.stopPropagation();})

.append('<option value="80">80</option>' +

'<option value="200">200</option>' +

'<option value="500">500</option>' +

'<option value="2000">2000</option>' +

'<option value="NaN">' + _t("Unlimited") + '</option>')

.change(function () {

var val = parseInt($select.val(), 10);

self._limit = (isNaN(val) ? null : val);

self.page = 0;

self.reload_content();

}).blur(function() {

$(this).trigger('change');

})

.val(self._limit || 'NaN');

});

this.configure_pager(this.dataset);

$node = $node || this.options.$pager;

if ($node) {

this.$pager.appendTo($node);

} else {

this.$('.oe_list_pager').replaceWith(this.$pager);

}

如果系统运行许久积累了大量数据，特别是互联网海量应用，这个无限制就造成了一个性能上的隐患

var ListView = require('web.ListView');
ListView.include({
    render_pager: function ($node) {
        var self = this;
        self._super.apply(self, arguments);
        if (self.$pager && self.options.pager) {
            self.$pager.find('.oe_list_pager_state').click(function(e){
                e.stopPropagation();
                $(this).find("select").children("option:last").remove();
            });
        }
    }
});

var ListView = require('web.ListView');

ListView.include({

render_pager: function ($node) {

var self = this;

self._super.apply(self, arguments);

if (self.$pager && self.options.pager) {

self.$pager.find('.oe_list_pager_state').click(function(e){

e.stopPropagation();

$(this).find("select").children("option:last").remove();

});

}

});

这里通过继承渲染分页方法，在点击分页信息动态生成记录条数选择的事件上优雅的移除掉最后一个无限制选项

分组日期格式自定义

@api.model
def _read_group_process_groupby(self, gb, query):
    #自定义格式
    display_formats = {
        # Careful with week/year formats:
        #  - yyyy (lower) must always be used, *except* for week+year formats
        #  - YYYY (upper) must always be used for week+year format
        #         e.g. 2006-01-01 is W52 2005 in some locales (de_DE),
        #                         and W1 2006 for others
        #
        # Mixing both formats, e.g. 'MMM YYYY' would yield wrong results,
        # such as 2006-01-01 being formatted as "January 2005" in some locales.
        # Cfr: http://babel.pocoo.org/docs/dates/#date-fields
        'day': 'yyyy-MM-dd', # yyyy = normal year
        'week': "yyyy-w",  # w YYYY = ISO week-year
        'month': 'yyyy-MM',
        'quarter': 'yyyy-QQ',
        'year': 'yyyy',
    }
    annotate = super(Model, self)._read_group_process_groupby(gb=gb, query=query)
    if annotate.get('display_format'):
        gb = annotate.get('groupby','')
        split = gb.split(':')
        #默认月
        gb_function = split[1] if len(split) == 2 else 'month'
        #覆盖超类默认格式
        annotate["display_format"] = display_formats.get(gb_function,"")
    return annotate

@api.model

def _read_group_process_groupby(self, gb, query):

#自定义格式

display_formats = {

# Careful with week/year formats:

# - yyyy (lower) must always be used, *except* for week+year formats

# - YYYY (upper) must always be used for week+year format

# e.g. 2006-01-01 is W52 2005 in some locales (de_DE),

# and W1 2006 for others

# Mixing both formats, e.g. 'MMM YYYY' would yield wrong results,

# such as 2006-01-01 being formatted as "January 2005" in some locales.

# Cfr: http://babel.pocoo.org/docs/dates/#date-fields

'day': 'yyyy-MM-dd', # yyyy = normal year

'week': "yyyy-w", # w YYYY = ISO week-year

'month': 'yyyy-MM',

'quarter': 'yyyy-QQ',

'year': 'yyyy',

}

annotate = super(Model, self)._read_group_process_groupby(gb=gb, query=query)

if annotate.get('display_format'):

gb = annotate.get('groupby','')

split = gb.split(':')

#默认月

gb_function = split[1] if len(split) == 2 else 'month'

#覆盖超类默认格式

annotate["display_format"] = display_formats.get(gb_function,"")

return annotate

排序日期默认倒序

@api.model
def read_group(self, domain, fields, groupby, offset=0, limit=None, context=None, orderby=False, lazy=True):
    if not orderby and groupby and len(groupby) == 1:
        first_group_field = groupby[0]
        #日期分组
        if len(first_group_field.split(":")) == 2:
            #默认倒序
            orderby = "%s desc" % first_group_field
    return super(Model, self).read_group(domain=domain, fields=fields, groupby=groupby, offset=offset, limit=limit, context=context, orderby=orderby, lazy=lazy)

@api.model

def read_group(self, domain, fields, groupby, offset=0, limit=None, context=None, orderby=False, lazy=True):

if not orderby and groupby and len(groupby) == 1:

first_group_field = groupby[0]

#日期分组

if len(first_group_field.split(":")) == 2:

#默认倒序

orderby = "%s desc" % first_group_field

return super(Model, self).read_group(domain=domain, fields=fields, groupby=groupby, offset=offset, limit=limit, context=context, orderby=orderby, lazy=lazy)

月份：2016年5月

odoo tree view pagination disable unlimited

odoo pivot graph view group by date format and order by date desc