public function actionClear($id) { $this->layout = 'column2'; $model = Itens::model()->find(array('select' => '*', 'condition' => 'itens_id=:itens_id', 'params' => array(':itens_id' => $id))); try { $transaction = Yii::app()->db->beginTransaction(); if (count($model) > 0) { ItensMultimidia::model()->deleteAll(array('condition' => "itens_id = :itens_id", 'params' => array(':itens_id' => $id))); StatusNegocios::model()->deleteAll(array('condition' => "itens_id = :itens_id", 'params' => array(':itens_id' => $id))); // echo Itens::model()->deleteByPk($id); exit; if (Itens::model()->deleteByPk($id)) { $transaction->commit(); } Yii::app()->user->setState('frm_clear', true); $this->redirect(array('admin')); } } catch (CDbException $e) { $transaction->rollback(); //$model->addError(null, $e->getMessage()); } $this->render('index', array('model' => $model)); }
public function actionClear($id) { $this->layout = 'column2'; $model = Usuario::model()->find(array('select' => '*', 'condition' => 'usuario_id=:usuario_id', 'params' => array(':usuario_id' => $id))); $itens = Itens::model()->findAll(array('select' => '*', 'condition' => 'usuario_id=:usuario_id', 'params' => array(':usuario_id' => $id))); $arr_itens = ''; foreach ($itens as $key => $values) { $arr_itens .= $values->itens_id . ','; } if ($arr_itens) { $arr_itens = substr($arr_itens, 0, -1); } try { $transaction = Yii::app()->db->beginTransaction(); if (count($model) > 0) { $criteria = new CDbCriteria(); if (strlen($arr_itens)) { $criteria->condition = 'itens_id in(' . $arr_itens . ')'; ItensMultimidia::model()->deleteAll($criteria); StatusNegocios::model()->deleteAll($criteria); Itens::model()->deleteAll($criteria); } // echo Itens::model()->deleteByPk($id); exit; if (Usuario::model()->deleteByPk($id)) { $transaction->commit(); } Yii::app()->user->setState('frm_clear', true); $this->redirect(array('admin')); } } catch (CDbException $e) { $transaction->rollback(); //$model->addError(null, $e->getMessage()); } $this->render('index', array('model' => $model)); }