xhg/app/api/controller/many/ManyController.php

<?php

namespace app\api\controller\many;


use app\models\many\Many;
use app\models\many\ManyDiscipline;
use app\models\many\ManyGreen;
use app\models\many\ManyOrder;
use app\models\store\StoreOrder;
use app\models\user\User;
use app\models\user\UserBill;
use app\Request;
use crmeb\services\GroupDataService;
use crmeb\services\QrcodeService;
use crmeb\services\SystemConfigService;
use crmeb\services\UtilService;
use crmeb\services\upload\Upload;
use think\facade\Db;

/**
 * 账单类
 * Class UserBillController
 * @package app\api\controller\user
 */
class ManyController
{
    /**
     * 众筹列表
     * @param Request $request
     * @return mixed
     */
    public function many(Request $request)
    {
        $where = UtilService::getMore([
            ['page', 1],
            ['limit', 10],
            ['name']
        ]);
        $list = \app\models\many\Many::list($where);
        return app('json')->success($list);
    }

    /**
     * 投注
     * @param Request $request
     * @return mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function purchase(Request $request)
    {
        $data = UtilService::postMore([
            ['id'],
            ['price']
        ]);
        $many = Many::where('id', $data['id'])->find();
        $surplus = $this->surplus($data['id'], 1);
        $user = User::where('uid', $request->uid())->find();
        if (!$many) return app('json')->fail('场次不存在');
        if ($many['number'] >= $many['money']) return app('json')->fail('已完成无法投注');
        if ( $many['status'] == 0) return app('json')->fail('未开启');
        if ($many['end_time'] < time()) return app('json')->fail('已结束');
        if (($many['number']+$data['price']) > $many['money']) return app('json')->fail('还能最大投注'.($many['money']-$many['number']));
        if ($surplus < $data['price']) return app('json')->fail('超过最大可投注额度');
        Db::startTrans();
        if ($many['add_time'] > time()){
            $green = ManyGreen::where('uid', $user['uid'])->where('status', 0)->find();
            if (!$green) return app('json')->fail('你无法提前投注');
            $green['status'] = 1;
        }
        $integral = $user['white_integral'] + $user['purple_integral'];// 白积分加紫积分的总积分
        if ($integral < $data['price']) return app('json')->fail('积分额度不够');
        try {
            if ($user['white_integral'] < $data['price']){
                $white = $user['white_integral'];
                $user['white_integral'] = 0;
                $user['purple_integral'] = ($data['price'] - $white);
                UserBill::expend('扣除白积分', $user['uid'], 'white_integral', 'bet', $white, 0,0,'使用白积分,投注场次'.$many['name'].'成功');
                UserBill::expend('扣除紫积分', $user['uid'], 'purple_integral', 'bet', $data['price']-$white, 0,$user['purple_integral'],'使用紫积分,投注场次'.$many['name'].'成功');
            }else{
                $user['white_integral'] -= $data['price'];
                UserBill::expend('扣除白积分', $user['uid'], 'white_integral', 'bet', $data['price'], 0,$user['white_integral'],'使用白积分,投注场次'.$many['name'].'成功');
            }
            $many['number'] += $data['price'];
            if ($many['number'] >= $many['money']){
                $many['suc'] = 1;// 众筹成功
                $many['status'] = 0;// 众筹成功
                ManyDiscipline::create(['many_id' => $many['id'], 'stage' => $many['stage'], 'status' => 1]);// 成功记录
                if ($many['stage'] >= 4){
                    // 期数如果大于等于4
                    $stage = $many['stage'] - 3;
                    ManyOrder::where('many_id', $many['id'])->where('stage', $stage)->update(['is_return' => 1]);// 成功后添加返还状态
                }
            }
            $user->save();
            ManyOrder::create([
                'order_id' => StoreOrder::getNewOrderId(),
                'many_id' => $many['id'],
                'uid' => $user['uid'],
                'stage' => $many['stage'],
                'price' => $data['price'],
            ]);
            $many->save();
            if ($many['add_time'] > time()) $green->save();
            Db::commit();
            return app('json')->success('投注成功');
        } catch (\Exception $e) {
            Db::rollback();
            return app('json')->fail($e->getMessage());
        }

    }

    /**
     * 还有多少可投注
     * @param $id
     * @param $type
     * @return float|mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function surplus($id, $type = 0)
    {
        if ($type > 0){
            $many = Many::where('id', $id)->find();
            if (!$many) return app('json')->fail('场次不存在');
            $many_order = ManyOrder::where('many_id', $id)->where('stage', $many['stage'])->sum('price');
            $price = ($many['upper_limit'] - $many_order); // 还可以投注额度
            return $price;
        }else{
            $many = Many::where('id', $id)->find();
            if (!$many) return app('json')->fail('场次不存在');
            $many_order = ManyOrder::where('many_id', $id)->where('stage', $many['stage'])->sum('price');
            $data['price'] = ($many['upper_limit'] - $many_order); // 还可以投注额度

            return app('json')->fail($data);
        }
    }



}