rsclg/club-member-fields

Provides club specific adaptation of Contao member management.

1.4.2 2017-09-25 19:06 UTC

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

LGPL-3.0+

• Cliff Parnitzky

• club
• members
• contao
• member management

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.