You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
76 lines
2.0 KiB
PHTML
76 lines
2.0 KiB
PHTML
|
2 months ago
|
<?php
|
||
|
|
|
||
|
|
namespace App\Services;
|
||
|
|
|
||
|
|
use App\Models\User;
|
||
|
|
use App\Models\Code;
|
||
|
|
|
||
|
|
class Analytics
|
||
|
|
{
|
||
|
|
public function getTotalUser()
|
||
|
|
{
|
||
|
|
return User::count();
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getIncome($start, $end)
|
||
|
|
{
|
||
|
|
$sum = Code::where('usedatetime', '>=', date("Y-m-d H:i:s", $start))
|
||
|
|
->where('usedatetime', '<', date("Y-m-d H:i:s", $end))
|
||
|
|
->sum('number');
|
||
|
|
if ($sum == null) {
|
||
|
|
$sum = 0;
|
||
|
|
}
|
||
|
|
return $sum;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getNewUsers($start, $end)
|
||
|
|
{
|
||
|
|
$users = User::where('reg_date', '>=', date("Y-m-d H:i:s", $start))
|
||
|
|
->where('reg_date', '<', date("Y-m-d H:i:s", $end))
|
||
|
|
->count();
|
||
|
|
if ($users == null) {
|
||
|
|
$users = 0;
|
||
|
|
}
|
||
|
|
return $users;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getNewUserIncome($start, $end)
|
||
|
|
{
|
||
|
|
$startDate = date("Y-m-d H:i:s", $start);
|
||
|
|
$endDate = date("Y-m-d H:i:s", $end);
|
||
|
|
|
||
|
|
$sum = Code::join('user', 'code.userid', '=', 'user.id')
|
||
|
|
->where('user.reg_date', '>=', $startDate)
|
||
|
|
->where('user.reg_date', '<', $endDate)
|
||
|
|
->where('code.usedatetime', '>=', $startDate)
|
||
|
|
->where('code.usedatetime', '<', $endDate)
|
||
|
|
->where('code.number', '>', 0)
|
||
|
|
->sum('code.number');
|
||
|
|
|
||
|
|
if ($sum == null) {
|
||
|
|
$sum = 0;
|
||
|
|
}
|
||
|
|
return $sum;
|
||
|
|
}
|
||
|
|
|
||
|
|
public function getNewPaidUsers($start, $end)
|
||
|
|
{
|
||
|
|
$startDate = date("Y-m-d H:i:s", $start);
|
||
|
|
$endDate = date("Y-m-d H:i:s", $end);
|
||
|
|
|
||
|
|
$users = Code::join('user', 'code.userid', '=', 'user.id')
|
||
|
|
->where('user.reg_date', '>=', $startDate)
|
||
|
|
->where('user.reg_date', '<', $endDate)
|
||
|
|
->where('code.usedatetime', '>=', $startDate)
|
||
|
|
->where('code.usedatetime', '<', $endDate)
|
||
|
|
->where('code.number', '>', 0)
|
||
|
|
->distinct()
|
||
|
|
->count('code.userid');
|
||
|
|
|
||
|
|
if ($users == null) {
|
||
|
|
$users = 0;
|
||
|
|
}
|
||
|
|
return $users;
|
||
|
|
}
|
||
|
|
}
|