Afternoon All,
So i am very new to PHP and Yii etc, i have working with VBA and SQL before but again not very much.
I have the Yii2 advanced Framework and have added a field to the User table.
I thought i had added to the relevent places but i am getting an error
i am not 100% sure what part of the code you would like to see as it passes through 2 or 3 models.
But let me know and i will edit and paste in.
Appreciate any help in advanced.
First of all, restart your PHP (or webserver) to make sure schema is not cached.
Then please show your model which errors i.e. SignupForm.
So i have restart Apache which in my understanding restarts PHP?
<?php
namespace frontend\models;
use common\models\User;
use common\rbac\helpers\RbacHelper;
use nenad\passwordStrength\StrengthValidator;
use yii\base\Model;
use Yii;
/**
* Model representing Signup Form.
*/
class SignupForm extends Model
{
public $username;
public $email;
public $customer_id;
public $password;
public $status;
/**
* Returns the validation rules for attributes.
*
* @return array
*/
public function rules()
{
return [
['username', 'filter', 'filter' => 'trim'],
['username', 'required'],
['username', 'string', 'min' => 2, 'max' => 255],
['username', 'unique', 'targetClass' => '\common\models\User',
'message' => 'This username has already been taken.'],
['email', 'filter', 'filter' => 'trim'],
['email', 'required'],
['email', 'email'],
['email', 'string', 'max' => 255],
['email', 'unique', 'targetClass' => '\common\models\User',
'message' => 'This email address has already been taken.'],
['password', 'required'],
// use passwordStrengthRule() method to determine password strength
$this->passwordStrengthRule(),
// on default scenario, user status is set to active
['status', 'default', 'value' => User::STATUS_ACTIVE, 'on' => 'default'],
// status is set to not active on rna (registration needs activation) scenario
['status', 'default', 'value' => User::STATUS_NOT_ACTIVE, 'on' => 'rna'],
// status has to be integer value in the given range. Check User model.
['status', 'in', 'range' => [User::STATUS_NOT_ACTIVE, User::STATUS_ACTIVE]]
];
}
/**
* Set password rule based on our setting value (Force Strong Password).
*
* @return array Password strength rule
*/
private function passwordStrengthRule()
{
// get setting value for 'Force Strong Password'
$fsp = Yii::$app->params['fsp'];
// password strength rule is determined by StrengthValidator
// presets are located in: vendor/nenad/yii2-password-strength/presets.php
$strong = [['password'], StrengthValidator::className(), 'preset'=>'normal'];
// use normal yii rule
$normal = ['password', 'string', 'min' => 6];
// if 'Force Strong Password' is set to 'true' use $strong rule, else use $normal rule
return ($fsp) ? $strong : $normal;
}
/**
* Returns the attribute labels.
*
* @return array
*/
public function attributeLabels()
{
return [
'username' => Yii::t('app', 'Username'),
'password' => Yii::t('app', 'Password'),
'customer_id' => yii::t('app','Customer ID'),
'email' => Yii::t('app', 'Email'),
];
}
/**
* Signs up the user.
* If scenario is set to "rna" (registration needs activation), this means
* that user need to activate his account using email confirmation method.
*
* @return User|null The saved model or null if saving fails.
*/
public function signup()
{
$user = new User();
$user->username = $this->username;
$user->email = $this->email;
$user->customer_ID = $this->customer_ID;
$user->setPassword($this->password);
$user->generateAuthKey();
$user->status = $this->status;
// if scenario is "rna" we will generate account activation token
if ($this->scenario === 'rna')
{
$user->generateAccountActivationToken();
}
// if user is saved and role is assigned return user object
return $user->save() && RbacHelper::assignRole($user->getId()) ? $user : null;
}
/**
* Sends email to registered user with account activation link.
*
* @param object $user Registered user.
* @return bool Whether the message has been sent successfully.
*/
public function sendAccountActivationEmail($user)
{
return Yii::$app->mailer->compose('accountActivationToken', ['user' => $user])
->setFrom([Yii::$app->params['supportEmail'] => Yii::$app->name . ' robot'])
->setTo($this->email)
->setSubject('Account activation for ' . Yii::$app->name)
->send();
}
}
Note the case. You have Customer_ID, customer_ID, customer_id.