public function pie_sendAction()
{
require_once '../vendor/dhtmlx/dhtmlxConnector/codebase/chart_connector.php';
$database_host = $this->container->getParameter('database_host');
$database_host = $this->container->getParameter('database_port');
$database_name = $this->container->getParameter('database_name');
$database_user = $this->container->getParameter('database_user');
$database_password = $this->container->getParameter('database_password');
$conn = mysql_connect($database_host, $database_user, $database_password);
mysql_select_db($database_name);
$data = new \ChartConnector($conn);
$sql = "select f.STATUS, count(*) as FILES \n from SOSFTP_FILES_HISTORY f \n group by f.status \n order by f.status";
// $data->event->attach("beforeRender", array( $this, "color_rows") );
$data->render_sql($sql, "STATUS", "STATUS,FILES");
}
<?php
require_once 'config.php';
require_once "../js/dhtmlx/chart_connector.php";
$today = date('Y-m-d');
$conn = new ChartConnector($conn);
$conn->enable_log("log.txt", true);
$conn->render_complex_sql("SELECT eluates.EluateID, eluates.`Elution activity` as ElutionActivity, eluates.`Remaining activity`as RemainingActivity, eluates.`Remaining activity calibration time`,(eluates.`Remaining activity` / eluates.`Elution activity`) * 100 AS percentRemaining,((eluates.`Elution activity` - eluates.`Remaining activity`) / eluates.`Elution activity`) * 100 AS percentUsed " . "FROM eluates " . "WHERE eluates.`Elution time` LIKE '{$today}%'", "EluateID", "ElutionActivity, RemainingActivity, percentRemaining, percentUsed");
