rsclg / club-member-fields
Provides club specific adaptation of Contao member management.
Installs: 33
Dependents: 1
Suggesters: 0
Security: 0
Stars: 0
Watchers: 2
Forks: 0
Open Issues: 0
Type:contao-module
Requires
- php: >=5.3
- contao-community-alliance/composer-plugin: ~2.0
- contao/core: >=3.2.0,<3.6
Conflicts
- contao/core: 3.4.0,3.4.1,3.4.2
README
Contao Extension: RscClubMemberFields
Provides club specific adaptation of Contao member management:
- Extension of
tl_member
for additional club fields - Automatic generation of the next free member number
- Set default values for new members
- Adjustment of filter, search and sorting
Installation
Install the extension via composer: rsclg/club-member-fields.
If you prefer to install it manually, download the latest release here: https://github.com/rsclg/RscClubMemberFields/releases
Database modification
Execute the following database script to define some views:
-- add view that are expected from contao
CREATE OR REPLACE VIEW v_tl_member AS SELECT tl_member.*, CONCAT(tl_member.firstname, ' ', tl_member.lastname) as name, (SELECT GROUP_CONCAT(mg.name ORDER BY mg.name SEPARATOR ', ') FROM tl_member_group mg JOIN tl_member_to_group m2g ON mg.id = m2g.group_id WHERE m2g.member_id = tl_member.id) as member_groups FROM tl_member;
CREATE OR REPLACE VIEW rcb2cto_contactgroups (id, name, tstamp) AS SELECT contactgroup_id, name, changed FROM rcb_contactgroups;
CREATE OR REPLACE VIEW rcb2cto_contacts (id, tstamp, name, firstname, lastname, email, member_number, user_id) AS SELECT contact_id, changed, name, firstname, surname, email, rsc_member_number, user_id FROM rcb_contacts WHERE del = 0;
CREATE OR REPLACE VIEW rcb2cto_users (id, name, tstamp) AS SELECT user_id, username, created FROM rcb_users;
Tracker
https://github.com/rsclg/RscClubMemberFields/issues
Compatibility
- min. Contao version: >= 3.2.0
- max. Contao version: < 3.6.0
Dependency
There are no dependencies to other extensions, that have to be installed.