// $instance = $DB->get_record('enrol', array('courseid'=>$assigned_course->courseid, 'enrol'=>'manual'), '*', MUST_EXIST);
// if($instance){
// $timeend='';
// $add_user[]=$get_trainerid->trainerid;
// $manual->enrol_user($instance,$add_user, $studentrole->id,time(),$timeend);
// /* add members to a group*/
// if($assigned_course->testid !=0)
// groups_add_member($assigned_course->groupid, $add_user, $component=null, $itemid=0);
//
//
// }
}
}
$manual = enrol_get_plugin('manual');
$studentrole = $DB->get_record('role', array('shortname'=>'trainers'));
enroll_users_tocourse($get_trainerid->trainerid,$assigned_course,$studentrole,$manual);
}elseif($data->submit_users=="Remove Users >>"){
$remove_users=$data->add_users;
$batch_enrol_users=$DB->get_record_sql("SELECT * FROM {facetoface} WHERE id=$batchid");
$enrolled_users=$batch_enrol_users->enrolled_users-count($remove_users);
$enrolled_user=new stdClass();
$enrolled_user->id=$batchid;
$enrolled_user->enrolled_users=$enrolled_users;
$DB->update_record('facetoface', $enrolled_user);
foreach($remove_users as $remove_user){
$get_record=$DB->get_record('local_batch_users',array('f2fid'=>$batchid,'userid'=>$remove_user));
function assign_course_to_batch($data){//*This function for face2face sql*//
global $DB, $OUTPUT,$USER,$CFG;
$fromform=new stdClass();
$fromform->batchid=$data->batchid;
$fromform->courseid=$data->assign_courses;
$fromform->timeadded=time();
$fromform->testid=$data->assign_quizes;
$record_exist=$DB->record_exists_sql("SELECT * FROM {local_batch_courses} WHERE batchid=$data->batchid AND courseid=0");
if($record_exist==1){
$assigned_course=$DB->get_record_sql("SELECT * FROM {local_batch_courses} WHERE batchid=$data->batchid AND courseid=0");
$course_batch=new stdClass();
$course_batch->id=$assigned_course->id;
$course_batch->courseid=$data->assign_courses;
$course_batch->testid=$data->assign_quizes;
$assigned_course=$DB->update_record('local_batch_courses',$course_batch);
$batch_users=$DB->record_exists_sql("SELECT * FROM {local_batch_users} WHERE f2fid=$data->batchid");
if($batch_users==1){
$trainerid=$DB->get_field('facetoface','trainerid',array('id'=>$data->batchid));
$assigned_users=$DB->get_records_sql("SELECT * FROM {local_batch_users} WHERE f2fid=$data->batchid");
if(!empty($data->assign_quizes)) {
$batchdetails=$DB->get_record_sql("SELECT * FROM {local_batch_courses} WHERE batchid=$data->batchid ");
create_course_group($data,$batchdetails->id);
}
$assigned_courseid=$DB->get_record_sql("SELECT * FROM {local_batch_courses} WHERE batchid=$data->batchid AND courseid!=0");
foreach($assigned_users as $assigned_user){
$manual = enrol_get_plugin('manual');
$studentrole = $DB->get_record('role', array('shortname'=>'student'));
enroll_users_tocourse($assigned_user->userid,$assigned_courseid,$studentrole,$manual);
/*$instance = $DB->get_record('enrol', array('courseid'=>$assigned_courseid->courseid, 'enrol'=>'manual'), '*', MUST_EXIST);
if($instance){
$timeend='';
$manual->enrol_user($instance,$assigned_user->userid, $studentrole->id,time(),$timeend);
} */
$user_batch=new stdClass();
$user_batch->id=$assigned_user->id;
$user_batch->courseid=$assigned_courseid->courseid;
$user_batch->timemodified=time();
$assigned_users=$DB->update_record('local_batch_users',$user_batch);
}
$manual = enrol_get_plugin('manual');
$studentrole = $DB->get_record('role', array('shortname'=>'trainers'));
enroll_users_tocourse($trainerid,$assigned_courseid,$studentrole,$manual);
}
else {
if(!empty($data->assign_quizes)) {
$batchdetails=$DB->get_record_sql("SELECT * FROM {local_batch_courses} WHERE batchid=$data->batchid ");
create_course_group($data,$batchdetails->id);
}
}
return $assigned_course;
}else{
$record_exist_test=$DB->record_exists_sql("SELECT * FROM {local_batch_courses} WHERE batchid=$data->batchid AND courseid=$data->assign_courses AND (testid IS NULL OR testid = 0)");
if($record_exist_test){
if(!empty($data->assign_quizes)) {
$assigned_course=$DB->get_record_sql("SELECT * FROM {local_batch_courses} WHERE batchid=$data->batchid AND courseid=$data->assign_courses");
$DB->execute('update {local_batch_courses} SET testid='.$data->assign_quizes.' WHERE id='.$assigned_course->id.'');
$assigned_course_id=$assigned_course->id;
//print_object($data);
create_course_group($data,$assigned_course_id);
$assigned_course_test=$DB->get_record_sql("SELECT * FROM {local_batch_courses} WHERE batchid=$data->batchid AND courseid=$data->assign_courses");
$assigned_users=$DB->get_records_sql("SELECT * FROM {local_batch_users} WHERE f2fid=$data->batchid");
foreach($assigned_users as $assigned_user){
groups_add_member($assigned_course_test->groupid, $assigned_user->userid, $component=null, $itemid=0);
}
return $assigned_course;
}
}else{
$record_exist_test_id=$DB->record_exists_sql("SELECT * FROM {local_batch_courses} WHERE batchid=$data->batchid AND courseid=$data->assign_courses");
if(($data->assign_quizes!=0)||(!$record_exist_test_id)){
$assigned_course_id=$DB->insert_record('local_batch_courses', $fromform);
if($data->assign_quizes!=0){
create_course_group($data,$assigned_course_id);
return $assigned_course_id;
}
}
}
// if(!empty($data->assign_quizes))
// create_course_group($data,$assigned_course_id);
}
/**End of the function **/
}
//<!--code end here-->
$data=data_submitted();
if(!empty($data)){
require_once $CFG->dirroot.'/group/lib.php';
$fromform=new stdClass();
if($data->submit_users=="<< Add Users"){
$add_users=$data->remove_users;
foreach($add_users as $add_user){
$manual = enrol_get_plugin('manual');
$studentrole = $DB->get_record('role', array('shortname'=>'student'));
if($instance){
enroll_users_tocourse($add_user,$instance,$studentrole,$manual);
}
}
}elseif($data->submit_users=="Remove Users >>"){
$remove_users=$data->add_users;
foreach($remove_users as $remove_user){
$manual = enrol_get_plugin('manual');
$studentrole = $DB->get_record('role', array('shortname'=>'student'));
if($instance){
$timeend='';
$manual->unenrol_user($instance,$remove_user, $studentrole->id,time(),$timeend);
}
