odoo | Odoo Connects Everything

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

分组日期格式自定义

@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)

odoo china baidu maps api

odoo原生内置google maps，导致中国大部分区域不仅无法正常使用，用户浏览器一直加载到超时还拖慢了网站整体

odoo disabled website homepage

odoo有些模块包含website功能，这就依赖了website这个重量级模块
很多时候仅仅想用其核心功能，并不想因此造成首页变成企业网站

# -*- coding: utf-8 -*-
import logging

from openerp import http
from openerp.http import request
from openerp.addons.website.controllers.main import Website

logger = logging.getLogger(__name__)

class WebsiteDisabled(Website):
    @http.route(auth="none", website=False)
    def index(self, **kw):
        return http.local_redirect('/web', query=request.params, keep_hash=True)

# -*- coding: utf-8 -*-

import logging

from openerp import http

from openerp.http import request

from openerp.addons.website.controllers.main import Website

logger = logging.getLogger(__name__)

class WebsiteDisabled(Website):

@http.route(auth="none", website=False)

def index(self, **kw):

return http.local_redirect('/web', query=request.params, keep_hash=True)

odoo muilt domain dbfilter many to one config and code

odoo支持dbfilter配置用于实现多域名对应多账套，dbfilter是一个python标准正则字符串，并支持特殊的%h、%d这两个动态参数

根据源代码剖析（odoo8、odoo9）
openerp/http.py

def db_filter(dbs, httprequest=None):
    httprequest = httprequest or request.httprequest
    #请求域名去除端口号，如果有的话
    h = httprequest.environ.get('HTTP_HOST', '').split(':')[0]
    #分割域名取主机名，即多级域名最左边段
    d, _, r = h.partition('.')
    #如主机名为www且有下一段取第二段为主机名
    if d == "www" and r:
        d = r.partition('.')[0]
    #动态正则支持，%h替换为域名，%d替换为主机名
    r = openerp.tools.config['dbfilter'].replace('%h', h).replace('%d', d)
    #正则筛选匹配的数据库列表   
    dbs = [i for i in dbs if re.match(r, i)]
    return dbs

def db_filter(dbs, httprequest=None):

httprequest = httprequest or request.httprequest

#请求域名去除端口号，如果有的话

h = httprequest.environ.get('HTTP_HOST', '').split(':')[0]

#分割域名取主机名，即多级域名最左边段

d, _, r = h.partition('.')

#如主机名为www且有下一段取第二段为主机名

if d == "www" and r:

d = r.partition('.')[0]

#动态正则支持，%h替换为域名，%d替换为主机名

r = openerp.tools.config['dbfilter'].replace('%h', h).replace('%d', d)

#正则筛选匹配的数据库列表

dbs = [i for i in dbs if re.match(r, i)]

return dbs

由此可见，绝大部分有规律的映射需求都可以得到满足。惟有那些情况特殊，完全没有规则可言的：比如SEO需要、历史数据库命名混乱、甚至多个一级域名只对一个数据库的需求就悲剧了

这里举一个理想的openerp-server.conf扩展配置特例

dbfilter = %m
dbfilter_zhunlian.net = www-zhunlian-net
dbfilter_www.zhunlian.net = www-zhunlian-net
dbfilter_wap.zhunlian.net = www-zhunlian-net
dbfilter_higk.com = www-higk-com
dbfilter_www.higk.com = www-higk-com
dbfilter_wap.higk.com = www-higk-com
dbfilter_higk.com.cn = www-higk-com
dbfilter_www.higk.com.cn = www-higk-com
dbfilter_higk.net = www-higk-com
dbfilter_www.higk.net = www-higk-com

dbfilter = %m

dbfilter_zhunlian.net = www-zhunlian-net

dbfilter_www.zhunlian.net = www-zhunlian-net

dbfilter_wap.zhunlian.net = www-zhunlian-net

dbfilter_higk.com = www-higk-com

dbfilter_www.higk.com = www-higk-com

dbfilter_wap.higk.com = www-higk-com

dbfilter_higk.com.cn = www-higk-com

dbfilter_www.higk.com.cn = www-higk-com

dbfilter_higk.net = www-higk-com

dbfilter_www.higk.net = www-higk-com

首先新增支持%m特别参数，用来开启域名数据库映射复杂模式
其次新增支持dbfilter_前缀的域名映射独立配置指定数据库名称（www-zhunlian-net、www-higk-com）
最后迫不得已新增插入两行精炼的源代码

