Boltforms/ContentType and Date field type

[leocavalcante]

I was getting Catchable fatal error: Object of class DateTime could not be converted to string if a form field of type birthday linked to an ContentType field of type date.

The solution was:

Bolt\Content.php below line 287

if ($this->values[$key] instanceof \DateTime) {
    $this->values[$key] = $this->values[$key]->format('c');
}

Bolt\Extension\Bolt\BoltForms\Database.php below line 81

if ($value instanceof \DateTime) {
    $savedata[$key] = $value->format('c');
}

Not sure if is the best solution, but solved to me.

[bobdenotter]

Hi @leocavalcante,

Could you give a bit more information about what you were doing, that caused these errors? I think your solution won't cause any side-effects, but we'd need to test those out.

[leocavalcante]

Sure!

To reproduce just link a Boltforms to a ContentType with a date/datetime type field:

contenttypes.yml:

form_requests:
  name: Form Requests
  singular_name: Form Request
  fields:
    title:
      type: text
    date:
      type: date
    file:
      type: file

boltforms.bolt.yml:

form_request:
  database:
    contenttype: form_requests
  fields:
    title:
      type: text
    date:
      type: date
    file:
      type: file
    submit:
      type: submit

index.twig

{{ boltforms('form_request') }}

Try to submit a request and got:

Catchable fatal error: Object of class DateTime could not be converted to string in C:\apache\htdocs\bolt-issue\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php on line 91

I added a file type cause I think it wont will link properly to. Just as headsup.
At the end I created a extension to handle my form request on my actual project.

Changing to table:

form_request:
  database:
    #contenttype: form_requests
    table: bolt_form_requests

Doest not resolve, both Bolt\Storage->insertContent() and Bolt\Extension\Bolt\BoltForms\Database->writeToTable() are not handling different kinds of type.

[jadwigo]

This also needs the following in Bolt\Extension\Bolt\BoltForms\Email

https://github.com/GawainLynch/bolt-extension-boltforms/blob/master/src/Email.php#L96

And maybe the formatting must be some user readable format

        foreach($formdata as $key => $value) {
            if ($value instanceof \DateTime) {
                $formdata[$key] = $value->format('c');
            }
        }

[leocavalcante]

Not sure if Bolt must know how to handle field values or if Boltforms should pass it already as strings. Sorry if issue is in wrong place.

[GwendolenLynch]

The game is changing in that regard when we start work on Bolt 2.3… Watch this space 😁

For now we'll handle in BoltForms, @jadwigo PRed a fix today and I have merged it into the BF master branch and will tag a release soon(ish).

[GwendolenLynch]

Closing as we're working around this now in BoltForms and as mentioned Bolt 2.3 has some significant updates on this.