| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| web:kg [2017-05-01 11:52] – [Table] admin | web:kg [2023-10-26 20:04] (current) – external edit 127.0.0.1 |
|---|
| <div class="alert alert-info" role="alert" id="loading-text"> <strong>Gegevens worden geladen, even geduld ...</strong> </div> | <div class="alert alert-info" role="alert" id="loading-text"> <strong>Gegevens worden geladen, even geduld ...</strong> </div> |
| <?php | <?php |
| $tablefields[1]['algemeen']['id*'] = array('type'=>'modal', 'col'=>'col-12 col-sm-4', 'label_extra'=>'kort label, zonder spaties', 'placeholder'=>'Vul een ID in', 'attributes'=>array('pattern'=>'^[a-zA-Z0-9_]+$'),'validation'=>array('notempty-message'=>'Je moet een ID invullen','regexp-message'=>'ID mag geen spaties of speciale tekens bevatten: gebruik enkel letters, cijfers en underscore _')); | $recfields[1]['algemeen']['id*'] = array('type'=>'modal', 'th-title'=>'title veld voor th','col'=>'col-12 col-sm-4', 'label-extra'=>'kort label, zonder spaties', 'placeholder'=>'Vul een ID in', 'attributes'=>array('pattern'=>'^[a-zA-Z0-9_]+$'),'validation'=>array('notempty-message'=>'Je moet een ID invullen','regexp-message'=>'ID mag geen spaties of speciale tekens bevatten: gebruik enkel letters, cijfers en underscore _')); |
| $tablefields[1]['algemeen']['omschrijving*'] = array('thdata'=>array('orderable'=>'false'), 'col'=>'col-12 col-sm-8', 'label_extra'=>'langere omschrijving, mag spaties bevatten', 'placeholder'=>'Vul een omschrijving voor de reis in'); | $recfields[1]['algemeen']['omschrijving*'] = array('thdata'=>array('orderable'=>'false'), 'col'=>'col-12 col-sm-8', 'label_extra'=>'langere omschrijving, mag spaties bevatten', 'placeholder'=>'Vul een omschrijving voor de reis in'); |
| $tablefields[1]['algemeen']['startdatum'] = array('type'=>'daterange_start','data'=>array('daterange_stopid'=>'reis_einddatum'), 'schrijf_datum_options'=>'dag_kort,maand_voluit', 'col'=>'col-6 col-md-4', 'placeholder'=>'Startdatum'); | $recfields[1]['algemeen']['startdatum'] = array('type'=>'daterange_start','data'=>array('daterange_stopid'=>'reis_einddatum'), 'schrijf_datum_options'=>'dag_kort,maand_voluit', 'col'=>'col-6 col-md-4', 'placeholder'=>'Startdatum'); |
| $tablefields[1]['algemeen']['einddatum'] = array('type'=>'daterange_stop', 'col'=>'col-6 col-md-4', 'placeholder'=>'Einddatum'); | $recfields[1]['algemeen']['einddatum'] = array('type'=>'daterange_stop', 'col'=>'col-6 col-md-4', 'placeholder'=>'Einddatum'); |
| $tablefields[1]['munt']['munteenheid'] = array('col'=>'col-8 col-sm-4 col-lg-3', 'label_extra'=>'(<a href="http://www.xe.com/symbols.php" target="_blank">lijst</a>)', 'placeholder'=>'EUR'); | $recfields[1]['munt']['munteenheid'] = array('col'=>'col-8 col-sm-4 col-lg-3', 'label_extra'=>'(<a href="http://www.xe.com/symbols.php" target="_blank">lijst</a>)', 'placeholder'=>'EUR'); |
| $tablefields[1]['munt']['muntsymbool'] = array('col'=>'col-4 col-sm-2 col-lg-2', 'label'=>'symbool'); | $recfields[1]['munt']['muntsymbool'] = array('col'=>'col-4 col-sm-2 col-lg-2', 'label'=>'symbool'); |
| $tablefields[1]['munt']['wisselkoers'] = array('type'=>'float' ,'col'=>'col-12 col-sm-6 col-lg-4', 'placeholder'=>'1.00'); | $recfields[1]['munt']['wisselkoers'] = array('type'=>'float' ,'col'=>'col-12 col-sm-6 col-lg-4', 'placeholder'=>'1.00'); |
| $tableoptions[1]['data'] = array('order'=>'[[3,"desc"]]'); | $tableoptions[1] = array('data'=>array('order'=>'[[3,"desc"]]'); |
| | $formoptions[1] = array('delete'=>true)); |
| ?> | ?> |
| <?php include ("includes/table/table.php"); ?> | <?php include ("includes/table/table.php"); ?> |
| </code> | </code> |
| === Table === | === Table === |
| * ''$tablefields[//formnr//][//tabname//][//label//] = array(...)'' | * ''$recfields[//formnr//][//tabname//][//label//] = array(...)'' |
| * ''//formnr//'': nummer van form (indien meerdere database tabellen op 1 pagina gebruikt worden) | * ''//formnr//'': number of form (normally ``1``, but can be ``2``, ``3``, etc. if multiple database tables are used) |
| * ''//tabname//'': | * ''//tabname//'': name of group of columns to display |
| * ''//label//'': th-veld (in principe is dit de dbcolumnname zonder de naam van de tabel, bv. ''naam_lokale_taal'' voor ''hotel_naam_lokale_taal'') | * ''//label//'': th-field (normally this is the dbcolumnname without the name of the dbtable, e.g. ''naam_lokale_taal'' for ''hotel_naam_lokale_taal'') |
| * ''type=>'' | * ''array(...'' |
| * ''text'': default (i.e. not needed) | * ``type=>`` |
| * ''modal'': adds links to modal (''data-target="#modalDetails-//formnr//"'') | * ``text``: default (i.e. not needed) |
| * ''date'': adds 'data-order=' to <td> and uses ''schrijf_datum'' for value | * ``modal``: adds link to modal (``data-target="#modalDetails-//formnr//"``) |
| * additional options: ''schrijf_datum_options'' | * ``date``: adds 'data-order=' to <td> and uses ''schrijf_datum'' for value |
| * ''float'' | * additional options: ''schrijf_datum_options'' |
| | * ``float`` |
| | * ``th_title``: title attribatue for th-tags |
| | * ``th_data``: |
| === Form === | === Form === |
| * ''$tablefields[//tabname//][//label//] = array('' | * ``$recfields[//formnr//][//tabname//][//label//] = array(..)`` |
| * ''col=>//bootstrap grid//'' | * ``//formnr//``: number of form (normally ``1``, but could be ``2``, ``3``, etc. if multiple forms are needed) |
| * ''label=>//label//'' (default=label as defined in $tablefields) | * Note: ensure ``$dbtable[//formnr//]`` and ``$record_id[//formnr//]`` is defined for all forms (typically at top of php page) |
| * ''label_extra=>//extra information//'' extra info after label (in <small>-text) (string, delimiter=space) | * ``label``: see above (in section Table) |
| * ''placeholder=>//placeholder//'' | * additional options: |
| * ''attributes=>//attributes//'' additional attributes for input, eg. ''required'' (string, delimiter=space) | * ``label`` ends with *: required field (validation.io not-empty will be triggered) |
| | * ``label`` starts with [: new row in form |
| | * ``label`` starts with _: ?? |
| | * ``array(...`` |
| | * ``col=>//bootstrap grid//`` |
| | * ``label=>//label//`` (default=label as defined in $tablefields) |
| | * if ``label`` ends with ``*``, this field is required (``required`` will be added as attribute) |
| | * ``label_extra=>//extra information//`` extra info after label (in <small>-text) (string, delimiter=space) |
| | * ``placeholder=>//placeholder//`` |
| | * ``attributes=>//attributes//`` additional attributes for input, eg. ''required'' (string, delimiter=space) |
| | * ``type=>...`` |
| | * ``text``, ``number```, ``radio``, ``radio_from_array``, ``select``, ``daterange_start``, ``daterange_stop`` |
| | * ``options=>//options//`` additional options, eg. ''no-copy'' (array) |
| |
| * ''data-trigger="//event//"'': will trigger //event// after updating value with ''val()'' | * ''data-trigger="//event//"'': will trigger //event// after updating value with ''val()'' |
| * This allows for additional processing, e.g. updating another field using ''data-trigger="change"'', which can be captured by ''$("//element//").on('change', function() { ...'' | * This allows for additional processing, e.g. updating another field using ''data-trigger="change"'', which can be captured by ''$("//element//").on('change', function() { ...'' |
| * ''.readonly'': field will not be sent to ajax/process.php for updating | * ``.readonly``: field will not be sent to ajax/process.php for updating |
| * ''.hidenew'': field will not be sent to ajax/process.php for updating when #modalId == -1 (new record) | * ''.hidenew'': field will not be sent to ajax/process.php for updating when #modalId == -1 (new record) |
| * ''data-fieldformatting='//JSON-object//''': return value will be reformatted in ajax/process.php | * ''data-fieldformatting='//JSON-object//''': return value will be reformatted in ajax/process.php |