'StatementEntry.id', 'formatter' => 'id'); $cols['Entry'] = array('index' => 'LedgerEntry.id', 'formatter' => 'id'); $cols['Date'] = array('index' => 'Transaction.stamp', 'formatter' => 'date'); //$cols['Type'] = array('index' => 'StatementEntry.type', 'formatter' => 'name'); $cols['Account'] = array('index' => 'Account.name', 'formatter' => 'longname'); //$cols['Comment'] = array('index' => 'StatementEntry.comment', 'formatter' => 'comment', 'width'=>150); //$cols['Amount'] = array('index' => 'StatementEntry.amount', 'formatter' => 'currency'); $cols['Charge'] = array('index' => 'charge', 'formatter' => 'currency'); $cols['Payment'] = array('index' => 'payment', 'formatter' => 'currency'); if ($subtotal_amount) { $cols['Sub-Total'] = array('index' => 'subtotal', 'formatter' => 'currency', 'sortable' => false); } $custom_post_data = compact('statement_id'); $jqGrid_options = array('jqGridColumns' => $cols, 'controller' => 'statement_entries', ); $jqGrid_options += compact('grid_div_id', 'grid_id', 'caption', 'grid_setup', 'limit'); if (isset($statement_entries)) { $jqGrid_options += array('custom_ids' => array_map(create_function('$data', 'return $data["id"];'), $statement_entries), 'limit' => 10); } else { $jqGrid_options += array('action' => 'statement', 'limit' => 50); } $jqGrid_options += compact('custom_post_data'); $jqGrid_options['sort_column'] = 'Date'; echo $this->element('jqGrid', $jqGrid_options);