Class ilExerciseMembers. More...

Public Member Functions
	ilExerciseMembers ($a_obj_id, $a_ref_id)
	getRefId ()
	getObjId ()
	setObjId ($a_obj_id)
	getMembers ()
	setMembers ($a_members)
	assignMember ($a_usr_id)
	isAssigned ($a_id)
	assignMembers ($a_members)
	deassignMember ($a_usr_id)
	deassignMembers ($a_members)
	setStatus ($a_status)
	getStatus ()
	getStatusByMember ($a_member_id)
	setStatusForMember ($a_member_id, $a_status)
	set status for member (notgraded\|passed\|failed)
	updateStatusTimeForMember ($a_member_id)
	Update status time (last change) for member.
	setStatusSent ($a_status)
	getStatusSent ()
	getStatusSentByMember ($a_member_id)
	setStatusSentForMember ($a_member_id, $a_status)
	getStatusReturned ()
	setStatusReturned ($a_status)
	getStatusReturnedByMember ($a_member_id)
	setStatusReturnedForMember ($a_member_id, $a_status)
	setStatusFeedback ($a_status)
	getStatusFeedback ()
	getStatusFeedbackByMember ($a_member_id)
	setStatusFeedbackForMember ($a_member_id, $a_status)
	getNotice ()
	setNotice ($a_notice)
	getNoticeByMember ($a_member_id)
	hasReturned ($a_member_id)
	getAllDeliveredFiles ()
&	getDeliveredFiles ($a_member_id)
	Returns an array of all delivered files of an user.
	deleteDeliveredFiles ($file_id_array, $a_member_id)
	Deletes already delivered files.
	deliverReturnedFiles ($a_member_id, $a_only_new=false)
	Delivers the returned files of an user.
	updateTutorDownloadTime ($a_member_id)
	Update the timestamp of the last download of current user (=tutor) for member $a_member_id.
	downloadSelectedFiles ($array_file_id)
	downloadSingleFile ($filename, $filetitle)
	downloadMultipleFiles ($array_filenames, $pathname)
	setNoticeForMember ($a_member_id, $a_notice)
	read ()
	ilClone ($a_new_id)
	delete ()
	_getMembers ($a_obj_id)
	_getReturned ($a_obj_id)
	_getPassedUsers ($a_obj_id)
	_getFailedUsers ($a_obj_id)
	_lookupStatus ($a_obj_id, $a_user_id)
	lookup current status (notgraded\|passed\|failed)
Data Fields
	$ilias
	$ref_id
	$obj_id
	$members
	$status
	$status_feedback
	$status_sent
	$status_returned
	$notice

Detailed Description

Class ilExerciseMembers.

Author:: Stefan Meyer <smeyer@databay.de>

Version:

Id:: class.ilExerciseMembers.php 11760 2006-08-03 08:35:29Z smeyer

Definition at line 33 of file class.ilExerciseMembers.php.

Member Function Documentation

ilExerciseMembers::_getFailedUsers ( $ a_obj_id )

Definition at line 804 of file class.ilExerciseMembers.php.

References $query, $res, and $row.

Referenced by ilLPStatusExerciseReturned::_getFailed().

        {
                global $ilDB;

                $query = "SELECT DISTINCT(usr_id) FROM exc_members ".
                        "WHERE obj_id = '".$a_obj_id."' ".
                        "AND status = 'failed'";
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $usr_ids[] = $row->usr_id;
                }
                return $usr_ids ? $usr_ids : array();
        }

Here is the caller graph for this function:

ilExerciseMembers::_getMembers ( $ a_obj_id )

Definition at line 752 of file class.ilExerciseMembers.php.

References $query, $res, and $row.

Referenced by ilLPStatusExerciseReturned::_getNotAttempted().

        {
                global $ilDB;

                $query = "SELECT DISTINCT(usr_id) as ud FROM exc_members ".
                        "WHERE obj_id = '".$a_obj_id."'";

                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $usr_ids[] = $row->ud;
                }

                return $usr_ids ? $usr_ids : array();
        }

Here is the caller graph for this function:

ilExerciseMembers::_getPassedUsers ( $ a_obj_id )

Definition at line 789 of file class.ilExerciseMembers.php.

References $query, $res, and $row.

