qd/app/models/auction/AuctionOrder.php

<?php

/**
 *
 * @author: xaboy<365615158@qq.com>
 * @day: 2017/11/02
 */

namespace app\models\auction;

use app\admin\model\user\User;
use app\admin\model\user\UserBill;
use crmeb\services\product\Product;
use crmeb\traits\ModelTrait;
use crmeb\basic\BaseModel;

/**
 * 预约 Model
 * Class WechatNews
 * @package app\admin\model\wechat
 */
class AuctionOrder extends BaseModel
{

    use ModelTrait;

    protected $pk = 'id';

    protected $name = 'auction_order';
    protected $autoWriteTimestamp = true;


    /**
     * 用户订单
     * @param $data
     * @param $uid
     * @return \think\Collection
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public static function userOrder($data,$uid)
    {
        if ($data['order_id']){
            $list = self::alias('a')
                ->field('a.*,u.nickname,u.avatar,u.uid as user_id,c.nickname as c_nickname,c.phone')
                ->leftJoin('user u', 'a.uid = u.uid')
                ->leftJoin('user c', 'a.collection_id = c.uid')
                ->where('a.order_id', $data['order_id'])->find(); //详细订单
            $pay = AuctionPay::where('uid', $list['collection_id'])->select();

            $list['wx'] = [];
            $list['zfb'] = [];
            $list['bank'] = [];
            $list['time'] = strtotime($list['create_time']);
            if ($pay){
                foreach ($pay as $k => $v){
                    if ($v['type'] == 1){
                        $list['wx'] = $v;
                    }elseif ($v['type'] == 2){
                        $list['zfb'] = $v;
                    }elseif ($v['type'] == 3){
                        $list['bank'] = $v;
                    }
                }
            }
        }else{
            if ($data['type'] == 1){
                $list = self::where([['uid', '=', $uid], ['status', '=', 1]])->page($data['page'], $data['limit'])->select(); //待上传订单

            }else if($data['type'] == 2){
                $list = self::where([['uid', '=', $uid], ['status', '=', 2]])->page($data['page'], $data['limit'])->select(); //待审核订单

            }else if($data['type'] == 3) {
                $list = self::where([['uid', '=', $uid], ['status', '=', 3], ['is_gs', '=', 1]])->page($data['page'], $data['limit'])->select(); //完成订单
            }else if($data['type'] == 4) {

                $list = self::alias('a')
                    ->field('a.*,p.frozen')
                    ->where([['a.uid', '=', $uid], ['a.status', '=', 3],['a.is_gs', '=', 0]])
                    ->leftJoin('auction_product p', 'p.id = a.product_id')
                    ->page($data['page'], $data['limit'])
                    ->select(); //待挂售订单
            }else{
                $list = self::where([['uid', '=', $uid], ['status', '<', 1]])->page($data['page'], $data['limit'])->select(); //过期订单
            }
        }

        $list = !empty($list)? $list->toArray(): [];
        return $list;
    }

    /**
     * 卖家订单
     * @param $data
     * @param $uid
     * @return \think\Collection
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public static function seller_list($data,$uid)
    {
        if ($data['order_id']){
            $list = self::alias('a')
                ->field('a.*,u.nickname,u.avatar,u.uid as user_id')
                ->leftJoin('user u', 'a.uid = u.uid')
                ->where('a.order_id', $data['order_id'])->find(); //详细订单
        }else{
            if ($data['type'] == 1){
                $status = 1;
            }else if($data['type'] == 2){
                $status = 2;
            }else if($data['type'] == 3) {
                $status = 3;
            }else{
                $status = 0;
            }
            if ($data['type'] == 4){
                $product = AuctionTime::alias('a')
                    ->field('FROM_UNIXTIME(a.add_time,"%Y-%m-%d") as gs_time,au.nickname,b.*')
                    ->order('a.id DESC')
                    ->where([['a.uid', '=', $uid]])
                    ->leftJoin('auction_product b', 'a.product_id = b.id')
                    ->leftJoin('auction au', 'au.id = a.auction_id')
                    ->select();
            }else{
                $list = self::alias('a')
                    ->field('a.*,u.nickname,u.avatar,u.uid as user_id')
                    ->leftJoin('user u', 'a.uid = u.uid')
                    ->order('id DESC')
                    ->where([['a.collection_id', '=', $uid], ['a.status', '=', $status]])
                    ->page($data['page'], $data['limit'])
                    ->select(); //待上传订单
            }

        }

        if ($data['type'] != 4){
            $list = !empty($list)? $list->toArray(): [];
            foreach ($list as $k => $v) {
                $pay = AuctionPay::where('uid', $v['uid'])->find();
                $list[$k]['phone'] = $pay['phone'];
            }
            return $list;
        }else{
            $product = empty($product) ? []: $product->toArray();
            return $product;
        }


    }

    /**
     * 卖家操作
     * @param $id  //商品所属人
     * @param $price //卖出价格
     * @param $product //商品详情
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public static function earn($id, $price,$product)
    {
        $userModel = new \app\models\user\User();
        $productModel = new AuctionProduct();
        $user = $userModel->find($id);
        if ($user['spread_uid'] > 0){
            $s_price = round(($price - $product['price']) * 0.1, 2); // 卖出价格减去购买价格的百分之十 为上级直推奖励
            $spread = $userModel->find($user['spread_uid']);
            $spread['integral'] = $spread['integral'] + $s_price; //积分增加
            $spread->save();
            \app\models\user\UserBill::income('直推奖励', $spread['uid'], 'anticipate', 'add_anticipate', $s_price, 0, $spread['integral'], '奖励趣豆');
        }
//        $user['anticipate'] = $user['anticipate']-$price*($product['deduct']/100); // 扣除当前卖出价格百分比的预约卷
//        $user->save();
//        UserBill::expend('预约卷扣除', $user['uid'], 'anticipate','reduce_anticipate', $price*($product['deduct']/100), 0, $user['anticipate'] ,'卖出扣除预约卷');
        AuctionTime::where([['product_id', '=', $product['id']], ['uid', '=', $id]])->delete();
        $productModel->where('id', $product['id'])->save(['is_show' => 0]); //下架等待挂售

    }

    /**
     * 购买成功退预约卷
     * @param $id
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public static function return($id)
    {
        $data = self::find($id);
        $userModel = new User();
        $productModel = new AuctionProduct();
        $auctionModel = new Auction();
        $bookingModel = new AuctionBooking();


        $user = $userModel->find($data['uid']);
        if ($user['is_new'] == 1){

            if ($user['spread_uid']) {
                $spread = $userModel->where('uid', $user['spread_uid'])->find();
                $spread['green_time'] = strtotime(date('Y-m-d', strtotime('+1 day'))); // 开启明天的绿色通道
            }
            $orderCount = AuctionOrder::where([['uid', '=',  $user['uid']], ['status','=', 3]])->count();
            if ($orderCount >= 5){
                $user['is_new'] = 0;
            }


        }
        $product = $productModel->where('id', $data['product_id'])->find();
        $auction = $auctionModel->where('id', $product['auction_id'])->find();
        $time = strtotime(date('Y-m-d' ,strtotime($data['create_time']))); // 订单当天时间段
        $totime = strtotime(date('Y-m-d' ,strtotime($data['create_time']))) + 86400; // 订单凌晨时间段
        $booking = $bookingModel->where('auction_id', $auction['id'])->where('uid', $user['uid'])->whereBetweenTime('create_time', $time, $totime)->find();
        if ($booking['status'] > 0){
            $booking['status'] = 0;
            $booking->save();
            $anticipate = $booking['anticipate'] - $booking['deduction'];
            $user['anticipate'] = $user['anticipate'] + $anticipate;// 退还预约卷
            $user->save();


            \app\models\user\UserBill::create([
                'uid' => $user['uid'],
                'pm' => 1,
                'title' => '预约卷退还',
                'category' => 'anticipate',
                'type' => 'add_anticipate',
                'mark' => '退还'.$anticipate.'预约卷扣除'.$booking['deduction'],
                'add_time' => time(),
                'number' => $anticipate,
                'balance' => $user['anticipate']
            ]);
        }
    }

    /**
     * 订单过期
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public static function deduction()
    {
        $hour = strtotime(date('Y-m-d H:i:s', strtotime('-1 hour'))); // 一小时以前
        $time = $hour - 1800; // 一个半小时
        $order = AuctionOrder::where('create_time', '<', $hour)->where('status', '=', 1)->select(); // 查询不在当前一个半小时内的所有订单
        if ($order){
            foreach ($order as $K => $v){
                $product = AuctionProduct::where('id', $v['product_id'])->find();
                $auction = Auction::where('id', $product['auction_id'])->find();
                $booking = AuctionBooking::where([['uid', '=', $v['uid']], ['status', '=', 1], ['auction_id', '=', $auction['id']]])->find(); // 找到预约订单
                if (strtotime($v['create_time']) <= $hour and strtotime($v['create_time']) > $time){
                    // 订单在一个小时到一个半小时内
                    if ($booking){
                        if ($booking['deduction'] == 0){
                            $user = \app\models\user\User::where('uid', $v['collection_id'])->find();
                            $user['anticipate'] = $user['anticipate'] + $auction['anticipate']/2; // 卖家增加预约卷
                            $booking['deduction'] = $auction['anticipate']/2;
                            UserBill::income('增加预约卷', $v['collection_id'], 'anticipate', 'add_anticipate',  $auction['anticipate']/2, $v['uid'], $user['anticipate'], '卖出订单未上传支付凭证,增加'.($auction['anticipate']/2).'预约卷');
                            $booking->save();
                            $user->save();
                        }
                    }
                }elseif (strtotime($v['create_time']) <= $time){
                    if ($booking) {
                        $user = \app\models\user\User::where('uid', $v['collection_id'])->find();
                        $user['anticipate'] = $user['anticipate'] + ($auction['anticipate'] - $auction['deduction']); // 卖家增加预约卷
                        $booking['deduction'] = $auction['anticipate'];
                        UserBill::income('增加预约卷', $v['collection_id'], 'anticipate', 'add_anticipate', $auction['anticipate'] - $auction['deduction'], $v['uid'], $user['anticipate'], '卖出订单未上传支付凭证,增加' . ($auction['anticipate'] - $auction['deduction']) . '预约卷');
                        $booking->save();
                        $user->save();
                        AuctionBooking::where('id', $booking['id'])->update(['status' => 2]); // 修改预约订单状态 为扣除
                        AuctionOrder::where('create_time', '<', $hour)->where('status', '=', 1)->update(['status' => 0]); // 修改为已过期订单
                    }
                }
            }

        }
    }

    /**
     * 退回预约卷
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public static function th()
    {
        $auction = Auction::where('rend_time', '<', date('H:i:s', time()))->select();
        if ($auction){
            foreach ($auction as $k => $v){

                $booking = AuctionBooking::where([['auction_id', '=', $v['id']], ['status','=' , 1]])->select();
                if ($booking){
                    foreach ($booking as $key => $value){
                        $product = AuctionProduct::where('auction_id', $value['auction_id'])->column('id');
                        $order = AuctionOrder::where([['product_id', 'in', $product], ['frequency', '=', $value['frequency']], ['uid', '=', $value['uid']]])->find();
                        if (!$order){
                            $find = AuctionBooking::find($value['id']);
                            $find['status'] = 0;

                            $user = User::where('uid', $value['uid'])->find();
                            $user['anticipate'] = $user['anticipate'] + $value['anticipate'];

                            $user->save();
                            $find->save();
                            UserBill::income('退回预约券',$user['uid'], 'anticipate', 'add_anticipate', $value['anticipate'], 0, $user['anticipate'], '预约卷'.$value['anticipate'].'退回');
                        }
                    }
                }
            }
        }
    }





}