PHP高并发的测试与解决方案（二）PHP乐观锁

public function sale_order(){
        $user_id = mt_rand(1,100000);
        $goods_info = Db::name('goods')->where('id',1)->find();
        if($goods_info['goods_num'] <= 0){
            return '商品已售罄';
        }
        $user_info = Db::name('wallet')->where('user_id',$user_id)->find();
        if(empty($user_info)){
            return '用户信息不存在';
        }
        if($user_info['money']<$goods_info['flash_sale_price']){
            return '秒杀失败，余额不足';
        }
        $order_num = $this->get_order_num();
        $order_info = [
            'order_num'     => $order_num,
            'user_id'       => $user_id,
            'goods_id'      => $goods_info['id'],
            'num'           => 1
        ];
        $goods_data = [
            'goods_num'     => $goods_info['goods_num'] -1,
            'version'       => $goods_info['version'] + 1,
        ];
        $goods_where_data = [
            'id'            => $goods_info['id'],
            'version'       => $goods_info['version']
        ];
        $user_banlance = round(($user_info['money'] - $goods_info['flash_sale_price']),2);
        Db::startTrans();
        try{
            $res = Db::name('goods')->where($goods_where_data)
                ->update($goods_data);
            if($res != 1){
                Exception('减库存失败',0);
            }
            Db::name('goods_order')->insert($order_info);
            Db::name('wallet')->where('user_id',$user_info['id'])
                ->update(['money'=>$user_banlance]);
            Db::commit();
        }catch (\Exception $e){
            Db::rollback();
            $log_data = [
                'log'   =>   $e->getMessage(),
            ];
            Db::name('log')->insert($log_data);
            return '下单失败';
        }
        return '下单成功';
    }