@extends('m3::liberty-theme.layout.main')
@section('title')
Solon Sentinel Portal - Daily User Efficiency
@endsection
@section('content')
    <!-- /.row -->
    <div class="container-fluid px-4">
        <h1 class="mt-4">Daily User Efficiency</h1>

        <div class="card mb-4">
            <div class="card-header" style="line-height: 34px;">
                <i class="fas fa-table me-1"></i>
                Filters
            </div>
            <div class="card-body">
                <div class="card-body">
                    <form>
                        @csrf
                        <div class="row mb-3">
                            <label for="inputEmail" class="col-sm-2 col-form-label">Date</label>
                            <div class="col-sm-10">
                                <label for="text" class="visually-hidden">dates</label>
<input value="{{ $starting }}" id="text" name="dates" type="text"  aria-describedby="textHelpBlock" class="form-control">
                            </div>
                        </div>
                        <div class="row mb-3">
                        <label for="inputUser" class="col-sm-2 col-form-label">User</label>
                            <div class="col-sm-10">
                                <label for="picking_user" class="visually-hidden">User</label>
                                <select id="picking_user" name="user" class="form-select">
                                    <option value="" selected> </option>
                                    @foreach($user_array as $key=>$val)
                                        <option value={{$val['userprf']}}
                                                @if($val['userprf']==$user) selected @endif
                                        >{{$val['name']}}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="form-group row">
                            <div class="col-xs-offset-2 col-xs-10">
                                <button name="submit" type="submit" class="btn btn-primary">Submit</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>

        <div class="card mb-4">
            <div class="card-header">
                <i class="fas fa-table me-1"></i>
                User Picking Stats
            </div>
            <div class="card-body">
                <table class="table table-striped table-bordered table-hover" id="datatablesSimple5">
                    <thead>
                        <tr>
                            <th> </th>
                            <th>Code</th>
                            <th>Mon</th>
                            <th>Date</th>
                            <th>Hour</th>
                            <th>Pick ended at</th>
                            <th style="text-align:right">Weight </th>
                            <th style="text-align:right">Units Picked</th>
                            <th style="text-align:right">Part</th>
                            <th style="text-align:left">Order-Rl-Sh#</th>
                            <th style="text-align:left">Cust Name</th>
                            <th style="text-align:right">Time (in mins)</th>
                            <th> </th>
                        </tr>
                    </thead>
                    <tbody>
                    @if($no_data=="Y")
                        <tr> <td colspan=12 style="text-align:center; background-color:yellow"> <b>No data retrieved for this user</b> <td> <tr>
                    @else
                        @foreach($statistic4 as $key=>$val)
                            <tr>
                                <td></td>
                                <td> {{ $val->CODE }} </td>
                                <td> {{ $val->A5SENTVIEW }} </td>
                                <td> {{ $val->DT }} </td>
                                <td> {{ $val->HOUR }} </td>
                                <td> {{ str_replace(' ','______',$val->A5PICKCMTS) }} </td>
                                <td style="text-align:right"> {{ number_format($val->WEIGHT,2) }} </td>
                                    <a href="http://{{$_SERVER['HTTP_HOST']}}/php/AllSentPkr.php?order={{$val->A5ONO}}&release={{$val->A5RLNO}}&shipment={{$val->A5SHNO}}">
                                    {{ $val->A5ONO }}-{{ $val->A5RLNO }}-{{ $val->A5SHNO }}
                                    </a>
                                </td>
                                <td style="text-align:left"> {{ $val->A4SHSHNM }} </td>
                                <td style="text-align:right"> {{ number_format($val->TIMEDIFF/60,1) }} </td>
                                <td style="background-color: {{ $val->COLOUR }}"> &nbsp; </td>
                            </tr>
                        @endforeach
                    @endif
                    </tbody>
                    <tfoot>
                        <tr>
                            <td style="text-align:right" colspan="5"> Total </td>
                            <td style="text-align:right"> {{ (isset($totals_array['entries']) ? $totals_array['entries'] : "") }} </td>
                            <td style="text-align:right"> {{number_format($totals_array['weight'],2)}} </td>
                            <td style="text-align:right"> {{number_format($totals_array['picked'],0)}} </td>
                            <td> </td>
                            <td> </td>
                            <td> </td>
                            <td style="text-align:right"> {{number_format($totals_array['timediff']/60,1)}} </td>
                            <td> </td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>

        <div class="card mb-4">
            <div class="card-header">
                <i class="fas fa-table me-1"></i>
                User Picking Stats Summary
            </div>
            <div class="card-body">
                <table class="table table-striped table-bordered table-hover" id="datatablesSimple3">
                        <tr>
                            <th>Monitor</th>
                            <th>Total</th>
                            @foreach($monitor_array as $key)
                                @if($key['header']!="0")
                                    <th> {{$key['header']}} </th>
                                @endif
                            @endforeach
                        </tr>
                        <tr>
                            <td> Picked Weight </td>
                            <td> {{number_format($totals_array['weight'],0)}} </td>
                            @foreach($monitor_array as $key)
                                @if($key['header']!="0")
                                    <td> {{number_format($key['weight'],0) }} </td>
                                @endif
                            @endforeach
                        </tr>
                        <tr>
                            <td> Picked Lines </td>
                            <td> {{number_format($totals_array['entries'],0)}} </td>
                            @foreach($monitor_array as $key)
                                @if($key['header']!="0")
                                    <td> {{number_format($key['lines'],0)}} </td>
                                @endif
                            @endforeach
                        </tr>
                        <tr>
                            <td>Total in hours (based on Greg time entry)</td>
                            <td>{{(isset($perf_array['tot_hours'])?number_format($perf_array['tot_hours'],1):"")}}</td>
                            @foreach($monitor_array as $key)
                                @if($key['header']!="0")
                                    <td> {{number_format($key['tot_hours'],1) }} </td>
                                @endif
                            @endforeach
                        </tr>
                        <tr>
                            <td>Percent per activity</td>
                            <td>100%</td>
                            @foreach($monitor_array as $key)
                                @if($key['header']!="0")
                                    <td> {{number_format($key['percent_per_activity']*100,0)}}% </td>
                                @endif
                            @endforeach
                        </tr>
                        <tr>
                            <td>LPH contribution per activity </td>
                            <td>{{(isset($monitor_array[0]['lph_blended_per_activity'])?number_format($monitor_array[0]['lph_blended_per_activity'],1):"")}}</td>
                            @foreach($monitor_array as $key)
                                @if($key['header']!="0")
                                    <td> {{number_format($key['lph_blended_per_activity'],1)}} </td>
                                @endif
                            @endforeach
                        </tr>
                </table>
            </div>
        </div>
        <div class="card mb-4">
            <div class="card-header">
                <i class="fas fa-table me-1"></i>
                User Picking Stats Performance Summary
            </div>
            <div class="card-body">
                <table class="table table-striped table-bordered table-hover" id="datatablesSimple4">
                    <tr>
                        <th scope="row">Total in hours (based on Greg time entry)</th>
                        <td>{{(isset($perf_array['tot_hours'])?number_format($perf_array['tot_hours'],1):"")}}</td>
                    </tr>
                    <tr>
                        <td></td>
                        <td></td>
                    </tr>
                    <tr>
                        <td>Per hour actual</td>
                        <td>{{(isset($perf_array['per_hour_actual'])?number_format($perf_array['per_hour_actual'],1):"")}}</td>
                    </tr>
                    <tr>
                        <td>Blended target for the day</td>
                        <td>{{(isset($monitor_array[0]['lph_blended_per_activity'])?number_format($monitor_array[0]['lph_blended_per_activity'],1):"")}}</td>
                    </tr>
                    <tr>
                        <td>Performance</td>
                        <td>{{(isset($perf_array['performance_activity'])?number_format($perf_array['performance_activity']*100,0):"")}}%</td>
                    </tr>
                </table>
            </div>
        </div>

    </div>
    <!-- /.row -->

@endsection

@section('scripts')
<script>

    $(document).ready(function() {

        // DataTable init
        $('#datatablesSimple5').DataTable({
            "aaSorting": [],
            "lengthMenu": [ [10,25,50,-1], [10,25,50,"All"] ]
        });

        // Date range init
        $('input[name="dates"]').daterangepicker({
            singleDatePicker: true,
            showDropdowns: true,
            minYear: 2001,
            maxYear: parseInt(moment().format('YYYY'),10),
            locale: {
                format: 'YYYY-MM-DD',
            },
            startDate: '{{ $starting }}',
            alwaysShowCalendars: true
        });

    });

</script>
@endsection