This is an old revision of the document!


Web

KG's code

Sample Code

Sample code:

<?php
$dbtable[1] = 'reis';
$table_id[1] = 'table_'.$dbtable[1];
$record_id[1] = 'reis_id';
$record_title[1] = '[reis_omschrijving]';
?>
<div class="alert alert-info" role="alert" id="loading-text"> <strong>Gegevens worden geladen, even geduld ...</strong> </div>
<?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 _'));
$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');
$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');
$tablefields[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');
$tablefields[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');
$tableoptions[1]['data'] = array('order'=>'[[3,"desc"]]');
?>
<?php include ("includes/table/table.php"); ?>

Table

  • $tablefields[formnr][tabname][label] = array(…)
    • formnr: nummer van form (indien meerdere database tabellen op 1 pagina gebruikt worden)
    • type⇒
      • text: default (i.e. not needed)
      • modal: adds links to modal (data-target="#modalDetails-formnr")
      • date: adds 'data-order=' to <td> and uses schrijf_datum for value
        • additional options: schrijf_datum_options
      • float

Form

  • $tablefields[tabname][label] = array(
    • col⇒bootstrap grid
    • label⇒label (default=label as defined in $tablefields)
    • 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)
  • 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() { …
  • .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)
  • data-fieldformatting='JSON-object': return value will be reformatted in ajax/process.php
    • valid options: strftime, bv. data-fieldformatting='{"strftime":"%a %e %b %Y"}'

Plugins