billiards-server/application/api/model/user/Area.php

<?php

namespace app\api\model\user;

use app\api\model\BaseModel;
use think\Model;


class Area extends BaseModel
{

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

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

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

    // 追加属性
    protected $append = [

    ];


    public function user()
    {
        return $this->belongsTo('app\admin\model\User', 'user_id', 'id', [], 'LEFT')->setEagerlyType(0);
    }


    public function getArea($user_id, $area_id)
    {
        $area = $this->where([
            "id" => $area_id,
            "user_id" => $user_id
        ])->find();
        return $area ? $area : null;
    }


    public function getEnableArea($user_id)
    {
        return $this->where([
            'user_id' => $user_id,
            'enable' => 1,
        ])->order("updatetime", "Desc")
            ->find();
    }

    public function fetchArea($user_id)
    {
        return $this->where("user_id", $user_id)
            ->order("createtime", "desc")
            ->select();
    }


}