学习 | Odoo Connects Everything

odoo html field summernote wysiwyg editor custom

ODOO富文本字段Summernote编辑器自定义
Summernote是一个非常简单灵活所见即所得的HTML在线编辑器，基于jQuery和Bootstrap构建，支持快捷键操作，提供大量可定制的选项

不同版本的ODOO在不同阶段都尝试过各种自定义，比如字体选择、全屏功能以及开发者模式下的源码视图，以下将根据代码odoo/addons/web_editor/static/src/js/backend.js里的默认配置为基础进行自定义调整：

/**
 * author: i@renjie.me
 */
var FieldTextHtmlSimple = core.form_widget_registry.get("html");
FieldTextHtmlSimple.include({
    _config: function() {
        var self = this;
        var config = self._super.apply(self, arguments);
        // 初始高度
        config["height"] = 200;
        // 删除线功能
        config.toolbar[1][1].splice(3, 0, 'strikethrough');
        // 普通模式源码视图
        if(!session.debug){
            config.toolbar.splice(7, 0, ['view', ['codeview']]);
        }
        // 全屏功能
        config.toolbar[7][1].unshift('fullscreen');
        return config;
    },
    initialize_content: function() {
        var self = this;
        self._super.apply(self, arguments);
        // 关闭拼写检查
        if(!self.get("effective_readonly")){
            self.$content.attr("spellcheck", false);
        }
    }
});

/**

* author: i@renjie.me

var FieldTextHtmlSimple = core.form_widget_registry.get("html");

FieldTextHtmlSimple.include({

_config: function() {

var self = this;

var config = self._super.apply(self, arguments);

// 初始高度

config["height"] = 200;

// 删除线功能

config.toolbar[1][1].splice(3, 0, 'strikethrough');

// 普通模式源码视图

if(!session.debug){

config.toolbar.splice(7, 0, ['view', ['codeview']]);

}

// 全屏功能

config.toolbar[7][1].unshift('fullscreen');

return config;

initialize_content: function() {

var self = this;

self._super.apply(self, arguments);

// 关闭拼写检查

if(!self.get("effective_readonly")){

self.$content.attr("spellcheck", false);

}

});

summernote

odoo wechat user info sync issue

ODOO微信用户信息同步问题
Python使用http高级requests库来对接微信开放平台和公众平台非常干净利落，主要两个小问题需要注意一下：

1、用户昵称乱码
正常拉取用户信息所返回的内容编码不太友好，读取时乱码，需要显式设定lang和encoding

'''
  author: i@renjie.me
'''
def get_sns_user_info(self, sns_token, openid):
    url = self.get_api_url("api") + "/sns/userinfo"
    params = dict(
        access_token = sns_token,
        openid = openid,
        lang = "en",
    )
    res = requests.get(url, params=params)
    res.encoding = 'utf-8'
    ret = res.json()
    log = "get_sns_user_info: sns_token(%s) openid(%s) ret(%s)" % (sns_token, openid, ret)
    if "nickname" in ret:
        _logger.info(log)
        return ret
    else:
        _logger.error(log)

'''

author: i@renjie.me

'''

def get_sns_user_info(self, sns_token, openid):

url = self.get_api_url("api") + "/sns/userinfo"

params = dict(

access_token = sns_token,

openid = openid,

lang = "en",

)

res = requests.get(url, params=params)

res.encoding = 'utf-8'

ret = res.json()

log = "get_sns_user_info: sns_token(%s) openid(%s) ret(%s)" % (sns_token, openid, ret)

if "nickname" in ret:

_logger.info(log)

return ret

else:

_logger.error(log)

2、用户头像时效
如只保存头像链接，若用户更换头像，原有链接将失效，需要用Binary字段存储一份图片二进制base64编码的副本

'''
  author: i@renjie.me
  headimgurl = fields.Char(u'头像地址', readonly=True)
  head = fields.Binary(u"头像", attachment=True, readonly=True)
'''
@api.multi
def write(self, vals):
    if "headimgurl" in vals:
        if vals.get("headimgurl"):
            res = requests.get(vals["headimgurl"])
            vals["head"] = res.content.encode('base64')
        else:
            vals["head"] = ""
    return super(UsersWechat, self).write(vals)

'''

author: i@renjie.me

headimgurl = fields.Char(u'头像地址', readonly=True)

head = fields.Binary(u"头像", attachment=True, readonly=True)

'''

@api.multi

def write(self, vals):

if "headimgurl" in vals:

if vals.get("headimgurl"):

res = requests.get(vals["headimgurl"])

vals["head"] = res.content.encode('base64')

else:

vals["head"] = ""

return super(UsersWechat, self).write(vals)

odoo tree view disable open form content

ODOO列表视图禁止打开表单内容
正常的列表视图做为菜单动作直接打开的话，直接点击是跳转当前动作下的表单视图；还有一种是做为表单视图One2many、Many2many类型的嵌入式列表视图，直接点击打开Dialog窗口展示表单视图，一些特殊的需求场景下往往希望只将信息展示到列表即止，不用更多的详细互动：

/**
 * author: i@renjie.me
 */
