ZDS KALIPI-RIC Women Federation, Inc.
Women's Profiling System β CY 2026
A modern, responsive, full-stack web application for profiling, managing, and analyzing member records of the Zamboanga del Sur KALIPI-RIC Women Federation, Inc. Built according to official government profiling form standards (CY 2026).
π Key Features
- π¨ Modern Glassmorphic Design & Palette: Inspired by the official federation logo featuring Royal Purple, Gold, and Orchid accents with smooth dark/light mode toggle.
- π΄ Dual Interactive View Modes:
- Cards Grid View: Elevated 3D cards with micro-animations, position badges (Leader, Officer, Member), civil status pills, and hover quick-action overlays.
- Data Table View: Replicates the official Excel spreadsheet template columns (
No.,Name of Woman,Age,Civil Status,Occupation,Position,Contact Number,Remarks,Actions).
- π Real-Time Search & Multi-Filters: Instant query matching by name, position, occupation, remarks, and contact number. Filter by Civil Status and Association Position.
- π KPI Dashboard Analytics: Live dynamic statistics tracking Total Profiled Members, Officers, Solo Parents Advocates, and Average Age.
- β‘ Full CRUD Operations: Create, read detailed profile sheets, update, and delete woman records seamlessly.
- πΎ Live MySQL Database + Offline Fallback: Synchronizes via PHP REST API (
api.php) directly to MySQL (zds_kalipi_db) with automatic browserlocalStoragefallback. - π Export & Official Printing:
- Export dataset to CSV (Excel compatible) or JSON.
- Formal print module styled directly after official form layouts with signature sections.
π File Structure
d:\Server\www\projects\zds-kalipi\
βββ index.html # Main Single Page Application UI
βββ config.php # Production Database Configuration
βββ api.php # PHP PDO REST API (MySQL CRUD operations)
βββ schema.sql # Database schema DDL & initial seed dataset
βββ css\
β βββ style.css # Glassmorphism design tokens, cards/table, print styles
βββ js\
β βββ app.js # Core logic engine, state manager, search/filter pipeline
β βββ sample-data.js # Pre-populated ZDS sample dataset & municipality lists
βββ images\
βββ logo.jpg # Official ZDS KALIPI Federation Logo
ποΈ Database Setup
1. Requirements
- MySQL 5.7+ / MariaDB 10.3+ / PHP 7.4+
2. Schema Structure
barangay_associations: Header details (Municipality, Barangay, Association Name, Leader, Contact No, DOLE Reg #).women_profiles: Individual member profile records linked via Foreign Key.
3. Import Command
Run in MySQL command line or phpMyAdmin:
SOURCE schema.sql;
π Installation & Deployment Guide
Local Development (WampServer / XAMPP / LAMP)
- Copy project folder to your server root (e.g.
d:/Server/www/projects/zds-kalipi). - Update database credentials in
config.php:define('DB_HOST', 'YOUR_DB_HOST'); define('DB_NAME', 'YOUR_DB_NAME'); define('DB_USER', 'YOUR_DB_USER'); define('DB_PASS', 'YOUR_DB_PASS'); - Open
http://localhost/projects/zds-kalipi/or start a local PHP/HTTP server.
Production Web Server Deployment (cPanel / VPS)
- Upload
index.html,config.php,api.php,css/,js/, andimages/to your serverpublic_html/. - Create a MySQL Database in cPanel / phpMyAdmin.
- Import
schema.sqlinto your production database. - Update
config.phpwith your live hosting database name, user, and password.
π License & Accreditation
Developed for Zamboanga del Sur KALIPI-RIC Women Federation, Inc. • CY 2026.
For inquires:
admin@mcjim-server.com