/**
* @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;
}
