========================================
  HSE MANAGEMENT SYSTEM - FULL TEST
========================================

1. Testing Database Connection...
   ✓ Database connection successful

2. Checking Database Tables...
   ✓ Table 'users' exists
   ✓ Table 'companies' exists
   ✓ Table 'departments' exists
   ✗ Table 'employees' is missing
   ✓ Table 'roles' exists
   ✓ Table 'permissions' exists
   ✓ Table 'incidents' exists
   ✓ Table 'incident_investigations' exists
   ✓ Table 'root_cause_analyses' exists
   ✓ Table 'capas' exists
   ✓ Table 'hazards' exists
   ✓ Table 'risk_assessments' exists
   ✓ Table 'jsas' exists
   ✓ Table 'control_measures' exists
   ✓ Table 'risk_reviews' exists
   ✓ Table 'toolbox_talks' exists
   ✓ Table 'toolbox_talk_topics' exists
   ✓ Table 'toolbox_talk_attendances' exists
   ✓ Table 'safety_communications' exists
   ✓ Table 'training_plans' exists
   ✓ Table 'training_sessions' exists
   ✓ Table 'training_records' exists
   ✗ Table 'ppe_items' is missing
   ✗ Table 'ppe_issuances' is missing
   ✗ Table 'ppe_inspections' is missing
   ✗ Table 'ppe_suppliers' is missing
   ✓ Table 'work_permits' exists
   ✓ Table 'work_permit_types' exists
   ✓ Table 'work_permit_approvals' exists
   ✓ Table 'gca_logs' exists
   ✓ Table 'inspections' exists
   ✓ Table 'inspection_schedules' exists
   ✓ Table 'inspection_checklists' exists
   ✓ Table 'non_conformance_reports' exists
   ✓ Table 'audits' exists
   ✓ Table 'audit_findings' exists
   ✓ Table 'emergency_contacts' exists
   ✓ Table 'emergency_equipment' exists
   ✓ Table 'emergency_response_teams' exists
   ✓ Table 'evacuation_plans' exists
   ✓ Table 'fire_drills' exists
   ✓ Table 'waste_management_records' exists
   ✓ Table 'waste_tracking_records' exists
   ✓ Table 'emission_monitoring_records' exists
   ✓ Table 'spill_incidents' exists
   ✓ Table 'resource_usage_records' exists
   ✗ Table 'iso14001_compliance_records' is missing
   ✓ Table 'health_surveillance_records' exists
   ✓ Table 'first_aid_logbook_entries' exists
   ✓ Table 'ergonomic_assessments' exists
   ✓ Table 'workplace_hygiene_inspections' exists
   ✗ Table 'health_campaigns' is missing
   ✗ Table 'sick_leave_records' is missing
   ✗ Table 'procurement_requests' is missing
   ✗ Table 'suppliers' is missing
   ✗ Table 'equipment_certifications' is missing
   ✗ Table 'stock_consumption_reports' is missing
   ✗ Table 'safety_material_gap_analyses' is missing
   ✗ Table 'hse_documents' is missing
   ✗ Table 'document_versions' is missing
   ✗ Table 'document_templates' is missing
   ✗ Table 'compliance_requirements' is missing
   ✗ Table 'permits_licenses' is missing
   ✗ Table 'compliance_audits' is missing
   ✗ Table 'housekeeping_inspections' is missing
   ✗ Table 'five_s_audits' is missing
   ✗ Table 'waste_sustainability_records' is missing
   ✗ Table 'carbon_footprint_records' is missing
   ✗ Table 'notification_rules' is missing
   ✗ Table 'escalation_matrices' is missing
   ✗ Table 'biometric_devices' is missing
   ✗ Table 'daily_attendance' is missing
   ✓ Table 'activity_logs' exists
   ✓ Table 'user_sessions' exists
   ⚠ Missing 27 table(s)

