# |
Nov 14th 2017, 13:53 |
birdy247 |
How would you approach this? |
# |
Nov 14th 2017, 13:52 |
birdy247 |
just "pretty much like this site" |
# |
Nov 14th 2017, 13:52 |
birdy247 |
No documents or anything |
# |
Nov 14th 2017, 13:52 |
birdy247 |
They want a very high level ballpark |
# |
Nov 14th 2017, 13:51 |
birdy247 |
a potential client called to ask how much it would be to replicate a already existing website (or at least 90% the same) |
# |
Nov 14th 2017, 13:51 |
birdy247 |
bit of an odd/offtopic one... but Ill put it to you guys anyway :slightly_smiling_face: |
# |
Nov 14th 2017, 13:42 |
acosonic |
sorry it's @admad ... Meh I'll just switch to slack... |
# |
Nov 14th 2017, 13:41 |
acosonic |
@amad slack, of course... |
# |
Nov 14th 2017, 13:41 |
acosonic |
@amad there is version 4 rolling out soon, and there is over 800 plugins, some of them are like telegram chat bots etc... |
# |
Nov 14th 2017, 13:40 |
admad |
people still use redmine? |
# |
Nov 14th 2017, 13:25 |
acosonic |
if that's interesting... |
# |
Nov 14th 2017, 13:24 |
acosonic |
I mean next year :D |
# |
Nov 14th 2017, 13:24 |
acosonic |
Hm cool, that's enough time :D I want to speak about Redmine + SVN/GIT (issue-code relationship) + our cake workflow (Demo application, dev server, stage server and production server) and some type of agile/scrum adoption |
# |
Nov 14th 2017, 13:21 |
dereuromark |
acosonic: this is just a local meetup, not a conference. the actual conference is next year and is called CakeFest. Just so you know. So no probs, you dont have to burn yourself out. We got the presentations all covered and stuff. |
# |
Nov 14th 2017, 13:03 |
nooot77 |
hi , how to view tree in https://book.cakephp.org/3.0/en/orm/behaviors/tree.html , to display categories , parent categories , and articles title for each category |
# |
Nov 14th 2017, 12:52 |
felix |
perfect, thank you. i was searching at the wrong pages in the docu |
# |
Nov 14th 2017, 12:51 |
admad |
err @felix |
# |
Nov 14th 2017, 12:51 |
admad |
@felipemjesuss https://book.cakephp.org/3.0/en/chronos.html#generating-differences |
# |
Nov 14th 2017, 12:49 |
felix |
hi, is there a builtin way to calculate the difference in days (or hours any other ..) between two `\Cake\I18n\Date`s ? i know i could for example write a function that compares them by using strtotime() |
# |
Nov 14th 2017, 12:34 |
acosonic |
Actually I wanted to say @dereuromark since I haven't switched to slack yet :D |
# |
Nov 14th 2017, 12:28 |
acosonic |
@dereuromakr I wanted to create presentation, and apply for talking, but I'm just too busy and too tired :( I'm actually taking this trip to take some break from daily routine, which is managing too many assets... |
# |
Nov 14th 2017, 12:22 |
admad |
``` return $query->where([ 'start_date <=' => $options['today'], 'OR' => [ 'end_date >=' => $options['today'], 'end_date IS' => null ] ]); ``` |
# |
Nov 14th 2017, 12:19 |
diego182 |
@willem indeed |
# |
Nov 14th 2017, 12:10 |
willem |
@stoykovnet you are a god! Sometime the docs can explain simple stuff so difficult |
# |
Nov 14th 2017, 11:54 |
stoykovnet |
@willem, wouldn't that suffice? ``` // In some model class. public function findBetweenDates(Query $query, array $options) { return $query->where([ 'OR' => [ ['start_date <=' => $options['today'], 'end_date >=' => $options['today']] ['start_date <=' => $options['today'], 'end_date IS' => null] ] ]); } ``` |
# |
Nov 14th 2017, 11:54 |
neon1024 |
What query are you trying to write? |
# |
Nov 14th 2017, 11:48 |
diego182 |
@willem you can use queryExpressions with $exp->or_ or as array |
# |
Nov 14th 2017, 11:47 |
obinoob |
if you feel fine with sql |
# |
Nov 14th 2017, 11:47 |
obinoob |
willen above you can read a very simple example on how to use ConnectionManager |
# |
Nov 14th 2017, 11:46 |
obinoob |
https://gist.github.com/obinoob/6182a57343f5b8b04cfc57d2d2fa6e1d |
# |
Nov 14th 2017, 11:46 |
obinoob |
willem you can either create a query by using the ORM or PDO with prepared statments prety easy... |
# |
Nov 14th 2017, 11:37 |
willem |
yes, i noticed, but I have no clue how to create the query. I find it difficult to create an more advanced query using Cake, whilst writing in sql would be easy. Of course i want to use the framework to create the query. |
# |
Nov 14th 2017, 11:03 |
diego182 |
awesome! |
# |
Nov 14th 2017, 11:02 |
obinoob |
diego182 didn't had a clue about this function existence thank you again http://php.net/manual/en/function.http-build-query.php |
# |
Nov 14th 2017, 11:02 |
obinoob |
diego182 that will work just fine :) thank you |
# |
Nov 14th 2017, 11:00 |
obinoob |
I've read the api documentation for 3.1 (fast reading :) ) and the api does not provide any method that can retrieve the full query :( |
# |
Nov 14th 2017, 10:56 |
diego182 |
cakephp use http_build_query internally in some functions |
# |
Nov 14th 2017, 10:56 |
diego182 |
`http_build_query($this->request->query)` |
# |
Nov 14th 2017, 10:55 |
obinoob |
this seems awkward |
# |
Nov 14th 2017, 10:54 |
obinoob |
So does 3.1 provide me with any method/property that can handle the url complete query or do I have to create a helper function? |
# |
Nov 14th 2017, 10:54 |
diego182 |
he is using cakephp 3.1 |