[SOLVED] change the user model

[l-vanel]

I want to add some field to the user_identities model and when i read the doc, according the shield concept's, it posiible by using the user provider. But i don't really understand how to.

[datamweb]

Hi @l-vanel,
Thank you for registering your question again in this section.

1. Create a migration file in path app\Database\Migrations\AddCustomColumnForUser with the following content:

<?php

namespace App\Database\Migrations;

use CodeIgniter\Database\Migration;

// Add custom column for shield
class AddCustomColumnForUser extends Migration
{
    public function up()
    {
        
        $fields = [
            "gender SET('male', 'female', 'bisexual') NULL DEFAULT NULL COMMENT 'gender user'",
            'first_name' => [
                'type'       => 'text',
                'constraint' => '50',
                'null'       => TRUE
            ],
            'last_name' => [
                'type'       => 'VARCHAR',
                'constraint' => '50',
                'null'       => TRUE
            ],
            'avatar' => [
                'type'       => 'VARCHAR',
                'constraint' => '1000',
                'null'       => TRUE
            ],
            'phone_number' => [
                'type'       => 'VARCHAR',
                'constraint' => '20',
                'null'       => TRUE
            ],
            'company' => [
                'type'       => 'VARCHAR',
                'constraint' => '100',
                'null'       => TRUE
            ],
            'description' => [
                'type'       => 'VARCHAR',
                'constraint' => '1200',
                'null'       => TRUE
            ],
            'code_meli' => [
                'type'       => 'VARCHAR',
                'constraint' => '20',
                'null'       => TRUE
            ],
            'birth_day date default NULL',
            'country' => [
                'type'       => 'VARCHAR',
                'constraint' => '20',
                'null'       => TRUE
            ],        
            'state' => [
                'type'       => 'VARCHAR',
                'constraint' => '20',
                'null'       => TRUE
            ],
            'city' => [
                'type'       => 'VARCHAR',
                'constraint' => '20',
                'null'       => TRUE
            ],
            'full_address' => [
                'type'       => 'VARCHAR',
                'constraint' => '400',
                'null'       => TRUE
            ],
        

        ];

        $this->forge->addColumn('users', $fields);
    
    }

    public function down()
    {
        $fields = [
            'gender',
            'first_name',
            'last_name',
            'company',
            'phone_number',
            'description',
            'code_meli',
            'birth_day',
            'country',
            'state',
            'city',
            'full_address',

        ];
        $this->forge->dropColumn('users', $fields);
    }
}

2 . Execute command php spark migrate to apply changes to the users table.
3. Checking the addition of columns in table users with command php spark db:table users
4. Create file UserModel.php via php spark shield:model with the following content:

<?php

declare(strict_types=1);

namespace App\Models;

use CodeIgniter\Shield\Models\UserModel as ShieldUserModel;

class UserModel extends ShieldUserModel
{
    protected function initialize(): void
    {
        parent::initialize();

        $this->allowedFields = [
            ...$this->allowedFields,
          'gender',
          'first_name',
          'last_name',
          'avatar',
          'phone_number',
          'company',
          'code_meli',
          'birth_day ',
          'country',
          'state',
          'city',
          'full_address',

            // 'first_name',
        ];
    }
}

6. Edit file app\Config\Auth.php and change as follows:

    public string $userProvider = \App\Models\UserModel::class;

end of work.
Now you can use the same methods as in the documentation without any problems.
e.g :

use CodeIgniter\Shield\Entities\User;

$users = model(\App\Models\UserModel::class);
$user = new User([
    'username' => 'foo-bar',
    'email'    => '[email protected]',
    'password' => 'secret plain text password',
    'first_name' => 'Pooya',
    'last_name' => 'Parsa',
]);
$users->save($user);

more info see
I believe we should document this in Part customization documentation.
Also, thank you very much, after checking this issue, I realized that there are bug in the file Session.php , which we will fix in the next few days.

[datamweb]

What you presented in #766 seems off topic.

However, if you think creating a new table can help you, you can use the following options in file Config/Auth.php.

shield/src/Config/Auth.php

Lines 72 to 80 in 0bf28b2

	public array $tables = [
	'users' => 'users',
	'identities' => 'auth_identities',
	'logins' => 'auth_logins',
	'token_logins' => 'auth_token_logins',
	'remember_tokens' => 'auth_remember_tokens',
	'groups_users' => 'auth_groups_users',
	'permissions_users' => 'auth_permissions_users',
	];

For UUID you can use this .

In general, considering that I have not implemented this issue, I cannot provide an exact solution. However, I believe that by creating a new table, there is a need for changes in other sections.