3. Checking Models...
   ✓ Model 'ActivityLog' exists
   ✓ Model 'Audit' exists
   ✓ Model 'AuditFinding' exists
   ✓ Model 'BiometricDevice' exists
   ✓ Model 'CAPA' exists
   ✓ Model 'CarbonFootprintRecord' exists
   ✓ Model 'Company' exists
   ✓ Model 'CompanyKPI' exists
   ✓ Model 'CompetencyAssessment' exists
   ✓ Model 'ComplianceAudit' exists
   ✓ Model 'ComplianceRequirement' exists
   ✓ Model 'ControlMeasure' exists
   ✓ Model 'DailyAttendance' exists
   ✓ Model 'Department' exists
   ✓ Model 'DocumentTemplate' exists
   ✓ Model 'DocumentVersion' exists
   ✓ Model 'EmergencyContact' exists
   ✓ Model 'EmergencyEquipment' exists
   ✓ Model 'EmergencyResponseTeam' exists
   ✓ Model 'EmissionMonitoringRecord' exists
   ✓ Model 'Employee' exists
   ✓ Model 'EmployeeKPI' exists
   ✓ Model 'EquipmentCertification' exists
   ✓ Model 'ErgonomicAssessment' exists
   ✓ Model 'EscalationMatrix' exists
   ✓ Model 'EvacuationPlan' exists
   ✓ Model 'FireDrill' exists
   ✓ Model 'FirstAidLogbookEntry' exists
   ✓ Model 'FiveSAudit' exists
   ✓ Model 'GCALog' exists
   ✓ Model 'HSEDocument' exists
   ✓ Model 'Hazard' exists
   ✓ Model 'HealthCampaign' exists
   ✓ Model 'HealthSurveillanceRecord' exists
   ✓ Model 'HousekeepingInspection' exists
   ✓ Model 'ISO14001ComplianceRecord' exists
   ✓ Model 'Incident' exists
   ✓ Model 'IncidentAttachment' exists
   ✓ Model 'IncidentInvestigation' exists
   ✓ Model 'Inspection' exists
   ✓ Model 'InspectionChecklist' exists
   ✓ Model 'InspectionSchedule' exists
   ✓ Model 'JSA' exists
   ✓ Model 'JobCompetencyMatrix' exists
   ✓ Model 'NonConformanceReport' exists
   ✓ Model 'NotificationRule' exists
   ✓ Model 'PPEComplianceReport' exists
   ✓ Model 'PPEInspection' exists
   ✓ Model 'PPEIssuance' exists
   ✓ Model 'PPEItem' exists
   ✓ Model 'PPESupplier' exists
   ✓ Model 'Permission' exists
   ✓ Model 'PermitLicense' exists
   ✓ Model 'ProcurementRequest' exists
   ✓ Model 'ResourceUsageRecord' exists
   ✓ Model 'RiskAssessment' exists
   ✓ Model 'RiskReview' exists
   ✓ Model 'Role' exists
   ✓ Model 'RootCauseAnalysis' exists
   ✓ Model 'SafetyCommunication' exists
   ✓ Model 'SafetyMaterialGapAnalysis' exists
   ✓ Model 'SickLeaveRecord' exists
   ✓ Model 'SpillIncident' exists
   ✓ Model 'StockConsumptionReport' exists
   ✓ Model 'Supplier' exists
   ✓ Model 'SystemKPI' exists
   ✓ Model 'ToolboxTalk' exists
   ✓ Model 'ToolboxTalkAttendance' exists
   ✓ Model 'ToolboxTalkFeedback' exists
   ✓ Model 'ToolboxTalkTemplate' exists
   ✓ Model 'ToolboxTalkTopic' exists
   ✓ Model 'TrainingAttendance' exists
   ✓ Model 'TrainingCertificate' exists
   ✓ Model 'TrainingEffectivenessEvaluation' exists
   ✓ Model 'TrainingMaterial' exists
   ✓ Model 'TrainingNeedsAnalysis' exists
   ✓ Model 'TrainingPlan' exists
   ✓ Model 'TrainingRecord' exists
   ✓ Model 'TrainingSession' exists
   ✓ Model 'User' exists
   ✓ Model 'UserKPI' exists
   ✓ Model 'UserSession' exists
   ✓ Model 'WasteManagementRecord' exists
   ✓ Model 'WasteSustainabilityRecord' exists
   ✓ Model 'WasteTrackingRecord' exists
   ✓ Model 'WorkPermit' exists
   ✓ Model 'WorkPermitApproval' exists
   ✓ Model 'WorkPermitType' exists
   ✓ Model 'WorkplaceHygieneInspection' exists
   ✓ Found 89 model(s)

