@php $rowCounter = 4; @endphp @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; $counter = 4; @endphp @foreach($courts as $court) @php $rowCounter++; $counter++; @endphp @php $rowCounter++; $counter++; @endphp @php $rowCounter++; $counter++; @endphp @php $rowCounter++; $counter++; @endphp @endforeach @php $totalActiveProbationCases = $rowCounter; $rowCounter++; $counter++; $subcounter = 'a'; @endphp @foreach($courts as $court) @php $rowCounter++; $subcounter++; @endphp @endforeach @php $totalWarrantsProbationCases = $rowCounter; $rowCounter++; $counter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $counter = 1; $rowCounter++; $paymentTypeTotalsArray = []; @endphp @foreach($paymentTypeGroups as $paymentTypeGroup) @php $paymentTypeTotalStartRow = $rowCounter; @endphp @if(isset($queries['destinationQueries']['paymentsQuery'][$paymentTypeGroup->getKey()])) @foreach($paymentDestinations as $paymentDestination) @if(isset($queries['destinationQueries']['paymentsQuery'][$paymentTypeGroup->getKey()][$paymentDestination->getKey()])) @foreach($queries['destinationQueries']['paymentsQuery'][$paymentTypeGroup->getKey()][$paymentDestination->getKey()] as $payment) @php $counter++; $rowCounter++; @endphp @endforeach @else @php $counter++; $rowCounter++; @endphp @endif @endforeach @php $paymentTypeTotalEndRow = $rowCounter-1; $paymentTypeTotalsArray[] = 'G' . $rowCounter; @endphp @php $counter++; $rowCounter++; @endphp @else @foreach($paymentDestinations as $paymentDestination) @php $counter++; $rowCounter++; @endphp @endforeach @php $counter++; $rowCounter++; @endphp @endif @endforeach @php $counter++; $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; @endphp @foreach($courts as $court) @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; $counter = 1; @endphp @if(isset($queries['destinationQueries']['activeThisMonthQuery'][$court->getKey()])) @foreach($queries['destinationQueries']['activeThisMonthQuery'][$court->getKey()] as $data) @php $rowCounter++; $counter++; @endphp @endforeach @else @php $rowCounter++; $counter++; @endphp @endif @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; $counter = 1; @endphp @if(isset($queries['destinationQueries']['dischargedThisMonthQuery'][$court->getKey()])) @foreach($queries['destinationQueries']['dischargedThisMonthQuery'][$court->getKey()] as $data) @php $rowCounter++; $counter++; @endphp @endforeach @else @php $rowCounter++; $counter++; @endphp @endif @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; $counter = 1; @endphp @if(isset($queries['destinationQueries']['revokedThisMonthQuery'][$court->getKey()])) @foreach($queries['destinationQueries']['revokedThisMonthQuery'][$court->getKey()] as $data) @php $rowCounter++; $counter++; @endphp @endforeach @else @php $rowCounter++; $counter++; @endphp @endif @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; $counter = 1; @endphp @if(isset($queries['destinationQueries']['warrantsThisMonthQuery'][$court->getKey()])) @foreach($queries['destinationQueries']['warrantsThisMonthQuery'][$court->getKey()] as $data) @php $rowCounter++; $counter++; @endphp @endforeach @else @php $rowCounter++; $counter++; @endphp @endif @php $rowCounter++; @endphp @endforeach @foreach($courts as $court) @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; $counter = 1; @endphp @if(isset($queries['destinationQueries']['activeQuery'][$court->getKey()])) @foreach($queries['destinationQueries']['activeQuery'][$court->getKey()] as $data) @php $rowCounter++; $counter++; @endphp @endforeach @else @php $rowCounter++; $counter++; @endphp @endif @php $rowCounter++; @endphp @endforeach @php $rowCounter++; @endphp @php $rowCounter++; @endphp @foreach($courts as $court) @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; @endphp @php $rowCounter++; $counter = 1; @endphp @if(isset($queries['destinationQueries']['activeQuery'][$court->getKey()])) @foreach($queries['destinationQueries']['activeQuery'][$court->getKey()] as $data) @php $rowCounter++; $counter++; @endphp @endforeach @else @php $rowCounter++; $counter++; @endphp @endif @php $rowCounter++; @endphp @endforeach

