# |
Nov 14th 2017, 16:32 |
inoas |
diego182 and how would that example work if you wanted articles that matched to Tag CakePHP AND to Tag ORM? |
# |
Nov 14th 2017, 16:30 |
diego182 |
just consider the fallowing "As this function will create an INNER JOIN, you might want to consider calling distinct on the find query as you might get duplicate rows if your conditions don’t exclude them already. This might be the case, for example, when the same users comments more than once on a single article." |
# |
Nov 14th 2017, 16:28 |
diego182 |
theres an example just like you need |
# |
Nov 14th 2017, 16:27 |
diego182 |
https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#filtering-by-associated-data-via-matching-and-joins |
# |
Nov 14th 2017, 16:27 |
diego182 |
i would go with matching |
# |
Nov 14th 2017, 16:16 |
inoas |
leftJoinWith group and count? |
# |
Nov 14th 2017, 16:14 |
inoas |
can this be done with innerJoin or leftJoin instead of matching or is matching the way to go? |
# |
Nov 14th 2017, 16:13 |
inoas |
where posts HABTM tags |
# |
Nov 14th 2017, 16:13 |
inoas |
my brain is stuck today on ORM: I want to fetch a post that has at minium tag A and tag B |
# |
Nov 14th 2017, 16:05 |
acosonic |
lol, I didn't know my avatar was that ugly,while on irc |
# |
Nov 14th 2017, 15:08 |
birdy247 |
@flavius thanks |
# |
Nov 14th 2017, 14:23 |
nooot77 |
hey man |
# |
Nov 14th 2017, 14:17 |
flavius |
and in development, if the other site changes and adds more functionality, tell him that you need to analyze that and decide how much time it will take you to implement it and how much it will cost him on top of the existing price |
# |
Nov 14th 2017, 14:16 |
flavius |
so I would build a spec (if I thought its worth getting into the project, because this takes quite some time to do as well) and then send it to him with some time tables such as, this feature will take this many hours, then add my per hour fee and a total :slightly_smiling_face: |
# |
Nov 14th 2017, 14:11 |
flavius |
and not "work for free" |
# |
Nov 14th 2017, 14:11 |
flavius |
plus, the other site might evolve over time and add functionality where previously there wasnt, you need to take into consideration that :slightly_smiling_face: |
# |
Nov 14th 2017, 14:11 |
flavius |
@birdy247 depends if he's willing to pay you above average. You can figure out if its worth the effort to document all the existing functionality based on that |
# |
Nov 14th 2017, 14:10 |
neon1024 |
Plus the “well the old site did that” syndrome |
# |
Nov 14th 2017, 14:10 |
neon1024 |
It’s a dangerous one as you’ll have significant scope creep |
# |
Nov 14th 2017, 14:10 |
neon1024 |
As there will be hidden features |
# |
Nov 14th 2017, 14:09 |
neon1024 |
@birdy247 I’d build a spec of the existing functionality, budget against that and add 25% |
# |
Nov 14th 2017, 14:09 |
nooot77 |
hey man |
# |
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() |