One Hat Cyber Team

Edit File: 387937628fd088c7ab357604cb187f87.php

<?php $__env->startSection('title', get_phrase('Admin Dashboard')); ?>
<?php $__env->startSection('admin_layout'); ?>
<script src="<?php echo e(asset('assets/backend/js/Chart.js')); ?>"></script>
<style>
    #myChart{
        width: 100%;
        height: 600px;
    }
</style>
<div class="row g-2 g-3 mb-3">
    <div class=" col-lg-3 col-md-6 col-sm-6">
        <div class="ol-card card-hover">
            <div class="ol-card-body px-20px py-3">
                <p class="sub-title fs-14px mb-2"><?php echo e(get_phrase('All User')); ?></p>
                <p class="title card-title-hover fs-18px"><?php echo e(count($users)); ?></p>
            </div>
        </div>
    </div>
    <div class=" col-lg-3 col-md-6 col-sm-6">
        <div class="ol-card card-hover">
            <div class="ol-card-body px-20px py-3">
                <p class="sub-title fs-14px mb-2"><?php echo e(get_phrase('Agent')); ?></p>
                <?php 
                  $agent = App\Models\User::where('is_agent',1)->get();  
                ?>
                <p class="title card-title-hover fs-18px"><?php echo e(count($agent)); ?></p>
            </div>
        </div>
    </div>
    <div class= "col-lg-3 col-md-6 col-sm-6">
        <div class="ol-card card-hover">
            <div class="ol-card-body px-20px py-3">
                <?php 
                 $subscriber = App\Models\Newsletter_subscriber::get();
                ?>
                <p class="sub-title fs-14px mb-2"><?php echo e(get_phrase('Subscriber')); ?></p>
                <p class="title card-title-hover fs-18px"><?php echo e(count($subscriber)); ?></p>
            </div>
        </div>
    </div>
    <div class= " col-lg-3 col-md-6 col-sm-6" >
        <div class="ol-card card-hover">
            <div class="ol-card-body px-20px py-3">
                <?php 
                   $totalPaidAmount = App\Models\Subscription::sum('paid_amount');
                ?>
                <p class="sub-title fs-14px mb-2"><?php echo e(get_phrase('Total Subscription')); ?></p>
                <p class="title card-title-hover fs-18px"><?php echo e(currency($totalPaidAmount)); ?></p>
            </div>
        </div>
    </div>
</div>
<?php

$beauty = App\Models\BeautyListing::where('visibility', 'visible')->count();
    $hotel = App\Models\HotelListing::where('visibility', 'visible')->count();
    $restaurant = App\Models\RestaurantListing::where('visibility', 'visible')->count();
    $realEstate = App\Models\RealEstateListing::where('visibility', 'visible')->count();
    $car = App\Models\CarListing::where('visibility', 'visible')->count();
    $totalStatic = $beauty + $hotel + $restaurant + $realEstate + $car;

// Dynamic listings and all types
    $customListings = App\Models\CustomListings::where('visibility', 'visible')->get();
    $customTypes = App\Models\CustomType::where('status', 1)->orderBy('sorting', 'asc')->get();

$totalDynamic = $customListings->count();
    $totalListing = $totalStatic + $totalDynamic;

// Define static types and counts
    $staticCounts = [
        'beauty' => $beauty,
        'hotel' => $hotel,
        'restaurant' => $restaurant,
        'real-estate' => $realEstate,
        'car' => $car,
    ];

$staticSlugs = array_keys($staticCounts);

// Calculate percentages
    $beautyPercentage = $totalListing ? ($beauty / $totalListing) * 100 : 0;
    $hotelPercentage = $totalListing ? ($hotel / $totalListing) * 100 : 0;
    $restaurantPercentage = $totalListing ? ($restaurant / $totalListing) * 100 : 0;
    $realEstatePercentage = $totalListing ? ($realEstate / $totalListing) * 100 : 0;
    $carPercentage = $totalListing ? ($car / $totalListing) * 100 : 0;

?> 
<div class="row mb-3 ">

<div class="col-xl-6 col-lg-6 col-md-12 col-sm-12">
        <div class="row gx-3 gy-2">
            
            <div class="col-lg-6 col-md-6 col-sm-6 mb-2">
                <div class="ol-card card-hover">
                    <div class="ol-card-body px-20px py-3">
                        <h5 class="sub-title fs-16px mb-2"><?php echo e(get_phrase('Total Listing')); ?></h5>
                        <h3 class="title card-title-hover fs-18px"><?php echo e($totalListing); ?></h3>
                    </div>
                </div>
            </div>
            <?php $__currentLoopData = $customTypes; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $type): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
                <?php
                    $typeSlug = $type->slug;
                    $typeName = ucfirst(str_replace('-', ' ', $typeSlug));

