Two languages in a invoice

Question

Hi there,

I would like to use two languages in one report (invoice). Not for every line, but only for the product name.

I know I have to use setLang but somehow I can't get it to work correctly. The whole report is made up in the language of the client [[ setLang(o.partner_id.lang) ]]. But we would like to have the name of the product in English and Chinese.

This is (a little part of) what I have till now.

<td>
  <para style="terp_default_9">[[ setLang('zh_CN') ]] [[ format(l.product_id.name) ]]</para>
</td>
<td>
  <para style="terp_default_9">[[ setLang('en_US') ]] [[ format(l.product_id.name) ]]</para>
</td>

I will send a big hug to the one who is able to help me ;-)

MacKan · Answer

def translation(self,name,lang=''zh_CN'',source_type=''):

if source_type:
query = "select value from ir_translation where lang='"+lang+"' and type='"+source_type+"' and src='"+name+"'"
else:
query = "select value from ir_translation where lang='"+lang+"' and src='"+name+"'"
cr = self.cr
cr.execute(str(query))
res_trans = cr.fetchone()
res = res_trans and res_trans[0] or name
return res

def __init__(self, cr, uid, name, context):

super(contract, self).__init__(cr, uid, name, context)
self.cr =

المنشورات ذات الصلة	الردود	أدوات العرض
Two languages in a invoice language invoice report chinese setlang	0 مارس 15	4389
[18.0] invoice report looks OK when previewing but fonts scaled up and sections overlap when printed تم الحل invoice report	2 يونيو 25	2249
Group Invoice Lines by Sales Order invoice report	4 مايو 24	6215
Issue with header & footer of the invoice invoice report	1 مايو 23	3994
Arabic translate of Reports shows ";gt & انه؛! دوكتيب هتمل &" at head/footer تم الحل language report	2 يناير 18	7804

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!