$dialogcourse_view_toggle .= $output->heading(get_string("nocoursesassigned", 'block_learning_plan'),5);
else
$dialogcourse_view_toggle .= html_writer::table($output->courses_info($lp));
echo $dialogcourse_view_toggle .="</div>";
break;
case 2:
$dialoguser_view_toggle = "<div id='dialoguser_view$lp'>";
$sql = "SELECT id, u_id, lp_id, (SELECT concat(firstname,' ', lastname) FROM {user} WHERE id = u_id) as fullname,
(SELECT learning_plan FROM {learning_learningplan} WHERE id = lp_id) as learning_plan,
(SELECT concat(firstname,' ', lastname) FROM {user} WHERE id = assignee_id) as assignee
FROM {learning_user_learningplan} as lup WHERE lup.lp_id=$lp";
$rs = $DB->get_records_sql($sql, array(), null, null);
if(empty($rs)){
$dialoguser_view_toggle .= $output->heading(get_string("nousersassigned", 'block_learning_plan'),5);
}else{
$completed_lp_count = completed_learningplan_count($lp);
$student_status = $output->learning_completed_employees_info($completed_lp_count,$lp,true);
$dialoguser_view_toggle .= html_writer::table($student_status);
}
//$dialoguser_view_toggle .= html_writer::table($this->user_info($log->id));
echo $dialoguser_view_toggle .="</div>";
break;
case 3:
$course_toggle = "<div id='dialogcourse$lp'>";
$course_toggle .= $output->assign_courses($lp);
echo $course_toggle .="</div>";
break;
case 4:
$user_toggle = "<div id='dialoguser$lp'>";
$user_toggle .= $output->assign_users($lp);
echo $user_toggle .="</div>";
<?php
// Variable
global $DB, $USER, $OUTPUT, $PAGE, $CFG;
require_login();
$lp_id = required_param('id', PARAM_INT);
$pageurl = '/blocks/learning_plan/completed_plans.php?id=' . $lp_id;
$context = context_system::instance();
$PAGE->set_context($context);
$PAGE->set_url($pageurl);
$PAGE->set_pagelayout('standard');
$PAGE->set_heading(get_string('learning_plan', 'block_learning_plan'));
$PAGE->set_title(get_string('learning_plan', 'block_learning_plan'));
$PAGE->navbar->ignore_active();
$PAGE->navbar->add(get_string("pluginname", 'block_learning_plan'), new moodle_url($pageurl));
echo $OUTPUT->header();
$users = completed_learningplan_count($lp_id);
//if(isset($rs) && !empty($rs)){
$output = $PAGE->get_renderer('block_learning_plan');
$student_status = $output->learning_completed_employees_info($users,$lp_id);
//$title = '<table width="100%" style="background-color:#EEE;"><tr><td style="text-align:center;"><h3>'.get_string('status_report', 'block_learning_plan').'</h3><h3>'.$USER->firstname . ' ' . $USER->lastname .'</h3><h3>'.get_learningplan_name($lp_id) .'</h3></h3><p>'.get_string('report_at', 'block_learning_plan') . ' ' .(Date("d M Y")).'</p></td></tr></tr><table>';
//echo $title;
echo html_writer::table($student_status);
//} else {
// echo "No learning plans assigned";
//}
echo $OUTPUT->footer();
public function mylearning_plans($uid) {
global $USER, $DB;
$table = new html_table();
$table->head = array(get_string('learning_plan', 'block_learning_plan'), get_string('status', 'block_learning_plan'));
$table->attributes = array('class' => 'generaltable');
$table->align = array('left', 'left', 'left');
//$table->class = 'generaltable';
$table->width = '100%';
$sql = "SELECT ll.id,ll.learning_plan FROM {learning_learningplan} as ll RIGHT JOIN {learning_user_learningplan} as lut ON ll.id = lut.lp_id where lut.u_id=$uid";
$lps = $DB->get_records_sql($sql);
foreach ($lps as $lp) {
$row = array();
$row[] = html_writer::link(new moodle_url('/blocks/learning_plan/student/view.php', array('l_id' => $lp->id)), $lp->learning_plan);
$completed_users = completed_learningplan_count($lp->id);
if (in_array($USER->id, $completed_users))
$row[] = 'Completed';
else
$row[] = 'No yet completed';
$table->data[] = $row;
}
if(!empty($lps))
return $table;
else
return false;
}