def db_filter(dbs, httprequest=None):
    httprequest = httprequest or request.httprequest
    h = httprequest.environ.get('HTTP_HOST', '').split(':')[0]
    d, _, r = h.partition('.')
    if d == "www" and r:
        d = r.partition('.')[0]
    r = openerp.tools.config['dbfilter'].replace('%h', h).replace('%d', d)
    #开启域名数据库映射复杂模式
    if r == '%m':
        #尝试获取域名独立配置，如无指定则映射同名数据库名，相当于保底%h功能以减少标准配置
        r = openerp.tools.config.get('dbfilter_%s' % h, h)
    dbs = [i for i in dbs if re.match(r, i)]
    return dbs

def db_filter(dbs, httprequest=None):

httprequest = httprequest or request.httprequest

h = httprequest.environ.get('HTTP_HOST', '').split(':')[0]

d, _, r = h.partition('.')

if d == "www" and r:

d = r.partition('.')[0]

r = openerp.tools.config['dbfilter'].replace('%h', h).replace('%d', d)

#开启域名数据库映射复杂模式

if r == '%m':

#尝试获取域名独立配置，如无指定则映射同名数据库名，相当于保底%h功能以减少标准配置

r = openerp.tools.config.get('dbfilter_%s' % h, h)

dbs = [i for i in dbs if re.match(r, i)]

return dbs

注：一个域名必备的.号在正则表达式领域可用于匹配任意字符，所以域名全称作为正则也可以根据需要匹配出一组数据库列表，如域名renjie.me可同时匹配出数据库名为renjie.me、renjie-me、renjie@me等等相似名称的数据库

python ldap userPassword salt sha md5 encrypt

odoo自带的auth_ldap模块虽然实现了ldap统一账户的验证，但如果用户一旦修改密码就变成同名的本地用户。这是因为odoo默认先验证本地res.users信息，如果没有记录，或者有记录但密码字段为空才会去ldap服务器验证

根据其原理，可以在修改密码的时候对接上ldap的密码信息就完美了，但用modify指令写入的userPassword值是原文存储，即明文直接写入在服务器也是明文，这就需要在请求端预先加密成ldap标准的密文格式

网上看到有很多php的实现都是要写点代码什么的，照葫芦折腾几下才发现python的passlib库居然有现成拿来即用的函数

>>> from passlib.hash import ldap_salted_sha1 as ssha
>>> ssha.encrypt("test", salt_size=16)
'{SSHA}tiULq3HOY1XRLW+bjGkHe3awnZCHcE5JSam1tnaOce49B4Dw'

>>> from passlib.hash import ldap_salted_sha1 as ssha

>>> ssha.encrypt("test", salt_size=16)

'{SSHA}tiULq3HOY1XRLW+bjGkHe3awnZCHcE5JSam1tnaOce49B4Dw'

以此类推

>>> import passlib.hash
>>> dir(passlib.hash)
['__class__', '__delattr__', '__dict__', '__dir__', '__doc__', '__format__', '__getattr__', '__getattribute__', '__hash__', '__init__', '__module__', '__name__', '__new__', '__package__', '__reduce__', '__reduce_ex__', '__repr__', '__setattr__', '__sizeof__', '__str__', '__subclasshook__', '__weakref__', 'apr_md5_crypt', 'atlassian_pbkdf2_sha1', 'bcrypt', 'bcrypt_sha256', 'bigcrypt', 'bsd_nthash', 'bsdi_crypt', 'cisco_pix', 'cisco_type7', 'crypt16', 'cta_pbkdf2_sha1', 'des_crypt', 'django_bcrypt', 'django_bcrypt_sha256', 'django_des_crypt', 'django_disabled', 'django_pbkdf2_sha1', 'django_pbkdf2_sha256', 'django_salted_md5', 'django_salted_sha1', 'dlitz_pbkdf2_sha1', 'fshp', 'grub_pbkdf2_sha512', 'hex_md4', 'hex_md5', 'hex_sha1', 'hex_sha256', 'hex_sha512', 'htdigest', 'ldap_bcrypt', 'ldap_bsdi_crypt', 'ldap_des_crypt', 'ldap_hex_md5', 'ldap_hex_sha1', 'ldap_md5', 'ldap_md5_crypt', 'ldap_pbkdf2_sha1', 'ldap_pbkdf2_sha256', 'ldap_pbkdf2_sha512', 'ldap_plaintext', 'ldap_salted_md5', 'ldap_salted_sha1', 'ldap_sha1', 'ldap_sha1_crypt', 'ldap_sha256_crypt', 'ldap_sha512_crypt', 'lmhash', 'md5_crypt', 'msdcc', 'msdcc2', 'mssql2000', 'mssql2005', 'mysql323', 'mysql41', 'nthash', 'oracle10', 'oracle11', 'pbkdf2_sha1', 'pbkdf2_sha256', 'pbkdf2_sha512', 'phpass', 'plaintext', 'postgres_md5', 'roundup_plaintext', 'scram', 'sha1_crypt', 'sha256_crypt', 'sha512_crypt', 'sun_md5_crypt', 'unix_disabled', 'unix_fallback']