$count = in_array($typeSlug, $staticSlugs)
                        ? ($staticCounts[$typeSlug] ?? 0)
                        : $customListings->where('type', $typeSlug)->count();
                ?>

<div class="col-lg-6 col-md-6 col-sm-6 mb-2">
                    <div class="ol-card card-hover">
                        <div class="ol-card-body px-20px py-3">
                            <h5 class="sub-title fs-16px mb-2"><?php echo e(get_phrase($typeName)); ?></h5>
                            <h3 class="title card-title-hover fs-18px"><?php echo e($count); ?></h3>
                        </div>
                    </div>
                </div>
            <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
        </div>
    </div>

<?php
    $staticCounts = [
        'beauty' => $beauty,
        'hotel' => $hotel,
        'restaurant' => $restaurant,
        'real-estate' => $realEstate,
        'car' => $car,
    ];

$staticSlugs = array_keys($staticCounts);

$allTypes = \App\Models\CustomType::where('status', 1)->orderBy('sorting', 'asc')->get();
    $customListings = \App\Models\CustomListings::where('visibility', 'visible')->get();

$totalListing = array_sum($staticCounts) + $customListings->count();

$labels = [];
    $percentages = [];
    $colors = [];

// Predefined colors for first 5 static types
    $presetColors = ["#FF736A", "#124797", "#EF255C", "#44A1ED", "#0F0B0B"];
    $dynamicColorPool = ['#7F27FF', '#35A29F', '#F86F03', '#A34343', '#4C4B16', '#7286D3', '#43766C', '#FD8D14', '#B3005E', '#A0C49D'];

$colorIndex = 0;

foreach ($allTypes as $index => $type) {
        $slug = $type->slug;
        $name = ucfirst(str_replace('-', ' ', $slug));

$count = in_array($slug, $staticSlugs)
            ? ($staticCounts[$slug] ?? 0)
            : $customListings->where('type', $slug)->count();

$percentage = $totalListing > 0 ? round(($count / $totalListing) * 100, 2) : 0;

$labels[] = $name;
        $percentages[] = $percentage;

// Use static color if available, otherwise pick from dynamic pool
        $colors[] = $presetColors[$index] ?? $dynamicColorPool[$colorIndex++ % count($dynamicColorPool)];
    }
?>

<?php
    $currentYear = date('Y');
    $monthlyEarnings = DB::table('subscriptions')
        ->selectRaw("MONTH(created_at) as month, SUM(paid_amount) as total_earning")
        ->whereYear('created_at', $currentYear)
        ->groupBy(DB::raw("MONTH(created_at)"))
        ->orderBy(DB::raw("MONTH(created_at)"))
        ->get();
    $monthlyData = [];
    for ($i = 1; $i <= 12; $i++) {
        $earningsForMonth = $monthlyEarnings->firstWhere('month', $i);
        $monthlyData[$i] = $earningsForMonth ? $earningsForMonth->total_earning : 0;
    }
?>
<div class="row">
    <div class="col-12">
        <div class="ol-card h-100">
            <div class="ol-card-body p-4">
                <canvas id="myCharts" class="w-100"></canvas>
            </div>
        </div>
    </div>
</div>
<script>
    "use strict";
    const xValues = <?php echo json_encode($labels); ?>;
    const yValues = <?php echo json_encode($percentages); ?>;
    const barColors = <?php echo json_encode($colors); ?>;

new Chart("myChart", {
        type: "pie",
        data: {
            labels: xValues,
            datasets: [{
                backgroundColor: barColors,
                data: yValues
            }]
        },
        options: {
            title: {
                display: true,
                text: "<?php echo e(get_phrase('Visible Listings as Percentages')); ?>"
            },
            tooltips: {
                callbacks: {
                    label: function(tooltipItem, data) {
                        let label = data.labels[tooltipItem.index] || '';
                        if (label) {
                            label += ': ';
                        }
                        label += data.datasets[0].data[tooltipItem.index].toFixed(2) + '%';
                        return label;
                    }
                }
            }
        }
    });
</script>

new Chart("myCharts", {
      type: "bar",
      data: {
        labels: months,
        datasets: [{
          label: "Earnings", 
          backgroundColor: barColors2, 
          data: earnings
        }]
      },
      options: {
        legend: {display: false},
        title: {
          display: true,
          text: "<?php echo e(get_phrase('Monthly Earnings for')); ?> " + currentYear 
        },
        scales: {
          y: {
            beginAtZero: true
          }
        }
      }
    });
</script>

<?php $__env->stopSection(); ?>
<?php echo $__env->make('layouts.admin', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?><?php /**PATH /www/wwwroot/jumo.com.ng/resources/views/admin/dashboard.blade.php ENDPATH**/ ?>