Problem with JS

equintanilla82

Hi guys, I use the following URLS but now both stop working:

https://cdn.datatables.net/v/dt/jszip-2.5.0/pdfmake-0.1.18/dt-1.10.12/af-2.1.2/b-1.2.2/b-colvis-1.2.2/b-flash-1.2.2/b-html5-1.2.2/b-print-1.2.2/cr-1.3.2/fc-3.2.2/fh-3.1.2/kt-2.1.3/r-2.1.0/rr-1.1.2/sc-1.4.2/se-1.2.0/datatables.min.css

https://cdn.datatables.net/v/dt/jszip-2.5.0/pdfmake-0.1.18/dt-1.10.12/af-2.1.2/b-1.2.2/b-colvis-1.2.2/b-flash-1.2.2/b-html5-1.2.2/b-print-1.2.2/cr-1.3.2/fc-3.2.2/fh-3.1.2/kt-2.1.3/r-2.1.0/rr-1.1.2/sc-1.4.2/se-1.2.0/datatables.min.js

Some hints or help will be great!
Thank you in advance!
Eduardo

colin

They appear to be working for me. Can you elaborate on the problem you're seeing, please?

Colin

equintanilla82

Thank you Collin, I thought it was those links.

I am totally new. I am learning some PHP programming but to tell you the truth, I download an example to understand how to build the code to use the Editor.

The link is: https://eldesvandejose.com/2016/12/07/el-editor-de-datatables-ii-funcionamiento-basico/

The problem is that the code in that example does not launch the action in the buttons: Edit - New - Delete.

I thought the problem was those links.

I have no idea where to download a complete example with the editor. The examples on the official webpage are too hard to follow. I do not know where to paste the code they mention. I do not know if all the examples has to be in one php file, or how to structure the folder with one or several php files.

Do you know a website to download a complete example?

Thank you in advance!
Eduardo

tangerine

The link is: https://eldesvandejose.com/2016/12/07/el-editor-de-datatables-ii-funcionamiento-basico/
The problem is that the code in that example does not launch the action in the buttons: Edit - New - Delete.

Have you tried referring the problem to the author of that tutorial?

equintanilla82

Thank you Tangerine for your comment.
Yes I tried, but it seems really old the website. Since 2016!! The last comment was last year in January.

If I just have a complete example of editor with two relation-tables will be great!

I used the generator, but it only allows the data of one table

colin

As tangerine said, if you want support on that document, you'll need to speak to the author.

We have a manual with installation instructions, which also talks about joins, and in-depth reference pages with examples.

I'd say look at those, see how you go, and if no success, please report back and we'll see if we can help you,

Colin

equintanilla82

Thank you Colin for your answer. I decided to start from scratch with my own code, because the author of my last question is not answering my questions.

I used the generator to create an example and start joining tables.

Now I am trying to follow your instructions on the "examples" page, but I am stock.

Could you please take a look of my database and code?
I am lost in the last file "Server script".

DATABASE:

JAVASCRIPT CODE:

(function($){

$(document).ready(function() {
    var editor = new $.fn.dataTable.Editor( {
        ajax: 'php/table.Proyectos.php',
        table: '#Proyectos',
        fields: [
            {
                "label": "nombredelproyecto:",
                "name": "Proyectos.nombredelproyecto"
            },
            {
                "label": "estatus:",
                "name": "Proyectos.id_estatus"
            },
            {
                "label": "nombregenerico:",
                "name": "Proyectos.nombregenerico"
            },
            {
                "label": "formafarmaceutica:",
                "name": "Proyectos.formafarmaceutica"
            },
            {
                "label": "fechainicio:",
                "name": "Proyectos.fechainicio",
                "type": "datetime",
                "format": "ddd, D MMM YY"
            }
        ]
    } );

    var table = $('#Proyectos').DataTable( {
        dom: 'Bfrtip',
        ajax: {
            url: "php/table.Proyectos.php",
            type: 'POST'
        },
        columns: [
            {
                "data": "Proyectos.nombredelproyecto"
            },
            {
                "data": "Estatus.estatus"
            },
            {
                "data": "Proyectos.nombregenerico"
            },
            {
                "data": "Proyectos.formafarmaceutica"
            },
            {
                "data": "Proyectos.fechainicio"
            }
        ],
        select: true,
        lengthChange: false,
        buttons: [
            { extend: 'create', editor: editor },
            { extend: 'edit',   editor: editor },
            { extend: 'remove', editor: editor }
        ]
    } );
} );

}(jQuery));

SERVER SCRIPT:

<?php

// DataTables PHP library and database connection
include( "lib/DataTables.php" );

// Alias Editor classes so they are easy to use
use
    DataTables\Editor,
    DataTables\Editor\Field,
    DataTables\Editor\Format,
    DataTables\Editor\Mjoin,
    DataTables\Editor\Options,
    DataTables\Editor\Upload,
    DataTables\Editor\Validate,
    DataTables\Editor\ValidateOptions;



// Build our Editor instance and process the data coming from _POST
Editor::inst( $db, 'Proyectos', 'id')
    ->fields(
        Field::inst( 'Proyectos.nombredelproyecto' ),
        Field::inst( 'Proyectos.id_estatus' )
            ->options( Options::inst()
                ->table( 'Estatus' )
                ->value( 'id' )
                ->label( 'estatus' )
            ),
            ->validator( Validate::dbValues() )
            Field::inst( 'Estatus.estatus' ),   
        Field::inst( 'Proyectos.nombregenerico' ),
        Field::inst( 'Proyectos.formafarmaceutica' ),
        Field::inst( 'Proyectos.fechainicio' )
            ->validator( Validate::dateFormat( 'D, j M y' ) )
            ->getFormatter( Format::dateSqlToFormat( 'D, j M y' ) )
            ->setFormatter( Format::dateFormatToSql( 'D, j M y' ) )
    )
    ->leftJoin( 'Estatus', 'id', '=', 'Proyectos.id_estatus' )
    ->process( $_POST )
    ->json();

Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.

colin

When you say you're stuck, what's the problem? Are you seeing errors?

Colin

equintanilla82

Hi Collin, you are very kind.
The error says:
DataTables warning: table id=Proyectos - Ajax error. For more information about this error, please see http://datatables.net/tn/7

I ran the instructions of the Help-page and this appears:

colin

The link in the error code is the place to start. It'll suggest diagnostic steps to try.

Colin

equintanilla82

Dear Colin, I did it!! Thank you for your advice!!