最近在做业务的时候有一个这样的需求，客户选择了某一个m2m值的时候可以填写相应的字段，若未选则不显示。
参考资料：Changing attrs based on an empty many2many relation
<group>
<field name="power_ids" widget="many2many_tags"/>
<field name="power_char" attrs="{'invisible':[('power_ids','not in', [(6, False, [1])])]}"/>
</group><record id="purchase_order_tree" model="ir.ui.view">
<field name="name">purchase.order.tree</field>
<field name="model">purchase.order</field>
<field name="arch" type="xml">
<tree decoration-bf="message_unread==True" decoration-muted="state=='cancel'" decoration-info="state in ('wait','confirmed')" string="Purchase Order">
<field name="message_unread" invisible="1"/>
<field name="name" string="Reference"/>
<field name="date_order" />
<field name="partner_id"/>
<field name="company_id" groups="base.group_multi_company" options="{'no_create': True}"/>
<field name="date_planned" invisible="context.get('quotation_only', False)"/>
<field name="origin"/>
<field name="amount_untaxed" sum="Total Untaxed amount" string="Untaxed" widget="monetary"/>
<field name="amount_total" sum="Total amount" widget="monetary"/>
<field name="currency_id" invisible="1"/>
<field name="state"/>
<field name="invoice_status" invisible="not context.get('show_purchase', True)"/>
</tree>
</field>
</record>color值为0~9
<li><ul class="oe_kanban_colorpicker" data-field="color"/></li><record id="view_forum_post_kanban" model="ir.ui.view">
<field name="name">forum.post.kanban</field>
<field name="model">forum.post</field>
<field name="arch" type="xml">
<kanban default_group_by="documentation_stage_id" >
<field name="documentation_stage_id"/>
<field name="create_uid"/>
<field name="color"/>
<templates>
<t t-name="kanban-box">
<div t-attf-class="oe_kanban_color_#{kanban_getcolor(record.color.raw_value)} oe_kanban_card oe_kanban_global_click">
<div class="o_dropdown_kanban dropdown" groups="base.group_user">
<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
<li t-if="widget.editable"><a type="edit">Edit Post</a></li>
<li t-if="widget.deletable"><a type="delete">Delete</a></li>
<li><ul class="oe_kanban_colorpicker" data-field="color"/></li>
</ul>
</div>
</div>
</t>
</templates>
</kanban>
</field>
</record>值范围：1~12
<field name="about_place_route" widget="many2many_tags" options="{'color_field': 'color', 'no_open':True,'no_create':1,'no_create_edit':1}" />
最后在写一个项目，数据源自NC接口，需要将NC接口返回的数据处理后导入Sqlite数据库。
在实际操作中需要直接写入Datatable的对象进数据库，或直接将一行数据库写入数据，但每次构建SQL这些太麻烦。因此才有了这样一个处理类。
/// <summary>
/// 根据DataTable构建插入语句
/// </summary>
/// <param name="dataTable"></param>
/// <returns></returns>
public static string builderSql(DataTable dataTable)
{
StringBuilder sb = new StringBuilder("insert into "+ dataTable.TableName + "(");
StringBuilder head = new StringBuilder();
StringBuilder values = new StringBuilder();
foreach (DataColumn col in dataTable.Columns)
{
head.Append(col.ColumnName + ",");
values.Append("@" + col.ColumnName + ",");
}
head.Remove(head.Length - 1, 1);
values.Remove(values.Length - 1, 1);
sb.Append(head).Append(") VALUES (").Append(values).Append(");");
sb.Append("select last_insert_rowid();");
return sb.ToString();
}
/// <summary>
/// 插入行
/// </summary>
/// <param name="row"></param>
/// <returns>数据库ID</returns>
public static int InsertDataRow(DataRow row)
{
using (SQLiteConnection connection = new SQLiteConnection(connectionString))
{
using (SQLiteCommand cmd = new SQLiteCommand())
{
try
{
string SQLString = builderSql(row.Table);
List<SQLiteParameter> sqlitePars = new List<SQLiteParameter>();
foreach (DataColumn col in row.Table.Columns)
{
SQLiteParameter pars = new SQLiteParameter();
pars.ParameterName = string.Format("@{0}", col.ColumnName);
pars.Value = row[col.ColumnName];
pars.DbType = GetDbType(col.DataType);
sqlitePars.Add(pars);
}
PrepareCommand(cmd, connection, null, SQLString, sqlitePars.ToArray());
int rows = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Parameters.Clear();
return rows;
}
catch (System.Data.SQLite.SQLiteException sqlex)
{
throw sqlex;
}
}
}
}
/// <summary>
/// 批量插入
/// </summary>
/// <param name="dataTable">需插入数据库的表</param>
/// <param name="DataBaseName">数据库名称</param>
/// <returns></returns>
public static void InsertDataTable(DataTable dataTable)
{
using (SQLiteConnection conn = new SQLiteConnection(connectionString))
{
conn.Open();
using (SQLiteTransaction trans = conn.BeginTransaction())
{
SQLiteCommand cmd = new SQLiteCommand();
try
{
// 构建插入语句
string cmdText = builderSql(dataTable);
//循环
foreach (DataRow row in dataTable.Rows)
{
string BaseName = dataTable.TableName;
// 构建插入值
List<SQLiteParameter> sqlitePars = new List<SQLiteParameter>();
foreach (DataColumn col in dataTable.Columns)
{
SQLiteParameter pars = new SQLiteParameter();
pars.ParameterName = string.Format("@{0}", col.ColumnName);
pars.Value = row[col.ColumnName];
pars.DbType = GetDbType(col.DataType);
sqlitePars.Add(pars);
}
PrepareCommand(cmd, conn, trans, cmdText, sqlitePars.ToArray());
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
}private static Dictionary typeMap;
#region 类型对应
static SQLite()
{
typeMap = new Dictionary();
typeMap[typeof(string)] = DbType.String;
typeMap[typeof(byte)] = DbType.Byte;
typeMap[typeof(int)] = DbType.Int32;
typeMap[typeof(Int16)] = DbType.Int16;
typeMap[typeof(Int32)] = DbType.Int32;
typeMap[typeof(Int64)] = DbType.Int64;
typeMap[typeof(DateTime)] = DbType.DateTime;
typeMap[typeof(decimal)] = DbType.Decimal;
typeMap[typeof(float)] = DbType.Double;
typeMap[typeof(double)] = DbType.Double;
}
public static DbType GetDbType(Type giveType)
{
giveType = Nullable.GetUnderlyingType(giveType) ?? giveType;
if (typeMap.ContainsKey(giveType))
{
return typeMap[giveType];
}
throw new ArgumentException(string.Format("{0} is not a supported .NET class", giveType.FullName));
}
public static DbType GetDbType()
{
return GetDbType(typeof(T));
}
#endregion参考链接：QWeb Reports
<report
id="budget_report"
model="budget.budget"
report_type="qweb-pdf"
string="Budget Report"
name="contract_manager.budget_report_template"
file="contract_manager.budget_report_template"
paperformat="budget_print_format"
menu="True"
/>
参考链接：Paper Format
<record id="budget_print_format" model="report.paperformat">
<field name="name">Budget Print format</field>
<field name="format">A4</field>
<field name="orientation">Landscape</field> <!--方向-->
<field name="margin_top">3</field>
<field name="margin_bottom">3</field>
<field name="margin_left">3</field>
<field name="margin_right">3</field>
<field name="header_line" eval="False" />
<field name="header_spacing">3</field>
<field name="dpi">90</field>
</record>
<template id="report_invoice">
<t t-call="report.html_container">
<t t-foreach="docs" t-as="o">
<t t-call="report.external_layout">
<div class="page">
<h2>Report title</h2>
<p>This object's name is <span t-field="o.name"/></p>
</div>
</t>
</t>
</t>
</template>调用report.external_layout将在报告上添加默认的页眉和页脚，正文将是其中的<div class="page">
报告中可以访问的一些特定变量，主要是：
使用自定义报告需要具有一个默认的 get_html 函数，如果你希望在模板中包含更多的内容（例如，其他模型记录）来自定义报告，则可以定义此模型，覆盖函数并在字典中传递对象： report.module.report_name render_html docargs
from odoo import api, models
class ParticularReport(models.AbstractModel):
_name = 'report.module.report_name'
@api.model
def render_html(self, docids, data=None):
report_obj = self.env['report']
report = report_obj._get_report_from_name('module.report_name')
docargs = {
'doc_ids': docids,
'doc_model': report.model,
'docs': self,
}
return report_obj.render('module.report_name', docargs)恢复Odoo数据抛出错误导致无法进入页面
2018-06-14 08:26:09,705 30127 INFO yszs odoo.addons.base.ir.ir_attachment: _read_file reading /var/lib/odoo/filestore/yszs/98/9809d6d03b894abb232008e691e68e8d34a2fb71
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/odoo/addons/base/ir/ir_attachment.py", line 100, in _file_read
r = open(full_path,'rb').read().encode('base64')
IOError: [Errno 2] No such file or directory: u'/var/lib/odoo/filestore/yszs/98/9809d6d03b894abb232008e691e68e8d34a2fb71'
解决方法
select *
from ir_attachment
where url LIKE '/web/content/%';
DELETE FROM ir_attachment
WHERE url LIKE '/web/content/%';重启Odoo服务
经常需要将开发的项目部署到测试服务器上以便客户可以看到，但之前都是安装环境这样的方式，不适合快速搭建。
yum install -y docker docker-compose
systemctl enable docker # 开机自动启动docker
systemctl start docker # 启动docker
systemctl restart docker # 重启dokcer
systemctl stop docker
# 验证docker是否安装成功
docker run --rm hello-world阿里云：https://cr.console.aliyun.com/#/accelerator
sudo mkdir -p /etc/docker
sudo tee /etc/docker/daemon.json <<-'EOF'
{
"registry-mirrors": ["https://wkumpv63.mirror.aliyuncs.com"]
}
EOF
sudo systemctl daemon-reload
sudo systemctl restart docker
version: '3'
services:
web:
image: odoo:12.0
container_name: odoo
depends_on:
- db
ports:
- "8069:8069"
networks:
- "odoonetwork"
volumes:
- odoo-web-data:/var/lib/odoo
- ./config:/etc/odoo
- ./addons:/mnt/extra-addons
web_odoo:
image: odoo:10.0
container_name: odoo10
depends_on:
- db
ports:
- "8010:8069"
networks:
- "odoonetwork"
volumes:
- odoo10-web-data:/var/lib/odoo
- ./config10:/etc/odoo
- ./addons10:/mnt/extra-addons
web_odoo11:
image: odoo:11.0
container_name: odoo11
depends_on:
- db
ports:
- "8011:8069"
networks:
- "odoonetwork"
volumes:
- odoo11-web-data:/var/lib/odoo
- ./config11:/etc/odoo
- ./addons11:/mnt/extra-addons
db:
image: postgres:10
container_name: pgsql
ports:
- "5432:5432"
networks:
- "odoonetwork"
environment:
- POSTGRES_DB=postgres
- POSTGRES_PASSWORD=odoo
- POSTGRES_USER=odoo
- PGDATA=/var/lib/postgresql/data/pgdata
volumes:
- odoo-db-data:/var/lib/postgresql/data/pgdata
jenkins:
restart: always
image: jenkins/jenkins:lts
container_name: jenkins
ports:
- "8080:8080"
- "50000:50000"
networks:
- "odoonetwork"
volumes:
- ./data:/var/jenkins_home
networks:
odoonetwork:
driver: bridge
volumes:
odoo-web-data:
odoo-db-data:
odoo10-web-data:
odoo11-web-data:配置文件可以从这里找到相应的版本：https://github.com/odoo/docker/tree/master/12.0
路径：addons/odoo.conf
[options]
addons_path = /mnt/extra-addons,/usr/lib/python2.7/dist-packages/odoo/addons
;data_dir = /var/lib/odoo
admin_passwd = admin
csv_internal_sep = ,
db_maxconn = 64
db_name = False
db_template = template1
dbfilter = .*
debug_mode = False
email_from = False
limit_memory_hard = 2684354560
limit_memory_soft = 2147483648
limit_request = 8192
limit_time_cpu = 60
limit_time_real = 120
list_db = True
log_db = False
log_handler = [':INFO']
log_level = info
logfile = None
longpolling_port = 8072
max_cron_threads = 2
osv_memory_age_limit = 1.0
osv_memory_count_limit = False
smtp_password = False
smtp_port = 25
smtp_server = localhost
smtp_ssl = False
smtp_user = False
workers = 0
xmlrpc = True
xmlrpc_interface =
xmlrpc_port = 8069
xmlrpcs = True
xmlrpcs_interface =
xmlrpcs_port = 8071docker-compose up -d
docker-compose stop
# 停止某一个容器
docker ps -a # 查看当前所有容器
docker stop <CONTAINER ID or NAMES>
docker start <CONTAINER ID or NAMES>
docker restart <CONTAINER ID or NAMES>docker仓库：https://hub.docker.com/_/postgres/
docker exec -tiu postgres <postgres_container_name> psql
docker exec -ti <postgres_container_name> psql -U <postgres_user>
# 推荐使用如下方式，它不会干扰主容器
docker run -it --link <postgres_container_name>:postgres --rm postgres sh -c 'exec psql -h "$POSTGRES_PORT_5432_TCP_ADDR" -p "$POSTGRES_PORT_5432_TCP_PORT" -U <postgres_user>'
# 备份\删除数据库\恢复
# To backup
docker exec -u <your_postgres_user> <postgres_container_name> pg_dump -Fc <database_name_here> > db.dump
# To drop db
docker exec -u <your_postgres_user> <postgres_container_name> psql -c 'DROP DATABASE <your_db_name>'
# To restore
docker exec -i -u <your_postgres_user> <postgres_container_name> pg_restore -C -d postgres < db.dump# 进入odoo容器
docker exec -u 0 -it 28854cf96877 bash
# 安装依赖
pip install xmltodict服务器的默认配置文件位于（/etc/odoo/odoo.conf），若你有一个自定义的配置文件位于（/path/to/config/odoo.conf)，那么你的运行命令就该是如下这样。
docker run -v /path/to/config:/etc/odoo -p 8069:8069 --name odoo --link db:db -t odoo
当然，你也可以直接指定内联的Odoo参数，这些参数必须在前面加上 --，如下所示：
docker run -p 8069:8069 --name odoo --link db:db -t odoo --db-filter=odoo_db_.*
当然，运行Odoo，大部分时候是需要运行我们自己开发的模块，在docker中运行的时候，我们可以使用如下方式将其加载。
docker run -v /path/to/addons:/mnt/extra-addons -p 8069:8069 --name odoo --link db:db -t odoo
升级docker版本
docker run --volumes-from old-odoo -p 8070:8069 --name new-odoo --link db:db -t odoo
firewall-cmd --zone=public --add-port=8069/tcp --permanent
firewall-cmd --reload# 查看容器信息
docker info
# 查看镜像列表
docker images
# 启动、停止
docker stop <id/container_name>
docker start <id/container_name>
docker kill <id/container_name>
# 查看正在运行的容器
docker ps -a
# 查看容器日志
docker logs <id/container_name>
# 实时查看日志输出
docker logs -f <id/container_name> (类似 tail -f) (带上时间戳-t）
# 启动容器以后台方式运行(更通用的方式）
docker run -d -it image_name
# 显示一个运行的容器里面的进程信息
docker top Name/ID
# 移除镜像
docker stop <id/container_name>
docker rm <id/container_name>
# 完全删除镜像
docker rmi <id>
# 制作镜像(根据容器id来创建新的镜像
docker commit 93639a83a38e wsl/javaweb:0.1