Solution
I've solved the problem using this:
DB::statement('set @balance := 0');
$entries = Voucher::with('chequeInfo')
->select('receipt_no', 'particular', DB::raw('@balance := @balance + (deposite - expense) as cBal'))
->where('receipt_type', 'LIKE', '%-fund')
->where('ladger_id', $id)->get();
If there is any better way then please post here.
Last updated
1 year ago.
0
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast