@extends('layouts.blank')

@push('stylesheets')

@endpush
@push('inline-scripts')
    @if(isset($selectedBranches))
        var selectedBranches = <?php echo json_encode($selectedBranches); ?>;
    @else
        var selectedBranches = [];
    @endif
@endpush

@push('scripts')
    <script src="{{ asset("js/refraction.js") }}"></script>
@endpush

@section('main_container')
    <div class="right_col" role="main">
        <div class="">
            <div class="page-title">

                {!! Form::open(array('route' => array('refraction.index'), 'class' => 'form-horizontal form-label-left', 'method' => 'POST')) !!}
                

                <div class="row">
                    <div class="col-md-12 col-xs-12">
                        <div class="x_panel">
                            <div class="row">

                                <div class="col-md-4 col-xs-12">
                                    <div class="form-group">
                                        <label for="branch">Branch</label>
                                        {!! Form::select('branch[]', [], null, array('id' => 'branch', 'class' => 'form-control', 'multiple' => 'multiple')) !!}
                                    </div>
                                </div>
                                <div class="col-md-2 col-xs-12">
                                    <div class="form-group">
                                        <label for="date_from">Date From</label>
                                        {!! Form::text('dateFrom', $dateFrom, array('class' => 'form-control', 'id' => 'dateFrom')) !!}
                                    </div>
                                </div>
                                <div class="col-md-2 col-xs-12">
                                    <div class="form-group">
                                        <label for="date_to">Date To</label>
                                        {!! Form::text('dateTo', $dateTo, array('class' => 'form-control', 'id' => 'dateTo')) !!}
                                    </div>
                                </div>
                            </div>

                            <div class="row">
                                <div class="col-md-12 col-xs-12">
                                    <div class="btn-group">
                                        <button type="submit" class="btn-sm btn-success" value="search" name="submit">
                                            <span class="glyphicon glyphicon-search"></span> Search
                                        </button>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="clearfix"></div>

            <div class="row">
                <div class="col-md-12 col-sm-12 col-xs-12">
                    <div class="x_panel">
                        <div class="x_title">
                            <h2>Refraction Report
                                <strong>{{ $formattedDateFrom == $formattedDateTo ? $formattedDateFrom : $formattedDateFrom . ' - ' . $formattedDateTo }}</strong>
                            </h2>
                            <ul class="nav navbar-right panel_toolbox">
                                <li>
                                    <a class="collapse-link"><i class="fa fa-chevron-up"></i></a>
                                </li>

                                <li class="dropdown">
                                    <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false"><i class="glyphicon glyphicon-export"></i></a>
                                    <ul class="dropdown-menu" role="menu">
                                        <li>
                                            <span class="label label-default" style="display: block; border-radius: 0px;">
                                                <small>Export <span class="glyphicon glyphicon-save"></span>&nbsp;
                                                    <strong>{{ $formattedDateFrom == $formattedDateTo ? $formattedDateFrom : $formattedDateFrom . ' - ' . $formattedDateTo }}</strong>
                                                </small>
                                            </span>
                                        </li>
                                        <li>
                                            <button style="text-decoration: none;" type="submit" class="btn btn-link" value="excel" name="submit">
                                                <small><span class="fa fa-retweet"></span>&nbsp;&nbsp;Download</small>
                                            </button>
                                        </li>
                                    </ul>
                                </li>
                                <li>
                                    <a class="close-link">
                                        <i class="fa fa-close"></i>
                                    </a>
                                </li>
                                {!! Form::close() !!}
                            </ul>
                            <div class="clearfix"></div>


                        </div>
                        <div class="x_content table-responsive">
                            <table id="datatable" class="table table-responsive table-striped jambo_table table-hover table-bordered">
                                <thead>
                                <tr>
                                    <th>Date</th>
                                    <th>Branch</th>
                                    <th>Specialist</th>
                                    <th>Purchased</th>
                                    <th>Eyetest</th>
                                    <th>Total</th>
                                </tr>
                                </thead>


                                <tbody>
                        @foreach ($data as $row)
                                    <tr>
                                    
                                       <td>{{$row->date}}</td>
                                        <td>{{$row->branch_name}}</td>
                                        <td>{{$row->doctor}}</td>
                                        
                                        <td>{{$row->total}}</td>
                                        <?php
                                        
                                        $eye = DB::table('eyetest1')->where([['customer','=',$row->member],['doctor','=',$row->doctor]])->count();?>
                                        <td>{{$eye}}</td>
                                    <td>{{$row->total+$eye}}</td>
                                       
                                    </tr>
                              @endforeach
                                </tbody>
                            </table>
                             </div>

                        </div>
                    </div>
                </div>
                {!! Form::close() !!}
            </div>
        </div>
    </div>
@endsection