rsclg/club-member-fields

Provides club specific adaptation of Contao member management.

Installs: 30

Dependents: 1

Suggesters: 0

Security: 0

Stars: 0

Watchers: 1

Forks: 0

Open Issues: 0

Type:contao-module

1.4.2 2017-09-25 19:06 UTC

This package is auto-updated.

Last update: 2020-07-15 01:56:58 UTC


README

Latest Version on Packagist Installations via composer per month Installations via composer total

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.