book_admin/application/admin/model/Agreementyi.php

<?php

namespace app\admin\model;

use think\Model;

class Agreementyi extends Model
{
    // 表名
    protected $table = 'agreementyi';

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

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

    // 追加属性
    protected $append = [

    ];

    /**
     * 检查渠道是否已签署协议
     *
     * @param int    $admin_id    渠道ID
     * @param string $card_holder 收款人
     * @return bool  true:已签署 false:未签署 or 收款人变更
     */
    public function checkAgreement($admin_id, $card_holder, $benefit)
    {
        $agreemenuCardHolder = $this->field('id,card_holder,card_num,card_bank,benefit')->where('admin_id', $admin_id)->order('id', 'desc')->find();
        if (!$agreemenuCardHolder || $agreemenuCardHolder['card_holder'] != $card_holder || $agreemenuCardHolder['benefit'] != $benefit) {
            return false;
        }
        return $agreemenuCardHolder['id'];
    }

    /**
     * 关联表
     *
     * @return \think\model\relation\BelongsTo
     */
    public function admin()
    {
        return $this->belongsTo('app\common\model\Admin', 'admin_id', 'id', [], 'INNER')->setEagerlyType(0);
    }
}