Dummy Fields / Virtual Fields

Dummy fields (or virtual fields) can be created, typically for use only in the List and/or View modes, to display information based on a calculation, MySQL function, or lookup.

$opts['fdd']['dummy|L']['sql'] = 'foo + bar';

$now = time();

$opts['fdd']['dummy_field'] = array(
  'css'        => array('postfix' => 'right-justify'),
  'name'       => 'Days since last edit',
  'mask'       =>  '%0.1f',
  'options'    => 'L',
  'sql'        => "($now - UNIX_TIMESTAMP(updated))/86400",
); 

$opts['fdd']['dummy1'] = array (
   'name'    => 'Dummy',
   'sql'     => 'CONCAT(first_name, "", last_name)',
   'options' => 'RACPDVL',
   'escape'  => false,
   'sort'    => true
);

$opts['fdd']['CurrentDate'] = array(
  'name'     => 'Current Date',
  'select'   => 'T',
  'maxlen'   => 14,
  'options'  => 'L',
  'sql'    => 'CURDATE()',
  'sort'     => true
);

$opts['fdd']['dummy'] = array(
  'name'     => 'Dummy',
  'options'  => 'L',
  'select'   => 'T',
  'sql|L'    => 'some_other_column + 30',
  'sort'     => true
);

$opts['fdd']['dummy'] = array(
  'name'     => 'Total',
  'select'   => 'T',
  'maxlen'   => 11,
  'sql'      => 'field1 + field2',
  'sort'     => true
); 

$opts['fdd']['dummy_column'] = array(
  'maxlen'   => 14,
  'name'     => 'Days Until',
  'options'  => 'L',
  'select'   => 'T',
  'sort'     => true,
  'sql'    => 'due_date - CURDATE()'
); 

After completing a lookup of `last_name` and `first_name` from `vs_users`, virtual fields enable the lookup of `user_level` from the currently joined table, for display in a separate column.

$opts['fdd']['user'] = array(
  'default'    => '',
  'input'      => '',
  'maxlen'     => 20,
  'name'       => 'User Name',
  'options'    => 'ACPVDFL',
  'required'   => true,
  'select'     => 'D',
  'size|ACP'   => 20,
  'sqlw'       => 'TRIM("$val_as")',
  'sort'       => true,
  'values'     => array(
    'table'       => 'vs_users',
    'column'      => 'user_name',
    'description'=> array(
       'columns' => array('0' => 'last_name', '1' => 'first_name'),
       'divs'    => array('0' => ', '),
     ),
    'filters'     => $filter_by_user_id,
    'orderby'     => 'last_name')
);

$opts['fdd']['virtual_1'] = array(
	'name' => ' ',
	'input' => 'VR',
	'options' => 'LFV',
	'sql' => 'PMEjoin1.user_level'
);

PHP Form Generator Home | PHP Form Generator Demo