Document Control System Development

Objective: Create a document control system to track incoming and outgoing drawings for each job and manage the multi-stage approval process. Database Structure: Store key information such as job number, drawing number, customer, project description, drawing date, and order number. Include tables for drawing updates and email tracking. Drawing Management: Implement a system to store and manage drawing files, linking them to their respective jobs in the database. Track versions and updates of each drawing along with their dates. Email Integration: Use a third-party email service (like SendGrid or Mailgun) to send notifications and track email communications. Log all email interactions in the database for reference. Approval Process: Set up a multi-stage approval workflow where drawings are reviewed and approved at various stages. Include tracking for approval dates and comments from approvers. User Interface: Develop an easy-to-use interface for users to upload drawings, view statuses, and manage approvals. Reporting: Create reporting features to view drawing statuses, approval timelines, and email communications related to each job. Include roles for admin and general users, with admins having full access and users having restricted access based on their roles. Implement basic security measures, including password protection and basic encryption for stored data. The system should be web-based, accessible via standard web browsers. Develop the system using Python and Django for backend development. The reporting features should include detailed reports of drawing statuses, approval timelines, and email communications related to each job. The document control system will operate independently without integration with other systems. Include a dashboard for an overview and notifications for critical updates. The interface will be built using existing templates for quicker development. The dashboard should display drawing statuses. Include basic reports showing summary information about drawing statuses, approval timelines, and email communications.

Project ID: 38746176