@extends('layouts.app')

@section('content')
 <!-- ============================================================== -->
		<!-- 						Content Start	 						-->
		<!-- ============================================================== -->
		
            <div class="row page-header"><div class="col-lg-6 align-self-center ">
			  <h2>Fish Tanks</h2>
				<ol class="breadcrumb">
					<li class="breadcrumb-item"><a href="{{ url('/home') }}">Home</a></li>
					<li class="breadcrumb-item active">Fish Tanks</li>		
				</ol></div>
				<div class="col-lg-6 align-self-center text-right">
					<a href="#" class="btn btn-success box-shadow btn-icon btn-rounded"><i class="fa fa-plus"></i> Add Fish Tank</a>
				</div>
				</div>
			
        <section class="main-content">

            <div class="row">
               
                 <div class="col-md-12">
                    <div class="card">
                        <div class="card-header card-default">
                            Fish Tanks
                        </div>
                        <div class="card-body">
                            <table id="datatable" class="table table-striped dt-responsive nowrap">
                                            <thead>
                                                <tr>
                                                    <th>Name</th>
                                                    <th>PH</th>
                                                    <th>Oxygen</th>
                                                    <th>Temperature</th>
                                                    <th>Volume</th>
                                                    <th>Location</th>
                                                    <th>Action</th>
                                                </tr>
                                            </thead>

                                            <tbody>
                                            @if(isset($tanks))
                                                @foreach($tanks as $tank)_
                                                
                                                	@php( $ph = null )
                                                	@php( $oxygen = null )
                                                	@php( $volume = null )
                                                	@php( $watertemperature = null )
                        
                        							@foreach($tank->sensors as $sensor)
                                                    	  @php ( $columns=explode(",",$sensor->sensor->sensor->columns) )
                                                    	  
                            							  
                            							  	@if($sensor->latestReadings)
                                                            	@if(in_array("ph", $columns))
                                                            		@php( $ph = $sensor->latestReadings->ph )
                                                            	@endif
                                                            	@if(in_array("oxygen", $columns))
                                                            		@php( $oxygen = $sensor->latestReadings->oxygen )
                                                            	@endif
                        										@if(in_array("volume", $columns)) 
                        											@php( $volume = $sensor->latestReadings->volume) 
                        										@endif
                        										@if(in_array("watertemperature", $columns)) 
                        											@php( $watertemperature = $sensor->latestReadings->watertemperature ) 
                        										@endif
                            							  	@endif
                            						@endforeach
                                                    <tr>
                                                        <td>{{ $tank->name }}</td>
                                                        <td>{{ $ph }}</td>
                                                        <td>{{ $oxygen }}</td>
                                                        <td>{{ $watertemperature }}</td>
                                                        <td>{{ $volume }}</td>
                                                        <td>{{ $tank->location }}</td>
                                                        <td><a href="{{ url('/fishtank/'.$tank->id) }}" class="btn btn-default btn-rounded">View</a></td>
                                                    </tr>
                                                 @endforeach
                                             @endif
                                           </tbody>
                              </table>
                       </div>
                    </div>
                </div>
            </div>
            
            

            <footer class="footer">
                <span>Copyright &copy; 2018 FixedPlus</span>
            </footer>


        </section>
        <!-- ============================================================== -->
		<!-- 						Content End		 						-->
		<!-- ============================================================== -->
@endsection
@section('jscript')
	<!-- Js Grid -->
		<script src="{{ asset('admin/assets/lib/jsgrid/jsgrid.min.js') }}"></script>
        
		<!-- Datatables-->
        <script src="{{ asset('admin/assets/lib/datatables/jquery.dataTables.min.js') }}"></script>
        <script src="{{ asset('admin/assets/lib/datatables/dataTables.responsive.min.js') }}"></script>

		<script src="{{ asset('admin/assets/lib/datatables/dataTables.buttons.min.js') }}"></script>
		<script src="{{ asset('admin/assets/lib/datatables/jszip.min.js') }}"></script>
		<script src="{{ asset('admin/assets/lib/datatables/pdfmake.min.js') }}"></script>
		<script src="{{ asset('admin/assets/lib/datatables/vfs_fonts.js') }}"></script>
		<script src="{{ asset('admin/assets/lib/datatables/buttons.html5.min.js') }}"></script>
        <script>
            $(document).ready(function () {
                $('#datatable').dataTable();
				
				$('#datatable2').DataTable({
					 dom: 'Bfrtip',
					buttons: [
						'copyHtml5',
						'excelHtml5',
						'csvHtml5',
						'pdfHtml5'
					]
				});
				
				 $('#datatable3').DataTable( {
					"scrollY":        "400px",
					"scrollCollapse": true,
					"paging":         false
				} );
            });
			
        </script>
@endsection