<?php

namespace App\Http\Api;

use App\Models\Discussion;
use App\Models\Sentence;
use App\Models\SentPr;

class SuggestionApi
{
    public static function getCountBySent($book, $para, $start, $end, $channel, $type = 'suggestion')
    {
        $count['suggestion'] = SentPr::where('book_id', $book)
            ->where('paragraph', $para)
            ->where('word_start', $start)
            ->where('word_end', $end)
            ->where('channel_uid', $channel)
            ->count();
        $sentId = Sentence::where('book_id', $book)
            ->where('paragraph', $para)
            ->where('word_start', $start)
            ->where('word_end', $end)
            ->where('channel_uid', $channel)
            ->value('uid');
        if ($sentId) {
            $count['discussion'] = Discussion::where('res_id', $sentId)
                ->whereNull('parent')
                ->count();
        }

        return $count;
    }
}