</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";