<?php
|
|
namespace app\job\model\plus\bonus;
|
|
use app\common\model\plus\bonus\User as UserModel;
|
use app\common\model\plus\bonus\Setting;
|
use app\common\library\helper;
|
|
/**
|
* 用户优惠券模型
|
*/
|
class User extends UserModel
|
{
|
/**
|
* 获取排位已过期的队长ID集
|
*/
|
// public function getExpiredUserIds($app_id)
|
// {
|
// $setting = Setting::getItem('basic', $app_id);
|
// // log_write($setting);
|
// if (empty($setting['expire_day'])) {
|
// return '';
|
// }
|
// $time = time() - 86400 * $setting['expire_day'];
|
// // log_write($time);
|
// return $this->where('is_expire', '=', 0)
|
// ->where('is_delete', '=', 0)
|
// ->where('tree_level', '>', 3)
|
// ->where('agent_time', '<', $time)->column('user_id');
|
// }
|
|
/**
|
* 获取排位已过期的队长ID集（直推超过3个的不设置过期）
|
*/
|
public function getExpiredUserIds($app_id)
|
{
|
$setting = Setting::getItem('basic', $app_id);
|
// log_write($setting);
|
if (empty($setting['expire_day'])) {
|
return '';
|
}
|
$time = time() - 86400 * $setting['expire_day'];
|
$list = $this->alias('bonus')->where('bonus.is_expire', '=', 0)
|
->where('bonus.is_delete', '=', 0)
|
->where('bonus.tree_level', '>', 3)
|
->where('bonus.is_permanent', '=', 0)
|
->where('bonus.agent_time', '<', $time)
|
->field('bonus.user_id,count(agent.user_id) as num')
|
->leftJoin('agent_user agent', 'agent.referee_id=bonus.user_id')
|
->having('num<3')
|
->group('bonus.user_id')
|
->select()->toArray();
|
log_write($list);
|
return helper::getArrayColumn($list, 'user_id');
|
}
|
|
/**
|
* 设置队长排位过期状态
|
*/
|
public function setIsExpire($UserIds)
|
{
|
if (empty($UserIds)) {
|
return false;
|
}
|
return $this->where('user_id', 'in', $UserIds)->save(['is_expire' => 1]);
|
}
|
|
/**
|
* 获取可解冻业绩奖的队长列表
|
*/
|
public function getBackUserList($app_id)
|
{
|
$setting = Setting::getItem('basic', $app_id);
|
$model = $this->alias('bonus');
|
if (!empty($setting['expire_day'])) {
|
$model = $model->where('bonus.is_expire', '=', 0);
|
}
|
return $model->where('bonus.is_delete', '=', 0)
|
->where('freeze_money_second', '>', 0)
|
->join('agent_user agent', 'agent.referee_id=bonus.user_id and agent.first_num>=3')
|
->field('bonus.user_id,bonus.money,bonus.freeze_money_second,count(agent.user_id) as num')
|
->having('num>=3')
|
->group('bonus.user_id')
|
->select();
|
}
|
|
/**
|
* 执行解冻业绩
|
*/
|
public function setBackFreezeMoneySecond($list)
|
{
|
$data = [];
|
foreach ($list as $item) {
|
$data[] = [
|
'user_id' => $item['user_id'],
|
'money' => $item['money'] + $item['freeze_money_second'],
|
'freeze_money_second' => 0
|
];
|
}
|
$data && $this->saveAll($data);
|
return true;
|
}
|
|
}
|
