odd_job/app/common/model/Agent.php

<?php

namespace app\common\model;

use think\Model;
use think\model\concern\SoftDelete;

class Agent extends Model
{
    use SoftDelete;
    protected $deleteTime = 'deletetime';
    protected $defaultSoftDelete = 0;
    // 设置字段信息
    protected $schema = [
        'id'           => 'int',
        'userid'       => 'int',
        'workerid'     => 'int',
        'loginname'    => 'string',
        'password'     => 'string',
        'idnumber'     => 'string',
        'title'        => 'string',
        'tilpic'       => 'string',
        'picall'       => 'string',
        'realname'     => 'string',
        'mobile'       => 'string',
        'telephone'    => 'string',
        'latitude'     => 'float',
        'longitude'    => 'float',
        'province'     => 'string',
        'city'         => 'string',
        'district'     => 'string',
        'address'      => 'string',
        'details'      => 'string',
        'priority'     => 'int',
        'remark'       => 'string',
        'status'       => 'tinyint',
        'createtime'   => 'int',
        'wxampcode'    => 'string',
        'income'       => 'decimal',
        'income_total' => 'decimal',
        'is_settle'    => 'tinyint',
    ];

    // 设置字段自动转换类型
    protected $type = [
        'picall'     => 'json',
        'createtime' => 'timestamp:Y-m-d H:i:s',
    ];
    protected $jsonAssoc = true;

    public function getStatusTextAttr($value, $data)
    {
        $status = [1 => '正常', 2 => '禁用'];
        return $status[$data['status']];
    }

    // 关联User
    public function muser()
    {
        return $this->hasOne(User::class, "id", "userid");
    }

    // 关联Worker
    public function worker()
    {
        return $this->hasOne(Worker::class, "id", "workerid");
    }

    // 关联Broker
    public function broker()
    {
        return $this->hasMany(Broker::class, "agentid", "id");
    }

    // 关联Partjob
    public function partjob()
    {
        return $this->hasMany(Partjob::class, "agentid", "id");
    }

}