example

applier:SQLFunctioniser

id:check_form

method:require_value

value:ja

default_value:nee

columns:discipline;motivatie;werkzaamheden

php

function require_value () {

$cols = expl ( $this -> columns ) ;

if ( ! $cols) { return ; }

$true_value = $this -> value ;

$false_value = $this -> default_value ;

foreach ( $cols as $col ){

$build .= " WHEN $col = '' THEN '$false_value' " ;

}

$this -> result = "CASE " . $build.

"ELSE '$true_value' END" ;

}