>>> import passlib.hash

>>> dir(passlib.hash)

['__class__', '__delattr__', '__dict__', '__dir__', '__doc__', '__format__', '__getattr__', '__getattribute__', '__hash__', '__init__', '__module__', '__name__', '__new__', '__package__', '__reduce__', '__reduce_ex__', '__repr__', '__setattr__', '__sizeof__', '__str__', '__subclasshook__', '__weakref__', 'apr_md5_crypt', 'atlassian_pbkdf2_sha1', 'bcrypt', 'bcrypt_sha256', 'bigcrypt', 'bsd_nthash', 'bsdi_crypt', 'cisco_pix', 'cisco_type7', 'crypt16', 'cta_pbkdf2_sha1', 'des_crypt', 'django_bcrypt', 'django_bcrypt_sha256', 'django_des_crypt', 'django_disabled', 'django_pbkdf2_sha1', 'django_pbkdf2_sha256', 'django_salted_md5', 'django_salted_sha1', 'dlitz_pbkdf2_sha1', 'fshp', 'grub_pbkdf2_sha512', 'hex_md4', 'hex_md5', 'hex_sha1', 'hex_sha256', 'hex_sha512', 'htdigest', 'ldap_bcrypt', 'ldap_bsdi_crypt', 'ldap_des_crypt', 'ldap_hex_md5', 'ldap_hex_sha1', 'ldap_md5', 'ldap_md5_crypt', 'ldap_pbkdf2_sha1', 'ldap_pbkdf2_sha256', 'ldap_pbkdf2_sha512', 'ldap_plaintext', 'ldap_salted_md5', 'ldap_salted_sha1', 'ldap_sha1', 'ldap_sha1_crypt', 'ldap_sha256_crypt', 'ldap_sha512_crypt', 'lmhash', 'md5_crypt', 'msdcc', 'msdcc2', 'mssql2000', 'mssql2005', 'mysql323', 'mysql41', 'nthash', 'oracle10', 'oracle11', 'pbkdf2_sha1', 'pbkdf2_sha256', 'pbkdf2_sha512', 'phpass', 'plaintext', 'postgres_md5', 'roundup_plaintext', 'scram', 'sha1_crypt', 'sha256_crypt', 'sha512_crypt', 'sun_md5_crypt', 'unix_disabled', 'unix_fallback']

其中ldap_bcrypt,ldap_bsdi_crypt,ldap_des_crypt,ldap_hex_md5,ldap_hex_sha1,ldap_md5,ldap_md5_crypt,ldap_pbkdf2_sha1,ldap_pbkdf2_sha256,ldap_pbkdf2_sha512,ldap_plaintext,ldap_salted_md5,ldap_salted_sha1,ldap_sha1,ldap_sha1_crypt,ldap_sha256_crypt,ldap_sha512_crypt等都是ldap加密相关的兄弟函数，可谓是应有尽有非常丰富，看来在odoo端直接集成phpLDAPadmin里各种类型的加密密码更新都是易事了

odoo addons xml develop debug auto update

odoo以开发者模式运行的话，能自动检测所有的addons目录的代码变动情况自动进行reload
这个机制对于python代码来说是够用的，但是对csv安全规则、xml数据及视图模版来说还需要更新模块才能使其生效

今天由于逐个测试安全规则条目，不断的手工更新模块不胜其烦，只好深入研究一下

odoo9开始已经将开发者模式依赖的pyinotify替换为watchdog，可能是后者的应用范围更广把，不仅提供python库，还附带shell工具

那就学习下这个叫watchmedo的命令行工具吧

(python)[srj@x1c odoo9]$ watchmedo --help
usage: watchmedo [-h] [--version]
                 
                 {tricks-from,tricks-generate-yaml,log,shell-command,auto-restart}
                 ...

positional arguments:
  {tricks-from,tricks-generate-yaml,log,shell-command,auto-restart}
    tricks-from         Subcommand to execute tricks from a tricks
                        configuration file. :param args: Command line argument
                        options.
    tricks-generate-yaml
                        Subcommand to generate Yaml configuration for tricks
                        named on the command line. :param args: Command line
                        argument options.
    log                 Subcommand to log file system events to the console.
                        :param args: Command line argument options.
    shell-command       Subcommand to execute shell commands in response to
                        file system events. :param args: Command line argument
                        options.
    auto-restart        Subcommand to start a long-running subprocess and
                        restart it on matched events. :param args: Command
                        line argument options.

