Hi!
I have used groceryCrudComunity for a system that's corrently un production, to solve some necesities I use a library called ajax_grocerycrud, just to get a dependency issue solved:
$crud->set_relation('ruta_ruta_id','ruta','{ruta}');
$crud->set_primary_key('empresa_id', 'v_cliente_ruta');
$crud->set_relation('clientes_cliente_id','v_cliente_ruta','empresa');
$crud->set_relation_dependency('clientes_cliente_id','ruta_ruta_id','ruta_id');
$crud->set_primary_key('empresa_id', 'v_proveedor_ruta');
$crud->set_relation('proveedor_proveedor_id','v_proveedor_ruta','empresa');
$crud->set_relation_dependency('proveedor_proveedor_id','ruta_ruta_id','ruta_id');
$crud->set_primary_key('patio_id', 'v_patio_ruta');
$crud->set_relation('patio_toma','v_patio_ruta','{patio}');
$crud->set_relation_dependency('patio_toma','ruta_ruta_id','ruta_id');
There I have 3 dependecies and as you can see I use views, not tables.
Now that the dependency functionality is available in enterprise edition I'm working in the migration of the entire system and this dependency looks now like this
$crud->setRelation('ruta_ruta_id','ruta','{ruta}');
$crud->setPrimaryKey('empresa_id', 'v_cliente_ruta');
$crud->setRelation('clientes_cliente_id','v_cliente_ruta','empresa');+
$crud->setDependentRelation('clientes_cliente_id','ruta_ruta_id','ruta_id');
$crud->setPrimaryKey('empresa_id', 'v_proveedor_ruta');
$crud->setRelation('proveedor_proveedor_id','v_proveedor_ruta','empresa');
$crud->setDependentRelation('proveedor_proveedor_id','ruta_ruta_id','ruta_id');
$crud->setPrimaryKey('patio_id', 'v_patio_ruta');
$crud->setRelation('patio_toma','v_patio_ruta','patio');
$crud->setDependentRelation('patio_toma','ruta_ruta_id','ruta_id');
But it is not working , when i'm adding a new item, as soon as I select the first data dependecy I get an error of JSON malformed
This is the extract that I got
</div>{"total_count":14,"items":[{"id":null,"title":"Altamira"},{"id":null,"title":"Altamira Terminal Portuaria, S.A. de C.V."},{"id":null,"title":"Cooper T. Smith de M?xico, S.A. de C.V. (CTS)"},{"id":null,"title":"Industrias Negromex"},{"id":null,"title":"Infraestructura Portuaria Mexicana S.A. de C."},{"id":null,"title":"Inmobiliaria Portuaria De Altamira S.A. de C."},{"id":null,"title":"Operadora de Terminales Maritimas S.A. de C.V"},{"id":null,"title":"Terminal de LNG de Altamira S. de R.L. de C.V"},{"id":null,"title":"Terminal J. Ray McDermott de M?xico, S.A. de "},{"id":null,"title":"Terminal Maritima de BASF"},{"id":null,"title":"Terminal Maritima de de Altamira, S.A. de C.V"},{"id":null,"title":"Terminal Petroquimica de Altamira, S.A. de C."},{"id":null,"title":"TMM LOGISTICS ATM"},{"id":null,"title":"Vopak Terminals Mexico, S.A. de C.V."}]}
I can see that "id" for all the data is null. Is that a bug? Could you recomend something?
thanks in advance.