WIKIPEDIA DashboardTopUp.php

Back Back Up Advanced Editor

<?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
        ]);

}
}