积分商品兑换

<?php

use App\Http\Controllers\Controller;
use App\Models\Goods;
use App\Models\Order;
use App\User;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class OrderController extends Controller
{
    public function createOrder()
    {
        $user = $this->request->user();
        $order_sn = get_order_sn('P');
        $goods_id = $this->request->input('goods_id', 1);
        $test = Goods::where('id', $goods_id)->first();
        $goods_integral = $test->integral * $goods_number;
        $order_status = 1;
        $sign_name = '兑换' . mb_substr($test->name, 0, 8, 'utf-8');
        $order = [
            'order_sn' => $order_sn,
            'store_id' => $store_id,
            'goods_id' => $goods_id,
            'goods_number' => $goods_number,
            'goods_integral' => $goods_integral,
            'user_id' => $user->id,
            'order_status' => $order_status,
        ];
        try {
            DB::beginTransaction();
            if ($user->point < $goods_integral) {
                return api_throw('当前账户积分余额不足!');
            }
            User::where('id', $user->id)->update(['point' => $user->point - $goods_integral]);
            $newUser = User::where('id', $user->id)->first();
            UsersSign::create([
                'user_id' => $user->id,
                'sign_name' => $sign_name,
                'sign_num' => '-' . $goods_integral,
                'sign_date' => 0,
                'before_change' => $user->point,
                'before_after' => $newUser->point,
            ]);
            Order::create($order);
            $goods = Goods::where('id', $goods_id)->first();
            if ($goods->stock == 0){
                return api_throw('该商品库存不足');
            }
            Goods::where('id', $goods_id)->decrement('stock', 1);
            DB::commit();
            return api_return();
        } catch (\Exception $exception) {
            DB::rollBack();
            return api_throw('兑换失败,' . $exception->getMessage());
    } }
    }

本作品采用《CC 协议》，转载必须注明作者和本文链接