| # |
Jul 6th 2017, 15:50 |
inoas |
I think there is Model->quote or model->quoteField or so |
| # |
Jul 6th 2017, 15:49 |
eBug |
i guess there is no other way yes |
| # |
Jul 6th 2017, 15:49 |
inoas |
$conditions[] = '(transporte_id,asociado_id,operacion_venta_id) IN (' . $yourGeneratedStringOfIdsThatYouEscaped . ')' |
| # |
Jul 6th 2017, 15:48 |
inoas |
and you have to escape it |
| # |
Jul 6th 2017, 15:48 |
inoas |
you have to generate the string yourself |
| # |
Jul 6th 2017, 15:48 |
inoas |
eBug so what? |
| # |
Jul 6th 2017, 15:48 |
 sathomsen |
@cleptic it also shows in the repo :S |
| # |
Jul 6th 2017, 15:47 |
sathomsen |
I did |
| # |
Jul 6th 2017, 15:40 |
cleptric |
Or create a webhook in your Github Account for that repository |
| # |
Jul 6th 2017, 15:40 |
cleptric |
There is a update button on the composer page |
| # |
Jul 6th 2017, 15:40 |
cleptric |
Did you “updated” it? |
| # |
Jul 6th 2017, 15:39 |
sathomsen |
https://packagist.org/packages/sathomsen/cakephp-facebook-auth |
| # |
Jul 6th 2017, 15:38 |
sathomsen |
Hey guys, I’m trying to fix a bug in my facebook plugin, and so I’ve uploaded a new version. Somehow composer refuses to realize this. Any ideas? Composer error: Problem 1 - The requested package sathomsen/cakephp-facebook-auth v0.0.6 exists as sathomsen/cakephp-facebook-auth[v0.0.4] but these are rejected by your constraint. |
| # |
Jul 6th 2017, 15:37 |
styks1987 |
ok thanks |
| # |
Jul 6th 2017, 15:34 |
jeremyharris |
validation too I think |
| # |
Jul 6th 2017, 15:34 |
jeremyharris |
styks1987 yes |
| # |
Jul 6th 2017, 15:30 |
styks1987 |
beforeMarshal doesn’t get called in the second? |
| # |
Jul 6th 2017, 15:30 |
styks1987 |
what is the main difference between patchEntity and $entity->property = ‘new value’? |
| # |
Jul 6th 2017, 15:25 |
eBug |
length |
| # |
Jul 6th 2017, 15:25 |
eBug |
$lista_ids has a varialbe |
| # |
Jul 6th 2017, 15:25 |
eBug |
this is why we have 'conditions' => ['(transporte_id,asociado_id,operacion_venta_id)' => $lista_ids] |
| # |
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 |