Db::startTrans();
try{
$order = Db::name('charge')->where('order_no', $data['out_trade_no'])->find();
if(!$order){
echo 'FAIL';
exit();
}
if($order['status']==){
echo 'FAIL';
exit();
}
DB::table('charge')->where('order_no', $data['out_trade_no'])->update(['status'=>1, 'update_time'=>time()
Db::table('user')->where('id', $order['user_id])->setInc('money', $order['money']);
$data = array(
'uid' => $order['user_id'],
'type' => 3,
'relation' => $order['id'],
'money' => $order['money'],
'info' => '会员充值' . $order['money'] . '元',
'create_time' => time(),
'create_ip' => request()->ip()
);
Db::name('wealthlog')->insert($data);
//提交事务
Db::commit();
echo 'SUCCESS';
} catch (\Exception $e) {
//回滚事务
Db::rollback();
echo 'FAIL';
}
TP5-事务的操作与回滚
最新推荐文章于 2022-12-31 17:06:34 发布