class.ilTestSession.php

Go to the documentation of this file.

<?php
 /*
   +----------------------------------------------------------------------------+
   | ILIAS open source                                                          |
   +----------------------------------------------------------------------------+
   | Copyright (c) 1998-2001 ILIAS open source, University of Cologne           |
   |                                                                            |
   | This program is free software; you can redistribute it and/or              |
   | modify it under the terms of the GNU General Public License                |
   | as published by the Free Software Foundation; either version 2             |
   | of the License, or (at your option) any later version.                     |
   |                                                                            |
   | This program is distributed in the hope that it will be useful,            |
   | but WITHOUT ANY WARRANTY; without even the implied warranty of             |
   | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the              |
   | GNU General Public License for more details.                               |
   |                                                                            |
   | You should have received a copy of the GNU General Public License          |
   | along with this program; if not, write to the Free Software                |
   | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
   +----------------------------------------------------------------------------+
*/

class ilTestSession
{
        var $active_id;

        var $user_id;

        var $anonymous_id;

        var $test_id;

        var $lastsequence;

        var $submitted;

        var $submittedTimestamp;

        function ilTestSession($active_id = "")
        {
                $this->active_id = 0;
                $this->user_id = 0;
                $this->anonymous_id = 0;
                $this->test_id = 0;
                $this->lastsequence = 0;
                $this->submitted = FALSE;
                $this->submittedTimestamp = "";
                $this->pass = 0;
                if ($active_id > 0)
                {
                        $this->loadFromDb($active_id);
                }
        }
        
        function saveToDb()
        {
                global $ilDB, $ilLog;
                
                $submitted = ($this->isSubmitted()) ? "1" : "0";
                $submittedTimestamp = (strlen($this->getSubmittedTimestamp())) ? $ilDB->quote($this->getSubmittedTimestamp()) : "NULL";
                if ($this->active_id > 0)
                {
                        $query = sprintf("UPDATE tst_active SET lastindex = %s, tries = %s, submitted = %s, submittimestamp = %s WHERE active_id = %s",
                                $ilDB->quote($this->getLastSequence() . ""),
                                $ilDB->quote($this->getPass() . ""),
                                $ilDB->quote($submitted . ""),
                                $submittedTimestamp,
                                $ilDB->quote($this->getActiveId() . "")
                        );
                        $result = $ilDB->query($query);
                }
                else
                {
                        $anonymous_id = ($this->getAnonymousId()) ? $ilDB->quote($this->getAnonymousId() . "") : "NULL";
                        $query = sprintf("INSERT INTO tst_active (active_id, user_fi, anonymous_id, test_fi, lastindex, tries, submitted, submittimestamp) VALUES (NULL, %s, %s, %s, %s, %s, %s, %s)",
                                $ilDB->quote($this->getUserId() . ""),
                                $anonymous_id,
                                $ilDB->quote($this->getTestId() . ""),
                                $ilDB->quote($this->getLastSequence() . ""),
                                $ilDB->quote($this->getPass() . ""),
                                $ilDB->quote($submitted . ""),
                                $submittedTimestamp
                        );
                        $result = $ilDB->query($query);
                        $this->active_id = $ilDB->getLastInsertId();
                }
        }
        
        function loadTestSession($test_id, $user_id = "", $anonymous_id = "")
        {
                global $ilDB;
                global $ilUser;

                if (!$user_id)
                {
                        $user_id = $ilUser->getId();
                }
                if (($_SESSION["AccountId"] == ANONYMOUS_USER_ID) && (strlen($_SESSION["tst_access_code"][$test_id])))
                {
                        $query = sprintf("SELECT * FROM tst_active WHERE user_fi = %s AND test_fi = %s AND anonymous_id = %s",
                                $ilDB->quote($user_id),
                                $ilDB->quote($test_id),
                                $ilDB->quote($_SESSION["tst_access_code"][$test_id])
                        );
                }
                else if (strlen($anonymous_id))
                {
                        $query = sprintf("SELECT * FROM tst_active WHERE user_fi = %s AND test_fi = %s AND anonymous_id = %s",
                                $ilDB->quote($user_id),
                                $ilDB->quote($test_id),
                                $ilDB->quote($anonymous_id)
                        );
                }
                else
                {
                        if ($_SESSION["AccountId"] == ANONYMOUS_USER_ID)
                        {
                                return NULL;
                        }
                        $query = sprintf("SELECT * FROM tst_active WHERE user_fi = %s AND test_fi = %s",
                                $ilDB->quote($user_id),
                                $ilDB->quote($test_id)
                        );
                }
                $result = $ilDB->query($query);
                if ($result->numRows())
                {
                        $row = $result->fetchRow(MDB2_FETCHMODE_ASSOC);
                        $this->active_id = $row["active_id"];
                        $this->user_id = $row["user_fi"];
                        $this->anonymous_id = $row["anonymous_id"];
                        $this->test_id = $row["test_fi"];
                        $this->lastsequence = $row["lastindex"];
                        $this->pass = $row["tries"];
                        $this->submitted = ($row["submitted"]) ? TRUE : FALSE;
                        $this->submittedTimestamp = $row["submittimestamp"];
                }
        }
        
        private function loadFromDb($active_id)
        {
                global $ilDB;
                $query = sprintf("SELECT * FROM tst_active WHERE active_id = %s", 
                        $ilDB->quote($active_id . "")
                );
                $result = $ilDB->query($query);
                if ($result->numRows())
                {
                        $row = $result->fetchRow(MDB2_FETCHMODE_ASSOC);
                        $this->active_id = $row["active_id"];
                        $this->user_id = $row["user_fi"];
                        $this->anonymous_id = $row["anonymous_id"];
                        $this->test_id = $row["test_fi"];
                        $this->lastsequence = $row["lastindex"];
                        $this->pass = $row["tries"];
                        $this->submitted = ($row["submitted"]) ? TRUE : FALSE;
                        $this->submittedTimestamp = $row["submittimestamp"];
                }
        }
        
        function getActiveId()
        {
                return $this->active_id;
        }
        
        function setUserId($user_id)
        {
                $this->user_id = $user_id;
        }
        
        function getUserId()
        {
                return $this->user_id;
        }
        
        function setTestId($test_id)
        {
                $this->test_id = $test_id;
        }
        
        function getTestId()
        {
                return $this->test_id;
        }
        
        function setAnonymousId($anonymous_id)
        {
                $this->anonymous_id = $anonymous_id;
        }
        
        function getAnonymousId()
        {
                return $this->anonymous_id;
        }
        
        function setLastSequence($lastsequence)
        {
                $this->lastsequence = $lastsequence;
        }
        
        function getLastSequence()
        {
                return $this->lastsequence;
        }
        
        function setPass($pass)
        {
                $this->pass = $pass;
        }
        
        function getPass()
        {
                return $this->pass;
        }
        
        function increasePass()
        {
                $this->pass += 1;
        }
        
        function isSubmitted()
        {
                return $this->submitted;
        }
        
        function setSubmitted()
        {
                $this->submitted = TRUE;
        }
        
        function getSubmittedTimestamp()
        {
                return $this->submittedTimestamp;
        }
        
        function setSubmittedTimestamp()
        {
                $this->submittedTimestamp = strftime("%Y-%m-%d %H:%M:%S");
        }
}

?>