Undefined Index when I use an Entity which it`s primary key is a foreign key

[guillermo26]

Hi!!

I´m using this bundle and i`m getting 'undefined index' error when I use an entity that has a primary key wich is a foreign key at the same time. This is my code:

public function getUserTableAction() {
$datatable = $this->get('lankit_datatables')->getDatatable('ErictelValetBundle:TDevices');
return $datatable->getSearchResults();
}

And this are the associations of entity TDevices:

Erictel\ValetBundle\Entity\TDevices:
type: entity
table: t_devices
id:
deviceInfo:
associationKey: true
fields:
jid:
type: string
length: 45
fixed: false
nullable: false
oneToOne:
deviceInfo:
targetEntity: TDeviceInfo
cascade: { }
mappedBy: null
inversedBy: null
joinColumns:
device_info_id:
referencedColumnName: id
orphanRemoval: false
manyToOne:
state:
targetEntity: TStates
cascade: { }
mappedBy: null
inversedBy: null
joinColumns:
state_id:
referencedColumnName: id
orphanRemoval: false
user:
targetEntity: TUsers
cascade: { }
mappedBy: null
inversedBy: null
joinColumns:
user_id:
referencedColumnName: id
orphanRemoval: false
serviceIsActive:
targetEntity: TServiceStateCodes
cascade: { }
mappedBy: null
inversedBy: null
joinColumns:
service_id:
referencedColumnName: id
orphanRemoval: false
lifecycleCallbacks: { }

And this is the error:

Notice: Undefined index: TDevices in /var/www/valet_parking/vendor/lankit/datatables-bundle/LanKit/DatatablesBundle/Datatables/Datatable.php line 562.

Can anybody help me??

Thanks in advance

[ChadSikorra]

Interesting, I'll have to setup some test entities to look into this. It's possible I'm not handling the identifiers properly in this case when I do...

        $identifiers = $this->metadata->getIdentifierFieldNames();
        $this->rootEntityIdentifier = array_shift($identifiers);

It would be interesting to see what rootEntityIdenitifier ends up as if you do a var_dump.

[guillermo26]

I was able to know what was the problem of the undefined index. In this part of the code of datatables.php:

public function setSelect(QueryBuilder $qb)
{
       $columns = array();
        $partials = array();

        // Make sure all related joins are added as needed columns. A column many entities deep may rely on a
        // column not specifically requested in the mData
        foreach (array_keys($this->assignedJoins) as $joinName) {
            $columns[$joinName] = array();
        }

        // Combine all columns to pull
        foreach ($this->associations as $column) {
            $parts = explode('.', $column['fullName']);
            $columns[$parts[0]][] = $parts[1];
        }

        // Partial column results on entities require that we include the identifier as part of the selection
        foreach ($this->identifiers as $joinName => $identifiers) {
            if (!in_array($identifiers[0], $columns[$joinName])) {
                array_unshift($columns[$joinName], $identifiers[0]);
            }
        }

You don`t put the index $columns[$this->tableName] if I don´t specify any field of the table that is not foreign key. If i ask for this fields:

"aoColumns": [
                    {"mData": "user.lastName"},
                    {"mData": "user.login"}, 
                    {"mData": "user.email"}, 
                    {"mData": "user.phoneNumber"}, 
                    {"mData": "deviceInfo.phoneNumber"}, 
                    {"mData": "serviceIsActive.id"}
                ],

But if I add the only field that is not foreign key:

"aoColumns": [
                    {"mData": "user.lastName"},
                    {"mData": "user.login"}, 
                    {"mData": "user.email"}, 
                    {"mData": "user.phoneNumber"}, 
                    {"mData": "deviceInfo.phoneNumber"}, 
              -->  {"mData": "jid"}, 
                    {"mData": "serviceIsActive.id"}
                ],

The problem is fixed, but now I'm getting this error:

[Semantical Error] line 0, col 183 near '} FROM Erictel\ValetBundle\Entity\TDevices': Error: There is no mapped field named 'deviceInfo' on class Erictel\ValetBundle\Entity\TDevices.

Do you know why??
Thanks for your help.