<?php
/**
 * MessageUser.class.php
 * model class for table message_user
 *
 * 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    mlunzena
 * @copyright (c) Authors
 *
 * @property array $id alias for pk
 * @property string $user_id database column
 * @property string $message_id database column
 * @property int $readed database column
 * @property int $deleted database column
 * @property string $snd_rec database column
 * @property int $answered database column
 * @property int $mkdate database column
 * @property User $user belongs_to User
 * @property Message $message belongs_to Message
 */

class MessageUser extends SimpleORMap implements PrivacyObject
{
    protected static function configure($config = [])
    {
        $config['db_table'] = 'message_user';

        $config['belongs_to']['user'] = [
            'class_name' => User::class,
            'foreign_key' => 'user_id',
        ];
        $config['belongs_to']['message'] = [
            'class_name' => Message::class,
            'foreign_key' => 'message_id',
        ];

        $config['registered_callbacks']['after_store'][] = 'cleanUpTags';
        $config['registered_callbacks']['after_delete'][] = 'cleanUpTags';

        parent::configure($config);
    }

    public static function hasUnreadByUserId($user_id)
    {
        return self::countBySql("snd_rec = 'rec' AND readed = 0 AND user_id = ? AND deleted = 0", [$user_id]) > 0;
    }

    public static function findSentByMessageId($message_id)
    {
        return self::findOneBySQL("message_id=? AND snd_rec='snd'", [$message_id]);
    }

    public static function findReceivedByMessageId($message_id)
    {
        return self::findBySQL("message_id=? AND snd_rec='rec'", [$message_id]);
    }

    public function cleanUpTags($callback)
    {
        $query = "DELETE FROM message_tags
                      WHERE message_id = :message_id AND user_id = :user_id";
        $statement = DBManager::get()->prepare($query);
        $statement->bindValue(':message_id', $this['message_id']);
        $statement->bindValue(':user_id', $this['user_id']);
        if ($callback == 'after_delete') {
            $statement->execute();
        }
        if ($callback == 'after_store' && $this->isDirty("deleted") && $this['deleted']) {
            $statement->execute();
            $this->message->removeIfOrphaned();
        }
        return true;
    }

    /**
     * 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("user_id = ?", [$storage->user_id]);
        if ($sorm) {
            $field_data = [];
            foreach ($sorm as $row) {
                $field_data[] = $row->toRawArray();
            }
            if ($field_data) {
                $storage->addTabularData(_('MessageUser'), 'message_user', $field_data);
            }
        }
    }
}