{{$communityInfo->cust_name}}

{{$communityInfo->contact_address}}
E-mail: {{$communityInfo->email}}
Phone: {{$communityInfo->phone}}, GST: {{$communityInfo->gst_no}}

MIS report

Period: {{date('d M Y',strtotime($from))}} - {{date('d M Y',strtotime($to))}} at {{date('d M Y H:i:s')}}

Resident Leaves

Total: {{$leave_summary_data['total_requests']}} Residents: {{$leave_summary_data['residents']}}

Guardian
  {{$leave_summary_data['guardian_approved']}} @if($leave_summary_data['guardian_approved']>0 && $leave_summary_data['total_requests']>0) ({{round(($leave_summary_data['guardian_approved']*100/$leave_summary_data['total_requests']),2)}}%) @endif         {{$leave_summary_data['guardian_cancelled']}} @if($leave_summary_data['guardian_cancelled']>0 && $leave_summary_data['total_requests']>0) ({{round(($leave_summary_data['guardian_cancelled']*100/$leave_summary_data['total_requests']),2)}}%) @endif

Response time
Avg : {{floor(($leave_summary_data['guardian_avg_time'] / 60))}} Min Max : {{floor(($leave_summary_data['guardian_max_time'] / 60))}} Min Fastest: @if($leave_summary_data['guardian_min_time']==0 ) few Seconds @else {{$leave_summary_data['guardian_min_time'] }} Min @endif

Warden
  {{$leave_summary_data['warden_approved']}} @if($leave_summary_data['warden_approved']>0 && $leave_summary_data['total_requests']>0) ({{round(($leave_summary_data['warden_approved']*100/$leave_summary_data['total_requests']),2)}}%) @endif        {{$leave_summary_data['warden_cancelled']}} @if($leave_summary_data['warden_cancelled']>0 && $leave_summary_data['total_requests']>0) ({{round(($leave_summary_data['warden_cancelled']*100/$leave_summary_data['total_requests']),2)}}%) @endif

Response time
Avg : {{floor(($leave_summary_data['warden_avg_time'] / 60))}} Min Max : {{floor(($leave_summary_data['warden_max_time'] / 60))}} Min Fastest: {{floor(($leave_summary_data['warden_min_time'] / 60))}} Min

No Action: {{$leave_summary_data['leave_no_action']}} @if($leave_summary_data['leave_no_action']>0 && $leave_summary_data['total_requests']>0) ({{round(($leave_summary_data['leave_no_action']*100/$leave_summary_data['total_requests']),2)}}%) @endif Urgent: {{$leave_summary_data['urgent']}} @if($leave_summary_data['urgent']>0 && $leave_summary_data['total_requests']>0) ({{round(($leave_summary_data['urgent']*100/$leave_summary_data['total_requests']),2)}}%) @endif

Top 5 residents applying leaves

@foreach($leave_summary_data['resident_max_leave_count'] as $resident) @endforeach
Name Building Residence No of leave request
{{ucfirst($resident->resident_name)}} {{$resident->building_name}} {{$resident->apartment_name}} {{$resident->leave_request_count}}

Top 10 residents leave days

@foreach($leave_summary_data['resident_max_leave_days'] as $resident) @endforeach
Name Building Residence Total leave days
{{ucfirst($resident->resident_name)}} {{$resident->building_name}} {{$resident->apartment_name}} {{$resident->leave_days_count}}

Month wise leave reports

@foreach ($leaves_monthly->chunk(2) as $chunk) @foreach ($chunk as $key=>$monthly) @endforeach @endforeach

{{$key}}

Total {{$monthly['Total']}} requests by {{$monthly['residents']}} Residents

Urgent {{$monthly['urgent']}} @if($monthly['urgent']>0 && $monthly['Total']>0) ({{round(($monthly['urgent']*100/$monthly['Total']),2)}}%) @endif

Guardian Approved {{$monthly['guardian_approved']}} @if($monthly['guardian_approved']>0 && $monthly['Total']>0) ({{round(($monthly['guardian_approved']*100/$monthly['Total']),2)}}%) @endif

Warden Approved {{$monthly['warden_approved']}} @if($monthly['warden_approved']>0 && $monthly['Total']>0) ({{round(($monthly['warden_approved']*100/$monthly['Total']),2)}}%) @endif

