IntegralBill.php

<?php


namespace App\Models;


use App\Http\Filters\IntegralBillFilter;
use App\Http\Filters\QueryFilter;
use http\Env\Request;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;

class IntegralBill extends Model
{
    public $timestamps = false;


    public function integral()
    {
        return $this->belongsTo(Integral::class, 'integral_id', 'id');
    }

    public function scopePage($query, $page = 1, $pageSize = 10)
    {
        return $query->offset(($page - 1) * $pageSize)->limit($pageSize);
    }

    public function scopeFilter($query, QueryFilter $filters)
    {
        return $filters->apply($query);
    }

    //获取用户兑换红包列表
    public function getIntegralBillList($page, $pageSize, $filter)
    {
        $request = new \Illuminate\Http\Request();
        $bills = IntegralBill::with('integral')->filter($filter)->page($page, $pageSize)
            ->orderBy('id', 'desc')
            ->get()->toArray();
        $count = IntegralBill::filter($filter)->count();

        return ['data' => $bills, 'count' => $count];
    }

    public function createIntegralBill($data = [])
    {
        $res = DB::table('integral_bills')->insert($data);

        return $res;
    }

    //更新用户红包兑换列表
    public function updateIntegralBill($id, $data = [])
    {
        $res = DB::table('integral_bills')->where('id', $id)
            ->update($data);

        return $res;
    }

    //删除
    public function deleteIntegralBill($ids = [])
    {
        $res = DB::table('integral_bills')->whereIn('id', $ids)->delete();

        return $res;
    }

    //获取用户红包统计信息
    public function getUserIntegralStatistics($userId)
    {
        //一共获得的积分金额
        $totalAmount = DB::table('integral_bills')
            ->leftJoin('integrals', 'integral_bills.integral_id', 'integrals.id')
            ->where('user_id', $userId)
            ->sum('amount');
        //已经兑换的金额
        $exchangedAmount = DB::table('user_exchanges')
            ->leftJoin('exchange_settings', 'user_exchanges.exchange_id', 'exchange_settings.id')
            ->where('user_id', $userId)
            ->sum('amount');
        //剩余可兑换积分金额
        $integral = DB::table('user_integrals')
            ->where('user_id', $userId)->value('integral');

        return [
            'total_amount'     => $totalAmount,
            'exchanged_amount' => $exchangedAmount,
            'integral'         => $integral,
        ];

    }
}