| # |
Jul 6th 2017, 15:01 |
inoas |
https://mariadb.com/kb/en/mariadb/virtual-computed-columns/ |
| # |
Jul 6th 2017, 15:00 |
inoas |
or you can setup an auto increment key |
| # |
Jul 6th 2017, 15:00 |
inoas |
there are virtual fields in recent mysql/mariadb versions which just read other fields and combine them |
| # |
Jul 6th 2017, 15:00 |
 juststeveking |
For some reason my relation isn't loading :S could it be because the model I am loading is a plugin?? |
| # |
Jul 6th 2017, 15:00 |
inoas |
create a surrogate primary key |
| # |
Jul 6th 2017, 14:59 |
inoas |
other than that you can hack it in sql |
| # |
Jul 6th 2017, 14:59 |
inoas |
you can try 'conditions' => ['(transporte_id,asociado_id,operacion_venta_id) IN' => $lista_ids] |
| # |
Jul 6th 2017, 14:59 |
inoas |
$lista_ids = array(array('foo', 'bar', 'quux'), array(1, 2, 3))? |
| # |
Jul 6th 2017, 14:59 |
eBug |
inoas and $lista_ids = $this->request->data['RetiradaTransportePendiente']; |
| # |
Jul 6th 2017, 14:58 |
eBug |
inoas i only use 'conditions' => ['(transporte_id,asociado_id,operacion_venta_id)' => $lista_ids] |
| # |
Jul 6th 2017, 14:58 |
inoas |
in cakephp2 I would take a look if there is a way to write a subquery and that squbery I would write by hand |
| # |
Jul 6th 2017, 14:58 |
juststeveking |
Containable behviour isnt behaving for me |
| # |
Jul 6th 2017, 14:57 |
eBug |
yes |
| # |
Jul 6th 2017, 14:57 |
inoas |
eBug which conditions? cakephp2? |
| # |
Jul 6th 2017, 14:57 |
eBug |
#inoas the thing is in $conditions you don't use 'where' |
| # |
Jul 6th 2017, 14:29 |
inoas |
else you might need a custom expression |
| # |
Jul 6th 2017, 14:28 |
inoas |
ebug where([fieldA;fieldB;fieldC' => [['foo','bar','quux'], [1,2,3]]]) may work... or may not... give it a try |
| # |
Jul 6th 2017, 14:24 |
chris-andre |
cakephp-tree is located :slightly_smiling_face: |
| # |
Jul 6th 2017, 14:23 |
admad |
Check my GH account for tree plugin |
| # |
Jul 6th 2017, 14:22 |
chris-andre |
Allright, interesting @dereuromark , Thanks :slightly_smiling_face: |
| # |
Jul 6th 2017, 14:22 |
chris-andre |
@jeremyharris Ill check out recursive function |
| # |
Jul 6th 2017, 14:22 |
dereuromark |
See http://www.dereuromark.de/2013/02/17/cakephp-and-tree-structures/#treehelper |
| # |
Jul 6th 2017, 14:21 |
admad |
Just Not in core ;) |
| # |
Jul 6th 2017, 14:21 |
chris-andre |
Yea, sure, I use the TreeBehavior. |
| # |
Jul 6th 2017, 14:21 |
neon1024 |
Ah, no, it doesn’t. |
| # |
Jul 6th 2017, 14:20 |
neon1024 |
I’m pretty certain it has a helper |
| # |
Jul 6th 2017, 14:20 |
neon1024 |
I’d use the Tree behaviour |
| # |
Jul 6th 2017, 14:17 |
jeremyharris |
@chris-andre probably a recursive function, unless you know the nesting depth |
| # |
Jul 6th 2017, 14:09 |
chris-andre |
Hi. I have an resultset/array with tasks which might have children, child might have children and so on (multidimensional). Now I want each task listed in a table with children and childs children etc... Any tips how to "loop" through that data? |
| # |
Jul 6th 2017, 14:09 |
eBug |
hi, i'm trying to build $conditions for a find so that the resulting sql query would looks something like 'WHERE (colA,colB,colC) in ((a,b,c),(d,e,f),(g,h,i)). My problem ATM is that Cake quotes the elements of the array I'm passing, like '... IN ('a,b,c','d,e,f'','g,h,i')' |
| # |
Jul 6th 2017, 14:03 |
inoas |
https://gist.github.com/ionas/94e961bf414c78362442041081dad3ca ... @ burzum |
| # |
Jul 6th 2017, 14:01 |
neon1024 |
Yes |
| # |
Jul 6th 2017, 13:56 |
obinoob |
Hi, I have a form text field that must be obligatory in case a checkbox is ticked I wonder how can I validate such? I Suppose I need to add some custom rule and return boolean based on checkbox value right? |
| # |
Jul 6th 2017, 13:48 |
Wodan__ |
Alright, thank you for all your help |
| # |
Jul 6th 2017, 13:48 |
dakota |
Yes, `composer update` (Assuming your composer.json version contraints allow you to), then have a quick look through https://book.cakephp.org/3.0/en/appendices/3-4-migration-guide.html |
| # |
Jul 6th 2017, 13:47 |
Wodan__ |
I did a composer update earlier |
| # |
Jul 6th 2017, 13:47 |
Wodan__ |
^ Is there a fail safe way to update? |
| # |
Jul 6th 2017, 13:47 |
dakota |
Ah, then use ->config( |
| # |
Jul 6th 2017, 13:47 |
Wodan__ |
running 3.3.16 |
| # |
Jul 6th 2017, 13:46 |
dakota |
And yes, that’s what you need to be using |
| # |
Jul 6th 2017, 13:46 |
dakota |
What version of cakephp are you using? |