yanglao/application/api/model/service/PackageOrder.php

<?php

namespace app\api\model\service;

use app\api\controller\service\Package;
use think\Model;
use fast\Random;
use think\Exception;

class PackageOrder extends Model
{
    // 表名
    protected $name = 'service_package_order';

    // 自动写入时间戳字段
    protected $autoWriteTimestamp = 'int';

    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = 'updatetime';


    public static function getCount($params)
    {
        return self::where($params)->count('id');
    }


    /**
     * 创建套餐订单
     * @param $params
     * @return array
     * @throws Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public static function createOrder($params)
    {
        $package = PackageCard::where(['id'=>$params['package_card_id'],'status'=>'normal'])->find();
        if(!$package)
        {
            throw new Exception('套餐产品异常,请联系管理员');
        }
        $package = PackageCard::packageInfo($package);
        $totalNums = PackageGoods::where(['package_card_id'=>$package['id'],'status'=>'normal'])->sum('nums');
        $userInfo = UserInfo::where(['user_id' => $params['user_id']])->field('discount,is_plus,leader_id,rec_leader_id')->find();
        $data = ['user_id' => $params['user_id'],'payprice'=>sprintf("%.2f",$package['price']),'total_nums'=>$totalNums,'package_card_id'=>$package['id'],'name'=>$package['name'],'image'=>$package['image'],'original_price'=>sprintf("%.2f",$package['original_price']),'price'=>sprintf("%.2f",$package['price']),'discount'=>$userInfo['discount'],'paytype' => $params['paytype'], 'orderId' => 'PackageOr' . Random::alnum(4) . '-' . $params['user_id'] . '-' . time()];
        $discount = bcmul($userInfo['discount'],0.01,2);

        if($discount<100 && $package['plus_state'])
        {
            $data['payprice'] = bcmul($data['price'],$discount,2);
        }

        if ($params['coupon_id']) {
            if($package['coupon_state'] == 0)
            {
                throw new Exception('当前套餐产品无法使用优惠券');
            }
            $coupon = UserCoupon::where(['id'=>$params['coupon_id'],'state'=>0])->find();
            if (!$coupon || !in_array($coupon['type'],[0,4])) {
                throw new Exception('优惠券无法使用');
            }
            $data['coupon_id'] = $params['coupon_id'];
            $data['coupon_price'] = sprintf("%.2f", $coupon['reduce']);
            $data['payprice'] = bcsub($data['payprice'], $data['coupon_price'],2);
        }

        $userMoney = User::getMoney($params['user_id']);
        if ($params['paytype'] == 4 && $userMoney < $data['payprice']) {
            throw new Exception('余额不足,请及时充值');
        }
        $packageOrder = new PackageOrder($data);
        $packageOrder->allowField(true)->save();
        $goods = PackageGoods::getList($package['id']);

        foreach ($goods as $val)
        {

            $actPrice = $val['price'];
            $totalPrice = $val['total_price'];
            if($data['payprice']<$package['price'])
            {
                $totalPrice = bcmul(bcdiv($val['total_price'],$package['price'],4),$data['payprice'],2);
                
                $actPrice = $val['nums'] == 1?$totalPrice:bcdiv($totalPrice,$val['nums'],2);
            }

            $packageOrderDetail = new PackageOrderDetail(['package_order_id'=>$packageOrder->id,'goods_id'=>$val['goods_id'],'goods_sku_id'=>$val['goods_sku_id'],'user_id'=>$params['user_id'],'goodsname'=>$val['goodsname'],'name'=>$val['name'],'price'=>$val['price'],'total_price'=>$totalPrice,'act_price'=>$actPrice,'cost_seconds'=>$val['cost_seconds'],'unit'=>$val['unit'],'nums'=>$val['nums']]);
            $packageOrderDetail->allowField(true)->save();
        }

        $re = [];
        $re['status'] = 0;
        if (in_array($params['paytype'], [0, 1, 2, 3])) {
            $re['pay'] = \addons\service\library\Pay::payOrder(['amount' => $data['payprice'], 'orderid' => $data['orderId'], 'title' => '支付套餐卡费用'], $params['paytype'], $params['user_id'], 0);
        } elseif ($params['paytype'] == 4) {
            User::money(-$data['payprice'], $data['user_id'], '支付' . $package['name'] . '套餐卡费用');
            $packageOrder->save(['status' => 1, 'paytime' => time()], ['id' => $packageOrder->id]);
            if($params['coupon_id'])
            {
                UserCoupon::where('id',$params['coupon_id'])->update(['state'=>1,'updatetime'=>time()]);
            }
            $re['pay'] = '';
            $re['status'] = 1;
            self::updateTime($packageOrder->id);
        }
        return $re;
    }

    public static function updateTime($id)
    {
        $packageOrder = self::where(['id'=>$id,'status'=>1,'is_update'=>0])->find();
        if(!$packageOrder)
        {
            return false;
        }
        $package = PackageCard::where('id',$packageOrder['package_card_id'])->find();
        if($package['daynums'])
        {
            $endtime = 86400*$package['daynums']+time();
            self::where(['id'=>$id])->update(['starttime'=>time(),'endtime'=>$endtime]);
        }
        return  true;
    }


    public static function getOrderList($params)
    {
        extract($params);
        $order = 'createtime desc';
        $where['status'] = ['<>',0];
        if (isset($status) && $status != '') {
            $where['status'] = $status;
        }
        if (isset($user_id) && $user_id != '') {
            $where['user_id'] = $user_id;
        }
        $list = self::where($where)->field('id,user_id,payprice,status,orderId,name,image,paytype,total_nums,note,use_nums,starttime,endtime,is_service')->order($order)->page($page)->limit(10)->select();
        foreach ($list as &$value)
        {
            $value['diffDay'] = $value['endtime']>time()?intval(($value['endtime']-time())/86400):0;
            $value['total'] = PackageOrderDetail::where(['package_order_id'=>$value['id']])->sum('nums-usenums');
            $value['detail'] = PackageOrderDetail::where(['package_order_id'=>$value['id']])->select();
        }
        return $list;
    }



}