private function get_valuation_table_data($course_id, $group_id = NULL, $condensed = FALSE)
{
$table_data = array('header' => array(), 'content' => array());
$course = new Course();
$course->get_by_id(intval($course_id));
$group = new Group();
$group->get_by_id((int) $group_id);
if ($course->exists()) {
$students = new Student();
$students->select('id, fullname, email');
$students->include_related('participant/group', array('id', 'name'));
$students->where_related('participant/course', 'id', $course->id);
$students->where_related('participant', 'allowed', 1);
$students->order_by_as_fullname('fullname');
if ($group->exists()) {
$students->where_related('participant/group', 'id', (int) $group_id);
}
$students->get_iterated();
$task_sets_out_of_group_ids = array(0);
$task_sets_data = array();
$task_sets_ids = array();
$projects_ids = array();
if ($group->exists()) {
$students_filter = new Student();
$students_filter->select('id');
$students_filter->where_related('participant/course', 'id', $course->id);
$students_filter->where_related('participant', 'allowed', 1);
$students_filter->where_related('participant/group', 'id', (int) $group->id);
$solutions_filter = new Solution();
$solutions_filter->select('id');
$solutions_filter->where_in_subquery('student_id', $students_filter);
$task_sets_out_of_group = new Task_set();
$task_sets_out_of_group->select('id');
$task_sets_out_of_group->where_in_subquery('id', $solutions_filter);
$task_sets_out_of_group->where('published', 1);
$task_sets_out_of_group->get();
$task_sets_out_of_group_ids = $task_sets_out_of_group->all_to_single_array('id');
$task_sets_out_of_group_ids[] = 0;
}
$content_type_task_set = new Task_set();
$content_type_task_set->select('id, name, content_type, group_id, task_set_type_id');
$content_type_task_set->include_related('task_set_type', 'name');
$content_type_task_set->include_related('group', 'name');
$content_type_task_set->where('content_type', 'task_set');
$content_type_task_set->where('published', 1);
$content_type_task_set->where_related_course($course);
$content_type_task_set->order_by_related_with_constant('task_set_type', 'name', 'asc');
$content_type_task_set->order_by('task_set_type_id', 'asc');
$content_type_task_set->order_by('publish_start_time', 'asc');
if ($group->exists()) {
$content_type_task_set->group_start();
$content_type_task_set->group_start('', 'OR ');
$content_type_task_set->group_start();
$content_type_task_set->or_where('group_id', NULL);
$content_type_task_set->or_where('group_id', (int) $group_id);
$content_type_task_set->group_end();
$content_type_task_set->where_subquery(0, '(SELECT COUNT(`tsp`.`id`) AS `count` FROM `task_set_permissions` tsp WHERE `tsp`.`task_set_id` = `task_sets`.`id` AND `tsp`.`enabled` = 1)');
$content_type_task_set->group_end();
$content_type_task_set->group_start('', 'OR ');
$content_type_task_set->where_related('task_set_permission', 'group_id', (int) $group_id);
$content_type_task_set->where_related('task_set_permission', 'enabled', 1);
$content_type_task_set->group_end();
$content_type_task_set->or_where_in('id', $task_sets_out_of_group_ids);
$content_type_task_set->group_end();
}
$content_type_task_set->get();
$header_items = array();
if ($content_type_task_set->result_count() > 0) {
$last_task_set_type_id = NULL;
foreach ($content_type_task_set->all as $task_set) {
$permissions = new Task_set_permission();
$permissions->select('id, group_id');
$permissions->include_related('group', 'name');
$permissions->where_related_task_set($task_set);
$permissions->where('enabled', 1);
$permissions->get_iterated();
if ($permissions->result_count() > 0) {
$group_ids = array();
$group_names = array();
foreach ($permissions as $permission) {
$group_ids[] = $permission->group_id;
$group_names[] = $this->lang->text($permission->group_name);
}
$task_sets_data[$task_set->id] = array('group_id' => $group_ids, 'group_name' => $group_names);
} else {
$task_sets_data[$task_set->id] = array('group_id' => array($task_set->group_id), 'group_name' => $this->lang->text($task_set->group_name));
}
if ($task_set->task_set_type_id !== $last_task_set_type_id) {
$last_task_set_type_id = $task_set->task_set_type_id;
$header_items[] = array('type' => 'task_set_type', 'id' => $task_set->task_set_type_id, 'name' => $this->lang->text($task_set->task_set_type_name), 'title' => '');
}
if (!$condensed) {
$header_items[] = array('type' => 'task_set', 'id' => $task_set->id, 'name' => $this->lang->get_overlay_with_default('task_sets', $task_set->id, 'name', $task_set->name), 'title' => is_array($task_sets_data[$task_set->id]['group_name']) ? implode(', ', $task_sets_data[$task_set->id]['group_name']) : $task_sets_data[$task_set->id]['group_name']);
}
$task_sets_ids[] = $task_set->id;
}
}
$table_data['header']['content_type_task_set'] = array('content_type_name' => $this->lang->line('admin_solutions_valuation_tables_header_content_type_task_sets'), 'items' => $header_items);
$content_type_project = new Task_set();
$content_type_project->where('content_type', 'project');
$content_type_project->where('published', 1);
$content_type_project->where_related_course($course);
$content_type_project->order_by_related_with_constant('task_set_type', 'name', 'asc');
$content_type_project->order_by('publish_start_time', 'asc');
$content_type_project->get();
$header_items = array();
if ($content_type_project->result_count() > 0) {
foreach ($content_type_project->all as $project) {
if (!$condensed) {
$header_items[] = array('type' => 'task_set', 'id' => $project->id, 'name' => $this->lang->get_overlay_with_default('task_sets', $project->id, 'name', $project->name), 'title' => '');
}
$projects_ids[] = $project->id;
}
}
$table_data['header']['content_type_project'] = array('content_type_name' => $this->lang->line('admin_solutions_valuation_tables_header_content_type_project'), 'items' => $header_items);
foreach ($students as $student) {
$student_line = array('fullname' => $student->fullname, 'email' => $student->email, 'id' => $student->id, 'total_points' => 0, 'task_sets_points' => array(), 'task_sets_points_total' => 0, 'projects_points' => array(), 'projects_points_total' => 0);
$solutions_data = array();
if ($content_type_task_set->result_count() > 0 || $content_type_project->result_count() > 0) {
$solutions = new Solution();
$solutions->select('task_set_id, points, tests_points, not_considered, revalidate');
$solutions->where_related_student($student);
$solutions->group_start();
if (count($task_sets_ids) > 0) {
$solutions->or_where_in('task_set_id', $task_sets_ids);
}
if (count($projects_ids) > 0) {
$solutions->or_where_in('task_set_id', $projects_ids);
}
$solutions->group_end();
$solutions->get_iterated();
foreach ($solutions as $solution) {
$solutions_data[$solution->task_set_id] = array('points' => is_null($solution->points) && is_null($solution->tests_points) ? NULL : $solution->points + $solution->tests_points, 'not_considered' => $solution->not_considered, 'revalidate' => $solution->revalidate);
}
}
$task_sets_points_array = array();
if ($content_type_task_set->result_count() > 0) {
$task_sets_points = 0;
$last_task_set_type_id = NULL;
$last_task_set_type_key = NULL;
foreach ($content_type_task_set->all as $task_set) {
if ($last_task_set_type_id !== $task_set->task_set_type_id) {
$last_task_set_type_id = $task_set->task_set_type_id;
$task_sets_points_array[] = array('type' => 'task_set_type', 'points' => 0, 'flag' => 'ok');
$last_task_set_type_key = count($task_sets_points_array) - 1;
}
$points = 0;
if (isset($solutions_data[$task_set->id])) {
if ($solutions_data[$task_set->id]['not_considered']) {
if (!$condensed) {
$task_sets_points_array[] = array('type' => 'task_set', 'points' => '*', 'flag' => 'notConsidered');
}
} else {
if (is_null($solutions_data[$task_set->id]['points'])) {
if (!$condensed) {
$task_sets_points_array[] = array('type' => 'task_set', 'points' => '!', 'flag' => 'revalidate');
}
} elseif ($solutions_data[$task_set->id]['revalidate']) {
if (!$condensed) {
$task_sets_points_array[] = array('type' => 'task_set', 'points' => $solutions_data[$task_set->id]['points'], 'flag' => 'revalidate');
}
$points = floatval($solutions_data[$task_set->id]['points']);
} else {
if (!$condensed) {
$task_sets_points_array[] = array('type' => 'task_set', 'points' => $solutions_data[$task_set->id]['points'], 'flag' => 'ok');
}
$points = floatval($solutions_data[$task_set->id]['points']);
}
}
} else {
if (!$condensed) {
if (!is_null($task_sets_data[$task_set->id]['group_id'][0]) && !in_array($student->participant_group_id, $task_sets_data[$task_set->id]['group_id'])) {
$task_sets_points_array[] = array('type' => 'task_set', 'points' => '-', 'flag' => 'notInGroup');
} else {
$task_sets_points_array[] = array('type' => 'task_set', 'points' => 'x', 'flag' => 'notSubmitted');
}
}
}
$task_sets_points += $points;
$task_sets_points_array[$last_task_set_type_key]['points'] += $points;
$student_line['total_points'] += $points;
$student_line['task_sets_points_total'] = $task_sets_points;
}
}
$student_line['task_sets_points'] = $task_sets_points_array;
$task_sets_points_array = array();
if ($content_type_project->result_count() > 0) {
$task_sets_points = 0;
foreach ($content_type_project as $task_set) {
$points = 0;
if (isset($solutions_data[$task_set->id])) {
if ($solutions_data[$task_set->id]['not_considered']) {
if (!$condensed) {
$task_sets_points_array[] = array('type' => 'task_set', 'points' => '*', 'flag' => 'notConsidered');
}
} else {
if (is_null($solutions_data[$task_set->id]['points'])) {
if (!$condensed) {
$task_sets_points_array[] = array('type' => 'task_set', 'points' => '!', 'flag' => 'revalidate');
}
} elseif ($solutions_data[$task_set->id]['revalidate']) {
if (!$condensed) {
$task_sets_points_array[] = array('type' => 'task_set', 'points' => $solutions_data[$task_set->id]['points'], 'flag' => 'revalidate');
}
$points = floatval($solutions_data[$task_set->id]['points']);
} else {
if (!$condensed) {
$task_sets_points_array[] = array('type' => 'task_set', 'points' => $solutions_data[$task_set->id]['points'], 'flag' => 'ok');
}
$points = floatval($solutions_data[$task_set->id]['points']);
}
}
} else {
if (!$condensed) {
$task_sets_points_array[] = array('type' => 'task_set', 'points' => 'x', 'flag' => 'notSubmitted');
}
}
$task_sets_points += $points;
$student_line['total_points'] += $points;
$student_line['projects_points_total'] = $task_sets_points;
}
}
$student_line['projects_points'] = $task_sets_points_array;
$table_data['content'][] = $student_line;
}
}
return $table_data;
}
public function get_all_task_sets()
{
$fields_config = array(array('name' => 'created', 'caption' => 'lang:common_table_header_created'), array('name' => 'updated', 'caption' => 'lang:common_table_header_updated'), array('name' => 'name', 'caption' => 'lang:admin_task_sets_table_header_name'), array('name' => 'content_type', 'caption' => 'lang:admin_task_sets_table_header_content_type'), array('name' => 'course', 'caption' => 'lang:admin_task_sets_table_header_course'), array('name' => 'group', 'caption' => 'lang:admin_task_sets_table_header_group'), array('name' => 'task_set_type', 'caption' => 'lang:admin_task_sets_table_header_task_set_type'), array('name' => 'tasks', 'caption' => 'lang:admin_task_sets_table_header_tasks'), array('name' => 'published', 'caption' => 'lang:admin_task_sets_table_header_published'), array('name' => 'publish_start_time', 'caption' => 'lang:admin_task_sets_table_header_publish_start_time'), array('name' => 'upload_end_time', 'caption' => 'lang:admin_task_sets_table_header_upload_end_time'), array('name' => 'project_selection_deadline', 'caption' => 'lang:admin_task_sets_table_header_project_selection_deadline'));
$filter = $this->input->post('filter');
$this->store_filter($filter);
$this->inject_stored_filter();
$task_sets = new Task_set();
$task_sets->include_related_count('task_set_permission');
$task_sets->add_join_condition('`task_set_permissions`.`enabled` = 1');
$task_sets->include_related('course', 'name', TRUE);
$task_sets->include_related('course/period', 'name', TRUE);
$task_sets->include_related('group', 'name', TRUE);
$task_sets->include_related('task_set_type', 'name', TRUE);
$task_sets->include_related_count('task');
$task_sets->include_related_count('comment');
if (isset($filter['course']) && intval($filter['course']) > 0) {
$task_sets->where_related_course('id', intval($filter['course']));
if (isset($filter['group']) && $filter['group'] == 'none') {
$task_sets->where_related_group('id', NULL);
$task_sets->where_subquery(0, '(SELECT COUNT(`tsp`.`id`) AS `count` FROM `task_set_permissions` tsp WHERE `tsp`.`task_set_id` = `task_sets`.`id` AND `tsp`.`enabled` = 1)');
} else {
if (isset($filter['group']) && intval($filter['group']) > 0) {
$task_sets->group_start();
$task_sets->or_group_start();
$task_sets->where_related_group('id', intval($filter['group']));
$task_sets->where_subquery(0, '(SELECT COUNT(`tsp`.`id`) AS `count` FROM `task_set_permissions` tsp WHERE `tsp`.`task_set_id` = `task_sets`.`id` AND `tsp`.`enabled` = 1)');
$task_sets->group_end();
$task_sets->or_group_start();
$task_sets->where_related('task_set_permission/group', 'id', intval($filter['group']));
$task_sets->where_related('task_set_permission', 'enabled', 1);
$task_sets->group_end();
$task_sets->group_end();
}
}
}
if (isset($filter['task_set_type']) && intval($filter['task_set_type']) > 0) {
$task_sets->where_related_task_set_type('id', intval($filter['task_set_type']));
}
if (isset($filter['tasks']) && is_numeric($filter['tasks']) && intval($filter['tasks']) == 0) {
$task_sets->where_has_no_tasks();
} else {
if (isset($filter['tasks']) && is_numeric($filter['tasks']) && intval($filter['tasks']) == 1) {
$task_sets->where_has_tasks();
}
}
if (isset($filter['name']) && trim($filter['name']) != '') {
$name_value = trim($filter['name']);
$task_sets->like_with_overlay('name', $name_value);
}
$order_by_direction = $filter['order_by_direction'] == 'desc' ? 'desc' : 'asc';
if ($filter['order_by_field'] == 'created') {
$task_sets->order_by('created', $order_by_direction);
} elseif ($filter['order_by_field'] == 'updated') {
$task_sets->order_by('updated', $order_by_direction);
} elseif ($filter['order_by_field'] == 'name') {
$task_sets->order_by_with_overlay('name', $order_by_direction);
} elseif ($filter['order_by_field'] == 'course') {
$task_sets->order_by_related('course/period', 'sorting', $order_by_direction);
$task_sets->order_by_related_with_constant('course', 'name', $order_by_direction);
} elseif ($filter['order_by_field'] == 'group') {
$task_sets->order_by_related_with_constant('group', 'name', $order_by_direction);
} elseif ($filter['order_by_field'] == 'task_set_type') {
$task_sets->order_by_related_with_constant('task_set_type', 'name', $order_by_direction);
} elseif ($filter['order_by_field'] == 'tasks') {
$task_sets->order_by('task_count', $order_by_direction);
} elseif ($filter['order_by_field'] == 'published') {
$task_sets->order_by('published', $order_by_direction);
} elseif ($filter['order_by_field'] == 'upload_end_time') {
$task_sets->order_by('upload_end_time', $order_by_direction);
} elseif ($filter['order_by_field'] == 'publish_start_time') {
$task_sets->order_by('publish_start_time', $order_by_direction);
} elseif ($filter['order_by_field'] == 'project_selection_deadline') {
$task_sets->order_by('project_selection_deadline', $order_by_direction);
} elseif ($filter['order_by_field'] == 'content_type') {
$task_sets->order_by('content_type', $order_by_direction);
}
$task_sets->get_paged_iterated(isset($filter['page']) ? intval($filter['page']) : 1, isset($filter['rows_per_page']) ? intval($filter['rows_per_page']) : 25);
$this->lang->init_overlays('task_sets', $task_sets->all_to_array(), array('name'));
$opened_task_set = new Task_set();
$opened_task_set->get_as_open();
$this->parser->parse('backend/task_sets/table_content.tpl', array('task_sets' => $task_sets, 'opened_task_set' => $opened_task_set, 'fields_config' => $fields_config));
}
