In every database application we want to have the possibility do do someting with our data. 

The buttons setting should be enable you to create in a standardized way.

Parameters:

  • Form
  • Min. Userrole
  • Type
  • Title
  • Tooltip-Text
  • fa-icon
  • CSS Class
  • Action
  • Payload
  • Custom JS-Function
  • Sort Order

Form:

If an button click should do an create or edit action, we have to open a form. Here you can define which one. This enable you to use different forms for different actions if the data is mapped from the table to both forms.

Types:

  • Default
    Display the Button above the table like create buttons or custom actions
  • Form
    Display the button in the row, so the button relates to the data row, like edit or delete an entry.
    This also works for subtables
  • FormDataTable Specific
  • header-csv – maps to the datatable.net csv export setting
  • header-pdf – maps to the datatable.net csv export setting
  • header-excel – maps to the datatable.net excel export setting

Scope

  • GLOBAL – HEADER
    • Display Button in Form TOP or DataTable TOP
  • GLOBAL – FOOTER
    • Display Button in Form Footer
  • LOCAL
    • Display Button in DataTable Row for each Entry

Title

Button-Title

Tooltip-Text

Button tooltip text

fa-icon:

We include font-awesome as our default icon libaray, so you can insert here te font awesome class.

CSS Class:

Here you can provide the class for the buttons. We inclode the bootstrap library, so you could use bootstrap classes like btn btn-primary …

Actions:

To define which function should be called after the button click, we provide a default interface to register actions. See Action section.

Actions:

To define which function should be called after the button click, we provide a default interface to register actions. See Action section.

Payload: (DEPRECATED)

In some special cases we want to provide the action more information. Here you could add data in json style like follows:

"identifier":"pdf_a", "filename":"export.pdf"

Example: Option: onclick with code

jQuery('###datatable_identifier##').DataTable().ajax.reload();

Sort Order:

This defines the order of the displayed buttons

Options:

  • add_entity_to_update : true –  Updates Datatables with Entity after Submit

  • add_parent_entity_to_update : true – Updates Datatables with Parent Entity after Submit

  • class_column
    This allows referring to a select field of the query, for example, if the query result has a column named calculated_css_class, then this option can be used to assign the value of that class.
    key: class_column, valuecalculated_css_class

  • parent_form_identifier

  • tooltip_column

    • key: tooltip_column, value: column_name
    • The same principle as class_column is applied here.
  • id_column

    • Default ID Column is the row id. If you what to use another id column you can set it:
      • key: id_column, value: column_name
  • create_as_entity