/** * View existing invoices */ public function indexAction() { $invoicesTable = new Invoices(); $invoices = $invoicesTable->fetchAll(); if ($invoices) { foreach ($invoices as $i) { $customerData = $i->findParentRow('Customers'); $lineItems = $i->findDependentRowset('InvoiceDetails'); $subtotals = $i->findDependentRowset('InvoiceSubtotals')->current(); $invoiceData[] = array_merge($i->toArray(), $customerData->toArray(), $lineItems->toArray(), $subtotals->toArray()); } } $this->view->invoices = $invoiceData; }