Referenced by ilLPStatusExerciseReturned::_getCompleted().

        {
                global $ilDB;

                $query = "SELECT DISTINCT(usr_id) FROM exc_members ".
                        "WHERE obj_id = '".$a_obj_id."' ".
                        "AND status = 'passed'";
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $usr_ids[] = $row->usr_id;
                }
                return $usr_ids ? $usr_ids : array();
        }

Here is the caller graph for this function:

ilExerciseMembers::_getReturned ( $ a_obj_id )

Definition at line 768 of file class.ilExerciseMembers.php.

References $query, $res, and $row.

Referenced by ilLPStatusExerciseReturned::_getInProgress().

        {
                global $ilDB;

                $query = "SELECT DISTINCT(usr_id) as ud FROM exc_members ".
                        "WHERE obj_id = '".$a_obj_id."' ".
                        "AND returned = 1";

                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $usr_ids[] = $row->ud;
                }

                return $usr_ids ? $usr_ids : array();
        }

Here is the caller graph for this function:

ilExerciseMembers::_lookupStatus	(	$	a_obj_id,
		$	a_user_id
	)

lookup current status (notgraded|passed|failed)

Parameters:

	int	$a_obj_id exercise id
	int	$a_user_id member id

Returns:: mixed false (if user is no member) or notgraded|passed|failed

Definition at line 825 of file class.ilExerciseMembers.php.

References $query, $res, and $row.

Referenced by ilObjExercise::_checkCondition(), ilObjExerciseGUI::infoScreen(), and ilObjExerciseGUI::membersObject().

        {
                global $ilDB;

                $query = "SELECT status FROM exc_members ".
                        "WHERE obj_id = ".$ilDB->quote($a_obj_id).
                        "AND usr_id = ".$ilDB->quote($a_user_id);

                $res = $ilDB->query($query);
                if($row = $res->fetchRow(DB_FETCHMODE_ASSOC))
                {
                        return $row["status"];
                }

                return false;
        }

Here is the caller graph for this function:

ilExerciseMembers::assignMember ( $ a_usr_id )

Definition at line 76 of file class.ilExerciseMembers.php.

References $query, $res, $tmp_user, ilObjectFactory::getInstanceByObjId(), getRefId(), and read().

