Procurement System Database Test
Testing procurement system with:
Host: localhost
Database: irtqnoel_procurement_system
Username: irtqnoel_proc_user
Password: **************
✅ Database connection successful!
1. Checking Procurement Tables...
✅ procurement_requests: 6 records - Main requests table
✅ procurement_request_items: 0 records - Request items table
✅ request_attachments: 0 records - File attachments table
✅ approval_queue: 6 records - Approval workflow queue
✅ approval_actions: 0 records - Approval actions history
✅ workflow_rules: 12 records - Approval workflow rules
✅ workflow_instances: 0 records - Active workflow instances
✅ procurement_categories: 5 records - Request categories
✅ users: 15 records - User accounts for approvers
2. Checking Procurement Categories...
✅ Found 5 active procurement categories:
• ID 1: Information Technology
• ID 2: Office Equipment
• ID 3: Professional Services
• ID 4: Maintenance & Repairs
• ID 5: Marketing & Advertising
3. Checking Approval Workflow Rules...
✅ Found 12 active workflow rules:
• Micro Purchases: ₦0 - ₦10,000
• Small Purchases: ₦10,001 - ₦50,000
• Medium Purchases: ₦50,001 - ₦200,000
• Large Purchases: ₦200,001 - ₦500,000
• Major Purchases: ₦500,001 - ₦2,000,000
• Capital Expenditure: ₦2,000,001 - No maximum
• Micro Purchases: ₦0 - ₦10,000
• Small Purchases: ₦10,001 - ₦50,000
• Medium Purchases: ₦50,001 - ₦200,000
• Large Purchases: ₦200,001 - ₦500,000
• Major Purchases: ₦500,001 - ₦2,000,000
• Capital Expenditure: ₦2,000,001 - No maximum
4. Checking Approval Users...
✅ admin role: 4 users
• ID 2: Managing Director
• ID 3: Procurement Manager
• ID 4: Finance Manager
• ID 42: System Administrator
✅ md role: 1 users
• ID 203: Test Managing Director
✅ procurement role: 2 users
• ID 102: Procurement Officer
• ID 202: Test Procurement Officer
✅ finance role: 2 users
• ID 101: Finance Manager
• ID 201: Test Finance Manager
✅ hod role: 2 users
• ID 100: Department Head
• ID 200: Test Department Head
5. Testing Request Number Generation...
✅ Next request number would be: REQ-2025-0001
6. Testing Sample Procurement Request...
✅ Test request inserted successfully (ID: 76)
✅ Test item inserted successfully
✅ Test data cleaned up
7. Testing API Endpoint...
⚠️ API categories endpoint not accessible
Make sure API files are uploaded to /api/ directory
8. Testing Upload Directories...
✅ Directory 'uploads' exists
✅ Directory is writable
✅ Directory 'uploads/requests' exists
✅ Directory is writable
Test Summary
✅ Working Components:
- Database connection successful
- Core procurement tables exist
- Request numbering system working
- Sample data insertion/deletion working
⚠️ Potential Issues to Check:
- Ensure you have active workflow rules
- Verify users exist with approval roles (md, finance, procurement, hod)
- Create upload directories if missing
- Test the procurement request form
🚀 Next Steps:
1. Upload procurement request form to website
2. Upload API files to /api/ directory
3. Create upload directory structure
4. Test submitting a procurement request
5. Check approval workflow functionality
📂 Required File Structure:
- procurement_request.php (main form)
- api/endpoints/procurement-request.php (API handler)
- api/index.php (updated with procurement endpoint)
- uploads/requests/ (directory for file uploads)
Ready to test procurement requests!
Go to Procurement Request Form
Run Simple Database Test
Test Vendor Registration