コード例 #1
0
 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;
 }