function _lookupRemainingWorkingTimeString($a_obj_id)
{
global $ilDB, $lng;
$q = "SELECT MIN(deadline) mtime FROM rep_robj_xeph_assign WHERE eph_id = " . $ilDB->quote($a_obj_id, "integer") . " AND deadline > " . $ilDB->quote(time(), "integer");
$set = $ilDB->query($q);
$rec = $ilDB->fetchAssoc($set);
if ($rec["mtime"] > 0) {
$time_str = ilObjEphorus::period2String(new ilDateTime($rec["mtime"], IL_CAL_UNIX));
}
return $time_str;
}
function updateStatusOfUser($a_ass_id, $a_user_id, $a_status)
{
global $ilDB;
$ilDB->manipulateF("UPDATE rep_robj_xeph_ass_stat " . "SET status = %s, status_time= %s " . "WHERE ass_id = %s AND user_id = %s AND status <> %s ", array("text", "timestamp", "integer", "integer", "text"), array($a_status, ilUtil::now(), $a_ass_id, $a_user_id, $a_status));
$ass = new ilEphAssignment($a_ass_id);
$eph = new ilObjEphorus($ass->getEphorusRefId());
$eph->updateUserStatus($a_user_id);
}
/**
* Get time string for deadline
*/
function getTimeString($a_deadline)
{
global $lng;
if ($a_deadline - time() <= 0) {
$time_str = $lng->txt("rep_robj_xeph_time_over_short");
} else {
$time_str = ilObjEphorus::period2String(new ilDateTime($a_deadline, IL_CAL_UNIX));
}
return $time_str;
}
