如何在 Laravel 中不同表中的两个整数值相减

Question

我试图实现减去不同表中的两个整数值，这是我到目前为止所尝试的。

Controller:

$amount = DB::table('shipping_datas')->where('amount')->first();

$payment = DB::table('payments')->where('amount')->first();

$balance = $amount - $payment;

Blade:

{{ $balance }}

先感谢您 ：）

Answer 1

$amount = DB::table('shipping_datas')->pluck('amount')->sum();$payment = DB::table('payments')->pluck('amount')->sum();$balance = $amount - $payment;我认为它的工作。