docs: update changelog with reporting and checkout verification improvements

Reviewed-on: North-Hackathon/silent-auction#5

.env.example

@@ -39,3 +39,7 @@ OIDC_CLIENT_ID=
 OIDC_CLIENT_SECRET=
 OIDC_REDIRECT_URI="${APP_URL}/auth/social/oidc/callback"
 
+NORTH_CHECKOUT_ID=
+NORTH_PROFILE_ID=
+NORTH_PRIVATE_API_KEY=
+

.gitignore

@@ -12,3 +12,4 @@ npm-debug.log
 /public/rldbadm
 /stats
 /.well-known
+.DS_Store

app/Filament/Resources/UserResource.php

@@ -13,6 +13,7 @@ use Filament\Actions\EditAction;
 use Filament\Actions\BulkActionGroup;
 use Filament\Actions\DeleteBulkAction;
 use Filament\Support\Icons\Heroicon;
+use BackedEnum;
 
 class UserResource extends Resource
 {
@@ -20,7 +21,7 @@ class UserResource extends Resource
 
     protected static ?string $recordTitleAttribute = 'name';
 
-    protected static string | \UnitEnum | null $navigationIcon = 'heroicon-o-users';
+    protected static string | BackedEnum | null $navigationIcon = 'heroicon-o-users';
 
     public static function form(Schema $schema): Schema
     {

app/Filament/Resources/WinningBidsResource.php

@@ -49,8 +49,7 @@ class WinningBidsResource extends Resource
                     ->searchable(),
                 TextInput::make('winning_cost')
                     ->label('Winning Bid')
-                    ->prefix('$')
+                    ->prefix('$'),
-                    ->numeric(),
             ]);
     }
 

app/Http/Controllers/Controller.php

@@ -7,7 +7,7 @@ use Illuminate\Routing\Controller as BaseController;
 use Illuminate\Foundation\Validation\ValidatesRequests;
 use Illuminate\Foundation\Auth\Access\AuthorizesRequests;
 
-class Controller extends BaseController
+class Controller extends \Illuminate\Routing\Controller
 {
     use AuthorizesRequests, DispatchesJobs, ValidatesRequests;
 }

app/Http/Controllers/NorthCheckoutController.php

