function delete_learningplan_record($table, $id, $url, $lp_id = '') { global $DB, $OUTPUT; // Delete Department. $costcenter = new costcenter; if ($table == 'learning_learningplan') { /* * */ //$courses = $DB->get_fieldset_select('learning_plan_training','t_id',array('lp_id'=>$id)); //$users = $DB->get_fieldsetselect('learning_user_learningplan','u_id',array('lp_id'=>$id)); //foreach($users as $user){ // //} $DB->delete_records('learning_plan_training ', array('lp_id' => $id)); $DB->delete_records('learning_user_learningplan ', array('lp_id' => $id)); $DB->delete_records('learning_learningplan', array('id' => $id)); } else if ($table == 'learning_training') { $DB->delete_records('learning_training', array('id' => $id)); $training = $DB->get_field('learning_plan_training','t_id',array('id'=>$id)); $DB->delete_records('enrol',array('enrol'=>'learning_plan','courseid'=>$training)); $DB->delete_records('learning_plan_training', array('t_id' => $id)); } else if ($table == 'learning_plan_training') { $training = $DB->get_field('learning_plan_training','t_id',array('id'=>$id)); $userids = $DB->get_field('learning_user_trainingplan','u_id',array('lpt_id'=>$id)); $studentroleid = $DB->get_field('role', 'id', array('shortname' => 'student'), MUST_EXIST); $lplanenrol = new enrol_learning_plan_plugin; foreach($userids as $userid){ $enrol = $DB->get_record('enrol', array('courseid' => $training, 'enrol' => 'learning_plan')); $lplanenrol->unenrol_user($enrol, $id, $studentroleid); } $DB->delete_records('enrol',array('enrol'=>'learning_plan','courseid'=>$training)); $DB->delete_records('learning_plan_training', array('id' => $id)); } else if ($table == 'learning_user_learningplan') { $DB->delete_records('learning_user_learningplan', array('u_id' => $id, 'lp_id' => $lp_id)); // Remove all training in learning_user_trainingplan $sql = "select id from {learning_plan_training} where lp_id =?"; $lpts = $DB->get_recordset_sql($sql, array('lp_id' => $lp_id), $limitfrom = 0, $limitnum = 0); $training = learningplan_training($lp_id); foreach ($training as $train) { $studentroleid = $DB->get_field('role', 'id', array('shortname' => 'student'), MUST_EXIST); $manualenrol = enrol_get_plugin('manual'); $enrol = $DB->get_record('enrol', array('courseid' => $train->t_id, 'enrol' => 'manual')); $manualenrol->unenrol_user($enrol, $id, $studentroleid); } foreach ($lpts as $lpt) { $DB->delete_records('learning_user_trainingplan', array('u_id' => $id, 'lpt_id' => $lpt->id)); } } $style = array('style' => 'notifysuccess'); $costcenter->set_confirmation(get_string('learningplandeletedsuccess', 'block_learning_plan'), $url, $style); }
$lp_record = $DB->get_record('learning_learningplan',array('id'=>$value)); $record->lp_id = $value; $record->assignee_id = $USER->id; $userids = $DB->get_fieldset_sql('select userid from {local_userdata} where position='.$position.''); foreach ($userids as $formtid) { $record->u_id = $formtid; $training = learningplan_training($value); foreach ($training as $train) { $studentroleid = $DB->get_field('role', 'id', array('shortname' => 'student'), MUST_EXIST); //$manualenrol = enrol_get_plugin('manual'); //$enrol = $DB->get_record('enrol', array('courseid'=>$train->t_id, 'enrol'=>'manual')); //$manualenrol->enrol_user($enrol, $record->u_id,$studentroleid); /* * Enrol users to the existing learning plan courses with "learning_plan" enrolment method */ $lplanenrol = new enrol_learning_plan_plugin; $enrol = $DB->get_record('enrol', array('courseid'=>$train->t_id, 'enrol'=>'learning_plan')); $lplanenrol->enrol_user($enrol, $record->u_id,$studentroleid,$lp_record->startdate,$lp_record->enddate); $record2->lpt_id = $train->id; $record2->u_id = $record->u_id; $record2->timemodified = time(); // Insert in learning_user_trainingplan $DB->insert_record('learning_user_trainingplan', $record2); } $record->timemodified = time(); // Insert in learning_user_learningplan if(!$DB->record_exists('learning_user_learningplan',array('lp_id'=>$record->lp_id,'u_id'=>$formtid))) $DB->insert_record('learning_user_learningplan', $record); }