@extends('layouts.admin')

@section('page-header')
School List
@endsection


@section('content')
<style>
.table > thead > tr > th {
	vertical-align: middle;
}




/* 
Max width before this PARTICULAR table gets nasty
This query will take effect for any screen smaller than 760px
and also iPads specifically.

모바일에서 테이블 (제목+내용)이 하나의 박스로 나오도록 설정
*/

@media only screen and (max-width: 760px),
(min-device-width: 768px) and (max-device-width: 1024px) {
    /* Force table to not be like tables anymore */
    table,
    thead,
    tbody,
    th,
    td,
    tr {
        display: block;
        float: left;
        /* ie9 fix */
        width: 100%;
        clear: both;
    }
    /* Hide table headers (but not display: none;, for accessibility) */
    thead tr {
        position: absolute;
        top: -9999px;
        left: -9999px;
    }
    tr {
        border: 1px solid #ccc;
    }
    td {
        /* Behave  like a "row" */
        border: none;
        border-bottom: 1px solid #eee;
        position: relative;
        padding-left: 50%;
        word-break: break-all;
        white-space: normal;
        display: block;
        -moz-box-sizing: border-box;
        -webkit-box-sizing: border-box;
        box-sizing: border-box;
        text-align: center;
    }

    /*고정값을 주게 되면 제목과 내용이 제대로 안나오는 문제 발생*/
    td:before {
        padding-right: 10px;
        white-space: nowrap;
        text-align: left;
        font-weight: bold;
        float: left;
        width: 45%;
        padding: 0 0 0 1%;
        /*  margin-left:-100%;*/
    }
    
    /*
    Label the data 각 테이블마다 tr에 작성 된 제목을 지정해준다 
    */
    table.school_list_table td:nth-of-type(1):before {
        content: "No";
    }
    table.school_list_table td:nth-of-type(2):before {
        content: "Type";
    }
    table.school_list_table td:nth-of-type(3):before {
        content: "Grade level";
    }
    table.school_list_table td:nth-of-type(4):before {
        content: "State/City";
    }
    table.school_list_table td:nth-of-type(5):before {
        content: "School name";
    }
    table.school_list_table td:nth-of-type(6):before {
        content: "number of H/F";
    }
    table.school_list_table td:nth-of-type(7):before {
        content: "Number of AnB Student";
    }
}


/* Smartphones (portrait and landscape) ----------- */

@media only screen and (min-device-width: 320px) and (max-device-width: 480px) {
    body {
        padding: 0;
        margin: 0;
        width: 100%;
    }
}


/* iPads (portrait and landscape) ----------- */

@media only screen and (min-device-width: 768px) and (max-device-width: 1024px) {
    body {
        width: 100%;
    }
}


/* 2017.10.30 school list page */





