</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>
<?php
require_once "inc/initialize.php";
include "inc/header.php";
include 'inc/validate.php';
$assessment_id = $_GET['id'];
$assessment = assessment::find_by_id($assessment_id);
$team = team::find_by_id($assessment->team_id);
$goal = goal::find_by_id($assessment->goals_id);
$user = user::find_by_id($assessment->user_id);
$team_type = $team->team_type;
if ($team_type == 0) {
$slo = slo::find_by_id($assessment->slo_id);
}
?>
<div class="well">
<h1>Submitted Assessment : Date <?php
echo $assessment->submit_date;
?>
</h1>
<h3 style="color: #004990;"> Unit: <?php
echo $team->team_name;
?>
</h3>
<h3 style="color: #004990;">Name : <?php
echo $user->full_name();
?>
</h3>
<br>
<button type="button" onclick="location.href='print_form.php?id=<?php
echo $assessment_id;
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
</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
$msg = "";
if (isset($_POST['submitAssessments'])) {
$_POST['userID'] = $user->id;
$assessmentValidator = new assessment($_POST);
$assessmentReturn = $assessmentValidator->validateAssessments();
if ($assessmentReturn == "SUCCESS") {
$msg = ["Assessment Selection Completed.", 1];
} else {
$msg = ["Please select one or more assessments", 0];
}
}
if (isset($_POST['submitData'])) {
$_POST['userID'] = $user->id;
unset($_POST['submitData']);
// printr($_POST);
$assessmentValidator = new assessment($_POST);
$assessmentReturn = $assessmentValidator->validateAssessmentData();
if ($assessmentReturn == "SUCCESS") {
$msg = ["Assessment submitted successfully.", 1];
} else {
$msg = ["Failed to submit assessment data", 0];
}
}
$array = ["Chairstand" => ["30 Second Chair Stand", "Lower body strength evaluation. Assess strength for climbing stairs, walking, and getting out of a chair, car, or tub. Number of full stands that can be completed in 30 seconds with arms folded across chest. If the arms are pulled away from the chest or you rock back and forward to help you stand that is unacceptable and the test will be stopped at that point. You may rest while siting on the chair and continue if you are still within the 30 seconds.", "ChairStand", "m0APvLqZr5E"], "ArmCurl" => ["Arm Curl", "Assess upper body strength, needed for performing household and other activities involving lifting and carrying things such as groceries, suitcases and grandchildren. Number of bicep curls – lifting the weight from the arm extended up to the shoulder and back down – that can be completed in 30 seconds holding a 5 lb weight (for women) or an 8 lb weight (for men). You may not use the back to help “throw” the weight up. The weight must come up and touch the shoulder and the return to the lowered position should be with control, not just dropping the arm. You may rest in the down position and continue with lifts if you are still within the 30 seconds.", "ArmCurl", "m0APvLqZr5E"], "StepTest" => ["2-Minute Step Test", "Aerobic endurance test. Number of full steps completed in 2 minutes, raising the knee to a point halfway between the kneecap and the hip on each step. If the knee does not come up high enough you will be reminded to lift it higher. If you are testing yourself at home stand in front of a mirror so you can assess the knee height.", "Steptest", "m0APvLqZr5E"], "FootUpAndGo" => ["8 Foot Up and Go", "Assess agility and dynamic balance needed for quick maneuvering such as getting on or off a bus, getting up to attend to something in the kitchen, going to the bathroom, or getting up to answer the phone. Number of seconds it takes to get up out of a chair, walk 8 feet, turn around a cone, and return to the chair and sit down. The entire movement must be in control. You may use your hands to help get up from the chair and to sit back down.", "FootUpandGo", "m0APvLqZr5E"], "unilateralbalancetest" => ["Unilateral Balance Test", "Fall risk evaluation. Balance test determined by how long you can stand on one foot without moving, or touching the lifted foot back to the ground. The lifted leg may not be braced against the support leg, lift the lower leg up and to the rear till the knee is at 90 degrees. Not acceptable is excessive movement of arms or body to hold position", "Unilateral", "m0APvLqZr5E"], "FunctionalReach" => ["Functional Reach", "Assess balance in a forward motion. Reach as far forward as you can keep your arm parallel to the yardstick without touching the wall or taking a step forward. Do not overreach and risk falling.", "Functional", "m0APvLqZr5E"]];
?>
<div class="background">
<!-- Accordion -->
<?php
$find = QueryFactory::Build('select');
$find->Select("Chairstand", "ArmCurl", "StepTest", "FootUpAndGo", "leftunilateralbalancetest", "rightunilateralbalancetest", "FunctionalReach")->From('assessments')->Where(['userID', '=', $user->id, "AND"], ['DateCompleted', '=', 0]);
$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-->
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";