Referenced by assignMembers().

        {
                $tmp_user = ilObjectFactory::getInstanceByObjId($a_usr_id);
                $tmp_user->addDesktopItem($this->getRefId(),"exc");


                $query = "REPLACE INTO exc_members ".
                        "SET obj_id = '".$this->getObjId()."', ".
                        "usr_id = '".$a_usr_id."', ".
                        "status = 'notgraded', sent = '0', feedback='0'";

                $res = $this->ilias->db->query($query);
                $this->read();

                return true;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilExerciseMembers::assignMembers ( $ a_members )

Definition at line 97 of file class.ilExerciseMembers.php.

References assignMember(), and isAssigned().

        {
                $assigned = 0;
                if(is_array($a_members))
                {
                        foreach($a_members as $member)
                        {
                                if(!$this->isAssigned($member))
                                {
                                        $this->assignMember($member);
                                }
                                else
                                {
                                        ++$assigned;
                                }
                        }
                }
                if($assigned == count($a_members))
                {
                        return false;
                }
                else
                {
                        return true;
                }
        }

Here is the call graph for this function:

ilExerciseMembers::deassignMember ( $ a_usr_id )

Definition at line 123 of file class.ilExerciseMembers.php.

References $dir, $key, $query, $tmp_user, deleteDeliveredFiles(), getDeliveredFiles(), ilObjectFactory::getInstanceByObjId(), getRefId(), and read().

Referenced by deassignMembers().

        {
                $tmp_user = ilObjectFactory::getInstanceByObjId($a_usr_id);
                $tmp_user->dropDesktopItem($this->getRefId(),"exc");

                $query = "DELETE FROM exc_members ".
                        "WHERE obj_id = '".$this->getObjId()." '".
                        "AND usr_id = '".$a_usr_id."'";

                $this->ilias->db->query($query);
                $this->read();
                // delete all delivered files of the member
                $delivered_files =& $this->getDeliveredFiles($a_usr_id);
                $files_to_delete = array();
                $userfile = "";
                foreach ($delivered_files as $key => $value)
                {
                        array_push($files_to_delete, $value["returned_id"]);
                        $userfile = $value["filename"];
                }
                $this->deleteDeliveredFiles($files_to_delete, $a_usr_id);
                // delete the user directory if existing
                if ($userfile)
                {
                        $pathinfo = pathinfo($userfile);
                        $dir = $pathinfo["dirname"];
                }
                if (is_dir($dir))
                {
                        rmdir($dir);
                }
                return false;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilExerciseMembers::deassignMembers ( $ a_members )

Definition at line 157 of file class.ilExerciseMembers.php.

References deassignMember().

        {
                if(is_array($a_members))
                {
                        foreach($a_members as $member)
                        {
                                $this->deassignMember($member);
                        }
                }
                else
                {
                        return false;
                }
        }

Here is the call graph for this function:

ilExerciseMembers::delete ( )

Definition at line 710 of file class.ilExerciseMembers.php.

References $query.

        {
                $query = "DELETE FROM exc_members WHERE obj_id = '".$this->getObjId()."'";
                $this->ilias->db->query($query);

                return true;
        }

ilExerciseMembers::deleteDeliveredFiles	(	$	file_id_array,
		$	a_member_id
	)

Deletes already delivered files.

Parameters:

	array	$file_id_array An array containing database ids of the delivered files
	numeric	$a_member_id The database id of the user public

Definition at line 417 of file class.ilExerciseMembers.php.

References $key, $query, $result, and $row.

Referenced by deassignMember().

        {
                if (count($file_id_array))
                {
                        $query = sprintf("SELECT * FROM exc_returned WHERE user_id = %s AND returned_id IN (" . join($file_id_array, ",") . ")",
                                $this->ilias->db->quote($a_member_id . "")
                        );
                        $result = $this->ilias->db->query($query);
                        if ($result->numRows())
                        {
                                $result_array = array();
                                while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                                {
                                        array_push($result_array, $row);
                                }
                                // delete the entries in the database
                                $query = sprintf("DELETE FROM exc_returned WHERE user_id = %s AND returned_id IN (" . join($file_id_array, ",") . ")",
                                        $this->ilias->db->quote($a_member_id . "")
                                );
                                $result = $this->ilias->db->query($query);
                                // delete the files
                                foreach ($result_array as $key => $value)
                                {
                                        unlink($value["filename"]);
                                }
                        }
                }
        }

Here is the caller graph for this function:

ilExerciseMembers::deliverReturnedFiles	(	$	a_member_id,
		$	a_only_new = `false`
	)

Delivers the returned files of an user.

Parameters:

numeric

$a_member_id The database id of the user public

Definition at line 451 of file class.ilExerciseMembers.php.

References $dir, $file, $q, $query, $result, $row, downloadMultipleFiles(), downloadSingleFile(), getObjId(), and updateTutorDownloadTime().

        {
                global $ilUser, $ilDB;
                
                // get last download time
                $and_str = "";
                if ($a_only_new)
                {
                        $q = "SELECT download_time FROM exc_usr_tutor WHERE ".
                                " obj_id = ".$ilDB->quote($this->getObjId())." AND ".
                                " usr_id = ".$ilDB->quote($a_member_id)." AND ".
                                " tutor_id = ".$ilDB->quote($ilUser->getId());
                        $lu_set = $ilDB->query($q);
                        if ($lu_rec = $lu_set->fetchRow(DB_FETCHMODE_ASSOC))
                        {
                                if ($lu_rec["download_time"] > 0)
                                {
                                        $and_str = " AND timestamp > ".$ilDB->quote($lu_rec["download_time"]);
                                }
                        }
                }
                
                $this->updateTutorDownloadTime($a_member_id);
                
                $query = sprintf("SELECT * FROM exc_returned WHERE obj_id = %s AND user_id = %s".
                        $and_str,
                        $this->ilias->db->quote($this->getObjId() . ""),
                        $this->ilias->db->quote($a_member_id . "")
                );
                $result = $this->ilias->db->query($query);
                $count = $result->numRows();
                if ($count == 1)
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        $this->downloadSingleFile($row["filename"], $row["filetitle"]);
                }
                else
                {
                        $array_files = array();
                        $filename = "";
                        while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                        {
                                $filename = $row["filename"];
                                $pathinfo = pathinfo($filename);
                                $dir = $pathinfo["dirname"];
                                $file = $pathinfo["basename"];
                                array_push($array_files, $file);
                        }
                        $pathinfo = pathinfo($filename);
                        $dir = $pathinfo["dirname"];
                        $this->downloadMultipleFiles($array_files, $dir);
                }
        }

Here is the call graph for this function:

ilExerciseMembers::downloadMultipleFiles	(	$	array_filenames,
		$	pathname
	)

Definition at line 563 of file class.ilExerciseMembers.php.

References $key, $lng, ilUtil::deliverFile(), ilUtil::escapeShellArg(), and ilUtil::ilTempnam().

Referenced by deliverReturnedFiles(), and downloadSelectedFiles().

        {
                global $lng;
                require_once "./classes/class.ilUtil.php";
                $cdir = getcwd();
                chdir($pathname);
                $zip = PATH_TO_ZIP;
                $tmpfile = ilUtil::ilTempnam();
                $tmpzipfile = $tmpfile . ".zip";
                foreach ($array_filenames as $key => $filename)
                {
                        $array_filenames[$key] = ilUtil::escapeShellArg($array_filenames[$key]);
                }
                $zipcmd = $zip." ".ilUtil::escapeShellArg($tmpzipfile)." ".join($array_filenames, " ");
                exec($zipcmd);
                ilUtil::deliverFile($tmpzipfile, strtolower($lng->txt("excs")) . ".zip");
                chdir($cdir);
                unlink($tmpfile);
                unlink($tmpzipfile);
        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilExerciseMembers::downloadSelectedFiles ( $ array_file_id )

Definition at line 522 of file class.ilExerciseMembers.php.

References $dir, $file, $key, $query, $result, $row, downloadMultipleFiles(), and downloadSingleFile().

        {
                if (count($array_file_id))
                {
                        $query = "SELECT * FROM exc_returned WHERE returned_id IN (" . join($array_file_id, ",") . ")";
                        $result = $this->ilias->db->query($query);
                        if ($result->numRows())
                        {
                                $array_found = array();
                                while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                                {
                                        array_push($array_found, $row);
                                }
                                if (count($array_found) == 1)
                                {
                                        $this->downloadSingleFile($array_found[0]["filename"], $array_found[0]["filetitle"]);
                                }
                                else
                                {
                                        $filenames = array();
                                        $dir = "";
                                        $file = "";
                                        foreach ($array_found as $key => $value)
                                        {
                                                $pathinfo = pathinfo($value["filename"]);
                                                $dir = $pathinfo["dirname"];
                                                $file = $pathinfo["basename"];
                                                array_push($filenames, $file); 
                                        }
                                        $this->downloadMultipleFiles($filenames, $dir);
                                }
                        }
                }
        }

Here is the call graph for this function:

ilExerciseMembers::downloadSingleFile	(	$	filename,
		$	filetitle
	)

Definition at line 557 of file class.ilExerciseMembers.php.

References ilUtil::deliverFile().

Referenced by deliverReturnedFiles(), and downloadSelectedFiles().

        {
                require_once "./classes/class.ilUtil.php";
                ilUtil::deliverFile($filename, $filetitle);
        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilExerciseMembers::getAllDeliveredFiles ( )

Definition at line 374 of file class.ilExerciseMembers.php.

References $query, $res, and $row.

        {
                $query = "SELECT * FROM exc_returned WHERE obj_id = '".$this->getObjId()."'";

                $res = $this->ilias->db->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_ASSOC))
                {
                        $delivered[] = $row;
                }
                return $delivered ? $delivered : array();
        }

& ilExerciseMembers::getDeliveredFiles ( $ a_member_id )

Returns an array of all delivered files of an user.

Parameters:

numeric

$a_member_id The user id public

Returns:: array An array containing the information on the delivered files

Definition at line 393 of file class.ilExerciseMembers.php.

References $query, $result, and $row.

Referenced by deassignMember().

        {
                $query = sprintf("SELECT *, TIMESTAMP + 0 AS TIMESTAMP14 FROM exc_returned WHERE obj_id = %s AND user_id = %s ORDER BY TIMESTAMP14",
                        $this->ilias->db->quote($this->getObjId() . ""),
                        $this->ilias->db->quote($a_member_id . "")
                );
                $result = $this->ilias->db->query($query);
                $delivered_files = array();
                if ($result->numRows())
                {
                        while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                        {
                                array_push($delivered_files, $row);
                        }
                }
                return $delivered_files;
        }

Here is the caller graph for this function:

ilExerciseMembers::getMembers ( )

Definition at line 68 of file class.ilExerciseMembers.php.

Referenced by isAssigned().

        {
                return $this->members ? $this->members : array();
        }

Here is the caller graph for this function:

ilExerciseMembers::getNotice ( )

Definition at line 337 of file class.ilExerciseMembers.php.

        {
                return $this->notice ? $this->notice : array(0 => 0);
        }

ilExerciseMembers::getNoticeByMember ( $ a_member_id )

Definition at line 352 of file class.ilExerciseMembers.php.

        {
                if(isset($this->notice[$a_member_id]))
                {
                        return $this->notice[$a_member_id];
                }
                else
                {
                        return "";
                }
        }

ilExerciseMembers::getObjId ( )

Definition at line 60 of file class.ilExerciseMembers.php.

Referenced by deliverReturnedFiles(), setStatusReturnedForMember(), and updateTutorDownloadTime().

        {
                return $this->obj_id;
        }

Here is the caller graph for this function:

ilExerciseMembers::getRefId ( )

Definition at line 56 of file class.ilExerciseMembers.php.

Referenced by assignMember(), and deassignMember().

        {
                return $this->ref_id;
        }

Here is the caller graph for this function:

ilExerciseMembers::getStatus ( )

Definition at line 179 of file class.ilExerciseMembers.php.

        {
                return $this->status ? $this->status : array();
        }

ilExerciseMembers::getStatusByMember ( $ a_member_id )

Definition at line 183 of file class.ilExerciseMembers.php.

        {
                if(isset($this->status[$a_member_id]))
                {
                        return $this->status[$a_member_id];
                }
                return false;
        }

ilExerciseMembers::getStatusFeedback ( )

Definition at line 310 of file class.ilExerciseMembers.php.

        {
                return $this->status_feedback ? $this->status_feedback : array(0 => 0);
        }

ilExerciseMembers::getStatusFeedbackByMember ( $ a_member_id )

Definition at line 314 of file class.ilExerciseMembers.php.

        {
                if(isset($this->status_feedback[$a_member_id]))
                {
                        return $this->status_feedback[$a_member_id];
                }
                return false;
        }

ilExerciseMembers::getStatusReturned ( )

Definition at line 266 of file class.ilExerciseMembers.php.

        {
                return $this->status_returned ? $this->status_returned : array(0 => 0);
        }

ilExerciseMembers::getStatusReturnedByMember ( $ a_member_id )

Definition at line 280 of file class.ilExerciseMembers.php.

        {
                if(isset($this->status_returned[$a_member_id]))
                {
                        return $this->status_returned[$a_member_id];
                }
                return false;
        }

ilExerciseMembers::getStatusSent ( )

Definition at line 240 of file class.ilExerciseMembers.php.

        {
                return $this->status_sent ? $this->status_sent : array(0 => 0);
        }

ilExerciseMembers::getStatusSentByMember ( $ a_member_id )

Definition at line 244 of file class.ilExerciseMembers.php.

        {
                if(isset($this->status_sent[$a_member_id]))
                {
                        return $this->status_sent[$a_member_id];
                }
                return false;
        }

ilExerciseMembers::hasReturned ( $ a_member_id )

Definition at line 364 of file class.ilExerciseMembers.php.

References $query, and $result.

        {
                $query = sprintf("SELECT returned_id FROM exc_returned WHERE obj_id = %s AND user_id = %s",
                        $this->ilias->db->quote($this->getObjId() . ""),
                        $this->ilias->db->quote($a_member_id . "")
                );
                $result = $this->ilias->db->query($query);
                return $result->numRows();
        }

ilExerciseMembers::ilClone ( $ a_new_id )

Definition at line 676 of file class.ilExerciseMembers.php.

References $data, $query, $res, and $row.

        {
                $data = array();

                $query = "SELECT * FROM exc_members ".
                        "WHERE obj_id = '".$this->getObjId()."'";

                $res = $this->ilias->db->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $data[] = array("usr_id" => $row->usr_id,
                                                        "notice" => $row->notice,
                                                        "returned" => $row->returned,
                                                        "status" => $row->status,
                                                        "sent"   => $row->sent,
                                                        "feedback"       => $row->feedback
                                                        );
                }
                foreach($data as $row)
                {
                        $query = "INSERT INTO exc_members ".
                                "SET obj_id = '".$a_new_id."', ".
                                "usr_id = '".$row["usr_id"]."', ".
                                "notice = '".addslashes($row["notice"])."', ".
                                "returned = '".$row["returned"]."', ".
                                "status = '".$row["status"]."', ".
                                "feedback = '".$row["feedback"]."', ".
                                "sent = '".$row["sent"]."'";

                        $res = $this->ilias->db->query($query);
                }
                return true;
        }

