|
|
|
|
<?php
|
|
|
|
|
|
|
|
|
|
namespace App\Models;
|
|
|
|
|
|
|
|
|
|
/**
|
|
|
|
|
* User Model
|
|
|
|
|
*/
|
|
|
|
|
|
|
|
|
|
use App\Utils\Tools;
|
|
|
|
|
use App\Utils\Hash;
|
|
|
|
|
use App\Services\Config;
|
|
|
|
|
use App\Utils\GA;
|
|
|
|
|
use App\Utils\QQWry;
|
|
|
|
|
use App\Utils\Radius;
|
|
|
|
|
use Ramsey\Uuid\Uuid;
|
|
|
|
|
use App\Models\DetectLog;
|
|
|
|
|
use App\Models\DetectBanLog;
|
|
|
|
|
|
|
|
|
|
class User extends Model
|
|
|
|
|
{
|
|
|
|
|
protected $connection = 'default';
|
|
|
|
|
protected $table = 'user';
|
|
|
|
|
|
|
|
|
|
public $isLogin;
|
|
|
|
|
|
|
|
|
|
public $isAdmin;
|
|
|
|
|
|
|
|
|
|
protected $casts = [
|
|
|
|
|
't' => 'float',
|
|
|
|
|
'u' => 'float',
|
|
|
|
|
'd' => 'float',
|
|
|
|
|
'port' => 'int',
|
|
|
|
|
'transfer_enable' => 'float',
|
|
|
|
|
'enable' => 'int',
|
|
|
|
|
'is_admin' => 'boolean',
|
|
|
|
|
'is_multi_user' => 'int',
|
|
|
|
|
'node_speedlimit' => 'float',
|
|
|
|
|
];
|
|
|
|
|
|
|
|
|
|
public function getGravatarAttribute()
|
|
|
|
|
{
|
|
|
|
|
$hash = md5(strtolower(trim($this->attributes['email'])));
|
|
|
|
|
return 'https://gravatar.loli.net/avatar/' . $hash;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function isAdmin()
|
|
|
|
|
{
|
|
|
|
|
return $this->attributes['is_admin'];
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function lastSsTime()
|
|
|
|
|
{
|
|
|
|
|
if ($this->attributes['t'] == 0) {
|
|
|
|
|
return '从未使用喵';
|
|
|
|
|
}
|
|
|
|
|
return Tools::toDateTime($this->attributes['t']);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function getMuMd5()
|
|
|
|
|
{
|
|
|
|
|
$str = str_replace(
|
|
|
|
|
array('%id', '%suffix'),
|
|
|
|
|
array($this->attributes['id'], Config::get('mu_suffix')),
|
|
|
|
|
Config::get('mu_regex')
|
|
|
|
|
);
|
|
|
|
|
preg_match_all("|%-?[1-9]\d*m|U", $str, $matches, PREG_PATTERN_ORDER);
|
|
|
|
|
foreach ($matches[0] as $key) {
|
|
|
|
|
$key_match = str_replace(array('%', 'm'), '', $key);
|
|
|
|
|
$md5 = substr(
|
|
|
|
|
MD5($this->attributes['id'] . $this->attributes['passwd'] . $this->attributes['method'] . $this->attributes['obfs'] . $this->attributes['protocol']),
|
|
|
|
|
($key_match < 0 ? $key_match : 0),
|
|
|
|
|
abs($key_match)
|
|
|
|
|
);
|
|
|
|
|
$str = str_replace($key, $md5, $str);
|
|
|
|
|
}
|
|
|
|
|
return $str;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function lastCheckInTime()
|
|
|
|
|
{
|
|
|
|
|
if ($this->attributes['last_check_in_time'] == 0) {
|
|
|
|
|
return '从未签到';
|
|
|
|
|
}
|
|
|
|
|
return Tools::toDateTime($this->attributes['last_check_in_time']);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function regDate()
|
|
|
|
|
{
|
|
|
|
|
return $this->attributes['reg_date'];
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function updatePassword($pwd)
|
|
|
|
|
{
|
|
|
|
|
$this->pass = Hash::passwordHash($pwd);
|
|
|
|
|
$this->save();
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function get_forbidden_ip()
|
|
|
|
|
{
|
|
|
|
|
return str_replace(',', PHP_EOL, $this->attributes['forbidden_ip']);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function get_forbidden_port()
|
|
|
|
|
{
|
|
|
|
|
return str_replace(',', PHP_EOL, $this->attributes['forbidden_port']);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function updateSsPwd($pwd)
|
|
|
|
|
{
|
|
|
|
|
$this->passwd = $pwd;
|
|
|
|
|
$this->save();
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function updateMethod($method)
|
|
|
|
|
{
|
|
|
|
|
$this->method = $method;
|
|
|
|
|
$this->save();
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function addInviteCode()
|
|
|
|
|
{
|
|
|
|
|
$uid = $this->attributes['id'];
|
|
|
|
|
$code = new InviteCode();
|
|
|
|
|
while (true) {
|
|
|
|
|
$temp_code = Tools::genRandomChar(4);
|
|
|
|
|
if (InviteCode::where('user_id', $uid)->count() == 0) {
|
|
|
|
|
break;
|
|
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
$code->code = $temp_code;
|
|
|
|
|
$code->user_id = $uid;
|
|
|
|
|
$code->save();
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function getUuid()
|
|
|
|
|
{
|
|
|
|
|
return Uuid::uuid3(
|
|
|
|
|
Uuid::NAMESPACE_DNS,
|
|
|
|
|
$this->attributes['id'] . '|' . $this->attributes['passwd']
|
|
|
|
|
)->toString();
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function trafficUsagePercent()
|
|
|
|
|
{
|
|
|
|
|
$total = $this->attributes['u'] + $this->attributes['d'];
|
|
|
|
|
$transferEnable = $this->attributes['transfer_enable'];
|
|
|
|
|
if ($transferEnable == 0) {
|
|
|
|
|
return 0;
|
|
|
|
|
}
|
|
|
|
|
$percent = $total / $transferEnable;
|
|
|
|
|
$percent = round($percent, 2);
|
|
|
|
|
$percent *= 100;
|
|
|
|
|
return $percent;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function enableTraffic()
|
|
|
|
|
{
|
|
|
|
|
$transfer_enable = $this->attributes['transfer_enable'];
|
|
|
|
|
return Tools::flowAutoShow($transfer_enable);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function enableTrafficInGB()
|
|
|
|
|
{
|
|
|
|
|
$transfer_enable = $this->attributes['transfer_enable'];
|
|
|
|
|
return Tools::flowToGB($transfer_enable);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function usedTraffic()
|
|
|
|
|
{
|
|
|
|
|
$total = $this->attributes['u'] + $this->attributes['d'];
|
|
|
|
|
return Tools::flowAutoShow($total);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function unusedTraffic()
|
|
|
|
|
{
|
|
|
|
|
$total = $this->attributes['u'] + $this->attributes['d'];
|
|
|
|
|
$transfer_enable = $this->attributes['transfer_enable'];
|
|
|
|
|
return Tools::flowAutoShow($transfer_enable - $total);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function TodayusedTraffic()
|
|
|
|
|
{
|
|
|
|
|
$total = $this->attributes['u'] + $this->attributes['d'] - $this->attributes['last_day_t'];
|
|
|
|
|
return Tools::flowAutoShow($total);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function LastusedTraffic()
|
|
|
|
|
{
|
|
|
|
|
$total = $this->attributes['last_day_t'];
|
|
|
|
|
return Tools::flowAutoShow($total);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function isAbleToCheckin()
|
|
|
|
|
{
|
|
|
|
|
$last = $this->attributes['last_check_in_time'];
|
|
|
|
|
|
|
|
|
|
$now = time();
|
|
|
|
|
return date('Ymd', $now) != date('Ymd', $last);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
/*
|
|
|
|
|
* @param traffic 单位 MB
|
|
|
|
|
*/
|
|
|
|
|
public function addTraffic($traffic)
|
|
|
|
|
{
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function getGAurl()
|
|
|
|
|
{
|
|
|
|
|
$ga = new GA();
|
|
|
|
|
$url = $ga->getUrl(
|
|
|
|
|
urlencode(Config::get('appName') . '-' . $this->attributes['user_name'] . '-两步验证码'),
|
|
|
|
|
$this->attributes['ga_token']
|
|
|
|
|
);
|
|
|
|
|
return $url;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function inviteCodes()
|
|
|
|
|
{
|
|
|
|
|
$uid = $this->attributes['id'];
|
|
|
|
|
return InviteCode::where('user_id', $uid)->get();
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function ref_by_user()
|
|
|
|
|
{
|
|
|
|
|
$uid = $this->attributes['ref_by'];
|
|
|
|
|
return self::where('id', $uid)->first();
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function clean_link()
|
|
|
|
|
{
|
|
|
|
|
$uid = $this->attributes['id'];
|
|
|
|
|
Link::where('userid', $uid)->delete();
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function clear_inviteCodes()
|
|
|
|
|
{
|
|
|
|
|
$uid = $this->attributes['id'];
|
|
|
|
|
InviteCode::where('user_id', $uid)->delete();
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function online_ip_count()
|
|
|
|
|
{
|
|
|
|
|
$uid = $this->attributes['id'];
|
|
|
|
|
$total = Ip::where('datetime', '>=', time() - 90)->where('userid', $uid)->orderBy('userid', 'desc')->get();
|
|
|
|
|
$unique_ip_list = array();
|
|
|
|
|
foreach ($total as $single_record) {
|
|
|
|
|
$single_record->ip = Tools::getRealIp($single_record->ip);
|
|
|
|
|
$is_node = Node::where('node_ip', $single_record->ip)->first();
|
|
|
|
|
if ($is_node) {
|
|
|
|
|
continue;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
if (!in_array($single_record->ip, $unique_ip_list)) {
|
|
|
|
|
$unique_ip_list[] = $single_record->ip;
|
|
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
return count($unique_ip_list);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function kill_user()
|
|
|
|
|
{
|
|
|
|
|
$uid = $this->attributes['id'];
|
|
|
|
|
$email = $this->attributes['email'];
|
|
|
|
|
|
|
|
|
|
Radius::Delete($email);
|
|
|
|
|
|
|
|
|
|
RadiusBan::where('userid', '=', $uid)->delete();
|
|
|
|
|
Disconnect::where('userid', '=', $uid)->delete();
|
|
|
|
|
Bought::where('userid', '=', $uid)->delete();
|
|
|
|
|
Bought::where('userid', '=', $uid)->delete();
|
|
|
|
|
Ip::where('userid', '=', $uid)->delete();
|
|
|
|
|
Code::where('userid', '=', $uid)->delete();
|
|
|
|
|
DetectLog::where('user_id', '=', $uid)->delete();
|
|
|
|
|
Link::where('userid', '=', $uid)->delete();
|
|
|
|
|
LoginIp::where('userid', '=', $uid)->delete();
|
|
|
|
|
InviteCode::where('user_id', '=', $uid)->delete();
|
|
|
|
|
TelegramSession::where('user_id', '=', $uid)->delete();
|
|
|
|
|
UnblockIp::where('userid', '=', $uid)->delete();
|
|
|
|
|
TrafficLog::where('user_id', '=', $uid)->delete();
|
|
|
|
|
Token::where('user_id', '=', $uid)->delete();
|
|
|
|
|
PasswordReset::where('email', '=', $email)->delete();
|
|
|
|
|
|
|
|
|
|
$this->delete();
|
|
|
|
|
|
|
|
|
|
return true;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function get_table_json_array()
|
|
|
|
|
{
|
|
|
|
|
$id = $this->attributes['id'];
|
|
|
|
|
$today_traffic = Tools::flowToMB($this->attributes['u'] + $this->attributes['d'] - $this->attributes['last_day_t']);
|
|
|
|
|
$is_enable = $this->attributes['enable'] == 1 ? '可用' : '禁用';
|
|
|
|
|
$reg_location = $this->attributes['reg_ip'];
|
|
|
|
|
$account_expire_in = $this->attributes['expire_in'];
|
|
|
|
|
$class_expire_in = $this->attributes['class_expire'];
|
|
|
|
|
$used_traffic = Tools::flowToGB($this->attributes['u'] + $this->attributes['d']);
|
|
|
|
|
$enable_traffic = Tools::flowToGB($this->attributes['transfer_enable']);
|
|
|
|
|
|
|
|
|
|
$im_type = '';
|
|
|
|
|
$im_value = $this->attributes['im_value'];
|
|
|
|
|
switch ($this->attributes['im_type']) {
|
|
|
|
|
case 1:
|
|
|
|
|
$im_type = '微信';
|
|
|
|
|
break;
|
|
|
|
|
case 2:
|
|
|
|
|
$im_type = 'QQ';
|
|
|
|
|
break;
|
|
|
|
|
case 3:
|
|
|
|
|
$im_type = 'Google+';
|
|
|
|
|
break;
|
|
|
|
|
default:
|
|
|
|
|
$im_type = 'Telegram';
|
|
|
|
|
$im_value = '<a href="https://telegram.me/' . $im_value . '">' . $im_value . '</a>';
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
$ref_user = self::find($this->attributes['ref_by']);
|
|
|
|
|
|
|
|
|
|
if ($this->attributes['ref_by'] == 0) {
|
|
|
|
|
$ref_user_id = 0;
|
|
|
|
|
$ref_user_name = '系统邀请';
|
|
|
|
|
} elseif ($ref_user == null) {
|
|
|
|
|
$ref_user_id = $this->attributes['ref_by'];
|
|
|
|
|
$ref_user_name = '邀请人已经被删除';
|
|
|
|
|
} else {
|
|
|
|
|
$ref_user_id = $this->attributes['ref_by'];
|
|
|
|
|
$ref_user_name = $ref_user->user_name;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
$iplocation = new QQWry();
|
|
|
|
|
$location = $iplocation->getlocation($reg_location);
|
|
|
|
|
$reg_location .= "\n" . iconv('gbk', 'utf-8//IGNORE', $location['country'] . $location['area']);
|
|
|
|
|
|
|
|
|
|
$return_array = array(
|
|
|
|
|
'DT_RowId' => 'row_1_' . $id,
|
|
|
|
|
$id,
|
|
|
|
|
$id,
|
|
|
|
|
$this->attributes['user_name'],
|
|
|
|
|
$this->attributes['remark'],
|
|
|
|
|
$this->attributes['email'],
|
|
|
|
|
$this->attributes['money'],
|
|
|
|
|
$im_type,
|
|
|
|
|
$im_value,
|
|
|
|
|
$this->attributes['node_group'],
|
|
|
|
|
$account_expire_in,
|
|
|
|
|
$this->attributes['class'],
|
|
|
|
|
$class_expire_in,
|
|
|
|
|
$this->attributes['passwd'],
|
|
|
|
|
$this->attributes['port'],
|
|
|
|
|
$this->attributes['method'],
|
|
|
|
|
$this->attributes['protocol'],
|
|
|
|
|
$this->attributes['obfs'],
|
|
|
|
|
$this->online_ip_count(),
|
|
|
|
|
$this->lastSsTime(),
|
|
|
|
|
$used_traffic,
|
|
|
|
|
$enable_traffic,
|
|
|
|
|
$this->lastCheckInTime(),
|
|
|
|
|
$today_traffic,
|
|
|
|
|
$is_enable,
|
|
|
|
|
$this->attributes['reg_date'],
|
|
|
|
|
$reg_location,
|
|
|
|
|
$this->attributes['auto_reset_day'],
|
|
|
|
|
$this->attributes['auto_reset_bandwidth'],
|
|
|
|
|
$ref_user_id,
|
|
|
|
|
$ref_user_name
|
|
|
|
|
);
|
|
|
|
|
return $return_array;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function get_user_attributes($key)
|
|
|
|
|
{
|
|
|
|
|
return $this->attributes[$key];
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function get_top_up()
|
|
|
|
|
{
|
|
|
|
|
$codes = Code::where('userid', $this->attributes['id'])->get();
|
|
|
|
|
$top_up = 0;
|
|
|
|
|
foreach ($codes as $code) {
|
|
|
|
|
$top_up += $code->number;
|
|
|
|
|
}
|
|
|
|
|
return round($top_up, 2);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
// 最后一次被封禁的时间
|
|
|
|
|
public function last_detect_ban_time()
|
|
|
|
|
{
|
|
|
|
|
return ($this->attributes['last_detect_ban_time'] == '1989-06-04 00:05:00'
|
|
|
|
|
? '未被封禁过'
|
|
|
|
|
: $this->attributes['last_detect_ban_time']
|
|
|
|
|
);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
// 当前解封时间
|
|
|
|
|
public function relieve_time()
|
|
|
|
|
{
|
|
|
|
|
if ($this->attributes['detect_ban'] == 1) {
|
|
|
|
|
$logs = DetectBanLog::where('user_id', $this->attributes['id'])->orderBy("id", "desc")->first();
|
|
|
|
|
$time = ($logs->end_time + $logs->ban_time * 60);
|
|
|
|
|
return date('Y-m-d H:i:s', $time);
|
|
|
|
|
} else {
|
|
|
|
|
return '当前未被封禁';
|
|
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
// 累计被封禁的次数
|
|
|
|
|
public function detect_ban_number()
|
|
|
|
|
{
|
|
|
|
|
$logs = DetectBanLog::where('user_id', $this->attributes['id'])->get();
|
|
|
|
|
return count($logs);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
// 最后一次封禁的违规次数
|
|
|
|
|
public function user_detect_ban_number()
|
|
|
|
|
{
|
|
|
|
|
$logs = DetectBanLog::where('user_id', $this->attributes['id'])->orderBy("id", "desc")->first();
|
|
|
|
|
return $logs->detect_number;
|
|
|
|
|
}
|
|
|
|
|
public function yesterdayIncome()
|
|
|
|
|
{ $number = Code::where('usedatetime', 'like', date('Y-m-d%', strtotime('-1 days')))->sum('number');
|
|
|
|
|
return is_null($number)?0:$number;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function todayIncome()
|
|
|
|
|
{
|
|
|
|
|
$number = Code::where('usedatetime', 'like', date('Y-m-d%'))->sum('number');
|
|
|
|
|
return is_null($number)?0:$number;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function thisMonthIncome()
|
|
|
|
|
{
|
|
|
|
|
$number = Code::where('usedatetime', 'like', date('Y-m%'))->sum('number');
|
|
|
|
|
return is_null($number)?0:$number;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function lastMonthIncome()
|
|
|
|
|
{
|
|
|
|
|
$number = Code::where('usedatetime', 'like', date('Y-m%', strtotime('-1 months')))->sum('number');
|
|
|
|
|
return is_null($number)?0:$number;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function totalIncome()
|
|
|
|
|
{
|
|
|
|
|
$number = Code::where('usedatetime', 'like', date('%'))->sum('number');
|
|
|
|
|
return is_null($number)?0:$number;
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function paidUserCount()
|
|
|
|
|
{
|
|
|
|
|
return self::where('class', '!=', '0')->count();
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
public function disableReason()
|
|
|
|
|
{
|
|
|
|
|
$reason_id = DetectLog::where('user_id', '=', $this->attributes['id'])->orderBy('id', 'DESC')->first();
|
|
|
|
|
$reason = DetectRule::where('id', '=', $reason_id->list_id)->get();
|
|
|
|
|
return $reason[0]->text;
|
|
|
|
|
}
|
|
|
|
|
}
|