Backend\Modules\FormBuilder\Engine\Model::getData PHP Method

getData() public static method

Get data for a given id.
public static getData ( integer $id ) : array
$id integer The id for the record to get.
return array
    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;
    }

Usage Example

Exemplo n.º 1
0
 /**
  * Get the data
  */
 private function getData()
 {
     $this->data = BackendFormBuilderModel::getData($this->id);
     $this->record = BackendFormBuilderModel::get($this->data['form_id']);
 }