Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kế toán
Tồn kho
PoS
Dự án
MRP

All apps

Tất cả bài viết Người Huy hiệu

Thẻ (Xem tất cả)

odoo accounting v14 pos v15

Về diễn đàn này

Hỗ trợ

Target all element td with xpath in qweb view

views qweb report xpath wkhtmltopdf

13 Trả lời

34079 Lượt xem

Youri Lebarch

Hello,

I try to add condition in all td element of first table in report sale_order. For this i use xpath.
But, just the first td element is targeting. Why ? It's bug ? This error come to qweb ? wkhtmltopdf ?
My code

<template id="report_so_no_print_lines" inherit_id="sale.report_saleorder_document">

	<xpath expr="//table[1]/tbody/tr/td" position="attributes">	

		<attribute name="t-if">l.product_id.product_tmpl_id.no_print_in_invoice != True</attribute>

	</xpath> 

</template>

I try with other element, other position for test and with this code :

<xpath expr="//span" position="replace">	

				<span>COUCOU</span>

</xpath>

And I've the same problem, just the first element span is replace.
Please, can you help me ?

Temur

Câu trả lời hay nhất

Add brackets () at the end, it means All Elements... otherwise it matches the first element, it's expected behavior, not an error.

for all span, your example will become:

<xpath expr="//span()" position="replace">	

				<span>COUCOU</span>

</xpath>

Youri Lebarch

Tác giả

Doesn't work, i have a parse error : ParseError: "ValidateError Field(s) `arch` failed against a constraint: Invalid view definition

Temur

You tried for span?

Youri Lebarch

Tác giả

For //span and for //table[1]/tbody/tr/td And i've this error

Temur

and for expr="//table[1]/tbody/tr::td()" ? I never tried it in Odoo, but in Xpath "//node()" should select all "node"-s. I do not know why you get that error.

Youri Lebarch

Tác giả

Thanks for your responses, but it doesn't work too :( I think odoo's parser has little problem.

TKF

Hello dark,

I adapted your xpath's expression to "//table[1]/tbody/t/tr/td", because my template is :

template id="report_saleorder_document">
<t t-call="report.external_layout">
<t t-set="doc" t-value="doc.with_context({'lang':doc.partner_id.lang})" />
<div class="page">
<div class="oe_structure"/>
<div class="row">
<div class="col-xs-6">
<strong t-if="doc.partner_shipping_id == doc.partner_invoice_id">Invoicing and shipping address:</strong>
<strong t-if="doc.partner_shipping_id != doc.partner_invoice_id">Invoicing address:</strong>
<div t-field="doc.partner_invoice_id"
t-field-options='{"widget": "contact", "fields": ["address", "name", "phone", "fax"], "no_marker": true, "phone_icons": true}'/>
<p t-if="doc.partner_id.vat">VAT: <span t-field="doc.partner_id.vat"/></p>
<div t-if="doc.partner_shipping_id != doc.partner_invoice_id" class="mt8">
<strong>Shipping address:</strong>
<div t-field="doc.partner_shipping_id"
t-field-options='{"widget": "contact", "fields": ["address", "name", "phone", "fax"], "no_marker": true, "phone_icons": true}'/>
<p t-if="doc.partner_id.vat">VAT: <span t-field="doc.partner_id.vat"/></p>
</div>
</div>
<div class="col-xs-5 col-xs-offset-1">
<div t-field="doc.partner_id"
t-field-options='{"widget": "contact", "fields": ["address", "name"], "no_marker": true}' />
</div>
</div>

<h2>
<span t-if="doc.state not in ['draft','sent']">Order # </span>
<span t-if="doc.state in ['draft','sent']">Quotation # </span>
<span t-field="doc.name"/>
</h2>

<div class="row mt32 mb32" id="informations">
<div t-if="doc.client_order_ref" class="col-xs-3">
<strong>Your Reference:</strong>
<p t-field="doc.client_order_ref"/>
</div>
<div t-if="doc.date_order" class="col-xs-3">
<strong t-if="doc.state not in ['draft','sent']">Date Ordered:</strong>
<strong t-if="doc.state in ['draft','sent']">Quotation Date:</strong>
<p t-field="doc.date_order"/>
</div>
<div t-if="doc.user_id.name" class="col-xs-3">
<strong>Salesperson:</strong>
<p t-field="doc.user_id"/>
</div>
<div name="payment_term" t-if="doc.payment_term_id" class="col-xs-3">
<strong>Payment Term:</strong>
<p t-field="doc.payment_term_id"/>
</div>
</div>


<t t-set="display_discount" t-value="any([l.discount for l in doc.order_line])"/>

