+global\DataIntegrityTestDefaultEntries::update()

Complexity

Conditions	9
Paths	35

Size

Total Lines

31

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public static function update($baseTable, $field, $value, $id = 0, $replace = false, $addLive = false)

The parameter $addLive is not used and could be removed.

    {
        $object = DataObject::get_one($baseTable);
        if ($object) {
            $tableArray = array($baseTable);
            if ($object instanceof SiteTree) {
                $tableArray[] = $baseTable."_Live";
            }
            foreach ($tableArray as $table) {
                $value = Convert::raw2sql($value);
                $sql = "UPDATE \"$table\" SET \"$table\".\"$field\" = '$value'";
                $where = array();
                if ($id) {
                    $where[] = "  \"$table\".\"ID\" = ".$id;
                }
                if (!$replace) {
                    $where[] = " \"$table\".\"$field\" IS NULL OR \"$table\".\"$field\" = '' OR \"$table\".\"$field\" = 0 ";
                }
                $wherePhrase = '';
                if (count($where)) {
                    $wherePhrase = " WHERE ( " . implode(") AND (", $where) . " )";
                }
                $result = DB::query("SELECT COUNT(\"$table\".\"ID\") C FROM \"$table\" ".$wherePhrase);
                if ($result && $result->value()) {
                    $sql .= $wherePhrase;
                    DB::query($sql);
                    DB::alteration_message("Updated $field in $table to $value ", "added");
                }
            }
        }
    }
}