Skip to main content

Black Friday 2025! Only until December 1st: coupon FRIDAY25 for 40% off Yearly/Lifetime membership!

Read more here

saleem-hadad/finance

404 stars
2 code files
View saleem-hadad/finance on GitHub

app/Models/Transaction.php

Open in GitHub
use Illuminate\Database\Eloquent\Model;
 
class Transaction extends Model
{
//
public function scopeExpenses($query)
{
return $query->whereHas('brand.category', function ($query) {
return $query->where('type', Category::EXPENSES);
});
}
//
}

app/GraphQL/Queries/TotalExpensesTrend.php

Open in GitHub
use App\Models\Transaction;
use Illuminate\Support\Facades\DB;
 
class TotalExpensesTrend extends TrendMetric
{
//
public function __invoke($_, array $args)
{
$rangeData = app('findRangeByKey', ["key" => $args['range']]);
 
$query = Transaction::query()
->expenses()
->select(DB::raw("date_format(created_at, '%Y-%m') as label, SUM(transactions.amount) as value"))
->groupBy(DB::raw("label"))
->orderBy("label");
 
if($rangeData) {
$query->whereBetween('transactions.created_at', [$rangeData->start(), $rangeData->end()]);
}
 
return $query->get();
}
}

We'd Love Your Feedback

Tell us what you like or what we can improve

Feel free to share anything you like or dislike about this page or the platform in general.