Compare commits

..

3 Commits

+5 -1
View File
@@ -351,7 +351,11 @@ class PagesController extends Controller
public function winnersbyitem() public function winnersbyitem()
{ {
$winnersbyitem_results = WinningBids::with(['items', 'bidders'])->get(); $winnersbyitem_results = WinningBids::with(['items', 'bidders'])
->join('items', 'winning_bids.winning_item_num', '=', 'items.iditems')
->orderByRaw('CAST(items.item_assigned_num AS UNSIGNED) ASC')
->select('winning_bids.*')
->get();
return view('winnersbyitem', ['winnersbyitem_results' => $winnersbyitem_results]); return view('winnersbyitem', ['winnersbyitem_results' => $winnersbyitem_results]);
} }