CS {{$data['reportType']}} Dashboard - All India (FY {{$data['financialYear']}}) | |||||||||||
Complaint | Target | @foreach($data['tableHeader'] as $yearMonth){{$yearMonth}} | @endforeach|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Total Complaints Registered | - | @foreach($data['tableHeader'] as $yearMonth){{isset($data['totalComplaintsYearMonthWise'][$yearMonth])?$data['totalComplaintsYearMonthWise'][$yearMonth]:'0'}} | @endforeach|||||||||
Open Complaints | - | @foreach($data['tableHeader'] as $yearMonth){{isset($data['openComplaintsYearMonthWise'][$yearMonth])?$data['openComplaintsYearMonthWise'][$yearMonth]:'0'}} | @endforeach|||||||||
Open Complaints Ageing (in days) | - | @foreach($data['tableHeader'] as $yearMonth){{isset($data['openComplaintsDays'][$yearMonth])?round($data['openComplaintsDays'][$yearMonth]/$data['openComplaintsYearMonthWise'][$yearMonth]):'0'}} | @endforeach|||||||||
Complaint acknowledged within 24 hrs. | 100% | @foreach($data['tableHeader'] as $yearMonth) @if(isset($data['complaintAcknWithinOneDay'][$yearMonth]) && $data['totalComplaintAckn'][$yearMonth] > 0) @php $ackPer = round(($data['complaintAcknWithinOneDay'][$yearMonth]/$data['totalComplaintAckn'][$yearMonth])*100); @endphp @else @php $ackPer = '0'; @endphp @endif @php $class = $ackPer == '0' ? '' : ($ackPer > '89' ? 'green' : ($ackPer > '69' ? 'yellow' : 'red')); @endphp{{ $ackPer }}% | @endforeach|||||||||
Overall Closure within TAT (%) | 90% | @foreach($data['tableHeader'] as $yearMonth) @if(isset($data['totalCloserWithinTat'][$yearMonth]) && isset($data['totalComplaintsYearMonthWise'][$yearMonth])) @php $closerPer = round(($data['totalCloserWithinTat'][$yearMonth]/$data['totalComplaintsYearMonthWise'][$yearMonth])*100); @endphp @else @php $closerPer = '0'; @endphp @endif @php $class = $closerPer == '0' ? '' : ($closerPer > '89' ? 'green' : ($closerPer > '69' ? 'yellow' : 'red')); @endphp{{$closerPer}}% | @endforeach|||||||||
- {{$key}} (%) | 90% | @foreach($data['tableHeader'] as $yearMonth) @if(isset($data['closerWithinTatCatWise'][$key][$yearMonth]) && isset($data['totalComplaintsYearMonthWise'][$yearMonth])) @php $closerPer = round(($data['closerWithinTatCatWise'][$key][$yearMonth]/$data['totalComplaintsYearMonthWise'][$yearMonth])*100); @endphp @else @php $closerPer = '0'; @endphp @endif @php $class = $closerPer == '0' ? '' : ($closerPer > '89' ? 'green' : ($closerPer > '69' ? 'yellow' : 'red')); @endphp{{$closerPer}}% | @endforeach|||||||||
Post Complaint Satisfaction (%) | 75% | @foreach($data['tableHeader'] as $yearMonth) @if(isset($data['overallPcsCompletedYearMonthWise'][$yearMonth])) @php $pcsPer = round(($data['overallPcsCompletedYearMonthWise'][$yearMonth]['score']/$data['overallPcsCompletedYearMonthWise'][$yearMonth]['count'])*10); @endphp @else @php $pcsPer = '0'; @endphp @endif @php $class = $pcsPer == '0' ? '' : ($pcsPer > '89' ? 'green' : ($pcsPer > '69' ? 'yellow' : 'red')); @endphp{{$pcsPer}}% | @endforeach
CS {{$data['reportType']}} Dashboard - {{$region}} (FY {{$data['financialYear']}}) | |||||||||||
Complaint | Target | @foreach($data['tableHeader'] as $yearMonth){{$yearMonth}} | @endforeach|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Total Complaints Registered | - | @foreach($data['tableHeader'] as $yearMonth){{isset($data['regionTotalComplaintsYearMonthWise'][$region][$yearMonth])?$data['regionTotalComplaintsYearMonthWise'][$region][$yearMonth]:'0'}} | @endforeach|||||||||
Open Complaints | - | @foreach($data['tableHeader'] as $yearMonth){{isset($data['regionOpenComplaintsYearMonthWise'][$region][$yearMonth])?$data['regionOpenComplaintsYearMonthWise'][$region][$yearMonth]:'0'}} | @endforeach|||||||||
Open Complaints Ageing (in days) | - | @foreach($data['tableHeader'] as $yearMonth){{isset($data['regionOpenComplaintsDays'][$region][$yearMonth])?round($data['regionOpenComplaintsDays'][$region][$yearMonth]/$data['regionOpenComplaintsYearMonthWise'][$region][$yearMonth]):'0'}} | @endforeach|||||||||
Complaint acknowledged within 24 hrs. | 100% | @php $class = ''; @endphp @foreach($data['tableHeader'] as $yearMonth) @if(isset($data['totalComplaintAcknRegion'][$region][$yearMonth]) && $data['totalComplaintAcknRegion'][$region][$yearMonth] > 0) @php $acknPer = round(($data['regionComplaintAcknWithinOneDay'][$region][$yearMonth]/$data['totalComplaintAcknRegion'][$region][$yearMonth])*100); @endphp @else @php $acknPer = '0'; @endphp @endif @php $class = $acknPer == '0' ? '' : ($acknPer > '89' ? 'green' : ($acknPer > '69' ? 'yellow' : 'red')); @endphp{{$acknPer}}% | @endforeach|||||||||
Overall Closure within TAT (%) | 90% | @foreach($data['tableHeader'] as $yearMonth) @if(isset($data['regionTotalCloserWithinTat'][$region][$yearMonth]) && isset($data['regionTotalComplaintsYearMonthWise'][$region][$yearMonth])) @php $closerPer = round(($data['regionTotalCloserWithinTat'][$region][$yearMonth]/$data['regionTotalComplaintsYearMonthWise'][$region][$yearMonth])*100); @endphp @else @php $closerPer = '0'; @endphp @endif @php $class = $closerPer == '0' ? '' : ($closerPer > '89' ? 'green' : ($closerPer > '69' ? 'yellow' : 'red')); @endphp{{$closerPer}}% | @endforeach|||||||||
- {{$key}} (%) | 90% | @foreach($data['tableHeader'] as $yearMonth) @if(isset($data['regionCloserWithinTatCatWise'][$region][$key][$yearMonth]) && isset($data['regionTotalComplaintsYearMonthWise'][$region][$yearMonth])) @php $closerCatPer = round(($data['regionCloserWithinTatCatWise'][$region][$key][$yearMonth]/$data['regionTotalComplaintsYearMonthWise'][$region][$yearMonth])*100); @endphp @else @php $closerCatPer = '0'; @endphp @endif @php $class = $closerCatPer == '0' ? '' : ($closerCatPer > '89' ? 'green' : ($closerCatPer > '69' ? 'yellow' : 'red')); @endphp{{$closerCatPer}}% | @endforeach|||||||||
Post Complaint Satisfaction (%) | 75% | @foreach($data['tableHeader'] as $yearMonth) @if(isset($data['regionPcsCompletedYearMonthWise'][$region][$yearMonth])) @php $pcsPer = round(($data['regionPcsCompletedYearMonthWise'][$region][$yearMonth]['score']/$data['regionPcsCompletedYearMonthWise'][$region][$yearMonth]['count'])*10); @endphp @else @php $pcsPer = '0'; @endphp @endif @php $class = $pcsPer == '0' ? '' : ($pcsPer > '89' ? 'green' : ($pcsPer > '69' ? 'yellow' : 'red')); @endphp{{$pcsPer}}% | @endforeach
CS {{$data['reportType']}} Dashboard - {{$region}} {{$dealer}} | |||||||||||
Complaint | Target | @foreach($data['tableHeader'] as $yearMonth){{$yearMonth}} | @endforeach|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Total Complaints Registered | - | @foreach($data['tableHeader'] as $yearMonth){{isset($data['totalComplaintsDealerWise'][$region][$dealer][$yearMonth])?$data['totalComplaintsDealerWise'][$region][$dealer][$yearMonth]:'0'}} | @endforeach|||||||||
Open Complaints | - | @foreach($data['tableHeader'] as $yearMonth){{isset($data['openComplaintsDealerhWise'][$region][$dealer][$yearMonth])?$data['openComplaintsDealerhWise'][$region][$dealer][$yearMonth]:'0'}} | @endforeach|||||||||
Open Complaints Ageing (in days) | - | @foreach($data['tableHeader'] as $yearMonth){{isset($data['openComplaintsDays'][$region][$dealer][$yearMonth])?round($data['openComplaintsDealerDays'][$region][$dealer][$yearMonth]/$data['openComplaintsDealerhWise'][$region][$dealer][$yearMonth]):'0'}} | @endforeach|||||||||
Complaint acknowledged within 24 hrs. | 100% | @foreach($data['tableHeader'] as $yearMonth) @if(isset($data['complaintAcknWithinOneDayDealerWise'][$region][$dealer][$yearMonth]) && $data['totalComplaintAcknDealerWise'][$region][$dealer][$yearMonth] > 0) @php $ackPer = round(($data['complaintAcknWithinOneDayDealerWise'][$region][$dealer][$yearMonth]/$data['totalComplaintAcknDealerWise'][$region][$dealer][$yearMonth])*100); @endphp @else @php $ackPer = '0'; @endphp @endif @php $class = $ackPer == '0' ? '' : ($ackPer > '89' ? 'green' : ($ackPer > '69' ? 'yellow' : 'red')); @endphp{{ $ackPer }}% | @endforeach|||||||||
Overall Closure within TAT (%) | 90% | @foreach($data['tableHeader'] as $yearMonth) @if(isset($data['totalCloserWithinTatDealerWise'][$region][$dealer][$yearMonth]) && isset($data['totalComplaintsDealerWise'][$region][$dealer][$yearMonth])) @php $closerPer = round(($data['totalCloserWithinTatDealerWise'][$region][$dealer][$yearMonth]/$data['totalComplaintsDealerWise'][$region][$dealer][$yearMonth])*100); @endphp @else @php $closerPer = '0'; @endphp @endif @php $class = $closerPer == '0' ? '' : ($closerPer > '89' ? 'green' : ($closerPer > '69' ? 'yellow' : 'red')); @endphp{{$closerPer}}% | @endforeach|||||||||
- {{$key}} (%) | 90% | @foreach($data['tableHeader'] as $yearMonth) @if(isset($data['closerWithinTatCatDealerWise'][$region][$dealer][$key][$yearMonth]) && isset($data['totalComplaintsDealerWise'][$yearMonth])) @php $closerPer = round(($data['closerWithinTatCatDealerWise'][$region][$dealer][$key][$yearMonth]/$data['totalComplaintsDealerWise'][$yearMonth])*100); @endphp @else @php $closerPer = '0'; @endphp @endif @php $class = $closerPer == '0' ? '' : ($closerPer > '89' ? 'green' : ($closerPer > '69' ? 'yellow' : 'red')); @endphp{{$closerPer}}% | @endforeach|||||||||
Post Complaint Satisfaction (%) | 75% | @foreach($data['tableHeader'] as $yearMonth) @if(isset($data['overallPcsCompletedDealerWise'][$region][$dealer][$yearMonth])) @php $pcsPer = round(($data['overallPcsCompletedDealerWise'][$region][$dealer][$yearMonth]['score']/$data['overallPcsCompletedDealerWise'][$region][$dealer][$yearMonth]['count'])*10); @endphp @else @php $pcsPer = '0'; @endphp @endif @php $class = $pcsPer == '0' ? '' : ($pcsPer > '89' ? 'green' : ($pcsPer > '69' ? 'yellow' : 'red')); @endphp{{$pcsPer}}% | @endforeach
CS {{$data['reportType']}} Dashboard - {{$region}} Dealer Performance ({{$data['selectedMonth']}}) | |||||||||||
Complaint | Target | @if(isset($data['dealerTotalComplaints'][$region])) @foreach($data['dealerTotalComplaints'][$region] as $dealer => $dealerRegionData){{$dealer}} | @endforeach @endif|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Total Complaints Registered | - | @if(isset($data['dealerTotalComplaints'][$region])) @foreach($data['dealerTotalComplaints'][$region] as $dealer => $dealerRegionData){{isset($dealerRegionData)?$dealerRegionData:'0'}} | @endforeach @endif|||||||||
Open Complaints | - | @if(isset($data['dealerOpenComplaints'][$region])) @foreach($data['dealerOpenComplaints'][$region] as $complaints){{isset($complaints)?$complaints:'0'}} | @endforeach @endif|||||||||
Open Complaints Ageing (in days) | - | @if(isset($data['dealerOpenComplaintsDays'][$region])) @foreach($data['dealerOpenComplaintsDays'][$region] as $key => $value){{isset($value)?round($value/$data['dealerOpenComplaints'][$region][$key]):'0'}} | @endforeach @endif|||||||||
Complaint acknowledged within 24 hrs. | 100% | @if(isset($data['dealerComplaintAcknWithinOneDay'][$region]) && $data['dealerTotalComplaintAckn'][$region][$dealer] > 0) @foreach($data['dealerComplaintAcknWithinOneDay'][$region] as $dealer => $ackComplaint) @if(isset($data['dealerTotalComplaintAckn'][$region][$dealer])) @php $acknPerDealer = round(($ackComplaint/$data['dealerTotalComplaintAckn'][$region][$dealer])*100); @endphp @else @php $acknPerDealer = '0'; @endphp @endif @if($acknPerDealer > '89') @php $class = 'green'; @endphp @elseif($acknPerDealer > '69') @php $class = 'yellow'; @endphp @elseif($acknPerDealer <= '69' && $acknPerDealer >= '0') @php $class = 'red'; @endphp @else @php $class = ''; @endphp @endif{{$acknPerDealer}}% | @endforeach @else0% | @endif||||||||
Overall Closure within TAT (%) | 90% | @if(isset($data['dealerTotalCloserWithinTat'][$region])) @foreach($data['dealerTotalCloserWithinTat'][$region] as $dealer => $value) @php $clsrPer = round(($value/$data['dealerTotalComplaints'][$region][$dealer])*100); $class = $clsrPer == '0' ? '' : ($clsrPer > '89' ? 'green' : ($clsrPer > '69' ? 'yellow' : 'red')); @endphp{{$clsrPer}}% | @endforeach @endif|||||||||
- {{$category}} (%) | 90% | @foreach($data['dealerTotalComplaints'][$region] as $dealer => $dedata) @if(isset($dealerData[$dealer])) @php $closerCatPer = round(($dedata/$data['dealerTotalComplaints'][$region][$dealer])*100); @endphp @else @php $closerCatPer = '0'; @endphp @endif @php $class = $closerCatPer == '0' ? '' : ($closerCatPer > '89' ? 'green' : ($closerCatPer > '69' ? 'yellow' : 'red')); @endphp{{$closerCatPer}}% | @endforeach|||||||||
Post Complaint Satisfaction (%) | 75% | @if(isset($data['dealerPcsCompleted'][$region])) @foreach($data['dealerPcsCompleted'][$region] as $dealer => $pcsComplaints) @if(isset($pcsComplaints['score']) && $pcsComplaints['count'] > 0) @php $pcsPerDealer = round(($pcsComplaints['score']/$pcsComplaints['count'])*10); @endphp @else @php $pcsPerDealer = '0'; @endphp @endif @php $class = $pcsPerDealer == '0' ? '' : ($pcsPerDealer > '89' ? 'green' : ($pcsPerDealer > '69' ? 'yellow' : 'red')); @endphp{{$pcsPerDealer}}% | @endforeach @endif