Probation		{{ $user->name }}
Month Ending		{{ $date->format('F Y') }}
Monthly Statistics
1.	Number of Active probationers from previous month:					{{ $queries['activeLastMonthQuery'] }}
2.	Number of probationers transferred from officer to officer add:					0
3.	Number of probationers transferred from officer to officer substract:					0
{{ $counter }}.	Number of probationers added from {{ $court->name }}:					{{ isset($queries['destinationQueries']['activeThisMonthQuery'][$court->getKey()]) ? $queries['destinationQueries']['activeThisMonthQuery'][$court->getKey()]->count() : 0 }}
{{ $counter }}.	Number of probationers discharged from {{ $court->name }}:					{{ isset($queries['destinationQueries']['dischargedThisMonthQuery'][$court->getKey()]) ? $queries['destinationQueries']['dischargedThisMonthQuery'][$court->getKey()]->count() : 0 }}
{{ $counter }}.	Number of probationers revoked from {{ $court->name }}:					{{ isset($queries['destinationQueries']['revokedThisMonthQuery'][$court->getKey()]) ? $queries['destinationQueries']['revokedThisMonthQuery'][$court->getKey()]->count() : 0 }}
{{ $counter }}.	Number of {{ $court->name }} Warrants issued this month:					{{ isset($queries['destinationQueries']['warrantsThisMonthQuery'][$court->getKey()]) ? $queries['destinationQueries']['warrantsThisMonthQuery'][$court->getKey()]->count() : 0 }}
{{ $counter }}	Total number of Active probationers this month:					{{ isset($queries['activeQuery']) ? $queries['activeQuery']->count() : 0 }}
{{ $subcounter }}.	Total number of Active probation cases {{ $court->name }}:					{{ isset($queries['destinationQueries']['activeQuery'][$court->getKey()]) ? $queries['destinationQueries']['activeQuery'][$court->getKey()]->count() : 0 }}
{{ $counter }}	Total number of probationers on Warrant Status:			@foreach($courts as $court) {{ $court->abbreviation }}-{{ isset($queries['destinationQueries']['warrantsQuery'][$court->getKey()]) ? $queries['destinationQueries']['warrantsQuery'][$court->getKey()]->count() : 0 }} / @endforeach		{{ isset($queries['warrantsQuery']) ? $queries['warrantsQuery']->count() : 0 }}
{{ $counter }}.	Overall Total probation cases (Active and on Warrant Status):					=G{{ $totalActiveProbationCases }}+G{{ $totalWarrantsProbationCases }}
Money Collected
{{ $counter }}	Amount of {{ $payment->payment_type_group_name }} paid by Probationers to {{ $payment->payment_destination_name }}					{{ $payment->total_amount ?? 0 }}
{{ $counter }}	Amount of {{ $paymentTypeGroup->name }} paid by Probationers to {{ $paymentDestination->name }}					0
{{ $counter }}	Total {{ $payment->payment_type_group_name }}					=SUM(G{{ $paymentTypeTotalStartRow }}:G{{ $paymentTypeTotalEndRow }})
{{ $counter }}	Amount of {{ $paymentTypeGroup->name }} paid by Probationers to {{ $paymentDestination->name }}					0
{{ $counter }}	Total {{ $paymentTypeGroup->name }}					0
{{ $counter }}	Total Amount Collected for the Month					={{ implode('+', $paymentTypeTotalsArray) }}
Hours Worked/Travel
1.	Total hours worked for the month:					0
2.	Total miles traveled for the month:					0
	{{ strtoupper($court->name) }}
	{{ strtoupper('Cases Added') }}
	Last Name	First Name	Middle Name	SID	EXP
{{ $counter }}	{{ strtoupper($data->last_name) }}	{{ strtoupper($data->middle_name) }}	{{ strtoupper($data->first_name) }}	{{ \PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel($data->probation_start_date) }}	{{ \PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel($data->probation_end_date) }}
	No cases added
	{{ strtoupper('Cases Discharged') }}
	Last Name	First Name	Middle Name	SID	EXP
{{ $counter }}	{{ strtoupper($data->last_name) }}	{{ strtoupper($data->middle_name) }}	{{ strtoupper($data->first_name) }}	{{ \PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel($data->probation_start_date) }}	{{ \PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel($data->probation_end_date) }}	{{ ($data->active_status->offender_status_type->name !== 'Discharged' ? $data->active_status->offender_status_type->name : '') }}
	No discharged cases
	{{ strtoupper('Cases Revoked') }}
	Last Name	First Name	Middle Name	SID	EXP
{{ $counter }}	{{ strtoupper($data->last_name) }}	{{ strtoupper($data->middle_name) }}	{{ strtoupper($data->first_name) }}	{{ \PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel($data->probation_start_date) }}	{{ \PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel($data->probation_end_date) }}
	No revoked cases
	{{ strtoupper('New Warrants') }}
	Last Name	First Name	Middle Name	SID	EXP
{{ $counter }}	{{ strtoupper($data->last_name) }}	{{ strtoupper($data->middle_name) }}	{{ strtoupper($data->first_name) }}	{{ \PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel($data->probation_start_date) }}	{{ \PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel($data->probation_end_date) }}
	No new warrants
	{{ strtoupper($court->name) }}
	{{ strtoupper('Active Caseload') }}
	Last Name	First Name	Middle Name	SID	EXP
{{ $counter }}	{{ strtoupper($data->last_name) }}	{{ strtoupper($data->middle_name) }}	{{ strtoupper($data->first_name) }}	{{ \PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel($data->probation_start_date) }}	{{ \PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel($data->probation_end_date) }}	{{ ($data->active_status->completed_date->greaterThan($lastMonthDate) && $data->active_status->completed_date->lessThanOrEqualTo($date) ? 'Added' : '') }}
	No cases added
	{{ strtoupper('Warrants') }}
	{{ strtoupper($court->name) }}
	{{ strtoupper('Active Warrants') }}
	Last Name	First Name	Middle Name	SID	EXP
{{ $counter }}	{{ strtoupper($data->last_name) }}	{{ strtoupper($data->middle_name) }}	{{ strtoupper($data->first_name) }}	{{ \PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel($data->probation_start_date) }}	{{ \PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel($data->probation_end_date) }}	{{ ($data->active_status->completed_date->greaterThan($lastMonthDate) && $data->active_status->completed_date->lessThanOrEqualTo($date) ? 'New Warrant' : '') }}
	No cases added