<table class="table table-condensed">
<thead>
<tr>
<th>Description</th>
<th class="text-right">Quantity</th>
<th class="text-right">Unit Price</th>
<th t-if="display_discount" class="text-right" groups="sale.group_discount_per_so_line">Disc.(%)</th>
<th class="text-right">Taxes</th>
<th class="text-right">Price</th>
</tr>
</thead>
<tbody class="sale_tbody">
<t t-foreach="doc.order_line" t-as="l">
<tr t-if="l.product_uom_qty">
<td>
<span t-field="l.name"/>
</td>
<td class="text-right">
<span t-field="l.product_uom_qty"/>
<span groups="product.group_uom" t-field="l.product_uom"/>
</td>
<td class="text-right">
<span t-field="l.price_unit"/>
</td>
<td t-if="display_discount" class="text-right" groups="sale.group_discount_per_so_line">
<span t-field="l.discount"/>
</td>
<td class="text-right">
<span t-esc="', '.join(map(lambda x: (x.description or x.name), l.tax_id))"/>
</td>
<td class="text-right">
<span t-field="l.price_subtotal"
t-field-options='{"widget": "monetary", "display_currency": "doc.pricelist_id.currency_id"}'/>
</td>
</tr>
</t>
</tbody>
</table>

<div class="row" name="total">
<div class="col-xs-4 pull-right">
<table class="table table-condensed">
<tr class="border-black">
<td><strong>Total Without Taxes</strong></td>
<td class="text-right">
<span t-field="doc.amount_untaxed"
t-field-options='{"widget": "monetary", "display_currency": "doc.pricelist_id.currency_id"}'/>
</td>
</tr>
<tr>
<td>Taxes</td>
<td class="text-right">
<span t-field="doc.amount_tax"
t-field-options='{"widget": "monetary", "display_currency": "doc.pricelist_id.currency_id"}'/>
</td>
</tr>
<tr class="border-black">
<td><strong>Total</strong></td>
<td class="text-right">
<span t-field="doc.amount_total"
t-field-options='{"widget": "monetary", "display_currency": "doc.pricelist_id.currency_id"}'/>
</td>
</tr>
</table>
</div>
</div>

<p t-field="doc.note" />
<p t-if="doc.payment_term_id.note">
<span t-field="doc.payment_term_id.note"/>
</p>
<p t-if="not doc.payment_term_id and doc.partner_id.property_payment_term_id">
<span t-field="doc.partner_id.property_payment_term_id.note"/>
</p>
<p id="fiscal_position_remark" t-if="doc.fiscal_position_id and doc.fiscal_position_id.note">
<strong>Fiscal Position Remark:</strong>
<span t-field="doc.fiscal_position_id.note"/>
</p>
<div class="oe_structure"/>
</div>
</t>
</template>

And I got the first too. But when I try on "online xpath tester", like : www.codebeautify.org/Xpath-Tester

I have what you wanted:

So my conclusion is that there is a bug.

Akhil P Sivan

Hi,

Your code target only the first element and its not an error. A possible solution, please try:

<template id="report_so_no_print_lines" inherit_id="sale.report_saleorder_document">
      <xpath expr="//table[1]/tbody/tr" position="replace">	
		<tr t-foreach="o.order_line" t-as="l">
			<t t-if="l.product_id.product_tmpl_id.no_print_in_invoice != True">
	                        <td>
	                           <span t-field="l.name"/>
	                        </td>
	                        <td>
	                            <span t-esc="', '.join(map(lambda x: x.name, l.tax_id))"/>
	                        </td>
	                        <td class="text-right">
	                            <span t-field="l.product_uom_qty"/>
	                            <span groups="product.group_uom" t-field="l.product_uom"/>
	                        </td>
	                        <td class="text-right">
	                            <span t-field="l.price_unit"/>
	                        </td>
	                        <td groups="sale.group_discount_per_so_line">
	                            <span t-field="l.discount"/>
	                        </td>
	                        <td class="text-right">
	                            <span t-field="l.price_subtotal"
	                                t-field-options='{"widget": "monetary", "display_currency": "o.pricelist_id.currency_id"}'/>
	                        </td>
                        </t>
                    </tr>
	</xpath> 
 </template>

Youri Lebarch

Tác giả

Thank for your response but i try to generalize this fonctionality for all my project which have different sale.order report. So if you have an idea to put this element after

element but before first , i take ! ;)

Youri Lebarch

Tác giả

*So if you have an idea to put this element t after element tr but before first td element, i take ! ;)

Akhil P Sivan

Sorry dark, I didn't get you. You want to check that same condition on each column? You just tell me what exactly you need, I can help you to solve it.

Youri Lebarch

Tác giả

I want to hide a line of sale.order.line when user print report if product in this line is mark as hide in print (just checkbox in product form). I can't put condition in tr element because they are iteration. So i want to check that condition in each column, yes.

Akhil P Sivan

Means if you check "hide in print" on product form, then that product should not appear in sale order lines on the report right? Did you check report with the above code? As the condition is same and applicable to an entire line or row, I didn't put the condition on each column. If you need I can put the condition in each column, but before that please check with the above code.

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!

Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!

Đăng ký

Bài viết liên quan	Trả lời	Lượt xem
Xpath problems...Help me write this xpath views qweb xpath	1 thg 8 24	3257
external_layout_header's fixed space can not be changed in PDF qweb report xpath	2 thg 2 24	8340
Report text and header is overlaps when description is too long in QWeb report line. qweb report wkhtmltopdf	1 thg 2 24	3999
How to add custom footer in invoice Qweb printouts of Odoo? Đã xử lý qweb report wkhtmltopdf odoo	4 thg 10 24	54634
Odoo 11 Qweb Report: xpath tag "replace" not replacing? qweb report xpath odoo11	1 thg 2 18	10409

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!