// $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); }