EDITOR DATATABLE AJAX POST IS EMPTY ARRAY ON CI4

chamssoudine

Hello,

I need to experiment Editor Datatable on CI4, first attempt everything was working and then all crached. I spend two days trying to found the issue but always failed. if someone can help fix it.

Credentials :

https://comebillets.com/agenceamani.com/login
Login : admin@example.com
Pass: admin

Editor link : https://comebillets.com/agenceamani.com/loyers

DataTables warning: table id=loyersTable - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1:
Status code 200 OK but $_POST variable is empty on the CI4 controller

kthorngren

but $_POST variable is empty on the CI4 controller

This i your Datatables ajax config:

        ajax: {
            url: "https://comebillets.com/agenceamani.com/Auth/LoyersController/ViewLoyers",
            type: "POST"
        },

Are you expecting POST parameters to be sent? If so then use ajax.data.

This is the JSON response:

Array ( )

I'm not familiar with Codeigniter but maybe this SO thread will give you some ideas of how to return the JSON response. Debugging why the array is empty would require debugging the server script. There is nothing we can look at on the client side to help with this issue.

Kevin

chamssoudine

Hello Kevin,

My Controller is function :

public function ViewLoyers()
    {
        try {
            if (! $this->session->isLoggedIn) {
                return redirect()->to('login');
            }
            $editor = new EditorLib();
            print_r($_POST);
            $result = $editor->loyers($_POST);

            // Handle the result if needed
        } catch (\Exception $e) {
            // Log or handle the exception
            echo 'Caught exception: ',  $e->getMessage(), "\n";
        }
    }

$_POST variable is empty, is not supposed to post the table columns ? to model? im confused.

//Model

<?php

namespace App\Models;
//require_once APPPATH . 'Libraries/EditorLib/DataTables.php';

use CodeIgniter\Model;
use DataTables\Editor;
use DataTables\Editor\Field;
use DataTables\Editor\Format;
use DataTables\Editor\Join;
use DataTables\Editor\Upload;
use DataTables\Editor\Validate;
use DataTables\Editor\ValidateOptions;

class LoyersModel extends Model
{
    protected $table = 'properties';
    protected $primaryKey = 'id';
    protected $allowedFields = ['Title', 'Description', 'Price', 'Location', 'Type', 'Status'];
    
    private $editorDb = null;
     
    public function init($editorDb)
    {
        $this->editorDb = $editorDb;
    }

    public function getLoyers($post)
    {
        try {
            // Initialize the Editor instance with the database connection and table name
            $editor = new Editor($this->editorDb, 'properties');
            $editor->leftJoin('properties_details', 'properties.id', '=', 'properties_details.propId');

            // Define fields with validators
            $editor->fields(
                Field::inst('properties.Title')->validator('Validate::notEmpty'),
                Field::inst('properties.Description')->validator('Validate::notEmpty'),
                Field::inst('properties.Price'),
                Field::inst('properties.Location')->validator('Validate::notEmpty'),
                Field::inst('properties.Type')->validator('Validate::notEmpty'),
                Field::inst('properties.Status')->validator('Validate::notEmpty'),
                Field::inst('properties_details.NumBedrooms'),
                Field::inst('properties_details.NumBathrooms'),
                Field::inst('properties_details.Area'),
                Field::inst('properties_details.ParkingSpaces'),
                Field::inst('properties_details.HasGarden'),
                Field::inst('properties_details.HasGarage')
            );

            // Enable debugging (optional)
            $editor->debug(true);

            // Process the request and return JSON response
            $result = $editor->process($post)->json();

            return $result;
        } catch (\Exception $e) {
            // Handle any exceptions or errors
            return ['error' => $e->getMessage()];
        }
    }


} 

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

chamssoudine

Noted that same code is working on CI3

kthorngren

$_POST variable is empty, is not supposed to post the table columns ? to model? im confused.

Only when serverSide is enabled will the server side processing parameters be sent to the server. Are the server side processing parameters what you are expecting to be sent?

Kevin

chamssoudine

Js code look like :

const editor = new DataTable.Editor({
        ajax: '<?php echo site_url("Auth/LoyersController/ViewLoyers")  ?>',
        fields: [
            {
                label: "Titre:",
                name: "properties.Title",
            },
            {
                label: "Description:",
                name: "properties.Description",
                type: "textarea",
            },
            {
                label: "Prix:",
                name: "properties.Price",
            },
            {
                label: "Location:",
                name: "properties.Location",
            },

 const table = new DataTable("#loyersTable", {
        ajax: {
            url: "<?php echo site_url() ?>Auth/LoyersController/ViewLoyers",
            type: "POST",
        },
        buttons: [
            { extend: "create", editor },
            { extend: "edit", editor },
            { extend: "remove", editor },
        ],
        dom: "lQBfrtip",
        order: [1, "asc"],
        responsive: true,
        //scrollX: true,
        select: {
            style: "os",
            selector: "td:first-child",
        },
        columns: [
            {
                data: null,
                defaultContent: "",
                className: "select-checkbox",
                orderable: false,
            },
            { data: "properties.Title" },
            { data: "properties.Description" },
            { data: "properties.Price" },
            { data: "properties.Location" },
            { data: "properties.Type" },
            { data: "properties.Status" },
            { data: "properties_details.NumBedrooms" },
            { data: "properties_details.NumBathrooms" },
            { data: "properties_details.Area" },
            { data: "properties_details.ParkingSpaces" },
            { data: "properties_details.HasGarden" },
            { data: "properties_details.HasGarage" },
        ],

Edited by Allan to add syntax highlighting

allan

With that initialisation, a POST request, with no data parameters will be sent to ViewLoyers when the DataTable is initialised.

For create, edit and delete actions, Editor will POST data in the format shown here to the same route.

At the moment ViewLoywers is returning:

Array
(
)

which looks like a PHP print_r() statement. That isn't valid JSON, hence the error.

What I would suggest doing is adding some logging to make sure that you are getting into the getLoyers method, and where in it you are getting to.

Allan

chamssoudine

Hello Allan,

Thank you, the issue was here : DB code was deleted by error.

$this->loyersModel->init($db);

public function loyers($post)
{
// DataTables PHP library
require_once APPPATH . 'Libraries/EditorLib/DataTables.php';
$this->loyersModel->init($db);
return $this->loyersModel->getLoyers($post);
}

allan

No worries - good to hear you got it working.

Allan