var ListView = require('web.ListView');
ListView.List.include({
    row_clicked: function () {
        var self = this;
        var context = self.dataset.get_context().eval();
        if(!context["disable_open"]){
            self._super.apply(self, arguments);
        }
    }
});

/**

* author: i@renjie.me

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

ListView.List.include({

row_clicked: function () {

var self = this;

var context = self.dataset.get_context().eval();

if(!context["disable_open"]){

self._super.apply(self, arguments);

}

});

原理就是找到相关的行点击入口，通过万能的context扩展一个独立的禁止打开参数，默认不禁止，视图里通过显式声明使用该功能：

<field name="renjie_ids" context="{'disable_open': True}"/>

1	<field name="renjie_ids" context="{'disable_open': True}"/>

odoo tree view link text url widget

原生列表视图的url组件会将链接也显式的填充到字段列，如果遇到该字段的链接特别长且参数众多，表格就会撑的很难看，这就需要量身为其定制一种纯显示链接文字的widget：

var core = require('web.core');
var list_widget_registry = core.list_widget_registry;
var _t = core._t;
/**
 * author: i@renjie.me
 */
var Column = list_widget_registry.get('field');
var ColumnLink = Column.extend({
    PROTOCOL_REGEX: /^(?!\w+:?\/\/)/,
    _format: function(row_data, options) {
        var value = row_data[this.id].value;
        if (value) {
            return _.template("<a href='<%-href%>' target='_blank'><%-text%></a>")({
                href: value.trim().replace(this.PROTOCOL_REGEX, '//'),
                text: _t("Link")
            });
        }
        return this._super(row_data, options);
    }
});
list_widget_registry.add('field.link', ColumnLink);

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

var list_widget_registry = core.list_widget_registry;

var _t = core._t;