</style>
<div class="form-inline">
<form name="search_list" class="form-horizontal">
<div class="row">
	<div class="col-sm-9">
		<select class="form-control" name="sl_state">
		<option value="">Select state</option>
		@foreach($states as $state)
		<option value="{{ $state->id }}" {{ Request::Input('sl_state') == $state->id ? 'selected' : '' }}>{{ $state->state_name }}</option>
		@endforeach
		</select>
		<select class="form-control" name="sl_start_grade">
		<option value="">start grade</option>
			<option value="-2" {{ Request::Input('sl_start_grade') == -2 ? 'selected' : '' }}>PK</option>
			<option value="-1" {{ Request::Input('sl_start_grade') == -1 ? 'selected' : '' }}>K</option>
			@for($i=1;$i<=12;$i++)
			<option value="{{ $i }}" {{ Request::Input('sl_start_grade') == $i ? 'selected' : '' }}>{{ $i }}th</option>
			@endfor
		</select>
		<select class="form-control" name="sl_end_grade">
		<option value="">end grade</option>
			<option value="-2" {{ Request::Input('sl_end_grade') == -2 ? 'selected' : '' }}>PK</option>
			<option value="-1" {{ Request::Input('sl_end_grade') == -1 ? 'selected' : '' }}>K</option>
			@for($i=1;$i<=12;$i++)
			<option value="{{ $i }}" {{ Request::Input('sl_end_grade') == $i ? 'selected' : '' }}>{{ $i }}th</option>
			@endfor
		</select>
		<select class="form-control" name="sl_type">
			<option value="">public, private</option>
			<option value="public" {{ Request::Input('sl_type') == 'public' ? 'selected' : '' }}>public</option>
			<option value="private" {{ Request::Input('sl_type') == 'private' ? 'selected' : '' }}>private</option>
		</select>
		<select class="form-control" name="sl_school_type">
			<option value="">day, boarding, none</option>
			<option value="day" {{ Request::Input('sl_school_type') == 'day' ? 'selected' : '' }}>Day</option>
			<option value="boarding" {{ Request::Input('sl_school_type') == 'boarding' ? 'selected' : '' }}>Boarding</option>
			<option value="none" {{ Request::Input('sl_school_type') == 'none' ? 'selected' : '' }}>none</option>
		</select>
		<select class="form-control" name="sl_gender">
			<option value="">gender</option>
			<option value="Coed" {{ Request::Input('sl_gender') == 'Coed' ? 'selected' : '' }}>Coed</option>
			<option value="Boys" {{ Request::Input('sl_gender') == 'Boys' ? 'selected' : '' }}>Boys</option>
			<option value="Girls" {{ Request::Input('sl_gender') == 'Girls' ? 'selected' : '' }}>Girls</option>
		</select>

		<select class="form-control" name="sl_search">
			<option value="school_name" {{ Request::Input('sl_search') == 'school_name' ? 'selected' : '' }}>School name</option>
			<option value="religious" {{ Request::Input('sl_search') == 'religious' ? 'selected' : '' }}>Religious</option>
		</select>
		<input type="text" name="sl_keyword" class="form-control" value="{{ Request::Input('sl_keyword') }}">
		<button class="btn btn-primary"><i class="fa fa-search"></i></button>
		<a href="/{{ Request::path() }}" class="btn btn-info"><i class="fa fa-undo"> Reset</i></a>
		<a href="/admin/school/excel" class="btn btn-success"><i class="fa fa-file-text-o"> Excel Download</i></a>
	</div>
	<div class="col-sm-3 text-right">
		<select aria-controls="editable" class="form-control" name="page_size" onchange="document.search_list.submit();">
		<option value="25" {{ $schools->perPage() == 25 ? 'selected' : '' }}>List 25</option>
		<option value="50" {{ $schools->perPage() == 50 ? 'selected' : '' }}>List 50</option>
		<option value="100" {{ $schools->perPage() == 100 ? 'selected' : '' }}>List 100</option>
		</select>
	</div>
</div>
</form>
</div>

<div class="row mt20">
	<div class="col-xs-6">
		<p style="margin-bottom:0px;height:41px;line-height: 41px;">* Total <b>{{ number_format($schools->total()) }}</b> Records.</p>
	</div>
</div>

<div class="panel mt5">
  <div class="panel-body pn">
    <div class="bs-component">
		
      <table class="table table-striped table-bordered table-hover school_list_table" style="word-wrap:break-word;word-break:break-all;">
        <thead>
          <tr>
            <th width="80" class="text-center">No</th>
            <th class="text-center">Type</th>
            <th class="text-center">Grade level</th>
            <th class="text-center">State/City</th>
            <th class="text-center">School name</th>
            <th class="text-center">number of H/F</th>
            <th class="text-center">Number of AnB Student</th>
          </tr>
        </thead>
        <tbody>
		@for ($i=0,$cnt=count($schools);$i<$cnt;$i++)
				<tr>
			<td class="text-center">{{ $schools->total() - ($schools->perPage() * ($schools->currentPage()-1)) - $i }}</td>
			<td class="text-center">{{ $school->type }}</td>
			<td class="text-center">
			@if($school->start_grade == '-1')
			K 
			@elseif($school->start_grade == '-2')
			PK
			@else
			{{$school->start_grade}}th
			@endif
			~
			@if($school->end_grade == '-1')
			K 
			@elseif($school->end_grade == '-2')
			PK
			@else
			{{$school->end_grade}}th
			@endif</td>
			<td>{{ $school->state}} / {{ $school->city}}</td>
			<td><a href="/{{ Request::path() }}/{{ $school->id }}/write">{{ $school->school_name }}</a></td>
			<td class="text-center"><a href="host?school_id={{ $school->id }}">{{ $school->hosts->count()+ $school->hosts_school1->count()+ $school->hosts_school2->count() }}</a></td>
			<td class="text-center"><a href="student?sl_search=school_name&sl_keyword={{ urlencode($school->school_name) }}">{{ $school->students->count() }}</a></td>
		</tr>
				@endfor
	     @if (count($schools) <= 0)
	       <tr>
		     <td colspan="7" class="text-center">No search result.</td>
		   </tr>
	     @endif
        </tbody>
      </table>
    </div>
  </div>
</div>

<div class="text-left smart-widget">
	<a href="/admin/school/write" class="btn btn-primary">Add</a>
</div>

<nav class="text-center">
	{{ $schools->appends(Request::only('sl_state', 'sl_search', 'sl_keyword', 'page_size'))->links() }}
</nav>


@endsection



@section('script')>

  <script type="text/javascript">
  jQuery(document).ready(function() {
    "use strict";
  });
  </script>
@endsection