PHP Contact::deleteAll方法代碼示例

 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]);
 }