ilShopTopic Class Reference

Class ilShopTopic. More...

Collaboration diagram for ilShopTopic:

Public Member Functions
	__construct ($a_id=0)
	save ()
	delete ()
	saveCustomSorting ()
	setId ($a_id)
	getId ()
	setTitle ($a_title)
	getTitle ()
	setCreateDate ($a_createdate)
	getCreateDate ()
	setChangeDate ($a_changedate)
	getChangeDate ()
	setSorting ($a_sorting)
	getSorting ()
	setCustomSorting ($a_custom_sorting)
	getCustomSorting ()

Static Public Member Functions
static	_lookupTitle ($a_id)

Private Member Functions
	read ()

Private Attributes
	$id = 0
	$title = ''
	$sorting = 0
	$createdate = 0
	$changedate = 0
	$custom_sorting = 0
	$db = null

Detailed Description

Class ilShopTopic.

Author

Michael Jansen mjans.nosp@m.en@d.nosp@m.ataba.nosp@m.y.de

Version

$Id:$

Definition at line 13 of file class.ilShopTopic.php.

Constructor & Destructor Documentation

__construct()

ilShopTopic::__construct

(

$a_id = 0

)

Definition at line 24 of file class.ilShopTopic.php.

References $ilDB, and read().

        {
                global $ilDB;

                $this->db = $ilDB;
                
                if($a_id)
                {
                        $this->id = $a_id;
                        
                        $this->read();
                }
        }

Here is the call graph for this function:

Member Function Documentation

_lookupTitle()

static ilShopTopic::_lookupTitle (   $a_id )

static

Definition at line 146 of file class.ilShopTopic.php.

References $ilDB, $result, and $row.

Referenced by ilShopTopicsGUI\showTopicsList().

        {
                global $ilDB;
                                
                $result = $ilDB->queryf("SELECT pt_topic_title FROM payment_topics WHERE pt_topic_pk = %s",
                                 array('integer'), array($a_id));

         while($row = $ilDB->fetchObject($result))
                {
                        return $row->pt_topic_title;
                }
                
                return false;
        }

Here is the caller graph for this function:

delete()

ilShopTopic::delete

(

)

Definition at line 113 of file class.ilShopTopic.php.

References $result, and getId().

        {
                if($this->id)
                {
                        
                        $result = $this->db->manipulateF('
                                DELETE FROM payment_topics              
                                WHERE pt_topic_pk = %s',
                                array('integer'),
                                array($this->getId())
                        );
                        
                        $result = $this->db->manipulateF('
                                DELETE FROM payment_topic_usr_sort              
                                WHERE ptus_pt_topic_fk = %s',
                                array('integer'),
                                array($this->getId())
                        );
                        
                        $result = $this->db->manipulateF('
                                UPDATE payment_objects
                                SET pt_topic_fk = %s
                                WHERE pt_topic_fk = %s',
                                array('integer', 'integer'),
                                array(0, $this->getId())
                        );
                        
                        return true;
                }
                
                return false;
        }

Here is the call graph for this function:

getChangeDate()

ilShopTopic::getChangeDate

(

)

Definition at line 233 of file class.ilShopTopic.php.

References $changedate.

Referenced by save().

        {
                return $this->changedate;
        }

Here is the caller graph for this function:

getCreateDate()

ilShopTopic::getCreateDate

(

)

Definition at line 225 of file class.ilShopTopic.php.

References $createdate.

Referenced by save().

        {
                return $this->createdate;
        }

Here is the caller graph for this function:

getCustomSorting()

ilShopTopic::getCustomSorting

(

)

Definition at line 249 of file class.ilShopTopic.php.

References $custom_sorting.

Referenced by saveCustomSorting().

        {
                return $this->custom_sorting;
        }

Here is the caller graph for this function:

getId()

ilShopTopic::getId

(

)

Definition at line 209 of file class.ilShopTopic.php.

References $id.

Referenced by delete(), save(), and saveCustomSorting().

        {
                return $this->id;
        }

Here is the caller graph for this function:

getSorting()

ilShopTopic::getSorting

(

)

Definition at line 241 of file class.ilShopTopic.php.

References $sorting.

Referenced by save().

        {
                return $this->sorting;
        }

Here is the caller graph for this function:

getTitle()

ilShopTopic::getTitle

(

)

Definition at line 217 of file class.ilShopTopic.php.

References $title.

Referenced by save().

        {
                return $this->title;
        }

Here is the caller graph for this function:

read()

ilShopTopic::read ( )

private

Definition at line 38 of file class.ilShopTopic.php.

References $id, $ilUser, $result, $row, setChangeDate(), setCreateDate(), setCustomSorting(), setSorting(), and setTitle().

