</table>
<!-- </div>-->
<h2>Administrative Final</h2>
<!--<button type="button" class="btn btn-info" data-toggle="collapse" data-target="#final_admin">Show Assessments</button>
<div id="final_admin" class="collapse">-->
<table border="1" class="table table-striped table-condensed">
<tr><td width="200"><h4>Creator</h4></td><td width="700"><h4>Expected Outcome</h4></td></tr>
<?php
$teams = team::find_by_sql($final_inst_team_sql);
foreach ($teams as $team) {
echo "<tr><th colspan='4'><div='column_header>" . $team->team_name . "</div></th></tr>";
?>
<?php
$team_id = $team->team_id;
$assessments = assessment::find_by_sql("select * from assessment, team, users where assessment.team_id='{$team_id}' and team.team_id=assessment.team_id AND assessment.user_id=users.user_id AND submitted='1'");
foreach ($assessments as $assessment) {
?>
<tr>
<td><?php
echo $assessment->full_name();
?>
</td>
<td><a href="<?php
echo $team->final ? 'final' : 'initial';
?>
_view.php?id=<?php
echo $assessment->assessment_id;
?>
"><?php
</table>
</div>
<div class="well">
<h2>Administrative Units</h2>
<table border="1">
<?php
$teams = team::find_by_sql($inst_team_sql);
foreach ($teams as $team) {
$i = 0;
echo "<tr><th colspan='4'><h3>" . $team->team_name . "</h3></th></tr>";
?>
<tr><td width="200"><h4>Creator</h4></td><td width="700"><h4>Expected Outcome</h4></td></tr>
<?php
$team_id = $team->team_id;
$assessments = assessment::find_by_sql("select * from assessment, team_user join users on team_user.user_id=users.user_id where assessment.user_id=users.user_id AND assessment_period='2015' AND submitted='1' AND team_user.team_id='{$team_id}'");
foreach ($assessments as $assessment) {
?>
<tr>
<td><?php
echo $assessment->user_fname . " " . $assessment->user_lname;
?>
</td>
<td><a href="report_data.php?id=<?php
echo $assessment->assessment_id;
?>
"><?php
echo $assessment->expected_outcome;
?>
</a></td>
$teamSql = "select * from assessment where team_id = " . $team->team_id . " AND submitted AND assessment_period <> 2014 AND (data_summary IS NULL OR data_summary='')";
$assessments = assessment::find_by_sql($teamSql);
//echo ($team->final==1?"N/A": (count($assessments)==0?"0":count($assessments)));
//echo ($team->final==1?"N/A": (count($assessments)==0?"0":"<a href='admin_list.php?draft=0&final=" .$team->final . "&team_id=" . $team->team_id . "' >" . count($assessments) . "</a>"));
echo count($assessments) == 0 ? "0" : "<a href='admin_list.php?draft=0&initial=1&final=" . $team->final . "&team_id=" . $team->team_id . "' >" . count($assessments) . "</a>";
echo "</td>";
echo "<td>";
//echo $team->team_id;
$teamSql = "select * from assessment where team_id = " . $team->team_id . " AND NOT completed AND (data_summary is not NULL AND assessment_period <> 2014 AND data_summary <> '')";
$assessments = assessment::find_by_sql($teamSql);
//echo ($team->final==0?"N/A": (count($assessments)==0?"0":count($assessments)));
echo $team->final == 0 ? "N/A" : (count($assessments) == 0 ? "0" : "<a href='admin_list.php?draft=1&final=" . $team->final . "&team_id=" . $team->team_id . "' >" . count($assessments) . "</a>");
echo "</td>";
echo "<td>";
//echo $team->team_id;
$teamSql = "select * from assessment where team_id = " . $team->team_id . " AND assessment_period <> 2014 AND completed";
$assessments = assessment::find_by_sql($teamSql);
//echo ($team->final==0?"N/A": count($assessments));
//echo ($team->final==0?"N/A": (count($assessments)==0?"0":count($assessments)));
echo $team->final == 0 ? "N/A" : (count($assessments) == 0 ? "0" : "<a href='admin_list.php?draft=0&final=" . $team->final . "&team_id=" . $team->team_id . "' >" . count($assessments) . "</a>");
echo "</td>";
echo "</tr>";
}
?>
</table>
</div>
<div class="well">
<div class="page_header"><a href="admin.php">Return to Admin Page</a></div>
</div>
</div>
<!-- container-->
if ($final) {
if ($draft) {
$sql = $sql . " AND data_summary <> '' AND NOT completed";
} else {
$sql = $sql . " AND completed = 1";
}
} else {
if ($draft) {
$sql = $sql . " AND NOT submitted";
} else {
$sql = $sql . " AND submitted = 1";
}
}
}
$sql;
$assessments = assessment::find_by_sql($sql);
//print_r($assessments)
?>
<div class="well">
<h1><?php
echo $team->team_name;
?>
</h1>
</div>
<div class="well">
<table class="table table-striped table-bordered table-condensed">
<tr>
<td width="15%">Name</td>
<?php
function pages($team_id, $team_type, $page_type, $user_id, $IO_count)
{
if ($IO_count) {
$intended_outcome = ", intended_outcome";
$IO_and = " AND assessment.team_id = intended_outcome.team_id AND assessment.intended_outcome_id = intended_outcome.intended_outcome_id";
}
if ($team_type == 0) {
switch ($page_type) {
case "initial_edit":
$sql = "select * from assessment, users, slo where slo.team_id = '{$team_id}' AND assessment.user_id=users.user_id \n\t\t\t\t\t\t\t AND assessment.slo_id= slo.slo_id AND submitted =0 AND assessment_period<>2014";
$assess_phase = "Initial Draft ";
break;
case "initial_view":
$sql = "select * from assessment, users, slo where slo.team_id = '{$team_id}' AND assessment.user_id=users.user_id AND assessment.slo_id= slo.slo_id AND submitted =1 AND assessment_period<>2014";
$assess_phase = "Initial Complete";
$phase_page = "initial_view";
break;
case "final_new":
$sql = "select * from assessment, users, slo where slo.team_id = '{$team_id}' AND assessment.user_id=users.user_id AND assessment.slo_id= slo.slo_id AND submitted =1 AND completed=0 AND (data_summary is NULL OR data_summary ='') AND assessment_period<>2014";
$assess_phase = "Initial Complete";
$phase_page = "final_new";
break;
case "final_edit":
$sql = "select * from assessment, users, slo where slo.team_id = '{$team_id}' AND assessment.user_id=users.user_id AND assessment.slo_id= slo.slo_id AND submitted =1 AND completed=0 AND data_summary<>'' AND assessment_period<>2014";
$assess_phase = "Final Draft";
$phase_page = "final_edit";
break;
case "final_view":
$sql = "select * from assessment, users, slo where slo.team_id = '{$team_id}' AND assessment.user_id=users.user_id AND assessment.slo_id= slo.slo_id AND submitted =1 AND completed=1 AND assessment_period<>2014";
$assess_phase = "Final Complete";
$phase_page = "final_view";
break;
}
} else {
switch ($page_type) {
case "initial_edit":
$sql = "select * from assessment, users" . @$intended_outcome . " where assessment.team_id = '{$team_id}' AND \n\t\t\t\t\t\t\t\t assessment.user_id=users.user_id AND submitted =0 AND assessment_period<>2014 " . @$IO_and;
$assess_phase = "Initial Draft ";
break;
case "initial_view":
$sql = "select * from assessment, users " . @$intended_outcome . " where assessment.team_id = '{$team_id}' AND \n\t\t\t\t\t\t\t\t assessment.user_id=users.user_id AND submitted =1 AND assessment_period<>2014 " . @$IO_and;
$assess_phase = "Initial Complete";
$phase_page = "initial_view";
break;
case "final_new":
$sql = "select * from assessment, users " . @$intended_outcome . " where assessment.team_id = '{$team_id}' AND \n\t\t\t\t\t\t\t\t assessment.user_id=users.user_id AND submitted =1 AND completed=0 AND (data_summary is NULL OR data_summary ='') AND assessment_period<>2014 " . @$IO_and;
$assess_phase = "Initial Complete";
$phase_page = "final_new";
break;
case "final_edit":
$sql = "select * from assessment, users" . @$intended_outcome . " where assessment.team_id = '{$team_id}' AND \n\t\t\t\t\t\t\t\t assessment.user_id=users.user_id AND submitted =1 AND completed=0 AND data_summary<>'' AND assessment_period<>2014 " . @$IO_and;
$assess_phase = "Final Edit";
$phase_page = "final_edit";
break;
case "final_view":
$sql = "select * from assessment, users " . @$intended_outcome . " where assessment.team_id = '{$team_id}' AND \n\t\t\t\t\t\t\t\t assessment.user_id=users.user_id AND submitted =1 AND completed=1 AND assessment_period<>2014 " . @$IO_and;
$assess_phase = "Final Complete";
$phase_page = "final_view";
break;
}
}
// Check for any reassessment records returned
$assess_count = 0;
$assessments = assessment::find_by_sql($sql);
foreach ($assessments as $assessment) {
++$assess_count;
}
$assess_count;
if ($assess_count < '1') {
echo "<br>";
echo "There are no " . $assess_phase . " assessments";
echo "<br>";
} else {
//Show assessment by type, if they exist
echo "<h3 style='color: #004990;'>" . $assess_phase . "</h3>";
?>
<table>
<tr>
<td width='900'><h3>Details</h3></td><td><h3>Created By:</h3></td>
</tr>
<?php
foreach ($assessments as $assessment) {
?>
<tr>
<td><a href='<?php
echo $page_type;
?>
.php?id=<?php
echo $assessment->assessment_id;
?>
&user_id=<?php
echo $user_id;
?>
'><?php
echo $team_type == 0 ? $assessment->slo_text : ($assessment->intended_outcome_id ? $assessment->intended_outcome_text : $assessment->expected_outcome);
?>
</a></td><td><?php
echo $assessment->full_name();
?>
</td>
</tr><?php
}
?>
</table>
<?php
}
}
}
}
?>
</table>
</div>
<div class="well">
<div class="page_header">Administrative</div>
<table class="table table-bordered table-condensed table-striped table-hover">
<tr><td width="200"><div class="column_header">Creator</div></td><td width="700"><div class="column_header">Expected Outcome</div></td></tr>
<?php
foreach ($teams as $team) {
if ($team->team_type == 1) {
echo "<tr><th colspan='4'><div class='column_header'>" . ($team_name = $team->team_name . "</div></th></tr>");
?>
<?php
$assessments = assessment::find_by_sql("select * from assessment, users WHERE assessment.team_id = '{$team->team_id}' and assessment.user_id=users.user_id and submitted='1' and completed = 0 and data_summary IS NOT NULL");
foreach ($assessments as $assessment) {
?>
<tr><td width="200"><h4><?php
echo $assessment->full_name();
?>
</h4></td><td width="700"><h4><a href="final_edit.php?id=<?php
echo $assessment->assessment_id;
?>
&user_id=<?php
echo $assessment->user_id;
?>
"><?php
echo $assessment->expected_outcome;
?>
</a></h4></td></tr>
}
}
?>
</table>
</div>
<div class="well">
<div class="page_header">Administrative</div>
<table class="table table-bordered table-condensed table-striped table-hover">
<tr><td width="200"><div class="column_header">Creator</div></td><td width="700"><div class="column_header">Expected Outcome</div></td></tr>
<?php
foreach ($teams as $team) {
if ($team->team_type == 1) {
echo "<tr><th colspan='4'><div class='column_header'>" . ($team_name = $team->team_name . "</div></th></tr>");
?>
<?php
$assessments = assessment::find_by_sql("select * from assessment, users WHERE assessment.team_id = '{$team->team_id}' and assessment.user_id=users.user_id and submitted='1' and assessment_period <>2014");
foreach ($assessments as $assessment) {
?>
<tr><td width="200"><h4><?php
echo $assessment->full_name();
?>
</h4></td><td width="700"><h4><a href="edit.php?id=<?php
echo $assessment->assessment_id;
?>
"><?php
echo $assessment->expected_outcome;
?>
</a></h4></td></tr>
<?php
}
}
function academic_completed($team_id, $assess_type)
{
//If assess_type is Submitted, then do this
if ($assess_type == 'Submitted') {
$sql = "select * from assessment, users, slo where slo.team_id = '{$team_id}' AND assessment.user_id=users.user_id AND assessment.slo_id= slo.slo_id AND submitted =1 AND completed = 0 AND assessment_period=2015";
$assess_phase = "Initial Completed";
} elseif ($assess_type == "F_Complete") {
$sql = "select * from assessment, users, slo where slo.team_id = '{$team_id}' AND assessment.user_id=users.user_id AND assessment.slo_id= slo.slo_id AND completed =1 AND assessment_period=2015";
$assess_phase = "Final Completed";
} else {
$sql = "select * from assessment, users, slo where slo.team_id = '{$team_id}' AND assessment.user_id=users.user_id AND assessment.slo_id= slo.slo_id AND submitted =0 AND assessment_period=2015";
$assess_phase = "Initial Draft";
}
// Check for any reassessment records returned
$assess_count = 0;
$assessments = assessment::find_by_sql($sql);
foreach ($assessments as $assessment) {
++$assess_count;
}
//Show No assessments if none exist
if ($assess_count < '1') {
echo "<br>";
echo "There are no " . $assess_phase . " assessments";
echo "<br>";
} else {
//Show assessment by type, if they exist
echo "<h3 style='color: #004990;'>" . $assess_phase . "</h3>";
?>
<table>
<tr>
<td width='900'><h3>SLO</h3></td><td><h3>Created By:</h3></td>
</tr>
<?php
foreach ($assessments as $assessment) {
?>
<tr>
<td><a href='<?php
echo $assess_type;
?>
.php?id=<?php
echo $assessment->assessment_id;
?>
'><?php
echo $assessment->slo_text;
?>
</a></td><td><?php
echo $assessment->full_name();
?>
</td>
</tr><?php
}
?>
</table>
<?php
}
}
</tr>
<?php
}
?>
</table>
<?php
}
if ($A_count > 0) {
?>
<h2>Academic</h2>
<table>
<tr>
<td width="350"><h3>Team</h3></td><td width="600"><h3>Student Learning Outcome</h3></td><td><h3>Resolved?</h3></td>
</tr>
<?php
$assessments = assessment::find_by_sql("SELECT * FROM assessment, team, slo where assessment_period='2014' AND assessment.team_id=team.team_id AND slo.slo_id=assessment.slo_id order by team_name");
foreach ($assessments as $assessment) {
?>
<tr>
<td><?php
echo $assessment->team_name;
?>
</td>
<td><?php
echo htmlentities($assessment->slo_text);
?>
</td>
<!--<td><?php
if ($row['reassessment'] > 0) {
echo "Yes";
