/** * 获取new_trans_result表里面状态为成功或者失败的记录 * 将取出的记录原封不动的存入new_trans_history表 * 存入成功后删除new_trans_result表里面对应的记录 * */ public function checkResultStatus() { $newTransResultModel = new NewTransResultModel(); $newTransHistoryModel = new NewTransHistoryModel(); $res = $newTransResultModel->getSuccAndFail(); if ($res) { foreach ($res as $k => $v) { $newTransHistoryModel->begin(); $v = (array) $v; $newTransHistoryModel->insert($v); $rs = $newTransHistoryModel->affectRow(); if ($rs) { $del = $newTransResultModel->delSuccAndFail($v['t_id']); if ($del) { $newTransHistoryModel->commit(); echo 't_id为' . $v['t_id'] . '的交易记录从result转存history成功' . PHP_EOL; } else { $newTransHistoryModel->rollback(); echo 't_id为' . $v['t_id'] . '的交易记录从result删除失败' . PHP_EOL; } } else { $newTransHistoryModel->rollback(); echo 't_id为' . $v['t_id'] . '的交易记录从result写入history失败' . PHP_EOL; } } } }