@php use App\Extensions\SocialMedia\System\Models\SocialMediaPost; use Illuminate\Support\Carbon; use App\Extensions\SocialMedia\System\Enums\StatusEnum; $startDate = Carbon::now()->subDays(30); $endDate = Carbon::now(); $query = SocialMediaPost::query() ->where('user_id', auth()->id()) ->selectRaw( "COUNT(*) as all_posts, SUM(CASE WHEN status = 'published' THEN 1 ELSE 0 END) as published_posts, SUM(CASE WHEN status = 'scheduled' THEN 1 ELSE 0 END) as scheduled_posts, SUM(CASE WHEN status = 'failed' THEN 1 ELSE 0 END) as failed_posts", ) ->whereBetween('scheduled_at', [$startDate, $endDate]) ->first(); $posts = [ 'all_posts' => $query->all_posts ?? 0, 'published_posts' => $query->published_posts ?? 0, 'scheduled_posts' => $query->scheduled_posts ?? 0, 'failed_posts' => $query->failed_posts ?? 0, ]; $posts_stats = [ 'last_30_days' => $posts, ]; @endphp

@lang('Overview')

{{ __('View All') }}

@lang('All Posts')

@lang('Published Posts')

@lang('Scheduled Posts')

@lang('Failed Posts')

@lang('Social Media Posts')

{{ __('View All') }}
@forelse (SocialMediaPost::query()->where('user_id', auth()->id())->take(4)->get() as $post)
{!! getSocialMediaIcon($post?->getPlatformEnum()?->value) !!}
@if (isset($post['image']))
@lang('Social Media Post')
@endif @if (isset($post['content']))

{{ str()->words($post['content'], isset($post['image']) ? 11 : 23) }}

@endif
$post['status'] === \App\Extensions\SocialMedia\System\Enums\StatusEnum::published, 'text-foreground' => $post['status'] === \App\Extensions\SocialMedia\System\Enums\StatusEnum::scheduled, ])> @if ($post['status'] === \App\Extensions\SocialMedia\System\Enums\StatusEnum::published) @elseif ($post['status'] === \App\Extensions\SocialMedia\System\Enums\StatusEnum::scheduled) @else @endif {{ str()->title($post['status']->value) }}
@empty

@lang('No posts have been added yet.')

@endforelse