ilDBUpdate3136 Class Reference

Update class for step 3136. More...

Collaboration diagram for ilDBUpdate3136:

Static Public Member Functions
static	copyStyleClass (string $orig_class, string $class, string $type, string $tag, int $hide=0)
	Create style class GlossaryLink, link, IntLink. More...
static	addStyleClass (string $class, string $type, string $tag, array $parameters=[], int $hide=0)
	Add style class. More...

Detailed Description

Update class for step 3136.

Author

alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

Version

$Id$

Definition at line 28 of file class.ilDBUpdate3136.php.

Member Function Documentation

addStyleClass()

static ilDBUpdate3136::addStyleClass ( string  $class, string  $type, string  $tag, array  $parameters = [], int  $hide = 0  )

static

Add style class.

Deprecated:

use Services/Style/classes/Setup/class.ilStyleClassAddedObjective.php instead

Definition at line 104 of file class.ilDBUpdate3136.php.

     : void {
        global $ilDB;
        $db = $ilDB;
 
        $sql =
            "SELECT obj_id" . PHP_EOL
            . "FROM object_data" . PHP_EOL
            . "WHERE type = 'sty'" . PHP_EOL
        ;
        $result = $db->query($sql);
 
        while ($row = $db->fetchAssoc($result)) {
            $sql =
                "SELECT style_id, type, characteristic, hide" . PHP_EOL
                . "FROM style_char" . PHP_EOL
                . "WHERE style_id = " . $db->quote($row["obj_id"], "integer") . PHP_EOL
                . "AND characteristic = " . $db->quote($class, "text") . PHP_EOL
                . "AND type = " . $db->quote($type, "text") . PHP_EOL;
            $res = $db->query($sql);
 
            if (!$db->fetchAssoc($res)) {
                $values = [
                    "style_id" => ["integer", $row["obj_id"]],
                    "type" => ["text", $type],
                    "characteristic" => ["text", $class],
                    "hide" => ["integer", $hide]
                ];
                $db->insert("style_char", $values);
 
                foreach ($parameters as $k => $v) {
                    $spid = $db->nextId("style_parameter");
                    $values = [
                        "id" => ["integer", $spid],
                        "style_id" => ["integer", $row["obj_id"]],
                        "tag" => ["text", $tag],
                        "class" => ["text", $class],
                        "parameter" => ["text", $k],
                        "value" => ["text", $v],
                        "type" => ["text", $type]
                    ];
                    $db->insert("style_parameter", $values);
                }
            }
        }
    }

References $res.

copyStyleClass()

static ilDBUpdate3136::copyStyleClass ( string  $orig_class, string  $class, string  $type, string  $tag, int  $hide = 0  )

static

Create style class GlossaryLink, link, IntLink.

Deprecated:

use Services/Style/classes/Setup/class.ilStyleClassCopiedObjective.php instead

Definition at line 35 of file class.ilDBUpdate3136.php.

     : void {
        global $ilDB;
        $db = $ilDB;
 
        $sql =
            "SELECT obj_id" . PHP_EOL
            . "FROM object_data" . PHP_EOL
            . "WHERE type = 'sty'" . PHP_EOL
        ;
        $set = $db->query($sql);
 
        while ($row = $db->fetchAssoc($set)) {
            $sql =
                "SELECT style_id, type, characteristic, hide" . PHP_EOL
                . "FROM style_char" . PHP_EOL
                . "WHERE style_id = " . $db->quote($row["obj_id"], "integer") . PHP_EOL
                . "AND characteristic = " . $db->quote($class, "text") . PHP_EOL
                . "AND type = " . $db->quote($type, "text") . PHP_EOL
            ;
            $res = $db->query($sql);
 
            if (!$db->fetchAssoc($res)) {
                $values = [
                    "style_id" => ["integer", $row["obj_id"]],
                    "type" => ["text", $type],
                    "characteristic" => ["text", $class],
                    "hide" => ["integer", $hide]
                ];
                $db->insert("style_char", $values);
 
                $sql =
                    "SELECT id, style_id, tag, class, parameter, value, type, mq_id, custom" . PHP_EOL
                    . "FROM style_parameter" . PHP_EOL
                    . "WHERE style_id = " . $db->quote($row["obj_id"], "integer") . PHP_EOL
                    . "AND type = " . $db->quote($type, "text") . PHP_EOL
                    . "AND class = " . $db->quote($orig_class, "text") . PHP_EOL
                    . "AND tag = " . $db->quote($tag, "text") . PHP_EOL
                ;
 
                $res = $db->query($sql);
 
                while ($row_2 = $db->fetchAssoc($res)) {
                    $spid = $db->nextId("style_parameter");
                    $values = [
                        "id" => ["integer", $spid],
                        "style_id" => ["integer", $row["obj_id"]],
                        "tag" => ["text", $tag],
                        "class" => ["text", $class],
                        "parameter" => ["text", $row_2["parameter"]],
                        "value" => ["text", $row_2["value"]],
                        "type" => ["text", $row_2["type"]]
                    ];
                    $db->insert("style_parameter", $values);
                }
            }
        }
    }

References $res.

---

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

• components/ILIAS/Migration/DBUpdate_3136/classes/class.ilDBUpdate3136.php