'boolean', ]; public function processingTypes() { return $this->hasMany(VisaProcessingType::class); } } 'boolean', ]; public function visaType() { return $this->belongsTo(VisaType::class); } } 'boolean', ]; public function insurancePlans() { return $this->hasMany(InsurancePlan::class); } } 'boolean', ]; public function company() { return $this->belongsTo(InsuranceCompany::class, 'insurance_company_id'); } } 'date', ]; public function user() { return $this->belongsTo(User::class); } public function visaType() { return $this->belongsTo(VisaType::class); } public function processingType() { return $this->belongsTo(VisaProcessingType::class, 'visa_processing_type_id'); } public function insurancePlan() { return $this->belongsTo(InsurancePlan::class); } public function applicants() { return $this->hasMany(VisaApplicant::class); } public function documents() { return $this->hasMany(VisaDocument::class); } public function payment() { return $this->hasOne(Payment::class); } } 'date', 'date_of_birth' => 'date', 'is_main_applicant' => 'boolean', ]; public function application() { return $this->belongsTo(VisaApplication::class); } } belongsTo(VisaApplication::class); } } 'datetime', ]; public function application() { return $this->belongsTo(VisaApplication::class); } } 'date', 'end_date' => 'date', ]; public function application() { return $this->belongsTo(VisaApplication::class); } public function plan() { return $this->belongsTo(InsurancePlan::class, 'insurance_plan_id'); } } id(); $table->string('name'); $table->text('description')->nullable(); $table->integer('duration_days'); $table->boolean('is_active')->default(true); $table->softDeletes(); $table->timestamps(); }); } public function down(): void { Schema::dropIfExists('visa_types'); } }; id(); $table->foreignId('visa_type_id')->constrained()->onDelete('cascade'); $table->string('name'); $table->text('description')->nullable(); $table->decimal('price', 10, 2); $table->integer('processing_days'); $table->boolean('is_active')->default(true); $table->timestamps(); }); } public function down(): void { Schema::dropIfExists('visa_processing_types'); } }; id(); $table->string('name'); $table->text('description')->nullable(); $table->string('logo')->nullable(); $table->string('website')->nullable(); $table->string('phone'); $table->string('email'); $table->boolean('is_active')->default(true); $table->softDeletes(); $table->timestamps(); }); } public function down(): void { Schema::dropIfExists('insurance_companies'); } }; id(); $table->foreignId('insurance_company_id')->constrained()->onDelete('cascade'); $table->string('name'); $table->text('description'); $table->decimal('price_per_person', 10, 2); $table->text('coverage_details'); $table->integer('duration_days'); $table->boolean('is_active')->default(true); $table->timestamps(); }); } public function down(): void { Schema::dropIfExists('insurance_plans'); } }; id(); $table->foreignId('user_id')->constrained()->onDelete('cascade'); $table->foreignId('visa_type_id')->constrained()->onDelete('cascade'); $table->foreignId('visa_processing_type_id')->constrained('visa_processing_types')->onDelete('cascade'); $table->foreignId('insurance_plan_id')->nullable()->constrained('insurance_plans')->onDelete('set null'); $table->string('status')->default('pending'); $table->date('expected_travel_date'); $table->decimal('total_amount', 10, 2); $table->string('payment_status')->default('pending'); $table->text('notes')->nullable(); $table->softDeletes(); $table->timestamps(); }); } public function down(): void { Schema::dropIfExists('visa_applications'); } }; id(); $table->foreignId('visa_application_id')->constrained()->onDelete('cascade'); $table->string('first_name'); $table->string('last_name'); $table->string('passport_number'); $table->date('passport_expiry'); $table->string('nationality'); $table->date('date_of_birth'); $table->string('gender'); $table->boolean('is_main_applicant')->default(false); $table->timestamps(); }); } public function down(): void { Schema::dropIfExists('visa_applicants'); } }; id(); $table->foreignId('visa_application_id')->constrained()->onDelete('cascade'); $table->string('document_type'); $table->string('file_path'); $table->text('notes')->nullable(); $table->timestamps(); }); } public function down(): void { Schema::dropIfExists('visa_documents'); } }; id(); $table->foreignId('visa_application_id')->constrained()->onDelete('cascade'); $table->decimal('amount', 10, 2); $table->string('payment_method'); $table->string('transaction_id')->nullable(); $table->string('status')->default('pending'); $table->dateTime('payment_date')->nullable(); $table->timestamps(); }); } public function down(): void { Schema::dropIfExists('payments'); } }; id(); $table->foreignId('visa_application_id')->constrained()->onDelete('cascade'); $table->foreignId('insurance_plan_id')->constrained()->onDelete('cascade'); $table->string('policy_number'); $table->date('start_date'); $table->date('end_date'); $table->text('coverage_details'); $table->string('status')->default('active'); $table->timestamps(); }); } public function down(): void { Schema::dropIfExists('insurance_policies'); } }; with(['visaType', 'processingType', 'insurancePlan']) ->latest() ->paginate(10); return view('visa.applications.index', compact('applications')); } public function create() { $visaTypes = VisaType::active()->with('processingTypes')->get(); $insuranceCompanies = InsuranceCompany::active()->with('insurancePlans')->get(); return view('visa.applications.create', compact('visaTypes', 'insuranceCompanies')); } public function store(Request $request) { $validated = $request->validate([ 'visa_type_id' => 'required|exists:visa_types,id', 'visa_processing_type_id' => 'required|exists:visa_processing_types,id', 'expected_travel_date' => 'required|date|after:today', 'applicants' => 'required|array|min:1', 'applicants.*.first_name' => 'required|string|max:255', 'applicants.*.last_name' => 'required|string|max:255', 'applicants.*.passport_number' => 'required|string|max:255', 'applicants.*.passport_expiry' => 'required|date', 'applicants.*.nationality' => 'required|string|max:255', 'applicants.*.date_of_birth' => 'required|date', 'applicants.*.gender' => 'required|in:male,female,other', 'insurance_plan_id' => 'nullable|exists:insurance_plans,id', 'documents' => 'nullable|array', 'documents.*' => 'file|mimes:pdf,jpg,png|max:2048', ]); // Calculate total amount $processingType = VisaProcessingType::find($validated['visa_processing_type_id']); $insurancePlan = isset($validated['insurance_plan_id']) ? InsurancePlan::find($validated['insurance_plan_id']) : null; $totalAmount = $processingType->price; if ($insurancePlan) { $totalAmount += $insurancePlan->price_per_person * count($validated['applicants']); } // Create visa application $application = VisaApplication::create([ 'user_id' => Auth::id(), 'visa_type_id' => $validated['visa_type_id'], 'visa_processing_type_id' => $validated['visa_processing_type_id'], 'insurance_plan_id' => $validated['insurance_plan_id'] ?? null, 'expected_travel_date' => $validated['expected_travel_date'], 'total_amount' => $totalAmount, 'status' => 'pending', 'payment_status' => 'pending', ]); // Add applicants foreach ($validated['applicants'] as $index => $applicantData) { VisaApplicant::create([ 'visa_application_id' => $application->id, 'first_name' => $applicantData['first_name'], 'last_name' => $applicantData['last_name'], 'passport_number' => $applicantData['passport_number'], 'passport_expiry' => $applicantData['passport_expiry'], 'nationality' => $applicantData['nationality'], 'date_of_birth' => $applicantData['date_of_birth'], 'gender' => $applicantData['gender'], 'is_main_applicant' => $index === 0, ]); } // Upload documents if (isset($validated['documents'])) { foreach ($validated['documents'] as $document) { $path = $document->store('visa-documents/' . $application->id, 'public'); VisaDocument::create([ 'visa_application_id' => $application->id, 'document_type' => $document->getClientOriginalName(), 'file_path' => $path, ]); } } // Create insurance policy if plan selected if ($insurancePlan) { InsurancePolicy::create([ 'visa_application_id' => $application->id, 'insurance_plan_id' => $insurancePlan->id, 'policy_number' => 'POL-' . strtoupper(uniqid()), 'start_date' => now(), 'end_date' => now()->addDays($insurancePlan->duration_days), 'coverage_details' => $insurancePlan->coverage_details, 'status' => 'pending', ]); } return redirect()->route('visa.payment', $application) ->with('success', 'Visa application submitted successfully. Please proceed to payment.'); } public function show(VisaApplication $application) { $this->authorize('view', $application); $application->load([ 'visaType', 'processingType', 'insurancePlan', 'applicants', 'documents', 'payment', ]); return view('visa.applications.show', compact('application')); } public function payment(VisaApplication $application) { $this->authorize('view', $application); if ($application->payment_status === 'paid') { return redirect()->route('visa.applications.show', $application) ->with('info', 'Payment already completed for this application.'); } return view('visa.applications.payment', compact('application')); } public function processPayment(Request $request, VisaApplication $application) { $this->authorize('update', $application); // In a real application, integrate with payment gateway here $payment = Payment::create([ 'visa_application_id' => $application->id, 'amount' => $application->total_amount, 'payment_method' => $request->input('payment_method', 'credit_card'), 'transaction_id' => 'TXN-' . strtoupper(uniqid()), 'status' => 'completed', 'payment_date' => now(), ]); $application->update(['payment_status' => 'paid']); // Update insurance policy status if exists if ($application->insurancePlan) { InsurancePolicy::where('visa_application_id', $application->id) ->update(['status' => 'active']); } return redirect()->route('visa.applications.show', $application) ->with('success', 'Payment processed successfully. Your application is now under review.'); } public function printVisa(VisaApplication $application) { $this->authorize('view', $application); if ($application->status !== 'approved') { return back()->with('error', 'Visa not yet approved for printing.'); } $application->load(['visaType', 'processingType', 'applicants']); return view('visa.applications.print', compact('application')); } public function printInsurance(VisaApplication $application) { $this->authorize('view', $application); if (!$application->insurancePlan || $application->payment_status !== 'paid') { return back()->with('error', 'Insurance policy not available for printing.'); } $policy = InsurancePolicy::where('visa_application_id', $application->id)->first(); $application->load(['applicants', 'insurancePlan.company']); return view('visa.applications.print-insurance', compact('application', 'policy')); } } latest() ->paginate(20); return view('admin.visa.applications.index', compact('applications')); } public function show(VisaApplication $application) { $application->load([ 'user', 'visaType', 'processingType', 'insurancePlan.company', 'applicants', 'documents', 'payment', ]); return view('admin.visa.applications.show', compact('application')); } public function updateStatus(Request $request, VisaApplication $application) { $validated = $request->validate([ 'status' => 'required|in:pending,processing,approved,rejected', 'notes' => 'nullable|string', ]); $application->update([ 'status' => $validated['status'], 'notes' => $validated['notes'] ?? $application->notes, ]); return back()->with('success', 'Application status updated successfully.'); } public function addComment(Request $request, VisaApplication $application) { $validated = $request->validate([ 'comment' => 'required|string', ]); $application->update([ 'notes' => $application->notes ? $application->notes . "\n\n" . $validated['comment'] : $validated['comment'], ]); return back()->with('success', 'Comment added successfully.'); } } with('insurancePlans') ->get(); return view('insurance.companies.index', compact('companies')); } public function show(InsuranceCompany $company) { $company->load(['insurancePlans' => function($query) { $query->active(); }]); return view('insurance.companies.show', compact('company')); } } group(function () { // Visa application routes Route::prefix('visa')->group(function () { Route::get('/applications', [VisaApplicationController::class, 'index'])->name('visa.applications.index'); Route::get('/applications/create', [VisaApplicationController::class, 'create'])->name('visa.applications.create'); Route::post('/applications', [VisaApplicationController::class, 'store'])->name('visa.applications.store'); Route::get('/applications/{application}', [VisaApplicationController::class, 'show'])->name('visa.applications.show'); Route::get('/applications/{application}/payment', [VisaApplicationController::class, 'payment'])->name('visa.payment'); Route::post('/applications/{application}/payment', [VisaApplicationController::class, 'processPayment'])->name('visa.process-payment'); Route::get('/applications/{application}/print', [VisaApplicationController::class, 'printVisa'])->name('visa.print'); Route::get('/applications/{application}/print-insurance', [VisaApplicationController::class, 'printInsurance'])->name('visa.print-insurance'); }); // Insurance companies Route::get('/insurance-companies', [InsuranceCompanyController::class, 'index'])->name('insurance.companies.index'); Route::get('/insurance-companies/{company}', [InsuranceCompanyController::class, 'show'])->name('insurance.companies.show'); }); // Admin routes Route::prefix('admin')->middleware(['auth', 'admin'])->group(function () { Route::prefix('visa')->group(function () { Route::get('/applications', [VisaApplicationAdminController::class, 'index'])->name('admin.visa.applications.index'); Route::get('/applications/{application}', [VisaApplicationAdminController::class, 'show'])->name('admin.visa.applications.show'); Route::put('/applications/{application}/status', [VisaApplicationAdminController::class, 'updateStatus'])->name('admin.visa.applications.update-status'); Route::post('/applications/{application}/comment', [VisaApplicationAdminController::class, 'addComment'])->name('admin.visa.applications.add-comment'); }); }); Route::get('/home', [App\Http\Controllers\HomeController::class, 'index'])->name('home'); with('visaTypes', VisaType::active()->get()); $view->with('insuranceCompanies', InsuranceCompany::active()->get()); }); // Custom blade directives Blade::if('admin', function () { return auth()->check() && auth()->user()->is_admin; }); } } check() || !auth()->user()->is_admin) { abort(403, 'Unauthorized action.'); } return $next($request); } } where('is_active', true); } }