class.ilSurveyPhrases.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 ilSurveyPhrases 
{
        protected $arrData;
        
        function __construct()
        {
                $this->arrData = array();
        }
        
        public static function &_getAvailablePhrases($useronly = 0)
        {
                global $ilUser;
                global $ilDB;
                global $lng;
                
                $phrases = array();
                $result = $ilDB->queryF("SELECT * FROM svy_phrase WHERE defaultvalue = %s OR owner_fi = %s ORDER BY title",
                        array('text', 'integer'),
                        array('1', $ilUser->getId())
                );
                while ($row = $ilDB->fetchObject($result))
                {
                        if (($row->defaultvalue == 1) and ($row->owner_fi == 0))
                        {
                                if (!$useronly)
                                {
                                        $phrases[$row->phrase_id] = array(
                                                "title" => $lng->txt($row->title),
                                                "owner" => $row->owner_fi
                                        );
                                }
                        }
                        else
                        {
                                if ($ilUser->getId() == $row->owner_fi)
                                {
                                        $phrases[$row->phrase_id] = array(
                                                "title" => $row->title,
                                                "owner" => $row->owner_fi
                                        );
                                }
                        }
                }
                return $phrases;
        }
        
        public static function &_getCategoriesForPhrase($phrase_id)
        {
                global $ilDB;
                global $lng;
                
                $categories = array();
                $result = $ilDB->queryF("SELECT svy_category.* FROM svy_category, svy_phrase_cat WHERE svy_phrase_cat.category_fi = svy_category.category_id AND svy_phrase_cat.phrase_fi = %s ORDER BY svy_phrase_cat.sequence",
                        array('integer'),
                        array($phrase_id)
                );
                while ($row = $ilDB->fetchObject($result))
                {
                        if (($row->defaultvalue == 1) and ($row->owner_fi == 0))
                        {
                                $categories[$row->category_id] = $lng->txt($row->title);
                        }
                        else
                        {
                                $categories[$row->category_id] = $row->title;
                        }
                }
                return $categories;
        }
        
        function deletePhrases($phrase_array)
        {
                global $ilDB;
                
                if ((is_array($phrase_array)) && (count($phrase_array)))
                {
                        $affectedRows = $ilDB->manipulate("DELETE FROM svy_phrase WHERE " . $ilDB->in('phrase_id', $phrase_array, false, 'integer'));
                        $affectedRows = $ilDB->manipulate("DELETE FROM svy_phrase_cat WHERE " . $ilDB->in('phrase_fi', $phrase_array, false, 'integer'));
                }
        }
        
        function updatePhrase($phrase_id)
        {
                global $ilUser;
                global $ilDB;

                $affectedRows = $ilDB->manipulateF("UPDATE svy_phrase SET title = %s, tstamp = %s WHERE phrase_id = %s",
                        array('text','integer','integer'),
                        array($this->title, time(), $phrase_id)
                );

                $affectedRows = $ilDB->manipulateF("DELETE FROM svy_phrase_cat WHERE phrase_fi = %s",
                        array('integer'),
                        array($phrase_id)
                );

                $counter = 1;
                for ($i = 0; $i < $this->categories->getCategoryCount(); $i++) 
                {
                        $cat = $this->categories->getCategory($i);
                        $next_id = $ilDB->nextId('svy_category');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO svy_category (category_id, title, defaultvalue, owner_fi, tstamp) VALUES (%s, %s, %s, %s, %s)",
                                array('integer','text','text','integer','integer'),
                                array($next_id, $cat->title, 1, $ilUser->getId(), time())
                        );
                        $category_id = $next_id;
                        $next_id = $ilDB->nextId('svy_phrase_cat');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO svy_phrase_cat (phrase_category_id, phrase_fi, category_fi, sequence) VALUES (%s, %s, %s, %s)",
                                array('integer', 'integer', 'integer','integer'),
                                array($next_id, $phrase_id, $category_id, $counter)
                        );
                        $counter++;
                }
        }
        
        public function savePhrase()
        {
                global $ilUser;
                global $ilDB;

                $next_id = $ilDB->nextId('svy_phrase');
                $affectedRows = $ilDB->manipulateF("INSERT INTO svy_phrase (phrase_id, title, defaultvalue, owner_fi, tstamp) VALUES (%s, %s, %s, %s, %s)",
                        array('integer','text','text','integer','integer'),
                        array($next_id, $this->title, 1, $ilUser->getId(), time())
                );
                $phrase_id = $next_id;

                $counter = 1;
                for ($i = 0; $i < $this->categories->getCategoryCount(); $i++) 
                {
                        $cat = $this->categories->getCategory($i);
                        $next_id = $ilDB->nextId('svy_category');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO svy_category (category_id, title, defaultvalue, owner_fi, tstamp) VALUES (%s, %s, %s, %s, %s)",
                                array('integer','text','text','integer','integer'),
                                array($next_id, $cat->title, 1, $ilUser->getId(), time())
                        );
                        $category_id = $next_id;
                        $next_id = $ilDB->nextId('svy_phrase_cat');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO svy_phrase_cat (phrase_category_id, phrase_fi, category_fi, sequence) VALUES (%s, %s, %s, %s)",
                                array('integer', 'integer', 'integer','integer'),
                                array($next_id, $phrase_id, $category_id, $counter)
                        );
                        $counter++;
                }
        }
        
        public function __get($value)
        {
                switch ($value)
                {
                        default:
                                if (array_key_exists($value, $this->arrData))
                                {
                                        return $this->arrData[$value];
                                }
                                else
                                {
                                        return null;
                                }
                                break;
                }
        }

        public function __set($key, $value)
        {
                switch ($key)
                {
                        default:
                                $this->arrData[$key] = $value;
                                break;
                }
        }
}
?>