Add a "Show All" link as search criteria in Invoices module

_form.php

// File location: siwapp\apps\siwapp\modules\search\templates\_form.php

<ul class="filters">
  <li><?php echo __('Status');?>: </li>
  <li><?php echo filter_by_status(__('Opened'), Invoice::OPENED, $status = $form['status']->getValue()) ?> |</li>
  <li><?php echo filter_by_status(__('Closed'), Invoice::CLOSED, $status) ?> |</li>
  <li><?php echo filter_by_status(__('Overdue'), Invoice::OVERDUE, $status) ?> |</li>
  <li><?php echo filter_by_status(__('Drafts'), Invoice::DRAFT, $status) ?> |</li>
  <li><?php echo filter_by_status(__('Show All'), 99, $status) ?></li>
</ul>

CommonInvoiceQuery.class.php

<?php

public function status($status, $is = true)
{
  // $status = 99 to show all result, ignore filtering
  if($status !== null && $status != "" && (int)$status < 10)
  {
    $status = (array) $status;
    $statusString = implode(", ", (array) $status);
    if($is)
    {
      $this->andWhere(sprintf('i.status IN (%s)', $statusString));
    }
    else
    {
      $this->andWhere(sprintf('i.status NOT IN (%s)', $statusString));
    }
  }
      
  return $this;
}