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.

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

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

Member Function Documentation

◆ delete()

ilAdvancedMDFieldTranslation::delete ( )

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

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

     {
         $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);
     }

Here is the call graph for this function:

◆ getDescription()

ilAdvancedMDFieldTranslation::getDescription ( )

Returns: string

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

References $description.

Referenced by insert(), and update().

                                      : string
     {
         return $this->description;
     }

Here is the caller graph for this function:

◆ getFieldId()

ilAdvancedMDFieldTranslation::getFieldId ( )

Returns: int

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

References $field_id.

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

                                  : int
     {
         return $this->field_id;
     }

Here is the caller graph for this function:

◆ getLangKey()

ilAdvancedMDFieldTranslation::getLangKey ( )

Returns: string

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

References $lang_key.

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

                                  : string
     {
         return $this->lang_key;
     }

Here is the caller graph for this function:

◆ getTitle()

ilAdvancedMDFieldTranslation::getTitle ( )

Returns: string

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

References $title.

Referenced by insert(), and update().

                                : string
     {
         return $this->title;
     }

Here is the caller graph for this function:

◆ insert()

ilAdvancedMDFieldTranslation::insert ( )

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

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

Referenced by update().

     {
         $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);
     }

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.

References $description.

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

◆ setTitle()

ilAdvancedMDFieldTranslation::setTitle ( string $title )

Parameters

string $title

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

References $title.

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

◆ update()

ilAdvancedMDFieldTranslation::update ( )

update or insert entry

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

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

     {
         $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);
     }