DataTables Editor - joined tables example

estudios

Can you provide the name of the table and the fields in each table. I am confused with the sintaxis trying to understand
Thanks a lot

estudios

Alan, I gonna write a few more to clarify my questions...

I want to get the field named "razsoc" from the table named "empresas".
I have, in the table named "contactos", a field named "idempresa" and I have, in the table named "empresas", the fields named "id" and other named "razsoc"

What is wrong

My php code:
Editor::inst( $db, 'contactos' )
->fields(
Field::inst( 'nombre' ),
Field::inst( 'pais' ),
Field::inst( 'direccion' ),
Field::inst( 'email' ),
Field::inst( 'tel1' ),
Field::inst( 'iva' ),
Field::inst( 'cuit' ),
Field::inst( 'notas' )
)
->join(
Join::inst( 'empresas', 'object' )
->join( 'idempresa', 'id' )
->fields( Field::inst( 'razsoc' ))
)

->process( $_POST )
->json();

And my js code:
$('#EEcontactos').dataTable( {
"sDom": "Tfrtip",
"sAjaxSource": "php/_table.EEcontactos.php",
"aoColumns": [
{"mData": "nombre"},
{"mData": "pais"},
{"mData": "email"},
{"mData": "tel1"},
{"mData": "empresas.razsoc",
"sDefaultContent": ""}

],
"oTableTools": {
"sRowSelect": "single",
"aButtons": [
{ "sExtends": "editor_create", "editor": editor },
{ "sExtends": "editor_edit", "editor": editor },
{ "sExtends": "editor_remove", "editor": editor }
]
},
"fnInitComplete": function ( settings, json ) {
// Set the allowed values based on
// what is available in the database
editor.field('idempresa').update( json.empresas );
}

} );

allan

That almost looks okay to me.

I think you need an extra little bit of code to get whatever it is you want into `json.empresas` (possibly something like in this example http://editor.datatables.net/release/DataTables/extras/Editor/examples/join.html ), but the basic structure looks fine other than that. Are you getting an error somewhere?

Allan

estudios

Thanks a lot.

yes I got an error JSON not be parsed...etc and if I delete the following code no error but no data from the "empresas" table

->join(
Join::inst( 'empresas', 'object' )
->join( 'idempresa', 'id' )
->fields( Field::inst( 'razsoc' ))
)

again thanks a lot

estudios

few more steps

It seems that I have diferent tables structure and I am using join in the wrong way

My tables are
1) CREATE TABLE `contactos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idempresa` int(11) DEFAULT NULL,
`nombre` char(30) DEFAULT NULL,
PRIMARY KEY (`id`))
2) CREATE TABLE `empresas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`razsoc` char(100) CHARACTER SET latin1 DEFAULT NULL,
PRIMARY KEY (`id`))

field "idempresa" in table "contactos" is relationated with field "id" in table "empresas"

I want to see a list with "nombre" from table "contactos" and "razsoc" from table "empresas"

I would appreciate very much your help

thanks a lot

allan

> yes I got an error JSON not be parsed...etc

Okay - that's quite important. What is actually being returned from the server? Likely there is an error message shown which will indicate what the problem is.

Thanks,
Allan

estudios

Alan, the error is: DataTables warning (table id=EEcontactos): DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.

I am still can not join the tables. Should I pay 1 hour support to get more help?

Thanks a lot

allan

We need to know what the JSON return from the server is. The error message is telling you that its not valid JSON, but we need to know what it actually - likely it will contain an error message which will hopefully lead us to a solution. You can find out what is actually being returned by using Firebug or Inspector or similar.

You are most welcome to pick up DataTables support :-). It would allow me to prioritise your questions and respond as quickly as possible.

Allan

estudios

I got the error, solve one and got another. I do not have join.php file in this path. Do you know why?

Warning: require(/var/www/consultas/php/lib/Editor/Join.php) [function.require]: failed to open stream: No such file or directory in /var/www/consultas/php/lib/Bootstrap.php on line 48

Fatal error: require() [function.require]: Failed opening required '/var/www/consultas/php/lib/Editor/Join.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/consultas/php/lib/Bootstrap.php on line 48

I file the request for support to my administrative manager. As soon as I get the approval I gonna load the support fee.

Thanks

allan

Have you downloaded the full Editor package from https://editor.datatables.net/download ? The trial version of Editor doesn't include the Join.php file, but the licensed download package (which you should be able to download since you have a license :-) ) does include that file.

Regards,
Allan

estudios

almost done.

The table looks good and the editor Windows also.B

BUT if I change the type TEXT for SELECT, no data is avalilable for selection

allan

Have you supplied it with data using the `ipOpts` option? Example: http://editor.datatables.net/release/DataTables/extras/Editor/examples/fieldTypes.html

Allan