CrmModel.php

<?php
namespace App\Model;
use Illuminate\Database\Eloquent\Model;

class CrmModel extends Model
{
    protected $connection = 'crm';
    protected $table = 'user';
    protected $primaryKey = 'user_id';
    public $timestamps = false;

    // 获取用户绑定的业务员ID
    public function getSaleId($user_id)
    {
        $user = $this->where('outter_uid', $user_id)->select('user_id')->first();

        if (!$user) return false;

        $sales = $this->from('salesman')->where('user_id', $user->user_id)->select('sale_id')->first();

        return $sales ? $sales->sale_id : 0;
    }

}