@extends('layouts.report')

@section('page_title')
    OSAA Playoff Officials Reimbursement Report
@stop

@section('style')        
    <style type="text/css">

        .page {            
            font-size: 10pt;
            width: 11in;
            /*outline: 1px solid black;*/
            page-break-after: always;
        }    

        .page.no-page-break {
            page-break-after: avoid;
        }

        .title {
            width: 100%;
            text-align: center;
            font-size: 12pt;
            font-weight: bold;
            margin: 0.5em 0 0.25em 0;
        }     

        .odd {
             background-color: #dddddd;
        }  

        table {
            width: 100%;
            border-collapse: collapse;
        }

        table thead th {
            text-align: left;
        }

        table tbody td {
            border-bottom: 1px solid #000000;            
            padding: 0.2em 0.1em;
        }

        table tbody tr.totals {
            background-color: #ffffff !important;
            font-weight: bold;
        }

        table tbody tr.totals td {
            border-top: 2px solid #000000;
        }

        .footnote {
            font-size: 8pt;
            line-height: 1.15em;
            padding-bottom: 0.5em;
            page-break-inside: avoid;
        }        	

    </style>
@stop

@section('jquery_init')	
	
    $('tbody tr.info td')
        .css({'border' : 'none'});

@stop


@section('body')    

    @foreach ($info['association_objects'] as $association_object)

        <div class="page">

            <div class="title">
                {{ $association_object->association->name }} Reimbursements for {{ $association_object->association->sport }} Playoff Officials {{ $info['school_year'] }}-{{ substr(intval($info['school_year']) + 1, 2, 2) }}
            </div>

            <table style="font-size: 8pt;">
                <thead>
                    <tr>
                        <th>#</th>
                        <th>Subt.</th>
                        <th>Act.</th>                    
                        <th>Div.</th>
                        <th>Rnd.</th>
                        <th>Date</th>
                        <th>Time</th>
                        <th>Teams</th>                    
                        <th># Officials</th>
                        <th>Rate</th>
                        <th>Game Fee</th>
                        <th>Assign</th>
                        <th>B</th>
                        <th>L</th>
                        <th>D</th>
                        <th>Meals</th>
                        <th>Miles</th>
                        <th>Mileage</th>
                        <th>Other</th>
                        <th>Total</th>
                    </tr>
                </thead>

                <tbody>
                                        @foreach ($association_object->records as $record)
                        
                        <tr class="{{ ($row_index % 2 == 1) ? 'odd' : null }} info">
                            <td>#{{ $record->assignment_number }}</td>
                            <td>
                                @if (is_null($record->cmsh_verified_at))
                                    Never
                                @else
                                    {{ date('n/j', strtotime($record->cmsh_verified_at)) }}
                                @endif
                            </td>
                            <td>
                                @if (!Helpers::strContains('b', $record->assignment_number))
                                    {{ $record->bracket->activity }}
                                @endif
                            </td>  
                            <td>
                                @if (!Helpers::strContains('b', $record->assignment_number))
                                    {{ $record->bracket->division }}
                                @endif
                            </td>                      
                            <td>
                                @if (!Helpers::strContains('b', $record->assignment_number))
                                    @if (Helpers::strEqual($record->bracket->activity, array('VBL', 'BBX', 'GBX')) and Helpers::strEqual($record->round->round_type, array('QF', 'SF', 'F', 'S', 'SC', 'C')))
                                        Final-Site ({{ $record->round->round_type }})
                                    @else
                                        {{ $record->round_type->slug }}
                                    @endif
                                @endif
                            </td>
                            <td>
                                @if (!Helpers::strContains('b', $record->assignment_number))
                                    {{ date('n/j', strtotime($record->event->start_at)) }}
                                    @endif
                            </td>
                            <td>
                                @if (!Helpers::strContains('b', $record->assignment_number))
                                    {{ Helpers::formatDateTime('%SCHEDULE%', strtotime($record->event->start_at)) }}
                                @endif
                            </td>
                            <td>
                                @if (!Helpers::strContains('b', $record->assignment_number))
                                    {{ $record->contest->away_team_name }} @ {{ $record->contest->home_team_name }}                            
                                @endif
                            </td>
                            <td style="white-space: nowrap;">
                                {{ $record->number }} &#215; {{ $record->officials_fee->position }}                            
                            </td>                            
                            <td>
                                @if (!$record->is_half_fee)
                                    ${{ number_format($record->officials_fee->amount, 2) }}
                                @else
                                    ${{ number_format($record->officials_fee->amount / 2, 3) }}
                                @endif                                
                            </td>
                            <td>${{ number_format($record->game_fee, 2) }}</td>
                            <td>${{ number_format($record->assign_fee, 2) }}</td>
                            <td>{{ $record->breakfast }}</td>
                            <td>{{ $record->lunch }}</td>
                            <td>{{ $record->dinner }}</td>
                            <td>${{ number_format($record->meals_fee, 2) }}</td>
                            <td>{{ $record->miles }}</td>
                            <td>${{ number_format($record->mileage_fee, 2) }}</td>
                            <td>${{ number_format($record->other_fee, 2) }}</td>
                            <td>${{ number_format($record->total_amount, 2) }}</td>
                        </tr>

                        <tr @if ($row_index % 2 == 1) class="odd" @endif>                        
                            <td colspan="20" style="line-height: 1.5em; font-size: 7pt; vertical-align: top;">
                                @if (!Helpers::strIsEmpty($record->notes))
                                    Notes: {{ $record->notes }}
                                @endif
                            
                                @if (!Helpers::strIsEmpty($record->officials))
                                    Officials: {{ $record->officials }}
                                @endif
                            </td>
                        </tr>
                    @endforeach
                
                    <tr class="totals">
                        <td colspan="8">
                            {{ $association_object->association->name }}
                            @if ($association_object->unverified > 0)
                                ({{ $association_object->unverified }} Unsubmitted)
                            @endif
                        </td>
                        <td></td>                    
                        <td colspan="2" style="text-align: center;">${{ number_format($association_object->totals->game_fees, 2) }}<br />Game</td>
                        <td>${{ number_format($association_object->totals->assign_fees, 2) }}<br />Assign</td>
                        <td></td>                    
                        <td colspan="3" style="text-align: center;">${{ number_format($association_object->totals->meals_fees, 2) }}<br />Meals</td>
                        <td></td>
                        <td>${{ number_format($association_object->totals->mileage_fees, 2) }}<br />Mileage</td>
                        <td>${{ number_format($association_object->totals->other_fees, 2) }}<br />Other</td>
                        <td>${{ number_format($association_object->totals->total_fees, 2) }}<br />Total</td>
                    </tr>


                </tbody>

            </table>

            <br class="clear" /><br />

            <div class="footnote">
                @if (Helpers::strEqual($association_object->association->sport, 'Football'))
                    The OSAA will reimburse mileage at the rate of 75&#162; per mile up to 60 miles round trip and 50&#162; per mile for 61 or more miles round trip.  A minimum of $5 per official is allowed.  The OSAA assumes the minimum mileage for each assignment unless otherwise entered by the commissioner.  Each reimbursement record includes a $1.50 assigning fee.  Where meal claims are allowed, receipts are not required and the rates are as follows: breakfast - $8, lunch - $10, dinner - $15.  When the OSAA determines that lodging is necessary, complimentary rooms will be provided based on two officials per room.  If an official wishes not to share a room, there will be no reimbursement for lodging expenses.  In these cases, the official is responsible for their own reservations and are not eligible for the OSAA discounted rates.  The deadline for submitting expenses is December 12.
                @elseif (Helpers::strEqual($association_object->association->sport, 'Volleyball'))
                    The OSAA will reimburse mileage at the rate of 50&#162; per mile with a minimum of $5 per official.  The OSAA assumes the minimum mileage for each assignment unless otherwise entered by the commissioner.  Line judge assignments for the same contest and officials association are included with that assignment's primary reimbursement record which lists the higher officials game fee rate.  Round trip miles for the initial arrival at the final tournament site and for the return home are included in one assignment record, nominally a semi-final contest assignment.  Similarly, meal claims for the tournament at the final-site will be input by OSAA staff into one assignment to reimburse meal expenses, if any, for the entire tournament at the final-site.  Each reimbursement record includes a $1.50 assigning fee, except for assignments at the final-site.  In which case one, single assigning fee of $1.50 will be added to one assignment during the tournament.  Where meal claims are allowed, receipts are not required and the rates are as follows: breakfast - $8, lunch - $10, dinner - $15.  When the OSAA determines that lodging is necessary, complimentary rooms will be provided based on two officials per room.  If an official wishes not to share a room, there will be no reimbursement for lodging expenses.  In these cases, the official is responsible for their own reservations and are not eligible for the OSAA discounted rates.  The deadline for submitting expenses is November 14.
                @elseif (Helpers::strEqual($association_object->association->sport, 'Soccer'))
                    The OSAA will reimburse mileage at the rate of 50&#162; per mile with a minimum of $5 per official.  The OSAA assumes the minimum mileage for each assignment unless otherwise entered by the commissioner.  Fourth official assignments for the same contest and officials association are included with that assignment's primary reimbursement record which lists the higher officials game fee rate.  Each reimbursement record includes a $1.50 assigning fee.  Where meal claims are allowed, receipts are not required and the rates are as follows: breakfast - $8, lunch - $10, dinner - $15.  When the OSAA determines that lodging is necessary, complimentary rooms will be provided based on two officials per room.  If an official wishes not to share a room, there will be no reimbursement for lodging expenses.  In these cases, the official is responsible for their own reservations and are not eligible for the OSAA discounted rates.  The deadline for submitting expenses is November 16.
                @elseif (Helpers::strEqual($association_object->association->sport, 'Basketball'))
                    The OSAA will reimburse mileage at the rate of 50&#162; per mile with a minimum of $5 per official.  The OSAA assumes the minimum mileage for each assignment unless otherwise entered by the commissioner.  Round trip miles for the initial arrival at the final tournament site and for the return home are included in one assignment record, nominally the last assignment for finals.  Similarly, meal claims for the tournament at the final-site will be input by OSAA staff into one assignment to reimburse meal expenses, if any, for the entire tournament at the final-site.  Each reimbursement record includes a $1.50 assigning fee, except for assignments at the final-site.  In which case one, single assigning fee of $1.50 will be added to one assignment during the tournament.  Where meal claims are allowed, receipts are not required and the rates are as follows: breakfast - $8, lunch - $10, dinner - $15.  When the OSAA determines that lodging is necessary, complimentary rooms will be provided based on two officials per room.  If an official wishes not to share a room, there will be no reimbursement for lodging expenses.  In these cases, the official is responsible for their own reservations and are not eligible for the OSAA discounted rates.  The deadline for submitting expenses is April 1.
                @elseif (Helpers::strEqual($association_object->association->sport, 'Wrestling'))
                    The OSAA will reimburse mileage at the rate of 50&#162; per mile with a minimum of $5 per official.  The OSAA assumes the minimum mileage for each assignment unless otherwise entered by the commissioner.  Each reimbursement record includes a $1.50 assigning fee.  Where meal claims are allowed, receipts are not required and the rates are as follows: breakfast - $8, lunch - $10, dinner - $15.  When the OSAA determines that lodging is necessary, complimentary rooms will be provided based on two officials per room.  If an official wishes not to share a room, there will be no reimbursement for lodging expenses.  In these cases, the official is responsible for their own reservations and are not eligible for the OSAA discounted rates.  The deadline for submitting expenses is April 1.
                @else
                    The OSAA will reimburse mileage at the rate of 50&#162; per mile with a minimum of $5 per official.  The OSAA assumes the minimum mileage for each assignment unless otherwise entered by the commissioner.  Each reimbursement record includes a $1.50 assigning fee.  Where meal claims are allowed, receipts are not required and the rates are as follows: breakfast - $8, lunch - $10, dinner - $15.  When the OSAA determines that lodging is necessary, complimentary rooms will be provided based on two officials per room.  If an official wishes not to share a room, there will be no reimbursement for lodging expenses.  In these cases, the official is responsible for their own reservations and are not eligible for the OSAA discounted rates.  The deadline for submitting expenses is July 1.
                @endif
            </div>

            <br class="clear" />

        </div>

    @endforeach

    <div class="page no-page-break">

        <div class="title">
            Summary
        </div>

        <table style="font-size: 8pt;">
            <thead>
                <tr>
                    <th>Association</th>
                    <th>Records</th>
                    <th>Un-Subt.</th>                    
                    <th>Contests</th>
                    <th>Game Fee</th>
                    <th>Assign</th>                    
                    <th>Meals</th>
                    <th>Miles</th>
                    <th>Mileage</th>
                    <th>Other</th>
                    <th>Total</th>
                </tr>
            </thead>

            <tbody>
                
                @foreach ($info['association_objects'] as $index => $association_object)

                    <tr class="{{ ($index % 2 == 0) ? 'odd' : null }} info">
                        <td>{{ $association_object->association->name }}</td>
                        <td>{{ count($association_object->records) }}</td>
                        <td>{{ $association_object->unverified }}</td>
                        <td>{{ $association_object->contest_count }}</td>                        
                        <td>${{ number_format($association_object->totals->game_fees, 2) }}</td>
                        <td>${{ number_format($association_object->totals->assign_fees, 2) }}</td>                        
                        <td>${{ number_format($association_object->totals->meals_fees, 2) }}</td>
                        <td>{{ $association_object->totals->miles }}</td>
                        <td>${{ number_format($association_object->totals->mileage_fees, 2) }}</td>
                        <td>${{ number_format($association_object->totals->other_fees, 2) }}</td>
                        <td><b>${{ number_format($association_object->totals->total_fees, 2) }}</b></td>
                    </tr>
                    
                @endforeach

                <tr class="totals">
                    <td>{{ count($info['association_objects']) }} Officials Associations</td>
                    <td>{{ $info['grand_totals']->records }}</td>
                    <td>{{ $info['grand_totals']->unverified }}</td>
                    <td>{{ count($info['grand_totals']->contests) }} / {{ $info['bracketed_contests'] }}</td>
                    <td>${{ number_format($info['grand_totals']->game_fees, 2) }}</td>
                    <td>${{ number_format($info['grand_totals']->assign_fees, 2) }}</td>                    
                    <td>${{ number_format($info['grand_totals']->meals_fees, 2) }}</td>
                    <td>{{ $info['grand_totals']->miles }}</td>
                    <td>${{ number_format($info['grand_totals']->mileage_fees, 2) }}</td>
                    <td>${{ number_format($info['grand_totals']->other_fees, 2) }}</td>
                    <td>${{ number_format($info['grand_totals']->total_fees, 2) }}</td>
                </tr>
            </tbody>

        </table>

    </div>
 	
@stop