// edvcd_datatables.js muss vor edvcd.datatables.js.php stehen var dt_labels = de_labels; /** * Vordefinierte Tabellen */ var datatable_predefined = { "ProcesssTable" : { "autoWidth": true, "language": jQuery.extend(true, {}, dt_labels, {'sSearch':'Verfahren suchen:'}), "serverSide": true, "dom" : 'frltip', "buttons" : [], "processing": true, "pagingType": "full_numbers", // "bootstrap", "full_numbers", "simple_numbers", "paging": true, "searchDelay": 1000, "searching": true, "ordering": true, "order": [[2, "asc"]], "has_editable": false, "pageLength": 10, "ajax": {"url": "https://inso2.grub-brugger.de/?app=model_list&cls=Process&datatable=1&tableid=ProcesssTable&t=1795112236", "data": ajaxDataPlusFiltersFor('Process'), "type" : "POST", "complete" : function(data, status) { // consoleLog("datatable-complete", data, status); }, // wenn hier success behandelt wird, kommt der dataSrc nicht und wir bekommen keine Daten "error": function(transport) { handleError(transport, 'Process'); }, "dataSrc": function(data) { $waiting.hide(); // consoleLog("dataSrc-loadModelTable(Process):", data); if (data.errMsgCode) { dlg_alert("Serverfehler Process", JSON.stringify(data)); data.data = {}; } return data.data; } }, "rowCallback": function(row, data) {}, "columns" : [ {"name" : "id", "searchable": false}, {"name" : "getEditHtml()", "searchable": false, "orderable": false, "width":"100px"}, {"name" : "showDebitorStr()","title" : "Schuldner"},{"name" : "showTrusteeStr()","title" : "Verwalter"},{"name" : "showCourtStr()","title" : "Gericht"},{"name" : "showDownloadListBeschluesse()","title" : "Beschlüsse"} ], "_class": "Process" , "_fields": {"Schuldner":"showDebitorStr()","Verwalter":"showTrusteeStr()","Gericht":"showCourtStr()","Beschl\u00fcsse":"showDownloadListBeschluesse()"} , "_dom": "frltip" , "_filters": [{"filter":"hidefinished","type":"checkbox","value":"1","title2":"aufgehobene Verfahren ausblenden"}] , "_filters_complete": "setFiltersLabelClick" , "_labels": "{'sSearch':'Verfahren suchen:'}" , "_dialogWidth": 550 , "_newText": "Neues Verfahren" , "_orderedBy": "showDebitorStr()" , "_buttonbarType": "assist" } , "RegistrationsTable" : { "autoWidth": true, "language": jQuery.extend(true, {}, dt_labels, {}), "serverSide": true, "dom" : 'lfrtip', "buttons" : ["pdf"], "processing": true, "pagingType": "full_numbers", // "bootstrap", "full_numbers", "simple_numbers", "paging": true, "searchDelay": 1000, "searching": true, "ordering": true, "order": [[2, "asc"]], "has_editable": false, "pageLength": 10, "ajax": {"url": "https://inso2.grub-brugger.de/?app=model_list&cls=Registration&datatable=1&tableid=RegistrationsTable&t=1795112236", "data": ajaxDataPlusFiltersFor('Registration'), "type" : "POST", "complete" : function(data, status) { // consoleLog("datatable-complete", data, status); }, // wenn hier success behandelt wird, kommt der dataSrc nicht und wir bekommen keine Daten "error": function(transport) { handleError(transport, 'Registration'); }, "dataSrc": function(data) { $waiting.hide(); // consoleLog("dataSrc-loadModelTable(Registration):", data); if (data.errMsgCode) { dlg_alert("Serverfehler Registration", JSON.stringify(data)); data.data = {}; } return data.data; } }, "rowCallback": function(row, data) {}, "columns" : [ {"name" : "id", "searchable": false}, {"name" : "getEditHtml()", "searchable": false, "orderable": false, "width":"100px"}, {"name" : "showCreditorStr()","title" : "Gläubiger"},{"name" : "showCreditorAgentStr()","title" : "Vertreter"},{"name" : "showCreditReason()","title" : "Schuldgrund"},{"name" : "showCreditorDemand()","title" : "Forderung"} ], "_class": "Registration" , "_fields": {"Gl\u00e4ubiger":"showCreditorStr()","Vertreter":"showCreditorAgentStr()","Schuldgrund":"showCreditReason()","Forderung":"showCreditorDemand()"} , "_dialogWidth": 850 , "_newText": "Neue Anmeldung" , "_orderedBy": "showCreditorStr()" , "_orderedByDir": "asc" , "_buttonbarType": "assist" , "_cond": "`creditor`.`createduid` = 0" , "_dom": "lfrtip" , "_buttons": ["pdf"] } , "DemandsTable" : { "autoWidth": true, "language": jQuery.extend(true, {}, dt_labels, {}), "serverSide": true, "dom" : 'lfrtip', "buttons" : [], "processing": true, "pagingType": "full_numbers", // "bootstrap", "full_numbers", "simple_numbers", "paging": true, "searchDelay": 1000, "searching": true, "ordering": true, "order": [[2, "asc"]], "has_editable": false, "pageLength": 10, "ajax": {"url": "https://inso2.grub-brugger.de/?app=model_list&cls=Demand&datatable=1&tableid=DemandsTable&t=1795112236", "data": ajaxDataPlusFiltersFor('Demand'), "type" : "POST", "complete" : function(data, status) { // consoleLog("datatable-complete", data, status); }, // wenn hier success behandelt wird, kommt der dataSrc nicht und wir bekommen keine Daten "error": function(transport) { handleError(transport, 'Demand'); }, "dataSrc": function(data) { $waiting.hide(); // consoleLog("dataSrc-loadModelTable(Demand):", data); if (data.errMsgCode) { dlg_alert("Serverfehler Demand", JSON.stringify(data)); data.data = {}; } return data.data; } }, "rowCallback": function(row, data) {}, "columns" : [ {"name" : "id", "searchable": false}, {"name" : "getEditHtml()", "searchable": false, "orderable": false, "width":"100px"}, {"name" : "showCreditorStr()","title" : "Gläubiger"},{"name" : "showCreditorAgentStr()","title" : "Gläubigervertreter"},{"name" : "showCreditReason()","title" : "Schuldgrund"},{"name" : "showCreditorDemand()","title" : "Forderung"} ], "_class": "Demand" , "_fields": {"Gl\u00e4ubiger":"showCreditorStr()","Gl\u00e4ubigervertreter":"showCreditorAgentStr()","Schuldgrund":"showCreditReason()","Forderung":"showCreditorDemand()"} , "_dialogWidth": 850 , "_newText": "Neue Forderung" , "_orderedBy": "showCreditorStr()" , "_orderedByDir": "asc" , "_buttonbarType": "assist" } , "AttachmentsTable" : { "autoWidth": true, "language": jQuery.extend(true, {}, dt_labels, {}), "serverSide": true, "dom" : 'lfrtip', "buttons" : [], "processing": true, "pagingType": "full_numbers", // "bootstrap", "full_numbers", "simple_numbers", "paging": true, "searchDelay": 1000, "searching": true, "ordering": true, "order": [[2, "asc"],[3, "desc"]], "has_editable": false, "pageLength": 10, "ajax": {"url": "https://inso2.grub-brugger.de/?app=model_list&cls=Attachment&datatable=1&tableid=AttachmentsTable&t=1795112236", "data": ajaxDataPlusFiltersFor('Attachment'), "type" : "POST", "complete" : function(data, status) { // consoleLog("datatable-complete", data, status); }, // wenn hier success behandelt wird, kommt der dataSrc nicht und wir bekommen keine Daten "error": function(transport) { handleError(transport, 'Attachment'); }, "dataSrc": function(data) { $waiting.hide(); // consoleLog("dataSrc-loadModelTable(Attachment):", data); if (data.errMsgCode) { dlg_alert("Serverfehler Attachment", JSON.stringify(data)); data.data = {}; } return data.data; } }, "rowCallback": function(row, data) {}, "columns" : [ {"name" : "id", "searchable": false}, {"name" : "getEditHtml()", "searchable": false, "orderable": false, "width":"100px"}, {"name" : "col_display_type()","title" : "Typ"},{"name" : "created","title" : "created"},{"name" : "attachment_name","title" : "Name"},{"name" : "attachment_comment","title" : "Bemerkung"} ], "_class": "Attachment" , "_fields": {"Typ":"col_display_type()","created":"created","Name":"attachment_name","Bemerkung":"attachment_comment"} , "_fields_data": {"created":{"visible":"false"}} , "_filters": [{"filter":"attachment_type[]","title2":"Beschl\u00fcsse","type":"checkbox","value":"B","label2Class":"attachment_filter_labeldesign btn btn-default btn-sm"},{"filter":"attachment_type[]","title2":"Sachst\u00e4nde","type":"checkbox","value":"S","label2Class":"attachment_filter_labeldesign btn btn-default btn-sm"},{"filter":"attachment_type[]","title2":"Berichte","type":"checkbox","value":"R","label2Class":"attachment_filter_labeldesign btn btn-default btn-sm"},{"filter":"attachment_type[]","title2":"Presseerkl\u00e4rungen","type":"checkbox","value":"P","label2Class":"attachment_filter_labeldesign btn btn-default btn-sm"},{"title2":"Bitte auswählen:<\/b>"}] , "_filters_complete": "setFiltersLabelClick" , "_dialogWidth": 550 , "_newText": "Neuer Anhang" , "_orderedBy": ["col_display_type()","created"] , "_orderedByDir": ["asc","desc"] } , "CreditReasonsTable" : { "autoWidth": true, "language": jQuery.extend(true, {}, dt_labels, {}), "serverSide": true, "dom" : 'frltip', "buttons" : [], "processing": true, "pagingType": "full_numbers", // "bootstrap", "full_numbers", "simple_numbers", "paging": true, "searchDelay": 1000, "searching": true, "ordering": true, "order": [[2, "asc"]], "has_editable": false, "pageLength": 50, "ajax": {"url": "https://inso2.grub-brugger.de/?app=model_list&cls=CreditReason&datatable=1&tableid=CreditReasonsTable&t=1795112236", "data": ajaxDataPlusFiltersFor('CreditReason'), "type" : "POST", "complete" : function(data, status) { // consoleLog("datatable-complete", data, status); }, // wenn hier success behandelt wird, kommt der dataSrc nicht und wir bekommen keine Daten "error": function(transport) { handleError(transport, 'CreditReason'); }, "dataSrc": function(data) { $waiting.hide(); // consoleLog("dataSrc-loadModelTable(CreditReason):", data); if (data.errMsgCode) { dlg_alert("Serverfehler CreditReason", JSON.stringify(data)); data.data = {}; } return data.data; } }, "rowCallback": function(row, data) {}, "columns" : [ {"name" : "id", "searchable": false}, {"name" : "getEditHtml()", "searchable": false, "orderable": false, "width":"100px"}, {"name" : "credit_reason_name","title" : "Bezeichnung"},{"name" : "getUseCount()","title" : "Verwendung"} ], "_class": "CreditReason" , "_fields": {"Bezeichnung":"credit_reason_name","Verwendung":"getUseCount()"} , "_dom": "frltip" , "_dialogWidth": 640 , "_pageLength": 50 , "_newText": "Neuer Schuldgrund" , "_orderedBy": "credit_reason_name" } , "UsersTable" : { "autoWidth": true, "language": jQuery.extend(true, {}, dt_labels, {}), "serverSide": true, "dom" : 'frltip', "buttons" : [], "processing": true, "pagingType": "full_numbers", // "bootstrap", "full_numbers", "simple_numbers", "paging": true, "searchDelay": 1000, "searching": true, "ordering": true, "order": [[2, "asc"]], "has_editable": false, "pageLength": 10, "ajax": {"url": "https://inso2.grub-brugger.de/?app=model_list&cls=User&datatable=1&tableid=UsersTable&t=1795112236", "data": ajaxDataPlusFiltersFor('User'), "type" : "POST", "complete" : function(data, status) { // consoleLog("datatable-complete", data, status); }, // wenn hier success behandelt wird, kommt der dataSrc nicht und wir bekommen keine Daten "error": function(transport) { handleError(transport, 'User'); }, "dataSrc": function(data) { $waiting.hide(); // consoleLog("dataSrc-loadModelTable(User):", data); if (data.errMsgCode) { dlg_alert("Serverfehler User", JSON.stringify(data)); data.data = {}; } return data.data; } }, "rowCallback": function(row, data) {}, "columns" : [ {"name" : "id", "searchable": false}, {"name" : "getEditHtml()", "searchable": false, "orderable": false, "width":"100px"}, {"name" : "getFullname()","title" : "Name"},{"name" : "username","title" : "Benutzername"},{"name" : "getRoleName()","title" : "Benutzerrolle"},{"name" : "email","title" : "E-Mail"} ], "_class": "User" , "_fields": {"Name":"getFullname()","Benutzername":"username","Benutzerrolle":"getRoleName()","E-Mail":"email"} , "_dom": "frltip" , "_dialogWidth": 640 , "_newText": "Neuer Benutzer" , "_orderedBy": "getFullname()" , "_cond": "`users`.`role` in ('admin','admin+','grub')" } };