- Project: A header record with name, description, start/end dates, status, and totals for materials/tasks.
- Components: Sub-sections of a project (e.g., phases), with name, quantity, dates, and linked materials/tasks.
- Materials: Items under components, with quantity, cost, unit, and transaction links.
- Tasks: Activities under components, with name, assigned_to, due_date, speed/rate calculations, and totals.
- Status ID: Integer for states (e.g., 1 = Pending, 2 = Active, 3 = Cancelled, 4 = Template).
- Order ID: Sequencing field for components/materials/tasks (used in move up/down).
- Total Hours/Materials/Tasks: Aggregated calculations for project/component summaries.
- Schedule Project: Stored procedure (spScheduleProject) to assign dates based on include_days_id (e.g., every day, weekends).
- Copy Component: Function to duplicate components within a project.
- Filter Materials: Checkbox to show only filtered materials (param filter_id in qryProjectMaterials).
- PgDAC: Database components for queries like qryProjectHeader.
- DevExpress Grid (TcxGridDBTableView): For displaying/editing projects, components, materials, tasks.
Glossary
< 1 min read