Class ilAdvancedMDFieldTranslation. More...

Collaboration diagram for ilAdvancedMDFieldTranslation:

Public Member Functions
	__construct (int $field_id, string $title, string $description, string $lang_key)
	ilAdvancedMDFieldTranslation constructor. More...

	setTitle (string $title)

	setDescription (string $description)

	getFieldId ()

	getTitle ()

	getDescription ()

	getLangKey ()

	update ()
	update or insert entry More...

	delete ()

	insert ()

Data Fields
const	TABLE_NAME = 'adv_md_field_int'

Private Attributes
	$field_id

	$title

	$description

	$lang_key

	$db

Detailed Description

Class ilAdvancedMDFieldTranslation.

Definition at line 9 of file class.ilAdvancedMDFieldTranslation.php.

Constructor & Destructor Documentation

◆ __construct()

ilAdvancedMDFieldTranslation::__construct	(	int	$field_id,
		string	$title,
		string	$description,
		string	$lang_key
	)

ilAdvancedMDFieldTranslation constructor.

Definition at line 42 of file class.ilAdvancedMDFieldTranslation.php.

    {
        global $DIC;
 
        $this->db = $DIC->database();
 
        $this->field_id = $field_id;
        $this->title = $title;
        $this->description = $description;
        $this->lang_key = $lang_key;
    }

References $description, $DIC, $field_id, $lang_key, and $title.

Member Function Documentation

◆ delete()

ilAdvancedMDFieldTranslation::delete ( )

Definition at line 125 of file class.ilAdvancedMDFieldTranslation.php.

    {
        $query = 'delete from ' . self::TABLE_NAME . ' ' .
            'where field_id = ' . $this->db->quote($this->getFieldId(), ilDBConstants::T_INTEGER) . ' and ' .
            'lang_code = ' . $this->db->quote($this->getLangKey(), ilDBConstants::T_TEXT);
        $this->db->manipulate($query);
    }

References $query, getFieldId(), ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

Here is the call graph for this function:

◆ getDescription()

ilAdvancedMDFieldTranslation::getDescription ( )

Returns: string

Definition at line 90 of file class.ilAdvancedMDFieldTranslation.php.

                                     : string
    {
        return $this->description;
    }

References $description.

Referenced by insert(), and update().

Here is the caller graph for this function:

◆ getFieldId()

ilAdvancedMDFieldTranslation::getFieldId ( )

Returns: int

Definition at line 74 of file class.ilAdvancedMDFieldTranslation.php.

                                 : int
    {
        return $this->field_id;
    }

References $field_id.

Referenced by delete(), insert(), and update().

Here is the caller graph for this function:

◆ getLangKey()

ilAdvancedMDFieldTranslation::getLangKey ( )

Returns: string

Definition at line 98 of file class.ilAdvancedMDFieldTranslation.php.

                                 : string
    {
        return $this->lang_key;
    }

References $lang_key.

Referenced by insert(), and update().

Here is the caller graph for this function:

◆ getTitle()

ilAdvancedMDFieldTranslation::getTitle ( )

Returns: string

Definition at line 82 of file class.ilAdvancedMDFieldTranslation.php.

                               : string
    {
        return $this->title;
    }

References $title.

Referenced by insert(), and update().

Here is the caller graph for this function:

◆ insert()

ilAdvancedMDFieldTranslation::insert ( )

Definition at line 133 of file class.ilAdvancedMDFieldTranslation.php.

    {
        $query = 'insert into ' . self::TABLE_NAME . ' (field_id, title, lang_code, description) ' .
            'values (  ' .
            $this->db->quote($this->getFieldId(), ilDBConstants::T_INTEGER) . ', ' .
            $this->db->quote($this->getTitle() , ilDBConstants::T_TEXT) . ', ' .
            $this->db->quote($this->getLangKey(), ilDBConstants::T_TEXT) . ', ' .
            $this->db->quote($this->getDescription(), ilDBConstants::T_TEXT) . ' ' .
            ')';
        $this->db->manipulate($query);
    }

References $query, getDescription(), getFieldId(), getLangKey(), getTitle(), ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

Referenced by update().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setDescription()

ilAdvancedMDFieldTranslation::setDescription ( string $description )

Parameters

string $description

Definition at line 65 of file class.ilAdvancedMDFieldTranslation.php.

                                                        : void
    {
        $this->description = $description;
    }

References $description.

◆ setTitle()

ilAdvancedMDFieldTranslation::setTitle ( string $title )

Parameters

string $title

Definition at line 57 of file class.ilAdvancedMDFieldTranslation.php.

                                            : void
    {
        $this->title = $title;
    }

References $title.

◆ update()

ilAdvancedMDFieldTranslation::update ( )

update or insert entry

Definition at line 106 of file class.ilAdvancedMDFieldTranslation.php.

    {
        $query = 'select *  from ' . self::TABLE_NAME . ' ' .
            'where field_id = ' . $this->db->quote($this->getFieldId(), ilDBConstants::T_INTEGER) . ' ' .
            'and lang_code = ' . $this->db->quote($this->getLangKey(), ilDBConstants::T_TEXT) . ' ';
        $res = $this->db->query($query);
        if (!$res->numRows()) {
            return $this->insert();
        }
 
        $query = 'update ' . self::TABLE_NAME . ' ' .
            'set title = ' . $this->db->quote($this->getTitle(), ilDBConstants::T_TEXT) . ', ' .
            'description = ' . $this->db->quote($this->getDescription(), ilDBConstants::T_TEXT) . ' ' .
            'where field_id = ' . $this->db->quote($this->getFieldId(), ilDBConstants::T_INTEGER) . ' ' .
            'and lang_code = ' . $this->db->quote($this->getLangKey(), ilDBConstants::T_TEXT);
 
        $this->db->manipulate($query);
    }