@extends('layouts.app') @section('content')

{{\App\BusinessBranch::count()}}

الفروع

{{\App\BusinessAdministration::count()}}

الأدارات

{{\App\BusinessDepartment::count()}}

الأقسام

{{\App\BusinessJob::count()}}

الوظائف

{{trans('nav.employees')}}

{{__('general.total_employees')}}

{{App\EmployeeGeneralData::count()}}

{{__('general.in_work_employees')}}

{{App\EmployeeGeneralData::where('statue','active')->count()}}

{{trans('general.resignation') .' '. App\EmployeeGeneralData::where('statue','resignation')->count()}} {{trans('general.inactive') .' '. App\EmployeeGeneralData::where('statue','inactive')->count()}}
@foreach(DB::table('business_branches')->get() as $branch)

{{$branch->name}} {{App\EmployeeGeneralData::where('branch_id',$branch->id)->count()}} {{App\EmployeeGeneralData::where('branch_id',$branch->id)->where('statue','active')->count()}}

@endforeach
{{App\EmployeeGeneralData::where('statue','active')->count()}}

{{App\EmployeeGeneralData::where('statue','active')->where('contract_ending_date','<',date('d'))->count() > 0 ? '+'.App\EmployeeGeneralData::where('contract_ending_date','<',date('d'))->count(): App\EmployeeGeneralData::where('contract_ending_date','<',date('d'))->count()}}

{{trans('general.contract_ended')}} {{App\EmployeeGeneralData::where('statue','active')->count()}}


{{App\EmployeeGeneralData::where('statue','active')->where('residency_expiry_date','<',date('d'))->count() > 0 ? '+'.App\EmployeeGeneralData::where('residency_expiry_date','<',date('d'))->count(): App\EmployeeGeneralData::where('contract_ending_date','<',date('d'))->count()}}

{{trans('general.resident_ended')}} {{App\EmployeeGeneralData::where('statue','active')->count()}}


{{App\EmployeeGeneralData::where('statue','active')->where('passport_expiry_date','<',date('d'))->count() > 0 ? '+'.App\EmployeeGeneralData::where('passport_expiry_date','<',date('d'))->count(): App\EmployeeGeneralData::where('contract_ending_date','<',date('d'))->count()}}

{{trans('general.passport_ended')}} {{App\EmployeeGeneralData::where('statue','active')->count()}}

الحضور اليوم0

@endsection