Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/job-board.corals.io/Corals/modules/Reservation/Widgets/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php


namespace Corals\Modules\Reservation\Widgets;

use \Corals\Modules\Reservation\Charts\DailyReservations;
use Corals\Modules\Reservation\Models\Reservation;

class DailyReservationsWidget
{

    function run($args)
    {

        $data = Reservation::query()
            ->selectRaw(
                "count(res_reservations.id) as count, DATE_FORMAT(res_reservations.created_at,'%M %D') as days"
            )->groupBy('status', 'days')
            ->whereBetween('res_reservations.created_at', [today()->subDays(10), today()->addDay()])
            ->orderByRaw("DATE_FORMAT(res_reservations.created_at,'%m'), DATE_FORMAT(res_reservations.created_at,'%d')")
            ->pluck('count', 'days')
            ->toArray();


        $chart = new DailyReservations();


        $chart->labels(array_keys($data));

        $chart->dataset(trans('Reservation::labels.widget.daily_number_of_reservations'), 'line', array_values($data));

        $chart->options([
            'fill' => false,
            'plugins' => '{
                    colorschemes: {
                        scheme: \'brewer.Paired12\'
                    }
                }'
        ]);


        return view('Corals::chart')->with(['chart' => $chart])->render();


    }
}