optional arguments:
  -h, --help            show this help message and exit
  --version             show program's version number and exit

(python)[srj@x1c odoo9]$ watchmedo --help

usage: watchmedo [-h] [--version]

{tricks-from,tricks-generate-yaml,log,shell-command,auto-restart}

...

positional arguments:

{tricks-from,tricks-generate-yaml,log,shell-command,auto-restart}

tricks-from Subcommand to execute tricks from a tricks

configuration file. :param args: Command line argument

options.

tricks-generate-yaml

Subcommand to generate Yaml configuration for tricks

named on the command line. :param args: Command line

argument options.

log Subcommand to log file system events to the console.

:param args: Command line argument options.

shell-command Subcommand to execute shell commands in response to

file system events. :param args: Command line argument

options.

auto-restart Subcommand to start a long-running subprocess and

restart it on matched events. :param args: Command

line argument options.

optional arguments:

-h, --help show this help message and exit

--version show program's version number and exit

看到auto-restart参数后真是让人眼前一亮，根据提示继续学习二级参数

(python)[srj@x1c odoo9]$ watchmedo auto-restart -h
usage: watchmedo auto-restart [-h] [-d directory] [-p PATTERNS]
                              [-i IGNORE_PATTERNS] [-D] [-R]
                              [--interval TIMEOUT] [--signal SIGNAL]
                              [--kill-after KILL_AFTER]
                              command [arg [arg ...]]

    Subcommand to start a long-running subprocess and restart it
    on matched events.

    :param args:
        Command line argument options.
    

positional arguments:
  command               Long-running command to run in a subprocess.
  arg                   Command arguments. Note: Use -- before the command
                        arguments, otherwise watchmedo will try to interpret
                        them. (default: -)

optional arguments:
  -h, --help            show this help message and exit
  -d directory, --directory directory
                        Directory to watch. Use another -d or --directory
                        option for each directory. (default: -)
  -p PATTERNS, --pattern PATTERNS, --patterns PATTERNS
                        matches event paths with these patterns (separated by
                        ;). (default: '*')
  -i IGNORE_PATTERNS, --ignore-pattern IGNORE_PATTERNS, --ignore-patterns IGNORE_PATTERNS
                        ignores event paths with these patterns (separated by
                        ;). (default: '')
  -D, --ignore-directories
                        ignores events for directories (default: False)
  -R, --recursive       monitors the directories recursively (default: False)
  --interval TIMEOUT, --timeout TIMEOUT
                        use this as the polling interval/blocking timeout
                        (default: 1.0)
  --signal SIGNAL       stop the subprocess with this signal (default SIGINT)
                        (default: 'SIGINT')
  --kill-after KILL_AFTER
                        when stopping, kill the subprocess after the specified
                        timeout (default 10) (default: 10.0)

(python)[srj@x1c odoo9]$ watchmedo auto-restart -h

usage: watchmedo auto-restart [-h] [-d directory] [-p PATTERNS]

[-i IGNORE_PATTERNS] [-D] [-R]

[--interval TIMEOUT] [--signal SIGNAL]

[--kill-after KILL_AFTER]

command [arg [arg ...]]

Subcommand to start a long-running subprocess and restart it

on matched events.

:param args:

Command line argument options.

positional arguments:

command Long-running command to run in a subprocess.

arg Command arguments. Note: Use -- before the command

arguments, otherwise watchmedo will try to interpret

them. (default: -)

optional arguments:

-h, --help show this help message and exit

-d directory, --directory directory

Directory to watch. Use another -d or --directory

option for each directory. (default: -)

-p PATTERNS, --pattern PATTERNS, --patterns PATTERNS

matches event paths with these patterns (separated by

;). (default: '*')

-i IGNORE_PATTERNS, --ignore-pattern IGNORE_PATTERNS, --ignore-patterns IGNORE_PATTERNS

ignores event paths with these patterns (separated by

;). (default: '')

-D, --ignore-directories

ignores events for directories (default: False)

-R, --recursive monitors the directories recursively (default: False)

--interval TIMEOUT, --timeout TIMEOUT

use this as the polling interval/blocking timeout

(default: 1.0)

--signal SIGNAL stop the subprocess with this signal (default SIGINT)

(default: 'SIGINT')

--kill-after KILL_AFTER

when stopping, kill the subprocess after the specified

timeout (default 10) (default: 10.0)

真是太强大了，本以为还要写点小代码什么的，没想到几个选项就可以灵活组合出一个小型的监控工具

