Log message #4184038

# At Username Text
# Apr 19th 2019, 21:00 swimboy I was only looking at the validator code to understand what was going on.
# Apr 19th 2019, 20:59 swimboy I understand that I shouldn't muck around in the validator code, I just wanted to set up the date validator once, instead of each table class file.
# Apr 19th 2019, 20:54 admad And stop mucking around with the validator code, just specific the format to use when setting up the validator in your table class
# Apr 19th 2019, 20:52 admad @swimboy you are supposed to enable locale based datetime string parsing here https://github.com/cakephp/app/blob/master/config/bootstrap.php#L181
# Apr 19th 2019, 20:18 swimboy If I change the default in ``function dateTime`` and ``function date`` to ``'mdy'`` it works just fine. Obviously, I don't want to do that in a production setting. Is there a way in my own code to override the behavior of the date and dateTime validators in a single location rather than adding it as a separate parameter everywhere I validate a date in a table?
# Apr 19th 2019, 20:12 swimboy Digging even deeper, I found this line in the Validator.php file: ``` public function dateTime($field, $formats = ['ymd'], $message = null, $when = null)``` which looks to me like the default behavior for date validation is expecting the date in year,month,day order unless another format is specified when the validator is called. It seems to me that this default should pick up the format from setLocaleFormat, should it not?
# Apr 19th 2019, 20:01 swimboy @ricksaccous I just discovered that the code I had above works, but I had to disable the date validation rule. It would fail if I had a date in any format other than yyyy-MM-dd. Is there somewhere I can tell the validator what format to expect the date to be in (or is there a reason why it would ignore the setLocaleFormat?)
# Apr 19th 2019, 19:05 swimboy @ricksaccous I'm getting closer, but I'm still missing something. I have this in AppController.php ``` Type::build('datetime')->useLocaleParser()->setLocaleFormat('M/d/yyyy'); Date::setToStringFormat('M/d/yyyy');``` And it displays dates as M/d/yyyy, but it still errors out unless I enter dates as 2019-04-19
# Apr 19th 2019, 19:00 maymeow im creating new Note (instead of using it from fixture) on each test because i need to create openssl_signature with logged in user. Its good idea or its better to use fixtures?
# Apr 19th 2019, 18:59 maymeow Hello Here is my Test for NotesConntroller https://gist.github.com/MayMeow/a60b2847580bdaf9392252264c92ea8b
# Apr 19th 2019, 18:44 swimboy Yup! I just found that page too. Looking through it now. Seems like it will get me on the right track. Thanks!
# Apr 19th 2019, 18:43 ricksaccous @swimboy https://book.cakephp.org/3.0/en/core-libraries/internationalization-and-localization.html#parsing-localized-datetime-data
# Apr 19th 2019, 18:42 ricksaccous hmmmm
# Apr 19th 2019, 18:42 ricksaccous so DateTimeType->setLocaleFormat('') and then you can set the format
# Apr 19th 2019, 18:42 ricksaccous I think in bootstrap or Application.php or something you can setLocaleFormat()
# Apr 19th 2019, 18:41 ricksaccous if you look at DateTimeType.php
# Apr 19th 2019, 18:41 ricksaccous i seeeee
# Apr 19th 2019, 18:40 swimboy Yeah, that gets us right back where we started. The JS is returning it in one format, but CakePHP wants another format. I'm trying to find a way that I can display an input all my dates in m/d/Y format, but have the data saved to the database as Y-m-d.
# Apr 19th 2019, 18:39 ricksaccous 'Y-m-d'
# Apr 19th 2019, 18:38 ricksaccous i think the format it wants is
# Apr 19th 2019, 18:38 ricksaccous heheeh
# Apr 19th 2019, 18:38 swimboy Yeah, that's what it looks like. If I use the standard date picker, it returns an object with year, month, and day values. When I use the JS, it returns the string "4/17/2019".
# Apr 19th 2019, 18:37 ricksaccous i think cake MIGHT expect a certain format for date in request data to format it into FrozenDate, hmph
# Apr 19th 2019, 18:33 swimboy Yes, it is. I'm digging into the code, and there's some JS that's generating a pop-up calendar to enter the date. It must be causing a problem with CakePHP being able to parse the input as a date when it's returned.
# Apr 19th 2019, 18:29 ricksaccous is it a date field in the schema?
# Apr 19th 2019, 18:29 ricksaccous @swimboy that doesn't sound right at all, it should be just changing it based on it's type
# Apr 19th 2019, 18:13 swimboy In the request data, it's '4/17/2019'
# Apr 19th 2019, 18:12 waspinator `$this->request->getQuery('redirect', ['default'])` always returns default
# Apr 19th 2019, 18:12 swimboy Actually, after patchEntity, the date field is null.
# Apr 19th 2019, 18:08 waspinator @admad okay, so how would I get the requesting page? I think it used to be in `$this->Auth->redirect()`
# Apr 19th 2019, 18:05 swimboy frozendate
# Apr 19th 2019, 18:03 ricksaccous @swimboy after you patchEntity is the date field a frozentime or frozendate object?
# Apr 19th 2019, 18:02 swimboy @ricksaccous I am calling patchEntity but it was still trying to stuff "4/19/2019" into the date field in my MariaDB table and spitting out SQL errors.
# Apr 19th 2019, 18:01 admad No it doesn't, home page is just the default value
# Apr 19th 2019, 17:48 waspinator how would you redirect to the requesting page after logging in using the Authentication plugin? The [example](https://github.com/cakephp/authentication/blob/master/docs/en/migration-from-the-authcomponent.rst#login-action) always redirects to the pages home display
# Apr 19th 2019, 17:47 ricksaccous as far as displaying dates that's completely up to you to use the Cake Libs available to you
# Apr 19th 2019, 17:46 ricksaccous done
# Apr 19th 2019, 17:46 ricksaccous third step - save
# Apr 19th 2019, 17:46 ricksaccous second step - patch entity, your request data becomes a frozenDate object
# Apr 19th 2019, 17:46 ricksaccous so first step - request data
# Apr 19th 2019, 17:45 ricksaccous you can safely save a FrozenTime object and cake will translate it however it needs to