ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / tripvare.com / app / Http / Controllers / admin / dashboard

<?php

namespace App\Http\Controllers\admin\dashboard;

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Carbon;

use App\Models\User;
use App\Models\TravelInformation;

class AdminDashboard extends Controller
{

/**
     * Get Statistical Data
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {        
        $record = $graph_data = [];
        
        $query = DB::raw('COUNT(*) AS total_users, COUNT(if(account_status=1,1,null)) as total_active_users');
        $data = DB::table('users')->select($query)->get(); 
        
        $total_travel_information = TravelInformation::whereNotNull('information')->count();

$graph = User::selectRaw('month(created_at) month, COUNT(*) new_join')              
              ->groupBy('month')
              ->where('created_at', '>=', Carbon::now()->subMonths(6))             
              ->orderBy('month','asc')
              ->get();

foreach($graph as $key=>$d){
            $record[$d->month] =  $d->new_join;           
        }

for ($i = 6; $i >= 1; $i--) {        
            $month_name = date('M', strtotime("-$i month"));
            $month_numeric = date('n', strtotime("-$i month"));                   
            $graph_data[$month_name] = isset($record[$month_numeric])?$record[$month_numeric]:0;
        }

return view('admin/dashboard/dashboard_landing')->with('data', $data)->with('graph_data',$graph_data)->with('total_travel_information',$total_travel_information);        
    }

}

[-] AdminProfile.php [edit]
[-] ManageCorporateUser.php [edit]
[+] ..
[-] ManageNavigation.php [edit]
[-] AdminDashboard.php [edit]
[-] ManageUser.php [edit]
[-] ManageSettings.php [edit]
[-] ManagePages.php [edit]
[-] ManageReward.php [edit]