function getPieChart($sid, $tableName, $columnName) { $datasetDAO = new DatasetDAO(); $cid = $datasetDAO->getCidBySidTableNameColumName($sid, $tableName, $columnName); $pieChartInput = new stdClass(); $inputObj = new stdClass(); $inputObj->sid = $sid; $inputObj->oneSid = true; $inputObj->tableName = $tableName; $inputObj->title = 'pieChart'; $pieChartInput->inputObj = $inputObj; $pieChartInput->table = $tableName; $columnObj = new stdClass(); $columnObj->cid = $cid; $pieChartInput->pieColumnCat = $columnObj; $pieChartInput->pieColumnAgg = $columnObj; $pieChartInput->pieAggType = "Count"; $pieChartInput->where = ""; $pieChart = new PieChart(null, null, null, null, null, null, null, null, null, null, null); $pieData = $pieChart->query($pieChartInput); $chartId = str_replace(".", "dot", "{$sid}{$tableName}{$columnName}"); $pieData["chartId"] = $chartId; $pieData["columnName"] = $columnName; // foreach ($pieData["content"] as $key => $value) { // SAVETODB($cid, $value->Category, $value->AggValue); // //$value["Category"], $value["AggValue"] // } return $pieData; }