@php $pastdays = $thirtydays = $thirtytosixty = $sixtytoninty = $greaterninty = $thirtyamt = $thirtysixtyamt = $sixtytonintyamt = $greaternintyamt = $thirtydayAgencyCnt = $thirtysixtyAgencyCnt = $sixtytonintyAgencyCnt = $greaternintyAgencyCnt = $pastamount=$pastAgencycnt= 0; @endphp @php $stateList = []; $duplicateStateList = []; @endphp @if(isset($stateSpecificData)) {{-- @php dd($stateSpecificData); @endphp --}} @foreach($stateSpecificData as $details) @php $pastdays += $details->pastdays ? $details->pastdays : 0; $thirtydays += $details->thirtydays ? $details->thirtydays : 0; $thirtytosixty += $details->thirtytosixty ? $details->thirtytosixty : 0; $sixtytoninty += $details->sixtytoninty ? $details->sixtytoninty : 0; $greaterninty += $details->greaterninty ? $details->greaterninty : 0; $pastamount += $details->pastamount ? $details->pastamount : 0; $thirtyamt += $details->thirtyamt ? $details->thirtyamt : 0; $thirtysixtyamt += $details->thirtysixtyamt ? $details->thirtysixtyamt : 0; $sixtytonintyamt += $details->sixtytonintyamt ? $details->sixtytonintyamt : 0; $greaternintyamt += $details->greaternintyamt ? $details->greaternintyamt : 0; $pastAgencycnt +=$details->pastAgencycnt ? $details->pastAgencycnt : 0; $thirtydayAgencyCnt += $details->thirtydayAgencyCnt ? $details->thirtydayAgencyCnt : 0; $thirtysixtyAgencyCnt += $details->thirtysixtyAgencyCnt ? $details->thirtysixtyAgencyCnt : 0; $sixtytonintyAgencyCnt += $details->sixtytonintyAgencyCnt ? $details->sixtytonintyAgencyCnt : 0; $greaternintyAgencyCnt += $details->greaternintyAgencyCnt ? $details->greaternintyAgencyCnt : 0; @endphp @endforeach @endif
Past days
No Of Agencies {{ $pastAgencycnt }}
No Of Liens {{ $pastdays }}
Amount ${{ $pastamount >= 0 ? number_format($pastamount,2) : 0.00 }}
0-30 days
No Of Agencies {{ $thirtydayAgencyCnt }}
No Of Liens {{ $thirtydays }}
Amount ${{ $thirtyamt >= 0 ? number_format($thirtyamt,2) : 0.00 }}
30-60 days
No Of Agencies {{ $thirtysixtyAgencyCnt }}
No Of Liens {{ $thirtytosixty }}
Amount ${{ $thirtysixtyamt >= 0 ? number_format($thirtysixtyamt,2) : 0.00 }}
60-90 days
No Of Agencies {{ $sixtytonintyAgencyCnt }}
No Of Liens {{ $sixtytoninty }}
Amount ${{ $sixtytonintyamt >= 0 ? number_format($sixtytonintyamt,2) : 0.00 }}
90+ days
No Of Agencies {{ $greaternintyAgencyCnt }}
No Of Liens {{ $greaterninty }}
Amount ${{ $greaternintyamt >= 0 ? number_format($greaternintyamt,2) : 0.00 }}
@if(isset($stateSpecificData)) @php $includedInCService = Null;$twonottwodata = ""; @endphp @foreach($stateSpecificData as $details) @php $stateDetails = explode(',', $details->stateCodes); @endphp @endforeach @endif
State Tax Year Installment C RPT M-Pay Discount Date Prefrd. Date ELD Total W/AMTS Reported Pending % Complete Total $ Action
{{ $details->state_shortcode }} {{ $details->year }} {{ $details->installment }} {{ (isset($details->cservicereportdate) ? date('m/d/Y', strtotime($details->cservicereportdate)) : '') }} {{ (isset($details->balancingreportdate) ? date('m/d/Y', strtotime($details->balancingreportdate)) : '') }} {{ (isset($details->discount_date) ? date('m/d/Y', strtotime($details->discount_date)) : '') }} {{ (isset($details->preferredduedate) ? date('m/d/Y', strtotime($details->preferredduedate)) : '') }} {{ (isset($details->eld_date) ? date('m/d/Y', strtotime($details->eld_date)) : '') }} {{ $details->totalopen }} {{ $details->withamount }} {{ $details->reported }} {{ $details->pending }} {{ ((isset($details->totalopen) && $details->totalopen != 0) ? number_format(($details->withamount * 100 ) / $details->totalopen, 2) : "0") }} ${{ isset($details->totalBaseTax) ? number_format($details->totalBaseTax,2) : '0.00' }} Bulk Upload