Full-Stack Web Application (REST Architecture)Status: Live REST API on Render / Client in Repository

DTR ni Latch

Daily Time Record and attendance tracking application for work and internship/OJT hour tracking.

Source Code (GitHub)Visit Project Website

Interactive Web Application Preview

Live iframe preview directly rendering https://dtrnilatch.vercel.app/ with instant controls

dtrnilatch.vercel.app/

80%

Connecting to live application...Rendering deployment directly from https://dtrnilatch.vercel.app/

Live Deployment: dtrnilatch.vercel.app/(80% scale)Open in new tab

System Overview

A full-featured attendance management and audit platform engineered to track rendered hours, calculate deductions accurately, project completion milestones, and export standardized documentation for internship and professional compliance.

Note: The application is deployed on Vercel at https://dtrnilatch.vercel.app/

Architecture & Data Flow

Vanilla ES6+ Modular Frontend → Express REST API → MongoDB Atlas Database Cluster

Technologies & Tools Applied

HTML5CSS3JavaScript (ES6 Modules)Node.jsExpressMongooseMongoDB AtlasJWTbcryptjs

Functional Requirements & Key Features

✓Precise time-in/time-out logging with automatic duration computation

✓Automated overtime and undertime classification

✓Built-in Philippine official holiday detection and custom adjustments

✓Automatic mandatory lunch-break deduction algorithms

✓Target completion date projection based on remaining rendered hours

✓Bulk attendance data import supporting CSV and TXT files

✓Form-accurate printable DTR document output for formal compliance submission

✓One-click CSV exports for payroll and audit ingestion

✓Role-based access control (RBAC) separating regular personnel and administrative reviewers

✓Comprehensive record auditing logs for manual time adjustments

Engineering Decisions & Technical Highlights

›

Designed modular RESTful endpoints handling JWT authentication, bcrypt password hashing, and rate limiting.

›

Implemented business rules for Philippine labor calendar adjustments and non-working holiday calculations.

›

Constructed MongoDB aggregation pipelines for instant computation of total rendered hours, undertime, and overtime.

›

Standardized print stylesheets for exact physical layout reproduction conforming to standard government/corporate DTR forms.

Back to all projects

GitHub Repository Launch Project Website