hover: true,
offsetLeft: 125,
width: 250,
className: 'criteria-tooltip-box'
});
});
});
</script>
<?php
$query = "SELECT * FROM `evaluations` AS a\n\t\t\t\tJOIN `evaluation_forms` AS b\n\t\t\t\tON a.`eform_id` = b.`eform_id`\n JOIN `evaluations_lu_targets` AS c\n ON b.`target_id` = c.`target_id`\n\t\t\t\tWHERE `evaluation_id` = " . $db->qstr($RECORD_ID);
$evaluation = $db->GetRow($query);
if ($evaluation) {
$questions = array();
$responses = array();
$criteria_response_ids = array();
$permissions = Models_Evaluation::getReviewPermissions($evaluation["evaluation_id"]);
$query = "SELECT * FROM `evaluation_form_questions` AS a\n\t\t\t\t\tJOIN `evaluations_lu_questions` AS b\n\t\t\t\t\tON a.`equestion_id` = b.`equestion_id`\n\t\t\t\t\tWHERE a.`eform_id` = " . $db->qstr($evaluation["eform_id"]) . "\n\t\t\t\t\tORDER BY a.`question_order`";
$evaluation_questions = $db->GetAll($query);
if ($evaluation_questions) {
foreach ($evaluation_questions as $evaluation_question) {
$query = "SELECT *, a.`eqresponse_id` FROM `evaluations_lu_question_responses` AS a\n\t\t\t\t\t\t\tLEFT JOIN `evaluations_lu_question_response_criteria` AS b\n\t\t\t\t\t\t\tON a.`eqresponse_id` = b.`eqresponse_id`\n\t\t\t\t\t\t\tWHERE a.`equestion_id` = " . $db->qstr($evaluation_question["equestion_id"]) . "\n\t\t\t\t\t\t\tORDER BY a.`response_order`";
$evaluation_question_responses = $db->GetAll($query);
if ($evaluation_question_responses) {
$evaluation_question["response_ids"] = array();
foreach ($evaluation_question_responses as $evaluation_question_response) {
if ($evaluation_question_response["criteria_text"]) {
$criteria_response_ids[] = $evaluation_question_response["eqresponse_id"];
?>
<div id="criteria-<?php
echo $evaluation_question_response["eqresponse_id"];
?>
public static function getReviewerEvaluations()
{
global $db, $ENTRADA_ACL;
$query = "SELECT a.*, b.*, c.*, d.* FROM `evaluations` AS a\n\t\t\t\t\tJOIN `evaluation_targets` AS b\n\t\t\t\t\tON a.`evaluation_id` = b.`evaluation_id`\n\t\t\t\t\tJOIN `evaluation_forms` AS c\n\t\t\t\t\tON a.`eform_id` = c.`eform_id`\n\t\t\t\t\tJOIN `evaluations_lu_targets` AS d\n\t\t\t\t\tON c.`target_id` = d.`target_id`\n\t\t\t\t\tGROUP BY a.`evaluation_id`";
$evaluations = $db->GetAll($query);
$output_evaluations = array();
foreach ($evaluations as $evaluation) {
$permissions = Models_Evaluation::getReviewPermissions($evaluation["evaluation_id"]);
if ($ENTRADA_ACL->amIAllowed(new EvaluationResource($evaluation["evaluation_id"], $evaluation["organisation_id"], true), 'update')) {
$evaluation["admin"] = true;
$permissions[] = array("contact_type" => "reviewer");
} else {
$evaluation["admin"] = false;
}
if ($permissions) {
if (!$evaluation["admin"]) {
if (count($permissions) > 1) {
foreach ($permissions as $permission) {
if (isset($permission["contact_type"]) && $permission["contact_type"] == "reviewer") {
$evaluation["admin"] = true;
}
}
} elseif (isset($permissions[0]["contact_type"]) && $permissions[0]["contact_type"] == "reviewer") {
$evaluation["admin"] = true;
}
}
if (!$evaluation["admin"]) {
$progress_records = Models_Evaluation::getProgressRecordsByPermissions($evaluation["evaluation_id"], $permissions, true, $evaluation["target_shortname"]);
if (isset($progress_records) && count($progress_records)) {
$evaluation["completed_attempts"] = count($progress_records);
$evaluation["permissions"] = $permissions;
$output_evaluations[] = $evaluation;
}
unset($progress_records);
} else {
if (isset($evaluation["evaluation_completions"]) && $evaluation["evaluation_completions"]) {
$evaluation["completed_attempts"] = $evaluation["evaluation_completions"];
$evaluation["permissions"] = $permissions;
$output_evaluations[] = $evaluation;
}
}
}
}
return $output_evaluations;
}
public function assert(Zend_Acl $acl, Zend_Acl_Role_Interface $role = null, Zend_Acl_Resource_Interface $resource = null, $privilege = null)
{
global $db;
//If asserting is off then return true right away
if (isset($resource->assert) && $resource->assert == false || isset($acl->_entrada_last_query) && isset($acl->_entrada_last_query->assert) && $acl->_entrada_last_query->assert == false) {
return true;
}
if (isset($resource->evaluation_id)) {
$evaluation_id = $resource->evaluation_id;
} else {
if (isset($acl->_entrada_last_query->evaluation_id)) {
$evaluation_id = $acl->_entrada_last_query->evaluation_id;
} else {
//Parse out the user ID and course ID
$resource_id = $resource->getResourceId();
$resource_type = preg_replace('/[0-9]+/', "", $resource_id);
if ($resource_type !== "evaluation") {
//This only asserts for users reviewing evaluations.
return false;
}
$evaluation_id = preg_replace('/[^0-9]+/', "", $resource_id);
}
}
$role_id = $role->getRoleId();
$access_id = preg_replace('/[^0-9]+/', "", $role_id);
$query = "SELECT `user_id` FROM `" . AUTH_DATABASE . "`.`user_access`\n\t\t\t\t\tWHERE `id` = " . $db->qstr($access_id);
$user_id = $db->GetOne($query);
if (!isset($user_id) || !$user_id) {
$role_id = $acl->_entrada_last_query_role->getRoleId();
$access_id = preg_replace('/[^0-9]+/', "", $role_id);
$query = "SELECT `user_id` FROM `" . AUTH_DATABASE . "`.`user_access`\n\t\t\t\t\t\tWHERE `id` = " . $db->qstr($access_id);
$user_id = $db->GetOne($query);
}
$permissions = Models_Evaluation::getReviewPermissions($evaluation_id);
if (count($permissions)) {
return true;
} else {
return false;
}
}