No action {{$monthly['leave_no_action']}} @if($monthly['leave_no_action']>0 && $monthly['Total']>0) ({{round(($monthly['leave_no_action']*100/$monthly['Total']),2)}}%) @endif

Guardian Response Time

Avg: {{floor(($monthly['guardian_avg_time'] / 60))}} Min, Best:{{floor(($monthly['guardian_min_time'] / 60))}} Min Max: {{floor(($monthly['guardian_max_time'] / 60))}} Min

Warden Response Time

Avg: {{floor(($monthly['warden_avg_time'] / 60))}} Min, Best:{{floor(($monthly['warden_min_time'] / 60))}} Min Max: {{floor(($monthly['warden_max_time'] / 60))}} Min

Resident complaints

Total: {{$complaintsStatusCounts['total_complaints']}}

Accepted: {{$complaintsStatusCounts['accepted_complaints']}}

Rejected: {{$complaintsStatusCounts['rejected_complaints']}} @if($complaintsStatusCounts['accepted_complaints']>0) ({{round(($complaintsStatusCounts['rejected_complaints']*100/$complaintsStatusCounts['total_complaints']),2)}}%) @endif

Pending: {{$complaintsStatusCounts['pending_complaints']}} + Reopen: {{$complaintsStatusCounts['reopen_complaints']}}

Success rate: {{$complaintsStatusCounts['success_rate']}}%
@foreach ($complains_monthly as $key=>$monthly)

{{$key}}

- By status:
@foreach($monthly['grouped_count'] as $status=>$count) {{$status}}: {{$count}} | @endforeach
- By Priority:
@foreach($monthly['priority_count'] as $priority=>$count) {{$priority}}: {{$count}} | @endforeach
- By Department:
@foreach($monthly['department_count'] as $department=>$count) {{$department}}; {{$count}} | @endforeach
- By Subject:
@foreach($monthly['subject_count'] as $subject=>$count) {{$subject}}; {{$count}} | @endforeach

- Top 5 residents applying complaints:
@foreach($monthly['resident_max_complaints_count'] as $resident) @endforeach
Name Building Residence Total complaints
{{ucfirst($resident->resident_name)}} {{$resident->building_name}} {{$resident->apartment_name}} {{$resident->complaint_count}}
@endforeach

Feature usage

@foreach ($months_array as $key=>$month) @endforeach @foreach ($resident_monthly as $key=>$monthly) @endforeach @foreach ($notices_monthly as $key=>$monthly) @endforeach @foreach ($emergencies_monthly as $key=>$monthly) @endforeach @foreach ($enquiry_monthly as $key=>$monthly) @php $join_percentage=0; if($monthly['Total']>0){ $join_percentage=($monthly['joined']*100)/$monthly['Total']; } @endphp @endforeach @php $join_percentage=0; if($enquiry_summary['total']>0){ $join_percentage=($enquiry_summary['joined']*100)/$enquiry_summary['total']; } @endphp @foreach ($late_entry_request_monthly as $key=>$monthly) @endforeach
Month{{$month['month']}}Net
Residents

{{$monthly['New']}} @if($monthly['Left']>0) {{$monthly['Left']}} @endif

Total={{$monthly['Total']}}

Notices + {{$monthly['Total']}} | {{$monthly['urgent']}} Total {{$notices_summary['total']}}
Urgent {{$notices_summary['urgent']}}
Emergency {{$monthly['Total']}}Total {{$emergencies_summary['total']}}
Enquiries

New: {{$monthly['Total']}}

Joined: {{$monthly['joined']}}

{{round($join_percentage,1)}}%

Total: {{$enquiry_summary['total']}}

Joined: {{$enquiry_summary['joined']}}

{{round($join_percentage,1)}}%
Late entry request
= No Action

{{$monthly['Total']}}

@if($monthly['approved']>0) {{$monthly['approved']}} @endif @if($monthly['cancelled']>0)    {{$monthly['cancelled']}} @endif @if($monthly['no_action']>0)    {{$monthly['no_action']}} @endif 		Total {{$late_entry_summary['total']}}
@if($late_entry_summary['approved']>0) {{$late_entry_summary['approved']}} @endif @if($late_entry_summary['cancelled']>0)    {{$late_entry_summary['cancelled']}} @endif @if($late_entry_summary['no_action']>0)    {{$late_entry_summary['no_action']}} @endif

For any discrepency, report to support@fretbox.in

This is system generated receipt at FretBox & does not require physical signature.