Log message #4099581

# At Username Text
# Nov 29th 2017, 22:20 saeideng I will look again into chronos to ability to add calendar
# Nov 29th 2017, 22:13 saeideng true?
# Nov 29th 2017, 22:12 saeideng with porting into chronos we no needs to cakephp/i18n at all
# Nov 29th 2017, 22:08 dereuromark I am sure it could fit into it
# Nov 29th 2017, 22:08 dereuromark mainly needs a PR from someone
# Nov 29th 2017, 22:08 saeideng perhaps needs open issue first
# Nov 29th 2017, 22:07 saeideng ?
# Nov 29th 2017, 22:07 saeideng do you think there is a plan to add calendar into chronos
# Nov 29th 2017, 22:06 saeideng I always use non-gregorian in apps
# Nov 29th 2017, 22:05 saeideng no
# Nov 29th 2017, 22:05 dereuromark seems like you have a new pet project :slightly_smiling_face:
# Nov 29th 2017, 22:05 saeideng other calendars :middle_finger:
# Nov 29th 2017, 22:04 saeideng japanese buddhist chinese persian indian islamic hebrew coptic ethiopic
# Nov 29th 2017, 22:04 saeideng basic calendar returns gregorian
# Nov 29th 2017, 22:03 dereuromark cant it already do basic calendar? everything else could maybe provided as PR
# Nov 29th 2017, 22:02 saeideng I check chronos that have not `calendar` IMO
# Nov 29th 2017, 22:02 saeideng `$result = $now->i18nFormat(\IntlDateFormatter::FULL, null, 'en-IR@calendar=persian');`
# Nov 29th 2017, 22:00 saeideng like calendar in cakephp/time
# Nov 29th 2017, 22:00 saeideng I need timezone + calendar in chronos
# Nov 29th 2017, 21:59 saeideng no
# Nov 29th 2017, 21:59 saeideng gui?
# Nov 29th 2017, 21:58 dereuromark I use https://github.com/dereuromark/cakephp-calendar for some basic gui
# Nov 29th 2017, 21:58 dereuromark you could look into the open carbon issues, they discussed this, and there might be already a few libs around this in php that could serve as ideas
# Nov 29th 2017, 21:57 saeideng how can we add calendar into chronos ?
# Nov 29th 2017, 21:50 inoas you can use formatResults as I said to tinker with the resultset and make it a single item
# Nov 29th 2017, 21:09 saeideng first show your native sql
# Nov 29th 2017, 21:08 saeideng if you need first first in joined table you can not IMO
# Nov 29th 2017, 21:07 saeideng first on resultset
# Nov 29th 2017, 21:07 joopm saeideng my query is more than complicated to not to konw how to use ->first() in simple query
# Nov 29th 2017, 21:07 saeideng first on query
# Nov 29th 2017, 21:06 saeideng because we have 2 first()
# Nov 29th 2017, 21:06 inoas well that first() is probably a collection method or so
# Nov 29th 2017, 21:06 inoas why the execute?
# Nov 29th 2017, 21:06 saeideng limit(1)->execute()->first() :slightly_smiling_face:
# Nov 29th 2017, 21:06 inoas or even run them in background mode to get 10 items and then cache them in the db to be consumed
# Nov 29th 2017, 21:06 inoas basically to make web services that return data faster
# Nov 29th 2017, 21:05 inoas I want to cache responses of Http\Client ... serialize a good thing?
# Nov 29th 2017, 21:05 saeideng inoas
# Nov 29th 2017, 21:05 saeideng https://api.cakephp.org/3.5/source-class-Cake.Datasource.QueryTrait.html#402-421
# Nov 29th 2017, 21:05 inoas saeideng you can use formatResults to get the first item only instead of list of 1 items
# Nov 29th 2017, 21:05 saeideng $query->select(['id', 'username'])->first();