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");