如何在 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;

我认为它的工作。