Management & Administration System CAEJPA.

Offline, easy to use, simple and user-friendly web application designed to automate the workflow and transactions of the Public Savings Bank CAEJPA.

⚡ Features

• Full CRUD Operations: Create, Read, Update and Delete.
• Database Backup and Restoration from within the application.
• User's Roles and Statuses management.
• Password Recovery functions.
• PDF Printouts.
• User's Manual included.

🧱 Technologies

• Framework: SvelteKit and Tailwind for the client, with Express for the backend, along with TypeScript used as the main language all over the project.
• DB: MySQL as the main DB client.
• Tests: Unit and integration tests with Vitest

✨ Getting Started

Installation

git clone https://github.com/morzatt/caejpa
cd caejpa

cd server
npm i

cd client
npm i

npm run dev # run in development mode with tsc -- --watch and nodemon
npm start # run in production mode

Environment Variables

This app needs the following environment Variables

• NODE_ENV node environment configuration.
• PORT Port for the HTTP Express Server.
• HOST Host for the HTTP Express Server.
• COOKIE_SECRET Secret to code and decode cookies.
• DBHOST Database Host.
• DBUSER Database User.
• DBPORT Database Port.
• DBPWD Database Password.
• DBNAME Database's Name.

App Preview

Retirement.mp4

Transactions.mp4

Backup.mp4