Project

General

Profile

Actions
Copy link

Bug #99847

closed

Null value for time field is ignored in BE

Added by JAKOTA Design Group GmbH about 1 year ago. Updated 10 months ago.

Status:
Resolved
Priority:
Should have
Assignee:
-
Category:
-
Target version:
Candidate for patchlevel
Start date:
2023-02-06
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
11
PHP Version:
8.0
Tags:
Complexity:
no-brainer
Is Regression:
Sprint Focus:

Description

Hi,

Following the example for building a time picker

https://docs.typo3.org/m/typo3/reference-tca/11.5/en-us/ColumnsConfig/Type/Input/DateTime/Properties/DbType.html

I've done this:

    'start_time' => [
      'exclude' => true,
      'l10n_mode' => 'exclude',
      'l10n_display' => 'defaultAsReadonly',
      'label' => 'Start time',
      'config' => [
        'type' => 'input',
        'renderType' => 'inputDateTime',
        'dbType' => 'time',
        'size' => 4,
        'disableAgeDisplay' => true,
        'eval' => 'time,null',
        'default' => null,
      ],
    ],

CREATE TABLE tx_myext_domain_model_thing (
  start_time time default NULL,
);

and it work fine.

But if the field value in the DB is null the "Set value" checkbox should not be set automatically.

And another thing even if the checkbox for "Set value" is set and the field value in the backend is 00:00 the value in the DB is not changed from null to 00:00

This makes it hard to determine if no value is set or the time is 00:00.

Thanks

Related issues 4 (3 open — 1 closed)

Related to TYPO3 Core - Bug #97216: Time value "midnight" (00:00) is not acceptedClosed2022-03-21

Actions
Related to TYPO3 Core - Bug #98252: TCA Default value for times cannot be setNew2022-09-02

Actions
Related to TYPO3 Core - Bug #100649: Extbase DataMapper doesn't respect datetime when 0 or 0000-00-00 or 0000-00-00 00:00:00 or 00:00:00New2023-04-18

Actions
Related to TYPO3 Core - Bug #92900: Unable to store "epoch start" on native datetime fields with dbtypeUnder Review2020-11-21

Actions
Actions
Copy link
 #1

Updated by JAKOTA Design Group GmbH about 1 year ago

One additional note:

The value is only not saved as 00:00 and left null if 00:00 is put in the input field.
If the TimePicker UI is used to set the value the time 00:00 is saved to DB.

Actions
Copy link
 #2

Updated by JAKOTA Design Group GmbH about 1 year ago

  • Complexity set to no-brainer

I've found the reason why this is not working.

/typo3/sysext/backend/Classes/Form/FormDataProvider/DatabaseRowDateTimeFields.php

always sets the value to 0 if it is null and also is not returning the correct timestamp for 00:00.

Line: 49 to 51 is:

                } else {
                    $result['databaseRow'][$column] = $format['reset'] ?? null;
                }

but should/could be:

                } else if ($result['databaseRow'][$column] === ($format['empty'] ?? null)) {
                    $result['databaseRow'][$column] = date('c', 0);
                } else if (null !== $result['databaseRow'][$column]) {
                    $result['databaseRow'][$column] = ($format['reset'] ?? null) === null ? null : date('c', (int)$format['reset']);
                }

This solves both issues.

I'm not sure why the first "if" checks for an format empty

&& $result['databaseRow'][$column] !== ($format['empty'] ?? null)

Cause even that needs to be converted to something like 1970-01-01T00:00:00+00:00 otherwise this value gets set back to null the next time the record is saved.

If someone could have a look please.

Thanks.

Actions
Copy link
 #3

Updated by Gerrit Code Review about 1 year ago

  • Status changed from New to Under Review

Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #4

Updated by Gerrit Code Review about 1 year ago

Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #5

Updated by Gerrit Code Review about 1 year ago

Patch set 3 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #6

Updated by Gerrit Code Review about 1 year ago

Patch set 4 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #7

Updated by Gerrit Code Review about 1 year ago

Patch set 5 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #8

Updated by Gerrit Code Review about 1 year ago

Patch set 6 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #9

Updated by Gerrit Code Review about 1 year ago

Patch set 7 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #10

Updated by JAKOTA Design Group GmbH about 1 year ago

  • Related to Bug #97216: Time value "midnight" (00:00) is not accepted added
  • Related to Bug #98252: TCA Default value for times cannot be set added
Actions
Copy link
 #11

Updated by Gerrit Code Review about 1 year ago

Patch set 1 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78168

Actions
Copy link
 #12

Updated by Gerrit Code Review about 1 year ago

Patch set 8 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #13

Updated by Gerrit Code Review about 1 year ago

Patch set 9 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #14

Updated by Sebastien Convers about 1 year ago

  • Related to Bug #100649: Extbase DataMapper doesn't respect datetime when 0 or 0000-00-00 or 0000-00-00 00:00:00 or 00:00:00 added
Actions
Copy link
 #15

Updated by JAKOTA Design Group GmbH about 1 year ago

  • Related to Bug #92900: Unable to store "epoch start" on native datetime fields with dbtype added
Actions
Copy link
 #16

Updated by Gerrit Code Review about 1 year ago

Patch set 2 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78168

Actions
Copy link
 #17

Updated by Gerrit Code Review about 1 year ago

Patch set 10 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #18

Updated by Gerrit Code Review 10 months ago

Patch set 11 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #19

Updated by Gerrit Code Review 10 months ago

Patch set 12 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #20

Updated by Gerrit Code Review 10 months ago

Patch set 13 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #21

Updated by Gerrit Code Review 10 months ago

Patch set 14 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #22

Updated by Gerrit Code Review 10 months ago

Patch set 15 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78096

Actions
Copy link
 #23

Updated by Gerrit Code Review 10 months ago

Patch set 1 for branch 12.4 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/79748

Actions
Copy link
 #24

Updated by Gerrit Code Review 10 months ago

Patch set 3 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78168

Actions
Copy link
 #25

Updated by Gerrit Code Review 10 months ago

Patch set 4 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78168

Actions
Copy link
 #26

Updated by JAKOTA Design Group GmbH 10 months ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions
Copy link
 #27

Updated by Gerrit Code Review 10 months ago

  • Status changed from Resolved to Under Review

Patch set 5 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78168

Actions
Copy link
 #28

Updated by Gerrit Code Review 10 months ago

Patch set 6 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78168

Actions
Copy link
 #29

Updated by Gerrit Code Review 10 months ago

Patch set 7 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78168

Actions
Copy link
 #30

Updated by Gerrit Code Review 10 months ago

Patch set 8 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78168

Actions
Copy link
 #31

Updated by Gerrit Code Review 10 months ago

Patch set 9 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/78168

Actions
Copy link
 #32

Updated by JAKOTA Design Group GmbH 10 months ago

  • Status changed from Under Review to Resolved
Actions
Copy link

Also available in: Atom PDF