1. Fabrik 3.7 is now available. This version contains critical security updates, please update as soon as possible. Please remember to backup your site before updating, we also recommend testing your updates on development sites if possible.
  2. We had to restore the site around midday (CST) on Wed 7/26 from a backup approximately 8 hours old. So a few posts in the forums were lost. You may want to check to see if you need to re-post anything.

PHP Events list plugin

Oct 23, 2015
PHP Events list plugin
  • The PHP Events plugin allows for certain hooks into the internals of a Fabrik list. For each option the list model is represented by the variable $model.

    The following events are supported
    • onFiltersGot - Called when the list's filter array has been populated
    • onMakeFilters - Called when the list HTML filters are loaded
    • process
    • onPreloadData - Run before the list loads its data
    • onLoadData - After the data has loaded
    • onDeleteRows - Called when the list mode deletes rows
    • onQueryBuildWhere - after the where statement has been created
    See the API reference here for full details.

    [h1]Examples[/h1]


    Changing the colour of a cell based on the value stored in a colour picker element.(top)


    Add the following code to the plugin's 'onLoadData' option. This allows us to alter the list's data before it is displayed:

    PHP:


    // $model is the list model, we want to get its data and then alter it.
    $data = $model->getData();

    foreach ($data as $group)
    {
      foreach ($group as $row)
      {
        // Set a default rgb colour that will be used if nothing has been filled in by the colour picker
        $default = '155,20,45' ;

        // tablename___colour_raw is the raw full name of the colour picker element
        $c = (string) $row->tablename___colour_raw === '' ? $default : $row->tablename___colour_raw;

        // Update the 'birthday' element, wrapping it with a span with our selected colour.
        $row->tablename___birthday = '<span style="color:rgb(' . $c . ')">' . $row->tablename___birthday . '<span>';
      }
    }
     

    Changing a date element, to show how many days old it is(top)


    Add the following code to the plugin's 'onLoadData' option. This allows us to alter the list's data before it is displayed:

    PHP:

    // $model is the list model, we want to get its data and then alter it.
    $data = $model->getData();

    foreach ($data as $group)
    {
      foreach ($group as $row)
      {
        $nowDate = strtotime($row->events___start_raw);
        $thenDate = strtotime("today");
        $dateDiff = $thenDate - $nowDate;
        $row->events___start = round($dateDiff / 86400);
      }
    }