public function beforeDelete()
{
if (parent::beforeDelete()) {
Contact::deleteAll('member_id = :member_id', [':member_id' => $this->id]);
foreach ($this->codes as $code) {
if ($code->delete() === false) {
return false;
}
}
return true;
}
return false;
}
public function deleteMemberData()
{
// Delete all existing members.
// get member ids to delete
$memberIds = ArrayHelper::getColumn($this->members, 'id');
if (sizeof($memberIds) > 0) {
// without members there should be no contact etc.
$transaction = Yii::$app->db->beginTransaction();
try {
// delete contacts by member_id
Contact::deleteAll(['member_id' => $memberIds]);
/*
$codes = app\models\Code::find()
->select('id')
//->where(['poll_id' => $this->id, 'member_id' => $memberIds]) // member_id not required because i will delete all anyhow?
->where(['poll_id' => $this->id])
->asArray()
->all();
$codeIds = ArrayHelper::getColumn($codes, 'id');
*/
// alternative also over the codes relation depends on what is "faster"
$codeIds = ArrayHelper::getColumn($this->codes, 'id');
// delete the votes by the code_id
Vote::deleteAll(['code_id' => $codeIds]);
// delete the Codes by poll_id and member_id
//Code::deleteAll(['poll_id'=> $this->id, 'member_id' => $memberIds]);
Code::deleteAll(['poll_id' => $this->id]);
// member_id not required because i will delete all anyhow?
// also delete member entries by id
Member::deleteAll(['id' => $memberIds]);
$transaction->commit();
return true;
} catch (Exception $e) {
$transaction->rollBack();
return false;
}
}
return true;
}
/**
* Updates an existing Member model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id
* @return mixed
*/
public function actionUpdate($id)
{
$model = $this->findModel($id);
$modelContacts = $model->contacts;
if ($model->load(Yii::$app->request->post())) {
$oldIDs = ArrayHelper::map($modelContacts, 'id', 'id');
$modelContacts = Model::createMultiple(Contact::classname(), $modelContacts);
Model::loadMultiple($modelContacts, Yii::$app->request->post());
$deletedIDs = array_diff($oldIDs, array_filter(ArrayHelper::map($modelContacts, 'id', 'id')));
// ajax validation
if (Yii::$app->request->isAjax) {
Yii::$app->response->format = Response::FORMAT_JSON;
return ArrayHelper::merge(ActiveForm::ValidateMultiple($modelContacts), ActiveForm::validate($model));
}
// validate all models
$valid = $model->validate();
$valid = Model::validateMultiple($modelContacts) && $valid;
if ($valid) {
$transaction = Yii::$app->db->beginTransaction();
try {
if ($flag = $model->save(false)) {
if (!empty($deletedIDs)) {
Contact::deleteAll(['id' => $deletedIDs]);
}
foreach ($modelContacts as $modelContact) {
$modelContact->member_id = $model->id;
if (!($flag = $modelContact->save(false))) {
$transaction->rollBack();
break;
}
}
}
if ($flag) {
$transaction->commit();
//return $this->redirect(['view', 'id' => $model->id]);
return $this->redirect($this->getReturnUrl(['view', 'id' => $model->id]));
}
} catch (Exception $e) {
$transaction->rollBack();
}
}
}
return $this->render('update', ['model' => $model, 'modelContacts' => empty($modelContacts) ? [new Contact()] : $modelContacts]);
}
