NN2022112805/app/Services/Common/TradeService.php

<?php
// +----------------------------------------------------------------------
// | LARAVEL8.0 框架 [ LARAVEL ][ RXThinkCMF ]
// +----------------------------------------------------------------------
// | 版权所有 2017~2021 LARAVEL研发中心
// +----------------------------------------------------------------------
// | 官方网站: http://www.laravel.cn
// +----------------------------------------------------------------------
// | Author: laravel开发员 <laravel.qq.com>
// +----------------------------------------------------------------------

namespace App\Services\Common;

use App\Models\TradeModel;
use App\Services\BaseService;

/**
 * 交易管理-服务类
 * @author laravel开发员
 * @since 2020/11/11
 * Class TradeService
 * @package App\Services\Common
 */
class TradeService extends BaseService
{
    // 静态对象
    protected static $instance = null;

    /**
     * 构造函数
     * @author laravel开发员
     * @since 2020/11/11
     * TradeService constructor.
     */
    public function __construct()
    {
        $this->model = new TradeModel();
    }

    /**
     * 静态入口
     * @return static|null
     */
    public static function make()
    {
        if (!self::$instance) {
            self::$instance = (new static());
        }
        return self::$instance;
    }

    /**
     * 添加或编辑
     * @return array
     * @since 2020/11/11
     * @author laravel开发员
     */
    public function edit()
    {
        $data = request()->all();
        return parent::edit($data); // TODO: Change the autogenerated stub
    }

    /**
     * 获取店铺交易统计
     * @param $shopId
     * @param int $type
     * @param int $coinType
     * @return mixed
     */
    public function getShopTradeTotal($shopId, $status=0)
    {
        $where = ['shop_id'=>$shopId,'mark'=>1];
        if($status){
            $where['status'] = $status;
        }
        return $this->model->where($where)
            ->sum('price');
    }

    /**
     * 获取交易数
     * @param $shopId
     * @param int $type
     * @param int $coinType
     * @return mixed
     */
    public function getShopTradeCount($shopId, $status = 0)
    {
        $where = ['shop_id'=>$shopId,'mark'=>1];
        if($status){
            $where['status'] = $status;
        }
        return $this->model->where($where)
            ->count('id');
    }

    /**
     * 抢拍交易订单数
     * @param $userId 用户ID
     * @param int $status 状态
     * @return mixed
     */
    public function getNewTradeCountByStatus($userId, $status=0, $time=30)
    {
        $where = ['user_id'=>$userId,'mark'=>1,'is_read'=>1];
        return $this->model->where($where)
            ->where(function($query) use($status){
                $query->whereIn('status',is_array($status)? $status:[$status]);
            })
            ->where(function($query) use($time){
                if($time){
                    $query->where('update_time','>', $time);
                }
            })
            ->groupBy('status')
            ->count();
    }
}