<?php
|
|
namespace app\shop\model\branch;
|
|
use app\common\model\branch\Member as MemberModel;
|
use app\common\model\user\User as UserModel;
|
|
/**
|
* 连盟成员模型
|
* Class Member
|
* @package app\shop\model\branch
|
*/
|
class Member extends MemberModel
|
{
|
/**
|
* 获取连盟成员列表
|
*/
|
public function getList($params = [])
|
{
|
// 构建查询规则
|
$model = $this->alias('branch_member')
|
->field('branch_member.*, user.nickName, user.avatarUrl, user.real_name, user.mobile, branch_position.weight, branch_position.name as position_name')
|
->with(['branch'])
|
->join('user', 'user.user_id = branch_member.user_id')
|
->join('branch_position', 'branch_position.position_id = branch_member.position_id')
|
->where('branch_member.is_delete', '=', 0)
|
->order(['branch_position.weight' => 'desc', 'branch_member.create_time' => 'desc']);
|
// 查询条件
|
if (!empty($params['branch_id'])) {
|
$model = $model->where('branch_member.branch_id', '=', $params['branch_id']);
|
}
|
if (!empty($params['keywords'])) {
|
if ($params['keywords'] == 'user_id') {
|
$model = $model->where('user.user_id', '=', (int)$params['keywords']);
|
} else {
|
$model = $model->where('user.nickName|user.real_name|user.mobile', 'like', '%' . $search . '%');
|
}
|
}
|
return $model->paginate($params);
|
}
|
|
/**
|
* 编辑连盟成员
|
* @param $data
|
* @return bool
|
*/
|
public function edit($data)
|
{
|
return $this->save($data) !== false;
|
}
|
|
/**
|
* 删除连盟成员
|
* @return mixed
|
*/
|
public function setDelete()
|
{
|
return $this->transaction(function () {
|
// 标记当前股东记录为已删除
|
return $this->save([
|
'is_delete' => 1
|
]);
|
});
|
}
|
|
/**
|
* 提现打款成功：累积提现佣金
|
*/
|
public static function totalMoney($user_id, $money)
|
{
|
$model = self::detail($user_id);
|
return $model->save([
|
'freeze_money' => $model['freeze_money'] - $money,
|
'total_money' => $model['total_money'] + $money,
|
]);
|
}
|
|
/**
|
* 提现驳回：解冻股东资金
|
*/
|
public static function backFreezeMoney($user_id, $money)
|
{
|
$model = self::detail($user_id);
|
return $model->save([
|
'money' => $model['money'] + $money,
|
'freeze_money' => $model['freeze_money'] - $money,
|
]);
|
}
|
|
/**
|
* 获取平台的总销售额
|
*/
|
public function getTotalMoney($type = 'all_money')
|
{
|
$model = $this;
|
if($type == 'money'){
|
return $model->sum('money');
|
} else if($type == 'freeze_money'){
|
return $model->sum('freeze_money');
|
} else if($type == 'total_money'){
|
return $model->sum('total_money');
|
} else if($type == 'all_money'){
|
return $model->sum('total_money') + $model->sum('freeze_money') + $model->sum('money');
|
}
|
return 0;
|
}
|
}
|
