<?php
/**
 * DatafieldEntryModel
 * model class for table datafields_entries
 *
 * 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.de>
 * @copyright   2012 Stud.IP Core-Group
 * @license     http://www.gnu.org/licenses/gpl-2.0.html GPL version 2
 * @category    Stud.IP
 *
 * @property string datafield_id database column
 * @property string range_id database column
 * @property string content database column
 * @property string mkdate database column
 * @property string chdate database column
 * @property string sec_range_id database column
 * @property string name computed column read/write
 * @property string id computed column read/write
 * @property Datafield datafield belongs_to Datafield
 */

class DatafieldEntryModel extends SimpleORMap implements PrivacyObject
{
    protected static function configure($config = [])
    {
        $config['db_table'] = 'datafields_entries';
        $config['belongs_to']['datafield'] = [
            'class_name' => DataField::class,
            'foreign_key' => 'datafield_id'
        ];
        $config['additional_fields']['name'] = ['datafield', 'name'];
        parent::configure($config);
    }

    /**
     * returns datafields belonging to given model
     * if a datafield entry not exists yet, a new DatafieldEntryModel is returned
     * second param filters for a given datafield id
     *
     * @param SimpleORMap $model Course,Institute,User,CourseMember or InstituteMember
     * @param string $datafield_id
     * @return array of DatafieldEntryModel
     */
    public static function findByModel(SimpleORMap $model, $datafield_id = null)
    {
        $mask = ["user" => 1, "autor" => 2, "tutor" => 4, "dozent" => 8, "admin" => 16, "root" => 32];

        if (is_a($model, "Course")) {
            $params[':institution_ids'] = $model->institutes->pluck('institut_id');
            $object_class = SeminarCategories::GetByTypeId($model->status)->id;
            $object_type = 'sem';
            $range_id = $model->getId();
        } elseif(is_a($model, "Institute")) {
            $params[':institution_ids'] = [$model->Institut_id];
            $object_class = $model->type;
            $object_type = 'inst';
            $range_id = $model->getId();
        } elseif(is_a($model, "User")) {
            $params[':institution_ids'] = $model->institute_memberships->pluck('institut_id');
            $object_class = $mask[$model->perms];
            $object_type = 'user';
            $range_id = $model->getId();
        } elseif(is_a($model, "CourseMember")) {
            $params[':institution_ids'] = $model->course->institutes->pluck('institut_id');
            $object_class = $mask[$model->status];
            $object_type = 'usersemdata';
            $range_id = $model->user_id;
            $sec_range_id = $model->seminar_id;
        } elseif(is_a($model, "InstituteMember")) {
            $params[':institution_ids'] = [$model->institut_id];
            $object_class = $mask[$model->inst_perms];
            $object_type = 'userinstrole';
            $range_id = $model->user_id;
            $sec_range_id = $model->institut_id;
        } elseif (is_a($model, 'ModulDeskriptor')) {
            $params[':institution_ids'] = '';
            if (!empty($model->modul->responsible_institute->institut_id)) {
                $params[':institution_ids'] = [$model->modul->responsible_institute->institut_id];
            }
            $object_class = $model->getVariant();
            $object_type = 'moduldeskriptor';
            $range_id = $model->deskriptor_id;
            $sec_range_id = null;
        } elseif (is_a($model, 'ModulteilDeskriptor')) {
            $params[':institution_ids'] = [$model->modulteil->modul->responsible_institute->institut_id];
            $object_class = $model->getVariant();
            $object_type = 'modulteildeskriptor';
            $range_id = $model->deskriptor_id;
            $sec_range_id = null;
        } elseif ($model instanceof StatusgruppeUser) {
            if (isset($model->group->institute)) {
                $params[':institution_ids'] = [$model->group->institute->id];
            } else {
                $params[':institution_ids'] = [];
            }
            $object_class = 255;
            $object_type = 'userinstrole';
            $range_id = $model->user_id;
            $sec_range_id = $model->statusgruppe_id;
        } elseif ($model instanceof Studiengang) {
            $params[':institution_ids'] = [$model->institut_id];
            $object_class = $model->getVariant();
            $object_type = 'studycourse';
            $range_id = $model->studiengang_id;
            $sec_range_id = null;
        }

        if (!$object_type) {
            throw new InvalidArgumentException('Wrong type of model: ' . get_class($model));
        }
        if ($datafield_id !== null) {
            $one_datafield = ' AND a.datafield_id = ' . DBManager::get()->quote($datafield_id);
        } else {
            $one_datafield = '';
        }

        $query = "SELECT a.*, b.*,a.datafield_id,b.datafield_id as isset_content ";
        $query .= "FROM datafields a LEFT JOIN datafields_entries b ON (a.datafield_id=b.datafield_id AND range_id = :range_id AND sec_range_id = :sec_range_id) ";
        $query .= "WHERE object_type = :object_type AND (ISNULL(lang) OR lang = '') AND (a.institut_id IS NULL OR a.institut_id IN (:institution_ids))";

        if ($object_type === 'studycourse') {
            $query .= "AND (LOCATE(:object_class, object_class) OR LOCATE('all', object_class)) $one_datafield ORDER BY priority";
            $params = array_merge($params,[
                ':range_id' => (string) $range_id,
                ':sec_range_id' => (string) $sec_range_id,
                ':object_type' => $object_type,
                ':object_class' => (string) $object_class]);
        } elseif ($object_type === 'moduldeskriptor'
                || $object_type === 'modulteildeskriptor') {
            // find datafields by language (string)
            $query .= "AND (LOCATE(:object_class, object_class) OR object_class IS NULL) $one_datafield ORDER BY priority";
            $params = array_merge($params,[
                ':range_id' => (string) $range_id,
                ':sec_range_id' => (string) $sec_range_id,
                ':object_type' => $object_type,
                ':object_class' => (string) $object_class]);
        } else {
            // find datafields by perms or status (int)
            $query .= "AND ((object_class & :object_class) OR object_class IS NULL) $one_datafield ORDER BY priority";
            $params = array_merge($params, [
                ':range_id' => (string) $range_id,
                ':sec_range_id' => (string) ($sec_range_id ?? ''),
                ':object_type' => $object_type,
                ':object_class' => (int) $object_class]);
        }

        $st = DBManager::get()->prepare($query);
        $st->execute($params);
        $ret = [];
        $c = 0;
        $df_entry = new DatafieldEntryModel();
        $df_entry_i18n = new DatafieldEntryModelI18N();
        $df = new DataField();
        while ($row = $st->fetch(PDO::FETCH_ASSOC)) {
            if (mb_strpos($row['type'], 'i18n') === false) {
                $ret[$c] = clone $df_entry;
            } else {
                $ret[$c] = clone $df_entry_i18n;
                $row['content'] = I18NStringDatafield::load(
                        [
                            $row['datafield_id'],
                            $range_id,
                            (string) $sec_range_id
                        ]);
            }
            $ret[$c]->setData($row, true);
            if (!$row['isset_content']) {
                $ret[$c]->setValue('range_id', (string) $range_id);
                $ret[$c]->setValue('sec_range_id', (string) $sec_range_id);
                $ret[$c]->setValue('lang', '');
            }
            $ret[$c]->setNew(!$row['isset_content']);
            $cloned_df = clone $df;
            $cloned_df->setData($row, true);
            $cloned_df->setNew(false);
            $ret[$c]->setValue('datafield', $cloned_df);
            $c++;
        }
        return $ret;
    }
    public function setContentLanguage($language)
    {
        if (!Config::get()->CONTENT_LANGUAGES[$language]) {
            throw new InvalidArgumentException('Language not configured.');
        }

        $content_languages = array_keys(Config::get()->CONTENT_LANGUAGES);
        if ($language == reset($content_languages)) {
            $language = '';
        }

        $this->lang = $language;
    }

    /**
     * returns matching "old-style" DataFieldEntry object
     *
     * @return DataFieldEntry
     */
    public function getTypedDatafield()
    {
        $range_id = $this->sec_range_id
                  ? [$this->range_id, $this->sec_range_id, $this->lang]
                  : [$this->range_id, '', $this->lang];

        $df = DataFieldEntry::createDataFieldEntry($this->datafield, $range_id, $this->getValue('content'));
        $observer = function ($event, $object, $user_data) {
            if ($user_data['changed']) {
                $this->restore();
            }
        };
        NotificationCenter::addObserver($observer, '__invoke', 'DatafieldDidUpdate', $df);

        return $df;
    }

    /**
     * Export available data of a given user into a storage object
     * (an instance of the StoredUserData class) for that user.
     *
     * @param StoredUserData $storage object to store data into
     */
    public static function exportUserData(StoredUserData $storage)
    {
        $sorm = self::findBySQL("range_id = ?", [$storage->user_id]);
        if ($sorm) {
            $field_data = [];
            foreach ($sorm as $row) {
                $field_data[] = $row->toRawArray();
            }
            if ($field_data) {
                $storage->addTabularData(_('Datenfeld Einträge'), 'datafields_entries', $field_data);
            }
        }
    }
}