forkbb/app/Models/Forum/Save.php

<?php
/**
 * This file is part of the ForkBB <https://github.com/forkbb>.
 *
 * @copyright (c) Visman <mio.visman@yandex.ru, https://github.com/MioVisman>
 * @license   The MIT License (MIT)
 */

declare(strict_types=1);

namespace ForkBB\Models\Forum;

use ForkBB\Models\Action;
use ForkBB\Models\Forum\Forum;
use RuntimeException;

class Save extends Action
{
    /**
     * Обновляет раздел в БД
     */
    public function update(Forum $forum): Forum
    {
        if ($forum->id < 1) {
            throw new RuntimeException('The model does not have ID');
        }
        $modified = $forum->getModified();
        if (empty($modified)) {
            return $forum;
        }
        $values = $forum->getAttrs();
        $fileds = $this->c->dbMap->forums;
        $set = $vars = [];
        foreach ($modified as $name) {
            if (! isset($fileds[$name])) {
                continue;
            }
            $vars[] = $values[$name];
            $set[]  = $name . '=?' . $fileds[$name];
        }
        if (empty($set)) {
            return $forum;
        }
        $vars[] = $forum->id;
        $query = 'UPDATE ::forums
            SET ' . \implode(', ', $set) . ' WHERE id=?i';

        $this->c->DB->exec($query, $vars);

        // модификация категории у потомков при ее изменении
        if (
            \in_array('cat_id', $modified)
            && $forum->descendants
        ) {
            foreach ($forum->descendants as $f) {
                $f->__cat_id = $values['cat_id'];
            }
            $vars = [
                ':ids'      => \array_keys($forum->descendants),
                ':category' => $values['cat_id'],
            ];
            $query = 'UPDATE ::forums
                SET cat_id=?i:category
                WHERE id IN (?ai:ids)';

            $this->c->DB->exec($query, $vars);
        }

        $forum->resModified();

        return $forum;
    }

    /**
     * Добавляет новый раздел в БД
     */
    public function insert(Forum $forum): int
    {
        if (null !== $forum->id) {
            throw new RuntimeException('The model has ID');
        }
        $attrs  = $forum->getAttrs();
        $fileds = $this->c->dbMap->forums;
        $set = $set2 = $vars = [];
        foreach ($attrs as $key => $value) {
            if (! isset($fileds[$key])) {
                continue;
            }
            $vars[] = $value;
            $set[]  = $key;
            $set2[] = '?' . $fileds[$key];
        }
        if (empty($set)) {
            throw new RuntimeException('The model is empty');
        }

        $query = 'INSERT INTO ::forums (' . \implode(', ', $set) . ')
            VALUES (' . \implode(', ', $set2) . ')';

        $this->c->DB->exec($query, $vars);
        $forum->id = (int) $this->c->DB->lastInsertId();
        $forum->resModified();

        return $forum->id;
    }
}