[solomon-ochepa]

However, I believe that by creating a new table, there is a need for changes in other sections. ...

You are right, that is the reason why I'm suggesting the migration should be publishable to the app migrations dir and the developer can make all the necessary customization. You can relate this with the "Laravel Roles and Permissions" package.

[solomon-ochepa]

For UUID you can use [this ](https://github.com/michalsn/codeigniter4-uuid).

This is not needed as we already have our UUID implementation in place.

[kenjis]

@solomon-ochepa
Thank you for your opinion.

I'm suggesting the migration should be publishable to the app migrations dir and the developer can make all the necessary customization.

That is a reasonable point, but CI4 does not employ such a mechanism.
This is probably largely due to practice in the past of not having to use the CLI.

Making such a change is a big change and requires more agreements on the change.

You can relate this with the "Laravel Roles and Permissions" package.

What do you mean? I don't know what you want to say.

[kenjis]

Can you modify the table?
https://codeigniter4.github.io/CodeIgniter4/dbmgmt/forge.html#modifying-a-field-in-a-table

[l-vanel]

hi , i have one problem , the code work but the data of new customs columns doesn't insert in the database. in other words ,only the username , email and password are insert in the database when i click on the register

[datamweb]

Hey vanel ,

 $users = model('UserModel'); 

Change to

 $users = model('App\Models\UserModel');

Did your problem get solved?

[l-vanel]

Now my problem is about the insertion of datas

[datamweb]

OK, let me test myself by tomorrow. It is now 4:30 am.

[datamweb]

Now my problem is about the insertion of datas

@l-vanel, I know that you are new to this part of GitHub. Therefore, first of all, I will explain the following things to you.

1. You should not use edit to change the question. This will make the readers not understand what your question was and why you received such an answer.
2. Try to ask your questions separately. For example, the title of this was change the user model, but then you made another request.
3. When inserting your code, you should do the following, this will make the reader feel good.(more info see)

```php
// php code 
```
OR 
```html
// html code
```

4. There is no need for a personal message, all questions here are reviewed by members. If you do not receive a response, be sure that there was no response time or ability.
   Remember that these explanations are not just for you, these explanations are true for everyone.

Let's go, to answer your question.

[l-vanel]

Ok, thanks. Le sam. 6 août 2022 à 00:49, Pooya Parsa Dadashi ***@***.***> a écrit :

…

OK, let me test myself by tomorrow. It is now 4:30 am. — Reply to this email directly, view it on GitHub <#333 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AOVUTKJA52X2G6ZK6QDDEQDVXWSCJANCNFSM55MLAR5A> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[datamweb]

Your question is how can I save the values of gender, first_name, last_name and ... in the database in addition to email, username and password on the registration page.

[datamweb]

Answer Do the following steps:

1. Add in the view file(Please use the customization of views)

<!-- Gender-->
<div class="mb-4">
<select id="gender" class="form-control" name="gender" placeholder="<?= lang('Auth.gender') ?>>
<option value="male">Male</option>
<option value="female">Female</option>
<option value="bisexual">Bisexual</option>
</select>
</div>
<!-- First Name-->
<div class="mb-4">
 <input type="text" class="form-control" name="first_name" inputmode="text" autocomplete="first_name" placeholder="<?= lang('Auth.first_name') ?>" value="<?= old('first_name') ?>" required />
</div>
<!-- Last Name-->
<div class="mb-4">
<input type="text" class="form-control" name="last_name" inputmode="text" autocomplete="last_name" placeholder="<?= lang('Auth.last_name') ?>" value="<?= old('last_name') ?>" required />
</div>

2. in file app/Config/Auth.php add :

    public array $personalFields = ['gender','first_name', 'last_name'];

3. in file app\Config\Validation.php add :

       //--------------------------------------------------------------------
    // Rules
    //--------------------------------------------------------------------
    public $registration = [
        'username'         => [
                'required',
                'max_length[30]',
                'min_length[3]',
                'regex_match[/\A[a-zA-Z0-9\.]+\z/]',
                'is_unique[users.username]',
            ],
        'email'            => 'required|max_length[254]|valid_email|is_unique[auth_identities.secret]',
        'gender' => 'in_list[male,female,bisexual]',
        'first_name' => 'required|alpha|min_length[3]|max_length[10]',
        'last_name' => 'required|alpha|min_length[3]|max_length[15]',
        'password'         => 'required|strong_password',
        'password_confirm' => 'required|matches[password]',
    ];

Do the same for other fields.

Did I understand your question correctly and was the answer complete?

[l-vanel]

yes it's work. thks