49 lines
1.4 KiB
PHP
49 lines
1.4 KiB
PHP
<?php
|
|
|
|
namespace App\Http\Controllers\Manages;
|
|
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
class Index extends Base
|
|
{
|
|
public function index()
|
|
{
|
|
if (empty(session('admin_id'))){
|
|
return redirect('/manage');
|
|
}
|
|
$view = [
|
|
'menus'=>AuthModel::getMenus(),
|
|
'username' => session('admin_username')
|
|
];
|
|
return view('manages.index',$view);
|
|
}
|
|
|
|
public function console()
|
|
{
|
|
$start = strtotime(date('Y-m-d'));
|
|
$end = $start + 24 * 60 * 60 - 1;
|
|
$today = [$start,$end];
|
|
$data['today_user'] = DB::table('users')
|
|
->whereBetween('time',$today)
|
|
->count();
|
|
$data['all_user'] = DB::table('users')
|
|
->count();
|
|
|
|
$data['today_withdraw_count'] = DB::table('users_wallet_out')
|
|
->whereBetween('create_time',$today)
|
|
->count();
|
|
$data['today_withdraw_amount'] = DB::table('users_wallet_out')
|
|
->whereBetween('create_time',$today)
|
|
->sum('number');
|
|
|
|
$data['today_charge_count'] = DB::table('charge_req')
|
|
->whereBetween('created_at',$today)
|
|
->count();
|
|
$data['today_charge_amount'] = DB::table('charge_req')
|
|
->whereBetween('created_at',$today)
|
|
->sum('amount');
|
|
|
|
return view('manages.console')->with('data',$data);
|
|
}
|
|
|
|
} |