Skip to content

Latest commit

 

History

History
290 lines (227 loc) · 11.8 KB

README.md

File metadata and controls

290 lines (227 loc) · 11.8 KB

Genealogy

Genealogy

Latest Stable Version

About this project

Genealogy is a free and open-source family tree PHP application to record family members and their relationships, build with Laravel 11.

Genealogy-000a

Genealogy-020

This TallStack application is build using :

tall-stack

Logic concept

  1. A person can have 1 biological father (1 person, based on father_id)

  2. A person can have 1 biological mother (1 person, based on mother_id)

  3. A person can have 1 set of parents, biological or not (1 couple of 2 people, based on parents_id)

  4. A person can have 0 to many biological children (n people, based on father_id/mother_id)

  5. A couple can have 0 to many (plus) children (based on parents_id as a couple or father_id/mother_id individually)

  6. A person can have 0 to many partners (n people), being part of 0 to many couples (opposite or same biological sex)

  7. A person can be part of a couple with the same partner multiple times (remarriage or reunite)

  8. A person can have 0 to many siblings (n people) (based on parents_id as a couple or father_id/mother_id individually)

  9. A couple can be married or not, still together or separated in the meantime

Requirements

License

This project is open-sourced software licensed under the MIT license.

Demo

https://genealogy.kreaweb.be/

This demo has 2 family trees implemented, BRITISH ROYALS and KENNEDY.

E-mail Password Purpose
administrator@genealogy.test password to access teams BRITISH ROYALS and KENNEDY as team owner
manager@genealogy.test password to access team BRITISH ROYALS as manager
editor@genealogy.test password to access team KENNEDY as editor
member_1@genealogy.test password to access team BRITISH ROYALS as normal member
member_4@genealogy.test password to access team KENNEDY as normal member
developer@genealogy.test password to access options reserved for the developer, like the user management and access to all persons in all teams

Roles & permissions

Role Model Permissions
Administrator user (team member) create, read, update, delete
person create, read, update, delete
couple create, read, update, delete
Manager person create, read, update, delete
couple create, read, update, delete
Editor person create, read, update
couple create, read, update
Member person read
couple read

Features

  • Light/Dark theme
  • Fully responsive
  • Multi-language, language setting saved in authenticated users profile
  • Multi-timezone, timezone setting saved in authenticated users profile
  • Multi-tenancy by Laravel Jetstream Teams, including Transfer Team Ownership
  • Security through Laravel Jetstream Teams Roles & Permissions, 2FA & API can be enabled
  • Offcanvas menu
  • Multiple image upload with possibility of watermarking, photo carousel with navigation
  • Multiple documents upload

Special features

This application has a built-in Backup Manager :

  • Backups can be initiated and managed manually
  • Backups can be scheludeld by issuing a cron job on your development or production server
  • An e-mail will be send after each backup

This application has a built-in Log Viewer, on demand showing :

  • INFO : All scheduled backups
  • DEBUG : All executed requests (off by default)
  • DEBUG : All executed database queries (off by default), only in local development mode
  • WARNING : All detected N+1 queries, only in local development mode
  • WARNING : All detected slow (> 250 ms) queries, only in local development mode
  • ERROR : All detected errors

Logging can be enabled or disabled by the developer in the Application Settings.

This application has a built-in User management & logging, available to the developer :

  • User statistics by country of origin
  • User statistics by year, month, week or day

All activities (create, update, delete) on persons and couples are logged in the database.
All activities (create, update, delete, invite) on users and teams are logged in the database.
Change history available on Persons (with Couples) and Teams (with Users).

Languages

  • German (DE)
  • English (EN)
  • Spanish (ES)
  • French (FR)
  • Dutch (NL)
  • Portuguese (PT)
  • Vietnamese (VI)
  • Simplified Chinese (ZH_CN)

Translations can be added by submitting a Pull Request to the project. Translation integrity can be checked by issuing the command
php artisan translations:check --excludedDirectories=vendor

To Do ...

Techniques

Both the ancestors and descendants family trees are build using Recursive Common Table Expressions (Recursive CTE). This prevents the N+1 query problem generating the recursive tree family elements and dramatically improves performance.

Installation

create a new project folder, cd into the folder

git clone https://github.com/MGeurts/genealogy.git .

cp .env.example .env

make the needed changes regarding name, url, database connection & mail server

composer install

php artisan key:generate

php artisan storage:link

php artisan migrate:fresh --seed

npm install & npm run build

php artisan serve or npm run dev

Testing

php artisan test

Contributing

Feel free to submit Issues or Pull Requests, for bugs, suggestions or feature requests.

Documentation

The documentation is included in the applications help. Visit the demo project to read the documentation.

Sponsoring

If you like this project, please consider giving it a star and spread the word. Thank you.

Impressum

Basic idea (2017)

This application is based on an original idea by Nafies Luthfi. Thanks for your excellent work.

Design & Development (2024)

This Laravel application is designed and developed by kreaweb.be.