Online PHP editor | refs for 778Ea

<?php $arr = array ( 'db' => array ( 'from' => array ( 'SAVING_0', 'PPERS_0', 'SUPP_0' ), 'select' => array ( 'ORGSUPP' => NULL, 'UIDSUPP' => NULL, 'NAMSUPP' => NULL, 'UIDPPERS' => NULL, 'NAMPPERS' => NULL, 'REFSAVING' => NULL, 'MONTHSAVING' => NULL, 'YRSAVING' => NULL, 'INITAMOUNT' => NULL, 'NETSAVING' => NULL, 'ESTSAVING' => NULL, 'ESTIMATED' => NULL, 'SUPPLIER' => NULL, 'COMMENTS' => NULL, 'CREATED' => NULL, 'CREATEDDATE' => NULL, ), 'where' => array ( 'UIDSAVING' => '#UIDPPERS', 'ORGSUPP' => '#ORGPPERS', '#1.STATUS' => 'Y', '#2.STATUS' => 'Y', 'SAVING' => 'Y', ), 'filters' => NULL ), 'dynamic' => TRUE, 'editable' => TRUE, 'number' => NULL, 'title' => "Savings from the staff in the FP group.", 'subtitle' => NULL, 'num_columns' => 10, 'graph' => NULL, 'headers' => array ( array ( 'layout' => array ( 'ORGSUPP' => FALSE, 'UIDSUPP' => FALSE, 'NAMSUPP' => FALSE, 'UIDPPERS' => FALSE, 'NAMPPERS' => FALSE, 'REFSAVING' => array('class' => "text-center"), 'MONTHSAVING' => array('class' => "text-center"), 'YRSAVING' => array('class' => "text-center"), 'INITAMOUNT' => array('class' => "text-center"), 'NETSAVING' => array('class' => "text-center"), 'ESTSAVING' => array('class' => "text-center"), 'ESTIMATED' => array('class' => "text-center"), 'SUPPLIER' => array('class' => "text-center"), 'COMMENTS' => array('class' => "text-center"), 'CREATED' => array('class' => "text-center"), 'CREATEDDATE' => array('class' => "text-center"), ), 'data' => array ( 'REFSAVING' => "Order / contract ref.", 'MONTHSAVING' => "Month", 'YRSAVING' => "Year", 'INITAMOUNT' => "Initial Amount (CHF)", 'NETSAVING' => "Firm saving (CHF)", 'ESTSAVING' => "Estimated saving (CHF)", 'ESTIMATED' => "Is it estimated?", 'SUPPLIER' => "Supplier", 'COMMENTS' => "Comments", 'CREATED' => "Created by", 'CREATEDDATE' => "Date", ), ), ), 'body' => array ( 'layout' => array ( 'REFSAVING' => array('class' => "text-left no-wrap"), 'MONTHSAVING' => array('class' => "text-center no-wrap"), 'YRSAVING' => array('class' => "text-center no-wrap"), 'INITAMOUNT' => array('class' => "text-right no-wrap", 'data-format' => 'currency'), 'NETSAVING' => array('class' => "text-right no-wrap", 'data-format' => 'currency'), 'ESTSAVING' => array('class' => "text-right no-wrap", 'data-format' => ' currency'), 'ESTIMATED' => array('class' => "border-left border-right text-center"), 'SUPPLIER' => array('class' => "no-wrap"), 'COMMENTS' => array('class' => "text-min-width"), 'CREATED' => NULL, 'CREATEDDATE' => array('class' => "text-center no-wrap", 'data-format' => 'date'), ), 'format' => array ( 'MONTHSAVING' => 'format_date_month', 'YRSAVING' => 'format_date_year', 'INITAMOUNT' => array('format_french_number', 'format_no_decimals'), 'NETSAVING' => array('format_french_number', 'format_no_decimals'), 'ESTSAVING' => array('format_french_number', 'format_no_decimals'), 'CREATEDDATE' => 'format_date', ) ), 'footers' => array ( FALSE ), ); echo json_encode($arr);