| # |
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 |
| # |
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']; |