//
// begin by creating pivot table from analyses_output table
//
// get full list of analyses
$result = mysql_query("SELECT name from " . $current_project . ".analyses_list");
while ($row = mysql_fetch_array($result)) {
$analyses_list[] = $row[0];
}
// get full list of sessions
$result = mysql_query("SELECT name from " . $current_project . ".session_list");
while ($row = mysql_fetch_array($result)) {
$session_list[] = $row[0];
}
// now build pivot table query
$result = mysql_query("DROP TABLE IF EXISTS " . $current_project . ".output");
$output_trunk = " CREATE TABLE " . $current_project . ".output AS SELECT participant ";
foreach ($analyses_list as $analysis) {
foreach ($session_list as $session) {
$output_trunk .= ", avg(if(session_id = '" . $session . "' and runner='" . $analysis . "', value, NULL)) \n\t \t\tAS " . $analysis . "_" . $session . "";
}
}
$output_trunk .= " FROM " . $current_project . ".analyses_output GROUP BY participant ";
$result = mysql_query($output_trunk);
echo "<div>";
table_builder($current_project . ".output");
echo "</div>";
}
if (isset($_GET['create_excel'])) {
create_excel($current_project . '.output');
echo "File has been saved. \n <br><a href='projects/" . $current_project . "/excel_output/" . $current_project . ".output.xls'><button>Click here to open it.</button></a>";
}
<link href="src/style/dashboard_structures.css" type="text/css" rel="stylesheet" />
<script src="src/script/dashboard.js" type="text/javascript"></script>
</head>
<body>
<div id="background">
<div id="mid_circle"></div>
<div id="left_top_circle"></div>
<div id="left_bottom_circle"></div>
<div id="right_top_circle"></div>
<div id="right_bottom_circle"></div>
</div>
<div id="dashboard_container">
<table id="dashboard_container_table">
<tr>
<?php
table_builder();
?>
<!-- <td>
<div class="dashboard_box" id="dashboard_box1">
<div class="dashboard_box_title">Long text demo</div>
<div class="dashboard_box_content">
<div class="dashboard_box_entry_title" class="dashboard_box_entry_long_text_title">Just a long text passing by</div>
<div class="dashboard_box_structure_long_text" id="dashboard_box1_entry1" onmouseover="expandTextBox(this)" onmouseout="collapseTextBox(this)">Text.....</div>
<div class="dashboard_box_entry_title">Random text to show drifting</div>
</div>
</div>
<div class="dashboard_box" id="dashboard_box2">
<div class="dashboard_box_title">Small text fields</div>
<div class="dashboard_box_content">
<p><span class="dashboard_box_entry_small_title">Title of entry:</span><span class="dashboard_box_entry_small_data">Text field data</span></p>
<p><span class="dashboard_box_entry_small_title">Small text entry:</span><span class="dashboard_box_entry_small_data">Some data</span></p>
