function drawSummary($profile_data_faculty)
{
global $type;
global $con;
if ($type === "faculty" || $type === "dept") {
global $dept_grp_id;
} else {
if ($type === "custom") {
global $internetIdList;
}
}
// Generate descriptive statistics for department
$fields = array("Indices" => array("hIndex" => "h-index", "hflIndex" => "h(fl)-index"), "Publication Counts" => array("pubCount" => "Total", "flPubCount" => "First/Last"), "Citation Counts" => array("totalCitations" => "Total", "totalflCitations" => "First/Last"));
$profile_data_dept = array();
foreach ($fields as $category => $subcategories) {
$profile_data_dept[$category] = array();
foreach ($subcategories as $metric => $metric_label) {
$metricArray = array();
$profile_data_dept[$category][$metric] = array();
$dataPointer =& $profile_data_dept[$category][$metric];
if ($type === "faculty" || $type === "dept") {
$sql = "SELECT faculty_metrics." . $metric . " AS metric FROM faculty_metrics INNER JOIN faculty_data ON faculty_metrics.internetID = faculty_data.internetID INNER JOIN faculty_affiliations ON faculty_affiliations.internetID = faculty_data.internetID WHERE faculty_data.status_faculty = 1 AND faculty_data.percentTime >= 0.67 AND faculty_data.status_current = 1 AND faculty_affiliations.affilID = '{$dept_grp_id}' AND faculty_affiliations.affilClass = 'DISPLAY' ORDER BY metric ASC";
} else {
if ($type === "custom") {
$sql = "SELECT faculty_metrics." . $metric . " AS metric FROM faculty_metrics INNER JOIN faculty_data ON faculty_metrics.internetID = faculty_data.internetID WHERE faculty_data.status_faculty = 1 AND faculty_data.percentTime >= 0.67 AND faculty_data.status_current = 1 AND faculty_data.internetID IN ({$internetIdList}) ORDER BY metric ASC";
}
}
$result = mysqli_query($con, $sql);
while ($row = mysqli_fetch_array($result)) {
$metricArray[] = $row['metric'];
}
$count = count($metricArray);
$dataPointer["min"] = $metricArray[0];
$dataPointer["max"] = $metricArray[$count - 1];
$dataPointer["median"] = quartile($metricArray, 0.5);
$dataPointer["lower_quartile"] = quartile($metricArray, 0.25);
$dataPointer["upper_quartile"] = quartile($metricArray, 0.75);
$dataPointer["label"] = $metric_label;
mysqli_free_result($result);
}
}
?>
<div id='summaryData'>
<div class='sectionHeader'><a target='_blank' href='resources.php?p=faq#about-metrics'><img class='info_bubble' src='inc/images/info_bubble.png'></a>Overview</div>
<?php
include "inc/visualizations/summary_data.php";
?>
</div> <!-- end summaryData -->
<?php
}
include "../../config/default-config.php";
include "../../functions/default-functions.php";
// Establish connection
$con = connectDB();
// Define variables
$id = $_POST["id"];
$type = $_POST["type"];
switch ($type) {
case "faculty":
$sql = "SELECT hIndex, hflIndex, pubCount,flPubCount,totalCitations,totalflCitations FROM faculty_metrics WHERE internetID = '{$id}'";
$result = runQuery($con, $sql);
$obj = mysqli_fetch_object($result);
$dataArray = array("<i>h</i>-index" => $obj->hIndex, "<i>h</i>(<i>fl</i>)-index" => $obj->hflIndex, "Total Publications" => $obj->pubCount, "First/Last Author Publications" => $obj->flPubCount, "Total Citations" => $obj->totalCitations, "First/Last Author Citations" => $obj->totalflCitations);
break;
case "dept":
$fields = array("hIndex" => "Median <i>h</i>-index", "hflIndex" => "Median <i>h</i>(<i>fl</i>)-index", "pubCount" => "Median Total Publications", "flPubCount" => "Median First/Last Author Publications", "totalCitations" => "Median Total Citations", "totalflCitations" => "Median First/Last Author Citations");
$dataArray = array();
foreach ($fields as $metric => $metric_label) {
$metricArray = array();
$sql = "SELECT faculty_metrics." . $metric . " AS metric FROM faculty_metrics INNER JOIN faculty_data ON faculty_data.internetID = faculty_metrics.internetID INNER JOIN faculty_affiliations ON faculty_affiliations.internetID = faculty_data.internetID WHERE faculty_data.status_faculty = 1 AND faculty_data.percentTime >= 0.67 AND faculty_affiliations.affilID = '{$id}' AND faculty_affiliations.affilClass = 'DISPLAY' AND faculty_data.status_current = 1 ORDER BY metric ASC";
$result = mysqli_query($con, $sql);
while ($row = mysqli_fetch_array($result)) {
$metricArray[] = $row['metric'];
}
$count = count($metricArray);
$dataArray[$metric_label] = quartile($metricArray, 0.5);
mysqli_free_result($result);
}
break;
}
echo json_encode($dataArray, true);
