CORE_V5 // Controllers

PATH: home / rwabteecom / public_html / app / Http / Controllers /

Editing: DashboardController.php

<?php

namespace App\Http\Controllers;

use App\Models\ScheduleAppointment;
use App\Models\Subscription;
use App\Models\Transaction;
use App\Models\User;
use App\Models\Vcard;
use App\Models\WhatsappStore;
use App\Models\WpOrder;
use App\Repositories\DashboardRepository;
use Carbon\Carbon;
use Carbon\CarbonPeriod;
use Illuminate\Contracts\Foundation\Application;
use Illuminate\Contracts\View\Factory;
use Illuminate\Contracts\View\View;
use Illuminate\Http\JsonResponse;
use Illuminate\Http\Request;

class DashboardController extends AppBaseController
{
    /* @var DashboardRepository */
    private DashboardRepository $dashboardRepository;

public function __construct(DashboardRepository $dashboardRepo)
    {
        $this->dashboardRepository = $dashboardRepo;
    }

/**
     * @return Application|Factory|View
     */
    public function index(): \Illuminate\View\View
    {
        $activeUsersCount = User::whereHas('roles', function ($q) {
            $q->where('name', '!=', 'super_admin');
        })->where('is_active', 1)->count();

$deActiveUsersCount = User::whereHas('roles', function ($q) {
            $q->where('name', '!=', 'super_admin');
        })->where('is_active', 0)->count();

$enquiry = $this->dashboardRepository->getEnquiryCountAttribute();
        $appointment = $this->dashboardRepository->getAppointmentCountAttribute();

if (\Request::is('sadmin/dashboard')) {
            $activeVcard = Vcard::whereStatus(1)->count();
            $deActiveVcard = Vcard::whereStatus(0)->count();

return view('dashboard.index', compact('activeUsersCount', 'deActiveUsersCount', 'activeVcard', 'deActiveVcard'));
        }

$activeVcard = Vcard::whereTenantId(auth()->user()->tenant_id)->whereStatus(1)->count();
        $deActiveVcard = Vcard::whereTenantId(auth()->user()->tenant_id)->whereStatus(0)->count();
        $totalWpTemplate = WhatsappStore::all()->count();
        $storeIds = WhatsappStore::whereTenantId(auth()->user()->tenant_id)->pluck('id');
        $totalOrder = WpOrder::whereIn('wp_store_id', $storeIds)->count();
        $totalPendingOrder = WpOrder::whereIn('wp_store_id', $storeIds)->where('status', WpOrder::PENDING)->count();

return view('dashboard.index', compact('enquiry', 'appointment', 'activeVcard', 'deActiveVcard', 'totalWpTemplate', 'totalOrder', 'totalPendingOrder'));
    }

public function getUsersList(Request $request): JsonResponse
    {
        $input = $request->all();

$data['users'] = $this->dashboardRepository->usersData($input);

return $this->sendResponse($data, 'Users retrieved successfully.');
    }

public function appointments(): JsonResponse
    {
        $vcardIds = Vcard::toBase()->whereTenantId(getLogInTenantId())->pluck('id')->toArray();

$today = Carbon::now()->format('Y-m-d');

$appointments = ScheduleAppointment::with('vcard')->whereIn('vcard_id', $vcardIds)->whereDate('date',
            $today)->orderBy('created_at', 'DESC')
            ->paginate(5);

return $this->sendResponse($appointments, 'Appointment retrieved successfully.');
    }

public function planChartData(): JsonResponse
    {
        $data = $this->dashboardRepository->planChartData();

return $this->sendResponse($data, 'Plan chart data fetch successfully.');
    }

public function incomeChartData(Request $request): JsonResponse
    {
        $input = $request->all();
        $data = $this->dashboardRepository->incomeChartData($input);

return $this->sendResponse($data, 'Income chart data fetch successfully.');
    }
 }

CANCEL