<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;
use App\Models\DTO\SearchData;

class PostTag extends Model
{
    protected $table = 'tb_post_tag';
    protected $primaryKey = 'id';

    public $keyType = 'int';
    public $incrementing = true;
    public $timestamps = true;

    const CREATED_AT = 'created_at';
    const UPDATED_AT = null;

    protected $guarded = [];

    public function board()
    {
        return $this->belongsTo(Board::class);
    }

    public function post()
    {
        return $this->belongsTo(Post::class);
    }

    public function user()
    {
        return $this->belongsTo(User::class);
    }

    /**
     * 게시글 태그 조회
     */
    public function data(SearchData $params): object
    {
        $query = $this->query();
        $query->from(function($q) use($params) {
            $q->select(
                'tb_board.name AS boardName',
                'tb_board.code',
                'tb_post_tag.*',
                'tb_post.subject',
                'tb_post.user_id',
                'users.sid',
                'users.name'
            );

            if($params->keyword) {
                switch ($params->field) {
                    case 'tb_post_tag.id' :
                    case 'users.id' :
                    case 'users.sid' :
                        $q->where($params->field, '=', $params->keyword);
                        break;
                    case 'tb_post.subject' :
                    case 'tb_post_tag.tag' :
                    case 'users.name' :
                    case 'users.email' :
                        $q->where($params->field, 'LIKE', "%{$params->keyword}%");
                        break;
                }
            }

            if($params->startDate || $params->endDate) {
                if($params->startDate) {
                    $q->where('tb_post_tag.created_at', '>=', $params->startDate . ' 00:00:00');
                }
                if($params->endDate) {
                    $q->where('tb_post_tag.created_at', '<=', $params->endDate . ' 23:59:59');
                }
            }

            if($params->boardID) {
                $q->where('tb_post_tag.board_id', '=', $params->boardID);
            }

            $q->from('tb_post_tag');
            $q->join('tb_post', 'tb_post.id', '=', 'tb_post_tag.post_id');
            $q->join('tb_board', 'tb_board.id', '=', 'tb_post_tag.board_id');
            $q->leftJoin('users', 'users.id', '=', 'tb_post.user_id');

        }, 'TT');

        $query->select(
            'TT.id',
            'TT.boardName',
            'TT.post_id',
            'TT.board_id',
            'TT.user_id',
            'TT.created_at',
            'TT.code',
            'TT.subject',
            'TT.sid',
            'TT.name',
            DB::raw('GROUP_CONCAT(DISTINCT TT.tag SEPARATOR ", ") AS tag')
        );

        $query->groupBy('TT.id', 'TT.post_id', 'TT.board_id', 'TT.user_id', 'TT.created_at', 'TT.code', 'TT.subject', 'TT.sid', 'TT.name');
        $list = $query->paginate($params->perPage, ['*'], 'page', $params->page);
        $total = $this->count();
        $rows = $list->count();

        return (object)[
            'total' => $total,
            'rows' => $rows,
            'list' => $list
        ];
    }

    /**
     * 게시글 태그 저장 (쉼표(,) 구분하여 값 삽입)
     */
    public function register(Post $post, ?string $tags): void
    {
        if ($tags) {
            foreach (explode(',', $tags) as $tag) {
                $tag = trim($tag);
                if ($tag) {
                    $this->insert([
                        'board_id' => $post->board_id,
                        'post_id' => $post->id,
                        'tag' => $tag,
                        'ip_address' => IP_ADDRESS,
                        'user_agent' => USER_AGENT,
                        'created_at' => now()
                    ]);
                }
            }

            $post->updateTagRows($post->id);
        }
    }

    /**
     * 게시글 태그 저장 (쉼표(,) 구분하여 값 삽입)
     */
    public function updater(Post $post, ?string $tags): void
    {
        // 기존 태그 삭제
        $this->remove($post);

        // 새로 등록
        $this->register($post, $tags);
    }

    /**
     * 게시글 태그 삭제
     */
    public function remove(Post $post): void
    {
        $this->where([
            ['board_id', $post->board_id],
            ['post_id', $post->id]
        ])->delete();
    }
}