private function invoicesGrid()
{
$request = Zend_Controller_Front::getInstance()->getRequest();
if (isset($request->id) && is_numeric($request->id)) {
$fields = "invoice_id, \n\t\t\t\tDATE_FORMAT(i.invoice_date, '%d/%m/%Y') as invoice_date, \n\t\t\t\ti.formatted_number as invoice, \n\t\t\t\to.order_number as order, \n\t\t\t\to.total as total, \n\t\t\t\to.vat as vat,\n\t\t\t\to.grandtotal as grandtotal";
$rs = Invoices::getByCustomerID($request->id, $fields);
$columns[] = $this->translator->translate('Date');
$columns[] = $this->translator->translate('Invoice No.');
$columns[] = $this->translator->translate('Order No.');
$columns[] = $this->translator->translate('Total');
$columns[] = $this->translator->translate('VAT');
$columns[] = $this->translator->translate('Grand Total');
return array('name' => 'invoices', 'columns' => $columns, 'records' => $rs, 'edit' => array('controller' => 'invoices', 'action' => 'edit'), 'actions' => array('/admin/invoices/print/id/' => $this->translator->translate('Print')));
}
}