watchmedo auto-restart -R -p="*.py;*.xml;*.csv" -d /home/srj/Git/Odoo/custom_addons/account_simple/ -- ./odoo.py -c c.conf -d test9 -u account_simple

1	watchmedo auto-restart -R -p=".py;.xml;*.csv" -d /home/srj/Git/Odoo/custom_addons/account_simple/ -- ./odoo.py -c c.conf -d test9 -u account_simple

-R是目录递归监控
-p是文件模式匹配，主要是排除前端资源和pyc
-d是指定监控目录
–是watchmedo与odoo各自的命令行参数分割线

至此odoo的模块开发效率又提高了一个层次：）

centos odoo decoder jpeg not available

云服务器上传jpg图片提示IOError错误

  File "/usr/lib64/python2.7/site-packages/PIL/ImageFile.py", line 200, in load
    d = Image._getdecoder(self.mode, d, a, self.decoderconfig)
  File "/usr/lib64/python2.7/site-packages/PIL/Image.py", line 417, in _getdecoder
    raise IOError("decoder %s not available" % decoder_name)
IOError: decoder jpeg not available

File "/usr/lib64/python2.7/site-packages/PIL/ImageFile.py", line 200, in load

d = Image._getdecoder(self.mode, d, a, self.decoderconfig)

File "/usr/lib64/python2.7/site-packages/PIL/Image.py", line 417, in _getdecoder

raise IOError("decoder %s not available" % decoder_name)

IOError: decoder jpeg not available

初步判断是python pil库依赖的底层jpeg lib问题
但是本机正常无法重现，于是检查环境

[srj@x1c ~]$ yum list installed|grep jpeg
libjpeg-turbo.x86_64               1.2.90-5.el7                        @anaconda
libjpeg-turbo-devel.x86_64         1.2.90-5.el7                        @anaconda
openjpeg-libs.x86_64               1.5.1-10.el7                        @anaconda

[srj@x1c ~]$ yum list installed|grep jpeg

libjpeg-turbo.x86_64 1.2.90-5.el7 @anaconda

libjpeg-turbo-devel.x86_64 1.2.90-5.el7 @anaconda

openjpeg-libs.x86_64 1.5.1-10.el7 @anaconda

对比了下发现服务器环境没有libjpeg-turbo-devel.x86_64立马补装一个，重启odoo服务错误依旧，于是继续更新Pillow库

[root@demo ~]# pip install --upgrade Pillow
Collecting Pillow
  Downloading Pillow-3.1.0.tar.gz (9.9MB)
    100% |████████████████████████████████| 9.9MB 42kB/s 
Installing collected packages: Pillow
  Found existing installation: Pillow 2.7.0
    Uninstalling Pillow-2.7.0:
      Successfully uninstalled Pillow-2.7.0
  Running setup.py install for Pillow
Successfully installed Pillow-3.1.0

[root@demo ~]# pip install --upgrade Pillow

Collecting Pillow

Downloading Pillow-3.1.0.tar.gz (9.9MB)

100% |████████████████████████████████| 9.9MB 42kB/s

Installing collected packages: Pillow

Found existing installation: Pillow 2.7.0

Uninstalling Pillow-2.7.0:

Successfully uninstalled Pillow-2.7.0

Running setup.py install for Pillow

Successfully installed Pillow-3.1.0

重启odoo服务问题解决
最后回顾了下odoo requirements.txt：
odoo8 Pillow==2.5.1
odoo9 Pillow==2.7.0
其实所谓更新无非是重新安装编译一下Pillow库，没想到直接升级到3.1.0版本，希望没有什么副作用：）

odoo Many2one field create use custom view open

odoo联系人相关的信息全部存储在res.partner对象里，包括供应商、客户、员工等个人及公司相关的信息都可以归纳入内

partner_id = fields.Many2one('res.partner', required=True)

1	partner_id = fields.Many2one('res.partner', required=True)

二次开发经常会直接关联该对象可以少造很多轮子，但由于其新建联系人的默认视图view_partner_form是一个非常重且包含好多类型设置又被各种业务模块继承扩展过的大视图，这就需要为不同的应用场景开发对应业务信息的轻量级自定义视图

最开始我是从继承res.partner并重写其@api.model的fields_view_get方法来完成的

@api.model
def fields_view_get(self, view_id=None, view_type=False, toolbar=False, submenu=False):
    def get_view_id(name):
        view = self.env['ir.ui.view'].search([('name', '=', name)], limit=1)
        if not view:
            return None
        return view.id
    context_view_name = self._context.get('view_name')
    if context_view_name:
        ##重置context指定视图
        view_id = get_view_id(context_view_name)
    return super(res_partner, self).fields_view_get(
        view_id=view_id, view_type=view_type, toolbar=toolbar, submenu=submenu)