4. Checking Controllers...
   ✓ Controller 'ActivityLogController' exists
   ✓ Controller 'AdminController' exists
   ✓ Controller 'AuditController' exists
   ✓ Controller 'AuditFindingController' exists
   ✓ Controller 'BiometricDeviceController' exists
   ✓ Controller 'CAPAController' exists
   ✓ Controller 'CarbonFootprintRecordController' exists
   ✓ Controller 'CompanyController' exists
   ✓ Controller 'ComplianceAuditController' exists
   ✓ Controller 'ComplianceDashboardController' exists
   ✓ Controller 'ComplianceRequirementController' exists
   ✓ Controller 'ControlMeasureController' exists
   ✓ Controller 'DailyAttendanceController' exists
   ✓ Controller 'DashboardController' exists
   ✓ Controller 'DepartmentController' exists
   ✓ Controller 'DocumentManagementDashboardController' exists
   ✓ Controller 'DocumentTemplateController' exists
   ✓ Controller 'DocumentVersionController' exists
   ✓ Controller 'EmailShareController' exists
   ✓ Controller 'EmergencyContactController' exists
   ✓ Controller 'EmergencyEquipmentController' exists
   ✓ Controller 'EmergencyPreparednessDashboardController' exists
   ✓ Controller 'EmergencyResponseTeamController' exists
   ✓ Controller 'EmissionMonitoringRecordController' exists
   ✓ Controller 'EmployeeController' exists
   ✓ Controller 'EnvironmentalDashboardController' exists
   ✓ Controller 'EquipmentCertificationController' exists
   ✓ Controller 'ErgonomicAssessmentController' exists
   ✓ Controller 'EscalationMatrixController' exists
   ✓ Controller 'EvacuationPlanController' exists
   ✓ Controller 'FireDrillController' exists
   ✓ Controller 'FirstAidLogbookEntryController' exists
   ✓ Controller 'FiveSAuditController' exists
   ✓ Controller 'GCALogController' exists
   ✓ Controller 'HSEDocumentController' exists
   ✓ Controller 'HazardController' exists
   ✓ Controller 'HealthCampaignController' exists
   ✓ Controller 'HealthSurveillanceRecordController' exists
   ✓ Controller 'HealthWellnessDashboardController' exists
   ✓ Controller 'HousekeepingDashboardController' exists
   ✓ Controller 'HousekeepingInspectionController' exists
   ✓ Controller 'ISO14001ComplianceRecordController' exists
   ✓ Controller 'IncidentAttachmentController' exists
   ✓ Controller 'IncidentController' exists
   ✓ Controller 'IncidentInvestigationController' exists
   ✓ Controller 'IncidentReportController' exists
   ✓ Controller 'InspectionChecklistController' exists
   ✓ Controller 'InspectionController' exists
   ✓ Controller 'InspectionDashboardController' exists
   ✓ Controller 'InspectionScheduleController' exists
   ✓ Controller 'JSAController' exists
   ✓ Controller 'LandingPageController' exists
   ✓ Controller 'ManpowerReportController' exists
   ✓ Controller 'NonConformanceReportController' exists
   ✓ Controller 'NotificationRuleController' exists
   ✓ Controller 'PPEComplianceReportController' exists
   ✓ Controller 'PPEController' exists
   ✓ Controller 'PPEInspectionController' exists
   ✓ Controller 'PPEIssuanceController' exists
   ✓ Controller 'PPEItemController' exists
   ✓ Controller 'PPESupplierController' exists
   ✓ Controller 'PermitLicenseController' exists
   ✓ Controller 'ProcurementDashboardController' exists
   ✓ Controller 'ProcurementRequestController' exists
   ✓ Controller 'ProfileController' exists
   ✓ Controller 'QRCodeController' exists
   ✓ Controller 'RecentItemsController' exists
   ✓ Controller 'ResourceUsageRecordController' exists
   ✓ Controller 'RiskAssessmentController' exists
   ✓ Controller 'RiskAssessmentDashboardController' exists
   ✓ Controller 'RiskAssessmentReportController' exists
   ✓ Controller 'RiskReviewController' exists
   ✓ Controller 'RoleController' exists
   ✓ Controller 'RootCauseAnalysisController' exists
   ✓ Controller 'SafetyCommunicationController' exists
   ✓ Controller 'SafetyCommunicationReportController' exists
   ✓ Controller 'SafetyMaterialGapAnalysisController' exists
   ✓ Controller 'SearchController' exists
   ✓ Controller 'SettingsController' exists
   ✓ Controller 'SickLeaveRecordController' exists
   ✓ Controller 'SpillIncidentController' exists
   ✓ Controller 'StockConsumptionReportController' exists
   ✓ Controller 'SupplierController' exists
   ✓ Controller 'ToolboxTalkController' exists
   ✓ Controller 'ToolboxTalkReportController' exists
   ✓ Controller 'ToolboxTalkTemplateController' exists
   ✓ Controller 'ToolboxTalkTopicController' exists
   ✓ Controller 'TrainingCertificateController' exists
   ✓ Controller 'TrainingDashboardController' exists
   ✓ Controller 'TrainingNeedsAnalysisController' exists
   ✓ Controller 'TrainingPlanController' exists
   ✓ Controller 'TrainingReportingController' exists
   ✓ Controller 'TrainingSessionController' exists
   ✓ Controller 'UserController' exists
   ✓ Controller 'WasteManagementRecordController' exists
   ✓ Controller 'WasteSustainabilityDashboardController' exists
   ✓ Controller 'WasteSustainabilityRecordController' exists
   ✓ Controller 'WasteTrackingRecordController' exists
   ✓ Controller 'WorkPermitController' exists
   ✓ Controller 'WorkPermitDashboardController' exists
   ✓ Controller 'WorkPermitTypeController' exists
   ✓ Controller 'WorkplaceHygieneInspectionController' exists
   ✓ Found 102 controller(s)

