Log message #4123268

# At Username Text
# Mar 8th 2018, 16:31 savant heh
# Mar 8th 2018, 16:31 meder savant: it's a huge site and that would take time the client wouldn't pay for
# Mar 8th 2018, 16:31 jojomartius @ricksaccous yes, thats with thing with euro’s and cents
# Mar 8th 2018, 16:30 savant upgrade to latest cakephp?
# Mar 8th 2018, 16:30 meder anyone know how i'd go about implementing the core pull updates in https://github.com/cakephp/cakephp/pull/11765 to 3.3? is it possible through middleware? there are updates to Router.php but can I override that?
# Mar 8th 2018, 16:28 ricksaccous oh well, you'll figure it out
# Mar 8th 2018, 16:27 ricksaccous is that 3 euros 45 cents?
# Mar 8th 2018, 16:27 ricksaccous like 3,45
# Mar 8th 2018, 16:27 ricksaccous wait do commas in european prices work like cents?
# Mar 8th 2018, 16:25 ricksaccous lol
# Mar 8th 2018, 16:25 ricksaccous int it up dyud
# Mar 8th 2018, 16:25 jojomartius stupid shit
# Mar 8th 2018, 16:25 jojomartius but my friend here is comming with a english IE, typing in german numbers and because IE is not able to send floats out and mysql is not accepting comma seperated decimals i loose information :(
# Mar 8th 2018, 16:25 lorenzo you could have a select for “use comma as separator, or use dot as separator” and use that as the hint
# Mar 8th 2018, 16:24 lorenzo it’s difficult to guess
# Mar 8th 2018, 16:24 jojomartius yes.. thats the theory ;)
# Mar 8th 2018, 16:23 lorenzo or at least that will give you a good hint
# Mar 8th 2018, 16:23 lorenzo in theory the format should be dependent on the browser’s locale
# Mar 8th 2018, 16:22 ricksaccous in view always divide number by 100
# Mar 8th 2018, 16:22 ricksaccous just take out all , or . and multiply number by 100
# Mar 8th 2018, 16:22 ricksaccous store number as int and then use step=any in the textfield
# Mar 8th 2018, 16:20 jojomartius but what i dont like is that i need to know how the user will enter its number... if the german user uses an english format, it returns 0 and the otherway around ;)
# Mar 8th 2018, 16:14 jojomartius good idea ;)) thanks
# Mar 8th 2018, 16:05 lorenzo @jojomartius my suggestion would be to either use a beforeMarshal callback or use a custom database type
# Mar 8th 2018, 16:04 jojomartius ;) sounds like a quite good solution ;) and if we do this in the model directly while setting the value it should happen "automatically" ;)
# Mar 8th 2018, 16:03 lorenzo you can maybe read the locale from the user agent string of the user, and pre-process the inputs with that function
# Mar 8th 2018, 16:03 lorenzo @jojomartius https://api.cakephp.org/3.5/class-Cake.I18n.Number.html#_parseFloat
# Mar 8th 2018, 16:02 jojomartius Hey there, I'm using cake 3.x and had issues with the formhelper or lets call in number inputs. Is there an official way to correct decimal numbers (from number inputs) comming from IE with commas as decimal seperator in real floats?
# Mar 8th 2018, 16:00 lorenzo find StatementDecorator in our github repo
# Mar 8th 2018, 15:59 neon1024 Wow, quite a bit then! Thanks, I’ll have a read of the code an see if a more concrete implementation helps get it into my brain
# Mar 8th 2018, 15:58 lorenzo formatResults is a decorator of the result set
# Mar 8th 2018, 15:58 lorenzo the code that converts the rows to entities is a decorator of the statement…
# Mar 8th 2018, 15:58 lorenzo the code that casts the results to the right type (int, dates…) is a decorator of the statement
# Mar 8th 2018, 15:57 lorenzo the statement object is a decorator for pdo statement
# Mar 8th 2018, 15:57 lorenzo I sued decorator for a bunch of stuff, but where it is more obvious is in the result set
# Mar 8th 2018, 15:56 neon1024 @lorenzo The decorator in the ORM, is that for the query building, the sql, or the entities? I’m unsure
# Mar 8th 2018, 15:55 ricksaccous heh
# Mar 8th 2018, 15:55 ricksaccous so no issue
# Mar 8th 2018, 15:55 ricksaccous i see, so the issue with the docs is actually probably a difference in version between me and repo rather than a bug
# Mar 8th 2018, 15:55 em. ok, thx!
# Mar 8th 2018, 15:55 lorenzo haha