school-administrarion/assets/plugin/editable-table/numeric-input-example.js

49 lines
1.3 KiB
JavaScript
Executable File

/* global $ */
/* this is an example for validation and change events */
$.fn.numericInputExample = function () {
'use strict';
var element = $(this),
footer = element.find('tfoot tr'),
dataRows = element.find('tbody tr'),
initialTotal = function () {
var column, total;
for (column = 1; column < footer.children().size(); column++) {
total = 0;
dataRows.each(function () {
var row = $(this);
total += parseFloat(row.children().eq(column).text());
});
footer.children().eq(column).text(total);
};
};
element.find('td').on('change', function (evt) {
var cell = $(this),
column = cell.index(),
total = 0;
if (column === 0) {
return;
}
element.find('tbody tr').each(function () {
var row = $(this);
total += parseFloat(row.children().eq(column).text());
});
if (column === 1 && total > 5000) {
$('.alert').show();
return false; // changes can be rejected
} else {
$('.alert').hide();
footer.children().eq(column).text(total);
}
}).on('validate', function (evt, value) {
var cell = $(this),
column = cell.index();
if (column === 0) {
return !!value && value.trim().length > 0;
} else {
return !isNaN(parseFloat(value)) && isFinite(value);
}
});
initialTotal();
return this;
};