public function actionPilihDelete() { if (Yii::$app->request->isAjax) { Yii::$app->response->format = Response::FORMAT_JSON; $request = Yii::$app->request; $dataKeySelect = $request->post('keysSelect'); foreach ($dataKeySelect as $key => $value) { $model = DraftPlanDetail::find()->where(['LIKE', 'ID', $value])->one(); $scdl_group_nm = $model->SCDL_GROUP_NM; $cus_id = $model->CUST_ID; $transaction = DraftPlan::getDb()->beginTransaction(); try { self::conn_esm()->createCommand()->update('c0002scdl_plan_detail', ['STATUS' => 3], 'CUST_ID LIKE"' . $cus_id . '"')->execute(); self::conn_esm()->createCommand()->update('c0002scdl_plan_header', ['STATUS' => 3], 'NOTE="' . $scdl_group_nm . '"')->execute(); // ...other DB operations... $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); throw $e; } // self::conn_esm()->createCommand()->update('c0002scdl_plan_detail',['STATUS'=>3],'CUST_ID LIKE"'.$cus_id.'"')->execute(); // self::conn_esm()->createCommand()->update('c0002scdl_plan_header',['STATUS'=>3],'NOTE="'.$scdl_group_nm.'"')->execute(); } } return true; }