Online PHP editor | refs for kpmA8

<?php $table_template = array( 'db' => array( 'from' => 'T50KCHF_0', 'select' => array( 'SUPPLIER_NAME' => NULL, 'ORD' => NULL, 'REFER' => NULL, 'LIB' => NULL, 'COUNTRY' => NULL, 'PRC' => '###', 'COM' => '###', ), 'where' => array( 'COM' => array('>=', '50000'), ), ), 'filters' => array( 'country' => array( 'type' => 'country_ms', 'description' => 'Country', 'where' => array( 'COUNTRY' => array('LIKE', '%'), ), ), ), 'dynamic' => TRUE, 'editable' => FALSE, 'number' => 13, 'title' => "List of orders / contracts for supplies for a total value exceeding 50 000 CHF<br><small>placed in 2013</small>", 'subtitle' => NULL, 'graph' => NULL, //array('query' => "select country, to_char(to_number(sum(com)), '999G999G999', 'NLS_NUMERIC_CHARACTERS = '', ''') from t50kchf_0 group by country order by country;"), 'headers' => array( array( 'from_db' => TRUE, 'layout' => array( 'SUPPLIER_NAME' => array('class' => "text-center"), 'ORD' => array('class' => "text-center"), 'REFER' => array('class' => "text-center"), 'LIB' => array('class' => "text-center"), 'COUNTRY' => array('class' => "text-center"), 'PRC' => array('class' => "text-center"), 'COM' => array('class' => "text-center") ), '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('class' => "text-min-width"), 'ORD' => array('class' => "text-left no-wrap"), 'REFER' => array('class' => "text-right no-wrap"), 'LIB' => array('class' => "text-left text-min-width"), 'COUNTRY' => array('class' => "text-center"), 'PRC' => array('class' => "text-right", 'data-format' => 'percentage'), 'COM' => array('class' => "text-right no-wrap", 'data-format' => 'currency') ), 'format' => array( 'SUPPLIER_NAME' => 'format_init_caps', 'ORD' => 'format_upper', 'COUNTRY' => 'format_upper', 'PRC' => 'format_percent', 'COM' => array('format_french_number', 'format_no_decimals'), ), ), '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($table_template);