var controleAmDtTable;
var controleAmDtEditor;
$(document).ready(function () {
InitTable();
})
function InitTable() {
controleAmDtTable = $('#controleArticleDtAmTable').DataTable({
dom: 'rt',
paging: false,
ordering: false,
fixedHeader: true,
orderCellsTop: true,
scrollCollapse: true,
scrollY: '50vh',
autoWidth: true,
initComplete: function (settings, json) {
var api = this.api();
api.columns
.adjust().draw() //.responsive.recalc();
//api.draw();
},
columns: [
{
data: 'GeneratedId',
name: 'GeneratedId',
visible: false
},
{
data: 'Cote',
name: 'Cote'
},
{
data: 'Description',
name: 'Description',
visible: false
},
{
data: 'ValeureNominale',
name: 'ValeureNominale',
render: function (data, type, row) {
if (type === 'display') {
if (row.ntailprelev == 0 && (row.ValeurBoolean == 0 || row.CoValNomVisible == 1)) {
return '+' + data;
} else {
return row.Description;
}
}
return data;
}
},
{
data: 'ValeurMin',
name: 'ValeurMin',
render: function (data, type, row) {
if (type === 'display') {
if (row.ntailprelev == 0 && (row.ValeurBoolean == 0 || row.CoValNomVisible == 1)) {
return data;
} else {
return '';
}
}
return data;
}
},
{
data: 'ValeurMax',
name: 'ValeurMax',
render: function (data, type, row) {
if (type === 'display') {
if (row.ntailprelev == 0 && (row.ValeurBoolean == 0 || row.CoValNomVisible == 1)) {
return data;
} else {
return '';
}
}
return data;
}
},
{
data: 'Valeur1',
name: 'Valeur1',
render: function (data, type, row) {
if (type === 'display') {
if (row.ValeurBoolean == 1 && (row.TailPrelev >= (row.ntailprelev + 1))) {
switch (row.CoValeur1) {
case '0':
return '
nr
';
case '1':
return 'ok
';
case '2':
return 'nok
';
default:
return data;
}
} else {
return ``;
}
}
return data;
}
},
{
data: 'CoValeur1',
name: 'CoValeur1',
visible: false
},
{
data: 'Valeur2',
name: 'Valeur2',
render: function (data, type, row) {
if (type === 'display') {
if (row.ValeurBoolean == 1 && (row.TailPrelev >= (row.ntailprelev + 2))) {
switch (row.CoValeur2) {
case '0':
return 'nr
';
case '1':
return 'ok
';
case '2':
return 'nok
';
default:
return data;
}
} else {
return ``;
}
}
return data;
}
},
{
data: 'CoValeur2',
name: 'CoValeur2',
visible: false
},
{
data: 'Valeur3',
name: 'Valeur3',
render: function (data, type, row) {
if (type === 'display') {
if (row.ValeurBoolean == 1 && (row.TailPrelev >= (row.ntailprelev + 3))) {
switch (row.CoValeur3) {
case '0':
return 'nr
';
case '1':
return 'ok
';
case '2':
return 'nok
';
default:
return data;
}
} else {
return ``;
}
}
return data;
}
},
{
data: 'CoValeur3',
name: 'CoValeur3',
visible: false
},
{
data: 'Valeur4',
name: 'Valeur4',
render: function (data, type, row) {
if (type === 'display') {
if (row.ValeurBoolean == 1 && (row.TailPrelev >= (row.ntailprelev + 4))) {
switch (row.CoValeur4) {
case '0':
return 'nr
';
case '1':
return 'ok
';
case '2':
return 'nok
';
default:
return data;
}
} else {
return ``;
}
}
return data;
}
},
{
data: 'CoValeur4',
name: 'CoValeur4',
visible: false
},
{
data: 'Valeur5',
name: 'Valeur5',
render: function (data, type, row) {
if (type === 'display') {
if (row.ValeurBoolean == 1 && (row.TailPrelev >= (row.ntailprelev + 5))) {
switch (row.CoValeur5) {
case '0':
return 'nr
';
case '1':
return 'ok
';
case '2':
return 'nok
';
default:
return data;
}
} else {
return ``;
}
}
return data;
}
},
{
data: 'CoValeur5',
name: 'CoValeur5',
visible: false
},
{
data: 'Valeur6',
name: 'Valeur6',
render: function (data, type, row) {
if (type === 'display') {
if (row.ValeurBoolean == 1 && (row.TailPrelev >= (row.ntailprelev + 6))) {
switch (row.CoValeur6) {
case '0':
return 'nr
';
case '1':
return 'ok
';
case '2':
return 'nok
';
default:
return data;
}
} else {
return ``;
}
}
return data;
}
},
{
data: 'CoValeur6',
name: 'CoValeur6',
visible: false
},
{
data: 'Valeur7',
name: 'Valeur7',
render: function (data, type, row) {
if (type === 'display') {
if (row.ValeurBoolean == 1 && (row.TailPrelev >= (row.ntailprelev + 7))) {
switch (row.CoValeur7) {
case '0':
return 'nr
';
case '1':
return 'ok
';
case '2':
return 'nok
';
default:
return data;
}
} else {
return ``;
}
}
return data;
}
},
{
data: 'CoValeur7',
name: 'CoValeur7',
visible: false
},
{
data: 'Valeur8',
name: 'Valeur8',
render: function (data, type, row) {
if (type === 'display') {
if (row.ValeurBoolean == 1 && (row.TailPrelev >= (row.ntailprelev + 8))) {
switch (row.CoValeur8) {
case '0':
return 'nr
';
case '1':
return 'ok
';
case '2':
return 'nok
';
default:
return data;
}
} else {
return ``;
}
}
return data;
}
},
{
data: 'CoValeur8',
name: 'CoValeur8',
visible: false
},
{
data: 'Valeur9',
name: 'Valeur9',
render: function (data, type, row) {
if (type === 'display') {
if (row.ValeurBoolean == 1 && (row.TailPrelev >= (row.ntailprelev + 9))) {
switch (row.CoValeur9) {
case '0':
return 'nr
';
case '1':
return 'ok
';
case '2':
return 'nok
';
default:
return data;
}
} else {
return ``;
}
}
return data;
}
},
{
data: 'CoValeur9',
name: 'CoValeur9',
visible: false
},
{
data: 'Valeur10',
name: 'Valeur10',
render: function (data, type, row) {
if (type === 'display') {
if (row.ValeurBoolean == 1 && (row.TailPrelev >= (row.ntailprelev + 10))) {
switch (row.CoValeur10) {
case '0':
return 'nr
';
case '1':
return 'ok
';
case '2':
return 'nok
';
default:
return data;
}
} else {
return ``;
}
}
return data;
}
},
{
data: 'CoValeur10',
name: 'CoValeur10',
visible: false
},
{
data: '',
name: 'Moyenne',
},
{
data: 'Decision',
name: 'Decision',
render: function (data, type, row) {
if (type === 'display') {
return ``
}
return data;
}
},
{
data: 'TailPrelev',
name: 'TailPrelev',
visible: false
},
{
data: 'ntailprelev',
name: 'ntailprelev',
visible: false
},
{
data: 'ValeurBoolean',
name: 'ValeurBoolean',
visible: false
},
{
data: 'CoValNomVisible',
name: 'CoValNomVisible',
visible: false
}
],
initComplete: function (settings, json) {
$('input[type="checkbox"]').each(function () {
if ($(this).hasClass('indeterminate')) {
$(this).prop("indeterminate", true);
}
})
}
})
controleAmDtEditor = new $.fn.dataTable.Editor({
table: '#controleArticleDtAmTable',
idSrc: 'GeneratedId',
fields: [
{
label: 'Valeur1',
name: 'Valeur1',
type: "checkbox"
},
{
label: 'Valeur2',
name: 'Valeur2',
type: 'checkbox'
},
{
label: 'Valeur3',
name: 'Valeur3'
},
{
label: 'Valeur4',
name: 'Valeur4'
},
{
label: 'Valeur5',
name: 'Valeur5'
},
{
label: 'Valeur6',
name: 'Valeur6'
},
{
label: 'Valeur7',
name: 'Valeur7'
},
{
label: 'Valeur8',
name: 'Valeur8'
},
{
label: 'Valeur9',
name: 'Valeur9'
},
{
label: 'Valeur10',
name: 'Valeur10'
},
{
label: 'CoValeur1',
name: 'CoValeur1'
},
{
label: 'CoValeur2',
name: 'CoValeur2'
},
{
label: 'CoValeur3',
name: 'CoValeur3'
},
{
label: 'CoValeur4',
name: 'CoValeur4'
},
{
label: 'CoValeur5',
name: 'CoValeur5'
},
{
label: 'CoValeur6',
name: 'CoValeur6'
},
{
label: 'CoValeur7',
name: 'CoValeur7'
},
{
label: 'CoValeur8',
name: 'CoValeur8'
},
{
label: 'CoValeur9',
name: 'CoValeur9'
},
{
label: 'CoValeur10',
name: 'CoValeur10'
},
{
label: 'Decision',
name: 'Decision',
type: 'select',
options: [
{ label: 'NR', value: null },
{ label: 'OK', value: 'O' },
{ label: 'NOK', value: 'N' },
{ label: 'Accepté', value: 'A' }
]
}
]
})
controleAmDtEditor.on('preSubmit', function (e, data, action) {
console.log("e", e, "data", data, "action", action)
})
$('#controleArticleDtAmTable').on('click', 'tbody td:not(:nth-child(-n+4))', function (e) {
controleAmDtEditor.inline(this, { onBlur: 'submit' });
})
}