<?php

namespace App\Http\Controllers;

use App\Credelec;
use App\PurchaseVoucher;
use App\Water;
use Illuminate\Http\Request;

class DashboardTopUp extends Controller
{
    public function getDashboard()
    {

        $voucherTv = PurchaseVoucher::query()
            ->where('type', '=', 'Tv')
            ->whereDate('created_at', date('Y-m-d'))
            ->sum('vouchervalue');

        $voucherRecarga = PurchaseVoucher::query()
            ->where('type', '=', 'recarga')
            ->whereDate('created_at', date('Y-m-d'))
            ->sum('vouchervalue');

        $water = Water::query()
            ->whereDate('created_at', date('Y-m-d'))
            ->sum('purchaseValue');

        $credelec = Credelec::query()
            ->whereDate('created_at', date('Y-m-d'))
            ->sum('amount');

        return response()->json([
            'voucher' => $voucherRecarga,
            'tv' => $voucherTv,
            'water' => $water,
            'credelec' => $credelec
        ]);

    }
}