from(RefundOrder::tableName()); $query->where(['>', 'id', 0]); $query->orderBy('addTime ASC'); foreach ($query->batch() as $batchOrder) { foreach ($batchOrder as $refund) { $connection = Yii::$app->db; $transaction = $connection->beginTransaction(); $orderSn = $refund['orderSn'] ?? ''; try { $status = $refund['status'] ?? 0; $addTime = $refund['addTime'] ?? ''; $updateTime = $refund['updateTime'] ?? ''; RefundOrderItemClass::updateByCondition(['orderSn' => $orderSn], ['status' => $status, 'addTime' => $addTime, 'updateTime' => $updateTime]); $cgRefundId = $refund['cgRefundId'] ?? 0; $cgRefund = CgRefundClass::getById($cgRefundId, true); if (empty($cgRefund)) { echo "{$orderSn} 没有找到采购的退款信息\n"; continue; } $cgRefundStatus = $cgRefund->status; $cgOrderSn = $cgRefund->orderSn ?? ''; $addTime = $cgRefund->addTime; $updateTime = $cgRefund->updateTime; CgRefundItemClass::updateByCondition(['orderSn' => $cgOrderSn], ['status' => $cgRefundStatus, 'addTime' => $addTime, 'updateTime' => $updateTime]); $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); $msg = $e->getMessage(); noticeUtil::push("{$orderSn} 报错了:{$msg}", '15280215347'); } } } } //退款数据更新 ./yii refund/update public function actionUpdate() { } }