billiards-server/application/api/model/massager/Collect.php

<?php

namespace app\api\model\massager;

use app\api\model\BaseModel;


class Collect extends BaseModel
{

    // 表名
    protected $name = 'massager_collect';

    // 自动写入时间戳字段
    protected $autoWriteTimestamp = 'integer';

    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = 'updatetime';

    public function massager()
    {
        return $this->hasOne(Massager::class, 'id', 'massager_id');
    }

    public function getByUserIdAndMassagerId(int $user_id, int $m_id)
    {
        return $this->where([
            'user_id' => $user_id,
            'massager_id' => $m_id
        ])
            ->find();
    }

    public function fetchByUserIdAndMassagerIds(int $user_id, array $m_ids)
    {
        return $this->where('user_id', $user_id)
            ->where('massager_id', 'in', $m_ids)
            ->select();
    }

    public function fetchCollectMassager($user_id, $page, $size)
    {
        return $this
            ->alias("a")
            ->field("a.user_id,a.massager_id")
            ->where("a.user_id", $user_id)
            ->with(["massager", 'massager.store', 'massager.nearly_two_days_orders'])
            ->page($page)
            ->paginate($size);
    }


}