Department of Agrarian Reform – Land Transfer Clearance and Monitoring System
DAR-LTCMS is a web-based administrative platform for the Department of Agrarian Reform Negros Oriental Provincial Office. It supports land transfer clearance processing, clearance form generation, application monitoring, role-based access, document review, reporting, and audit tracking.
DAR-LTCMS was developed as a thesis/capstone system for managing land transfer clearance-related records and workflows within the DAR Negros Oriental Provincial Office.
The system centralizes the following office records and activities:
DAR-LTCMS provides a structured platform for staff-assisted clearance processing. Approval or release of an application records the final clearance decision, generates the appropriate output, preserves the decision trail, and supports office monitoring and reporting.
Actual legal and administrative procedures remain governed by the authorized DAR process and applicable documentary requirements.
| Module | Description |
|---|---|
| Dashboard | Role-based overview of records, applications, and monitoring data |
| Landowner Management | Create and maintain landowner profiles and linked user accounts |
| Parcel Records | Store parcel details, title/tax declaration references, classification, area, and map geometry |
| Landholding Records | Connect landowners to parcel-based landholding records |
| Source Packages | Store documentary/reference source records for review and traceability |
| Clearance Applications | Encode, review, endorse, approve/release, deny, and monitor applications |
| Supporting Documents | Upload, view, and review application-related files |
| LTC Form Outputs | Generate printable/PDF outputs for required LTC forms |
| Map Viewer | Review parcel/map-based information using Leaflet |
| Notifications | Notify authorized users about important application events |
| Monitoring Reports | View office-level reports and clearance processing summaries |
| Audit Logs | Track important actions with actor, timestamp, and record context |
DAR Staff are the primary system operators. They can:
Landowner users have controlled self-service access. They can:
Geodetic users have limited review access. They can:
The current clearance workflow follows office-style processing stages:
Pending Review by Legal Officer
↓
Endorsed to LTI Division
↓
Endorsed to Chief Legal
↓
Endorsed to PARPO II
↓
For Releasing
↓
Released
Applications may also reach a final denied outcome when the review decision requires it.
Final decision states lock the record for preservation. Viewing, reporting, printing, and archival actions remain available to authorized users.
Recommended record creation order:
Landowner Record
↓
Parcel Record
↓
Landholding Record
↓
Land Transfer Clearance Application
A landholding is based on parcel information, so parcel records should be encoded before creating landholding records.
DAR-LTCMS currently supports application-related LTC outputs such as:
PDF and print views use a formal office style suitable for review, filing, and release.
The system follows these integrity principles:
| Layer | Technology |
|---|---|
| Backend | Laravel 12 |
| Language | PHP 8.4 |
| Database | PostgreSQL |
| Authentication | Laravel Breeze |
| Frontend | Blade, Vite, Tailwind CSS |
| Mapping | Leaflet |
| Local PHP Runtime | Laravel Herd / PHP local environment |
| Package Managers | Composer, npm |
git clone <repository-url>
cd <project-folder>
composer install
npm install
cp .env.example .env
php artisan key:generate
The current local PostgreSQL database name is:
DB_DATABASE=dar_iland
Recommended .env database settings:
DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5432
DB_DATABASE=dar_iland
DB_USERNAME=postgres
DB_PASSWORD=your_password
Run migrations:
php artisan migrate
Run seeders when using prepared development data:
php artisan db:seed
For a fresh reset with seed data:
php artisan migrate:fresh --seed
Start the Laravel development server:
php artisan serve
Start the Vite development server:
npm run dev
Build frontend assets:
npm run build
Clear Laravel caches:
php artisan optimize:clear
Create the storage link:
php artisan storage:link
Run tests:
php artisan test
Before beta deployment, test the following flows:
After an application reaches a final decision state, confirm that:
Recommended production-style settings:
APP_NAME="DAR-LTCMS"
APP_ENV=production
APP_DEBUG=false
DB_CONNECTION=pgsql
DB_DATABASE=dar_iland
Before deployment/build:
composer install --no-dev --optimize-autoloader
npm install
npm run build
php artisan migrate --force
php artisan storage:link
php artisan config:cache
php artisan route:cache
php artisan view:cache
For local beta testing, APP_DEBUG=true may be used to make errors easier to inspect.
Export local database:
pg_dump -U postgres -h 127.0.0.1 -p 5432 -d dar_iland --no-owner --no-privileges -f dar_iland_full_export.sql
Create database before restore:
createdb -U postgres dar_iland
Restore export:
psql -U postgres -d dar_iland -f dar_iland_full_export.sql
The active system name is DAR-LTCMS.
Older repository, folder, branch, or database labels may still appear during transition. Current application-facing text should use DAR-LTCMS.
Recommended main branches:
| Branch | Purpose |
|---|---|
main |
Stable project state |
beta-deployment |
Final beta testing and deployment preparation |
dar-flow-revision |
Previous workflow revision work |
Check current branch and changes:
git branch
git status
Stage all project changes:
git add -A
Remove local environment file from staging when needed:
git restore --staged .env
Commit changes:
git commit -m "Update DAR-LTCMS README"
Push current branch:
git push
This project was created for academic thesis/capstone purposes and is intended for DAR Negros Oriental Provincial Office workflow evaluation, beta testing, and system demonstration.