One Hat Cyber Team

Your IP: 216.73.216.53
Server IP: 217.76.53.76
Server: Linux vmi1397931.contaboserver.net 5.4.0-105-generic #119-Ubuntu SMP Mon Mar 7 18:49:24 UTC 2022 x86_64
Server Software: Apache
PHP Version: 8.2.27
Buat File | Buat Folder
Dir : ~/www/wwwroot/onlinestore.ng/app/Http/Controllers/
View File Name : StoreAnalytic.php

<?php

namespace App\Http\Controllers;

use App\Models\Order;
use App\Models\Store;
use Illuminate\Http\Request;
use Shetabit\Visitor\Models\Visit;
use Shetabit\Visitor\Visitor;

class StoreAnalytic extends Controller
{
    public function index()
    {
        if(\Auth::user()->can('Manage Store Analytics')){
            $user      = \Auth::user();
            $store     = Store::where('id', $user->current_store)->first();
            $chartData = $this->getOrderChart(['duration' => 'month'],$store);
            $slug      = $store->slug;

            $visitor_url   = \DB::table('visitor')->selectRaw("count('*') as total, url")->where('slug', $slug)->groupBy('url')->orderBy('total', 'DESC')->get();
            $user_device   = \DB::table('visitor')->selectRaw("count('*') as total, device")->where('slug', $slug)->groupBy('device')->orderBy('device', 'DESC')->get();
            $user_browser  = \DB::table('visitor')->selectRaw("count('*') as total, browser")->where('slug', $slug)->groupBy('browser')->orderBy('browser', 'DESC')->get();
            $user_platform = \DB::table('visitor')->selectRaw("count('*') as total, platform")->where('slug', $slug)->groupBy('platform')->orderBy('platform', 'DESC')->get();
            $devicearray          = [];
            $devicearray['label'] = [];
            $devicearray['data']  = [];

            foreach($user_device as $name => $device)
            {
                if(!empty($device->device))
                {
                    $devicearray['label'][] = $device->device;
                }
                else
                {
                    $devicearray['label'][] = 'Other';
                }
                $devicearray['data'][] = $device->total;
            }

            $browserarray          = [];
            $browserarray['label'] = [];
            $browserarray['data']  = [];

            foreach($user_browser as $name => $browser)
            {
                $browserarray['label'][] = $browser->browser;
                $browserarray['data'][]  = $browser->total;
            }
            $platformarray          = [];
            $platformarray['label'] = [];
            $platformarray['data']  = [];

            foreach($user_platform as $name => $platform)
            {
                $platformarray['label'][] = $platform->platform;
                $platformarray['data'][]  = $platform->total;
            }
            return view('store-analytic', compact('chartData', 'visitor_url', 'devicearray', 'browserarray', 'platformarray','slug'));
        }
        else{
            return redirect()->back()->with('error', 'Permission denied.');
        }
    }

    public function getOrderChart($arrParam,$store)
    {
        $user  = \Auth::user();
        $slug  = $store->slug;

        $arrDuration = [];
        if($arrParam['duration'])
        {
            if($arrParam['duration'] == 'month')
            {
                $previous_month = strtotime("-2 week +1 day");
                for($i = 0; $i < 15; $i++)
                {
                    $arrDuration[date('Y-m-d', $previous_month)] = date('d-M', $previous_month);
                    $previous_month                              = strtotime(date('Y-m-d', $previous_month) . " +1 day");
                }
            }
        }
        $arrTask          = [];
        $arrTask['label'] = [];
        $arrTask['data']  = [];

        foreach($arrDuration as $date => $label)
        {
            $data['visitor'] = \DB::table('visitor')->select(\DB::raw('count(*) as total'))->where('slug', $slug)->whereDate('created_at', '=', $date)->first();
            $uniq            = \DB::table('visitor')->select('ip')->distinct()->where('slug', $slug)->whereDate('created_at', '=', $date)->get();

            $data['unique']           = $uniq->count();
            $arrTask['label'][]       = $label;
            $arrTask['data'][]        = $data['visitor']->total;
            $arrTask['unique_data'][] = $data['unique'];
        }

        return $arrTask;
    }
}