AcidDiz

Hi maybe I am late.. You don't need to do that. Those are session cookies and you don't need the users permission, you just need to inform users that without those cookies your application won't work. Take a look here. https://gdpr.eu/cookies/

How do i query to make total count per day based on a name or an id?

With the following query i get count of click on all social anchors per day, but i want to show in the chart also which social anchor has been clicked on that day.

$social_stats= Social::join('social_statistics', 'social_statistics.social_id','socials.id')
                   ->select( array(
                                   'social_statistics.visited_at as visited_at',
                                    DB::raw('count(*) as count'),
                                  )
                           )
                   ->orderBy('visited_at')
                   ->groupBy('visited_at')
                   ->pluck('count','visited_at')
                   ->all();


    $social_bar_chart = new SocialBarChart;


    $visited_at = collect(array_keys($this->social_bar));


    $social_bar_labels = $visited_at->map(function ($date) {
        return Carbon::parse($date)->format('d/m');
    })->toArray();



    $social_bar_chart->labels($social_bar_labels)
           ->dataset('Social Count', 'bar', array_values($this->social_bar))
           ->options([
                        'tooltip' =>['show' => true],
                        'backgroundColor' => '#54a0ff',
                    ]);

Need to render a Chart that shows by day the count of click on different social.

Just add this to you Component Class

protected $paginationTheme = 'bootstrap';

in blade use just {{$your_model->links()}}

Year 2021 still useful. You save me lot of work. <3

To convert to a AM PM string just don't call toTimeString()..

$time = Carbon::now();

$time->format('Y/m/d g:i:s A');

echo gettype($time); //Return string

@aurawindsurfing

Ok i solved with a dedicated Middleware that check if user has activated a specific language, anyway thanks for your reply.

@aurawindsurfing

Hi thank for the reply.

I forgot to say that the application need also to be translated in all those language for the frontend and dashboard utilities. That's why I need some sort of redirection to a main language or a 404 page to avoid that a page been showed if user doesn't compile some languages. I didn't write the full application but I'm adding some functionality, and I saw that the other programmer didn't take care of this aspect. So I'll do it, but I really don't want to rewrite all the application.

Hi is there a way to unset supported locales for one or more routes with a condition?

For Example the application has EN,FR,DE,ES,IT as supported locales, user can write some text in all those language, but who doesn't speak Spanish or Italian doesn't need to compile text fields of those language so he can turn those 2 language off.

I know how to unset from the language selector list in the page, but if i type url in address bar, those 2 urls still exists and of course are empty because the fields in database are NULL.

So how can i redirect from an unsupported locales page to an available supported locales one?

I'm sorry, but i'm little rusty with Laravel, I think I have to create a dedicated middleware to do that and unset those language from there, but i'm not sure. Any tips?