Integrated Web Database with Customer Portal

Замовник: AI | Опубліковано: 22.02.2026
Бюджет: 750 $

Job Title: Development of a Web Database with Customer Portal, Transporter Mobile Interface, Barcode/QR Code Integration, and Admin Backend Project Description: I am looking for an experienced freelancer to develop a web-based database solution with mobile access, a customer portal, transporter interface, and an administrative backend. The system will be used to manage customers, contracts, and deliveries, including document uploads, status tracking, and automatic generation of delivery note numbers and QR or barcodes. The solution must be accessible via web browser and mobile devices. Scope of Work 1. Database Structure At least three main tables are required: Table 1: Customers Fields: Company name Contact person 1 Contact person 2 Phone number Email Unique Customer ID Table 2: Contracts Fields: Customer ID Customer name Articles (multiple possible) Status (Active / Inactive) Cost per article Upload function for: Contract (PDF) NDA (PDF) Table 3: Deliveries Fields: Customer ID Customer delivery note number Date Delivered quantity per article Delivery status: In transport In processing Completed Return transport Automatically generated delivery note number (our internal number) Format: CustomerID + RecordID Example: K10023-00015 Additional functions: Automatic generation of a unique QR code or barcode per delivery Upload function for: Customer documents Internal documents Automatic price calculation based on contract data if contract is active Payment status: Invoice issued Open Paid Complaint status: Open In progress Completed and validated Frontends / User Roles Three user interfaces are required: 1. Customer Portal Access: Web browser and mobile devices Login: Email Password Two-factor authentication (Authenticator App) Functions: Table view similar to Excel showing: Customer delivery note number Our delivery note number Date Status Total cost Download links for documents Upload function for documents Filters: Date Delivery note number Status Important: Customers must only be able to view their own data. 2. Transporter / Operator Interface Mobile-optimized interface Functions: Create new delivery: Input: Select customer Enter customer delivery note number Upload scanned delivery note (photo or PDF) Automatically generated: Our internal delivery note number QR code or barcode Additional functions: Change delivery status Print barcode on label printer 3. Administrator Interface Functions: Create and manage customers Create and manage contracts Full delivery management Export data to CSV for invoicing Filters: Customer Payment status Date range Security Important: Role-based access system: Administrator Customer Transporter Strict access separation required. Login with: Email Password Two-factor authentication (Authenticator App) Technical Requirements Open technology choice, preferred: Backend: PostgreSQL or MySQL Frontend: Web application Mobile optimized or Progressive Web App Cloud hosting possible. Barcode and QR code integration required. Deliverables Fully functional system including: Database Frontend Backend Deployment and setup Optional Please also provide: Hosting recommendation Maintenance costs Budget Please provide: Fixed price or hourly rate Application Please include: References Example projects Proposed technology stack Timeline Price Project start: Immediately possible I look forward to your proposals.