4require_once 
"./Services/Object/classes/class.ilObject.php";
 
    5require_once 
"./Modules/Exercise/classes/class.ilExerciseMembers.php";
 
   66    public function __construct($a_id = 0, $a_call_by_reference = 
true)
 
   70        $this->db = 
$DIC->database();
 
   71        $this->app_event_handler = 
$DIC[
"ilAppEventHandler"];
 
   72        $this->lng = 
$DIC->language();
 
   73        $this->
user = $DIC->user();
 
   76        $this->webFilesystem = 
$DIC->filesystem()->web();
 
   78        parent::__construct($a_id, $a_call_by_reference);
 
   82    public function setDate($a_hour, $a_minutes, $a_day, $a_month, $a_year)
 
   84        $this->hour = (int) $a_hour;
 
   85        $this->minutes = (int) $a_minutes;
 
   86        $this->day = (int) $a_day;
 
   87        $this->month = (int) $a_month;
 
   88        $this->year = (int) $a_year;
 
   89        $this->timestamp = mktime($this->hour, $this->minutes, 0, $this->month, $this->day, $this->year);
 
   98        $this->timestamp = $a_timestamp;
 
  102        $this->instruction = $a_instruction;
 
  116        $this->pass_mode = $a_val;
 
  126        return $this->pass_mode;
 
  136        $this->pass_nr = $a_val;
 
  146        return $this->pass_nr;
 
  156        $this->show_submissions = $a_val;
 
  166        return $this->show_submissions;
 
  177        return  $this->hour == (int) date(
"H", $this->timestamp) and
 
  178            $this->minutes == (int) date(
"i", $this->timestamp) and
 
  179            $this->day == (int) date(
"d", $this->timestamp) and
 
  180            $this->month == (int) date(
"m", $this->timestamp) and
 
  181            $this->year == (int) date(
"Y", $this->timestamp);
 
  206        $this->tutor_feedback = $a_value;
 
  213        $ilDB->insert(
"exc_data", array(
 
  214            "obj_id" => array(
"integer", $this->
getId()),
 
  216            "time_stamp" => array(
"integer", $this->
getTimestamp()),
 
  217            "pass_mode" => array(
"text", $this->
getPassMode()),
 
  218            "pass_nr" => array(
"text", $this->
getPassNr()),
 
  234    public function cloneObject($a_target_id, $a_copy_id = 0, $a_omit_tree = 
false)
 
  239        $new_obj = parent::cloneObject($a_target_id, $a_copy_id, $a_omit_tree);
 
  243        $new_obj->saveData();
 
  254        $crit_cat_map = array();
 
  255        include_once(
"./Modules/Exercise/classes/class.ilExcCriteriaCatalogue.php");
 
  257            $new_id = $crit_cat->cloneObject($new_obj->getId());
 
  258            $crit_cat_map[$crit_cat->getId()] = $new_id;
 
  262        include_once(
"./Modules/Exercise/classes/class.ilExAssignment.php");
 
  266        include_once(
'Services/Tracking/classes/class.ilLPObjSettings.php');
 
  268        $obj_settings->cloneSettings($new_obj->getId());
 
  269        unset($obj_settings);
 
  278            $this->webFilesystem,
 
  283        $cloneAction->cloneCertificate($this, $new_obj);
 
  294    public function delete()
 
  300        if (!parent::delete()) {
 
  304        $ilDB->manipulate(
"DELETE FROM exc_data " .
 
  305            "WHERE obj_id = " . 
$ilDB->quote($this->getId(), 
"integer"));
 
  307        include_once 
"Modules/Exercise/classes/class.ilExcCriteriaCatalogue.php";
 
  311        include_once 
"./Services/Notification/classes/class.ilNotification.php";
 
  314        $ilAppEventHandler->raise(
 
  317            array(
'obj_id' => $this->
getId())
 
  329        $query = 
"SELECT * FROM exc_data " .
 
  330            "WHERE obj_id = " . 
$ilDB->quote($this->
getId(), 
"integer");
 
  336            $pm = (
$row->pass_mode == 
"")
 
  339            $this->setPassMode($pm);
 
  341            if (
$row->pass_mode == 
"nr") {
 
  366        $ilDB->update(
"exc_data", array(
 
  368            "time_stamp" => array(
"integer", $this->
getTimestamp()),
 
  369            "pass_mode" => array(
"text", $this->
getPassMode()),
 
  370            "pass_nr" => array(
"integer", $this->
getPassNr()),
 
  375            "obj_id" => array(
"integer", $this->
getId())
 
  391        $lng->loadLanguageModule(
"exc");
 
  404        $body .= 
$lng->txt(
"exc_edit_until") . 
": ";
 
  406          ? 
$lng->txt(
"exc_no_deadline_specified")
 
  410        include_once 
"Services/Link/classes/class.ilLink.php";
 
  415        $file_names = array();
 
  416        include_once(
"./Modules/Exercise/classes/class.ilFSStorageExercise.php");
 
  418        $files = $storage->getFiles();
 
  420            include_once 
"./Services/Mail/classes/class.ilFileDataMail.php";
 
  422            foreach (
$files as $file) {
 
  423                $mfile_obj->copyAttachmentFile($file[
"fullpath"], $file[
"name"]);
 
  424                $file_names[] = $file[
"name"];
 
  429        $recipients = array();
 
  430        foreach ($a_members as $member_id) {
 
  432            $recipients[] = $tmp_obj->getLogin();
 
  435        $recipients = implode(
",", $recipients);
 
  438        include_once 
"Services/Mail/classes/class.ilMail.php";
 
  440        $errors = $tmp_mail_obj->sendMail(
 
  449        unset($tmp_mail_obj);
 
  452        if (
sizeof($file_names)) {
 
  453            $mfile_obj->unlinkFiles($file_names);
 
  458        foreach ($a_members as $member_id) {
 
  460            $member_status->setSent(
true);
 
  461            $member_status->update();
 
  474        if ($a_user_id == 0) {
 
  478        include_once(
"./Modules/Exercise/classes/class.ilExAssignment.php");
 
  481        $passed_all_mandatory = 
true;
 
  482        $failed_a_mandatory = 
false;
 
  485        $passed_at_least_one = 
false;
 
  487        foreach ($ass as $a) {
 
  488            $stat = $a->getMemberStatus($a_user_id)->getStatus();
 
  489            if ($a->getMandatory() && ($stat == 
"failed" || $stat == 
"notgraded")) {
 
  490                $passed_all_mandatory = 
false;
 
  492            if ($a->getMandatory() && ($stat == 
"failed")) {
 
  493                $failed_a_mandatory = 
true;
 
  495            if ($stat == 
"passed") {
 
  498            if ($stat == 
"notgraded") {
 
  503        if (count($ass) == 0) {
 
  504            $passed_all_mandatory = 
false;
 
  509            $overall_stat = 
"notgraded";
 
  510            if ($failed_a_mandatory) {
 
  512                $overall_stat = 
"failed";
 
  513            } elseif ($passed_all_mandatory && $cnt_passed > 0) {
 
  515                $overall_stat = 
"passed";
 
  520            $overall_stat = 
"notgraded";
 
  522            if ($failed_a_mandatory || ($cnt_passed + $cnt_notgraded < $min_nr)) {
 
  524                $overall_stat = 
"failed";
 
  525            } elseif ($passed_all_mandatory && $cnt_passed >= $min_nr) {
 
  527                $overall_stat = 
"passed";
 
  532            "overall_status" => $overall_stat,
 
  533            "failed_a_mandatory" => $failed_a_mandatory);
 
  546        if ($a_user_id == 0) {
 
  552        include_once(
"./Modules/Exercise/classes/class.ilExerciseMembers.php");
 
  556            $st[
"overall_status"]
 
  565        if (!is_object($this->members_obj)) {
 
  569        $mems = $this->members_obj->getMembers();
 
  570        foreach ($mems as $mem) {
 
  580        include_once(
"./Modules/Exercise/classes/class.ilExAssignment.php");
 
  583        include_once 
"./Services/Excel/classes/class.ilExcel.php";
 
  585        $excel->addSheet($this->lng->txt(
"exc_status"));
 
  594        $excel->setCell(
$row, 0, $this->lng->txt(
"name"));
 
  595        foreach ($ass_data as $ass) {
 
  596            $excel->setCell(
$row, $cnt++, ($cnt / 2) . 
" - ". $this->lng->txt(
"exc_tbl_status"));
 
  597            $excel->setCell(
$row, $cnt++, (($cnt - 1) / 2) . 
" - ". $this->lng->txt(
"exc_tbl_mark"));
 
  599        $excel->setCell(
$row, $cnt++, $this->lng->txt(
"exc_total_exc"));
 
  600        $excel->setCell(
$row, $cnt++, $this->lng->txt(
"exc_mark"));
 
  601        $excel->setCell(
$row++, $cnt, $this->lng->txt(
"exc_comment_for_learner"));
 
  602        $excel->setBold(
"A1:" . $excel->getColumnCoord($cnt) . 
"1");
 
  607        $filtered_members = 
$GLOBALS[
'DIC']->access()->filterUserIdsByRbacOrPositionOfCurrentUser(
 
  608            'edit_submissions_grades',
 
  609            'edit_submissions_grades',
 
  611            (array) $mem_obj->getMembers()
 
  614        foreach ((array) $filtered_members as $user_id) {
 
  619        include_once 
'Services/Tracking/classes/class.ilLPMarks.php';
 
  620        foreach ($mems as $user_id => 
$d) {
 
  624            $excel->setCell(
$row, $col++, 
$d[
"lastname"] . 
", " . 
$d[
"firstname"] . 
" [" . 
$d[
"login"] . 
"]");
 
  627            foreach ($ass_data as $ass) {
 
  628                $status = $ass->getMemberStatus($user_id)->getStatus();
 
  629                $mark = $ass->getMemberStatus($user_id)->getMark();
 
  630                $excel->setCell(
$row, $col++, $this->lng->txt(
"exc_" . $status));
 
  631                $excel->setCell(
$row, $col++, $mark);
 
  636            $excel->setCell(
$row, $col++, $this->lng->txt(
"exc_" . $status));
 
  640            $excel->setCell(
$row, $col++, $marks_obj->getMark());
 
  641            $excel->setCell(
$row++, $col, $marks_obj->getComment());
 
  649        $excel->addSheet($this->lng->txt(
"exc_mark"));
 
  653        $excel->setCell(
$row, 0, $this->lng->txt(
"name"));
 
  654        foreach ($ass_data as $ass) {
 
  655            $excel->setCell(
$row, $cnt++, $cnt - 1);
 
  657        $excel->setCell(
$row++, $cnt++, $this->lng->txt(
"exc_total_exc"));
 
  658        $excel->setBold(
"A1:" . $excel->getColumnCoord($cnt) . 
"1");
 
  662        foreach ($mems as $user_id => 
$d) {
 
  667            $excel->setCell(
$row, $col++, 
$d[
"lastname"] . 
", " . 
$d[
"firstname"] . 
" [" . 
$d[
"login"] . 
"]");
 
  670            foreach ($ass_data as $ass) {
 
  671                $excel->setCell(
$row, $col++, $ass->getMemberStatus($user_id)->getMark());
 
  679        $excel->sendToClient($exc_name);
 
  687        $user_ids = $a_user_id;
 
  688        if (!is_array($user_ids)) {
 
  689            $user_ids = array($user_ids);
 
  692        include_once(
"./Modules/Exercise/classes/class.ilExerciseMailNotification.php");
 
  694        $type = (bool) $a_is_text_feedback
 
  699        $not->setType(
$type);
 
  700        $not->setAssignmentId($a_ass_id);
 
  701        $not->setObjId($this->
getId());
 
  705        $not->setRecipients($user_ids);
 
  733        $this->completion_by_submission = (bool) $bool;
 
  740        $a_has_submitted = (bool) $a_has_submitted;
 
  742        include_once(
"./Modules/Exercise/classes/class.ilExerciseMembers.php");
 
  743        foreach ($a_user_ids as $user_id) {
 
  745            $member_status->setReturned($a_has_submitted);
 
  746            $member_status->update();
 
  753            foreach ($a_user_ids as $user_id) {
 
  754                $status = 
'notgraded';
 
  755                if ($a_has_submitted) {
 
  756                    if (!is_array($a_valid_submissions) ||
 
  757                        $a_valid_submissions[$user_id]) {
 
  763                $member_status->setStatus($status);
 
  764                $member_status->update();
 
  781        $set = 
$ilDB->query(
"SELECT obj_id, status FROM exc_members" .
 
  782            " WHERE usr_id = " . 
$ilDB->quote($a_user_id, 
"integer") .
 
  783            " AND (status = " . 
$ilDB->quote(
"passed", 
"text") .
 
  784            " OR status = " . 
$ilDB->quote(
"failed", 
"text") . 
")");
 
  788            $all[
$row[
"obj_id"]] = (
$row[
"status"] == 
"passed");
 
  802        return (strlen($this->certificate_visibility)) ? $this->certificate_visibility : 0;
 
  813        $this->certificate_visibility = $a_value;
 
  826        $affectedRows = 
$ilDB->manipulateF(
 
  827            "UPDATE exc_data SET certificate_visibility = %s WHERE obj_id = %s",
 
  828            array(
'integer', 
'integer'),
 
  829            array($a_value, $this->
getId())
 
  841        return (
bool) $exc_set->get(
"add_to_pd", 
true);
 
An exception for terminatinating execution or to throw for unit testing.
static formatDate(ilDateTime $date, $a_skip_day=false, $a_include_wd=false, $include_seconds=false)
Format a date @access public.
@classDescription Date and time handling
getExerciseId()
Get exercise id.
getId()
Get assignment id.
getInstruction()
Get instruction.
static getInstancesByExercise($a_exc_id)
static cloneAssignmentsOfExercise($a_old_exc_id, $a_new_exc_id, array $a_crit_cat_map)
Clone assignments of exercise.
getMemberStatus($a_user_id=null)
getDeadline()
Get deadline (timestamp)
static getInstancesByParentId($a_parent_id)
static deleteByParent($a_parent_id)
const TYPE_FEEDBACK_FILE_ADDED
const TYPE_FEEDBACK_TEXT_ADDED
static _writeReturned($a_obj_id, $a_user_id, $a_status)
Write returned status.
static _lookupStatus($a_obj_id, $a_user_id)
Lookup current status (notgraded|passed|failed)
static _writeStatus($a_obj_id, $a_user_id, $a_status)
Write user status.
static _lookupMark($a_usr_id, $a_obj_id)
static _getLink($a_ref_id, $a_type='', $a_params=array(), $append="")
static removeForObject($type, $id)
Remove all notifications for given object.
const TYPE_EXERCISE_SUBMISSION
static _lookupFinishedUserExercises($a_user_id)
Get all exercises for user.
const TUTOR_FEEDBACK_TEXT
hasAddToDesktop()
Add to desktop after hand-in.
sendFeedbackFileNotification($a_feedback_file, $a_user_id, $a_ass_id, $a_is_text_feedback=false)
Send feedback file notification to user.
setTimestamp($a_timestamp)
determinStatusOfUser($a_user_id=0)
Determine status of user.
updateAllUsersStatus()
Update status of all users.
setPassNr($a_val)
Set number of assignments that must be passed to pass the exercise.
const TUTOR_FEEDBACK_MAIL
getShowSubmissions()
Get whether submissions of learners should be shown to other learners after deadline.
setShowSubmissions($a_val)
Set whether submissions of learners should be shown to other learners after deadline.
__construct($a_id=0, $a_call_by_reference=true)
Constructor @access public.
const TUTOR_FEEDBACK_FILE
processExerciseStatus(ilExAssignment $a_ass, array $a_user_ids, $a_has_submitted, array $a_valid_submissions=null)
update()
update object in db
saveCertificateVisibility($a_value)
Saves the visibility settings of the certificate.
setTutorFeedback($a_value)
updateUserStatus($a_user_id=0)
Update exercise status of user.
setCertificateVisibility($a_value)
Sets the visibility settings of the certificate.
exportGradesExcel()
Exports grades as excel.
setPassMode($a_val)
Set pass mode (all | nr)
setInstruction($a_instruction)
getPassNr()
Get number of assignments that must be passed to pass the exercise.
$completion_by_submission
setDate($a_hour, $a_minutes, $a_day, $a_month, $a_year)
getCertificateVisibility()
Returns the visibility settings of the certificate.
read()
read object data from db into object
sendAssignment(ilExAssignment $a_ass, $a_members)
send exercise per mail to members
cloneObject($a_target_id, $a_copy_id=0, $a_omit_tree=false)
Clone exercise (no member data)
setCompletionBySubmission($bool)
Enabled/Disable completion by submission.
isCompletionBySubmissionEnabled()
Checks whether completion by submission is enabled or not.
getPassMode()
Get pass mode (all | nr)
static _lookupName($a_user_id)
lookup user name
static getInstanceByObjId($a_obj_id, $stop_on_error=true)
get an instance of an Ilias object by object id
Class ilObject Basic functions for all objects.
getRefId()
get reference id @access public
getId()
get object id @access public
getTitle()
get object title @access public
static sortArray( $array, $a_array_sortby, $a_array_sortorder=0, $a_numeric=false, $a_keep_keys=false)
sortArray
static getASCIIFilename($a_filename)
convert utf8 to ascii filename
for( $i=6;$i< 13;$i++) for($i=1; $i< 13; $i++) $d
$GLOBALS['JPEG_Segment_Names']
Global Variable: XMP_tag_captions.
update($pash, $contents, Config $config)
foreach($_POST as $key=> $value) $res