lib/models/Forum/PostingRead.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64

<?php
namespace Forum;

use SimpleORMap;
use User;

/**
 * @property string $discussion_id
 * @property string $user_id
 * @property int $read_index
 * @property int $chdate
 *
 * @property Discussion $discussion
 * @property User $users
 */

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

        $config['belongs_to']['discussion'] = [
            'class_name' => Discussion::class,
            'foreign_key' => 'discussion_id',
            'assoc_foreign_key' => 'discussion_id'
        ];

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

        parent::configure($config);
    }

    public static function updateUserReadPoint($user_id, $discussion_id, int $read_index = 0): PostingRead
    {
        $postingRead = PostingRead::findOneBySQL(
            "discussion_id = :discussion_id AND user_id = :user_id",
            [
                'discussion_id' => $discussion_id,
                'user_id' => $user_id
            ]
        );

        if (!$postingRead) {
            $postingRead = new PostingRead();
            $postingRead->discussion_id = $discussion_id;
            $postingRead->user_id = $user_id;
        }

        if (!$read_index) {
            $read_index = $postingRead->read_index + 1;
        }

        $postingRead->read_index = $read_index;

        $postingRead->store();

        return $postingRead;
    }
}