Example #1
0
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);
}
Example #2
0
                 $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);
                }