243 lines
11 KiB
PHP
Executable File
243 lines
11 KiB
PHP
Executable File
@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 }}"> </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
|