@@ -0,0 +1,212 @@
+<?php
+
+namespace App\Http\Controllers;
+
+use App\Models\Bidders;
+use App\Models\Checkout;
+use App\Models\WinningBids;
+use Illuminate\Http\Request;
+use Illuminate\Support\Facades\Http;
+use Illuminate\Support\Facades\Log;
+use Illuminate\Support\Facades\DB;
+
+class NorthCheckoutController extends Controller
+{
+    public function checkout(Request $request, $bidder_id)
+    {
+        $bidder = Bidders::where('idbidders', $bidder_id)->firstOrFail();
+
+        // Check if already checked out
+        if (Checkout::where('bidder_num', $bidder->idbidders)->exists()) {
+            return redirect('/mywinnings?bidder_number=' . $bidder->bidder_assigned_number)->with('error', 'Bidder has already checked out.');
+        }
+
+        $winnings = WinningBids::where('winning_bidder_num', $bidder->idbidders)->get();
+        $total_cost = $winnings->sum('winning_cost');
+
+        if ($total_cost <= 0) {
+            return redirect('/mywinnings?bidder_number=' . $bidder->bidder_assigned_number)->with('error', 'No winnings found for this bidder.');
+        }
+
+        return view('north_checkout', [
+            'bidder' => $bidder,
+            'total_cost' => $total_cost,
+        ]);
+    }
+
+    public function createSession(Request $request, $bidder_id)
+    {
+        $bidder = Bidders::findOrFail($bidder_id);
+        $winnings = WinningBids::with('items')->where('winning_bidder_num', $bidder->idbidders)->get();
+        $total_cost = $winnings->sum('winning_cost');
+
+        $products = $winnings->map(function($winning) {
+            return [
+                'name' => $winning->items->item_desc ?? 'Auction Item',
+                'price' => (float)$winning->winning_cost,
+                'quantity' => 1
+            ];
+        })->toArray();
+
+        $apiKey = config('services.north.private_api_key');
+        $checkoutId = config('services.north.checkout_id');
+        $profileId = config('services.north.profile_id');
+
+        if (!$apiKey || !$checkoutId || !$profileId) {
+            return response()->json(['error' => 'North configuration missing.'], 500);
+        }
+
+        $response = Http::withHeaders([
+            'Authorization' => 'Bearer ' . $apiKey,
+            'Accept' => 'application/json',
+            'Content-Type' => 'application/json',
+        ])->post('https://checkout.north.com/api/sessions', [
+            'checkoutId' => $checkoutId,
+            'profileId' => $profileId,
+            'amount' => (float)$total_cost,
+            'products' => $products,
+        ]);
+
+        if ($response->failed()) {
+            Log::error('North Session Creation Failed: ' . $response->status() . ' ' . $response->body());
+            return response()->json([
+                'error' => 'Failed to create checkout session: ' . ($response->json('message') ?? 'Unknown error'),
+                'status' => $response->status(),
+                'body' => $response->body()
+            ], 500);
+        }
+
+        $data = $response->json();
+        
+        // If json() is null but body is not empty, it might be a parsing error
+        if (is_null($data) && !empty($response->body())) {
+             Log::error('North Session Response is not JSON: ' . $response->body());
+             return response()->json([
+                'error' => 'Response from North is not valid JSON.',
+                'raw_body' => $response->body()
+            ], 500);
+        }
+
+        $token = $data['token'] ?? 
+                 $data['sessionToken'] ?? 
+                 $data['id'] ?? 
+                 $data['session_id'] ?? 
+                 ($data['session']['id'] ?? null);
+
+        if (!$token) {
+            Log::error('North Session Token Missing in Response: ' . json_encode($data));
+            return response()->json([
+                'error' => 'Session token not found in API response.',
+                'debug_response' => $data,
+                'raw_body' => $response->body()
+            ], 500);
+        }
+
+        return response()->json(['sessionToken' => $token]);
+    }
+
+    public function verify(Request $request, $bidder_id)
+    {
+        $bidder = Bidders::findOrFail($bidder_id);
+        $sessionToken = $request->query('sessionToken');
+        if (!$sessionToken) {
+            return redirect('/mywinnings?bidder_number=' . $bidder->bidder_assigned_number)->with('error', 'Missing session token.');
+        }
+
+        $apiKey = config('services.north.private_api_key');
+        $checkoutId = config('services.north.checkout_id');
+        $profileId = config('services.north.profile_id');
+
+        $response = Http::withHeaders([
+            'Authorization' => 'Bearer ' . $apiKey,
+            'SessionToken' => $sessionToken,
+            'CheckoutId' => $checkoutId,
+            'ProfileId' => $profileId,
+            'Accept' => 'application/json',
+        ])->get('https://checkout.north.com/api/sessions/status');
+
+        if ($response->failed()) {
+            Log::error('North Session Verification Failed: ' . $response->status() . ' ' . $response->body());
+            return redirect('/mywinnings?bidder_number=' . $bidder->bidder_assigned_number)->with('error', 'Failed to verify payment status. Status: ' . $response->status());
+        }
+
+        $status = $response->json();
+        $currentStatus = $status['status'] ?? '';
+
+        // The North API status check might return Approved, completed, success, authorized, or captured.
+        $successStatuses = ['approved', 'completed', 'success', 'authorized', 'captured'];
+        
+        if (in_array(strtolower($currentStatus), $successStatuses)) {
+             // Check if already checked out to avoid duplicates
+             $existingCheckout = Checkout::where('bidder_num', $bidder->idbidders)->first();
+             
+             if (!$existingCheckout) {
+                 // According to docs, when status is Approved, transaction details are in 'body'
+                 // Digital wallets might have these at the top level
+                 $body = $status['body'] ?? [];
+                 $winnertotal = $status['amount'] ?? 
+                                ($body['amount'] ?? 
+                                ($status['amount_total'] ?? 
+                                WinningBids::where('winning_bidder_num', $bidder->idbidders)->sum('winning_cost')));
+                                
+                 $payment_method = 3; // Credit Card
+                 $cc_transaction = $body['auth_guid'] ?? 
+                                   ($status['transaction_id'] ?? 
+                                   ($status['transactionId'] ?? 
+                                   ($status['id'] ?? 'NORTH_EC')));
+                                   
+                 $cc_amount = $winnertotal;
+                 $check_number = null;
+
+                 $checkout_id = DB::table('checkout')->insertGetID(
+                    [
+                    'bidder_num' => $bidder->idbidders,
+                    'winnertotal' => $winnertotal,
+                    'payment_method' => $payment_method,
+                    'check_number' => $check_number,
+                    'cc_transaction' => $cc_transaction,
+                    'cc_amount' => $cc_amount,
+                    'created_at' => now(),
+                    'updated_at' => now(),
+                    ]
+                 );
+             } else {
+                 $checkout_id = $existingCheckout->checkout_id;
+                 $payment_method = $existingCheckout->payment_method;
+                 $cc_transaction = $existingCheckout->cc_transaction;
+                 $check_number = $existingCheckout->check_number;
+             }
+
+             // Replicate the data for checkout_complete view
+             $checkout_list_results = DB::select("SELECT
+                *, items.item_assigned_num, items.item_desc
+                FROM winning_bids
+                INNER JOIN items AS items
+                ON winning_bids.winning_item_num=items.iditems
+                WHERE winning_bidder_num = $bidder->idbidders
+              ");
+
+             $checkout_info_results = DB::select("SELECT
+                winning_bids.*,
+                bidders.*,
+                sum(winning_cost) AS total_cost
+                FROM winning_bids
+                INNER JOIN bidders AS bidders
+                ON winning_bids.winning_bidder_num=bidders.idbidders
+                WHERE winning_bidder_num = $bidder->idbidders
+                GROUP BY winning_bids.winning_bidder_num
+              ");
+
+             return view('checkout_complete', [
+               'checkout_result' => $checkout_id,
+               'checkout_list_results' => $checkout_list_results,
+               'checkout_info_results' => $checkout_info_results,
+               'payment_method' => $payment_method,
+               'check_number' => $check_number,
+               'cc_transaction' => $cc_transaction
+             ]);
+        }
+
+        return redirect('/mywinnings?bidder_number=' . $bidder->bidder_assigned_number)->with('error', 'Payment not completed. Status: ' . ($status['status'] ?? 'unknown'));
+    }
+}

app/Http/Controllers/PagesController.php

@@ -6,7 +6,7 @@ use Illuminate\Http\Request;
 use Illuminate\Support\Facades\DB;
 use View;
 use App\helpers;
-use PDF;
+use Spatie\LaravelPdf\Facades\Pdf;
 use App\Models\Bidders;
 use App\Models\Items;
 use App\Models\Checkout;
@@ -19,6 +19,7 @@ use App\Models\CarShowCategory;
 use App\Models\Types;
 use App\Models\Vehicles;
 use App\Models\VehicleScores;
+use Dompdf\Dompdf;
 
 class PagesController extends Controller
 {
@@ -81,7 +82,8 @@ class PagesController extends Controller
     public function checkout(Request $checkout_req)
     {
         if (!$checkout_req->checkoutbiddernum) {
-            return view('checkout_select_form');
+            $bidders = \App\Models\Bidders::orderByRaw('CAST(bidder_assigned_number AS UNSIGNED) ASC')->get();
+            return view('checkout_select_form', ['bidders' => $bidders]);
         } elseif (!$checkout_req->checkout_payment_method) {
             $checkout_bidder = $checkout_req->checkoutbiddernum;
             $checkout_list_results = DB::select("SELECT
@@ -161,20 +163,32 @@ class PagesController extends Controller
 
     public function editwinners(Request $edit_win_req)
     {
-        if (!$edit_win_req->winid) {
+        if ($edit_win_req->id) {
-            return view('editwinners');
+            $winner = WinningBids::with(['items', 'bidders'])->find($edit_win_req->id);
+            $bidders = Bidders::all();
+            $items = Items::all();
+            return view('editwinners', ['winner' => $winner, 'bidders' => $bidders, 'items' => $items]);
         }
+        
+        if (!$edit_win_req->winid) {
+            $winners = WinningBids::with(['items', 'bidders'])->get();
+            return view('winnersbyitem', ['winnersbyitem_results' => $winners]);
+        }
+        
         $winning_bid_id = $edit_win_req->winid;
         $winner_bidder = $edit_win_req->winnerbiddernum;
+        $winner_item = $edit_win_req->winneritemnum;
         $winner_cost = $edit_win_req->winnerbid;
+        
         $winner_insert = WinningBids::where('idwinning_bids', $winning_bid_id)
                     ->update(
                         [
                         'winning_bidder_num' => $winner_bidder,
+                        'winning_item_num' => $winner_item,
                         'winning_cost' => $winner_cost
                         ]
                       );
-        return redirect('editwinners');
+        return redirect('winnersbyitem');
     }
 
     public function finaltally()
@@ -250,10 +264,54 @@ class PagesController extends Controller
         return view('receiptpdf', $checkout_data);
     }
 
+    public function downloadReceiptPdf(Request $request)
+    {
+        $checkoutid = $request->checkout_id;
+        $checkout_final_results = Checkout::where('checkout_id', '=', $checkoutid)->first();
+        if (!$checkout_final_results) {
+            return redirect('/mywinnings')->with('error', 'Checkout record not found.');
+        }
+
+        $bidder_num = $checkout_final_results->bidder_num;
+        $checkout_list_results = DB::select("SELECT
+            *, items.item_assigned_num, items.item_desc
+            FROM winning_bids
+            INNER JOIN items AS items ON winning_bids.winning_item_num=items.iditems
+            WHERE winning_bidder_num = $bidder_num
+        ");
+        $checkout_info_results = DB::select("SELECT
+            winning_bids.*,
+            bidders.*,
+            sum(winning_cost) AS total_cost
+            FROM winning_bids
+            INNER JOIN bidders AS bidders ON winning_bids.winning_bidder_num=bidders.idbidders
+            WHERE winning_bidder_num = $bidder_num
+            GROUP BY winning_bids.winning_bidder_num
+        ");
+
+        $options = new \Dompdf\Options();
+        $options->set('isHtml5ParserEnabled', true);
+        $options->set('isRemoteEnabled', true);
+        $dompdf = new Dompdf($options);
+        
+        $html = view('receiptpdf', [
+            'checkout_final_results' => $checkout_final_results,
+            'checkout_list_results' => $checkout_list_results,
+            'checkout_info_results' => $checkout_info_results
+        ])->render();
+        
+        $dompdf->loadHtml($html);
+        $dompdf->setPaper('letter', 'portrait');
+        $dompdf->render();
+        
+        return $dompdf->stream('receipt-'.$checkoutid.'.pdf');
+    }
+
     public function reprintReceipt(Request $reprint_receipt_req)
     {
         if (!$reprint_receipt_req->reprintbiddernum) {
-            return view('reprint_receipt_form');
+            $bidders = Bidders::has('checkout')->get();
+            return view('reprint_receipt_form', ['bidders' => $bidders]);
         } else {
             $bidnum=$reprint_receipt_req->reprintbiddernum;
             $checkout_result = Checkout::where('bidder_num', '=', $bidnum)
@@ -274,7 +332,9 @@ class PagesController extends Controller
     public function winners(Request $winners_req)
     {
         if (!$winners_req->winnerbid) {
-            return view('winners');
+            $bidders = Bidders::all();
+            $items = Items::all();
+            return view('winners', ['bidders' => $bidders, 'items' => $items]);
         }
         $winner_item = $winners_req->winneritemnum;
         $winner_bidder = $winners_req->winnerbiddernum;
@@ -291,22 +351,15 @@ class PagesController extends Controller
 
     public function winnersbyitem()
     {
-        $winnersbyitem_results = DB::select("SELECT
+        $winnersbyitem_results = WinningBids::with(['items', 'bidders'])->get();
-      *
-      FROM winning_bids
-      INNER JOIN items as items
-      ON winning_bids.winning_item_num=items.iditems
-      INNER JOIN bidders AS bidders
-      ON winning_bids.winning_bidder_num=bidders.idbidders
-      ORDER BY item_assigned_num ASC
-    ");
         return view('winnersbyitem', ['winnersbyitem_results' => $winnersbyitem_results]);
     }
 
     public function winnertotal(Request $winnertotal_req)
     {
         if (!$winnertotal_req->winnerbiddernum) {
-            return view('winnertotalform');
+            $bidders = Bidders::all();
+            return view('winnertotalform', ['bidders' => $bidders]);
         }
         $winner_total_bidder = $winnertotal_req->winnerbiddernum;
         $winnertotal_list_results = DB::select("SELECT
@@ -334,37 +387,41 @@ class PagesController extends Controller
 
     public function winningbidderlist()
     {
-        $winnerlist_results = WinningBids::join('bidders', 'winning_bids.winning_bidder_num', '=', 'bidders.idbidders')
+        $winnerlist_results = Bidders::whereHas('winningBids')
-                                          ->groupBy('winning_bidder_num')
+                                          ->orderBy('bidder_assigned_number')
-                                          ->orderBy('bidders.bidder_assigned_number')
                                           ->get();
-        return view('winningbidderlist', ['winnerlist_results' => $winnerlist_results]);
+        return view('winningbidderlist', ['winning_bidders' => $winnerlist_results]);
     }
+
     public function judgingentry(Request $judgingentry_req)
     {
-        if (!$judgingentry_req->vehnum) {
+        $judges = \App\Models\Judges::all();
-            return view('judgingentry');
+        $vehicles = \App\Models\Vehicles::select('vehicles.*')
-        }
+            ->leftJoin('bidders', 'vehicles.owner', '=', 'bidders.bidder_assigned_number')
-        $vehicle = $judgingentry_req->vehnum;
+            ->orderByRaw('CAST(bidders.bidder_assigned_number AS UNSIGNED) ASC')
-        $judge = $judgingentry_req->judgenum;
+            ->get();
-        $score = $judgingentry_req->vehscore;
-        $bidder_insert = VehicleScores::updateOrCreate(
-            [
-            'vehicle' => $vehicle,
-            'judge' => $judge 
-            ],
-            [
-            'overall_score' => $score
-            ]
-        );
 
-        return redirect('judgingentry');
+        if ($judgingentry_req->isMethod('post')) {
+            $vehicle = $judgingentry_req->vehnum;
+            $judge = $judgingentry_req->judgenum;
+            $score = $judgingentry_req->vehscore;
+            
+            VehicleScores::updateOrCreate(
+                ['vehicle' => $vehicle, 'judge' => $judge],
+                ['overall_score' => $score]
+            );
+
+            return redirect('judgingentry');
+        }
+
+        return view('judgingentry', ['judges' => $judges, 'vehicles' => $vehicles]);
     }
 
     public function showcars(Request $showcar_req)
     {
         if (!$showcar_req->bidderlname) {
-            return view('showcars');
+            $vehicles = \App\Models\Vehicles::with('vehicleOwner')->get();
+            return view('showcars', ['vehicles' => $vehicles]);
         }
         $bidder_lname = $showcar_req->bidderlname;
         $bidder_fname = $showcar_req->bidderfname;
@@ -423,7 +480,8 @@ class PagesController extends Controller
     public function pcentry(Request $pcentry_req)
     {
         if (!$pcentry_req->vehnum) {
-            return view('pcentry');
+            $vehicles = Vehicles::all();
+            return view('pcentry', ['vehicles' => $vehicles]);
         }
         $vehicle=$pcentry_req->vehnum;
         $pc_count=$pcentry_req->pc_count;
@@ -457,7 +515,8 @@ class PagesController extends Controller
    public function awardcategories(Request $category_req)
     {
         if (!$category_req->category) {
-            return view('awardcategories');
+            $categories = CarShowCategory::all();
+            return view('awardcategories', ['categories' => $categories]);
         }
         $category = $category_req->category;
         if ($category_req->has('vehtype')) {
@@ -479,20 +538,20 @@ class PagesController extends Controller
    public function showwinners()
     {
         $carshowwinner_results = CarShowWinner::with(['awardCategory', 'awardVehicle', 'awardVehicle.vehicleOwner'])->get();
-        return view('carshowwinners', ['carshowwinner_results' => $carshowwinner_results]);
+        return view('carshowwinners', ['winners' => $carshowwinner_results]);
     }
    public function showscores()
     {
-        $carshowscore_results = VehicleScores::with(['scoredVehicle'])
+        $carshowscore_results = VehicleScores::with(['scoredVehicle', 'scoredVehicle.vehicleOwner'])
             ->groupBy('vehicle')
             ->selectRaw('*, sum(vehicle_scores.overall_score) as totalscore')
             ->orderBy('totalscore', 'desc')
             ->get();
-        return view('carshowscores', ['carshowscore_results' => $carshowscore_results]);
+        return view('carshowscores', ['scores_results' => $carshowscore_results]);
     }
    public function showscoresbycar()
     {
-        $carshowscore2_results = VehicleScores::with(['scoredVehicle'])
+        $carshowscore2_results = VehicleScores::with(['scoredVehicle', 'scoredVehicle.vehicleOwner'])
             ->groupBy('vehicle')
             ->selectRaw('*, sum(vehicle_scores.overall_score) as totalscore')
             //->orderBy('scoredVehicle.vehicleOwner.bidder_assigned_number')
@@ -503,7 +562,7 @@ class PagesController extends Controller
                 LIMIT 1
             ) AS UNSIGNED) ASC')
             ->get();
-        return view('carshowscores', ['carshowscore_results' => $carshowscore2_results]);
+        return view('carshowscores', ['scores_results' => $carshowscore2_results]);
     }    
     public function showcarlist()
     {
@@ -535,10 +594,14 @@ class PagesController extends Controller
 
         $total_cost = $winnings->sum('winning_cost');
 
+        $is_checked_out = \App\Models\Checkout::where('bidder_num', $bidder->idbidders)->exists();
+
         return view('mywinnings_results', [
             'bidder' => $bidder,
             'winnings' => $winnings,
-            'total_cost' => $total_cost
+            'total_cost' => $total_cost,
+            'is_checked_out' => $is_checked_out
         ]);
     }
 }
+

app/Models/CarShowWinner.php

@@ -24,11 +24,11 @@ class CarShowWinner extends Model
 
   public function awardVehicle()
   {
-    return $this->hasMany('App\Models\Vehicles', 'id', 'vehicle');
+    return $this->belongsTo('App\Models\Vehicles', 'vehicle', 'id');
   }
 
   public function awardCategory()
   {
-    return $this->hasMany('App\Models\CarShowCategory', 'id', 'category');
+    return $this->belongsTo('App\Models\CarShowCategory', 'category', 'id');
   }
 }

app/Models/VehicleScores.php

@@ -30,6 +30,6 @@ class VehicleScores extends Model
 
   public function scoredVehicle()
   {
-      return $this->hasMany('App\Models\Vehicles', 'id', 'vehicle');
+      return $this->belongsTo('App\Models\Vehicles', 'vehicle', 'id');
   }
 }

app/Providers/Filament/AdminPanelProvider.php

@@ -23,6 +23,8 @@ use Illuminate\Support\Facades\Blade;
 
 use Filament\Navigation\MenuItem;
 
+use Filament\Facades\Filament;
+
 class AdminPanelProvider extends PanelProvider
 {
     public function boot()
@@ -42,6 +44,13 @@ class AdminPanelProvider extends PanelProvider
                 </div>
             '),
         );
+
+        Filament::registerUserMenuItems([
+            MenuItem::make()
+                ->label('Link OIDC Account')
+                ->icon('heroicon-o-link')
+                ->url(fn (): string => url('auth/social/oidc')),
+        ]);
     }
 
     public function panel(Panel $panel): Panel
@@ -51,14 +60,15 @@ class AdminPanelProvider extends PanelProvider
             ->id('admin')
             ->path('admin')
             ->login()
-            ->brandName(env('APP_NAME'))
+            ->profile()
-            ->homeUrl('/')
             ->userMenuItems([
-                MenuItem::make()
+                'oidc' => MenuItem::make()
                     ->label('Link OIDC Account')
                     ->icon('heroicon-o-link')
                     ->url(fn (): string => url('auth/social/oidc')),
             ])
+            ->brandName(env('APP_NAME'))
+            ->homeUrl('/')
             ->colors([
                 'primary' => Color::Amber,
             ])

composer.json

@@ -5,16 +5,19 @@
     "license": "MIT",
     "type": "project",
     "require": {
-        "php": "^8.2",
+        "php": "^8.3",
         "barryvdh/laravel-snappy": "^1.0",
         "carlos-meneses/laravel-mpdf": "^2.1",
+        "dompdf/dompdf": "^3.1",
         "filament/filament": "^5.0",
         "kovah/laravel-socialite-oidc": "^0.7.0",
-        "laravel/framework": "^11.0",
+        "laravel/framework": "^12.0",
         "laravel/socialite": "^5.26",
         "laravel/tinker": "^2.9",
         "laravel/ui": "^4.2",
-        "socialiteproviders/manager": "^4.9"
+        "socialiteproviders/manager": "^4.9",
+        "spatie/laravel-pdf": "^2.8",
+        "takielias/tablar": "^13.02"
     },
     "require-dev": {
         "barryvdh/laravel-debugbar": "^3.8",
@@ -69,5 +72,7 @@
         "preferred-install": "dist",
         "sort-packages": true,
         "optimize-autoloader": true
-    }
+    },
+    "minimum-stability": "dev",
+    "prefer-stable": true
 }

config/services.php

@@ -42,4 +42,10 @@ return [
         'redirect' => env('OIDC_REDIRECT_URI'),
     ],
 
+    'north' => [
+        'checkout_id' => env('NORTH_CHECKOUT_ID'),
+        'profile_id' => env('NORTH_PROFILE_ID'),
+        'private_api_key' => env('NORTH_PRIVATE_API_KEY'),
+    ],
+
 ];

config/tablar.php

@@ -0,0 +1,145 @@
+<?php
+
+return [
+    'title' => 'Silent Auction Dashboard',
+    'logo' => '/assets/tablar-logo.png',
+    'menu' => [
+        [
+            'text' => 'Home',
+            'route' => 'home',
+            'icon' => 'ti ti-home',
+        ],
+        [
+            'text' => 'Bidders',
+            'icon' => 'ti ti-users',
+            'submenu' => [
+                [
+                    'text' => 'Add Bidder',
+                    'route' => 'bidders',
+                ],
+                [
+                    'text' => 'List Bidders',
+                    'route' => 'bidderlist',
+                ],
+            ],
+        ],
+        [
+            'text' => 'Items',
+            'icon' => 'ti ti-box',
+            'submenu' => [
+                [
+                    'text' => 'Add Item',
+                    'route' => 'items',
+                ],
+                [
+                    'text' => 'List Items',
+                    'route' => 'itemlist',
+                ],
+            ],
+        ],
+        [
+            'text' => 'Winners',
+            'icon' => 'ti ti-trophy',
+            'submenu' => [
+                [
+                    'text' => 'Add Winner',
+                    'route' => 'winners',
+                ],
+                [
+                    'text' => 'Edit Winner',
+                    'route' => 'editwinners',
+                ],
+                [
+                    'text' => 'List Winners',
+                    'route' => 'winnerlist',
+                ],
+                [
+                    'text' => 'Winners by Item',
+                    'route' => 'winnersbyitem',
+                ],
+                [
+                    'text' => 'Check My Winnings',
+                    'route' => 'mywinnings',
+                ],
+            ],
+        ],
+        [
+            'text' => 'CarShow',
+            'icon' => 'ti ti-car',
+            'submenu' => [
+                [
+                    'text' => 'Add Car',
+                    'route' => 'showcars',
+                ],
+                [
+                    'text' => 'List Show Cars',
+                    'route' => 'showcarlist',
+                ],
+                [
+                    'text' => 'Judging Entry',
+                    'route' => 'judgingentry',
+                ],
+                [
+                    'text' => 'People\'s Choice Entry',
+                    'route' => 'pcentry',
+                ],
+                [
+                    'text' => 'Add Judge',
+                    'route' => 'judges',
+                ],
+                [
+                    'text' => 'Car Show Winners',
+                    'route' => 'showwinners',
+                ],
+                [
+                    'text' => 'Vehicle Total Scores',
+                    'route' => 'showscores',
+                ],
+                [
+                    'text' => 'Scores by Car',
+                    'route' => 'showscoresbycar',
+                ],
+                [
+                    'text' => 'Tabulate Winners',
+                    'route' => 'tabulateshowwinners',
+                ],
+            ],
+        ],
+        [
+            'text' => 'Reports',
+            'icon' => 'ti ti-file-text',
+            'submenu' => [
+                [
+                    'text' => 'Bidder List',
+                    'route' => 'bidderlist',
+                ],
+                [
+                    'text' => 'Completed Checkouts',
+                    'route' => 'checkout_complete_list',
+                ],
+                [
+                    'text' => 'Items',
+                    'route' => 'itemlist',
+                ],
+                [
+                    'text' => 'Winners',
+                    'route' => 'winnerlist',
+                ],
+            ],
+        ],
+        [
+            'text' => 'Checkout',
+            'icon' => 'ti ti-credit-card',
+            'submenu' => [
+                [
+                    'text' => 'Checkout Bidder',
+                    'route' => 'checkout',
+                ],
+                [
+                    'text' => 'Re-Print Receipt',
+                    'route' => 'reprint_receipt',
+                ],
+            ],
+        ],
+    ],
+];

database/factories/ModelFactory.php

@@ -23,14 +23,131 @@ $factory->define(App\User::class, function (Faker\Generator $faker) {
     ];
 });
 
-//Bidder
+// Bidders
-$factory->define(App\Models\Bidder::class, function (Faker\Generator $faker) {
+$factory->define(App\Models\Bidders::class, function (Faker\Generator $faker) {
-    static $password;
-
     return [
-        'name' => $faker->name,
+        'bidder_fname' => $faker->firstName,
-        'email' => $faker->unique()->safeEmail,
+        'bidder_lname' => $faker->lastName,
-        'password' => $password ?: $password = bcrypt('secret'),
+        'bidder_addr' => $faker->streetAddress,
-        'remember_token' => str_random(10),
+        'bidder_city' => $faker->city,
+        'bidder_state' => $faker->stateAbbr,
+        'bidder_zip' => $faker->postcode,
+        'bidder_phone' => $faker->phoneNumber,
+        'bidder_email' => $faker->unique()->safeEmail,
+        'bidder_assigned_number' => $faker->unique()->numberBetween(1, 1000),
+    ];
+});
+
+// Items
+$factory->define(App\Models\Items::class, function (Faker\Generator $faker) {
+    return [
+        'item_desc' => $faker->sentence(3),
+        'item_min_bid' => $faker->numberBetween(10, 100),
+        'item_est_value' => $faker->numberBetween(50, 500),
+        'item_assigned_num' => $faker->unique()->numberBetween(1, 500),
+    ];
+});
+
+// CarShowCategory
+$factory->define(App\Models\CarShowCategory::class, function (Faker\Generator $faker) {
+    return [
+        'category_name' => $faker->words(2, true),
+        'vehicle_type' => $faker->boolean,
+    ];
+});
+
+// Vehicles
+$factory->define(App\Models\Vehicles::class, function (Faker\Generator $faker) {
+    return [
+        'year' => $faker->year,
+        'make' => $faker->company,
+        'model' => $faker->word,
+        'type' => function () {
+            return factory(App\Models\CarShowCategory::class)->create()->id;
+        },
+        'doNotJudge' => $faker->boolean,
+        'owner' => function () {
+            return factory(App\Models\Bidders::class)->create()->bidder_assigned_number;
+        },
+    ];
+});
+
+// PaymentMethods
+$factory->define(App\Models\PaymentMethods::class, function (Faker\Generator $faker) {
+    return [
+        'pm_name' => $faker->randomElement(['Cash', 'Check', 'Credit Card']),
+    ];
+});
+
+// Judges
+$factory->define(App\Models\Judges::class, function (Faker\Generator $faker) {
+    return [
+        'judge_number' => $faker->unique()->numberBetween(1, 50),
+    ];
+});
+
+// VehicleScores
+$factory->define(App\Models\VehicleScores::class, function (Faker\Generator $faker) {
+    return [
+        'judge' => function () {
+            return factory(App\Models\Judges::class)->create()->id;
+        },
+        'overall_score' => $faker->numberBetween(1, 100),
+        'vehicle' => function () {
+            return factory(App\Models\Vehicles::class)->create()->id;
+        },
+    ];
+});
+
+// PeoplesChoice
+$factory->define(App\Models\PeoplesChoice::class, function (Faker\Generator $faker) {
+    return [
+        'vehicle' => function () {
+            return factory(App\Models\Vehicles::class)->create()->id;
+        },
+        'pc_count' => $faker->numberBetween(0, 50),
+    ];
+});
+
+// WinningBids
+$factory->define(App\Models\WinningBids::class, function (Faker\Generator $faker) {
+    return [
+        'winning_bidder_num' => function () {
+            return factory(App\Models\Bidders::class)->create()->idbidders;
+        },
+        'winning_cost' => $faker->numberBetween(10, 1000),
+        'winning_item_num' => function () {
+            return factory(App\Models\Items::class)->create()->iditems;
+        },
+    ];
+});
+
+// Checkout
+$factory->define(App\Models\Checkout::class, function (Faker\Generator $faker) {
+    return [
+        'bidder_num' => function () {
+            return factory(App\Models\Bidders::class)->create()->idbidders;
+        },
+        'winnertotal' => $faker->numberBetween(10, 2000),
+        'payment_method' => function () {
+            return factory(App\Models\PaymentMethods::class)->create()->pm_id;
+        },
+        'check_number' => $faker->optional()->numberBetween(100, 999),
+        'cc_transaction' => $faker->optional()->uuid,
+        'cc_amount' => $faker->optional()->numberBetween(10, 2000),
+    ];
+});
+
+// CarShowWinner
+$factory->define(App\Models\CarShowWinner::class, function (Faker\Generator $faker) {
+    return [
+        'vehicle' => function () {
+            return factory(App\Models\Vehicles::class)->create()->id;
+        },
+        'category' => function () {
+            return factory(App\Models\CarShowCategory::class)->create()->id;
+        },
+        'place' => $faker->numberBetween(1, 3),
+        'total_score' => $faker->numberBetween(50, 300),
     ];
 });

database/seeds/BiddersTableSeeder.php

@@ -0,0 +1,12 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Models\Bidders;
+
+class BiddersTableSeeder extends Seeder
+{
+    public function run()
+    {
+        factory(Bidders::class, 50)->create();
+    }
+}

database/seeds/CarShowCategoryTableSeeder.php

@@ -0,0 +1,12 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Models\CarShowCategory;
+
+class CarShowCategoryTableSeeder extends Seeder
+{
+    public function run()
+    {
+        factory(CarShowCategory::class, 10)->create();
+    }
+}

database/seeds/CarShowWinnerTableSeeder.php

@@ -0,0 +1,25 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Models\CarShowWinner;
+use App\Models\Vehicles;
+use App\Models\CarShowCategory;
+
+class CarShowWinnerTableSeeder extends Seeder
+{
+    public function run()
+    {
+        $categories = CarShowCategory::all();
+        $vehicles = Vehicles::all();
+
+        foreach ($categories as $category) {
+            for ($i = 1; $i <= 3; $i++) {
+                factory(CarShowWinner::class)->create([
+                    'category' => $category->id,
+                    'vehicle' => $vehicles->random()->id,
+                    'place' => $i,
+                ]);
+            }
+        }
+    }
+}

database/seeds/CheckoutTableSeeder.php

@@ -0,0 +1,24 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Models\Checkout;
+use App\Models\Bidders;
+use App\Models\PaymentMethods;
+
+class CheckoutTableSeeder extends Seeder
+{
+    public function run()
+    {
+        $bidders = Bidders::all();
+        $paymentMethods = PaymentMethods::all();
+
+        foreach ($bidders as $bidder) {
+            if (rand(0, 1)) {
+                factory(Checkout::class)->create([
+                    'bidder_num' => $bidder->idbidders,
+                    'payment_method' => $paymentMethods->random()->pm_id,
+                ]);
+            }
+        }
+    }
+}

database/seeds/DatabaseSeeder.php

@@ -11,6 +11,17 @@ class DatabaseSeeder extends Seeder
      */
     public function run()
     {
-        // $this->call(UsersTableSeeder::class);
+        $this->call(UsersTableSeeder::class);
+        $this->call(PaymentMethodsTableSeeder::class);
+        $this->call(CarShowCategoryTableSeeder::class);
+        $this->call(BiddersTableSeeder::class);
+        $this->call(ItemsTableSeeder::class);
+        $this->call(JudgesTableSeeder::class);
+        $this->call(VehiclesTableSeeder::class);
+        $this->call(VehicleScoresTableSeeder::class);
+        $this->call(PeoplesChoiceTableSeeder::class);
+        $this->call(WinningBidsTableSeeder::class);
+        $this->call(CheckoutTableSeeder::class);
+        $this->call(CarShowWinnerTableSeeder::class);
     }
 }

database/seeds/ItemsTableSeeder.php

@@ -0,0 +1,12 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Models\Items;
+
+class ItemsTableSeeder extends Seeder
+{
+    public function run()
+    {
+        factory(Items::class, 30)->create();
+    }
+}

database/seeds/JudgesTableSeeder.php

@@ -0,0 +1,12 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Models\Judges;
+
+class JudgesTableSeeder extends Seeder
+{
+    public function run()
+    {
+        factory(Judges::class, 5)->create();
+    }
+}

database/seeds/PaymentMethodsTableSeeder.php

@@ -0,0 +1,14 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Models\PaymentMethods;
+
+class PaymentMethodsTableSeeder extends Seeder
+{
+    public function run()
+    {
+        PaymentMethods::create(['pm_name' => 'Cash']);
+        PaymentMethods::create(['pm_name' => 'Check']);
+        PaymentMethods::create(['pm_name' => 'Credit Card']);
+    }
+}

database/seeds/PeoplesChoiceTableSeeder.php

@@ -0,0 +1,19 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Models\PeoplesChoice;
+use App\Models\Vehicles;
+
+class PeoplesChoiceTableSeeder extends Seeder
+{
+    public function run()
+    {
+        $vehicles = Vehicles::all();
+
+        foreach ($vehicles as $vehicle) {
+            factory(PeoplesChoice::class)->create([
+                'vehicle' => $vehicle->id,
+            ]);
+        }
+    }
+}

database/seeds/UsersTableSeeder.php

@@ -0,0 +1,12 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\User;
+
+class UsersTableSeeder extends Seeder
+{
+    public function run()
+    {
+        factory(User::class, 10)->create();
+    }
+}

database/seeds/VehicleScoresTableSeeder.php

@@ -0,0 +1,24 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Models\VehicleScores;
+use App\Models\Judges;
+use App\Models\Vehicles;
+
+class VehicleScoresTableSeeder extends Seeder
+{
+    public function run()
+    {
+        $judges = Judges::all();
+        $vehicles = Vehicles::all();
+
+        foreach ($vehicles as $vehicle) {
+            foreach ($judges as $judge) {
+                factory(VehicleScores::class)->create([
+                    'judge' => $judge->id,
+                    'vehicle' => $vehicle->id,
+                ]);
+            }
+        }
+    }
+}

database/seeds/VehiclesTableSeeder.php

@@ -0,0 +1,24 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Models\Vehicles;
+use App\Models\CarShowCategory;
+use App\Models\Bidders;
+
+class VehiclesTableSeeder extends Seeder
+{
+    public function run()
+    {
+        $categories = CarShowCategory::all();
+        $bidders = Bidders::all();
+
+        factory(Vehicles::class, 40)->create([
+            'type' => function () use ($categories) {
+                return $categories->random()->id;
+            },
+            'owner' => function () use ($bidders) {
+                return $bidders->random()->bidder_assigned_number;
+            },
+        ]);
+    }
+}

database/seeds/WinningBidsTableSeeder.php

@@ -0,0 +1,24 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Models\WinningBids;
+use App\Models\Bidders;
+use App\Models\Items;
+
+class WinningBidsTableSeeder extends Seeder
+{
+    public function run()
+    {
+        $bidders = Bidders::all();
+        $items = Items::all();
+
+        foreach ($items as $item) {
+            if (rand(0, 1)) {
+                factory(WinningBids::class)->create([
+                    'winning_bidder_num' => $bidders->random()->idbidders,
+                    'winning_item_num' => $item->iditems,
+                ]);
+            }
+        }
+    }
+}

package.json

@@ -1,21 +1,43 @@
 {
-  "private": true,
+    "private": true,
-  "scripts": {
+    "type": "module",
-    "dev": "npm run development",
+    "scripts": {
-    "development": "cross-env NODE_ENV=development node_modules/webpack/bin/webpack.js --progress --hide-modules --config=node_modules/laravel-mix/setup/webpack.config.js",
+        "dev": "vite",
-    "watch": "cross-env NODE_ENV=development node_modules/webpack/bin/webpack.js --watch --progress --hide-modules --config=node_modules/laravel-mix/setup/webpack.config.js",
+        "build": "vite build"
-    "watch-poll": "npm run watch -- --watch-poll",
+    },
-    "hot": "cross-env NODE_ENV=development node_modules/webpack-dev-server/bin/webpack-dev-server.js --inline --hot --config=node_modules/laravel-mix/setup/webpack.config.js",
+    "devDependencies": {
-    "prod": "npm run production",
+        "@melloware/coloris": "^0.25.0",
-    "production": "cross-env NODE_ENV=production node_modules/webpack/bin/webpack.js --progress --hide-modules --config=node_modules/laravel-mix/setup/webpack.config.js"
+        "@popperjs/core": "^2.11.8",
-  },
+        "@tabler/core": "1.4.0",
-  "devDependencies": {
+        "@tabler/icons": "^3.35.0",
-    "axios": "^0.15.3",
+        "@tabler/icons-webfont": "^3.35.0",
-    "bootstrap-sass": "^3.3.7",
+        "apexcharts": "^3.54.1",
-    "cross-env": "^3.2.3",
+        "autosize": "^6.0.1",
-    "jquery": "^3.1.1",
+        "axios": "^1.7.4",
-    "laravel-mix": "0.*",
+        "bootstrap": "5.3.8",
-    "lodash": "^4.17.4",
+        "bootstrap-sass": "^3.3.7",
-    "vue": "^2.1.10"
+        "choices.js": "^11.1.0",
-  }
+        "countup.js": "^2.9.0",
+        "cross-env": "^7.0.3",
+        "dropzone": "^6.0.0-beta.2",
+        "fslightbox": "^3.7.4",
+        "fullcalendar": "^6.1.19",
+        "imask": "^7.6.1",
+        "jquery": "^3.7.1",
+        "jsvectormap": "^1.7.0",
+        "laravel-vite-plugin": "^1.0",
+        "list.js": "^2.3.1",
+        "litepicker": "^2.0.12",
+        "lodash": "^4.17.21",
+        "nouislider": "^15.8.1",
+        "plyr": "^3.8.3",
+        "sass": "~1.64.2",
+        "sass-loader": "^16.0.1",
+        "signature_pad": "^5.1.1",
+        "star-rating.js": "^4.3.1",
+        "tom-select": "^2.4.3",
+        "typed.js": "^2.1.0",
+        "vite": "^5.0.0",
+        "vite-plugin-static-copy": "~3.0.0"
+    }
 }

public/.well-known

@@ -1 +1 @@
-/home/sjcsauction/public_html/.well-known
+auction/home/sjcsauction/public_html/.well-known