TA貢獻1813條經驗 獲得超2個贊
您可以計算每個請求的總飛行時間。這未經測試，但假設它應該有效。
$logBook = $this->log_book->orderBy('flight_date','asc');
$logBookPagination = $logBook->paginate(18);
// change the offset value to a value that makes sense for you
$logBookFlightTime = $logBook->offset(0)->limit($logBookPagination->perPage() * $logBookPagination->currentPage())->sum('id'); // replace with your column
return [
'logBook' => $logBookPagination,
'totalFlightTime' => $logBookFlightTime
];
為了解釋我正在做什么，我從0中獲取模型切片 - 當前頁面，然后添加所有這些模型的飛行時間。
TA貢獻1817條經驗 獲得超6個贊
我解決了這個問題。
$currentPage = $logs->currentPage();
if ($currentPage == 1) {
$totalPrevPages = $flight_total_time;
$flightInsTimePrevPages = $flight_ins_time;
$total_time=$totalPrevPages + $totalCurrentPage;
}
else {
$total_time = $this->log_book->log()->orderBy('leg_date','asc')->limit($count * $currentPage)->sum('total_time') + $flight_total_time;
$totalPrevPages = $total_time - $totalCurrentPage ;
}
舉報