Referenced by __construct().

        {
                global $ilUser;
                
                if($this->id)
                {
                        $result = $this->db->queryf('
                                SELECT * FROM payment_topics 
                                LEFT JOIN payment_topic_usr_sort ON ptus_pt_topic_fk = pt_topic_pk
                                AND ptus_usr_id = %s
                                WHERE pt_topic_pk = %s',
                        array('integer', 'integer'),
                        array($ilUser->getId(), $this->id));
                        
                        while($row = $this->db->fetchObject($result))
                        {
                                $this->setTitle($row->pt_topic_title);
                                $this->setSorting($row->pt_topic_sort);
                                $this->setCreateDate($row->pt_topic_created);
                                $this->setChangeDate($row->pt_topic_changed);
                                $this->setCustomSorting($row->ptus_sorting);
                                
                                return true;            
                        }                       
                }
                
                return false;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

save()

ilShopTopic::save

(

)

Definition at line 67 of file class.ilShopTopic.php.

References getChangeDate(), getCreateDate(), getId(), getSorting(), and getTitle().

        {
                if($this->id)
                {
                        $this->changedate = time();
                        
                        $statement = $this->db->manipulateF('
                                UPDATE payment_topics
                                SET pt_topic_title = %s,
                                        pt_topic_sort = %s,
                                        pt_topic_changed = %s
                                WHERE pt_topic_pk = %s',
                                array('text', 'integer', 'integer', 'integer'),
                                array(  
                                        $this->getTitle(),
                                        $this->getSorting(),
                                        $this->getChangeDate(),
                                        $this->getId()
                                ));
                        

                        
                        return true;
                }
                else
                {
                        $this->createdate = time();
                        
                        $next_id = $this->db->nextId('payment_topics');
                        $statement = $this->db->manipulateF('
                                INSERT INTO payment_topics 
                                (       pt_topic_pk,
                                        pt_topic_title,
                                        pt_topic_sort,
                                        pt_topic_created
                                ) VALUES (%s, %s, %s, %s)',
                                array('integer','text', 'integer', 'integer'),
                                array($next_id, $this->getTitle(), $this->getSorting(), $this->getCreateDate()));

                        $this->id = $next_id;                   
                        if($this->id) return true;
                }
                
                return  false;
        }

Here is the call graph for this function:

saveCustomSorting()

ilShopTopic::saveCustomSorting

(

)

Definition at line 161 of file class.ilShopTopic.php.

References $ilUser, $res, getCustomSorting(), and getId().

        {
                global $ilUser;
                
                if($this->id)
                {               
                        $res = $this->db->queryf('
                                SELECT * FROM payment_topic_usr_sort
                                WHERE ptus_pt_topic_fk = %s
                                AND ptus_usr_id = %s',
                                array('integer', 'integer'),
                                array($this->getId(), $ilUser->getId())
                        );
                        
                        if($this->db->numRows($res) > 0)
                        {
                                $statement = $this->db->manipulateF('
                                        UPDATE payment_topic_usr_sort
                                        SET ptus_sorting = %s
                                        WHERE ptus_usr_id = %s
                                        AND     ptus_pt_topic_fk = %s',
                                                array('integer', 'integer', 'integer'),
                                                array( $this->getCustomSorting(),$ilUser->getId(), $this->getId())
                                );
                        }
                        else
                        {
                                $statement = $this->db->manipulateF('
                                        INSERT INTO payment_topic_usr_sort
                                        (       ptus_pt_topic_fk,
                                                ptus_usr_id,
                                                ptus_sorting
                                        ) VALUES (%s,%s,%s)',
                                                array('integer', 'integer', 'integer'),
                                                array($this->getId(), $ilUser->getId(), $this->getCustomSorting())
                                );      
                        }
                        
                        return true;
                }
                
                return false;
        }       

Here is the call graph for this function:

setChangeDate()

ilShopTopic::setChangeDate

(

$a_changedate

)

Definition at line 229 of file class.ilShopTopic.php.

Referenced by read().

        {
                $this->changedate = $a_changedate;
        }

Here is the caller graph for this function:

setCreateDate()

ilShopTopic::setCreateDate

(

$a_createdate

)

Definition at line 221 of file class.ilShopTopic.php.

Referenced by read().

        {
                $this->createdate = $a_createdate;
        }

Here is the caller graph for this function:

setCustomSorting()

ilShopTopic::setCustomSorting

(

$a_custom_sorting

)

Definition at line 245 of file class.ilShopTopic.php.

Referenced by read().

        {
                $this->custom_sorting = $a_custom_sorting;
        }

Here is the caller graph for this function:

setId()

ilShopTopic::setId

(

$a_id

)

Definition at line 205 of file class.ilShopTopic.php.

        {
                $this->id = $a_id;
        }

setSorting()

ilShopTopic::setSorting

(

$a_sorting

)

Definition at line 237 of file class.ilShopTopic.php.

Referenced by read().

        {
                $this->sorting = $a_sorting;
        }

Here is the caller graph for this function:

setTitle()

ilShopTopic::setTitle

(

$a_title

)

Definition at line 213 of file class.ilShopTopic.php.

Referenced by read().

        {
                $this->title = $a_title;
        }

Here is the caller graph for this function:

Field Documentation

$changedate

ilShopTopic::$changedate = 0

private

Definition at line 19 of file class.ilShopTopic.php.

Referenced by getChangeDate().

$createdate

ilShopTopic::$createdate = 0

private

Definition at line 18 of file class.ilShopTopic.php.

Referenced by getCreateDate().

$custom_sorting

ilShopTopic::$custom_sorting = 0

private

Definition at line 20 of file class.ilShopTopic.php.

Referenced by getCustomSorting().

$db

ilShopTopic::$db = null

private

Definition at line 22 of file class.ilShopTopic.php.

$id

ilShopTopic::$id = 0

private

Definition at line 15 of file class.ilShopTopic.php.

Referenced by getId(), and read().

$sorting

ilShopTopic::$sorting = 0

private

Definition at line 17 of file class.ilShopTopic.php.

Referenced by getSorting().

$title

ilShopTopic::$title = ''

private

Definition at line 16 of file class.ilShopTopic.php.

Referenced by getTitle().

---

The documentation for this class was generated from the following file:

• Services/Payment/classes/class.ilShopTopic.php