266 lines
12 KiB
Twig
266 lines
12 KiB
Twig
{% extends 'base.html.twig' %}
|
|
|
|
{% block body %}
|
|
<!-- BEGIN: Subheader -->
|
|
<div class="m-subheader">
|
|
<div class="d-flex align-items-center">
|
|
<div class="mr-auto">
|
|
<h3 class="m-subheader__title">
|
|
Job Orders (All)
|
|
</h3>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<!-- END: Subheader -->
|
|
<div class="m-content">
|
|
<!--Begin::Section-->
|
|
<div class="row">
|
|
<div class="col-xl-12">
|
|
<div class="m-portlet m-portlet--mobile">
|
|
<div class="m-portlet__body">
|
|
<div class="m-form m-form--label-align-right m--margin-top-20 m--margin-bottom-30">
|
|
<div class="row align-items-center">
|
|
<div class="col-xl-12">
|
|
<div class="form-group m-form__group row align-items-center">
|
|
<div class="col-md-4">
|
|
<div class="m-input-icon m-input-icon--left">
|
|
<input type="text" class="form-control m-input m-input--solid" placeholder="Search..." id="data-rows-search">
|
|
<span class="m-input-icon__icon m-input-icon__icon--left">
|
|
<span><i class="la la-search"></i></span>
|
|
</span>
|
|
</div>
|
|
</div>
|
|
<div class="col-md-4">
|
|
<div class="m-input-icon m-input-icon--left">
|
|
<div class="input-group">
|
|
<select class="form-control m-input" id="rider_list" name="rider_list">
|
|
<option value="">All Riders</option>
|
|
{% for rider in riders %}
|
|
<option value="{{ rider.getID }}">{{ rider.getFirstName ~ ' ' ~ rider.getLastName }} </option>
|
|
{% endfor %}
|
|
</select>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-md-4">
|
|
<div class="m-input-icon m-input-icon--left">
|
|
<div class="input-daterange input-group" id="date-range">
|
|
<input role="presentation" type="text" class="form-control m-input" id="date_start" name="date_start" placeholder="Start date" />
|
|
<div class="input-group-append">
|
|
<span class="input-group-text"><i class="la la-ellipsis-h"></i></span>
|
|
</div>
|
|
<input role="presentation" type="text" class="form-control" id="date_end" name="date_end" placeholder="End date" />
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<!--begin: Datatable -->
|
|
<div id="data-rows"></div>
|
|
<!--end: Datatable -->
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
{% endblock %}
|
|
|
|
{% block scripts %}
|
|
<script>
|
|
$(function() {
|
|
$("#date-range").datepicker({
|
|
orientation: "bottom"
|
|
});
|
|
|
|
var options = {
|
|
data: {
|
|
type: 'remote',
|
|
source: {
|
|
read: {
|
|
url: '{{ url('jo_all_rows') }}',
|
|
method: 'POST'
|
|
}
|
|
},
|
|
saveState: {
|
|
cookie: false,
|
|
webstorage: false
|
|
},
|
|
pageSize: 10,
|
|
serverPaging: true,
|
|
serverFiltering: true,
|
|
serverSorting: true
|
|
},
|
|
rows: {
|
|
beforeTemplate: function (row, data, index) {
|
|
if (data.flag_advance) {
|
|
$(row).addClass('m-table__row--danger');
|
|
}
|
|
},
|
|
afterTemplate: function (row, data, index) {
|
|
// if this row has an incrementing timer, handle the behavior
|
|
const timer = row.find('[data-incrementing]')[0];
|
|
|
|
if (timer) {
|
|
setInterval(() => {
|
|
const dateStart = new moment(data.date_assign, moment.ISO_8601);
|
|
const dateEnd = moment();
|
|
|
|
timer.innerHTML = timeDiff(dateStart, dateEnd);
|
|
}, 1000)
|
|
}
|
|
},
|
|
},
|
|
columns: [
|
|
{
|
|
field: 'id',
|
|
title: 'JO Number'
|
|
},
|
|
{
|
|
field: 'plate_number',
|
|
title: 'Plate #'
|
|
},
|
|
{
|
|
field: 'flag_cust_new',
|
|
title: 'New',
|
|
template: function (row, index, datatable) {
|
|
var tag = '';
|
|
|
|
if (row.flag_cust_new === true) {
|
|
tag = '<span class="m-badge m-badge--success m-badge--wide">Yes</span>';
|
|
} else {
|
|
tag = '<span class="m-badge m-badge--danger m-badge--wide">No</span>';
|
|
}
|
|
|
|
return tag;
|
|
}
|
|
},
|
|
{
|
|
field: 'customer_name',
|
|
title: 'Customer'
|
|
},
|
|
{
|
|
field: 'delivery_address',
|
|
title: 'Customer Area'
|
|
},
|
|
{
|
|
field: 'assigned_hub',
|
|
title: 'Assigned Hub'
|
|
},
|
|
{
|
|
field: 'service_type',
|
|
title: 'Transaction Type'
|
|
},
|
|
{
|
|
field: 'date_schedule',
|
|
title: 'Scheduled Date'
|
|
},
|
|
{
|
|
field: 'status',
|
|
title: 'Status'
|
|
},
|
|
{
|
|
field: 'processor',
|
|
title: 'Dispatcher'
|
|
},
|
|
{
|
|
field: '',
|
|
title: 'Dispatch Time',
|
|
sortable: false,
|
|
searchable: false,
|
|
textAlign: 'right',
|
|
template: function (row, index, datatable) {
|
|
let dateAssign;
|
|
let dateEnd;
|
|
let incrementing = false;
|
|
|
|
// only display timer for these statuses
|
|
const statusesWithTimer = [
|
|
'Assigned',
|
|
'In Transit',
|
|
'In Progress',
|
|
'Completed', // NOTE: completed would be based off the fulfillment time
|
|
];
|
|
|
|
if (row.date_assign && statusesWithTimer.includes(row.status)) {
|
|
dateAssign = new moment(row.date_assign, moment.ISO_8601);
|
|
|
|
// on completed jos, use date_fulfill as end date and do not increment
|
|
if (row.status == 'Completed') {
|
|
if (row.date_fulfill) {
|
|
dateEnd = new moment(row.date_fulfill, moment.ISO_8601);
|
|
}
|
|
} else {
|
|
dateEnd = moment();
|
|
incrementing = true;
|
|
}
|
|
}
|
|
|
|
return dateEnd ? '<span class="m-badge m-badge--wide m--font-boldest ' + (incrementing ? 'm-badge--warning" data-incrementing="1"' : 'm-badge--success"') + '>' + timeDiff(dateAssign, dateEnd) + '</span>' : '-';
|
|
},
|
|
},
|
|
{
|
|
field: 'Actions',
|
|
width: 110,
|
|
title: 'Actions',
|
|
sortable: false,
|
|
overflow: 'visible',
|
|
template: function (row, index, datatable) {
|
|
var actions = '<a href="' + row.meta.update_url + '" class="m-portlet__nav-link btn m-btn m-btn--hover-accent m-btn--icon m-btn--icon-only m-btn--pill btn-edit" title="Edit"><i class="la la-edit"></i></a>';
|
|
actions += '<a href="' + row.meta.view_url + '" class="m-portlet__nav-link btn m-btn m-btn--hover-accent m-btn--icon m-btn--icon-only m-btn--pill btn-edit" title="View"><i class="la la-eye"></i></a>';
|
|
actions += '<a href="' + row.meta.pdf_url + '" class="m-portlet__nav-link btn m-btn m-btn--hover-accent m-btn--icon m-btn--icon-only m-btn--pill btn-edit" title="PDF" target="_blank"><i class="la la-file-o"></i></a>';
|
|
|
|
return actions;
|
|
},
|
|
},
|
|
],
|
|
search: {
|
|
onEnter: false,
|
|
input: $('#data-rows-search'),
|
|
delay: 400
|
|
},
|
|
};
|
|
|
|
var table = $("#data-rows").mDatatable(options);
|
|
|
|
// auto refresh table
|
|
setInterval(function() {
|
|
table.reload();
|
|
}, {{ table_refresh_rate }});
|
|
|
|
$("#rider_list").on("change", function() {
|
|
table.search($(this).val(), "rider");
|
|
});
|
|
|
|
$("#date_start").on("change", function() {
|
|
var date_start = $(this).val();
|
|
var date_end = $("[name='date_end']").val();
|
|
var date_array = [date_start, date_end];
|
|
|
|
table.search(date_array, "schedule_date");
|
|
});
|
|
|
|
$("#date_end").on("change", function() {
|
|
console.log($(this).val());
|
|
|
|
var date_end = $(this).val();
|
|
var date_start = $("[name='date_start']").val();
|
|
var date_array = [date_start, date_end];
|
|
|
|
table.search(date_array, "schedule_date");
|
|
});
|
|
});
|
|
|
|
// get difference in hh:mm:ss format
|
|
const timeDiff = (startDate, endDate) => {
|
|
const seconds = Math.abs(startDate.diff(endDate, 'seconds'));
|
|
|
|
const hh = Math.floor(seconds / 3600).toString().padStart(2, "0");
|
|
const mm = Math.floor((seconds % 3600) / 60).toString().padStart(2, "0");
|
|
const ss = (seconds % 60).toString().padStart(2, "0");
|
|
|
|
return [hh, mm, ss].join(':');
|
|
}
|
|
</script>
|
|
{% endblock %}
|