In a view, I have fields for selecting from and to dates along with branch and spare parts as dropdown options. When I select the date range, it will retrieve data including the branch name, grand total, etc. What I am trying to achieve is getting the total sum of all the grand total prices in the column. For example, if there are 10 data entries each containing a grand total of 1000, I need to calculate the total of these 10 data entries which should be 10,000.
View
<template>
<div>
<div class="card">
<div class="card-header d-flex flex-wrap align-items-center">
...
</button>
</td>
...
...
</div>
<div class="table-responsive">
<table class="table table-bordered">
...
</thead>
</table>
...
</div>
</div>
</div>
</div>
</template>
...
Controller
public function getScrapCollectionReport(Request $request)
{
$scrap_total=0;
$scrap_collections = ScrapCollection::with(['branch:id,name,zone_id','scrap_collection_items','user_verified','user_approved'])->orderBy('id','desc');
if($request->user()->user_type_id > 2){
...
...
// $scrap_total=$scrap_collections->sum('grand_total');
$data['scrap_collections'] = $scrap_collections;
// $sum['whole_total']= $scrap_total;
return $this->sendResponse(true,$data);
}
Sample Video https://i.stack.imgur.com/svrWa.gif