1/12












CEMCDO App
Jan 2025 - Apr 2025Kimberly Baylon, Bridget Jose, Azlan Tomindug, Francheska Mei Besana
Django-powered information system for the City Economic Management and Cooperative Development Office of General Santos City — unified cooperative records and fund-utilization workflows.
DjangoPythonGovernmentHTMLCSSJavaScriptTailwind CSS
Common entry point: https://cemcdo-demo.onrender.com. After login, users land on role-specific dashboards.
- Cooperative Profiling: register cooperatives, manage profiles, and generate reports.
- Fund Utilization: administrative module for division budgets, transactions, and augmentation workflows.
- Single source of truth for cooperative records and financial utilization.
- Faster reporting via built-in exports and analytic charts.
- Controlled access through authenticated roles and per-division views.
- Admin Division: manages fund dashboards, master data, divisions, accounts, reports, and augmentation approvals.
- Division Officers/Staff: handle division accounts, obligation and augmentation requests, and transactions.
- Cooperative Accounts: manage their cooperative details through issued credentials.
- Register cooperatives via multi-step forms with optional fields like organization date, apex, cluster, and remarks.
- Create cooperative accounts with enforced password policy.
- View, edit, or delete cooperative profiles and export filtered lists to Excel.
- Generate summary reports with chart insights and Excel/PDF exports.
- Admin dashboard cards for total accounts, budgets, expenses, and pending augments with quarterly expense charts.
- Department analytics showing budget vs. expenses and exportable funds summaries.
- Division and account management with quarterly budget allocations.
- Obligation requests, payee registry, purchase requests, and augmentation workflows that validate source and target totals.
- Comprehensive transaction views and financial reports (yearly, quarterly, or custom range).
- Authentication gates all modules with role-based dashboards.
- Cooperative account creation enforces passwords ≥8 characters with uppercase, number, and symbol requirements.
- Backend: Django apps for cooperatives and funds providing REST-like views and export endpoints.
- Frontend: HTML, CSS, Tailwind CSS, and JavaScript with Chart.js visualizations.
- Database & Auth: Supabase PostgreSQL with managed authentication.
- Hosting: Render for web service and static/media assets.
Production deployment uses Render with environment variables for the Supabase database and Django configuration. Build steps include Tailwind compilation, collectstatic, migrations, and seeding master data.
- Log in at the site URL to reach the appropriate dashboard.
- Cooperative Profiling: register cooperatives, issue accounts, and export profiles.
- Fund Utilization: manage divisions and accounts, submit obligation or augmentation requests, and export reports.
- Fine-grained permissions and audit logging.
- Additional export formats and scheduled reports.
- Enhanced cooperative self-service portal.
Developed for the Cooperatives and Administrative divisions of CEMCDO, based on official user manuals for each module.