@php($last15Days=\App\Models\CompaniesUser::where(['company_id'=>$company->id,'type'=>'member'])->whereBetween('created_at', [$start,$end] )->count()) @if($is15Days) @php($beforeLast15Days=\App\Models\CompaniesUser::where(['company_id'=>$company->id,'type'=>'member'])->whereBetween('created_at', [\Carbon\Carbon::now()->subDays(30),\Carbon\Carbon::now()->subDays(15)])->count()) @php($number=$beforeLast15Days>0?(($last15Days-$beforeLast15Days)/$beforeLast15Days)*100:($last15Days>0?100:0)) @endif

{{ $last15Days }}

{{ \App\Models\CompaniesUsersCourse::where(['company_id'=>$company->id])->whereBetween('created_at',[$start,$end])->count() }}

@php($last15Days=\App\Models\CompaniesUser::where(['company_id'=>$company->id,'type'=>'member'])->whereBetween('created_at',[$start,$end])->avg("courses_percentage")) @if($is15Days) @php($beforeLast15Days=\App\Models\CompaniesUser::where(['company_id'=>$company->id,'type'=>'member'])->whereBetween('created_at', [\Carbon\Carbon::now()->subDays(30),\Carbon\Carbon::now()->subDays(15)])->avg("courses_percentage")) @php($number=$beforeLast15Days>0?(($last15Days-$beforeLast15Days)/$beforeLast15Days)*100:($last15Days>0?100:0)) @endif

{{ $last15Days }}%

@php($last15Days=\App\Models\CoursesCurriculumCertificate::whereRaw("user_id IN (SELECT user_id FROM companies_users WHERE type=? AND company_id=? AND deleted_at IS NULL)",['member',$company->id])->whereBetween('createdtime', [$start,$end])->count()) @if($is15Days) @php($beforeLast15Days=\App\Models\CoursesCurriculumCertificate::whereRaw("user_id IN (SELECT user_id FROM companies_users WHERE type=? AND company_id=? AND deleted_at IS NULL)",['member',$company->id])->whereBetween('createdtime', [\Carbon\Carbon::now()->subDays(30),\Carbon\Carbon::now()->subDays(15)])->count()) @php($number=$beforeLast15Days>0?(($last15Days-$beforeLast15Days)/$beforeLast15Days)*100:($last15Days>0?100:0)) @endif

{{ $last15Days }}

@php($last15Days=\App\Models\UsersCoursesVideo::whereRaw("user_id IN (SELECT user_id FROM companies_users WHERE type=? AND company_id=? AND deleted_at IS NULL)",['member',$company->id])->whereBetween('created_date', [$start,$end])->sum('max_time')) @if($is15Days) @php($beforeLast15Days=\App\Models\UsersCoursesVideo::whereRaw("user_id IN (SELECT user_id FROM companies_users WHERE type=? AND company_id=? AND deleted_at IS NULL)",['member',$company->id])->whereBetween('created_date', [\Carbon\Carbon::now()->subDays(30),\Carbon\Carbon::now()->subDays(15)])->sum('max_time')) @php($number=$beforeLast15Days>0?(($last15Days-$beforeLast15Days)/$beforeLast15Days)*100:($last15Days>0?100:0)) @endif

{{ $last15Days }}

@php($currentProgress = \App\Models\CompaniesUsersCoursesDailyProgress::whereRaw("user_id IN(SELECT user_id FROM companies_users WHERE type=? AND company_id=? AND deleted_at IS NULL)", ['member', $company->id])->whereBetween('created_at', [$start,$end])->max('progress')) @php($previousProgress = \App\Models\CompaniesUsersCoursesDailyProgress::whereRaw("user_id IN(SELECT user_id FROM companies_users WHERE type=? AND company_id=? AND deleted_at IS NULL)", ['member', $company->id])->where('created_at', '<', $start)->max('progress')) {{ max(0, $currentProgress - $previousProgress) }}%