function get_rubric($id)
{
// verify access to object
if (!abet_is_admin_authenticated() && !abet_is_observer() && !check_assessment_access($_SESSION[id], $id, 'assessment_worksheet')) {
page_fail(UNAUTHORIZED);
}
// select required fields from rubric and rubric_result
$rubric = new Query(new QueryBuilder(SELECT_QUERY, array('tables' => array('rubric' => array('name', 'threshold', 'threshold_desc'), 'rubric_description' => array('outstanding_desc', 'expected_desc', 'marginal_desc', 'unacceptable_desc'), 'rubric_results' => 'total_students'), 'joins' => array("INNER JOIN assessment_worksheet ON assessment_worksheet.fk_rubric = rubric.id", "INNER JOIN rubric_description ON rubric.fk_description = rubric_description.id", "INNER JOIN rubric_results ON assessment_worksheet.fk_rubric_results = rubric_results.id"), 'where' => 'assessment_worksheet.id = ?', 'where-params' => array("i:{$id}"))));
$row = $rubric->get_row_assoc();
if (is_null($row)) {
page_fail(NOT_FOUND);
}
// select competencies
$comps = new Query(new QueryBuilder(SELECT_QUERY, array('tables' => array('competency_results' => array('id', 'competency_desc', 'outstanding_tally', 'expected_tally', 'marginal_tally', 'unacceptable_tally', 'pass_fail_type', 'comment')), 'aliases' => array('competency_results.competency_desc' => 'description'), 'joins' => array("INNER JOIN rubric_results ON rubric_results.id = competency_results.fk_rubric_results", "INNER JOIN assessment_worksheet ON assessment_worksheet.fk_rubric_results = rubric_results.id"), 'where' => 'assessment_worksheet.id = ?', 'where-params' => array("i:{$id}"))));
if ($comps->is_empty()) {
page_fail(NOT_FOUND);
}
// prepare json object
$cs = array();
$comps->for_each_assoc(function ($row) use(&$cs) {
$cs[] = $row;
});
$row['competency'] = $cs;
return json_encode($row);
}
function get_assessment($id)
{
// get general assessment information
$query = new Query(new QueryBuilder(SELECT_QUERY, array('tables' => array('abet_assessment' => 'name', 'abet_characteristic' => 'id', 'general_content' => 'id'), 'joins' => array('LEFT OUTER JOIN abet_characteristic ON abet_characteristic.id = abet_assessment.fk_characteristic', 'LEFT OUTER JOIN general_content ON general_content.fk_assessment = abet_assessment.id'), 'where' => 'abet_assessment.id = ?', 'where-params' => array("i:{$id}"), 'limit' => 1)));
if ($query->is_empty()) {
page_fail(NOT_FOUND);
}
// get acl and profile information
$aclQuery = new Query(new QueryBuilder(SELECT_QUERY, array('tables' => array('userprofile' => array('id', 'first_name', 'last_name'), 'abet_assessment' => 'id'), 'joins' => array('LEFT OUTER JOIN acl_entry ON acl_entry.fk_profile = userprofile.id', 'LEFT OUTER JOIN acl ON acl.id = acl_entry.fk_acl', 'LEFT OUTER JOIN abet_assessment ON abet_assessment.fk_acl = acl.id ' . 'AND abet_assessment.id = ' . intval($id)), 'orderby' => 'userprofile.last_name')));
if ($aclQuery->is_empty()) {
// this shouldn't happen
page_fail(NOT_FOUND);
}
// get worksheet information
$contentQuery = new Query(new QueryBuilder(SELECT_QUERY, array('tables' => array('assessment_worksheet' => array('id', 'activity'), 'course' => 'course_number'), 'joins' => array('INNER JOIN abet_assessment ON abet_assessment.id = assessment_worksheet.fk_assessment', 'LEFT OUTER JOIN course ON course.id = assessment_worksheet.fk_course'), 'where' => 'abet_assessment.id = ?', 'where-params' => array("i:{$id}"))));
// get characteristics information
$charsQuery = new Query(new QueryBuilder(SELECT_QUERY, array('tables' => array('abet_characteristic' => array('id', 'level', 'program_specifier', 'short_name')), 'orderby' => 'CHAR_LENGTH(level), level')));
// get single entity rows
$genInfo = $query->get_row_assoc();
// prepare assessment object
$obj = new stdClass();
$obj->name = $genInfo['name'];
$obj->characteristic = $genInfo['abet_characteristic.id'];
$obj->has_content = !is_null($genInfo['general_content.id']);
$obj->acl = array();
$obj->profiles = array();
$obj->worksheets = array();
$obj->characteristics = array();
// assign profile and acl information
$m = array();
$aclQuery->for_each_assoc(function ($row) use($obj, &$m) {
if (array_key_exists($row['userprofile.id'], $m)) {
return;
}
$m[$row['userprofile.id']] = null;
if (!is_null($row['abet_assessment.id'])) {
$obj->acl[] = $row['userprofile.id'];
}
$p = new stdClass();
$p->id = $row['userprofile.id'];
$p->name = "{$row['first_name']} {$row['last_name']}";
$obj->profiles[] = $p;
});
// assign worksheet info
$contentQuery->for_each_assoc(function ($row) use($obj) {
$w = new stdClass();
$w->id = $row['id'];
if (!is_null($row['activity'])) {
$w->name = $row['activity'];
} else {
$w->name = $row['course_number'];
}
$obj->worksheets[] = $w;
});
// assign characteristics
$charsQuery->for_each_assoc(function ($row) use($obj) {
$c = new stdClass();
$c->id = $row['id'];
$c->name = "{$row['level']}. {$row['short_name']}";
if (!is_null($row['program_specifier'])) {
$c->name .= " [{$row['program_specifier']}]";
}
$obj->characteristics[] = $c;
});
return json_encode($obj);
}
function get_acl()
{
$query = new Query(new QueryBuilder(SELECT_QUERY, array('tables' => array('userprofile' => array('id', 'username', 'first_name', 'last_name')), 'joins' => array('INNER JOIN userauth ON userprofile.fk_userauth = userauth.id', 'INNER JOIN acl_entry ON acl_entry.fk_profile = userprofile.id', 'INNER JOIN acl ON acl.id = acl_entry.fk_acl', 'INNER JOIN abet_assessment ON abet_assessment.fk_acl = acl.id'), 'where' => "abet_assessment.id = {$this->id} AND userauth.role = 'Faculty'")));
$results = array();
$query->for_each_assoc(function ($row) use(&$results) {
$entry = new stdClass();
$entry->id = $row['id'];
$entry->username = $row['username'];
$entry->full_name = "{$row['first_name']} {$row['last_name']}";
$results[] = $entry;
});
return $results;
}
function get_content($gcId)
{
global $DATETIME_FORMAT;
$content = array();
// select comments and file uploads separately
$comments = new Query(new QueryBuilder(SELECT_QUERY, array('tables' => array('user_comment' => array('id', 'content'), 1 => array("DATE_FORMAT(user_comment.created,'{$DATETIME_FORMAT}') created", "UNIX_TIMESTAMP(user_comment.created) unix_time"), 'userprofile' => array('first_name', 'last_name')), 'joins' => array('INNER JOIN userprofile ON userprofile.id = user_comment.fk_author'), 'where' => "fk_content_set = ?", 'where-params' => array("i:{$gcId}"))));
$uploads = new Query(new QueryBuilder(SELECT_QUERY, array('tables' => array('file_upload' => array('id', 'file_name', 'file_comment'), 1 => array("DATE_FORMAT(file_created,'{$DATETIME_FORMAT}') file_created", "UNIX_TIMESTAMP(file_created) unix_time"), 'userprofile' => array('first_name', 'last_name')), 'joins' => array('INNER JOIN userprofile ON userprofile.id = file_upload.fk_author'), 'where' => "fk_content_set = ?", 'where-params' => array("i:{$gcId}"))));
// create closure for adding row to content set
$addRow = function ($row) use(&$content) {
$row['author'] = "{$row['first_name']} {$row['last_name']}";
unset($row['first_name']);
unset($row['last_name']);
$content[] = $row;
};
// grab content items and sort them by create time
$comments->for_each_assoc($addRow);
$uploads->for_each_assoc($addRow);
usort($content, function ($a, $b) {
return $a['unix_time'] - $b['unix_time'];
});
return json_encode($content);
}
