| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| web:kg [2017-05-01 12:26] – [Form] 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'') |
| * ''array(...'' | * ''array(...'' |
| * ``type=>`` | * ``type=>`` |
| * ``text``: default (i.e. not needed) | * ``text``: default (i.e. not needed) |
| * ``modal``: adds links to modal (``data-target="#modalDetails-//formnr//"``) | * ``modal``: adds link to modal (``data-target="#modalDetails-//formnr//"``) |
| * ``date``: adds 'data-order=' to <td> and uses ''schrijf_datum'' for value | * ``date``: adds 'data-order=' to <td> and uses ''schrijf_datum'' for value |
| * additional options: ''schrijf_datum_options'' | * additional options: ''schrijf_datum_options'' |
| * ``float`` | * ``float`` |
| | * ``th_title``: title attribatue for th-tags |
| | * ``th_data``: |
| === Form === | === Form === |
| * ``$tablefields[//formnr//][//tabname//][//label//] = array(..)`` | * ``$recfields[//formnr//][//tabname//][//label//] = array(..)`` |
| * ``//formnr//``: number of form (normally ``1``, but could be ``2``, ``3``, etc. if multiple forms are needed) | * ``//formnr//``: number of form (normally ``1``, but could be ``2``, ``3``, etc. if multiple forms are needed) |
| * Note: ensure ``$dbtable[//formnr//]`` and ``$record_id[//formnr//]`` is defined for all forms (typically at top of php page) | * Note: ensure ``$dbtable[//formnr//]`` and ``$record_id[//formnr//]`` is defined for all forms (typically at top of php page) |
| | * ``label``: see above (in section Table) |
| | * additional options: |
| | * ``label`` ends with *: required field (validation.io not-empty will be triggered) |
| | * ``label`` starts with [: new row in form |
| | * ``label`` starts with _: ?? |
| * ``array(...`` | * ``array(...`` |
| * ``col=>//bootstrap grid//`` | * ``col=>//bootstrap grid//`` |
| * ``placeholder=>//placeholder//`` | * ``placeholder=>//placeholder//`` |
| * ``attributes=>//attributes//`` additional attributes for input, eg. ''required'' (string, delimiter=space) | * ``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()'' |