public static function getData($id)
{
// get data
$data = (array) BackendModel::getContainer()->get('database')->getRecord('SELECT fd.id, fd.form_id, UNIX_TIMESTAMP(fd.sent_on) AS sent_on
FROM forms_data AS fd
WHERE fd.id = ?', (int) $id);
// get fields
$data['fields'] = (array) BackendModel::getContainer()->get('database')->getRecords('SELECT fdf.label, fdf.value
FROM forms_data_fields AS fdf
WHERE fdf.data_id = ?
ORDER BY fdf.id', (int) $data['id']);
// unserialize values
foreach ($data['fields'] as &$field) {
if ($field['value'] !== null) {
$field['value'] = unserialize($field['value']);
}
}
return $data;
}