@api.model

def fields_view_get(self, view_id=None, view_type=False, toolbar=False, submenu=False):

def get_view_id(name):

view = self.env['ir.ui.view'].search([('name', '=', name)], limit=1)

if not view:

return None

return view.id

context_view_name = self._context.get('view_name')

if context_view_name:

##重置context指定视图

view_id = get_view_id(context_view_name)

return super(res_partner, self).fields_view_get(

view_id=view_id, view_type=view_type, toolbar=toolbar, submenu=submenu)

使用很简单view context新增一个view_name属性指定自定义视图名称即可

<field name="partner_id" context="{'view_name': 'res.partner.daybook.form'}"/>

1	<field name="partner_id" context="{'view_name': 'res.partner.daybook.form'}"/>

当后来对其它对象也有同样需求的时候就基本确定我悲剧的造了一个小轮子
因为这个需求是非常合理，如果要一个个对象去继承重写是非常不实现的，至少也要在共同的父类上做对接
根据这个思路从openerp.osv.Model一直寻找到openerp.models.Model的fields_view_get父级方法，其中有一段代码让人眼前一亮

# try to find a view_id if none provided
if not view_id:
    # <view_type>_view_ref in context can be used to overrride the default view
    view_ref_key = view_type + '_view_ref'
    view_ref = context.get(view_ref_key)
    if view_ref:
        if '.' in view_ref:
            module, view_ref = view_ref.split('.', 1)
            cr.execute("SELECT res_id FROM ir_model_data WHERE model='ir.ui.view' AND module=%s AND name=%s", (module, view_ref))
            view_ref_res = cr.fetchone()
            if view_ref_res:
                view_id = view_ref_res[0]

# try to find a view_id if none provided

if not view_id:

# <view_type>_view_ref in context can be used to overrride the default view

view_ref_key = view_type + '_view_ref'

view_ref = context.get(view_ref_key)

if view_ref:

if '.' in view_ref:

module, view_ref = view_ref.split('.', 1)

cr.execute("SELECT res_id FROM ir_model_data WHERE model='ir.ui.view' AND module=%s AND name=%s", (module, view_ref))

view_ref_res = cr.fetchone()

if view_ref_res:

view_id = view_ref_res[0]

这不就是传说中解决分类自选视图的相关代码：类型、模块名、视图ID确定一个视图
马上删除之前所有相关代码，view context按如下规则修改直接应用

<field name="partner_id" context="{'form_view_ref': '模块名.视图ID'}"/>

1	<field name="partner_id" context="{'form_view_ref': '模块名.视图ID'}"/>

至此，对odoo一切都是models的理念又有了进一步的理解

Odoo8、9打印中文字体配置分析详解

源码路径odoo/openerp/report/render/rml2pdf/customfonts.py

# Search path for TTF files, in addition of rl_config.TTFSearchPath
TTFSearchPath = [
            '/usr/share/fonts/truetype', # SuSE
            '/usr/share/fonts/dejavu', '/usr/share/fonts/liberation', # Fedora, RHEL
            '/usr/share/fonts/truetype/*','/usr/local/share/fonts' # Ubuntu,
            '/usr/share/fonts/TTF/*', # Mandriva/Mageia
            '/usr/share/fonts/TTF', # Arch Linux
            '/usr/lib/openoffice/share/fonts/truetype/',
            '~/.fonts',
            '~/.local/share/fonts',

            # mac os X - from
            # http://developer.apple.com/technotes/tn/tn2024.html
            '~/Library/Fonts',
            '/Library/Fonts',
            '/Network/Library/Fonts',
            '/System/Library/Fonts',

            # windows
            'c:/winnt/fonts',
            'c:/windows/fonts'
]

# Search path for TTF files, in addition of rl_config.TTFSearchPath

TTFSearchPath = [

'/usr/share/fonts/truetype', # SuSE

'/usr/share/fonts/dejavu', '/usr/share/fonts/liberation', # Fedora, RHEL

'/usr/share/fonts/truetype/*','/usr/local/share/fonts' # Ubuntu,

'/usr/share/fonts/TTF/*', # Mandriva/Mageia

'/usr/share/fonts/TTF', # Arch Linux

'/usr/lib/openoffice/share/fonts/truetype/',

'~/.fonts',

'~/.local/share/fonts',

# mac os X - from

# http://developer.apple.com/technotes/tn/tn2024.html

'~/Library/Fonts',

'/Library/Fonts',

'/Network/Library/Fonts',

'/System/Library/Fonts',

# windows

'c:/winnt/fonts',

'c:/windows/fonts'

]

