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