5. Checking Routes...
   ✓ Found 713 route(s)
   ✓ Route 'dashboard' exists
   ✓ Route 'login' exists
   ✓ Route 'register' exists
   ✓ Route 'incidents.index' exists
   ✓ Route 'toolbox-talks.index' exists
   ✓ Route 'risk-assessment.risk-assessments.index' exists
   ✓ Route 'training.training-plans.index' exists
   ✓ Route 'ppe.items.index' exists
   ✓ Route 'work-permits.index' exists
   ✓ Route 'inspections.index' exists
   ✓ Route 'inspections.audits.index' exists
   ✓ Route 'compliance.dashboard' exists
   ✓ Route 'housekeeping.dashboard' exists
   ✓ Route 'biometric-devices.index' exists
   ✓ Route 'settings.index' exists
   ✓ All key routes exist

6. Checking Migrations...
   ✓ Found 115 migration file(s)
   ✓ 75 migration(s) have been run

7. Checking Services...
   ✓ Service 'BiometricDeviceManager' exists
   ✓ Service 'CertificateExpiryAlertService' exists
   ✓ Service 'CompanyGroupService' exists
   ✓ Service 'EnhancedZKTecoService' exists
   ✓ Service 'KPICalculationService' exists
   ✓ Service 'MultiDeviceZKTecoService' exists
   ✓ Service 'NetworkConnectionService' exists
   ✓ Service 'PPEAlertService' exists
   ✓ Service 'QRCodeService' exists
   ✓ Service 'TNAEngineService' exists
   ✓ Service 'ZKTecoService' exists
   ✓ Service 'ZKTecoTCPProtocol' exists
   ✓ Found 12 service(s)

8. Checking Views...
   ✓ Found 50 view file(s)

9. Checking Configuration...
   ✓ Config 'app' loaded
   ✓ Config 'database' loaded
   ✓ Config 'mail' loaded
   ✓ Config 'cache' loaded
   ✓ Config 'queue' loaded
   ✓ Config 'filesystems' loaded

10. Checking Storage Directories...
   ✓ Storage 'app/public' is writable
   ✓ Storage 'framework/cache' is writable
   ✓ Storage 'framework/sessions' is writable
   ✓ Storage 'framework/views' is writable
   ✓ Storage 'logs' is writable

========================================
  TEST SUMMARY
========================================
✓ Passed: 280
⚠ Warnings: 0
✗ Errors: 27

ERRORS:
  ✗ Missing table: employees
  ✗ Missing table: ppe_items
  ✗ Missing table: ppe_issuances
  ✗ Missing table: ppe_inspections
  ✗ Missing table: ppe_suppliers
  ✗ Missing table: iso14001_compliance_records
  ✗ Missing table: health_campaigns
  ✗ Missing table: sick_leave_records
  ✗ Missing table: procurement_requests
  ✗ Missing table: suppliers
  ✗ Missing table: equipment_certifications
  ✗ Missing table: stock_consumption_reports
  ✗ Missing table: safety_material_gap_analyses
  ✗ Missing table: hse_documents
  ✗ Missing table: document_versions
  ✗ Missing table: document_templates
  ✗ Missing table: compliance_requirements
  ✗ Missing table: permits_licenses
  ✗ Missing table: compliance_audits
  ✗ Missing table: housekeeping_inspections
  ✗ Missing table: five_s_audits
  ✗ Missing table: waste_sustainability_records
  ✗ Missing table: carbon_footprint_records
  ✗ Missing table: notification_rules
  ✗ Missing table: escalation_matrices
  ✗ Missing table: biometric_devices
  ✗ Missing table: daily_attendance