Dashboard stats for current day

Bobelism

/app/Http/Controllers/AdminController.php

public function dashboard(Request $request)
    {
        //Added today dates
        $displayUsersToday = User::where('created_at', Carbon::now())->get()->count();

        $displayRestaurantsToday = Restaurant::where('created_at', Carbon::now())->get()->count();
    
        $displaySalesToday = Order::where('orderstatus_id', 5)->get();
        
        $displaySalesToday = Order::whereDate('created_at', Carbon::now())->get()->count();
        
        $displayEarningsToday = Order::whereDate('created_at', Carbon::now())->get();
        
        $total = 0;
        foreach ($displayEarningsToday as $de) {
            $total += $de->total;
        }
        $displayEarningsToday = $total;
        // End today dates

return view('admin.dashboard', array(
            'displayUsers' => $displayUsers,
            'displayRestaurants' => $displayRestaurants,
            'displaySales' => $displaySales,
            'displayEarnings' => number_format((float) $displayEarnings, 2, '.', ''),
            'orders' => $orders,
            'users' => $users,
            'todaysDate' => $todaysDate,
            'orderStatusesName' => $orderStatusesName,
            'orderStatusesData' => $orderStatusesData,
            'ifAnyOrders' => $ifAnyOrders,
            'displayUsersToday' => $displayUsersToday,
            'displayRestaurantsToday' => $displayRestaurantsToday,
            'displaySalesToday' => $displaySalesToday,
            'displayEarningsToday' => number_format((float) $displayEarningsToday, 2, '.', ''),
        ));
    }

/resources/views/admin/dashboard.blade.php

<div class="row mt-4" style="margin-top: -5px !important;">
        <div class="col-6 col-xl-3 mb-2 mt-2">
            <div class="col-xl-12 dashboard-display p-3" style="background-color: #1c1c1c !important;">
                <a class="block block-link-shadow text-left text-default" href="javascript:void(0)">
                    <div class="block-content block-content-full clearfix">
                        <div class="float-right mt-10 d-none d-sm-block">
                            <i class="dashboard-display-icon icon-basket" style="color: rgb(241, 216, 15) !important;"></i>
                        </div>
                        <div class="dashboard-display-number"  style="color: #fff !important;">{{ $displaySalesToday }}</div>
                        <div class="font-size-sm text-uppercase text-muted">Today Orders</div>
                    </div>
                </a>
            </div>
        </div>
        <div class="col-6 col-xl-3 mb-2 mt-2">
            <div class="col-xl-12 dashboard-display p-3" style="background-color: #1c1c1c !important;">
                <a class="block block-link-shadow text-left text-default" href="javascript:void(0)">
                    <div class="block-content block-content-full clearfix">
                        <div class="float-right mt-10 d-none d-sm-block">
                            <i class="dashboard-display-icon icon-users4" style="color: rgb(241, 216, 15) !important;"></i>
                        </div>
                        <div class="dashboard-display-number" style="color: #fff !important;">{{ $displayUsersToday }}</div>
                        <div class="font-size-sm text-uppercase text-muted">Today Users</div>
                    </div>
                </a>
            </div>
        </div>
        <div class="col-6 col-xl-3 mb-2 mt-2">
            <div class="col-xl-12 dashboard-display p-3" style="background-color: #1c1c1c !important;">
                <a class="block block-link-shadow text-left text-default" href="javascript:void(0)">
                    <div class="block-content block-content-full clearfix">
                        <div class="float-right mt-10 d-none d-sm-block">
                            <i class="dashboard-display-icon icon-store2" style="color: rgb(241, 216, 15) !important;"></i>
                        </div>
                        <div class="dashboard-display-number" style="color: #fff !important;">{{ $displayRestaurantsToday }}</div>
                        <div class="font-size-sm text-uppercase text-muted">Today Stores</div>
                    </div>
                </a>
            </div>
        </div>
        <div class="col-6 col-xl-3 mb-2 mt-2">
            <div class="col-xl-12 dashboard-display p-3" style="background-color: #1c1c1c !important;">
                <a class="block block-link-shadow text-left text-default" href="javascript:void(0)">
                    <div class="block-content block-content-full clearfix">
                        <div class="float-right mt-10 d-none d-sm-block" style="color: rgb(241, 216, 15) !important;">
                            <i class="dashboard-display-icon icon-coin-dollar" style="color: rgb(241, 216, 15) !important;"></i>
                        </div>
                        <div class="dashboard-display-number" style="color: #fff !important;">{{ config('appSettings.currencyFormat') }} {{ $displayEarningsToday }}</div>
                        <div class="font-size-sm text-uppercase text-muted">Today Earnings</div>
                    </div>
                </a>
            </div>
        </div>
    </div>