可见对于windows、mac及linux大部分发行版的默认系统字体路径都做了比较全面的配置

def list_all_sysfonts():
    """
        This function returns list of font directories of system.
    """
    filepath = []

    # Perform the search for font files ourselves, as reportlab's
    # TTFOpenFile is not very good at it.
    searchpath = list(set(TTFSearchPath + rl_config.TTFSearchPath))
    for dirname in searchpath:
        for filename in glob.glob(os.path.join(os.path.expanduser(dirname), '*.[Tt][Tt][FfCc]')):
            filepath.append(filename)
    return filepath

def list_all_sysfonts():

"""

This function returns list of font directories of system.

"""

filepath = []

# Perform the search for font files ourselves, as reportlab's

# TTFOpenFile is not very good at it.

searchpath = list(set(TTFSearchPath + rl_config.TTFSearchPath))

for dirname in searchpath:

for filename in glob.glob(os.path.join(os.path.expanduser(dirname), '*.[Tt][Tt][FfCc]')):

filepath.append(filename)

return filepath

接着根据正则*.[Tt][Tt][FfCc]对所有配置路径下的文件扩展名做字体匹配以生成odoo可供配置选择的字体列表

一般Linux下使用最多的开源中文字体是文泉译系列，简称wqy，Centos下yum search wqy相关英文描述（中文笔者补充）：

wqy-microhei-fonts.noarch : Compact Chinese fonts derived from Droid
文泉驿微米黑是一个”自由字体”。该字体包含了所有常用简体中文、繁体中文所需要的汉字(最新版本包含超过20932个汉字，完整覆盖GB2312/Big5以及GBK标准字符集)。该字体同时还包含了日文、韩文和其他几十种语言符号。以外，该字体还包含了高质量的Droid Sans拉丁符号和Droid Sans Mono等宽字体，并内置Hinting和Kerning信息。微米黑字体文件极小，特别使用于便携式电脑设备

wqy-unibit-fonts.noarch : WenQuanYi Unibit Bitmap Font
文泉驿Unibit是一款等宽的点阵字体，该字体包含了46,000多个unicode符号，超过27,000多个符合国家标准的汉字点阵字型，是已知的开源字体当中包含符号最完整的字体之一

wqy-zenhei-fonts.noarch : WenQuanYi Zen Hei CJK Font
黑体由于笔画略宽，显示对比度比宋体大，所以越来越得到桌面用户的青睐。文泉驿正黑体正是为这种目的设计的一款开源字体

据上描述可直接根据需要yum install对应的字体名称即可快速安装
当然也可以直接去文泉译官网http://wenq.org/获取最新版本及其它类型中文字体，如文泉驿点阵宋体

然后以优秀的文泉驿微米黑字体为例：

[srj@x1c ~]# rpm -ql wqy-microhei-fonts
/etc/fonts/conf.d/65-wqy-microhei.conf
/usr/share/doc/wqy-microhei-fonts-0.2.0
/usr/share/doc/wqy-microhei-fonts-0.2.0/LICENSE_Apache2.txt
/usr/share/doc/wqy-microhei-fonts-0.2.0/LICENSE_GPLv3.txt
/usr/share/doc/wqy-microhei-fonts-0.2.0/README.txt
/usr/share/fontconfig/conf.avail/65-wqy-microhei.conf
/usr/share/fonts/wqy-microhei
/usr/share/fonts/wqy-microhei/wqy-microhei.ttc

[srj@x1c ~]# rpm -ql wqy-microhei-fonts

/etc/fonts/conf.d/65-wqy-microhei.conf

/usr/share/doc/wqy-microhei-fonts-0.2.0

/usr/share/doc/wqy-microhei-fonts-0.2.0/LICENSE_Apache2.txt

/usr/share/doc/wqy-microhei-fonts-0.2.0/LICENSE_GPLv3.txt

/usr/share/doc/wqy-microhei-fonts-0.2.0/README.txt

/usr/share/fontconfig/conf.avail/65-wqy-microhei.conf

/usr/share/fonts/wqy-microhei

/usr/share/fonts/wqy-microhei/wqy-microhei.ttc

最后一行是字体文件物理位置，很不幸用了独立子目录wqy-microhei，这在官方配置列表里是没有的，不过好在扩展名正则已经支持ttc字体了，之前只有ttf字体才可匹配到，所以很多老教程都是直接在源码里加路径加扩展名匹配来解决

那不改源码最简单的方法就是从配置里与系统最低耦合的~/.fonts用户目录来存放可识别字体：

