| # |
Jul 6th 2017, 15:24 |
eBug |
$conditions[] = '(transporte_id,asociado_id,operacion_venta_id) IN ((80,68,99), (80,78,96), (80,78,86),(80,78,62))' works fine but i'm working with a variable set of objects in IN |
| # |
Jul 6th 2017, 15:20 |
inoas |
either make the ORM do what you want, or surrogate key in schema, or virtual column, or sql view, orm + subquery in raw sql, or only raw sql |
| # |
Jul 6th 2017, 15:18 |
inoas |
$conditions[] = '(transporte_id,asociado_id,operacion_venta_id) IN ((80,68,99), (80,78,96), (80,78,86),(80,78,62))' |
| # |
Jul 6th 2017, 15:18 |
inoas |
erm |
| # |
Jul 6th 2017, 15:18 |
inoas |
did you try $conditions['(transporte_id,asociado_id,operacion_venta_id) IN ((80,68,99), (80,78,96), (80,78,86),(80,78,62))'] |
| # |
Jul 6th 2017, 15:18 |
inoas |
so why is an SQL VIEW no option? ... you simply concat the 3 ids and it is easy to query with the old orm |
| # |
Jul 6th 2017, 15:09 |
eBug |
because $this->request->data['RetiradaTransportePendiente'] returns an array |
| # |
Jul 6th 2017, 15:08 |
eBug |
virtual columns isn't an option here |
| # |
Jul 6th 2017, 15:07 |
eBug |
i mean WHERE (transporte_id,asociado_id,operacion_venta_id) IN ((80,68,99), (80,78,96), (80,78,86),(80,78,62)) |
| # |
Jul 6th 2017, 15:06 |
inoas |
you can use an sql view or virtual column to get around the problem entirely |
| # |
Jul 6th 2017, 15:06 |
eBug |
instead I need WHERE (transporte_id,asociado_id,operacion_venta_id) IN ((80,68,99), (80,78,96), (80,78,86),('80,78,62)) |
| # |
Jul 6th 2017, 15:06 |
inoas |
you can try $conditions[] = 'raw sql' |
| # |
Jul 6th 2017, 15:06 |
inoas |
ebug if you want to do that yourself |
| # |
Jul 6th 2017, 15:05 |
eBug |
this is the resulting SQL: WHERE (transporte_id,asociado_id,operacion_venta_id) IN ('80,68,99', '80,78,96', '80,78,86', '80,78,62') |
| # |
Jul 6th 2017, 15:05 |
eBug |
inoas: the problem isn't SQL, the problem is that the content of the $request array is quoted by cake when it turns it into a query |
| # |
Jul 6th 2017, 15:05 |
inoas |
gist your model and finder |
| # |
Jul 6th 2017, 15:05 |
inoas |
as I said |
| # |
Jul 6th 2017, 15:04 |
 juststeveking |
inoas I have set up all relations on model correctly, and set up everything the way I expect it to, but the container behviour isn't loading it in |
| # |
Jul 6th 2017, 15:03 |
inoas |
https://gist.github.com/ionas/ec164aa57b8aae3f4d6d0be96ad54af5 |
| # |
Jul 6th 2017, 15:02 |
inoas |
juststevekind gist your table |
| # |
Jul 6th 2017, 15:01 |
inoas |
then it becomes a simple transporte_id_asociado_id_operacion_venta_id => $list_of_concatted_ids |
| # |
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: |