php - 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;

我认为它的工作。