Search code examples
javascriptnetsuite

advance pdf tempelate delete null or 0

I create an Advanced PDF/HTML Template with the following script

<#list item.data_item as line>
    <tr>
    <td></td>
    <td colspan="3" rowspan="1"><span style="font-size:8px;"><span style="font-family:Arial,Helvetica,sans-serif;">${line.item}</span></span></td>
    <td style="width: 3px;"><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.rateCtnDev} / ${line.ratePcsDev}</span></span></td>
    <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.bonusBOnCtn} / ${line.bonusBOnPcs}</span></span></td>
    <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.price?number?string[",###"]}</span></span></td>
    <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.diskon1}</span></span></td>
    <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.diskon2}</span></span></td>
    <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.diskon3?number?string[",###"]}</span></span></td>
    <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.diskon4}</span></span></td>
    <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.diskon5}</span></span></td>
    <td colspan="2" rowspan="1"><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.subTotNew?number?string[",###"]}</span></span></td>
    <td>&nbsp;</td>
    <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.sisaCtnMod} / ${line.sisaPcsMod} </span></span></td>
    <td style="width: 39px;">&nbsp;</td>
    <td style="width: 41px;">&nbsp;</td>
    <td>&nbsp;</td>
    </tr>

after that a result like this will appear enter image description here

there is 1 row which is an empty item (null) when typing <#if line.subTotNew != 0> then, the result will delete the line item. how to delete only 1 empty row line (null)

Solution

  • Here's updated code in your script to delete only 1 empty row ilne (null): -

    <#list item.data_item as line>
  <#if line.item?has_content> <!-- Check if item is not null or empty -->
    <tr>
      <td></td>
      <td colspan="3" rowspan="1"><span style="font-size:8px;"><span style="font-family:Arial,Helvetica,sans-serif;">${line.item}</span></span></td>
      <td style="width: 3px;"><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.rateCtnDev} / ${line.ratePcsDev}</span></span></td>
      <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.bonusBOnCtn} / ${line.bonusBOnPcs}</span></span></td>
      <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.price?number?string[",###"]}</span></span></td>
      <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.diskon1}</span></span></td>
      <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.diskon2}</span></span></td>
      <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.diskon3?number?string[",###"]}</span></span></td>
      <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.diskon4}</span></span></td>
      <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.diskon5}</span></span></td>
      <td colspan="2" rowspan="1"><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.subTotNew?number?string[",###"]}</span></span></td>
      <td>&nbsp;</td>
      <td><span style="font-family:Arial,Helvetica,sans-serif;"><span style="font-size:9px;">${line.sisaCtnMod} / ${line.sisaPcsMod} </span></span></td>
      <td style="width: 39px;">&nbsp;</td>
      <td style="width: 41px;">&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
  </#if>
</#list>