cp /usr/share/fonts/wqy-microhei/wqy-microhei.ttc ~/.fonts/

1	cp /usr/share/fonts/wqy-microhei/wqy-microhei.ttc ~/.fonts/

最后重启odoo，设置-配置-常规设置-报表字体-重载字体，字体下拉里就可以直接选择或者搜索到WenQuanYi Micro Hei选择并应用生效后即可完美使用中文打印各种报表了

本机同时部署odoo8和odoo9等多套开发环境注意事项

自从odoo9正式发布后，odoo8就意味着迟早要跟odoo7一样进入历史
但在一段时间的过渡期内
开发者可能要维持两套版本环境方便快速调式自己的代码能否多版本兼容运行
特别是插件开发，经常一个修改就需要到两个系统更新应用测试
以下记载各个共存环节需要注意的事项

安装方式：
因为安装包是互斥冲突的，所以必须源码安装

依赖库：
相同部分(python)或特有部分(nodejs)可以全局安装，不同部分则用上篇python-virtualenv虚拟环境隔离

数据库：
最简单一个本机帐号同名的超级账户共享使用，odoo缺省配置就能连接上了
不过最好先安装8在安装9，因为9能认识8创建的数据库而忽略，但8不太认识9创建的数据库自动连接会报错
共存之后8的控制台会例行报如下警告，要洁癖只能分别配置两个数据库帐号

2015-12-08 04:36:17,108 2143 WARNING odoo9 openerp.addons.base.ir.ir_cron: Skipping database odoo9 as its base version is not 8.0.1.3.

1	2015-12-08 04:36:17,108 2143 WARNING odoo9 openerp.addons.base.ir.ir_cron: Skipping database odoo9 as its base version is not 8.0.1.3.

版本库：
odoo8和odoo9两目录分别clone对应官方git版本库的8.0和9.0分支，独立各自日常更新

[srj@x1c odoo8]$ git clone -b 8.0 git@github.com:odoo/odoo.git .

[srj@x1c odoo9]$ git clone -b 9.0 git@github.com:odoo/odoo.git .

[srj@x1c odoo8]$ git clone -b 8.0 git@github.com:odoo/odoo.git .

[srj@x1c odoo9]$ git clone -b 9.0 git@github.com:odoo/odoo.git .

插件库：
比较灵活，我的方式是与odoo目录同级，然后配置文件共同指向

[srj@x1c Odoo]$ pwd
/home/srj/Git/Odoo
[srj@x1c Odoo]$ ls
learn_addons  odoo8  odoo9  other_addons  renjie_addons

[srj@x1c Odoo]$ pwd

/home/srj/Git/Odoo

[srj@x1c Odoo]$ ls

learn_addons odoo8 odoo9 other_addons renjie_addons

配置文件：
启动时分别指定各自独立配置，各自用不同的端口

[srj@x1c odoo8]$ cat c.conf
[options]
addons_path = /home/srj/Git/Odoo/renjie_addons,/home/srj/Git/Odoo/odoo8/openerp/addons,/home/srj/Git/Odoo/odoo8/addons
xmlrpc_port = 8008

[srj@x1c odoo9]$ cat c.conf
[options]
addons_path = /home/srj/Git/Odoo/renjie_addons,/home/srj/Git/Odoo/odoo9/openerp/addons,/home/srj/Git/Odoo/odoo9/addons
xmlrpc_port = 8009

[srj@x1c odoo8]$ cat c.conf

[options]

addons_path = /home/srj/Git/Odoo/renjie_addons,/home/srj/Git/Odoo/odoo8/openerp/addons,/home/srj/Git/Odoo/odoo8/addons

xmlrpc_port = 8008

[srj@x1c odoo9]$ cat c.conf

[options]

addons_path = /home/srj/Git/Odoo/renjie_addons,/home/srj/Git/Odoo/odoo9/openerp/addons,/home/srj/Git/Odoo/odoo9/addons

xmlrpc_port = 8009

浏览器：
虽然分属不同的端口提供服务，但因为登录标识必须要写用户本地浏览器cookie如session_id，或者犹如website_lang网站默认语言这种个性化设置。但由于cookie只匹配域名及路径就是不区分端口，所以同一个浏览器只能固定某个版本调式，如果同时使用就会发生各种意想不到的混乱错误。
当然解决方案也很简单，就是将本机127.0.0.1多设置几个如localhost这种别名来给不同的odoo版本独立访问即可

sudo vim /etc/hosts
127.0.0.1   odoo8 odoo9

1 2	sudo vim /etc/hosts 127.0.0.1 odoo8 odoo9