ilExerciseMembers::ilExerciseMembers	(	$	a_obj_id,
		$	a_ref_id
	)

Definition at line 46 of file class.ilExerciseMembers.php.

References $ilias.

        {
                global $ilias;

                $this->ilias =& $ilias;
                $this->obj_id = $a_obj_id;
                $this->ref_id = $a_ref_id;
        }

ilExerciseMembers::isAssigned ( $ a_id )

Definition at line 92 of file class.ilExerciseMembers.php.

References getMembers().

Referenced by assignMembers().

        {
                return in_array($a_id,$this->getMembers());
        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilExerciseMembers::read ( )

Definition at line 645 of file class.ilExerciseMembers.php.

References $query, $res, $row, setMembers(), setNotice(), setStatus(), setStatusFeedback(), setStatusReturned(), and setStatusSent().

Referenced by assignMember(), deassignMember(), setNoticeForMember(), setStatusFeedbackForMember(), setStatusForMember(), setStatusReturnedForMember(), setStatusSentForMember(), and updateStatusTimeForMember().

        {
                $tmp_arr_members = array();
                $tmp_arr_status = array();
                $tmp_arr_sent = array();
                $tmp_arr_notice = array();
                $tmp_arr_returned = array();
                $tmp_arr_feedback = array();

                $query = "SELECT * FROM exc_members ".
                        "WHERE obj_id = '".$this->getObjId()."' ";

                $res = $this->ilias->db->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $tmp_arr_members[] = $row->usr_id;
                        $tmp_arr_notice[$row->usr_id] = $row->notice;
                        $tmp_arr_returned[$row->usr_id] = $row->returned;
                        $tmp_arr_status[$row->usr_id] = $row->status;
                        $tmp_arr_sent[$row->usr_id] = $row->sent;
                        $tmp_arr_feedback[$row->usr_id] = $row->feedback;
                }
                $this->setMembers($tmp_arr_members);
                $this->setNotice($tmp_arr_notice);
                $this->setStatus($tmp_arr_status);
                $this->setStatusSent($tmp_arr_sent);
                $this->setStatusReturned($tmp_arr_returned);
                $this->setStatusFeedback($tmp_arr_feedback);
                
                return true;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilExerciseMembers::setMembers ( $ a_members )

Definition at line 72 of file class.ilExerciseMembers.php.

Referenced by read().

        {
                $this->members = $a_members;
        }

Here is the caller graph for this function:

ilExerciseMembers::setNotice ( $ a_notice )

Definition at line 342 of file class.ilExerciseMembers.php.

Referenced by read().

        {
                if(is_array($a_notice))
                {
                        $this->notice = $a_notice;
                        return true;
                }
                return false;
        }

Here is the caller graph for this function:

ilExerciseMembers::setNoticeForMember	(	$	a_member_id,
		$	a_notice
	)

Definition at line 584 of file class.ilExerciseMembers.php.

References $query, and read().

        {

                $query = "UPDATE exc_members ".
                        "SET notice = '".addslashes($a_notice)."' ".
                        "WHERE obj_id = '".$this->getObjId()."' ".
                        "AND usr_id = '".$a_member_id."'";

                $this->ilias->db->query($query);
                $this->read();

                return true;
        }

Here is the call graph for this function:

ilExerciseMembers::setObjId ( $ a_obj_id )

Definition at line 64 of file class.ilExerciseMembers.php.

        {
                $this->obj_id = $a_obj_id;
        }

ilExerciseMembers::setStatus ( $ a_status )

Definition at line 171 of file class.ilExerciseMembers.php.

Referenced by read().

        {
                if(is_array($a_status))
                {
                        $this->status = $a_status;
                        return true;
                }
        }

Here is the caller graph for this function:

ilExerciseMembers::setStatusFeedback ( $ a_status )

Definition at line 302 of file class.ilExerciseMembers.php.

Referenced by read().

        {
                if(is_array($a_status))
                {
                        $this->status_feedback = $a_status;
                        return true;
                }
        }

Here is the caller graph for this function:

ilExerciseMembers::setStatusFeedbackForMember	(	$	a_member_id,
		$	a_status
	)

Definition at line 322 of file class.ilExerciseMembers.php.

References $query, and read().

        {

          $query = "UPDATE exc_members ".
            "SET feedback = '".($a_status ? 1 : 0)."', ".
            "feedback_time=".($a_status ? ("'".date("Y-m-d H:i:s")."'") : ("'0000-00-00 00:00:00'")).
            " WHERE obj_id = '".$this->getObjId()."' ".
            "AND usr_id = '".$a_member_id."'";
//echo "<br/><br/>$query";
          $this->ilias->db->query($query);
          $this->read();
          
          return true;
        }

Here is the call graph for this function:

ilExerciseMembers::setStatusForMember	(	$	a_member_id,
		$	a_status
	)

set status for member (notgraded|passed|failed)

Parameters:

	int	$a_member_id user id of member
	string	$a_status (notgraded\|passed\|failed)

Definition at line 198 of file class.ilExerciseMembers.php.

References $query, and read().

        {
                $query = "UPDATE exc_members ".
                        "SET status = '".$a_status."', ".
                        "status_time= '".date("Y-m-d H:i:s")."'".
                        " WHERE obj_id = '".$this->getObjId()."' ".
                        "AND usr_id = '".$a_member_id."'".
                        " AND status <> '".$a_status."'";
          
                $this->ilias->db->query($query);
                $this->read();
                
                return true;
        }

Here is the call graph for this function:

ilExerciseMembers::setStatusReturned ( $ a_status )

Definition at line 270 of file class.ilExerciseMembers.php.

Referenced by read().

        {
                if(is_array($a_status))
                {
                        $this->status_returned = $a_status;
                        return true;
                }
                return false;
        }

Here is the caller graph for this function:

ilExerciseMembers::setStatusReturnedForMember	(	$	a_member_id,
		$	a_status
	)

Definition at line 288 of file class.ilExerciseMembers.php.

References $query, getObjId(), and read().

        {
                $query = "UPDATE exc_members ".
                        "SET returned = '".($a_status ? 1 : 0)."' ".
                        "WHERE obj_id = '".$this->getObjId()."' ".
                        "AND usr_id = '".$a_member_id."'";

                $this->ilias->db->query($query);
                $this->read();

                return true;
        }

Here is the call graph for this function:

ilExerciseMembers::setStatusSent ( $ a_status )

Definition at line 232 of file class.ilExerciseMembers.php.

Referenced by read().

        {
                if(is_array($a_status))
                {
                        $this->status_sent = $a_status;
                        return true;
                }
        }

Here is the caller graph for this function:

ilExerciseMembers::setStatusSentForMember	(	$	a_member_id,
		$	a_status
	)

Definition at line 252 of file class.ilExerciseMembers.php.

References $query, and read().

        {
                $query = "UPDATE exc_members ".
                        "SET sent = '".($a_status ? 1 : 0)."', ".
                        "sent_time=".($a_status ? ("'".date("Y-m-d H:i:s")."'") : ("'0000-00-00 00:00:00'")).
                        " WHERE obj_id = '".$this->getObjId()."' ".
                        "AND usr_id = '".$a_member_id."'";

                $this->ilias->db->query($query);
                $this->read();

                return true;
        }

Here is the call graph for this function:

ilExerciseMembers::updateStatusTimeForMember ( $ a_member_id )

Update status time (last change) for member.

Parameters:

int

$a_member_id user id of member

Definition at line 218 of file class.ilExerciseMembers.php.

References $query, and read().

        {
                $query = "UPDATE exc_members ".
                        "SET status_time= '".date("Y-m-d H:i:s")."'".
                        " WHERE obj_id = '".$this->getObjId()."' ".
                        "AND usr_id = '".$a_member_id."'";
          
                $this->ilias->db->query($query);
                $this->read();
                
                return true;
        }

Here is the call graph for this function:

ilExerciseMembers::updateTutorDownloadTime ( $ a_member_id )

Update the timestamp of the last download of current user (=tutor) for member $a_member_id.

Parameters:

int

$a_member_id Member ID.

Definition at line 511 of file class.ilExerciseMembers.php.

References $q, and getObjId().

Referenced by deliverReturnedFiles().

        {
                global $ilUser, $ilDB;
                
                // set download time
                $q = "REPLACE INTO exc_usr_tutor (obj_id, usr_id, tutor_id, download_time) VALUES ".
                        "(".$ilDB->quote($this->getObjId()).",".$ilDB->quote($a_member_id).
                        ",".$ilDB->quote($ilUser->getId()).",now())";
                $ilDB->query($q);
        }

Here is the call graph for this function: