$data = DB::table('cariharekets as T1')
->select(DB::raw('T1.musteriId,T1.borc,T1.alacak,T2.bakiye,(SUM(T2.borc)-SUM(T2.alacak)) as balance'))
->join('cariharekets as T2','T2.id', '<=', 'T1.id' )
->where('T1.musteriId', '=' ,' T2.musteriId')
->groupBy('T1.id');
$data=Carihareket::paginate(10);
return view('front.carihareket.index',['data'=>$data]);
as balance çıkan sonucu nasıl index.blade.php gösterebilirim.
<tbody>
@foreach($data as $key=>$value)
<tr>
<td>{{$value['faturaId']}}</td>
<td>{{$value['borc']}}</td>
<td>{{$value['alacak']}}</td>
<td>{{$value['balance']}}</td>
</tr>
@endforeach
</tbody>