dev-chiefworks
472 lines
16 KiB
PHP
472 lines
16 KiB
PHP
<div class="panel panel-flat" style="background-color: aliceblue;">
|
|
<div class="panel-body">
|
|
<div class="row">
|
|
<div id="lineoption">
|
|
|
|
</div>
|
|
</div>
|
|
|
|
<div class="row">
|
|
|
|
<div class="col-lg-8">
|
|
<!-- Current server load -->
|
|
<div class="panel">
|
|
<div class="panel-heading">
|
|
<h5>Merged Receipts</h5>
|
|
<div class="row">
|
|
<form name="merged_receipts_form" id="merged-receipts-form" autocomplete="off">
|
|
<div class="form-group row">
|
|
<div class="type">
|
|
<label for="?column?" class="font-weight-bold col-lg-3 col-md-3 col-sm-3 col-xs-3 col-form-label">
|
|
Type
|
|
</label>
|
|
<div class="col-lg-12">
|
|
<?= $acc_email_card ?>
|
|
</div>
|
|
</div>
|
|
<div class="travel_date">
|
|
<label for="start_travel_date" class="font-weight-bold col-lg-6 col-md-6 col-sm-6 col-xs-6 col-form-label">
|
|
Travel Date
|
|
</label>
|
|
<div class="search-by-range">
|
|
<div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
|
|
<input type="search" name="start_travel_date" id="start_travel_date" value="<?= $start_travel_date ?>" class="form-control" />
|
|
</div>
|
|
<div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
|
|
<input type="search" name="end_travel_date" id="end_travel_date" value="<?= $end_travel_date ?>" class="form-control" />
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="cost">
|
|
<label for="start_cost" class="font-weight-bold col-lg-2 col-form-label">
|
|
Cost
|
|
</label>
|
|
<div class="search-by-range">
|
|
<div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
|
|
<input type="search" maxlength="10" name="start_cost" id="start_cost" value="<?= $start_cost ?>" class="form-control" />
|
|
</div>
|
|
<div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
|
|
<input type="search" maxlength="10" name="end_cost" id="end_cost" value="<?= $end_cost ?>" class="form-control" />
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<input type="button" name="search_merged_receipts" id="search-merged-receipts" value="Search" class="btn btn-info" />
|
|
</div>
|
|
</form>
|
|
</div>
|
|
<div class="alert alert-danger" id="print-error-msg" style="display:none">
|
|
<a href="#" class="close">×</a>
|
|
<p id="error-msg"></p>
|
|
</div>
|
|
<div>
|
|
<? if (is_array($pages)) { ?><table>
|
|
<tr>
|
|
<td>Page <?= $page ?> out of <?= $total_pages ?></td>
|
|
<td><?= $pagination_config['full_tag_open'] ?>
|
|
<? foreach ($pages as $key => $val) {
|
|
if ($offset == $val) {
|
|
echo $pagination_config['cur_tag_open'] . $key . $pagination_config['cur_tag_close'];
|
|
} else {
|
|
echo $pagination_config['num_tag_open'] . "<a href='#' onclick=\"viewMemberActionLimitOffset(
|
|
'MERGED',
|
|
${member_id},
|
|
'${limit}',
|
|
'${val}',
|
|
generateParamsFromForm('merged-receipts-form')
|
|
);return false;\">${key}</a>" . $pagination_config['num_tag_close'];
|
|
}
|
|
}
|
|
echo $pagination_config['full_tag_close']; ?></td>
|
|
</tr>
|
|
</table><? } ?>
|
|
</div>
|
|
</div>
|
|
<div class="panel-body">
|
|
<?= $member_merged ?>
|
|
</div>
|
|
</div>
|
|
<!-- /current server load -->
|
|
</div>
|
|
|
|
<div class="col-lg-4">
|
|
<!-- Current server load -->
|
|
<div class="panel">
|
|
<div class="panel-body">
|
|
<canvas id="myChart" style="width:100%; height:400px"></canvas>
|
|
</div>
|
|
</div>
|
|
<!-- /current server load -->
|
|
|
|
<!-- Current server load -->
|
|
<div class="panel">
|
|
<div class="panel-body">
|
|
<canvas id="myChart" style="width:100%; height:400px"></canvas>
|
|
</div>
|
|
</div>
|
|
<!-- /current server load -->
|
|
|
|
</div>
|
|
|
|
</div>
|
|
|
|
</div>
|
|
</div>
|
|
|
|
<?php
|
|
|
|
$c = 0;
|
|
$labelArray = '';
|
|
$valueArray = '';
|
|
foreach ($plot["plot_transpotercount"] as $rr) {
|
|
// echo "{$key} => {$value} ";
|
|
// print_r($rr);
|
|
if ($c > 0) {
|
|
$labelArray .= ',';
|
|
$valueArray .= ',';
|
|
}
|
|
$labelArray .= "'" . $rr['name'] . "'";
|
|
$valueArray .= $rr['count'];
|
|
$c++;
|
|
}
|
|
|
|
$dowL = array('Sun', 'Mon', 'Tue', 'Wed', 'Thurs', 'Fri', 'Sat');
|
|
$c = 0;
|
|
$labelArray2 = '';
|
|
$valueArray2 = '';
|
|
foreach ($plot["plot_dayofweekcount"] as $rr) {
|
|
// echo "{$key} => {$value} ";
|
|
// print_r($rr);
|
|
if ($c > 0) {
|
|
$labelArray2 .= ',';
|
|
$valueArray2 .= ',';
|
|
}
|
|
$labelArray2 .= "'" . $dowL[$rr['dow']] . "'";
|
|
$valueArray2 .= $rr['count'];
|
|
$c++;
|
|
}
|
|
|
|
$dowL = array('Sun', 'Mon', 'Tue', 'Wed', 'Thurs', 'Fri', 'Sat');
|
|
$c = 0;
|
|
$labelArray3 = '';
|
|
$valueArray3 = '';
|
|
foreach ($plot["plot_dayofweekamount"] as $rr) {
|
|
// echo "{$key} => {$value} ";
|
|
// print_r($rr);
|
|
if ($c > 0) {
|
|
$labelArray3 .= ',';
|
|
$valueArray3 .= ',';
|
|
}
|
|
$labelArray3 .= "'" . $dowL[$rr['dow']] . "'";
|
|
$valueArray3 .= $rr['sum'];
|
|
$c++;
|
|
}
|
|
|
|
$c = 0;
|
|
$labelArray4 = '';
|
|
$valueArray4 = '';
|
|
foreach ($plot["plot_dayofweekdistance"] as $rr) {
|
|
// echo "{$key} => {$value} ";
|
|
// print_r($rr);
|
|
if ($c > 0) {
|
|
$labelArray4 .= ',';
|
|
$valueArray4 .= ',';
|
|
}
|
|
$labelArray4 .= "'" . $dowL[$rr['dow']] . "'";
|
|
$valueArray4 .= $rr['sum'];
|
|
$c++;
|
|
}
|
|
|
|
|
|
|
|
//echo $labelArray;
|
|
//$l1Arr = " 'Red', 'Blue', 'Yellow', 'Green', 'Purple', 'Orange' ";
|
|
|
|
?>
|
|
|
|
<script src="/assets/js/plugins/pickers/datepicker.js"></script>
|
|
<script type="text/javascript">
|
|
$(document).ready(function() {
|
|
$('#search-merged-receipts').on('click', function(event) {
|
|
event.preventDefault();
|
|
viewMemberActionLimitOffset(
|
|
'MERGED',
|
|
<?= $member_id ?>,
|
|
'50',
|
|
'0',
|
|
$('#merged-receipts-form').serialize()
|
|
);
|
|
})
|
|
|
|
function generateParamsFromForm(form) {
|
|
return $('#' + form).serialize();
|
|
}
|
|
|
|
$("#start_travel_date").datepicker({
|
|
defaultDate: "+1w",
|
|
changeMonth: true,
|
|
numberOfMonths: 3,
|
|
format: 'yyyy-mm-dd',
|
|
onClose: function(selectedDate) {
|
|
$("#start_travel_date").datepicker("option", "minDate", selectedDate);
|
|
}
|
|
})
|
|
|
|
$("#end_travel_date").datepicker({
|
|
defaultDate: "+1w",
|
|
changeMonth: true,
|
|
numberOfMonths: 3,
|
|
format: 'yyyy-mm-dd',
|
|
onClose: function(selectedDate) {
|
|
$("#end_travel_date").datepicker("option", "maxDate", selectedDate);
|
|
}
|
|
})
|
|
|
|
$('.close').on('click', function() {
|
|
$(this).parent().toggle();
|
|
})
|
|
})
|
|
</script>
|
|
<script type="text/javascript">
|
|
var ctx = document.getElementById("myChart");
|
|
var myChart = new Chart(ctx, {
|
|
type: 'bar',
|
|
data: {
|
|
labels: [<?= $labelArray ?>],
|
|
datasets: [{
|
|
label: 'Frequency by Transport mode',
|
|
data: [<?= $valueArray ?>],
|
|
backgroundColor: [
|
|
'rgba(255, 99, 132, 0.2)',
|
|
'rgba(54, 162, 235, 0.2)',
|
|
'rgba(255, 206, 86, 0.2)',
|
|
'rgba(75, 192, 192, 0.2)',
|
|
'rgba(153, 102, 255, 0.2)',
|
|
'rgba(255, 159, 64, 0.2)'
|
|
],
|
|
borderColor: [
|
|
'rgba(255,99,132,1)',
|
|
'rgba(54, 162, 235, 1)',
|
|
'rgba(255, 206, 86, 1)',
|
|
'rgba(75, 192, 192, 1)',
|
|
'rgba(153, 102, 255, 1)',
|
|
'rgba(255, 159, 64, 1)'
|
|
],
|
|
borderWidth: 1
|
|
}]
|
|
},
|
|
options: {
|
|
scales: {
|
|
yAxes: [{
|
|
ticks: {
|
|
beginAtZero: true
|
|
}
|
|
}]
|
|
}
|
|
}
|
|
});
|
|
|
|
|
|
var ctx1 = document.getElementById("myChartL");
|
|
var myChart = new Chart(ctx1, {
|
|
type: 'bar',
|
|
data: {
|
|
labels: [<?= $labelArray2 ?>],
|
|
datasets: [{
|
|
label: 'Frequency by Day of the Week',
|
|
data: [<?= $valueArray2 ?>],
|
|
backgroundColor: [
|
|
'rgba(255, 99, 132, 0.2)',
|
|
'rgba(54, 162, 235, 0.2)',
|
|
'rgba(255, 206, 86, 0.2)',
|
|
'rgba(75, 192, 192, 0.2)',
|
|
'rgba(153, 102, 255, 0.2)',
|
|
'rgba(255, 159, 64, 0.2)'
|
|
],
|
|
borderColor: [
|
|
'rgba(255,99,132,1)',
|
|
'rgba(54, 162, 235, 1)',
|
|
'rgba(255, 206, 86, 1)',
|
|
'rgba(75, 192, 192, 1)',
|
|
'rgba(153, 102, 255, 1)',
|
|
'rgba(255, 159, 64, 1)'
|
|
],
|
|
borderWidth: 1
|
|
}]
|
|
},
|
|
options: {
|
|
scales: {
|
|
yAxes: [{
|
|
ticks: {
|
|
beginAtZero: true
|
|
}
|
|
}]
|
|
}
|
|
}
|
|
});
|
|
|
|
|
|
var ctx3 = document.getElementById("myChartX");
|
|
var myChart = new Chart(ctx3, {
|
|
type: 'bar',
|
|
data: {
|
|
labels: [<?= $labelArray3 ?>],
|
|
datasets: [{
|
|
label: 'Amount by Day of the Week',
|
|
data: [<?= $valueArray3 ?>],
|
|
backgroundColor: [
|
|
'rgba(255, 99, 132, 0.2)',
|
|
'rgba(54, 162, 235, 0.2)',
|
|
'rgba(255, 206, 86, 0.2)',
|
|
'rgba(75, 192, 192, 0.2)',
|
|
'rgba(153, 102, 255, 0.2)',
|
|
'rgba(255, 159, 64, 0.2)'
|
|
],
|
|
borderColor: [
|
|
'rgba(255,99,132,1)',
|
|
'rgba(54, 162, 235, 1)',
|
|
'rgba(255, 206, 86, 1)',
|
|
'rgba(75, 192, 192, 1)',
|
|
'rgba(153, 102, 255, 1)',
|
|
'rgba(255, 159, 64, 1)'
|
|
],
|
|
borderWidth: 1
|
|
}]
|
|
},
|
|
options: {
|
|
scales: {
|
|
yAxes: [{
|
|
ticks: {
|
|
beginAtZero: true
|
|
}
|
|
}]
|
|
}
|
|
}
|
|
});
|
|
|
|
|
|
var ctx4 = document.getElementById("myChartD");
|
|
var myChart = new Chart(ctx4, {
|
|
type: 'line',
|
|
data: {
|
|
labels: [<?= $labelArray4 ?>],
|
|
datasets: [{
|
|
label: 'Distance by Day of the Week',
|
|
data: [<?= $valueArray4 ?>],
|
|
backgroundColor: [
|
|
'rgba(255, 99, 132, 0.2)',
|
|
'rgba(54, 162, 235, 0.2)',
|
|
'rgba(255, 206, 86, 0.2)',
|
|
'rgba(75, 192, 192, 0.2)',
|
|
'rgba(153, 102, 255, 0.2)',
|
|
'rgba(255, 159, 64, 0.2)'
|
|
],
|
|
borderColor: [
|
|
'rgba(255,99,132,1)',
|
|
'rgba(54, 162, 235, 1)',
|
|
'rgba(255, 206, 86, 1)',
|
|
'rgba(75, 192, 192, 1)',
|
|
'rgba(153, 102, 255, 1)',
|
|
'rgba(255, 159, 64, 1)'
|
|
],
|
|
borderWidth: 1
|
|
}]
|
|
},
|
|
options: {
|
|
scales: {
|
|
yAxes: [{
|
|
ticks: {
|
|
beginAtZero: true
|
|
}
|
|
}]
|
|
}
|
|
}
|
|
});
|
|
|
|
var ctx1 = document.getElementById("scatterChart");
|
|
var scatterChart = new Chart(ctx1, {
|
|
type: 'scatter',
|
|
data: {
|
|
datasets: [{
|
|
label: 'Mode Group By Price',
|
|
data: [{
|
|
x: -10,
|
|
y: 0
|
|
}, {
|
|
x: 0,
|
|
y: 10
|
|
}, {
|
|
x: 10,
|
|
y: 5
|
|
}]
|
|
}]
|
|
},
|
|
options: {
|
|
scales: {
|
|
xAxes: [{
|
|
type: 'linear',
|
|
position: 'bottom'
|
|
}]
|
|
}
|
|
}
|
|
});
|
|
|
|
|
|
var ctx3 = document.getElementById("myPieChart ");
|
|
var myPieChart = new Chart(ctx3, {
|
|
type: 'doughnut',
|
|
data: {
|
|
datasets: [{
|
|
data: [10, 20, 30]
|
|
}],
|
|
labels: [
|
|
'Red',
|
|
'Yellow',
|
|
'Blue'
|
|
]
|
|
},
|
|
options: {
|
|
|
|
}
|
|
});
|
|
|
|
function viewMemberActionLimitOffset(action_name, member_id, limit, offset, params) {
|
|
$('#transp_detail').html('Processing...');
|
|
$('#acc' + member_id).prop('disabled', true);
|
|
$.ajax({
|
|
url: "/member/viewMemberAction?proc=PROCESS&action_name=" + action_name +
|
|
"&member_id=" + member_id +
|
|
"&limit=" + limit +
|
|
"&offset=" + offset +
|
|
'&' + params
|
|
}).done(function(data) {
|
|
$('#transp_detail').html(data);
|
|
$('#acc' + member_id).prop('disabled', false);
|
|
});
|
|
}
|
|
|
|
function generateParamsFromForm(form) {
|
|
return $('#' + form).serialize();
|
|
}
|
|
</script>
|
|
|
|
<style>
|
|
#merged-receipts-form .form-group {
|
|
display: flex;
|
|
align-items: flex-end;
|
|
}
|
|
|
|
.travel_date,
|
|
.cost {
|
|
display: flex;
|
|
flex-direction: column;
|
|
}
|
|
|
|
.search-by-range {
|
|
display: flex;
|
|
align-items: flex-end;
|
|
}
|
|
|
|
.search-by-range div {
|
|
padding: 1px;
|
|
}
|
|
</style>
|