public function actionView()
{
$dataProvider = new ActiveDataProvider(['query' => Register::find()->orderBy('dateCreation DESC'), 'pagination' => ['pageSize' => 5]]);
return $this->render('view', ['registerDataProvider' => $dataProvider]);
}
public function actionView_register()
{
$reg = Register::find()->all();
return $this->render('view_register', ['reg' => $reg]);
}
/**
*
************ @var profile save and Update *******/
public function profileSave($data)
{
/************* get Query User table *******/
$user = User::findOne(Yii::$app->user->id);
$Id = $user['id'];
$uId = $user['uId'];
$MemId = $user['MemId'];
/************* get Query Register table *******/
$userInfo = Register::find()->where(['uid' => $uId])->one();
$Id = $userInfo['id'];
if ($userInfo) {
$userInfo->firstname = $data['Register']['firstname'];
$userInfo->middlename = $data['Register']['middlename'];
$userInfo->lastname = $data['Register']['lastname'];
$userInfo->email = $data['Register']['email'];
$userInfo->city = $data['Register']['city'];
$userInfo->state = $data['Register']['state'];
$userInfo->country = $data['Register']['country'];
$userInfo->zip = $data['Register']['zip'];
$userInfo->secondLanguage = $data['Register']['secondLanguage'];
$userInfo->thirdLanguage = $data['Register']['thirdLanguage'];
$userInfo->address = $data['Register']['address'];
$userInfo->address2 = $data['Register']['address2'];
$userInfo->dob = $data['Register']['dob'];
/************* Update Query *******/
$command = Yii::$app->db->createCommand("UPDATE register SET\n\t\t\t\t \t\t\tfirstname ='{$userInfo->firstname}',\n\t\t\t\t \t\t\tmiddlename ='{$userInfo->middlename}',\n\t\t\t\t \t\t\tlastname ='{$userInfo->lastname}',\n\t\t\t\t \t\t\temail ='{$userInfo->email}',\n\t\t\t\t \t\t\tcity ='{$userInfo->city}',\n\t\t\t\t \t\t\tstate ='{$userInfo->state}',\n\t\t\t\t \t\t\tcountry ='{$userInfo->country}',\n\t\t\t\t \t\t\tzip ='{$userInfo->zip}',\n\t\t\t\t \t\t\tsecondLanguage ='{$userInfo->secondLanguage}',\n\t\t\t\t \t\t\tthirdLanguage ='{$userInfo->thirdLanguage}',\n\t\t\t\t \t\t\taddress ='{$userInfo->address}',\n\t\t\t\t \t\t\taddress2 ='{$userInfo->address2}',\n\t\t\t\t \t\t\tdob ='{$userInfo->dob}'\n\t\t\t\t \t\t\tWHERE id ='{$Id}'");
$command->execute();
return $userInfo;
} else {
$this->firstname = $data['UserprofileForm']['firstname'];
$this->lastname = $data['UserprofileForm']['lastname'];
$this->middlename = $data['UserprofileForm']['middlename'];
$this->email = $data['UserprofileForm']['email'];
$this->city = $data['UserprofileForm']['city'];
$this->state = $data['UserprofileForm']['state'];
$this->country = $data['UserprofileForm']['country'];
$this->zip = $data['UserprofileForm']['zip'];
$this->secondLanguage = $data['UserprofileForm']['secondLanguage'];
$this->thirdLanguage = $data['UserprofileForm']['thirdLanguage'];
$this->address = $data['UserprofileForm']['address'];
$this->address2 = $data['UserprofileForm']['address2'];
$this->dob = $data['UserprofileForm']['dob'];
/************* Insert Query Into Register table *******/
$data = Yii::$app->db->createCommand()->insert('register', ['firstname' => $this->firstname, 'lastname' => $this->lastname, 'middlename' => $this->middlename, 'email' => $this->email, 'city' => $this->city, 'state' => $this->state, 'country' => $this->country, 'zip' => $this->zip, 'secondLanguage' => $this->secondLanguage, 'thirdLanguage' => $this->thirdLanguage, 'address' => $this->address, 'address2' => $this->address2, 'dob' => $this->dob, 'createdDate' => date("Y-m-d H:i:s"), 'id' => $Id, 'uId' => $uId, 'MemId' => $MemId])->execute();
return $data;
}
}
