Dear @lasalesi thanks a million
it’s working fine
but i try to add space between to elements using <p dir="rtl" align="center"> </p> working fine in preview but not affected in pdf
You are welcome 
If the print format ignores stuff, sometimes it is due to some “!important” style overrides. However, to add vertical space, have you tried
<p><br></p>
Sorry @lasalesi
but there are another issue about font color only black color appear i using this code td><span style="color: #ff0000 !important;">
Sorry, I am unable to reproduce this…
Preview:
PDF:
You might have another issue in the code…
Thanks @lasalesi
it’s working using this code <p style="color:Tomato!important;">
but now i need to add Terms and condition section to my html code do you have any idea
thanks in advance
Dear @lasalesi
it’s solved by this code
<div class="row section-break">
<div class="col-xs-12 column-break">
<div style="padding: 10px 0px" data-fieldname="terms" data-fieldtype="Text Editor">
{{ doc.terms }}
</div>
</div>
the other issue is I need to get total of specific item group in summary code, for example, the total of items belongs to product group
if you have any idea about this
thanks in advance
1 Like
Hi @Alaa_Badri,
the optimal way would be to include this as a function somewhere. But, you can also do it directly from Jinja with a code block like this:
<!-- positions -->
<p></p>
<table style="width: 100%; ">
<tr>
<th style="width: 10%;">Pos</th>
<th style="width: 30%;">Beschreibung</th>
<th style="width: 20%;">Preis</th>
<th style="width: 20%;">Menge</th>
<th style="width: 20%;">Betrag</th>
</tr>
{% set group_total = {} %}
{% for n in doc.items %}
{% if group_total[n.item_group] is defined %}
{% if group_total.update({n.item_group: group_total[n.item_group] + n.amount}) %}{% endif %}
{% else %}
{% if group_total.update({n.item_group: n.amount}) %}{% endif %}
{% endif %}
<tr>
<td>{{ loop.index }}</td>
<td>{{ n.item_name}}</td>
<td>{{ n.get_formatted('price_list_rate') }}</td>
<td>{{ n.qty }} {{ n.stock_uom }}</td>
<td>{{ n.get_formatted('amount') }}</td>
</tr>
{% endfor %}
</table>
<!-- total per category -->
<table>
<tr><th>Category</th><th>Total</th></tr>
{% for key, value in group_total.iteritems() %}
<tr><td>{{ key }}</td><td>{{ value }}</td>
{% endfor %}
</table>
<!-- summary and taxes -->
<p></p>
<table style="width: 100%; ">
<tr>
<td style="width: 60%;"></td>
<td style="width: 20%;">
Summe netto<br />
{% for t in doc.taxes %}
{{ t.description }}<br />
{% endfor %}
{% if doc.discount_amount != 0 %}
Rabatt<br />
{% endif %}
<strong>Gesamtbetrag</strong>
</td>
<td style="width: 20%;">
{{ doc.get_formatted('total') }}<br />
{% for t in doc.taxes %}
{{ t.get_formatted('tax_amount') }}<br />
{% endfor %}
{% if doc.discount_amount != 0 %}
-{{ doc.get_formatted('discount_amount') }}<br />
{% endif %}
<strong>{{ doc.get_formatted('base_grand_total') }}</strong>
</td>
</tr>
</table>
1 Like
Dear @lasalesi
first i’m very appreciate your help thanks a lot for that
second if we can isolate every group of items category inside the item table by any break and i try to view item image but it’s not working i got the image file path inside the system ( /files/01700.jpg)
Hi @Alaa_Badri,
you are welcome
How do you mean isolate every group of items in the item table? If you want to sort for item group, you could build a logic that reads the item_groups (already in your code). Then loop through the item_groups and items and put the items that match the current group (from the group loop) into the table. Something like
{% for key, value in group_total.iteritems() %}
{% for n in doc.items %}
{% if n.item_group == key %}
<!-- add table row here -->
{% endif %}
{% endfor %}
<!-- add item_group total row here -->
{% endfor %}
If your images are not pulled, there might be different reasons. Check this
- is the image available (take a private browsing window and try to access the link without login) Images used for sales invoices should be “public”
- is the server able to access the resource (e.g. run
$ wget https://yourserver/files/1234.jpgend check if the files is received. This is required for the pdf generation. - if the above works, check the html syntax
Hope this helps.
1 Like
Dear @lasalesi
Thanks for your help
could you guide me how to update my code with your code you are suggested above
<!-- positions -->
<p></p>
<table style="width: 100%; float: left;" border="1">
<tr>
<th style="width: 30%;">Product</th>
<th style="width: 20%;">Module</th>
<th style="width: 20%;">QTY</th>
<th style="width: 20%;">VIS.</th>
<th style="width: 10%;">Brand</th>
</tr>
{% set group_total = {} %}
{% for n in doc.items %}
{% if group_total[n.item_group] is defined %}
{% if group_total.update({n.item_group: group_total[n.item_group] + n.amount}) %}{% endif %}
{% else %}
{% if group_total.update({n.item_group: n.amount}) %}{% endif %}
{% endif %}
<tr>
<td>{{ n.item_name}}</td>
<td>{{ n.get_formatted('item_group') }}</td>
<td>{{ n.qty }} {{ n.stock_uom }}</td>
<td><img src="{{ n.image }}" style="width: 60%"></td>
<td>{{ n.brand }}</td>
</tr>
{% endfor %}
</table>
<!-- total per category -->
<table>
<tr><th>Category</th><th>Total</th></tr>
{% for key, value in group_total.iteritems() %}
<tr><td>{{ key }}</td><td>{{ value }}</td>
{% endfor %}
</table>
<!-- summary and taxes -->
<p></p>
<table style="width: 100%; ">
<tr>
<td style="width: 60%;"></td>
<td style="width: 20%;">
Net Total<br />
{% for t in doc.taxes %}
{{ t.description }}<br />
{% endfor %}
{% if doc.discount_amount != 0 %}
Rabatt<br />
{% endif %}
<strong>Grand Total</strong>
</td>
<td style="width: 20%;">
{{ doc.get_formatted('total') }}<br />
{% for t in doc.taxes %}
{{ t.get_formatted('tax_amount') }}<br />
{% endfor %}
{% if doc.discount_amount != 0 %}
-{{ doc.get_formatted('discount_amount') }}<br />
{% endif %}
<strong>{{ doc.get_formatted('base_grand_total') }}</strong>
</td>
</tr>
</table>
Try this
<!-- positions -->
<p></p>
<table style="width: 100%; float: left;" border="1">
<tr>
<th style="width: 30%;">Product</th>
<th style="width: 20%;">Module</th>
<th style="width: 20%;">QTY</th>
<th style="width: 20%;">VIS.</th>
<th style="width: 10%;">Brand</th>
</tr>
<!-- prepare groups -->
{% set group_total = {} %}
{% for n in doc.items %}
{% if group_total[n.item_group] is defined %}
{% if group_total.update({n.item_group: group_total[n.item_group] + n.amount}) %}{% endif %}
{% else %}
{% if group_total.update({n.item_group: n.amount}) %}{% endif %}
{% endif %}
{% endfor %}
{% for key, value in group_total.iteritems() %}
{% for n in doc.items %}
<!-- add group items -->
{% if n.item_group == key %}
<tr>
<td>{{ n.item_name}}</td>
<td>{{ n.get_formatted('item_group') }}</td>
<td>{{ n.qty }} {{ n.stock_uom }}</td>
<td><img src="{{ n.image }}" style="width: 60%"></td>
<td>{{ n.brand }}</td>
</tr>
{% endif %}
{% endfor %}
<!-- total per group -->
<tr>
<td>Total</td>
<td>{{ key }}</td>
<td></td>
<td></td>
<td>{{ value }}</td>
</tr>
{% endfor %}
</table>
<!-- summary and taxes -->
<p></p>
<table style="width: 100%; ">
<tr>
<td style="width: 60%;"></td>
<td style="width: 20%;">
Net Total<br />
{% for t in doc.taxes %}
{{ t.description }}<br />
{% endfor %}
{% if doc.discount_amount != 0 %}
Rabatt<br />
{% endif %}
<strong>Grand Total</strong>
</td>
<td style="width: 20%;">
{{ doc.get_formatted('total') }}<br />
{% for t in doc.taxes %}
{{ t.get_formatted('tax_amount') }}<br />
{% endfor %}
{% if doc.discount_amount != 0 %}
-{{ doc.get_formatted('discount_amount') }}<br />
{% endif %}
<strong>{{ doc.get_formatted('base_grand_total') }}</strong>
</td>
</tr>
</table>
1 Like
Dear @lasalesi
thanks for your support
it’s a very good idea to add total for every item group but actually, I need to add something like page break after every item group may be like page break option in item table page
Thanks in advance
In that case, simply close the table, add the page break and then on the new page start a new table…
{% for n in doc.items %}
<table style="width: 100%; float: left;" border="1">
<tr>
<th style="width: 30%;">Product</th>
<th style="width: 20%;">Module</th>
<th style="width: 20%;">QTY</th>
<th style="width: 20%;">VIS.</th>
<th style="width: 10%;">Brand</th>
</tr>
<!-- add group items -->
{% if n.item_group == key %}
<tr>
(...)
<td>{{ value }}</td>
</tr>
</table>
<div class="page-break"></div>
{% endfor %}
1 Like
Dear @lasalesi
i try your suggestion but not working fine please find my code below
<!-- positions -->
<p></p>
<table style="width: 100%; float: left;" border="1">
<tr>
<th style="width: 30%;">Product</th>
<th style="width: 20%;">Module</th>
<th style="width: 20%;">QTY</th>
<th style="width: 20%;">VIS.</th>
<th style="width: 10%;">Brand</th>
</tr>
<!-- prepare groups -->
{% set group_total = {} %}
{% for n in doc.items %}
{% if group_total[n.item_group] is defined %}
{% if group_total.update({n.item_group: group_total[n.item_group] + n.amount}) %}{% endif %}
{% else %}
{% if group_total.update({n.item_group: n.amount}) %}{% endif %}
{% endif %}
{% endfor %}
{% for key, value in group_total.iteritems() %}
{% for n in doc.items %}
<!-- add group items -->
{% if n.item_group == key %}
<tr>
<td>{{ n.item_name}}</td>
<td>{{ n.get_formatted('item_group') }}</td>
<td>{{ n.qty }} {{ n.stock_uom }}</td>
<td><img src="{{ n.image }}" style="width: 60%"></td>
<td>{{ n.brand }}</td>
</tr>
</table>
<div class="page-break"></div>
{% endif %}
{% endfor %}
<!-- total per group -->
<tr>
<td>Total</td>
<td>{{ key }}</td>
<td></td>
<td></td>
<td>{{ value }}</td>
</tr>
{% endfor %}
</table>
<!-- summary and taxes -->
<p></p>
<table style="width: 100%; ">
<tr>
<td style="width: 60%;"></td>
<td style="width: 20%;">
Net Total<br />
{% for t in doc.taxes %}
{{ t.description }}<br />
{% endfor %}
{% if doc.discount_amount != 0 %}
Rabatt<br />
{% endif %}
<strong>Grand Total</strong>
</td>
<td style="width: 20%;">
{{ doc.get_formatted('total') }}<br />
{% for t in doc.taxes %}
{{ t.get_formatted('tax_amount') }}<br />
{% endfor %}
{% if doc.discount_amount != 0 %}
-{{ doc.get_formatted('discount_amount') }}<br />
{% endif %}
<strong>{{ doc.get_formatted('base_grand_total') }}</strong>
</td>
</tr>
</table>
Hi @Alaa_Badri,
your table definition has an extra </table> and the structure does not reflect what you want (I guess). Try this:
<!-- positions -->
<p></p>
<!-- prepare groups -->
{% set group_total = {} %}
{% for n in doc.items %}
{% if group_total[n.item_group] is defined %}
{% if group_total.update({n.item_group: group_total[n.item_group] + n.amount}) %}{% endif %}
{% else %}
{% if group_total.update({n.item_group: n.amount}) %}{% endif %}
{% endif %}
{% endfor %}
{% for key, value in group_total.iteritems() %}
<table style="width: 100%; float: left;" border="1">
<tr>
<th style="width: 30%;">Product</th>
<th style="width: 20%;">Module</th>
<th style="width: 20%;">QTY</th>
<th style="width: 20%;">VIS.</th>
<th style="width: 10%;">Brand</th>
</tr>
{% for n in doc.items %}
<!-- add group items -->
{% if n.item_group == key %}
<tr>
<td>{{ n.item_name}}</td>
<td>{{ n.get_formatted('item_group') }}</td>
<td>{{ n.qty }} {{ n.stock_uom }}</td>
<td><img src="{{ n.image }}" style="width: 60%"></td>
<td>{{ n.brand }}</td>
</tr>
{% endif %}
{% endfor %}
<!-- total per group -->
<tr>
<td>Total</td>
<td>{{ key }}</td>
<td></td>
<td></td>
<td>{{ value }}</td>
</tr>
</table>
<div class="page-break"></div>
{% endfor %}
1 Like
Dear @lasalesi
thanks for your support
the above code is generate extra table but wihout page break between them
Hi @Alaa_Badri,
you are indeed right. It reproduced on my system. And while I cannot give you a reason, this snippet will work 
(note only one additional line that adds a Jinja-induced line break; if you do it in plain html it will not work - really don’t know why)
<!-- positions -->
<p></p>
<!-- prepare groups -->
{% set group_total = {} %}
{% for n in doc.items %}
{% if group_total[n.item_group] is defined %}
{% if group_total.update({n.item_group: group_total[n.item_group] + n.amount}) %}{% endif %}
{% else %}
{% if group_total.update({n.item_group: n.amount}) %}{% endif %}
{% endif %}
{% endfor %}
{% for key, value in group_total.iteritems() %}
<table style="width: 100%; float: left;" border="1">
<tr>
<th style="width: 30%;">Product</th>
<th style="width: 20%;">Module</th>
<th style="width: 20%;">QTY</th>
<th style="width: 20%;">VIS.</th>
<th style="width: 10%;">Brand</th>
</tr>
{% for n in doc.items %}
<!-- add group items -->
{% if n.item_group == key %}
<tr>
<td>{{ n.item_name}}</td>
<td>{{ n.get_formatted('item_group') }}</td>
<td>{{ n.qty }} {{ n.stock_uom }}</td>
<td><img src="{{ n.image }}" style="width: 60%"></td>
<td>{{ n.brand }}</td>
</tr>
{% endif %}
{% endfor %}
<!-- total per group -->
<tr>
<td>Total</td>
<td>{{ key }}</td>
<td></td>
<td></td>
<td>{{ value }}</td>
</tr>
</table>
<p>{{ '<br>' }}</p>
<div class="page-break"></div>
{% endfor %}
2 Likes
Dear @lasalesi
I very appreciate your effort and support your code above it working well
now I try to add a paragraph after every table related to specific item group using below code but I think there is something wrong it’s not working
{% if item_group == 'Security' %}
<h3>| Security</h3>
{% else %}
<h3>| Not Security </h3>
{% endif %}
Note that the item group is an attribute of the loop instance n…
1 Like