COOP is the result of a personal project around the monitoring of building rehabilitation projects in mix mode involving professionals and private individuals. These projects are monitored and coordinated by a network of independent associations. This explains the name of the app and the section devoted to collaborative work.
COOP is a 3 in 1 modular app combining a website, teams workspaces and building rehab projects management. COOP is a multilevel user app : admin, supervisor, editor, viewer, public, with a possibility of group permissions at each level (if needed, COOP can be sliced down to one or two modules).
- The project management module allows to monitor project schedule through Gantt charts, team composition, workhours, expenses, wastes, carbon footprint, meetings schedules, pictures gallery and documents . The module include also a supervisor dashboard with various stats and an address book.
- The workspace module includes various tools : FAQ, forum, chat, news, events.
- The website module includes standard features : About us, Contact form, FAQ, news, events, event registration. It includes also some tools to manage a small organization : members and membership follow up, document.
- The admin panel includes the users permissions management, a debug forum, help and process management, connexions stats, list of choices and patterns management.
I am not an IT pro so I choose SQLPage to develop COOP. COOP code is very simple: basic SQL queries, SQLPage base (no custom components, no scripts), very academic query writing, very explicit file and folder names... The first version of COOP was develop with sqlite as database engine but it was not consistent with the collaborative aim of COOP, so COOP was rewrite to work on Postgresql. Postgreql allows multiple connections in the same time and postgresql offers much more features for further developments (for example : links to Postgis).
COOP can be used as a template, a draft to develop more complex apps around project management, or as a set of examples to discover SQLpage.
COOP was developed with SQLpage 0.35.2, Postgresql 16, linux mint 22.1. Development tools : VSCodium, DBeaver-CE, Pandoc, Retex (all free and open source apps, thanks to all developers !)
Installing COOP is straightforward:
-
install postgresql (version 16 or +)
-
create a user : coop with its password
-
download the entire COOP_pg folder from Github
-
paste the files and folder from COOP_pg folder into
/var/www/coop -
restore coop database from the dump file located at
/var/www/coop/a_install/dump-coop-*******.sql ;the dump comes with few data which are necessary to use COOP : users accounts, list of choices...(You may have to adjust the beginning of the file about the users and roles) -
modify the json file located at
/var/www/coop/sqlpage/sqlpage.jsonto setup the password in
"database_url": "postgres://coop:CoopPassword@localhost:5432/coop",
-
to display the correct info about your organisation, you need to set up the
orga_dept_idin$orga_footer, $orga_dept_name, $logoin/var/www/coop/a_shells/shell_core.sql. By default, theorga_dept_idis set on '2' but if you have made some changes in theorga_depttable it can be the good value. You may have to do the same adjustments in the files of the folder/var/www/coop/b_about. -
set up write permissions on the sub-folders with an "x_" prefix (these are used to download documents or images)
-
in the terminal, go to the COOP folder:
/var/www/coop -
in the terminal, launch SQLPage:
/var/www/coop/sqlpage/sqlpage.bin -
you can create a sevice to launch sqlpage when starting you computer see the post
-
in your browser, go to:
http://localhost:8080/
COOP comes with several preset user accounts :
all accounts are using the same password: CoopCoop1@
Playing with different accounts can be useful to test the collaborative tools : forum, chat, event.
To create new users,you need to use the sign up form in the menu "connect" then log as admin to set the rights of the new user in the menu "NEW USERS" in the admin dashboard panel.
When logged as admin, in the admin panel, you will find a "Help Dev" menu with COOP on-board documentation. you will find also a complete description of COOP in the wiki in github .
SQLapge is well documented ; you may find good examples also in Learn SQLPage.