neiyou_user_web/app/Http/Models/ReferralLog.php

<?php

namespace App\Http\Models;

use Auth;
use Eloquent;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Carbon;

/**
 * 返利日志
 * Class ReferralLog
 *
 * @package App\Http\Models
 * @mixin Eloquent
 * @property int         $id
 * @property int         $user_id     用户ID
 * @property int         $ref_user_id 推广人ID
 * @property int         $order_id    关联订单ID
 * @property int         $amount      消费金额，单位分
 * @property int         $ref_amount  返利金额
 * @property int         $status      状态：0-未提现、1-审核中、2-已提现
 * @property Carbon|null $created_at  创建时间
 * @property Carbon|null $updated_at  最后更新时间
 * @property-read Order  $order
 * @property-read User   $ref_user
 * @property-read User   $user
 * @method static Builder|ReferralLog newModelQuery()
 * @method static Builder|ReferralLog newQuery()
 * @method static Builder|ReferralLog query()
 * @method static Builder|ReferralLog uid()
 * @method static Builder|ReferralLog whereAmount($value)
 * @method static Builder|ReferralLog whereCreatedAt($value)
 * @method static Builder|ReferralLog whereId($value)
 * @method static Builder|ReferralLog whereOrderId($value)
 * @method static Builder|ReferralLog whereRefAmount($value)
 * @method static Builder|ReferralLog whereRefUserId($value)
 * @method static Builder|ReferralLog whereStatus($value)
 * @method static Builder|ReferralLog whereUpdatedAt($value)
 * @method static Builder|ReferralLog whereUserId($value)
 */
class ReferralLog extends Model
{
	protected $table = 'referral_log';
	protected $primaryKey = 'id';

	function scopeUid($query)
	{
		return $query->whereRefUserId(Auth::user()->id);
	}

	function user()
	{
		return $this->hasOne(User::class, 'id', 'user_id');
	}

	function ref_user()
	{
		return $this->hasOne(User::class, 'id', 'ref_user_id');
	}

	function order()
	{
		return $this->hasOne(Order::class, 'oid', 'order_id');
	}

	function getAmountAttribute($value)
	{
		return $value/100;
	}

	function setAmountAttribute($value)
	{
		$this->attributes['amount'] = $value*100;
	}

	function getRefAmountAttribute($value)
	{
		return $value/100;
	}

	function setRefAmountAttribute($value)
	{
		$this->attributes['ref_amount'] = $value*100;
	}
}