/**

* author: i@renjie.me

var Column = list_widget_registry.get('field');

var ColumnLink = Column.extend({

PROTOCOL_REGEX: /^(?!\w+:?\/\/)/,

_format: function(row_data, options) {

var value = row_data[this.id].value;

if (value) {

return _.template("<a href='<%-href%>' target='_blank'><%-text%></a>")({

href: value.trim().replace(this.PROTOCOL_REGEX, '//'),

text: _t("Link")

});

}

return this._super(row_data, options);

}

});

list_widget_registry.add('field.link', ColumnLink);

之后就可以在列表视图中直接使用诸如<field name=”content_url” widget=”link”/>形式的链接文字字段组件

odoo search view default show filters advanced menu

odoo搜索视图默认是隐藏高级搜索菜单栏，虽然可以打开记住状态，但换台电脑或浏览器默认又是关闭，这就需要改变其缺省机制，源码如下：

var SearchView = require('web.SearchView');
SearchView.include({
    init: function () {
        var self = this;
        self._super.apply(self, arguments);
        self.visible_filters = (localStorage.visible_search_menu !== 'false');
    }
});

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

SearchView.include({

init: function () {

var self = this;

self._super.apply(self, arguments);

self.visible_filters = (localStorage.visible_search_menu !== 'false');

}

});

python decompress http response gzip and deflate Content-Encoding

deflate与gzip解压的方法几乎相同，源码如下：

import zlib
import urllib2

def get_url_content(url):
    headers = {
        'Accept-Encoding': 'gzip, deflate',
    }
    response = urllib2.urlopen(urllib2.Request(url, headers=headers))
    content = response.read()
    content_encode = response.info().get('Content-Encoding')
    if content_encode == 'gzip':
        content = zlib.decompress(content, zlib.MAX_WBITS|16)
    elif content_encode == 'deflate':
        content = zlib.decompress(content, -zlib.MAX_WBITS)
    return content

import zlib

import urllib2

def get_url_content(url):

headers = {

'Accept-Encoding': 'gzip, deflate',

}

response = urllib2.urlopen(urllib2.Request(url, headers=headers))

content = response.read()

content_encode = response.info().get('Content-Encoding')

if content_encode == 'gzip':

content = zlib.decompress(content, zlib.MAX_WBITS|16)

elif content_encode == 'deflate':

content = zlib.decompress(content, -zlib.MAX_WBITS)

return content

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)

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里各种类型的加密密码更新都是易事了

freeswitch http https ws wss nginx domain default port config

现代H5浏览器产业链越来越丰富，http+websocket+webrtc+sip组合已经是一种非常成熟的web原生音视频通讯解决方案

FreeSWITCH是一个开源的电话软交换平台，早在SIP年代就非常有名，自从支持WebSocket传输sip信令后与Web结合玩法多了许多

WebRTC提供了音视频通讯的核心技术，包括音视频的采集、编解码、网络传输、显示等功能，并且还支持跨平台，但就是没有信令协议部分

Chrome、Firefox等浏览器为了从保护用户隐私绝对安全角度考虑，纷纷提高了Web原生应用访问摄像头、麦克风的门槛：如不是用https、wss安全协议则会有各种警告及确认甚至直接拒绝

WS、WSS其实就是HTTP、HTTPS的WebSocket协议名称，其使用方式及默认端口都完全一致

综上所述，如果都用同一个域名地址承载web sip相关服务方便用户使用，就需要在nginx上做一些优雅的配置

map $http_upgrade $connection_upgrade {
    default upgrade;
    ''      close;
}

server {
    listen       80;
    listen       443 ssl;
    root         /var/www/sip;

    proxy_read_timeout 3600;
    proxy_http_version 1.1;
    proxy_set_header Upgrade $http_upgrade;
    proxy_set_header Connection $connection_upgrade;

    location / {
        if ($scheme = 'http') {
            set $ws_port 5066;
        }
        if ($scheme = 'https') {
            set $ws_port 7443;
        }
        if ($http_upgrade = 'websocket') {
            proxy_pass    $scheme://$server_addr:$ws_port;
        }
    }
}

map $http_upgrade $connection_upgrade {

default upgrade;

'' close;

}

server {

listen 80;

listen 443 ssl;

root /var/www/sip;

proxy_read_timeout 3600;

proxy_http_version 1.1;

proxy_set_header Upgrade $http_upgrade;

proxy_set_header Connection $connection_upgrade;

location / {

if ($scheme = 'http') {

set $ws_port 5066;

}

if ($scheme = 'https') {

set $ws_port 7443;

}

if ($http_upgrade = 'websocket') {

proxy_pass $scheme://$server_addr:$ws_port;

}

其对应freeswitch相关端口配置片断如下

<!-- Internal SIP Profile -->
<X-PRE-PROCESS cmd="set" data="internal_sip_port=5060"/>
<!-- RTP port range -->
<param name="rtp-start-port" value="16384"/>
<param name="rtp-end-port" value="32768"/>
<!-- for sip over websocket support -->
<param name="ws-binding"  value=":5066"/>
<!-- for sip over secure websocket support -->
<param name="wss-binding" value=":7443"/>

<X-PRE-PROCESS cmd="set" data="internal_sip_port=5060"/>

注：
sip和rtp端口不经nginx直连，但需要防火墙做相应的白名单
ws5066端口和wss7443端口间接通过nginx的http端口和https端口反向代理提供服务
nginx默认的http80端口和https443端口又用来提供webrtc前端相关资源访问

阿里云ecs部署freeswitch默认event socket listen port 8021 ipv6问题

阿里云ecs服务器目前还不支持ipv6
freeswitch默认event_socket模块配置
/etc/freeswitch/autoload_configs/event_socket.conf.xml

<configuration name="event_socket.conf" description="Socket Client">
  <settings>
    <param name="nat-map" value="false"/>
    <param name="listen-ip" value="::"/>
    <param name="listen-port" value="8021"/>
    <param name="password" value="ClueCon"/>
    <!--<param name="apply-inbound-acl" value="loopback.auto"/>-->
    <!--<param name="stop-on-bind-error" value="true"/>-->
  </settings>
</configuration>

</settings>

</configuration>

里的<param name=”listen-ip” value=”::”/>是ipv6地址的表现形式，其等同于ipv4的0.0.0.0
这就造成服务启动后，由于无法绑定ipv6地址，也就不能通过fs_cli命令行进行控制台管理了
这就解释了同样的配置在本机一切正常，部署到阿里云上就无法管理

知道原理解决起来就简单了，将listen-ip的value根据实际需要改成127.0.0.1、0.0.0.0或内外网卡的ipv4地址即可