simple standalone is not that simple
simple standalone is not that simple
Link to test case: https://ficos.nl/standalone/account.php
Debugger code (debug.datatables.net): ujozic
Error messages shown: none
Description of problem:
I managed to load the data of 1 specific record. This data should be edited but the editor doesn't get the data. Data will be created in a new record and I want only to be able to edit the existing record.
$(document).ready(function () {
function format_data(data) {
var id = data.DT_RowId;
$(
'<div data-editor-id="'+id+'">'+
'<dl>'+
'<dt>bankrekening:</dt>'+
'<dd data-editor-field="adm_client.bank">'+data.bank+'</dd>'+
'<dt>sjabloon:</dt>'+
'<dd data-editor-field="adm_client.sjabloon">'+data.sjabloon+'</dd>'+
'<dt>regels:</dt>'+
'<dd data-editor-field="adm_client.rownr">' + data.rownr + '</dd>' +
'</dl>'+
'</div>'
).appendTo('#instellingen');
}
const config_editor = new DataTable.Editor({
ajax: {
url: 'php/standalone.php',
type: "post",
data: function (d) {
d.dossier = 1840; //curDossier;
}
},
fields: [
{ label: 'client', name: 'clientID' },
{ label: 'bankrekening', name: 'bank' },
{
label: 'aantal regels:',
name: 'rownr',
type: 'select',
options: [
{ label: '5', value: '5' },
{ label: '6', value: '6' },
{ label: '7', value: '7' },
{ label: '8', value: '8' },
{ label: '9', value: '9' },
{ label: '10', value: '10' },
{ label: '11', value: '11' },
{ label: '12', value: '12' },
{ label: 'alles', value: 'all' },
]
},
{ label: 'sjabloon', name: 'sjabloon' }
]
});
// Load the initial data and display
$.ajax({
url: 'php/standalone.php',
success: function (json) {
data = JSON.parse(json);
format_data(data.data[0]);
}
});
$('#edit').on('click', function () {
config_editor
.buttons({
label: 'Save',
fn: function () {
this.submit();
}
})
.edit();
});
});
I am using Foundation but I don't think the problem is there.
Basically I used the examples (simple standalone and collection editor).
Any ideas?
Jan
Answers
Hi Jan,
What does
standalone,phpcontain?Also, you aren't passing anything to the
edit()method. You need to pass the id to edit - in this case justid, which should help a bit.Allan
Normally I use dataTables to do that (passing the id), but there is no dataTables present, so I guess I need to pass it in
?
or do I need to add a table to the editor?
changed account.php:
added in config_editor:
which results in an error: s.settings()[0] is undefined
I am missing something here.
Jan
Hi Jan,
Many thanks for the details. You don't need a DataTable, and you shouldn't reference one since you don't have one. But you do need to specify the primary key id that is being edited. Consider this example - on line 60 in the code shown below the table, I've used:
In your case:
I think should work, although I could confirm that on your page due to the use of
table.Allan
In your example (line 6-9) you define the div:
I removed the table and the reference to it.
The function format_data (in your example: createPanel is changed to:
but now I get an error: Could not find an element with
data-editor-idoridof: row_20I can't see why I get this error as the structure is the same.
Furthermore: I need the editrecord to have the actual record, but it is still empty. Assigning "20" to edit() saves the record for that id, but I need to have the record's ID here as it might change for another record (curDossier, which is not active in the example)
Jan.
I have never managed to get Standalone Editing running for my purpose. My simple workaround is:
- set up a "dummy" datatable with just one arbitrary column and hide that data table simply by adding class "hidden" in its HTML
I was asking myself why I could never make it work. I think it means something different than what I think it should mean. The basic use case for me is editing additional data that don't directly belong to the primary data table that is displayed to the user: The user should be able to edit those data using a button belonging to the primary table, but those data shouldn't be displayed in its own data table.
That doesn't seem to be the use case that Allan has in mind for Standalone Editing.
Hi Jan,
Thanks for updating the page. With a bit of debugging I think I've realised what is going wrong.
The
dddefines the fields like this:However, the Javascript defines it as:
Notice the difference in the name:
bankvadm_client.bank.Remove the
adm_client.from theddelements and it should then work.Allan