class.ilShopNewsItem.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilShopNewsItem 
{
        private $id = 0;
        private $title = '';
        private $content = '';
        private $creation_date = null;
        private $update_date = null;
        private $user_id = 0;
        private $visibility = 'users';

        public function __construct($a_id = 0)
        {               
                if((int)$a_id > 0)
                {
                        $this->setId((int)$a_id);
                        $this->read();
                }
        }

        public function setId($a_id)
        {
                $this->id = $a_id;
        }

        public function getId()
        {
                return $this->id;
        }

        public function setTitle($a_title)
        {
                $this->title = $a_title;
        }

        public function getTitle()
        {
                return $this->title;
        }

        public function setContent($a_content)
        {
                $this->content = $a_content;
        }

        public function getContent()
        {
                return $this->content;
        }


        public function setCreationDate($a_creation_date)
        {
                $this->creation_date = $a_creation_date;
        }

        public function getCreationDate()
        {
                return $this->creation_date;
        }

        public function setUpdateDate($a_update_date)
        {
                $this->update_date = $a_update_date;
        }

        public function getUpdateDate()
        {
                return $this->update_date;
        }

        public function setVisibility($a_visibility = 'users')
        {
                $this->visibility = $a_visibility;
        }

        public function getVisibility()
        {
                return $this->visibility;
        }

        public function setUserId($a_user_id)
        {
                $this->user_id = $a_user_id;
        }

        public function getUserId()
        {
                return $this->user_id;
        }
        
        public function create()
        {
                global $ilDB;
                
                $createdate = new ilDateTime(time(), IL_CAL_UNIX);
                
                $next_id = $ilDB->nextId('payment_news');
                if((int)$next_id)
                {
                        $ilDB->insert('payment_news', array(
                                'news_id'                       => array('integer', $next_id),
                                'news_title'            => array('text', $this->getTitle()),
                                'news_content'          => array('clob', $this->getContent()),
                                'visibility'            => array('text', $this->getVisibility()),
                                'creation_date'         => array('timestamp', $createdate->get(IL_CAL_DATETIME)),
                                'update_date'           => array('timestamp', $createdate->get(IL_CAL_DATETIME)),
                                'user_id'                       => array('integer', $this->getUserId())         
                        ));
                        $this->id = $next_id;
                        return true;
                }
                
                return false;
        }

        private function read()
        {
                global $ilDB;
                        
                $result = $ilDB->queryf('SELECT * FROM payment_news WHERE news_id = %s',
                                                        array('integer'),
                                                        array($this->getId())
                                                );
                
                while($record = $ilDB->fetchAssoc($result))
                {
                        $this->setTitle($record['news_title']);
                        $this->setCreationDate($record['creation_date']);
                        $this->setVisibility($record['visibility']);
                        $this->setContent($record['news_content']);
                        $this->setUpdateDate($record['update_date']);
                        $this->setUserId($record['user_id']);
                        break;
                }
        }

        public function update()
        {
                global $ilDB;
                
                $updatedate = new ilDateTime(time(), IL_CAL_UNIX);      

                if((int)$this->getId())
                {
                        $ilDB->update('payment_news', 
                                array(                          
                                        'news_title'            => array('text', $this->getTitle()),
                                        'news_content'          => array('clob', $this->getContent()),
                                        'visibility'            => array('text', $this->getVisibility()),
                                        'update_date'           => array('timestamp', $updatedate->get(IL_CAL_DATETIME)),
                                        'user_id'                       => array('integer', $this->getUserId())         
                                ),
                                array(
                                        'news_id'                       => array('integer', $this->getId())
                                )                               
                        );
                                                  
                        return true;
                }
                
                return false;
        }

        public function delete()
        {
                global $ilDB;
                
                if((int)$this->getId())
                {
                        $query = 'DELETE FROM payment_news WHERE news_id = %s';
                        $statement = $ilDB->manipulateF($query, array('integer'),array($this->getId()));
                
                        return true;
                }
                
                return false;
        }
}
?>