'Transaction.id', 'formatter' => 'id'); $cols['Entry'] = array('index' => 'LedgerEntry.id', 'formatter' => 'id'); $cols['Date'] = array('index' => 'Transaction.stamp', 'formatter' => 'date'); $cols['Account'] = array('index' => 'Account.name', 'formatter' => 'name'); $cols['Cr/Dr'] = array('index' => 'LedgerEntry.crdr', 'formatter' => 'enum'); $cols['Tender'] = array('index' => 'Tender.name', 'formatter' => 'longname'); $cols['Comment'] = array('index' => 'LedgerEntry.comment', 'formatter' => 'comment', 'width'=>150); $cols['Amount'] = array('index' => 'LedgerEntry.amount', 'formatter' => 'currency'); $cols['Debit'] = array('index' => 'debit', 'formatter' => 'currency'); $cols['Credit'] = array('index' => 'credit', 'formatter' => 'currency'); $cols['Balance'] = array('index' => 'balance', 'formatter' => 'currency'); $cols['Sub-Total'] = array('index' => 'subtotal-balance', 'formatter' => 'currency', 'sortable' => false); // Render the grid $grid ->columns($cols) ->sortField('Date', 'DESC') ->defaultFields(array('Entry', 'Date', 'Amount')) ->searchFields(array('Customer', 'Unit')) ->render($this, isset($config) ? $config : null, array_diff(array_keys($cols), array('Transaction', 'Debit', 'Credit', 'Balance', 'Sub-Total', 'Comment')));