This customization was made with the help of @Mashwishi , thank you!

bbamaska

Bobelism can you tell me where to put thats code after what code? or how to input?
thank you bro

mounika

Bobelism Found bugs in this code

With out completing orders, it is counting as orders ( after cancelling, it is not changing )
Amount also not reflecting.

For Ex:
If an item of Rs.260 is ordered by an user, before completing the order, it is counting to Today Orders and also in Today Earnings.
If user cancelled the ordered. It is not reflecting.

May be you missed it. check once please

Djaniel

Bobelism The default restauraunt dashboard is so messy and hard to read and understand. Have you got any solution for it or for zen mode. 😄

KalLach

Bobelism hello how to add not for the day but by month

Bobelism

bbamaska

You can get an idea if you search for the first line of each code.
For example, look for public function dashboard(Request $request) in AdminController.php and replace it with the rest of the code up to line // End today dates

You can also search for return view('admin.dashboard', array( and replace everything until the bracket }

In dashboard.blade.php You can add the whole code which is almost the same as the old one, but it's just duplicated with new variable names.
Experiment with it a bit and you will figure out 🙂

SebastianCamia

Well well well.. cheers to the f*ing people like you that shares their hard work with us, god bless you all (or whatver deity you might want to chose!)

THANK YOU!

bbamaska

Bobelism i got error when trying to replace on dashboard.blade.php . can you share your dashboard.blade.php please.

Bobelism

bbamaska Please paste a screenshot with debugging mode on and with the error screen.

ventis

The script works fine bro !!!!! Awesome !!!!

Bobelism

mounika Thank you for reporting.
Im not a php developer so i did it the best as i could. Maybe someone can help us fix this 🙂

bbamaska Unfortunately i cannot offer you my files because those are havely modified. But you can find me on Discord unofficial community with my name Bobelism #8503 and I can try to help you 🙂

tapasfun

Fixed the issue here: https://discuss.foodomaa.com/d/908-add-today-stats-on-admin-dashboard-solved

Hope this helps!

Djaniel

505 server error :/

Djaniel

Nevermind it worked! Thanks!

bbamaska

Djaniel Can i get ur AdminController.php and dashboard.blade.php because i always error

mounika

Bobelism It's ok buddy, but it was too good.
I will try to solve these bugs and will inform you 🙂

Hamza

@Bobelism can you please tell me how to add separate reports button in admin panel

Bobelism

Update:
/app/Http/Controllers/AdminController.php
replace those two lines. Now it works for users and stores counter.

$displayUsersToday = User::whereDate('created_at', Carbon::now())->get()->count();

$displayRestaurantsToday = Restaurant::whereDate('created_at', Carbon::now())->get()->count();

mounika

Bobelism

Any solution for the bugs, that I mentioned ?
I tried, but failed

mounika

Bobelism Can you please tell me what does this 2 codes does.

whereDate, what does this command exactly do ?

What's the diff between previous one and this one ?

Bobelism

mounika I haven't managed to find any solutions :/

Mohit

get error, if you share your 2 files that will good

paulfos

error also,

TalhaSaeed

@Bobelism can you please help us to make an alarm sound or beep sound when the app is close for the vendor it will be very useful feature for us

Bobelism

It would help posting an image with the error so i can help you fix it...

TalhaSaeed please be more specific.

Djaniel what do you mean is messy?

Hurry up! Limited time offer