{% if pagination == 'emptyfilters' %}
  <table class="table table-condensed" >
    <tr>
      <td style="text-align:center;padding:50px 0 50px 0">Please select from the above filters to generate a report.</td>
    </tr>
  </table>
{% elseif pagination is empty %}
  <table class="table table-condensed" >
    <tr>
      <td style="text-align:center;padding:50px 0 50px 0">There are currently no records to show</td>
    </tr>
  </table>
{% else %}

  <table class="table table-condensed report_fixed_table">
    <thead>
	  {% if show_links %}
      <tr>
        <th>{{ knp_pagination_sortable(pagination, 'Date', 't.date')|raw }}</th>
        <th>{{ knp_pagination_sortable(pagination, 'Account No', 't.account_number')|raw }}</th>
        <th>{{ knp_pagination_sortable(pagination, 'Account', 't.account_name')|raw }}</th>
        <th>{{ knp_pagination_sortable(pagination, 'Invoice No', 't.invoice_number')|raw }}</th>
        <th>{{ knp_pagination_sortable(pagination, 'Description', 't.description')|raw }}</th>
        <th>Inventory</th>
        <th>Category</th>
        <th style="text-align:right">{{ knp_pagination_sortable(pagination, 'Amount', 't.total')|raw }}</th>
      </tr>
      {% else %}
        <th>Date</th>
        <th>Account No</th>
        <th>Account</th>
        <th>Invoice No</th>
        <th>Description</th>
        <th>Inventory</th>
        <th>Category</th>
        <th style="text-align:right">Amount</th>
      {% endif %}
    </thead>
    <tbody>
    {% set grand_total = 0 %}
    {% for entity in pagination %}
      <tr>
        <td>{{ entity.date|date('Y-m-d') }}</td>
        <td>
			{% if show_links %}
			<a href="{{ path('customer_account_edit', { 'id': entity.account_id }) }}" title="View Account">{{ entity.account_number | trim }}</a>
			{% else %}
			{{ entity.account_number | trim }}
			{% endif %}
		</td>
        <td>
			{% if show_links %}
			<a href="{{ path('customer_account_edit', { 'id': entity.account_id }) }}" title="View Account">{{ entity.account_name | trim }}</a>
			{% else %}
			{{ entity.account_name | trim }}
			{% endif %}
		</td>
        <td>
			{% if show_links %}
			<a href="{{ path('invoices_show', { 'id': entity.invoice_id }) }}" title="View Invoice">{{ entity.invoice_number | trim }}</a>
			{% else %}
			{{ entity.invoice_number | trim }}
			{% endif %}
		</td>
        <td>{{ entity.description | trim }}</td>
        <td>
          {% if ',' not in entity.category_item_ids %}
            {{ entity.category_item | trim}}
          {% else %}
            <span title="{{ entity.category_item | trim }}">Mixed <span class="info_icon_shift"><img width="16" src="{{ asset('bundles/d2billing/images/info-mini.png') }}" /></span></span>
          {% endif %}
        </td>
        <td>
          {% if ',' not in entity.category_ids %}
            {{ entity.category_description | trim}}
          {% else %}
            <span title="{{ entity.category_description | trim }}">Mixed <span class="info_icon_shift"><img width="16" src="{{ asset('bundles/d2billing/images/info-mini.png') }}" /></span></span>
          {% endif %}
        </td>
        <td style="text-align:right"><span{% if entity.total < 0 %} class="red"{% endif %}>{{ entity.total | number_format(2, '.', ' ') | trim('-') }}</span></td>
        {% set grand_total = grand_total + entity.total %}
      </tr>
    {% endfor %}
      <tr>
        <td colspan="6"></td>
        <td><b>Grand Total</b></td>
        <td style="text-align:right"><b><span{% if grand_total < 0 %} class="red"{% endif %}>{{ grand_total | number_format(2, '.', ' ') | trim('-') }}</span></b></td>
      </tr>
    </tbody>
  </table>
  <div class="navigation">
    {{ knp_pagination_render(pagination)|raw }}
  </div>
{% endif %}