Esempio n. 1
0
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);
		}
	}
	
}
Esempio n. 2
0
        $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']);
Esempio n. 3
0
function cancelEnrolment($enrols)
{
    global $DB;
    foreach ($enrols as $enrol) {
        $info = getRelatedInfo($enrol);
        if ($DB->delete_records('user_enrolments', array('id' => $enrol))) {
            sendCancelMail($info);
        }
    }
}