<?php

namespace app\common\repository;

use app\common\newmodel\BookCaseModel;

class BookCaseReposotpry extends BookCaseModel
{
    /**
     * 根据Uid查询 function
     *
     * @author dotdotdot <6383846@qq.com>
     * @date 2022-08-17
     * @param array $fields
     * @param integer $uid
     * @return array
     */
    public function selectByUid(array $fields, int $uid): array
    {
        return BookCaseModel::field($fields)->where(['uid' => $uid])->select()->toArray();
    }

    /**
     * 根据Uid,Articleid查询 function
     *
     * @author dotdotdot <6383846@qq.com>
     * @date 2022-08-17
     * @param array $fields
     * @param integer $uid
     * @param integer $articleid
     * @return array
     */
    public function selectByUidAndArticleid(array $fields, int $uid, int $articleid): array
    {
        $object = BookCaseModel::field($fields)->where(['uid' => $uid, 'articleid' => $articleid])->find();

        return empty($object) ? [] : $object->toArray();
    }

    /**
     * 插入数据 function
     *
     * @author dotdotdot <6383846@qq.com>
     * @date 2022-08-17
     * @param array $data
     * @return integer
     */
    public function insert(array $data): int
    {
        return BookCaseModel::insert($data);
    }

    /**
     * 根据ID删除 function
     *
     * @author dotdotdot <6383846@qq.com>
     * @date 2022-08-22
     * @param int $id
     * @return integer
     */
    public function deleteById(int $id): int
    {
        return BookCaseModel::where(['id' => $id])->delete();
    }
}