@extends('layouts.report')

@section('page_title')
    {{ $info['year'] }}-{{ substr($info['year'] + 1, 2, 2) }} OSAA {{ $info['activity_name'] }} State Championship School Reimbursements
@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 tr {
            line-height: 1.5em;
            page-break-inside: avoid;
        }

        table tbody td {
            border-bottom: 1px solid #000000;            
            padding: 0.2em 0.1em 0.2em 0.1em;
            vertical-align: middle;
            page-break-inside: avoid;
        }

        table tbody tr.totals td {
            border-top: 2px solid #000000;
            font-weight: bold;
            page-break-inside: avoid;
        }

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

    </style>
@stop

@section('jquery_init')         
    
    

@stop


@section('body')

    <div class="page">

        <div class="title">
            {{ $info['year'] }}-{{ substr($info['year'] + 1, 2, 2) }} OSAA {{ $info['activity_name'] }} State Championship School Reimbursements
        </div>

        <table>
            <thead>
                <tr>
                    <th>School</th>                                        
                    <th>Participants</th>                    
                    <th>Days</th>
                    <th>Miles</th>
                    <th>Rate</th>                    
                    <th>Mileage</th>                                        
                    <th>Total</th>                    
                </tr>
            </thead>

            <tbody>

                
                @foreach ($info['school_objects'] as $array_index => $school_object)                                        
                    
                    
                    <tr class="{{ ($index % 2 == 1) ? 'odd' : null }}">
                        <td>{{ $school_object->school->short_name}}</td>                        
                        <td>{{ $school_object->data->participants }}</td>                        
                        <td>{{ $school_object->data->days }}</td>                        
                        <td>{{ $school_object->data->miles }}</td>
                        <td>${{ number_format($school_object->data->mileage_rate, 2) }}</td>                        
                        <td>${{ number_format($school_object->data->mileage, 2) }}</td>                        
                        <td style="font-weight: bold;">${{ number_format($school_object->record->amount, 2) }}</td>
                    </tr>

                @endforeach 

                

            </tbody>
        </table>
    </div>

    <div class="page">

        <div class="title">
            {{ $info['year'] }}-{{ substr($info['year'] + 1, 2, 2) }} OSAA {{ $info['activity_name'] }} State Championship School Reimbursements - Summary
        </div>

        <table>
            <thead>
                <tr>
                    <th>School</th>                                
                    <th>Participants</th>                                
                    <th>Miles</th>
                    <th></th>
                    <th>&#215;</th>                    
                    <th>Mileage</th>                                
                    <th>Total</th>                    
                </tr>
            </thead>

            <tbody>                

                <tr class="totals">
                    <td>{{ count($info['school_objects']) }} Schools</td>                    
                    <td>{{ $info['totals']['grand_total']->participants }}</td>                                        
                    <td>{{ $info['totals']['grand_total']->miles }}</td>                    
                    <td></td>
                    <td>${{ number_format($info['totals']['grand_total']->mileage, 2) }}</td>
                    <td></td>                    
                    <td>${{ number_format($info['totals']['grand_total']->total, 2) }}</td>
                </tr>

            </tbody>
        </table>

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

        @if (Helpers::strEqual($info['activity_name'], 'Choir'))

            Calculated from the music registration download of all music entries.  Downloaded directly from the website based off of state registration forms.  Filtered down to all choir groups selected for state.  If a group did not appear at the state championship, their registration form is updated to reflect they were not selected.

        @elseif (Helpers::strEqual($info['activity_name'], 'Band'))

            Calculated from the music registration download of all music entries.  Downloaded directly from the website based off of state registration forms.  Filtered down to all band groups selected for state.  If a group did not appear at the state championship, their registration form is updated to reflect they were not selected.

        @elseif (Helpers::strEqual($info['activity_name'], 'Orchestra'))

            Calculated from the music registration download of all music entries.  Downloaded directly from the website based off of state registration forms.  Filtered down to all orchestra groups selected for state.  If a group did not appear at the state championship, their registration form is updated to reflect they were not selected.
        
        @elseif (Helpers::strEqual($info['activity_name'], 'Speech'))

            Calculated from a created spreadsheet of all teams and their number of participants.  This spreadsheet is created from the TabRoom website, Results Report for "School Report" and getting all schools.  Each school is examined for unique participant names and excluding any participant that did not attend the championships because of no ballot entries.

        @elseif (Helpers::strEqual($info['activity_name'], 'Solo Music'))

            Calculated from the solo music schedule.  The CSV file from the web server is downloaded, then a "Status" column is added and anyone who did not attend the state championship is marked in the status column as "NS" for no-show and excluded from the report.

            <br /><br />

            Any no-shows are listed below:


        @endif

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

    </div>          

@stop