<link href="<?php echo $CFG->wwwroot ?>/theme/clean/css/simple-sidebar.css" rel="stylesheet">
</head>
<body <?php echo $OUTPUT->body_attributes(); ?>>
<?php echo $OUTPUT->standard_top_of_body_html();
global $DB,$USER, $CFG;
require_once $CFG->dirroot.'/local/lib.php';
//$superviourrole= new assign_smanager();
$newsuper = is_supervisor_dashboard();
$is_ast_nh = is_ast_nh($USER->id);
$is_zht = is_zht($USER->id);
$is_hod = is_hod($USER->id);
$is_instructor = is_instructor($USER->id);
$is_trainers = is_trainers($USER->id);
$is_bt = is_bt($USER->id);
$is_ct = is_ct($USER->id);
$is_zh = is_zh($USER->id);
$is_rh = is_rh($USER->id);
?>
<div id="wrapper" class="">
<!-- Sidebar -->
<div id="sidebar-wrapper">
<?php
echo $OUTPUT->login_info();
echo $OUTPUT->blocks('side-pre', 'span3');
?>
</div>
<!-- /#sidebar-wrapper -->
function getAllEnrolment($id = null,$enrolid=null){
global $DB,$USER,$CFG;
$newsuper = is_supervisor_dashboard();
$is_ast_nh = is_ast_nh($USER->id);
$is_zht = is_zht($USER->id);
$is_hod = is_hod($USER->id);
$is_instructor = is_instructor($USER->id);
$is_trainers = is_trainers($USER->id);
$is_bt = is_bt($USER->id);
$is_ct = is_ct($USER->id);
$is_zh = is_zh($USER->id);
$is_rh = is_rh($USER->id);
$userdepartment=$DB->get_record('local_userdata',array('userid'=>$USER->id));
$sql="select ue.userid,ue.id,c.fullname as course,ue.timecreated from {user_enrolments} as ue join {enrol} as e on ue.enrolid=e.id join {course} as c on e.courseid=c.id,{local_userdata} ud where ue.userid=ud.userid AND ue.status=1 and e.courseid=$id and e.id=$enrolid ";
if (is_siteadmin()||$is_ast_nh||$is_hod||$is_instructor||$is_zht||$is_trainers) {
}else if($newsuper) {
$sql.= " AND ud.supervisorid=$USER->id";
}
//if(is_supervisor_dashboard()){
// $sql.= " AND ud.supervisorid=$USER->id";
//}
if($userdepartment){
switch($userdepartment->lms_category){
case "AST":
$sql.= " AND (ud.lms_category='AST')";
break;
case "AST-EXT":
$sql.= " AND (ud.lms_category='AST-EXT')";
break;
}
}
//echo $sql;
//if(!$userdepartment->lms_category !=' ' || is_ast_nh()){
// $userdepartment_lms_category=0;
// $sql="select ue.userid,ue.id,u.firstname,u.lastname,u.email,u.picture,c.fullname as course,ue.timecreated from {user_enrolments} as ue left join {user} as u on ue.userid=u.id left join {enrol} as e on ue.enrolid=e.id left join {course} as c on e.courseid=c.id JOIN {local_userdata} ud ON u.id=ud.userid where ue.status=1 and e.courseid={$id} AND u.deleted=0 AND u.suspended=0 AND (ud.lms_category='AST' OR ud.lms_category='NON AST')";
//}else{
// $userdepartment_lms_category=$userdepartment->lms_category;
// $sql="select ue.userid,ue.id,u.firstname,u.lastname,u.email,u.picture,c.fullname as course,ue.timecreated from {user_enrolments} as ue left join {user} as u on ue.userid=u.id left join {enrol} as e on ue.enrolid=e.id left join {course} as c on e.courseid=c.id JOIN {local_userdata} ud ON u.id=ud.userid where ue.status=1 and e.courseid={$id}";
//
//}
if($id){
$userenrolments = $DB->get_records_sql($sql);
}else{
$userenrolments = $DB->get_records_sql($sql);
}
//print_object($userenrolments);
return $userenrolments;
}