<?php
/**
 * StudipScmEntry.class.php
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License as
 * published by the Free Software Foundation; either version 2 of
 * the License, or (at your option) any later version.
 *
 * @author André Noack <noack@data-quest>, Suchi & Berg GmbH <info@data-quest.de>
 * @author Jan-Hendrik Willms <tleilax+studip@gmail.com>
 *
 * @property string scm_id database column
 * @property string id alias column for scm_id
 * @property string range_id database column
 * @property string user_id database column
 * @property string tab_name database column
 * @property string content database column
 * @property string mkdate database column
 * @property string chdate database column
 * @property string position database column
 * @property User user belongs_to User
 * @property Course course belongs_to Course
 */

class StudipScmEntry extends SimpleORMap
{
    protected static function configure($config = [])
    {
        $config['db_table'] = 'scm';

        $config['belongs_to']['user'] = [
            'class_name'  => User::class,
            'foreign_key' => 'user_id',
        ];
        $config['belongs_to']['course'] = [
            'class_name'  => Course::class,
            'foreign_key' => 'range_id',
        ];

        $config['i18n_fields']['tab_name'] = true;
        $config['i18n_fields']['content'] = true;

        $config['registered_callbacks']['before_create'][] = function ($scm) {
            $query = "SELECT MAX(`position`)
                      FROM `scm`
                      WHERE `range_id` = ?";
            $max_pos = DBManager::get()->fetchColumn($query, [$scm->range_id]);

            $scm->position = $max_pos + 1;
        };

        parent::configure($config);
    }
}