Online PHP editor | refs for 59oCi

<?php $arr = array( 'db' => array( 'name' => 'T50KCHF_0', 'filter' => array( 'columns' => array( 'SUPPLIER_NAME' => NULL, 'ORD' => NULL, 'REFER' => NULL, 'LIB' => NULL, 'COUNTRY' => NULL, 'PRC' => "concat(to_char(round(cast(### as number), 2), '990.00'),'%')", 'COM' => "to_char(to_number(###), '999G999G999', 'NLS_NUMERIC_CHARACTERS = '', ''')" ), 'where' => array( 'COUNTRY' => 'CH' ) ), 'graph_query' => "select country, to_char(to_number(sum(com)), '999G999G999', 'NLS_NUMERIC_CHARACTERS = '', ''') from t50kchf_0 group by country order by country;" ), 'dynamic' => TRUE, 'number' => 13, 'title' => "List of orders / contracts for supplies for a total value exceeding 50 000 CHF<br><small>placed in 2013</small>", 'subtitle' => FALSE, 'num_columns' => 7, 'headers' => array( array( 'from_db' => TRUE, 'layout' => NULL, 'data' => array( 'SUPPLIER_NAME' => "Supplier Name", 'ORD' => "Order/contract", 'REFER' => "Reference", 'LIB' => "Description", 'COUNTRY' => "Country", 'PRC' => "Percentage", 'COM' => "Commitment (CHF)" ) ) ), 'body' => array( 'layout' => array( 'SUPPLIER_NAME' => array(), 'ORD' => array( 'class' => "text-right" ), 'REFER' => array( 'class' => "text-right" ), 'LIB' => array(), 'COUNTRY' => array( 'class' => "text-center" ), 'PRC' => array( 'class' => "text-right", 'data-format' => 'percentage' ), 'COM' => array( 'class' => "text-right", 'data-format' => 'currency' ) ) ), 'footers' => array( array( 'from_db' => TRUE, 'exclude' => NULL, 'layout' => NULL, 'data' => array( 'SUPPLIER_NAME' => "Supplier Name", 'ORD' => "Order/contract", 'REFER' => "Reference", 'LIB' => "Description", 'COUNTRY' => "Country", 'PRC' => "Percentage", 'COM' => "Commitment" ) ) ) ); echo json_encode((object) $arr, JSON_FORCE_OBJECT);