Bdtjtk

I am new developer in CakePHP and PHP.

I have 2 tables: Tasks, Users and Customers.

Among others Tasks has this foreign key linked to Users table: Assigned_from and the foreign key Customer_id linked to Customers table.

So in UsersTable.php I have inserted these lines:

Function initialize :

$this->hasMany('TasksFrom', [

            'foreignKey' => 'assigned_From',

            'className' => 'Tasks'

        ]);

Function buildrules :

$rules->add($rules->existsIn(['assigned_from'], 'TasksFrom'));

Accordingly in TasksTable.php :
Function initialize :

$this->belongsTo('UsersFrom', [

        'foreignKey' => 'assigned_from',

        'className' => 'Users'

    ]);

Function buildrules :

$rules->add($rules->existsIn(['assigned_from'], 'UsersFrom'));

And in CustomersTable.php:

Function Initialize:

$this->hasMany('Tasks', [

            'foreignKey' => 'customer_id'

        ]);

So in order to show this information in the User view I have added these lines in UsersController.php :

public function view($id = null)

{

    $user = $this->Users->get($id,[

        'contain' => ['TasksTo', 'TasksFrom', 'TasksBy']

    ]); 

    $this->set('user', $user);

}

How I can modify my code in order to display User Name instead of User Id when accessing echo $task->assigned_from and Customer name instead of Customer_id when accessing echo $task->customer_id?

Here is the current code in users/view.ctp:

foreach ($user->tasks_to as $task) {





            ?>

                <tr  id="<?php echo $task['id'] ?>">

                    <td><?php echo $task->priority ?></td>

                    <td><?php echo $task->name ?></td>

                    <td><?php echo $task->instructions ?></td>

                    <td><?php echo $task->assigned_from ?></td>   //It displays user id, I want to display user name

                    <td><?php echo $task->customer_id ?></td>     //Display Customer name instead of Customer_id

                    <td><?php echo $task->progress ?></td>                            

                </tr>

            <?php } ?>

Debug output debug($user->tasks_to):

(int) 1 => object(AppModelEntityTask) {



        'id' => (int) 2,

        'name' => 'Design Logo for Website',

        'task_type_id' => (int) 1,

        'role_id' => (int) 5,

        'instructions' => 'Design logo for website.com website, (instructions)',

        'date_start' => object(CakeI18nFrozenDate) {



            'time' => '2018-12-20T00:00:00+00:00',

            'timezone' => 'UTC',

            'fixedNowTime' => false



        },

        'date_end' => object(CakeI18nFrozenDate) {



            'time' => '2018-12-22T00:00:00+00:00',

            'timezone' => 'UTC',

            'fixedNowTime' => false



        },

        'total_minutes' => (int) 120,

        'assigned_to' => (int) 1,

        'assigned_from' => (int) 1,

        'customer_id' => (int) 1,

        'progress' => null,

        'progress_weight_id' => (int) 2,

        'priority' => (int) 1,

        'status_id' => (int) 2,

        'shared_folder_path' => 'path_to_logo_files',

        'created_by' => null,

        'created_date' => null,

        'price' => (float) 0,

        'cost' => (float) 0,

        'project_status' => object(AppModelEntityProjectStatus) {



            'id' => (int) 2,

            'status' => 'Running',

            '[new]' => false,

            '[accessible]' => [

                'status' => true

            ],

            '[dirty]' => ,

            '[original]' => ,

            '[virtual]' => ,

            '[errors]' => ,

            '[invalid]' => ,

            '[repository]' => 'ProjectStatus'



        },

        '[new]' => false,

        '[accessible]' => [

            'name' => true,

            'task_type_id' => true,

            'role_id' => true,

            'instructions' => true,

            'date_start' => true,

            'date_end' => true,

            'total_minutes' => true,

            'assigned_to' => true,

            'assigned_from' => true,

            'customer_id' => true,

            'progress' => true,

            'progress_weight_id' => true,

            'priority' => true,

            'status_id' => true,

            'shared_folder_path' => true,

            'created_by' => true,

            'created_date' => true,

            'price' => true,

            'cost' => true,

            'task_type' => true,

            'role' => true,

            'users_to' => true,

            'users_from' => true,

            'users_by' => true,

            'user' => true,

            'customer' => true,

            'progress_weight_label' => true,

            'project_status' => true,

            'transactions' => true

        ],

        '[dirty]' => ,

        '[original]' => ,

        '[virtual]' => ,

        '[errors]' => ,

        '[invalid]' => ,

        '[repository]' => 'TasksTo'



    }

]

<td><?php echo $task->assigned_from ?></td>   

//It displays user id, I want to display user name

Something like:

<?= $task->users_from->name ?>

and

<td><?php echo $task->customer_id ?></td>

//Display Customer name instead of Customer_id

like:

<?= $task->customers->name ?>