public function displayFieldValue($value, $type, $rule)
{
$displayFieldValue = $value;
switch ($type) {
case 'yesno':
$displayFieldValue = $value == 1 ? 'Yes' : 'No';
break;
case 'select':
case 'checkbox':
case 'radio':
$sql = "SELECT option_text FROM {$rule} WHERE option_value = ? AND language_code = 'en'";
$pA = array('i', $value);
$result = DB::query($sql, $pA);
if ($result->getRows()) {
$displayFieldValue = $result->option_text;
}
break;
case 'username':
$user = new eCRFUser($value);
$displayFieldValue = $user;
break;
case 'date':
$displayFieldValue = convertDate($value);
break;
case 'datetime':
$dt = splitDateTime($value);
$time = $dt['time'];
$date = convertDate($dt['date']);
$displayFieldValue = $date . ' at ' . $time;
}
return $displayFieldValue;
}
case "0":
echo "Não Processado";
break;
}
?>
</td>
<td><?php
echo $data['smsid'];
?>
</td>
<td><?php
echo $data['user_name'];
?>
</td>
<?php
$new_date = splitDateTime($data['sms_date']);
?>
<td><?php
echo inverte_data($new_date[0]);
?>
</td>
<td><?php
echo $new_date[1];
?>
</td>
<td><?php
echo $data['sms_contact'];
?>
</td>
<td><?php
echo $data['sms_text'];
if ($row->field == 'complete') {
continue;
}
$field = $trial->record->getFieldData($row->tableName, $row->field);
if (is_null($field)) {
continue;
}
if ($field->encrypted) {
if (!$user->isCentralAdmin()) {
continue;
}
$td = new Encrypt($user->getKey());
$row->old_value = $td->decrypt($row->old_value);
$row->new_value = $td->decrypt($row->new_value);
}
$dt = splitDateTime($row->time);
$time = $dt['time'];
$sql = "SELECT value FROM formVal WHERE formFields_id = ? AND operator = 'IN LIST' ORDER BY groupNum";
$pA = array('i', $field->id);
$ruleSearch = DB::query($sql, $pA);
if ($ruleSearch->getRows()) {
$rule = $ruleSearch->value;
} else {
$rule = NULL;
}
if ($row->old_value) {
$ov = $trial->record->displayFieldValue($row->old_value, $field->type, $rule);
if ($field->type == 'checkbox') {
echo "<li>{$field->labelText} had {$ov} removed at {$time}</li>";
} else {
$nv = $trial->record->displayFieldValue($row->new_value, $field->type, $rule);
