public static function getFields($id)
{
$fields = (array) BackendModel::getContainer()->get('database')->getRecords('SELECT ff.id, ff.type, ff.settings
FROM forms_fields AS ff
WHERE ff.form_id = ?
ORDER BY ff.sequence ASC', (int) $id);
foreach ($fields as &$field) {
// unserialize
if ($field['settings'] !== null) {
$field['settings'] = unserialize($field['settings']);
}
// get validation
$field['validations'] = (array) BackendModel::getContainer()->get('database')->getRecords('SELECT ffv.type, ffv.parameter, ffv.error_message
FROM forms_fields_validation AS ffv
WHERE ffv.field_id = ?', $field['id'], 'type');
}
return $fields;
}