function cancelEnrolment($enrols){ global $DB; global $CFG; require_once($CFG->dirroot.'/lib/moodlelib.php'); require_once $CFG->dirroot.'/mod/facetoface/lib.php'; foreach ($enrols as $enrol){ $info = getRelatedInfo($enrol); $userenrolment = $DB->get_record_sql('select * from '.$CFG->prefix.'user_enrolments where id='.$enrol); $userenrolments=array($userenrolment); $user_course=$DB->get_record_sql('select * from '.$CFG->prefix.'enrol where id='.$userenrolment->enrolid); $local_batch_course=$DB->get_record_sql("SELECT lb.* FROM {local_batch_users} as lb where lb.userid=$userenrolment->userid and lb.courseid=$user_course->courseid group by lb.id"); if(empty($local_batch_course)){ //print_object($instance);exit; $sql ="SELECT course.*, ue.timecreated as time_enroled FROM {course} AS course JOIN {enrol} as en ON en.courseid=course.id and en.enrol='apply' JOIN {user_enrolments} AS ue ON ue.enrolid=en.id and ue.userid=$userenrolment->userid WHERE course.id=$user_course->courseid"; $courses = $DB->get_record_sql($sql); if(!empty($courses)){ $emai_users=email_send_users_list($userenrolments,$user_course->courseid); $to_emailid=$emai_users[0]; $to_userid=$emai_users[1]; if((!empty($to_emailid))&&(!empty($to_userid))){ e_learning_and_request_course_emails($user_course,$to_emailid,'apply','apply_cancel',$to_userid); } } } if($DB->delete_records('user_enrolments',array('id'=>$enrol))){ //sendCancelMail($info); } } }
$smarty->assign("MODE", $quote_focus->mode); $smarty->assign("AVAILABLE_PRODUCTS", 'true'); } } if (isset($_REQUEST['isDuplicate']) && $_REQUEST['isDuplicate'] == 'true') { $smarty->assign("DUPLICATE_FROM", $focus->id); $SO_associated_prod = getAssociatedProducts("SalesOrder", $focus); $focus->id = ""; $focus->mode = ''; } if (empty($_REQUEST['record']) && $focus->mode != 'edit') { setObjectValuesFromRequest($focus); } if (isset($_REQUEST['potential_id']) && $_REQUEST['potential_id'] != '') { $focus->column_fields['potential_id'] = $_REQUEST['potential_id']; $relatedInfo = getRelatedInfo($_REQUEST['potential_id']); if (!empty($relatedInfo)) { $setype = $relatedInfo["setype"]; $relID = $relatedInfo["relID"]; } if ($setype == 'Accounts') { $_REQUEST['account_id'] = $relID; } elseif ($setype == 'Contacts') { $_REQUEST['contact_id'] = $relID; } $log->debug("Sales Order EditView: Potential Id from the request is " . $_REQUEST['potential_id']); $associated_prod = getAssociatedProducts("Potentials", $focus, $focus->column_fields['potential_id']); } if (isset($_REQUEST['product_id']) && $_REQUEST['product_id'] != '') { $focus->column_fields['product_id'] = $_REQUEST['product_id']; $associated_prod = getAssociatedProducts("Products", $focus, $focus->column_fields['product_id']);
function cancelEnrolment($enrols) { global $DB; foreach ($enrols as $enrol) { $info = getRelatedInfo($enrol); if ($DB->delete_records('user_enrolments', array('id' => $enrol))) { sendCancelMail($info); } } }