# |
May 26th 2017, 13:31 |
hmic |
s/as/has/ |
# |
May 26th 2017, 13:31 |
hmic |
so you are looking for the bid of that person that as no other bid (from that person) that is greater |
# |
May 26th 2017, 13:30 |
styks1987 |
I just want the max by that person |
# |
May 26th 2017, 13:30 |
styks1987 |
but 3 made by one person |
# |
May 26th 2017, 13:30 |
styks1987 |
there may be 6 bids |
# |
May 26th 2017, 13:30 |
styks1987 |
hmic: I assume this would work with other conditions on it like no other one greater (of a specific user id) |
# |
May 26th 2017, 13:29 |
hmic |
left join, greater than condition, where is null. so you are looking for the one that has *no* other one greater than on the relation in the table |
# |
May 26th 2017, 13:27 |
styks1987 |
hmic solid thanks |
# |
May 26th 2017, 13:27 |
hmic |
this: https://www.exchangecore.com/blog/mysql-sql-retrieve-most-recent-or-largest-record-group/ |
# |
May 26th 2017, 13:27 |
styks1987 |
So start with the bids and go the other direction? |
# |
May 26th 2017, 13:26 |
hmic |
this is a standard sql problem with a standard solution to it. |
# |
May 26th 2017, 13:26 |
hmic |
styks1987, wrong approach |
# |
May 26th 2017, 13:26 |
styks1987 |
I am trying to find listings a user has bid on and return their highest bid. So I am using matching to get the listings the user has bid on but this produces multiple listings with the same id. So I group them. The problem that i am having is that the group does not order the bids by date so it returns the first bid instead of the highest bid |
# |
May 26th 2017, 13:17 |
dakota |
http://cakefest.org/ |
# |
May 26th 2017, 13:17 |
dakota |
@grymmjack If you aren’t already, you should also come to CakeFest :) Not only will you learn loads about CakePHP, but you might even be able to find somebody who’s looking for CakePHP work! |
# |
May 26th 2017, 13:15 |
dakota |
@grymmjack You can also use: http://cakephpjobs.com/ |
# |
May 26th 2017, 13:04 |
rchavik |
using Crud, in my add() action, something went wrong. how do i find out what it is? right now no logs, only shows Flash message: 'could not create link' |
# |
May 26th 2017, 12:55 |
obinoob |
Thank you so much for your input |
# |
May 26th 2017, 12:54 |
obinoob |
hmic: if you have any example on how to do such Class let me know |
# |
May 26th 2017, 12:53 |
obinoob |
*want |
# |
May 26th 2017, 12:53 |
obinoob |
anyway, user must pass rules before can add a new document but I wont to put all that logic away from controller as it will increase code complexity etc |
# |
May 26th 2017, 12:51 |
obinoob |
that's why I've wrote a UserData class |
# |
May 26th 2017, 12:50 |
obinoob |
hmic: I need to check if user has active certificate, credits etc in order to let him add a new document, I've to check database in order to acknowledge user authorization, I've found https://book.cakephp.org/3.0/en/controllers/components/authentication.html#authorization very poor in examples |
# |
May 26th 2017, 12:50 |
grymmjack |
our cakephp site: http://www.carbontv.com |
# |
May 26th 2017, 12:50 |
grymmjack |
hello guys - we're looking to hire a cakephp deverloper full time - any additional experience like wordpress is great too - but mainly asking in here since it seems the most direct route to find someone :slightly_smiling_face: would any of you be interested? if so, please msg me :slightly_smiling_face: thanks! |
# |
May 26th 2017, 12:35 |
eax |
Excellent - Thanks! :) |
# |
May 26th 2017, 12:35 |
hmic |
eax: of course |
# |
May 26th 2017, 12:35 |
hmic |
obinoob, thats exactly it. just roll your own authorization class, if its more custom |
# |
May 26th 2017, 12:34 |
eax |
hmic: I'm unsure if this test is enough: https://gist.github.com/eaxexe/775ab0043c6822065ba56645f0cfb64d (Which fails) - I have made a repo on github that reproduces the error, and added this test to ArticlesTableTest.php - Is it acceptable to make the issue and refer to that repo, as for showing how to reproduce it? :) |
# |
May 26th 2017, 12:34 |
inoas |
so there was something built-in already :) |
# |
May 26th 2017, 12:34 |
inoas |
->add('output_content_type', 'equalTo', ['rule' => ['equalTo', 'INHERIT'], 'on' => function ($context) { return $context['data']['kind'] !== 'DOCUMENT'; }]); - works like a charm |
# |
May 26th 2017, 12:33 |
obinoob |
hmic well I first though of ACL but not sure... I've also read https://github.com/burzum/cakephp-simple-rbac it's not definitely what I need I could easily achieve that with authorise method |
# |
May 26th 2017, 12:31 |
hmic |
you can easily roll a completely custom authorization class too of course. if thats what you like to do... |
# |
May 26th 2017, 12:31 |
hmic |
thats eighter rbac or acl with me. depending on the degree of controll you want |
# |
May 26th 2017, 12:29 |
obinoob |
hmic: for example user can only add if he meets a few requirements... authorization yes but with a refined degree |
# |
May 26th 2017, 12:25 |
hmic |
plugins for both do exist |
# |
May 26th 2017, 12:25 |
obinoob |
hmic you're probably right about it |
# |
May 26th 2017, 12:25 |
hmic |
if thats not enough, you will need a full blown ACL solution |
# |
May 26th 2017, 12:25 |
hmic |
the first thing to consider, besides hardcoded groups of users, is RBAC authorization |
# |
May 26th 2017, 12:25 |
obinoob |
I also learned that components will not need view components or a build up responses right? |
# |
May 26th 2017, 12:25 |
hmic |
probably you are looking for authorization stuff? not validation? |