<?php

namespace App\Models;

use App\Models\Order\Items;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Book extends Model
{
    use HasFactory,SoftDeletes;
    protected $table    = 'tblBooks';
    protected $fillable = [
        'title',
        'totalPages',
        'bookThumbnail',
        'bookTitle',
        'bookPrice',
        'shortDescription',
        'reviewId',
        'ISBN',
        'publisherDate',
        'publisherId',
        'fileId',
        'sku',
        'category',
        'aboutBook',
        'display',
        'previewIdOne',
        'previewIdTwo',
        'previewIdThree',
    ];

    protected $connection = 'pgsql';



    /**
     * Get the tblFiles data.
     */
    public function fileData()
    {
        return $this->belongsTo(Files::class, 'fileId', 'id');
    }

    /**
     * Get the tblFiles data.
     */
    public function previewOne()
    {
        return $this->belongsTo(Files::class, 'previewIdOne', 'id');
    }

    /**
     * Get the tblFiles data.
     */
    public function previewTwo()
    {
        return $this->belongsTo(Files::class, 'previewIdTwo', 'id');
    }

    /**
     * Get the tblFiles data.
     */
    public function previewThree()
    {
        return $this->belongsTo(Files::class, 'previewIdThree', 'id');
    }

    /**
     * Get the tblBooksAuthor data.
     */
    public function booksAuthor()
    {
        return $this->hasOne(BooksAuthor::class, 'bookId', 'id');
    }

    public function booksArtist()
    {
        return $this->hasOne(BooksArtist::class, 'bookId', 'id');
    }

    public function booksAuthors()
    {
        return $this->hasMany(BooksAuthor::class, 'bookId', 'id');
    }
    public function booksArtists()
    {
        return $this->hasMany(BooksArtist::class, 'bookId', 'id');
    }


    /**
     * Get the tblBooksGenre data.
     */
    public function booksGenre()
    {
        return $this->hasOne(BooksGenre::class, 'bookId', 'id');
    }

    /**
     * Get the tblBookDetails data.
     */
    public function bookDetail()
    {
        return $this->hasOne(BookDetail::class, 'bookId', 'id');
    }

    /**
     * Get the tblBookReview data.
     */
    public function bookReview()
    {
        return $this->hasMany(BookReview::class, 'bookId', 'id');
    }

    /**
     * Get the tblBookRatings data.
     */
    public function bookRating()
    {
        return $this->hasMany(BookRating::class, 'bookId', 'id');
    }

    /**
     * Get the tblPublisher data.
     */
    public function bookPublisher()
    {
        return $this->belongsTo(Publisher::class, 'publisherId', 'id');
    }

    public function item()
    {
        return $this->belongsTo(Items::class, 'id', 'bookId');
    }
}