$tool_content .= "<fieldset>";
$tool_content .= "<script type='text/javascript' src='../auth/sorttable.js'></script>\n <form method='post' action='{$_SERVER['SCRIPT_NAME']}?course={$course_code}&book=" . $userID . "'>\n <table class='table-default sortable' id='t2'>";
$tool_content .= "<tr><th>" . $m['title'] . "</th>" . "<th>" . $langdate . "</th>" . "<th>{$langType}</th>";
$tool_content .= "<th width='60' class='center'>" . $langAttendanceBooking . "</th>";
$tool_content .= "</tr>";
} else {
$tool_content .= "<p class='alert1'>{$langAttendanceNoActMessage1} <a href='{$_SERVER['SCRIPT_NAME']}?course={$course_code}&addActivity=1'>{$langHere}</a> {$langAttendanceNoActMessage3}</p>\n";
}
//ui counter
if ($result) {
foreach ($result as $activ) {
//check if there is auto mechanism
if ($activ->auto == 1) {
//check for auto activities
if ($activ->module_auto_type) {
$userAttend = attendForAutoActivities($userID, $activ->module_auto_id, $activ->module_auto_type);
if ($userAttend == 0) {
$q = Database::get()->querySingle("SELECT attend FROM attendance_book WHERE attendance_activity_id = ?d AND uid = ?d", $activ->id, $userID);
if ($q) {
$userAttend = $q->attend;
}
}
}
} else {
$q = Database::get()->querySingle("SELECT attend FROM attendance_book WHERE attendance_activity_id = ?d AND uid = ?d", $activ->id, $userID);
if ($q) {
$userAttend = $q->attend;
} else {
$userAttend = 0;
}
}
/**
* @brief dislay user presences
* @global type $course_code
* @global type $tool_content
* @global type $langTitle
* @global type $langType
* @global type $langAttendanceNewBookRecord
* @global type $langDate
* @global type $langAttendanceNoActMessage1
* @global type $langAttendanceBooking
* @global type $langAttendanceActAttend
* @global type $langAttendanceActCour
* @global type $langAttendanceInsAut
* @global type $langAttendanceInsMan
* @global type $langGradebookUpToDegree
* @global type $langAttendanceBooking
* @param type $attendance_id
*/
function display_user_presences($attendance_id) {
global $course_code, $tool_content,
$langTitle, $langType, $langAttendanceNewBookRecord, $langDate,
$langAttendanceNoActMessage1, $langAttendanceBooking,
$langAttendanceActAttend, $langAttendanceActCour,
$langAttendanceInsAut, $langAttendanceInsMan,
$langAttendanceBooking;
$attendance_limit = get_attendance_limit($attendance_id);
$limit = isset($_REQUEST['limit']) ? intval($_REQUEST['limit']) : 0;
$userID = intval($_GET['book']); //user
//check if there are booking records for the user, otherwise alert message for first input
$checkForRecords = Database::get()->querySingle("SELECT COUNT(attendance_book.id) AS count FROM attendance_book, attendance_activities
WHERE attendance_book.attendance_activity_id = attendance_activities.id
AND uid = ?d AND attendance_activities.attendance_id = ?d", $userID, $attendance_id)->count;
if(!$checkForRecords) {
$tool_content .="<div class='alert alert-success'>$langAttendanceNewBookRecord</div>";
}
//get all the activities
$result = Database::get()->queryArray("SELECT * FROM attendance_activities WHERE attendance_id = ?d ORDER BY `DATE` DESC", $attendance_id);
$actNumber = count($result);
if ($actNumber > 0) {
$tool_content .= "<h5>". display_user($userID) ."</h5>";
$tool_content .= "<form method='post' action='$_SERVER[SCRIPT_NAME]?course=$course_code&attendance_id=$attendance_id&book=" . $userID . "' onsubmit=\"return checkrequired(this, 'antitle');\">
<table class='table-default'>";
$tool_content .= "<tr><th>$langTitle</th><th >$langDate</th><th>$langType</th>";
$tool_content .= "<th width='10' class='text-center'>$langAttendanceBooking</th>";
$tool_content .= "</tr>";
} else {
$tool_content .= "<div class='alert alert-warning'>$langAttendanceNoActMessage1</div>";
}
if ($result) {
foreach ($result as $activity) {
//check if there is auto mechanism
if($activity->auto == 1) {
if($activity->module_auto_type) { //assignments, exercises, lp(scorms)
$userAttend = attendForAutoActivities($userID, $activity->module_auto_id, $activity->module_auto_type);
if ($userAttend == 0) {
$q = Database::get()->querySingle("SELECT attend FROM attendance_book WHERE attendance_activity_id = ?d AND uid = ?d", $activity->id, $userID);
if ($q) {
$userAttend = $q->attend;
}
}
}
} else {
$q = Database::get()->querySingle("SELECT attend FROM attendance_book
WHERE attendance_activity_id = ?d AND uid = ?d", $activity->id, $userID);
if ($q) {
$userAttend = $q->attend;
} else {
$userAttend = 0;
}
}
$content = standard_text_escape($activity->description);
$tool_content .= "<tr><td><b>";
if (!empty($activity->title)) {
$tool_content .= q($activity->title);
}
$tool_content .= "</b>";
$tool_content .= "</td>";
if($activity->date){
$tool_content .= "<td><div class='smaller'><span class='day'>" . nice_format($activity->date, true, true) . "</div></td>";
} else {
$tool_content .= "<td>-</td>";
}
if ($activity->module_auto_id) {
$tool_content .= "<td class='smaller'>$langAttendanceActCour";
if ($activity->auto) {
$tool_content .= "<br>($langAttendanceInsAut)";
} else {
$tool_content .= "<br>($langAttendanceInsMan)";
}
$tool_content .= "</td>";
} else {
$tool_content .= "<td class='smaller'>$langAttendanceActAttend</td>";
}
$tool_content .= "<td class='text-center'>
<input type='checkbox' value='1' name='" . $activity->id . "'";
if(isset($userAttend) && $userAttend) {
$tool_content .= " checked";
}
$tool_content .= ">
<input type='hidden' value='" . $userID . "' name='userID'>
</td></tr>";
} // end of while
}
$tool_content .= "</table>";
$tool_content .= "<div class='pull-right'><input class='btn btn-primary' type='submit' name='bookUser' value='$langAttendanceBooking'></div>";
}
