public function safeDown() { // drop tables in reverse order (for foreign key constraints) $this->dropTable(Profile::tableName()); $this->dropTable(UserKey::tableName()); $this->dropTable(User::tableName()); $this->dropTable(Role::tableName()); }
/** * Deletes an existing UserCv model. * If deletion is successful, the browser will be redirected to the 'index' page. * @param integer $id * @return mixed */ public function actionDelete($id) { $model = $this->findModel($id); $user = User::findOne(['id' => $model->user_id]); $profile = Profile::findOne(['user_id' => $model->user_id]); $userabonnement = UserAbonnement::findOne(['user_id' => $model->user_id]); UserActivedays::deleteAll(['user_id' => $model->user_id]); $profile->delete(); $usertarieven = UserTarieven::deleteAll(['user_id' => $model->user_id]); UserReistarief::deleteAll(['user_id' => $model->user_id]); if ($userabonnement) { $userabonnement->delete(); } $model->delete(); $user->delete(); return $this->redirect(['index']); }
/** * Updates an existing Company model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate() { $userid = Yii::$app->user->identity; // if(!$userid) return; $user = User::findOne($userid->id); $company = Company::findOne(['user_id' => $userid->id]); $tarievenDag = UserTarievenDag::findOne(['user_id' => $user->id, 'naam' => 'Dagdienst']); $tarievenNacht = UserTarievenNacht::findOne(['user_id' => $user->id, 'naam' => 'Nachtdienst']); $tarievenWeekend = UserTarievenWeekend::findOne(['user_id' => $user->id, 'naam' => 'Weekenddienst']); $tariefReizen = UserReistarief::findOne(['user_id' => $user->id]); $profile = Profile::findOne(['user_id' => $user->id]); $abonnement = UserAbonnement::findOne(['user_id' => $userid->id]); $userLoaded = $user->load(Yii::$app->request->post()); if ($userLoaded && $user->validate()) { if (Yii::$app->getModule("user")->emailChangeConfirmation && $user->checkAndPrepEmailChange()) { $userKey = Yii::$app->getModule("user")->model("UserKey"); $userKey = $userKey::generate($user->id, $userKey::TYPE_EMAIL_CHANGE); if (!($numSent = $user->sendEmailConfirmation($userKey))) { // handle email error Yii::$app->session->setFlash("Email-error", "Failed to send email"); return $this->refresh(); } } } if ($user->load(Yii::$app->request->post()) && $user->save() && $company->load(Yii::$app->request->post()) && $company->save() && $tarievenDag->load(Yii::$app->request->post()) && $tarievenDag->save() && $tarievenNacht->load(Yii::$app->request->post()) && $tarievenNacht->save() && $tarievenWeekend->load(Yii::$app->request->post()) && $tarievenWeekend->save() && $tariefReizen->load(Yii::$app->request->post()) && $tariefReizen->save() && $profile->load(Yii::$app->request->post()) && $profile->save() && $abonnement->load(Yii::$app->request->post()) && $abonnement->save()) { $this->updateZoHoContact($user); Yii::$app->session->setFlash("Account-success", Yii::t("user", "Account updated")); return $this->refresh(); //return $this->redirect(['update',]); } else { return $this->render('update', ['company' => $company, 'user' => $user, 'tarievenDag' => $tarievenDag, 'tarievenNacht' => $tarievenNacht, 'tarievenWeekend' => $tarievenWeekend, 'tariefReizen' => $tariefReizen, 'profile' => $profile, 'abonnement' => $abonnement]); } }
/** * @inheritdoc */ public function upManual() { // delete neo user that the migration automatically adds UserKey::deleteAll(['user_id' => 1]); UserAuth::deleteAll(['user_id' => 1]); Profile::deleteAll(['user_id' => 1]); User::deleteAll(['id' => 1]); }
/** * Vervewijder alle werknemers die gelieerd zijn aan een company * **/ public function deleteDependentUsers($user) { $depUsers = Yii::$app->getModule("user")->model("User"); $depUsers = User::findAll(['company_id' => $user->company_id]); if ($depUsers) { foreach ($depUsers as $depUser) { //$reistarief = UserReistarief::findAll(['user_id'=>$depUser->id]); UserReistarief::deleteAll(['user_id' => $depUser->id]); //$tarief = UserTarieven::findAll(['user_id'=>$depUser->id]); UserTarieven::deleteAll(['user_id' => $depUser->id]); //$cv = UserCv::findAll(['user_id'=>$depUser->id]); UserCv::deleteAll(['user_id' => $depUser->id]); //$ce = CalendarEvents::find()->where(['user_id'=>$depUser->id])->all; CalendarEvents::deleteAll(['user_id' => $depUser->id]); //$cd = ContractDeals::find()->where(['user_id'=>$depUser->id])->all; ContractDeals::deleteAll(['user_id' => $depUser->id]); Profile::deleteAll(['user_id' => $depUser->id]); } } }