<?php
|
|
namespace app\common\model\supplier;
|
|
use app\common\model\BaseModel;
|
|
/**
|
* 商家供应商提现记录模型
|
*/
|
class Balance extends BaseModel
|
{
|
protected $name = 'supplier_user_balance';
|
protected $pk = 'balance_id';
|
|
|
/**
|
* 关联供应商表
|
*/
|
public function supplier()
|
{
|
return $this->belongsTo('app\\common\\model\\supplier\\Supplier', 'shop_supplier_id', 'shop_supplier_id');
|
}
|
|
/**
|
* 关联应用表
|
*/
|
public function user()
|
{
|
return $this->belongsTo('app\\common\\model\\user\\User', 'user_id', 'user_id');
|
}
|
|
/**
|
* 详情
|
*/
|
public static function detail($where)
|
{
|
$model = new static;
|
if (is_array($where)) {
|
$filter = $where;
|
} else {
|
$filter['balance_id'] = (int)$where;
|
}
|
return $model->where($filter)->with(['supplier', 'user'])->find();
|
}
|
|
/**
|
* 增加余额
|
*/
|
public function setIncBalance($shop_supplier_id,$user_id,$money)
|
{
|
$model = $this->where('user_id', '=', $user_id)
|
->where('shop_supplier_id', '=', $shop_supplier_id)
|
->find();
|
if(!empty($detail)){
|
return $model->where('user_id', '=', $user_id)
|
->where('shop_supplier_id', '=', $shop_supplier_id)
|
->inc('balance', $money)
|
->update();
|
}else{
|
$save_data = [
|
'user_id' => $user_id,
|
'shop_supplier_id' => $shop_supplier_id,
|
'balance' => $money,
|
];
|
return $this->save($save_data);
|
}
|
|
}
|
|
/**
|
* 减少余额
|
*/
|
public function setDecBalance($shop_supplier_id,$user_id,$money)
|
{
|
return $this->where('user_id', '=', $user_id)
|
->where('shop_supplier_id', '=', $shop_supplier_id)
|
->dec('balance', $money)
|
->update();
|
}
|
|
/**
|
* 获取总余额
|
*/
|
public static function getTotalBalance($user_id)
|
{
|
$model = new static();
|
return $model->where('user_id', '=', $user_id)
|
->sum("balance");
|
}
|
}
|
