gradebook_functions_users.inc.php

完美的在线教育系统

<?php

/*
 * Various user related functions
 */


/**
 * returns users within a course given by param
 * @param $course_id
 */
function get_users_in_course($course_id)
{
	$tbl_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
	$tbl_user = Database :: get_main_table(TABLE_MAIN_USER);

	$sql = 'SELECT user.user_id,lastname,firstname'
			.' FROM '.$tbl_course_user.' as course_rel_user, '.$tbl_user.' as user'
			.' WHERE course_rel_user.user_id=user.user_id'
			.' AND course_rel_user.status='.STUDENT
			." AND course_rel_user.course_code='".$course_id."'"
			.' ORDER BY lastname ASC';
	$result = api_sql_query($sql, __FILE__, __LINE__);
	return get_user_array_from_mysql_result($result);
}


function get_user_array_from_mysql_result($result)
{
	$a_students = array();
	while ($user = mysql_fetch_array($result))
	{
		if (!array_key_exists($user['user_id'],$a_students))
		{
			$a_current_student = array ();
			$a_current_student[] = $user['user_id'];
			$a_current_student[] = $user['lastname'];
			$a_current_student[] = $user['firstname'];
			$a_students['STUD'.$user['user_id']] = $a_current_student;
		}
	}
	//var_dump($a_students);
	return $a_students;
}

function get_all_users ($evals = array(), $links = array())
{
	$coursecodes = array();
	$users = array();
	
	foreach ($evals as $eval)
	{
		$coursecode = $eval->get_course_code();
		// evaluation in course
		if (isset($coursecode) && !empty($coursecode))
		{
			if (!array_key_exists($coursecode,$coursecodes))
			{
				$coursecodes[$coursecode] = '1';
				$users = array_merge($users, get_users_in_course($coursecode));
			}
		}
		// course independent evaluation
		else
		{
			$tbl_user = Database :: get_main_table(TABLE_MAIN_USER);
			$tbl_res = Database :: get_main_table(TABLE_MAIN_GRADEBOOK_RESULT);
			
			$sql = 'SELECT user.user_id,lastname,firstname'
					.' FROM '.$tbl_res.' as res, '.$tbl_user.' as user'
					.' WHERE res.evaluation_id = '.$eval->get_id()
					.' AND res.user_id = user.user_id';
			$result = api_sql_query($sql, __FILE__, __LINE__);
			$users = array_merge($users,get_user_array_from_mysql_result($result));
		}
	}
	
	foreach ($links as $link)
	{
		// links are always in a course
		$coursecode = $link->get_course_code();
		if (!array_key_exists($coursecode,$coursecodes))
		{
			$coursecodes[$coursecode] = '1';
			$users = array_merge($users, get_users_in_course($coursecode));
		}
	}
	
	unset ($coursecodes);
	
	return $users;
	
}


/**
 * Search students matching a given last name and/or first name
 * @author Bert Stepp锟