7include_once
'./Services/Tracking/classes/class.ilLPStatus.php';
63 $set =
$ilDB->query(
"SELECT survey_id FROM svy_svy" .
64 " WHERE obj_fi = " .
$ilDB->quote($a_obj_id));
65 $row =
$ilDB->fetchAssoc($set);
66 return (
int) $row[
"survey_id"];
82 $sql =
"SELECT user_fi FROM svy_finished fin" .
83 " WHERE fin.survey_fi = " .
$ilDB->quote($survey_id,
"integer");
85 if ($a_only_finished) {
86 $sql .=
" AND fin.state = " .
$ilDB->quote(1,
"integer");
89 $set =
$ilDB->query($sql);
90 while ($row =
$ilDB->fetchAssoc($set)) {
91 $res[] = $row[
"user_fi"];
An exception for terminatinating execution or to throw for unit testing.
determineStatus($a_obj_id, $a_user_id, $a_obj=null)
Determine status.
static getParticipants($a_obj_id, $a_only_finished=false)
static _getInProgress($a_obj_id)
static _getCompleted($a_obj_id)
static getSurveyId($a_obj_id)
Abstract class ilLPStatus for all learning progress modes E.g ilLPStatusManual, ilLPStatusObjectives ...
const LP_STATUS_COMPLETED_NUM
const LP_STATUS_IN_PROGRESS_NUM
const LP_STATUS_NOT_ATTEMPTED_NUM
static _isSurveyParticipant($user_id, $survey_id)
static _lookupFinished($a_obj_id, $a_user_id="")
get finished status
foreach($_POST as $key=> $value) $res