/** * @depends loadData */ public function destroyData() { Employee::deleteAll(); Authuser::deleteAll('auth_user_id <> 1'); Dolzh::deleteAll(); Podraz::deleteAll(); Build::deleteAll(); }
/** * @depends loadData */ public function destroyData() { Mattraffic::deleteAll(); Material::deleteAll(); Employee::deleteAll(); Matvid::deleteAll(); Izmer::deleteAll(); Schetuchet::deleteAll(); Authuser::deleteAll('auth_user_id <> 1'); Build::deleteAll(); Dolzh::deleteAll(); Podraz::deleteAll(); }
public function actionRemoveinactiveemployee() { $au = \app\models\Fregat\Employee::find()->select(['employee_id', 'id_person'])->groupBy(['id_person'])->all(); $del = 0; $nodel = 0; $count = count((array) $au); foreach ($au as $ar) { $inactivePerson = \app\models\Fregat\Employee::find()->andWhere(['id_person' => $ar->id_person, 'employee_dateinactive' => NULL])->count(); if (empty($inactivePerson)) { $transaction = Yii::$app->db->beginTransaction(); try { $au2 = \app\models\Config\Authuser::findOne($ar->id_person)->auth_user_fullname; \app\models\Fregat\Employee::deleteAll(['id_person' => $ar->id_person]); \app\models\Config\Authuser::deleteAll(['auth_user_id' => $ar->id_person]); Profile::deleteAll(['profile_id' => $ar->id_person]); $transaction->commit(); $del++; echo 'Deleted "' . $au2 . '"<br>'; } catch (\yii\db\IntegrityException $e) { $nodel++; echo 'Can\'t delete "' . $au2 . '"<br>'; $transaction->rollBack(); } } } echo 'Removed ' . $del . ' from ' . $count . '. Errors = ' . $nodel; }